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.

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.

This is the week number using a 12 month calendar year. Note that this value is based on the actual date of each record.

The lowest level of work managed on a project.

For Spectrum only. This represents the cost center, profit center or some other way to group the organization.

For Spectrum only. This represents the cost centers, profit centers or some other way to group the organization.

For Spectrum only. A group of cost types added together for reporting purposes.

This represents the specific company.

This code is used to identify the job.

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.

The status of the job that includes Active, Inactive, and Complete.

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.

This is the current period's billing, before backing off the current period's retention amounts.

• Vista table.field: JCCD.ActualCost
• Spectrum table.field: VN_GL_DISTRIBUTION_DETAIL_MC.Debit_Amount

This is the job-to-date billed, before backing off retention amounts.

This is the quantity billed for the current period.

• Vista table.field: JCCD.ActualQuantity
• Spectrum table.field: VN_GL_DISTRIBUTION_DETAIL_MC.Quantity

This is the job-to-date quantity billed for the subcontract.

By month, the total value of all executed Subcontract Change Orders and Change Requests.

• Vista table.field: JCCD.TotalCommitedCost
• Spectrum table.field: VN_CHNG_REQ_SUB_DET_MC.CR_Amount

By month, the total quantities used in all executed Subcontract Change Orders and Change Requests.

• Vista table.field: JCCD.TotalCommitedUnits
• Spectrum table.field: VN_CHNG_REQ_SUB_DET_MC.CR_Quantity

The sum of the original subcontract plus executed subcontract changes.

• Vista: summation of the jccdtotalCommittedCosts from the start of the project up to the present.
• Spectrum table.field: VN_SUBCONTRACT_PHASE_MC.Original_Contract_Amount + VN_CHNG_REQ_SUB_DET_MC.CR_Amount

The sum of the original subcontract quantities plus executed subcontract changes to quantities.

• Vista: summation of the jccd.totalCommittedUnits from the start of the project up to the present.
• Spectrum table.field: VN_SUBCONTRACT_PHASE_MC.Original_Contract_Quantity + VN_CHNG_REQ_SUB_DET_MC.CR_Amount

For Spectrum only. The subcontract type is used to group subs by function, or by any other desired classification.

• Spectrum table.field: VN_SUBCONTRACT_MC.Contract_Type

This code represents a specific vendor.

This is the number used to refer to the subcontract.

• Vista table.field: SLHD.SL
• Spectrum table.field: VN_SUBCONTRACT_MC.Subcontract_Number

This code represents a specific line item on the subcontract. Billing is done by these bill items.

• Vista table.field: SLIT.SLItem
• Spectrum table.field: VN_SUBCONTRACT_PHASE.Bid_Item_Number