WO Facility

Must match existing Facility

int(5)

WO Number

Need an switch to ask if they want to use WO number from the file or let RTA assign the Vehicle number

char(7)

Asset Facility

Must match existing facility

int(5)

Asset Number

Must Match existing vehicle

char(8)

Customer Facility

 int(5)

Customer Number

 char(10)

Shop ID

 char(3)

Created Date

 Date

Created Time

int(8)

Start Date

Date

Start Time

HHMM

int(4)

End Date

Date

 End Time

 HHMM

 int(4)

 Unit Meter

decimal(8, 3)

 Unit Life Meter

 decimal(10, 3)

 Vehicle Alternate Odometer

 decimal(8, 3)

 Vehicle Alternate Life Miles

decimal(10, 3) 

 Reason Code

Codes are defined in System Codes (SSY Reason Type tab) Defaults to the first code listed if empty

  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)

WO Master Note