Project Management: Materials
Find descriptions of the fields in the Project Management: Materials 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. Note that this value is based on the actual date of each record.
- Month
-
Includes all dates from the start of the month through the end of the month. Note that this value is based on the actual date of each record.
- Week
-
This is the week number using a 12 month calendar year. Note that this value is based on the actual date of each record.
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
Item
- Item
-
This code represents a specific 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
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
- Open Commitment
-
This value is the Ordered Amount minus the Received Amount.
- Vista table.field: JCCD.RemainCmtdCost
- Spectrum table.field: Ordered Amount - Received Amount
- Open Commitment to Date
-
This value is the Ordered Amount minus the Received Amount to date.
- Vista table.field: JCCD.ActualDate
- Spectrum table.field: Ordered Amount To Date - Received Amount To Date
- Ordered Amount
-
This is the month's ordered amount.
- Vista table.field: JCCD.ActualCost
- Spectrum table.field: PO_PURCHASE_ORDER_DETAIL_MC.Line_Extension_List1 + IM_REQUISITION_DETAIL_MC + IM_TRANSACTION_HISTORY.Committed_Extension
- Ordered Amount to Date
-
This is the job to date ordered amount.
- Vista table.field: JCCD.ActualDate
- Spectrum table.field: PO_PURCHASE_ORDER_DETAIL_MC.Line_Extension_List1 + IM_REQUISITION_DETAIL_MC + IM_TRANSACTION_HISTORY.Committed_Extension
- Ordered Quantity
-
This is the month's quantity ordered.
- Vista table.field: JCCD.ActualUnits
- Spectrum table.field: PO_PURCHASE_ORDER_DETAIL_MC.Quantity_List1 + IM_REQUISITION_DETAIL_MC.Transaction_Quantity + IM_TRANSACTION_HISTORY.Transaction_Quantity
- Ordered Quantity to Date
-
This is the job to date quantity ordered.
- Vista table.field: JCCD.ActualDate
- Spectrum table.field: PO_PURCHASE_ORDER_DETAIL_MC.Quantity_List1 + IM_REQUISITION_DETAIL_MC.Transaction_Quantity + IM_TRANSACTION_HISTORY.Transaction_Quantity
- Received Amount
-
This is the amount received for the month.
- Vista table.field: JCCD.TotalCmtdCost -JCCD.RemainCmtdCost
- Spectrum table.field: PO_RECEIVING_HISTORY_MC.Received_Amount + IM_TRANSACTION_HISTORY_MC.Committed_Extension
- Received Amount to Date
-
This is the amount received job to date.
- Vista table.field: JCCD.ActualDate
- Spectrum table.field: PO_RECEIVING_HISTORY_MC.Received_Amount + IM_TRANSACTION_HISTORY_MC.Committed_Extension
- Received Quantity
-
This is the month's quantity received.
- Vista table.field: CCD.TotalCmtdUnits -JCCD.RemainCmtdUnits
- Spectrum table.field: PO_RECEIVING_HISTORY_MC.Received_Quantity + IM_TRANSACTION_HISTORY_MC.Transaction_Quantity
- Received Quantity to Date
-
This is the job to date quantity received.
- Vista table.field: JCCD.ActualDate
- Spectrum table.field: PO_RECEIVING_HISTORY_MC.Received_Quantity + IM_TRANSACTION_HISTORY_MC.Transaction_Quantity
Type
- Type
- Indicates the source of the transaction: Purchase Order or Job Requisition/Material Order.
- Purchase Order Number
-
For Purchase Orders, the number of the transaction.
- Vista table.field: JCCD.PO
- Spectrum table.field: PO_PURCHASE_ORDER_DETAIL_MC.PO_Number, PO_RECEIVING_HISTORY_MC.PO_Number
- Requisition Number
-
For Spectrum, this is the job requisition number of the transaction. For Vista, this is the material order number.
- Vista table.field: RQRL.RQID
- Spectrum table.field: IM_REQUISITION_DETAIL_MC.Transaction_Reference, IM_TRANSACTION_HISTORY_MC.Transaction_Reference
Vendor
- Vendor
-
This code represents a specific vendor.
- Vista table.field: APVM.Vendor
- Spectrum table.field: VN_VENDOR_MASTER_MC.Vendor_Code