Class TZLocationTableInfo

Table 'TZLocation': Time zone location

Inheritance

object

TableInfo

TZLocationTableInfo

Implements

ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(params FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(string)

TableInfo.ProtAll

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.this[string]

TableInfo.PrimaryKeyField

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

[DatabaseTable("TZLocation")]
public class TZLocationTableInfo : 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 TablesInfo.GetTZLocationInfo().

Fields

DictionaryTableName

Conceptual name of table TZLocation in the database dictionary: TZLocation

Declaration

public const string DictionaryTableName = "TZLocation"

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 TablesInfo.GetTZLocationInfo().

Properties

Cities

Field 'cities' in table 'TZLocation': Dictionary type String[2048], .NET type: string

Cities, comma-separated list. Future localization via localeText resource type 32

Declaration

public StringFieldInfo Cities { 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 TablesInfo.GetTZLocationInfo().

CountryId

Field 'countryId' in table 'TZLocation': Dictionary type FK, target: Country, .NET type: int

Country that this timezone location is defined for

Declaration

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 TablesInfo.GetTZLocationInfo().

CountryId_InnerJoin_Country

Generated join from the foreign key CountryId in this table, to its target table CountryTableInfo.

Declaration

public TargetedInnerJoin<CountryTableInfo> CountryId_InnerJoin_Country { get; }

Property Value

Type	Description
TargetedInnerJoin<CountryTableInfo>

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 TablesInfo.GetTZLocationInfo().

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration

public override SoTable Definition { get; }

Property Value

Type	Description
SoTable

Overrides

TableInfo.Definition

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 TablesInfo.GetTZLocationInfo().

Deleted

Field 'isDeleted' in table 'TZLocation': Dictionary type Bool, .NET type: short

Is this row 'deleted' (invisible in lists)

Declaration

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 TablesInfo.GetTZLocationInfo().

Description

Field 'description' in table 'TZLocation': Dictionary type String[255], .NET type: string

Dcescription, only visible in Admin contexts

Declaration

public StringFieldInfo Description { 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 TablesInfo.GetTZLocationInfo().

DictionaryTableNumber

Table number for table TZLocation 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
int

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 TablesInfo.GetTZLocationInfo().

GroupName

Field 'groupName' in table 'TZLocation': Dictionary type String[255], .NET type: string

Group (heading) name for timezone locations that do not have a country (such as the EU zones)

Declaration

public StringFieldInfo GroupName { 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 TablesInfo.GetTZLocationInfo().

IsActive

Field 'isActive' in table 'TZLocation': Dictionary type Bool, .NET type: short

Is this field visible in the standard drop-down list in the GUI? If no, it can still be used and searched for, but won't be visible directly in the dropdown list.

Declaration

public UInt16FieldInfo IsActive { 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 TablesInfo.GetTZLocationInfo().

IsBuiltIn

Field 'isBuiltIn' in table 'TZLocation': Dictionary type Bool, .NET type: short

Is this row part of 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 TablesInfo.GetTZLocationInfo().

LeftOuterJoin_Appointment_PreferredTZLocation

Generated left outer join from the primary key TZLocationId on this table, to Appointment.PreferredTZLocation.

Declaration

public TargetedLeftOuterJoin<AppointmentTableInfo> LeftOuterJoin_Appointment_PreferredTZLocation { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<AppointmentTableInfo>

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 TablesInfo.GetTZLocationInfo().

LeftOuterJoin_Associate_TzLocationId

Generated left outer join from the primary key TZLocationId on this table, to Associate.TzLocationId.

Declaration

public TargetedLeftOuterJoin<AssociateTableInfo> LeftOuterJoin_Associate_TzLocationId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<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 TablesInfo.GetTZLocationInfo().

LeftOuterJoin_BaseTZLocation_TZLocationId

Generated left outer join from the primary key TZLocationId on this table, to BaseTZLocation.TZLocationId.

Declaration

public TargetedLeftOuterJoin<BaseTZLocationTableInfo> LeftOuterJoin_BaseTZLocation_TZLocationId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<BaseTZLocationTableInfo>

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 TablesInfo.GetTZLocationInfo().

LeftOuterJoin_ChatTopic_TzLocationId

Generated left outer join from the primary key TZLocationId on this table, to ChatTopic.TzLocationId.

Declaration

public TargetedLeftOuterJoin<ChatTopicTableInfo> LeftOuterJoin_ChatTopic_TzLocationId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<ChatTopicTableInfo>

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 TablesInfo.GetTZLocationInfo().

LeftOuterJoin_Contact_TzLocationId

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

Declaration

public TargetedLeftOuterJoin<ContactTableInfo> LeftOuterJoin_Contact_TzLocationId { 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 TablesInfo.GetTZLocationInfo().

LeftOuterJoin_Country_TzLocationId

Generated left outer join from the primary key TZLocationId on this table, to Country.TzLocationId.

Declaration

public TargetedLeftOuterJoin<CountryTableInfo> LeftOuterJoin_Country_TzLocationId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<CountryTableInfo>

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 TablesInfo.GetTZLocationInfo().

LeftOuterJoin_DiaryView_TzLocationId

Generated left outer join from the primary key TZLocationId on this table, to DiaryView.TzLocationId.

Declaration

public TargetedLeftOuterJoin<DiaryViewTableInfo> LeftOuterJoin_DiaryView_TzLocationId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<DiaryViewTableInfo>

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 TablesInfo.GetTZLocationInfo().

LeftOuterJoin_Person_TzLocationId

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

Declaration

public TargetedLeftOuterJoin<PersonTableInfo> LeftOuterJoin_Person_TzLocationId { 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 TablesInfo.GetTZLocationInfo().

LeftOuterJoin_Project_TzLocationId

Generated left outer join from the primary key TZLocationId on this table, to Project.TzLocationId.

Declaration

public TargetedLeftOuterJoin<ProjectTableInfo> LeftOuterJoin_Project_TzLocationId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<ProjectTableInfo>

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 TablesInfo.GetTZLocationInfo().

LeftOuterJoin_TZDstRule_TZLocationId

Generated left outer join from the primary key TZLocationId on this table, to TZDstRule.TZLocationId.

Declaration

public TargetedLeftOuterJoin<TZDstRuleTableInfo> LeftOuterJoin_TZDstRule_TZLocationId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TZDstRuleTableInfo>

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 TablesInfo.GetTZLocationInfo().

LeftOuterJoin_TZStdRule_TZLocationId

Generated left outer join from the primary key TZLocationId on this table, to TZStdRule.TZLocationId.

Declaration

public TargetedLeftOuterJoin<TZStdRuleTableInfo> LeftOuterJoin_TZStdRule_TZLocationId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TZStdRuleTableInfo>

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 TablesInfo.GetTZLocationInfo().

LeftOuterJoin_Workflow_TzLocationId

Generated left outer join from the primary key TZLocationId on this table, to Workflow.TzLocationId.

Declaration

public TargetedLeftOuterJoin<WorkflowTableInfo> LeftOuterJoin_Workflow_TzLocationId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<WorkflowTableInfo>

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 TablesInfo.GetTZLocationInfo().

LocationCode

Field 'locationCode' in table 'TZLocation': Dictionary type String[30], .NET type: string

Code, such as CA-NT, identifying the timezone location in the imported data. Unique, NOT equal to the culture codes of Windows

Declaration

public StringFieldInfo LocationCode { 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 TablesInfo.GetTZLocationInfo().

RegionName

Field 'regionName' in table 'TZLocation': Dictionary type String[255], .NET type: string

Name of region, such as Northwest Territories. Future localization via localeText resource type 31

Declaration

public StringFieldInfo RegionName { 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 TablesInfo.GetTZLocationInfo().

Registered

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

Registered when

Declaration

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 TablesInfo.GetTZLocationInfo().

RegisteredAssociateId

Field 'registered_associate_id' in table 'TZLocation': Dictionary type FK, target: Associate, .NET type: int

Registered by whom

Declaration

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 TablesInfo.GetTZLocationInfo().

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 TablesInfo.GetTZLocationInfo().

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

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 TablesInfo.GetTZLocationInfo().

ShortName

Field 'shortName' in table 'TZLocation': Dictionary type String[255], .NET type: string

Short name, such as CET (Central European Time); future localization via localeText resource type 33

Declaration

public StringFieldInfo ShortName { 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 TablesInfo.GetTZLocationInfo().

TZLocationId

Field 'TZLocation_id' in table 'TZLocation': Dictionary type PK, .NET type: int

Primary key

Declaration

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 TablesInfo.GetTZLocationInfo().

Updated

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

Last updated when

Declaration

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 TablesInfo.GetTZLocationInfo().

UpdatedAssociateId

Field 'updated_associate_id' in table 'TZLocation': Dictionary type FK, target: Associate, .NET type: int

Last updated by whom

Declaration

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 TablesInfo.GetTZLocationInfo().

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 TablesInfo.GetTZLocationInfo().

UpdatedCount

Field 'updatedCount' in table 'TZLocation': Dictionary type UShort, .NET type: short

Number of updates made to this record

Declaration

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 TablesInfo.GetTZLocationInfo().

Implements

ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)