XLA_AE_HEADERS

This table contains subledger accounting journal entries.

Details

  • Schema: FUSION

  • Object owner: XLA

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

XLA_AE_HEADERS_PK

AE_HEADER_ID, APPLICATION_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
AE_HEADER_ID NUMBER 18 Yes Identifier of accounting entry.
APPLICATION_ID NUMBER 18 Yes Functional area within a software suite of products. For example, Financials or Payroll.
ACCT_RULE_DEFINITION_ID NUMBER 18 Internal identifier of an accounting rule definition that was used to generate the accounting.
APPLIED_DESCRIPTION_PRIORITY NUMBER 18 Rule priority of the successfully evaluated description rule that was used to create the journal entry description.
LEDGER_ID NUMBER 18 Yes Self-contained accounting information set for single or multiple legal or management entities.
ENTITY_ID NUMBER 18 Yes Subledger transactions associated with the accounting events.
EVENT_ID NUMBER 18 Yes Identifier of the categorization of accounting events that is unique within an application and event class.
EVENT_TYPE_CODE VARCHAR2 30 Yes Unique abbreviated name assigned to an event type and used for reporting or in reference to an option.
ACCOUNTING_DATE DATE Yes Date, referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions.
GL_TRANSFER_STATUS_CODE VARCHAR2 30 Yes General Ledger transfer status code.
GL_TRANSFER_DATE DATE Date when journal entry is transferred to general ledger.
JE_CATEGORY_NAME VARCHAR2 30 Yes Group of journal entries with similar characteristics such allocations, accruals, or revenues.
ACCOUNTING_ENTRY_STATUS_CODE VARCHAR2 30 Yes Status code of the accounting entry.
ACCOUNTING_ENTRY_TYPE_CODE VARCHAR2 30 Yes Code that uniquely identifies the source of accounting entry generation: Standard or Manual.
AMB_CONTEXT_CODE VARCHAR2 30 Accounting methods builder context.
PRODUCT_RULE_TYPE_CODE VARCHAR2 1 Application accounting definition type code, not applicable for manual adjustments.
PRODUCT_RULE_CODE VARCHAR2 30 Application accounting definition type code, not applicable for manual adjustments.
PRODUCT_RULE_VERSION VARCHAR2 30 Version of the rules, not applicable for manual adjustments.
DESCRIPTION VARCHAR2 1996 Description of a subledger journal entry.
DOC_SEQUENCE_ID NUMBER Sub-Ledger document sequence identifier.
DOC_SEQUENCE_VALUE NUMBER Sub-Ledger document sequence value.
ACCOUNTING_BATCH_ID NUMBER 18 Identifier of accounting batch program.
COMPLETION_ACCT_SEQ_VERSION_ID NUMBER 18 Accounting sequence version identifier.
CLOSE_ACCT_SEQ_VERSION_ID NUMBER 18 Reporting sequence version identifier.
COMPLETION_ACCT_SEQ_VALUE NUMBER Name of the sequence used to generate a unique number for the journal when the journal is posted.
CLOSE_ACCT_SEQ_VALUE NUMBER Name of sequence used to generate unique number for the journal when the period is closed.
BUDGET_VERSION_ID NUMBER 18 Unique identifier of budget version.
FUNDS_STATUS_CODE VARCHAR2 30 Status resulted from a fund check performed on a journal entry. Valid values include Pass, Fail, Not Attempted, Reserved, and Not Required.
ENCUMBRANCE_TYPE_ID NUMBER 18 Identifier of encumbrance type assigned to a journal entry in the encumbrance accounting.
BALANCE_TYPE_CODE VARCHAR2 1 Yes Balance type. Values are Actual, Budget, or Encumbrance.
REFERENCE_DATE DATE Accounting entry reference date.
COMPLETED_DATE DATE Subledger journal entry completion date.
PERIOD_NAME VARCHAR2 15 Fiscal period that reports financial results, such as a calendar month or fiscal period.
PACKET_ID NUMBER 18 Budgetary control packet defining column.
COMPLETION_ACCT_SEQ_ASSIGN_ID NUMBER 18 Accounting sequence assignment identifier.
CLOSE_ACCT_SEQ_ASSIGN_ID NUMBER 18 Reporting sequence assignment identifier.
DOC_CATEGORY_CODE VARCHAR2 30 Subledger document sequence category.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Subledger Journal Entry Header (XLA_AE_HEADERS)
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
GROUP_ID NUMBER 18 Interface group identifying column.
DOC_SEQUENCE_VERSION_ID NUMBER 18 Subledger document sequence version identifier.
DOC_SEQUENCE_ASSIGN_ID NUMBER 18 Subledger document sequence assignment identifier.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
UPG_BATCH_ID NUMBER 18 Unique identifier of upgrade batch.
UPG_SOURCE_APPLICATION_ID NUMBER 18 Internal identifier of the upgrading application.
UPG_VALID_FLAG VARCHAR2 1 Flag to indicate if validation was successfully run for the batch.
ZERO_AMOUNT_FLAG VARCHAR2 1 Indicate whether the entry is a zero-amount entry.
PARENT_AE_HEADER_ID NUMBER 18 Journal entry header id of the parent entry.
PARENT_AE_LINE_NUM NUMBER 18 Journal entry line number of the parent entry.
ACCRUAL_REVERSAL_FLAG VARCHAR2 1 Indicates if the subledger journal entry is an accrual reversal entry.
MERGE_EVENT_ID NUMBER 18 Identifier of merge accounting event.
OBJECT_VERSION_NUMBER NUMBER 9 Yes 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.
NEED_BAL_CODE VARCHAR2 30 Tracks when balancing is necessary.
AE_PENDING_STATUS_CODE VARCHAR2 30 Shows the temporary status for accounting entry generation. The value is for internal use only.
INTERCOMPANY_REVERSED_CODE VARCHAR2 30 Tracks whether the intercompany lines for this journal have been reversed.
LEGAL_ENTITY_ID NUMBER 18 Legal entity that owns this accounting entry. Will be populated only when there is one and only legal entity for the accounting entry.
SUBLEDGER_XCC_COMPLETE_STATUS VARCHAR2 1 Status used to determine if budgetary control is performed on general ledger entries
MULTIPERIOD_FLAG VARCHAR2 1 Indicates whether the journal entry contains any line that requires multiperiod accounting. Possible values are Y (journal contains multiperiod accounting line) and N (journal does not contain multiperiod accounting line).
PARTITION_GROUP_CODE VARCHAR2 15 Partition grouping information, when combined with the period, determines the database partition in which this journal will be stored.
ACCRUAL_REVERSAL_OPTION_CODE VARCHAR2 30 Indicates the accrual reversal option code, which is used to create the accrual reversal entry for a manual journal entry.

Indexes

Index Uniqueness Tablespace Columns
XLA_AE_HEADERS_N1 Non Unique Default GROUP_ID, LEDGER_ID
XLA_AE_HEADERS_N2 Non Unique Default EVENT_ID, LEDGER_ID
XLA_AE_HEADERS_N3 Non Unique Default ENTITY_ID, ACCOUNTING_ENTRY_STATUS_CODE
XLA_AE_HEADERS_N4 Non Unique Default UPG_BATCH_ID
XLA_AE_HEADERS_N5 Non Unique Default LEDGER_ID, APPLICATION_ID, ACCOUNTING_DATE
XLA_AE_HEADERS_N8 Non Unique Default GL_TRANSFER_STATUS_CODE, ACCOUNTING_BATCH_ID
XLA_AE_HEADERS_U1 Unique Default AE_HEADER_ID, APPLICATION_ID