SubledgerAccountingEntryDistributionLink

A subledger accounting entry distribution link contains the subledger accounting entry header identifier, line number, account information, related debits or credits, and source distribution identifiers. This information is used to establish the relationship between source transactions and subledger accounting entry lines.

Expand all

Collapse all

Business Views

** Available for extracting data

• subledgerAccountingEntryDistributionLinksExtract**

  A subledger accounting entry distribution link contains the subledger accounting entry header identifier, line number, account information, related debits or credits, and source distribution identifiers. This information is used to establish the relationship between source transactions and subledger accounting entry lines.

  Label

  Subledger Accounting Entry Distribution Links

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountingPeriod (string)

    The corresponding accounting period of the subledger accounting entry.

    Label

    Accounting Period

    Properties

    • inherited
    • searchable
    • sortable
  • applicationId (int64)

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

    Label

    Application

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
  • calculateAcctdAmtsFlag (boolean)

    Indicates whether the accounted amounts are calculated by Subledger Accounting or passed through transaction objects. It has two values Y and N. Y indicates that accounted amounts are calculated by the accounting program. N indicates that accounted amounts were passed through the extract.

    Label

    Calculate Accounted Amounts Indicator

    Properties

    • searchable
    • sortable
  • calculateGLAmtsFlag (boolean)

    Indicates whether the gain or loss amounts are calculated by the accounting engine. It has two values Y and N. Y indicates that gain or loss amounts are calculated by the accounting program. N indicates that gain or loss amounts were passed through the extract.

    Label

    Calculate Gain or Loss Amounts Indicator

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
  • documentRoundingAcctdAmount (big-decimal)

    The rounding amount in the ledger currency calculated by the accounting engine for the document.

    Label

    Subledger Document Rounding Accounted Amount

    Properties

    • searchable
    • sortable
    • not readable
  • documentRoundingEnteredAmount (big-decimal)

    The rounding amount in the entered currency calculated by the accounting engine for the document.

    Label

    Subledger Document Rounding Entered Amount

    Properties

    • searchable
    • sortable
    • not readable
  • documentRoundingLevel (string)

    The document identifier for which the accounting engine performs the rounding. The Create Accounting process uses JournalEntryDistributionDocumentRoundingLevel and JournalEntryDistributionRoundingClassCode to group lines together to perform the rounding.

    Label

    Document Rounding Level

    Properties

    • searchable
    • sortable
    • not readable
  • eventClassCode (string)

    The short name of the event class associated with the subledger accounting entry.

    Label

    Event Class

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
  • gainOrLossRef (string)

    The source value of the Gain or Loss Reference accounting attribute. It's used to add journal lines in the gain or loss amount calculation.

    Label

    Gain or Loss Reference

    Properties

    • searchable
    • sortable
    • not readable
  • intermediateLineNumber (int64)

    The temporary line number generated by the accounting engine when entries are in the most detailed form.

    Label

    Intermediate Line Number

    Properties

    • inherited
    • 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

    Label

    Partition Group Code

    Properties

    • inherited
    • searchable
    • sortable
  • referenceAeLineNumber (int64)

    The temporary line number reference of the reversed journal entry line.

    Label

    Reference Line Number

    Properties

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

    The unique identifier of the reference subledger accounting entry header.

    Label

    Reference Subledger Accounting Entry Header Identifier

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
  • referenceLineNumber (int64)

    The number associated with the reference subledger accounting entry line.

    Label

    Reference Subledger Accounting Entry Line Identifier

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
  • roundingClassCode (string)

    Indicates the accounting class associated with the journal line. It's used as the grouping criteria for rounding. The Create Accounting Process uses JournalEntryDistributionRoundingClassCode and JournalEntryDistributionDocumentRoundingLevel to group lines together to perform the rounding. A list of accepted values is defined in the lookup type XLA_ACCOUNTING_CLASS.

    Label

    Rounding Class Short Name

    Properties

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

    The transaction source distribution identifier in the text format.

    Label

    Source Distribution Identifier Character 1

    Properties

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

    The transaction source distribution identifier in the text format.

    Label

    Source Distribution Identifier Character 2

    Properties

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

    The transaction source distribution identifier in the text format.

    Label

    Source Distribution Identifier Character 3

    Properties

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

    The transaction source distribution identifier in the text format.

    Label

    Source Distribution Identifier Character 4

    Properties

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

    The transaction source distribution identifier in the text format.

    Label

    Source Distribution Identifier Character 5

    Properties

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

    The transaction source distribution identifier in the numeric format.

    Label

    Source Distribution Identifier Number 1

    Properties

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

    The transaction source distribution identifier in the numeric format.

    Label

    Source Distribution Identifier Number 2

    Properties

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

    The transaction source distribution identifier in the numeric format.

    Label

    Source Distribution Identifier Number 3

    Properties

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

    The transaction source distribution identifier in the numeric format.

    Label

    Source Distribution Identifier Number 4

    Properties

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

    The transaction source distribution identifier in the numeric format.

    Label

    Source Distribution Identifier Number 5

    Properties

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

    The classification of the subledger transaction source distribution.

    Label

    Source Distribution Type

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
  • statisticalAmount (big-decimal)

    The statistical amount of a subledger accounting entry line.

    Label

    Statistical Amount

    Properties

    • inherited
    • searchable
    • sortable
  • subledgerJournalHeaderId (int64)

    The unique identifier of the subledger accounting entry.

    Label

    Subledger Accounting Entry Header Identifier

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

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

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
  • unroundedAccountedCr (big-decimal)

    The unrounded subledger accounting entry line credit amount in the ledger currency.

    Label

    Unrounded Accounted Amount Credit

    Properties

    • inherited
    • searchable
    • sortable
  • unroundedAccountedDr (big-decimal)

    The unrounded subledger accounting entry line debit amount in the ledger currency.

    Label

    Unrounded Accounted Amount Debit

    Properties

    • inherited
    • searchable
    • sortable
  • unroundedEnteredCr (big-decimal)

    The unrounded subledger accounting entry line credit amount in the entered currency.

    Label

    Unrounded Entered Amount Credit

    Properties

    • inherited
    • searchable
    • sortable
  • unroundedEnteredDr (big-decimal)

    The unrounded subledger accounting entry line debit amount in the entered currency.

    Label

    Unrounded Entered Amount Debit

    Properties

    • inherited
    • searchable
    • sortable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • subledgerAccountingEntryLine (SubledgerAccountingEntryLine)

    A subledger accounting entry line contains the accounting entry lines information for each subledger accounting entry. These lines contain the associated accounting entry header identifier, line number, and associated account information and related debits or credits.

    Business Object

    SubledgerAccountingEntryLine

    Expand all

    Collapse all

    Fields

    • subledgerJournalLineNumber (int64)

      The number associated with each subledger accounting entry line.

      Label

      Subledger Accounting Entry Line Number

      Properties

      • searchable
      • sortable
      • not nullable

  • subledgerAccountingEvent (SubledgerAccountingEvent)

    A subledger accounting event contains all information related to a specific accounting event and the transactions linked to the event which are used to generate accounting entries. It stores details associated with the accounting event such as the associated accounting event identifier, application identifier, event type, event status, event processing status, and other information associated with the accounting event.

    Business Object

    SubledgerAccountingEvent

    Expand all

    Collapse all

    Fields

    • eventId (int64)

      The unique identifier of the accounting event within an application and event class.

      Label

      Event Identifier

      Properties

      • searchable
      • sortable
      • not nullable

  • subledgerAccountingEventType (SubledgerAccountingEventType)

    A subledger accounting event type contains information related to the subledger accounting event types associated with an event class. It stores details such as the application identifier, entity code, event class code, event type code and other relevant information associated with the event type.

    Business Object

    SubledgerAccountingEventType

    Expand all

    Collapse all

    Fields

    • eventTypeCode (string)

      The short name of the event type.

      Label

      Event Type

      Properties

      • searchable
      • sortable
      • not nullable

  • subledgerJournalEntryRuleSet (SubledgerJournalEntryRuleSet)

    A subledger journal entry rule set represents a group of journal line rules, account rules, description rules and supporting reference assignments within an event type or for all event types within a event class. It stores details such as the application identifier, journal entry rule set, event class, event type, activation status and other relevant information associated with the journal entry rule set.

    Business Object

    SubledgerJournalEntryRuleSet

    Expand all

    Collapse all

    Fields

    • jersCode (string)

      The short name of the journal entry rule set.

      Label

      Journal Entry Rule Set Short Name

      Properties

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

      Indicates whether the journal entry rule set is predefined in the system.

      Label

      Journal Entry Rule Set Type

      Properties

      • searchable
      • sortable
      • not nullable

  • subledgerJournalLineRule (SubledgerJournalLineRule)

    A subledger journal line rule outlines the details of an accounting entry line within a subledger accounting entry. Each journal line rule is linked to a specific event class and contains details such as application identifier, entity, event class, natural side, accounting class and other relevant information associated with the journal line rule.

    Business Object

    SubledgerJournalLineRule

    Expand all

    Collapse all

    Fields

    • accountingLineCode (string)

      The short name of the journal line rule.

      Label

      Journal Line Rule Short Name

      Properties

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

      Indicates whether the journal line rule is predefined.

      Label

      Journal Line Rule Type

      Properties

      • searchable
      • sortable
      • not nullable

  • taxLineReference (TaxLine)

    The tax line represents the details of the tax calculated for an item line for a purchase or sales transaction. It includes details such as the rate applied and the tax amount.

    Business Object

    TaxLine

    Expand all

    Collapse all

    Fields

    • taxLineId (int64)

      The unique identifier of the tax line.

      Label

      Tax Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • taxRecNrecDistributionReference (PurchaseTransactionTaxDistribution)

    Purchase tax distribution refers to the tax distributions for taxable purchase transactions.

    Business Object

    PurchaseTransactionTaxDistribution

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier for the recoverable and nonrecoverable tax distribution.

      Label

      Recoverable and Nonrecoverable Tax Distribution ID

      Properties

      • searchable
      • sortable
      • not nullable

  • taxSummaryLineReference (SummaryTaxLine)

    Summary tax line provides summarized information for transaction tax lines associated with a Payable transaction.

    Business Object

    SummaryTaxLine

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the summary tax line associated with this tax line.

      Label

      Summary Tax Line ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top