Class SLinkTableInfo

Table 's_link': Links in messages to measure success rate of a campaign.

Inheritance

object

TableInfo

SLinkTableInfo

Implements

ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(params FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(string)

TableInfo.ProtAll

TableInfo.UseNolockIfPossible

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("s_link")]
public class SLinkTableInfo : 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.GetSLinkInfo().

Fields

DictionaryTableName

Conceptual name of table SLink in the database dictionary: s_link

Declaration

public const string DictionaryTableName = "s_link"

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.GetSLinkInfo().

Properties

ActionFlags

Field 'action_flags' in table 's_link': Dictionary type Enum, .NET type: ShipmentLinkAction

Bitmask defining what action should be taken

Declaration

public ShipmentLinkActionFieldInfo ActionFlags { get; }

Property Value

Type	Description
ShipmentLinkActionFieldInfo

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.GetSLinkInfo().

AddContactInterest

Field 'add_contact_interest' in table 's_link': Dictionary type FK, target: ContInt, .NET type: int

Contact interest to add to recipient person

Declaration

public Int32FieldInfo AddContactInterest { 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.GetSLinkInfo().

AddContactInterest_InnerJoin_ContInt

Generated join from the foreign key AddContactInterest in this table, to its target table ContIntTableInfo.

Declaration

public TargetedInnerJoin<ContIntTableInfo> AddContactInterest_InnerJoin_ContInt { get; }

Property Value

Type	Description
TargetedInnerJoin<ContIntTableInfo>

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.GetSLinkInfo().

AddContactSelection

Field 'add_contact_selection' in table 's_link': Dictionary type FK, target: Selection, .NET type: int

Static contact selection to add person to

Declaration

public Int32FieldInfo AddContactSelection { 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.GetSLinkInfo().

AddContactSelection_InnerJoin_Selection

Generated join from the foreign key AddContactSelection in this table, to its target table SelectionTableInfo.

Declaration

public TargetedInnerJoin<SelectionTableInfo> AddContactSelection_InnerJoin_Selection { get; }

Property Value

Type	Description
TargetedInnerJoin<SelectionTableInfo>

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.GetSLinkInfo().

AddPersonInterest

Field 'add_person_interest' in table 's_link': Dictionary type FK, target: PersInt, .NET type: int

Person interest to add to recipient person

Declaration

public Int32FieldInfo AddPersonInterest { 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.GetSLinkInfo().

AddPersonInterest_InnerJoin_PersInt

Generated join from the foreign key AddPersonInterest in this table, to its target table PersIntTableInfo.

Declaration

public TargetedInnerJoin<PersIntTableInfo> AddPersonInterest_InnerJoin_PersInt { get; }

Property Value

Type	Description
TargetedInnerJoin<PersIntTableInfo>

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.GetSLinkInfo().

AddProject

Field 'add_project' in table 's_link': Dictionary type FK, target: Project, .NET type: int

Project to add person to, as member

Declaration

public Int32FieldInfo AddProject { 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.GetSLinkInfo().

AddProject_InnerJoin_Project

Generated join from the foreign key AddProject in this table, to its target table ProjectTableInfo.

Declaration

public TargetedInnerJoin<ProjectTableInfo> AddProject_InnerJoin_Project { get; }

Property Value

Type	Description
TargetedInnerJoin<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.GetSLinkInfo().

AddToSelection

Field 'add_to_selection' in table 's_link': Dictionary type FK, target: Ejselection, .NET type: int

The id of the selection that the customer shall be added to

Declaration

public Int32FieldInfo AddToSelection { 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.GetSLinkInfo().

AddToSelection_InnerJoin_Ejselection

Generated join from the foreign key AddToSelection in this table, to its target table EjselectionTableInfo.

Declaration

public TargetedInnerJoin<EjselectionTableInfo> AddToSelection_InnerJoin_Ejselection { get; }

Property Value

Type	Description
TargetedInnerJoin<EjselectionTableInfo>

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.GetSLinkInfo().

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.GetSLinkInfo().

Description

Field 'description' in table 's_link': Dictionary type String[256], .NET type: string

A short description of this link

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.GetSLinkInfo().

DictionaryTableNumber

Table number for table SLink 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.GetSLinkInfo().

ExtraField

Field 'extra_field' in table 's_link': Dictionary type String[256], .NET type: string

The name of the extra field to set if the customer clicks a link. empty if no extra field

Declaration

public StringFieldInfo ExtraField { 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.GetSLinkInfo().

FolderId

Field 'folder_id' in table 's_link': Dictionary type Int, .NET type: int

The folder which this link belongs to. -1 indicates that the link is on the root

Declaration

public Int32FieldInfo FolderId { 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.GetSLinkInfo().

FormId

Field 'form_id' in table 's_link': Dictionary type FK, target: Form, .NET type: int

Relation to the form this link redirects to

Declaration

public Int32FieldInfo FormId { 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.GetSLinkInfo().

FormId_InnerJoin_Form

Generated join from the foreign key FormId in this table, to its target table FormTableInfo.

Declaration

public TargetedInnerJoin<FormTableInfo> FormId_InnerJoin_Form { get; }

Property Value

Type	Description
TargetedInnerJoin<FormTableInfo>

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.GetSLinkInfo().

FormParameters

Field 'form_parameters' in table 's_link': Dictionary type String[4001], .NET type: string

Contains url parameters that will be added when link is inserted in message

Declaration

public StringFieldInfo FormParameters { 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.GetSLinkInfo().

Hits

Field 'hits' in table 's_link': Dictionary type Int, .NET type: int

Number of clicks on this link

Declaration

public Int32FieldInfo Hits { 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.GetSLinkInfo().

LastReset

Field 'last_reset' in table 's_link': Dictionary type DateTime, .NET type: DateTime

The time of last reset.

Declaration

public DateTimeFieldInfo LastReset { 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.GetSLinkInfo().

LeftOuterJoin_EmailFlowContentLink_SLinkId

Generated left outer join from the primary key SLinkId on this table, to EmailFlowContentLink.SLinkId.

Declaration

public TargetedLeftOuterJoin<EmailFlowContentLinkTableInfo> LeftOuterJoin_EmailFlowContentLink_SLinkId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<EmailFlowContentLinkTableInfo>

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.GetSLinkInfo().

LeftOuterJoin_SLinkCustomerStatical_LinkId

Generated left outer join from the primary key SLinkId on this table, to SLinkCustomerStatical.LinkId.

Declaration

public TargetedLeftOuterJoin<SLinkCustomerStaticalTableInfo> LeftOuterJoin_SLinkCustomerStatical_LinkId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SLinkCustomerStaticalTableInfo>

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.GetSLinkInfo().

LeftOuterJoin_SLinkCustomer_LinkId

Generated left outer join from the primary key SLinkId on this table, to SLinkCustomer.LinkId.

Declaration

public TargetedLeftOuterJoin<SLinkCustomerTableInfo> LeftOuterJoin_SLinkCustomer_LinkId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SLinkCustomerTableInfo>

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.GetSLinkInfo().

LinkParameters

Field 'link_parameters' in table 's_link': Dictionary type Clob, .NET type: string

Contains parameters that will be added to the link when it is used

Declaration

public StringFieldInfo LinkParameters { 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.GetSLinkInfo().

LinkValue

Field 'value' in table 's_link': Dictionary type String[256], .NET type: string

The value of the extra field to set if the customer clicks a link.

Declaration

public StringFieldInfo LinkValue { 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.GetSLinkInfo().

LocalLink

Field 'local_link' in table 's_link': Dictionary type FK, target: SMessage, .NET type: int

If this references a shipment message, then this is a local link belonging to that message

Declaration

public Int32FieldInfo LocalLink { 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.GetSLinkInfo().

LocalLink_InnerJoin_SMessage

Generated join from the foreign key LocalLink in this table, to its target table SMessageTableInfo.

Declaration

public TargetedInnerJoin<SMessageTableInfo> LocalLink_InnerJoin_SMessage { get; }

Property Value

Type	Description
TargetedInnerJoin<SMessageTableInfo>

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.GetSLinkInfo().

RedirectKind

Field 'redirect_kind' in table 's_link': Dictionary type Enum, .NET type: ShipmentLinkRedirectKind

Enum defining the redirect kind (show text, url, etc) of the link

Declaration

public ShipmentLinkRedirectKindFieldInfo RedirectKind { get; }

Property Value

Type	Description
ShipmentLinkRedirectKindFieldInfo

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.GetSLinkInfo().

Registered

Field 'registered' in table 's_link': 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.GetSLinkInfo().

RegisteredAssociateId

Field 'registered_associate_id' in table 's_link': 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.GetSLinkInfo().

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.GetSLinkInfo().

RemoveContactInterest

Field 'remove_contact_interest' in table 's_link': Dictionary type FK, target: ContInt, .NET type: int

Person interest to remove from recipient person

Declaration

public Int32FieldInfo RemoveContactInterest { 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.GetSLinkInfo().

RemoveContactInterest_InnerJoin_ContInt

Generated join from the foreign key RemoveContactInterest in this table, to its target table ContIntTableInfo.

Declaration

public TargetedInnerJoin<ContIntTableInfo> RemoveContactInterest_InnerJoin_ContInt { get; }

Property Value

Type	Description
TargetedInnerJoin<ContIntTableInfo>

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.GetSLinkInfo().

RemoveContactSelection

Field 'remove_contact_selection' in table 's_link': Dictionary type FK, target: Selection, .NET type: int

Static contact selection to remove person from

Declaration

public Int32FieldInfo RemoveContactSelection { 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.GetSLinkInfo().

RemoveContactSelection_InnerJoin_Selection

Generated join from the foreign key RemoveContactSelection in this table, to its target table SelectionTableInfo.

Declaration

public TargetedInnerJoin<SelectionTableInfo> RemoveContactSelection_InnerJoin_Selection { get; }

Property Value

Type	Description
TargetedInnerJoin<SelectionTableInfo>

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.GetSLinkInfo().

RemoveFromSelection

Field 'remove_from_selection' in table 's_link': Dictionary type FK, target: Ejselection, .NET type: int

The id of the selection that the customer shall be removed from

Declaration

public Int32FieldInfo RemoveFromSelection { 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.GetSLinkInfo().

RemoveFromSelection_InnerJoin_Ejselection

Generated join from the foreign key RemoveFromSelection in this table, to its target table EjselectionTableInfo.

Declaration

public TargetedInnerJoin<EjselectionTableInfo> RemoveFromSelection_InnerJoin_Ejselection { get; }

Property Value

Type	Description
TargetedInnerJoin<EjselectionTableInfo>

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.GetSLinkInfo().

RemovePersonInterest

Field 'remove_person_interest' in table 's_link': Dictionary type FK, target: PersInt, .NET type: int

Person interest to remove from recipient person

Declaration

public Int32FieldInfo RemovePersonInterest { 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.GetSLinkInfo().

RemovePersonInterest_InnerJoin_PersInt

Generated join from the foreign key RemovePersonInterest in this table, to its target table PersIntTableInfo.

Declaration

public TargetedInnerJoin<PersIntTableInfo> RemovePersonInterest_InnerJoin_PersInt { get; }

Property Value

Type	Description
TargetedInnerJoin<PersIntTableInfo>

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.GetSLinkInfo().

RemoveProject

Field 'remove_project' in table 's_link': Dictionary type FK, target: Project, .NET type: int

Project to remove person from, as member

Declaration

public Int32FieldInfo RemoveProject { 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.GetSLinkInfo().

RemoveProject_InnerJoin_Project

Generated join from the foreign key RemoveProject in this table, to its target table ProjectTableInfo.

Declaration

public TargetedInnerJoin<ProjectTableInfo> RemoveProject_InnerJoin_Project { get; }

Property Value

Type	Description
TargetedInnerJoin<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.GetSLinkInfo().

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.GetSLinkInfo().

SLinkId

Field 'id' in table 's_link': Dictionary type PK, .NET type: int

Primary key

Declaration

public Int32FieldInfo SLinkId { 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.GetSLinkInfo().

ScriptId

Field 'script_id' in table 's_link': Dictionary type FK, target: Ejscript, .NET type: int

The ejScript which will be run when the link is clicked. -1 means no script is run

Declaration

public Int32FieldInfo ScriptId { 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.GetSLinkInfo().

ScriptId_InnerJoin_Ejscript

Generated join from the foreign key ScriptId in this table, to its target table EjscriptTableInfo.

Declaration

public TargetedInnerJoin<EjscriptTableInfo> ScriptId_InnerJoin_Ejscript { get; }

Property Value

Type	Description
TargetedInnerJoin<EjscriptTableInfo>

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.GetSLinkInfo().

Status

Field 'status' in table 's_link': Dictionary type Enum, .NET type: short

Deleted or not. Deleted links should still work.

Declaration

public UInt16FieldInfo Status { 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.GetSLinkInfo().

TaskAssociateId

Field 'task_associate_id' in table 's_link': Dictionary type FK, target: Associate, .NET type: int

Associate whose diary should receive the task or assignment (unless AssignToOurContact is specified)

Declaration

public Int32FieldInfo TaskAssociateId { 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.GetSLinkInfo().

TaskAssociateId_InnerJoin_Associate

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

Declaration

public TargetedInnerJoin<AssociateTableInfo> TaskAssociateId_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.GetSLinkInfo().

TaskCreatingAssociateId

Field 'task_creating_associate_id' in table 's_link': Dictionary type FK, target: Associate, .NET type: int

Associate who should stand as creator of task; also works as fallback if an assigned task is rejected. Usually the associate who ordered the shipment

Declaration

public Int32FieldInfo TaskCreatingAssociateId { 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.GetSLinkInfo().

TaskCreatingAssociateId_InnerJoin_Associate

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

Declaration

public TargetedInnerJoin<AssociateTableInfo> TaskCreatingAssociateId_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.GetSLinkInfo().

TaskDuration

Field 'task_duration' in table 's_link': Dictionary type Int, .NET type: int

Task duration in minutes

Declaration

public Int32FieldInfo TaskDuration { 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.GetSLinkInfo().

TaskFlags

Field 'task_flags' in table 's_link': Dictionary type Enum, .NET type: ShipmentLinkTaskFlags

Flags that control how the task is created

Declaration

public ShipmentLinkTaskFlagsFieldInfo TaskFlags { get; }

Property Value

Type	Description
ShipmentLinkTaskFlagsFieldInfo

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.GetSLinkInfo().

TaskIdx

Field 'task_idx' in table 's_link': Dictionary type FK, target: Task, .NET type: int

Task type of new task

Declaration

public Int32FieldInfo TaskIdx { 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.GetSLinkInfo().

TaskIdx_InnerJoin_Task

Generated join from the foreign key TaskIdx in this table, to its target table TaskTableInfo.

Declaration

public TargetedInnerJoin<TaskTableInfo> TaskIdx_InnerJoin_Task { get; }

Property Value

Type	Description
TargetedInnerJoin<TaskTableInfo>

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.GetSLinkInfo().

TaskProject

Field 'task_project' in table 's_link': Dictionary type FK, target: Project, .NET type: int

Project to connect task to, can be 0

Declaration

public Int32FieldInfo TaskProject { 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.GetSLinkInfo().

TaskProject_InnerJoin_Project

Generated join from the foreign key TaskProject in this table, to its target table ProjectTableInfo.

Declaration

public TargetedInnerJoin<ProjectTableInfo> TaskProject_InnerJoin_Project { get; }

Property Value

Type	Description
TargetedInnerJoin<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.GetSLinkInfo().

TaskStart

Field 'task_start' in table 's_link': Dictionary type DateTime, .NET type: DateTime

Start time of task, unless UseNextAvailableTime is specified

Declaration

public DateTimeFieldInfo TaskStart { 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.GetSLinkInfo().

TaskText

Field 'task_text' in table 's_link': Dictionary type String[2048], .NET type: string

Text of task to be created

Declaration

public StringFieldInfo TaskText { 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.GetSLinkInfo().

TemplateText

Field 'template_text' in table 's_link': Dictionary type Clob, .NET type: string

Text to print when link is clicked.

Declaration

public StringFieldInfo TemplateText { 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.GetSLinkInfo().

TicketCategory

Field 'ticket_category' in table 's_link': Dictionary type FK, target: EjCategory, .NET type: int

The id of the category a ticket is in.

Declaration

public Int32FieldInfo TicketCategory { 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.GetSLinkInfo().

TicketCategory_InnerJoin_EjCategory

Generated join from the foreign key TicketCategory in this table, to its target table EjCategoryTableInfo.

Declaration

public TargetedInnerJoin<EjCategoryTableInfo> TicketCategory_InnerJoin_EjCategory { get; }

Property Value

Type	Description
TargetedInnerJoin<EjCategoryTableInfo>

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.GetSLinkInfo().

TicketOwnedBy

Field 'ticket_owned_by' in table 's_link': Dictionary type FK, target: Ejuser, .NET type: int

The id of the user who owns the ticket. 1 (system user) if the ticket is unassigned.

Declaration

public Int32FieldInfo TicketOwnedBy { 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.GetSLinkInfo().

TicketOwnedBy_InnerJoin_Ejuser

Generated join from the foreign key TicketOwnedBy in this table, to its target table EjuserTableInfo.

Declaration

public TargetedInnerJoin<EjuserTableInfo> TicketOwnedBy_InnerJoin_Ejuser { get; }

Property Value

Type	Description
TargetedInnerJoin<EjuserTableInfo>

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.GetSLinkInfo().

TicketPriority

Field 'ticket_priority' in table 's_link': Dictionary type FK, target: TicketPriority, .NET type: int

The reference to the ticket_priority table.

Declaration

public Int32FieldInfo TicketPriority { 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.GetSLinkInfo().

TicketPriority_InnerJoin_TicketPriority

Generated join from the foreign key TicketPriority in this table, to its target table TicketPriorityTableInfo.

Declaration

public TargetedInnerJoin<TicketPriorityTableInfo> TicketPriority_InnerJoin_TicketPriority { get; }

Property Value

Type	Description
TargetedInnerJoin<TicketPriorityTableInfo>

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.GetSLinkInfo().

TicketTitle

Field 'ticket_title' in table 's_link': Dictionary type String[256], .NET type: string

The title on the ticket if the clicks results in creating a request.

Declaration

public StringFieldInfo TicketTitle { 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.GetSLinkInfo().

Updated

Field 'updated' in table 's_link': 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.GetSLinkInfo().

UpdatedAssociateId

Field 'updated_associate_id' in table 's_link': 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.GetSLinkInfo().

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.GetSLinkInfo().

UpdatedCount

Field 'updatedCount' in table 's_link': 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.GetSLinkInfo().

Url

Field 'url' in table 's_link': Dictionary type String[4001], .NET type: string

The real URL of this link (www.vg.no etc)

Declaration

public StringFieldInfo Url { 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.GetSLinkInfo().

Implements

ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)