Table erp.COMPIERE.C_BPARTNER

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_ID number 10 AD_ARCHIVE C_BPARTNER_ID Implied Constraint AD_ORG_V C_BPARTNER_ID Implied Constraint AD_USER C_BPARTNER_ID CBPARTNER_ADUSER A_ASSET C_BPARTNER_ID CBPARTNER_AASSET A_REGISTRATION C_BPARTNER_ID CBPARTNER_AREGISTRATION C_ACCTSCHEMA_ELEMENT C_BPARTNER_ID CBUSPARTNER_CASCHEMAELEMENT C_ALLOCATIONLINE C_BPARTNER_ID CBPARTNER_CALLOCATIONLINE C_BANKSTATEMENTLINE C_BPARTNER_ID CBPARTNER_CBANKSTATEMENTLINE C_BPARTNER BPARTNER_PARENT_ID CBPARTNER_CPBARTNERPARENT C_BPARTNER_LOCATION C_BPARTNER_ID CBPARTNER_CBPLOCATION C_BPARTNER_PRODUCT C_BPARTNER_ID CBPARTNER_CBPPRODUCT C_BP_BANKACCOUNT C_BPARTNER_ID CBPARTNER_CBPBANKACCOUNT C_BP_CUSTOMER_ACCT C_BPARTNER_ID CBUSPARTNER_CBPCUSTOMER_ACCT C_BP_EDI C_BPARTNER_ID C_BPARTNER_CBPEDI C_BP_EMPLOYEE_ACCT C_BPARTNER_ID CBUSPARTNER_C_BPEMPLOYEEACCT C_BP_RELATION C_BPARTNERRELATION_ID CBPARTNER_CBPRELATIONBP C_BP_RELATION C_BPARTNER_ID CBPARTNER_CBPRELATION C_BP_VENDOR_ACCT C_BPARTNER_ID C_BUSPARTNER_C_BP_VENDOR_ACCT C_BP_WITHHOLDING C_BPARTNER_ID CBPARTNER_CBPWITHHOLDING C_CHARGE C_BPARTNER_ID Implied Constraint C_COMMISSION C_BPARTNER_ID CBPARTNER_CCOMMISSION C_COMMISSIONLINE C_BPARTNER_ID CBPARTNER_CCOMMISSIONLINE C_DUNNINGRUNENTRY C_BPARTNER_ID CBPARTNER_CDUNNINGRUNENTRY C_DUNNING_HEADER_V C_BPARTNER_ID Implied Constraint C_DUNNING_HEADER_VT C_BPARTNER_ID Implied Constraint C_INVOICE C_BPARTNER_ID CBPARTNER_CINVOICE C_INVOICEBATCHLINE C_BPARTNER_ID CBPARTNER_CINVOICEBATCHLINE C_INVOICE_HEADER_V C_BPARTNER_ID Implied Constraint C_INVOICE_HEADER_VT C_BPARTNER_ID Implied Constraint C_INVOICE_V C_BPARTNER_ID Implied Constraint C_ORDER BILL_BPARTNER_ID CBPARTNERBILL_CORDER C_ORDER C_BPARTNER_ID CBPARTNER_CORDER C_ORDER PAY_BPARTNER_ID CBPARTNERPAY_CORDER C_ORDERLINE C_BPARTNER_ID CBPARTNER_SOLINE C_ORDER_HEADER_V C_BPARTNER_ID Implied Constraint C_ORDER_HEADER_VT C_BPARTNER_ID Implied Constraint C_PAYMENT C_BPARTNER_ID CBPARTNER_CPAYMENT C_PAYMENT_V C_BPARTNER_ID Implied Constraint C_PAYSELECTIONCHECK C_BPARTNER_ID CBPARTNER_CPAYSELECTIONCHECK C_PAYSELECTION_REMITTANCE_V C_BPARTNER_ID Implied Constraint C_PAYSELECTION_REMITTANCE_VT C_BPARTNER_ID Implied Constraint C_PROJECT C_BPARTNER_ID CBPARTNER_CPROJECT C_PROJECT_HEADER_V C_BPARTNER_ID Implied Constraint C_PROJECT_HEADER_VT C_BPARTNER_ID Implied Constraint C_RFQ C_BPARTNER_ID CBPARTNER_CRFQ C_RFQRESPONSE C_BPARTNER_ID CBPARTNER_CRFQRESPONSE C_RFQRESPONSE_V C_BPARTNER_ID Implied Constraint C_RFQRESPONSE_VT C_BPARTNER_ID Implied Constraint C_RFQ_TOPICSUBSCRIBER C_BPARTNER_ID CBPARTNER_CRFQTOPICSUBR C_SUBSCRIPTION C_BPARTNER_ID CBPARTNER_CSUBSCRIPTION C_TAXDECLARATIONLINE C_BPARTNER_ID CBPARTNER_CTAXDECLLINE C_VALIDCOMBINATION C_BPARTNER_ID CBPARTNER_VC FACT_ACCT C_BPARTNER_ID C_BUSPARTNER_FACT_ACCT FACT_ACCT_BALANCE C_BPARTNER_ID CBPARTNER_FACTACCTBAL GL_DISTRIBUTION C_BPARTNER_ID CBPARTNER_GLDIST GL_DISTRIBUTIONLINE C_BPARTNER_ID CBPARTNER_GLDISTLINE GL_JOURNALLINE_ACCT_V C_BPARTNER_ID Implied Constraint I_BANKSTATEMENT C_BPARTNER_ID CBPARTNER_IBANKSTATEMENT I_BPARTNER C_BPARTNER_ID CBPARTNER_IBPARTNER I_GLJOURNAL C_BPARTNER_ID CBPARTNER_IGLJOURNAL I_INVOICE C_BPARTNER_ID CBPARTNER_IINVOICE I_ORDER C_BPARTNER_ID CBPARTNER_IORDER I_PAYMENT C_BPARTNER_ID CBPARTNER_IPAYMENT I_PRODUCT C_BPARTNER_ID CBPARTNER_IPRODUCT M_DISCOUNTSCHEMALINE C_BPARTNER_ID CBPARTNER_MDISCOUNTSLINE M_DISTRIBUTIONLISTLINE C_BPARTNER_ID CBPARTNER_MDISTLISTLINE M_DISTRIBUTIONRUN C_BPARTNER_ID CBPARTNER_MDISTRIBUTIONRUN M_INOUT C_BPARTNER_ID CBPARTNER_MINOUT M_INOUTCONFIRM_V C_BPARTNER_ID Implied Constraint M_INOUTCONFIRM_VT C_BPARTNER_ID Implied Constraint M_INOUT_CANDIDATE_V C_BPARTNER_ID Implied Constraint M_INOUT_HEADER_V C_BPARTNER_ID Implied Constraint M_INOUT_HEADER_VT C_BPARTNER_ID Implied Constraint M_PRODUCT_PO C_BPARTNER_ID C_BUSPARTNER_M_PRODUCT_PO M_RMA C_BPARTNER_ID Implied Constraint M_SHIPPER C_BPARTNER_ID CBPARTNER_MSHIPPER PA_GOALRESTRICTION C_BPARTNER_ID CBPARTNER_PAGOALRESTRICTION PA_REPORTCOLUMN C_BPARTNER_ID CBPARTNER_PAREPORTCOLUMN PA_REPORTSOURCE C_BPARTNER_ID CBPARTNER_PAREPORTSOURCE PA_SLA_GOAL C_BPARTNER_ID CBPARTNER_PASLAGOAL RV_ALLOCATION C_BPARTNER_ID Implied Constraint RV_ASSET_CUSTOMER C_BPARTNER_ID Implied Constraint RV_ASSET_DELIVERY C_BPARTNER_ID Implied Constraint RV_BPARTNER C_BPARTNER_ID Implied Constraint RV_C_RFQRESPONSE C_BPARTNER_ID Implied Constraint RV_C_RFQ_UNANSWERED C_BPARTNER_ID Implied Constraint RV_FACT_ACCT C_BPARTNER_ID Implied Constraint RV_FACT_ACCT_PERIOD C_BPARTNER_ID Implied Constraint RV_INOUTCONFIRM C_BPARTNER_ID Implied Constraint RV_INOUTLINECONFIRM C_BPARTNER_ID Implied Constraint RV_M_TRANSACTION C_BPARTNER_ID Implied Constraint R_REQUEST C_BPARTNER_ID C_BPARTNER_RREQUEST R_REQUESTACTION C_BPARTNER_ID CBPARTNER_RREQUESTACTION S_TIMEEXPENSE C_BPARTNER_ID CBPARTNER_STIMEEXPENSE S_TIMEEXPENSELINE C_BPARTNER_ID CBPARTNER_STIMEEXPENSELINE TEST C_BPARTNER_ID Implied Constraint TIRE_STORAGE C_BPARTNER_ID CBPARTNER_TIRESTORAGE T_AGING C_BPARTNER_ID CBPARTNER_TAGING T_DISTRIBUTIONRUNDETAIL C_BPARTNER_ID CBPARTNER_TDRDETAIL T_INVOICEGL_V C_BPARTNER_ID Implied Constraint T_INVOICEGL_VT C_BPARTNER_ID Implied Constraint T_REPLENISH C_BPARTNER_ID Implied Constraint T_TRIALBALANCE C_BPARTNER_ID Implied Constraint W_ADVERTISEMENT C_BPARTNER_ID CBPARTNER_WADVERTISEMENT W_BASKET C_BPARTNER_ID CBPARTNER_WBASKET W_CLICKCOUNT C_BPARTNER_ID CBPARTNER_WCLICKCOUNT W_COUNTERCOUNT C_BPARTNER_ID CBPARTNER_WCOUNTERCOUNT AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID ADCLIENT_CBPARTNER AD_ORG_ID number 10 AD_ORG AD_ORG_ID ADORG_CBPARTNER ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 VALUE nvarchar2 80 NAME nvarchar2 120 NAME2 nvarchar2 120  √  null DESCRIPTION nvarchar2 510  √  null ISSUMMARY char 1 'N' C_BP_GROUP_ID number 10 C_BP_GROUP C_BP_GROUP_ID CBPGROUP_CBPARTNER ISONETIME char 1 'N' ISPROSPECT char 1 'Y' ISVENDOR char 1 'N' ISCUSTOMER char 1 'Y' ISEMPLOYEE char 1 'N' ISSALESREP char 1 'N' REFERENCENO nvarchar2 80  √  null DUNS char 11  √  null URL nvarchar2 240  √  null AD_LANGUAGE varchar2 6  √  null AD_LANGUAGE AD_LANGUAGE AD_LANGUAGE_C_BUSPARTNER TAXID varchar2 20  √  null ISTAXEXEMPT char 1  √  'N' C_INVOICESCHEDULE_ID number 10  √  null C_INVOICESCHEDULE C_INVOICESCHEDULE_ID CINVOICESCHEDULE_CBPARTNER RATING char 1  √  null SALESVOLUME number 10  √  null NUMBEREMPLOYEES number 10  √  null NAICS char 6  √  null FIRSTSALE date 7  √  null ACQUSITIONCOST number 22  √  0 POTENTIALLIFETIMEVALUE number 22  √  0 ACTUALLIFETIMEVALUE number 22  √  0 SHAREOFCUSTOMER number 10  √  null PAYMENTRULE char 1  √  null SO_CREDITLIMIT number 22  √  0 SO_CREDITUSED number 22  √  0 C_PAYMENTTERM_ID number 10  √  null C_PAYMENTTERM C_PAYMENTTERM_ID CPAYMENTTERM_CBPARTNER M_PRICELIST_ID number 10  √  null M_PRICELIST M_PRICELIST_ID MPRICELIST_CBPARTNER M_DISCOUNTSCHEMA_ID number 10  √  null M_DISCOUNTSCHEMA M_DISCOUNTSCHEMA_ID MDISCOUNTS_CBPARTNER C_DUNNING_ID number 10  √  null C_DUNNING C_DUNNING_ID CDUNNING_CBPARTNER ISDISCOUNTPRINTED char 1  √  'Y' SO_DESCRIPTION nvarchar2 510  √  null POREFERENCE nvarchar2 40  √  null PAYMENTRULEPO char 1  √  null PO_PRICELIST_ID number 10  √  null M_PRICELIST M_PRICELIST_ID MPRICELISTPO_CBUSPARTNER PO_DISCOUNTSCHEMA_ID number 10  √  null M_DISCOUNTSCHEMA M_DISCOUNTSCHEMA_ID MDISCOUNTSPO_CBPARTNER PO_PAYMENTTERM_ID number 10  √  null C_PAYMENTTERM C_PAYMENTTERM_ID CPOPAYMENTTERM_CBPARTNER DOCUMENTCOPIES number 10  √  null C_GREETING_ID number 10  √  null C_GREETING C_GREETING_ID CGREETING_CBPARTNER INVOICERULE char 1  √  null DELIVERYRULE char 1  √  null FREIGHTCOSTRULE char 1  √  null DELIVERYVIARULE char 1  √  null SALESREP_ID number 10  √  null AD_USER AD_USER_ID ADUSERSALESREP_CBPARTNER SENDEMAIL char 1 'N' BPARTNER_PARENT_ID number 10  √  null C_BPARTNER C_BPARTNER_ID CBPARTNER_CPBARTNERPARENT INVOICE_PRINTFORMAT_ID number 10  √  null AD_PRINTFORMAT AD_PRINTFORMAT_ID ADPRINTFORMATINV_CBPARTNER SOCREDITSTATUS char 1  √  'O' SHELFLIFEMINPCT number 10  √  null AD_ORGBP_ID number 10  √  null AD_ORG AD_ORG_ID ADORG_CBPARTNERORG FLATDISCOUNT number 22  √  null TOTALOPENBALANCE number 22  √  null 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.