Class CountryTableInfo
Table 'country': Country information
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 |
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
Properties
Abbrev2
Field 'abbrev2' in table 'country': Dictionary type String[3], .NET type: String
ISO 2-letter abbreviationDeclaration
public StringFieldInfo Abbrev2 { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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
Abbrev3
Field 'abbrev3' in table 'country': Dictionary type String[4], .NET type: String
ISO 3-letter abbreviationDeclaration
public StringFieldInfo Abbrev3 { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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
AddressLayout
Field 'addressLayout' in table 'country': Dictionary type Id, .NET type: Int32
Points to address format used in the GUIDeclaration
public Int32FieldInfo AddressLayout { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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
AddressLayoutDomestic
Field 'addressLayoutDomestic' in table 'country': Dictionary type Id, .NET type: Int32
Points to address format used for labels to own countryDeclaration
public Int32FieldInfo AddressLayoutDomestic { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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
AddressLayoutForeign
Field 'addressLayoutForeign' in table 'country': Dictionary type Id, .NET type: Int32
Points to address format used for labels to other countries than own countryDeclaration
public Int32FieldInfo AddressLayoutForeign { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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
CountryId
Field 'country_id' in table 'country': Dictionary type PK, .NET type: Int32
Primary keyDeclaration
public Int32FieldInfo CountryId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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
CurrencyId
Field 'currency_id' in table 'country': Dictionary type FK, target: Currency, .NET type: Int32
Default currency for this countryDeclaration
public Int32FieldInfo CurrencyId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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
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> |
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
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 |
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
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 tableDeclaration
public FieldInfo DefaultLcid { get; }
Property Value
Type | Description |
---|---|
FieldInfo |
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
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Overrides
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
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 listsDeclaration
public UInt16FieldInfo Deleted { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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
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 |
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
DialOutPrefix
Field 'dialOutPrefix' in table 'country': Dictionary type String[32], .NET type: String
Prefix for dialling out of the country, voice callDeclaration
public StringFieldInfo DialOutPrefix { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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
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 |
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
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 |
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
EnglishName
Field 'english_name' in table 'country': Dictionary type String[40], .NET type: String
Name of country in englishDeclaration
public StringFieldInfo EnglishName { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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
FlagresId
Field 'flagres_id' in table 'country': Dictionary type UInt, .NET type: UInt32
Resource ID of flag graphicDeclaration
public FieldInfo FlagresId { get; }
Property Value
Type | Description |
---|---|
FieldInfo |
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
InterAreaPrefix
Field 'interAreaPrefix' in table 'country': Dictionary type String[32], .NET type: String
Prefix for inter-area dialling in the countryDeclaration
public StringFieldInfo InterAreaPrefix { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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
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 |
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
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 |
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
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> |
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
LeftOuterJoin_CountryGroupLink_CountryId
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> |
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
LeftOuterJoin_CountryHeadingLink_CountryId
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> |
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
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> |
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
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> |
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
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> |
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
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> |
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
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> |
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
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> |
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
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> |
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
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> |
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
Name
Field 'name' in table 'country': Dictionary type String[240], .NET type: String
Name of country in installed languageDeclaration
public StringFieldInfo Name { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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
OrgNrText
Field 'orgNrText' in table 'country': Dictionary type String[255], .NET type: String
Lead text for organisation fieldDeclaration
public StringFieldInfo OrgNrText { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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
PhonePartOfNA
Field 'phonePartOfNA' in table 'country': Dictionary type Bool, .NET type: Int16
Is the phone system part of the North American systemDeclaration
public UInt16FieldInfo PhonePartOfNA { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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
Rank
Field 'rank' in table 'country': Dictionary type UShort, .NET type: Int16
Rank orderDeclaration
public UInt16FieldInfo Rank { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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
Registered
Field 'registered' in table 'country': Dictionary type UtcDateTime, .NET type: DateTime
Registered whenDeclaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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
RegisteredAssociateId
Field 'registered_associate_id' in table 'country': Dictionary type FK, target: Associate, .NET type: Int32
Registered by whomDeclaration
public Int32FieldInfo RegisteredAssociateId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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
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> |
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
RuntimeDefinition
Definition of the table as described in the deployed runtime dictionary
Declaration
public static SoTable RuntimeDefinition { get; }
Property Value
Type | Description |
---|---|
SoTable |
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
Tooltip
Field 'tooltip' in table 'country': Dictionary type String[255], .NET type: String
Tooltip or other descriptionDeclaration
public StringFieldInfo Tooltip { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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
TzLocationId
Field 'tzLocationId' in table 'country': Dictionary type FK, target: TZLocation, .NET type: Int32
Default timezone location for this countryDeclaration
public Int32FieldInfo TzLocationId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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
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> |
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
Updated
Field 'updated' in table 'country': Dictionary type UtcDateTime, .NET type: DateTime
Last updated whenDeclaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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
UpdatedAssociateId
Field 'updated_associate_id' in table 'country': Dictionary type FK, target: Associate, .NET type: Int32
Last updated by whomDeclaration
public Int32FieldInfo UpdatedAssociateId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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
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> |
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
UpdatedCount
Field 'updatedCount' in table 'country': Dictionary type UShort, .NET type: Int16
Number of updates made to this recordDeclaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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
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 |
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