Window: Product
[Created: 09/08/1999 - Updated: 26/01/2023 ]
Description: Maintain Products
Help: 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: Product
[Created: 09/08/1999 - Updated: 02/01/2000 ]
Description: Define Product
Help: 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.
Tab Level: 0
Table 10: Product - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_product.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_product.AD_Org_ID numeric(10) Table Direct |
| Search Key | Search key for the record in the format required - must be unique | A search key allows you a fast method of finding a particular record.If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order). | m_product.Value character varying(510) String |
| Version No | Version Number | m_product.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. | m_product.Name character varying(255) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | m_product.Description character varying(255) String |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | m_product.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. | m_product.DocumentNote character varying(2000) Text |
| UPC/EAN | Bar Code (Universal Product Code or its superset European Article Number) | Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode) | m_product.UPC character varying(30) String |
| SKU | Stock Keeping Unit | The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema. | m_product.SKU character varying(30) String |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | m_product.IsActive character(1) Yes-No |
| Summary Level | This is a summary entity | A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. | m_product.IsSummary character(1) Yes-No |
| Product Category | Category of a Product | Identifies the category which this product belongs to. Product categories are used for pricing and selection. | m_product.M_Product_Category_ID numeric(10) Table Direct |
| Classification | Classification for grouping | The Classification can be used to optionally group products. | m_product.Classification character varying(12) String |
| Tax Category | Tax Category | The Tax Category provides a method of grouping similar taxes. For example, Sales Tax or Value Added Tax. | m_product.C_TaxCategory_ID numeric(10) Table Direct |
| Revenue Recognition | Method for recording revenue | The Revenue Recognition indicates how revenue will be recognized for this product | m_product.C_RevenueRecognition_ID numeric(10) Table Direct |
| UOM | Unit of Measure | The UOM defines a unique non monetary Unit of Measure | m_product.C_UOM_ID numeric(10) Table Direct |
| Sales Representative | Sales Representative or Company Agent | The Sales Representative indicates the Sales Rep for this Region. Any Sales Rep must be a valid internal user. | m_product.SalesRep_ID numeric(10) Table |
| Product Type | Type of product | The type of product also determines accounting consequences. | m_product.ProductType character(1) List |
| Mail Template | Text templates for mailings | The Mail Template indicates the mail template for return messages. Mail text can include variables. The priority of parsing is User/Contact, Business Partner and then the underlying business object (like Request, Dunning, Workflow object).So, @Name@ would resolve into the User name (if user is defined defined), then Business Partner name (if business partner is defined) and then the Name of the business object if it has a Name.For Multi-Lingual systems, the template is translated based on the Business Partner's language selection. | m_product.R_MailText_ID numeric(10) Table Direct |
| Weight | Weight of a product | The Weight indicates the weight of the product in the Weight UOM of the Tenant | m_product.Weight numeric Amount |
| Volume | Volume of a product | The Volume indicates the volume of the product in the Volume UOM of the Tenant | m_product.Volume numeric Amount |
| Own Box | m_product.IsOwnBox character(1) Yes-No | ||
| Customs Tariff Number | Customs Tariff Number, usually the HS-Code | m_product.CustomsTariffNumber character varying(20) String | |
| Freight Category | Category of the Freight | Freight Categories are used to calculate the Freight for the Shipper selected | m_product.M_FreightCategory_ID numeric(10) Table Direct |
| Drop Shipment | Drop Shipments are sent directly to the Drop Shipment Location | Drop Shipments are sent directly to the Drop Shipment Location using the Drop Ship Business Partner name and contact. | m_product.IsDropShip character(1) Yes-No |
| Stocked | Organization stocks this product | The Stocked check box indicates if this product is stocked by this Organization. | m_product.IsStocked character(1) Yes-No |
| Manufactured | This product is manufactured | m_product.IsManufactured character(1) Yes-No | |
| 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. | m_product.IsPhantom character(1) Yes-No |
| Kanban controlled | This part is Kanban controlled | m_product.IsKanban character(1) Yes-No | |
| Part Type | m_product.M_PartType_ID numeric(10) Table Direct | ||
| Locator | Warehouse Locator | The Locator indicates where in a Warehouse a product is located. | m_product.M_Locator_ID numeric(10) Locator (WH) |
| Shelf Width | Shelf width required | The Shelf Width indicates the width dimension required on a shelf for a product | m_product.ShelfWidth numeric(10) Integer |
| Shelf Height | Shelf height required | The Shelf Height indicates the height dimension required on a shelf for a product | m_product.ShelfHeight numeric Amount |
| Shelf Depth | Shelf depth required | The Shelf Depth indicates the depth dimension required on a shelf for a product | m_product.ShelfDepth numeric(10) Integer |
| Units Per Pallet | Units Per Pallet | The Units per Pallet indicates the number of units of this product which fit on a pallet. | m_product.UnitsPerPallet numeric Costs+Prices |
| Bill of Materials | Bill of Materials | The Bill of Materials check box indicates if this product consists of a bill of materials. | m_product.IsBOM character(1) 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 | m_product.IsVerified character(1) Yes-No |
| Verify BOM Structure | Verify BOM for correctness | The Verify BOM process checks for circular BOMs (unsupported). | m_product.Processing character(1) Button |
| Auto Produce | Auto create production to fulfill shipment | m_product.IsAutoProduce character(1) Yes-No | |
| 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. | m_product.IsInvoicePrintDetails character(1) 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. | m_product.IsPickListPrintDetails character(1) Yes-No |
| Purchased | Organization purchases this product | The Purchased check box indicates if this product is purchased by this organization. | m_product.IsPurchased character(1) Yes-No |
| Sold | Organization sells this product | The Sold check box indicates if this product is sold by this organization. | m_product.IsSold character(1) Yes-No |
| Discontinued | This product is no longer available | The Discontinued check box indicates a product that has been discontinued. | m_product.Discontinued character(1) Yes-No |
| Discontinued At | Discontinued At indicates Date when product was discontinued | m_product.DiscontinuedAt timestamp without time zone Date | |
| Expense Type | Expense report type | m_product.S_ExpenseType_ID numeric(10) Table Direct | |
| Resource | Resource | m_product.S_Resource_ID numeric(10) Table Direct | |
| 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. | m_product.IsExcludeAutoDelivery character(1) Yes-No |
| Image URL | URL of image | URL of image; The image is not stored in the database, but retrieved at runtime. The image can be a gif, jpeg or png. | m_product.ImageURL character varying(120) URL |
| Description URL | URL for the description | m_product.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. | m_product.GuaranteeDays numeric(10) Integer |
| Min Guarantee Days | Minimum 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. | m_product.GuaranteeDaysMin numeric(10) Integer |
| Attribute Set | Product 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_product.M_AttributeSet_ID numeric(10) Table Direct |
| Attribute Set Instance | Product Attribute Values | The values of the actual Product Attributes. Product Instance attributes are defined in the actual transactions. | m_product.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| Copy from product | Copy prices etc from other product | m_product.CopyFrom character(1) Button | |
| Featured in Web Store | If selected, the product is displayed in the initial or any empty search | In the display of products in the Web Store, the product is displayed in the initial view or if no search criteria are entered. To be displayed, the product must be in the price list used. | m_product.IsWebStoreFeatured character(1) 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. | m_product.IsSelfService character(1) Yes-No |
| Group1 | m_product.Group1 character varying(255) String | ||
| Group2 | m_product.Group2 character varying(255) String |
Tab: BOM
[Created: 26/11/2009 - Updated: 26/09/2021 ]
Description: Bill of Material product lines
Help: 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" tabPrice:- BOMs must be listed in Pricelists- If the price is 0.00, the price is dynamically calculatedPrinting:- 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
Tab Level: 1
Table 15: BOM - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | pp_product_bom.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | pp_product_bom.AD_Org_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | pp_product_bom.M_Product_ID numeric(10) Search |
| Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | pp_product_bom.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| Search Key | Search key for the record in the format required - must be unique | A search key allows you a fast method of finding a particular record.If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order). | pp_product_bom.Value character varying(80) 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. | pp_product_bom.Name character varying(60) Text |
| Description | Optional short description of the record | A description is limited to 255 characters. | pp_product_bom.Description character varying(255) String |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | pp_product_bom.Help character varying(2000) Text |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | pp_product_bom.IsActive character(1) Yes-No |
| Revision | pp_product_bom.Revision character varying(10) String | ||
| BOM Type | Type of BOM | The type of Bills of Materials determines the state | pp_product_bom.BOMType character(1) List |
| BOM Use | The use of the Bill of Material | By default the Master BOM is used, if the alternatives are not defined | pp_product_bom.BOMUse character(1) List |
| Copy BOM Lines From | Copy BOM Lines from an existing BOM | Copy BOM Lines from an existing BOM. The BOM being copied to, must not have any existing BOM Lines. | pp_product_bom.CopyFrom character(1) Button |
Tab: Components
[Created: 26/11/2009 - Updated: 15/01/2024 ]
Description: Components
Help: Components of Bill of Materials
Tab Level: 2
Table 16: Components - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| 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. | pp_product_bomline.Line numeric(10) Integer |
| BOM & Formula | BOM & Formula | pp_product_bomline.PP_Product_BOM_ID numeric(10) Search | |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | pp_product_bomline.M_Product_ID numeric(10) Search |
| Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | pp_product_bomline.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| 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 BOM2.- Component: Define a normal Component into BOM 3.- Option: Define an Option for Product Configure BOM4.- Phantom: Define a Phantom as Component into BOM5.- Packing: Define a Packing as Component into BOM6.- Planning : Define Planning as Component into BOM7.- Tools: Define Tools as Component into BOM8.- Variant: Define Variant for Product Configure BOM | pp_product_bomline.ComponentType character(2) List |
| Description | Optional short description of the record | A description is limited to 255 characters. | pp_product_bomline.Description character varying(255) String |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | pp_product_bomline.Help character varying(2000) Text |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | pp_product_bomline.IsActive character(1) Yes-No |
| Quantity | Indicate the Quantity use in this BOM | Exist two way the add a component to a BOM or Formula:1.- Adding a Component based in quantity to use in this BOM2.- Adding a Component based in % to use the Order Quantity of Manufacturing Order in this Formula. | pp_product_bomline.QtyBOM numeric Number |
| Feature | Indicated the Feature for Product Configure | Indicated the Feature for Product Configure | pp_product_bomline.Feature character varying(30) String |
Tab: Substitute
[Created: 09/08/1999 - Updated: 21/01/2009 ]
Description: Define Substitute
Help: The Substitute Tab defines products which may be used as a replacement for the selected product.
Tab Level: 1
Table 30: Substitute - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_substitute.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_substitute.AD_Org_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | m_substitute.M_Product_ID numeric(10) 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. | m_substitute.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | m_substitute.Description character varying(255) String |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | m_substitute.IsActive character(1) Yes-No |
| Substitute | Entity which can be used in place of this entity | The Substitute identifies the entity to be used as a substitute for this entity. | m_substitute.Substitute_ID numeric(10) Search |
Tab: Related
[Created: 19/02/2004 - Updated: 21/01/2009 ]
Description: Related Product
Help: Related Product - e.g. for promotions
Tab Level: 1
Table 40: Related - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_relatedproduct.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_relatedproduct.AD_Org_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | m_relatedproduct.M_Product_ID numeric(10) 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. | m_relatedproduct.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | m_relatedproduct.Description character varying(255) Text |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | m_relatedproduct.IsActive character(1) Yes-No |
| Related Product Type | m_relatedproduct.RelatedProductType character(1) List | ||
| Related Product | Related Product | m_relatedproduct.RelatedProduct_ID numeric(10) Search |
Tab: Replenish
[Created: 09/08/1999 - Updated: 21/07/2005 ]
Description: Define Product Replenishment
Help: The Replenishment Tab defines the type of replenishment quantities. This is used for automated ordering. If you select a custom replenishment type, you need to create a class implementing org.compiere.util.ReplenishInterface and set that on warehouse level.
Tab Level: 1
Table 50: Replenish - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_replenish.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_replenish.AD_Org_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | m_replenish.M_Product_ID numeric(10) Search |
| Warehouse | Storage Warehouse and Service Point | The Warehouse identifies a unique Warehouse where products are stored or Services are provided. | m_replenish.M_Warehouse_ID numeric(10) Table Direct |
| Locator | Warehouse Locator | The Locator indicates where in a Warehouse a product is located. | m_replenish.M_Locator_ID numeric(10) Table Direct |
| 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. | m_replenish.IsActive character(1) 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. If you select a custom replenishment type, you need to create a class implementing org.compiere.util.ReplenishInterface and set that on warehouse level. | m_replenish.ReplenishType character(1) List |
| Minimum Level | Minimum Inventory level for this product | Indicates the minimum quantity of this product to be stocked in inventory. | m_replenish.Level_Min numeric Amount |
| Maximum Level | Maximum Inventory level for this product | Indicates the maximum quantity of this product to be stocked in inventory. | m_replenish.Level_Max numeric Amount |
| Source Warehouse | Optional Warehouse to replenish from | If defined, the warehouse selected is used to replenish the product(s) | m_replenish.M_WarehouseSource_ID numeric(10) Table |
| Qty Batch Size | m_replenish.QtyBatchSize numeric Quantity |
Tab: Purchasing
[Created: 04/12/1999 - Updated: 02/01/2000 ]
Description: Purchasing
Help: The Purchasing Tab define the pricing and rules ( pack quantity, UPC, minimum order quantity) for each product.
Tab Level: 1
Table 60: Purchasing - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_product_po.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_product_po.AD_Org_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | m_product_po.M_Product_ID numeric(10) Search |
| Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | m_product_po.C_BPartner_ID numeric(10) Search |
| Quality Rating | Method for rating vendors | The Quality Rating indicates how a vendor is rated (higher number = higher quality) | m_product_po.QualityRating numeric Integer |
| 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. | m_product_po.IsActive character(1) 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 | m_product_po.IsCurrentVendor character(1) Yes-No |
| UPC/EAN | Bar Code (Universal Product Code or its superset European Article Number) | Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode) | m_product_po.UPC character varying(20) String |
| Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | m_product_po.C_Currency_ID numeric(10) Table Direct |
| List Price | List Price | The List Price is the official List Price in the document currency. | m_product_po.PriceList numeric Costs+Prices |
| Price effective | Effective Date of Price | 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. | m_product_po.PriceEffective timestamp without time zone Date |
| PO Price | Price based on a purchase order | The PO Price indicates the price for a product per the purchase order. | m_product_po.PricePO numeric Costs+Prices |
| Royalty Amount | (Included) Amount for copyright, etc. | m_product_po.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. | m_product_po.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. | m_product_po.PriceLastInv numeric Costs+Prices |
| UOM | Unit of Measure | The UOM defines a unique non monetary Unit of Measure | m_product_po.C_UOM_ID numeric(10) Table Direct |
| Minimum Order Qty | Minimum order quantity in UOM | The Minimum Order Quantity indicates the smallest quantity of this product which can be ordered. | m_product_po.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. | m_product_po.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. | m_product_po.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 | m_product_po.DeliveryTime_Actual numeric(10) Integer |
| Cost per Order | Fixed Cost Per Order | The Cost Per Order indicates the fixed charge levied when an order for this product is placed. | m_product_po.CostPerOrder numeric Costs+Prices |
| Partner Product Key | Product Key of the Business Partner | The Business Partner Product Key identifies the number used by the Business Partner for this product. It can be printed on orders and invoices when you include the Product Key in the print format. | m_product_po.VendorProductNo character varying(40) String |
| Partner Category | Product Category of the Business Partner | The Business Partner Category identifies the category used by the Business Partner for this product. | m_product_po.VendorCategory character varying(30) String |
| Manufacturer | Manufacturer of the Product | The manufacturer of the Product (used if different from the Business Partner / Vendor) | m_product_po.Manufacturer character varying(30) String |
| Discontinued | This product is no longer available | The Discontinued check box indicates a product that has been discontinued. | m_product_po.Discontinued character(1) Yes-No |
| Discontinued At | Discontinued At indicates Date when product was discontinued | m_product_po.DiscontinuedAt timestamp without time zone Date |
Tab: Business Partner
[Created: 07/12/2003 - Updated: 19/04/2005 ]
Description: Business Partner specific Information of a Product
Help: Note that some information is for reference only! The
Tab Level: 1
Table 70: Business Partner - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | c_bpartner_product.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | c_bpartner_product.AD_Org_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | c_bpartner_product.M_Product_ID numeric(10) Search |
| Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | c_bpartner_product.C_BPartner_ID numeric(10) Search |
| Description | Optional short description of the record | A description is limited to 255 characters. | c_bpartner_product.Description character varying(255) String |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | c_bpartner_product.IsActive character(1) Yes-No |
| Partner Product Key | Product Key of the Business Partner | The Business Partner Product Key identifies the number used by the Business Partner for this product. It can be printed on orders and invoices when you include the Product Key in the print format. | c_bpartner_product.VendorProductNo character varying(30) String |
| Partner Category | Product Category of the Business Partner | The Business Partner Category identifies the category used by the Business Partner for this product. | c_bpartner_product.VendorCategory character varying(30) String |
| Manufacturer | Manufacturer of the Product | The manufacturer of the Product (used if different from the Business Partner / Vendor) | c_bpartner_product.Manufacturer character varying(30) String |
| Quality Rating | Method for rating vendors | The Quality Rating indicates how a vendor is rated (higher number = higher quality) | c_bpartner_product.QualityRating numeric Number |
| Min Shelf Life % | Minimum Shelf Life in percent based on Product Instance Guarantee Date | Minimum 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 minimum shelf life, unless you select "Show All" | c_bpartner_product.ShelfLifeMinPct numeric(10) Integer |
| Min Shelf Life Days | Minimum Shelf Life in days based on Product Instance Guarantee Date | Minimum Shelf Life of products with Guarantee Date instance. If > 0 you cannot select products with a shelf life less than the minimum shelf life, unless you select "Show All" | c_bpartner_product.ShelfLifeMinDays numeric(10) Integer |
| Is Manufacturer | Indicate role of this Business partner as Manufacturer | c_bpartner_product.IsManufacturer character(1) Yes-No |
Tab: Price
[Created: 09/08/1999 - Updated: 02/01/2000 ]
Description: Product Pricing
Help: The Pricing Tab displays the List, Standard and Limit prices for each price list a product is contained in.
Tab Level: 1
Table 90: Price - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_productprice.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_productprice.AD_Org_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | m_productprice.M_Product_ID numeric(10) Search |
| Price List Version | Identifies a unique instance of a Price List | Each Price List can have multiple versions. The most common use is to indicate the dates that a Price List is valid for. | m_productprice.M_PriceList_Version_ID numeric(10) Table Direct |
| 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. | m_productprice.IsActive character(1) Yes-No |
| List Price | List Price | The List Price is the official List Price in the document currency. | m_productprice.PriceList numeric Costs+Prices |
| Standard Price | Standard Price | The Standard Price indicates the standard or normal price for a product on this price list | m_productprice.PriceStd numeric Costs+Prices |
| Limit Price | Lowest price for a product | The Price Limit indicates the lowest price for a product stated in the Price List Currency. | m_productprice.PriceLimit numeric Costs+Prices |
Tab: Accounting
[Created: 26/09/1999 - Updated: 05/03/2013 ]
Description: Define Accounting Parameters
Help: The Accounting Tab defines the defaults to use when generating accounting transactions for orders and invoices which contain this product.
Tab Level: 1
Table 100: Accounting - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_product_acct.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_product_acct.AD_Org_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | m_product_acct.M_Product_ID numeric(10) Search |
| Accounting Schema | Rules for accounting | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | m_product_acct.C_AcctSchema_ID numeric(10) Table Direct |
| 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. | m_product_acct.IsActive character(1) Yes-No |
| Product Asset | Account for Product Asset (Inventory) | The Product Asset Account indicates the account used for valuing this a product in inventory. | m_product_acct.P_Asset_Acct numeric(10) Account |
| Product Expense | Account for Product Expense | The Product Expense Account indicates the account used to record expenses associated with this product. | m_product_acct.P_Expense_Acct numeric(10) Account |
| Cost Adjustment | Product Cost Adjustment Account | Account used for posting product cost adjustments (e.g. landed costs) | m_product_acct.P_CostAdjustment_Acct numeric(10) Account |
| 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. | m_product_acct.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. | m_product_acct.P_COGS_Acct numeric(10) Account |
| Product Revenue | Account for Product Revenue (Sales Account) | The Product Revenue Account indicates the account used for recording sales revenue for this product. | m_product_acct.P_Revenue_Acct numeric(10) Account |
| Purchase Price Variance | Difference between Standard Cost and Purchase Price (PPV) | The Purchase Price Variance is used in Standard Costing. It reflects the difference between the Standard Cost and the Purchase Order Price. | m_product_acct.P_PurchasePriceVariance_Acct numeric(10) Account |
| Invoice Price Variance | Difference between Costs and Invoice Price (IPV) | The Invoice Price Variance is used reflects the difference between the current Costs and the Invoice Price. | m_product_acct.P_InvoicePriceVariance_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 | m_product_acct.P_TradeDiscountRec_Acct numeric(10) Account |
| Trade Discount Granted | Trade Discount Granted Account | The Trade Discount Granted Account indicates the account for granted trade discount in sales invoices | m_product_acct.P_TradeDiscountGrant_Acct numeric(10) Account |
| 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. | m_product_acct.P_RateVariance_Acct numeric(10) Account |
| 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. | m_product_acct.P_AverageCostVariance_Acct numeric(10) Account |
| Landed Cost Clearing | Product Landed Cost Clearing Account | Account used for posting of estimated and actual landed cost amount. The balance on the clearing account should be zero and accounts for the timing difference between material receipt and landed cost invoice. | m_product_acct.P_LandedCostClearing_Acct numeric(10) Account |
Tab: Transactions
[Created: 17/05/2000 - Updated: 02/01/2000 ]
Description: Transactions for stored Products
Help: The Transaction Tab displays the transactions that have been processed for this product.
Tab Level: 1
Table 110: Transactions - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_transaction.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_transaction.AD_Org_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | m_transaction.M_Product_ID numeric(10) Search |
| Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | m_transaction.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| 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. | m_transaction.IsActive character(1) Yes-No |
| Locator | Warehouse Locator | The Locator indicates where in a Warehouse a product is located. | m_transaction.M_Locator_ID numeric(10) Locator (WH) |
| Movement Quantity | Quantity of a product moved. | The Movement Quantity indicates the quantity of a product that has been moved. | m_transaction.MovementQty numeric 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. | m_transaction.MovementDate timestamp without time zone Date |
| Movement Type | Method of moving the inventory | The Movement Type indicates the type of movement (in, out, to production, etc) | m_transaction.MovementType character(2) List |
| Shipment/Receipt Line | Line on Shipment or Receipt document | The Shipment/Receipt Line indicates a unique line in a Shipment/Receipt document | m_transaction.M_InOutLine_ID numeric(10) Search |
| Phys.Inventory Line | Unique line in an Inventory document | The Physical Inventory Line indicates the inventory document line (if applicable) for this transaction | m_transaction.M_InventoryLine_ID numeric(10) Search |
| Move Line | Inventory Move document Line | The Movement Line indicates the inventory movement document line (if applicable) for this transaction | m_transaction.M_MovementLine_ID numeric(10) Search |
| Production Line | Document Line representing a production | The Production Line indicates the production document line (if applicable) for this transaction | m_transaction.M_ProductionLine_ID numeric(10) Search |
| Project Issue | Project Issues (Material, Labor) | Issues to the project initiated by the "Issue to Project" process. You can issue Receipts, Time and Expenses, or Stock. | m_transaction.C_ProjectIssue_ID numeric(10) Search |
| Manufacturing Cost Collector | m_transaction.PP_Cost_Collector_ID numeric(10) Search |
Tab: Translation
[Created: 04/12/1999 - Updated: 27/10/2024 ]
Description:
Help:
Tab Level: 1
Table 120: Translation - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_product_trl.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_product_trl.AD_Org_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | m_product_trl.M_Product_ID numeric(10) Search |
| Language | Language for this entity | The Language identifies the language to use for display and formatting | m_product_trl.AD_Language character varying(6) 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. | m_product_trl.Name character varying(255) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | m_product_trl.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. | m_product_trl.DocumentNote character varying(2000) String |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | m_product_trl.IsActive character(1) Yes-No |
| Translated | This column is translated | The Translated checkbox indicates if this column is translated. | m_product_trl.IsTranslated character(1) Yes-No |
Tab: Located at
[Created: 28/08/2009 - Updated: 19/11/2012 ]
Description: Where are my units located?
Help:
Tab Level: 1
Table 130: Located at - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_storage.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_storage.AD_Org_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | m_storage.M_Product_ID numeric(10) Search |
| Date Material Policy | Time used for LIFO and FIFO Material Policy | This field is used to record time used for LIFO and FIFO material policy | m_storage.DateMaterialPolicy timestamp without time zone Date |
| Locator | Warehouse Locator | The Locator indicates where in a Warehouse a product is located. | m_storage.M_Locator_ID numeric(10) Locator (WH) |
| Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | m_storage.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| 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. | m_storage.IsActive character(1) Yes-No |
| On Hand Quantity | On Hand Quantity | The On Hand Quantity indicates the quantity of a product that is on hand in a warehouse. | m_storage.QtyOnHand numeric Quantity |
| Date Last Inventory Count | Date of Last Inventory Count | The Date Last Inventory Count indicates the last time an Inventory count was done. | m_storage.DateLastInventory timestamp without time zone Date |
| Ordered Quantity | Ordered Quantity | The Ordered Quantity indicates the quantity of a product that was ordered. | m_storage.QtyOrdered numeric Quantity |
| Reserved Quantity | Reserved Quantity | The Reserved Quantity indicates the quantity of a product that is currently reserved. | m_storage.QtyReserved numeric Quantity |
Tab: UOM Conversion
[Created: 29/08/2009 - Updated: 29/08/2009 ]
Description:
Help:
Tab Level: 1
Table 140: UOM Conversion - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | c_uom_conversion.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | c_uom_conversion.AD_Org_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | c_uom_conversion.M_Product_ID numeric(10) Search |
| 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. | c_uom_conversion.IsActive character(1) Yes-No |
| UOM | Unit of Measure | The UOM defines a unique non monetary Unit of Measure | c_uom_conversion.C_UOM_ID numeric(10) Table Direct |
| UoM To | Target or destination Unit of Measure | The UOM To indicates the destination UOM for a UOM Conversion pair. | c_uom_conversion.C_UOM_To_ID numeric(10) 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. | c_uom_conversion.MultiplyRate numeric 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. | c_uom_conversion.DivideRate numeric Number |
Tab: Costs
[Created: 02/12/2009 - Updated: 02/12/2009 ]
Description:
Help:
Tab Level: 1
Table 150: Costs - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_cost.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_cost.AD_Org_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | m_cost.M_Product_ID numeric(10) Search |
| Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | m_cost.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| Accounting Schema | Rules for accounting | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | m_cost.C_AcctSchema_ID numeric(10) Table Direct |
| Cost Type | Type of Cost (e.g. Current, Plan, Future) | You can define multiple cost types. A cost type selected in an Accounting Schema is used for accounting. | m_cost.M_CostType_ID numeric(10) Table Direct |
| Cost Element | Product Cost Element | m_cost.M_CostElement_ID numeric(10) Table Direct | |
| Description | Optional short description of the record | A description is limited to 255 characters. | m_cost.Description character varying(255) Text |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | m_cost.IsActive character(1) Yes-No |
| Current Cost Price | The currently used cost price | m_cost.CurrentCostPrice numeric Costs+Prices | |
| 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. | m_cost.CurrentCostPriceLL numeric Costs+Prices |
| Future Cost Price | m_cost.FutureCostPrice numeric Costs+Prices | ||
| Future Cost Price Lower Level | m_cost.FutureCostPriceLL numeric Costs+Prices | ||
| Percent | Percentage | The Percent indicates the percentage used. | m_cost.Percent numeric(10) Integer |
| Current Quantity | Current Quantity | m_cost.CurrentQty numeric Quantity | |
| Cost Frozen | Indicated that the Standard Cost is frozen | m_cost.IsCostFrozen character(1) Yes-No | |
| Accumulated Amt | Total Amount | Sum of all amounts | m_cost.CumulatedAmt numeric Amount |
| Accumulated Qty | Total Quantity | Sum of the quantities | m_cost.CumulatedQty numeric Quantity |
Tab: Reserved Quantity Log
[Created: 01/11/2021 - Updated: 01/11/2021 ]
Description:
Help:
Tab Level: 1
Table 160: Reserved Quantity Log - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_storagereservationlog.AD_Client_ID numeric(10) Search |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_storagereservationlog.AD_Org_ID numeric(10) Table Direct |
| Warehouse | Storage Warehouse and Service Point | The Warehouse identifies a unique Warehouse where products are stored or Services are provided. | m_storagereservationlog.M_Warehouse_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | m_storagereservationlog.M_Product_ID numeric(10) Search |
| Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | m_storagereservationlog.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| Document Type | Document type or rules | The Document Type determines document sequence and processing rules | m_storagereservationlog.C_DocType_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_", where TableName is the actual name of the table (e.g. C_Order). | m_storagereservationlog.DocumentNo character varying(255) String |
| Line | Line No | m_storagereservationlog.LineNo numeric(10) Integer | |
| Table | Database Table information | The Database Table provides the information of the table definition | m_storagereservationlog.AD_Table_ID numeric(10) Table Direct |
| Record ID | Direct internal record ID | The Record ID is the internal unique identifier of a record. Please note that zooming to the record may not be successful for Orders, Invoices and Shipment/Receipts as sometimes the Sales Order type is not known. | m_storagereservationlog.Record_ID numeric(10) Record ID |
| Old Current Quantity | Old current quantity before the processing of M_CostDetail | m_storagereservationlog.OldQty numeric Quantity | |
| Delta Quantity | Quantity Difference | m_storagereservationlog.DeltaQty numeric Quantity | |
| New Current Quantity | New current quantity after processing of M_CostDetail | m_storagereservationlog.NewQty numeric Quantity | |
| Created | Date this record was created | The Created field indicates the date that this record was created. | m_storagereservationlog.Created timestamp without time zone Date+Time |
Tab: Ordered Quantity Log
[Created: 01/11/2021 - Updated: 01/11/2021 ]
Description:
Help:
Tab Level: 1
Table 170: Ordered Quantity Log - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | m_storagereservationlog.AD_Client_ID numeric(10) Search |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | m_storagereservationlog.AD_Org_ID numeric(10) Table Direct |
| Warehouse | Storage Warehouse and Service Point | The Warehouse identifies a unique Warehouse where products are stored or Services are provided. | m_storagereservationlog.M_Warehouse_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | m_storagereservationlog.M_Product_ID numeric(10) Search |
| Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | m_storagereservationlog.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| Document Type | Document type or rules | The Document Type determines document sequence and processing rules | m_storagereservationlog.C_DocType_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_", where TableName is the actual name of the table (e.g. C_Order). | m_storagereservationlog.DocumentNo character varying(255) String |
| Line | Line No | m_storagereservationlog.LineNo numeric(10) Integer | |
| Table | Database Table information | The Database Table provides the information of the table definition | m_storagereservationlog.AD_Table_ID numeric(10) Table Direct |
| Record ID | Direct internal record ID | The Record ID is the internal unique identifier of a record. Please note that zooming to the record may not be successful for Orders, Invoices and Shipment/Receipts as sometimes the Sales Order type is not known. | m_storagereservationlog.Record_ID numeric(10) Record ID |
| Old Current Quantity | Old current quantity before the processing of M_CostDetail | m_storagereservationlog.OldQty numeric Quantity | |
| Delta Quantity | Quantity Difference | m_storagereservationlog.DeltaQty numeric Quantity | |
| New Current Quantity | New current quantity after processing of M_CostDetail | m_storagereservationlog.NewQty numeric Quantity | |
| Created | Date this record was created | The Created field indicates the date that this record was created. | m_storagereservationlog.Created timestamp without time zone Date+Time |