Jump to content


caseydockry

Member Since 10 Jan 2006
Offline Last Active Mar 15 2006 02:18 PM
-----

Posts I've Made

In Topic: Sales Order Table

12 January 2006 - 11:24 AM

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.

In Topic: Sales Order Table

11 January 2006 - 09:53 AM

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

View Post


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?