• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

country Table (19)

Some tooltip text!
• 4 minutes to read
 • 4 minutes to read

country MDO list item table. Country information

Fields

Name Description Type Null
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 ●

country table relationship diagram

Indexes

Fields Types Description
country_id PK Clustered, Unique
name String(239) Unique
english_name String(39) Index

Relationships

Table Description
associate Employees, resources and other users - except for External persons
contact Companies and Organizations. This table features a special record containing information about the contact that owns the database.
CountryGroupLink User group link table for Country, for MDO item hiding
CountryHeadingLink Heading link table for Country, for MDO headers
Currency Currency list table
LanguageInfoCountry Many-many link between countries and languages, to give intelligent choices for language
person Persons in a company or an organizations. All associates have a corresponding person record
PhoneFormat Formatting information for telephone numbers
QuoteVersion There may be multiple Versions of a Quote, with one of them active
redletterday Red letter days for calendar (holidays, birthday of king etc)
TZLocation Time zone location
ziptocity Zip 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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top