Project Management: Cost Detail
Find descriptions of the fields in the Project Management: Cost Detail data source organized by category.
Calendar Date
- Year
-
Calendar year starting with January 1st and ending on December 31st. This may be different from the company's Fiscal Calendar.
- Month
-
Includes all dates from the start of the month through the end of the month.
- Week
-
This is the week number using a 12 month calendar year.
Cost Type
- Cost Type
-
The lowest level of work managed on a project.
- Vista table.field: JCCT.CostType
- Spectrum table.field: JC_PHASE_MASTER_MC.Cost_Type
- Cost Center
-
For Spectrum only. This represents the cost center, profit center or some other way to group the organization.
- Spectrum table.field: JC.PHASE_MASTER_MC.Cost_Center if it exists, otherwise JC_JOB_MASTER_MC.Cost_Center
- Cost Groups
-
For Spectrum only. This represents the cost centers, profit centers or some other way to group the organization.
- Spectrum table.field: EM_COST_GROUP_LIST_MC.Cost_Group
Cost Type Summary
- Cost Type Summary
-
For Spectrum only. A group of cost types added together for reporting purposes.
- Spectrum table.field: JC_COST_TYPE_SUMMARY_MC.Summary_Name
Employee Department
- Department
-
The employee's home Payroll Department.
- Vista table.field: bPREH.PRDept
- Spectrum table.field:PR_EMPLOYEE_MASTER_1_MC.DepartmentCode
Employee Occupation
- Occupation
-
The employee's occupation from payroll.
- Vista table.field: bPREH.OccupCat
- Spectrum table.field: PR_EMPLOYEE_MASTER_1_MC.Occupation
Employee Title
- Employee Title
-
For Spectrum only. The employee's title.
- Spectrum table.field: PR_EMPLOYEE_MASTER_1_MC.Title
Employee Trade
- Employee Trade
-
The employee's trade.
- Vista table.field: bPREH.Craft
- Spectrum table.field: PR_EMPLOYEE_MASTER_1_MC.Trade
Equipment
- Equipment Type
-
Represents a type of equipment.
- Vista table.field: bEMEM.Type
- Spectrum table.field: EC_EQUIPMENT_MASTER_MC.Equipment_Type
- Weight Class
-
For Spectrum only. Represents the equipment's weight class.
- Spectrum table.field: EC_EQUIPMENT_MASTER_MC.Equipment_Weight_Class
- Make
-
Represents the make of the equipment.
- Vista table.field: bEMEM.Manufacturer
- Spectrum table.field: EC_EQUIPMENT_MASTER_MC.Equipment_Make
- Model
-
Represents the model of the equipment.
- Vista table.field: bEMEM.Model
- Spectrum table.field: EC_EQUIPMENT_MASTER_MC.Equipment_Model
- Equipment Code
-
This code represents specific equipment.
- Vista table.field: bEMEM.Equipment
- Spectrum table.field: EC_EQUIPMENT_MC.Equipment_Code
Item Code
- Item Code
-
This code represents a material item. When it starts with '!', it indicates that the item is not stocked normally.
- Vista table.field: HQMT.Material and HQMT.MaterialGroup
- Spectrum table.field: IM_ITEM_MASTER_MC.Item_Code
Job
- Company Code
-
This represents the specific company.
- Vista table.field: JCJM.JCCo
- Spectrum table.field: JC_JOB_MASTER_MC.Company_Code
- Job Code
-
This code is used to identify the job.
- Vista table.field: JCJM.Job
- Spectrum table.field: JC_JOB_MASTER_MC.Job_Code
- Phase Code
-
The Phase Code may be thought of as a way to break the job into smaller parts. Other names include Work Breakdown Structure (WBS) codes, Construction Specifications Institute (CSI) codes or cost codes.
- Vista table.field: JCCD.Phase
- Spectrum table.field: JC_PHASE_SUMMARY_MC.Phase_Code
Job Status
- Job Status
-
The status of the job that includes Active, Inactive, and Complete.
- Vista table.field: JCJM.Status
- Spectrum table.field: JC_JOB_MASTER_MC.Status
Master Job
- Master Job
-
For Spectrum Only. The master job serves as the primary setup, and be for reporting purposes to include all sub-job activity as if performed in a single large job, It may also control how T+M billings of the sub-jobs work.
- Spectrum table.field: JC_JOB_MASTER_MC.Master_Job
Measures
- Cost
-
The current month's actual cost for the project.
- Vista table.field: JCCD.ActualCost
- Spectrum table.field: JC_TRANSACTION_HISTORY_MC.Tran_Amount
- Cost to Date
-
This is the job-to-date actual cost amount for the project.
- Estimated Cost
-
The net changes to estimated costs for the month
- Vista table.field: JCCD. - Job Cost Detail.CurrEstCosEstCost
- Spectrum table.field: JC_PHASE_MASTER_MC.Original_Est_Cost + JC_PHASE_ESTIMATES_MC.Est_Cost + CR_CHNG_REQ_CON_DET_MC. Change_Request_Amount
- Estimated Cost to Date
-
The job-to-date estimated cost budget for this project.
- Estimated Hours
-
The net changes to estimated hours for the month.
- Vista table.field: JCCD.EstHours
- Spectrum table.field: JC_PHASE_MASTER_MC.Original_Est_Hours + JC_PHASE_ESTIMATES_MC.Est_Hours + CR_CHNG_REQ_CON_DET_MC.Change_Request_Hours
- Estimated Hours To Date
-
The job-to-date original estimated hours plus change orders.
- Estimated Quantity
-
The net changes to estimated quantities for the month.
- Vista table.field: JCCD.EstUnits
- Spectrum table.field: JC_PHASE_MASTER_MC.Original_Est_Quantity + JC_PHASE_ESTIMATES_MC.Est_Quantity + CR_CHNG_REQ_CON_DET_MC.Change_Request_Quantity
- Estimated Quantity To Date
-
The job-to-date estimated quantities budget for this project.
- Hours
-
The labor hours and contract labor hours for the month.
- Vista table.field: JCCD.ActualHours
- Spectrum table.field: JC_TRANSACTION_HISTORY_MC.Total_Hours
- Hours to Date
-
The job-to-date labor hours and contract labor hours for the job.
- Original Estimated Cost
-
The original estimated costs for this project.
- Vista table.field: JCCD.EstCost
- Spectrum table.field: JC_PHASE_MASTER_MC.Original_Est_Cost
- Projected Cost
-
The projected final cost of the contract. Note that if the projected final cost is zero, this value will display the estimated cost.
- Vista table.field: JCCD.ProjCost
- Spectrum table.field: JC_PROJ_COST_HISTORY_MC.Amount
- Projected Cost to Date
- The job-to-date projected cost budget for this project.
- Projected Hours
-
The projected hours for the month.
- Vista table.field: JCCD.ProjHours
- Spectrum table.field: JC_PROJ_COST_HISTORY_MC.Projected_Hours
- Projected Hours to Date
-
The job-to-date projected hours budget for this project.
- Projected Quantity
-
The projected quantities for the month.
- Vista table.field: JCCD.ProjUnits
- Spectrum table.field: JC_PROJ_COST_HISTORY_MC.Quantity
- Projected Quantity to Date
-
The job-to-date projected quantities for this project.
- Quantity
-
The current month's quantity for this project.
- Vista table.field: JCCD.ActualUnits
- Spectrum table.field: JC_TRANSACTION_HISTORY_MC.Quantity
- Quantity to Date
-
The job-to-date quantity for this project.
Transaction Type
- Transaction Type Code (1)
- Indicates the source of the transaction.
- AP - Accounts Payable
- AR - Accounts Receivable
- EQ - Equipment
- GL - General Ledger
- IC - Inventory
- JB - Job Billings
- JC - Job Cost
- OH - Overhead
- PR - Payroll
Vendor
- Vendor
-
This code represents a specific vendor.
- Vista table.field: APVM.Vendor
- Spectrum table.field: VN_VENDOR_MASTER_MC.Vendor_Code