iDempiere Product Master
1. Introduction
The Product Master manages all product-related data in iDempiere. It is the foundation for sales, purchases, inventory, costing, and reporting.
2. Navigation
Menu → Material Management and Pricing → Product
The Product Master window contains multiple tabs, each offering distinct functionalities.
Let’s explore them in the following order:
Window Name: Product(AD_Window_ID =140)
3. Tabs and Field Descriptions
3.1 Product Tab
The Product tab is used to define each product and make it available for use in price lists and transactions.
Note: The Location field indicates the default storage location where the product will be received.
Tab name: Product(AD_Tab_ID=180)
Table Name: M_Product(AD_Table_ID=208)
| Field Name | Description | Column Name DataType Reference Type AD_Column_ID |
| Tenant | The client or business entity using the system | * AD_Client_ID * numeric(10) * Table Direct * 1403 |
| Organization | The specific organization or store location | * AD_Org_ID * numeric(10) * Table Direct * 1404 |
| Search Key | Unique internal product identifier (often used as SKU) | * Value * character varying(510) * String * 2011 |
| Version No | Version of the product, for variations or revisions | * VersionNo * character varying(20) * String * 7973 |
| Name | The name of the product | * Name * character varying(255) * String * 1410 |
| Description | A short description of the product | * Description * character varying(255) * String * 1411 |
| Comment/Help | Internal comment or hint | * Help * character varying(2000) * Text * 3015 |
| Document Note | Notes shown on documents like invoices | * DocumentNote * character varying(2000) * Text * 3014 |
| UPC/EAN | Universal/EAN barcode number | * UPC * character varying(30) * String * 2304 |
| SKU | Alternate product code (may match Search Key) | * SKU * character varying(30) * String * 2305 |
| Active | If false, product is inactive and excluded from use | * IsActive * character(1) * Yes-No * 1405 |
| Summary Level | If checked, it’s a non-transactional grouping product | * IsSummary * character(1) * Yes-No * 1413 |
| Product Category | Logical grouping for price lists, reports | * M_Product_Category_ID * numeric(10) * Table Direct * 2012 |
| Classification | Additional internal categorization (e.g., brand, range) | * Classification * character varying(12) * String * 3016 |
| Tax Category | Defines which tax rules apply | * C_TaxCategory_ID * numeric(10) * Table Direct * 2019 |
| Revenue Recognition | Determines how revenue is deferred or recognized | * C_RevenueRecognition_ID * numeric(10) * Table Direct * 3909 |
| UOM | Unit of Measure (e.g., pieces, kg, liters) | * C_UOM_ID * numeric(10) * Table Direct * 1760 |
| Sales Representative | Salesperson associated with this product | * SalesRep_ID * numeric(10) * Table * 3391 |
| Product Type | Type: Item, Service, Resource, Expense | * ProductType * character(1) * List * 7795 |
| Mail Template | Default email template used for this product | * R_MailText_ID * numeric(10) * Table Direct * 7972 |
| Weight | Weight of one unit (used in logistics/shipping) | * Weight * numeric * Amount * 1767 |
| Volume | Volume of one unit | * Volume * numeric * Amount * 1766 |
| Own Box | If checked, product requires its own box for shipping | * IsOwnBox * character(1) * Yes-No * 201242 |
| Customs Tariff Number | Code used in customs declaration | * CustomsTariffNumber * character varying(20) * String * 214343 |
| Freight Category | Used to group freight calculation types | * M_FreightCategory_ID * numeric(10) * Table Direct * 9329 |
| Drop Shipment | Ships directly from vendor to customer | * IsDropShip * character(1) * Yes-No * 12147 |
| Stocked | If checked, product is stocked and inventoried | * IsStocked * character(1) * Yes-No * 1761 |
| Manufactured | Indicates whether the product is manufactured in-house | * IsManufactured * character(1) * Yes-No * 61997 |
| Phantom | Used in BOM – not stocked, but part of structure | * IsPhantom * character(1) * Yes-No * 200242 |
| Kanban controlled | Enables Kanban-based replenishment | * IsKanban * character(1) * Yes-No * 61996 |
| Part Type | Further classification of part role | * M_PartType_ID * numeric(10) * Table Direct * 61995 |
| Locator | Default bin/location in warehouse | * M_Locator_ID * numeric(10) * Locator (WH) * 9420 |
| Shelf Width | Width of product on shelf | * ShelfWidth * numeric(10) * Integer * 2307 |
| Shelf Height | Height of product on shelf | * ShelfHeight * numeric * Amount * 2308 |
| Shelf Depth | Depth of product on shelf | * ShelfDepth * numeric(10) * Integer * 2309 |
| Units Per Pallet | Total units that can be stacked per pallet | * UnitsPerPallet * numeric * Costs+Prices * 2310 |
| Bill of Materials | Indicates whether the product has a BOM | * IsBOM * character(1) * Yes-No * 4708 |
| Verified | If true, product details have been verified | * IsVerified * character(1) * Yes-No * 4711 |
| Verify BOM Structure | Process flag to check and validate BOM structure | * Processing * character(1) * Button * 4712 |
| Auto Produce | Product will be auto-generated during production | * IsAutoProduce * character(1) * Yes-No * 214618 |
| Print detail records on invoice | Shows individual BOM items on invoice | * IsInvoicePrintDetails * character(1) * Yes-No * 4709 |
| Print detail records on pick list | Shows individual BOM items on pick list | * IsPickListPrintDetails * character(1) * Yes-No * 4710 |
| Purchased | Indicates if product is procured externally | * IsPurchased * character(1) * Yes-No * 1762 |
| Sold | Indicates if product is available for sale | * IsSold * character(1) * Yes-No * 1763 |
| Discontinued | Marks the product as no longer available | * Discontinued * character(1) * Yes-No * 2703 |
| Discontinued At | Date on which the product was discontinued | * DiscontinuedAt * timestamp without time zone * Date * 2704 |
| Expense Type | Associated expense category | * S_ExpenseType_ID * numeric(10) * Table Direct * 6771 |
| Resource | Linked resource (machine, person, etc.) | * S_Resource_ID * numeric(10) * Table Direct * 6773 |
| Exclude Auto Delivery | Prevents product from being delivered in auto-generated shipments | * IsExcludeAutoDelivery * character(1) * Yes-No * 14505 |
| Subscription Type | Specifies type of subscription billing | * C_SubscriptionType_ID * numeric(10) * Table Direct * 10919 |
| Image URL | Web URL to product image | * ImageURL * character varying(120) * URL * 7962 |
| Description URL | Web URL to more product information | * DescriptionURL * character varying(120) * URL * 7963 |
| Guarantee Days | Days the product is under warranty/guarantee | * GuaranteeDays * numeric(10) * Integer * 7974 |
| Min Guarantee Days | Minimum required guarantee duration | * GuaranteeDaysMin * numeric(10) * Integer * 9889 |
| Attribute Set | Group of attributes (e.g., color, size, expiry) | * M_AttributeSet_ID * numeric(10) * Table Direct * 8417 |
| Attribute Set Instance | Actual values for attribute set (per lot/batch) | * M_AttributeSetInstance_ID * numeric(10) * Product Attribute * 8418 |
| Copy from product | Enables copying fields from another product | * CopyFrom * character(1) * Button * 59231 |
| Featured in Web Store | Marks product as a featured item in the online store | * IsWebStoreFeatured * character(1) * Yes-No * 10260 |
| Self-Service | Product is visible in self-service portal | * IsSelfService * character(1) * Yes-No * 10261 |
| Group1 | Custom grouping tag 1 (e.g., Season) | * Group1 * character varying(255) * String * 52061 |
| Group2 | Custom grouping tag 2 (e.g., Gender, Department) | * Group2 * character varying(255) * String * 52062 |