Show / Hide Table of Contents

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)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top