JournalBatches
Used to view journal batches, update batch completion status and reversal attributes, and delete journal batches.
Columns
| Name | Type | Description |
| JeBatchId [KEY] | Long | The unique identifier of the batch. |
| AccountedPeriodType | String | The accounting period type. |
| DefaultPeriodName | String | The accounting period of the journal batch. |
| BatchName | String | The name of the batch. |
| Status | String | The status of the batch. |
| ControlTotal | Decimal | The control total of the batch. |
| BatchDescription | String | The description of the batch. |
| ErrorMessage | String | The error for which the batch failed to post. |
| PostedDate | Date | The date when the batch was posted. |
| PostingRunId | Long | The unique sequence number assigned to a batch posting run. |
| RequestId | Long | The unique identifier for the last process run on the batch, such as an import request ID or a posting request ID. |
| RunningTotalAccountedCr | Decimal | The total accounted credit of the batch. |
| RunningTotalAccountedDr | Decimal | The total accounted debit of the batch. |
| RunningTotalCr | Decimal | The total entered credit of the batch. |
| RunningTotalDr | Decimal | The total entered debit of the batch. |
| CreatedBy | String | The user who created the batch. |
| CreationDate | Datetime | The date and time when the batch was created. |
| LastUpdateDate | Datetime | The date and time when the batch was last updated. |
| LastUpdatedBy | String | The user who last updated the batch. |
| ActualFlagMeaning | String | The balance type of the batch. Accepted values are Actual or Encumbrance. |
| ApprovalStatusMeaning | String | The batch approval status. |
| ApproverEmployeeName | String | The user who was the final approver of the batch. |
| FundsStatusMeaning | String | The budgetary control funds status of the batch. |
| ParentJeBatchName | String | The name of the corresponding batch in the primary ledger from which this batch was replicated. |
| ChartOfAccountsName | String | The chart of accounts associated with the batch. |
| StatusMeaning | String | The status of the batch. |
| CompletionStatusMeaning | String | The completion status of the batch. Accepted values are Incomplete or Complete. |
| UserPeriodSetName | String | The calendar name of the ledger associated with the journal. |
| UserJeSourceName | String | The source of the journal. Review and manage sources using the Setup and Maintenance work area, Manage Journal Sources task. |
| ReversalDate | Date | The reversal date for the journals in the batch. |
| ReversalPeriod | String | The reversal period for the journals in the batch. |
| ReversalFlag | Bool | The indicator for whether to reverse all journals in the batch. Accepted values are Y or N. |
| ReversalMethodMeaning | String | The reversal method for the journals in the batch. Accepted values are Change sign or Switch debit or credit. |
| AccountingPeriod | String | The accounting period of the batch. |
| BatchSource | String | The journal source of the batch. |
| BatchStatus | String | The status of the batch. |
| Finder | String | Used as a predefined finder to search the collection. Available finders: JournalsFinder, PrimaryKey. |
| JournalCategory | String | The name of the journal category for the batch. |
| JournalName | String | The name of the journal that belongs to the batch. |