[Home] [Help] [Dependency Information]
Object Name: | PA_MC_EVENTS_AR |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_MC_EVENTS_AR |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_MC_EVENTS_AR_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SET_OF_BOOKS_ID
PROJECT_ID EVENT_NUM TASK_ID |
PA_MC_EVENTS_AR_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PURGE_PROJECT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_BATCH_ID | NUMBER | (15) | Yes | Purge batch Id |
PURGE_RELEASE | VARCHAR2 | (50) | Yes | Purge release version |
PURGE_PROJECT_ID | NUMBER | (15) | Yes | Purge Project Id |
SET_OF_BOOKS_ID | NUMBER | (15) | The reporting set of books unique identifier | |
EVENT_ID | NUMBER | (15) | The system-generated number that uniquely identifies an event. | |
PROJECT_ID | NUMBER | (15) | The identifier of the project to which event is assigned. | |
TASK_ID | NUMBER | (15) | The identifier of the top level task to which the event is assigned | |
EVENT_NUM | NUMBER | (15) | The sequential number that identifies the event entered for a task | |
REVENUE_AMOUNT | NUMBER | The amount of revenue in the reporting currency to accrue for the event upon the event"s completion | ||
BILL_AMOUNT | NUMBER | The amount in the reporting currency to be billed for the event on an invoice upon the event"s completion | ||
CURRENCY_CODE | VARCHAR2 | (30) | The currency code associated with the reporting set of books | |
EXCHANGE_RATE | NUMBER | The exchange rate used to convert to the reporting set of books currency | ||
CONVERSION_DATE | DATE | The conversion date used to convert to the reporting set of books currency | ||
PRC_ASSIGNMENT_ID | NUMBER | (15) | For future use | |
RATE_TYPE | VARCHAR2 | (30) | The exchange rate type used to convert to the reporting set of books currency | |
PROJFUNC_INV_RATE_DATE | VARCHAR2 | (240) | Exchange rate date used for conversion between bill transaction currency to project functional Currency during invoice generation | |
PROJFUNC_INV_EXCHANGE_RATE | NUMBER | Exchange rate to be used for conversion between bill transaction currency to Project functional currency during invoice generation | ||
DESCRIPTION | VARCHAR2 | (2000) | The free text description of the event. |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_BATCH_ID
, PURGE_RELEASE
, PURGE_PROJECT_ID
, SET_OF_BOOKS_ID
, EVENT_ID
, PROJECT_ID
, TASK_ID
, EVENT_NUM
, REVENUE_AMOUNT
, BILL_AMOUNT
, CURRENCY_CODE
, EXCHANGE_RATE
, CONVERSION_DATE
, PRC_ASSIGNMENT_ID
, RATE_TYPE
, PROJFUNC_INV_RATE_DATE
, PROJFUNC_INV_EXCHANGE_RATE
, DESCRIPTION
FROM PA.PA_MC_EVENTS_AR;
PA.PA_MC_EVENTS_AR does not reference any database object
PA.PA_MC_EVENTS_AR is referenced by following:
|
|
|