WO Import Field Definitions

FieldValueType/Size
WO FacilityRequiredint(5)
WO NumberRequiredchar(7)
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 DateDefault is current date Date
Created Time
int(8)
Last Update DateDefault is current dateDate
Start Date


Date
Start TimeHHMMint(4)
End DateDefault is the current user logged into RTADate
 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 CodeCodes 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)