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.
SQL Table where Transaction Number exists
Jul 24, 2007
3 Replies
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:
Transaction number is in the "Transaction" table. The link to the ship to is via the Customer table via CustomerID field.
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:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required