[Home] [Help]
| Product: | PA - Projects |
|---|---|
| Description: | R10SC Only - Actual cost and revenue totals for projects and tasks by GL Period and expenditure category |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PROJECT_ID
, TASK_ID
, GL_PERIOD
, GL_START_DATE
, GL_END_DATE
, EXPENDITURE_CATEGORY
, ROUND(SUM(TOTAL_REVENUE)) TOTAL_REVENUE
, ROUND(SUM(TOTAL_RAW_COST)) TOTAL_RAW_COST
, ROUND(SUM(TOTAL_BURDEN_COST)) TOTAL_BURDEN_COST
, ROUND(SUM(TOTAL_QUANTITY)) TOTAL_QUANTITY
, ROUND(SUM(TOTAL_LABOR_HOURS)) TOTAL_LABOR_HOURS
, ROUND(SUM(BILLABLE_RAW_COST)) BILLABLE_RAW_COST
, ROUND(SUM(BILLABLE_BURDEN_COST)) BILLABLE_BURDEN_COST
, ROUND(SUM(BILLABLE_QUANTITY)) BILLABLE_QUANTITY
, ROUND(SUM(BILLABLE_LABOR_HOURS)) BILLABLE_LABOR_HOURS
, ROUND(SUM(BUDGETED_COST)) BUDGETED_COST
, ROUND(SUM(BUDGETED_REVENUE)) BUDGETED_REVENUE
, ROUND(SUM(BUDGETED_LABOR_HOURS)) BUDGETED_LABOR_HOURS GROUP BY PROJECT_ID
, TASK_ID
, GL_PERIOD
, GL_START_DATE
, GL_END_DATE
, EXPENDITURE_CATEGORY