Contains definitions of countries.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
DESCRIPTION
|
nvarchar(100)
|
false
|
|
Stores the description of the country
|
|
ABBREVIATION
|
nvarchar(5)
|
false
|
|
Stores the abbreviation of the country
|
|
ACTIVE
|
bit
|
false
|
|
Indicates whether or not the country is active
|
|
SEQUENCE
|
int
|
false
|
|
Stores the user-defined sequence for the country
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
USEFORCOAUPDATE
|
bit
|
false
|
|
Indicates which country is to be used for the change of address udpate process.
|
|
PHONEFORMATCODE
|
tinyint
|
false
|
|
Stores the phone format code for the country.
|
|
COUNTRYCODE
|
nvarchar(10)
|
false
|
|
Stores the telephone country code for calling this country.
|
|
ISO3166
|
nvarchar(2)
|
false
|
|
Stores the ISO3166 code for the country.
|
