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 | ||