Imports - Work Order Transaction Import Information
Field | Value | Type/Size | Required |
|---|---|---|---|
WO Facility | Must be existing | int(5) | |
WO Number | Must be existing | char(7) | |
WO Line Number | Must be existing | int(2) | |
Transaction Type | 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 | Existing Facility | int(5) | |
Post Item Number | Tran Type P, OP, WP, OL, T, OT, WT, or M char(25) Tran Type L or WL int(10) | ||
Quantity | 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) | ||
Post Date | date | ||
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) | ||
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) | |
Creator ID | char(10) |