XLA_SEQ_JE_HEADERS_GT

This is a temporary table which is used internally by Oracle.

Details

  • Schema: FUSION

  • Object owner: XLA

  • Object type: TABLE

Columns

Name

APPLICATION_IDNUMBER18YesFunctional area within a software suite of products. For example, Financials or Payroll.

LEDGER_IDNUMBER18YesSelf-contained accounting information set for single or multiple legal or management entities.

AE_HEADER_IDNUMBER18YesSubledger journal entry identifier.

JE_SOURCE_NAMEVARCHAR230YesCode for origin of journal entries such as payables, receivables, or manual.

JE_CATEGORY_NAMEVARCHAR230YesGroup of journal entries with similar characteristics such as allocations, accruals, or revenues.

GL_DATEDATEYesDate, referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions.

REFERENCE_DATEDATEManual journal entry legal reporting date.

SEQUENCE_ASSIGN_IDNUMBER18Identifier of sequence assignment.

SEQUENCE_VERSION_IDNUMBER18Identifier of sequence version.

SEQUENCE_VALUENUMBER18Value of the generated unique number.

COMPLETION_POSTED_DATEDATEYesDate when subledger journal entries are completed or posted in general ledger.

LEGAL_ENTITY_IDNUMBER18Legal entity that owns this accounting entry. Copied from XLA_AE_HEADERS table.

Indexes

Index Uniqueness Columns
XLA_SEQ_JE_HEADERS_GT_U1 Unique AE_HEADER_ID, APPLICATION_ID