Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

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)