UPS WorldShip - Import/Export Data Report

February 06, 2012 10:20:16

Map Name:	workoutz_import

Data Source Information:

	DSN Name:
		workoutz1
	DSN Description:
		workoutz Import
	ODBC Driver Name:
		MySQL ODBC 5.1 Driver
	ODBC Driver:
		C:\Program Files\MySQL\Connector ODBC 5.1\myodbc5.dll
	Database Name:
		workoutz_live
	Database Path:
		
	Database Server:
		174.123.112.210


Map Information:

	Map Type:
		Shipment
	Map Version:
		1015
	Primary Table:
		cart_orders
	Primary Key:
		orderNum
	Package Name:
		
	Prompt for Table Name:
		No


Field Mappings:

	ODBC Data Source Field (Table::Field)
		WorldShip Field (Container::Field)

	cart_orders::addressType
		Ship To::Residential Indicator
	cart_orders::ship_zip
		Ship To::Postal Code
	cart_orders::ship_state
		Ship To::State/Province/County
	cart_orders::ship_address1
		Ship To::Address 1
	cart_orders::ship_company
		Ship To::Attention
	cart_orders::ship_firstName
		Ship To::Company or Name
	cart_orders::ship_lastName
		Ship To::Company or Name
	cart_orders::ship_address2
		Ship To::Address 2
	cart_orders::serviceType
		Shipment Information::Service Type
	cart_orders::ship_address3
		Ship To::Address 3
	cart_orders::ship_phone
		Ship To::Telephone
	cart_orders::ship_country
		Ship To::Country/Territory
	cart_orders::ship_city
		Ship To::City or Town
	cart_orders::packageWeight
		Shipment Information::Actual Weight
	cart_orders::orderNum
		Package::Reference 1