# Address mapping state names

**URL:** <https://connective.celigo.com/t/address-mapping-state-names/1442>\
**Category:** Integration Apps\
**Tags:** mapper, salesforce, netsuite\
**Created:** [April 21, 2020, 12:53pm UTC](https://connective.celigo.com/t/address-mapping-state-names/1442 "2020-04-21T12:53:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![itihd-sql](https://avatars.discourse-cdn.com/v4/letter/i/278dde/32.png) [@itihd-sql](https://connective.celigo.com/u/itihd-sql)\
**Post date:** [April 21, 2020, 12:53pm UTC](https://connective.celigo.com/t/address-mapping-state-names/1442/1 "2020-04-21T12:53:57Z")

</div>

so by default the Netsuite to Salesforce account flow maps shipstate (not a dropdown field from Netsuite) to the Shipping Address State/Province Code in Salesforce.

Unfortunately the Shipstate from Netsuite uses the short name values from Netsuite, and for the UK North Yorkshire becomes N Yorkshire. On the salesforce side, valid country/state combinations are part of global picklists, where the code cannot exceed 10 characters.

I'd like to use a picklist dynamic search to look by state name and flip it to the appropriate code, however shipstate is the state code/abbreviation, is there a shipstatename magical field (not in the drop list) that gives the name of the state instead of the code?

---

<div class="post-metadata">

**Author:** ![docssupport](https://avatars.discourse-cdn.com/v4/letter/d/df788c/32.png) [@docssupport](https://connective.celigo.com/u/docssupport)\
**Post date:** [June 10, 2020, 2:17pm UTC](https://connective.celigo.com/t/address-mapping-state-names/1442/2 "2020-06-10T14:17:26Z")

</div>

Please raise a support case. We can help you resolve this.

Thank you,

Celigo Product Team