Table erp.COMPIERE.I_ORDER

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_ORDER_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_IORDER AD_ORGTRX_ID number 10  √  null AD_ORG AD_ORG_ID ADORGTRX_IORDER 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' SALESREP_ID number 10  √  null AD_USER AD_USER_ID ADUSERSALESREP_IORDER M_WAREHOUSE_ID number 10  √  null M_WAREHOUSE M_WAREHOUSE_ID MWAREHOUSE_IORDER M_PRICELIST_ID number 10  √  null M_PRICELIST M_PRICELIST_ID MPRICELIST_IORDER C_CURRENCY_ID number 10  √  null C_CURRENCY C_CURRENCY_ID CCURRENCY_IORDER M_SHIPPER_ID number 10  √  null M_SHIPPER M_SHIPPER_ID MSHIPPER_IORDER ISSOTRX char 1  √  'Y' C_BPARTNER_ID number 10  √  null C_BPARTNER C_BPARTNER_ID CBPARTNER_IORDER BPARTNERVALUE nvarchar2 80  √  null NAME nvarchar2 120  √  null C_BPARTNER_LOCATION_ID number 10  √  null C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID CBOLOCATION_IORDER BILLTO_ID number 10  √  null C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID CBPARTNERLOCBILLTO_IORDER C_LOCATION_ID number 10  √  null C_LOCATION C_LOCATION_ID CLOCATION_IORDER 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_IORDER REGIONNAME nvarchar2 120  √  null C_COUNTRY_ID number 10  √  null C_COUNTRY C_COUNTRY_ID CCOUNTRY_IORDER COUNTRYCODE char 2  √  null AD_USER_ID number 10  √  null AD_USER AD_USER_ID ADUSER_IORDER CONTACTNAME nvarchar2 120  √  null EMAIL nvarchar2 120  √  null PHONE nvarchar2 80  √  null C_PROJECT_ID number 10  √  null C_PROJECT C_PROJECT_ID CPROJECT_IORDER C_ACTIVITY_ID number 10  √  null C_ACTIVITY C_ACTIVITY_ID CACTIVITY_IORDER C_DOCTYPE_ID number 10  √  null C_DOCTYPE C_DOCTYPE_ID CDOCTYPE_IORDER DOCTYPENAME nvarchar2 120  √  null C_PAYMENTTERM_ID number 10  √  null C_PAYMENTTERM C_PAYMENTTERM_ID CPAYMENTTERM_IORDER PAYMENTTERMVALUE nvarchar2 80  √  null C_ORDER_ID number 10  √  null C_ORDER C_ORDER_ID CORDER_IORDER DOCUMENTNO nvarchar2 60  √  null DATEORDERED date 7  √  null DATEACCT date 7  √  null DESCRIPTION nvarchar2 510  √  null M_PRODUCT_ID number 10  √  null M_PRODUCT M_PRODUCT_ID MPRODUCT_IORDER PRODUCTVALUE nvarchar2 80  √  null UPC nvarchar2 60  √  null SKU nvarchar2 60  √  null C_TAX_ID number 10  √  null C_TAX C_TAX_ID CTAX_IORDER TAXINDICATOR varchar2 5  √  null TAXAMT number 22  √  0 C_ORDERLINE_ID number 10  √  null C_ORDERLINE C_ORDERLINE_ID CORDERLINE_IORDER LINEDESCRIPTION nvarchar2 510  √  null C_UOM_ID number 10  √  null C_UOM C_UOM_ID CUOM_IORDER QTYORDERED number 22  √  0 PRICEACTUAL number 22  √  0 FREIGHTAMT number 22  √  0 C_CAMPAIGN_ID number 10  √  null C_CAMPAIGN C_CAMPAIGN_ID CCAMPAIGN_IORDER 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.