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: OKL.OKL_AE_HEADERS_ALL

Object Details

Object Name:	OKL_AE_HEADERS_ALL
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_AE_HEADERS_ALL
Subobject Name:
Status:	VALID

An accounting entry header is an entity grouping all accounting entry lines created for a given accounting event and a particular set of books. An accounting entry header can either be transferred over to GL or not at all. That is, either all its accounting entry lines are transferred or none at all. The transferred to GL status is marked in the GL_TRANSFER_FLAG. Possible values for GL_TRANSFER_FLAG are Y, N, or E. Y indicates that the accounting entry header has been transferred to GL. N indicates that the accounting entry header has not been transferred to GL due to 2 possible reasons: either the transfer process has not run or it has run but the accounting entry had an accounting error on it. E indicates that an error was encountered during the transfer to GL process.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_AE_HEADERS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AE_HEADER_ID
OKL_AE_HEADERS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNTING_EVENT_ID
OKL_AE_HEADERS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID
OKL_AE_HEADERS_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID
OKL_AE_HEADERS_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AE_HEADER_ID	NUMBER		Yes	Accounting entry header identifier
POST_TO_GL_FLAG	VARCHAR2	(3)		Not used
SET_OF_BOOKS_ID	NUMBER		Yes	Accounting books defining column
ACCOUNTING_EVENT_ID	NUMBER		Yes	Accounting event identifier
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
AE_CATEGORY	VARCHAR2	(90)	Yes	Accounting entry category. The possible values come from GL_JE_CATEGORIES
PERIOD_NAME	VARCHAR2	(45)	Yes	Accounting period name
ACCOUNTING_DATE	DATE		Yes	Accounting date
GL_TRANSFER_RUN_ID	NUMBER	(15)	Yes	Uniquely identifies a transfer to GL batch for a particular set of books. It is set to -1 for all accounting entry headers which have not been transferred to GL
CROSS_CURRENCY_FLAG	VARCHAR2	(3)	Yes	Indicates whether this accounting entry header has accounting entry lines with different entered currencies. This is used by the GL Transfer program to set the journal category to CrossCurrency to enable GL to create the balancing journal line
GL_TRANSFER_FLAG	VARCHAR2	(3)	Yes	Indicates whether accounting entry header has been successfully transferred to GL. Possible values are Y, N, E
SEQUENCE_ID	NUMBER			Sequence Identifier
SEQUENCE_VALUE	NUMBER			Sequence Value
DESCRIPTION	VARCHAR2	(720)		User entered description
ACCOUNTING_ERROR_CODE	VARCHAR2	(90)		Accounting entry header level error code that was encountered during the OKL Accounting Process
GL_TRANSFER_ERROR_CODE	VARCHAR2	(90)		Accounting entry header level error code that was encountered during the OKL Transfer to GL Process
GL_REVERSAL_FLAG	VARCHAR2	(3)		Not used..
ORG_ID	NUMBER			Operating unit identifier
PROGRAM_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_UPDATE_DATE	DATE			Concurrent Manager column
REQUEST_ID	NUMBER	(15)		Concurrent Manager column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column

Query Text

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


SELECT AE_HEADER_ID
,      POST_TO_GL_FLAG
,      SET_OF_BOOKS_ID
,      ACCOUNTING_EVENT_ID
,      OBJECT_VERSION_NUMBER
,      AE_CATEGORY
,      PERIOD_NAME
,      ACCOUNTING_DATE
,      GL_TRANSFER_RUN_ID
,      CROSS_CURRENCY_FLAG
,      GL_TRANSFER_FLAG
,      SEQUENCE_ID
,      SEQUENCE_VALUE
,      DESCRIPTION
,      ACCOUNTING_ERROR_CODE
,      GL_TRANSFER_ERROR_CODE
,      GL_REVERSAL_FLAG
,      ORG_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OKL.OKL_AE_HEADERS_ALL;

Dependencies

[top of page]

OKL.OKL_AE_HEADERS_ALL does not reference any database object

OKL.OKL_AE_HEADERS_ALL is referenced by following:

APPS: OKL_AE_HEADERS; OKL_AE_HEADERS_ALL