Imports - PM Import Information

Field

Value

Type/Size

Required for create new

Required for Update

Update Allowed

Asset Facility

Must be an existing facility

 int(5)

  •  
  •  
  •  

Asset Number

Must Match and existing asset in that facility

char(8)

  •  
  •  
  •  

PM Code

A0 thru Z9

char(1)Int(1)

  •  
  •  
  •  

Include PM Code

A0 thru Z9

char(1)Int(1)

  •  
  •  
  •  

Major VMRS

Must match an existing code

int(3)

  •  
  •  
  •  

 Intermediate VMRS

Must match an existing code

int(3) 

  •  
  •  
  •  

 Minor VMRS

Must match an existing code

 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 Meter

D = 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

If not set, set to N

 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 1

Only valid if the alternate meter is in use

int(6) 

  •  
  •  
  •  

  Last Done Alt Meter 1

Only valid if the alternate meter is in use

  int(6) 

  •  
  •  
  •  

  Interval Alt Meter 2

Only valid if the alternate meter is in use 

int(6)

  •  
  •  
  •  

 Last Done Alt Meter 2

Only valid if the alternate meter is in use  

int(6) 

  •  
  •  
  •  

  Interval Alt Meter 3

Only valid if the alternate meter is in use  

int(6) 

  •  
  •  
  •  

 Last Done Alt Meter 3

Only valid if the alternate meter is in use  

int(6) 

  •  
  •  
  •  

  Interval Alt Meter 4

Only valid if the alternate meter is in use  

int(6) 

  •  
  •  
  •  

 Last Done Alt Meter 4

Only valid if the alternate meter is in use  

int(6) 

  •  
  •  
  •  

 Current WO Facility

Must match existing facility

int(5) 

  •  
  •  
  •  

 Current WO Number

Must Match existing WO. If filled out, then we should mark PM as scheduled

 char(7)

  •  
  •  
  •  

 Current WO Line

Must match an existing line on the WO

 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)

  •  
  •  
  •  

Search