Table idempiere9.adempiere.m_product
Product Service Item

Generated by
Quality Systems & Solutions
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
m_product_id numeric 10
c_invoiceline.m_product_id mproduct_cinvoiceline R
c_orderline.m_product_id mproduct_corderline R
c_servicelevel.m_product_id mproduct_cservicelevel R
s_timeexpenseline.m_product_id mproduct_stimeexpenseline R
Product, Service, Item
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
value varchar 40 Search key for the record in the format required - must be unique
name varchar 255 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
documentnote varchar 2000  √  null Additional information for a Document
help varchar 2000  √  null Comment or Hint
upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
sku varchar 30  √  null Stock Keeping Unit
c_uom_id numeric 10
c_uom.c_uom_id cuom_mproduct R
Unit of Measure
salesrep_id numeric 10  √  null Sales Representative or Company Agent
issummary bpchar 1 'N'::bpchar This is a summary entity
isstocked bpchar 1 'Y'::bpchar Organization stocks this product
ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
issold bpchar 1 'Y'::bpchar Organization sells this product
isbom bpchar 1 'N'::bpchar Bill of Materials
isinvoiceprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the invoice
ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
isverified bpchar 1 'N'::bpchar The BOM configuration has been verified
c_revenuerecognition_id numeric 10  √  null Method for recording revenue
m_product_category_id numeric 10
m_product_category.m_product_category_id mproduct_mproductcategory R
Category of a Product
classification varchar 12  √  null Classification for grouping
volume numeric 0  √  0 Volume of a product
weight numeric 0  √  0 Weight of a product
shelfwidth numeric 10  √  null Shelf width required
shelfheight numeric 0  √  null Shelf height required
shelfdepth numeric 10  √  null Shelf depth required
unitsperpallet numeric 0  √  null Units Per Pallet
c_taxcategory_id numeric 10
c_taxcategory.c_taxcategory_id ctaxcategory_mproduct R
Tax Category
s_resource_id numeric 10  √  null
s_resource.s_resource_id sresource_mproduct R
discontinued bpchar 1  √  'N'::bpchar This product is no longer available
discontinuedby timestamp 29,6  √  null
processing bpchar 1  √  null Process Now
s_expensetype_id numeric 10  √  null
s_expensetype.s_expensetype_id sexpensetype_mproduct R
Expense report type
producttype bpchar 1 'I'::bpchar Type of product
imageurl varchar 120  √  null URL of image
descriptionurl varchar 120  √  null URL for the description
guaranteedays numeric 10  √  null Number of days the product is guaranteed or available
r_mailtext_id numeric 10  √  null Text templates for mailings
versionno varchar 20  √  null Version Number
m_attributeset_id numeric 10  √  null Product Attribute Set
m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
downloadurl varchar 120  √  null
m_freightcategory_id numeric 10  √  null Category of the Freight
m_locator_id numeric 10  √  null Warehouse Locator
guaranteedaysmin numeric 10  √  null Minimum number of guarantee days
iswebstorefeatured bpchar 1 'N'::bpchar If selected, the product is displayed in the initial or any empty search
isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
c_subscriptiontype_id numeric 10  √  null Type of subscription
isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
group1 varchar 255  √  null Group1
group2 varchar 255  √  null Group2
istoformule bpchar 1  √  null
lowlevel numeric 10 (0)::numeric The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
copyfrom bpchar 1  √  NULL::bpchar Copy From Record
m_product_uu varchar 36  √  NULL::character varying M_Product_UU
m_parttype_id numeric 10  √  NULL::numeric Part Type
iskanban bpchar 1 'N'::bpchar This part is Kanban controlled
ismanufactured bpchar 1 'N'::bpchar This product is manufactured
isphantom bpchar 1  √  'N'::bpchar Phantom Component
isownbox bpchar 1 'N'::bpchar Own Box
customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment

Table contained 55 rows at 2021-12-25 14:56 +0100

Column(s) Type Sort Constraint Name
m_product_id Primary key Asc m_product_pkey
s_expensetype_id Must be unique Asc m_product_expensetype
name Performance Asc m_product_name
m_product_category_id Performance Asc m_product_productcategory
s_resource_id Must be unique Asc m_product_resource
upc Performance Asc m_product_upc
m_product_uu Must be unique Asc m_product_uu_idx
ad_client_id + value Must be unique Asc/Asc m_product_value

Close relationships  within of separation: