LedgerDailyBalance
A ledger daily balance provides daily aggregate balances for detail and summary balance sheet accounts when the ledger is enabled for average balance processing. It includes balances in ledger, foreign, entered, and statistical currencies, and translated daily aggregate balances for each nonadjusting period that has ever been opened.
Business Views
** Available for extracting data- ledgerDailyBalancesExtract**
A ledger daily balance provides daily aggregate balances for detail and summary balance sheet accounts when the ledger is enabled for average balance processing. It includes balances in ledger, foreign, entered, and statistical currencies, and translated daily aggregate balances for each nonadjusting period that has ever been opened.
Label
Ledger Daily Balances
Data Source
Read-optimized data store
Fields
- balanceTypeCode (string)
Type of balance. Valid values are A for actual and E for encumbrance.
Label
Balance Type
Properties
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
Unique identifier of the general ledger account.
Label
Account Combination ID
Properties
- searchable
- sortable
- not nullable
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- searchable
- sortable
- not readable
- not nullable
- currencyCode (string)
Currency of the daily balance.
Label
Currency
Properties
- searchable
- sortable
- not nullable
- currencyTypeCode (string)
Currency type of the daily balance. A list of accepted values is defined in the lookup type GL_CURRENCY_TYPE.
Label
Currency Type
Properties
- searchable
- sortable
- not nullable
- ledgerId (int64)
Ledger identifier of the daily balance.
Label
Ledger ID
Properties
- searchable
- sortable
- not nullable
- openingPeriodAggregate (big-decimal)
The end-of-day balance of the last day of the previous period.
Label
Opening Period Aggregate Balance
Properties
- searchable
- sortable
- openingQuarterAggregate (big-decimal)
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.
Label
Opening Quarter Aggregate Balance
Properties
- searchable
- sortable
- openingYearAggregate (big-decimal)
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.
Label
Opening Year Aggregate Balance
Properties
- searchable
- sortable
- periodAggregate1 (big-decimal)
The end-of-day balance of the first day of the accounting period for the daily balance.
Label
Period Aggregate Balance for Day 1
Properties
- searchable
- sortable
- periodAggregate10 (big-decimal)
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.
Label
Period Aggregate Balance for Day 10
Properties
- searchable
- sortable
- periodAggregate11 (big-decimal)
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.
Label
Period Aggregate Balance for Day 11
Properties
- searchable
- sortable
- periodAggregate12 (big-decimal)
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.
Label
Period Aggregate Balance for Day 12
Properties
- searchable
- sortable
- periodAggregate13 (big-decimal)
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.
Label
Period Aggregate Balance for Day 13
Properties
- searchable
- sortable
- periodAggregate14 (big-decimal)
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.
Label
Period Aggregate Balance for Day 14
Properties
- searchable
- sortable
- periodAggregate15 (big-decimal)
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.
Label
Period Aggregate Balance for Day 15
Properties
- searchable
- sortable
- periodAggregate16 (big-decimal)
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.
Label
Period Aggregate Balance for Day 16
Properties
- searchable
- sortable
- periodAggregate17 (big-decimal)
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.
Label
Period Aggregate Balance for Day 17
Properties
- searchable
- sortable
- periodAggregate18 (big-decimal)
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.
Label
Period Aggregate Balance for Day 18
Properties
- searchable
- sortable
- periodAggregate19 (big-decimal)
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.
Label
Period Aggregate Balance for Day 19
Properties
- searchable
- sortable
- periodAggregate2 (big-decimal)
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.
Label
Period Aggregate Balance for Day 2
Properties
- searchable
- sortable
- periodAggregate20 (big-decimal)
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.
Label
Period Aggregate Balance for Day 20
Properties
- searchable
- sortable
- periodAggregate21 (big-decimal)
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.
Label
Period Aggregate Balance for Day 21
Properties
- searchable
- sortable
- periodAggregate22 (big-decimal)
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.
Label
Period Aggregate Balance for Day 22
Properties
- searchable
- sortable
- periodAggregate23 (big-decimal)
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.
Label
Period Aggregate Balance for Day 23
Properties
- searchable
- sortable
- periodAggregate24 (big-decimal)
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.
Label
Period Aggregate Balance for Day 24
Properties
- searchable
- sortable
- periodAggregate25 (big-decimal)
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.
Label
Period Aggregate Balance for Day 25
Properties
- searchable
- sortable
- periodAggregate26 (big-decimal)
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.
Label
Period Aggregate Balance for Day 26
Properties
- searchable
- sortable
- periodAggregate27 (big-decimal)
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.
Label
Period Aggregate Balance for Day 27
Properties
- searchable
- sortable
- periodAggregate28 (big-decimal)
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.
Label
Period Aggregate Balance for Day 28
Properties
- searchable
- sortable
- periodAggregate29 (big-decimal)
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.
Label
Period Aggregate Balance for Day 29
Properties
- searchable
- sortable
- periodAggregate3 (big-decimal)
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.
Label
Period Aggregate Balance for Day 3
Properties
- searchable
- sortable
- periodAggregate30 (big-decimal)
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.
Label
Period Aggregate Balance for Day 30
Properties
- searchable
- sortable
- periodAggregate31 (big-decimal)
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.
Label
Period Aggregate Balance for Day 31
Properties
- searchable
- sortable
- periodAggregate32 (big-decimal)
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.
Label
Period Aggregate Balance for Day 32
Properties
- searchable
- sortable
- periodAggregate33 (big-decimal)
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.
Label
Period Aggregate Balance for Day 33
Properties
- searchable
- sortable
- periodAggregate34 (big-decimal)
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.
Label
Period Aggregate Balance for Day 34
Properties
- searchable
- sortable
- periodAggregate35 (big-decimal)
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.
Label
Period Aggregate Balance for Day 35
Properties
- searchable
- sortable
- periodAggregate4 (big-decimal)
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.
Label
Period Aggregate Balance for Day 4
Properties
- searchable
- sortable
- periodAggregate5 (big-decimal)
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.
Label
Period Aggregate Balance for Day 5
Properties
- searchable
- sortable
- periodAggregate6 (big-decimal)
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.
Label
Period Aggregate Balance for Day 6
Properties
- searchable
- sortable
- periodAggregate7 (big-decimal)
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.
Label
Period Aggregate Balance for Day 7
Properties
- searchable
- sortable
- periodAggregate8 (big-decimal)
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.
Label
Period Aggregate Balance for Day 8
Properties
- searchable
- sortable
- periodAggregate9 (big-decimal)
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.
Label
Period Aggregate Balance for Day 9
Properties
- searchable
- sortable
- periodEndDate (date)
The date when the accounting period for the daily balance ends.
Label
Period End Date
Properties
- searchable
- sortable
- not nullable
- periodName (string)
Accounting period name of the daily balance.
Label
Period Name
Properties
- searchable
- sortable
- not nullable
- periodNumber (int64)
The number of the accounting period for the daily balance.
Label
Period Number
Properties
- searchable
- sortable
- periodStartDate (date)
The date when the accounting period for the daily balance starts.
Label
Period Start Date
Properties
- searchable
- sortable
- not nullable
- periodType (string)
The frequency of the accounting period, such as, Weekly, Monthly, and Quarterly. The list of accepted values for period frequency can be found in the lookup type CAL_NON_ADJ_FREQ. When creating a calendar with period frequency codes, the period type is concatenated with a unique number. For example, MONTH2558721688.
Label
Period Type
Properties
- searchable
- sortable
- periodYear (int64)
The year of the accounting period for the daily balance.
Label
Period Year
Properties
- searchable
- sortable
- quarterStartDate (date)
The start date of the quarter that contains the accounting period for the daily balance.
Label
Quarter Start Date
Properties
- searchable
- sortable
- not nullable
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- sortable
- not readable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- sortable
- not readable
- not nullable
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- searchable
- sortable
- not readable
- not nullable
- yearStartDate (date)
The start date of the fiscal year that contains the accounting period for the daily balance.
Label
Year Start Date
Properties
- searchable
- sortable
- not nullable
Reference Object
- convertedFromCurrency (Currency)
The currency the daily balance was converted from.
Business Object
CurrencyFields
- currencyCode (string)
The currency in which an amount or a conversion rate is denominated.
Label
Currency Code
Properties
- searchable
- sortable
- not nullable
- currencyCode (string)
- balanceTypeCode (string)