Table erp.COMPIERE.C_LOCATION

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_LOCATION_ID number 10 AD_ORGINFO C_LOCATION_ID C_LOCATION_AD_ORGINFO AD_ORG_V C_LOCATION_ID Implied Constraint AD_REGISTRATION C_LOCATION_ID Implied Constraint A_ASSET C_LOCATION_ID CLOCATION_AASSET C_ACCTSCHEMA_ELEMENT C_LOCATION_ID CLOCATION_CASCHEMAELEMENT C_BANK C_LOCATION_ID CLOCATION_CBANK C_BPARTNER_LOCATION C_LOCATION_ID CLOCATION_CBPLOCATION C_DUNNING_HEADER_V C_LOCATION_ID Implied Constraint C_DUNNING_HEADER_VT C_LOCATION_ID Implied Constraint C_INVOICE_HEADER_V C_LOCATION_ID Implied Constraint C_INVOICE_HEADER_VT C_LOCATION_ID Implied Constraint C_ORDER_HEADER_V C_LOCATION_ID Implied Constraint C_ORDER_HEADER_VT C_LOCATION_ID Implied Constraint C_PROJECT_HEADER_V C_LOCATION_ID Implied Constraint C_PROJECT_HEADER_VT C_LOCATION_ID Implied Constraint C_RFQRESPONSE_V C_LOCATION_ID Implied Constraint C_RFQRESPONSE_VT C_LOCATION_ID Implied Constraint C_VALIDCOMBINATION C_LOCFROM_ID MLOCATIONFROM_VC C_VALIDCOMBINATION C_LOCTO_ID MLOCATIONTO_VC FACT_ACCT C_LOCFROM_ID C_LOCATIONFROM_FACT_ACCT FACT_ACCT C_LOCTO_ID C_LOCATIONTO_FACT_ACCT FACT_ACCT_BALANCE C_LOCFROM_ID CLOCFROM_FACTACCTBALANCE FACT_ACCT_BALANCE C_LOCTO_ID CLOCTO_FACTACCTBAL GL_DISTRIBUTION C_LOCFROM_ID CLOCFROM_GLDIST GL_DISTRIBUTION C_LOCTO_ID CLOCTO_GLDIST GL_DISTRIBUTIONLINE C_LOCFROM_ID CLOCFROM_GLDISTLINE GL_DISTRIBUTIONLINE C_LOCTO_ID CLOCTO_GLDISTLINE I_GLJOURNAL C_LOCFROM_ID CLOCFROM_IGLJOURNAL I_GLJOURNAL C_LOCTO_ID CLOCTO_IGLJOURNAL I_INVOICE C_LOCATION_ID CLOCATION_IINVOICE I_ORDER C_LOCATION_ID CLOCATION_IORDER M_INOUT_HEADER_V C_LOCATION_ID Implied Constraint M_INOUT_HEADER_VT C_LOCATION_ID Implied Constraint M_WAREHOUSE C_LOCATION_ID C_LOCATION_WAREHOUSE PA_REPORTCOLUMN C_LOCATION_ID CLOCATION_PAREPORTCOLUMN PA_REPORTSOURCE C_LOCATION_ID CLOCATION_PAREPORTSOURCE TEST C_LOCATION_ID Implied Constraint AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID ADCLIENT_CLOCATION AD_ORG_ID number 10 AD_ORG AD_ORG_ID ADORG_CLOCATION ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 ADDRESS1 nvarchar2 120  √  null ADDRESS2 nvarchar2 120  √  null CITY nvarchar2 120  √  null POSTAL varchar2 10  √  null POSTAL_ADD varchar2 10  √  null C_COUNTRY_ID number 10 C_COUNTRY C_COUNTRY_ID C_COUNTRY_LOCATION C_REGION_ID number 10  √  null C_REGION C_REGION_ID C_REGION_LOCATION C_CITY_ID number 10  √  null C_CITY C_CITY_ID CCITY_CLOCATION REGIONNAME nvarchar2 80  √  null ADDRESS3 nvarchar2 120  √  null ADDRESS4 nvarchar2 120  √  null Table contained 13 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.