| 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 default: CURRENT_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 | ||