[Home] [Help]
select ORGANIZATION_ID ORGANIZATION_ID, PROJECT_TYPE PROJECT_TYPE, EXPENDITURE_TYPE EXPENDITURE_TYPE, WEEK_ENDING_DATE WEEK_ENDING_DATE, ORG_ID ORG_ID, TOTAL_RAW_COST TOTAL_RAW_COST, TOTAL_BURDEN_COST TOTAL_BURDEN_COST, TOTAL_REVENUE TOTAL_REVENUE, BILLABLE_RAW_COST BILLABLE_RAW_COST, BILLABLE_BURDEN_COST BILLABLE_BURDEN_COST, INC_TOTAL_RAW_COST INC_TOTAL_RAW_COST, INC_TOTAL_BURDEN_COST INC_TOTAL_BURDEN_COST, INC_TOTAL_REVENUE INC_TOTAL_REVENUE, INC_BILLABLE_RAW_COST INC_BILLABLE_RAW_COST, INC_BILLABLE_BURDEN_COST INC_BILLABLE_BURDEN_COST, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CREATION_DATE CREATION_DATE from "PA"."PA_EMPLOYEE_ORG_ACCUM_EFC"
SELECT ORGANIZATION_ID ORGANIZATION_ID
, PROJECT_TYPE PROJECT_TYPE
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, WEEK_ENDING_DATE WEEK_ENDING_DATE
, ORG_ID ORG_ID
, TOTAL_RAW_COST TOTAL_RAW_COST
, TOTAL_BURDEN_COST TOTAL_BURDEN_COST
, TOTAL_REVENUE TOTAL_REVENUE
, BILLABLE_RAW_COST BILLABLE_RAW_COST
, BILLABLE_BURDEN_COST BILLABLE_BURDEN_COST
, INC_TOTAL_RAW_COST INC_TOTAL_RAW_COST
, INC_TOTAL_BURDEN_COST INC_TOTAL_BURDEN_COST
, INC_TOTAL_REVENUE INC_TOTAL_REVENUE
, INC_BILLABLE_RAW_COST INC_BILLABLE_RAW_COST
, INC_BILLABLE_BURDEN_COST INC_BILLABLE_BURDEN_COST
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CREATION_DATE CREATION_DATE
FROM "PA"."PA_EMPLOYEE_ORG_ACCUM_EFC"
|
|
|
|