WO Facility

int(5)

WO Number

char(7)

Line #

 int(2)

VMRS Major

int(3)

VMRS Intermediate

int(3)

VMRS Minor

 int(3)

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)

Vendor Facility

 int(5)

Vendor Number

 int(10)

Job Account Code

 char(25)

Description

char(40)

User ID

 char(10)

Created Date

Date 

Line Notes

char(60,000)

Mechanic Facility

Must be an existing facility

int(5)

Mechanic Number

Must be an existing mechanic.

This will go in as the primary mechanic on the line.

int(10)