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

System.Object

TableInfo

AppointmentTableInfo

Implements

System.ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(String)

TableInfo.ProtAll

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.Item[String]

TableInfo.PrimaryKeyField

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

[DatabaseTable("appointment")]
public class AppointmentTableInfo : TableInfo, ICloneable

Remarks

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

Fields

DictionaryTableName

Conceptual name of table Appointment in the database dictionary: appointment

Declaration

public const string DictionaryTableName = "appointment"

Field Value

Type	Description
System.String

Properties

ActiveDate

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

The date to be used for searching & showing

Declaration

public DateTimeFieldInfo ActiveDate { get; }

Property Value

Type	Description
DateTimeFieldInfo

ActiveLinks

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

Number of active links to documents, other appointments, and such

Declaration

public FieldInfo ActiveLinks { get; }

Property Value

Type	Description
FieldInfo

AgendaTextId

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

ID of record containing agenda text

Declaration

public Int32FieldInfo AgendaTextId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

Alarm

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

Alarm leadtime, the alarm flag has moved to hasAlarm

Declaration

public UInt16FieldInfo Alarm { get; }

Property Value

Type	Description
UInt16FieldInfo

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

AppointmentId

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

Primary key

Declaration

public Int32FieldInfo AppointmentId { get; }

Property Value

Type	Description
Int32FieldInfo

AssignedBy

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

Who (last) assigned this appointment to associate_id?

Declaration

public Int32FieldInfo AssignedBy { get; }

Property Value

Type	Description
Int32FieldInfo

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>

AssociateId

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

ID of associate whose diary the appointment is in, REQUIRED

Declaration

public Int32FieldInfo AssociateId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

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

CentralserviceVideomeetId

Field 'centralservice_videomeet_id' in table 'appointment': Dictionary type String[101], .NET type: System.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

ColorIndex

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

Appointment colour, used only in Japanese versions. Western versions take colour from Task

Declaration

public UInt16FieldInfo ColorIndex { get; }

Property Value

Type	Description
UInt16FieldInfo

ContactId

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

Contact ID of owning contact, may be 0

Declaration

public Int32FieldInfo ContactId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

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

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
System.Int32

DoBy

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

date + start time planned

Declaration

public DateTimeFieldInfo DoBy { get; }

Property Value

Type	Description
DateTimeFieldInfo

DocumentId

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

Points to document record; 0 for non-document appointments!

Declaration

public Int32FieldInfo DocumentId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

Done

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

date + start time this task was done

Declaration

public DateTimeFieldInfo Done { get; }

Property Value

Type	Description
DateTimeFieldInfo

EmailId

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

If invitation and status changes should be mailed, this is the ID of the email address used

Declaration

public Int32FieldInfo EmailId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

EndDate

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

Date + end time planned

Declaration

public DateTimeFieldInfo EndDate { get; }

Property Value

Type	Description
DateTimeFieldInfo

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

GroupIdx

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

Group of owning associate at the time tha ppnt was created

Declaration

public Int32FieldInfo GroupIdx { get; }

Property Value

Type	Description
Int32FieldInfo

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>

HasAlarm

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

Does this appointment have an alarm

Declaration

public UInt16FieldInfo HasAlarm { get; }

Property Value

Type	Description
UInt16FieldInfo

InternalNotesTextId

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

ID of record containing internal notes text

Declaration

public Int32FieldInfo InternalNotesTextId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

InvitedPersonId

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

Valid when mother_id != 0 && mother_id != id

Declaration

public Int32FieldInfo InvitedPersonId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

IsMilestone

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

Is this appointment a milestone?

Declaration

public UInt16FieldInfo IsMilestone { get; }

Property Value

Type	Description
UInt16FieldInfo

JoinVideomeetUrl

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

Blank when not a video meeting. Filled with Join Meeting URL when created.

Declaration

public StringFieldInfo JoinVideomeetUrl { get; }

Property Value

Type	Description
StringFieldInfo

LagTime

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

as leadtime, but after the end - time blocked for travel etc.

Declaration

public UInt16FieldInfo LagTime { get; }

Property Value

Type	Description
UInt16FieldInfo

Leadtime

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

Time blocked (minutes) BEFORE starttime

Declaration

public UInt16FieldInfo Leadtime { get; }

Property Value

Type	Description
UInt16FieldInfo

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

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>

Location

Field 'location' in table 'appointment': Dictionary type String[255], .NET type: System.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

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

MotherAssociateId

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

Associate/owner of the mother appointment

Declaration

public Int32FieldInfo MotherAssociateId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

MotherId

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

ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking

Declaration

public Int32FieldInfo MotherId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

OriginalStartDate

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

The original start date for an appointment in a recurring series

Declaration

public DateTimeFieldInfo OriginalStartDate { get; }

Property Value

Type	Description
DateTimeFieldInfo

PersonId

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

Person ID of person the appointment is with, may be 0

Declaration

public Int32FieldInfo PersonId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

PreferredTZLocation

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

Preferred timezone location to use when displaying/editing this appointment

Declaration

public Int32FieldInfo PreferredTZLocation { get; }

Property Value

Type	Description
Int32FieldInfo

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>

PriorityIdx

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

Link to priority list

Declaration

public Int32FieldInfo PriorityIdx { get; }

Property Value

Type	Description
Int32FieldInfo

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>

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

ProjectId

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

ID of project referred to, may be 0

Declaration

public Int32FieldInfo ProjectId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

RecurrenceRuleId

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

Pointer to recurrence rule, for recurring appointments, otherwise 0

Declaration

public Int32FieldInfo RecurrenceRuleId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

Registered

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

Registered date

Declaration

public DateTimeFieldInfo Registered { get; }

Property Value

Type	Description
DateTimeFieldInfo

RegisteredAssociateId

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

Registered by whom

Declaration

public Int32FieldInfo RegisteredAssociateId { get; }

Property Value

Type	Description
Int32FieldInfo

RegisteredAssociateId_InnerJoin_Associate

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

Declaration

public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }

Property Value

Type	Description
TargetedInnerJoin<AssociateTableInfo>

RejectCounter

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

How many invitees have rejected this appointment

Declaration

public UInt16FieldInfo RejectCounter { get; }

Property Value

Type	Description
UInt16FieldInfo

RejectReason

Field 'rejectReason' in table 'appointment': Dictionary type String[255], .NET type: System.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

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration

public static SoTable RuntimeDefinition { get; }

Property Value

Type	Description
SoTable

SaleId

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

Owning sale, if any (may be 0)

Declaration

public Int32FieldInfo SaleId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

SendEmail

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

Send invitation and appointment changes by e-mail to this participant.

Declaration

public UInt16FieldInfo SendEmail { get; }

Property Value

Type	Description
UInt16FieldInfo

Source

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

For future integration use; source of record

Declaration

public UInt16FieldInfo Source { get; }

Property Value

Type	Description
UInt16FieldInfo

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

SuggestedAppointmentId

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

Suggested guide item that this appointment is an instance of (Note: NOT VALID for document-type appointments, they have their own link)

Declaration

public Int32FieldInfo SuggestedAppointmentId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

SuggestedDocumentId

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

Suggested guide item that this document is an instance of (Note: NOT valid for appointments, they have their own link)

Declaration

public Int32FieldInfo SuggestedDocumentId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

TaskIdx

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

Link to Task list, OR to DocTmpl list, if this is a document

Declaration

public Int32FieldInfo TaskIdx { get; }

Property Value

Type	Description
Int32FieldInfo

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>

TextId

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

ID of record containing appointment text

Declaration

public Int32FieldInfo TextId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

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

Updated

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

Updated date

Declaration

public DateTimeFieldInfo Updated { get; }

Property Value

Type	Description
DateTimeFieldInfo

UpdatedAssociateId

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

Updated by who

Declaration

public Int32FieldInfo UpdatedAssociateId { get; }

Property Value

Type	Description
Int32FieldInfo

UpdatedAssociateId_InnerJoin_Associate

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

Declaration

public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }

Property Value

Type	Description
TargetedInnerJoin<AssociateTableInfo>

UpdatedCount

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

Number of updates made to this record

Declaration

public UInt16FieldInfo UpdatedCount { get; }

Property Value

Type	Description
UInt16FieldInfo

Userdef2Id

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

User defined table record 2 (for future use)

Declaration

public Int32FieldInfo Userdef2Id { get; }

Property Value

Type	Description
Int32FieldInfo

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>

UserdefId

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

User defined table record 1 (for future use)

Declaration

public Int32FieldInfo UserdefId { get; }

Property Value

Type	Description
Int32FieldInfo

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>

Methods

IdxAssociateId(Int32)

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

Field	Description
AssociateId	ID of associate whose diary the appointment is in, REQUIRED

Declaration

public Restriction IdxAssociateId(int associateId)

Parameters

Type	Name	Description
System.Int32	associateId

Returns

Type	Description
Restriction

IdxAssociateIdActiveDate(Int32, DateTime)

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

Field	Description
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
ActiveDate	The date to be used for searching & showing

Declaration

public Restriction IdxAssociateIdActiveDate(int associateId, DateTime activeDate)

Parameters

Type	Name	Description
System.Int32	associateId
System.DateTime	activeDate

Returns

Type	Description
Restriction

IdxAssociateIdActiveDateMotherId(Int32, DateTime, Int32)

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

Field	Description
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
ActiveDate	The date to be used for searching & showing
MotherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking

Declaration

public Restriction IdxAssociateIdActiveDateMotherId(int associateId, DateTime activeDate, int motherId)

Parameters

Type	Name	Description
System.Int32	associateId
System.DateTime	activeDate
System.Int32	motherId

Returns

Type	Description
Restriction

IdxAssociateIdStatus(Int32, AppointmentStatus)

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

Field	Description
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
Status	status=done,started, not started, hidden

Declaration

public Restriction IdxAssociateIdStatus(int associateId, AppointmentStatus status)

Parameters

Type	Name	Description
System.Int32	associateId
AppointmentStatus	status

Returns

Type	Description
Restriction

IdxAssociateIdStatusDoBy(Int32, AppointmentStatus, DateTime)

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

Field	Description
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
Status	status=done,started, not started, hidden
DoBy	date + start time planned

Declaration

public Restriction IdxAssociateIdStatusDoBy(int associateId, AppointmentStatus status, DateTime doBy)

Parameters

Type	Name	Description
System.Int32	associateId
AppointmentStatus	status
System.DateTime	doBy

Returns

Type	Description
Restriction

IdxAssociateIdType(Int32, AppointmentType)

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

Field	Description
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
Type	where=no start time,note,docin, docout

Declaration

public Restriction IdxAssociateIdType(int associateId, AppointmentType type)

Parameters

Type	Name	Description
System.Int32	associateId
AppointmentType	type

Returns

Type	Description
Restriction

IdxAssociateIdTypeEndDate(Int32, AppointmentType, DateTime)

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

Field	Description
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
Type	where=no start time,note,docin, docout
EndDate	Date + end time planned

Declaration

public Restriction IdxAssociateIdTypeEndDate(int associateId, AppointmentType type, DateTime endDate)

Parameters

Type	Name	Description
System.Int32	associateId
AppointmentType	type
System.DateTime	endDate

Returns

Type	Description
Restriction

IdxAssociateIdTypeStatus(Int32, AppointmentType, AppointmentStatus)

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

Field	Description
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
Type	where=no start time,note,docin, docout
Status	status=done,started, not started, hidden

Declaration

public Restriction IdxAssociateIdTypeStatus(int associateId, AppointmentType type, AppointmentStatus status)

Parameters

Type	Name	Description
System.Int32	associateId
AppointmentType	type
AppointmentStatus	status

Returns

Type	Description
Restriction

IdxContactId(Int32)

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

Field	Description
ContactId	Contact ID of owning contact, may be 0

Declaration

public Restriction IdxContactId(int contactId)

Parameters

Type	Name	Description
System.Int32	contactId

Returns

Type	Description
Restriction

IdxMotherId(Int32)

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

Field	Description
MotherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking

Declaration

public Restriction IdxMotherId(int motherId)

Parameters

Type	Name	Description
System.Int32	motherId

Returns

Type	Description
Restriction

IdxMotherIdStatus(Int32, AppointmentStatus)

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

Field	Description
MotherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Status	status=done,started, not started, hidden

Declaration

public Restriction IdxMotherIdStatus(int motherId, AppointmentStatus status)

Parameters

Type	Name	Description
System.Int32	motherId
AppointmentStatus	status

Returns

Type	Description
Restriction

IdxMotherIdStatusActiveDate(Int32, AppointmentStatus, DateTime)

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

Field	Description
MotherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Status	status=done,started, not started, hidden
ActiveDate	The date to be used for searching & showing

Declaration

public Restriction IdxMotherIdStatusActiveDate(int motherId, AppointmentStatus status, DateTime activeDate)

Parameters

Type	Name	Description
System.Int32	motherId
AppointmentStatus	status
System.DateTime	activeDate

Returns

Type	Description
Restriction

IdxMotherIdStatusActiveDateRegisteredAssociateId(Int32, AppointmentStatus, DateTime, Int32)

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

Field	Description
MotherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Status	status=done,started, not started, hidden
ActiveDate	The date to be used for searching & showing
RegisteredAssociateId	Registered by whom

Declaration

public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateId(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId)

Parameters

Type	Name	Description
System.Int32	motherId
AppointmentStatus	status
System.DateTime	activeDate
System.Int32	registeredAssociateId

Returns

Type	Description
Restriction

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

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

Field	Description
MotherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Status	status=done,started, not started, hidden
ActiveDate	The date to be used for searching & showing
RegisteredAssociateId	Registered by whom
Registered	Registered date

Declaration

public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegistered(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered)

Parameters

Type	Name	Description
System.Int32	motherId
AppointmentStatus	status
System.DateTime	activeDate
System.Int32	registeredAssociateId
System.DateTime	registered

Returns

Type	Description
Restriction

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

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

Field	Description
MotherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Status	status=done,started, not started, hidden
ActiveDate	The date to be used for searching & showing
RegisteredAssociateId	Registered by whom
Registered	Registered date
AssignedBy	Who (last) assigned this appointment to associate_id?

Declaration

public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedBy(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy)

Parameters

Type	Name	Description
System.Int32	motherId
AppointmentStatus	status
System.DateTime	activeDate
System.Int32	registeredAssociateId
System.DateTime	registered
System.Int32	assignedBy

Returns

Type	Description
Restriction

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

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

Field	Description
MotherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Status	status=done,started, not started, hidden
ActiveDate	The date to be used for searching & showing
RegisteredAssociateId	Registered by whom
Registered	Registered date
AssignedBy	Who (last) assigned this appointment to associate_id?
GroupIdx	Group of owning associate at the time tha ppnt was created

Declaration

public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdx(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy, int groupIdx)

Parameters

Type	Name	Description
System.Int32	motherId
AppointmentStatus	status
System.DateTime	activeDate
System.Int32	registeredAssociateId
System.DateTime	registered
System.Int32	assignedBy
System.Int32	groupIdx

Returns

Type	Description
Restriction

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

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

Field	Description
MotherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Status	status=done,started, not started, hidden
ActiveDate	The date to be used for searching & showing
RegisteredAssociateId	Registered by whom
Registered	Registered date
AssignedBy	Who (last) assigned this appointment to associate_id?
GroupIdx	Group of owning associate at the time tha ppnt was created
Type	where=no start time,note,docin, docout

Declaration

public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy, int groupIdx, AppointmentType type)

Parameters

Type	Name	Description
System.Int32	motherId
AppointmentStatus	status
System.DateTime	activeDate
System.Int32	registeredAssociateId
System.DateTime	registered
System.Int32	assignedBy
System.Int32	groupIdx
AppointmentType	type

Returns

Type	Description
Restriction

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

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

Field	Description
MotherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
Status	status=done,started, not started, hidden
ActiveDate	The date to be used for searching & showing
RegisteredAssociateId	Registered by whom
Registered	Registered date
AssignedBy	Who (last) assigned this appointment to associate_id?
GroupIdx	Group of owning associate at the time tha ppnt was created
Type	where=no start time,note,docin, docout
AssociateId	ID of associate whose diary the appointment is in, REQUIRED

Declaration

public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxTypeAssociateId(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy, int groupIdx, AppointmentType type, int associateId)

Parameters

Type	Name	Description
System.Int32	motherId
AppointmentStatus	status
System.DateTime	activeDate
System.Int32	registeredAssociateId
System.DateTime	registered
System.Int32	assignedBy
System.Int32	groupIdx
AppointmentType	type
System.Int32	associateId

Returns

Type	Description
Restriction

IdxProjectId(Int32)

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

Field	Description
ProjectId	ID of project referred to, may be 0

Declaration

public Restriction IdxProjectId(int projectId)

Parameters

Type	Name	Description
System.Int32	projectId

Returns

Type	Description
Restriction

IdxProjectIdType(Int32, AppointmentType)

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

Field	Description
ProjectId	ID of project referred to, may be 0
Type	where=no start time,note,docin, docout

Declaration

public Restriction IdxProjectIdType(int projectId, AppointmentType type)

Parameters

Type	Name	Description
System.Int32	projectId
AppointmentType	type

Returns

Type	Description
Restriction

IdxProjectIdTypeActiveDate(Int32, AppointmentType, DateTime)

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

Field	Description
ProjectId	ID of project referred to, may be 0
Type	where=no start time,note,docin, docout
ActiveDate	The date to be used for searching & showing

Declaration

public Restriction IdxProjectIdTypeActiveDate(int projectId, AppointmentType type, DateTime activeDate)

Parameters

Type	Name	Description
System.Int32	projectId
AppointmentType	type
System.DateTime	activeDate

Returns

Type	Description
Restriction

IdxProjectIdTypeActiveDateDocumentId(Int32, AppointmentType, DateTime, Int32)

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

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

Declaration

public Restriction IdxProjectIdTypeActiveDateDocumentId(int projectId, AppointmentType type, DateTime activeDate, int documentId)

Parameters

Type	Name	Description
System.Int32	projectId
AppointmentType	type
System.DateTime	activeDate
System.Int32	documentId

Returns

Type	Description
Restriction

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

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

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

Declaration

public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateId(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId)

Parameters

Type	Name	Description
System.Int32	projectId
AppointmentType	type
System.DateTime	activeDate
System.Int32	documentId
System.Int32	associateId

Returns

Type	Description
Restriction

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

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

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

Declaration

public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdx(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx)

Parameters

Type	Name	Description
System.Int32	projectId
AppointmentType	type
System.DateTime	activeDate
System.Int32	documentId
System.Int32	associateId
System.Int32	groupIdx

Returns

Type	Description
Restriction

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

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

Field	Description
ProjectId	ID of project referred to, may be 0
Type	where=no start time,note,docin, docout
ActiveDate	The date to be used for searching & showing
DocumentId	Points to document record; 0 for non-document appointments!
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
GroupIdx	Group of owning associate at the time tha ppnt was created
MotherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking

Declaration

public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherId(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId)

Parameters

Type	Name	Description
System.Int32	projectId
AppointmentType	type
System.DateTime	activeDate
System.Int32	documentId
System.Int32	associateId
System.Int32	groupIdx
System.Int32	motherId

Returns

Type	Description
Restriction

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

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

Field	Description
ProjectId	ID of project referred to, may be 0
Type	where=no start time,note,docin, docout
ActiveDate	The date to be used for searching & showing
DocumentId	Points to document record; 0 for non-document appointments!
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
GroupIdx	Group of owning associate at the time tha ppnt was created
MotherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
AssignedBy	Who (last) assigned this appointment to associate_id?

Declaration

public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId, int assignedBy)

Parameters

Type	Name	Description
System.Int32	projectId
AppointmentType	type
System.DateTime	activeDate
System.Int32	documentId
System.Int32	associateId
System.Int32	groupIdx
System.Int32	motherId
System.Int32	assignedBy

Returns

Type	Description
Restriction

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

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

Field	Description
ProjectId	ID of project referred to, may be 0
Type	where=no start time,note,docin, docout
ActiveDate	The date to be used for searching & showing
DocumentId	Points to document record; 0 for non-document appointments!
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
GroupIdx	Group of owning associate at the time tha ppnt was created
MotherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
AssignedBy	Who (last) assigned this appointment to associate_id?
AppointmentId	Primary key

Declaration

public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentId(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId, int assignedBy, int appointmentId)

Parameters

Type	Name	Description
System.Int32	projectId
AppointmentType	type
System.DateTime	activeDate
System.Int32	documentId
System.Int32	associateId
System.Int32	groupIdx
System.Int32	motherId
System.Int32	assignedBy
System.Int32	appointmentId

Returns

Type	Description
Restriction

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

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

Field	Description
ProjectId	ID of project referred to, may be 0
Type	where=no start time,note,docin, docout
ActiveDate	The date to be used for searching & showing
DocumentId	Points to document record; 0 for non-document appointments!
AssociateId	ID of associate whose diary the appointment is in, REQUIRED
GroupIdx	Group of owning associate at the time tha ppnt was created
MotherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking
AssignedBy	Who (last) assigned this appointment to associate_id?
AppointmentId	Primary key
Registered	Registered date

Declaration

public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentIdRegistered(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId, int assignedBy, int appointmentId, DateTime registered)

Parameters

Type	Name	Description
System.Int32	projectId
AppointmentType	type
System.DateTime	activeDate
System.Int32	documentId
System.Int32	associateId
System.Int32	groupIdx
System.Int32	motherId
System.Int32	assignedBy
System.Int32	appointmentId
System.DateTime	registered

Returns

Type	Description
Restriction

IdxRecurrenceRuleId(Int32)

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

Field	Description
RecurrenceRuleId	Pointer to recurrence rule, for recurring appointments, otherwise 0

Declaration

public Restriction IdxRecurrenceRuleId(int recurrenceRuleId)

Parameters

Type	Name	Description
System.Int32	recurrenceRuleId

Returns

Type	Description
Restriction

IdxRecurrenceRuleIdActiveDate(Int32, DateTime)

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

Field	Description
RecurrenceRuleId	Pointer to recurrence rule, for recurring appointments, otherwise 0
ActiveDate	The date to be used for searching & showing

Declaration

public Restriction IdxRecurrenceRuleIdActiveDate(int recurrenceRuleId, DateTime activeDate)

Parameters

Type	Name	Description
System.Int32	recurrenceRuleId
System.DateTime	activeDate

Returns

Type	Description
Restriction

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

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)