ManPageW ProductCosts

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: Product Costs

Description : Maintain Product Costs

Help : Maintain Product Cost Elements



Tab: Select Product

Description : Select the product

Help :

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

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

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

CHAR(1)

List

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

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

NUMBER(10)

TableDir

Stocked Organization stocks this product The Stocked check box indicates if this product is stocked by this Organization. IsStocked

CHAR(1)

YesNo

Company Agent Purchase or Company Agent Purchase agent for the document. Any Sales Rep must be a valid internal user. SalesRep_ID

NUMBER(10)

Table


Tab: Product Costs

Description : Maintain Product Costs

Help :

Table Name  : M_Cost

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

Attribute Set Instance Product Attribute Set Instance The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. M_AttributeSetInstance_ID

NUMBER(10)

ProductAttribute

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

Cost Type Type of Cost (e.g. Current, Plan, Future) You can define multiple cost types. A cost type selected in an Accounting Schema is used for accounting. M_CostType_ID

NUMBER(10)

TableDir

Cost Element Product Cost Element M_CostElement_ID

NUMBER(10)

TableDir

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

NVARCHAR2(255)

Text

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

Current Cost Price The currently used cost price CurrentCostPrice

NUMBER

CostsPrices

Current Quantity Current Quantity CurrentQty

NUMBER

Quantity

Future Cost Price FutureCostPrice

NUMBER

CostsPrices

Percent Percentage The Percent indicates the percentage used. Percent

NUMBER(10)

Integer

Accumulated Amt Total Amount Sum of all amounts CumulatedAmt

NUMBER

Amount

Accumulated Qty Total Quantity Sum of the quantities CumulatedQty

NUMBER

Quantity


Tab: Cost Details

Description : View Product Cost Details

Help :

Table Name  : M_CostDetail

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

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

Cost Element Product Cost Element M_CostElement_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

Attribute Set Instance Product Attribute Set Instance The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. M_AttributeSetInstance_ID

NUMBER(10)

ProductAttribute

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

NUMBER

Quantity

Amount Amount Amount Amt

NUMBER

Amount

Delta Quantity Quantity Difference DeltaQty

NUMBER

Quantity

Delta Amount Difference Amount DeltaAmt

NUMBER

Amount

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

NVARCHAR2(255)

String

Created Date this record was created The Created field indicates the date that this record was created. Created

DATE

DateTime

Purchase Order Line Purchase Order Line The Purchase Order Line is a unique identifier for a line in an order. C_OrderLine_ID

NUMBER(10)

Search

Invoice Line Invoice Detail Line The Invoice Line uniquely identifies a single line of an Invoice. C_InvoiceLine_ID

NUMBER(10)

Search

Receipt Line Line on Receipt document M_InOutLine_ID

NUMBER(10)

Search

Move Line Inventory Move document Line The Movement Line indicates the inventory movement document line (if applicable) for this transaction M_MovementLine_ID

NUMBER(10)

Search

Phys.Inventory Line Unique line in an Inventory document The Physical Inventory Line indicates the inventory document line (if applicable) for this transaction M_InventoryLine_ID

NUMBER(10)

Search

Project Issue Project Issues (Material, Labor) Issues to the project initiated by the "Issue to Project" process. You can issue Receipts, Time and Expenses, or Stock. C_ProjectIssue_ID

NUMBER(10)

Search

Production Line Document Line representing a production The Production Line indicates the production document line (if applicable) for this transaction M_ProductionLine_ID

NUMBER(10)

Search

Sales Transaction This is a Sales Transaction The Sales Transaction checkbox indicates if this item is a Sales Transaction. IsSOTrx

CHAR(1)

YesNo


Tab: Cost Queue

Description : Cost Queue for Lifo/Fifo

Help : Note thet the cost queue may not be the same as the physical movement cost queue due to differences in costing level and warehouse priority.

Table Name  : M_CostQueue

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

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

Cost Type Type of Cost (e.g. Current, Plan, Future) You can define multiple cost types. A cost type selected in an Accounting Schema is used for accounting. M_CostType_ID

NUMBER(10)

TableDir

Cost Element Product Cost Element M_CostElement_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

Attribute Set Instance Product Attribute Set Instance The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. M_AttributeSetInstance_ID

NUMBER(10)

ProductAttribute

Current Cost Price The currently used cost price CurrentCostPrice

NUMBER

CostsPrices

Current Quantity Current Quantity CurrentQty

NUMBER

Quantity


Tab: Costing (old)

Description : Old Product Costing Info

Help :

Table Name  : M_Product_Costing

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

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

Current Cost Price The currently used cost price CurrentCostPrice

NUMBER

CostsPrices

Average Cost Weighted average costs Weighted average (actual) costs CostAverage

NUMBER

CostsPrices

Average Cost Amount Sum Cumulative average cost amounts (internal) Current cumulative costs for calculating the average costs CostAverageCumAmt

NUMBER

CostsPrices

Average Cost Quantity Sum Cumulative average cost quantities (internal) Current cumulative quantity for calculating the average costs CostAverageCumQty

NUMBER

Quantity

Standard Cost Standard Costs Standard (plan) costs. CostStandard

NUMBER

CostsPrices

Future Cost Price FutureCostPrice

NUMBER

CostsPrices

Std PO Cost Amount Sum Standard Cost Purchase Order Amount Sum (internal) Current cumulative amount for calculating the standard cost difference based on (planned) purchase order price CostStandardPOAmt

NUMBER

CostsPrices

Std PO Cost Quantity Sum Standard Cost Purchase Order Quantity Sum (internal) Current cumulative quantity for calculating the standard cost difference based on (planned) purchase order price CostStandardPOQty

NUMBER

Quantity

Std Cost Amount Sum Standard Cost Invoice Amount Sum (internal) Current cumulative amount for calculating the standard cost difference based on (actual) invoice price CostStandardCumAmt

NUMBER

CostsPrices

Std Cost Quantity Sum Standard Cost Invoice Quantity Sum (internal) Current cumulative quantity for calculating the standard cost difference based on (actual) invoice price CostStandardCumQty

NUMBER

Quantity

Last PO Price Price of the last purchase order for the product The Last PO Price indicates the last price paid (per the purchase order) for this product. PriceLastPO

NUMBER

CostsPrices

Last Invoice Price Price of the last invoice for the product The Last Invoice Price indicates the last price paid (per the invoice) for this product. PriceLastInv

NUMBER

CostsPrices

Total Invoice Amount Cumulative total lifetime invoice amount The cumulative total lifetime invoice amount is used to calculate the total average price TotalInvAmt

NUMBER

Amount

Total Invoice Quantity Cumulative total lifetime invoice quantity The cumulative total lifetime invoice quantity is used to calculate the total average price TotalInvQty

NUMBER

Quantity

Contributions

Personal tools