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_TXN_ACCUM_EFC#

Source

View Text - Preformatted


select TXN_ACCUM_ID TXN_ACCUM_ID, TOT_REVENUE TOT_REVENUE, TOT_RAW_COST TOT_RAW_COST, TOT_BURDENED_COST TOT_BURDENED_COST, TOT_BILLABLE_RAW_COST TOT_BILLABLE_RAW_COST, TOT_BILLABLE_BURDENED_COST TOT_BILLABLE_BURDENED_COST, TOT_CMT_RAW_COST TOT_CMT_RAW_COST, TOT_CMT_BURDENED_COST TOT_CMT_BURDENED_COST, I_TOT_REVENUE I_TOT_REVENUE, I_TOT_RAW_COST I_TOT_RAW_COST, I_TOT_BURDENED_COST I_TOT_BURDENED_COST, I_TOT_BILLABLE_RAW_COST I_TOT_BILLABLE_RAW_COST, I_TOT_BILLABLE_BURDENED_COST I_TOT_BILLABLE_BURDENED_COST, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CREATION_DATE CREATION_DATE from "PA"."PA_TXN_ACCUM_EFC"

View Text - HTML Formatted

SELECT TXN_ACCUM_ID TXN_ACCUM_ID
, TOT_REVENUE TOT_REVENUE
, TOT_RAW_COST TOT_RAW_COST
, TOT_BURDENED_COST TOT_BURDENED_COST
, TOT_BILLABLE_RAW_COST TOT_BILLABLE_RAW_COST
, TOT_BILLABLE_BURDENED_COST TOT_BILLABLE_BURDENED_COST
, TOT_CMT_RAW_COST TOT_CMT_RAW_COST
, TOT_CMT_BURDENED_COST TOT_CMT_BURDENED_COST
, I_TOT_REVENUE I_TOT_REVENUE
, I_TOT_RAW_COST I_TOT_RAW_COST
, I_TOT_BURDENED_COST I_TOT_BURDENED_COST
, I_TOT_BILLABLE_RAW_COST I_TOT_BILLABLE_RAW_COST
, I_TOT_BILLABLE_BURDENED_COST I_TOT_BILLABLE_BURDENED_COST
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CREATION_DATE CREATION_DATE
FROM "PA"."PA_TXN_ACCUM_EFC"