WO Line Import Field Definitions
Only new WO lines are imported. Updates to existing lines are not allowed.
Field | Value | Type/Size |
|---|---|---|
WO Facility | Required | int(5) |
WO Number | Required | char(7) |
VMRS Major | Required | int(3) |
VMRS Intermediate | Required | int(3) |
VMRS Minor | Required | int(3) |
Line Quantity | int(2) | |
Total Scheduled Hours | decimal(6, 2) | |
Repair Type | Codes are defined in System Codes (SSY Repair Type tab) Defaults to the first code listed. | char(2) |
Cause Code | Codes are defined in System Codes (SSY Cause Type tab) Defaults to the first code listed. | char(2) |
Work Accomplished Code | Codes are defined in System Codes (SSY Work Accomplished Type tab) Defaults to the first code listed. | char(2) |
Outside Line Flag | Y = Outside Line N = In House Line (Default) | char(1) |
OEM Warranty Flag | Y = OEM Warranty Line N = Not an OEM Warranty Line(Default) | char(1) |
Warranty Flag | Y = Warranty Line N = Not a Warranty Line(Default) | char(1) |
Part Kit Number | char(25) | |
Vendor Facility | int(5) | |
Vendor Number | int(10) | |
Job Account Code | char(25) | |
Description | char(40) | |
User ID | char(10) | |
Created Date | Date | |
Vehicle Status | Codes are defined in System Codes (SSY Vehicle Status Type tab) Defaults to the first code listed | char(2) |