SupportingReferenceBalance

A supporting reference balance provides the beginning and period activity balances for a combination of supporting references and an account. This information can be used to report on additional supporting information and reconcile with the source systems.

Expand all

Collapse all

Business Views

** Available for extracting data

• supportingReferenceBalancesExtract**

  A supporting reference balance provides the beginning and period activity balances for a combination of supporting references and an account. This information can be used to report on additional supporting information and reconcile with the source systems.

  Label

  Supporting Reference Balances

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • acBalanceId (int64)

    The unique identifier of the supporting reference balances.

    Label

    Supporting Reference Balance Identifier

    Properties

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

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

    Label

    Ledger Currency Beginning Balance Credit

    Properties

    • searchable
    • sortable
  • beginBalanceDebit (big-decimal)

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

    Label

    Ledger Currency Beginning Balance Debit

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

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

    The credit balance of the supporting references in the entered currency at the beginning of the accounting period.

    Label

    Entered Currency Beginning Balance Credit

    Properties

    • searchable
    • sortable
  • enteredCurBeginBalanceDebit (big-decimal)

    The debit balance of the supporting references in the entered currency at the beginning of the accounting period.

    Label

    Entered Currency Beginning Balance Debit

    Properties

    • searchable
    • sortable
  • enteredCurPeriodNetCredit (big-decimal)

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

    Label

    Entered Currency Period Balance Credit

    Properties

    • searchable
    • sortable
  • enteredCurPeriodNetDebit (big-decimal)

    The period-to-date debit balance of the supporting references in the entered currency.

    Label

    Entered Currency Period Balance Debit

    Properties

    • searchable
    • sortable
  • periodName (string)

    The name of the accounting period for which supporting reference balance is maintained.

    Label

    Period Name

    Properties

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

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

    Label

    Period Net Activity Credit

    Properties

    • searchable
    • sortable
  • periodNetDebit (big-decimal)

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

    Label

    Period Net Activity Debit

    Properties

    • searchable
    • sortable
  • periodYear (big-decimal)

    The fiscal year of the accounting period for the supporting reference balance.

    Label

    Period Year

    Properties

    • searchable
    • sortable
  • supportingReference1 (string)

    The source value associated with Supporting Reference 1.

    Label

    Supporting Reference 1 Value

    Properties

    • searchable
    • sortable
  • supportingReference10 (string)

    The source value associated with Supporting Reference 10.

    Label

    Supporting Reference 10 Value

    Properties

    • searchable
    • sortable
  • supportingReference11 (string)

    The source value associated with Supporting Reference 11.

    Label

    Supporting Reference 11 Value

    Properties

    • searchable
    • sortable
  • supportingReference12 (string)

    The source value associated with Supporting Reference 12.

    Label

    Supporting Reference 12 Value

    Properties

    • searchable
    • sortable
  • supportingReference13 (string)

    The source value associated with Supporting Reference 13.

    Label

    Supporting Reference 13 Value

    Properties

    • searchable
    • sortable
  • supportingReference14 (string)

    The source value associated with Supporting Reference 14.

    Label

    Supporting Reference 14 Value

    Properties

    • searchable
    • sortable
  • supportingReference15 (string)

    The source value associated with Supporting Reference 15.

    Label

    Supporting Reference 15 Value

    Properties

    • searchable
    • sortable
  • supportingReference16 (string)

    The source value associated with Supporting Reference 16.

    Label

    Supporting Reference 16 Value

    Properties

    • searchable
    • sortable
  • supportingReference17 (string)

    The source value associated with Supporting Reference 17.

    Label

    Supporting Reference 17 Value

    Properties

    • searchable
    • sortable
  • supportingReference18 (string)

    The source value associated with Supporting Reference 18.

    Label

    Supporting Reference 18 Value

    Properties

    • searchable
    • sortable
  • supportingReference19 (string)

    The source value associated with Supporting Reference 19.

    Label

    Supporting Reference 19 Value

    Properties

    • searchable
    • sortable
  • supportingReference2 (string)

    The source value associated with Supporting Reference 2.

    Label

    Supporting Reference 2 Value

    Properties

    • searchable
    • sortable
  • supportingReference20 (string)

    The source value associated with Supporting Reference 20.

    Label

    Supporting Reference 20 Value

    Properties

    • searchable
    • sortable
  • supportingReference21 (string)

    The source value associated with Supporting Reference 21.

    Label

    Supporting Reference 21 Value

    Properties

    • searchable
    • sortable
  • supportingReference22 (string)

    The source value associated with Supporting Reference 22.

    Label

    Supporting Reference 22 Value

    Properties

    • searchable
    • sortable
  • supportingReference23 (string)

    The source value associated with Supporting Reference 23.

    Label

    Supporting Reference 23 Value

    Properties

    • searchable
    • sortable
  • supportingReference24 (string)

    The source value associated with Supporting Reference 24.

    Label

    Supporting Reference 24 Value

    Properties

    • searchable
    • sortable
  • supportingReference25 (string)

    The source value associated with Supporting Reference 25.

    Label

    Supporting Reference 25 Value

    Properties

    • searchable
    • sortable
  • supportingReference26 (string)

    The source value associated with Supporting Reference 26.

    Label

    Supporting Reference 26 Value

    Properties

    • searchable
    • sortable
  • supportingReference27 (string)

    The source value associated with Supporting Reference 27.

    Label

    Supporting Reference 27 Value

    Properties

    • searchable
    • sortable
  • supportingReference28 (string)

    The source value associated with Supporting Reference 28.

    Label

    Supporting Reference 28 Value

    Properties

    • searchable
    • sortable
  • supportingReference29 (string)

    The source value associated with Supporting Reference 29.

    Label

    Supporting Reference 29 Value

    Properties

    • searchable
    • sortable
  • supportingReference3 (string)

    The source value associated with Supporting Reference 3.

    Label

    Supporting Reference 3 Value

    Properties

    • searchable
    • sortable
  • supportingReference30 (string)

    The source value associated with Supporting Reference 30.

    Label

    Supporting Reference 30 Value

    Properties

    • searchable
    • sortable
  • supportingReference4 (string)

    The source value associated with Supporting Reference 4.

    Label

    Supporting Reference 4 Value

    Properties

    • searchable
    • sortable
  • supportingReference5 (string)

    The source value associated with Supporting Reference 5.

    Label

    Supporting Reference 5 Value

    Properties

    • searchable
    • sortable
  • supportingReference6 (string)

    The source value associated with Supporting Reference 6.

    Label

    Supporting Reference 6 Value

    Properties

    • searchable
    • sortable
  • supportingReference7 (string)

    The source value associated with Supporting Reference 7.

    Label

    Supporting Reference 7 Value

    Properties

    • searchable
    • sortable
  • supportingReference8 (string)

    The source value associated with Supporting Reference 8.

    Label

    Supporting Reference 8 Value

    Properties

    • searchable
    • sortable
  • supportingReference9 (string)

    The source value associated with Supporting Reference 9.

    Label

    Supporting Reference 9 Value

    Properties

    • searchable
    • sortable
  • supportingReferenceValues (string)

    The concatenated value of all the supporting references.

    Label

    Concatenated Supporting Reference Values

    Properties

    • searchable
    • sortable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

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

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • account (GeneralLedgerAccount)

    A general ledger account combination represents the specific grouping of segment values within the Oracle General Ledger. It provides details of all the valid account combinations for each accounting flexfield structure within the General Ledger.

    Business Object

    GeneralLedgerAccount

    Expand all

    Collapse all

    Fields

    • codeCombinationId (int64)

      The unique identifier of the account combination.

      Label

      Account ID

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable

  • enteredCurrency (Currency)

    Currencies are defined and populated through seed data and used to create transactions within the application. This object encapsulates various properties and functionalities related to a specific currency.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • ledger (Ledger)

    A ledger represents a record-keeping book used to track financial transactions. It serves as a central repository for all financial activities within an organization, providing a chronological and systematic account of debits, credits, and balances. Ledgers play a crucial role in financial management, budgeting, and maintaining accurate financial records, tracking expenses, revenues, assets, liabilities, and equity.

    Business Object

    Ledger

    Expand all

    Collapse all

    Fields

    • ledgerId (int64)

      The unique identifier of the ledger for which the accounting entry is created.

      Label

      Ledger ID

      Properties

      • searchable
      • sortable
      • not nullable

  • subledgerApplication (SubledgerApplication)

    A subledger application refers to the predefined applications or accounting hub source systems that use subledger accounting rules to generate accounting entries for their transactions. It stores details such as the application identifier, application type code, associated journal source and other relevant information associated with the subledger application.

    Business Object

    SubledgerApplication

    Expand all

    Collapse all

    Fields

    • applicationId (int64)

      The unique identifier of the source application that represents a functional area.

      Label

      Application

      Properties

      • searchable
      • sortable
      • not nullable

  • suppReferenceCombination (SubledgerSupportingReferenceCombination)

    A supporting reference combination consists of a unique combination of supporting references which is associated with a supporting reference combination identifier.

    Business Object

    SubledgerSupportingReferenceCombination

    Expand all

    Collapse all

    Fields

    • suppRefCombinationId (int64)

      The unique identifier of the supporting reference combinations.

      Label

      Supporting Reference Combination Identifier

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top