Vendor Import

This program exports your Vendor 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	Value	Type/Size
Facility	Required	int(5)
Vendor Number	Required	int(10)
Abbreviation	Required (can't be duplicate)	char(20)
Name		char(25)
Account Number		char(25)
Contact		char(25)
Address 1		char(25)
Address 2		char(25)
City and State		char(25)
Zip Code		char(12)
Fax Number		char(24)
Phone Number		char(24)
Pay Due Days		int(3)
Terms		char(12)
Discount Days		int(3)
Discount Percent	This should be the ACTUAL percent i.e 20.10 for 20.1%	decimal(2,2)
Ships Via		char(12)
Email		char(60)
F.O.B.		char(10)
Total Ship Days		int(4)
Tax ID Number		char(15)
Tax Rate	This should be the DECIMAL version of the rate, i.e .0875 for 8.75%.	decimal(0,5)+/-
Legal Status		char(5)
Last Purchase Date		date
YTD Purchases		decimal(10,2)+/-
LTD Purchases		decimal(10,2)+/-
Total POs		int(7)
Disadvantage Flag	Y = True/Checked N = False/Unchecked	char(1)
Certified Flag	Y = True/Checked N = False/Unchecked	char(1)
Certified Date		date
Business Type		char(5)
Billable Flag	This field is an enhancement field and is typically not applicable. Y = True N = False	char(1)
Use Blanket PO Flag	Y = Yes N = No always set to "N" when adding a new vendor	char(1)
PO Budget	Edit for existing vendor only	decimal(7,2)
Budget Used	Edit for existing vendor only	decimal(7,3)+/-
Budget Running Balance	Edit for existing vendor only	decimal(7,3)+/-
Blanket PO Start Date	Edit for existing vendor only	date
Blanket PO Expire Date	Edit for existing vendor only	date
Dealer ID		int(10)
GPS Latitude	Must be -90 to 90	decimal(2,6)+/-
GPS Longitude	Must be -180 to 180	decimal(3,6)+/-
Service 1		char(20)
Service 2		char(20)
Service 3		char(20)
Service 4		char(20)
Service 5		char(20)
Service 6		char(20)
Service 7		char(20)
Service 8		char(20)
Service 9		char(20)
Service 10		char(20)
Service 11		char(20)
Service 12		char(20)
Service 13		char(20)
Service 14		char(20)
Service 15		char(20)
Service 16		char(20)
Service 17		char(20)
Service 18		char(20)
Service 19		char(20)
Service 20		char(20)
Service Rating		int(2)
Service Preference	0 = No Preference 1 = Preferred 2 = Avoid	int(1)
Pay Method		char(1)
Activity Date		date
Last Vehicle Facility		int(5)
Last Vehicle Number		char(8)
Last User		char(10)
Update Date		date