Project Type Base
| 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. |
|||
