Table almasdd.COMPIERE.C_ORDERLINE

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 C_ORDERLINE_ID number 10 C_COMMISSIONDETAIL C_ORDERLINE_ID CORDERLINE_CCOMMISSIONDETAIL C_INVOICELINE C_ORDERLINE_ID CORDERLINE_CINVOICELINE C_INVOICELINE_V C_ORDERLINE_ID Implied Constraint C_ORDERLINE REF_ORDERLINE_ID CORDERLINE_REF I_ORDER C_ORDERLINE_ID CORDERLINE_IORDER M_COSTDETAIL C_ORDERLINE_ID CORDERLINE_MCOSTDETAIL M_DEMANDDETAIL C_ORDERLINE_ID CORDERLINE_MDEMANDDETAIL M_INOUTLINE C_ORDERLINE_ID CORDERLINE_MINOUT M_MATCHPO C_ORDERLINE_ID CORDERLINE_MMATCHPO M_REQUISITIONLINE C_ORDERLINE_ID Implied Constraint RV_COMMISSIONRUNDETAIL C_ORDERLINE_ID Implied Constraint RV_INOUTDETAILS C_ORDERLINE_ID Implied Constraint RV_ORDERDETAIL C_ORDERLINE_ID Implied Constraint S_TIMEEXPENSELINE C_ORDERLINE_ID CORDERLINE_STIMEEXPENSELINE 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 C_ORDER_ID number 10 C_ORDER C_ORDER_ID CORDER_CORDERLINE LINE number 10 C_BPARTNER_ID number 10  √  null C_BPARTNER C_BPARTNER_ID CBPARTNER_SOLINE C_BPARTNER_LOCATION_ID number 10  √  null C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID CBPARTNERLOCATION_SOLINE DATEORDERED date 7 DATEPROMISED date 7  √  null DATEDELIVERED date 7  √  null DATEINVOICED date 7  √  null DESCRIPTION nvarchar2 510  √  null M_PRODUCT_ID number 10  √  null M_PRODUCT M_PRODUCT_ID MPRODUCT_CORDERLINE M_WAREHOUSE_ID number 10 M_WAREHOUSE M_WAREHOUSE_ID MWAREHOUSE_CORDERLINE C_UOM_ID number 10 C_UOM C_UOM_ID CUOM_CORDERLINE QTYORDERED number 22 0 QTYRESERVED number 22 0 QTYDELIVERED number 22 0 QTYINVOICED number 22 0 M_SHIPPER_ID number 10  √  null M_SHIPPER M_SHIPPER_ID MSHIPPER_CORDERLINE C_CURRENCY_ID number 10 C_CURRENCY C_CURRENCY_ID CCURRENCY_CORDERLINE PRICELIST number 22 0 PRICEACTUAL number 22 0 PRICELIMIT number 22 0 LINENETAMT number 22 0 DISCOUNT number 22  √  null FREIGHTAMT number 22 0 C_CHARGE_ID number 10  √  null C_CHARGE C_CHARGE_ID CCHARGE_CORDERLINE C_TAX_ID number 10 C_TAX C_TAX_ID CTAX_CORDERLINE S_RESOURCEASSIGNMENT_ID number 10  √  null S_RESOURCEASSIGNMENT S_RESOURCEASSIGNMENT_ID SRESOURCEASSIGN_CORDERLINE REF_ORDERLINE_ID number 10  √  null C_ORDERLINE C_ORDERLINE_ID CORDERLINE_REF M_ATTRIBUTESETINSTANCE_ID number 10  √  0 M_ATTRIBUTESETINSTANCE M_ATTRIBUTESETINSTANCE_ID MATTRSETINST_CORDERLINE ISDESCRIPTION char 1 'N' PROCESSED char 1 'N' QTYENTERED number 22 PRICEENTERED number 22 C_PROJECT_ID number 10  √  null C_PROJECT C_PROJECT_ID Implied Constraint PRICECOST number 22  √  null QTYLOSTSALES number 22 0 Table contained 25 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.