Product
M_Product
Product Service Item
Overview
| Table Name | M_Product |
|---|---|
| Access Level | Client Only |
| Entity Type | D |
| Is Document | No |
| Is View | No |
| Has UUID | Yes |
| Parent Table | AD_PrintLabel |
| Wiki | View on iDempiere Wiki |
Columns (98)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
ABCAnalysisGroup |
List(10) | No | - | Materials management ABC analysis or Selective Inventory Control |
AD_PrintLabel_ID |
Table Direct(22) | No | - | Label Format to print |
C_Contract_BillingMessage_ID |
Search(22) | No | - | - |
CM_Title |
String(255) | No | - | Title for rendered pages |
CommodityCode |
String(20) | No | - | Commodity code used for tax calculation |
CopyFrom |
Button(1) | No | - | Copy From Record |
C_SubscriptionType_ID |
Table Direct(22) | No | - | Type of subscription |
CustomsTariffNumber |
String(20) | No | - | Customs Tariff Number, usually the HS-Code |
DescriptionURL |
URL(120) | No | - | URL for the description |
GlobalSearchTerms |
String(2000) | No | - | - |
GuaranteeDays |
Integer(22) | No | - | Number of days the product is guaranteed or available |
GuaranteeDaysMin |
Integer(22) | No | - | Minumum number of guarantee days |
ImageURL |
URL(240) | No | - | URL of image |
InternalNote |
Text(2000) | No | - | - |
IsAutoProduce |
Yes-No(1) | Yes | N | Auto create production to fulfill shipment |
IsDropShip |
Yes-No(1) | Yes | - | Drop Shipments are sent directly to the Drop Shipment Location |
IsListed |
Yes-No(1) | No | N | - |
IsOwnBox |
Yes-No(1) | Yes | N | - |
IsPhantom |
Yes-No(1) | Yes | N | Phantom Component |
isReturnable |
Yes-No(1) | Yes | Y | Product can be returned |
IsSelfService |
Yes-No(1) | Yes | Y | This is a Self-Service entry or this entry can be changed via Self-Service |
IsWebStoreFeatured |
Yes-No(1) | Yes | - | If selected, the product is displayed in the inital or any empy search |
Length |
Integer(14) | No | - | - |
ListedAt |
Date(7) | No | - | Listed At indicates Date when product was listed |
M_AllocationRule_ID |
Table Direct(10) | No | - | - |
ManufacturerPartNo |
String(20) | No | - | Manufacturer Part No (MPN) of the Manufacturer |
M_AttributeSet_ID |
Table Direct(22) | No | - | Product Attribute Set |
M_AttributeSetInstance_ID |
Product Attribute(22) | Yes | - | Product Attribute Set Instance |
Meta_Description |
Text(2000) | No | - | Meta info describing the contents of the page |
Meta_Keywords |
Text(2000) | No | - | Contains the keywords for the content |
M_FreightCategory_ID |
Table Direct(22) | No | - | Category of the Freight |
M_Locator_ID |
Locator (WH)(22) | No | - | Warehouse Locator |
M_Product_Commodity_ID |
Search(22) | No | - | Combined Nomenclature on the Common Customs Tariff also used in intra-EU trade statistics |
M_Product_Parent_ID |
Search(10) | No | - | Summary Product |
PeriodType |
List(1) | No | - | Period Type |
ProductType |
List(1) | Yes | I | Type of product |
RecordLifeCycle |
List(1) | Yes | N | State of Life Cycle of the Record. |
RenewalSchedule |
List(3) | Yes | NRW | Define renewal scheduling for Contract |
R_MailText_ID |
Table Direct(22) | No | - | Text templates for mailings |
S_ExpenseType_ID |
Table Direct(22) | No | - | Expense report type |
Slug |
String(2000) | No | - | The slug is the user friendly and URL valid name of a record. |
S_Resource_ID |
Table Direct(22) | No | - | Resource |
TrialPeriodQty |
Integer(14) | No | - | Number of Units the product is available in for free. |
TrialPeriodType |
List(1) | No | D | Trial Period Type |
UnitsPerLayer |
Integer(10) | Yes | 1 | Units Per Layer |
UnitsPerPack |
Integer(10) | Yes | 1 | Units Per Pack |
UPC |
String(30) | No | - | Bar Code (Universal Product Code or its superset European Article Number) |
VersionNo |
String(20) | No | - | Version Number |
Value |
String(510) | Yes | - | Search key for the record in the format required - must be unique |
Name |
String(255) | Yes | - | Alphanumeric identifier of the entity |
Description |
String(255) | No | - | Optional short description of the record |
Group1 |
String(255) | No | - | - |
Group2 |
String(255) | No | - | - |
AD_Client_ID |
Table Direct(22) | Yes | @#AD_Client_ID@ | Tenant for this installation. |
AD_Org_ID |
Table Direct(22) | Yes | @#AD_Org_ID@ | Organizational entity within tenant |
ancestors_path |
JSON | No | - | - |
Classification |
String(255) | No | - | Classification for grouping |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
CreatedBy |
Search(22) | Yes | - | User who created this records |
C_RevenueRecognition_ID |
Table Direct(22) | No | - | Method for recording revenue |
C_TaxCategory_ID |
Table Direct(22) | Yes | - | Tax Category |
C_UOM_ID |
Table Direct(22) | Yes | - | Unit of Measure |
Discontinued |
Yes-No(1) | No | - | This product is no longer available |
DiscontinuedAt |
Date(7) | No | - | Discontinued At indicates Date when product was discontinued |
DiscontinuedBy |
Date+Time(29) | No | - | Discontinued By |
DocumentNote |
Text(2000) | No | - | Additional information for a Document |
DownloadURL |
URL(120) | No | - | URL of the Download files |
Help |
Text(10000) | No | - | Comment or Hint |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
IsBOM |
Yes-No(1) | Yes | N | Bill of Materials |
IsExcludeAutoDelivery |
Yes-No(1) | Yes | N | Exclude from automatic Delivery |
IsInvoicePrintDetails |
Yes-No(1) | Yes | - | Print detail BOM elements on the invoice |
IsKanban |
Yes-No(1) | Yes | N | This part is Kanban controlled |
IsManufactured |
Yes-No(1) | Yes | N | This product is manufactured |
IsPickListPrintDetails |
Yes-No(1) | Yes | - | Print detail BOM elements on the pick list |
IsPurchased |
Yes-No(1) | Yes | Y | Organization purchases this product |
IsSold |
Yes-No(1) | Yes | Y | Organization sells this product |
IsStocked |
Yes-No(1) | Yes | Y | Organization stocks this product |
IsSummary |
Yes-No(1) | Yes | - | This is a summary entity |
istoformule |
Yes-No(1) | No | - | - |
IsVerified |
Yes-No(1) | Yes | N | The BOM configuration has been verified |
LowLevel |
Integer(8) | Yes | 0 | The Low Level is used to calculate the material plan and determines if a net requirement should be exploited |
M_PartType_ID |
Table Direct(10) | No | - | - |
M_Product_Category_ID |
Category Tree(22) | Yes | - | Category of a Product |
M_Product_ID |
ID(22) | Yes | - | Product, Service, Item |
M_Product_UU |
String(36) | No | - | - |
Processing |
Button(1) | No | N | - |
SalesRep_ID |
Search(22) | No | - | Sales Representative or Company Agent |
ShelfDepth |
Amount(22) | No | - | Shelf depth required |
ShelfHeight |
Amount(22) | No | - | Shelf height required |
ShelfWidth |
Amount(22) | No | - | Shelf width required |
SKU |
String(30) | No | - | Stock Keeping Unit |
trialperioddays |
Integer(10) | No | - | - |
UnitsPerPallet |
Integer(10) | Yes | 1 | Units Per Pallet |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
Volume |
Amount(22) | No | - | Volume of a product |
Weight |
Amount(22) | No | - | Weight of a product |
Foreign Keys
| Column | References | Description |
|---|---|---|
AD_PrintLabel_ID |
AD_PrintLabel.AD_PrintLabel_ID | Label Format to print |
C_Contract_BillingMessage_ID |
C_Contract_BillingMessage.C_Contract_BillingMessage_ID | - |
C_SubscriptionType_ID |
C_SubscriptionType.C_SubscriptionType_ID | Type of subscription |
M_AllocationRule_ID |
M_AllocationRule.M_AllocationRule_ID | - |
M_AttributeSet_ID |
M_AttributeSet.M_AttributeSet_ID | Product Attribute Set |
M_AttributeSetInstance_ID |
M_AttributeSetInstance.M_AttributeSetInstance_ID | Product Attribute Set Instance |
M_FreightCategory_ID |
M_FreightCategory.M_FreightCategory_ID | Category of the Freight |
M_Locator_ID |
M_Locator.M_Locator_ID | Warehouse Locator |
M_Product_Commodity_ID |
M_Product_Commodity.M_Product_Commodity_ID | Combined Nomenclature on the Common Customs Tariff also used in intra-EU trade statistics |
M_Product_Parent_ID |
M_Product_Parent.M_Product_Parent_ID | Summary Product |
R_MailText_ID |
R_MailText.R_MailText_ID | Text templates for mailings |
S_ExpenseType_ID |
S_ExpenseType.S_ExpenseType_ID | Expense report type |
S_Resource_ID |
S_Resource.S_Resource_ID | Resource |
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
C_RevenueRecognition_ID |
C_RevenueRecognition.C_RevenueRecognition_ID | Method for recording revenue |
C_TaxCategory_ID |
C_TaxCategory.C_TaxCategory_ID | Tax Category |
C_UOM_ID |
C_UOM.C_UOM_ID | Unit of Measure |
M_PartType_ID |
M_PartType.M_PartType_ID | - |
M_Product_Category_ID |
M_Product_Category.M_Product_Category_ID | Category of a Product |
SalesRep_ID |
SalesRep.SalesRep_ID | Sales Representative or Company Agent |
Generated on 2026-05-03T15:25:03.017607762Z