Class ExternalEventTableInfo

Table 'ExternalEvent': The definition of projects as events in Audience (or other Collaborative apps)

Inheritance
Object
TableInfo
ExternalEventTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("ExternalEvent")]
public class ExternalEventTableInfo : 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 ExternalEvent in the database dictionary: ExternalEvent

Declaration
public const string DictionaryTableName = "ExternalEvent"
Field Value
Type Description
String

Properties

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides

DictionaryTableNumber

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

EventDate

Field 'eventDate' in table 'ExternalEvent': Dictionary type DateTime, .NET type: DateTime

Dateof the event; publishing/visibility dates are in Publish, and restrictions are in AudienceVisibility

Declaration
public DateTimeFieldInfo EventDate { get; }
Property Value
Type Description
DateTimeFieldInfo

EventEnabled

Field 'eventEnabled' in table 'ExternalEvent': Dictionary type Bool, .NET type: Int16

Is the event enabled

Declaration
public UInt16FieldInfo EventEnabled { get; }
Property Value
Type Description
UInt16FieldInfo

ExternalEventId

Field 'ExternalEvent_id' in table 'ExternalEvent': Dictionary type PK, .NET type: Int32

Primary key

Declaration
public Int32FieldInfo ExternalEventId { get; }
Property Value
Type Description
Int32FieldInfo

ParentRecord

Field 'parentRecord' in table 'ExternalEvent': Dictionary type RecordId, .NET type: Int32

The thing, that has now become an Event

Declaration
public Int32FieldInfo ParentRecord { get; }
Property Value
Type Description
Int32FieldInfo

ParentTable

Field 'parentTable' in table 'ExternalEvent': Dictionary type TableNumber, .NET type: Int16

The thing, that has now become an Event

Declaration
public UInt16FieldInfo ParentTable { get; }
Property Value
Type Description
UInt16FieldInfo

Registered

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

Registered when

Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type Description
DateTimeFieldInfo

RegisteredAssociateId

Field 'registered_associate_id' in table 'ExternalEvent': Dictionary type FK, .NET type: Int32

Registered by whom

Declaration
public Int32FieldInfo RegisteredAssociateId { get; }
Property Value
Type Description
Int32FieldInfo

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>

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

SignOff

Field 'signOff' in table 'ExternalEvent': Dictionary type Bool, .NET type: Int16

Is Sign Off functionality enabled

Declaration
public UInt16FieldInfo SignOff { get; }
Property Value
Type Description
UInt16FieldInfo

SignOffAssocId

Field 'signOffAssocId' in table 'ExternalEvent': Dictionary type FK, .NET type: Int32

If 0, the signOn Activity should go into the persons Our Contact; if not 0, this is the Associate whose diary should get the activity

Declaration
public Int32FieldInfo SignOffAssocId { get; }
Property Value
Type Description
Int32FieldInfo

SignOffAssocId_InnerJoin_Associate

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

Declaration
public TargetedInnerJoin<AssociateTableInfo> SignOffAssocId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

SignOffConfTextId

Field 'signOffConfTextId' in table 'ExternalEvent': Dictionary type FK, .NET type: Int32

If not 0, the given text should be shown as a confirmation text before accpting Sign Off

Declaration
public Int32FieldInfo SignOffConfTextId { get; }
Property Value
Type Description
Int32FieldInfo

SignOffConfTextId_InnerJoin_Text

Generated join from the foreign key SignOffConfTextId in this table, to its target table TextTableInfo.

Declaration
public TargetedInnerJoin<TextTableInfo> SignOffConfTextId_InnerJoin_Text { get; }
Property Value
Type Description
TargetedInnerJoin<TextTableInfo>

SignOffTaskEnable

Field 'signOffTaskEnable' in table 'ExternalEvent': Dictionary type Bool, .NET type: Int16

If not 0, a task should be created when the external user Signs Off an event

Declaration
public UInt16FieldInfo SignOffTaskEnable { get; }
Property Value
Type Description
UInt16FieldInfo

SignOffTaskId

Field 'signOffTaskId' in table 'ExternalEvent': Dictionary type FK, .NET type: Int32

If not 0, sign off should cause an Activity of this type to be registered

Declaration
public Int32FieldInfo SignOffTaskId { get; }
Property Value
Type Description
Int32FieldInfo

SignOffTaskId_InnerJoin_Task

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

Declaration
public TargetedInnerJoin<TaskTableInfo> SignOffTaskId_InnerJoin_Task { get; }
Property Value
Type Description
TargetedInnerJoin<TaskTableInfo>

SignOffTextId

Field 'signOffTextId' in table 'ExternalEvent': Dictionary type FK, .NET type: Int32

If not 0, the given text should be shown as a confirmation text before accpting Sign Off

Declaration
public Int32FieldInfo SignOffTextId { get; }
Property Value
Type Description
Int32FieldInfo

SignOffTextId_InnerJoin_Text

Generated join from the foreign key SignOffTextId in this table, to its target table TextTableInfo.

Declaration
public TargetedInnerJoin<TextTableInfo> SignOffTextId_InnerJoin_Text { get; }
Property Value
Type Description
TargetedInnerJoin<TextTableInfo>

SignOffTriggersAssign

Field 'signOffTriggersAssign' in table 'ExternalEvent': Dictionary type Bool, .NET type: Int16

If 1, the SignOff task should be created as an Assigned task, triggering the invitation dialog

Declaration
public UInt16FieldInfo SignOffTriggersAssign { get; }
Property Value
Type Description
UInt16FieldInfo

SignOn

Field 'signOn' in table 'ExternalEvent': Dictionary type Bool, .NET type: Int16

Is Sign On functionality enabled

Declaration
public UInt16FieldInfo SignOn { get; }
Property Value
Type Description
UInt16FieldInfo

SignOnAssocId

Field 'signOnAssocId' in table 'ExternalEvent': Dictionary type FK, .NET type: Int32

If 0, the signOn Activity should go into the persons Our Contact; if not 0, this is the Associate whose diary should get the activity

Declaration
public Int32FieldInfo SignOnAssocId { get; }
Property Value
Type Description
Int32FieldInfo

SignOnAssocId_InnerJoin_Associate

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

Declaration
public TargetedInnerJoin<AssociateTableInfo> SignOnAssocId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

SignOnConfTextId

Field 'signOnConfTextId' in table 'ExternalEvent': Dictionary type FK, .NET type: Int32

If not 0, the given text should be shown as a confirmation text before accpting Sign On

Declaration
public Int32FieldInfo SignOnConfTextId { get; }
Property Value
Type Description
Int32FieldInfo

SignOnConfTextId_InnerJoin_Text

Generated join from the foreign key SignOnConfTextId in this table, to its target table TextTableInfo.

Declaration
public TargetedInnerJoin<TextTableInfo> SignOnConfTextId_InnerJoin_Text { get; }
Property Value
Type Description
TargetedInnerJoin<TextTableInfo>

SignOnTaskEnable

Field 'signOnTaskEnable' in table 'ExternalEvent': Dictionary type Bool, .NET type: Int16

If not 0, a task should be created when the external user Signs On to an event

Declaration
public UInt16FieldInfo SignOnTaskEnable { get; }
Property Value
Type Description
UInt16FieldInfo

SignOnTaskId

Field 'signOnTaskId' in table 'ExternalEvent': Dictionary type FK, .NET type: Int32

If not 0, sign on should cause an Activity of this type to be registered

Declaration
public Int32FieldInfo SignOnTaskId { get; }
Property Value
Type Description
Int32FieldInfo

SignOnTaskId_InnerJoin_Task

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

Declaration
public TargetedInnerJoin<TaskTableInfo> SignOnTaskId_InnerJoin_Task { get; }
Property Value
Type Description
TargetedInnerJoin<TaskTableInfo>

SignOnTextId

Field 'signOnTextId' in table 'ExternalEvent': Dictionary type FK, .NET type: Int32

If not 0, the given text should be entered into the appointment

Declaration
public Int32FieldInfo SignOnTextId { get; }
Property Value
Type Description
Int32FieldInfo

SignOnTextId_InnerJoin_Text

Generated join from the foreign key SignOnTextId in this table, to its target table TextTableInfo.

Declaration
public TargetedInnerJoin<TextTableInfo> SignOnTextId_InnerJoin_Text { get; }
Property Value
Type Description
TargetedInnerJoin<TextTableInfo>

SignOnTriggersAssign

Field 'signOnTriggersAssign' in table 'ExternalEvent': Dictionary type Bool, .NET type: Int16

If 1, the SignOn task should be created as an Assigned task, triggering the invitation dialog

Declaration
public UInt16FieldInfo SignOnTriggersAssign { get; }
Property Value
Type Description
UInt16FieldInfo

Updated

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

Last updated when

Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type Description
DateTimeFieldInfo

UpdatedAssociateId

Field 'updated_associate_id' in table 'ExternalEvent': Dictionary type FK, .NET type: Int32

Last updated by whom

Declaration
public Int32FieldInfo UpdatedAssociateId { get; }
Property Value
Type Description
Int32FieldInfo

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>

UpdatedCount

Field 'updatedCount' in table 'ExternalEvent': Dictionary type UShort, .NET type: Int16

Number of updates made to this record

Declaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type Description
UInt16FieldInfo

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)