| Available Columns |
Description |
Date Range Available |
Chartable |
Links to Page |
| General Information
|
| CRM Client Type ID |
Indicates the ID from CRM |
|
|
|
| Description |
The description of the client type |
|
|
Client Type |
| Notes |
Any notes about the client type |
|
|
|
| Order |
The order of the client type in the client type list |
|
|
|
| Status |
The status of the client type
Examples: Active, Inactive
|
|
|
|
| Hours/Units
|
| Billed Hours |
The total number of hours billed to the client type |
X |
X |
|
| Hours Worked |
The total number of hours budgeted for the client type |
X |
X |
|
| Premium 1 Hours Worked |
The total premium 1 hours charged to this client type |
X |
X |
|
| Premium 2 Hours Worked |
The total premium 2 hours charged to this client type |
X |
X |
|
| Premium 3 Hours Worked |
The total premium 3 hours charged to this client type |
X |
X |
|
| Regular Hours Worked |
The total regular hours worked by this client type |
X |
X |
|
| WIP Hours |
The total number of work-in-progress (WIP) hours associated with the client type |
X |
X |
|
| Written off Hours |
The total number of write-off hours associated with the client type |
X |
X |
|
| Dollars
|
| Billed Adjustments Consultant |
The amount of adjustments with an activity type of Consultant that were billed
|
X |
X |
|
| Billed Adjustments Expense |
The amount of adjustments with an activity type of Expense that were billed
|
X |
X |
|
| Billed Adjustments Labor |
The amount of adjustments with an activity type of Labor that were billed
|
X |
X |
|
| Billed Adjustments |
The amount adjustments billed
|
X |
X |
|
| Billed Consultant |
The amount of consultant costs billed to the client type |
X |
X |
|
| Billed Expense |
The amount of expenses billed to the client type
|
X |
X |
|
| Billed Labor |
The amount of labor billed to the client type |
X |
X |
|
| Billed Sales Tax |
The amount of sales tax for labor or expenses associated with the client type |
X |
X |
|
| Billed |
The total amount billed to the client associated with the client type |
X |
X |
|
| Cost Burdened |
The cost amount of the phase + the overhead amount
|
X |
X |
|
| Cost Consultant |
The cost amount of the consultants for the client type |
X |
X |
|
| Cost Expense |
The cost amount of the expenses for the client type |
X |
X |
|
| Cost Labor Burdened |
The cost amount of the labor for the phase + the premium cost
|
X |
X |
|
| Cost Labor |
The cost amount of the labor for the client type |
X |
X |
|
| Cost |
The cost amount of the phase
This does not include any markups.
|
X |
X |
|
| Payroll Cost Burdened w/Exp & Cons |
The payroll cost of labor for the client type with overhead and DPE costs included, plus expenses and consultants
Payroll cost is the total sum of money to be paid out to employees at a given time.
|
X |
X |
|
| Payroll Cost Labor Burdened |
The payroll cost of labor for the client with overhead and DPE costs included
Payroll cost is the total sum of money to be paid out to employees at a given time.
|
X |
X |
|
| Payroll Cost Labor |
The payroll cost of labor for the client type without overhead and DPE costs
Payroll cost is the total sum of money to be paid out to employees at a given time.
|
X |
X |
|
| Payroll Cost w/Exp & Cons |
The payroll cost of labor for the client type without overhead and DPE costs, plus expenses and consultants
Payroll cost is the total sum of money to be paid out to employees at a given time.
|
X |
X |
|
| Prepayment Balance |
The total amount of prepayments remaining to be applied |
X |
X |
|
| Receipts Adjustments Consultant |
The amount of client receipts entered for adjustments with an activity type of Consultant
|
X |
X |
|
| Receipts Adjustments Expense |
The amount of client receipts entered for adjustments with an activity type of Expense
|
X |
X |
|
| Receipts Adjustments Labor |
The amount of client receipts entered for adjustments with an activity type of Labor
|
X |
X |
|
| Receipts Adjustments |
The amount of client receipts entered for adjustments, such as a discount, for the client type |
X |
X |
|
| Receipts Consultant |
The amount of client receipts entered for consultants for the client type |
X |
X |
|
| Receipts Expense |
The amount of client receipts entered for expenses for the client type |
X |
X |
|
| Receipts Labor |
The amount of client receipts entered for labor for the client type |
X |
X |
|
| Receipts Sales Tax |
The amount of sales tax for the client type included in the client receipts
|
X |
X |
|
| Receipts |
The total amount of client receipts entered for the client type |
X |
X |
|
| Receivable Balance |
The total amount remaining to be paid by the client associated with the client type |
X |
X |
|
| Spent Consultant |
The amount of consultant work performed by the client type at the billing rates
|
X |
X |
|
| Spent Expense |
The amount of expenses incurred by the client type at the billing rates
|
X |
X |
|
| Spent Labor |
The amount of labor performed by the client type at the billing rates
|
X |
X |
|
| Spent |
The total amount of time and expense spent by the client type at the billing rates
|
X |
X |
|
| WIP Consultant |
The amount of work-in-progress (WIP) for consultant costs for the client type |
X |
X |
|
| WIP Expense |
The amount of work-in-progress (WIP) for expenses for the client type |
X |
X |
|
| WIP Labor |
The amount of work-in-progress (WIP) for labor for the client type |
X |
X |
|
| WIP |
The total amount of work-in-progress associated with the client type |
X |
X |
|
| Written off Consultant |
The amount of write-off for consultant costs for the client type |
X |
X |
|
| Written off Expense |
The amount of write-off for expenses for the client type |
X |
X |
|
| Written off Labor |
The amount of write-off for labor for the client type |
X |
X |
|
| Written off |
The total amount of write-off associated with the client type |
X |
X |
|
| Keys
|
| Client Type Key |
The database identifier of the client type |
|
|
Client 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.
|
|
|
|
