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.

Expand all

Collapse all

Business Views

** Available for extracting data

• subledgerTransactionEntitiesExtract**

  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.

  Label

  Subledger Transaction Entities

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

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

    The short name of the entity associated with the event type.

    Label

    Entity Code

    Properties

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

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

    Label

    Entity ID

    Properties

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

    The integer security identifier value passed to Subledger Accounting by each subledger based on its security model.

    Label

    Security ID Integer 1

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable
  • sourceIdChar1 (string)

    The value passed to Subledger Accounting by each subledger based on its data model.

    Label

    Source Distribution Identifier Character 1

    Properties

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

    The value passed to Subledger Accounting by each subledger based on its data model.

    Label

    Source Transaction Identifier Integer 1

    Properties

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

    The value passed to Subledger Accounting by each subledger based on its data model.

    Label

    Source Transaction Identifier Integer 2

    Properties

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

    The value passed to Subledger Accounting by each subledger based on its data model.

    Label

    Source Transaction Identifier Integer 3

    Properties

    • searchable
    • sortable
    • not readable
  • 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
  • transactionNumber (string)

    The Subledger transaction for which the journal entry is created.

    Label

    Transaction Number

    Properties

    • searchable
    • sortable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • 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

  • 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

Back to Top