Imports - Work Order VMRS Import Information

Field

Value

Type/Size

Required for create new

Required for Update

Update Allowed

Major VMRS

Must match if update or not exist if create new for a combination of the three codes

int(3)

  •  
  •  
  •  

Intermediate VMRS

Must match if update or not exist if create new for a combination of the three codes

int(3)

  •  
  •  
  •  

Minor VMRS

Must match if update or not exist if create new for a combination of the three codes

int(3)

  •  
  •  
  •  

Description

char(40)

  •  
  •  
  •  

Miscellaneous

char(25)

  •  
  •  
  •  

Job Hours 1

decimal(3,2)

  •  
  •  
  •  

Job Hours 2

decimal(3,2)

  •  
  •  
  •  

Job Hours 3

decimal(3,2)

  •  
  •  
  •  

Job Hours 4

decimal(3,2)

  •  
  •  
  •  

Job Hours 5

decimal(3,2)

  •  
  •  
  •  

Job Hours 6

decimal(3,2)

  •  
  •  
  •  

Job Hours 7

decimal(3,2)

  •  
  •  
  •  

Warranty Flag

Y = Is Warranty (Checked)

N = Not Warranty (Not Checked)

char(1)

  •  
  •  
  •  

Condition Prompt

Y = Prompt for vehicle condition (Checked)

N = Don't Prompt for vehicle condition (Not Checked)

char(1)

  •  
  •  
  •  

 Delete VMRS

 Y = Delete this VMRS Code 

 char(1)

  •  
  •  
  •  

Allow on Schedule

Y = Allow on Schedule

char(1)

  •  
  •  
  •  

Search