Measures
This table shows the financial balance measures::
| Measure | Mapping | Note |
|---|---|---|
| Credit Amount | For transaction currency tfgld205.fcam Else tfgld205.fcah |
(1) |
| Credit Amount Including Non Finalized | For transaction currency tfgld205.fcam + tfgdl205.ncam Else tfgld205.fcah + tfgdl205.ncah |
(1) |
| Credit Amount Including Non Finalized up to Previous Period | For period 1 return 0 Else, sum all ‘Credit Amount Including Non Finalized’ till the previous period in the financial year |
(5) |
| Credit Amount up to Previous Period | For period 1 return 0 Else, sum all ‘Credit Amount’ till the previous period in the financial year |
(5) |
| Debit Amount | For transaction currency tfgld205.fdam Else, tfgld205.fdah |
(1) |
| Debit Amount Including Non Finalized | For transaction currency tfgld205.fdam + tfgld205.ndam Else, tfgld205.fdah + tfgld205.ndah |
(1) |
| Debit Amount Including Non Finalized up to Previous Period | For period 1 return 0 Else, sum all ‘Debit Amount Including Non Finalized’ till the previous period in the financial year |
(5) |
| Debit Amount up to Previous Period | For period 1 return 0 Else, sum all ‘Debit Amount’ till the previous period in the financial year |
(5) |
| Financial Balance Count | Count of available tfgld205 records in LN. | |
| Movement | For transaction currency tfgld205.fdam – tfgld205.fcam Else, tfgld205.fdah-tfgld205.fcah. Debit Amount minus Credit Amount |
(1) |
| Movement Including Non Finalized | For transaction currency tfgld205.fdam + tfgdl205.ndam –
tfgld205.fcam – tfgld205.nfcam Else, tfgld205.fdah + tfgld205.ndah -tfgld205.fcah – tfgld205.ncah Debit Amount Including Non Finalized - Credit Amount Including Non Finalized |
(1) |
| Movement Including Non Finalized up to Previous Period | For period 1 return 0 Else, sum all ‘Movement Including Non- Finalized’ till the previous period in the financial year |
(5) |
| Movement up to Previous Period | For period 1 return 0 Else, sum all ‘Movement’ till the previous period in the financial year |
(5) |
| Period Closing Balance | Year Opening Amount + Movement up to Previous Period + Movement | (5) |
| Period Closing Balance Including Non Finalized | Year Opening Amount Including Non Finalized + Movement Including Non Finalized up to Previous Period + Movement Including Non Finalized | (5) |
| Period Closing Balance Quantity 1 | Year Opening Quantity 1 + Quantity 1 up to Previous Period + Quantity 1 | (5) |
| Period Closing Balance Quantity 1 Including Non Finalized | Year Opening Quantity 1 Including Non Finalized + Quantity 1 up to Previous Period + Quantity 1 Including Non Finalized | (5) |
| Period Closing Balance Quantity 2 | Year Opening Quantity 2 + Quantity 2 up to Previous Period + Quantity 2 | (5) |
| Period Closing Balance Quantity 2 Including Non Finalized | Year Opening Quantity 2 Including Non Finalized + Quantity 2 up to Previous Period + Quantity 2 Including Non Finalized | (5) |
| Period Opening Balance | Year Opening Amount + Movement up to Previous Period | (5) |
| Period Opening Balance Including Non Finalized | Year Opening Amount Including Non Finalized + Movement Including Non Finalized up to Previous Period | (5) |
| Period Opening Balance Quantity 1 | Year Opening Quantity 1 + Quantity 1 up to Previous | (5) |
| Period Opening Balance Quantity 1 Including Non Finalized | Year Opening Quantity 1 Including Non Finalized + Quantity 1 up to Previous Period | (5) |
| Period Opening Balance Quantity 2 | Year Opening Quantity 2 + Quantity 2 up to Previous Period | (5) |
| Period Opening Balance Quantity 2 Including Non Finalized | Year Opening Quantity 2 Including Non Finalized + Quantity 2 up to Previous Period | (5) |
| Quantity 1 | tfgld205.fqt1 | (2) |
| Quantity 1 Including Non Finalized | tfgld205.fqt1 + tfgld205.nqt1 | (2) |
| Quantity 1 Including Non Finalized up to Previous Period | For period 1 return 0 Else, sum all ‘Quantity 1 Including Non- Finalized’ till the previous period in the financial year |
(5) |
| Quantity 1 up to Previous Period | For period 1 return 0 Else, sum all ‘Quantity 1’ till the previous period in the financial year |
|
| Quantity 2 | tfgld205.fqt2 | (2) |
| Quantity 2 Including Non Finalized | tfgld205.fqt2 + tfgld205.nqt2 | (2) |
| Quantity 2 Including Non Finalized up to Previous Period | For period 1 return 0 Else, sum all ‘Quantity 2 Including Non- Finalized’ till the previous period in the financial year |
(5) |
| Quantity 2 up to Previous Period | For period 1 return 0 Else, sum all ‘Quantity 2’ till the previous period in the financial year |
(5) |
| Year Opening Amount | For transaction currency tfgld206.ftob, else tfgld206.fobh | (3) |
| Year Opening Amount Including Non Finalized | For transaction currency tfgld206.ftob + tfgld206.ntob Else, tfgld206.fobh + tfgld206.nobh |
(3) |
| Year Opening Quantity 1 | tfgld206.qob1 | (4) |
| Year Opening Quantity 1 Including Non Finalized | tfgld206.qob1 + tfgld206.nob1 | |
| Year Opening Quantity 2 | tfgld206.qob2 | (4) |
| Year Opening Quantity 2 Including Non Finalized | tfgld206.qob2 + tfgld206.nob2 | (4) |
| deleted | Count |
- (1) Amounts facts are semi-additive (SA): amounts are available in 6 currency types (LC,
RC1, RC2, RFC, DWC, TC). Amounts in the transaction currency (TC) can be summed safely only
by filtering Financial Balances for a specific transaction currency. Other amounts can be
summed safely for a single company and for multiple companies that have the same currency
and financial period setup. Note: The amounts are only semi-additive when you filter on:
- The Period Type attribute of the Financial Period Dimension. Otherwise, amounts from the fiscal and reporting period are added together.
- The Sublevel attributes of the Chart of Account and Dimension01 till Dimension12 dimensions when they are dragged into a report. Otherwise, amounts from sublevel 0 accounts and their parent accounts are added together
- (2) Quantity facts are semi-additive (SA): Quantity 1 and Quantity 2 are available in the
units defined for the corresponding Ledger Account. Therefore, quantities can be summed up
safely only across ledger accounts with the same units (tfgld008.uni1 and
tfgld008.uni2).Note: The quantities are only semi-additive when you filter on:
- The Period Type attribute of the Financial Period Dimension. Otherwise, amounts from the fiscal and reporting period are added together.
- The Sublevel attributes of the Chart of Account and Dimension01 till Dimension12 dimensions when they are dragged into a report. Otherwise, amounts from sublevel 0 accounts and their parent accounts are added together.
- (3) Year Opening Amounts facts are semi-additive (SA): amounts are
available in 6 currency types (LC, RC1, RC2, RFC, DWC, TC). Year Opening Amounts are stored
in the first period of the financial year. Amounts in the transaction currency (TC) can be
summed safely only by filtering on Financial Balances for a specific
transaction currency in one financial year. Other amounts can be summed safely for a single
company and for multiple companies that have the same currency in the same financial year.
Note: The Year Opening Amounts are only semi-additive when you filter on:
- The Period Type and Year attributes of the Financial Period Dimension. Otherwise, year opening amounts from the fiscal and reporting period and year opening amounts from different years are added together.
- The Sublevel attributes of the Chart of Account and Dimension01 till Dimension12 dimensions when they are dragged into a report. Otherwise, amounts from sublevel 0 accounts and their parent accounts are added together.
- (4) Year Opening Quantity facts are semi-additive (SA): Quantity 1 and
Quantity 2 are available in the units defined for the corresponding Ledger Account. Year
opening quantities are stored in the first period of the financial year. Therefore, Year
opening quantities can be summed up safely only across ledger account with the same units
(tfgld008.uni1 and tfgld008.uni2) in the same financial year.Note: The quantities are only semi-additive when you filter on:
- The Period Type and Year attributes of the Financial Period Dimension. Otherwise, year opening quantities from the fiscal and reporting period are added together.
- The Sublevel attributes of the Chart of Account and Dimension01 till Dimension12 dimensions when they are dragged into a report. Otherwise, amounts from sublevel 0 accounts and their parent accounts are added together.
- (5) Dimensional Expression to calculate aggregated report measures that are different than the grain of the Financial Balance table. The dimensional expressions calculate the YTD, opening balance, and closing balance for a particular year period. Therefore, the report must have a filter on Period Type, Year, and Period attributes of the Financial Period dimension. Additionally, the report measure must follow the aggregation rules of the dimensional expression’s underlying measures.