[Home] [Help] [Dependency Information]
Object Name: | PA_MC_EVENTS |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_MC_EVENTS |
Subobject Name: | |
Status: | VALID |
PA_MC_EVENTS is an MRC sub table of PA_EVENTS. It stores currency
related information about events for each reporting set of books
associated
with the parent record on PA_EVENTS. The primary key on this table
is: SET_OF_BOOKS_ID, EVENT_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_MC_EVENTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SET_OF_BOOKS_ID
EVENT_ID |
PA_MC_EVENTS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SET_OF_BOOKS_ID
PROJECT_ID TASK_ID EVENT_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | The reporting set of books unique identifier |
EVENT_ID | NUMBER | Yes | The system-generated number that uniquely identifies an event. | |
PROJECT_ID | NUMBER | (15) | Yes | 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) | Yes | 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 | Yes | 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 | DATE | Exchange rate date to use for conversion from bill transaction currency to project functional currency if Fixed Date rate date type is used during invoice generation. | ||
PROJFUNC_INV_EXCHANGE_RATE | NUMBER | Exchange rate to use for conversion from 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 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;
PA.PA_MC_EVENTS does not reference any database object
PA.PA_MC_EVENTS is referenced by following:
|
|
|