Show / Hide Table of Contents

Class AppointmentTableInfo

Table 'appointment': Tasks, appointments, followups, phone calls; and documents (document_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this.

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

Declaration
public const string DictionaryTableName = "appointment"
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

ActiveDate

Field 'activeDate' in table 'appointment': Dictionary type DateTime, .NET type: DateTime

The date to be used for searching & showing
Declaration
public DateTimeFieldInfo ActiveDate { 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 .

ActiveLinks

Field 'activeLinks' in table 'appointment': Dictionary type UInt, .NET type: UInt32

Number of active links to documents, other appointments, and such
Declaration
public FieldInfo ActiveLinks { get; }
Property Value
Type Description
FieldInfo
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 .

AgendaTextId

Field 'agenda_text_id' in table 'appointment': Dictionary type FK, target: Text, .NET type: Int32

ID of record containing agenda text
Declaration
public Int32FieldInfo AgendaTextId { 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 .

AgendaTextId_InnerJoin_Text

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

Declaration
public TargetedInnerJoin<TextTableInfo> AgendaTextId_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 .

Alarm

Field 'alarm' in table 'appointment': Dictionary type UShort, .NET type: Int16

Alarm leadtime, the alarm flag has moved to hasAlarm
Declaration
public UInt16FieldInfo Alarm { 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 .

AlldayEvent

Field 'alldayEvent' in table 'appointment': Dictionary type Enum, .NET type: AllDayEvent

Is this an all day event: 0 = No, 1 = Yes
Declaration
public AllDayEventFieldInfo AlldayEvent { get; }
Property Value
Type Description
AllDayEventFieldInfo
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 .

AppointmentId

Field 'appointment_id' in table 'appointment': Dictionary type PK, .NET type: Int32

Primary key
Declaration
public Int32FieldInfo AppointmentId { 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 .

AssignedBy

Field 'assignedBy' in table 'appointment': Dictionary type FK, target: Associate, .NET type: Int32

Who (last) assigned this appointment to associate_id?
Declaration
public Int32FieldInfo AssignedBy { 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 .

AssignedBy_InnerJoin_Associate

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

Declaration
public TargetedInnerJoin<AssociateTableInfo> AssignedBy_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 .

AssociateId

Field 'associate_id' in table 'appointment': Dictionary type FK, target: Associate, .NET type: Int32

ID of associate whose diary the appointment is in, REQUIRED
Declaration
public Int32FieldInfo AssociateId { 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 .

AssociateId_InnerJoin_Associate

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

Declaration
public TargetedInnerJoin<AssociateTableInfo> AssociateId_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 .

CautionWarning

Field 'cautionWarning' in table 'appointment': Dictionary type Enum, .NET type: AppointmentCautionWarning

Status field to indicate appointments that have some sort of problem
Declaration
public AppointmentCautionWarningFieldInfo CautionWarning { get; }
Property Value
Type Description
AppointmentCautionWarningFieldInfo
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 .

CentralserviceVideomeetId

Field 'centralservice_videomeet_id' in table 'appointment': Dictionary type String[101], .NET type: String

GUID for video meeting in central services – this is set when we create meetings from SuperOffice. It is blank for incoming meetings created from inbox.
Declaration
public StringFieldInfo CentralserviceVideomeetId { 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 .

ColorIndex

Field 'color_index' in table 'appointment': Dictionary type UShort, .NET type: Int16

Appointment colour, used only in Japanese versions. Western versions take colour from Task
Declaration
public UInt16FieldInfo ColorIndex { 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 .

ContactId

Field 'contact_id' in table 'appointment': Dictionary type FK, target: Contact, .NET type: Int32

Contact ID of owning contact, may be 0
Declaration
public Int32FieldInfo ContactId { 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 .

ContactId_InnerJoin_Contact

Generated join from the foreign key ContactId in this table, to its target table ContactTableInfo.

Declaration
public TargetedInnerJoin<ContactTableInfo> ContactId_InnerJoin_Contact { get; }
Property Value
Type Description
TargetedInnerJoin<ContactTableInfo>
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 .

CreatedByWorkflowId

Field 'created_by_workflow_id' in table 'appointment': Dictionary type FK, target: Workflow, .NET type: Int32

The workflow this follow-up was created by
Declaration
public Int32FieldInfo CreatedByWorkflowId { 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 .

CreatedByWorkflowId_InnerJoin_Workflow

Generated join from the foreign key CreatedByWorkflowId in this table, to its target table WorkflowTableInfo.

Declaration
public TargetedInnerJoin<WorkflowTableInfo> CreatedByWorkflowId_InnerJoin_Workflow { get; }
Property Value
Type Description
TargetedInnerJoin<WorkflowTableInfo>
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
TableInfo.Definition
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 Appointment 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 .

DoBy

Field 'do_by' in table 'appointment': Dictionary type DateTime, .NET type: DateTime

date + start time planned
Declaration
public DateTimeFieldInfo DoBy { 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 .

DocumentId

Field 'document_id' in table 'appointment': Dictionary type FK, target: Document, .NET type: Int32

Points to document record; 0 for non-document appointments!
Declaration
public Int32FieldInfo DocumentId { 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 .

DocumentId_InnerJoin_Document

Generated join from the foreign key DocumentId in this table, to its target table DocumentTableInfo.

Declaration
public TargetedInnerJoin<DocumentTableInfo> DocumentId_InnerJoin_Document { get; }
Property Value
Type Description
TargetedInnerJoin<DocumentTableInfo>
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 .

Done

Field 'done' in table 'appointment': Dictionary type DateTime, .NET type: DateTime

date + start time this task was done
Declaration
public DateTimeFieldInfo Done { 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 .

EmailId

Field 'emailId' in table 'appointment': Dictionary type FK, target: Email, .NET type: Int32

If invitation and status changes should be mailed, this is the ID of the email address used
Declaration
public Int32FieldInfo EmailId { 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 .

EmailId_InnerJoin_Email

Generated join from the foreign key EmailId in this table, to its target table EmailTableInfo.

Declaration
public TargetedInnerJoin<EmailTableInfo> EmailId_InnerJoin_Email { get; }
Property Value
Type Description
TargetedInnerJoin<EmailTableInfo>
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 .

EndDate

Field 'endDate' in table 'appointment': Dictionary type DateTime, .NET type: DateTime

Date + end time planned
Declaration
public DateTimeFieldInfo EndDate { 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 .

FreeBusy

Field 'freeBusy' in table 'appointment': Dictionary type Enum, .NET type: FreeBusy

What kind of time is this: 0 = Busy, 1 = Free
Declaration
public FreeBusyFieldInfo FreeBusy { get; }
Property Value
Type Description
FreeBusyFieldInfo
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 .

GroupIdx

Field 'group_idx' in table 'appointment': Dictionary type FK, target: UserGroup, .NET type: Int32

Group of owning associate at the time tha ppnt was created
Declaration
public Int32FieldInfo GroupIdx { 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 .

GroupIdx_InnerJoin_UserGroup

Generated join from the foreign key GroupIdx in this table, to its target table UserGroupTableInfo.

Declaration
public TargetedInnerJoin<UserGroupTableInfo> GroupIdx_InnerJoin_UserGroup { get; }
Property Value
Type Description
TargetedInnerJoin<UserGroupTableInfo>
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 .

HasAlarm

Field 'hasAlarm' in table 'appointment': Dictionary type Bool, .NET type: Int16

Does this appointment have an alarm
Declaration
public UInt16FieldInfo HasAlarm { 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 .

InternalNotesTextId

Field 'internal_notes_text_id' in table 'appointment': Dictionary type FK, target: Text, .NET type: Int32

ID of record containing internal notes text
Declaration
public Int32FieldInfo InternalNotesTextId { 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 .

InternalNotesTextId_InnerJoin_Text

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

Declaration
public TargetedInnerJoin<TextTableInfo> InternalNotesTextId_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 .

InvitedPersonId

Field 'invitedPersonId' in table 'appointment': Dictionary type FK, target: Person, .NET type: Int32

Valid when mother_id != 0 && mother_id != id
Declaration
public Int32FieldInfo InvitedPersonId { 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 .

InvitedPersonId_InnerJoin_Person

Generated join from the foreign key InvitedPersonId in this table, to its target table PersonTableInfo.

Declaration
public TargetedInnerJoin<PersonTableInfo> InvitedPersonId_InnerJoin_Person { get; }
Property Value
Type Description
TargetedInnerJoin<PersonTableInfo>
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 .

IsMilestone

Field 'isMilestone' in table 'appointment': Dictionary type Bool, .NET type: Int16

Is this appointment a milestone?
Declaration
public UInt16FieldInfo IsMilestone { 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 .

JoinVideomeetUrl

Field 'join_videomeet_url' in table 'appointment': Dictionary type String[2001], .NET type: String

Blank when not a video meeting. Filled with Join Meeting URL when created.
Declaration
public StringFieldInfo JoinVideomeetUrl { 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 .

LagTime

Field 'lagTime' in table 'appointment': Dictionary type UShort, .NET type: Int16

as leadtime, but after the end - time blocked for travel etc.
Declaration
public UInt16FieldInfo LagTime { 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 .

Leadtime

Field 'leadtime' in table 'appointment': Dictionary type UShort, .NET type: Int16

Time blocked (minutes) BEFORE starttime
Declaration
public UInt16FieldInfo Leadtime { 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 .

LeftOuterJoin_Document_AppointmentId

Generated left outer join from the primary key AppointmentId on this table, to Document.AppointmentId.

Declaration
public TargetedLeftOuterJoin<DocumentTableInfo> LeftOuterJoin_Document_AppointmentId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<DocumentTableInfo>
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_Email_AppointmentId

Generated left outer join from the primary key AppointmentId on this table, to Email.AppointmentId.

Declaration
public TargetedLeftOuterJoin<EmailTableInfo> LeftOuterJoin_Email_AppointmentId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EmailTableInfo>
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_EmailItem_AppointmentId

Generated left outer join from the primary key AppointmentId on this table, to EmailItem.AppointmentId.

Declaration
public TargetedLeftOuterJoin<EmailItemTableInfo> LeftOuterJoin_EmailItem_AppointmentId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EmailItemTableInfo>
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_Invitation_AppointmentId

Generated left outer join from the primary key AppointmentId on this table, to Invitation.AppointmentId.

Declaration
public TargetedLeftOuterJoin<InvitationTableInfo> LeftOuterJoin_Invitation_AppointmentId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<InvitationTableInfo>
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_Project_NmdAppointmentId

Generated left outer join from the primary key AppointmentId on this table, to Project.NmdAppointmentId.

Declaration
public TargetedLeftOuterJoin<ProjectTableInfo> LeftOuterJoin_Project_NmdAppointmentId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ProjectTableInfo>
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_QuoteVersion_FollowupId

Generated left outer join from the primary key AppointmentId on this table, to QuoteVersion.FollowupId.

Declaration
public TargetedLeftOuterJoin<QuoteVersionTableInfo> LeftOuterJoin_QuoteVersion_FollowupId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<QuoteVersionTableInfo>
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_Sale_AppointmentId

Generated left outer join from the primary key AppointmentId on this table, to Sale.AppointmentId.

Declaration
public TargetedLeftOuterJoin<SaleTableInfo> LeftOuterJoin_Sale_AppointmentId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SaleTableInfo>
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_Sale_NddAppointmentId

Generated left outer join from the primary key AppointmentId on this table, to Sale.NddAppointmentId.

Declaration
public TargetedLeftOuterJoin<SaleTableInfo> LeftOuterJoin_Sale_NddAppointmentId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SaleTableInfo>
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_SaleHist_AppointmentId

Generated left outer join from the primary key AppointmentId on this table, to SaleHist.AppointmentId.

Declaration
public TargetedLeftOuterJoin<SaleHistTableInfo> LeftOuterJoin_SaleHist_AppointmentId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SaleHistTableInfo>
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_SaleHist_NddAppointmentId

Generated left outer join from the primary key AppointmentId on this table, to SaleHist.NddAppointmentId.

Declaration
public TargetedLeftOuterJoin<SaleHistTableInfo> LeftOuterJoin_SaleHist_NddAppointmentId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SaleHistTableInfo>
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_VisibleFor_AppointmentId

Generated left outer join from the primary key AppointmentId on this table, to VisibleFor.AppointmentId.

Declaration
public TargetedLeftOuterJoin<VisibleForTableInfo> LeftOuterJoin_VisibleFor_AppointmentId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<VisibleForTableInfo>
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 .

Location

Field 'location' in table 'appointment': Dictionary type String[255], .NET type: String

Location for appointment, defaulted from invited resource of type place and other rules, but you can write anything you want here
Declaration
public StringFieldInfo Location { 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 .

ModifiedAppointmentFields

Field 'modified_appointment_fields' in table 'appointment': Dictionary type Enum, .NET type: ModifiedAppointmentFields

Which important fields of an appointment have been changed. Used by notifications.
Declaration
public ModifiedAppointmentFieldsFieldInfo ModifiedAppointmentFields { get; }
Property Value
Type Description
ModifiedAppointmentFieldsFieldInfo
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 .

MotherAssociateId

Field 'mother_associate_id' in table 'appointment': Dictionary type FK, target: Associate, .NET type: Int32

Associate/owner of the mother appointment
Declaration
public Int32FieldInfo MotherAssociateId { 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 .

MotherAssociateId_InnerJoin_Associate

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

Declaration
public TargetedInnerJoin<AssociateTableInfo> MotherAssociateId_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 .

MotherId

Field 'mother_id' in table 'appointment': Dictionary type FK, target: Appointment, .NET type: Int32

ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Declaration
public Int32FieldInfo MotherId { 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 .

MotherId_InnerJoin_Appointment

Generated join from the foreign key MotherId in this table, to its target table AppointmentTableInfo.

Declaration
public TargetedInnerJoin<AppointmentTableInfo> MotherId_InnerJoin_Appointment { get; }
Property Value
Type Description
TargetedInnerJoin<AppointmentTableInfo>
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 .

OriginalStartDate

Field 'original_start_date' in table 'appointment': Dictionary type DateTime, .NET type: DateTime

The original start date for an appointment in a recurring series
Declaration
public DateTimeFieldInfo OriginalStartDate { 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 .

OwnedExternally

Field 'owned_externally' in table 'appointment': Dictionary type Enum, .NET type: AppointmentExternalOwner

Set if an external system owns this appointment.
Declaration
public AppointmentExternalOwnerFieldInfo OwnedExternally { get; }
Property Value
Type Description
AppointmentExternalOwnerFieldInfo
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 .

PersonId

Field 'person_id' in table 'appointment': Dictionary type FK, target: Person, .NET type: Int32

Person ID of person the appointment is with, may be 0
Declaration
public Int32FieldInfo PersonId { 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 .

PersonId_InnerJoin_Person

Generated join from the foreign key PersonId in this table, to its target table PersonTableInfo.

Declaration
public TargetedInnerJoin<PersonTableInfo> PersonId_InnerJoin_Person { get; }
Property Value
Type Description
TargetedInnerJoin<PersonTableInfo>
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 .

PreferredTZLocation

Field 'preferredTZLocation' in table 'appointment': Dictionary type FK, target: TZLocation, .NET type: Int32

Preferred timezone location to use when displaying/editing this appointment
Declaration
public Int32FieldInfo PreferredTZLocation { 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 .

PreferredTZLocation_InnerJoin_TZLocation

Generated join from the foreign key PreferredTZLocation in this table, to its target table TZLocationTableInfo.

Declaration
public TargetedInnerJoin<TZLocationTableInfo> PreferredTZLocation_InnerJoin_TZLocation { get; }
Property Value
Type Description
TargetedInnerJoin<TZLocationTableInfo>
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 .

PriorityIdx

Field 'priority_idx' in table 'appointment': Dictionary type FK, target: Priority, .NET type: Int32

Link to priority list
Declaration
public Int32FieldInfo PriorityIdx { 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 .

PriorityIdx_InnerJoin_Priority

Generated join from the foreign key PriorityIdx in this table, to its target table PriorityTableInfo.

Declaration
public TargetedInnerJoin<PriorityTableInfo> PriorityIdx_InnerJoin_Priority { get; }
Property Value
Type Description
TargetedInnerJoin<PriorityTableInfo>
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 .

Private

Field 'private' in table 'appointment': Dictionary type Enum, .NET type: AppointmentPrivate

Obsolete, but still maintained field for appointment privacy; denormalization of visiblefor status
Declaration
public AppointmentPrivateFieldInfo Private { get; }
Property Value
Type Description
AppointmentPrivateFieldInfo
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 .

ProjectId

Field 'project_id' in table 'appointment': Dictionary type FK, target: Project, .NET type: Int32

ID of project referred to, may be 0
Declaration
public Int32FieldInfo ProjectId { 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 .

ProjectId_InnerJoin_Project

Generated join from the foreign key ProjectId in this table, to its target table ProjectTableInfo.

Declaration
public TargetedInnerJoin<ProjectTableInfo> ProjectId_InnerJoin_Project { get; }
Property Value
Type Description
TargetedInnerJoin<ProjectTableInfo>
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 .

RecurrenceRuleId

Field 'recurrenceRuleId' in table 'appointment': Dictionary type FK, target: RecurrenceRule, .NET type: Int32

Pointer to recurrence rule, for recurring appointments, otherwise 0
Declaration
public Int32FieldInfo RecurrenceRuleId { 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 .

RecurrenceRuleId_InnerJoin_RecurrenceRule

Generated join from the foreign key RecurrenceRuleId in this table, to its target table RecurrenceRuleTableInfo.

Declaration
public TargetedInnerJoin<RecurrenceRuleTableInfo> RecurrenceRuleId_InnerJoin_RecurrenceRule { get; }
Property Value
Type Description
TargetedInnerJoin<RecurrenceRuleTableInfo>
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 'appointment': Dictionary type UtcDateTime, .NET type: DateTime

Registered date
Declaration
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 'appointment': Dictionary type FK, target: Associate, .NET type: Int32

Registered by whom
Declaration
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 .

RejectCounter

Field 'rejectCounter' in table 'appointment': Dictionary type UShort, .NET type: Int16

How many invitees have rejected this appointment
Declaration
public UInt16FieldInfo RejectCounter { 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 .

RejectReason

Field 'rejectReason' in table 'appointment': Dictionary type String[255], .NET type: String

Why was this booking or assignment rejected, the RejectReason list is a source of suggestions but you can write anything here
Declaration
public StringFieldInfo RejectReason { 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 .

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 .

SaleId

Field 'sale_id' in table 'appointment': Dictionary type FK, target: Sale, .NET type: Int32

Owning sale, if any (may be 0)
Declaration
public Int32FieldInfo SaleId { 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 .

SaleId_InnerJoin_Sale

Generated join from the foreign key SaleId in this table, to its target table SaleTableInfo.

Declaration
public TargetedInnerJoin<SaleTableInfo> SaleId_InnerJoin_Sale { get; }
Property Value
Type Description
TargetedInnerJoin<SaleTableInfo>
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 .

SendEmail

Field 'SendEmail' in table 'appointment': Dictionary type Bool, .NET type: Int16

Send invitation and appointment changes by e-mail to this participant.
Declaration
public UInt16FieldInfo SendEmail { 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 .

Source

Field 'source' in table 'appointment': Dictionary type UShort, .NET type: Int16

For future integration use; source of record
Declaration
public UInt16FieldInfo Source { 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 .

Status

Field 'status' in table 'appointment': Dictionary type Enum, .NET type: AppointmentStatus

status=done,started, not started, hidden
Declaration
public AppointmentStatusFieldInfo Status { get; }
Property Value
Type Description
AppointmentStatusFieldInfo
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 .

SuggestedAppointmentId

Field 'suggestedAppointmentId' in table 'appointment': Dictionary type FK, target: SuggestedAppointment, .NET type: Int32

Suggested guide item that this appointment is an instance of (Note: NOT VALID for document-type appointments, they have their own link)
Declaration
public Int32FieldInfo SuggestedAppointmentId { 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 .

SuggestedAppointmentId_InnerJoin_SuggestedAppointment

Generated join from the foreign key SuggestedAppointmentId in this table, to its target table SuggestedAppointmentTableInfo.

Declaration
public TargetedInnerJoin<SuggestedAppointmentTableInfo> SuggestedAppointmentId_InnerJoin_SuggestedAppointment { get; }
Property Value
Type Description
TargetedInnerJoin<SuggestedAppointmentTableInfo>
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 .

SuggestedDocumentId

Field 'suggestedDocumentId' in table 'appointment': Dictionary type FK, target: SuggestedDocument, .NET type: Int32

Suggested guide item that this document is an instance of (Note: NOT valid for appointments, they have their own link)
Declaration
public Int32FieldInfo SuggestedDocumentId { 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 .

SuggestedDocumentId_InnerJoin_SuggestedDocument

Generated join from the foreign key SuggestedDocumentId in this table, to its target table SuggestedDocumentTableInfo.

Declaration
public TargetedInnerJoin<SuggestedDocumentTableInfo> SuggestedDocumentId_InnerJoin_SuggestedDocument { get; }
Property Value
Type Description
TargetedInnerJoin<SuggestedDocumentTableInfo>
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 .

TaskIdx

Field 'task_idx' in table 'appointment': Dictionary type FK, target: Task, .NET type: Int32

Link to Task list, OR to DocTmpl list, if this is a document
Declaration
public Int32FieldInfo TaskIdx { 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 .

TaskIdx_InnerJoin_Task

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

Declaration
public TargetedInnerJoin<TaskTableInfo> TaskIdx_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 .

TextId

Field 'text_id' in table 'appointment': Dictionary type FK, target: Text, .NET type: Int32

ID of record containing appointment text
Declaration
public Int32FieldInfo TextId { 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 .

TextId_InnerJoin_Text

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

Declaration
public TargetedInnerJoin<TextTableInfo> TextId_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 .

Type

Field 'type' in table 'appointment': Dictionary type Enum, .NET type: AppointmentType

where=no start time,note,docin, docout
Declaration
public AppointmentTypeFieldInfo Type { get; }
Property Value
Type Description
AppointmentTypeFieldInfo
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 'appointment': Dictionary type UtcDateTime, .NET type: DateTime

Updated date
Declaration
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 'appointment': Dictionary type FK, target: Associate, .NET type: Int32

Updated by who
Declaration
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 'appointment': Dictionary type UShort, .NET type: Int16

Number of updates made to this record
Declaration
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 .

Userdef2Id

Field 'userdef2_id' in table 'appointment': Dictionary type FK, target: UDAppntLarge, .NET type: Int32

User defined table record 2 (for future use)
Declaration
public Int32FieldInfo Userdef2Id { 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 .

Userdef2Id_InnerJoin_UDAppntLarge

Generated join from the foreign key Userdef2Id in this table, to its target table UDAppntLargeTableInfo.

Declaration
public TargetedInnerJoin<UDAppntLargeTableInfo> Userdef2Id_InnerJoin_UDAppntLarge { get; }
Property Value
Type Description
TargetedInnerJoin<UDAppntLargeTableInfo>
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 .

UserdefId

Field 'userdef_id' in table 'appointment': Dictionary type FK, target: UDAppntSmall, .NET type: Int32

User defined table record 1 (for future use)
Declaration
public Int32FieldInfo UserdefId { 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 .

UserdefId_InnerJoin_UDAppntSmall

Generated join from the foreign key UserdefId in this table, to its target table UDAppntSmallTableInfo.

Declaration
public TargetedInnerJoin<UDAppntSmallTableInfo> UserdefId_InnerJoin_UDAppntSmall { get; }
Property Value
Type Description
TargetedInnerJoin<UDAppntSmallTableInfo>
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 .

Methods

IdxAssociateId(Int32)

Shortcut method for looking up using the database index AssociateId, which spans the following fields:

FieldDescription
AssociateIdID of associate whose diary the appointment is in, REQUIRED
Declaration
public Restriction IdxAssociateId(int associateId)
Parameters
Type Name Description
Int32 associateId
Returns
Type Description
Restriction
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 .

IdxAssociateIdActiveDate(Int32, DateTime)

Shortcut method for looking up using the database index AssociateIdActiveDate, which spans the following fields:

FieldDescription
AssociateIdID of associate whose diary the appointment is in, REQUIRED
ActiveDateThe date to be used for searching & showing
Declaration
public Restriction IdxAssociateIdActiveDate(int associateId, DateTime activeDate)
Parameters
Type Name Description
Int32 associateId
DateTime activeDate
Returns
Type Description
Restriction
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 .

IdxAssociateIdActiveDateMotherId(Int32, DateTime, Int32)

Shortcut method for looking up using the database index AssociateIdActiveDateMotherId, which spans the following fields:

FieldDescription
AssociateIdID of associate whose diary the appointment is in, REQUIRED
ActiveDateThe date to be used for searching & showing
MotherIdID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Declaration
public Restriction IdxAssociateIdActiveDateMotherId(int associateId, DateTime activeDate, int motherId)
Parameters
Type Name Description
Int32 associateId
DateTime activeDate
Int32 motherId
Returns
Type Description
Restriction
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 .

IdxAssociateIdStatus(Int32, AppointmentStatus)

Shortcut method for looking up using the database index AssociateIdStatus, which spans the following fields:

FieldDescription
AssociateIdID of associate whose diary the appointment is in, REQUIRED
Statusstatus=done,started, not started, hidden
Declaration
public Restriction IdxAssociateIdStatus(int associateId, AppointmentStatus status)
Parameters
Type Name Description
Int32 associateId
AppointmentStatus status
Returns
Type Description
Restriction
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 .

IdxAssociateIdStatusDoBy(Int32, AppointmentStatus, DateTime)

Shortcut method for looking up using the database index AssociateIdStatusDoBy, which spans the following fields:

FieldDescription
AssociateIdID of associate whose diary the appointment is in, REQUIRED
Statusstatus=done,started, not started, hidden
DoBydate + start time planned
Declaration
public Restriction IdxAssociateIdStatusDoBy(int associateId, AppointmentStatus status, DateTime doBy)
Parameters
Type Name Description
Int32 associateId
AppointmentStatus status
DateTime doBy
Returns
Type Description
Restriction
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 .

IdxAssociateIdType(Int32, AppointmentType)

Shortcut method for looking up using the database index AssociateIdType, which spans the following fields:

FieldDescription
AssociateIdID of associate whose diary the appointment is in, REQUIRED
Typewhere=no start time,note,docin, docout
Declaration
public Restriction IdxAssociateIdType(int associateId, AppointmentType type)
Parameters
Type Name Description
Int32 associateId
AppointmentType type
Returns
Type Description
Restriction
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 .

IdxAssociateIdTypeEndDate(Int32, AppointmentType, DateTime)

Shortcut method for looking up using the database index AssociateIdTypeEndDate, which spans the following fields:

FieldDescription
AssociateIdID of associate whose diary the appointment is in, REQUIRED
Typewhere=no start time,note,docin, docout
EndDateDate + end time planned
Declaration
public Restriction IdxAssociateIdTypeEndDate(int associateId, AppointmentType type, DateTime endDate)
Parameters
Type Name Description
Int32 associateId
AppointmentType type
DateTime endDate
Returns
Type Description
Restriction
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 .

IdxAssociateIdTypeStatus(Int32, AppointmentType, AppointmentStatus)

Shortcut method for looking up using the database index AssociateIdTypeStatus, which spans the following fields:

FieldDescription
AssociateIdID of associate whose diary the appointment is in, REQUIRED
Typewhere=no start time,note,docin, docout
Statusstatus=done,started, not started, hidden
Declaration
public Restriction IdxAssociateIdTypeStatus(int associateId, AppointmentType type, AppointmentStatus status)
Parameters
Type Name Description
Int32 associateId
AppointmentType type
AppointmentStatus status
Returns
Type Description
Restriction
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 .

IdxContactId(Int32)

Shortcut method for looking up using the database index ContactId, which spans the following fields:

FieldDescription
ContactIdContact ID of owning contact, may be 0
Declaration
public Restriction IdxContactId(int contactId)
Parameters
Type Name Description
Int32 contactId
Returns
Type Description
Restriction
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 .

IdxMotherId(Int32)

Shortcut method for looking up using the database index MotherId, which spans the following fields:

FieldDescription
MotherIdID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Declaration
public Restriction IdxMotherId(int motherId)
Parameters
Type Name Description
Int32 motherId
Returns
Type Description
Restriction
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 .

IdxMotherIdStatus(Int32, AppointmentStatus)

Shortcut method for looking up using the database index MotherIdStatus, which spans the following fields:

FieldDescription
MotherIdID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Statusstatus=done,started, not started, hidden
Declaration
public Restriction IdxMotherIdStatus(int motherId, AppointmentStatus status)
Parameters
Type Name Description
Int32 motherId
AppointmentStatus status
Returns
Type Description
Restriction
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 .

IdxMotherIdStatusActiveDate(Int32, AppointmentStatus, DateTime)

Shortcut method for looking up using the database index MotherIdStatusActiveDate, which spans the following fields:

FieldDescription
MotherIdID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Statusstatus=done,started, not started, hidden
ActiveDateThe date to be used for searching & showing
Declaration
public Restriction IdxMotherIdStatusActiveDate(int motherId, AppointmentStatus status, DateTime activeDate)
Parameters
Type Name Description
Int32 motherId
AppointmentStatus status
DateTime activeDate
Returns
Type Description
Restriction
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 .

IdxMotherIdStatusActiveDateRegisteredAssociateId(Int32, AppointmentStatus, DateTime, Int32)

Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateId, which spans the following fields:

FieldDescription
MotherIdID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Statusstatus=done,started, not started, hidden
ActiveDateThe date to be used for searching & showing
RegisteredAssociateIdRegistered by whom
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateId(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId)
Parameters
Type Name Description
Int32 motherId
AppointmentStatus status
DateTime activeDate
Int32 registeredAssociateId
Returns
Type Description
Restriction
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 .

IdxMotherIdStatusActiveDateRegisteredAssociateIdRegistered(Int32, AppointmentStatus, DateTime, Int32, DateTime)

Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateIdRegistered, which spans the following fields:

FieldDescription
MotherIdID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Statusstatus=done,started, not started, hidden
ActiveDateThe date to be used for searching & showing
RegisteredAssociateIdRegistered by whom
RegisteredRegistered date
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegistered(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered)
Parameters
Type Name Description
Int32 motherId
AppointmentStatus status
DateTime activeDate
Int32 registeredAssociateId
DateTime registered
Returns
Type Description
Restriction
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 .

IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedBy(Int32, AppointmentStatus, DateTime, Int32, DateTime, Int32)

Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedBy, which spans the following fields:

FieldDescription
MotherIdID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Statusstatus=done,started, not started, hidden
ActiveDateThe date to be used for searching & showing
RegisteredAssociateIdRegistered by whom
RegisteredRegistered date
AssignedByWho (last) assigned this appointment to associate_id?
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedBy(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy)
Parameters
Type Name Description
Int32 motherId
AppointmentStatus status
DateTime activeDate
Int32 registeredAssociateId
DateTime registered
Int32 assignedBy
Returns
Type Description
Restriction
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 .

IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdx(Int32, AppointmentStatus, DateTime, Int32, DateTime, Int32, Int32)

Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdx, which spans the following fields:

FieldDescription
MotherIdID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Statusstatus=done,started, not started, hidden
ActiveDateThe date to be used for searching & showing
RegisteredAssociateIdRegistered by whom
RegisteredRegistered date
AssignedByWho (last) assigned this appointment to associate_id?
GroupIdxGroup of owning associate at the time tha ppnt was created
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdx(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy, int groupIdx)
Parameters
Type Name Description
Int32 motherId
AppointmentStatus status
DateTime activeDate
Int32 registeredAssociateId
DateTime registered
Int32 assignedBy
Int32 groupIdx
Returns
Type Description
Restriction
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 .

IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType(Int32, AppointmentStatus, DateTime, Int32, DateTime, Int32, Int32, AppointmentType)

Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType, which spans the following fields:

FieldDescription
MotherIdID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Statusstatus=done,started, not started, hidden
ActiveDateThe date to be used for searching & showing
RegisteredAssociateIdRegistered by whom
RegisteredRegistered date
AssignedByWho (last) assigned this appointment to associate_id?
GroupIdxGroup of owning associate at the time tha ppnt was created
Typewhere=no start time,note,docin, docout
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy, int groupIdx, AppointmentType type)
Parameters
Type Name Description
Int32 motherId
AppointmentStatus status
DateTime activeDate
Int32 registeredAssociateId
DateTime registered
Int32 assignedBy
Int32 groupIdx
AppointmentType type
Returns
Type Description
Restriction
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 .

IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxTypeAssociateId(Int32, AppointmentStatus, DateTime, Int32, DateTime, Int32, Int32, AppointmentType, Int32)

Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxTypeAssociateId, which spans the following fields:

FieldDescription
MotherIdID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Statusstatus=done,started, not started, hidden
ActiveDateThe date to be used for searching & showing
RegisteredAssociateIdRegistered by whom
RegisteredRegistered date
AssignedByWho (last) assigned this appointment to associate_id?
GroupIdxGroup of owning associate at the time tha ppnt was created
Typewhere=no start time,note,docin, docout
AssociateIdID of associate whose diary the appointment is in, REQUIRED
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxTypeAssociateId(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy, int groupIdx, AppointmentType type, int associateId)
Parameters
Type Name Description
Int32 motherId
AppointmentStatus status
DateTime activeDate
Int32 registeredAssociateId
DateTime registered
Int32 assignedBy
Int32 groupIdx
AppointmentType type
Int32 associateId
Returns
Type Description
Restriction
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 .

IdxProjectId(Int32)

Shortcut method for looking up using the database index ProjectId, which spans the following fields:

FieldDescription
ProjectIdID of project referred to, may be 0
Declaration
public Restriction IdxProjectId(int projectId)
Parameters
Type Name Description
Int32 projectId
Returns
Type Description
Restriction
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 .

IdxProjectIdType(Int32, AppointmentType)

Shortcut method for looking up using the database index ProjectIdType, which spans the following fields:

FieldDescription
ProjectIdID of project referred to, may be 0
Typewhere=no start time,note,docin, docout
Declaration
public Restriction IdxProjectIdType(int projectId, AppointmentType type)
Parameters
Type Name Description
Int32 projectId
AppointmentType type
Returns
Type Description
Restriction
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 .

IdxProjectIdTypeActiveDate(Int32, AppointmentType, DateTime)

Shortcut method for looking up using the database index ProjectIdTypeActiveDate, which spans the following fields:

FieldDescription
ProjectIdID of project referred to, may be 0
Typewhere=no start time,note,docin, docout
ActiveDateThe date to be used for searching & showing
Declaration
public Restriction IdxProjectIdTypeActiveDate(int projectId, AppointmentType type, DateTime activeDate)
Parameters
Type Name Description
Int32 projectId
AppointmentType type
DateTime activeDate
Returns
Type Description
Restriction
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 .

IdxProjectIdTypeActiveDateDocumentId(Int32, AppointmentType, DateTime, Int32)

Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentId, which spans the following fields:

FieldDescription
ProjectIdID of project referred to, may be 0
Typewhere=no start time,note,docin, docout
ActiveDateThe date to be used for searching & showing
DocumentIdPoints to document record; 0 for non-document appointments!
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentId(int projectId, AppointmentType type, DateTime activeDate, int documentId)
Parameters
Type Name Description
Int32 projectId
AppointmentType type
DateTime activeDate
Int32 documentId
Returns
Type Description
Restriction
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 .

IdxProjectIdTypeActiveDateDocumentIdAssociateId(Int32, AppointmentType, DateTime, Int32, Int32)

Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateId, which spans the following fields:

FieldDescription
ProjectIdID of project referred to, may be 0
Typewhere=no start time,note,docin, docout
ActiveDateThe date to be used for searching & showing
DocumentIdPoints to document record; 0 for non-document appointments!
AssociateIdID of associate whose diary the appointment is in, REQUIRED
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateId(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId)
Parameters
Type Name Description
Int32 projectId
AppointmentType type
DateTime activeDate
Int32 documentId
Int32 associateId
Returns
Type Description
Restriction
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 .

IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdx(Int32, AppointmentType, DateTime, Int32, Int32, Int32)

Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdx, which spans the following fields:

FieldDescription
ProjectIdID of project referred to, may be 0
Typewhere=no start time,note,docin, docout
ActiveDateThe date to be used for searching & showing
DocumentIdPoints to document record; 0 for non-document appointments!
AssociateIdID of associate whose diary the appointment is in, REQUIRED
GroupIdxGroup of owning associate at the time tha ppnt was created
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdx(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx)
Parameters
Type Name Description
Int32 projectId
AppointmentType type
DateTime activeDate
Int32 documentId
Int32 associateId
Int32 groupIdx
Returns
Type Description
Restriction
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 .

IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherId(Int32, AppointmentType, DateTime, Int32, Int32, Int32, Int32)

Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherId, which spans the following fields:

FieldDescription
ProjectIdID of project referred to, may be 0
Typewhere=no start time,note,docin, docout
ActiveDateThe date to be used for searching & showing
DocumentIdPoints to document record; 0 for non-document appointments!
AssociateIdID of associate whose diary the appointment is in, REQUIRED
GroupIdxGroup of owning associate at the time tha ppnt was created
MotherIdID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherId(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId)
Parameters
Type Name Description
Int32 projectId
AppointmentType type
DateTime activeDate
Int32 documentId
Int32 associateId
Int32 groupIdx
Int32 motherId
Returns
Type Description
Restriction
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 .

IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy(Int32, AppointmentType, DateTime, Int32, Int32, Int32, Int32, Int32)

Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy, which spans the following fields:

FieldDescription
ProjectIdID of project referred to, may be 0
Typewhere=no start time,note,docin, docout
ActiveDateThe date to be used for searching & showing
DocumentIdPoints to document record; 0 for non-document appointments!
AssociateIdID of associate whose diary the appointment is in, REQUIRED
GroupIdxGroup of owning associate at the time tha ppnt was created
MotherIdID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
AssignedByWho (last) assigned this appointment to associate_id?
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId, int assignedBy)
Parameters
Type Name Description
Int32 projectId
AppointmentType type
DateTime activeDate
Int32 documentId
Int32 associateId
Int32 groupIdx
Int32 motherId
Int32 assignedBy
Returns
Type Description
Restriction
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 .

IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentId(Int32, AppointmentType, DateTime, Int32, Int32, Int32, Int32, Int32, Int32)

Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentId, which spans the following fields:

FieldDescription
ProjectIdID of project referred to, may be 0
Typewhere=no start time,note,docin, docout
ActiveDateThe date to be used for searching & showing
DocumentIdPoints to document record; 0 for non-document appointments!
AssociateIdID of associate whose diary the appointment is in, REQUIRED
GroupIdxGroup of owning associate at the time tha ppnt was created
MotherIdID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
AssignedByWho (last) assigned this appointment to associate_id?
AppointmentIdPrimary key
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentId(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId, int assignedBy, int appointmentId)
Parameters
Type Name Description
Int32 projectId
AppointmentType type
DateTime activeDate
Int32 documentId
Int32 associateId
Int32 groupIdx
Int32 motherId
Int32 assignedBy
Int32 appointmentId
Returns
Type Description
Restriction
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 .

IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentIdRegistered(Int32, AppointmentType, DateTime, Int32, Int32, Int32, Int32, Int32, Int32, DateTime)

Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentIdRegistered, which spans the following fields:

FieldDescription
ProjectIdID of project referred to, may be 0
Typewhere=no start time,note,docin, docout
ActiveDateThe date to be used for searching & showing
DocumentIdPoints to document record; 0 for non-document appointments!
AssociateIdID of associate whose diary the appointment is in, REQUIRED
GroupIdxGroup of owning associate at the time tha ppnt was created
MotherIdID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
AssignedByWho (last) assigned this appointment to associate_id?
AppointmentIdPrimary key
RegisteredRegistered date
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentIdRegistered(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId, int assignedBy, int appointmentId, DateTime registered)
Parameters
Type Name Description
Int32 projectId
AppointmentType type
DateTime activeDate
Int32 documentId
Int32 associateId
Int32 groupIdx
Int32 motherId
Int32 assignedBy
Int32 appointmentId
DateTime registered
Returns
Type Description
Restriction
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 .

IdxRecurrenceRuleId(Int32)

Shortcut method for looking up using the database index RecurrenceRuleId, which spans the following fields:

FieldDescription
RecurrenceRuleIdPointer to recurrence rule, for recurring appointments, otherwise 0
Declaration
public Restriction IdxRecurrenceRuleId(int recurrenceRuleId)
Parameters
Type Name Description
Int32 recurrenceRuleId
Returns
Type Description
Restriction
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 .

IdxRecurrenceRuleIdActiveDate(Int32, DateTime)

Shortcut method for looking up using the database index RecurrenceRuleIdActiveDate, which spans the following fields:

FieldDescription
RecurrenceRuleIdPointer to recurrence rule, for recurring appointments, otherwise 0
ActiveDateThe date to be used for searching & showing
Declaration
public Restriction IdxRecurrenceRuleIdActiveDate(int recurrenceRuleId, DateTime activeDate)
Parameters
Type Name Description
Int32 recurrenceRuleId
DateTime activeDate
Returns
Type Description
Restriction
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 .

IdxType(AppointmentType)

Shortcut method for looking up using the database index Type, which spans the following fields:

FieldDescription
Typewhere=no start time,note,docin, docout
Declaration
public Restriction IdxType(AppointmentType type)
Parameters
Type Name Description
AppointmentType type
Returns
Type Description
Restriction
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 .

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