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.

Expand all

Collapse all

Business Views

** Available for extracting data

• subledgerAccountingEventsExtract**

  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.

  Label

  Subledger Accounting Events

  Data Source

  Read-optimized data store

  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
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

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

    The date when the accounting event is created.

    Label

    Event Date

    Properties

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

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

    Label

    Event Identifier

    Properties

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

    The number associated with an accounting event used by the accounting program to process multiple events pertaining to the same entity

    Label

    Event Number

    Properties

    • searchable
    • sortable
    • not nullable
  • eventStatusCode (enumeration: EventStatusEnum)

    Indicates the status of the accounting entries generated for the event.

    Label

    Event Status

    Type

    • Module: oraErpCoreSubledgerAccountingEntries

    • Enumeration Type: EventStatusEnum

    Properties

    • searchable
    • sortable

    Valid Values

    • I
    • N
    • P
    • U
  • fileIdentifier (string)

    File Name or OCI object storage identifier of the data file using which the transaction was created.

    Label

    File Identifier

    Properties

    • searchable
    • sortable
    • not readable
  • processStatusCode (enumeration: ProcessStatusEnum)

    Indicates the processing status of the event within the accounting program.

    Label

    Process Status

    Type

    • Module: oraErpCoreSubledgerAccountingEntries

    • Enumeration Type: ProcessStatusEnum

    Properties

    • searchable
    • sortable

    Valid Values

    • D
    • E
    • I
    • P
    • R
    • U
  • 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
  • transactionDate (date)

    The date when a business transaction occurred.

    Label

    Transaction Date

    Properties

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

  • 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