Equipment Work Order Component
Use this service to import Preventive Maintenance Equipment Work Order Components information.
Method: EquipWOComponent
Underlying File Maintenance
Prior to importing Preventive Maintenance Equipment Work Order Components information, the following file maintenance areas must be completed:Assumptions and Dependencies
If Company_Code is blank then use the Authorization ID default value.
The Maintenance_WO_Number must have a Work Order Status of Open or Finished to add Components. The Work Order Components will not be updated or a new one added if the status is Closed.
The Component_Group, Component_Code and Component_Seq are related and all pieces must be tied to the Equipment code defined on the Equipment Work Order.
To update an existing record the following logic will be applied once a valid Maintenance_WO_Number has been found-.
Hierarchy Logic
The unique combination of the Component_Group, Component_Code and Component_Seq.
The unique combination of the Component_Group, and Component_Code.
The unique combination of the Component_Group.
If a unique combination is not found and a record exists it will be updated with the defined information.
If multiple records exist for an Equipment Work Order for any of the above combinations then an error message will be provide for the user to correct. The web service cannot select which record to update.
The Work_Ordered_Note is a data field within the screen and will not be appended. It will replace any existing information.
If duplicate records exist to be updated, then they will all be updated as they are processed.
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 | Text | 3 | Valid Company in Spectrum. Defaults from the Authorization ID if not populated. | ||
C |
Maintenance_WO_Number | Equipment Work Order | YES | Text | 10 | Vaid Equipment Work Order that exists. | |
D |
Component_Group | Component group | Text | 10 | ** See Assumptions and Dependencies. | Valid Equipment Component Group | |
E |
Create_New | Create New Component | Text | 1 | Y=Yes If blank then defaults to N. | Creates a new Equipment Component for the Work Order. | |
F |
Warranty_Related_Status | Warranty-related | Text | 1 | Y=Yes, P=Possible, E= No, Expired, or N=No, not applicable. If blank then defaults to N. | K | |
G |
Repair_Status_Code | Repair Status | Text | 10 | Valid Repair Status Code | ||
H |
Work_Ordered_Note | Work order note | Text | 250 | Any data provided here will be updated on the screen. It will not append. | ||
I |
Component_Code | Component reference | Text | 10 | If defined then it must be valid for the defined Component_Group. ** See Assumptions and Dependencies. | Valid Equipment Component | |
J |
Component_Seq | Sequence | Text | 5 | Format = all 5 characters. If defined then it must be valid for the defined Component_Code. ** See Assumptions and Dependencies. | Valid for Sequence of the Equipment Component | |
K |
Estimated_Hours | Estimated hours | Numeric | 7 | Format = 4.2 Positive number only. | ||
L |
Actual_Hours | Actual hours | Numeric | 7 | Format = 4.2 Positive number only. | ||
M |
Detail_Status | Status | Text | 1 | O=Open, P=Pending or C=Closed. If blank then defaults to Open. |
