Equipment (Get)
Use this service to import Equipment information.
Method: GetEquipment
Assumptions and Dependencies
The Authorization ID controls the security and defaults the pCompany_Code field if left blank in the parameter fields.
Equipment Status is based on the status type defined for each status code.
All parameter fields have SuperSelect logic except the following-
pStatus_Code
pCost_Center
pSort_By
Parameter Fields
Use the table below for reference when using this service.Element Name | Description | Req | Type | Max | Field Information |
---|---|---|---|---|---|
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 | |
pCompany_Code | Company Code | YES | Text | 3 | Valid Company in Spectrum. Defaults from the Authorization ID if not populated. |
pEquipment_Type | Equipment Type | Text | 4 | Equipment Type File Maintenance | |
pEquipment_Make | Make | Text | 20 | Equipment Make Maintenance based on Install option | |
pEquipment_Model | Model | Text | 20 | Equipment Model Maintenance based on Install option | |
pYear | Year | Numeric | 2 | ||
pStatus_Code | Equipment Status | Text | 4 | Define one specific Status type or leave blank to see Active and Inactive status types only | |
pCost_Center | Equipment Cost Center | Text | 10 | Define one specific Cost Center or leave blank to see all based on Authorization ID | |
pSort_By | Sort By Options | Text | 1 | Blank = Equipment Code or T= Equipment Type |
Return Fields
Use the table below for reference when using this service.Element Name | Description | Type | Max | Field Information |
---|---|---|---|---|
Company_Code | Company Code | Text | 3 | Valid Spectrum Company |
Equipment_Code | Equipment Code | Text | 10 | Equipment File Maintenance |
Equipment_Type | Equipment Type | Text | 4 | |
Description | Equipment Description | Text | 30 | |
Equipment_Status | Status | Text | 4 | Displays data based on the Equipment Status type |
Year | Year | Numeric | 2 | |
Equipment_Make | Make | Text | 20 | |
Equipment_Model | Model | Text | 20 | |
Owned_Flag | Acquisition Type | Text | 1 | O(wned), R(ent) or L(ease) |
License_Number | License # | Text | 15 | |
Serial_Number | Serial # / VIN | Text | 50 | |
Division_Code | Division | Text | 5 | |
Cost_Center | Equipment Cost Center | Text | 10 | |
Error_Code | Error Code | Text | 1 | Used for Error information if needed |
Error_Description | Error Description | Text | 250 | Used for Error information if needed |
Error_Column | Error Column | Text | 100 | Used for Error information if needed |