| Table a_ich_stewardship |
|
Description: Contains the calculation for the stewardship for a particular run. Files and reports can be recreated from this. ICH = International Clearing House (Handles transfering of funds and admin grant fees among offices.) |
| 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_accounting_period, a_cost_centre |
|
a_period_number_i
integer default: 0 NOT NULL | This defines which accounting period is being used | a_accounting_period |
|
a_ich_number_i
integer default: 0 NOT NULL | identifes the ICH process number | |
|
a_cost_centre_code_c
varchar (24) NOT NULL | This identifies which cost centre an account is applied to. A cost centre can be a partner but reflected as a character rather than a numeric | a_cost_centre |
|
a_year_i
integer default: 0 NOT NULL | Accounting Year | |
|
a_date_processed_d
date NOT NULL | This is the date the stewardship was processed. | |
|
a_income_amount_n
numeric (24, 10) default: 0 | Income amount for foreign cost centre's stewardship | |
|
a_expense_amount_n
numeric (24, 10) default: 0 | Expense amount for foreign cost centre's stewardship | |
|
a_direct_xfer_amount_n
numeric (24, 10) default: 0 | Direct Transfer amount for foreign cost centre's stewardship | |
|
a_income_amount_intl_n
numeric (24, 10) default: 0 | Income amount for foreign cost centre's stewardship in International Currency | |
|
a_expense_amount_intl_n
numeric (24, 10) default: 0 | Expense amount for foreign cost centre's stewardship in international currency | |
|
a_direct_xfer_amount_intl_n
numeric (24, 10) default: 0 | Direct Transfer amount for foreign cost centre's stewardship in international 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_ich_stewardship_fk1: a_ledger_number_i;a_period_number_i => a_accounting_period a_ich_stewardship_fk2: a_ledger_number_i;a_cost_centre_code_c => a_cost_centre a_ich_stewardship_fkcr: s_created_by_c => s_user a_ich_stewardship_fkmd: s_modified_by_c => s_user | ||