WO Import Field Definitions
| Field | Value | Type/Size |
|---|---|---|
| WO Facility | Required | int(5) |
WO Number | Required | char(7) |
| Open Flag | Y = Open, N = Closed | |
| Unit Facility | Required | int(5) |
| Unit Number | Required | char(8) |
| Customer Facility | int(5) | |
| Customer Number | char(10) | |
| Shop ID | char(3) | |
WO Priority | 0 through 9 Codes are defined in System Codes (SSY Priority tab) Defaults to the first code listed. | int(1) |
| Created Date | Default is current date | Date |
| Created Time | int(8) | |
| Last Update Date | Default is current date | Date |
| Start Date | Date | |
| Start Time | HHMM | int(4) |
| End Date | Default is the current user logged into RTA | Date |
| End Time | HHMM | int(4) |
| Scheduled Out Date | Date | |
| Scheduled Out Time | HHMM | int(4) |
Unit Class (Size) | L = Light M = Medium H = Heavy (Default) T = Trailer O = Other | char(1) |
| Unit Meter | decimal(8, 3) | |
| Unit Life Meter | decimal(10, 3) | |
| Vehicle Alternate Odometer | decimal(8, 3) | |
| Vehicle Alternate Life Miles | decimal(10, 3) | |
| Labor Code | char(25) | |
| Parts Code | char(25) | |
Outside Code | char(25) | |
| Tire Code | char(25) | |
| Shop Code | char(25) | |
| Tax Code | char(25) | |
| Reason Code | Codes are defined in System Codes (SSY Reason Type tab) Defaults to the first code listed. | char(2) |
| VMRS Major | int(3) | |
| VMRS Intermediate | int(3) | |
| VMRS Minor | int(3) | |
| Creator ID | char(10) | |
| PO Number | facility - PO number | char(13) |
| Invoice | char(20) | |
| Invoice Date | Date | |
| Vendor Facility | int(5) | |
| Vendor Number | int(10) | |
| Capitalize Flag | char(1) | |