Locations:
LocationType ID: 1, Name:Country, Source:BillAddress.Country, SelectedCode: US
ID: 1, Parent: 0, Name:United States, Code: US
ID: 2, Parent: 0, Name:Canada, Code: CA
ID: 3, Parent: 0, Name:Afghanistan, Code: AF
ID: 4, Parent: 0, Name:United Kingdom, Code: UK
ID: 5, Parent: 0, Name:Albania, Code: AL
ID: 6, Parent: 0, Name:Algeria, Code: DZ
ID: 7, Parent: 0, Name:American Samoa, Code: AS
ID: 8, Parent: 0, Name:Andorra, Code: AD
ID: 9, Parent: 0, Name:Angola, Code: AO
ID: 10, Parent: 0, Name:Anguilla, Code: AI
ID: 11, Parent: 0, Name:Antarctica, Code: AQ
ID: 12, Parent: 0, Name:Antigua Barbuda, Code: AG
ID: 13, Parent: 0, Name:Argentina, Code: AR
ID: 14, Parent: 0, Name:Armenia, Code: AM
ID: 15, Parent: 0, Name:Aruba, Code: AW
ID: 16, Parent: 0, Name:Australia, Code: AU
ID: 17, Parent: 0, Name:Austria, Code: AT
ID: 18, Parent: 0, Name:Azerbaijan, Code: AZ
ID: 19, Parent: 0, Name:Bahamas, Code: BS
ID: 20, Parent: 0, Name:Bahrain, Code: BH
ID: 21, Parent: 0, Name:Bangladesh, Code: BD
ID: 22, Parent: 0, Name:Barbados, Code: BB
ID: 23, Parent: 0, Name:Belarus, Code: BY
ID: 24, Parent: 0, Name:Belgium, Code: BE
ID: 25, Parent: 0, Name:Belize, Code: BZ
ID: 26, Parent: 0, Name:Benin, Code: BJ
ID: 27, Parent: 0, Name:Bermuda, Code: BM
ID: 28, Parent: 0, Name:Bhutan, Code: BT
ID: 29, Parent: 0, Name:Bolivia, Code: BO
ID: 30, Parent: 0, Name:Bosnia Herzegovina, Code: BA
ID: 31, Parent: 0, Name:Botswana, Code: BW
ID: 32, Parent: 0, Name:Bouvet Island, Code: BV
ID: 33, Parent: 0, Name:Brazil, Code: BR
ID: 34, Parent: 0, Name:British Indian Ocean Territory, Code: IO
ID: 35, Parent: 0, Name:Brunei Darussalam, Code: BN
ID: 36, Parent: 0, Name:Bulgaria, Code: BG
ID: 37, Parent: 0, Name:Burkina Faso, Code: BF
ID: 38, Parent: 0, Name:Burundi, Code: BI
ID: 39, Parent: 0, Name:Cambodia, Code: KH
ID: 40, Parent: 0, Name:Cameroon, Code: CM
ID: 41, Parent: 0, Name:Cape Verde, Code: CV
ID: 42, Parent: 0, Name:Cayman Islands, Code: KY
ID: 43, Parent: 0, Name:Central African Republic, Code: CF
ID: 44, Parent: 0, Name:Chad, Code: TD
ID: 45, Parent: 0, Name:Chile, Code: CL
ID: 46, Parent: 0, Name:China, Code: CN
ID: 47, Parent: 0, Name:Christmas Island, Code: CX
ID: 48, Parent: 0, Name:Cocos (Keeling) Islands, Code: CC
ID: 49, Parent: 0, Name:Colombia, Code: CO
ID: 50, Parent: 0, Name:Comoros, Code: KM
ID: 51, Parent: 0, Name:Congo, Code: CG
ID: 52, Parent: 0, Name:Cook Islands, Code: CK
ID: 53, Parent: 0, Name:Costa Rica, Code: CR
ID: 54, Parent: 0, Name:Cote D'Ivoire (Ivory Coast), Code: CI
ID: 55, Parent: 0, Name:Croatia (Hrvatska), Code: HR
ID: 56, Parent: 0, Name:Cuba, Code: CU
ID: 57, Parent: 0, Name:Cyprus, Code: CY
ID: 58, Parent: 0, Name:Czech Republic, Code: CZ
ID: 59, Parent: 0, Name:Czechoslovakia (former), Code: CS
ID: 60, Parent: 0, Name:Denmark, Code: DK
ID: 61, Parent: 0, Name:Djibouti, Code: DJ
ID: 62, Parent: 0, Name:Dominica, Code: DM
ID: 63, Parent: 0, Name:Dominican Republic, Code: DO
ID: 64, Parent: 0, Name:East Timor, Code: TP
ID: 65, Parent: 0, Name:Ecuador, Code: EC
ID: 66, Parent: 0, Name:Egypt, Code: EG
ID: 67, Parent: 0, Name:El Salvador, Code: SV
ID: 68, Parent: 0, Name:Equatorial Guinea, Code: GQ
ID: 69, Parent: 0, Name:Eritrea, Code: ER
ID: 70, Parent: 0, Name:Estonia, Code: EE
ID: 71, Parent: 0, Name:Ethiopia, Code: ET
ID: 72, Parent: 0, Name:Falkland Islands (Malvinas), Code: FK
ID: 73, Parent: 0, Name:Faroe Islands, Code: FO
ID: 74, Parent: 0, Name:Fiji, Code: FJ
ID: 75, Parent: 0, Name:Finland, Code: FI
ID: 76, Parent: 0, Name:France, Code: FR
ID: 77, Parent: 0, Name:France, Metropolitan, Code: FX
ID: 78, Parent: 0, Name:French Guiana, Code: GF
ID: 79, Parent: 0, Name:French Polynesia, Code: PF
ID: 80, Parent: 0, Name:French Southern Territories, Code: TF
ID: 81, Parent: 0, Name:Gabon, Code: GA
ID: 82, Parent: 0, Name:Gambia, Code: GM
ID: 83, Parent: 0, Name:Germany, Code: DE
ID: 84, Parent: 0, Name:Ghana, Code: GH
ID: 85, Parent: 0, Name:Gibraltar, Code: GI
ID: 86, Parent: 0, Name:Great Britain (UK), Code: GB
ID: 87, Parent: 0, Name:Greece, Code: GR
ID: 88, Parent: 0, Name:Greenland, Code: GL
ID: 89, Parent: 0, Name:Grenada, Code: GD
ID: 90, Parent: 0, Name:Guadeloupe, Code: GP
ID: 91, Parent: 0, Name:Guam, Code: GU
ID: 92, Parent: 0, Name:Guatemala, Code: GT
ID: 93, Parent: 0, Name:Guinea, Code: GN
ID: 94, Parent: 0, Name:Guinea-Bissau, Code: GW
ID: 95, Parent: 0, Name:Guyana, Code: GY
ID: 96, Parent: 0, Name:Haiti, Code: HT
ID: 97, Parent: 0, Name:Heard McDonald Islands, Code: HM
ID: 98, Parent: 0, Name:Honduras, Code: HN
ID: 99, Parent: 0, Name:Hong Kong, Code: HK
ID: 100, Parent: 0, Name:Hungary, Code: HU
ID: 101, Parent: 0, Name:Iceland, Code: IS
ID: 102, Parent: 0, Name:India, Code: IN
ID: 103, Parent: 0, Name:Indonesia, Code: ID
ID: 104, Parent: 0, Name:Iran, Code: IR
ID: 105, Parent: 0, Name:Iraq, Code: IQ
ID: 106, Parent: 0, Name:Ireland, Code: IE
ID: 107, Parent: 0, Name:Israel, Code: IL
ID: 108, Parent: 0, Name:Italy, Code: IT
ID: 109, Parent: 0, Name:Jamaica, Code: JM
ID: 110, Parent: 0, Name:Japan, Code: JP
ID: 111, Parent: 0, Name:Jordan, Code: JO
ID: 112, Parent: 0, Name:Kazakhstan, Code: KZ
ID: 113, Parent: 0, Name:Kenya, Code: KE
ID: 114, Parent: 0, Name:Kiribati, Code: KI
ID: 115, Parent: 0, Name:Korea (North), Code: KP
ID: 116, Parent: 0, Name:Korea (South), Code: KR
ID: 117, Parent: 0, Name:Kuwait, Code: KW
ID: 118, Parent: 0, Name:Kyrgyzstan, Code: KG
ID: 119, Parent: 0, Name:Laos, Code: LA
ID: 120, Parent: 0, Name:Latvia, Code: LV
ID: 121, Parent: 0, Name:Lebanon, Code: LB
ID: 122, Parent: 0, Name:Lesotho, Code: LS
ID: 123, Parent: 0, Name:Liberia, Code: LR
ID: 124, Parent: 0, Name:Libya, Code: LY
ID: 125, Parent: 0, Name:Liechtenstein, Code: LI
ID: 126, Parent: 0, Name:Lithuania, Code: LT
ID: 127, Parent: 0, Name:Luxembourg, Code: LU
ID: 128, Parent: 0, Name:Macau, Code: MO
ID: 129, Parent: 0, Name:Macedonia, Code: MK
ID: 130, Parent: 0, Name:Madagascar, Code: MG
ID: 131, Parent: 0, Name:Malawi, Code: MW
ID: 132, Parent: 0, Name:Malaysia, Code: MY
ID: 133, Parent: 0, Name:Maldives, Code: MV
ID: 134, Parent: 0, Name:Mali, Code: ML
ID: 135, Parent: 0, Name:Malta, Code: MT
ID: 136, Parent: 0, Name:Marshall Islands, Code: MH
ID: 137, Parent: 0, Name:Martinique, Code: MQ
ID: 138, Parent: 0, Name:Mauritania, Code: MR
ID: 139, Parent: 0, Name:Mauritius, Code: MU
ID: 140, Parent: 0, Name:Mayotte, Code: YT
ID: 141, Parent: 0, Name:Mexico, Code: MX
ID: 142, Parent: 0, Name:Micronesia, Code: FM
ID: 143, Parent: 0, Name:Moldova, Code: MD
ID: 144, Parent: 0, Name:Monaco, Code: MC
ID: 145, Parent: 0, Name:Mongolia, Code: MN
ID: 146, Parent: 0, Name:Montserrat, Code: MS
ID: 147, Parent: 0, Name:Morocco, Code: MA
ID: 148, Parent: 0, Name:Mozambique, Code: MZ
ID: 149, Parent: 0, Name:Myanmar, Code: MM
ID: 150, Parent: 0, Name:Namibia, Code: NA
ID: 151, Parent: 0, Name:Nauru, Code: NR
ID: 152, Parent: 0, Name:Nepal, Code: NP
ID: 153, Parent: 0, Name:Netherlands, Code: NL
ID: 154, Parent: 0, Name:Netherlands Antilles, Code: AN
ID: 155, Parent: 0, Name:Neutral Zone, Code: NT
ID: 156, Parent: 0, Name:New Caledonia, Code: NC
ID: 157, Parent: 0, Name:New Zealand (Aotearoa), Code: NZ
ID: 158, Parent: 0, Name:Nicaragua, Code: NI
ID: 159, Parent: 0, Name:Niger, Code: NE
ID: 160, Parent: 0, Name:Nigeria, Code: NG
ID: 161, Parent: 0, Name:Niue, Code: NU
ID: 162, Parent: 0, Name:Norfolk Island, Code: NF
ID: 163, Parent: 0, Name:Northern Mariana Islands, Code: MP
ID: 164, Parent: 0, Name:Norway, Code: NO
ID: 165, Parent: 0, Name:Oman, Code: OM
ID: 166, Parent: 0, Name:Pakistan, Code: PK
ID: 167, Parent: 0, Name:Palau, Code: PW
ID: 168, Parent: 0, Name:Panama, Code: PA
ID: 169, Parent: 0, Name:Papua New Guinea, Code: PG
ID: 170, Parent: 0, Name:Paraguay, Code: PY
ID: 171, Parent: 0, Name:Peru, Code: PE
ID: 172, Parent: 0, Name:Philippines, Code: PH
ID: 173, Parent: 0, Name:Pitcairn, Code: PN
ID: 174, Parent: 0, Name:Poland, Code: PL
ID: 175, Parent: 0, Name:Portugal, Code: PT
ID: 176, Parent: 0, Name:Puerto Rico, Code: PR
ID: 177, Parent: 0, Name:Qatar, Code: QA
ID: 178, Parent: 0, Name:Reunion, Code: RE
ID: 179, Parent: 0, Name:Romania, Code: RO
ID: 180, Parent: 0, Name:Russian Federation, Code: RU
ID: 181, Parent: 0, Name:Rwanda, Code: RW
ID: 182, Parent: 0, Name:S Valuergia Sandwich Isls, Code: GS
ID: 183, Parent: 0, Name:Saint Kitts Nevis, Code: KN
ID: 184, Parent: 0, Name:Saint Lucia, Code: LC
ID: 185, Parent: 0, Name:Saint Vincent the Grenadines, Code: VC
ID: 186, Parent: 0, Name:Samoa, Code: WS
ID: 187, Parent: 0, Name:San Marino, Code: SM
ID: 188, Parent: 0, Name:Sao Tome Principe, Code: ST
ID: 189, Parent: 0, Name:Saudi Arabia, Code: SA
ID: 190, Parent: 0, Name:Senegal, Code: SN
ID: 191, Parent: 0, Name:Seychelles, Code: SC
ID: 192, Parent: 0, Name:Sierra Leone, Code: SL
ID: 193, Parent: 0, Name:Singapore, Code: SG
ID: 194, Parent: 0, Name:Slovak Republic, Code: SK
ID: 195, Parent: 0, Name:Slovenia, Code: SI
ID: 196, Parent: 0, Name:Solomon Islands, Code: Sb
ID: 197, Parent: 0, Name:Somalia, Code: SO
ID: 198, Parent: 0, Name:South Africa, Code: ZA
ID: 199, Parent: 0, Name:Spain, Code: ES
ID: 200, Parent: 0, Name:Sri Lanka, Code: LK
ID: 201, Parent: 0, Name:St. Helena, Code: SH
ID: 202, Parent: 0, Name:St. Pierre Miquelon, Code: PM
ID: 203, Parent: 0, Name:Sudan, Code: SD
ID: 204, Parent: 0, Name:SuriValue, Code: SR
ID: 205, Parent: 0, Name:Svalbard Jan Mayen Isls, Code: SJ
ID: 206, Parent: 0, Name:Swaziland, Code: SZ
ID: 207, Parent: 0, Name:Sweden, Code: SE
ID: 208, Parent: 0, Name:Switzerland, Code: CH
ID: 209, Parent: 0, Name:Syria, Code: SY
ID: 210, Parent: 0, Name:Taiwan, Code: TW
ID: 211, Parent: 0, Name:Tajikistan, Code: TJ
ID: 212, Parent: 0, Name:Tanzania, Code: TZ
ID: 213, Parent: 0, Name:Thailand, Code: TH
ID: 214, Parent: 0, Name:Togo, Code: TG
ID: 215, Parent: 0, Name:Tokelau, Code: TK
ID: 216, Parent: 0, Name:Tonga, Code: TO
ID: 217, Parent: 0, Name:Trinidad Tobago, Code: TT
ID: 218, Parent: 0, Name:Tunisia, Code: TN
ID: 219, Parent: 0, Name:Turkey, Code: TR
ID: 220, Parent: 0, Name:Turkmenistan, Code: TM
ID: 221, Parent: 0, Name:Turks Caicos Islands, Code: TC
ID: 222, Parent: 0, Name:Tuvalu, Code: TV
ID: 223, Parent: 0, Name:Uganda, Code: UG
ID: 224, Parent: 0, Name:Ukraine, Code: UA
ID: 225, Parent: 0, Name:United Arab Emirates, Code: AE
ID: 226, Parent: 0, Name:Uruguay, Code: UY
ID: 227, Parent: 0, Name:US Minor Outlying Islands, Code: UM
ID: 228, Parent: 0, Name:Uzbekistan, Code: UZ
ID: 229, Parent: 0, Name:Valuergia, Code: GE
ID: 230, Parent: 0, Name:Vanuatu, Code: VU
ID: 231, Parent: 0, Name:Vatican City State (Holy City), Code: VA
ID: 232, Parent: 0, Name:Venezuela, Code: VE
ID: 233, Parent: 0, Name:Viet Nam, Code: VN
ID: 234, Parent: 0, Name:Virgin Islands (British), Code: VG
ID: 235, Parent: 0, Name:Virgin Islands (U.S.), Code: VI
ID: 236, Parent: 0, Name:Wallis Futuna Islands, Code: WF
ID: 237, Parent: 0, Name:Western Sahara, Code: EH
ID: 238, Parent: 0, Name:Yemen, Code: YE
ID: 239, Parent: 0, Name:Yugoslavia, Code: YU
ID: 240, Parent: 0, Name:Zaire, Code: ZR
ID: 241, Parent: 0, Name:Zambia, Code: ZM
ID: 242, Parent: 0, Name:Zimbabwe, Code: ZW
LocationType ID: 2, Name:Province, Source:BillAddress.StateProvince, SelectedCode:
ID: 243, Parent: 1, Name:Alabama, Code: AL
ID: 244, Parent: 1, Name:Arkansas, Code: AR
ID: 245, Parent: 1, Name:Alaska, Code: AK
ID: 246, Parent: 1, Name:Arizona, Code: AZ
ID: 247, Parent: 1, Name:California, Code: CA
ID: 248, Parent: 1, Name:Colorado, Code: CO
ID: 249, Parent: 1, Name:Connecticut, Code: CT
ID: 250, Parent: 1, Name:Delaware, Code: DE
ID: 251, Parent: 1, Name:Florida, Code: FL
ID: 252, Parent: 1, Name:Georgia, Code: GA
ID: 253, Parent: 1, Name:Hawaii, Code: HI
ID: 254, Parent: 1, Name:Idaho, Code: ID
ID: 255, Parent: 1, Name:Illinois, Code: IL
ID: 256, Parent: 1, Name:Indiana, Code: IN
ID: 257, Parent: 1, Name:IOWA, Code: IA
ID: 258, Parent: 1, Name:Kansas, Code: KS
ID: 259, Parent: 1, Name:Kentucky, Code: KY
ID: 260, Parent: 1, Name:Louisiana, Code: LA
ID: 261, Parent: 1, Name:Maine, Code: ME
ID: 262, Parent: 1, Name:Maryland, Code: MD
ID: 263, Parent: 1, Name:Massachusetts, Code: MA
ID: 264, Parent: 1, Name:Michigan, Code: MI
ID: 265, Parent: 1, Name:Minnesota, Code: MN
ID: 266, Parent: 1, Name:Mississippi, Code: MS
ID: 267, Parent: 1, Name:Missouri, Code: MO
ID: 268, Parent: 1, Name:Montana, Code: MT
ID: 269, Parent: 1, Name:Nebraska, Code: NE
ID: 270, Parent: 1, Name:Nevada, Code: NV
ID: 271, Parent: 1, Name:New Hampshire, Code: NH
ID: 272, Parent: 1, Name:New Jersey, Code: NJ
ID: 273, Parent: 1, Name:New Mexico, Code: NM
ID: 274, Parent: 1, Name:New York, Code: NY
ID: 275, Parent: 1, Name:North Carolina, Code: NC
ID: 276, Parent: 1, Name:North Dakota, Code: ND
ID: 277, Parent: 1, Name:Ohio, Code: OH
ID: 278, Parent: 1, Name:Oklahoma, Code: OK
ID: 279, Parent: 1, Name:Oregon, Code: OR
ID: 280, Parent: 1, Name:Pennsylvania, Code: PA
ID: 281, Parent: 1, Name:Rhode Island, Code: RI
ID: 282, Parent: 1, Name:South Carolina, Code: SC
ID: 283, Parent: 1, Name:South Dakota, Code: SD
ID: 284, Parent: 1, Name:Tennessee, Code: TN
ID: 285, Parent: 1, Name:Texas, Code: TX
ID: 286, Parent: 1, Name:Utah, Code: UT
ID: 287, Parent: 1, Name:Vermont, Code: VT
ID: 288, Parent: 1, Name:Virginia, Code: VA
ID: 289, Parent: 1, Name:Washington, Code: WA
ID: 290, Parent: 1, Name:Washington D.C., Code: DC
ID: 291, Parent: 1, Name:West Virginia, Code: WV
ID: 292, Parent: 1, Name:Wisconsin, Code: WI
ID: 293, Parent: 1, Name:Wyoming, Code: WY
ID: 294, Parent: 1, Name:Americas (AA), Code: AA
ID: 295, Parent: 1, Name:Europe (AE), Code: AE
ID: 296, Parent: 1, Name:Pacific (AP), Code: AP
ID: 297, Parent: 1, Name:American Samoa, Code: AS
ID: 298, Parent: 1, Name:Fed. Micronesia, Code: FM
ID: 299, Parent: 1, Name:Guam, Code: GU
ID: 300, Parent: 1, Name:Marshall Island, Code: MH
ID: 301, Parent: 1, Name:N. Mariana Is., Code: MP
ID: 302, Parent: 1, Name:Palau Island, Code: PW
ID: 303, Parent: 1, Name:Puerto Rico, Code: PR
ID: 304, Parent: 1, Name:Virgin Islands, Code: VI

Load only Canada's provinces:
LocationType ID: 2, Name:Province, Source:BillAddress.StateProvince, SelectedCode:
ID: 305, Parent: 2, Name:Alberta, Code: AB
ID: 306, Parent: 2, Name:British Columbia, Code: BC
ID: 307, Parent: 2, Name:Manitoba, Code: MB
ID: 308, Parent: 2, Name:New Brunswick, Code: NB
ID: 309, Parent: 2, Name:Newfoundland, Code: NF
ID: 310, Parent: 2, Name:Northwest Territories, Code: NT
ID: 311, Parent: 2, Name:Nova Scotia, Code: NS
ID: 312, Parent: 2, Name:Nunavut, Code: NU
ID: 313, Parent: 2, Name:Ontario, Code: ON
ID: 314, Parent: 2, Name:Prince Edward Island, Code: PE
ID: 315, Parent: 2, Name:Quebec, Code: QC
ID: 316, Parent: 2, Name:Saskatchewan, Code: SK
ID: 317, Parent: 2, Name:Yukon Territory, Code: YT