Part Vendor Import and Export

This program exports your Part Vedor 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
Part Facility	Required	int(5)
Part Number	Required	char(25)
Vendor Facility	Uses Part facility's default vendor facility if not specified then uses the Part Facility. Not Imported	int(5)
Vendor Number	Required	int(10)
Vendor Part Number		char(25)
Priority	1 through 9 inclusive Part must have a vendor and only one vendor with a priority of 1. If a part's vendor with priority of 1 is changed and another vendor is not changed during the import process to a priority of 1 this vendor will be reverted back to priority 1. If the priority for this vendor is set to 1 and there is already an existing priority 1 vendor for this part the existing priority 1 vendor's priority will be changed to 2.	Int(1)
Last Order Quantity	Not Imported	decimal(6,1)+/-
Last Order Price		decimal(7,3)
Manufacturer		char(5)
Lot Quantity		int(4)
Lot Unit		char(5)
Lot Price		decimal(7,3)
Last PO Facility	Not Imported	int(5)
Last PO Number	Not Imported	char(10)
Last PO Extension	Not Imported	int(4)
Last PO Date	Not Imported	date