Table a_recurring_journal
Description:
Templates of general ledger journals which are copied into the ledger with recurring 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_batch, a_transaction_type
a_batch_number_i
integer default: 0 NOT NULL
identifes which batch a transaction belongs to a_recurring_batch
a_journal_number_i
integer default: 0 NOT NULL
Identifies a journal within a batch

a_journal_description_c
varchar (160) NOT NULL
This is a long description and is 80 characters long.
a_journal_status_c
varchar (40) default: 'Unposted' NOT NULL
identifies the status of a batch
a_journal_debit_total_n
numeric (24, 10) default: 0 NOT NULL
This is a number of currency units
a_journal_credit_total_n
numeric (24, 10) default: 0 NOT NULL
This is a number of currency units
a_journal_period_i
integer default: 0
This defines which accounting period is being used
a_date_effective_d
date default: CURRENT_DATE NOT NULL
Date the batch comes into effect
a_transaction_type_code_c
varchar (16) NOT NULL
a_transaction_type
a_method_of_payment_code_c
varchar (16)
This is how the partner paid. Eg cash, Cheque etc a_method_of_payment
a_last_transaction_number_i
integer default: 0 NOT NULL
a_sub_system_code_c
varchar (24) NOT NULL
Defines a sub system of accounts a_transaction_type
a_exchange_rate_to_base_n
numeric (24, 10) default: 0 NOT NULL
The rate of exchange
a_transaction_currency_c
varchar (16) NOT NULL
This defines which currency is being used 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
This identifies the current version of the record.


FOREIGN KEY
a_recurring_journal_fk1: a_ledger_number_i;a_batch_number_i => a_recurring_batch
a_recurring_journal_fk2: a_ledger_number_i;a_sub_system_code_c;a_transaction_type_code_c => a_transaction_type
a_recurring_journal_fk3: a_method_of_payment_code_c => a_method_of_payment
a_recurring_journal_fk4: a_transaction_currency_c => a_currency
a_recurring_journal_fkcr: s_created_by_c => s_user
a_recurring_journal_fkmd: s_modified_by_c => s_user


REFERENCED BY
a_recurring_transaction, a_recurring_trans_anal_attrib