# Sales Order Ship To Address Data Needed for BPM

**Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5)
**Created:** 2017-02-02 20:49 UTC
**Views:** 806
**Replies:** 4
**URL:** https://www.epiusers.help/t/sales-order-ship-to-address-data-needed-for-bpm/37145

---

## Post #1 by @ShawnLeenerts

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!

---

## Post #2 by @josecgomez

ShipTo Table... Join on CustNum and ShipToNum

---

## Post #3 by @ShawnLeenerts

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

---

## Post #4 by @RBeaghan

Wouldn't the join be on ShipToCustNum and ShipToNum?

---

## Post #5 by @PaulMorgan

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

---


**Canonical:** https://www.epiusers.help/t/sales-order-ship-to-address-data-needed-for-bpm/37145
**Original content:** https://www.epiusers.help/t/sales-order-ship-to-address-data-needed-for-bpm/37145