Line |
Field Name |
Data Type |
Description |
1 |
str:trialBalance |
Table |
Trial balance information per general ledger subsystem. |
2 |
term:amountBeginning |
Term (Decimal) |
Period beginning balance amount (that is, the ending balance from the prior period) recorded in the functional or group currency. No multicurrency translation should need to be performed on this amount because all are recorded in a single currency. |
3 |
term:amountBeginningLocal |
Term (Decimal) |
Period beginning balance amount in the local country currency for multicurrency tracking. |
4 |
term:amountBeginningReporting |
Term (Decimal) |
Period beginning balance amount in reporting currency used for statutory reporting. |
5 |
term:amountCurrency |
Term (Text/String) |
The functional or group currency related to the balance. See ISO 4217 coding. |
6 |
term:amountEnding |
Term (Decimal) |
Period ending balance amount recorded in the functional or group currency. No multicurrency translation should need to be performed on this amount because all are recorded in a single currency. |
7 |
term:amountEndingLocal |
Term (Decimal) |
Period ending balance amount in the local country currency for multicurrency tracking. |
8 |
term:amountEndingReporting |
Term (Decimal) |
Period ending balance amount in reporting currency used for statutory reporting. |
9 |
term:amountLocalCurrency |
Term (Text/String) |
The currency used for local country reporting requirements. See ISO 4217 coding. |
10 |
term:amountReportingCurrency |
Term (Text/String) |
The currency used for nonconsolidated reporting as opposed to functional or consolidated reporting or local or actual amounts. See ISO 4217 coding. |
11 |
term:balanceAsOfDate |
Term (Date) |
Date of the provided balance, not when the Trial_Balance file was created (for example, 20141231 if year-end balance, even if the report was run on 20150122). |
12 |
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. |
13 |
term:fiscalYear |
Term (Text/String) |
Fiscal year in which Effective_Date occurred YYYY for delimited, CCYY-MM-DD fiscal year end (ISO 8601) for Extensible Business Reporting Language Global Ledger taxonomy framework (XBRL GL). |
14 |
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. |
15 |
term:period |
Term (Text/String) |
Fiscal period in which the Effective_Date occurs.Examples include W1‚W53 for weekly periods, M1‚M12 for monthly periods, and Q1‚Q4 for quarterly periods. |
16 |
term:segment01 |
Term (Text/String) |
Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
17 |
term:segment02 |
Term (Text/String) |
Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
18 |
term:segment03 |
Term (Text/String) |
Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
19 |
term:segment04 |
Term (Text/String) |
Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
20 |
term:segment05 |
Term (Text/String) |
Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |