notehead,

The exact information I'm looking for is everything that shows up on the invoice:
Invoice number, ShipTo Company, ShipTo Address, ShipTo City, ShipTo State, ShipTo Zip and Shipping Method (Ground, NDA, 2ND Air).

I am now able to link multiple tables within Worldship's new version 8.0. So if you could tell me what table each one of these fields is located in, I should be good to go.

Also, is there a reference document that I can download that tells me each table within MOM, and a description of the fields within these tables? That would make my life so much easier! Thanks for all your help on this!

P.S. Steve email me at "cdockry at ups.com" and I should be able to find you a local UPS Tech. to help you out.

Hi Casey,

EXPORT.DBF is the table you are looking for.  You client will have to export their invoices first then you will be able to access the data.

Cons : You will lose the data on each export.

Pros : You can map the data easily using UPS ODBC mapping utility.

Best,

Videoflicks2004

The customer I am working with does not have the import / export module installed. Is there another file I could link to that would contain all the information I'm looking for?

I'm a technician for UPS and I'd like to integrate UPS Worldship with MOM via a FoxPro ODBC Driver. I was wondering if there is a table within MOM that contains all the ship-to information as well as a sales order number? All the information I'm looking for would most likely be contained on the packing slip - invoice: Sales order number, Customer name, Address, City, State, Zip, Shipping method (ground, next day air, 2nd day air). Is there a table that contains all this info or am I going to have to link multiple tables using Access? Thanks your time and help.

-Casey