Equipment Import and Export

This program exports your Equipment records into a delimited text file. This file can then be edited manually or via a spreadsheet program, and then re-imported into the RTA system to update any changes made.

Import Options:

Create New
Checked - New records will be created
Unchecked - New Records WILL NOT be created

Update Existing
Checked - Existing records will be updated
Unchecked - Existing Records WILL NOT be updated

Import Field Definitions

Field Name	Value	Size/Type
Facility	Required	int(5)
Equipment Number	Required	char(8)
Type		char(4)
Description		char(30)
Year		int(4)
Serial Number		char(20)
Model		char(20)
Manufacturer		char(20)
Condition	N = New (Default) U = Used R = Rebuilt	char(1)
Status	M = Mounted I = Inventory (Default) R = Repair S = Scrapped	char(1)
Vehicle Facility		int(5)
Vehicle Number		char(8)
Assigned Facility		int(5)
Assigned Department		char(10)
Assigned Date		date
Assigned Terms		char(10)
Mounted Date		date
Mounted Odometer		decimal(7,1)
Mounted Value		decimal(6,2)
Current Value		decimal(6,2)
Purchase Date		date
Purchase Price		decimal(6,2)
PO Facility		int(5)
PO Number		char(10)
WO Facility		int(5)
WO Number		int(7)
WO Reason		char(30)
Comment 1		char(40)
Comment 2		char(40)
Comment 3		char(40)
Customer Facility		int(5)
Customer number		char(10)
Disposed Date		date
Disposed Value		decimal(6,2)
Disposed By		char(20)
Disposed Remarks		char(30)
Previous Vehicle Facility		int(5)
Previous Vehicle		char(8)
Dismount Date		date

RTA Knowledge Base

Equipment Import and Export

Analytics

Import Options:

Import Field Definitions

Related content