trialBalance

11/20/2020 12:37:05 PM

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.