Imports - Equipment Import Information

Field

Value

Type/Size

Required for create new

Required for Update

Update Allowed

Facility

Must Match Existing Facility

int(5)

  •  
  •  
  •  

Equipment Number

Create New - just needs to be within character limit and adhere to character restrictions

 

Update - Must match existing Equipment Number within facility selected

char(25)

  •  
  •  
  •  

Description

 Must be within character Limit

  •  
  •  
  •  

Type

 

  •  
  •  
  •  

Year

Must be 4 digits

int(4)

  •  
  •  
  •  

Serial

  •  
  •  
  •  

Model

  •  
  •  
  •  

Manufacturer

  •  
  •  
  •  

Condition

  •  
  •  
  •  

Mounted Facility

Must Match Existing Facility

int(5)

Mounted Vehicle

Must be an existing vehicle within the facility selected

If this is filled out, then the status will be mounted. Otherwise it will just go to inventory

Char(8)

  •  
  •  
  •  

Mounted Date

date field

  •  
  •  
  •  

Assignment Name

  •  
  •  
  •  

Department

  •  
  •  
  •  

Customer

  •  
  •  
  •  

Terms

  •  
  •  
  •  

Value

  •  
  •  
  •  

Assigned Date

  •  
  •  
  •  

Date Purchased

 

  •  
  •  
  •  

PO Number

  •  
  •  
  •  

Cost

  •  
  •  
  •  

Service Reminder Job Code

  •  
  •  
  •  

Interval Day

  •  
  •  
  •  

Last Done

 

  •  
  •  
  •  

Search