Table erp.COMPIERE.C_BPARTNER_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_BPARTNER_LOCATION_ID number 10 AD_USER C_BPARTNER_LOCATION_ID CBPLOCATION_ADUSER A_ASSET C_BPARTNER_LOCATION_ID CBPLOCATION_AASSET C_BP_RELATION C_BPARTNERRELATION_LOCATION_ID CBPLOCATION_CBPRELATIONBP C_BP_RELATION C_BPARTNER_LOCATION_ID CBPLOCATION_CBPRELATION C_DUNNINGRUNENTRY C_BPARTNER_LOCATION_ID Implied Constraint C_INVOICE C_BPARTNER_LOCATION_ID C_BPLOCATION_CINVOICE C_INVOICEBATCHLINE C_BPARTNER_LOCATION_ID CBPLOCATION_CINVOICEBLINE C_INVOICE_V C_BPARTNER_LOCATION_ID Implied Constraint C_ORDER BILL_LOCATION_ID CBPLOCATIONBILL_CORDER C_ORDER C_BPARTNER_LOCATION_ID CBPARTNERLOCATION_CORDER C_ORDER PAY_LOCATION_ID CBPLOCATIONPAY_CORDER C_ORDERLINE C_BPARTNER_LOCATION_ID CBPARTNERLOCATION_SOLINE C_PROJECT C_BPARTNER_LOCATION_ID CBPLOCATION_CPROJECT C_RFQ C_BPARTNER_LOCATION_ID CBPLOCATION_CRFQ C_RFQRESPONSE C_BPARTNER_LOCATION_ID CBPLOCATION_CRFQRESPONSE C_RFQRESPONSE_V C_BPARTNER_LOCATION_ID Implied Constraint C_RFQRESPONSE_VT C_BPARTNER_LOCATION_ID Implied Constraint C_RFQ_TOPICSUBSCRIBER C_BPARTNER_LOCATION_ID CBPARTNERLOC_CRFQTOPICSUBR I_BPARTNER C_BPARTNER_LOCATION_ID CBPARTNERLOCATION_IBPARTNER I_INVOICE C_BPARTNER_LOCATION_ID CBPLOCATION_IINVOICE I_ORDER BILLTO_ID CBPARTNERLOCBILLTO_IORDER I_ORDER C_BPARTNER_LOCATION_ID CBOLOCATION_IORDER M_DISTRIBUTIONLISTLINE C_BPARTNER_LOCATION_ID CBPARTNERLOC_MDISTLISTLINE M_DISTRIBUTIONRUN C_BPARTNER_LOCATION_ID CBPLOCATION_MDISTRIBUTIONRUN M_INOUT C_BPARTNER_LOCATION_ID VBPLOCATION_MINOUT M_INOUTCONFIRM_V C_BPARTNER_LOCATION_ID Implied Constraint M_INOUTCONFIRM_VT C_BPARTNER_LOCATION_ID Implied Constraint RV_ASSET_CUSTOMER C_BPARTNER_LOCATION_ID Implied Constraint RV_BPARTNER C_BPARTNER_LOCATION_ID Implied Constraint RV_C_RFQRESPONSE C_BPARTNER_LOCATION_ID Implied Constraint RV_C_RFQ_UNANSWERED C_BPARTNER_LOCATION_ID Implied Constraint RV_INOUTCONFIRM C_BPARTNER_LOCATION_ID Implied Constraint RV_INOUTLINECONFIRM C_BPARTNER_LOCATION_ID Implied Constraint T_DISTRIBUTIONRUNDETAIL C_BPARTNER_LOCATION_ID CBPARTNERLOCATION_TDRDETAIL T_INVOICEGL_V C_BPARTNER_LOCATION_ID Implied Constraint T_INVOICEGL_VT C_BPARTNER_LOCATION_ID Implied Constraint AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID C_BUSPARTNER_LOCATIONCLIENT AD_ORG_ID number 10 AD_ORG AD_ORG_ID C_BUSPARTNER_LOCATIONORG ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 NAME nvarchar2 120 ISBILLTO char 1 'Y' ISSHIPTO char 1 'Y' ISPAYFROM char 1 'Y' ISREMITTO char 1 'Y' PHONE nvarchar2 80  √  null PHONE2 nvarchar2 80  √  null FAX nvarchar2 80  √  null ISDN nvarchar2 80  √  null C_SALESREGION_ID number 10  √  null C_SALESREGION C_SALESREGION_ID CSALESREGION_BPARTNERLOCATION C_BPARTNER_ID number 10 C_BPARTNER C_BPARTNER_ID CBPARTNER_CBPLOCATION C_LOCATION_ID number 10  √  null C_LOCATION C_LOCATION_ID CLOCATION_CBPLOCATION Table contained 8 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.