Class CountryTableInfo

Table 'country': Country information

Inheritance
Object
TableInfo
CountryTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("country")]
public class CountryTableInfo : TableInfo, ICloneable
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Fields

DictionaryTableName

Conceptual name of table Country in the database dictionary: country

Declaration
public const string DictionaryTableName = "country"
Field Value
Type Description
String

Properties

Abbrev2

Field 'abbrev2' in table 'country': Dictionary type String[3], .NET type: String

ISO 2-letter abbreviation

Declaration
public StringFieldInfo Abbrev2 { get; }
Property Value
Type Description
StringFieldInfo

Abbrev3

Field 'abbrev3' in table 'country': Dictionary type String[4], .NET type: String

ISO 3-letter abbreviation

Declaration
public StringFieldInfo Abbrev3 { get; }
Property Value
Type Description
StringFieldInfo

AddressLayout

Field 'addressLayout' in table 'country': Dictionary type Id, .NET type: Int32

Points to address format used in the GUI

Declaration
public Int32FieldInfo AddressLayout { get; }
Property Value
Type Description
Int32FieldInfo

AddressLayoutDomestic

Field 'addressLayoutDomestic' in table 'country': Dictionary type Id, .NET type: Int32

Points to address format used for labels to own country

Declaration
public Int32FieldInfo AddressLayoutDomestic { get; }
Property Value
Type Description
Int32FieldInfo

AddressLayoutForeign

Field 'addressLayoutForeign' in table 'country': Dictionary type Id, .NET type: Int32

Points to address format used for labels to other countries than own country

Declaration
public Int32FieldInfo AddressLayoutForeign { get; }
Property Value
Type Description
Int32FieldInfo

CountryId

Field 'country_id' in table 'country': Dictionary type PK, .NET type: Int32

Primary key

Declaration
public Int32FieldInfo CountryId { get; }
Property Value
Type Description
Int32FieldInfo

CurrencyId

Field 'currency_id' in table 'country': Dictionary type FK, .NET type: Int32

Default currency for this country

Declaration
public Int32FieldInfo CurrencyId { get; }
Property Value
Type Description
Int32FieldInfo

CurrencyId_InnerJoin_Currency

Generated join from the foreign key CurrencyId in this table, to its target table CurrencyTableInfo.

Declaration
public TargetedInnerJoin<CurrencyTableInfo> CurrencyId_InnerJoin_Currency { get; }
Property Value
Type Description
TargetedInnerJoin<CurrencyTableInfo>

CustomPhoneDesc

Field 'customPhoneDesc' in table 'country': Dictionary type String[255], .NET type: String

Custom phone description, if any (comes from ISO/ITU documents)

Declaration
public StringFieldInfo CustomPhoneDesc { get; }
Property Value
Type Description
StringFieldInfo

DefaultLcid

Field 'defaultLcid' in table 'country': Dictionary type UInt, .NET type: UInt32

LCID code in .NET, this should be the defaultLcid of the language that has the isDefault flag set in the LanguageInforCountry link table

Declaration
public FieldInfo DefaultLcid { get; }
Property Value
Type Description
FieldInfo

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides

Deleted

Field 'deleted' in table 'country': Dictionary type UShort, .NET type: Int16

0 -> record is active 1 -> record is 'deleted' and should not be shown in lists

Declaration
public UInt16FieldInfo Deleted { get; }
Property Value
Type Description
UInt16FieldInfo

DialInPrefix

Field 'dialInPrefix' in table 'country': Dictionary type String[32], .NET type: String

Prefix for dialing into the country from outside (country code)

Declaration
public StringFieldInfo DialInPrefix { get; }
Property Value
Type Description
StringFieldInfo

DialOutPrefix

Field 'dialOutPrefix' in table 'country': Dictionary type String[32], .NET type: String

Prefix for dialling out of the country, voice call

Declaration
public StringFieldInfo DialOutPrefix { get; }
Property Value
Type Description
StringFieldInfo

DictionaryTableNumber

Table number for table Country in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database

Declaration
public int DictionaryTableNumber { get; }
Property Value
Type Description
Int32

DomainName

Field 'domainName' in table 'country': Dictionary type String[10], .NET type: String

Default Web domain identifier (.no, .uk, etc; but without the dot)

Declaration
public StringFieldInfo DomainName { get; }
Property Value
Type Description
StringFieldInfo

EnglishName

Field 'english_name' in table 'country': Dictionary type String[40], .NET type: String

Name of country in english

Declaration
public StringFieldInfo EnglishName { get; }
Property Value
Type Description
StringFieldInfo

FlagresId

Field 'flagres_id' in table 'country': Dictionary type UInt, .NET type: UInt32

Resource ID of flag graphic

Declaration
public FieldInfo FlagresId { get; }
Property Value
Type Description
FieldInfo

InterAreaPrefix

Field 'interAreaPrefix' in table 'country': Dictionary type String[32], .NET type: String

Prefix for inter-area dialling in the country

Declaration
public StringFieldInfo InterAreaPrefix { get; }
Property Value
Type Description
StringFieldInfo

IsBuiltIn

Field 'isBuiltIn' in table 'country': Dictionary type Bool, .NET type: Int16

Is this record populated by SuperOffice priming data?

Declaration
public UInt16FieldInfo IsBuiltIn { get; }
Property Value
Type Description
UInt16FieldInfo

IsoNumber

Field 'isoNumber' in table 'country': Dictionary type UInt, .NET type: UInt32

The primary key used by ISO to identify countries when they have a revolution and change their name from Upper Volta to Burkina Faso :-)

Declaration
public FieldInfo IsoNumber { get; }
Property Value
Type Description
FieldInfo

LeftOuterJoin_Contact_CountryId

Generated left outer join from the primary key CountryId on this table, to Contact.CountryId.

Declaration
public TargetedLeftOuterJoin<ContactTableInfo> LeftOuterJoin_Contact_CountryId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ContactTableInfo>

Generated left outer join from the primary key CountryId on this table, to CountryGroupLink.CountryId.

Declaration
public TargetedLeftOuterJoin<CountryGroupLinkTableInfo> LeftOuterJoin_CountryGroupLink_CountryId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<CountryGroupLinkTableInfo>

Generated left outer join from the primary key CountryId on this table, to CountryHeadingLink.CountryId.

Declaration
public TargetedLeftOuterJoin<CountryHeadingLinkTableInfo> LeftOuterJoin_CountryHeadingLink_CountryId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<CountryHeadingLinkTableInfo>

LeftOuterJoin_LanguageInfoCountry_CountryId

Generated left outer join from the primary key CountryId on this table, to LanguageInfoCountry.CountryId.

Declaration
public TargetedLeftOuterJoin<LanguageInfoCountryTableInfo> LeftOuterJoin_LanguageInfoCountry_CountryId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<LanguageInfoCountryTableInfo>

LeftOuterJoin_Person_CountryId

Generated left outer join from the primary key CountryId on this table, to Person.CountryId.

Declaration
public TargetedLeftOuterJoin<PersonTableInfo> LeftOuterJoin_Person_CountryId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<PersonTableInfo>

LeftOuterJoin_PhoneFormat_CountryId

Generated left outer join from the primary key CountryId on this table, to PhoneFormat.CountryId.

Declaration
public TargetedLeftOuterJoin<PhoneFormatTableInfo> LeftOuterJoin_PhoneFormat_CountryId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<PhoneFormatTableInfo>

LeftOuterJoin_QuoteVersion_DeliveryCountryId

Generated left outer join from the primary key CountryId on this table, to QuoteVersion.DeliveryCountryId.

Declaration
public TargetedLeftOuterJoin<QuoteVersionTableInfo> LeftOuterJoin_QuoteVersion_DeliveryCountryId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<QuoteVersionTableInfo>

LeftOuterJoin_QuoteVersion_InvoiceCountryId

Generated left outer join from the primary key CountryId on this table, to QuoteVersion.InvoiceCountryId.

Declaration
public TargetedLeftOuterJoin<QuoteVersionTableInfo> LeftOuterJoin_QuoteVersion_InvoiceCountryId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<QuoteVersionTableInfo>

LeftOuterJoin_RedLetterDay_CountryId

Generated left outer join from the primary key CountryId on this table, to RedLetterDay.CountryId.

Declaration
public TargetedLeftOuterJoin<RedLetterDayTableInfo> LeftOuterJoin_RedLetterDay_CountryId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<RedLetterDayTableInfo>

LeftOuterJoin_TZLocation_CountryId

Generated left outer join from the primary key CountryId on this table, to TZLocation.CountryId.

Declaration
public TargetedLeftOuterJoin<TZLocationTableInfo> LeftOuterJoin_TZLocation_CountryId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<TZLocationTableInfo>

LeftOuterJoin_ZipToCity_CountryId

Generated left outer join from the primary key CountryId on this table, to ZipToCity.CountryId.

Declaration
public TargetedLeftOuterJoin<ZipToCityTableInfo> LeftOuterJoin_ZipToCity_CountryId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ZipToCityTableInfo>

Name

Field 'name' in table 'country': Dictionary type String[240], .NET type: String

Name of country in installed language

Declaration
public StringFieldInfo Name { get; }
Property Value
Type Description
StringFieldInfo

OrgNrText

Field 'orgNrText' in table 'country': Dictionary type String[255], .NET type: String

Lead text for organisation field

Declaration
public StringFieldInfo OrgNrText { get; }
Property Value
Type Description
StringFieldInfo

PhonePartOfNA

Field 'phonePartOfNA' in table 'country': Dictionary type Bool, .NET type: Int16

Is the phone system part of the North American system

Declaration
public UInt16FieldInfo PhonePartOfNA { get; }
Property Value
Type Description
UInt16FieldInfo

Rank

Field 'rank' in table 'country': Dictionary type UShort, .NET type: Int16

Rank order

Declaration
public UInt16FieldInfo Rank { get; }
Property Value
Type Description
UInt16FieldInfo

Registered

Field 'registered' in table 'country': Dictionary type UtcDateTime, .NET type: DateTime

Registered when

Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type Description
DateTimeFieldInfo

RegisteredAssociateId

Field 'registered_associate_id' in table 'country': Dictionary type FK, .NET type: Int32

Registered by whom

Declaration
public Int32FieldInfo RegisteredAssociateId { get; }
Property Value
Type Description
Int32FieldInfo

RegisteredAssociateId_InnerJoin_Associate

Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration
[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }
Property Value
Type Description
SoTable

Tooltip

Field 'tooltip' in table 'country': Dictionary type String[255], .NET type: String

Tooltip or other description

Declaration
public StringFieldInfo Tooltip { get; }
Property Value
Type Description
StringFieldInfo

TzLocationId

Field 'tzLocationId' in table 'country': Dictionary type FK, .NET type: Int32

Default timezone location for this country

Declaration
public Int32FieldInfo TzLocationId { get; }
Property Value
Type Description
Int32FieldInfo

TzLocationId_InnerJoin_TZLocation

Generated join from the foreign key TzLocationId in this table, to its target table TZLocationTableInfo.

Declaration
public TargetedInnerJoin<TZLocationTableInfo> TzLocationId_InnerJoin_TZLocation { get; }
Property Value
Type Description
TargetedInnerJoin<TZLocationTableInfo>

Updated

Field 'updated' in table 'country': Dictionary type UtcDateTime, .NET type: DateTime

Last updated when

Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type Description
DateTimeFieldInfo

UpdatedAssociateId

Field 'updated_associate_id' in table 'country': Dictionary type FK, .NET type: Int32

Last updated by whom

Declaration
public Int32FieldInfo UpdatedAssociateId { get; }
Property Value
Type Description
Int32FieldInfo

UpdatedAssociateId_InnerJoin_Associate

Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

UpdatedCount

Field 'updatedCount' in table 'country': Dictionary type UShort, .NET type: Int16

Number of updates made to this record

Declaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type Description
UInt16FieldInfo

ZipPrefix

Field 'zip_prefix' in table 'country': Dictionary type String[6], .NET type: String

N- DK- etc.

Declaration
public StringFieldInfo ZipPrefix { get; }
Property Value
Type Description
StringFieldInfo

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)