WO Line Mechanic Import Field Definitions
Only new WO line mechanics are imported. Updates to existing mechanics are not allowed.
Field | Value | Type/Size |
|---|---|---|
Primary | Y = Is Primary N = Not Primary (default) | char(1) |
WO Facility | Required | int(5) |
WO Number | Required | char(7) |
WO Line Number | Required | int(2) |
Mechanic Facility | Required | int(5) |
Mechanic Number | Required | int(10) |
Wage | decimal(4, 2) | |
Scheduled Hours | decimal(3, 2) | |
Status | O = Open (Default) P = Partial C = Closed | char(1) |