Table erp.COMPIERE.I_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 I_INVOICE_ID number 10 AD_CLIENT_ID number 10  √  null AD_CLIENTINFO AD_CLIENT_ID Implied Constraint AD_ORG_ID number 10  √  null AD_ORG AD_ORG_ID ADORG_IINVOICE AD_ORGTRX_ID number 10  √  null AD_ORG AD_ORG_ID ADORGTRX_IINVOICE ISACTIVE char 1  √  'Y' CREATED date 7  √  now CREATEDBY number 10  √  null UPDATED date 7  √  now UPDATEDBY number 10  √  null I_ISIMPORTED char 1 'N' I_ERRORMSG nvarchar2 4000  √  null PROCESSING char 1  √  null PROCESSED char 1  √  'N' M_PRICELIST_ID number 10  √  null M_PRICELIST M_PRICELIST_ID MPRICELIST_IINVOICE C_CURRENCY_ID number 10  √  null C_CURRENCY C_CURRENCY_ID CCURRENCY_IINVOICE SALESREP_ID number 10  √  null AD_USER AD_USER_ID ADUSERSALESREP_IINVOICE ISSOTRX char 1  √  'Y' C_BPARTNER_ID number 10  √  null C_BPARTNER C_BPARTNER_ID CBPARTNER_IINVOICE C_BPARTNER_LOCATION_ID number 10  √  null C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID CBPLOCATION_IINVOICE BPARTNERVALUE nvarchar2 80  √  null NAME nvarchar2 120  √  null C_LOCATION_ID number 10  √  null C_LOCATION C_LOCATION_ID CLOCATION_IINVOICE ADDRESS1 nvarchar2 120  √  null ADDRESS2 nvarchar2 120  √  null POSTAL varchar2 10  √  null CITY nvarchar2 120  √  null C_REGION_ID number 10  √  null C_REGION C_REGION_ID CREGION_IINVOICE REGIONNAME nvarchar2 120  √  null AD_USER_ID number 10  √  null AD_USER AD_USER_ID ADUSER_IINVOICE EMAIL nvarchar2 120  √  null CONTACTNAME nvarchar2 120  √  null PHONE nvarchar2 80  √  null C_COUNTRY_ID number 10  √  null C_COUNTRY C_COUNTRY_ID CCOUNTRY_IINVOICE COUNTRYCODE char 2  √  null C_DOCTYPE_ID number 10  √  null C_DOCTYPE C_DOCTYPE_ID CDOCTYPE_IINVOICE DOCTYPENAME nvarchar2 120  √  null C_PAYMENTTERM_ID number 10  √  null C_PAYMENTTERM C_PAYMENTTERM_ID CPAYMENTTERM_IINVOICE PAYMENTTERMVALUE nvarchar2 80  √  null C_PROJECT_ID number 10  √  null C_PROJECT C_PROJECT_ID CPROJECT_IINVOICE C_CAMPAIGN_ID number 10  √  null C_CAMPAIGN C_CAMPAIGN_ID CCAMPAIGN_IINVOICE C_ACTIVITY_ID number 10  √  null C_ACTIVITY C_ACTIVITY_ID CACTIVITY_IINVOICE C_INVOICE_ID number 10  √  null C_INVOICE C_INVOICE_ID CINVOICE_IINVOICE DOCUMENTNO nvarchar2 60  √  null DATEINVOICED date 7  √  null DATEACCT date 7  √  null DESCRIPTION nvarchar2 510  √  null M_PRODUCT_ID number 10  √  null M_PRODUCT M_PRODUCT_ID NPRODUCT_IINVOICE PRODUCTVALUE nvarchar2 80  √  null UPC nvarchar2 60  √  null SKU nvarchar2 60  √  null C_TAX_ID number 10  √  null C_TAX C_TAX_ID CTAX_IINVOICE TAXINDICATOR varchar2 5  √  null TAXAMT number 22  √  0 C_INVOICELINE_ID number 10  √  null C_INVOICELINE C_INVOICELINE_ID CINVLICELINE_IINVOICE LINEDESCRIPTION nvarchar2 510  √  null QTYORDERED number 22  √  0 PRICEACTUAL number 22  √  0 Table contained 0 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.