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