Archived Journal Line Audits
The Archived Journal Line Audits view object contains archived information of the journal line audits. Each row of this object stores the associated journal entry header identifier, line number, and associated account information and related debits or credits. The combination of jeHeaderId and jeLineNum forms the unique identifier of the Journal Line view object.
Data Store Key : FscmTopModelAM.FinExtractAM.FinArchiveBiccExtractAM.ArchiveGlLineAuditExtractPVO
Primary Keys : JeHeaderId
Initial Extract Date : CreationDate
Incremental Extract Date :
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AccountedCr | The journal line credit amount in the ledger currency. |
| AccountedDr | The journal line debit amount in the ledger currency. |
| AmountIncludesTaxFlag | Indicates whether the amount includes tax for automatic tax calculations. |
| Attribute1 | A segment for the Journal Lines descriptive flexfield. |
| Attribute10 | A segment for the Journal Lines descriptive flexfield. |
| Attribute11 | A segment for the Journal Lines descriptive flexfield. |
| Attribute12 | A segment for the Journal Lines descriptive flexfield. |
| Attribute13 | A segment for the Journal Lines descriptive flexfield. |
| Attribute14 | A segment for the Journal Lines descriptive flexfield. |
| Attribute15 | A segment for the Journal Lines descriptive flexfield. |
| Attribute16 | A segment for the Journal Lines descriptive flexfield. |
| Attribute17 | A segment for the Journal Lines descriptive flexfield. |
| Attribute18 | A segment for the Journal Lines descriptive flexfield. |
| Attribute19 | A segment for the Journal Lines descriptive flexfield. |
| Attribute2 | A segment for the Journal Lines descriptive flexfield. |
| Attribute20 | A segment for the Journal Lines descriptive flexfield. |
| Attribute3 | A segment for the Journal Lines descriptive flexfield. |
| Attribute4 | A segment for the Journal Lines descriptive flexfield. |
| Attribute5 | A segment for the Journal Lines descriptive flexfield. |
| Attribute6 | A segment for the Journal Lines descriptive flexfield. |
| Attribute7 | A segment for the Journal Lines descriptive flexfield. |
| Attribute8 | A segment for the Journal Lines descriptive flexfield. |
| Attribute9 | A segment for the Journal Lines descriptive flexfield. |
| AttributeCategory | The context name for the Journal Lines descriptive flexfield. |
| AttributeCategory2 | The context name for the Journal Lines descriptive flexfield. |
| AttributeCategory3 | The context name for the Journal Lines descriptive flexfield. |
| AttributeCategory4 | The context name for the Journal Lines descriptive flexfield. |
| AttributeDate1 | A date segment for the Journal Entry Line descriptive flexfield. |
| AttributeDate10 | A date segment for the Journal Entry Line descriptive flexfield. |
| AttributeDate2 | A date segment for the Journal Entry Line descriptive flexfield. |
| AttributeDate3 | A date segment for the Journal Entry Line descriptive flexfield. |
| AttributeDate4 | A date segment for the Journal Entry Line descriptive flexfield. |
| AttributeDate5 | A date segment for the Journal Entry Line descriptive flexfield. |
| AttributeDate6 | A date segment for the Journal Entry Line descriptive flexfield. |
| AttributeDate7 | A date segment for the Journal Entry Line descriptive flexfield. |
| AttributeDate8 | A date segment for the Journal Entry Line descriptive flexfield. |
| AttributeDate9 | A date segment for the Journal Entry Line descriptive flexfield. |
| AttributeNumber1 | A number segment for the Journal Entry descriptive flexfield. |
| AttributeNumber10 | A number segment for the Journal Entry descriptive flexfield. |
| AttributeNumber2 | A number segment for the Journal Entry descriptive flexfield. |
| AttributeNumber3 | A number segment for the Journal Entry descriptive flexfield. |
| AttributeNumber4 | A number segment for the Journal Entry descriptive flexfield. |
| AttributeNumber5 | A number segment for the Journal Entry descriptive flexfield. |
| AttributeNumber6 | A number segment for the Journal Entry descriptive flexfield. |
| AttributeNumber7 | A number segment for the Journal Entry descriptive flexfield. |
| AttributeNumber8 | A number segment for the Journal Entry descriptive flexfield. |
| AttributeNumber9 | A number segment for the Journal Entry 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. |
| CoProcessedFlag | Indicates if it's processed by Colombian third party. |
| CoThirdParty | The Colombian third party on the journal line. |
| CodeCombinationId | The unique identifier of the account combination. This is a foreign key of the Code Combination view object. |
| CreatedBy | The user who created the journal line. |
| CreationDate | The date and time when the journal line was created. |
| CurrencyCode | The code representing the currency in which the journal line is entered. 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. |
| Description | The description of the journal line provided by the user or source application. |
| EffectiveDate | The accounting date of the journal line. |
| EnteredCr | The journal line credit amount in the entered currency. |
| EnteredDr | The journal line debit amount in the entered currency. |
| GlSlLinkId | The unique identifier of the link that's associated with the subledger transaction. |
| GlSlLinkTable | The name of the table containing the associated subledger data. |
| GlobalAttribute1 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute10 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute11 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute12 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute13 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute14 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute15 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute16 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute17 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute18 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute19 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute2 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute20 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute3 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute4 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute5 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute6 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute7 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute8 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttribute9 | A segment for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttributeCategory | The context name for the General Ledger Journal Line Regional Information global descriptive flexfield. |
| GlobalAttributeDate1 | A date segment for the General Ledger Journal Line Regional Information descriptive flexfield. |
| GlobalAttributeDate2 | A date segment for the General Ledger Journal Line Regional Information descriptive flexfield. |
| GlobalAttributeDate3 | A date segment for the General Ledger Journal Line Regional Information descriptive flexfield. |
| GlobalAttributeDate4 | A date segment for the General Ledger Journal Line Regional Information descriptive flexfield. |
| GlobalAttributeDate5 | A date segment for the General Ledger Journal Line Regional Information descriptive flexfield. |
| GlobalAttributeNumber1 | A number segment for the General Ledger Journal Line Regional Information descriptive flexfield. |
| GlobalAttributeNumber2 | A number segment for the General Ledger Journal Line Regional Information descriptive flexfield. |
| GlobalAttributeNumber3 | A number segment for the General Ledger Journal Line Regional Information descriptive flexfield. |
| GlobalAttributeNumber4 | A number segment for the General Ledger Journal Line Regional Information descriptive flexfield. |
| GlobalAttributeNumber5 | A number segment for the General Ledger Journal Line Regional Information descriptive flexfield. |
| IgnoreRateFlag | Indicates whether the accounted amounts are recalculated when the currency conversion rate changes. Valid values are Null, Y, or N. |
| InvoiceAmount | A segment for the Journal Value Added Tax descriptive flexfield. |
| JeHeaderId | The unique identifier of the journal entry header. This attribute is a part of the composite key of the Journal Line view object. |
| JeLineNum | The identifier of a line in a journal for a particular header. This attribute is a part of the composite key of the Journal Line view object. |
| JgzzReconRef | The additional Information of a journal line. |
| LastUpdateDate | The date when the journal line row was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the journal line. |
| LastUpdatedBy | The user who last updated the journal line row. |
| LedgerId | The unique identifier of the ledger of the journal line. This is a foreign key of the Ledger view object. |
| LineTypeCode | The type of line such as suspense, rounding, and intercompany. Valid values are Null, INTRA, INTER, ENTERED_CURR_BALANCE, SUSPENSE, ROUNDING, and GAIN_LOSS. |
| No1 | The value added tax descriptive flexfield column. |
| ObjectVersionNumber | A unique number used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| 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 amount entered in a journal that's based on the unit of measure. |
| Reference1 | The batch name entered by the user while submitting the Post Subledger Journal Entries process. |
| Reference10 | The batch name entered by the user while submitting the Post Subledger Journal Entries process. |
| Reference2 | The batch name entered by the user while submitting the Post Subledger Journal Entries process. |
| Reference3 | The batch name entered by the user while submitting the Post Subledger Journal Entries process. |
| Reference4 | The batch name entered by the user while submitting the Post Subledger Journal Entries process. |
| Reference5 | The batch name entered by the user while submitting the Post Subledger Journal Entries process. |
| Reference6 | The batch name entered by the user while submitting the Post Subledger Journal Entries process. |
| Reference7 | The batch name entered by the user while submitting the Post Subledger Journal Entries process. |
| Reference8 | The batch name entered by the user while submitting the Post Subledger Journal Entries process. |
| Reference9 | The batch name entered by the user while submitting the Post Subledger Journal Entries process. |
| StatAmount | The amount entered in a journal that's based on the unit of measure. |
| Status | The posting status for the journal. A list of accepted values are defined in the lookup type MJE_BATCH_STATUS. |
| SubledgerDocSequenceId | The sequential number assigned to a document. |
| SubledgerDocSequenceValue | The document sequence value generated by the subledger. |
| TaxCode | The code representing the tax for automatic tax calculation. |
| TaxCodeId | The unique identifier of the tax code for automatic tax calculations. |
| TaxCustomerName | The name of the tax customer on the journal line. |
| TaxCustomerReference | The reference of the tax customer on the journal line. |
| TaxDocumentDate | The date of the tax document on the journal line. |
| TaxGroupId | The tax group identifier for automatic tax calculations. |
| TaxLineFlag | Indicates whether the tax line is generated automatically. |
| TaxRegistrationNumber | The tax registration number of the enterprise. |
| TaxRoundingRuleCode | The code representing the rounding rule used for automatic tax calculations. |
| TaxTypeCode | The tax type for automatic tax calculations. |
| TaxableLineFlag | Indicates whether the line is taxable for automatic tax calculations. |