[Home] [Help] [Dependency Information]
Object Name: | PA_MC_CUST_EVENT_RDL_AR |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_MC_CUST_EVENT_RDL_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_CUST_EVENT_RDL_AR_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SET_OF_BOOKS_ID
PROJECT_ID EVENT_NUM TASK_ID LINE_NUM |
PA_MC_CUST_EVENT_RDL_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 |
DRAFT_INVOICE_ITEM_LINE_NUM | NUMBER | (15) | The draft invoice item line number on which the event distribution line is invoiced | |
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 | ||
SET_OF_BOOKS_ID | NUMBER | (15) | The reporting set of books unique identifier | |
PROJECT_ID | NUMBER | (15) | The identifier of the project for which the revenue distribution line is generated. | |
TASK_ID | NUMBER | (15) | The identifier of the task that the event is assigned to. | |
EVENT_NUM | NUMBER | (15) | The event number of the event that is revenue distributed by the distribution line | |
LINE_NUM | NUMBER | (15) | The sequential number that identifies the revenue distribution line for an event | |
AMOUNT | NUMBER | The revenue amount in the reporting currency to be charged to the GL account for the event on a draft revenue. | ||
REQUEST_ID | NUMBER | (15) | Concurrent program Who column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent program Who column | |
PROGRAM_ID | NUMBER | (15) | Concurrent program Who column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent program Who column | ||
BATCH_NAME | VARCHAR2 | (30) | The reference to the GL je line in which the revenue was included when posted to GL. | |
DRAFT_REVENUE_NUM | NUMBER | (15) | The draft revenue number for which the revenue distribution line is generated | |
DRAFT_REVENUE_ITEM_LINE_NUM | NUMBER | (15) | The draft revenue item line number under which the revenue distribution line is generated | |
DRAFT_INVOICE_NUM | NUMBER | (15) | The draft invoice number on which the event distribution line is invoiced | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_BATCH_ID
, PURGE_RELEASE
, PURGE_PROJECT_ID
, DRAFT_INVOICE_ITEM_LINE_NUM
, CURRENCY_CODE
, EXCHANGE_RATE
, CONVERSION_DATE
, SET_OF_BOOKS_ID
, PROJECT_ID
, TASK_ID
, EVENT_NUM
, LINE_NUM
, AMOUNT
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, BATCH_NAME
, DRAFT_REVENUE_NUM
, DRAFT_REVENUE_ITEM_LINE_NUM
, DRAFT_INVOICE_NUM
, PRC_ASSIGNMENT_ID
, RATE_TYPE
FROM PA.PA_MC_CUST_EVENT_RDL_AR;
PA.PA_MC_CUST_EVENT_RDL_AR does not reference any database object
PA.PA_MC_CUST_EVENT_RDL_AR is referenced by following:
|
|
|