Journal Batch
The journal batch view object contains information for the journal batch, such as batch name and description, status, running total debits and credits, and so on.
Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalBatchExtractPVO
Primary Keys : JournalBatchJeBatchId
Initial Extract Date : JournalBatchCreationDate
Incremental Extract Date : JournalBatchLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| JournalBatchAccountedPeriodType | The accounting period type of the journal batch. |
| JournalBatchActualFlag | The balance type that helps identify whether the journal is an actual or encumbrance journal. A list of accepted values is defined in the lookup type BATCH_TYPE. |
| JournalBatchApprovalStatusCode | The approval status of the journal entry batch. A list of accepted values is defined in the lookup type JE_BATCH_APPROVAL_STATUS. |
| JournalBatchApproverEmployeeId | The unique identifier of the employee who submitted the journal batch for approval. |
| JournalBatchAttribute1 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttribute10 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttribute2 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttribute3 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttribute4 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttribute5 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttribute6 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttribute7 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttribute8 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttribute9 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttributeCategory | The descriptive flexfield context name for the Journal Batch descriptive flexfield. |
| JournalBatchAttributeDate1 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttributeDate2 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttributeDate3 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttributeDate4 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttributeDate5 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttributeNumber1 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttributeNumber2 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttributeNumber3 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttributeNumber4 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAttributeNumber5 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| JournalBatchAverageJournalFlag | Indicates whether the journal is an average balance journal. A list of accepted values is defined in the lookup type YES_NO. |
| JournalBatchChartOfAccountsId | The unique identifier of the accounting flexfield used for the ledger. This is a foreign key to the KeyFlexStructure Instances view object. |
| JournalBatchControlTotal | The control total of a journal batch in the ledger currency. |
| JournalBatchCreatedBy | The user who created the journal batch. |
| JournalBatchCreationDate | The date and time when the journal batch was created. |
| JournalBatchDateCreated | The date when the journal batch was created. |
| JournalBatchDefaultEffectiveDate | The accounting date of the journal batch that falls within the default accounting period. |
| JournalBatchDefaultPeriodName | The identifier of the accounting period of the journal batch. This is a foreign key of Fiscal Period view object. |
| JournalBatchDescription | The description of the journal batch provided by the user or source application. |
| JournalBatchErrorMessage | The description of the validation errors thrown for the journal batch. |
| JournalBatchFundsStatusCode | The fund check status helps to identify whether funds are reserved for journal batch. A list of accepted values is defined in the lookup type XCC_BC_FUNDS_STATUSES. |
| JournalBatchGroupId | The identifier of the group when the data is loaded from the interface tables. |
| JournalBatchJeBatchId | The unique identifier of the journal entry batch. This is a primary key of the Journal Batch view object. |
| JournalBatchJeSource | The source of the journal batch. This is a foreign key of the Journal Source view object. |
| JournalBatchLastUpdateDate | The date when the journal batch row was last updated. |
| JournalBatchLastUpdateLogin | The session login associated with the user who last updated the journal batch. |
| JournalBatchLastUpdatedBy | The user who last updated the journal batch row. |
| JournalBatchName | The name of the journal batch provided by the user or source application. |
| JournalBatchObjectVersionNumber | The number of times the journal batch row has been updated. |
| JournalBatchParentJeBatchId | The unique identifier of the parent journal batch in the source reporting currency ledger. |
| JournalBatchPeriodSetName | The unique identifier of the name of the accounting calendar. This is a foreign key of the Fiscal Period view object. |
| JournalBatchPostedDate | The date when the journal batch was posted. |
| JournalBatchPostingRunId | The unique sequence number generated when posting was run. |
| JournalBatchRequestId | The unique identifier of the job that created or last updated the row. |
| JournalBatchRunningTotalAccountedCr | The running total credits of a journal batch in the ledger currency. |
| JournalBatchRunningTotalAccountedDr | The running total debits of a journal batch in the ledger currency. |
| JournalBatchRunningTotalCr | The running total credits of a journal batch in the entered currency. |
| JournalBatchRunningTotalDr | The running total debits of a journal batch in the entered currency. |
| JournalBatchStatus | The posting status for the journal batch. A list of accepted values is defined in the lookup type MJE_BATCH_STATUS. |