Income statement hierarchy levels

The GL data model uses the plhierarchy.csv file as input to build the income statement hierarchy. This file contains the hierarchy levels and their respective identification IDs called objectid for income statement 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 to suit your company's income statement hierarchy and then uploaded to the Raw Source space.

This table shows the default hierarchy in the plhierarchy.csv file.
Hierarchy Company Descriptions ObjectID ParentID AccountType LevelReportCode SortOrder
1 1 Net Profit / (Loss) 0000PIEGAAP PL Inc_Net_Prof_Los 99
2 1 Gross Profit 0001PIEGAAP 0000PIEGAAP PL Inc_Gros_Prof 99
3 1 Invoices 00100PIEGAAP 0001PIEGAAP I Inc_revenue 99
4 1 Sales 00110PIEGAAP 00100PIEGAAP I Inc_revenue 0
5 1 Cost of Goods Sold 00111PIEGAAP 00100PIEGAAP E Inc_COGS 1
6 1 Special Customer Rebates 00101PEGAAP 0001PIEGAAP E Inc_Rebate 99
7 1 Manual Special Customer Rebates 00102PEGAAP 0001PIEGAAP E Inc_Rebate 99
8 1 Rebated Due to Customers 00103PEGAAP 0001PIEGAAP E Inc_Rebate 99
9 1 Margin Variance 00104PEGAAP 0001PIEGAAP E Inc_Margin_Variance 99
10 1 Days Worked 011040PEGAAP 00104PEGAAP E Inc_Margin_Variance 99
11 1 AP Cost Adjustments 11041PEGAAP 011040PEGAAP E Inc_Margin_Variance 99
12 1 Inventory Adjustments 11042PEGAAP 011040PEGAAP E Inc_Margin_Variance 99
13 1 PO Closeouts 11043PEGAAP 011040PEGAAP E Inc_Margin_Variance 99
14 1 Non Stock Adjustments 11044PEGAAP 011040PEGAAP E Inc_Margin_Variance 99
15 1 Customer Pricing ADj 11045PEGAAP 011040PEGAAP E Inc_Margin_Variance 99
16 1 Scrap Proceeds 11046PEGAAP 011040PEGAAP E Inc_Margin_Variance 99
17 1 Inv Discrepancy No Response-Owned 11047PEGAAP 011040PEGAAP E Inc_Margin_Variance 99
18 1 Inv Discrepancy No Response-NS 11048PEGAAP 011040PEGAAP E Inc_Margin_Variance 99
19 1 Invoices Paid, No PO 11049PEGAAP 011040PEGAAP E Inc_Margin_Variance 99
20 1 Other Days Work Adjustments 110410PEGAAP 011040PEGAAP E Inc_Margin_Variance 99
21 1 Non Days Worked 011050PEGAAP 011040PEGAAP E Inc_Margin_Variance 99
22 1 Consigned Freight 11051PEGAAP 011050PEGAAP E Inc_Margin_Variance 99
23 1 Other Freight on Invoices 11052PEGAAP 011050PEGAAP E Inc_Margin_Variance 99
24 1 Freight In - FMS 11053PEGAAP 011050PEGAAP E Inc_Margin_Variance 99
25 1 Pallet Charges 11054PEGAAP 011050PEGAAP E Inc_Margin_Variance 99
26 1 Restocking Charges 11055PEGAAP 011050PEGAAP E Inc_Margin_Variance 99
27 1 PO Closeouts - Prior Year 11056PEGAAP 011050PEGAAP E Inc_Margin_Variance 99
28 1 Corp Approved Write Offs 11057PEGAAP 011050PEGAAP E Inc_Margin_Variance 99
29 1 Other 11058PEGAAP 011050PEGAAP E Inc_Margin_Variance 99
30 1 Consigned Cost Adjustments 11059PEGAAP 011050PEGAAP E Inc_Margin_Variance 99
31 1 Physical Inventory Adj 110510PEGAAP 011050PEGAAP E Inc_Margin_Variance 99
32 1 Margin Variance Reserve 110511PEGAAP 011050PEGAAP E Inc_Margin_Variance 99
33 1 LIFO Reserve 110512PEGAAP 011050PEGAAP E Inc_Margin_Variance 99
34 1 Operating Expenses 0002PEGAAP 0000PIEGAAP OE Inc_Operating_Exp 99
35 1 Salaries 0020PEGAAP 0002PEGAAP OE Inc_Sal 99
36 1 Salaries - Sales 0200PEGAAP 0020PEGAAP OE Inc_Sal 99
37 1 Sales Bonus Accr/Commission 0201PEGAAP 0020PEGAAP OE Inc_Sal 99
38 1 Allocated Outside Sales Exp 0202PEGAAP 0020PEGAAP OE Inc_Sal 99
39 1 Salaries - Branch Manager 0203PEGAAP 0020PEGAAP OE Inc_Sal 99
40 1 Branch Manager Bonus 0204PEGAAP 0020PEGAAP OE Inc_Sal 99
41 1 Salaries - BOM 0205PEGAAP 0020PEGAAP OE Inc_Sal 99
42 1 Inside Sales - Office 0206PEGAAP 0020PEGAAP OE Inc_Sal 99
43 1 Salaries - Clerical 0207PEGAAP 0020PEGAAP OE Inc_Sal 99
44 1 Warehouse - Hourly 0208PEGAAP 0020PEGAAP OE Inc_Sal 99
45 1 Salaries - Warehouse Manager 0209PEGAAP 0020PEGAAP OE Inc_Sal 99
46 1 Sick Pay Expense 02010PEGAAP 0020PEGAAP OE Inc_Sal 99
47 1 Christmas Bonue Accrual 02011PEGAAP 0020PEGAAP OE Inc_Sal 99
48 1 BOM Bonue Accrual 02012PEGAAP 0020PEGAAP OE Inc_Sal 99
49 1 Inside Sales - Incentives 02013PEGAAP 0020PEGAAP OE Inc_Sal 99
50 1 Inside Sales Commissions 02014PEGAAP 0020PEGAAP OE Inc_Sal 99
51 1 Other Branch Bonus 02015PEGAAP 0020PEGAAP OE Inc_Sal 99
52 1 Office/Warehouse - OT 0030PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
53 1 Temporary Warehouse Labor 0040PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
54 1 Other Associate Expenses 0050PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
55 1 Heathcare Expenses 0500PEGAAP 0500PEGAAP OE Inc_Operating_Exp 99
56 1 Healthcare Claims 5000PEGAAP 0500PEGAAP OE Inc_Operating_Exp 99
57 1 HSA Contribution 5001PEGAAP 0500PEGAAP OE Inc_Operating_Exp 9
58 1 HSA-Fees 5002PEGAAP 0500PEGAAP OE Inc_Operating_Exp 99
59 1 Other 5003PEGAAP 0500PEGAAP OE Inc_Operating_Exp 99
60 1 PR Deductions 5004PEGAAP 0500PEGAAP OE Inc_Operating_Exp 99
61 1 Other Associate Benefits 06000PEGAAP 0500PEGAAP OE Inc_Operating_Exp 99
62 1 Temp to Hire Salary Expense 6000PEGAAP 06000PEGAAP OE Inc_Operating_Exp 99
63 1 Other Taxable Comp/Fringe Benefits 6001PEGAAP 06000PEGAAP OE Inc_Operating_Exp 99
64 1 401 (K) Company Contribution 6002PEGAAP 06000PEGAAP OE Inc_Operating_Exp 99
65 1 FICA Taxes - Employer 6003PEGAAP 06000PEGAAP OE Inc_Operating_Exp 99
66 1 Federal Unemployment Taxes 6004PEGAAP 06000PEGAAP OE Inc_Operating_Exp 99
67 1 State Unemployment Taxes 6005PEGAAP 06000PEGAAP OE Inc_Operating_Exp 99
68 1 Employee Moving Expense 6006PEGAAP 06000PEGAAP OE Inc_Operating_Exp 99
69 1 Employee Training 6007PEGAAP 06000PEGAAP OE Inc_Operating_Exp 99
70 1 Regional Training Expense 6008PEGAAP 06000PEGAAP OE Inc_Operating_Exp 99
71 1 Employee Tuition Reimbursement 6009PEGAAP 06000PEGAAP OE Inc_Operating_Exp 99
72 1 On-Premise Meals 600010PEGAAP 06000PEGAAP OE Inc_Operating_Exp 99
73 1 Employement Fees 600011PEGAAP 06000PEGAAP OE Inc_Operating_Exp 99
74 1 Drug Screen/HR Fees/DOT Comp 600012PEGAAP 06000PEGAAP OE Inc_Operating_Exp 99
75 1 Outside Sales Expense 0060PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
76 1 Travel and Lodging 0600PEGAAP 0060PEGAAP OE Inc_Operating_Exp 99
77 1 Meals and Entertainment 0601PEGAAP 0060PEGAAP OE Inc_Operating_Exp 99
78 1 Auto Rent 0602PEGAAP 0060PEGAAP OE Inc_Operating_Exp 99
79 1 Auto Maintenance / Repairs 0603PEGAAP 0060PEGAAP OE Inc_Operating_Exp 99
80 1 Auto Fuel 0604PEGAAP 0060PEGAAP OE Inc_Operating_Exp 99
81 1 Sales Incentive Trip Expense 0070PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
82 1 Sales Meeting Expense 0080PEEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
83 1 Other Selling Expense 090PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
84 1 Mobile Communication - Sales 0900PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
85 1 Drivers Cell Phones 0901PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
86 1 Advertising Expense 0902PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
87 1 Customer Complaints 0903PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
88 1 Window Complaints 0904PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
89 1 Promotional Items 0905PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
90 1 New Customer Promotions 0906PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
91 1 Newsletters / Flyers / Brochures 0907PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
92 1 Dues and Subscriptions - Sales 0908PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
93 1 Customer Hospitality / Gifts 0909PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
94 1 Invoice / PO Forms 090010PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
95 1 Customer Appreciation / Rec 090011PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
96 1 Miscellaneous Selling Expense 090012PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
97 1 Measure & Install Labor Expense 090013PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
98 1 Window Samples / Material Exp 090014PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
99 1 Other Samples 090015PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
100 1 Uncollected Vendor Cr Memos 090016PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
101 1 C/T Window Co-Op 090017PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
102 1 Credit Card Fees 090018PEGAAP 0090PEGAAP OE Inc_Operating_Exp 99
103 1 Professional Fees 00100PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
104 1 Office Expenses 0110PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
105 1 Janitorial Expense 01100PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
106 1 Postage Expense 01101PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
107 1 Bank Service Charge 01102PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
108 1 Printing, Stationery & Supplies 01103PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
109 1 Want Ads Non-Sales Positions 01104PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
110 1 Landscaping 01105PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
111 1 Pest Control 01106PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
112 1 Temporary Office Labor 01107PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
113 1 Heat, Lights, and Water 01108PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
114 1 Dues and Subscriptions 01109PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
115 1 Charitable Contributions 0110010PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
116 1 Svc & Maintenance Contracts 0110011PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
117 1 Miscellaneous Expense 0110012PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
118 1 Cash Over / Short 0110013PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
119 1 Joint Pay Account 0110014PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
120 1 401 (K) Administrative Expense 0110015PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
121 1 Data Communications Lines 0110016PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
122 1 Small Computer Equipments 0110017PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
123 1 IT Supplies Expense 0110018PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
124 1 IT Hardware / Software Support 0110019PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
125 1 IT TWL Hardware/Software 0110020PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
126 1 IT TWL Licenses INFOR 0110021PEGAAP 0110PEGAAP OE Inc_Operating_Exp 99
127 1 Warehouse Expenses 00120PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
128 1 Trash Removal Expense 01201PEGAAP 00120PEGAAP OE Inc_Operating_Exp 99
129 1 Rent Forklifts 01202PEGAAP 00120PEGAAP OE Inc_Operating_Exp 99
130 1 Repairs Forklift 01203PEGAAP 00120PEGAAP OE Inc_Operating_Exp 99
131 1 Workman's Comp Claims 01204PEGAAP 00120PEGAAP OE Inc_Operating_Exp 99
132 1 Security Expense 01205PEGAAP 00120PEGAAP OE Inc_Operating_Exp 99
133 1 Uniforms Expense 01206PEGAAP 00120PEGAAP OE Inc_Operating_Exp 99
134 1 Warehouse Supplies Other 01207PEGAAP 00120PEGAAP OE Inc_Operating_Exp 99
135 1 Propane 01208PEGAAP 00120PEGAAP OE Inc_Operating_Exp 99
136 1 Packaging/Shipping Supplies 01209PEGAAP 00120PEGAAP OE Inc_Operating_Exp 99
137 1 Small Warehouse Equip & Tools 0120110PEGAAP 0010PEEGAPA OE Inc_Operating_Exp 99
138 1 Warehouse Safety Supplies 0120111PEGAAP 00120PEGAAP OE Inc_Operating_Exp 99
139 1 Warehouse Cleaning Supplies 0120112PEGAAP 00120PEGAAP OE Inc_Operating_Exp 99
140 1 Warehouse Want Ads 0120113PEGAAP 00120PEGAAP OE Inc_Operating_Exp 99
141 1 Warehouse Move / Renovation 0120114PEGAAP 00120PEGAAP OE Inc_Operating_Exp 99
142 1 Freight Out Expenses 00130PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
143 1 Freight - Branch Transfer 01301PEGAAP 00130PEGAAP OE Inc_Operating_Exp 99
144 1 Excess Freight Charge 01302PEGAAP 00130PEGAAP OE Inc_Operating_Exp 99
145 1 CC Customer Delivery 01303PEGAAP 00130PEGAAP OE Inc_Operating_Exp 99
146 1 Freight Accrual 01304PEGAAP 00130PEGAAP OE Inc_Operating_Exp 99
147 1 Freight Management Fees 01305PEGAAP 00130PEGAAP OE Inc_Operating_Exp 99
148 1 Customer Freight Income 01306PEGAAP 00130PEGAAP OE Inc_Operating_Exp 99
149 1 Stop-Over Charge 01307PEGAAP 00130PEGAAP OE Inc_Operating_Exp 99
150 1 Inventory Transfer Handling Chg 01308PEGAAP 00130PEGAAP OE Inc_Operating_Exp 99
151 1 Loop Truck Expenses - Washington 01309PEGAAP 00130PEGAAP OE Inc_Operating_Exp 99
152 1 Loop Truck Expenses - Memphis 0130110PEGAAP 00130PEGAAP OE Inc_Operating_Exp 99
153 1 Loop Truck Expenses - Columbia 0130111PEGAAP 00130PEGAAP OE Inc_Operating_Exp 99
154 1 Loop Truck Expenses - Richmond 0130112PEGAAP 00130PEGAAP OE Inc_Operating_Exp 99
155 1 Loop Truck Expenses - Atlanta 0130113PEGAAP 00130PEGAAP OE Inc_Operating_Exp 99
156 1 Loop Turck Expenses - Louisville 0130114PEGAAP 00130PEGAAP OE Inc_Operating_Exp 99
157 1 Loop Truck Expenses - Tampa 0130115PEGAAP 00130PEGAAP OE Inc_Operating_Exp 99
158 1 Truck Expenses 001440PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
159 1 Rent - Trucks 01401PEGAAP 00140PEGAAP OE Inc_Operating_Exp 99
160 1 Fuel - Trucks 01402PEGAAP 00140PEGAAP OE Inc_Operating_Exp 99
161 1 Repairs / Maintenance - Trucks 01403PEGP 00140PEGAAP O Inc_Operating_Exp 99
162 1 Depreciation / Amortization 00150PEGAAP 0002PEGAAP OE Inc_Depreciation 99
163 1 Rent - Office Equipment 00160PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
164 1 Rent - Building 00170PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
165 1 Telephone Expense 00180PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
166 1 Local Taxes & Licenses 00190PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
167 1 Repairs - Building / Other 200PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
168 1 Bad Debt Expense 201PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
169 1 Business Insurance 202PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
170 1 Credit & Collection Expense 203PEGAAP 0002PEGAAP OE Inc_Operating_Exp 99
171 1 Non-Operating Income / (Expense) 0003PIEGAAP 0000PIEGAAP PL Inc_Non-Oper_Exp 99
172 1 Service Charge Income 00030PIGAAP 0003PIEGAAP I Inc_Non-Oper_Exp 99
173 1 Waived Customer Service Chg 00031PEGAAP 0003PIEGAAP E Inc_Non-Oper_Exp 99
174 1 Interest Expense 00032PEGAAP 0003PIEGAAP E Inc_Interest 99
175 1 Delivery/Pickup Income 000033PIGAAP 0003PIEGAAP I Inc_Non-Oper_Exp 99
176 1 Transfer Charge Income 00034PIGAAP 0003PIEGAAP E Inc_Non-Oper_Exp 99
177 1 Other - Non Operating Inc / (Exp> 0035PIEGAAP 0003PIEGAAP PL Inc_Non-Oper_Exp 99
178 1 Customer Discounts Taken 00350PEGAAP 00035PIEGAAP E Inc_Non-Oper_Exp 99
179 1 Gain/(Loss) Fixed Assets 0351PEGAAP 00035PIEGAAP E Inc_Non-Oper_Exp 99
180 1 Miscelaneous Income 00352PAAP 00035PIEGAP I Inc_Non-Oper_Exp 99
181 1 Sales Tax Discounts 00352PIGAAP 00035PIEGAAP E Inc_Non-Oper_Exp 99
182 1 Net Income Before Admin Exp 0004PIEGAAP 0000PIEGAAP PL Inc_Net_Inc_Before_Exp 99
183 1 Admin 00040PEGAAP 0004PIEGAAP E Inc_Net_Inc_Before_Exp 99
184 1 Restructure Expenses 00041PEGAAP 0004PIEGAAP E Inc_Net_Inc_Before_Exp 99
185 1 Vendor Incenctives 00042PEGAAP 0004PIEGAAP PL Inc_Net_Inc_Before_Exp 99