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.
- 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
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