Archived Daily Balances
The Archived Daily Balances view object contains archived information of the daily balances. This 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.FinArchiveBiccExtractAM.ArchiveGlDailyBalanceExtractPVO
Primary Keys : LedgerId
Initial Extract Date : CreationDate
Incremental Extract Date :
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ActualFlag | 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. |
| CodeCombinationId | 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. |
| ConvertedFromCurrency | 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. |
| CreatedBy | The user who created the daily balance. |
| CreationDate | The date and time when the daily balance was created. |
| CurrencyCode | The code representing the currency type 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. |
| CurrencyType | 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 are defined in the lookup type GL_CURRENCY_TYPE. |
| EndOfDay1 | The balance at the end of the day on the 1st day of the accounting period. This column is only used for translated balances. |
| EndOfDay10 | The balance at the end of the day on the 10th day of the accounting period. This column is only used for translated balances. |
| EndOfDay11 | The balance at the end of the day on the 11th day of the accounting period. This column is only used for translated balances. |
| EndOfDay12 | The balance at the end of the day on the 12th day of the accounting period. This column is only used for translated balances. |
| EndOfDay13 | The balance at the end of the day on the 13th day of the accounting period. This column is only used for translated balances. |
| EndOfDay14 | The balance at the end of the day on the 14th day of the accounting period. This column is only used for translated balances. |
| EndOfDay15 | The balance at the end of the day on the 15th day of the accounting period. This column is only used for translated balances. |
| EndOfDay16 | The balance at the end of the day on the 16th day of the accounting period. This column is only used for translated balances. |
| EndOfDay17 | The balance at the end of the day on the 17th day of the accounting period. This column is only used for translated balances. |
| EndOfDay18 | The balance at the end of the day on the 18th day of the accounting period. This column is only used for translated balances. |
| EndOfDay19 | The balance at the end of the day on the 19th day of the accounting period. This column is only used for translated balances. |
| EndOfDay2 | The balance at the end of the day on the 2nd day of the accounting period. This column is only used for translated balances. |
| EndOfDay20 | The balance at the end of the day on the 20th day of the accounting period. This column is only used for translated balances. |
| EndOfDay21 | The balance at the end of the day on the 21st day of the accounting period. This column is only used for translated balances. |
| EndOfDay22 | The balance at the end of the day on the 22nd day of the accounting period. This column is only used for translated balances. |
| EndOfDay23 | The balance at the end of the day on the 23rd day of the accounting period. This column is only used for translated balances. |
| EndOfDay24 | The balance at the end of the day on the 24th day of the accounting period. This column is only used for translated balances. |
| EndOfDay25 | The balance at the end of the day on the 25th day of the accounting period. This column is only used for translated balances. |
| EndOfDay26 | The balance at the end of the day on the 26th day of the accounting period. This column is only used for translated balances. |
| EndOfDay27 | The balance at the end of the day on the 27th day of the accounting period. This column is only used for translated balances. |
| EndOfDay28 | The balance at the end of the day on the 28th day of the accounting period. This column is only used for translated balances. |
| EndOfDay29 | The balance at the end of the day on the 29th day of the accounting period. This column is only used for translated balances. |
| EndOfDay3 | The balance at the end of the day on the 3rd day of the accounting period. This column is only used for translated balances. |
| EndOfDay30 | The balance at the end of the day on the 30th day of the accounting period. This column is only used for translated balances. |
| EndOfDay31 | The balance at the end of the day on the 31st day of the accounting period. This column is only used for translated balances. |
| EndOfDay32 | The balance at the end of the day on the 32nd day of the accounting period. This column is only used for translated balances. |
| EndOfDay33 | The balance at the end of the day on the 33rd day of the accounting period. This column is only used for translated balances. |
| EndOfDay34 | The balance at the end of the day on the 34th day of the accounting period. This column is only used for translated balances. |
| EndOfDay35 | The balance at the end of the day on the 35th day of the accounting period. This column is only used for translated balances. |
| EndOfDay4 | The balance at the end of the day on the 4th day of the accounting period. This column is only used for translated balances. |
| EndOfDay5 | The balance at the end of the day on the 5th day of the accounting period. This column is only used for translated balances. |
| EndOfDay6 | The balance at the end of the day on the 6th day of the accounting period. This column is only used for translated balances. |
| EndOfDay7 | The balance at the end of the day on the 7th day of the accounting period. This column is only used for translated balances. |
| EndOfDay8 | The balance at the end of the day on the 8th day of the accounting period. This column is only used for translated balances. |
| EndOfDay9 | The balance at the end of the day on the 9th day of the accounting period. This column is only used for translated balances. |
| LastUpdateDate | The date when the daily balance row was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the daily balance row. |
| LastUpdatedBy | The user who last updated the daily balance row. |
| LedgerId | The unique identifier of the ledger of 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. |
| ObjectVersionNumber | The number of times the daily balance row has been updated. |
| OpeningPeriodAggregate | The end of the day balance of the last day of the previous accounting period. |
| OpeningQuarterAggregate | The aggregate of the end-of-day balances of all days in the quarter on the last day of the previous accounting period. This attribute isn't used for translated balances. |
| OpeningYearAggregate | The aggregate of the end-of-day balances of all days in the year on the last day of the previous accounting period. This attribute isn't used for translated balances. |
| PartitionGroupCode | The code that identifies the partition group. The partition grouping information, when combined with the period, determines the database partition where the daily balance will be stored. |
| PeriodAggregate1 | The end balance on the 1st day of the accounting period. |
| PeriodAggregate10 | The aggregate of end balances from the 1st day to 10th day of the accounting cycle. |
| PeriodAggregate11 | The aggregate of end balances from the 1st day to 11th day of the accounting cycle. |
| PeriodAggregate12 | The aggregate of end balances from the 1st day to 12th day of the accounting cycle. |
| PeriodAggregate13 | The aggregate of end balances from the 1st day to 13th day of the accounting cycle. |
| PeriodAggregate14 | The aggregate of end balances from the 1st day to 14th day of the accounting cycle. |
| PeriodAggregate15 | The aggregate of end balances from the 1st day to 15th day of the accounting cycle. |
| PeriodAggregate16 | The aggregate of end balances from the 1st day to 16th day of the accounting cycle. |
| PeriodAggregate17 | The aggregate of end balances from the 1st day to 17th day of the accounting cycle. |
| PeriodAggregate18 | The aggregate of end balances from the 1st day to 18th day of the accounting cycle. |
| PeriodAggregate19 | The aggregate of end balances from the 1st day to 19th day of the accounting cycle. |
| PeriodAggregate2 | The aggregate of end balances from the 1st day to 2nd day of the accounting cycle. |
| PeriodAggregate20 | The aggregate of end balances from the 1st day to 20th day of the accounting cycle. |
| PeriodAggregate21 | The aggregate of end balances from the 1st day to 21st day of the accounting cycle. |
| PeriodAggregate22 | The aggregate of end balances from the 1st day to 22nd day of the accounting cycle. |
| PeriodAggregate23 | The aggregate of end balances from the 1st day to 23rd day of the accounting cycle. |
| PeriodAggregate24 | The aggregate of end balances from the 1st day to 24th day of the accounting cycle. |
| PeriodAggregate25 | The aggregate of end balances from the 1st day to 25th day of the accounting cycle. |
| PeriodAggregate26 | The aggregate of end balances from the 1st day to 26th day of the accounting cycle. |
| PeriodAggregate27 | The aggregate of end balances from the 1st day to 27th day of the accounting cycle. |
| PeriodAggregate28 | The aggregate of end balances from the 1st day to 28th day of the accounting cycle. |
| PeriodAggregate29 | The aggregate of end balances from the 1st day to 29th day of the accounting cycle. |
| PeriodAggregate3 | The aggregate of end balances from the 1st day to 3rd day of the accounting cycle. |
| PeriodAggregate30 | The aggregate of end balances from the 1st day to 30th day of the accounting cycle. |
| PeriodAggregate31 | The aggregate of end balances from the 1st day to 31st day of the accounting cycle. |
| PeriodAggregate32 | The aggregate of end balances from the 1st day to 32nd day of the accounting cycle. |
| PeriodAggregate33 | The aggregate of end balances from the 1st day to 33rd day of the accounting cycle. |
| PeriodAggregate34 | The aggregate of end balances from the 1st day to 34th day of the accounting cycle. |
| PeriodAggregate35 | The aggregate of end balances from the 1st day to 35th day of the accounting cycle. |
| PeriodAggregate4 | The aggregate of end balances from the 1st day to 4th day of the accounting cycle. |
| PeriodAggregate5 | The aggregate of end balances from the 1st day to 5th day of the accounting cycle. |
| PeriodAggregate6 | The aggregate of end balances from the 1st day to 6th day of the accounting cycle. |
| PeriodAggregate7 | The aggregate of end balances from the 1st day to 7th day of the accounting cycle. |
| PeriodAggregate8 | The aggregate of end balances from the 1st day to 8th day of the accounting cycle. |
| PeriodAggregate9 | The aggregate of end balances from the 1st day to 9th day of the accounting cycle. |
| PeriodEndDate | The date when the accounting period for the daily balance ends. |
| PeriodName | 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. |
| PeriodNum | The number of the accounting period for the daily balance. |
| PeriodStartDate | The date when the accounting period for the daily balance starts. |
| PeriodType | The code representing the type of the accounting period of the daily balance. |
| PeriodYear | The year of the accounting period for the daily balance. |
| ProgramUpdateDate | The date when the daily balance program was last updated. |
| QuarterAggregate1 | The end balance on the 1st day of the accounting period in the quarter. This column is only used for translated balances. |
| QuarterAggregate10 | The aggregate of end balances from the 1st day to 10th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate11 | The aggregate of end balances from the 1st day to 11th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate12 | The aggregate of end balances from the 1st day to 12th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate13 | The aggregate of end balances from the 1st day to 13th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate14 | The aggregate of end balances from the 1st day to 14th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate15 | The aggregate of end balances from the 1st day to 15th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate16 | The aggregate of end balances from the 1st day to 16th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate17 | The aggregate of end balances from the 1st day to 17th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate18 | The aggregate of end balances from the 1st day to 18th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate19 | The aggregate of end balances from the 1st day to 19th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate2 | The aggregate of end balances from the 1st day to 2nd day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate20 | The aggregate of end balances from the 1st day to 20th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate21 | The aggregate of end balances from the 1st day to 21st day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate22 | The aggregate of end balances from the 1st day to 22nd day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate23 | The aggregate of end balances from the 1st day to 23rd day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate24 | The aggregate of end balances from the 1st day to 24th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate25 | The aggregate of end balances from the 1st day to 25th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate26 | The aggregate of end balances from the 1st day to 26th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate27 | The aggregate of end balances from the 1st day to 27th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate28 | The aggregate of end balances from the 1st day to 28th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate29 | The aggregate of end balances from the 1st day to 29th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate3 | The aggregate of end balances from the 1st day to 3rd day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate30 | The aggregate of end balances from the 1st day to 30th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate31 | The aggregate of end balances from the 1st day to 31st day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate32 | The aggregate of end balances from the 1st day to 32nd day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate33 | The aggregate of end balances from the 1st day to 33rd day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate34 | The aggregate of end balances from the 1st day to 34th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate35 | The aggregate of end balances from the 1st day to 35th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate4 | The aggregate of end balances from the 1st day to 4th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate5 | The aggregate of end balances from the 1st day to 5th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate6 | The aggregate of end balances from the 1st day to 6th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate7 | The aggregate of end balances from the 1st day to 7th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate8 | The aggregate of end balances from the 1st day to 8th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterAggregate9 | The aggregate of end balances from the 1st day to 9th day of the accounting cycle in the quarter. This column is only used for translated balances. |
| QuarterStartDate | The start date of the quarter that contains the accounting period for the daily balance. |
| RequestId | The unique identifier of the request ID of the job that created or last updated the row. |
| TemplateId | The unique identifier of the summary template. |
| YearAggregate1 | The end balance on the 1st day of the accounting period in the year. This column is only used for translated balances. |
| YearAggregate10 | The aggregate of end balances from the 1st day to 10th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate11 | The aggregate of end balances from the 1st day to 11th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate12 | The aggregate of end balances from the 1st day to 12th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate13 | The aggregate of end balances from the 1st day to 13th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate14 | The aggregate of end balances from the 1st day to 14th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate15 | The aggregate of end balances from the 1st day to 15th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate16 | The aggregate of end balances from the 1st day to 16th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate17 | The aggregate of end balances from the 1st day to 17th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate18 | The aggregate of end balances from the 1st day to 18th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate19 | The aggregate of end balances from the 1st day to 19th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate2 | The aggregate of end balances from the 1st day to 2nd day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate20 | The aggregate of end balances from the 1st day to 20th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate21 | The aggregate of end balances from the 1st day to 21st day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate22 | The aggregate of end balances from the 1st day to 22nd day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate23 | The aggregate of end balances from the 1st day to 23rd day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate24 | The aggregate of end balances from the 1st day to 24th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate25 | The aggregate of end balances from the 1st day to 25th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate26 | The aggregate of end balances from the 1st day to 26th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate27 | The aggregate of end balances from the 1st day to 27th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate28 | The aggregate of end balances from the 1st day to 28th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate29 | The aggregate of end balances from the 1st day to 29th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate3 | The aggregate of end balances from the 1st day to 3rd day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate30 | The aggregate of end balances from the 1st day to 30th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate31 | The aggregate of end balances from the 1st day to 31st day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate32 | The aggregate of end balances from the 1st day to 32nd day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate33 | The aggregate of end balances from the 1st day to 33rd day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate34 | The aggregate of end balances from the 1st day to 34th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate35 | The aggregate of end balances from the 1st day to 35th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate4 | The aggregate of end balances from the 1st day to 4th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate5 | The aggregate of end balances from the 1st day to 5th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate6 | The aggregate of end balances from the 1st day to 6th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate7 | The aggregate of end balances from the 1st day to 7th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate8 | The aggregate of end balances from the 1st day to 8th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearAggregate9 | The aggregate of end balances from the 1st day to 9th day of the accounting cycle in the year. This column is only used for translated balances. |
| YearStartDate | The start date of the fiscal year that contains the accounting period for the daily balance. |