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: AP.AP_AE_HEADERS_ALL

Object Details

Object Name:	AP_AE_HEADERS_ALL
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_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
AP_AE_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AE_HEADER_ID
AP_AE_HEADERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACCOUNTING_EVENT_ID SET_OF_BOOKS_ID
AP_AE_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_TRANSFER_FLAG
AP_AE_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_TRANSFER_RUN_ID ACCOUNTING_DATE
AP_AE_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNTING_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
AE_HEADER_ID	NUMBER	(15)	Yes	Accounting entry header identifier
ACCOUNTING_EVENT_ID	NUMBER	(15)	Yes	Accounting event identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of books identifier
AE_CATEGORY	VARCHAR2	(30)	Yes	Accounting entry category. The possible values come from GL_JE_CATEGORIES and are: Purchase Invoices, Payments, Reconciled Payments
CROSS_CURRENCY_FLAG	VARCHAR2	(1)	Yes	Indicates whether this accounting entry headerhas accounting entry lines with different enteredcurrencies. This is used by the GL Transferprogram to set the journal category to CrossCurrency to enable GL to create the balancing journal line
PERIOD_NAME	VARCHAR2	(15)	Yes	Accounting period name
ACCOUNTING_DATE	DATE		Yes	Accounting date
GL_TRANSFER_FLAG	VARCHAR2	(1)	Yes	Indicates whether accounting entry header has been successfully transferred to GL. Possible values are Y, N, E
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
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 entry header level error code that was encountered during the Payables Accounting Process
GL_TRANSFER_ERROR_CODE	VARCHAR2	(30)		Accounting entry header level error code that was encountered during the Payables Transfer to GL Process
GL_REVERSAL_FLAG	VARCHAR2	(1)		Indicates to GL that the journal should be flagged a reversal journal. Not used by AP
TRIAL_BALANCE_FLAG	VARCHAR2	(1)		Y indicates that the accounting entry lines associated with this header record were inserted in the AP_LIABILITY_BALANCE table.

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 AP.AP_AE_HEADERS_ALL;

Dependencies

[top of page]

AP.AP_AE_HEADERS_ALL does not reference any database object

AP.AP_AE_HEADERS_ALL is referenced by following:

AP: AP_AE_HEADERS_ALL#