Table: bank_account

Previous: attachment Unanet Data Model Next: bank_reconciliation
Columns
  Column Name Data Type Default
Value		 References
Table		 Foreign Key
Name
1. PK bank_account_key decimal(15)      
2.   name varchar(25)      
3.   type char(1)      
4.   bank_name varchar(50)      
5.   bank_account_number varchar(30)      
6.   bank_routing_number varchar(9)      
7.   account_key decimal(15)   account fk_bank_account1
8.   customer_key decimal(15)   customer fk_bank_account2
9.   checking_account char(1)      
10.   last_check_number_used int      
11.   attachment_key decimal(15)   attachment fk_bank_account3
12.   active char(1)      
Foreign Keys
Column References Foreign Key Name
Table Column
account_key account account_key fk_bank_account1
attachment_key attachment attachment_key fk_bank_account3
customer_key customer customer_key fk_bank_account2
Referenced from
Table Column Foreign Key Name
bank_reconciliation bank_account_key fk_bank_rec2
check_print_history bank_account_key fk_check_print_history2
customer_payment bank_account_key fk_customer_payment4
deposit bank_account_key fk_deposit2
vendor_payment bank_account_key fk_vendor_payment3
Check Constraints
Name Definition
cc_ba_checking_account ([checking_account]='N' OR [checking_account]='Y')
cc_bank_account_active ([active]='N' OR [active]='Y')
cc_bank_account_type ([type]='O' OR [type]='U' OR [type]='B')
Indices
Index Name Unique Column Name Asc Or Desc
pk_bank_account true bank_account_key Asc
idx_bank_account1 true name Asc
idx_bank_account2 false account_key Asc
idx_bank_account3 false customer_key Asc