DBA Data[Home] [Help] [Dependency Information]


TABLE: XLA.XLA_AE_HEADERS

Object Details
Object Name: XLA_AE_HEADERS
Object Type: TABLE
Owner: XLA
FND Design Data: TableXLA.XLA_AE_HEADERS
Subobject Name:
Status: VALID

The XLA_AE_HEADERS table stores subledger journal entries. There is a one-to-many relationship between accounting events and journal entry headers.

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XLA_AE_HEADERS_U1 NORMAL UNIQUE Tablespace ColumnAE_HEADER_ID
ColumnAPPLICATION_ID
XLA_AE_HEADERS_N1 NORMAL NONUNIQUE Tablespace ColumnGROUP_ID
ColumnLEDGER_ID
XLA_AE_HEADERS_N2 NORMAL NONUNIQUE Tablespace ColumnEVENT_ID
ColumnLEDGER_ID
XLA_AE_HEADERS_N3 NORMAL NONUNIQUE Tablespace ColumnENTITY_ID
ColumnACCOUNTING_ENTRY_STATUS_CODE
ColumnGL_TRANSFER_STATUS_CODE
XLA_AE_HEADERS_N4 NORMAL NONUNIQUE Tablespace ColumnAPPLICATION_ID
ColumnREQUEST_ID
XLA_AE_HEADERS_N5 NORMAL NONUNIQUE Tablespace ColumnACCOUNTING_DATE
ColumnLEDGER_ID
ColumnGL_TRANSFER_STATUS_CODE
XLA_AE_HEADERS_N8 NORMAL NONUNIQUE Tablespace ColumnACCOUNTING_BATCH_ID
Columns
Name Datatype Length Mandatory Comments
AE_HEADER_ID NUMBER (15) Yes Accounting entry id
APPLICATION_ID NUMBER (15) Yes Internal Id of the application
LEDGER_ID NUMBER (15) Yes Ledger id
ENTITY_ID NUMBER (15) Yes Entity id
EVENT_ID NUMBER (15) Yes Event id
EVENT_TYPE_CODE VARCHAR2 (30) Yes Event type code
ACCOUNTING_DATE DATE
Yes Accounting date
GL_TRANSFER_STATUS_CODE VARCHAR2 (30) Yes General Ledger transfer status code
GL_TRANSFER_DATE DATE

General Ledger transfer date
JE_CATEGORY_NAME VARCHAR2 (30) Yes General Ledger category name
ACCOUNTING_ENTRY_STATUS_CODE VARCHAR2 (30) Yes Accounting entry status code
ACCOUNTING_ENTRY_TYPE_CODE VARCHAR2 (30) Yes Accounting entry type code
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
DOC_SEQUENCE_ID NUMBER

Sub-Ledger document sequence identifier
DOC_SEQUENCE_VALUE NUMBER

Sub-Ledger document sequence value
ACCOUNTING_BATCH_ID NUMBER (15)
Accounting Program batch Id
COMPLETION_ACCT_SEQ_VERSION_ID NUMBER (15)
Subledger journal entry creation sequence Identifier
CLOSE_ACCT_SEQ_VERSION_ID NUMBER (15)
Accounting entry reporting sequence
COMPLETION_ACCT_SEQ_VALUE NUMBER

Subledger journal entry creation sequence Value
CLOSE_ACCT_SEQ_VALUE NUMBER

Accounting entry reporting sequence Value
BUDGET_VERSION_ID NUMBER (15)
Budget version defining column
FUNDS_STATUS_CODE VARCHAR2 (30)
Funds checker status
ENCUMBRANCE_TYPE_ID NUMBER (15)
Encumbrance type identifier
BALANCE_TYPE_CODE VARCHAR2 (1) Yes Balance type (Actual, Budget, or Encumbrance)
REFERENCE_DATE DATE

Accounting Entry reference Date.
COMPLETED_DATE DATE

Subledger journal entry completion date
PERIOD_NAME VARCHAR2 (15)
Subledger journal entry period name.
PACKET_ID NUMBER (15)
Budgetary control packet defining column.
COMPLETION_ACCT_SEQ_ASSIGN_ID NUMBER (15)
Journal entry completion sequence assignment identifier
CLOSE_ACCT_SEQ_ASSIGN_ID NUMBER (15)
Journal entry reporting sequence assignment identifier
DOC_CATEGORY_CODE VARCHAR2 (30)
Document sequence category category code. It used as part of the subledger journal entry sequencing criteria.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column.
GROUP_ID NUMBER (15)
Interface group identifying column.
DOC_SEQUENCE_VERSION_ID NUMBER (15)
Document sequence identifier
DOC_SEQUENCE_ASSIGN_ID NUMBER (15)
Document sequence assignment identifier
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
PROGRAM_UPDATE_DATE DATE

Extended Who Column
PROGRAM_APPLICATION_ID NUMBER (15)
Extended Who Column
PROGRAM_ID NUMBER (15)
Extended Who Column
REQUEST_ID NUMBER (15)
Extended Who Column
UPG_BATCH_ID NUMBER (15)
Upgrade batch identifier
UPG_SOURCE_APPLICATION_ID NUMBER (15)
Internal Id 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 (15)
The journal entry header id of the parent entry.
PARENT_AE_LINE_NUM NUMBER (15)
The journal entry line number of the parent entry.
ACCRUAL_REVERSAL_FLAG VARCHAR2 (1)
MERGE_EVENT_ID NUMBER (15)
NEED_BAL_FLAG VARCHAR2 (1)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AE_HEADER_ID
,      APPLICATION_ID
,      LEDGER_ID
,      ENTITY_ID
,      EVENT_ID
,      EVENT_TYPE_CODE
,      ACCOUNTING_DATE
,      GL_TRANSFER_STATUS_CODE
,      GL_TRANSFER_DATE
,      JE_CATEGORY_NAME
,      ACCOUNTING_ENTRY_STATUS_CODE
,      ACCOUNTING_ENTRY_TYPE_CODE
,      AMB_CONTEXT_CODE
,      PRODUCT_RULE_TYPE_CODE
,      PRODUCT_RULE_CODE
,      PRODUCT_RULE_VERSION
,      DESCRIPTION
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      ACCOUNTING_BATCH_ID
,      COMPLETION_ACCT_SEQ_VERSION_ID
,      CLOSE_ACCT_SEQ_VERSION_ID
,      COMPLETION_ACCT_SEQ_VALUE
,      CLOSE_ACCT_SEQ_VALUE
,      BUDGET_VERSION_ID
,      FUNDS_STATUS_CODE
,      ENCUMBRANCE_TYPE_ID
,      BALANCE_TYPE_CODE
,      REFERENCE_DATE
,      COMPLETED_DATE
,      PERIOD_NAME
,      PACKET_ID
,      COMPLETION_ACCT_SEQ_ASSIGN_ID
,      CLOSE_ACCT_SEQ_ASSIGN_ID
,      DOC_CATEGORY_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      GROUP_ID
,      DOC_SEQUENCE_VERSION_ID
,      DOC_SEQUENCE_ASSIGN_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
,      UPG_BATCH_ID
,      UPG_SOURCE_APPLICATION_ID
,      UPG_VALID_FLAG
,      ZERO_AMOUNT_FLAG
,      PARENT_AE_HEADER_ID
,      PARENT_AE_LINE_NUM
,      ACCRUAL_REVERSAL_FLAG
,      MERGE_EVENT_ID
,      NEED_BAL_FLAG
FROM XLA.XLA_AE_HEADERS;

Dependencies

[top of page]

XLA.XLA_AE_HEADERS does not reference any database object

XLA.XLA_AE_HEADERS is referenced by following:

SchemaXLA
ViewXLA_AE_HEADERS#