LedgerBalance

A ledger balance provides actual, budget, and encumbrance balances for reconciliation and financial reporting. It includes actual, budget, and encumbrance balances in both ledger and foreign currencies for detail and summary accounts. It also provides quarter-to date and year-to- date balances, and period activity balances for each account.

Expand all

Collapse all

Business Views

** Available for extracting data

• ledgerBalancesExtract**

  A ledger balance provides actual, budget, and encumbrance balances for reconciliation and financial reporting. It includes actual, budget, and encumbrance balances in both ledger and foreign currencies for detail and summary accounts. It also provides quarter-to date and year-to- date balances, and period activity balances for each account.

  Label

  Ledger Balances

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • balanceTypeCode (string)

    Type of balance. Valid values are A for actual and E for encumbrance.

    Label

    Balance Type

    Properties

    • searchable
    • sortable
    • not nullable
  • baseBeginBalanceCredit (big-decimal)

    The credit balance at the beginning of the period in the ledger currency.

    Label

    Ledger Currency Beginning Balance CR

    Properties

    • searchable
    • sortable
  • baseBeginBalanceDebit (big-decimal)

    The debit balance at the beginning of the period in the ledger currency.

    Label

    Ledger Currency Beginning Balance DR

    Properties

    • searchable
    • sortable
  • basePeriodNetActivityCredit (big-decimal)

    Accounting period net credit balance in the ledger currency.

    Label

    Ledger Currency Period Net Activity CR

    Properties

    • searchable
    • sortable
  • basePeriodNetActivityDebit (big-decimal)

    Accounting period net debit balance in the ledger currency.

    Label

    Ledger Currency Period Net Activity DR

    Properties

    • searchable
    • sortable
  • baseProjectToDateCredit (big-decimal)

    Accumulated or life-to-date credit balance of the project in the ledger currency.

    Label

    Ledger Currency Project-to-Date CR

    Properties

    • searchable
    • sortable
  • baseProjectToDateDebit (big-decimal)

    The accumulated or life-to-date debit balance of the project in the ledger currency.

    Label

    Ledger Currency Project-to-Date DR

    Properties

    • searchable
    • sortable
  • baseQuarterToDateCredit (big-decimal)

    The credit balance of the quarter-to-date period in the ledger currency.

    Label

    Ledger Currency Quarter-to-Date CR

    Properties

    • searchable
    • sortable
  • baseQuarterToDateDebit (big-decimal)

    The debit balance of the quarter-to-date period in the ledger currency.

    Label

    Ledger Currency Quarter-to-Date DR

    Properties

    • searchable
    • sortable
  • beginBalanceCredit (big-decimal)

    Credit balance at the beginning of the period in the entered currency.

    Label

    Beginning Balance CR

    Properties

    • searchable
    • sortable
  • beginBalanceDebit (big-decimal)

    Debit balance at the beginning of the period in the entered currency.

    Label

    Beginning Balance DR

    Properties

    • searchable
    • sortable
  • codeCombinationId (int64)

    Unique identifier of the general ledger account.

    Label

    Account Combination ID

    Properties

    • searchable
    • sortable
    • not nullable
  • currencyCode (string)

    Currency of the ledger balance.

    Label

    Currency

    Properties

    • searchable
    • sortable
    • not nullable
  • ledgerId (int64)

    Ledger identifier of the balance.

    Label

    Ledger ID

    Properties

    • searchable
    • sortable
    • not nullable
  • partitionGroupCode (string)

    Partition grouping information, which when combined with the period, determines the database partition in which the journal will be stored

    Properties

    • searchable
    • sortable
  • periodName (string)

    Accounting period associated with the balance.

    Label

    Period Name

    Properties

    • searchable
    • sortable
    • not nullable
  • periodNetCredit (big-decimal)

    Accounting period net credit balance in the entered currency.

    Label

    Period Net Activity CR

    Properties

    • searchable
    • sortable
  • periodNetDebit (big-decimal)

    Accounting period net debit balance in the entered currency.

    Label

    Period Net Activity DR

    Properties

    • searchable
    • sortable
  • periodNumber (int64)

    Accounting period number of the ledger balance.

    Label

    Period Number

    Properties

    • searchable
    • sortable
  • periodYear (int64)

    Accounting period year of the ledger balance.

    Label

    Period Year

    Properties

    • searchable
    • sortable
  • projectToDateCredit (big-decimal)

    The accumulated or life-to-date credit balance of the project in the entered currency.

    Label

    Project-to-Date CR

    Properties

    • searchable
    • sortable
  • projectToDateDebit (big-decimal)

    The credit balance of the quarter-to-date period in the entered currency.

    Label

    Project-to-Date DR

    Properties

    • searchable
    • sortable
  • quarterToDateCredit (big-decimal)

    The accumulated or life-to-date credit balance of the project in the entered currency.

    Label

    Quarter-to-Date CR

    Properties

    • searchable
    • sortable
  • quarterToDateDebit (big-decimal)

    The credit balance of the quarter-to-date period in the entered currency.

    Label

    Quarter-to-Date DR

    Properties

    • searchable
    • sortable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • sortable
    • not nullable
  • translationStatusCode (string)

    Indicates translation status of the ledger balance. A list of accepted values is defined in the lookup type GL_BALANCES_TRANSLATION_STATUS.

    Label

    Translated

    Properties

    • searchable
    • sortable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • encumbranceType (EncumbranceType)

    An encumbrance type stores information about encumbrance types, including their identifiers and descriptions. It serves as a comprehensive source for encumbrance type information.

    Business Object

    EncumbranceType

    Expand all

    Collapse all

    Fields

    • description (string)

      Description of the encumbrance type.

      Label

      Description

      Properties

      • translatable
    • encumbranceType (string)

      Encumbrance Type name such as Commitment or Obligation.

      Label

      Encumbrance Type Name

      Properties

      • translatable
      • not nullable
    • encumbranceTypeId (int64)

      Identifier of the encumbrance type.

      Label

      Encumbrance Type ID

      Properties

      • searchable
      • sortable
      • not nullable
    • $language (string)

      The language of the record.

      Label

      Language

      Properties

      • creatable
      • translatable
      • not nullable

Back to Top