[Home] [Help] [Dependency Information]
Object Name: | PA_MC_EXP_ITEMS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
EXPENDITURE_ITEM_ID | NUMBER | (15) | Yes | |
RAW_COST | NUMBER | |||
RAW_COST_RATE | NUMBER | |||
BURDEN_COST | NUMBER | |||
BURDEN_COST_RATE | NUMBER | |||
RAW_REVENUE | NUMBER | |||
BILL_RATE | NUMBER | |||
ACCRUED_REVENUE | NUMBER | |||
ACCRUAL_RATE | NUMBER | |||
ADJUSTED_REVENUE | NUMBER | |||
ADJUSTED_RATE | NUMBER | |||
BILL_AMOUNT | NUMBER | |||
FORECAST_REVENUE | NUMBER | |||
NET_ZERO_ADJUSTMENT_FLAG | VARCHAR2 | (1) | ||
TRANSFERRED_FROM_EXP_ITEM_ID | NUMBER | (15) | ||
PRC_ASSIGNMENT_ID | NUMBER | Yes | ||
CURRENCY_CODE | VARCHAR2 | (30) | ||
COST_EXCHANGE_RATE | NUMBER | |||
COST_CONVERSION_DATE | DATE | |||
COST_RATE_TYPE | VARCHAR2 | (30) | ||
REVENUE_EXCHANGE_RATE | NUMBER | |||
REVENUE_CONVERSION_DATE | DATE | |||
REVENUE_RATE_TYPE | VARCHAR2 | (30) | ||
TRANSFER_PRICE | NUMBER | |||
TP_EXCHANGE_RATE | NUMBER | |||
TP_CONVERSION_DATE | DATE | |||
TP_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_INV_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_INV_RATE_DATE | DATE | |||
PROJFUNC_INV_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_FCST_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_FCST_RATE_DATE | DATE | |||
PROJFUNC_FCST_EXCHANGE_RATE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT 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_ALL#;
|
|
|