This solution provides standardized reference tables for countries and states/provinces, aligned to the ISO 3166‑1 and ISO 3166‑2 standards.
The country/state lookup fields provided in the solution for account/contact tables can coexists with corresponding free‑text fields to ensure data quality and enable reliable integrations using ISO identifiers.
US‑CA, IN‑TN).| Display Name | Data Type | Sample Data |
|---|---|---|
| Country Name | Text (Primary name) | (e.g., India, United States of America) |
| ISO 2 Code | Text | (e.g., IN, US) |
| ISO 3 Code | Text | (e.g., IND, USA) |
| ISO Numeric Code | Whole Number | (e.g., 356, 840) |
| Display Name | Data Type | Sample Data |
|---|---|---|
| State/Province Name | Text (Primary name) | (e.g., Tamil Nadu, California) |
| ISO Code | Text | (e.g., IN‑TN, US-CA) |
| Country | Lookup | The display name column (i.e. 'Country Name') of country table is used. |
Country (1:N) → State/Province — Each country may have multiple subdivisions. Use the lookup to enforce referential integrity and enable joins in views and forms.
| Display Name | Description |
|---|---|
| Account - Populate Country & State/Province Fields |
Sets the OOB address fields for country and state/province text fields with the display name of the Lookup whenever corresponding lookup fields change. duit_address1countryname -> address1_country duit_address1stateprovincename -> address1_stateorprovince duit_address2countryname -> address2_country duit_address2stateprovincename -> address2_stateorprovince |
| Contact - Populate Country & State/Province Fields |
Sets the OOB address fields for country and state/province text fields with the display name of the Lookup whenever corresponding lookup fields change. duit_address1countryname -> address1_country duit_address1stateprovincename -> address1_stateorprovince duit_address2countryname -> address2_country duit_address2stateprovincename -> address2_stateorprovince duit_address3countryname -> address3_country duit_address3stateprovincename -> address3_stateorprovince |
All country and state/province data will be automatically loaded into the corresponding tables, if the solution was installed from Microsoft AppSource.
In other cases, please manually import the data using the Configuration Migration Tool (CMT) provided by Microsoft. The CMT zip file and zip content is located at the Data folder.
Wikipedia references
For State/Province Data, the datasource is https://github.com/ipregistry/iso3166/blob/main/countries.csv
For Country Data, the datasource is https://www.ip2location.com/free/iso3166-2
Update frequency should follow official ISO changes (monitor for code or subdivision updates).
Maintenance responsibilities: System Administrator / Data Steward. Suggested periodic review: quarterly or on ISO updates.
#E0EAF7#DBEADAVersion:1.0.0.0
Last updated: 2025‑10‑05
Email: info@duitconsulting.com