[Home] [Help] [Dependency Information]
Object Name: | PA_MC_EXP_ITEMS_AR |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_MC_EXP_ITEMS_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_EXP_ITEMS_AR_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SET_OF_BOOKS_ID
PURGE_PROJECT_ID EXPENDITURE_ITEM_ID |
PA_MC_EXP_ITEMS_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 | |
EXPENDITURE_ITEM_ID | NUMBER | (15) | The system-generated number that uniquely identifies the expenditure item | |
RAW_COST | NUMBER | The total raw cost of the expenditure item in the reporting currency. | ||
RAW_COST_RATE | NUMBER | The raw cost rate in the reporting currency used to cost the item | ||
BURDEN_COST | NUMBER | Total burdened cost of the expenditure item in the reporting currency. | ||
BURDEN_COST_RATE | NUMBER | The burdened cost rate in the reporting currency of the item. | ||
RAW_REVENUE | NUMBER | The potential revenue of the item in the reporting currency. | ||
BILL_RATE | NUMBER | The bill rate in the reporting currency for the expenditure item. | ||
ACCRUED_REVENUE | NUMBER | The total amount of revenue that the item accrued in the reporting currency. | ||
ACCRUAL_RATE | NUMBER | The rate in the reporting currency based on the accrued revenue. | ||
ADJUSTED_REVENUE | NUMBER | The discounted revenue amount of the item in the reporting currency based on the bill rate schedule | ||
ADJUSTED_RATE | NUMBER | The rate in the reporting currency based on the adjusted revenue. | ||
BILL_AMOUNT | NUMBER | The amount to be billed for the item in the reporting currency. | ||
FORECAST_REVENUE | NUMBER | The forecast revenue amount of a labor item based on T&M bill rates and markups and labor multiplier | ||
NET_ZERO_ADJUSTMENT_FLAG | VARCHAR2 | (1) | Flag that indicates whether the item is fully reversed or the item is one of the adjusting items | |
TRANSFERRED_FROM_EXP_ITEM_ID | NUMBER | (15) | The identifier of the expenditure item from which this expenditure item originated | |
PRC_ASSIGNMENT_ID | NUMBER | (15) | The assignment identifier used for project reporting currency | |
CURRENCY_CODE | VARCHAR2 | (30) | The currency code associated with the reporting set of books | |
COST_EXCHANGE_RATE | NUMBER | The exchange rate used to convert raw cost to the reporting set of books currency | ||
COST_CONVERSION_DATE | DATE | The date used to convert raw cost to the reporting set of books currency | ||
COST_RATE_TYPE | VARCHAR2 | (30) | The rate type used to convert raw cost to the reporting set of books currency | |
REVENUE_EXCHANGE_RATE | NUMBER | The exchange rate used to convert revenue to the reporting set of books currency | ||
REVENUE_CONVERSION_DATE | DATE | The date used to convert revenue to the reporting set of books currency | ||
REVENUE_RATE_TYPE | VARCHAR2 | (30) | The rate type used to convert revenue to the reporting set of books currency | |
TRANSFER_PRICE | NUMBER | The transfer price amount in the reporting currency code | ||
TP_EXCHANGE_RATE | NUMBER | The exchange rate used to convert transfer price amount to the reporting currency code | ||
TP_CONVERSION_DATE | DATE | The date used to convert transfer price amount to the reporting currency code | ||
TP_RATE_TYPE | VARCHAR2 | (30) | The rate type used to convert transfer price amount to the reporting currency code | |
PROJFUNC_INV_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type used for conversion between bill transaction currency to project functional currency during Invoice generation | |
PROJFUNC_INV_RATE_DATE | DATE | 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 | ||
PROJFUNC_FCST_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type to use for conversion between bill transaction currency to project functional currency during Forecast revenue generation. | |
PROJFUNC_FCST_RATE_DATE | DATE | Exchange rate date to use for conversion between bill transaction currency to project functional Currency if 'Fixed Date' rate date type used during forecast revenue generation. | ||
PROJFUNC_FCST_EXCHANGE_RATE | NUMBER | Exchange rate to be used for conversion between bill transaction currency to Project functional currency if 'User' exchange rate type used. During forecast revenue generation. |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_BATCH_ID
, PURGE_RELEASE
, PURGE_PROJECT_ID
, SET_OF_BOOKS_ID
, EXPENDITURE_ITEM_ID
, RAW_COST
, RAW_COST_RATE
, BURDEN_COST
, BURDEN_COST_RATE
, RAW_REVENUE
, BILL_RATE
, ACCRUED_REVENUE
, ACCRUAL_RATE
, ADJUSTED_REVENUE
, ADJUSTED_RATE
, BILL_AMOUNT
, FORECAST_REVENUE
, NET_ZERO_ADJUSTMENT_FLAG
, TRANSFERRED_FROM_EXP_ITEM_ID
, PRC_ASSIGNMENT_ID
, CURRENCY_CODE
, COST_EXCHANGE_RATE
, COST_CONVERSION_DATE
, COST_RATE_TYPE
, REVENUE_EXCHANGE_RATE
, REVENUE_CONVERSION_DATE
, REVENUE_RATE_TYPE
, TRANSFER_PRICE
, TP_EXCHANGE_RATE
, TP_CONVERSION_DATE
, TP_RATE_TYPE
, PROJFUNC_INV_RATE_TYPE
, PROJFUNC_INV_RATE_DATE
, PROJFUNC_INV_EXCHANGE_RATE
, PROJFUNC_FCST_RATE_TYPE
, PROJFUNC_FCST_RATE_DATE
, PROJFUNC_FCST_EXCHANGE_RATE
FROM PA.PA_MC_EXP_ITEMS_AR;
PA.PA_MC_EXP_ITEMS_AR does not reference any database object
PA.PA_MC_EXP_ITEMS_AR is referenced by following:
|
|
|