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)