| Table p_banking_details | 
| 
Description: Any bank details for a partner can be stored in this table  | 
| PRIMARY KEY | ||
| 
p_banking_details_key_i
 
integer NOT NULL  | A sequence key for the banking details. | |
| 
p_banking_type_i
 
integer NOT NULL  | The type of banking: BANK ACCOUNT, CREDIT CARD, etc. | p_banking_type | 
| 
p_account_name_c
 
varchar (160)  | The full name used for authorizing a transaction with this banking entity. | |
| 
p_title_c
 
varchar (64)  | ||
| 
p_first_name_c
 
varchar (64)  | ||
| 
p_middle_name_c
 
varchar (64)  | ||
| 
p_last_name_c
 
varchar (64)  | ||
| 
p_bank_key_n
 
bigint NOT NULL  | Link to p_bank to see what details the bank has. | p_bank | 
| 
p_bank_account_number_c
 
varchar (40)  | The account number in the bank | |
| 
p_iban_c
 
varchar (128)  | The IBAN (International Bank Account Number). IBAN is a standardised international format for entering account details which consists of the country code, the local bank code, the (payee) account number and a control number. | |
| 
p_security_code_c
 
varchar (24)  | Credit Card Security Code | |
| 
p_valid_from_date_d
 
date  | When the credit card is valid from | |
| 
p_expiry_date_d
 
date  | When this expires | |
| 
p_comment_c
 
varchar (510)  | This is the finance details comment. | |
| 
s_date_created_d
 
date default: CURRENT_DATE  | The date the record was created. | |
| 
s_created_by_c
 
varchar (20)  | User ID of who created this record. | s_user | 
| 
s_date_modified_d
 
date  | The date the record was modified. | |
| 
s_modified_by_c
 
varchar (20)  | User ID of who last modified this record. | s_user | 
| 
s_modification_id_t
 
timestamp default: CURRENT_TIMESTAMP  | This identifies the current version of the record. | |
FOREIGN KEY p_banking_details_fk3: p_banking_type_i => p_banking_type p_banking_details_fk4: p_bank_key_n => p_bank p_banking_details_fkcr: s_created_by_c => s_user p_banking_details_fkmd: s_modified_by_c => s_user  | ||
REFERENCED BY p_partner_banking_details, p_banking_details_usage, a_account, a_ep_statement, a_ep_account  | ||