Table almasdd.COMPIERE.M_PRICELIST

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_PRICELIST_ID number 10 B_TOPICTYPE M_PRICELIST_ID MPRICELIST_BTOPICTYPE C_BPARTNER M_PRICELIST_ID MPRICELIST_CBPARTNER C_BPARTNER PO_PRICELIST_ID MPRICELISTPO_CBUSPARTNER C_BP_GROUP M_PRICELIST_ID MPRICELIST_CBPGROUP C_BP_GROUP PO_PRICELIST_ID MPRICELISTPO_CBPGROUP C_DUNNING_LINE_V M_PRICELIST_ID Implied Constraint C_DUNNING_LINE_VT M_PRICELIST_ID Implied Constraint C_INVOICE M_PRICELIST_ID MPRICELIST_CINVOICE C_INVOICE_HEADER_V M_PRICELIST_ID Implied Constraint C_INVOICE_HEADER_VT M_PRICELIST_ID Implied Constraint C_INVOICE_V M_PRICELIST_ID Implied Constraint C_INVOICE_V1 M_PRICELIST_ID Implied Constraint C_ORDER M_PRICELIST_ID MPRICELIST_SOHEADER C_ORDER_HEADER_V M_PRICELIST_ID Implied Constraint C_ORDER_HEADER_VT M_PRICELIST_ID Implied Constraint C_POS M_PRICELIST_ID MPRICELIST_CPOS I_INVOICE M_PRICELIST_ID MPRICELIST_IINVOICE I_ORDER M_PRICELIST_ID MPRICELIST_IORDER M_PRICELIST BASEPRICELIST_ID BASEPRICELIST M_PRICELIST_VERSION M_PRICELIST_ID MPRICELIST_MPRICELISTVERSION M_REQUISITION M_PRICELIST_ID MPROCELIST_MREQUISITION RV_BPARTNER M_PRICELIST_ID Implied Constraint RV_C_INVOICE M_PRICELIST_ID Implied Constraint RV_M_REQUISITION M_PRICELIST_ID Implied Constraint S_TIMEEXPENSE M_PRICELIST_ID MPRICELIST_STIMEEXPENSE W_BASKET M_PRICELIST_ID MPRICELIST_WBASKET W_STORE M_PRICELIST_ID Implied Constraint AD_CLIENT_ID number 10 AD_CLIENTINFO AD_CLIENT_ID Implied Constraint AD_ORG_ID number 10 AD_ORGINFO AD_ORG_ID Implied Constraint ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 NAME nvarchar2 120 DESCRIPTION nvarchar2 510  √  null BASEPRICELIST_ID number 10  √  null M_PRICELIST M_PRICELIST_ID BASEPRICELIST ISTAXINCLUDED char 1 'N' ISSOPRICELIST char 1 'Y' ISDEFAULT char 1 'N' C_CURRENCY_ID number 10 C_CURRENCY C_CURRENCY_ID CCURRENCY_MPRICELIST ENFORCEPRICELIMIT char 1 'N' PRICEPRECISION number 10 2 Table contained 3 rows at ‰Î 3 07 12:14 JST 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.