Table a_ep_statement

Description:
List of recently imported bank statements

PRIMARY KEY
a_statement_key_i integer NOT NULL	auto generated unique identifier for bank statements

a_bank_account_key_i integer	this is the bank account that this statement is for; this is necessary because you can have several accounts at the same bank	p_banking_details
a_ledger_number_i integer default: 0 NOT NULL	The four digit ledger number of the gift.	a_account
a_bank_account_code_c varchar (16)	The bank account for creating GL transactions against	a_account
a_date_d date default: CURRENT_DATE NOT NULL	The date of this statement
a_id_from_bank_c varchar (40)	This is the ID that the bank uses for this statement; it can be used to find the paper version of the bank statement
a_filename_c varchar (40)	This is the name of the file that this statement was read from; this can be used to prevent duplicate import of bank statements
a_start_balance_n numeric (24, 10)	The start balance of the bank account at the beginning of the statement
a_end_balance_n numeric (24, 10)	The end balance of the bank account after the statement
a_currency_code_c varchar (16) NOT NULL	This defines the currency of the transactions on this statement	a_currency
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 a_ep_statement_fk1: a_bank_account_key_i => p_banking_details a_ep_statement_fk2: a_currency_code_c => a_currency a_ep_statement_fk3: a_ledger_number_i;a_bank_account_code_c => a_account a_ep_statement_fkcr: s_created_by_c => s_user a_ep_statement_fkmd: s_modified_by_c => s_user
REFERENCED BY a_ep_transaction