Table a_transaction

Description:
Detailed information for each debit and credit in a general ledger journal.

PRIMARY KEY
a_ledger_number_i integer default: 0 NOT NULL	This is used as a key field in most of the accounting system files	a_journal, a_batch, a_account, a_cost_centre
a_batch_number_i integer default: 0 NOT NULL	identifes which batch a transaction belongs to	a_journal, a_batch
a_journal_number_i integer default: 0 NOT NULL		a_journal
a_transaction_number_i integer default: 0 NOT NULL	Identifies a transaction within a journal within a batch within a ledger

a_account_code_c varchar (16) NOT NULL	This identifies the account the financial transaction must be stored against	a_account
a_primary_account_code_c varchar (16)	This identifies the account the financial transaction must be stored against [NOT USED]
a_cost_centre_code_c varchar (24) NOT NULL	This identifies which cost centre an account is applied to	a_cost_centre
a_primary_cost_centre_code_c varchar (24)	This identifies which cost centre an account is applied to [NOT USED]
a_transaction_date_d date default: CURRENT_DATE NOT NULL	Date the transaction took place
a_transaction_amount_n numeric (24, 10) default: 0 NOT NULL	This is a number of currency units
a_amount_in_base_currency_n numeric (24, 10) default: 0 NOT NULL	This is a number of currency units
a_analysis_indicator_l boolean default: '0' NOT NULL	Used to get a yes no response from the user
a_reconciled_status_l boolean default: '0' NOT NULL	shows if the transaction has been reconciled or not
a_narrative_c varchar (500)
a_debit_credit_indicator_l boolean default: '1' NOT NULL
a_transaction_status_l boolean default: '0'	Has a transaction been posted yet
a_header_number_i integer default: 0	The header (eg, cashbook #) that the transaction is associated with. [NOT USED]
a_detail_number_i integer default: 0	The detail (within the header) that the transaction is associated with. [NOT USED]
a_sub_type_c varchar (16)
a_to_ilt_flag_l boolean default: '0'	Indicates whether the ILT transaction has been transferred to transaction for ILT file.
a_source_flag_l boolean default: '0'	To flag a transaction as having come from a source ledger and been processed in an ilt processing centre
a_reference_c varchar (100) NOT NULL	Reference number/code for the transaction
a_source_reference_c varchar (100)	Transaction key which initiated an ILT transaction
a_system_generated_l boolean default: '0'	Was this transaction generated automatically by the system?
a_amount_in_intl_currency_n numeric (24, 10) default: 0	The transaction amount in the second base currency.
a_ich_number_i integer default: 0 NOT NULL	identifes the ICH process number
a_key_ministry_key_n bigint	Key ministry to which this transaction applies (just for fund transfers)	p_unit
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_transaction_fk1: a_ledger_number_i;a_batch_number_i;a_journal_number_i => a_journal a_transaction_fk2: a_ledger_number_i;a_batch_number_i => a_batch a_transaction_fk3: a_ledger_number_i;a_account_code_c => a_account a_transaction_fk4: a_ledger_number_i;a_cost_centre_code_c => a_cost_centre a_transaction_fk5: a_key_ministry_key_n => p_unit a_transaction_fkcr: s_created_by_c => s_user a_transaction_fkmd: s_modified_by_c => s_user
REFERENCED BY a_trans_anal_attrib