SubledgerAccountingEntryHeader

A subledger accounting entry header consists of accounting entries generated by the Accounting program with a one-to-many relationship between subledger accounting entry and subledger accounting entry lines. It stores these entries, containing the associated accounting entry header identifier, ledger identifier, accounting period, subledger application, journal category, accounting entry status, transfer status, and other information about the accounting entry.

Expand all

Collapse all

Business Views

** Available for extracting data

• subledgerAccountingEntryHeadersExtract**

  A subledger accounting entry header consists of accounting entries generated by the Accounting program with a one-to-many relationship between subledger accounting entry and subledger accounting entry lines. It stores these entries, containing the associated accounting entry header identifier, ledger identifier, accounting period, subledger application, journal category, accounting entry status, transfer status, and other information about the accounting entry.

  Label

  Subledger Accounting Entry Headers

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountingDate (date)

    The date that's used to determine the accounting period of the subledger accounting entry and when the entry appears in fiscal reports and queries.

    Label

    Accounting Date

    Properties

    • searchable
    • sortable
    • not nullable
  • accountingEntryTypeCode (enumeration: AccountingEntryTypeEnum)

    Indicates the type of a subledger accounting entry, with possible values including standard, manual, upgrade, or multiperiod.

    Label

    Accounting Entry Type

    Type

    • Module: oraErpCoreSubledgerAccountingEntries

    • Enumeration Type: AccountingEntryTypeEnum

    Properties

    • searchable
    • sortable
    • not nullable

    Valid Values

    • DEFERRED
    • MANUAL
    • MERGE
    • STANDARD
  • accountingSequenceNumber (big-decimal)

    The accounting sequence value for the subledger accounting entry.

    Label

    Accounting Sequence Number

    Properties

    • searchable
    • sortable
  • accrualReversalFlag (boolean)

    Indicates whether the subledger accounting entry is an accrual reversal entry.

    Label

    Accrual Reversal Indicator

    Properties

    • searchable
    • sortable
  • applicationId (int64)

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

    Label

    Application

    Properties

    • searchable
    • sortable
    • not nullable
  • balanceTypeCode (enumeration: BalanceTypeEnum)

    Indicates whether the type of balance is actual or encumbrance.

    Label

    Balance Type

    Type

    • Module: oraErpCoreSubledgerAccountingEntries

    • Enumeration Type: BalanceTypeEnum

    Properties

    • searchable
    • sortable
    • not nullable

    Valid Values

    • A
    • B
    • E
  • completedDate (date)

    The date when the subledger accounting entry was completed.

    Label

    Completion Date

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

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

    The document sequence value for the subledger transaction.

    Label

    Document Sequence Value

    Properties

    • searchable
    • sortable
  • fundsStatusCode (enumeration: FundsStatusEnum)

    Indicates the status resulting from a fund check performed on a journal entry.

    Label

    Funds Status

    Type

    • Module: oraErpCoreSubledgerAccountingEntries

    • Enumeration Type: FundsStatusEnum

    Properties

    • searchable
    • sortable

    Valid Values

    • A
    • F
    • FAILED
    • INPROCESS
    • P
    • PASSED
    • R
    • REQUIRED
    • S
  • generalLedgerTransferDate (date)

    The date when the subledger accounting entry is transferred to general ledger.

    Label

    General Ledger Transfer Date

    Properties

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

    Indicates whether the subledger accounting entry contains any line that requires multiperiod accounting.

    Label

    Multiperiod Accounting Indicator

    Properties

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

    • searchable
    • sortable
  • periodName (string)

    The accounting period associated with the subledger accounting entry.

    Label

    Period Name

    Properties

    • searchable
    • sortable
  • reportingSequenceNumber (big-decimal)

    The reporting sequence value for the subledger accounting entry.

    Label

    Reporting Sequence Number

    Properties

    • searchable
    • sortable
  • subledgerJournalDescription (string)

    The description of the subledger accounting entry provided by the user or source application.

    Label

    Subledger Accounting Entry Description

    Properties

    • searchable
    • sortable
  • subledgerJournalHeaderId (int64)

    The unique identifier of the subledger accounting entry.

    Label

    Subledger Accounting Entry Header Identifier

    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
  • zeroAmountFlag (boolean)

    Indicates whether the entry is a zero-amount entry. A list of accepted values is defined in the lookup type YES_NO.

    Label

    Zero Amount Indicator

    Properties

    • searchable
    • sortable

  Expand all

  Collapse all

  Reference Object

  • accountingEntryStatusLookup (ERPLookupCode)

    Indicates the accounting status of the subledger accounting entry.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • accountingSequence (SequenceVersion)

    The unique identifier of the accounting sequence version associated with the subledger journal. This is a primary key of the CompAcctSeqVersions entity object.

    Business Object

    SequenceVersion

    Expand all

    Collapse all

    Fields

    • headerName (string)

      Name of the sequence definition.

      Label

      Sequence Name

      Properties

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

      Identifier of the sequence version.

      Label

      Sequence Version ID

      Properties

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

      Name of the sequence version.

      Label

      Sequence Version Name

      Properties

      • searchable
      • sortable
      • not nullable

  • closingSequence (SequenceVersion)

    The unique identifier of the reporting sequence version associated with the subledger journal. This is a primary key of the CloseAcctSeqVersions entity object.

    Business Object

    SequenceVersion

    Expand all

    Collapse all

    Fields

    • headerName (string)

      Name of the sequence definition.

      Label

      Sequence Name

      Properties

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

      Identifier of the sequence version.

      Label

      Sequence Version ID

      Properties

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

      Name of the sequence version.

      Label

      Sequence Version Name

      Properties

      • searchable
      • sortable
      • not nullable

  • generalLedgerTransferStatusLookup (ERPLookupCode)

    Indicates the general ledger transfer status of the subledger accounting entry.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • journalCategory (JournalCategory)

    A journal category contains the category information that identifies the purpose of a journal, such as Adjustments or Invoices.

    Business Object

    JournalCategory

    Expand all

    Collapse all

    Fields

    • jeCategoryName (string)

      Name of the journal category.

      Label

      Category Name

      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

  • legalEntity (LegalEntity)

    A legal entity represents an entity created under a commercial law which can own property, create obligation, recruit people, trade, account for themselves to regulators, taxation authorities, and owners. It identifies the legal owner or custodian for each business transaction for legal compliance and reporting.

    Business Object

    LegalEntity

    Expand all

    Collapse all

    Fields

    • legalEntityId (int64)

      The unique identifier of the legal entity. This is the primary key of the Legal Entities view object.

      Label

      Legal Entity ID

      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

  • subledgerTransactionEntity (SubledgerTransactionEntity)

    A subledger transaction entity represents a transaction for which accounting events have been generated in subledger accounting. It stores details such as the associated entity code, source identifiers, and security identifiers, which are provided by the subledger based on its data and security model.

    Business Object

    SubledgerTransactionEntity

    Expand all

    Collapse all

    Fields

    • entityId (int64)

      The unique identifier of the subledger transactions associated with the accounting events.

      Label

      Entity ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top