WO Import Field Definitions

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)