Class ReplyTemplateTableInfo
Table 'reply_template': Templates for automatic and manual replies to emails/sms organized hierachically
Implements
Inherited Members
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 |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Properties
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 |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Overrides
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
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 |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
DictionaryTableNumber
Table number for table 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 |
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
Flags
Field 'flags' in table 'reply_template': Dictionary type Int, .NET type: Int32
Reply template type, for example "new customer" or "new password". While called flags - this is not actually flags. Only one type can be used at a time.Declaration
public Int32FieldInfo Flags { 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
FolderId
Field 'folder_id' in table 'reply_template': Dictionary type FK, target: ReplyTemplateFolder, .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 |
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
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> |
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
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 |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_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> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_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> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_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> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_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> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_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> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_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> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_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> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_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> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_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> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_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> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_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> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_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> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_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> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_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> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_TicketType_ReplyTemplate
Generated left outer join from the primary key ReplyTemplateId on this table, to TicketType.ReplyTemplate.
Declaration
public TargetedLeftOuterJoin<TicketTypeTableInfo> LeftOuterJoin_TicketType_ReplyTemplate { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<TicketTypeTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Name
Field 'name' in table '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 |
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
OwnedBy
Field 'owned_by' in table 'reply_template': Dictionary type FK, target: Ejuser, .NET type: Int32
The id of the user who owns this reply template.Declaration
public Int32FieldInfo OwnedBy { 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
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> |
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
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 |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
RuntimeDefinition
Definition of the table as described in the deployed runtime dictionary
Declaration
public static SoTable RuntimeDefinition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling