country Table (19)

country MDO list item table. Country information

Fields

NameDescriptionTypeNull
country_idPrimary keyPK
nameName of country in installed languageString(239)
rankRank orderUShort
tooltipTooltip or other descriptionString(254)
deleted0 -> record is active 1 -> record is ‘deleted’ and should not be shown in listsUShort
english_nameName of country in englishString(39)
zip_prefixN- DK- etc.String(5)
flagres_idResource ID of flag graphicUInt
addressLayoutPoints to address format used in the GUIId
addressLayoutDomesticPoints to address format used for labels to own countryId
addressLayoutForeignPoints to address format used for labels to other countries than own countryId
currency_idDefault currency for this countryFK Currency
orgNrTextLead text for organisation fieldString(254)
domainNameDefault Web domain identifier (.no, .uk, etc; but without the dot)String(9)
registeredRegistered whenUtcDateTime
registered_associate_idRegistered by whomFK associate
updatedLast updated whenUtcDateTime
updated_associate_idLast updated by whomFK associate
updatedCountNumber of updates made to this recordUShort
defaultLcidLCID code in .NET, this should be the defaultLcid of the language that has the isDefault flag set in the LanguageInforCountry link tableUInt
dialInPrefixPrefix for dialing into the country from outside (country code)String(31)
dialOutPrefixPrefix for dialling out of the country, voice callString(31)
interAreaPrefixPrefix for inter-area dialling in the countryString(31)
customPhoneDescCustom phone description, if any (comes from ISO/ITU documents)String(254)
phonePartOfNAIs the phone system part of the North American systemBool
isBuiltInIs this record populated by SuperOffice priming data?Bool
isoNumberThe primary key used by ISO to identify countries when they have a revolution and change their name from Upper Volta to Burkina Faso :-)UInt
abbrev3ISO 3-letter abbreviationString(3)
abbrev2ISO 2-letter abbreviationString(2)
tzLocationIdDefault timezone location for this countryFK TZLocation

country table relationship diagram

Indexes

FieldsTypesDescription
country_idPKClustered, Unique
nameString(239)Unique
english_nameString(39)Index

Relationships

TableDescription
associateEmployees, resources and other users - except for External persons
contactCompanies and Organizations.
CountryGroupLinkUser group link table for Country, for MDO item hiding
CountryHeadingLinkHeading link table for Country, for MDO headers
CurrencyCurrency list table
LanguageInfoCountryMany-many link between countries and languages, to give intelligent choices for language
personPersons
PhoneFormatFormatting information for telephone numbers
QuoteVersionThere may be multiple Versions of a Quote, with one of them active
redletterdayRed letter days for calendar (holidays, birthday of king etc)
TZLocationTime zone location
ziptocityZip codes and city names. Zip codes used during address entry. You will find more information about addressformat on http://techdoc.superoffice.com

Replication Flags

  • Replicate changes DOWN from central to satellites and travellers.
  • Copy to satellite and travel prototypes.

Security Flags

  • No access control via user’s Role.