LedgerBalances
Used to view the balance amount for any account combination or an account that is defined as part of an account group.
Columns
| Name | Type | SupportedFinders | Description |
| AccountGroupName [KEY] | String | AccountGroupBalanceFinder, PrimaryKey | The value that uniquely identifies the account group. |
| AccountName [KEY] | String | AccountGroupBalanceFinder, PrimaryKey | The name of the account defined as part of the account group. |
| LedgerSetName [KEY] | String | AccountBalanceFinder, PrimaryKey | The name of the ledger set for which balances are requested. |
| LedgerName [KEY] | String | AccountBalanceFinder, AccountGroupBalanceFinder, PrimaryKey | The name of the ledger for which balances are requested. |
| Currency [KEY] | String | AccountBalanceFinder, AccountGroupBalanceFinder, PrimaryKey | The currency in which balances are requested. |
| CurrentAccountingPeriod [KEY] | String | PrimaryKey | The accounting period, quarter, or year, for which balances are requested. |
| PeriodName | String | The name of the accounting period for which account balances are returned. Applicable to Detail Mode only. | |
| CurrentPeriodBalance | String | The account balance for the requested accounting period. | |
| ActualBalance | String | The actual balance for the provided budget-based account group and other criteria. | |
| BudgetBalance | String | The budget balance for the provided budget-based account group and other criteria. | |
| Scenario | String | AccountBalanceFinder | The scenario for an account group definition with a budget-based comparison option. Valid values include Forecast Q1 and Original Budget. |
| AccountCombination [KEY] | String | AccountBalanceFinder, PrimaryKey | The concatenated segment value string that denotes the requested general ledger account, with the chart of accounts delimiter as the segment separator. A percent sign for a segment indicates that all values for that segment apply. |
| DetailAccountCombination | String | The concatenated segment value string that denotes the detail general ledger account that is returned for a requested general ledger account, with the chart of accounts delimiter as the segment separator. Applicable to Detail Mode only. | |
| BeginningBalance | String | The beginning account balance for the provided criteria. | |
| PeriodActivity | String | The period account balance for the provided criteria. | |
| EndingBalance | String | The ending account balance for the provided criteria. | |
| AmountType | String | AccountBalanceFinder | The amount type requested for the account balance. Values include Base, PTD, YTD and QTD. The default value is Base. |
| CurrencyType | String | AccountBalanceFinder | The currency type requested for the account balance. The default value is Total. |
| ErrorDetail | String | The error message received from the Oracle Essbase server in the event of a request processing failure. | |
| Segment1TreeCode | String | AccountBalanceFinder | The tree code for Segment 1. |
| Segment2TreeCode | String | AccountBalanceFinder | The tree code for Segment 2. |
| Segment3TreeCode | String | AccountBalanceFinder | The tree code for Segment 3. |
| Segment4TreeCode | String | AccountBalanceFinder | The tree code for Segment 4. |
| Segment5TreeCode | String | AccountBalanceFinder | The tree code for Segment 5. |
| Segment6TreeCode | String | AccountBalanceFinder | The tree code for Segment 6. |
| Segment7TreeCode | String | AccountBalanceFinder | The tree code for Segment 7. |
| Segment8TreeCode | String | AccountBalanceFinder | The tree code for Segment 8. |
| Segment9TreeCode | String | AccountBalanceFinder | The tree code for Segment 9. |
| Segment10TreeCode | String | AccountBalanceFinder | The tree code for Segment 10. |
| Segment11TreeCode | String | AccountBalanceFinder | The tree code for Segment 11. |
| Segment12TreeCode | String | AccountBalanceFinder | The tree code for Segment 12. |
| Segment13TreeCode | String | AccountBalanceFinder | The tree code for Segment 13. |
| Segment14TreeCode | String | AccountBalanceFinder | The tree code for Segment 14. |
| Segment15TreeCode | String | AccountBalanceFinder | The tree code for Segment 15. |
| Segment16TreeCode | String | AccountBalanceFinder | The tree code for Segment 16. |
| Segment17TreeCode | String | AccountBalanceFinder | The tree code for Segment 17. |
| Segment18TreeCode | String | AccountBalanceFinder | The tree code for Segment 18. |
| Segment19TreeCode | String | AccountBalanceFinder | The tree code for Segment 19. |
| Segment20TreeCode | String | AccountBalanceFinder | The tree code for Segment 20. |
| Segment21TreeCode | String | AccountBalanceFinder | The tree code for Segment 21. |
| Segment22TreeCode | String | AccountBalanceFinder | The tree code for Segment 22. |
| Segment23TreeCode | String | AccountBalanceFinder | The tree code for Segment 23. |
| Segment24TreeCode | String | AccountBalanceFinder | The tree code for Segment 24. |
| Segment25TreeCode | String | AccountBalanceFinder | The tree code for Segment 25. |
| Segment26TreeCode | String | AccountBalanceFinder | The tree code for Segment 26. |
| Segment27TreeCode | String | AccountBalanceFinder | The tree code for Segment 27. |
| Segment28TreeCode | String | AccountBalanceFinder | The tree code for Segment 28. |
| Segment29TreeCode | String | AccountBalanceFinder | The tree code for Segment 29. |
| Segment30TreeCode | String | AccountBalanceFinder | The tree code for Segment 30. |
| AccountingPeriod | String | AccountBalanceFinder, AccountGroupBalanceFinder | The accounting period, quarter, or year, for which balances are requested. |
| EffectiveDate | String | AccountBalanceFinder | The effective date of the account hierarchy tree version. |
| Finder | String | Used as a predefined finder to search the collection. Available finders: AccountBalanceFinder, AccountGroupBalanceFinder, PrimaryKey. | |
| MaxFetchLimit | String | AccountBalanceFinder | The value (Y or N, with Y as the default), that allows for skipping the validation error when records exceed 10,000. |
| Mode | String | AccountBalanceFinder | The method for how account balances are retrieved, with Summary or Detail as valid values. |