Table erp.COMPIERE.C_INVOICELINE

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_INVOICELINE_ID number 10 A_ASSET_ADDITION C_INVOICELINE_ID CINVOICELINE_AASSETADDITION A_ASSET_RETIREMENT C_INVOICELINE_ID CINVOICELINE_AASSETRETIREMENT C_COMMISSIONDETAIL C_INVOICELINE_ID CINVOICELINE_CCOMMISSIONDET C_INVOICEBATCHLINE C_INVOICELINE_ID CINVOICELINE_CINVOICEBLINE C_INVOICELINE REF_INVOICELINE_ID CONVOICELINE_REF C_LANDEDCOST C_INVOICELINE_ID CINVOICELINE_CLANDEDCOST C_LANDEDCOSTALLOCATION C_INVOICELINE_ID CINVOICELINE_CLANDEDCOSTALLOC C_REVENUERECOGNITION_PLAN C_INVOICELINE_ID CINVOICELINE_CREVENUERECPLAN C_TAXDECLARATIONLINE C_INVOICELINE_ID CINVOICELINE_CTAXDECLLINE I_INVOICE C_INVOICELINE_ID CINVLICELINE_IINVOICE M_COSTDETAIL C_INVOICELINE_ID MINVOICELINE_MCOSTDETAIL M_INOUTLINECONFIRM C_INVOICELINE_ID Implied Constraint M_MATCHINV C_INVOICELINE_ID CONVOICELINE_MMATCHINV M_MATCHPO C_INVOICELINE_ID CINVOICELINE_MMATCHPO RV_COMMISSIONRUNDETAIL C_INVOICELINE_ID Implied Constraint RV_COSTDETAIL C_INVOICELINE_ID Implied Constraint S_TIMEEXPENSELINE C_INVOICELINE_ID CINVOICELINE_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_INVOICE_ID number 10 C_INVOICE C_INVOICE_ID CINVOICE_CINVOICELINE C_ORDERLINE_ID number 10  √  null C_ORDERLINE C_ORDERLINE_ID CORDERLINE_CINVOICELINE M_INOUTLINE_ID number 10  √  null M_INOUTLINE M_INOUTLINE_ID MINOUTLINE_CINVOICELINE LINE number 10 DESCRIPTION nvarchar2 510  √  null M_PRODUCT_ID number 10  √  null M_PRODUCT M_PRODUCT_ID MPRODUCT_CINVOICELINE QTYINVOICED number 22 0 PRICELIST number 22 0 PRICEACTUAL number 22 0 PRICELIMIT number 22 0 LINENETAMT number 22 0 C_CHARGE_ID number 10  √  null C_CHARGE C_CHARGE_ID CCHARGE_CINVOICELINE C_UOM_ID number 10  √  null C_UOM C_UOM_ID CUOM_CINVOICELINE C_TAX_ID number 10  √  null C_TAX C_TAX_ID CTAX_CINVOICELINE S_RESOURCEASSIGNMENT_ID number 10  √  null S_RESOURCEASSIGNMENT S_RESOURCEASSIGNMENT_ID SRESOURCEASSIGN_CINVOICELINE A_ASSET_ID number 10  √  null A_ASSET A_ASSET_ID AASSET_CINVOICELINE TAXAMT number 22  √  0 M_ATTRIBUTESETINSTANCE_ID number 10  √  0 M_ATTRIBUTESETINSTANCE M_ATTRIBUTESETINSTANCE_ID MATTRSETINST_CINVOICELINE ISDESCRIPTION char 1 'N' ISPRINTED char 1 'Y' LINETOTALAMT number 22  √  0 REF_INVOICELINE_ID number 10  √  null C_INVOICELINE C_INVOICELINE_ID CONVOICELINE_REF PROCESSED char 1 'N' QTYENTERED number 22 PRICEENTERED number 22 C_PROJECT_ID number 10  √  null C_PROJECT C_PROJECT_ID Implied Constraint Table contained 30 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.