ManPageW Resource

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Contents

Window: Resource

Description : Maintain Resources

Help : Maintain your Resources. The product for the resource is automatically created and synchronized. Update Name, Unit of Measure, etc. in the Resource and don't change it in the product.



Tab: Resource

Description : Maintain Resources

Help :

Table Name  : S_Resource

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Search Key Search key for the record in the format required - must be unique A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

Value

NVARCHAR2(40)

String

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Resource Type S_ResourceType_ID

NUMBER(10)

TableDir

User/Contact User within the system - Internal or Business Partner Contact The User identifies a unique user in the system. This could be an internal user or a business partner contact AD_User_ID

NUMBER(10)

TableDir

Warehouse Storage Warehouse and Service Point The Warehouse identifies a unique Warehouse where products are stored or Services are provided. M_Warehouse_ID

NUMBER(10)

TableDir

Available Resource is available Resource is available for assignments IsAvailable

CHAR(1)

YesNo


Tab: Unavailability

Description : Resource unavailability

Help : Dates, when the resource is not available (e.g. vacation)

Table Name  : S_ResourceUnAvailable

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Resource Resource S_Resource_ID

NUMBER(10)

TableDir

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Date From Starting date for a range The Date From indicates the starting date of a range. DateFrom

DATE

Date

Date To End date of a date range The Date To indicates the end date of a range (inclusive) DateTo

DATE

Date

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String


Tab: Resource Product

Description : Maintain Product information of Resource

Help : The product for the resource is automatically created and synchronized. Update Name, Unit of Measure, etc. in the Resource and don't change it in the product.

Table Name  : M_Product

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Search Key Search key for the record in the format required - must be unique A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

Value

NVARCHAR2(510)

String

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(510)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. Help

NVARCHAR2(2000)

Text

Document Note Additional information for a Document The Document Note is used for recording any additional information regarding this product. DocumentNote

NVARCHAR2(2000)

Text

UPC/EAN Bar Code (Universal Product Code or its superset European Article Number) Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode) UPC

VARCHAR2

String

SKU Stock Keeping Unit The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema. SKU

VARCHAR2

String

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Summary Level This is a summary entity A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. IsSummary

CHAR(1)

YesNo

Product Category Category of a Product Identifies the category which this product belongs to. Product categories are used for pricing and selection. M_Product_Category_ID

NUMBER(10)

TableDir

Classification Classification for grouping The Classification can be used to optionally group products. Classification

CHAR(1)

String

Tax Category Tax Category The Tax Category provides a method of grouping similar taxes. For example, Sales Tax or Value Added Tax. C_TaxCategory_ID

NUMBER(10)

TableDir

Revenue Recognition Method for recording revenue The Revenue Recognition indicates how revenue will be recognized for this product C_RevenueRecognition_ID

NUMBER(10)

TableDir

UOM Unit of Measure The UOM defines a unique non monetary Unit of Measure C_UOM_ID

NUMBER(10)

TableDir

Sales Representative Sales Representative or Company Agent The Sales Representative indicates the Sales Rep for this Region. Any Sales Rep must be a valid internal user. SalesRep_ID

NUMBER(10)

Table

Product Type Type of product The type of product also determines accounting consequences. ProductType

CHAR(1)

List

Purchased Organization purchases this product The Purchased check box indicates if this product is purchased by this organization. IsPurchased

CHAR(1)

YesNo

Sold Organization sells this product The Sold check box indicates if this product is sold by this organization. IsSold

CHAR(1)

YesNo

Discontinued This product is no longer available The Discontinued check box indicates a product that has been discontinued. Discontinued

CHAR(1)

YesNo

Discontinued by Discontinued By The Discontinued By indicates the individual who discontinued this product DiscontinuedBy

DATE

Date

Image URL URL of image URL of image; The image is not stored in the database, but retrieved at runtime. The image can be a gif, jpeg or png. ImageURL

NVARCHAR2(120)

Unknown (40)

Description URL URL for the description DescriptionURL

NVARCHAR2(120)

Unknown (40)


Tab: Price

Description : Resource Pricing

Help : The Pricing Tab displays the List, Standard and Limit prices for each price list a resource is contained in.

Table Name  : M_ProductPrice

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Price List Version Identifies a unique instance of a Price List Each Price List can have multiple versions. The most common use is to indicate the dates that a Price List is valid for. M_PriceList_Version_ID

NUMBER(10)

TableDir

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

List Price List Price The List Price is the official List Price in the document currency. PriceList

NUMBER

CostsPrices

Standard Price Standard Price The Standard Price indicates the standard or normal price for a product on this price list PriceStd

NUMBER

CostsPrices

Limit Price Lowest price for a product The Price Limit indicates the lowest price for a product stated in the Price List Currency. PriceLimit

NUMBER

CostsPrices


Tab: Accounting

Description : Define Accounting Parameters

Help : The Accounting Tab defines the defaults to use when generating accounting transactions for orders and invoices which contain this resource. Not all accounts apply to resources.

Table Name  : M_Product_Acct

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

TableDir

Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar C_AcctSchema_ID

NUMBER(10)

TableDir

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Product Asset Account for Product Asset (Inventory) The Product Asset Account indicates the account used for valuing this a product in inventory. P_Asset_Acct

NUMBER(10)

Account

Product Expense Account for Product Expense The Product Expense Account indicates the account used to record expenses associated with this product. P_Expense_Acct

NUMBER(10)

Account

Product COGS Account for Cost of Goods Sold The Product COGS Account indicates the account used when recording costs associated with this product. P_COGS_Acct

NUMBER(10)

Account

Purchase Price Variance Difference between Standard Cost and Purchase Price (PPV) The Purchase Price Variance is used in Standard Costing. It reflects the difference between the Standard Cost and the Purchase Order Price. P_PurchasePriceVariance_Acct

NUMBER(10)

Account

Invoice Price Variance Difference between Costs and Invoice Price (IPV) The Invoice Price Variance is used reflects the difference between the current Costs and the Invoice Price. P_InvoicePriceVariance_Acct

NUMBER(10)

Account

Trade Discount Received Trade Discount Receivable Account The Trade Discount Receivables Account indicates the account for received trade discounts in vendor invoices P_TradeDiscountRec_Acct

NUMBER(10)

Account

Trade Discount Granted Trade Discount Granted Account The Trade Discount Granted Account indicates the account for granted trade discount in sales invoices P_TradeDiscountGrant_Acct

NUMBER(10)

Account

Product Revenue Account for Product Revenue (Sales Account) The Product Revenue Account indicates the account used for recording sales revenue for this product. P_Revenue_Acct

NUMBER(10)

Account


Tab: Assignment

Description : Resource Assignments

Help : History of Assignments

Table Name  : S_ResourceAssignment

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Resource Resource S_Resource_ID

NUMBER(10)

TableDir

Assign From Assign resource from Assignment start AssignDateFrom

DATE

DateTime

Assign To Assign resource until Assignment end AssignDateTo

DATE

DateTime

Quantity Quantity The Quantity indicates the number of a specific product or item for this document. Qty

NUMBER

Quantity

Confirmed Assignment is confirmed Resource assignment is confirmed IsConfirmed

CHAR(1)

YesNo

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Contributions

Personal tools