eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	XLA.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:
PCT Free:
PCT Used:

Indexes

Index	Type	Uniqueness	Column
XLA_AE_HEADERS_U1	NORMAL	UNIQUE	AE_HEADER_ID APPLICATION_ID
XLA_AE_HEADERS_N1	NORMAL	NONUNIQUE	GROUP_ID LEDGER_ID
XLA_AE_HEADERS_N2	NORMAL	NONUNIQUE	EVENT_ID LEDGER_ID
XLA_AE_HEADERS_N3	NORMAL	NONUNIQUE	ENTITY_ID ACCOUNTING_ENTRY_STATUS_CODE GL_TRANSFER_STATUS_CODE
XLA_AE_HEADERS_N4	NORMAL	NONUNIQUE	APPLICATION_ID REQUEST_ID
XLA_AE_HEADERS_N5	NORMAL	NONUNIQUE	ACCOUNTING_DATE LEDGER_ID GL_TRANSFER_STATUS_CODE
XLA_AE_HEADERS_N8	NORMAL	NONUNIQUE	ACCOUNTING_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:

APPS: XLA_AE_HEADERS