Add Equipment (Required Fields)
Use this service to import Equipment information.
Method: AddEquip_Req
Underlying File Maintenance
Prior to importing Equipment information, the following file maintenance screens must be completed:Assumptions and Dependencies
- Depends on flag for "validate equipment division with G/L department" in the Equipment Control installation screen.
- If selected, then field entry is mandatory.
- The users will press F4 to select from the G/L Department File Maintenance.
- If not selected, this field is not mandatory and can be used to enter other information in alphanumeric format, up to 5 characters.
- If a Meter type is populated then the Meter description is required.
- The cost accruals method defaults to Year when the item is created.
- The Make and Model fields validate based on the Equipment Control Installation screen validation option for make and model.
- If the Equipment_Retired field is defined then the Equipment_Status field must have a status type of Retired.
- If the Equipment_Sold field is defined as Y(es) then the Sell Price, Sold Date, and Sold To fields are required.
- Cost center information will only be allowed if the Company is set to a Pending or Yes status.
- Cost centers will validate against the Cost Center Maintenance Table.
Field Descriptions
Use the table below for reference when using this service. The Authorization_ID and GUID elements are not shown on the Spectrum Excel Office Add-in templates for data entry points.| Excel | Element Name | Description | Req | Type | Max | Format | Validation |
|---|---|---|---|---|---|---|---|
| Authorization_ID | Authorization ID to access the server | YES | Text | 20 | Data Exchange Installation Screen | ||
| GUID | Unique reference number created by programming | Text | 36 | ** See GUID definition | |||
| B | Company_Code | Company Code | YES | Text | 3 | Valid Company in Spectrum | |
| C | Equipment_Code | Equipment Code | YES | Text | 10 | Unique identifier-No commas | UPPERCASE FORMAT- NO SYMBOLS |
| D | Division_Code | Division | Text | 5 | Depends on flag for Validate equipment division with G/L department? in the Equipment Control installation screen. If selected, this field entry is mandatory. | ||
| E | Equipment_Type | Equipment Type | YES | Text | 4 | Equipment Type Maintenance | |
| F | Description | Description | YES | Text | 30 | ||
| G | Year | Year | Numeric | 2 | |||
| H | Equipment_Make | Make | Text | 20 | Validated if Equipment installation option selected. | ||
| I | Equipment_Model | Model | Text | 20 | Validated if Equipment installation option selected. | ||
| J | Serial_Number | Serial No. | Text | 50 | |||
| K | On_Road_Code | Road Usage | Text | 1 | (1) for on-road or (2) for off road. If blank then defaults to 1. | ||
| L | Meter_Type | Primary Meter Type | Text | 1 | (M)iles, (H)ours, (K)ilometers, or (U)sage | ||
| M | Fuel_Oil_Code | Fuel Code | Text | 2 | Must have a fuel type of Gas or Diesel only. | Fuel/Oil Maintenance | |
| N | Capacity | Capacity Wt. | Numeric | 6 | Positive numbers only. | ||
| O | Gross_Weight | Vehicle Gross Wt. | Numeric | 6 | Positive numbers only. | ||
| P | Scale_Weight | Vehicle Scale Wt. | Numeric | 6 | Positive numbers only. | ||
| Q | Owned_Flag | Acquisition Type | Text | 1 | (O)wned, (R)ent, or (L)ease | ||
| R | Condition_Code | Condition: New or Used? | Text | 1 | (N)ew or (U)sed | ||
| S | Billing_Rate_Code | Billing Code | Text | 10 | T&M billing code file in EQ Billing Rates | ||
| T | Last_Job | Last Job No. | Text | 10 | Valid Job number or data entry field. | Jobs Maintenance (if applicable) | |
| U | Wage_Code | Wage Code | Text | 10 | Payroll Wage Code file in combination with Union Code | ||
| V | Union_Code | Union Code | Text | 10 | Payroll Wage Code file in combination with Union Code | ||
| W | Equipment_Status | Equipment status | YES | Text | 4 | Equipment Status Code Maintenance | |
| X | Purchase_Date | Purchase Date | Date | 10 | Enter as MM/DD/CCYY (01/15/2023) | ||
| Y | Purchased_From | Purchased From | Text | 15 | |||
| Z | Purchase_Cost | Original Cost | Numeric | 14 | Enter decimals but no $ or commas. | ||
| AA | Last_Meter | Primary Last Meter Reading | Numeric | 10 | No entry allowed in start screen field. If field is defined then Meter_Type must be defined. | ||
| AB | Last_Meter_Date | Primary Last Meter Read Date | Date | 8 | Enter as MM/DD/CCYY (01/15/2023) | No entry allowed in start screen field. If field is defined then Meter_Type must be defined. | |
| AC | Engine_Make | Engine Make | Text | 20 | Validated if Equipment installation option selected. | ||
| AD | Engine_Model | Engine Model | Text | 20 | Validated if Equipment installation option selected. | ||
| AE | Transmission_Make | Transmission Make | Text | 20 | Validated if Equipment installation option selected. | ||
| AF | Transmission_Model | Transmission Model | Text | 20 | Validated if Equipment installation option selected. | ||
| AG | Power_Axle_Make | Power Axle Make #1 | Text | 20 | Validated if Equipment installation option selected. | ||
| AH | Power_Axle_Model | Power Axle Model #1 | Text | 20 | Validated if Equipment installation option selected. | ||
| AI | Tire_Code_1 | Tire Code 1 | Text | 14 | Equipment Tire Maintenance | ||
| AJ | Tire_Code_2 | Tire Code 2 | Text | 14 | Equipment Tire Maintenance | ||
| AK | Yard_Code | Yard No. | Text | 5 | Yard Maintenance | ||
| AL | Location | Yard Location | Text | 8 | Equipment Location Maintenance | ||
| AM | Equipment_RFID | Equipment RFID | Text | 30 | |||
| AN | Equipment_GPS | Equipment GPS | Text | 30 | |||
| AO | Equipment_Meter_Type2 | Equipment Meter #2 Type | Text | 1 | (M)iles; (H)ours; (K)ilometers or (U)sage | ||
| AP | Equipment_Meter_Type3 | Equipment Meter #3 Type | Text | 1 | (M)iles; (H)ours; (K)ilometers or (U)sage | ||
| AQ | Equipment_Meter_Type4 | Equipment Meter #4Type | Text | 1 | (M)iles; (H)ours; (K)ilometers or (U)sage | ||
| AR | Equipment_Meter_Desc1 | Equipment Meter #1 Description | Text | 20 | Meter type must be defined in order to have a Meter description defined. | ||
| AS | Equipment_Meter_Desc2 | Equipment Meter #2 Description | Text | 20 | Meter type must be defined in order to have a Meter description defined. | ||
| AT | Equipment_Meter_Desc3 | Equipment Meter #3 Description | Text | 20 | Meter type must be defined in order to have a Meter description defined. | ||
| AU | Equipment_Meter_Desc4 | Equipment Meter #4 Description | Text | 20 | Meter type must be defined in order to have a Meter description defined. | ||
| AV | Equipment_Engine_Yr | Engine Year | Numeric | 4 | Enter the year | ||
| AW | Equipment_Trans_Yr | Transmission Year | Numeric | 4 | Enter the year | ||
| AX | Equipment_Power_Axle1_Yr | Power Axle #1 Year | Numeric | 4 | Enter the year | ||
| AY | Equipment_Power_Axle2_Yr | Power Axle #2 Year | Numeric | 4 | Enter the year | ||
| AZ | Equipment_Power_Axle2_Make | Power Axle #2 Make | Text | 20 | Validated if Equipment installation option selected. | ||
| BA | Equipment_Power_Axle2_Model | Power Axle #2 Model | Text | 20 | Validated if Equipment installation option selected. | ||
| BB | Equipment_Power_Axle3_Yr | Power Axle #3 Year | Numeric | 4 | Enter the year | ||
| BC | Equipment_Power_Axle3_Make | Power Axle #3 Make | Text | 20 | Validated if Equipment installation option selected. | ||
| BD | Equipment_Power_Axle3_Model | Power Axle #3 Model | Text | 20 | Validated if Equipment installation option selected. | ||
| BE | Equipment_Height | Transportation Height | Numeric | 10 | Positive numbers only. Decimal ok | ||
| BF | Equipment_Width | Transportation Width | Numeric | 10 | Positive numbers only. Decimal ok | ||
| BG | Equipment_Length | Transportation Length | Numeric | 10 | Positive numbers only. Decimal ok | ||
| BH | Equipment_Dim_UOM | Transportation Unit of Measure | Text | 2 | Unit of Measure File | ||
| BI | Equipment_Weight_UOM | Weight Unit of Measure | Text | 2 | Unit of Measure File | ||
| BJ | Equipment_Weight_Class | Weight Class | Text | 10 | Weight Class Code | ||
| BK | Equipment_Retired | Retired Date | Date | 8 | Enter as MM/DD/CCYY (01/15/2023). If defined then Equipment_Status field must have a Status Type of Retired. | ||
| BL | Equipment_Sold | Equipment Sold? | Text | 1 | (Y)es or (N)o. | If yes then the Equipment_Sell_Price; Equipment_Sell_Date and Equipment_Sell_To fields are required. | |
| BM | Equipment_Sell_Price | Equipment Sold Price | Numeric | 11 | Decimal ok | Required if Equipment_Sold = Y | |
| BN | Equipment_Sell_Date | Equipment Sold Date | Date | 8 | Enter as MM/DD/CCYY (01/15/2023) | Required if Equipment_Sold = Y | |
| BO | Equipment_Sell_To | Equipment Sold To | Text | 15 | Required if Equipment_Sold = Y | ||
| BP | Market_Value | Current Market Value | Numeric | 9 | Positive numbers only. | ||
| BQ | Entry_Date | Entry Date | Date | 8 | Enter as MM/DD/CCYY (01/15/2023) If left blank then defaults to the system date. | ||
| BR | Cost_Center | Equipment Cost Center | Text | 10 | Cost Center Maintenance |
