Daily Balances
The daily balances view object stores daily aggregate balances for detail and summary balance sheet accounts in ledgers with average balances enabled. The combination of GlDailyBalancesLedgerId, GlDailyBalancesCodeCombiantionId, GlDailyBalancesCurrencyCode, GlDailyBalancesCurrencyType, GlDailyBalancesActualFlag, GlDailyBalancesPeriodName and GlDailyBalancesConvertedFromCurrency forms the unique identifier of the Daily Balances view object.
Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.DailyBalanceExtractPVO
Primary Keys : GlDailyBalancesActualFlag, GlDailyBalancesCodeCombinationId, GlDailyBalancesConvertedFromCurrency, GlDailyBalancesCurrencyCode, GlDailyBalancesLedgerId, GlDailyBalancesPeriodName, GlDailyBalancesCurrencyType
Initial Extract Date : GlDailyBalancesCreationDate
Incremental Extract Date : GlDailyBalancesLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| GlDailyBalancesActualFlag | Identifies whether the balance is an actual or encumbrance amount. A list of accepted values is defined in the lookup type BATCH_TYPE. This attribute is a part of the composite key of the Daily Balances view object. |
| GlDailyBalancesCodeCombinationId | The unique identifier of the General Ledger Accounts view object. This is a foreign key of the General Ledger Accounts view object. This attribute is a part of the composite key of the Daily Balances view object. |
| GlDailyBalancesConvertedFromCurrency | The currency from which the balance was converted. It identifies functional, foreign entered, statistical, and translated balances rows in the daily balance. This attribute is a part of the composite key of the Daily Balances view object. |
| GlDailyBalancesCreatedBy | The user who created the daily balance. |
| GlDailyBalancesCreationDate | The date and time when the daily balance was created. |
| GlDailyBalancesCurrencyCode | The currency of the daily balance. This is a foreign key of the Currencies view object. This attribute is a part of the composite key of the Daily Balances view object. |
| GlDailyBalancesCurrencyType | The currency type of the daily balance. This attribute is a part of the composite key of the Daily Balances view object. A list of accepted values is defined in the lookup type GL_CURRENCY_TYPE. |
| GlDailyBalancesLastUpdateDate | The date when the daily balance row was last updated. |
| GlDailyBalancesLastUpdateLogin | The session login associated with the user who last updated the daily balance. |
| GlDailyBalancesLastUpdatedBy | The user who last updated the daily balance. |
| GlDailyBalancesLedgerId | The unique identifier of the ledger on which daily balances are calculated. This is a foreign key of the Ledgers view object. This attribute is a part of the composite key of the Daily Balances view object. |
| GlDailyBalancesObjectVersionNumber | The number of times the daily balance row has been updated. |
| GlDailyBalancesOpeningPeriodAggregate | The end-of-day balance of the last day of the previous period. |
| GlDailyBalancesOpeningQuarterAggregate | The aggregate of the end-of-day balances of all days in the quarter before the first day of the accounting period. This attribute isn't used for translated balances. |
| GlDailyBalancesOpeningYearAggregate | The aggregate of the end-of-day balances of all days in the year before the first day of the accounting period. This attribute isn't used for translated balances. |
| GlDailyBalancesPeriodAggregate1 | The end-of-day balance of the first day of the accounting period for the daily balance. |
| GlDailyBalancesPeriodAggregate10 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the tenth day of the period. |
| GlDailyBalancesPeriodAggregate11 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the eleventh day of the period. |
| GlDailyBalancesPeriodAggregate12 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the twelfth day of the period. |
| GlDailyBalancesPeriodAggregate13 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the thirteenth day of the period. |
| GlDailyBalancesPeriodAggregate14 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the fourteenth day of the period. |
| GlDailyBalancesPeriodAggregate15 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the fifteenth day of the period. |
| GlDailyBalancesPeriodAggregate16 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the sixteenth day of the period. |
| GlDailyBalancesPeriodAggregate17 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the seventeenth day of the period. |
| GlDailyBalancesPeriodAggregate18 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the eighteenth day of the period. |
| GlDailyBalancesPeriodAggregate19 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the nineteenth day of the period. |
| GlDailyBalancesPeriodAggregate2 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the second day of the period. |
| GlDailyBalancesPeriodAggregate20 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the twentieth day of the period. |
| GlDailyBalancesPeriodAggregate21 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the twenty-first day of the period. |
| GlDailyBalancesPeriodAggregate22 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the twenty-second day of the period. |
| GlDailyBalancesPeriodAggregate23 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the twenty-third day of the period. |
| GlDailyBalancesPeriodAggregate24 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the twenty-fourth day of the period. |
| GlDailyBalancesPeriodAggregate25 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the twenty-fifth day of the period. |
| GlDailyBalancesPeriodAggregate26 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the twenty-sixth day of the period. |
| GlDailyBalancesPeriodAggregate27 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the twenty-seventh day of the period. |
| GlDailyBalancesPeriodAggregate28 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the twenty-eighth day of the period. |
| GlDailyBalancesPeriodAggregate29 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the twenty-ninth day of the period. |
| GlDailyBalancesPeriodAggregate3 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the third day of the period. |
| GlDailyBalancesPeriodAggregate30 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the thirtieth day of the period. |
| GlDailyBalancesPeriodAggregate31 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the thirty-first day of the period. |
| GlDailyBalancesPeriodAggregate32 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the thirty-second day of the period. |
| GlDailyBalancesPeriodAggregate33 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the thirty-third day of the period. |
| GlDailyBalancesPeriodAggregate34 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the thirty-fourth day of the period. |
| GlDailyBalancesPeriodAggregate35 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the thirty-fifth day of the period. |
| GlDailyBalancesPeriodAggregate4 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the fourth day of the period. |
| GlDailyBalancesPeriodAggregate5 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the fifth day of the period. |
| GlDailyBalancesPeriodAggregate6 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the sixth day of the period. |
| GlDailyBalancesPeriodAggregate7 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the seventh day of the period. |
| GlDailyBalancesPeriodAggregate8 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the eighth day of the period. |
| GlDailyBalancesPeriodAggregate9 | The aggregate of the end-of-day balances of all days in the accounting period, up to and including the ninth day of the period. |
| GlDailyBalancesPeriodEndDate | The date when the accounting period for the daily balance ends. |
| GlDailyBalancesPeriodName | The name of the accounting period for the daily balance. This attribute is a part of the composite key of the Daily Balances view object. |
| GlDailyBalancesPeriodNum | The number of the accounting period for the daily balance. |
| GlDailyBalancesPeriodStartDate | The date when the accounting period for the daily balance starts. |
| GlDailyBalancesPeriodYear | The year of the accounting period for the daily balance. |
| GlDailyBalancesQuarterStartDate | The start date of the quarter that contains the accounting period for the daily balance. |
| GlDailyBalancesYearStartDate | The start date of the fiscal year that contains the accounting period for the daily balance. |