Line |
Field Name |
Data Type |
Description |
1 |
str:chartOfAccounts |
Table |
Chart of accounts information by general ledger account. |
2 |
term:accountSubtype |
Term (Text/String) |
Grouping for lower-level categories on the financial statements. Examples include reserve account, suspense account, intercompany account, and so on. |
3 |
term:accountType |
Term (Text/String) |
Grouping for high-level category on the financial statements. Values should be assets, liabilities, equity, revenue, expenses, and so on. |
4 |
term:businessUnitCode |
Term (Text/String) |
Used to identify the business unit, region, branch, and so on at the level that financial statements are being audited and for which the trial balance is generated. For example, you may use a code aligned with the concept of a reportable segment as defined in FASB Accounting Standards Codification (ASC) 280, Segment Reporting. |
5 |
term:fsCaption |
Term (Text/String) |
Financial statement caption. Grouping for the caption the GL account rolls up to on the financial statements (for example, cash and cash equivalents, accounts payable, cost of sales, and so on). Sometimes may prefer to be at the trial balance level. |
6 |
term:glAccountDescription |
Term (Text/String) |
Label or description associated with GL_Account_Number. |
7 |
term:glAccountName |
Term (Text/String) |
Name for the GL account. |
8 |
term:glAccountNumber |
Term (Text/String) |
Identifier for the GL financial quarterly periods. GL_Account_Number in this file must match the GL_Account_Number used in the Trial_Balance and Chart_Of_Accounts files. |
9 |
term:parentglAccountNumber |
Term (Text/String) |
A reference to the GL_Account_Number that is the parent in an account hierarchy. Provided to allow more than the predefined levels of hierarchy in the chart of accounts table. |
10 |
term:segment01 |
Term (Text/String) |
Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
11 |
term:segment02 |
Term (Text/String) |
Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
12 |
term:segment03 |
Term (Text/String) |
Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
13 |
term:segment04 |
Term (Text/String) |
Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
14 |
term:segment05 |
Term (Text/String) |
Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |