Table erp.COMPIERE.M_PRODUCT

Generated by SchemaSpy

Implied relationships Related columns Constraint names Legend

Legend: Primary key columns Columns with indexes Implied relationships Excluded column relationships Dashed lines show implied relationships < n > number of related tables Please support this project

Column Type Size Nulls Auto Default Children Parents M_PRODUCT_ID number 10 A_ASSET M_PRODUCT_ID MPRODUCT_AASSET A_REGISTRATION M_PRODUCT_ID MPRODUCT_AREGISTRATION A_REGISTRATIONPRODUCT M_PRODUCT_ID MPRODUCT_AREGPRODUCT B_TOPICTYPE M_PRODUCTMEMBER_ID MPRODUCT_BTOPICTYPEMEMBER B_TOPICTYPE M_PRODUCT_ID MPRODUCT_BTOPICTYPE C_ACCTSCHEMA_ELEMENT M_PRODUCT_ID MPRODUCT_CASCHEMAELEMENT C_BPARTNER_PRODUCT M_PRODUCT_ID MPRODUCT_CBPPRODUCT C_COMMISSIONLINE M_PRODUCT_ID MPRODUCT_CCOMMISSIONLINE C_INVOICELINE M_PRODUCT_ID MPRODUCT_CINVOICELINE C_LANDEDCOST M_PRODUCT_ID MPRODUCT_CLANDEDCOST C_LANDEDCOSTALLOCATION M_PRODUCT_ID MPRODUCT_CLANDEDCOSTALLOC C_ORDERLINE M_PRODUCT_ID MPRODUCT_CORDERLINE C_PHASE M_PRODUCT_ID MPRODUCT_CPHASE C_POSKEY M_PRODUCT_ID MPRODUCT_CPOSKEY C_PROJECTISSUE M_PRODUCT_ID MPRODUCT_CPROJECTISSUE C_PROJECTLINE M_PRODUCT_ID MPRODUCT_CPROJECTLINE C_PROJECTPHASE M_PRODUCT_ID MPRODUCT_CPROJECTPHASE C_PROJECTTASK M_PRODUCT_ID MPRODUCT_CPROJECTTASK C_PROJECT_DETAILS_V M_PRODUCT_ID Implied Constraint C_PROJECT_DETAILS_VT M_PRODUCT_ID Implied Constraint C_RFQLINE M_PRODUCT_ID MPRODUCT_CRFQLINE C_RFQ_TOPICSUBSCRIBERONLY M_PRODUCT_ID MPRODUCT_CRFQTSUBONLY C_SERVICELEVEL M_PRODUCT_ID MPRODUCT_CSERVICELEVEL C_SUBSCRIPTION M_PRODUCT_ID MPRODUCT_CSUBSCRIPTION C_TASK M_PRODUCT_ID MPRODUCT_CTASK C_UOM_CONVERSION M_PRODUCT_ID Implied Constraint C_VALIDCOMBINATION M_PRODUCT_ID MPRODUCT_VC FACT_ACCT M_PRODUCT_ID M_PRODUCT_FACT_ACCT FACT_ACCT_BALANCE M_PRODUCT_ID MPRODUCT_FACTACCTBAL GL_DISTRIBUTION M_PRODUCT_ID MPRODUCT_GLDIST GL_DISTRIBUTIONLINE M_PRODUCT_ID MPRODUCT_GLDISTLINE GL_JOURNALLINE_ACCT_V M_PRODUCT_ID Implied Constraint I_GLJOURNAL M_PRODUCT_ID MPRODUCT_OGLJOURNAL I_INVENTORY M_PRODUCT_ID MPRODUCT_IINVENTORY I_INVOICE M_PRODUCT_ID NPRODUCT_IINVOICE I_ORDER M_PRODUCT_ID MPRODUCT_IORDER I_PRODUCT M_PRODUCT_ID MPRODUCT_IPRODUCT M_BOM M_PRODUCT_ID MPRODUCT_MBOM M_BOMALTERNATIVE M_PRODUCT_ID MPRODUCT_MBOMALTERNATIVE M_BOMPRODUCT M_PRODUCTBOM_ID MPRODUCT_MBOMPRODUCT M_COST M_PRODUCT_ID MPRODUCT_MCOST M_COSTDETAIL M_PRODUCT_ID MPRODUCT_MCOSTDETAIL M_COSTQUEUE M_PRODUCT_ID MPRODUCT_MCOSTQUEUE M_DEMANDLINE M_PRODUCT_ID MPRODUCT_MDEMANDLINE M_DISCOUNTSCHEMABREAK M_PRODUCT_ID MPRODUCT_MDISCOUNTSBREAK M_DISCOUNTSCHEMALINE M_PRODUCT_ID MPRODUCT_MDISCOUNTSLINE M_DISTRIBUTIONRUNLINE M_PRODUCT_ID MPRODUCT_MDISTRIBUTIONRUN M_EDI M_PRODUCT_ID MPRODUCT_MEDI M_FORECASTLINE M_PRODUCT_ID MPRODUCT_MFORECASTLINE M_INOUTLINE M_PRODUCT_ID MPRODUCT_MINOUTLINE M_INOUTLINEMA_V M_PRODUCT_ID Implied Constraint M_INOUTLINEMA_VT M_PRODUCT_ID Implied Constraint M_INVENTORYLINE M_PRODUCT_ID MPRODUCT_MINVENTORYLINE M_LOT M_PRODUCT_ID MPRODUCT_MLOT M_MATCHINV M_PRODUCT_ID MPRODUCT_MMATCHINV M_MATCHPO M_PRODUCT_ID MPRODUCT_MMATCHPO M_MOVEMENTLINE M_PRODUCT_ID MPRODUCT_MMOVEMENTLINE M_MOVEMENTLINEMA_V M_PRODUCT_ID Implied Constraint M_MOVEMENTLINEMA_VT M_PRODUCT_ID Implied Constraint M_PRODUCTDOWNLOAD M_PRODUCT_ID MPRODUCT_MPRODUCTDOWNLOAD M_PRODUCTIONLINE M_PRODUCT_ID MPRODUCT_MPRODUCTIONLINE M_PRODUCTIONPLAN M_PRODUCT_ID MPRODUCT_MPRODUCTIONPLAN M_PRODUCTOPERATION M_PRODUCT_ID MPRODUCT_MPRODUCTOPERATION M_PRODUCTPRICE M_PRODUCT_ID MPRODUCT_MPRODUCTPRICE M_PRODUCT_ACCT M_PRODUCT_ID M_PRODUCT_M_PRODUCT_ACCT M_PRODUCT_BOM M_PRODUCTBOM_ID MPRODUCT_BOMPRODUCT M_PRODUCT_BOM M_PRODUCT_ID MPRODUCT_MPRODUCTBOM M_PRODUCT_COSTING M_PRODUCT_ID MPRODUCT_MPRODUCTCOSTING M_PRODUCT_PO M_PRODUCT_ID M_PRODUCT_PRODUCTPO M_PRODUCT_TRL M_PRODUCT_ID MPRODUCT_MPRODUCTTRL M_RELATEDPRODUCT M_PRODUCT_ID MPRODUCT_MRELATED_PRODUCT M_RELATEDPRODUCT RELATEDPRODUCT_ID MPRODUCT_MRELATEDPRODUCT M_REPLENISH M_PRODUCT_ID M_PRODUCT_REPLENISH M_REQUISITIONLINE M_PRODUCT_ID MPRODUCT_MREQUISITIONLINE M_STORAGE M_PRODUCT_ID MPRODUCT_STORAGE M_SUBSTITUTE M_PRODUCT_ID MPRODUCT_SUBSTITUTE M_SUBSTITUTE SUBSTITUTE_ID MPRODUCT_SUBSTITUTESUB M_TRANSACTION M_PRODUCT_ID MPRODUCT_MINVENTORYCOUNT M_TRANSACTIONALLOCATION M_PRODUCT_ID MPRODUCT_MTRXALLOC M_TRANSACTION_V M_PRODUCT_ID Implied Constraint PA_GOALRESTRICTION M_PRODUCT_ID MPRODUCT_PAGOALRESTRICTION PA_REPORTCOLUMN M_PRODUCT_ID MPRODUCT_PAREPORTCOLUMN PA_REPORTSOURCE M_PRODUCT_ID MPRODUCT_PAREPORTSOURCE RV_ASSET_CUSTOMER M_PRODUCT_ID Implied Constraint RV_ASSET_DELIVERY M_PRODUCT_ID Implied Constraint RV_COST M_PRODUCT_ID Implied Constraint RV_COSTDETAIL M_PRODUCT_ID Implied Constraint RV_COSTSUMMARY M_PRODUCT_ID Implied Constraint RV_C_RFQRESPONSE M_PRODUCT_ID Implied Constraint RV_FACT_ACCT M_PRODUCT_ID Implied Constraint RV_FACT_ACCT_PERIOD M_PRODUCT_ID Implied Constraint RV_INOUTLINECONFIRM M_PRODUCT_ID Implied Constraint RV_M_REQUISITION M_PRODUCT_ID Implied Constraint RV_M_TRANSACTION M_PRODUCT_ID Implied Constraint RV_M_TRANSACTION_SUM M_PRODUCT_ID Implied Constraint RV_PRODUCT_COSTING M_PRODUCT_ID Implied Constraint RV_TRANSACTION M_PRODUCT_ID Implied Constraint R_CATEGORY M_PRODUCT_ID Implied Constraint R_REQUEST M_PRODUCTSPENT_ID MPRODUCTSPENT_RREQUEST R_REQUEST M_PRODUCT_ID MPRODUCT_RREQUEST R_REQUESTACTION M_PRODUCT_ID MPRODUCT_RREQUESTACTION S_TIMEEXPENSELINE M_PRODUCT_ID MPRODUCT_STIMEEXPENSELINE S_TRAINING_CLASS M_PRODUCT_ID MPRODUCT_STRAININGCLASS TEST M_PRODUCT_ID Implied Constraint T_DISTRIBUTIONRUNDETAIL M_PRODUCT_ID MPRODUCT_TDRDETAIL T_INVENTORYVALUE M_PRODUCT_ID MPRODUCT_TINVENTORYVALUE T_REPLENISH M_PRODUCT_ID MPRODUCT_TREPLENISH T_TRANSACTION M_PRODUCT_ID MPRODUCT_TTRANSACTION T_TRIALBALANCE M_PRODUCT_ID Implied Constraint W_BASKETLINE M_PRODUCT_ID MPRODUCT_WBASKETLINE AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID ADCLIENT_MPRODUCT AD_ORG_ID number 10 AD_ORG AD_ORG_ID AD_ORG_MPRODUCT ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 VALUE nvarchar2 80 NAME nvarchar2 120 DESCRIPTION nvarchar2 510  √  null DOCUMENTNOTE nvarchar2 4000  √  null HELP nvarchar2 4000  √  null UPC varchar2 30  √  null SKU varchar2 30  √  null C_UOM_ID number 10 C_UOM C_UOM_ID CUOM_MPRODUCT SALESREP_ID number 10  √  null ISSUMMARY char 1 'N' ISSTOCKED char 1 'Y' ISPURCHASED char 1 'Y' ISSOLD char 1 'Y' ISBOM char 1 'N' ISINVOICEPRINTDETAILS char 1 'N' ISPICKLISTPRINTDETAILS char 1 'N' ISVERIFIED char 1 'N' C_REVENUERECOGNITION_ID number 10  √  null C_REVENUERECOGNITION C_REVENUERECOGNITION_ID CREVRECOGNITION_MPRODUCT M_PRODUCT_CATEGORY_ID number 10 M_PRODUCT_CATEGORY M_PRODUCT_CATEGORY_ID MPRODUCT_MPRODUCTCATEGORY CLASSIFICATION char 1  √  null VOLUME number 22  √  0 WEIGHT number 22  √  0 SHELFWIDTH number 10  √  null SHELFHEIGHT number 10  √  null SHELFDEPTH number 10  √  null UNITSPERPALLET number 10  √  null C_TAXCATEGORY_ID number 10 C_TAXCATEGORY C_TAXCATEGORY_ID CTAXCATEGORY_MPRODUCT S_RESOURCE_ID number 10  √  null S_RESOURCE S_RESOURCE_ID SRESOURCE_MPRODUCT DISCONTINUED char 1  √  'N' DISCONTINUEDBY date 7  √  null PROCESSING char 1  √  null S_EXPENSETYPE_ID number 10  √  null S_EXPENSETYPE S_EXPENSETYPE_ID SEXPENSETYPE_MPRODUCT PRODUCTTYPE char 1 'I' IMAGEURL nvarchar2 240  √  null DESCRIPTIONURL nvarchar2 240  √  null GUARANTEEDAYS number 10  √  null R_MAILTEXT_ID number 10  √  null R_MAILTEXT R_MAILTEXT_ID RMAILTEXT_MPRODUCT VERSIONNO nvarchar2 40  √  null M_ATTRIBUTESET_ID number 10  √  null M_ATTRIBUTESET M_ATTRIBUTESET_ID MATTRIBUTESET_MPRODUCT M_ATTRIBUTESETINSTANCE_ID number 10  √  0 M_ATTRIBUTESETINSTANCE M_ATTRIBUTESETINSTANCE_ID MATTRSETINST_MPRODUCT DOWNLOADURL nvarchar2 240  √  null M_FREIGHTCATEGORY_ID number 10  √  null M_FREIGHTCATEGORY M_FREIGHTCATEGORY_ID MFREIGHTCATEGORY_MPRODUCT M_LOCATOR_ID number 10  √  null M_LOCATOR M_LOCATOR_ID MLOCATOR_MPRODUCT GUARANTEEDAYSMIN number 10  √  null ISWEBSTOREFEATURED char 1 'N' ISSELFSERVICE char 1 'Y' C_SUBSCRIPTIONTYPE_ID number 10  √  null C_SUBSCRIPTIONTYPE C_SUBSCRIPTIONTYPE_ID CSUBSCRIPTIONTYPE_MPRODUCT ISDROPSHIP char 1 'N' ISEXCLUDEAUTODELIVERY char 1 'N' Table contained 27 rows at Wed Mar 15 18:14 SAST 2006

SchemaSpy was unable to generate a graphical representation of table relationships.
An appropriate version of dot must be in your path when generating these pages.
Requires dot version 2.2.1 or versions greater than 2.4 from www.graphviz.org.