Vehicle PM Import Field Definitions

Field
Value
Type/Size
Vehicle Facility

Required

 int(5)
Vehicle Number

Required

char(8)
PM CodeRequiredint(5)
Include PM Code

A0 thru Z9 

char(1)Int(1)
Major VMRS
int(3)
 Intermediate VMRS
int(3) 

 Minor VMRS


 int(3)
 Description
 char(50)
 Template WO Facility
 int(5)
 Template WO Number
 char(7)
 Part Kit Facility
 int(5)
 Part Kit Number
 char(25)
 PM Enabled

Y = PM Enabled (Default)

N = PM Not Enabled

 char(1)
 One Time PM

 Y = One Time Use PM

N = Recurring PM (Default)

 char(1)
 Inspection
 char(15)
 Primary MeterD = Days (Default)
M = Miles
G = Gallons
1 = Alt Meter 1
2 = Alt Meter 2
3 = Alt Meter 3
4 = Alt Meter 4
 char(1)
 Lock Days/Months

 P = interval is Months                                    (uses CCYYMM from date posted)

M = locked interval is Months                        (ignores date posted)

D = locked interval is Days

Space = Days meter is NOT locked                        (Default)

 char(1)
 Interval Days
int(6)
 Last Done Date
 date
 Last Done Lock Date
 date
 Lock Meter

Y =  Meter interval locked

N = Meter interval is NOT locked

 char(1)
 Interval Meter
 int(6)
 Last Done Work Meter
 decimal(8, 1)
 Last Done Life Meter
  int(8)
 Last Done Lock Meter
  int(8)
 Interval Gallons
 int(6)
 Last Done Gallons
int(8) 
 Interval Alt Meter 1Only valid if the alternate meter is in useint(6) 
  Last Done Alt Meter 1Only valid if the alternate meter is in use  int(6) 
  Interval Alt Meter 2Only valid if the alternate meter is in use int(6)
 Last Done Alt Meter 2Only valid if the alternate meter is in use  int(6) 
  Interval Alt Meter 3Only valid if the alternate meter is in use  int(6) 
 Last Done Alt Meter 3Only valid if the alternate meter is in use  int(6) 
  Interval Alt Meter 4Only valid if the alternate meter is in use  int(6) 
 Last Done Alt Meter 4Only valid if the alternate meter is in use  int(6) 
 Current WO Facility
int(5) 
 Current WO Number
 char(7)
 Current WO Line
 int(2)
 Last WO Facility
 int(5)
 Last WO Number
 char(7) 
 Last WO Line
 int2)
 Previous WO Facility
 int(5)
 Previous WO Number
  char(7)
 Previous WO Line
 int(2)
 Sleep Mode Enabled

Y = Sleep enabled

N = Sleep disabled

 char(1)
 Sleep Date
 date
 Days Sleep
 int(4)
 PM is Warranty

Y = PM is Warranty

N = PM Not Warranty (Default)

 char(1)
 Warranty Major VMRS
  int(3)
Warranty Intermediate   VMRS
  int(3) 
 Warranty Minor VMRS
   int(3)