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(params FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(string)

TableInfo.ProtAll

TableInfo.UseNolockIfPossible

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.this[string]

TableInfo.PrimaryKeyField

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

ActiveLinks

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

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 TablesInfo.GetAppointmentInfo().

AgendaTextId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

Alarm

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

AppointmentId

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

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 TablesInfo.GetAppointmentInfo().

AssignedBy

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

AssociateId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

ColorIndex

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

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 TablesInfo.GetAppointmentInfo().

ContactId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

CreatedByWorkflowId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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
int

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

DocumentId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

EmailId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

ExternalParticipants

Field 'external_participants' in table 'appointment': Dictionary type Clob, .NET type: string

Holds external participant information in JSON format.

Declaration

public StringFieldInfo ExternalParticipants { 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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

GroupIdx

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

HasAlarm

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

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 TablesInfo.GetAppointmentInfo().

InternalNotesTextId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

InvitedPersonId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

IsMilestone

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

LagTime

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

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 TablesInfo.GetAppointmentInfo().

Leadtime

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

MotherAssociateId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

MotherId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

PersonId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

PreferredTZLocation

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

PriorityIdx

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

ProjectId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

RecurrenceRuleId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

RegisteredAssociateId

Field 'registered_associate_id' in table 'appointment': Dictionary type FK, target: Associate, .NET type: int

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

RejectCounter

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration

[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }

Property Value

Type	Description
SoTable

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetAppointmentInfo().

SaleId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

SendEmail

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

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 TablesInfo.GetAppointmentInfo().

Source

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

SuggestedAppointmentId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

SuggestedDocumentId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

TaskIdx

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

TextId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

UpdatedAssociateId

Field 'updated_associate_id' in table 'appointment': Dictionary type FK, target: Associate, .NET type: int

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

UpdatedCount

Field 'updatedCount' in table 'appointment': Dictionary type UShort, .NET type: short

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 TablesInfo.GetAppointmentInfo().

Userdef2Id

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

UserdefId

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

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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

Methods

IdxAssociateId(int)

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
int	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 TablesInfo.GetAppointmentInfo().

IdxAssociateIdActiveDate(int, 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
int	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 TablesInfo.GetAppointmentInfo().

IdxAssociateIdActiveDateMotherId(int, DateTime, int)

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
int	associateId
DateTime	activeDate
int	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 TablesInfo.GetAppointmentInfo().

IdxAssociateIdStatus(int, 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
int	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 TablesInfo.GetAppointmentInfo().

IdxAssociateIdStatusDoBy(int, 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
int	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 TablesInfo.GetAppointmentInfo().

IdxAssociateIdType(int, 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
int	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 TablesInfo.GetAppointmentInfo().

IdxAssociateIdTypeEndDate(int, 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
int	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 TablesInfo.GetAppointmentInfo().

IdxAssociateIdTypeStatus(int, 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
int	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 TablesInfo.GetAppointmentInfo().

IdxContactId(int)

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
int	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 TablesInfo.GetAppointmentInfo().

IdxMotherId(int)

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
int	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 TablesInfo.GetAppointmentInfo().

IdxMotherIdStatus(int, 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
int	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 TablesInfo.GetAppointmentInfo().

IdxMotherIdStatusActiveDate(int, 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
int	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 TablesInfo.GetAppointmentInfo().

IdxMotherIdStatusActiveDateRegisteredAssociateId(int, AppointmentStatus, DateTime, int)

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
int	motherId
AppointmentStatus	status
DateTime	activeDate
int	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 TablesInfo.GetAppointmentInfo().

IdxMotherIdStatusActiveDateRegisteredAssociateIdRegistered(int, AppointmentStatus, DateTime, int, 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
int	motherId
AppointmentStatus	status
DateTime	activeDate
int	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 TablesInfo.GetAppointmentInfo().

IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedBy(int, AppointmentStatus, DateTime, int, DateTime, int)

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
int	motherId
AppointmentStatus	status
DateTime	activeDate
int	registeredAssociateId
DateTime	registered
int	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 TablesInfo.GetAppointmentInfo().

IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdx(int, AppointmentStatus, DateTime, int, DateTime, int, int)

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
int	motherId
AppointmentStatus	status
DateTime	activeDate
int	registeredAssociateId
DateTime	registered
int	assignedBy
int	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 TablesInfo.GetAppointmentInfo().

IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType(int, AppointmentStatus, DateTime, int, DateTime, int, int, 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
int	motherId
AppointmentStatus	status
DateTime	activeDate
int	registeredAssociateId
DateTime	registered
int	assignedBy
int	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 TablesInfo.GetAppointmentInfo().

IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxTypeAssociateId(int, AppointmentStatus, DateTime, int, DateTime, int, int, AppointmentType, int)

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
int	motherId
AppointmentStatus	status
DateTime	activeDate
int	registeredAssociateId
DateTime	registered
int	assignedBy
int	groupIdx
AppointmentType	type
int	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 TablesInfo.GetAppointmentInfo().

IdxProjectId(int)

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
int	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 TablesInfo.GetAppointmentInfo().

IdxProjectIdType(int, 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
int	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 TablesInfo.GetAppointmentInfo().

IdxProjectIdTypeActiveDate(int, 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
int	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 TablesInfo.GetAppointmentInfo().

IdxProjectIdTypeActiveDateDocumentId(int, AppointmentType, DateTime, int)

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
int	projectId
AppointmentType	type
DateTime	activeDate
int	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 TablesInfo.GetAppointmentInfo().

IdxProjectIdTypeActiveDateDocumentIdAssociateId(int, AppointmentType, DateTime, int, int)

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
int	projectId
AppointmentType	type
DateTime	activeDate
int	documentId
int	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 TablesInfo.GetAppointmentInfo().

IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdx(int, AppointmentType, DateTime, int, int, int)

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
int	projectId
AppointmentType	type
DateTime	activeDate
int	documentId
int	associateId
int	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 TablesInfo.GetAppointmentInfo().

IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherId(int, AppointmentType, DateTime, int, int, int, int)

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
int	projectId
AppointmentType	type
DateTime	activeDate
int	documentId
int	associateId
int	groupIdx
int	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 TablesInfo.GetAppointmentInfo().

IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy(int, AppointmentType, DateTime, int, int, int, int, int)

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
int	projectId
AppointmentType	type
DateTime	activeDate
int	documentId
int	associateId
int	groupIdx
int	motherId
int	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 TablesInfo.GetAppointmentInfo().

IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentId(int, AppointmentType, DateTime, int, int, int, int, int, int)

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
int	projectId
AppointmentType	type
DateTime	activeDate
int	documentId
int	associateId
int	groupIdx
int	motherId
int	assignedBy
int	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 TablesInfo.GetAppointmentInfo().

IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentIdRegistered(int, AppointmentType, DateTime, int, int, int, int, int, int, 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
int	projectId
AppointmentType	type
DateTime	activeDate
int	documentId
int	associateId
int	groupIdx
int	motherId
int	assignedBy
int	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 TablesInfo.GetAppointmentInfo().

IdxRecurrenceRuleId(int)

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
int	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 TablesInfo.GetAppointmentInfo().

IdxRecurrenceRuleIdActiveDate(int, 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
int	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 TablesInfo.GetAppointmentInfo().

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 TablesInfo.GetAppointmentInfo().

Implements

ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)