Archived Journal Batches
The Archived Journal Batches view object contains archived information of the journal batches. Each row of this object stores the batch name, description, status, running total debits and credits, and other information.
Data Store Key : FscmTopModelAM.FinExtractAM.FinArchiveBiccExtractAM.ArchiveGlBatchExtractPVO
Primary Keys : JeBatchId
Initial Extract Date : CreationDate
Incremental Extract Date :
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AccountedPeriodType | The accounting period type of the journal batch. |
| AccountingBatchId | The unique identifier of the data set for which a batch was created. A multiple group of identifiers can be associated with the a single data set identifier. This attribute is used for batches that aren't created by the Journal Import process. For example, an identifier for the set of data created by Create Accounting process. |
| ActualFlag | 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. |
| ApprovalStatusCode | The code that identifies the approval status of the journal entry batch. A list of accepted values is defined in the lookup type JE_BATCH_APPROVAL_STATUS. |
| ApproverEmployeeId | The accounting period type of the journal batch. |
| Attribute1 | The accounting period type of the journal batch. |
| Attribute10 | The accounting period type of the journal batch. |
| Attribute2 | The accounting period type of the journal batch. |
| Attribute3 | The accounting period type of the journal batch. |
| Attribute4 | The accounting period type of the journal batch. |
| Attribute5 | The accounting period type of the journal batch. |
| Attribute6 | The accounting period type of the journal batch. |
| Attribute7 | The accounting period type of the journal batch. |
| Attribute8 | The accounting period type of the journal batch. |
| Attribute9 | The accounting period type of the journal batch. |
| AttributeCategory | The descriptive flexfield context name for the Journal Batch descriptive flexfield. |
| AttributeCategory2 | The descriptive flexfield context name for the Journal Batch descriptive flexfield. |
| AttributeDate1 | A date segment for the Journal Batch descriptive flexfield. |
| AttributeDate2 | A date segment for the Journal Batch descriptive flexfield. |
| AttributeDate3 | A date segment for the Journal Batch descriptive flexfield. |
| AttributeDate4 | A date segment for the Journal Batch descriptive flexfield. |
| AttributeDate5 | A date segment for the Journal Batch descriptive flexfield. |
| AttributeNumber1 | A number segment for the Journal Batch descriptive flexfield. |
| AttributeNumber2 | A number segment for the Journal Batch descriptive flexfield. |
| AttributeNumber3 | A number segment for the Journal Batch descriptive flexfield. |
| AttributeNumber4 | A number segment for the Journal Batch descriptive flexfield. |
| AttributeNumber5 | A number segment for the Journal Batch descriptive flexfield. |
| AutorunRequestId | The unique identifier of the automatic accounting process that last attempted to approve a batch. |
| AverageJournalFlag | Indicates whether the journal is an average balance journal. A list of accepted values is defined in the lookup type YES_NO.. |
| BudgetaryControlStatus | Oracle internal use only. |
| ChartOfAccountsId | The unique identifier of the accounting flexfield used for the ledger. This is a foreign key to the Accounting Flexfield view object. |
| ControlTotal | The control total of a journal batch in the ledger currency. |
| CreatedBy | The user who created the journal batch. |
| CreationDate | The date and time when the journal batch was created. |
| DateCreated | The date when the journal batch was created. |
| DefaultEffectiveDate | Default effective accounting date of the journal batch that's within the default accounting period. |
| DefaultPeriodName | Default accounting period name of the journal batch. This is a foreign key of Fiscal Period view object. |
| Description | The description of the journal batch provided by the user or source application. |
| EarliestPostableDate | The earliest date a journal batch can be posted. |
| ErrorMessage | Validation errors of the journal batch. |
| FundsStatusCode | The code that identifies the funds status. This helps to identify if the funds are reserved for journal batch. A list of accepted values is defined in the lookup type XCC_BC_FUNDS_STATUSES. |
| GroupId | The unique identifier of the group if the data is loaded from the interface tables. |
| HasWarningsFlag | Indicates if there are warnings associated with the journal batch. |
| JeBatchId | The unique identifier of the journal entry batch. This is a primary key of the Journal Batch view object. |
| JeSource | The source of the journal batch. This is a foreign key of the Journal Source view object. |
| LastUpdateDate | The date when the journal batch row was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the journal batch. |
| LastUpdatedBy | The user who last updated the journal batch. |
| Name | The name of the journal batch. |
| ObjectVersionNumber | The number of times the journal batch action row has been updated. |
| ParentJeBatchId | The unique identifier of the parent journal batch. |
| PartitionGroupCode | The code that identifies the partition group. The partition grouping information, when combined with the period, determines the database partition where the journal batch will be stored. |
| PeriodSetName | The unique identifier of the accounting calendar name. This is a foreign key of the Fiscal Period view object. |
| PostedDate | The date when journal batch was posted. |
| PostingEligibilityCode | The code that identifies journal batch posting eligibility. |
| PostingRunId | The unique sequence number that's generated when the posting is run. |
| RequestId | The unique identifier of the job that created or last updated the row. |
| RunningTotalAccountedCr | The running total credits of a journal batch in the ledger currency. |
| RunningTotalAccountedDr | The running total debits of a journal batch in the ledger currency. |
| RunningTotalCr | The running total credits of a journal batch in the entered currency. |
| RunningTotalDr | The running total debits of a journal batch in the entered currency. |
| Status | The posting status for the journal batch. A list of accepted values is defined in the lookup type MJE_BATCH_STATUS. |
| StatusVerified | Indicates if the batch status is verified by the posting process. |
| UnreservationPacketId | The unique identifier of the journal batch packet for cancellation of funds reservation. |