...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
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) | |