Imports - Asset Class Code Import Information

Field

Value

Type/Size

Required for create new

Required for Update

Update Allowed

Vehicle Class

Create New- Must be unique

Update - Has to exist already

char(15)

  •  
  •  
  •  

Class Description

char(40)

  •  
  •  
  •  

Max Units

int(05)

  •  
  •  
  •  

Asset Spec 1

char(15)

  •  
  •  
  •  

Asset Spec 2

char(15)

  •  
  •  
  •  

Asset Spec 3

char(15)

  •  
  •  
  •  

Asset Spec 4

char(15)

  •  
  •  
  •  

Asset Spec 5

char(15)

  •  
  •  
  •  

Asset Spec 6

char(15)

  •  
  •  
  •  

Asset Spec 7

char(15)

  •  
  •  
  •  

Asset Spec 8

char(15)

  •  
  •  
  •  

Asset Spec 9

char(15)

  •  
  •  
  •  

Asset Spec 10

char(15)

  •  
  •  
  •  

Asset Spec 11

char(15)

  •  
  •  
  •  

Asset Spec 12

char(15)

  •  
  •  
  •  

Asset Spec 13

char(15)

  •  
  •  
  •  

Asset Spec 14

char(15)

  •  
  •  
  •  

Asset Spec 15

char(15)

  •  
  •  
  •  

Asset Spec 16

char(15)

  •  
  •  
  •  

Asset Spec 17

char(15)

  •  
  •  
  •  

Asset Spec 18

char(15)

  •  
  •  
  •  

Asset Spec 19

char(15)

  •  
  •  
  •  

Asset Spec 20

char(15)

  •  
  •  
  •  

Asset Spec 21

char(15)

  •  
  •  
  •  

Asset Spec 22

char(15)

  •  
  •  
  •  

Estimated Years

Will update default value in replacement by year

int(4)

  •  
  •  
  •  

Estimated Primary Meter

Will update default value in replacement by year

decimal (8,1)

  •  
  •  
  •  

Estimated Resale Value

Will update default value in replacement by year

decimal (8,2)+/-

  •  
  •  
  •  

Low Service Request  Per Year

Will update default value in replacement by year

int(4)

  •  
  •  
  •  

High Service Requests Per Year

Will update default value in replacement by year

int(4)

  •  
  •  
  •  

Service Request Count

1 = By WO

2 = By WO Line

int(1)

  •  
  •  
  •  

Search