Spectrum: Service

Find definitions of the fields and measures included in the Spectrum: Service dataset organized by folder.

Work Order Cost

Labor Cost

The amount of labor costs charged to work orders. Note that Other Charge transactions are only included when they are billed.

Labor Cost To Date

The job-to-date labor costs.

Material Cost

The amount of material costs charged to work orders. Note that Other Charge transactions are only included when they are billed.

Material Cost To Date

The job-to-date material costs.

Other Cost

The amount of non-labor or non-material costs charged to work orders. Note that Other Charge transactions are only included when they are billed.

Other Cost To Date

Job-to-date costs that are not labor or materials.

Work Order Revenue

Billed Revenue

The amount of billings posted on work orders. These amounts do not include sales tax or VAT.

Billed Revenue To Date

The job-to-date amount of billed revenue.

Unbilled Revenue

The amount of billings that have not yet been billed. These amounts do not include any sales tax or VAT.

Unbilled Revenue To Date

The job-to-date amount of unbilled revenue.

Calendar Date

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.

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.

Customer

Customer

This code represents a specific customer.

Customer Name

The name of the customer associated with a specific customer code.

Salesperson

The salesperson associated with a specific customer.

Transaction Type

Transaction Type

Indicates the type of transaction: Labor, Material, Other Charges and Flat Rate Revenue. Note that Other Charges only includes billed transactions.

Work Order

Case Type Code

This code is used to further classify work orders into categories such as maintenance, installation, repair and so on.

Case Type Description

The description for a specific case type.

Company Code

This code represents the Spectrum Company or Spectrum Group of Entities.

Contract

This code represents the specific service contract for the selected customer.

Contract Begin Date

The start date for the service contract.

Contract Description

The description for the service contract.

Contract End Date

The end date for the service contract.

Contract Labor Level

The value for the Labor Level of the service contract.

Contract Material Level

The value for the Material Level of the service contract.

Contract Material Markup

The value for the Material Markup of the service contract.

Contract Type

This code represents the service contract type for the selected customer.

Cost Center

This code represents the cost center, profit center, or other way of grouping of the organization.

Cost Center Description

The description for the specific cost center.

Cost Groups

This code represents the cost center, profit center, or other way of grouping of the organization.

Dispatch Status

A user-definable code that indicates the progress on a work order.

Dispatch Status Description

The description for a specific dispatch status.

Lead Source

This code represents the source of new work order business.

Lead Source Description

The description for a specific lead source.

Price Method

Indicates the method used to price out the work order: T+M or Flat Rate

Priority Code

This code is used to indicate the priority of the work. Examples include rush, standard, or whenever.

Priority Description

The description for a specific priority code.

Site

This code represents the service site for the selected customer.

Site Description

The description for the service site.

Work Order #

The Work Order number for the service contract.

Work Order Status

The status of the work order. Includes: Proposed, Open, Assigned, Arrived, Hold, Finished or None.

Work Order Type

This code represents the category of tasks assigned. It also is linked to the G/L Department to control where transactions are posted in the General Ledger.

Work Order Type Description

The description for the category of tasks assigned.

Zone Code

This code represents a section of the city, county or other geographical identifier.

Zone Description

The description for the specific zone.