Table openpetra_trunk.public.a_account
Details about each account code within a ledger. Also holds information on the summary account structure for reporting.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
a_ledger_number_i int4 10 0
a_account_hierarchy.a_ledger_number_i a_account_hierarchy_fk1 R
a_account_hierarchy_detail.a_ledger_number_i a_account_hierarchy_detail_fk2 R
a_account_property.a_ledger_number_i a_account_property_fk2 R
a_analysis_attribute.a_ledger_number_i a_analysis_attribute_fk1 R
a_ap_anal_attrib.a_ledger_number_i a_ap_anal_attrib_fk3 R
a_ap_document.a_ledger_number_i a_ap_document_fk3 R
a_ap_document_detail.a_ledger_number_i a_ap_document_detail_fk4 R
a_ap_payment.a_ledger_number_i a_ap_payment_fk3 R
a_budget.a_ledger_number_i a_budget_fk2 R
a_ep_account.a_ledger_number_i a_ep_account_fk3 R
a_ep_match.a_ledger_number_i a_ep_match_fk9 R
a_ep_payment.a_ledger_number_i a_ep_payment_fk3 R
a_ep_statement.a_ledger_number_i a_ep_statement_fk3 R
a_fees_payable.a_ledger_number_i a_fees_payable_fk2 R
a_fees_receivable.a_ledger_number_i a_fees_receivable_fk3 R
a_general_ledger_master.a_ledger_number_i a_general_ledger_master_fk1 R
a_gift_batch.a_ledger_number_i a_gift_batch_fk2 R
a_motivation_detail.a_ledger_number_i a_motivation_detail_fk2 R
a_previous_year_transaction.a_ledger_number_i a_previous_year_transaction_fk2 R
a_recurring_gift_batch.a_ledger_number_i a_recurring_gift_batch_fk2 R
a_recurring_trans_anal_attrib.a_ledger_number_i a_recurring_trans_anal_attr_fk2 R
a_recurring_transaction.a_ledger_number_i a_recurring_transaction_fk2 R
a_suspense_account.a_ledger_number_i a_suspence_account_fk1 R
a_this_year_old_transaction.a_ledger_number_i a_this_year_old_transaction_fk2 R
a_thisyearold_trans_anal_attrib.a_ledger_number_i a_thisyearold_tran_anal_attr_fk2 R
a_trans_anal_attrib.a_ledger_number_i a_trans_anal_attrib_fk2 R
a_transaction.a_ledger_number_i a_transaction_fk3 R
a_transaction_type.a_ledger_number_i a_transaction_type_fk1 R
a_ledger.a_ledger_number_i a_account_fk1 R
This is used as a key field in most of the accounting system files
a_account_code_c varchar 16
a_account_hierarchy.a_root_account_code_c a_account_hierarchy_fk1 R
a_account_hierarchy_detail.a_account_code_to_report_to_c a_account_hierarchy_detail_fk3 R
a_account_hierarchy_detail.a_reporting_account_code_c a_account_hierarchy_detail_fk2 R
a_account_property.a_account_code_c a_account_property_fk2 R
a_analysis_attribute.a_account_code_c a_analysis_attribute_fk1 R
a_ap_anal_attrib.a_account_code_c a_ap_anal_attrib_fk3 R
a_ap_document.a_ap_account_c a_ap_document_fk3 R
a_ap_document_detail.a_account_code_c a_ap_document_detail_fk4 R
a_ap_payment.a_bank_account_c a_ap_payment_fk3 R
a_budget.a_account_code_c a_budget_fk2 R
a_ep_account.a_account_code_c a_ep_account_fk3 R
a_ep_match.a_account_code_c a_ep_match_fk9 R
a_ep_payment.a_bank_account_c a_ep_payment_fk3 R
a_ep_statement.a_bank_account_code_c a_ep_statement_fk3 R
a_fees_payable.a_account_code_c a_fees_payable_fk2 R
a_fees_payable.a_dr_account_code_c a_fees_payable_fk3 R
a_fees_receivable.a_account_code_c a_fees_receivable_fk1 R
a_fees_receivable.a_dr_account_code_c a_fees_receivable_fk3 R
a_general_ledger_master.a_account_code_c a_general_ledger_master_fk1 R
a_gift_batch.a_bank_account_code_c a_gift_batch_fk2 R
a_motivation_detail.a_account_code_c a_motivation_detail_fk2 R
a_previous_year_transaction.a_account_code_c a_previous_year_transaction_fk2 R
a_recurring_gift_batch.a_bank_account_code_c a_recurring_gift_batch_fk2 R
a_recurring_trans_anal_attrib.a_account_code_c a_recurring_trans_anal_attr_fk2 R
a_recurring_transaction.a_account_code_c a_recurring_transaction_fk2 R
a_suspense_account.a_suspense_account_code_c a_suspence_account_fk1 R
a_this_year_old_transaction.a_account_code_c a_this_year_old_transaction_fk2 R
a_thisyearold_trans_anal_attrib.a_account_code_c a_thisyearold_tran_anal_attr_fk2 R
a_trans_anal_attrib.a_account_code_c a_trans_anal_attrib_fk2 R
a_transaction.a_account_code_c a_transaction_fk3 R
a_transaction_type.a_credit_account_code_c a_transaction_type_fk2 R
a_transaction_type.a_debit_account_code_c a_transaction_type_fk1 R
This identifies the account the financial transaction must be stored against
a_account_type_c varchar 20  √  null Income, Expense, Asset, Liability, Equity. Suspense accounts are in a_suspense_account.
a_account_code_long_desc_c varchar 160  √  null This is a long description and is 80 characters long.
a_account_code_short_desc_c varchar 64  √  null This is a short description which is 32 charcters long
a_eng_account_code_short_desc_c varchar 64  √  null This is a short description which is 32 charcters long
a_eng_account_code_long_desc_c varchar 160  √  null This is a long description and is 80 characters long.
a_debit_credit_indicator_l bool 1  √  true Defines if the the transcation is a debit or credit transaction
a_account_active_flag_l bool 1  √  true Defines whether the acount is active or not
a_analysis_attribute_flag_l bool 1  √  false Yes if the account has any analysis attributes.
a_standard_account_flag_l bool 1  √  false
a_consolidation_account_flag_l bool 1  √  false
a_intercompany_account_flag_l bool 1  √  false
a_budget_type_code_c varchar 16  √  null
a_budget_type.a_budget_type_code_c a_account_fk2 R
The type of budget. See the a_budget_type table.
a_posting_status_l bool 1  √  true
a_system_account_flag_l bool 1  √  false
a_budget_control_flag_l bool 1  √  false
a_valid_cc_combo_c varchar 16  √  'All'::character varying Which type of cost centres may be combined with this account.
a_foreign_currency_flag_l bool 1  √  false
a_foreign_currency_code_c varchar 16  √  null
a_currency.a_currency_code_c a_account_fk3 R
This defines which currency is being used
p_banking_details_key_i int4 10  √  null
p_banking_details.p_banking_details_key_i a_account_fk4 R
Link to banking details to use for this account - only really used if this account is a bank account
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c a_account_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c a_account_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 259 rows at Mi Nov 09 18:02 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
a_ledger_number_i + a_account_code_c Primary key Asc/Asc a_account_pk
a_ledger_number_i Performance Asc inx_a_account_fk1_key2
a_budget_type_code_c Performance Asc inx_a_account_fk2_key3
a_foreign_currency_code_c Performance Asc inx_a_account_fk3_key4
p_banking_details_key_i Performance Asc inx_a_account_fk4_key5
s_created_by_c Performance Asc inx_a_account_fkcr_key6
s_modified_by_c Performance Asc inx_a_account_fkmd_key7
a_ledger_number_i + a_account_code_c Must be unique Asc/Asc inx_a_account_pk1
a_ledger_number_i + a_account_code_c Performance Asc/Asc inx_a_ep_account_fk3_ref0

Close relationships  within of separation: