Transformed Fields
Fields within the dataset containing the suffix (s) have been transformed in some way. The following table details these transformations:
Field Type |
Field | Transformation Description |
---|---|---|
Measures |
Dual Value (s) | The dual value reversed. |
Dual Cr Value (s) | The dual credit value reversed. | |
Dual Dr Value (s) | The dual debit value reversed. | |
Financial Period (s) | The financial period represented as a number. | |
Financial Year and Period (s) | The financial year and period represented as a number. | |
Financial Year (s) | The financial year represented as a number. | |
Home Value (s) |
The home value reversed. |
|
Home Cr Value (s) | The home credit value reversed. | |
Home Dr Value (s) | The home debit value reversed. | |
Dimensions | Cash Flow Adjustment (s) | A formula. Where no cash flow adjustment is specified on the Reporting Balances object, use the cash flow adjustment specified on the General Ledger Account. |
Cash Flow Category (s) | A formula. Where no cash flow category is specified on the Reporting Balances object, use the cash flow category specified on the General Ledger Account. | |
Cash Flow Line Summary (s) | A formula. Where no cash flow line summary is specified on the Reporting Balances object, use the cash flow line summary specified on the General Ledger Account. | |
Financial Special Period (s) | A checkbox indicating if the period is a special period. Special periods are 000, 100, and 101. Period 100 is selected by default. | |
Financial Year and Period (s) | The financial year and period represented as a number. | |
General Ledger Account Name (s) | The general ledger account name with the numeric prefix removed. | |
General Ledger Account Name | The name of the general ledger account without its code prefix. See the General Ledger Account object. | |
Financial Year-Period (s) |
Hidden field. Combines the year from Financial Year (PeriodYearName) field, and the period from the Financial Period (PeriodNumber) field and transforms the values to create a date field for use in Time Series charts. This is calculated as follows: Financial Year = Year (not transformed). Financial Period: Period 000 is added to 01. Period 100 and Period 101 are added to 12. Following this calculation, 2018/012 becomes 2018-12. |
|
Income Statement Class (s) | A custom field for user-definition. | |
Intersect Definition (s) | A custom field for user-definition. | |
Trial Balance Level 1 (s) | A coded variant of trial balance 1 to allow for non-alpha sorting within lenses. | |
Trial Balance Level 2 (s) | A coded variant of trial balance 2 to allow for non-alpha sorting within lenses. | |
Trial Balance Level 3 (s) | A coded variant of trial balance 3 to allow for non-alpha sorting within lenses. | |
Trial Balance Level 4 (s) | A coded variant of trial balance 4 to allow for non-alpha sorting within lenses. | |
Dates |
Financial Year/Month (s) | Hidden field. Combines the year from Financial Year (PeriodYearName) field, and the period from the Financial Period (PeriodNumber) field and transforms the values to create a Year/Period string. Used for date labels. |