Table a_fees_payable
Description:
Fees owed to another ledger. (e.g. admin grant)
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_account, a_account
a_fee_code_c
varchar (16) NOT NULL
Identifies a specific fee.

a_charge_option_c
varchar (40) NOT NULL
a_charge_percentage_n
numeric (5, 2) default: 0
a_charge_amount_n
numeric (24, 10) default: 0
This is a the max or min amount charged dependent on the charge option. The value is the number of currency units.
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_account_code_c
varchar (16) NOT NULL
This identifies the account the financial transaction must be stored against a_account
a_fee_description_c
varchar (48)
explain what this fee is for.
a_dr_account_code_c
varchar (16) NOT NULL
This identifies the account for the DR side of the financial transaction. a_account
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_fees_payable_fk1: a_ledger_number_i;a_cost_centre_code_c => a_cost_centre
a_fees_payable_fk2: a_ledger_number_i;a_account_code_c => a_account
a_fees_payable_fk3: a_ledger_number_i;a_dr_account_code_c => a_account
a_fees_payable_fkcr: s_created_by_c => s_user
a_fees_payable_fkmd: s_modified_by_c => s_user