---
title: "Countries and States Tables"
canonical: "https://help.agiloft.com/space/SDA2603/521280348/Countries+and+States+Tables"
format: markdown
---
<span style="color: #000000">The Countries and States tables are two very similar tables used to store country and state records.</span>

<span style="color: #000000">Country records are used to store a country's full name, as well as their respective ISO2 code (2-letter abbreviation) and ISO3 code (3-letter abbreviation). The out-of-the-box table contains a full list of Agiloft-compatible countries along with their codes. State records are used to store state's full name, state abbreviation, and the country of origin. The out-of-the-box table holds records for the 50 United States and each of the Canadian provinces.</span>

## Use Case

<span style="color: #000000">Both Country and State records can be created by members of the Admin, Admin Import, and Business Admin groups. Links to these tables are used in a variety of places in the out-of-the-box system, such as Locations, Opportunities, Companies, People, Quotes, and Contracts tables. </span>

<span style="color: #000000">These links allow you to modify the information in the State and Country tables to fit your ideal presentation style. For example, an address of a company's headquarters can be shown as United States, CA in the Location record, and as USA, California in a Contract record without changing the stored information manually. Any required formatting can be chosen and quickly changed if needed, without manually editing records.</span>

<span style="color: #000000">Another use for Countries and States tables is creating easily maintainable lists for users to choose from. This helps to avoid typos, inconsistencies, and other potential errors.</span>

<span style="color: #000000">Country and State records can be created directly from their corresponding tables or imported from an Excel spreadsheet. Import can be useful when a large number of new records need to be added. For example, a good time to use import would be when you need to add a list of states or provinces for a country that is not already included in the out-of-the-box system.</span>

## Ownership

<span style="color: #000000">Both Country and State records are owned by the user who creates them. Specifically, a record is owned by the user whose Login matches the Creator Login field.</span>