Description: Defines acceptable country entries used by the system and application
| Column Name |
Ordinal Position |
|
| Column Name |
Ordinal Position |
Referenced Table |
|
|
Name |
Type |
|
| 1 |
LKCOUNTRYID |
INT |
|
|
Description: The unique Id for the LkCountry table
|
|
Name |
Type |
|
| 2 |
CODE |
NCHAR |
|
|
Description: Country Code
|
|
Name |
Type |
|
| 3 |
COUNTRY |
NVARCHAR |
|
|
Description: Text name of the country
|
|
Name |
Type |
|
| 4 |
COUNTRYABBR |
NVARCHAR |
|
|
Description: Text abbreviation of the country name
|
|
Name |
Type |
|
| 5 |
ZIPFORMAT |
NVARCHAR |
|
|
Description: Formatting mask for the postal code in the country
|
|
Name |
Type |
|
| 6 |
STARTDATE |
DATE |
|
|
Description: Date to start using this record for new entries
|
|
Name |
Type |
|
| 7 |
ENDDATE |
DATE |
|
|
Description: Date to stop using this record for new entries
|
|
Name |
Type |
|
| 8 |
ISO2 |
NCHAR |
|
|
Description: Iso 2-letter code for the country
|
|
Name |
Type |
|
| 9 |
ISO3 |
NVARCHAR |
|
|
Description: Iso 3-letter code for the country
|
|
Name |
Type |
|
| 10 |
NUMERICCODE |
NVARCHAR |
|
|
Description: Iso numeric code for the country
|