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:

Field	Description
AssociateId	ID 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:

Field	Description
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
ActiveDate	The 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:

Field	Description
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
ActiveDate	The date to be used for searching & showing
MotherId	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 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:

Field	Description
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
Status	status=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:

Field	Description
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
Status	status=done,started, not started, hidden
DoBy	date + 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:

Field	Description
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
Type	where=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:

Field	Description
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
Type	where=no start time,note,docin, docout
EndDate	Date + 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:

Field	Description
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
Type	where=no start time,note,docin, docout
Status	status=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:

Field	Description
ContactId	Contact 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:

Field	Description
MotherId	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 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:

Field	Description
MotherId	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
Status	status=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:

Field	Description
MotherId	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
Status	status=done,started, not started, hidden
ActiveDate	The 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:

Field	Description
MotherId	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
Status	status=done,started, not started, hidden
ActiveDate	The date to be used for searching & showing
RegisteredAssociateId	Registered 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:

Field	Description
MotherId	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
Status	status=done,started, not started, hidden
ActiveDate	The date to be used for searching & showing
RegisteredAssociateId	Registered by whom
Registered	Registered 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:

Field	Description
MotherId	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
Status	status=done,started, not started, hidden
ActiveDate	The date to be used for searching & showing
RegisteredAssociateId	Registered by whom
Registered	Registered date
AssignedBy	Who (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:

Field	Description
MotherId	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
Status	status=done,started, not started, hidden
ActiveDate	The date to be used for searching & showing
RegisteredAssociateId	Registered by whom
Registered	Registered date
AssignedBy	Who (last) assigned this appointment to associate_id?
GroupIdx	Group 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:

Field	Description
MotherId	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
Status	status=done,started, not started, hidden
ActiveDate	The date to be used for searching & showing
RegisteredAssociateId	Registered by whom
Registered	Registered date
AssignedBy	Who (last) assigned this appointment to associate_id?
GroupIdx	Group of owning associate at the time tha ppnt was created
Type	where=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:

Field	Description
MotherId	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
Status	status=done,started, not started, hidden
ActiveDate	The date to be used for searching & showing
RegisteredAssociateId	Registered by whom
Registered	Registered date
AssignedBy	Who (last) assigned this appointment to associate_id?
GroupIdx	Group of owning associate at the time tha ppnt was created
Type	where=no start time,note,docin, docout
AssociateId	ID 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:

Field	Description
ProjectId	ID 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:

Field	Description
ProjectId	ID of project referred to, may be 0
Type	where=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:

Field	Description
ProjectId	ID of project referred to, may be 0
Type	where=no start time,note,docin, docout
ActiveDate	The 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:

Field	Description
ProjectId	ID of project referred to, may be 0
Type	where=no start time,note,docin, docout
ActiveDate	The date to be used for searching & showing
DocumentId	Points 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:

Field	Description
ProjectId	ID of project referred to, may be 0
Type	where=no start time,note,docin, docout
ActiveDate	The date to be used for searching & showing
DocumentId	Points to document record; 0 for non-document appointments!
AssociateId	ID 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:

Field	Description
ProjectId	ID of project referred to, may be 0
Type	where=no start time,note,docin, docout
ActiveDate	The date to be used for searching & showing
DocumentId	Points to document record; 0 for non-document appointments!
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
GroupIdx	Group 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:

Field	Description
ProjectId	ID of project referred to, may be 0
Type	where=no start time,note,docin, docout
ActiveDate	The date to be used for searching & showing
DocumentId	Points to document record; 0 for non-document appointments!
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
GroupIdx	Group of owning associate at the time tha ppnt was created
MotherId	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 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:

Field	Description
ProjectId	ID of project referred to, may be 0
Type	where=no start time,note,docin, docout
ActiveDate	The date to be used for searching & showing
DocumentId	Points to document record; 0 for non-document appointments!
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
GroupIdx	Group of owning associate at the time tha ppnt was created
MotherId	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
AssignedBy	Who (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:

Field	Description
ProjectId	ID of project referred to, may be 0
Type	where=no start time,note,docin, docout
ActiveDate	The date to be used for searching & showing
DocumentId	Points to document record; 0 for non-document appointments!
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
GroupIdx	Group of owning associate at the time tha ppnt was created
MotherId	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
AssignedBy	Who (last) assigned this appointment to associate_id?
AppointmentId	Primary 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:

Field	Description
ProjectId	ID of project referred to, may be 0
Type	where=no start time,note,docin, docout
ActiveDate	The date to be used for searching & showing
DocumentId	Points to document record; 0 for non-document appointments!
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
GroupIdx	Group of owning associate at the time tha ppnt was created
MotherId	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
AssignedBy	Who (last) assigned this appointment to associate_id?
AppointmentId	Primary key
Registered	Registered 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:

Field	Description
RecurrenceRuleId	Pointer 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:

Field	Description
RecurrenceRuleId	Pointer to recurrence rule, for recurring appointments, otherwise 0
ActiveDate	The 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:

Field	Description
Type	where=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)