Class ExternalEventTableInfo
Table 'ExternalEvent': The definition of projects as events in Audience (or other Collaborative apps)
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 |
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
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
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 |
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
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 AudienceVisibilityDeclaration
public DateTimeFieldInfo EventDate { 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
EventEnabled
Field 'eventEnabled' in table 'ExternalEvent': Dictionary type Bool, .NET type: Int16
Is the event enabledDeclaration
public UInt16FieldInfo EventEnabled { 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
ExternalEventId
Field 'ExternalEvent_id' in table 'ExternalEvent': Dictionary type PK, .NET type: Int32
Primary keyDeclaration
public Int32FieldInfo ExternalEventId { 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
ParentRecord
Field 'parentRecord' in table 'ExternalEvent': Dictionary type RecordId, .NET type: Int32
The thing, that has now become an EventDeclaration
public Int32FieldInfo ParentRecord { 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
ParentTable
Field 'parentTable' in table 'ExternalEvent': Dictionary type TableNumber, .NET type: Int16
The thing, that has now become an EventDeclaration
public UInt16FieldInfo ParentTable { 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
Registered
Field 'registered' in table 'ExternalEvent': Dictionary type UtcDateTime, .NET type: DateTime
Registered whenDeclaration
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
RegisteredAssociateId
Field 'registered_associate_id' in table 'ExternalEvent': Dictionary type FK, target: Associate, .NET type: Int32
Registered by whomDeclaration
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
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
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
SignOff
Field 'signOff' in table 'ExternalEvent': Dictionary type Bool, .NET type: Int16
Is Sign Off functionality enabledDeclaration
public UInt16FieldInfo SignOff { 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
SignOffAssocId
Field 'signOffAssocId' in table 'ExternalEvent': Dictionary type FK, target: Associate, .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 activityDeclaration
public Int32FieldInfo SignOffAssocId { 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
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> |
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
SignOffConfTextId
Field 'signOffConfTextId' in table 'ExternalEvent': Dictionary type FK, target: Text, .NET type: Int32
If not 0, the given text should be shown as a confirmation text before accpting Sign OffDeclaration
public Int32FieldInfo SignOffConfTextId { 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
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> |
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
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 eventDeclaration
public UInt16FieldInfo SignOffTaskEnable { 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
SignOffTaskId
Field 'signOffTaskId' in table 'ExternalEvent': Dictionary type FK, target: Task, .NET type: Int32
If not 0, sign off should cause an Activity of this type to be registeredDeclaration
public Int32FieldInfo SignOffTaskId { 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
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> |
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
SignOffTextId
Field 'signOffTextId' in table 'ExternalEvent': Dictionary type FK, target: Text, .NET type: Int32
If not 0, the given text should be shown as a confirmation text before accpting Sign OffDeclaration
public Int32FieldInfo SignOffTextId { 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
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> |
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
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 dialogDeclaration
public UInt16FieldInfo SignOffTriggersAssign { 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
SignOn
Field 'signOn' in table 'ExternalEvent': Dictionary type Bool, .NET type: Int16
Is Sign On functionality enabledDeclaration
public UInt16FieldInfo SignOn { 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
SignOnAssocId
Field 'signOnAssocId' in table 'ExternalEvent': Dictionary type FK, target: Associate, .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 activityDeclaration
public Int32FieldInfo SignOnAssocId { 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
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> |
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
SignOnConfTextId
Field 'signOnConfTextId' in table 'ExternalEvent': Dictionary type FK, target: Text, .NET type: Int32
If not 0, the given text should be shown as a confirmation text before accpting Sign OnDeclaration
public Int32FieldInfo SignOnConfTextId { 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
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> |
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
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 eventDeclaration
public UInt16FieldInfo SignOnTaskEnable { 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
SignOnTaskId
Field 'signOnTaskId' in table 'ExternalEvent': Dictionary type FK, target: Task, .NET type: Int32
If not 0, sign on should cause an Activity of this type to be registeredDeclaration
public Int32FieldInfo SignOnTaskId { 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
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> |
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
SignOnTextId
Field 'signOnTextId' in table 'ExternalEvent': Dictionary type FK, target: Text, .NET type: Int32
If not 0, the given text should be entered into the appointmentDeclaration
public Int32FieldInfo SignOnTextId { 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
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> |
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
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 dialogDeclaration
public UInt16FieldInfo SignOnTriggersAssign { 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
Updated
Field 'updated' in table 'ExternalEvent': Dictionary type UtcDateTime, .NET type: DateTime
Last updated whenDeclaration
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
UpdatedAssociateId
Field 'updated_associate_id' in table 'ExternalEvent': Dictionary type FK, target: Associate, .NET type: Int32
Last updated by whomDeclaration
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
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
UpdatedCount
Field 'updatedCount' in table 'ExternalEvent': Dictionary type UShort, .NET type: Int16
Number of updates made to this recordDeclaration
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