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