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: PN.PN_AE_HEADERS_ALL

Object Details

Object Name:	PN_AE_HEADERS_ALL
Object Type:	TABLE
Owner:	PN
FND Design Data:	PN.PN_AE_HEADERS_ALL
Subobject Name:
Status:	VALID

An accounting entry header is an entity grouping all accounting entry lines created for a given acounting event. All the accounting entry lines of an accounting entry header can be transferred to General Ledger, or none at all can be transferred. The success of the Transfer to GL process is indicated in 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 General Ledger. N indicates that the accounting entry header has not been transferred to General Ledger due to two posible reasons: either the transfer process has not run or it has run, but the accounting entry has an accounting error. E indicates that an error occured during the transfer to GL process.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PN_AE_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AE_HEADER_ID
PN_AE_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_TRANSFER_FLAG
PN_AE_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_TRANSFER_RUN_ID ACCOUNTING_DATE
PN_AE_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNTING_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
AE_HEADER_ID	NUMBER	(15)	Yes	Uniquely identifies the accounting header.
ACCOUNTING_EVENT_ID	NUMBER	(15)	Yes	Accounting event ID.
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of books ID.
AE_CATEGORY	VARCHAR2	(30)	Yes	Journal category.
CROSS_CURRENCY_FLAG	VARCHAR2	(1)	Yes	Cross currency flag.
PERIOD_NAME	VARCHAR2	(15)	Yes	The accounting period for the accounting entry.
ACCOUNTING_DATE	DATE		Yes	Accounting date.
GL_TRANSFER_FLAG	VARCHAR2	(1)	Yes	Indicates whether or not the transfer to GL has been done.
GL_TRANSFER_RUN_ID	NUMBER	(15)	Yes	Batch ID of GL transfer instance that transferred this accounting entry.
DESCRIPTION	VARCHAR2	(240)		Accounting entry header description.
ORG_ID	NUMBER	(15)		Organization identifier
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ACCOUNTING_ERROR_CODE	VARCHAR2	(30)		Accounting errors.
GL_TRANSFER_ERROR_CODE	VARCHAR2	(30)		GL transfer errors.
GL_REVERSAL_FLAG	VARCHAR2	(1)		GL reversal flag.
TRIAL_BALANCE_FLAG	VARCHAR2	(1)		Trial balance flag.

Query Text

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


SELECT AE_HEADER_ID
,      ACCOUNTING_EVENT_ID
,      SET_OF_BOOKS_ID
,      AE_CATEGORY
,      CROSS_CURRENCY_FLAG
,      PERIOD_NAME
,      ACCOUNTING_DATE
,      GL_TRANSFER_FLAG
,      GL_TRANSFER_RUN_ID
,      DESCRIPTION
,      ORG_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
,      ACCOUNTING_ERROR_CODE
,      GL_TRANSFER_ERROR_CODE
,      GL_REVERSAL_FLAG
,      TRIAL_BALANCE_FLAG
FROM PN.PN_AE_HEADERS_ALL;

Dependencies

[top of page]

PN.PN_AE_HEADERS_ALL does not reference any database object

PN.PN_AE_HEADERS_ALL is referenced by following:

PN: PN_AE_HEADERS_ALL#