Subledger Journal Entry Headers
The subledger journal entry headers view object contains information for the journal header, such as ledger identifier, accounting period, subledger application, general category, accounting entry status, transfer status, and so on. The combination of JournalEntryHeaderAeHeaderId and JournalEntryHeaderApplicationId forms the unique identifier of the Subledger Journal Entry Headers view object.
Data Store Key : FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalHeaderExtractPVO
Primary Keys : JournalEntryHeaderAeHeaderId, JournalEntryHeaderApplicationId
Initial Extract Date : JournalEntryHeaderCreationDate
Incremental Extract Date : JournalEntryHeaderLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
CloseAcctSeqVersionsHeaderName | The name of the reporting sequence assigned to the subledger journal. |
CloseAcctSeqVersionsSeqVersionId | The unique identifier of the reporting sequence version associated with the subledger journal. This is a primary key of the CloseAcctSeqVersions entity object. |
CloseAcctSeqVersionsVersionName | The name of the reporting sequence version associated with the subledger journal. |
CompAcctSeqVersionsHeaderName | The name of the accounting sequence assigned to the subledger journal. |
CompAcctSeqVersionsSeqVersionId | The unique identifier of the accounting sequence version associated with the subledger journal. This is a primary key of the CompAcctSeqVersions entity object. |
CompAcctSeqVersionsVersionName | The name of the accounting sequence version associated with the subledger journal. |
JournalEntryHeaderAccountingBatchId | The identifier of the batch in which the subledger journal entry was created. |
JournalEntryHeaderAccountingDate | 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. |
JournalEntryHeaderAccountingEntryStatusCode | Indicates 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. |
JournalEntryHeaderAccountingEntryTypeCode | Indicates the source of accounting entry generation. A list of accepted values is defined in the lookup type XLA_ACCOUNTING_ENTRY_SEQ_TYPE. |
JournalEntryHeaderAccrualReversalFlag | Indicates whether the subledger journal entry is an accrual reversal entry. |
JournalEntryHeaderAeHeaderId | The unique identifier of the subledger journal entry. This attribute is a part of the composite key of the Subledger Journal Entry Headers view object. |
JournalEntryHeaderAmbContextCode | The accounting methods builder context. |
JournalEntryHeaderApplicationId | The unique identifier of the source application which represents a functional area. This is a primary key of the Application view object. This attribute is a part of the composite key of the Subledger Journal Entry Headers view object. |
JournalEntryHeaderAttribute1 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderAttribute10 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderAttribute11 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderAttribute12 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderAttribute13 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderAttribute14 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderAttribute15 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderAttribute2 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderAttribute3 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderAttribute4 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderAttribute5 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderAttribute6 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderAttribute7 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderAttribute8 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderAttribute9 | A segment of the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderAttributeCategory | The descriptive flexfield context name for the Subledger Journal Entry Headers descriptive flexfield. |
JournalEntryHeaderBalanceTypeCode | Indicates the type of subledger journal entry header. A list of accepted values is defined in the lookup type XLA_BALANCE_TYPE. |
JournalEntryHeaderBudgetVersionId | Identifier of the budget version. |
JournalEntryHeaderCloseAcctSeqAssignId | The identifier of the sequence assignment used when closing a period. |
JournalEntryHeaderCloseAcctSeqValue | A sequence value assigned during the period close. |
JournalEntryHeaderCloseAcctSeqVersionId | The identifier of the sequence version used during the period close. This is a foreign key to the CloseAcctSeqVersions entity object. |
JournalEntryHeaderCompletedDate | The subledger journal entry completion date. |
JournalEntryHeaderCompletionAcctSeqAssignId | The identifier of the accounting sequence assignment to the subledger journal entry. |
JournalEntryHeaderCompletionAcctSeqValue | The name of the sequence that's used to generate a unique sequence number for the subledger journal entry during posting. |
JournalEntryHeaderCompletionAcctSeqVersionId | The identifier of the sequence version used to generate a unique sequence number for the subledger journal entry during posting. This is a foreign key to the CompAcctSeqVersions entity object. |
JournalEntryHeaderCreatedBy | The user who created the subledger journal entry header. |
JournalEntryHeaderCreationDate | The date and time when the subledger journal entry header was created. |
JournalEntryHeaderDescription | The description of the subledger journal entry header provided by the user or source application. |
JournalEntryHeaderDocCategoryCode | The document sequence category code used to derive the document sequence of the subledger transaction. |
JournalEntryHeaderDocSequenceAssignId | The identifier of the document sequence assignment used for the subledger transaction. |
JournalEntryHeaderDocSequenceId | The identifier of the document sequence used for the subledger transaction. |
JournalEntryHeaderDocSequenceValue | The document sequence value for the subledger transaction. |
JournalEntryHeaderDocSequenceVersionId | The identifier of the document sequence version used for the subledger transaction. |
JournalEntryHeaderEncumbranceTypeId | The identifier of encumbrance type assigned to a subledger journal entry in the encumbrance accounting. |
JournalEntryHeaderEntityId | Identifier of the source transaction associated with a subledger journal entry header. This is a foreign key of the Transaction Entities view object. |
JournalEntryHeaderEventId | Identifier of the categorization of accounting events that's unique within an application and event class. This a foreign key of the Events view object. |
JournalEntryHeaderEventTypeCode | The unique abbreviated name assigned to an event type and used for reporting or in reference to an option. |
JournalEntryHeaderFundsStatusCode | 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. |
JournalEntryHeaderGlTransferDate | The date when the subledger journal entry is transferred to general ledger. |
JournalEntryHeaderGlTransferStatusCode | The general ledger transfer status of the subledger journal entry header. |
JournalEntryHeaderGroupId | Identifier of the journal import batches. |
JournalEntryHeaderJeCategoryName | The name of the journal category used to group journal entries with similar characteristics, such as allocations, accruals, or revenues. |
JournalEntryHeaderLastUpdateDate | The date when the subledger journal entry header row was last updated. |
JournalEntryHeaderLastUpdateLogin | The session login associated with the user who last updated the subledger journal entry header. |
JournalEntryHeaderLastUpdatedBy | The user who last updated the subledger journal entry header row. |
JournalEntryHeaderLedgerId | The unique identifier of the ledger associated with the subledger journal entry header. This is a foreign key to the Ledgers view object. |
JournalEntryHeaderLegalEntityId | The unique identifier of the legal entity associated with the subledger journal entry header. This is a foreign key of the Entity Profile view object. |
JournalEntryHeaderMergeEventId | The unique identifier of the third-party merge event. |
JournalEntryHeaderMultiPeriodFlag | Indicates whether the journal entry contains any line that requires multiperiod accounting. |
JournalEntryHeaderNeedBalFlag | Indicates whether balancing is required for the journal. A list of accepted values is defined in the lookup type YES_NO. |
JournalEntryHeaderObjectVersionNumber | The number of times the subledger journal entry header row has been updated. |
JournalEntryHeaderPacketId | Identifier of the budgetary control packet in the GL_BC_PACKETS table. It's used to implement budgetary control. |
JournalEntryHeaderParentAeHeaderId | The unique identifier of the parent subledger journal entry header in the source primary subledger. |
JournalEntryHeaderParentAeLineNum | The line number of the parent subledger journal line in the source primary subledger. |
JournalEntryHeaderPeriodName | The accounting period associated with the subledger journal entry header. This is a foreign key of the Period view object. |
JournalEntryHeaderProductRuleCode | The subledger accounting method code used by the Create Accounting process to create the journal entry. |
JournalEntryHeaderProductRuleTypeCode | The subledger accounting method type code used by the Create Accounting process to create the journal entry. |
JournalEntryHeaderProductRuleVersion | The version of the accounting rules used by the Create Accounting process to create the journal entry. |
JournalEntryHeaderReferenceDate | The date that can be used as a basis 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. |
JournalEntryHeaderRequestId | The unique identifier of the job that created or last updated the row. |
JournalEntryHeaderUpgBatchId | The unique identifier of the upgrade batch. |
JournalEntryHeaderUpgSourceApplicationId | The internal identifier of the upgrading source application. |
JournalEntryHeaderUpgValidFlag | Indicates whether the validation was successfully run for the batch. A list of accepted values is defined in the lookup type YES_NO. |
JournalEntryHeaderUserLanguage | The code of the language set up by the user into which the contents of the translatable attributes are translated. |
JournalEntryHeaderZeroAmountFlag | Indicates whether the entry is a zero-amount entry. A list of accepted values is defined in the lookup type YES_NO. |