Table p_banking_details
Diagram AccountsPayable 
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