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) |