Imports - Asset Import Information

Facility

Must match an existing Facility within your RTA Software (Facilities must exist first)

Numeric/5 character limit

Asset Number

Create- Just needs to be 8 or less char and must be valid character types

Update- Must match existing vehicle in selected facility

Alpha-Numeric/8 character limit

Year

must be 4 digits

Numeric/4 character limit

Make

If system switch is set to match from their list, needs to verify off of the Make/model codes

Alpha-Numeric/15 character limit

Model

If system switch is set to match from their list, needs to verify off of the Make/model codes

Alpha-Numeric/15 character limit

Serial Number

This is the VIN

Alpha-Numeric/20 character limit

License Plate

Alpha-Numeric/15 character limit

Cross-Reference Number

Alpha-Numeric/8 character limit

Class Code #

Must match existing code #

Alpha-Numeric/15 character limit

Department Number

Must match existing Department #

Alpha-Numeric/10 character limit

Customer Facility

Must match an existing facility

int(5)

Customer Number

Alpha-Numeric/10 character limit

Registration

Notational field only and can be used for items like a registration number

Alpha-Numeric/20 character limit

Purchase Date

Valid Date

date

Purchased New

Y = Yes

N = No

Default to yes if left blank

Y or N

Inservice Date

Valid Date

date

Vehicle Size

L = Light

M = Medium

H = Heavy

T = Trailer

O = Other

Alpha-Numeric/1 character limit

Gross Vehicle Weight

Depending on  switch SSM Misc 1 tab #29 alpha or numeric

Alpha-Numeric/7 numerical character limit or 10 Alpha limit

Rear End Capacity

int(7)

Operator

Must be an existing contact in the system. This will update the primary operator in the system to be whoever was entered in

Meter Units

G = Gallons

K = Kilometers

U = Units

M = Miles

H = Hours

N = None

char(1)

Current Odometer

decimal(8,1)

Base Meter

decimal(8,1)+/-

Last Meter Date

date

Last Fuel Date

date

Begin Odometer Reading

decimal(7,1)

Vehicle Location

Alpha-Numeric/20 character limit

Tire Count

Must be less than max tire count

int(2)

Max Tire Count

int(2)

Purchase Price

decimal(8,3)+/-

Insurance Per Year

decimal(8,3)+/-

License Per Year

decimal(8,3)+/-

License Period

int(2)

License Period Count

int(2)

License Position

int(2)

Leased Vehicle

Y = Is Leased

N = Not Leased

Alpha-Numeric/1 character limit

Lease Start Date

Valid Date

Leased Vehicle has to be marked as Y.

date

Lease Expiration Date

Valid Date after start date.

Leased Vehicle has to be marked as Y.

date

Lease Cost Per Month

Leased Vehicle has to be marked as Y.

decimal(8,3)+/-

Outside Vehicle

Y = Outside

N = Inside

Alpha-Numeric/1 character limit

Fuel Type

Must match a Fuel type code under fuel types (MUF)

1 character limit matching a fuel type code created in the software

Fuel Capacity

int(6)

Average MPG

decimal(3,3)

Highway Tax rate

decimal(1,4)

Fuel Taxable

Y = Taxable

N = Not Taxable

Y or N

Fuel Cross-Reference

Alpha-Numeric/8 character limit

Oil Type

Alpha-Numeric/25 character limit

Oil Capacity

decimal(4,1)

Transmission Fluid

Alpha-Numeric/25 character limit

Transmission Capacity

decimal(4,1)

Anti-freeze

char(25)

Anti-freeze Capacity

decimal(4,1)

Gear Oil

Alpha-Numeric/25 character limit

Gear Oil Capacity

decimal(4,1)

Hydraulic Fluid

Alpha-Numeric/25 character limit

Hydraulic Capacity

decimal(4,1)

Freon

Alpha-Numeric/25 character limit

Freon Capacity

decimal(4,1)

Alternate Meter 1

Must match Alternate Meter Type ID (MVA)

Character limit is 2 and must match the alternate meter type code set up in RTA Software

Alternate Meter 1 Odometer

decimal(7,2)

Alternate Meter 2

Must match Alternate Meter Type ID (MVA)

Character limit is 2 and must match the alternate meter type code set up in RTA Software

Alternate Meter 2 Odometer

decimal(7,2)

Alternate Meter 3

Must match Alternate Meter Type ID (MVA)

Character limit is 2 and must match the alternate meter type code set up in RTA Software 

Alternate Meter 3 Odometer

decimal(7,2)

Alternate Meter 4

Must match Alternate Meter Type ID (MVA)

Character limit is 2 and must match the alternate meter type code set up in RTA Software

Alternate Meter 4 Odometer

decimal(7,2)

classinfo1

char(20)

classinfo2

char(20)

classinfo3

char(20)

classinfo4

char(20)

classinfo5

char(20)

classinfo6

char(20)

classinfo7

char(20)

classinfo8

char(20)

classinfo9

char(20)

classinfo10

char(20)

classinfo11

char(20)

classinfo12

char(20)

classinfo13

char(20)

classinfo14

char(20)

classinfo15

char(20)

classinfo16

char(20)

classinfo17

char(20)

classinfo18

char(20)

classinfo19

char(20)

classinfo20

char(20)

classinfo201

char(20)

classinfo22

char(20)

Definable Description 1

char(15)

Definable Value 1

char(20)

Definable Description 2

char(15)

Definable Value 2

char(20)

Definable Description 3

char(15)

Definable Value 3

char(20)

Definable Description 4

char(15)

Definable Value 4

char(20)

Definable Description 5

char(15)

Definable Value 5

char(20)

Definable Description 6

char(15)

Definable Value 6

char(20)

Definable Description 7

char(15)

Definable Value 7

char(20)

Definable Description 8

char(15)

Definable Value 8

char(20)

Definable Description 9

char(15)

Definable Value 9

char(20)

Definable Description 10

char(15)

Definable Value 10

char(20)

Definable Description 11

char(15)

Definable Value 11

char(20)

Definable Description 12

char(15)

Definable Value 12

char(20)

Definable Description 13

char(15)

Definable Value 13

char(20)

Definable Description 14

char(15)

Definable Value 14

char(20)

Definable Description 15

char(15)

Definable Value 15

char(20)

Definable Description 16

char(15)

Definable Value 16

char(20)

Definable Description 17

char(15)

Definable Value 17

char(20)

Definable Description 18

char(15)

Definable Value 18

char(20)

Definable Description 19

char(15)

Definable Value 19

char(20)

Definable Description 20

char(15)

Definable Value 20

char(20)