Product (Window ID-140)

From iDempiere en

Table of Contents

Window: Product

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

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.

Product - Product - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Product.AD_Client_ID
numeric(10)
Table Direct
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. 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_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

M_Product.Value
character varying(40)
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 Client M_Product.Weight
numeric
Amount
Volume Volume of a product The Volume indicates the volume of the product in the Volume UOM of the Client M_Product.Volume
numeric
Amount
Own Box M_Product.IsOwnBox
character(1)
Yes-No
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 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. 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
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: Bill of Materials

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" 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

Product - Bill of Materials - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Product_BOM.AD_Client_ID
numeric(10)
Table Direct
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. M_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. M_Product_BOM.M_Product_ID
numeric(10)
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. M_Product_BOM.Line
numeric(10)
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_BOM.IsActive
character(1)
Yes-No
Description Optional short description of the record A description is limited to 255 characters. M_Product_BOM.Description
character varying(255)
String
BOM Type Type of BOM The type of Bills of Materials determines the state M_Product_BOM.BOMType
character(1)
List
BOM Product Bill of Material Component Product The BOM Product identifies an element that is part of this Bill of Materials. M_Product_BOM.M_ProductBOM_ID
numeric(10)
Search
BOM Quantity Bill of Materials Quantity The BOM Quantity indicates the quantity of the product in its Unit of Measure (multiplication) M_Product_BOM.BOMQty
numeric
Quantity

Tab: Substitute

Description: Define Substitute

Help: The Substitute Tab defines products which may be used as a replacement for the selected product.

Product - Substitute - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Substitute.AD_Client_ID
numeric(10)
Table Direct
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. 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

Description: Related Product

Help: Related Product - e.g. for promotions

Product - Related - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_RelatedProduct.AD_Client_ID
numeric(10)
Table Direct
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. 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

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.

Product - Replenish - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Replenish.AD_Client_ID
numeric(10)
Table Direct
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. 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

Description: Purchasing

Help: The Purchasing Tab define the pricing and rules ( pack quantity, UPC, minimum order quantity) for each product.

Product - Purchasing - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Product_PO.AD_Client_ID
numeric(10)
Table Direct
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. 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

Description: Business Partner specific Information of a Product

Help: Note that some information is for reference only! The

Product - Business Partner - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. C_BPartner_Product.AD_Client_ID
numeric(10)
Table Direct
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. 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

Description: Product Pricing

Help: The Pricing Tab displays the List, Standard and Limit prices for each price list a product is contained in.

Product - Price - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_ProductPrice.AD_Client_ID
numeric(10)
Table Direct
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. 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

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.

Product - Accounting - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Product_Acct.AD_Client_ID
numeric(10)
Table Direct
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. 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

Description: Transactions for stored Products

Help: The Transaction Tab displays the transactions that have been processed for this product.

Product - Transactions - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Transaction.AD_Client_ID
numeric(10)
Table Direct
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. 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

Description:

Help:

Product - Translation - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Product_Trl.AD_Client_ID
numeric(10)
Table Direct
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. 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

Description: Where are my units located?

Help:

Product - Located at - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Storage.AD_Client_ID
numeric(10)
Table Direct
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. 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

Description:

Help:

Product - UOM Conversion - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. C_UOM_Conversion.AD_Client_ID
numeric(10)
Table Direct
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. 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

Description:

Help:

Product - Costs - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. M_Cost.AD_Client_ID
numeric(10)
Table Direct
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. 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


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.