Archived Subledger Journal Entry Headers
The Archived Subledger Journal Entry Headers view object contains the archived subledger journal entry headers.
Data Store Key : FscmTopModelAM.FinExtractAM.FinArchiveBiccExtractAM.ArchiveXlaHeaderExtractPVO
Primary Keys : AeHeaderId
Initial Extract Date : CreationDate
Incremental Extract Date :
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AccountingBatchId | The unique identifier of the batch in which the subledger journal entry was created. |
| AccountingDate | The date that's used to determine the accounting period of the subledger journal entry and when the entry appears in fiscal reports and queries. |
| AccountingEntryStatusCode | The code representing the accounting entry status of the subledger journal entry header. A list of accepted values is defined in the lookup type XLA_ACCOUNTING_ENTRY_STATUS. |
| AccountingEntryTypeCode | The code representing the accounting entry type. A list of accepted values is defined in the lookup type XLA_ACCOUNTING_ENTRY_SEQ_TYPE. |
| AccrualReversalFlag | Indicates whether the subledger journal entry is an accrual reversal entry. |
| AeHeaderId | The unique identifier of the subledger journal entry. |
| AmbContextCode | The accounting methods builder context. |
| ApplicationId | The unique identifier of the source application which represents a functional area. |
| Attribute1 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
| Attribute10 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
| Attribute11 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
| Attribute12 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
| Attribute13 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
| Attribute14 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
| Attribute15 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
| Attribute2 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
| Attribute3 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
| Attribute4 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
| Attribute5 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
| Attribute6 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
| Attribute7 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
| Attribute8 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
| Attribute9 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeCategory | The context name for the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeDate1 | A date segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeDate10 | A date segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeDate2 | A date segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeDate3 | A date segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeDate4 | A date segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeDate5 | A date segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeDate6 | A date segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeDate7 | A date segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeDate8 | A date segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeDate9 | A date segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeNumber1 | A number segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeNumber10 | A number segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeNumber2 | A number segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeNumber3 | A number segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeNumber4 | A number segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeNumber5 | A number segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeNumber6 | A number segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeNumber7 | A number segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeNumber8 | A number segment of the Subledger Journal Entry Headers descriptive flexfield. |
| AttributeNumber9 | A number segment of the Subledger Journal Entry Headers descriptive flexfield. |
| BalanceTypeCode | The code representing the type of subledger journal entry header. A list of accepted values is defined in the lookup type XLA_BALANCE_TYPE. |
| BudgetVersionId | The unique identifier of the budget version. |
| CloseAcctSeqAssignId | The unique identifier of the reporting sequence assignment to the subledger journal entry. |
| CloseAcctSeqValue | The name of the sequence that's used to generate a unique sequence number for the subledger journal entry when the accounting period is closed. |
| CloseAcctSeqVersionId | The unique identifier of the sequence version used to generate a unique sequence number for the subledger journal entry when the accounting period is closed. |
| CompletedDate | The date when the subledger journal entry was completed. |
| CompletionAcctSeqAssignId | The unique identifier of the accounting sequence assignment to the subledger journal entry. |
| CompletionAcctSeqValue | The name of the sequence that's used to generate a unique sequence number for the subledger journal entry during posting. |
| CompletionAcctSeqVersionId | The unique identifier of the sequence version used to generate a unique sequence number for the subledger journal entry during posting. |
| CreatedBy | The user who created the subledger journal entry header. |
| CreationDate | The date and time when the subledger journal entry header was created. |
| Description | The description of the subledger journal entry header provided by the user or source application. |
| DocCategoryCode | The document sequence category code used to derive the document sequence of the subledger transaction. |
| DocSequenceAssignId | The unique identifier of the document sequence assignment used for the subledger transaction. |
| DocSequenceId | The unique identifier of the document sequence used for the subledger transaction. |
| DocSequenceValue | The document sequence value for the subledger transaction. |
| DocSequenceVersionId | The unique identifier of the document sequence version used for the subledger transaction. |
| EncumbranceTypeId | The unique identifier of encumbrance type assigned to a subledger journal entry in the encumbrance accounting. |
| EntityId | The unique identifier of the source transaction associated with a subledger journal entry header. |
| EventId | The unique identifier of the accounting event categorization that's unique within an application and event class. |
| EventTypeCode | The code representing the event type used for reporting or in reference to an option. |
| FundsStatusCode | Indicates the status resulting from a fund check performed on a journal entry. A list of accepted values is defined in the lookup type XLA_FUNDS_STATUS. |
| GlTransferDate | The date when the subledger journal entry is transferred to general ledger. |
| GlTransferStatusCode | The code representing the general ledger transfer status of the subledger journal entry header. |
| GroupId | The unique identifier of the journal import batches. |
| IntercompanyReversedCode | Indicates whether the intercompany lines for this journal have been reversed. |
| JeCategoryName | The name of the journal category used to group journal entries with similar characteristics, such as allocations, accruals, or revenues. |
| JobDefinitionName | The name of the job that created or last updated the row. |
| JobDefinitionPackage | The package name of the job that created or last updated the row. |
| LastUpdateDate | The date when the subledger journal entry header row was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the subledger journal entry header. |
| LastUpdatedBy | The user who last updated the subledger journal entry header row. |
| LedgerId | The unique identifier of the ledger associated with the subledger journal entry header. |
| LegalEntityId | The unique identifier of the legal entity associated with the subledger journal entry header. |
| MultiperiodFlag | Indicates whether the journal entry contains any line that requires multiperiod accounting. |
| NeedBalCode | Indicates whether balancing is required for the journal. A list of accepted values is defined in the lookup type YES_NO. |
| ObjectVersionNumber | The number of times the subledger journal entry header row has been updated. |
| PacketId | The unique identifier of the budgetary control packet in the GL_BC_PACKETS table used to implement the budgetary control. |
| ParentAeHeaderId | The unique identifier of the parent subledger journal entry header in the source primary subledger. |
| ParentAeLineNum | The line number of the parent subledger journal line in the source primary subledger. |
| PeriodName | The accounting period associated with the subledger journal entry header. |
| ProductRuleCode | The code representing the subledger accounting method used by the Create Accounting process to create the journal entry. |
| ProductRuleTypeCode | The code representing the subledger accounting method type used by the Create Accounting process to create the journal entry. |
| ProductRuleVersion | The version of the accounting rules used by the Create Accounting process to create the journal entry. |
| ReferenceDate | The date reference for the reporting sequence. When a subledger journal entry header is created and completed, the reference date must belong to an open or future open period in General Ledger. |
| RequestId | The unique identifier of the job that created or last updated the row. |
| SubledgerXccCompleteStatus | Indicates whether the budgetary control should be performed on general ledger entries. |
| UpgBatchId | The unique identifier of the upgrade batch. |
| UpgSourceApplicationId | The unique identifier of the upgrading source application used internally. |
| UpgValidFlag | Indicates whether the validation was successfully run for the batch. A list of accepted values is defined in the lookup type YES_NO. |
| ZeroAmountFlag | Indicates whether the entry is a zero-amount entry. A list of accepted values is defined in the lookup type YES_NO. |