[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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. |
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;
PN.PN_AE_HEADERS_ALL does not reference any database object
PN.PN_AE_HEADERS_ALL is referenced by following:
|
|
|