| Available Columns |
Description |
Date Range Available |
Chartable |
Links to Page |
| General Information
|
| CRM Project Type ID |
Indicates the ID from CRM |
|
|
|
| Description |
The type of project
Examples: Commercial, Educational Facilities, Environmental Planning, Interiors, Medical Facilities, Residential
|
|
|
Project Type |
| Notes |
Any notes entered on the Notes tab of the project type |
|
|
|
| Order |
The order the project type shows on the list |
|
|
|
| Status |
The status of the project type |
|
|
|
| Hours/Units
|
| Billed Hours |
The total billed hours associated with the project type |
X |
X |
|
| Hours Worked |
The total hours worked associated with the project type |
X |
X |
|
| Premium 1 Hours Worked |
The total premium 1 hours worked associated with the project type |
X |
X |
|
| Premium 2 Hours Worked |
The total premium 2 hours worked associated with the project type |
X |
X |
|
| Premium 3 Hours Worked |
The total premium 3 hours worked associated with the project type |
X |
X |
|
| Regular Hours Worked |
The total regular hours worked associated with the project type |
X |
X |
|
| WIP Hours |
The total WIP hours associated with the project type |
X |
X |
|
| Written off Hours |
The total hours written off associated with the project type |
X |
X |
|
| Dollars
|
| Billed Adjustments Consultant |
Total Billed Adjustments Consultants for the project type |
X |
X |
|
| Billed Adjustments Expense |
Total Billed Adjustments Expense for the project type |
X |
X |
|
| Billed Adjustments Labor |
Total Billed Adjustments Labor for the project type |
X |
X |
|
| Billed Adjustments |
Total Billed Adjustments for the project type |
X |
X |
|
| Billed Consultant |
Total Billed Consultants for the project type |
X |
X |
|
| Billed Expense |
Total Billed Expense for the project type |
X |
X |
|
| Billed Labor |
Total Billed Labor for the project type |
X |
X |
|
| Billed Sales Tax |
Total Billed Sales Tax for the project type |
X |
X |
|
| Billed |
Total Billed for the project type |
X |
X |
|
| Cost Burdened |
Total Cost Burdened (cost + overhead) for the project type |
X |
X |
|
| Cost Consultant |
Total consultant cost for the project type |
X |
X |
|
| Cost Expense |
Total Expense Cost for the project type |
X |
X |
|
| Cost Labor Burdened |
Total Labor Cost Burdened (labor cost + overhead) for the project type |
X |
X |
|
| Cost Labor |
Total Labor Cost for the project type |
X |
X |
|
| Cost |
Total Cost for the project type |
X |
X |
|
| Payable Balance |
Total Payable Balance for the project type |
X |
X |
|
| Payments Consultant |
Total Consultant Payments for the project type |
X |
X |
|
| Payments Expense |
Total Expense Payments for the project type |
X |
X |
|
| Payments |
Total Payments for the project type |
X |
X |
|
| Payroll Cost Burdened w/Exp & Cons |
Total Payroll Cost Burdened with expense and consultant cost (payroll labor cost + overhead + expense cost + consultant cost) for the project type |
X |
X |
|
| Payroll Cost Labor Burdened |
Total Payroll Labor Cost Burdened (payroll labor cost + overhead) for the project type |
X |
X |
|
| Payroll Cost Labor |
Total Payroll Labor Cost for the project type |
X |
X |
|
| Payroll Cost w/Exp & Cons |
Total Payroll Cost with Expense and Consultant costs for the project type |
X |
X |
|
| Prepayment Balance |
Total balance of all prepayments for the project type |
X |
X |
|
| Receipts Adjustments Consultant |
Total Receipt adjustments for consultants for the project type |
X |
X |
|
| Receipts Adjustments Expense |
Total Receipt adjustments for expenses for the project type |
X |
X |
|
| Receipts Adjustments Labor |
Total Receipt adjustments for labor for the project type |
X |
X |
|
| Receipts Adjustments |
Total Receipt adjustments for the project type |
X |
X |
|
| Receipts Consultant |
Total Receipt for consultants for the project type |
X |
X |
|
| Receipts Expense |
Total Receipt for expenses for the project type |
X |
X |
|
| Receipts Labor |
Total Receipt for labor for the project type |
X |
X |
|
| Receipts Sales Tax |
Total Receipt for sales tax for the project type |
X |
X |
|
| Receipts |
Total Receipts for the project type |
X |
X |
|
| Receivable Balance |
Total Receivable Balance for the project type |
X |
X |
|
| Spent Consultant |
Total Spent on consultants for the project type |
X |
X |
|
| Spent Expense |
Total Spent on expenses for the project type |
X |
X |
|
| Spent Labor |
Total Spent on Labor for the project type |
X |
X |
|
| Spent |
Total Spent for the project type |
X |
X |
|
| Vendor Invoiced Consultant |
Total Vendor Invoiced on consultants for the project type |
X |
X |
|
| Vendor Invoiced Expense |
Total Vendor Invoiced on expenses for the project type |
X |
X |
|
| Vendor Invoiced |
Total Vendor Invoiced for the project type |
X |
X |
|
| WIP Consultant |
Total WIP for consultants for the project type |
X |
X |
|
| WIP Expense |
Total WIP for expenses for the project type |
X |
X |
|
| WIP Labor |
Total WIP for labor for the project type |
X |
X |
|
| WIP |
Total WIP for the project type |
X |
X |
|
| Written off Consultant |
Total Written off for consultants for the project type |
X |
X |
|
| Written off Expense |
Total Written off for expenses for the project type |
X |
X |
|
| Written off Labor |
Total Written off for Labor for the project type |
X |
X |
|
| Written off |
Total Written off for the project type |
X |
X |
|
| Keys
|
| Project Type Key |
The database identifier for the project type |
|
|
Project Type |
| Action
|
| Delete CRM Mapping |
Deletes the record from the mapping table |
|
|
|
| Gantt
|
unavailable in ajeraCore Select to add the Gantt chart to your table widget.
|
|
|
|
