Spectrum: Equipment

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

The Spectrum: Equipment dataset provides a source of equipment cost (direct equipment cost and budgeted cost) and equipment financial (both cost and revenue on heavy equipment) information. It contains meter readings at a point in time as well as the net incremental change by period. You can use it to compare standby and usage hours against the asset's normal usage. It also includes meter readings at a point in time as well as the net incremental change by period. In addition, it includes both the original and current estimated value, standard job, and rental rates.

This dataset is intended for the Equipment Manager and Operations staff.

Note the following for certain fields in the dataset:

Date Format: Fiscal Calendar
Cost Centers: Equipment + Cost Category level

Equipment Costs

Budgeted Cost: The sum of the asset's ownership and operating annual costs.
Budgeted Hours: The asset's target annual work hours.
Equipment Current Market Value: The asset's estimated current market value as entered into the system.
Equipment Original Cost: The asset's original cost when purchased.
Normal Hours Per Week: The number of hours an asset is typically used in a week based on its equipment type.
Normal Kilometers Per Week: The number of kilometers an asset is typically driven in a week based on its equipment type.
Normal Miles Per Week: The number of miles an asset is typically driven in a week based on its equipment type.
Standard Job Rate: The asset's standard hourly charge-out rate for jobs.
Standard Rental Rate: The asset's standard rental rate.

Equipment Fuel/Cost

Cost: The cost of fuel or lubricant used in the asset.
Fuel Used: The quantity of fuel or lubricant used in the asset.

Note: This amount will match the amount reported on the asset's Fuel & Oil Report.

Equipment Meter

Meter Reading: The last meter reading at a point in time.
Net Meter: The difference between the current meter reading and the last meter reading.

Note: If there is no date range on the report, this amount matches Meter Reading.

Equipment Revenue

Hours: The hours an asset was used. This measure tracks either Standby or Usage hours depending on the asset's Usage Type.

Revenue: All revenue generated from asset usage. For job revenue assets, this includes all usage charged to jobs/projects. For rental revenue assets, this includes all usage billed to a third party customer.

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.

Cost Category Code

Component Group: A user-defined group to track similar components for warranty and maintenance purposes.
Component Group Description: Defines the parameters of the Component Group.
Cost Category Code: A user-defined code to track similar components for warranty and maintenance purposes.
Cost Category Description: Defines the parameters of the Cost Category Code.

Cost Category Type

Cost Category Type Code: A user-defined code to categorize expenses into 1-10 high-level categories.

Note: This field is only necessary if you enter data into Budget Cost Maintenance.
Cost Category Type Description: Defines the parameters of the Cost Category Type.

Equipment

Company Code: This code represents the Spectrum Company or Spectrum Group of Entities.
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.
Division: Used to group different assets together for reporting purposes.
Equipment Code: The user-defined code to represent a specific piece of equipment.
Equipment Description: A description of the asset.
Equipment Ownership: Indicates whether the asset is Owned, Leased, or Rented.
Equipment Status Code: A user-defined status for the asset that is mapped to an Equipment Status Type.
Equipment Status Description: Defines the parameters of the Equipment Status Code.
Equipment Status Type: Indicates whether the asset is Active, Inactive, or Retired.
Equipment Type: This is a way to group similar assets together.
Equipment Type Description: A description of the Equipment Type.
Equipment Year: The two-digit year that the asset was manufactured.
Latitude: The asset's latitude as measured by its GPS coordinates.
Location: The current location of the equipment.
Longitude: The asset's longitude as measured by its GPS coordinates.
Make: The brand of the asset.
Meter Type 1/2/3/4: Indicates the type of meter. These meters measure miles, hours, kilometers, and usage, respectively.
Model: The particular name that the manufacturer has given to the asset.
Purchase Condition: Indicates whether the asset was purchased new or used.
Purchased Date: The year, quarter, month, and/or day when the asset was acquired.
Road Usage: Indicates whether the asset is designed for On-road or Off-road use.
Weight Class: A user-defined group that allows equipment managers to compare equipment codes within the same weight class even when looking at different makes or models.
Weight Class Description: Defines the parameters of the Weight Class.
Weight Class Unit of Measure: Defines whether the weight class is measured in pounds, tons, or kilograms.

Equipment Fuel

Fuel / Oil Code: The user-defined code assigned to the specific type of fuel, oil, or lubricant.
Fuel / Oil Description: Defines the parameters of the Fuel / Oil Code.
Fuel / Oil Type: Indicates whether the equipment uses diesel, gasoline, or oil.
Fuel / Oil Unit of Measure: Indicates whether the fuel / oil is measured in quarts, gallons, or liters.

Meter

Meter: Indicates whether the data originates from Meter 1, 2, 3, or 4.

Revenue Type

Revenue Type: Indicates whether the revenue is based on the job or rental rate.

Source

Source: Indicates whether the data originates from Accounts Payable, Equipment Cost, General Ledger, Inventory Control, or Payroll.

Usage Type

Usage Type: Indicates whether the hours are Usage or Standby. Usage hours are computed as the sum of Full rate and Operating rate hours. Standby hours are not included in Usage.

Help for Trimble Products