Monday, June 24, 2019

ODBC > Name Format Used For State Field

In NetSuite, states are stored in two different formats:

1. Long Name (e.g. California)
2. Short Name (e.g. CA)

When users run a query in ODBC where State value is grabbed, ODBC uses the short name only for the states. This applies to all tables such us customers and contacts.

No comments:

Post a Comment