Table idempiere9.adempiere.m_product
Product Service Item

 Generated by
Quality Systems & Solutions
Legend:
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
a_asset.m_product_id mproduct_aasset R
a_asset_addition.m_product_id mproduct_aassetaddition R
a_asset_product.m_product_id mproduct_aassetproduct R
a_registration.m_product_id mproduct_aregistration R
a_registrationproduct.m_product_id mproduct_aregproduct R
ad_clientinfo.m_productfreight_id mproductfreight_adclientinfo R
b_topictype.m_product_id mproduct_btopictype R
b_topictype.m_productmember_id mproduct_btopictypemember R
c_acctschema_element.m_product_id mproduct_caschemaelement R
c_bpartner_product.m_product_id mproduct_cbpproduct C
c_cashplanline.m_product_id mproduct_ccashplanline R
c_commission.m_product_id mproduct_ccommission R
c_commissionline.m_product_id mproduct_ccommissionline R
c_invoiceline.m_product_id mproduct_cinvoiceline R
c_landedcost.m_product_id mproduct_clandedcost R
c_landedcostallocation.m_product_id mproduct_clandedcostalloc R
c_orderline.m_product_id mproduct_corderline R
c_phase.m_product_id mproduct_cphase R
c_poskey.m_product_id mproduct_cposkey R
c_projectissue.m_product_id mproduct_cprojectissue R
c_projectline.m_product_id mproduct_cprojectline R
c_projectphase.m_product_id mproduct_cprojectphase R
c_projecttask.m_product_id mproduct_cprojecttask R
c_rfq_topicsubscriberonly.m_product_id mproduct_crfqtsubonly R
c_rfqline.m_product_id mproduct_crfqline R
c_servicelevel.m_product_id mproduct_cservicelevel R
c_subscription.m_product_id mproduct_csubscription R
c_task.m_product_id mproduct_ctask R
c_taxdefinition.m_product_id mproduct_ctaxdefinition R
c_uom_conversion.m_product_id mproduct_cuomconversion R
c_validcombination.m_product_id mproduct_vc R
dd_orderline.m_product_id mproduct_ddorderline R
fact_acct.m_product_id m_product_fact_acct R
fact_acct_summary.m_product_id mproduct_factacctsummary R
gl_distribution.m_product_id mproduct_gldist R
gl_distributionline.m_product_id mproduct_gldistline R
gl_journalline.m_product_id mproduct_gljournalline R
i_asset.m_product_id mproduct_iasset R
i_fajournal.m_product_id mproduct_ifajournal R
i_fixedasset.m_product_id mproduct_ifixedasset R
i_gljournal.m_product_id mproduct_ogljournal N
i_inventory.m_product_id mproduct_iinventory N
i_invoice.m_product_id nproduct_iinvoice N
i_movement.m_product_id mproduct_imovement R
i_order.m_product_id mproduct_iorder N
i_pricelist.m_product_id mproduct_ipricelist R
i_product.m_product_id mproduct_iproduct N
i_productplanning.m_product_id mproduct_iproductplanning R
m_bom.m_product_id mproduct_mbom C
m_bomalternative.m_product_id mproduct_mbomalternative C
m_bomproduct.m_productbom_id mproduct_mbomproduct R
m_bp_price.m_product_id mproduct_mbpprice R
m_commodityshipment.m_product_id mproduct_mcommodityshipment R
m_cost.m_product_id mproduct_mcost R
m_costdetail.m_product_id mproduct_mcostdetail R
m_costqueue.m_product_id mproduct_mcostqueue R
m_demandline.m_product_id mproduct_mdemandline C
m_discountschemabreak.m_product_id mproduct_mdiscountsbreak R
m_discountschemaline.m_product_id mproduct_mdiscountsline N
m_distributionrunline.m_product_id mproduct_mdistributionrun R
m_edi.m_product_id mproduct_medi R
m_forecastline.m_product_id mproduct_mforecastline C
m_inoutline.m_product_id mproduct_minoutline R
m_inventoryline.m_product_id mproduct_minventoryline R
m_lot.m_product_id mproduct_mlot R
m_matchinv.m_product_id mproduct_mmatchinv R
m_matchpo.m_product_id mproduct_mmatchpo R
m_movementline.m_product_id mproduct_mmovementline R
m_packageline.m_product_id mproduct_mpackageline R
m_product_acct.m_product_id m_product_m_product_acct C
m_product_bom_old.m_product_id mproduct_mproductbom C
m_product_bom_old.m_productbom_id mproduct_bomproduct R
m_product_po.m_product_id m_product_productpo C
m_product_qualitytest.m_product_id mproduct_mproductqualitytest R
m_product_trl.m_product_id mproduct_mproducttrl C
m_productdownload.m_product_id mproduct_mproductdownload R
m_production.m_product_id mproduct_mproduction R
m_productionline.m_product_id mproduct_mproductionline R
m_productionplan.m_product_id mproduct_mproductionplan R
m_productoperation.m_product_id mproduct_mproductoperation C
m_productprice.m_product_id mproduct_mproductprice C
m_productpricevendorbreak.m_product_id mproduct_mproductpricevendorbr R
m_promotiongroupline.m_product_id mproduct_mpromotiongroupline R
m_relatedproduct.m_product_id mproduct_mrelated_product C
m_relatedproduct.relatedproduct_id mproduct_mrelatedproduct C
m_replenish.m_product_id m_product_replenish C
m_requisitionline.m_product_id mproduct_mrequisitionline R
m_rmaline.m_product_id mproduct_mrmaline R
m_storageonhand.m_product_id mproduct_mstorageonhand R
m_storagereservation.m_product_id mproduct_mstoragereservation R
m_storagereservationlog.m_product_id mproduct_mstoragereservationlo R
m_substitute.m_product_id mproduct_substitute C
m_substitute.substitute_id mproduct_substitutesub C
m_transaction.m_product_id mproduct_minventorycount R
m_transactionallocation.m_product_id mproduct_mtrxalloc R
pa_goalrestriction.m_product_id mproduct_pagoalrestriction R
pa_reportcolumn.m_product_id mproduct_pareportcolumn R
pa_reportsource.m_product_id mproduct_pareportsource R
pp_cost_collector.m_product_id mproduct_ppcostcollector R
pp_mrp.m_product_id mproduct_ppmrp R
pp_order.m_product_id mproduct_pporder R
pp_order_bom.m_product_id mproduct_pporderbom R
pp_order_bomline.m_product_id mproduct_pporderbomline R
pp_order_cost.m_product_id mproduct_ppordercost R
pp_order_node_product.m_product_id mproduct_ppordernodeproduct R
pp_product_bom.m_product_id mproduct_ppproductbom R
pp_product_bomline.m_product_id mproduct_ppproductbomline R
pp_product_planning.m_product_id mproduct_ppproductplanning R
pp_wf_node_product.m_product_id mproduct_ppwfnodeproduct R
qm_specification.m_product_id mproduct_qmspecification R
r_category.m_product_id mproduct_rcategory R
r_request.m_product_id mproduct_rrequest R
r_request.m_productspent_id mproductspent_rrequest R
r_requestaction.m_product_id mproduct_rrequestaction R
r_requestaction.m_productspent_id mproductspent_rrequestaction R
r_requestupdate.m_productspent_id mproductspent_rrequestupdate R
s_timeexpenseline.m_product_id mproduct_stimeexpenseline R
s_training_class.m_product_id mproduct_strainingclass R
t_distributionrundetail.m_product_id mproduct_tdrdetail C
t_inventoryvalue.m_product_id mproduct_tinventoryvalue C
t_replenish.m_product_id mproduct_treplenish C
t_transaction.m_product_id mproduct_ttransaction C
w_basketline.m_product_id mproduct_wbasketline R
Product, Service, Item
ad_client_id numeric 10
ad_client.ad_client_id adclient_mproduct R
Client/Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id ad_org_mproduct R
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
ad_user.ad_user_id salesrep_mproduct R
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
c_revenuerecognition.c_revenuerecognition_id crevrecognition_mproduct R
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
Resource
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
r_mailtext.r_mailtext_id rmailtext_mproduct R
Text templates for mailings
versionno varchar 20  √  null Version Number
m_attributeset_id numeric 10  √  null
m_attributeset.m_attributeset_id mattributeset_mproduct C
Product Attribute Set
m_attributesetinstance_id numeric 10  √  0
m_attributesetinstance.m_attributesetinstance_id mattrsetinst_mproduct R
Product Attribute Set Instance
downloadurl varchar 120  √  null
m_freightcategory_id numeric 10  √  null
m_freightcategory.m_freightcategory_id mfreightcategory_mproduct R
Category of the Freight
m_locator_id numeric 10  √  null
m_locator.m_locator_id mlocator_mproduct R
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
c_subscriptiontype.c_subscriptiontype_id csubscriptiontype_mproduct R
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
m_parttype.m_parttype_id mparttype_mproduct R
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:43 +0100

Indexes:
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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.