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: AX.AX_SLE_HEADERS

Object Details

Object Name:	AX_SLE_HEADERS
Object Type:	TABLE
Owner:	AX
FND Design Data:	AX.AX_SLE_HEADERS
Subobject Name:
Status:	VALID

This table stores the subledger accounting entry headers. One header exists for each accounting entry. The accounting entry header is used to group accounting entry lines.
Each row includes the journal sequence identifier, the value of the
journal sequence associated with the entry, the application, the
posting set of books, the accounting date, the information
related to currency conversion if applicable, and the identifier of the event that
generated the entry.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: AX_SLE_HEADERS_PK

SET_OF_BOOKS_ID
JOURNAL_SEQUENCE_ID
SLE_HEADER_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
AX_SLE_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID JOURNAL_SEQUENCE_ID SLE_HEADER_ID
AX_SLE_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_ID
AX_SLE_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERIOD_NAME
AX_SLE_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID SET_OF_BOOKS_ID PERIOD_NAME
AX_SLE_HEADERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EFFECTIVE_DATE GL_TRANSFER_FLAG
AX_SLE_HEADERS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNTING_SEQUENCE_ID
AX_SLE_HEADERS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JOURNAL_SEQUENCE_ID SLE_HEADER_ID
AX_SLE_HEADERS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_TRANSFER_RUN_ID
AX_SLE_HEADERS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID SET_OF_BOOKS_ID EFFECTIVE_DATE GL_TRANSFER_FLAG
AX_SLE_HEADERS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REFERENCE_1

Foreign Keys

Table		Foreign Table	Foreign Key Column
AX_SLE_HEADERS		AX_EVENTS	AX_SLE_HEADERS EVENT_ID
AX_SLE_LINES		AX_SLE_HEADERS	AX_SLE_LINES SET_OF_BOOKS_ID AX_SLE_LINES JOURNAL_SEQUENCE_ID AX_SLE_LINES SLE_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
JOURNAL_SEQUENCE_ID	NUMBER	(15)	Yes	Journal sequence identifier
SLE_HEADER_ID	NUMBER		Yes	Value of the journal sequence
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Extended Who column
PROGRAM_APPLICATION_ID	NUMBER			Extended Who column
PROGRAM_ID	NUMBER			Extended Who column
PROGRAM_UPDATE_DATE	DATE			Extended Who column
SET_OF_BOOKS_ID	NUMBER		Yes	Set of books identifier
APPLICATION_ID	NUMBER		Yes	Application identifier
EVENT_ID	NUMBER			Event identifier
EFFECTIVE_DATE	DATE			Accounting date
PERIOD_NAME	VARCHAR2	(15)	Yes	Period name
CURRENCY_CODE	VARCHAR2	(15)		Transaction currency
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date (no longer used)
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate (no longer used)
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type (no longer used)
REFERENCE_1	VARCHAR2	(255)		Character reference column
REFERENCE_2	VARCHAR2	(255)		Character reference column
REFERENCE_3	VARCHAR2	(255)		Character reference column
REFERENCE_4	VARCHAR2	(255)		Character reference column
REFERENCE_5	VARCHAR2	(255)		Character reference column
ORG_ID	NUMBER	(15)		Organization identifier
LEGAL_SEQUENCE_ID	NUMBER	(15)		Gapless sequence identifier
LEGAL_SEQUENCE_VALUE	NUMBER	(15)		Gapless sequence value
TRANSACTION_DATE	DATE			Trading partner accounting date for which tax is reported (for future use)
REFERENCE_NUM1	NUMBER			Numeric reference column
REFERENCE_NUM2	NUMBER			Numeric reference column
REFERENCE_NUM3	NUMBER			Numeric reference column
REFERENCE_NUM4	NUMBER			Numeric reference column
REFERENCE_NUM5	NUMBER			Numeric reference column
REFERENCE_DATE1	DATE			Date reference column
REFERENCE_DATE2	DATE			Date reference column
REFERENCE_DATE3	DATE			Date reference column
REFERENCE_DATE4	DATE			Date reference column
REFERENCE_DATE5	DATE			Date reference column
DESCRIPTION	VARCHAR2	(255)		Subledger accounting header description
DOC_SEQUENCE_ID	NUMBER	(15)		document sequence identifier (for future use)
DOC_SEQUENCE_NUMBER	NUMBER	(15)		document sequence value (for future use)
GL_TRANSFER_FLAG	VARCHAR2	(1)		GL Transfer Flag
GL_TRANSFER_DATE	DATE			GL Transfer Date
GL_TRANSFER_RUN_ID	NUMBER			Ledger Transfer Id
GL_CATEGORY	VARCHAR2	(30)		GL Category
ACCOUNTING_SEQUENCE_ID	NUMBER		Yes	Final accounting sequence id

Query Text

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


SELECT JOURNAL_SEQUENCE_ID
,      SLE_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SET_OF_BOOKS_ID
,      APPLICATION_ID
,      EVENT_ID
,      EFFECTIVE_DATE
,      PERIOD_NAME
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      REFERENCE_1
,      REFERENCE_2
,      REFERENCE_3
,      REFERENCE_4
,      REFERENCE_5
,      ORG_ID
,      LEGAL_SEQUENCE_ID
,      LEGAL_SEQUENCE_VALUE
,      TRANSACTION_DATE
,      REFERENCE_NUM1
,      REFERENCE_NUM2
,      REFERENCE_NUM3
,      REFERENCE_NUM4
,      REFERENCE_NUM5
,      REFERENCE_DATE1
,      REFERENCE_DATE2
,      REFERENCE_DATE3
,      REFERENCE_DATE4
,      REFERENCE_DATE5
,      DESCRIPTION
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_NUMBER
,      GL_TRANSFER_FLAG
,      GL_TRANSFER_DATE
,      GL_TRANSFER_RUN_ID
,      GL_CATEGORY
,      ACCOUNTING_SEQUENCE_ID
FROM AX.AX_SLE_HEADERS;

Dependencies

[top of page]

AX.AX_SLE_HEADERS does not reference any database object

AX.AX_SLE_HEADERS is referenced by following:

APPS: AX_SLE_HEADERS