Archived Journal Batch Audits
The Archived Journal Batch Audits view object contains archived information of the journal batch audits. 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.ArchiveGlBatchAuditExtractPVO
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 data set identifier for which a batch was created. A multiple group of identifiers may be associated with the same data set identifier. This is used for batches that weren't created by the Journal Import process. For example, an identifier for the set of data created by a particular 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 unique identifier of the employee who submitted the journal batch for approval. |
| Attribute1 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| Attribute10 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| Attribute2 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| Attribute3 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| Attribute4 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| Attribute5 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| Attribute6 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| Attribute7 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| Attribute8 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| Attribute9 | A segment for the General Ledger Journal Batch descriptive flexfield. |
| 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. |
| AuditActionType | The type of audition action such as insert, update, and delete. |
| AuditChangeBitMap | A bitmap of 1s and 0s for each column in the table. |
| AuditImpersonator | The original Impersonator User. |
| 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. |
| 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 | The description of the validation errors thrown for 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 provided by the user or source application. |
| ObjectVersionNumber | The number of times the journal batch audit 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 the 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 of 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. |