JournalBatch

A journal batch contains information such as batch name and description, status, and running total debits and credits. The batch status indicates whether it has been posted, selected for posting, or in the process of being posted.

Expand all

Collapse all

Business Views

** Available for extracting data

• journalBatchesExtract**

  A journal batch contains information such as batch name and description, status, and running total debits and credits. The batch status indicates whether it has been posted, selected for posting, or in the process of being posted.

  Label

  Journal Batches

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountedPeriodType (string)

    Type of accounting period such as Weekly, Monthly, Quarterly, which is automatically generated based on user input.

    Label

    Period Type

    Properties

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

    Default accounting period for the journal batch.

    Label

    Accounting Period

    Properties

    • searchable
    • sortable
  • batchAccountedCredit (big-decimal)

    Accumulated total accounted credit amounts at the batch level.

    Label

    Batch Accounted Credit

    Properties

    • searchable
    • sortable
  • batchAccountedDebit (big-decimal)

    Accumulated total accounted debit amounts at the batch level.

    Label

    Batch Accounted Debit

    Properties

    • searchable
    • sortable
  • batchEnteredCredit (big-decimal)

    Accumulated total entered credit amounts at the batch level.

    Label

    Batch Entered Credit

    Properties

    • searchable
    • sortable
  • batchEnteredDebit (big-decimal)

    Accumulated total entered debit amounts at the batch level.

    Label

    Batch Entered Debit

    Properties

    • searchable
    • sortable
  • controlTotal (big-decimal)

    Control total entered for a journal batch to validate that the batch is complete.

    Label

    Control Total

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable
  • dateCreated (date)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
  • defaultEffectiveDate (date)

    Date within default accounting period of the journal batch.

    Label

    Default Accounting Date

    Properties

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

    User-defined description of the journal batch.

    Label

    Description

    Properties

    • searchable
    • sortable
  • errorMessage (string)

    The description of the validation errors thrown for the journal batch.

    Label

    Error

    Properties

    • searchable
    • sortable
  • journalBatchId (int64)

    Unique identifier of the journal batch.

    Label

    Batch ID

    Properties

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

    Name of the journal batch.

    Label

    Journal Batch

    Properties

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

    Date when the journal entry is posted to the general ledger.

    Label

    Posting Date

    Properties

    • searchable
    • sortable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

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

    The date and time when the record was last updated.

    Label

    Last Updated 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 readable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • lookupApprovalStatus (ERPLookupCode)

    The approval status of the journal entry batch. A list of accepted values is defined in the lookup type JE_BATCH_APPROVAL_STATUS.

    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

  • lookupBalanceType (ERPLookupCode)

    Identifies whether the journal balance type is an actual or encumbrance journal. A list of accepted values is defined in the lookup type BATCH_TYPE. This attribute is a part of the composite key of the Ledger Balance view object.

    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

  • lookupBatchStatus (ERPLookupCode)

    Status of the journal header. A list of accepted values is defined in the lookup type MJE_BATCH_STATUS.

    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

  • lookupFundsStatus (StandardLookupCode)

    The funds check status of the journal entry batch. A list of accepted values is defined in the lookup type XCC_BC_FUNDS_STATUSES.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • parentJeBatch (JournalBatch)

    Journal batch name of the originating journal.

    Business Object

    JournalBatch

    Expand all

    Collapse all

    Fields

    • journalBatchId (int64)

      Unique identifier of the journal batch.

      Label

      Batch ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top