Description:
Details about each account code within a ledger. Also holds information on the summary account structure for reporting.
|
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_ledger |
a_account_code_c
varchar (16) NOT NULL |
This identifies the account the financial transaction must be stored against
| |
|
a_account_type_c
varchar (20) |
Income, Expense, Asset, Liability, Equity. Suspense accounts are in a_suspense_account.
| |
a_account_code_long_desc_c
varchar (160) |
This is a long description and is 80 characters long.
| |
a_account_code_short_desc_c
varchar (64) |
This is a short description which is 32 charcters long
| |
a_eng_account_code_short_desc_c
varchar (64) |
This is a short description which is 32 charcters long
| |
a_eng_account_code_long_desc_c
varchar (160) |
This is a long description and is 80 characters long.
| |
a_debit_credit_indicator_l
boolean default: '1' |
Defines if the the transcation is a debit or credit transaction
| |
a_account_active_flag_l
boolean default: '1' |
Defines whether the acount is active or not
| |
a_analysis_attribute_flag_l
boolean default: '0' |
Yes if the account has any analysis attributes.
| |
a_standard_account_flag_l
boolean default: '0' |
| |
a_consolidation_account_flag_l
boolean default: '0' |
| |
a_intercompany_account_flag_l
boolean default: '0' |
| |
a_budget_type_code_c
varchar (16) |
The type of budget. See the a_budget_type table.
| a_budget_type |
a_posting_status_l
boolean default: '1' |
| |
a_system_account_flag_l
boolean default: '0' |
| |
a_budget_control_flag_l
boolean default: '0' |
| |
a_valid_cc_combo_c
varchar (16) default: 'All' |
Which type of cost centres may be combined with this account.
| |
a_foreign_currency_flag_l
boolean default: '0' |
| |
a_foreign_currency_code_c
varchar (16) |
This defines which currency is being used
| a_currency |
p_banking_details_key_i
integer |
Link to banking details to use for this account - only really used if this account is a bank account
| p_banking_details |
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_account_fk1: a_ledger_number_i => a_ledger
a_account_fk2: a_budget_type_code_c => a_budget_type
a_account_fk3: a_foreign_currency_code_c => a_currency
a_account_fk4: p_banking_details_key_i => p_banking_details
a_account_fkcr: s_created_by_c => s_user
a_account_fkmd: s_modified_by_c => s_user
|
REFERENCED BY a_ep_statement,
a_account_property,
a_account_hierarchy,
a_account_hierarchy_detail,
a_account_hierarchy_detail,
a_budget,
a_analysis_attribute,
a_fees_payable,
a_fees_payable,
a_fees_receivable,
a_fees_receivable,
a_general_ledger_master,
a_motivation_detail,
a_motivation_detail,
a_ep_account,
a_ep_match,
a_transaction_type,
a_transaction_type,
a_recurring_transaction,
a_recurring_trans_anal_attrib,
a_recurring_gift_batch,
a_gift_batch,
a_gift_detail,
a_gift_detail,
a_transaction,
a_trans_anal_attrib,
a_suspense_account,
a_ap_document,
a_ap_document_detail,
a_ap_payment,
a_ep_payment,
a_ap_anal_attrib |
|