JournalLineReconciliation

A journal line reconciliation contains reconciled transactions for those accounts where clearing accounts reconciliation is enabled.

Expand all

Collapse all

Business Views

** Available for extracting data

• journalLinesReconciliationExtract**

  A journal line reconciliation contains reconciled transactions for those accounts where clearing accounts reconciliation is enabled.

  Label

  Journal Lines Reconciliation

  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
  • journalHeaderId (int64)

    Identifier of the journal header.

    Label

    Journal Header ID

    Properties

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

    Journal entry line number.

    Label

    Journal Line Number

    Properties

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

    Date when the clearing account journal lines were reconciled.

    Label

    Reconciliation Date

    Properties

    • searchable
    • sortable
  • reconciliationReference (string)

    Clearing accounts reconciliation reference information used to identify, group, and reconcile related journal lines during reconciliation.

    Label

    Reconciliation Reference

    Properties

    • searchable
    • sortable
  • reconciliationStatus (string)

    Reconciliation status associated with the clearing accounts journal lines. Possible values are Reconciled and Unreconciled.

    Label

    Reconciliation Status

    Properties

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

  • 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

  • reconRule (GeneralLedgerReconciliationRule)

    A general ledger reconciliation rule defines the reconciliation types that represent reconcilable clearing accounts and the associated rules that are applied to match and reconcile those clearing accounts.

    Business Object

    GeneralLedgerReconciliationRule

    Expand all

    Collapse all

    Fields

    • reconciliationRuleId (int64)

      Unique identifier of the reconciliation rule.

      Label

      Reconciliation Rule ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top