產品 (窗口 ID-140)
窗口: 產品
描述: 維護產品
幫助: The Product Window defines all products used by an organization. These products include those sold to customers, used in the manufacture of products sold to customers and products purchased by an organization.
TAB: 產品
描述: 定義產品
幫助 The Product Tab defines each product and identifies it for use in price lists and orders. The Location is the default location when receiving the stored product.
File:產品 - 產品 - 窗口 (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 |
| Version No | 版本號 | 版本數字 | null | VersionNo character varying(20) 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 |
| Document Note | 文件注釋 | Additional information for a Document | The Document Note is used for recording any additional information regarding this product. | DocumentNote character varying(2000) Text |
| 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 |
| 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 |
| Summary Level | 匯總級別 | 這是父類實體 | 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 character(1) NOT NULL Yes-No |
| 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 |
| Classification | 分類 | 分類為配列 | The Classification can be used to optionally group products. | Classification character varying(12) String |
| Tax Category | 稅分類 | 稅分類 | The Tax Category provides a method of grouping similar taxes. For example, Sales Tax or Value Added Tax. | C_TaxCategory_ID numeric(10) NOT NULL Table Direct |
| Revenue Recognition | 收入確認 | 記錄的收入方法 | The Revenue Recognition indicates how revenue will be recognized for this product | C_RevenueRecognition_ID numeric(10) Table Direct |
| UOM | 度量單位 | 度量單位 | The UOM defines a unique non monetary Unit of Measure | C_UOM_ID numeric(10) NOT NULL Table Direct |
| Company Agent | 公司代理人 | 採購或公司代理人 | Purchase agent for the document. Any Sales Rep must be a valid internal user. | SalesRep_ID numeric(10) Table |
| Product Type | 產品類型 | 產品的類型 | The type of product also determines accounting consequences. | ProductType character(1) NOT NULL List |
| Mail Template | 郵寄模板 | 本文模板為郵寄 | The Mail Template indicates the mail template for return messages. | R_MailText_ID numeric(10) Table Direct |
| Weight | 重量 | 一產品的重量 | The Weight indicates the weight of the product in the Weight UOM of the Client | Weight numeric Amount |
| Volume | 體積 | 產品的體積 | The Volume indicates the volume of the product in the Volume UOM of the Client | Volume numeric Amount |
| Freight Category | 運費分類 | 運費分類 | Freight Categories are used to calculate the Freight for the Shipper selected | M_FreightCategory_ID numeric(10) Table Direct |
| Drop Shipment | Drop Shipment | Drop Shipments are sent from the Vendor directly to the Customer | Drop Shipments do not cause any Inventory reservations or movements as the Shipment is from the Vendor's inventory. The Shipment of the Vendor to the Customer must be confirmed. | IsDropShip character(1) NOT NULL Yes-No |
| 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 |
| Manufactured | Manufactured | This product is manufactured | null | IsManufactured character(1) NOT NULL Yes-No |
| Phantom | Phantom | Phantom Component | Phantom Component are not stored and produced with the product. This is an option to avild maintaining an Engineering and Manufacturing Bill of Materials. | IsPhantom character(1) Yes-No |
| Kanban controlled | Kanban controlled | This part is Kanban controlled | null | IsKanban character(1) NOT NULL Yes-No |
| Part Type | Part Type | null | null | M_PartType_ID numeric(10) Table Direct |
| Locator | 貨位 | 倉庫貨位 | The Locator ID indicates where in a Warehouse a product is located. | M_Locator_ID numeric(10) Locator (WH) |
| Shelf Width | 架寬度 | 要求的架寬度 | The Shelf Width indicates the width dimension required on a shelf for a product | ShelfWidth numeric(10) Integer |
| Shelf Height | 架高度 | 要求的架高度 | The Shelf Height indicates the height dimension required on a shelf for a product | ShelfHeight numeric Amount |
| Shelf Depth | 架深度 | 要求的架深度 | The Shelf Depth indicates the depth dimension required on a shelf for a product | ShelfDepth numeric(10) Integer |
| Units Per Pallet | 每貨盤單位 | 每貨盤單位 | The Units per Pallet indicates the number of units of this product which fit on a pallet. | UnitsPerPallet numeric Costs+Prices |
| Bill of Materials | 物料清單 | 物料清單 | The Bill of Materials check box indicates if this product consists of a bill of materials. | IsBOM character(1) NOT NULL Yes-No |
| Verified | 驗證 | The BOM configuration has been verified | The Verified check box indicates if the configuration of this product has been verified. This is used for products that consist of a bill of materials | IsVerified character(1) NOT NULL Yes-No |
| Verify BOM Structure | Verify BOM Structure | Verify BOM for correctness | The Verify BOM process checks for circular BOMs (unsupported). | Processing character(1) Button |
| Print detail records on invoice | 發票打印發票明細 | Print detail BOM elements on the invoice | The Print Details on Invoice indicates that the BOM element products will print on the Invoice as opposed to this product. | IsInvoicePrintDetails character(1) NOT NULL Yes-No |
| Print detail records on pick list | 提貨列表打印明細 | Print detail BOM elements on the pick list | The Print Details on Pick List indicates that the BOM element products will print on the Pick List as opposed to this product. | IsPickListPrintDetails character(1) NOT NULL Yes-No |
| Purchased | 採購 | Organization purchases this product | The Purchased check box indicates if this product is purchased by this organization. | IsPurchased character(1) NOT NULL Yes-No |
| Sold | 銷售 | Organization sells this product | The Sold check box indicates if this product is sold by this organization. | IsSold character(1) NOT NULL Yes-No |
| Discontinued | 中止 | 該產品不再可用 | The Discontinued check box indicates a product that has been discontinued. | Discontinued character(1) Yes-No |
| Discontinued At | Discontinued At | Discontinued At indicates Date when product was discontinued | null | DiscontinuedAt timestamp without time zone Date |
| Expense Type | 費用類型 | 費用報表類型 | null | S_ExpenseType_ID numeric(10) Table Direct |
| Resource | 資源 | 資源 | null | S_Resource_ID numeric(10) Table Direct |
| Subscription Type | Subscription Type | Type of subscription | Subscription type and renewal frequency | C_SubscriptionType_ID numeric(10) Table Direct |
| Exclude Auto Delivery | Exclude Auto Delivery | Exclude from automatic Delivery | The product is excluded from generating Shipments. This allows manual creation of shipments for high demand items. If selected, you need to create the shipment manually.
But, the item is always included, when the delivery rule of the Order is Force (e.g. for POS). This allows finer granularity of the Delivery Rule Manual. |
IsExcludeAutoDelivery character(1) NOT NULL Yes-No |
| Image URL | 圖像網址 | 圖像的網址 | 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 character varying(120) URL |
| Description URL | 描述網址 | 網址為描述 | null | DescriptionURL character varying(120) URL |
| Guarantee Days | 保證天數 | Number of days the product is guaranteed or available | If the value is 0, there is no limit to the availability or guarantee, otherwise the guarantee date is calculated by adding the days to the delivery date. | GuaranteeDays numeric(10) Integer |
| Min Guarantee Days | Min Guarantee Days | Minumum number of guarantee days | When selecting batch/products with a guarantee date, the minimum left guarantee days for automatic picking. You can pick any batch/product manually. | GuaranteeDaysMin numeric(10) Integer |
| Attribute Set | 屬性組合 | 產品屬性組合 | Define Product Attribute Sets to add additional attributes and values to the product. You need to define a Attribute Set if you want to enable Serial and Lot Number tracking. | M_AttributeSet_ID numeric(10) Table Direct |
| Attribute Set Instance | Attribute Set Instance | Product Attribute Values | The values of the actual Product Attributes. Product Instance attributes are defined in the actual transactions. | M_AttributeSetInstance_ID numeric(10) Product Attribute |
| Copy from product | Copy from product | Copy prices etc from other product | null | CopyFrom character(1) Button |
| Featured in Web Store | Featured in Web Store | If selected, the product is displayed in the inital or any empy search | In the display of products in the Web Store, the product is displayed in the inital view or if no search criteria are entered. To be displayed, the product must be in the price list used. | IsWebStoreFeatured character(1) NOT NULL Yes-No |
| Self-Service | 自助式服務 | This is a Self-Service entry or this entry can be changed via Self-Service | Self-Service allows users to enter data or update their data. The flag indicates, that this record was entered or created via Self-Service or that the user can change it via the Self-Service functionality. | IsSelfService character(1) NOT NULL Yes-No |
| Group1 | Group1 | null | null | Group1 character varying(255) String |
| Group2 | Group2 | null | null | Group2 character varying(255) String |
TAB: BOM
描述: Bill of Material product lines
幫助 The Bill of Materials tab defines those products that are generated from other products. A Bill of Material (BOM) is one or more Products or BOMs.
Available Quantity: - Stored BOMs have to be created via "Production" - The available quantity of a non-stored BOMs is dynamically calculated - The attribute "Stored" is defined in the "Product" tab
Price: - BOMs must be listed in Pricelists - If the price is 0.00, the price is dynamically calculated
Printing: - Usually, only the BOM information is printed - For invoices, delivery slips and pick lists, you have the option to print the details - In the details, the quantity is listed - and the price, if this is dynamically calculated
File:產品 - BOM - 窗口 (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) Product Attribute |
| 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(80) NOT NULL String |
| UOM | 度量單位 | 度量單位 | The UOM defines a unique non monetary Unit of Measure | C_UOM_ID numeric(10) Table Direct |
| 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(60) NOT NULL Text |
| 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 |
| 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 |
| Change Notice | Change Notice | Bill of Materials (Engineering) Change Notice (Version) | null | M_ChangeNotice_ID numeric(10) Table Direct |
| Document No | 文檔號 | Document sequence number of the document | The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".
If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. 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). |
DocumentNo character varying(22) String |
| Revision | Revision | null | null | Revision character varying(10) String |
| Valid from | 開始有效 | Valid from including this date (first day) | The Valid From date indicates the first day of a date range | ValidFrom timestamp without time zone NOT NULL Date |
| Valid to | 結束有效 | Valid to including this date (last day) | The Valid To date indicates the last day of a date range | ValidTo timestamp without time zone Date |
| BOM Type | 物料清單類型 | BOM 的類型 | Type of Bill of Materials Part. A Standard Part (default) is always included in a BOM. An Optional Part can be selected in "Drop BOM". If a Part is member of one of the alternative groups, you can select one part in that group in the "Drop BOM" functionaly (example: either 64/256/512 MB Memory). | BOMType character(1) List |
| BOM Use | BOM Use | The use of the Bill of Material | By default the Master BOM is used, if the alternatives are not defined | BOMUse character(1) List |
| BOM & Formula | BOM & Formula | BOM & Formula | null | PP_Product_BOM_ID numeric(10) NOT NULL ID |
| Copy BOM Lines From | Copy BOM Lines From | Copy BOM Lines from an exising BOM | Copy BOM Lines from an exising BOM. The BOM being copied to, must not have any existing BOM Lines. | CopyFrom character(1) Button |
TAB: Components
描述: Components
幫助 Components of Bill fo Material
File:產品 - Components - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Line No | 明細號 | Unique line for this document | Indicates the unique line for a document. It will also control the display order of the lines within a document. | Line numeric(10) NOT NULL Integer |
| Product | 產品 | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) NOT NULL Search |
| Component Type | Component Type | Component Type for a Bill of Material or Formula | The Component Type can be:
1.- By Product: Define a By Product as Component into BOM 2.- Component: Define a normal Component into BOM 3.- Option: Define an Option for Product Configure BOM 4.- Phantom: Define a Phantom as Component into BOM 5.- Packing: Define a Packing as Component into BOM 6.- Planning : Define Planning as Component into BOM 7.- Tools: Define Tools as Component into BOM 8.- Variant: Define Variant for Product Configure BOM |
ComponentType character(2) List |
| UOM | 度量單位 | 度量單位 | The UOM defines a unique non monetary Unit of Measure | C_UOM_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 |
| 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 |
| 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 |
| Change Notice | Change Notice | Bill of Materials (Engineering) Change Notice (Version) | null | M_ChangeNotice_ID numeric(10) Table Direct |
| Valid from | Valid from | Valid from including this date (first day) | The Valid From date indicates the first day of a date range
The Valid From and Valid To dates indicate the valid time period to use the BOM in a Manufacturing Order. |
ValidFrom timestamp without time zone NOT NULL Date |
| Valid to | 結束有效 | Valid to including this date (last day) | The Valid To date indicates the last day of a date range | ValidTo timestamp without time zone Date |
| Is Qty Percentage | Is Qty Percentage | Indicate that this component is based in % Quantity | Indicate that this component is based in % Quantity | IsQtyPercentage character(1) Yes-No |
| Is Critical Component | Is Critical Component | Indicate that a Manufacturing Order can not begin without have this component | Indicate that a Manufacturing Order can not begin without have this component | IsCritical character(1) Yes-No |
| Quantity in % | Quantity in % | Indicate the Quantity % use in this Formula | Exist two way the add a compenent to a BOM or Formula:
1.- Adding a Component based in quantity to use in this BOM 2.- Adding a Component based in % to use the Order Quantity of Manufacturing Order in this Formula. |
QtyBatch numeric Number |
| Quantity | Quantity | Indicate the Quantity use in this BOM | Exist two way the add a compenent to a BOM or Formula:
1.- Adding a Component based in quantity to use in this BOM 2.- Adding a Component based in % to use the Order Quantity of Manufacturing Order in this Formula. |
QtyBOM numeric Number |
| Scrap % | Scrap % | Indicate the Scrap % for calculate the Scrap Quantity | Scrap is useful to determinate a rigth Standard Cost and management a good supply. | Scrap numeric Number |
| Quantity Assay | Quantity Assay | Indicated the Quantity Assay to use into Quality Order | Indicated the Quantity Assay to use into Quality Order | Assay numeric Quantity |
| Issue Method | Issue Method | There are two methods for issue the components to Manufacturing Order | Method Issue: The component are delivered one for one and is necessary indicate the delivered quantity for each component.
Method BackFlush: The component are delivered based in BOM, The delivered quantity for each component is based in BOM or Formula and Manufacturing Order Quantity. Use the field Backflush Group for grouping the component in a Backflush Method. |
IssueMethod character(1) NOT NULL List |
| Backflush Group | Backflush Group | The Grouping Components to the Backflush | When the components are deliver is possible to indicated The Backflush Group this way you only can deliver the components that are for this Backflush Group. | BackflushGroup character varying(20) String |
| Lead Time Offset | Lead Time Offset | Optional Lead Time offset before starting production | Optional Lead Time offset before starting production | LeadTimeOffset numeric(10) Integer |
| Feature | Feature | Indicated the Feature for Product Configure | Indicated the Feature for Product Configure | Feature character varying(30) String |
| Forecast | Forecast | Indicated the % of participation this component into a of the BOM Planning | The BOM of Planning Type are useful to Planning the Product family.
For example is possible create a BOM Planning for an Automobile 10% Automobile Red 35% Automobile Blue 45% Automobile Black 19% Automobile Green 1% Automobile Orange When Material Plan is calculated MRP generate a Manufacturing Order meet to demand to each of the Automobile |
Forecast numeric Quantity |
| BOM & Formula | BOM & Formula | BOM & Formula | null | PP_Product_BOM_ID numeric(10) NOT NULL Search |
TAB: 物料清單
描述: Bill of Material product lines
幫助 The Bill of Materials tab defines those products that are generated from other products. A Bill of Material (BOM) is one or more Products or BOMs.可用庫存:
- Stored BOMs have to be created via "Production"
- The available quantity of a non-stored BOMs is dynamically calculated
- The attribute "Stored" is defined in the "Product" tab價格:
- BOMs must be listed in Pricelists
- If the price is 0.00, the price is dynamically calculated打印:
- Usually, only the BOM information is printed
- For invoices, delivery slips and pick lists, you have the option to print the details
- In the details, the quantity is listed - and the price, if this is dynamically calculated
File:產品 - 物料清單 - 窗口 (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 |
| Line No | 明細號 | Unique line for this document | Indicates the unique line for a document. It will also control the display order of the lines within a document. | Line numeric(10) NOT NULL Integer |
| 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 |
| Description | 描述 | 該記錄的可選描述 | 描述最多為 255 個字符。 | Description character varying(255) String |
| BOM Type | 物料清單類型 | BOM 的類型 | Type of Bill of Materials Part. A Standard Part (default) is always included in a BOM. An Optional Part can be selected in "Drop BOM". If a Part is member of one of the alternative groups, you can select one part in that group in the "Drop BOM" functionaly (example: either 64/256/512 MB Memory). | BOMType character(1) List |
| BOM Product | 物料清單產品 | 產品物料清單 | The BOM Product identifies an element that is part of this Bill of Materials. | M_ProductBOM_ID numeric(10) NOT NULL Search |
| BOM Quantity | 物料清單數量 | 物料清單數量 | The BOM Quantity indicates the quantity of the product in its Unit of Measure (multiplication) | BOMQty numeric NOT NULL Quantity |
| Part Type | Part Type | null | null | M_PartType_ID 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 null String |
| Bill of Materials | Bill of Materials | Bill of Materials | The Bill of Materials check box indicates if this product consists of a bill of materials. | IsBillOfMaterial null Yes-No |
| Standard Cost | 標準成本 | 標準成本 | Standard (plan) costs. | CostStandard null Amount |
| 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 null Amount |
TAB: 替代
描述: 定義替代
幫助 The Substitute Tab defines products which may be used as a replacement for the selected product.
File:產品 - 替代 - 窗口 (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 |
| 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(60) String |
| Description | 描述 | 該記錄的可選描述 | 描述最多為 255 個字符。 | Description character varying(255) String |
| 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 |
| Substitute | 替代 | Product which can be used in place of another product | The Substitute identifies the product to be used as a substitute for this product. | Substitute_ID numeric(10) NOT NULL Search |
TAB: Related
描述: Related Product
幫助 Related Product - e.g. for promotions
File:產品 - Related - 窗口 (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 |
| 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(60) NOT NULL String |
| 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 |
| Related Product Type | Related Product Type | null | null | RelatedProductType character(1) NOT NULL List |
| Related Product | Related Product | Related Product | null | RelatedProduct_ID numeric(10) NOT NULL Search |
TAB: 補貨
描述: 定義採購報表
幫助 The Replenishment Tab defines the type of replenishment quantities. This is used for automated ordering.
File:產品 - 補貨 - 窗口 (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 |
| Warehouse | 倉庫或服務位置 | Storage Warehouse and Service Point | The Warehouse identifies a unique Warehouse where products are stored or Services are provided. | M_Warehouse_ID numeric(10) NOT NULL Table Direct |
| Locator | 貨位 | 倉庫貨位 | The Locator ID indicates where in a Warehouse a product is located. | M_Locator_ID numeric(10) Table Direct |
| 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 |
| Replenish Type | 補貨類型 | Method for re-ordering a product | The Replenish Type indicates if this product will be manually re-ordered, ordered when the quantity is below the minimum quantity or ordered when it is below the maximum quantity. | ReplenishType character(1) NOT NULL List |
| Minimum Level | 庫存下限 | Minimum Inventory level for this product | Indicates the minimum quantity of this product to be stocked in inventory. | Level_Min numeric NOT NULL Amount |
| Maximum Level | 庫存上限 | Maximum Inventory level for this product | Indicates the maximum quantity of this product to be stocked in inventory. | Level_Max numeric NOT NULL Amount |
| Source Warehouse | Source Warehouse | Optional Warehouse to replenish from | If defined, the warehouse selected is used to replenish the product(s) | M_WarehouseSource_ID numeric(10) Table |
| Qty Batch Size | Qty Batch Size | null | null | QtyBatchSize numeric Quantity |
TAB: 採購
描述: 採購
幫助 The Purchasing Tab define the pricing and rules ( pack quantity, UPC, minimum order quantity) for each product.
File:產品 - 採購 - 窗口 (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 |
| Business Partner | 業務夥伴 | 標識業務夥伴 | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | C_BPartner_ID numeric(10) NOT NULL Search |
| Quality Rating | 質量等級 | 評估供應商等級方法 | The Quality Rating indicates how a vendor is rated (higher number = higher quality) | QualityRating numeric Integer |
| 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 |
| Current vendor | 當前供應商 | Use this Vendor for pricing and stock replenishment | The Current Vendor indicates if prices are used and Product is reordered from this vendor | IsCurrentVendor character(1) NOT NULL Yes-No |
| 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(20) String |
| Currency | 貨幣 | 幣種為該筆記錄 | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID numeric(10) Table Direct |
| List Price | 公開報價 | 公開報價 | The List Price is the official List Price in the document currency. | PriceList numeric Costs+Prices |
| Price effective | 有效的日期價格 | 有效的日期價格 | The Price Effective indicates the date this price is for. This allows you to enter future prices for products which will become effective when appropriate. | PriceEffective timestamp without time zone Date |
| PO Price | 採購定單價格 | 基於採購定單的價格 | The PO Price indicates the price for a product per the purchase order. | PricePO numeric Costs+Prices |
| Royalty Amount | 版權金額 | (Included) Amount for copyright, etc. | null | RoyaltyAmt numeric Amount |
| 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 numeric Costs+Prices |
| 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 numeric Costs+Prices |
| UOM | 度量單位 | 度量單位 | The UOM defines a unique non monetary Unit of Measure | C_UOM_ID numeric(10) Table Direct |
| Minimum Order Qty | 最小量定單數量 | 在 UOM 中的最小量定單量 | The Minimum Order Quantity indicates the smallest quantity of this product which can be ordered. | Order_Min numeric Quantity |
| Order Pack Qty | 定單包裝數量 | Package order size in UOM (e.g. order set of 5 units) | The Order Pack Quantity indicates the number of units in each pack of this product. | Order_Pack numeric Quantity |
| Promised Delivery Time | 允諾配送時間 | Promised days between order and delivery | The Promised Delivery Time indicates the number of days between the order date and the date that delivery was promised. | DeliveryTime_Promised numeric(10) Integer |
| Actual Delivery Time | 實際配送時間 | Actual days between order and delivery | The Actual Delivery Time indicates the number of days elapsed between placing an order and the delivery of the order | DeliveryTime_Actual numeric(10) Integer |
| Cost per Order | 每定單成本 | 每定單固定的成本 | The Cost Per Order indicates the fixed charge levied when an order for this product is placed. | CostPerOrder numeric Costs+Prices |
| Partner Product Key | 夥伴產品號 | 供應商的產品未 | The Vendor Product Number identifies the number used by the vendor for this product. | VendorProductNo character varying(40) NOT NULL String |
| Partner Category | 供應商分類 | 供應商的產品種類 | The Vendor Category identifies the category used by the vendor for this product. | VendorCategory character(30) String |
| Manufacturer | 製造商 | null | null | Manufacturer character(30) String |
| Discontinued | 中止 | 該產品不再可用 | The Discontinued check box indicates a product that has been discontinued. | Discontinued character(1) Yes-No |
| Discontinued At | Discontinued At | Discontinued At indicates Date when product was discontinued | null | DiscontinuedAt timestamp without time zone Date |
TAB: 業務夥伴
描述: 產品的關於業務夥伴的特定信息
幫助 Note that some information is for reference only!
File:產品 - 業務夥伴 - 窗口 (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 |
| Business Partner | 業務夥伴 | 標識業務夥伴 | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | C_BPartner_ID numeric(10) NOT NULL Search |
| Description | 描述 | 該記錄的可選描述 | 描述最多為 255 個字符。 | Description character varying(255) String |
| 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 |
| Partner Product Key | 夥伴產品號 | 供應商的產品未 | The Vendor Product Number identifies the number used by the vendor for this product. | VendorProductNo character varying(30) String |
| Partner Category | 供應商分類 | 供應商的產品種類 | The Vendor Category identifies the category used by the vendor for this product. | VendorCategory character varying(30) String |
| Manufacturer | 製造商 | null | null | Manufacturer character varying(30) String |
| Quality Rating | 質量等級 | 評估供應商等級方法 | The Quality Rating indicates how a vendor is rated (higher number = higher quality) | QualityRating numeric Number |
| Min Shelf Life % | Min Shelf Life % | Minimum Shelf Life in percent based on Product Instance Guarantee Date | Miminum Shelf Life of products with Guarantee Date instance. If > 0 you cannot select products with a shelf life ((Guarantee Date-Today) / Guarantee Days) less than the minum shelf life, unless you select "Show All" | ShelfLifeMinPct numeric(10) NOT NULL Integer |
| Min Shelf Life Days | Min Shelf Life Days | Minimum Shelf Life in days based on Product Instance Guarantee Date | Miminum Shelf Life of products with Guarantee Date instance. If > 0 you cannot select products with a shelf life less than the minum shelf life, unless you select "Show All" | ShelfLifeMinDays numeric(10) NOT NULL Integer |
| Is Manufacturer | Is Manufacturer | Indicate role of this Business partner as Manufacturer | null | IsManufacturer character(1) NOT NULL Yes-No |
TAB: 價格
描述: 訂價的產品
幫助 The Pricing Tab displays the List, Standard and Limit prices for each price list a product is contained in.
File:產品 - 價格 - 窗口 (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 |
| 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 numeric(10) NOT NULL Table Direct |
| 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 |
| List Price | 公開報價 | 公開報價 | The List Price is the official List Price in the document currency. | PriceList numeric NOT NULL Costs+Prices |
| Standard Price | 標準價格 | 標準價格 | The Standard Price indicates the standard or normal price for a product on this price list | PriceStd numeric NOT NULL Costs+Prices |
| Limit Price | 限制價格 | 產品的最低價格 | The Price Limit indicates the lowest price for a product stated in the Price List Currency. | PriceLimit numeric NOT NULL Costs+Prices |
TAB: Download
描述: Maintain Product Downloads
幫助 Define downloads for a product. If the product is an asset, the user can download the data.
File:產品 - Download - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Client | 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 numeric(10) NOT NULL Table Direct |
| Organization | 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 numeric(10) NOT NULL Table Direct |
| Product | Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) NOT NULL Search |
| Name | 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(60) NOT NULL String |
| Active | 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 character(1) NOT NULL Yes-No |
| Download URL | Download URL | URL of the Download files | Semicolon separated list of URLs to be downloaded or distributed | DownloadURL character varying(120) NOT NULL URL |
TAB: 會計
描述: Define Accounting Parameters
幫助 The Accounting Tab defines the defaults to use when generating accounting transactions for orders and invoices which contain this product.
File:產品 - 會計 - 窗口 (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 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 |
| 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 |
| 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 numeric(10) NOT NULL Account |
| Product Expense | 產品費用 | 產品費用帳戶 | The Product Expense Account indicates the account used to record expenses associated with this product. | P_Expense_Acct numeric(10) NOT NULL Account |
| Cost Adjustment | Cost Adjustment | Product Cost Adjustment Account | Account used for posting product cost adjustments (e.g. landed costs) | P_CostAdjustment_Acct numeric(10) Account |
| Inventory Clearing | Inventory Clearing | Product Inventory Clearing Account | Account used for posting matched product (item) expenses (e.g. AP Invoice, Invoice Match). You would use a different account then Product Expense, if you want to differentiate service related costs from item related costs. The balance on the clearing account should be zero and accounts for the timing difference between invoice receipt and matching. | P_InventoryClearing_Acct numeric(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 numeric(10) NOT NULL 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 numeric(10) NOT NULL 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 numeric(10) NOT NULL Account |
| Average Cost Variance | Average Cost Variance | Average Cost Variance | The Average Cost Variance is used in weighted average costing to reflect differences when posting costs for negative inventory. | P_AverageCostVariance_Acct numeric(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 numeric(10) NOT NULL 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 numeric(10) NOT NULL 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 numeric(10) NOT NULL Account |
| Work In Process | Work In Process | The Work in Process account is the account used Manufacturing Order | null | P_WIP_Acct numeric(10) Account |
| Floor Stock | Floor Stock | The Floor Stock account is the account used Manufacturing Order | The Floor Stock is used for accounting the component with Issue method is set Floor stock into Bill of Material & Formula Window.
The components with Issue Method defined as Floor stock is acounting next way: Debit Floor Stock Account Credit Work in Process Account |
P_FloorStock_Acct numeric(10) Account |
| Method Change Variance | Method Change Variance | The Method Change Variance account is the account used Manufacturing Order | The Method Change Variance is used in Standard Costing. It reflects the difference between the Standard BOM , Standard Manufacturing Workflow and Manufacturing BOM Manufacturing Workflow.
If you change the method the manufacturing defined in BOM or Workflow Manufacturig then this variance is generate. |
P_MethodChangeVariance_Acct numeric(10) Account |
| Usage Variance | Usage Variance | The Usage Variance account is the account used Manufacturing Order | The Usage Variance is used in Standard Costing. It reflects the difference between the Quantities of Standard BOM or Time Standard Manufacturing Workflow and Quantities of Manufacturing BOM or Time Manufacturing Workflow of Manufacturing Order.
If you change the Quantities or Time defined in BOM or Workflow Manufacturig then this variance is generate. |
P_UsageVariance_Acct numeric(10) Account |
| Rate Variance | Rate Variance | The Rate Variance account is the account used Manufacturing Order | The Rate Variance is used in Standard Costing. It reflects the difference between the Standard Cost Rates and The Cost Rates of Manufacturing Order.
If you change the Standard Rates then this variance is generate. |
P_RateVariance_Acct numeric(10) Account |
| Mix Variance | Mix Variance | The Mix Variance account is the account used Manufacturing Order | The Mix Variance is used when a co-product received in Inventory is different the quantity expected | P_MixVariance_Acct numeric(10) Account |
| Labor | Labor | The Labor account is the account used Manufacturing Order | The Labor is used for accounting the productive Labor | P_Labor_Acct numeric(10) Account |
| Burden | Burden | The Burden account is the account used Manufacturing Order | The Burden is used for accounting the Burden | P_Burden_Acct numeric(10) Account |
| Cost Of Production | Cost Of Production | The Cost Of Production account is the account used Manufacturing Order | The Cost Of Production is used for accounting Non productive Labor | P_CostOfProduction_Acct numeric(10) Account |
| Outside Processing | Outside Processing | The Outside Processing Account is the account used in Manufacturing Order | The Outside Processing Account is used for accounting the Outside Processing | P_OutsideProcessing_Acct numeric(10) Account |
| Overhead | Overhead | The Overhead account is the account used in Manufacturing Order | null | P_Overhead_Acct numeric(10) Account |
| Scrap | Scrap | The Scrap account is the account used in Manufacturing Order | null | P_Scrap_Acct numeric(10) Account |
TAB: 交易
描述: Transactions for stored Products
幫助 The Transaction Tab displays the transactions that have been processed for this product.
File:產品 - 交易 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Inventory Transaction | 庫存交易 | null | null | M_Transaction_ID numeric(10) NOT NULL ID |
| 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 |
| 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 |
| Locator | 貨位 | 倉庫貨位 | The Locator ID indicates where in a Warehouse a product is located. | M_Locator_ID numeric(10) NOT NULL Locator (WH) |
| Movement Quantity | 調撥數量 | Quantity of a product moved. | The Movement Quantity indicates the quantity of a product that has been moved. | MovementQty numeric NOT NULL Quantity |
| Movement Date | 調撥日期 | Date a product was moved in or out of inventory | The Movement Date indicates the date that a product moved in or out of inventory. This is the result of a shipment, receipt or inventory movement. | MovementDate timestamp without time zone NOT NULL Date |
| Movement Type | 調撥類型 | Method of moving the inventory | The Movement Type indicates the type of movement (in, out, to production, etc) | MovementType character(2) NOT NULL List |
| Receipt Line | 收貨明細 | 接收貨明細 | The Shipment Receipt Line indicates a unique line in a Shipment Receipt document | M_InOutLine_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 |
| Move Line | 調撥明細 | 調撥明細 | The Movement Line indicates the inventory movement document line (if applicable) for this transaction | M_MovementLine_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 |
| 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 |
TAB: 翻譯
描述: null
幫助 null
File:產品 - 翻譯 - 窗口 (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 Table Direct |
| Language | 語言 | 本客戶使用的語言 | The Language identifies the language to use for display | AD_Language character varying(6) NOT NULL Table |
| 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 |
| Document Note | 文件注釋 | Additional information for a Document | The Document Note is used for recording any additional information regarding this product. | DocumentNote character varying(2000) String |
| 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 |
| Translated | 已翻譯 | 列被翻譯 | The Translated checkbox indicates if this column is translated. | IsTranslated character(1) NOT NULL Yes-No |
TAB: Located at
描述: Where are my units located?
幫助 null
File:產品 - Located at - 窗口 (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 |
| 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 |
| Attribute Set Instance | 屬性組合實例 | Product Attribute Set Instance | The values of the actual Product Attributes | M_AttributeSetInstance_ID numeric(10) NOT NULL Product Attribute |
| Locator | 貨位 | 倉庫貨位 | The Locator ID indicates where in a Warehouse a product is located. | M_Locator_ID numeric(10) NOT NULL Locator (WH) |
| Date last inventory count | 最近盤點日期 | 最近盤點日期 | The Date Last Inventory Count indicates the last time an Inventory count was done. | DateLastInventory timestamp without time zone Date |
| On Hand Quantity | 在庫庫存 | 在庫庫存 | The On Hand Quantity indicates the quantity of a product that is on hand in a warehouse. | QtyOnHand numeric NOT NULL Quantity |
| PO Quantity | 已定單量 | 已定單量 | The Ordered Quantity indicates the quantity of a product that was ordered. | QtyOrdered numeric NOT NULL Quantity |
| On Order Quantity | 保留庫存 | 保留庫存 | The Reserved Quantity indicates the quantity of a product that is currently reserved for other orders. | QtyReserved numeric NOT NULL Quantity |
TAB: UOM Conversion
描述: null
幫助 null
File:產品 - UOM Conversion - 窗口 (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) Search |
| 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 |
| UOM | 度量單位 | 度量單位 | The UOM defines a unique non monetary Unit of Measure | C_UOM_ID numeric(10) NOT NULL Table Direct |
| UoM To | UoM 到 | Target or destination Unit of Measure | The UOM To indicates the destination UOM for a UOM Conversion pair. | C_UOM_To_ID numeric(10) NOT NULL Table |
| Multiply Rate | 乘積比率 | Rate to multiple the source by to calculate the target. | To convert Source number to Target number, the Source is multiplied by the multiply rate. If the Multiply Rate is entered, then the Divide Rate will be automatically calculated. | MultiplyRate numeric NOT NULL Number |
| Divide Rate | 分開比率 | To convert Source number to Target number, the Source is divided | To convert Source number to Target number, the Source is divided by the divide rate. If you enter a Divide Rate, the Multiply Rate will be automatically calculated. | DivideRate numeric NOT NULL Number |
TAB: Costs
描述: null
幫助 null
File:產品 - 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 |
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}