RegionCodes Table
The RegionCodes table in the transaction configuration database defines the region codes that are used by the Commerce Server Core Systems application.
The following table describes the columns in the RegionCodes table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
Type |
int |
no |
The level of the region in a hierarchy. For example, a country has type 1, and a state within the country has type 2. |
Code |
nvarchar(64) |
yes |
The code for the region. |
Group |
nvarchar(64) |
yes |
If the region code represents a state, the value in the Group column is the code of the country that contains the state. |
Name |
nvarchar(64) |
yes |
The full name of the region. |
Description |
nvarchar(256) |
yes |
A description of the region. |
ModifiedBy |
nvarchar(128) |
yes |
The user ID of the person who last modified the region code. |
LastModified |
datetime |
no |
The date the region code was last modified. |
Created |
datetime |
no |
The date the region code was created. |