Balance sheet hierarchy levels

The GL data model uses the glsahierarchy.csv file as input to build the balance sheet hierarchy. This file contains the hierarchy levels and their respective identification IDs called ObjectID for balance sheet elements. The default file format is downloaded from the Infor Distribution Analytics General Ledger Account Mapping File Download dashboard. The hierarchy levels can be modified in a spreadsheet application, such as Excel, to suit your company's balance sheet hierarchy and then uploaded to the Raw Source space.

The ObjectID should be unique for each entry in the map. The ParentID is the level under which one or more ObjectIDs fall under. For example, you may have an Assets account, under which you have Current Assets and Fixed Assets accounts. Each account has its own Object ID, but Current Assets and Fixed Assets share the same ParentID, which is the Assets ObjectID.

This table shows the default hierarchy in the glsahierarchy.csv file. In this table, Assets has an ObjectID of 0010BAGAAP and it is the parent level in the hierarchy for Current Assets and Fixed Assets.
Hierarchy Company Description ObjectID ParentID AccountType LevelReportCode SortOrder
1 1 GAAP Balances 0000BBGAAP G Bal_Gaap_Bal 99
2 1 Assets 0010BAGAAP 0000BBGAAP A Bal_Assets 99
3 1 Current Assets K008GAAP 0010BAGAAP A Bal_Cur_Asst 99
4 1 Cash K009GAAP K008GAAP A Bal_Cash 1
5 1 Accounts Receivable 0080BAGAAP K008GAAP A Bal_AR 2
6 1 Accounts Receivable - Trade 0100BAGAAP 0080BAGAAP A Bal_AR-Trade 99
7 1 Less: A/R Reserve 0110BAGAAP 0080BAGAAP A Bal_AR_Reserve 99
8 1 Other Receivables 0240BAGAAP 0080BAGAAP A Bal_Oth_AR 99
9 1 Inventory K044GAAP K008GAAP A Bal_Inventory 3
10 1 Inventory In Transit K046GAAP K044GAAP A Bal_Inventory_In_Transit 99
11 1 Other Inventory K045GAAP K044GAAP A Bal_Oth_Inventory 99
12 1 Cores 0140BAGAAP K044GAAP A Bal_Cores 99
13 1 Inventory (Raw Materials and Production Supply) 0150BAGAAP K044GAAP A Bal_Inventory 99
14 1 LIFO Reserve 0160BAGAAP K044GAAP A Bal_Inventory_LIFO 99
16 1 Prepaid Expenses K010GAAP K008GAAP A Bal_Prepaid_Exp 99
17 1 Fixed Assets 0260BAGAAP 0010BAGAAP A Bal_Fix_Asst 99
18 1 Furniture & Equipment 0270BAGAAP 0260BAGAAP A Bal_Fix_Asst 99
19 1 Auto & Trucks 0280BAGAAP 0260BAGAAP A Bal_Fix_Asst 99
20 1 Leasehold Improvements 0290BAGAAP 0260BAGAAP A Bal_Fix_Asst 99
21 1 Software 0340BAGAAP 0260BAGAAP A Bal_Fix_Asst 99
22 1 Other Fixed Assets 0370BAGAAP 0260BAGAAP A Bal_Fix_Asst_Oth 99
23 1 Accumulated Depreciation 0390BAGAAP 0260BAGAAP A Bal_Fix_Asst 99
24 1 Other Assets 0430BAGAAP 0010BAGAAP A Bal_Oth_Asst 99
25 1 Due From Shareholders 0570BAGAAP 0430BAGAAP A Bal_Oth_Asst 99
26 1 Cash Surrender Value Life Insurance 0610BAGAAP 0430BAGAAP A Bal_Oth_Asst 99
27 1 Goodwill 0670BAGAAP 0430BAGAAP A Bal_Oth_Asst 99
28 1 Other 0710BAGAAP 0430BAGAAP A Bal_Oth_Asst 99
29 1 Liabilities & Stockholder Equity 0000BLSGAAP 0000BBGAAP LS Bal_Liablty_Eqty 99
30 1 Liabilities 0010BLGAAP 0000BLSGAAP L Bal_Liablty 99
31 1 Current Liabilities K014GAAP 0010BLGAAP L Bal_Cur_Liablty 99
32 1 Accounts Payable 0050BLGAAP K014GAAP L Bal_Acct_Payable 99
33 1 Cores Due 0051BLGAAP 0050BLGAAP L Bal_Core_Due 99
34 1 Accrued Payables 0060BLGAAP K014GAAP L Bal_Acct_Payable 99
35 1 PR Withholdings 0090BLGAAP K014GAAP L Bal_Acct_Payable 99
36 1 Notes Payable 0200BLGAAP K014GAAP L Bal_Acct_Payable 99
37 1 Long Term Liabilities K013GAAP 0010BLGAAP L Bal_Lng_Trm_Liablty 99
38 1 Notes Payable 0200BLGAAP K014GAAP L Bal_Lng_Trm_Liablty 99
39 1 Suntrust LOC 0230BLGAAP K013GAAP L Bal_Lng_Trm_Liablty 99
40 1 Wachovia LOC 0240BLGAAP K013GAAP L Bal_Lng_Trm_Liablty 99
41 1 Other 0250BLGAAP K013GAAP L Bal_Lng_Trm_Liablty 99
42 1 Stockholders Equity K011GAAP 0000BLSGAAP SE Bal_StckHldr_Eqty 99
43 1 Stockholders Equity 0370BLGAAP K011GAAP SE Bal_StckHldr_Eqty 99
44 1 Common Stock and APIC 0410BLGAAP 0370BLGAAP SE Bal_StckHldr_Eqty 99
45 1 Dividends Paid 0190BLGAAP 0370BLGAAP SE Bal_StckHldr_Eqty 99
46 1 Current Retained Earnings 0420BLGAAP 0370BLGAAP SE Bal_StckHldr_Eqty 99
47 1 Other Comprehensive Income 0430BLGAAP 0370BLGAAP SE Bal_StckHldr_Eqty 99
48 1 Retained Earnings K043GAAP 0370BLGAAP SE Bal_StckHldr_Eqty 99