Table a_recurring_transaction
Description:
Templates of general ledger transactions which are copied into the ledger with general ledger batches.
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_recurring_journal, a_account, a_cost_centre, a_recurring_batch
a_batch_number_i
integer default: 0 NOT NULL
identifes which batch a transaction belongs to a_recurring_journal, a_recurring_batch
a_journal_number_i
integer default: 0 NOT NULL
Journal number that transaction belongs to a_recurring_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_cost_centre_code_c
varchar (24) NOT NULL
This identifies which cost centre an account is applied to a_cost_centre
a_transaction_date_d
date default: CURRENT_DATE NOT NULL
Date the transaction took place
a_transaction_currency_c
varchar (16)
This defines which currency is being used a_currency
a_transaction_amount_n
numeric (24, 10) default: 0 NOT NULL
This is a number of currency units
a_base_currency_c
varchar (16)
This defines which currency is being used a_currency
a_exchange_rate_to_base_n
numeric (24, 10) default: 0
The rate of exchange
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
a_method_of_payment_code_c
varchar (16)
a_method_of_payment
a_period_number_i
integer default: 0
This defines which accounting period is being used
a_reconciled_flag_l
boolean default: '0' NOT NULL
Shows if the transaction has been reconciled or not
a_sub_system_code_c
varchar (24)
Defines a sub system of accounts
a_transaction_type_code_c
varchar (16)
a_narrative_c
varchar (240)
a_reference_c
varchar (16) NOT NULL
a_date_of_entry_d
date
s_user_id_c
varchar (20)
s_user
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.
a_detail_number_i
integer default: 0
The detail (within the header) that the transaction is associated with.
a_sub_type_c
varchar (16)
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_recurring_transaction_fk1: a_ledger_number_i;a_batch_number_i;a_journal_number_i => a_recurring_journal
a_recurring_transaction_fk2: a_ledger_number_i;a_account_code_c => a_account
a_recurring_transaction_fk3: a_ledger_number_i;a_cost_centre_code_c => a_cost_centre
a_recurring_transaction_fk4: a_transaction_currency_c => a_currency
a_recurring_transaction_fk5: a_base_currency_c => a_currency
a_recurring_transaction_fk6: a_method_of_payment_code_c => a_method_of_payment
a_recurring_transaction_fk7: s_user_id_c => s_user
a_recurring_transaction_fk8: a_ledger_number_i;a_batch_number_i => a_recurring_batch
a_recurring_transaction_fkcr: s_created_by_c => s_user
a_recurring_transaction_fkmd: s_modified_by_c => s_user


REFERENCED BY
a_recurring_trans_anal_attrib