LedgerRelationship

The ledger relationship provides the details of the relationships between ledgers. Each relationship between a primary ledger and a secondary ledger or between a ledger and its reporting currency is stored separately.

Expand all

Collapse all

Business Views

** Available for extracting data

• ledgerRelationshipsExtract**

  The ledger relationship provides the details of the relationships between ledgers. Each relationship between a primary ledger and a secondary ledger or between a ledger and its reporting currency is stored separately.

  Label

  Ledger Relationships

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • automaticPostFlag (boolean)

    Indicates whether to automatically post journals in the target ledger. If Y, then automatic posting of journals in the target ledger is enabled. If N, then automatic posting of journals in the target ledger isn't enabled.

    Label

    Automatic Post

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • searchable
    • sortable
    • not nullable
  • disableConversionDate (date)

    Date when the conversion date is disabled.

    Label

    Disable Currency Conversion Date

    Properties

    • searchable
    • sortable
  • inheritCreationUserFlag (boolean)

    Indicates whether to inherit user creation from source transaction is enabled. Possible values include Y for inherit user creation from source transaction is enabled and N for user creation from source transaction isn't enabled.

    Label

    Retain Journal Creator from Source Ledger

    Properties

    • searchable
    • sortable
    • not nullable
  • relationshipEnabledFlag (boolean)

    Indicates whether a ledger relationship is enabled. If Y, then a ledger relationship is enabled. If N, then a ledger relationship isn't enabled.

    Label

    Conversion Status

    Properties

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

    The unique identifier for the ledger relationship.

    Label

    Ledger Relationship ID

    Properties

    • searchable
    • sortable
    • not nullable
  • relationshipTypeCode (enumeration: LedgerRelationshipType)

    The relationship level between the source and target ledger. A list of accepted values is defined in the lookup type GL_ASF_ALC_RELATIONSHIP_LEVEL. The default value is BALANCE

    Label

    Relationship Type

    Type

    • Module: oraErpCoreStructure

    • Enumeration Type: LedgerRelationshipType

    Properties

    • searchable
    • sortable
    • not nullable

    Valid Values

    • ADJUST
    • BALANCE
    • JOURNAL
    • NONE
    • SUBLEDGER
  • reportingCurrencyInheritConversionTypeFlag (boolean)

    Indicates whether to inherit the conversion rate type from the transaction. If Y, then the conversion rate type is inherited from the transaction. If N, then the conversion rate type isn't inherited from the transaction.

    Label

    Retain Transaction Rate Type

    Properties

    • searchable
    • sortable
  • targetLedgerCategoryCode (enumeration: LedgerCategory)

    The category of the target ledger. A list of accepted values is defined in the lookup type GL_ASF_LEDGER_CATEGORY. The default value is ALC, which represents reporting currency.

    Label

    Target Ledger Category

    Type

    • Module: oraErpCoreStructure

    • Enumeration Type: LedgerCategory

    Properties

    • searchable
    • sortable
    • not nullable

    Valid Values

    • ALC
    • PRIMARY
    • SECONDARY
  • targetLedgerName (string)

    The name that the user entered for the target ledger.

    Label

    Target Ledger

    Properties

    • searchable
    • sortable
    • not nullable
  • 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

  • currency (Currency)

    Currency of the target ledger.

    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

  • journalConversion (CurrencyConversionRateType)

    Identifier of the journal conversion rules.

    Business Object

    CurrencyConversionRateType

    Expand all

    Collapse all

    Fields

    • conversionRateType (string)

      The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.

      Label

      Conversion Rate Type

      Properties

      • searchable
      • sortable
      • not nullable

  • primaryLedger (Ledger)

    Identifier of the ledger of the primary ledger as defined in the accounting configuration.

    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

  • reportingCurrencyDefaultConversion (CurrencyConversionRateType)

    A currency conversion rate type defines conversion rate types such as Corporate, Daily, Period End, and Period Average. These conversion rate types are used to convert foreign currency journal amounts to ledger currency equivalents or translate and remeasure account balances to a reporting currency.

    Business Object

    CurrencyConversionRateType

    Expand all

    Collapse all

    Fields

    • conversionRateType (string)

      The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.

      Label

      Conversion Rate Type

      Properties

      • searchable
      • sortable
      • not nullable

  • slaLedger (Ledger)

    Identifier of the ledger in the subledger transactions that are used for creating subledger accounting entries.

    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

  • targetLedger (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

Back to Top