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

FieldValueType/Size
FacilityRequiredint(5)
Vendor NumberRequiredint(10)
AbbreviationRequired (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 PercentThis 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 RateThis 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 BudgetEdit for existing vendor onlydecimal(7,2)
Budget UsedEdit for existing vendor onlydecimal(7,3)+/-
Budget Running BalanceEdit for existing vendor onlydecimal(7,3)+/-
Blanket PO Start DateEdit for existing vendor onlydate
Blanket PO Expire DateEdit for existing vendor onlydate
Dealer ID
int(10)
GPS LatitudeMust be -90 to 90decimal(2,6)+/-
GPS LongitudeMust be -180 to 180decimal(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