Table a_account
Diagram AccountsPayable 
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