| Table a_processed_fee |
|
Description: Stores administrative fees and grants which have been calculated on gifts. |
| 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_cost_centre, a_accounting_period, a_gift_detail, a_gift_batch |
|
a_batch_number_i
integer NOT NULL | Number of the gift batch containing this detail. | a_gift_detail, a_gift_batch |
|
a_gift_transaction_number_i
integer NOT NULL | Identifies a gift transaction within a gift batch. | a_gift_detail |
|
a_detail_number_i
integer NOT NULL | Identifies a gift detail within a gift transaction. When a donor gives a donation to multiple recipients (a split gift), a gift detail record is created for each recipient. | a_gift_detail |
|
a_fee_code_c
varchar (16) NOT NULL | the fee which the calculated amounts are stored against. | |
|
a_cost_centre_code_c
varchar (24) NOT NULL | Cost centre code which the fee will be charged against. | a_cost_centre |
|
a_period_number_i
integer default: 0 NOT NULL | Period number | a_accounting_period |
|
a_periodic_amount_n
numeric (24, 10) default: 0 NOT NULL | Total Amount of the fee for the given period. | |
|
a_processed_date_d
date | Date ""admin fee calculations"" have been run to fee total has been created as a transaction in the general ledger. | |
|
s_timestamp_i
integer | System generated time stamp. | |
|
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_processed_fee_fk1: a_ledger_number_i;a_cost_centre_code_c => a_cost_centre a_processed_fee_fk2: a_ledger_number_i;a_period_number_i => a_accounting_period a_processed_fee_fk3: a_ledger_number_i;a_batch_number_i;a_gift_transaction_number_i;a_detail_number_i => a_gift_detail a_processed_fee_fk4: a_ledger_number_i;a_batch_number_i => a_gift_batch a_processed_fee_fkcr: s_created_by_c => s_user a_processed_fee_fkmd: s_modified_by_c => s_user | ||