[Home] [Help] [Dependency Information]
Object Name: | PN_ACCOUNTING_EVENTS_ALL |
---|---|
Object Type: | TABLE |
Owner: | PN |
FND Design Data: | PN.PN_ACCOUNTING_EVENTS_ALL |
Subobject Name: | |
Status: | VALID |
An event is an entity whose role is to map transaction data to the accounting data created for it. Every accounting entry needs to be identified with the event that created it. Conceptualy, an event provides information about the timing and the reason for which the document created the accounting entries.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PN_ACCOUNTING_EVENTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ACCOUNTING_EVENT_ID |
PN_ACCOUNTING_EVENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SOURCE_TABLE
SOURCE_ID |
PN_ACCOUNTING_EVENTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
PN_ACCOUNTING_EVENTS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACCOUNTING_DATE |
PN_ACCOUNTING_EVENTS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EVENT_STATUS_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNTING_EVENT_ID | NUMBER | (15) | Yes | Uniquely identifies the accounting event. |
EVENT_TYPE_CODE | VARCHAR2 | (30) | Yes | The event type of the payment term. |
ACCOUNTING_DATE | DATE | Yes | Each accounting event has one accounting date. | |
EVENT_NUMBER | NUMBER | (15) | Yes | The number of the accounting event within the document. |
EVENT_STATUS_CODE | VARCHAR2 | (30) | Yes | Indicates whether the event has been accounted or if the event is in error . |
SOURCE_TABLE | VARCHAR2 | (30) | Yes | The source table the accounting event is linked(for example,PN_PAYMENT_TERMS). |
SOURCE_ID | NUMBER | (15) | Yes | The ID of the source document PAYMENT_TERM_ID. |
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_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). | |
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). | |
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). | |
ORG_ID | NUMBER | (15) | Organization identifier | |
CANNOT_ACCOUNT_FLAG | VARCHAR2 | (1) | Whether or not the event is to be accounted. |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNTING_EVENT_ID
, EVENT_TYPE_CODE
, ACCOUNTING_DATE
, EVENT_NUMBER
, EVENT_STATUS_CODE
, SOURCE_TABLE
, SOURCE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_UPDATE_DATE
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
, ORG_ID
, CANNOT_ACCOUNT_FLAG
FROM PN.PN_ACCOUNTING_EVENTS_ALL;
PN.PN_ACCOUNTING_EVENTS_ALL does not reference any database object
PN.PN_ACCOUNTING_EVENTS_ALL is referenced by following:
|
|
|