We utilize the ISO 3166-1 spec for country codes.
- 3166-1 Alpha-2 codes go into BDCountries.ISO_Code
- 3166-1 Alpha 3 codes go into BDCountries.ISO_CodeAlpha3
We added ISO_CodeAlpha3 because that is what Sage 100 uses. We also support 3166-1 Numeric which goes into BDCountries.ISO_Numeric. ISO 3166-2 is the spec for country subdivisions which we recently added to our system in BDCountrySubDivisions.
Some locations can have multiple codes: for example, Saint Barthélemy, an overseas territorial collectivity of France, is officially assigned the ISO 3166-1 alpha-2 code BL since 2007, after its secession from Guadeloupe. Moreover, it is also assigned the ISO 3166-2 code FR-BL under the entry for France. Similarly, Puerto Rico, an outlying area of the United States, is officially assigned the ISO 3166-1 alpha-2 code PR. Moreover, it is also assigned the ISO 3166-2 code US-PR under the entry for the United States.