Product Costs (窗口 ID-344)
窗口: Product Costs
描述: Maintain Product Costs
幫助: Maintain Product Cost Elements
TAB: Select Product
描述: Select the product
幫助 null
File:Product Costs - Select Product - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | 机构 | 客户内的机构实体。 | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) NOT NULL Table Direct |
Search Key | 检索关键字 | 记录的检索关键字在格式上是必须的 -并且必须唯一 | 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 character varying(40) NOT NULL 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 character varying(255) NOT NULL String |
Description | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
Comment/Help | 注释/帮助 | 注释或提示 | The Help field contains a hint, comment or help about the use of this item. | Help character varying(2000) Text |
Product Category | 产品分类 | Category this product is part of | Identifies the category which this product belongs to. Product categories are used for pricing. | M_Product_Category_ID numeric(10) NOT NULL Table Direct |
Product Type | 产品类型 | 产品的类型 | The type of product also determines accounting consequences. | ProductType character(1) NOT NULL List |
UPC/EAN | UPC/EAN条码 | 条形码 | 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 character varying(30) String |
SKU | SKU | 存货保管单位 | The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema. | SKU character varying(30) String |
UOM | 度量单位 | 度量单位 | The UOM defines a unique non monetary Unit of Measure | C_UOM_ID numeric(10) NOT NULL Table Direct |
Stocked | 存储 | Organization stocks this product | The Stocked check box indicates if this product is stocked by this Organization. | IsStocked character(1) NOT NULL Yes-No |
Company Agent | 公司代理人 | 采购或公司代理人 | Purchase agent for the document. Any Sales Rep must be a valid internal user. | SalesRep_ID numeric(10) Table |
TAB: Product Costs
描述: Maintain Product Costs
幫助 null
File:Product Costs - Product Costs - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | 机构 | 客户内的机构实体。 | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) NOT NULL Table Direct |
Product | 产品 | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) NOT NULL Search |
Attribute Set Instance | 属性组合实例 | Product Attribute Set Instance | The values of the actual Product Attributes | M_AttributeSetInstance_ID numeric(10) NOT NULL Product Attribute |
Accounting Schema | 会计模式 | 帐户的规则 | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | C_AcctSchema_ID numeric(10) NOT NULL Table Direct |
Cost Type | 成本类型 | 成本的类型 | null | M_CostType_ID numeric(10) NOT NULL Table Direct |
Cost Element | Cost Element | Product Cost Element | null | M_CostElement_ID numeric(10) NOT NULL Table Direct |
Description | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) Text |
Active | 有效 | 本记录有效 | 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 character(1) NOT NULL Yes-No |
Costing Method | 成本计算方法 | Indicates how Costs will be calculated | The Costing Method indicates how costs will be calculated (Standard, Average) | CostingMethod null List |
Current Cost Price | 当前成本价格 | 那现在使用过的成本价格 | null | CurrentCostPrice numeric NOT NULL Costs+Prices |
Current Cost Price Lower Level | Current Cost Price Lower Level | Current Price Lower Level Is the sum of the costs of the components of this product manufactured for this level. | Current Price Lower Level is used for get the total costs for lower level the a product manufactured.
The Current Price Lower Level always will be calculated. You can see the Current Cost Price and Current Cost Price Lower Level with Cost Bill of Material & Formula Detail Report. The sum the Current Cost Price + Current Cost Price Lower Level is the total cost to a product manufactured. |
CurrentCostPriceLL numeric Costs+Prices |
Future Cost Price | 未来成本价格 | null | null | FutureCostPrice numeric Costs+Prices |
Future Cost Price Lower Level | Future Cost Price Lower Level | null | null | FutureCostPriceLL numeric Costs+Prices |
Percent | 百分比 | 扣留百分比 | The Percent indicates the percentage used for withholding. | Percent numeric(10) Integer |
Current Quantity | Current Quantity | Current Quantity | null | CurrentQty numeric NOT NULL Quantity |
Cost Frozen | Cost Frozen | Indicated that the Standard Cost is frozen | null | IsCostFrozen character(1) Yes-No |
Accumulated Amt | Accumulated Amt | Total Amount | Sum of all amounts | CumulatedAmt numeric Amount |
Accumulated Qty | Accumulated Qty | Total Quantity | Sum of the quantities | CumulatedQty numeric Quantity |
Processed | 已处理 | The document has been processed | The Processed checkbox indicates that a document has been processed. | Processed null Yes-No |
TAB: Cost Movement
描述: Show movement of cost by transaction
幫助 null
File:Product Costs - Cost Movement - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Accounting Schema | 会计模式 | 帐户的规则 | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | C_AcctSchema_ID numeric(10) Table Direct |
Cost Type | 成本类型 | 成本的类型 | null | M_CostType_ID numeric(10) Table Direct |
Cost Element | Cost Element | Product Cost Element | null | M_CostElement_ID numeric(10) Table Direct |
Cost Detail | Cost Detail | Cost Detail Information | null | M_CostDetail_ID numeric(10) Table Direct |
Product | 产品 | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) Table Direct |
Attribute Set Instance | 属性组合实例 | Product Attribute Set Instance | The values of the actual Product Attributes | M_AttributeSetInstance_ID numeric(10) Product Attribute |
Quantity | 数量 | 数量 | The Quantity indicates the number of a specific product or item for this document. | Qty numeric Quantity |
Amount | 金额 | 金额 | 金额 | Amt numeric Amount |
Delta Amount | Delta Amount | Difference Amount | null | DeltaAmt numeric Amount |
Delta Quantity | Delta Quantity | Quantity Difference | null | DeltaQty numeric Quantity |
Old Current Quantity | Old Current Quantity | Old current quantity before the processing of M_CostDetail | null | OldQty numeric Quantity |
Old Current Cost Price | Old Current Cost Price | Old current cost price before the processing of M_CostDetail | null | OldCostPrice numeric Costs+Prices |
Old Accumulated Qty | Old Accumulated Qty | Old accumulated qty before the processing of M_CostDetail | null | OldCQty numeric Quantity |
Old Accumulated Amt | Old Accumulated Amt | Old accumulated amt before the processing of M_CostDetail | null | OldCAmt numeric Amount |
New Current Quantity | New Current Quantity | New current quantity after processing of M_CostDetail | null | NewQty numeric Quantity |
New Cost Price | New Cost Price | New current cost price after processing of M_CostDetail | null | NewCostPrice numeric Costs+Prices |
New Accumulated Qty | New Accumulated Qty | New Accumulated Qty after processing of M_CostDetail | null | NewCQty numeric Quantity |
New Accumulated Amt | New Accumulated Amt | Accumulated Amt after processing of M_CostDetail | null | NewCAmt numeric Amount |
Description | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
Move Line | 调拨明细 | 调拨明细 | The Movement Line indicates the inventory movement document line (if applicable) for this transaction | M_MovementLine_ID numeric(10) Table Direct |
Invoice Line | 发票明细 | 发票明细明细 | The Invoice Line uniquely identifies a single line of an Invoice. | C_InvoiceLine_ID numeric(10) Table Direct |
Phys.Inventory Line | Phys.Inventory Line | 盘点明细 | The Physical Inventory Line indicates the inventory document line (if applicable) for this transaction | M_InventoryLine_ID numeric(10) Table Direct |
Production Line | 制造明细 | 制造明细 | The Production Line indicates the production document line (if applicable) for this transaction | M_ProductionLine_ID numeric(10) Table Direct |
Project Issue | 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 numeric(10) Table Direct |
Purchase Order Line | 采购定单明细 | 采购定单明细 | The Purchase Order Line is a unique identifier for a line in an order. | C_OrderLine_ID numeric(10) Table Direct |
Receipt Line | 收货明细 | 接收货明细 | The Shipment Receipt Line indicates a unique line in a Shipment Receipt document | M_InOutLine_ID numeric(10) Table Direct |
TAB: Cost Details
描述: View Product Cost Details
幫助 null
File:Product Costs - Cost Details - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | 机构 | 客户内的机构实体。 | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) NOT NULL Table Direct |
Accounting Schema | 会计模式 | 帐户的规则 | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | C_AcctSchema_ID numeric(10) NOT NULL Table Direct |
Cost Element | Cost Element | Product Cost Element | null | M_CostElement_ID numeric(10) Table Direct |
Product | 产品 | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) NOT NULL Search |
Attribute Set Instance | 属性组合实例 | Product Attribute Set Instance | The values of the actual Product Attributes | M_AttributeSetInstance_ID numeric(10) NOT NULL Product Attribute |
Price | 价格 | 价格 | The Price indicates the Price for a product or service. | Price null Amount |
Quantity | 数量 | 数量 | The Quantity indicates the number of a specific product or item for this document. | Qty numeric NOT NULL Quantity |
Amount | 金额 | 金额 | 金额 | Amt numeric NOT NULL Amount |
Delta Quantity | Delta Quantity | Quantity Difference | null | DeltaQty numeric Quantity |
Delta Amount | Delta Amount | Difference Amount | null | DeltaAmt numeric Amount |
Description | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
Created | 创建日期 | 本记录产生日期 | The Created field indicates the date that this record was created. | Created timestamp without time zone NOT NULL Date+Time |
Purchase Order Line | 采购定单明细 | 采购定单明细 | The Purchase Order Line is a unique identifier for a line in an order. | C_OrderLine_ID numeric(10) Search |
Invoice Line | 发票明细 | 发票明细明细 | The Invoice Line uniquely identifies a single line of an Invoice. | C_InvoiceLine_ID numeric(10) Search |
Receipt Line | 收货明细 | 接收货明细 | The Shipment Receipt Line indicates a unique line in a Shipment Receipt document | M_InOutLine_ID numeric(10) Search |
Move Line | 调拨明细 | 调拨明细 | The Movement Line indicates the inventory movement document line (if applicable) for this transaction | M_MovementLine_ID numeric(10) Search |
Phys.Inventory Line | Phys.Inventory Line | 盘点明细 | The Physical Inventory Line indicates the inventory document line (if applicable) for this transaction | M_InventoryLine_ID numeric(10) Search |
Project Issue | 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 numeric(10) Search |
Production Line | 制造明细 | 制造明细 | The Production Line indicates the production document line (if applicable) for this transaction | M_ProductionLine_ID numeric(10) Search |
Sales Transaction | 销售交易 | 这是销售交易 | The Sales Transaction checkbox indicates if this item is a Sales Transaction. | IsSOTrx character(1) NOT NULL Yes-No |
Processed | 已处理 | The document has been processed | The Processed checkbox indicates that a document has been processed. | Processed character(1) NOT NULL Yes-No |
Current Cost Price | 当前成本价格 | 那现在使用过的成本价格 | null | CurrentCostPrice numeric Costs+Prices |
Current Quantity | Current Quantity | Current Quantity | null | CurrentQty numeric Quantity |
Accumulated Amt | Accumulated Amt | Total Amount | Sum of all amounts | CumulatedAmt numeric Amount |
Accumulated Qty | Accumulated Qty | Total Quantity | Sum of the quantities | CumulatedQty numeric Quantity |
TAB: Cost Queue
描述: Cost Queue for Lifo/Fifo
幫助 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.
File:Product Costs - Cost Queue - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | 机构 | 客户内的机构实体。 | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) NOT NULL Table Direct |
Accounting Schema | 会计模式 | 帐户的规则 | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | C_AcctSchema_ID numeric(10) NOT NULL Table Direct |
Cost Type | 成本类型 | 成本的类型 | null | M_CostType_ID numeric(10) NOT NULL Table Direct |
Cost Element | Cost Element | Product Cost Element | null | M_CostElement_ID numeric(10) NOT NULL Table Direct |
Product | 产品 | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) NOT NULL Search |
Attribute Set Instance | 属性组合实例 | Product Attribute Set Instance | The values of the actual Product Attributes | M_AttributeSetInstance_ID numeric(10) NOT NULL Product Attribute |
Current Cost Price | 当前成本价格 | 那现在使用过的成本价格 | null | CurrentCostPrice numeric NOT NULL Costs+Prices |
Current Quantity | Current Quantity | Current Quantity | null | CurrentQty numeric NOT NULL Quantity |