WO Line Import Field Definitions
- Alan Michalec (Unlicensed)
- Kevin Meek
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) |