SQL Table where Transaction Number exists

I had a representative from UPS come out to my store yesterday, and he was attempting to map the SQL fields to integrate UPs and RMS. He asked me to find out two things. 1. What table the transaction number is in. 2. How and where is the transaction number associated with the "Ship to" column? Thank you in advance for your help.

Reply to
knightsbridge
Loading thread data ...

the transaction number exists ALL over the place in RMS. But, what I believe you are interested in is the following:

SELECT * FROM [TRANSACTION] LEFT JOIN CUSTOMER ON CUSTOMER.ID = [TRANSACTION].CUSTOMERID LEFT JOIN SHIPTO ON SHIPTO.CUSTOMERID = [TRANSACTION].CUSTOMERID

"knightsbridge" wrote:

Reply to
Luminox

Transaction number is in the "Transaction" table. The link to the ship to is via the Customer table via CustomerID field.

Reply to
Jason

SKIP that and just get SHIPRUSH for UPS and RMS. It will make your life so much easier.

Just print the label and all the tracking info etc is written back to your transaction for future use.

Mickie

knightsbridge wrote:

Reply to
Mickie

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.