Class ReplyTemplateTableInfo

Table 'reply_template': Templates for automatic and manual replies to emails/sms organized hierachically

Inheritance

Object

TableInfo

ReplyTemplateTableInfo

Implements

ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(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.Item[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("reply_template")]
public class ReplyTemplateTableInfo : 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 ReplyTemplate in the database dictionary: reply_template

Declaration

public const string DictionaryTableName = "reply_template"

Field Value

Type	Description
String

Properties

AccessLevel

Field 'access_level' in table 'reply_template': Dictionary type Enum, .NET type: Int16

The access level (enum) for this reply template.

Declaration

public UInt16FieldInfo AccessLevel { get; }

Property Value

Type	Description
UInt16FieldInfo

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

Description

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

The description for this reply template.

Declaration

public StringFieldInfo Description { get; }

Property Value

Type	Description
StringFieldInfo

DictionaryTableNumber

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

Flags

Field 'flags' in table 'reply_template': Dictionary type Int, .NET type: Int32

A bitmap for flags.not used for anything [snarum 29 aug 2001]

Declaration

public Int32FieldInfo Flags { get; }

Property Value

Type	Description
Int32FieldInfo

FolderId

Field 'folder_id' in table 'reply_template': Dictionary type FK, .NET type: Int32

The id of the folder in which this reply template is located. NULL or -1 if this is a toplevel reply template.

Declaration

public Int32FieldInfo FolderId { get; }

Property Value

Type	Description
Int32FieldInfo

FolderId_InnerJoin_ReplyTemplateFolder

Generated join from the foreign key FolderId in this table, to its target table ReplyTemplateFolderTableInfo.

Declaration

public TargetedInnerJoin<ReplyTemplateFolderTableInfo> FolderId_InnerJoin_ReplyTemplateFolder { get; }

Property Value

Type	Description
TargetedInnerJoin<ReplyTemplateFolderTableInfo>

LastChanged

Field 'last_changed' in table 'reply_template': Dictionary type DateTime, .NET type: DateTime

When the reply template was last changed.

Declaration

public DateTimeFieldInfo LastChanged { get; }

Property Value

Type	Description
DateTimeFieldInfo

LeftOuterJoin_EjCategory_ReplyTemplate

Generated left outer join from the primary key ReplyTemplateId on this table, to EjCategory.ReplyTemplate.

Declaration

public TargetedLeftOuterJoin<EjCategoryTableInfo> LeftOuterJoin_EjCategory_ReplyTemplate { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<EjCategoryTableInfo>

LeftOuterJoin_MailInFilter_ReplyTemplateId

Generated left outer join from the primary key ReplyTemplateId on this table, to MailInFilter.ReplyTemplateId.

Declaration

public TargetedLeftOuterJoin<MailInFilterTableInfo> LeftOuterJoin_MailInFilter_ReplyTemplateId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<MailInFilterTableInfo>

LeftOuterJoin_MsFilter_BodyTemplate

Generated left outer join from the primary key ReplyTemplateId on this table, to MsFilter.BodyTemplate.

Declaration

public TargetedLeftOuterJoin<MsFilterTableInfo> LeftOuterJoin_MsFilter_BodyTemplate { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<MsFilterTableInfo>

LeftOuterJoin_MsFilter_ReplyTemplate

Generated left outer join from the primary key ReplyTemplateId on this table, to MsFilter.ReplyTemplate.

Declaration

public TargetedLeftOuterJoin<MsFilterTableInfo> LeftOuterJoin_MsFilter_ReplyTemplate { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<MsFilterTableInfo>

LeftOuterJoin_ReplyTemplateAttachment_EntryId

Generated left outer join from the primary key ReplyTemplateId on this table, to ReplyTemplateAttachment.EntryId.

Declaration

public TargetedLeftOuterJoin<ReplyTemplateAttachmentTableInfo> LeftOuterJoin_ReplyTemplateAttachment_EntryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<ReplyTemplateAttachmentTableInfo>

LeftOuterJoin_ReplyTemplateBody_ReplyTemplateId

Generated left outer join from the primary key ReplyTemplateId on this table, to ReplyTemplateBody.ReplyTemplateId.

Declaration

public TargetedLeftOuterJoin<ReplyTemplateBodyTableInfo> LeftOuterJoin_ReplyTemplateBody_ReplyTemplateId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<ReplyTemplateBodyTableInfo>

LeftOuterJoin_TicketAlert_ReplyTemplateIdCatmast

Generated left outer join from the primary key ReplyTemplateId on this table, to TicketAlert.ReplyTemplateIdCatmast.

Declaration

public TargetedLeftOuterJoin<TicketAlertTableInfo> LeftOuterJoin_TicketAlert_ReplyTemplateIdCatmast { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketAlertTableInfo>

LeftOuterJoin_TicketAlert_ReplyTemplateIdCatmastSms

Generated left outer join from the primary key ReplyTemplateId on this table, to TicketAlert.ReplyTemplateIdCatmastSms.

Declaration

public TargetedLeftOuterJoin<TicketAlertTableInfo> LeftOuterJoin_TicketAlert_ReplyTemplateIdCatmastSms { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketAlertTableInfo>

LeftOuterJoin_TicketAlert_ReplyTemplateIdCustomer

Generated left outer join from the primary key ReplyTemplateId on this table, to TicketAlert.ReplyTemplateIdCustomer.

Declaration

public TargetedLeftOuterJoin<TicketAlertTableInfo> LeftOuterJoin_TicketAlert_ReplyTemplateIdCustomer { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketAlertTableInfo>

LeftOuterJoin_TicketAlert_ReplyTemplateIdEmail

Generated left outer join from the primary key ReplyTemplateId on this table, to TicketAlert.ReplyTemplateIdEmail.

Declaration

public TargetedLeftOuterJoin<TicketAlertTableInfo> LeftOuterJoin_TicketAlert_ReplyTemplateIdEmail { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketAlertTableInfo>

LeftOuterJoin_TicketAlert_ReplyTemplateIdSms

Generated left outer join from the primary key ReplyTemplateId on this table, to TicketAlert.ReplyTemplateIdSms.

Declaration

public TargetedLeftOuterJoin<TicketAlertTableInfo> LeftOuterJoin_TicketAlert_ReplyTemplateIdSms { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketAlertTableInfo>

LeftOuterJoin_TicketAlert_ReplyTemplateIdUser

Generated left outer join from the primary key ReplyTemplateId on this table, to TicketAlert.ReplyTemplateIdUser.

Declaration

public TargetedLeftOuterJoin<TicketAlertTableInfo> LeftOuterJoin_TicketAlert_ReplyTemplateIdUser { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketAlertTableInfo>

LeftOuterJoin_TicketAlert_ReplyTemplateIdUserSms

Generated left outer join from the primary key ReplyTemplateId on this table, to TicketAlert.ReplyTemplateIdUserSms.

Declaration

public TargetedLeftOuterJoin<TicketAlertTableInfo> LeftOuterJoin_TicketAlert_ReplyTemplateIdUserSms { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketAlertTableInfo>

LeftOuterJoin_TicketAlert_RtiCustomerSms

Generated left outer join from the primary key ReplyTemplateId on this table, to TicketAlert.RtiCustomerSms.

Declaration

public TargetedLeftOuterJoin<TicketAlertTableInfo> LeftOuterJoin_TicketAlert_RtiCustomerSms { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketAlertTableInfo>

Name

Field 'name' in table 'reply_template': Dictionary type String[256], .NET type: String

The name for this reply template.

Declaration

public StringFieldInfo Name { get; }

Property Value

Type	Description
StringFieldInfo

OwnedBy

Field 'owned_by' in table 'reply_template': Dictionary type FK, .NET type: Int32

The id of the user who owns this reply template.

Declaration

public Int32FieldInfo OwnedBy { get; }

Property Value

Type	Description
Int32FieldInfo

OwnedBy_InnerJoin_Ejuser

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

Declaration

public TargetedInnerJoin<EjuserTableInfo> OwnedBy_InnerJoin_Ejuser { get; }

Property Value

Type	Description
TargetedInnerJoin<EjuserTableInfo>

ReplyTemplateId

Field 'id' in table 'reply_template': Dictionary type PK, .NET type: Int32

The primary key (auto-incremented)

Declaration

public Int32FieldInfo ReplyTemplateId { get; }

Property Value

Type	Description
Int32FieldInfo

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

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)