Archived Journal Audits
The Archived Journal Audits view object contains archived information of the journal audits. Each row of this object stores the batch ID, journal entry name and description, and other information about the journal entry.
Data Store Key : FscmTopModelAM.FinExtractAM.FinArchiveBiccExtractAM.ArchiveGlHeaderAuditExtractPVO
Primary Keys : JeHeaderId
Initial Extract Date : CreationDate
Incremental Extract Date :
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AccrualRevChangeSignFlag | The type of journal reversal. A list of accepted values are defined in the lookup type YES_NO. The value is passed as a parameter to attribute GlJeHeadersAccrualRevChangeSignFlagTransient. |
| AccrualRevEffectiveDate | The accounting date of the journal created from a reversal. |
| AccrualRevFlag | Indicates whether the journal is an average balances journal. A list of accepted values is defined in the lookup type YES_NO. |
| AccrualRevJeHeaderId | The unique identifier of the journal created from a reversal. |
| AccrualRevPeriodName | The accounting period of the journal created from a reversal. This is a foreign key to the Fiscal Period view object. |
| AccrualRevStatus | Indicates whether the journal has been reversed. A list of accepted values is defined in the lookup type JE_REVERSAL_STATUS. |
| ActualFlag | Identifies whether the journal is an actual or encumbrance journal. A list of accepted values is defined in the lookup type BATCH_TYPE. |
| Attribute1 | A segment for the General Ledger Journal descriptive flexfield. |
| Attribute10 | A segment for the General Ledger Journal descriptive flexfield. |
| Attribute2 | A segment for the General Ledger Journal descriptive flexfield. |
| Attribute3 | A segment for the General Ledger Journal descriptive flexfield. |
| Attribute4 | A segment for the General Ledger Journal descriptive flexfield. |
| Attribute5 | A segment for the General Ledger Journal descriptive flexfield. |
| Attribute6 | A segment for the General Ledger Journal descriptive flexfield. |
| Attribute7 | A segment for the General Ledger Journal descriptive flexfield. |
| Attribute8 | A segment for the General Ledger Journal descriptive flexfield. |
| Attribute9 | A segment for the General Ledger Journal descriptive flexfield. |
| AttributeCategory | The context name for the Journals descriptive flexfield. |
| AttributeCategory2 | The context name for the Journals descriptive flexfield. |
| AttributeDate1 | A date segment for the General Ledger Journal descriptive flexfield. |
| AttributeDate2 | A date segment for the General Ledger Journal descriptive flexfield. |
| AttributeDate3 | A date segment for the General Ledger Journal descriptive flexfield. |
| AttributeDate4 | A date segment for the General Ledger Journal descriptive flexfield. |
| AttributeDate5 | A date segment for the General Ledger Journal descriptive flexfield. |
| AttributeNumber1 | A number segment for the General Ledger Journal descriptive flexfield. |
| AttributeNumber2 | A number segment for the General Ledger Journal descriptive flexfield. |
| AttributeNumber3 | A number segment for the General Ledger Journal descriptive flexfield. |
| AttributeNumber4 | A number segment for the General Ledger Journal descriptive flexfield. |
| AttributeNumber5 | A number segment for the General Ledger Journal 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. |
| BalancedJeFlag | Indicates whether the journal is balanced. A list of accepted values is defined in the lookup type YES_NO. |
| BalancingSegmentValue | The key flexfield structure balancing segment value. |
| BudgetVersionId | The unique identifier of the budget version. |
| CloseAcctSeqAssignId | The identifier of the sequence assignment used when closing a period. |
| CloseAcctSeqValue | A sequence value assigned during the period close. |
| CloseAcctSeqVersionId | The identifier of the sequence version used during the period close. This is a foreign key to the CloseAcctSeqVersions entity object. |
| ControlTotal | The control amount of the journal. |
| ConversionFlag | Indicates whether the currency conversion is allowed for the journal header. |
| CrBalSegValue | The balancing segment value used on the credit side of an intercompany journal. This attribute is meaningful only for intercompany modes 1 and 3. |
| CreatedBy | The user who created the journal. |
| CreationDate | The date and time when the journal was created. |
| CurrencyCode | The code representing the currency on the journal entry header. This is a foreign key to the Currencies view object. |
| CurrencyConversionDate | The date as of which a conversion rate is used to convert an amount in the journal. |
| CurrencyConversionRate | The currency conversion rate used to convert the entered currency to ledger currency for a journal entry. |
| CurrencyConversionType | The currency conversion rate type of the journal. This is a foreign key to the Daily Conversion Type view object. |
| DateCreated | The date and time when the journal header was created. |
| DefaultEffectiveDate | The accounting date of the journal. |
| Description | The description of the journal header provided by the user or source application. |
| DisplayAlcJournalFlag | Indicates whether the journal is posted in the reporting currency. A list of accepted values is defined in the lookup type YES_NO. |
| DocSequenceId | The sequential numbering sequence of the documents. |
| DocSequenceValue | The sequential numbering sequence value of the documents. |
| DrBalSegValue | The balancing segment value used on the debit side of an intercompany journal. |
| EarliestPostableDate | The earliest date when the journal entry header can be posted. |
| EncumbranceTypeId | The unique identifier of the journal encumbrance type. This is a foreign key to the Journal Encumbrance Type entity object. |
| FromRecurringHeaderId | The unique identifier of the recurring batch header. |
| GlobalAttribute1 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute10 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute11 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute12 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute13 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute14 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute15 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute16 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute17 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute18 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute19 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute2 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute20 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute3 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute4 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute5 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute6 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute7 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute8 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttribute9 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttributeCategory | The context name for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttributeDate1 | A date segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttributeDate2 | A date segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttributeDate3 | A date segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttributeDate4 | A date segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttributeDate5 | A date segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttributeNumber1 | A number segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttributeNumber2 | A number segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttributeNumber3 | A number segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttributeNumber4 | A number segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlobalAttributeNumber5 | A number segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| IntercompanyMode | Indicates the intercompany mode of the journal. Valid values are 1 through 4. |
| JeBatchId | The unique identifier of the journal batch. This is a foreign key to the Journal Batch view object. |
| JeCategory | The category of the journal. This is a foreign key to the Journal Category view object. |
| JeFromSlaFlag | Indicates whether the journal is created from the subledger accounting process. A list of accepted values is defined in the lookup type YES_NO. |
| JeHeaderId | The unique identifier of the journal entry header. |
| JeSource | The source of the journal. This is a foreign key to the Journal Source view object. |
| LastUpdateDate | The date when the journal row was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the journal. |
| LastUpdatedBy | The user who last updated the journal row. |
| LedgerId | The unique identifier of the ledger of the journal entry header. This is a foreign key to the Ledger view object. |
| LegalEntityId | The unique identifier of the legal entity associated with the journal. This is a foreign key to the Entity Profile view object. |
| LocalDocSequenceId | The sequential numbering sequence of the local documents. |
| LocalDocSequenceValue | The sequential numbering sequence value of the local documents. |
| MultiBalSegFlag | Indicates whether multiple balancing segments apply to the journal. A list of accepted values is defined in the lookup type YES_NO. |
| MultiCurrencyFlag | Indicates whether the journal is multicurrency. A list of accepted values is defined in the lookup type YES_NO. The default value is N. |
| Name | The name of the journal header provided by the user or source application. |
| ObjectVersionNumber | The number of times the journal row has been updated. |
| OriginatingBalSegValue | A balancing segment value used in a journal to balance many to many intercompany journals. |
| ParentJeHeaderId | The unique identifier of the parent journal entry in the source primary ledger. |
| 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. |
| PeriodName | The accounting period associated with the journal. This is a foreign key of the Period view object. |
| PostCurrencyCode | The code representing the currency used for posting multicurrency journals. |
| PostMultiCurrencyFlag | Indicates whether the posted journal is a multicurrency. A list of accepted values is defined in the lookup type YES_NO. |
| PostedDate | The date when the journal was posted. |
| PostingAcctSeqAssignId | The identifier of the sequence assignment used when posting the journal. |
| PostingAcctSeqValue | The sequence value assigned when posting. |
| PostingAcctSeqVersionId | The identifier of the sequence version used when posting. This is a foreign key to the PostAcctSeqVersions entity object. |
| ReferenceDate | An additional reference date entered by the user or source application. |
| ReversedJeHeaderId | The unique identifier of the reversed journal header. This is a foreign key to the ReversedJournalHeader entity object. |
| RunningTotalAccountedCr | The running total credits of a journal entry in the ledger currency. |
| RunningTotalAccountedDr | The running total debits of a journal entry in the ledger currency. |
| RunningTotalCr | The running total credits of a journal entry in the entered currency. |
| RunningTotalDr | The running total debits of a journal entry in the entered currency. |
| Status | The posting status for the journal. A list of accepted values are defined in the lookup type MJE_BATCH_STATUS. |
| TaxLegalEntityId | The unique identifier of tax legal entity. |
| TaxStatusCode | The code representing the tax status of the journal entry header. |