WO Transaction Import Field Definitions
Only new WO transactions are imported. Updates to existing transactions are not allowed.
Field | Value | Type/Size |
|---|---|---|
WO Facility | Required | int(5) |
WO Number | Required | char(7) |
WO Line Number | Required | int(2) |
Transaction Type | Required P = Part OP = Outside Part WP = Warranty Part L = Labor OL = Outside Labor WL = Warranty Labor T = Tire OT = Outside Tire WT = Warranty Tire M = Miscellaneous | char(2) |
Post Item Facility | Required | int(5) |
Post Item Number | Required | Tran Type P, OP, WP, OL, T, OT, WT, or M char(25) Tran Type L or WL int(10) |
Quantity | Required | Tran Type P, OP, WP, T, OT, WT or M decimal(5, 1) Tran Type OL decimal(5, 2) Tran Type L or WL decimal(3, 2) |
Price | Tran Type P, OP, WP, T, or WT decimal(7, 3) Tran Type OL, OT, or M decimal(7, 2) Tran Type L or WL decimal(4, 2) | |
Odometer | decimal(8, 3) | |
Alt 1 Meter 1 Meter | decimal(7, 2) | |
Alt 2 Meter 2 Meter | decimal(7, 2) | |
Alt 3 Meter 3 Meter | decimal(7, 2) | |
Alt 4 Meter 4 Meter | decimal(7, 2) | |
Post Date | date | |
Item Description | char(40) | |
Work Accomplished Code | Codes are defined in System Codes (SSY Work Accomplished Type tab) Defaults to the first code listed. | char(2) |
Vehicle Status | Codes are defined in System Codes (SSY Vehicle Status Type tab) Defaults to the first code listed | char(2) |
Vehicle Condition | 1 -No Visual damage (Default) 2 -Minor imperfections 3 -Noticeable imperfections 4 -Accident damage 5 -Inoperative or unsafe | int(1) |
Creator ID | char(10) |