Table erp.COMPIERE.C_INVOICE

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_INVOICE_ID number 10 C_ALLOCATIONLINE C_INVOICE_ID CINVOICE_CALLOCATIONLINE C_BANKSTATEMENTLINE C_INVOICE_ID CINVOICE_CBANKSTATEMENTLINE C_CASHLINE C_INVOICE_ID CINVOICE_CCASHLINE C_DUNNINGRUNLINE C_INVOICE_ID CINVOICE_CDUNNINGRUNLINE C_DUNNING_LINE_V C_INVOICE_ID Implied Constraint C_DUNNING_LINE_VT C_INVOICE_ID Implied Constraint C_INVOICE REF_INVOICE_ID CINVOICE_REF C_INVOICEBATCHLINE C_INVOICE_ID CINVOICE_CINVOICEBATCHLINE C_INVOICELINE C_INVOICE_ID CINVOICE_CINVOICELINE C_INVOICEPAYSCHEDULE C_INVOICE_ID CINVOICE_CINVOICEPAYSCHED C_INVOICETAX C_INVOICE_ID CINVOICE_CINVOICETAX C_INVOICE_HEADER_V C_INVOICE_ID Implied Constraint C_INVOICE_HEADER_VT C_INVOICE_ID Implied Constraint C_INVOICE_V C_INVOICE_ID Implied Constraint C_PAYMENT C_INVOICE_ID Implied Constraint C_PAYMENTALLOCATE C_INVOICE_ID CINVOICE_CPAYMENTALLOCATE C_PAYMENT_V C_INVOICE_ID Implied Constraint C_PAYSELECTIONLINE C_INVOICE_ID CINVOICE_CPAYSELECTLINE C_RECURRING C_INVOICE_ID CINVOICE_CRECURRING C_RECURRING_RUN C_INVOICE_ID CINVOICE_CRECURRINGRUN C_TAXDECLARATIONLINE C_INVOICE_ID CINVOICE_CTAXDECLLINE I_BANKSTATEMENT C_INVOICE_ID CINVOICE_IBANKSTATEMENT I_INVOICE C_INVOICE_ID CINVOICE_IINVOICE I_PAYMENT C_INVOICE_ID CINVOICE_IPAYMENT M_INOUT C_INVOICE_ID Implied Constraint M_INOUTCONFIRM C_INVOICE_ID Implied Constraint RV_ALLOCATION C_INVOICE_ID Implied Constraint R_REQUEST C_INVOICEREQUEST_ID CINVOICEREQUEST_RREQUEST R_REQUEST C_INVOICE_ID RINVOICE_RREQUEST R_REQUESTACTION C_INVOICE_ID CINVOICE_RREQUESTACTION T_AGING C_INVOICE_ID Implied Constraint T_INVOICEGL C_INVOICE_ID CINVOICE_TINVOICEGL T_INVOICEGL_V C_INVOICE_ID Implied Constraint T_INVOICEGL_VT C_INVOICE_ID Implied Constraint AD_CLIENT_ID number 10 AD_CLIENTINFO AD_CLIENT_ID Implied Constraint AD_ORG_ID number 10 AD_ORG AD_ORG_ID ADORG_CINVOICE ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 ISSOTRX char 1 'Y' DOCUMENTNO nvarchar2 60 DOCSTATUS char 2 DOCACTION char 2 PROCESSING char 1  √  null PROCESSED char 1 'N' POSTED char 1 'N' C_DOCTYPE_ID number 10 C_DOCTYPE C_DOCTYPE_ID CDOCTYPE_CINVOICE C_DOCTYPETARGET_ID number 10 C_DOCTYPE C_DOCTYPE_ID CDOCTYPETARGET_CINVOICE C_ORDER_ID number 10  √  null C_ORDER C_ORDER_ID CORDER_CINVOICE DESCRIPTION nvarchar2 510  √  null ISAPPROVED char 1 'Y' ISTRANSFERRED char 1 'N' ISPRINTED char 1 'N' SALESREP_ID number 10  √  null AD_USER AD_USER_ID ADUSER_SR_CINVOICE DATEINVOICED date 7 DATEPRINTED date 7  √  null DATEACCT date 7 C_BPARTNER_ID number 10 C_BPARTNER C_BPARTNER_ID CBPARTNER_CINVOICE C_BPARTNER_LOCATION_ID number 10 C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID C_BPLOCATION_CINVOICE POREFERENCE nvarchar2 40  √  null ISDISCOUNTPRINTED char 1 'Y' DATEORDERED date 7  √  null C_CURRENCY_ID number 10 C_CURRENCY C_CURRENCY_ID CCURRENCY_CINVOICE PAYMENTRULE char 1 C_PAYMENTTERM_ID number 10 C_PAYMENTTERM C_PAYMENTTERM_ID CPAYMENTTERM_CINVOICE C_CHARGE_ID number 10  √  null C_CHARGE C_CHARGE_ID CCHARGE_CINVOICE CHARGEAMT number 22  √  0 TOTALLINES number 22 0 GRANDTOTAL number 22 0 M_PRICELIST_ID number 10 M_PRICELIST M_PRICELIST_ID MPRICELIST_CINVOICE ISTAXINCLUDED char 1 'N' C_CAMPAIGN_ID number 10  √  null C_CAMPAIGN C_CAMPAIGN_ID CCAMPAIGN_CINVOICE C_PROJECT_ID number 10  √  null C_PROJECT C_PROJECT_ID CPROJECT_CINVOICE C_ACTIVITY_ID number 10  √  null C_ACTIVITY C_ACTIVITY_ID CACTIVITY_CINVOICE ISPAID char 1 'N' C_PAYMENT_ID number 10  √  null C_PAYMENT C_PAYMENT_ID CPAYMENT_CINVOICE C_CASHLINE_ID number 10  √  null C_CASHLINE C_CASHLINE_ID CCASHLINE_CINVOICE CREATEFROM char 1  √  null GENERATETO char 1  √  null SENDEMAIL char 1 'N' AD_USER_ID number 10  √  null AD_USER AD_USER_ID ADUSER_CINVOICE COPYFROM char 1  √  null ISSELFSERVICE char 1 'N' AD_ORGTRX_ID number 10  √  null AD_ORG AD_ORG_ID ADORGTRX_CINVOICE USER1_ID number 10  √  null C_ELEMENTVALUE C_ELEMENTVALUE_ID CELEMENTVALUEUSER1_CINVOICE USER2_ID number 10  √  null C_ELEMENTVALUE C_ELEMENTVALUE_ID CELEMENTVALUEUSER2_CINVOICE C_CONVERSIONTYPE_ID number 10  √  null C_CONVERSIONTYPE C_CONVERSIONTYPE_ID CCONVERSIONTYPE_CINVOICE ISPAYSCHEDULEVALID char 1 'N' REF_INVOICE_ID number 10  √  null C_INVOICE C_INVOICE_ID CINVOICE_REF ISINDISPUTE char 1 'N' Table contained 14 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.