Table erp.COMPIERE.C_BANKACCOUNT

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_BANKACCOUNT_ID number 10 C_BANKACCOUNTDOC C_BANKACCOUNT_ID CBANKACCOUNT_CBADOC C_BANKACCOUNT_ACCT C_BANKACCOUNT_ID CBANKACCOUNT_CBANKACCTACCT C_BANKSTATEMENT C_BANKACCOUNT_ID CBANKACCOUNT_CBANKSTATEMENT C_BANKSTATEMENTLOADER C_BANKACCOUNT_ID CBANKACCT_CBANKSTMTLOADER C_CASHLINE C_BANKACCOUNT_ID CBANKACCT_CCASHLINE C_ELEMENTVALUE C_BANKACCOUNT_ID CBANKACCOUNT_CELEMENTVALUE C_PAYMENT C_BANKACCOUNT_ID CBANKACCOUNT_CPAYMENT C_PAYMENTPROCESSOR C_BANKACCOUNT_ID CBANKACCOUNT_CPAYMTPROCESSOR C_PAYMENT_V C_BANKACCOUNT_ID Implied Constraint C_PAYSELECTION C_BANKACCOUNT_ID CBANKACCOUNT_CPAYSELECTION I_BANKSTATEMENT C_BANKACCOUNT_ID CBANKACCOUNT_IBANKSTATEMENT I_PAYMENT C_BANKACCOUNT_ID CBANKACCOUNT_IPAYMENT 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 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 C_BANK_ID number 10 C_BANK C_BANK_ID CBANK_CBANKACCOUNT C_CURRENCY_ID number 10 C_CURRENCY C_CURRENCY_ID CCURRENCY_CBANKACCOUNT BANKACCOUNTTYPE char 1 ACCOUNTNO nvarchar2 40 CURRENTBALANCE number 22 0 CREDITLIMIT number 22 0 ISDEFAULT char 1 'N' IBAN nvarchar2 80  √  null DESCRIPTION nvarchar2 510  √  null BBAN nvarchar2 80  √  null Table contained 2 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.