eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PA.PA_MC_EXP_ITEMS_AR#

Source

View Text - Preformatted


select PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_RELEASE PURGE_RELEASE, PURGE_PROJECT_ID PURGE_PROJECT_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID, RAW_COST RAW_COST, RAW_COST_RATE RAW_COST_RATE, BURDEN_COST BURDEN_COST, BURDEN_COST_RATE BURDEN_COST_RATE, RAW_REVENUE RAW_REVENUE, BILL_RATE BILL_RATE, ACCRUED_REVENUE ACCRUED_REVENUE, ACCRUAL_RATE ACCRUAL_RATE, ADJUSTED_REVENUE ADJUSTED_REVENUE, ADJUSTED_RATE ADJUSTED_RATE, BILL_AMOUNT BILL_AMOUNT, FORECAST_REVENUE FORECAST_REVENUE, NET_ZERO_ADJUSTMENT_FLAG NET_ZERO_ADJUSTMENT_FLAG, TRANSFERRED_FROM_EXP_ITEM_ID TRANSFERRED_FROM_EXP_ITEM_ID, PRC_ASSIGNMENT_ID PRC_ASSIGNMENT_ID, CURRENCY_CODE CURRENCY_CODE, COST_EXCHANGE_RATE COST_EXCHANGE_RATE, COST_CONVERSION_DATE COST_CONVERSION_DATE, COST_RATE_TYPE COST_RATE_TYPE, REVENUE_EXCHANGE_RATE REVENUE_EXCHANGE_RATE, REVENUE_CONVERSION_DATE REVENUE_CONVERSION_DATE, REVENUE_RATE_TYPE REVENUE_RATE_TYPE, TRANSFER_PRICE TRANSFER_PRICE, TP_EXCHANGE_RATE TP_EXCHANGE_RATE, TP_CONVERSION_DATE TP_CONVERSION_DATE, TP_RATE_TYPE TP_RATE_TYPE, PROJFUNC_INV_RATE_TYPE PROJFUNC_INV_RATE_TYPE, PROJFUNC_INV_RATE_DATE PROJFUNC_INV_RATE_DATE, PROJFUNC_INV_EXCHANGE_RATE PROJFUNC_INV_EXCHANGE_RATE, PROJFUNC_FCST_RATE_TYPE PROJFUNC_FCST_RATE_TYPE, PROJFUNC_FCST_RATE_DATE PROJFUNC_FCST_RATE_DATE, PROJFUNC_FCST_EXCHANGE_RATE PROJFUNC_FCST_EXCHANGE_RATE from "PA"."PA_MC_EXP_ITEMS_AR"

View Text - HTML Formatted

SELECT PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_RELEASE PURGE_RELEASE
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, RAW_COST RAW_COST
, RAW_COST_RATE RAW_COST_RATE
, BURDEN_COST BURDEN_COST
, BURDEN_COST_RATE BURDEN_COST_RATE
, RAW_REVENUE RAW_REVENUE
, BILL_RATE BILL_RATE
, ACCRUED_REVENUE ACCRUED_REVENUE
, ACCRUAL_RATE ACCRUAL_RATE
, ADJUSTED_REVENUE ADJUSTED_REVENUE
, ADJUSTED_RATE ADJUSTED_RATE
, BILL_AMOUNT BILL_AMOUNT
, FORECAST_REVENUE FORECAST_REVENUE
, NET_ZERO_ADJUSTMENT_FLAG NET_ZERO_ADJUSTMENT_FLAG
, TRANSFERRED_FROM_EXP_ITEM_ID TRANSFERRED_FROM_EXP_ITEM_ID
, PRC_ASSIGNMENT_ID PRC_ASSIGNMENT_ID
, CURRENCY_CODE CURRENCY_CODE
, COST_EXCHANGE_RATE COST_EXCHANGE_RATE
, COST_CONVERSION_DATE COST_CONVERSION_DATE
, COST_RATE_TYPE COST_RATE_TYPE
, REVENUE_EXCHANGE_RATE REVENUE_EXCHANGE_RATE
, REVENUE_CONVERSION_DATE REVENUE_CONVERSION_DATE
, REVENUE_RATE_TYPE REVENUE_RATE_TYPE
, TRANSFER_PRICE TRANSFER_PRICE
, TP_EXCHANGE_RATE TP_EXCHANGE_RATE
, TP_CONVERSION_DATE TP_CONVERSION_DATE
, TP_RATE_TYPE TP_RATE_TYPE
, PROJFUNC_INV_RATE_TYPE PROJFUNC_INV_RATE_TYPE
, PROJFUNC_INV_RATE_DATE PROJFUNC_INV_RATE_DATE
, PROJFUNC_INV_EXCHANGE_RATE PROJFUNC_INV_EXCHANGE_RATE
, PROJFUNC_FCST_RATE_TYPE PROJFUNC_FCST_RATE_TYPE
, PROJFUNC_FCST_RATE_DATE PROJFUNC_FCST_RATE_DATE
, PROJFUNC_FCST_EXCHANGE_RATE PROJFUNC_FCST_EXCHANGE_RATE
FROM "PA"."PA_MC_EXP_ITEMS_AR"