Sales Order Ship To Address Data Needed for BPM

There’s a custom field in the BPM workflow designer for ttOrderHed.ShipToAddressList that I believe holds the data shown in the Ship To address textbox on the Sales Order Entry form. Does anyone know where that information is stored? I’m needed to get the country for each Sales Order in a BPM and can’t figure out where that is stored. Thanks for your time and any help you can offer!

ShipTo Table… Join on CustNum and ShipToNum

2 Likes

Thank you Jose! That’s just what I was looking for.

Wouldn’t the join be on ShipToCustNum and ShipToNum?

1 Like

the shipto table has custnum as part of the key… this is because the shiptonum is not unique, custnum and shiptonum is unique.

1 Like