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.