Description:
the elements of the hierarchy of accounts; which account is reporting to which other account

PRIMARY KEY
a_ledger_number_i integer NOT NULL		a_account_hierarchy, a_account, a_account
a_account_hierarchy_code_c varchar (16) NOT NULL	The code for the hierarchy	a_account_hierarchy
a_reporting_account_code_c varchar (16) NOT NULL	The reporting account	a_account

a_account_code_to_report_to_c varchar (16) NOT NULL	This identifies the account the financial transaction must be stored against	a_account
a_report_order_i integer default: 0 NOT NULL	Order to display the account or heading on the Balance Sheet & Income Statement report.
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_hierarchy_detail_fk1: a_ledger_number_i;a_account_hierarchy_code_c => a_account_hierarchy a_account_hierarchy_detail_fk2: a_ledger_number_i;a_reporting_account_code_c => a_account a_account_hierarchy_detail_fk3: a_ledger_number_i;a_account_code_to_report_to_c => a_account a_account_hierarchy_detail_fkcr: s_created_by_c => s_user a_account_hierarchy_detail_fkmd: s_modified_by_c => s_user