Equipment Import/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 |