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 |
