WO Line Import Field Definitions
Only new WO lines are imported. Updates to existing lines are not allowed.
| Field | Value | Type/Size |
|---|---|---|
| WO Facility | Required | int(5) |
| WO Number | Required | char(7) |
| VMRS Major | Required | int(3) |
| VMRS Intermediate | Required | int(3) |
| VMRS Minor | Required | int(3) |
| Line Quantity | int(2) | |
| Total Scheduled Hours | decimal(6, 2) | |
Repair Type | Codes are defined in System Codes (SSY Repair Type tab) Defaults to the first code listed. | char(2) |
| Cause Code | Codes are defined in System Codes (SSY Cause Type tab) Defaults to the first code listed. | char(2) |
| Work Accomplished Code | Codes are defined in System Codes (SSY Work Accomplished Type tab) Defaults to the first code listed. | char(2) |
| Outside Line Flag | Y = Outside Line N = In House Line (Default) | char(1) |
| OEM Warranty Flag | Y = OEM Warranty Line N = Not an OEM Warranty Line(Default) | char(1) |
| Warranty Flag | Y = Warranty Line N = Not a Warranty Line(Default) | char(1) |
| Part Kit Number | char(25) | |
| Vendor Facility | int(5) | |
| Vendor Number | int(10) | |
Job Account Code | char(25) | |
| Description | char(40) | |
| User ID | char(10) | |
| Created Date | Date | |
| Vehicle Status | Codes are defined in System Codes (SSY Vehicle Status Type tab) Defaults to the first code listed | char(2) |