View erp.COMPIERE.RV_BPARTNER

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 AD_CLIENT_ID number 10 AD_CLIENTINFO AD_CLIENT_ID Implied Constraint AD_ORG_ID number 10 AD_ORGINFO AD_ORG_ID Implied Constraint ISACTIVE char 1 CREATED date 7 CREATEDBY number 10 UPDATED date 7 UPDATEDBY number 10 C_BPARTNER_ID number 10 C_BPARTNER C_BPARTNER_ID Implied Constraint VALUE nvarchar2 80 NAME nvarchar2 120 NAME2 nvarchar2 120  √  null DESCRIPTION nvarchar2 510  √  null ISSUMMARY char 1 C_BP_GROUP_ID number 10 C_BP_GROUP C_BP_GROUP_ID Implied Constraint ISONETIME char 1 ISPROSPECT char 1 ISVENDOR char 1 ISCUSTOMER char 1 ISEMPLOYEE char 1 ISSALESREP char 1 REFERENCENO nvarchar2 80  √  null DUNS char 11  √  null URL nvarchar2 240  √  null AD_LANGUAGE varchar2 6  √  null AD_LANGUAGE AD_LANGUAGE Implied Constraint TAXID varchar2 20  √  null ISTAXEXEMPT char 1  √  null C_INVOICESCHEDULE_ID number 10  √  null C_INVOICESCHEDULE C_INVOICESCHEDULE_ID Implied Constraint RATING char 1  √  null SALESVOLUME number 10  √  null NUMBEREMPLOYEES number 10  √  null NAICS char 6  √  null FIRSTSALE date 7  √  null ACQUSITIONCOST number 22  √  null POTENTIALLIFETIMEVALUE number 22  √  null ACTUALLIFETIMEVALUE number 22  √  null SHAREOFCUSTOMER number 10  √  null PAYMENTRULE char 1  √  null SO_CREDITLIMIT number 22  √  null SO_CREDITUSED number 22  √  null SO_CREDITAVAILABLE number 22  √  null C_PAYMENTTERM_ID number 10  √  null C_PAYMENTTERM C_PAYMENTTERM_ID Implied Constraint M_PRICELIST_ID number 10  √  null M_PRICELIST M_PRICELIST_ID Implied Constraint M_DISCOUNTSCHEMA_ID number 10  √  null M_DISCOUNTSCHEMA M_DISCOUNTSCHEMA_ID Implied Constraint C_DUNNING_ID number 10  √  null C_DUNNING C_DUNNING_ID Implied Constraint ISDISCOUNTPRINTED char 1  √  null SO_DESCRIPTION nvarchar2 510  √  null POREFERENCE nvarchar2 40  √  null PAYMENTRULEPO char 1  √  null PO_PRICELIST_ID number 10  √  null PO_DISCOUNTSCHEMA_ID number 10  √  null PO_PAYMENTTERM_ID number 10  √  null DOCUMENTCOPIES number 10  √  null C_GREETING_ID number 10  √  null C_GREETING C_GREETING_ID Implied Constraint INVOICERULE char 1  √  null DELIVERYRULE char 1  √  null FREIGHTCOSTRULE char 1  √  null DELIVERYVIARULE char 1  √  null SALESREP_ID number 10  √  null SENDEMAIL char 1 BPARTNER_PARENT_ID number 10  √  null INVOICE_PRINTFORMAT_ID number 10  √  null SOCREDITSTATUS char 1  √  null SHELFLIFEMINPCT number 10  √  null AD_ORGBP_ID number 10  √  null FLATDISCOUNT number 22  √  null TOTALOPENBALANCE number 22  √  null AD_USER_ID number 10 AD_USER AD_USER_ID Implied Constraint CONTACTNAME nvarchar2 120 CONTACTDESCRIPTION nvarchar2 510  √  null EMAIL nvarchar2 120  √  null SUPERVISOR_ID number 10  √  null EMAILUSER nvarchar2 120  √  null BPCONTACTGREETING number 10  √  null TITLE nvarchar2 80  √  null COMMENTS nvarchar2 4000  √  null PHONE nvarchar2 80  √  null PHONE2 nvarchar2 80  √  null FAX nvarchar2 80  √  null LASTCONTACT date 7  √  null LASTRESULT nvarchar2 510  √  null BIRTHDAY date 7  √  null AD_ORGTRX_ID number 10  √  null EMAILVERIFY nvarchar2 80  √  null LDAPUSER nvarchar2 120  √  null EMAILVERIFYDATE date 7  √  null NOTIFICATIONTYPE char 1 C_BPARTNER_LOCATION_ID number 10  √  null C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID Implied Constraint POSTAL varchar2 10  √  null CITY nvarchar2 120  √  null ADDRESS1 nvarchar2 120  √  null ADDRESS2 nvarchar2 120  √  null ADDRESS3 nvarchar2 120  √  null C_REGION_ID number 10  √  null C_REGION C_REGION_ID Implied Constraint REGIONNAME nvarchar2 120  √  null C_COUNTRY_ID number 10  √  null C_COUNTRY C_COUNTRY_ID Implied Constraint COUNTRYNAME nvarchar2 120

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.