country_id | Primary key | PK | |
name | Name of country in installed language | String(239) | |
rank | Rank order | UShort | ● |
tooltip | Tooltip or other description | String(254) | ● |
deleted | 0 -> record is active 1 -> record is ‘deleted’ and should not be shown in lists | UShort | ● |
english_name | Name of country in english | String(39) | ● |
zip_prefix | N- DK- etc. | String(5) | ● |
flagres_id | Resource ID of flag graphic | UInt | ● |
addressLayout | Points to address format used in the GUI | Id | |
addressLayoutDomestic | Points to address format used for labels to own country | Id | |
addressLayoutForeign | Points to address format used for labels to other countries than own country | Id | |
currency_id | Default currency for this country | FK Currency | ● |
orgNrText | Lead text for organisation field | String(254) | ● |
domainName | Default Web domain identifier (.no, .uk, etc; but without the dot) | String(9) | ● |
registered | Registered when | UtcDateTime | |
registered_associate_id | Registered by whom | FK associate | |
updated | Last updated when | UtcDateTime | |
updated_associate_id | Last updated by whom | FK associate | |
updatedCount | Number of updates made to this record | UShort | |
defaultLcid | LCID code in .NET, this should be the defaultLcid of the language that has the isDefault flag set in the LanguageInforCountry link table | UInt | ● |
dialInPrefix | Prefix for dialing into the country from outside (country code) | String(31) | ● |
dialOutPrefix | Prefix for dialling out of the country, voice call | String(31) | ● |
interAreaPrefix | Prefix for inter-area dialling in the country | String(31) | ● |
customPhoneDesc | Custom phone description, if any (comes from ISO/ITU documents) | String(254) | ● |
phonePartOfNA | Is the phone system part of the North American system | Bool | ● |
isBuiltIn | Is this record populated by SuperOffice priming data? | Bool | ● |
isoNumber | The primary key used by ISO to identify countries when they have a revolution and change their name from Upper Volta to Burkina Faso :-) | UInt | ● |
abbrev3 | ISO 3-letter abbreviation | String(3) | ● |
abbrev2 | ISO 2-letter abbreviation | String(2) | ● |
tzLocationId | Default timezone location for this country | FK TZLocation | ● |