Show / Hide Table of Contents

Class AppointmentTableInfo

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

Inheritance
Object
TableInfo
AppointmentTableInfo
Implements
ICloneable
Inherited Members
TableInfo.ToString()
TableInfo.RegisterFields(FieldInfo[])
TableInfo.FieldInfoFromSoField(SoField)
TableInfo.Clone()
TableInfo.IsSameTable(TableInfo)
TableInfo.FindField(String)
TableInfo.ProtAll
TableInfo.HashCheckFields
TableInfo.TableName
TableInfo.DbName
TableInfo.IsDictionaryTable
TableInfo.All
TableInfo.Item[String]
TableInfo.PrimaryKeyField
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 .

Fields

DictionaryTableName

Conceptual name of table Appointment in the database dictionary: appointment

Declaration
public const string DictionaryTableName = "appointment"
Field Value
Type Description
String

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

ActiveLinks

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

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

Declaration
public FieldInfo ActiveLinks { get; }
Property Value
Type Description
FieldInfo

Alarm

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

Alarm leadtime, the alarm flag has moved to hasAlarm

Declaration
public UInt16FieldInfo Alarm { get; }
Property Value
Type Description
UInt16FieldInfo

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: Int32

Primary key

Declaration
public Int32FieldInfo AppointmentId { get; }
Property Value
Type Description
Int32FieldInfo

AssignedBy

Field 'assignedBy' in table 'appointment': Dictionary type FK, .NET type: 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, .NET type: 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: 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: 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, .NET type: 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
Int32

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

DocumentId

Field 'document_id' in table 'appointment': Dictionary type FK, .NET type: 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: 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, .NET type: Int32

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

Declaration
public Int32FieldInfo EmailId { get; }
Property Value
Type Description
Int32FieldInfo

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: 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, .NET type: 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: Int16

Does this appointment have an alarm

Declaration
public UInt16FieldInfo HasAlarm { get; }
Property Value
Type Description
UInt16FieldInfo

InvitedPersonId

Field 'invitedPersonId' in table 'appointment': Dictionary type FK, .NET type: 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: 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: 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: 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: 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: 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

MotherAssociateId

Field 'mother_associate_id' in table 'appointment': Dictionary type FK, .NET type: 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, .NET type: Int32

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

Declaration
public Int32FieldInfo MotherId { get; }
Property Value
Type Description
Int32FieldInfo

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: 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, .NET type: 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, .NET type: 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, .NET type: 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, .NET type: 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, .NET type: 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: DateTime

Registered date

Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type Description
DateTimeFieldInfo

RegisteredAssociateId

Field 'registered_associate_id' in table 'appointment': Dictionary type FK, .NET type: 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: 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: 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
[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }
Property Value
Type Description
SoTable

SaleId

Field 'sale_id' in table 'appointment': Dictionary type FK, .NET type: 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>

Source

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

For future integration use; source of record

Declaration
public UInt16FieldInfo Source { get; }
Property Value
Type Description
UInt16FieldInfo

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, .NET type: Int32

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

Declaration
public Int32FieldInfo SuggestedAppointmentId { get; }
Property Value
Type Description
Int32FieldInfo

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, .NET type: Int32

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

Declaration
public Int32FieldInfo SuggestedDocumentId { get; }
Property Value
Type Description
Int32FieldInfo

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, .NET type: Int32

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

Declaration
public Int32FieldInfo TaskIdx { get; }
Property Value
Type Description
Int32FieldInfo

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, .NET type: 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: DateTime

Updated date

Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type Description
DateTimeFieldInfo

UpdatedAssociateId

Field 'updated_associate_id' in table 'appointment': Dictionary type FK, .NET type: 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: 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, .NET type: 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, .NET type: 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:

FieldDescription
AssociateIdID of associate whose diary the appointment is in, REQUIRED
Declaration
public Restriction IdxAssociateId(int associateId)
Parameters
Type Name Description
Int32 associateId
Returns
Type Description
Restriction

IdxAssociateIdActiveDate(Int32, DateTime)

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

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

IdxAssociateIdActiveDateMotherId(Int32, DateTime, Int32)

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

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

IdxAssociateIdType(Int32, AppointmentType)

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

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

IdxAssociateIdTypeEndDate(Int32, AppointmentType, DateTime)

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

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

IdxAssociateIdTypeStatus(Int32, AppointmentType, AppointmentStatus)

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

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

IdxContactId(Int32)

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

FieldDescription
ContactIdContact ID of owning contact, may be 0
Declaration
public Restriction IdxContactId(int contactId)
Parameters
Type Name Description
Int32 contactId
Returns
Type Description
Restriction

IdxMotherId(Int32)

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

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

IdxMotherIdStatus(Int32, AppointmentStatus)

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

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

IdxMotherIdStatusActiveDate(Int32, AppointmentStatus, DateTime)

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

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

IdxMotherIdStatusActiveDateRegisteredAssociateId(Int32, AppointmentStatus, DateTime, Int32)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

IdxProjectId(Int32)

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

FieldDescription
ProjectIdID of project referred to, may be 0
Declaration
public Restriction IdxProjectId(int projectId)
Parameters
Type Name Description
Int32 projectId
Returns
Type Description
Restriction

IdxProjectIdType(Int32, AppointmentType)

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

FieldDescription
ProjectIdID of project referred to, may be 0
Typewhere=no start time,note,docin, docout
Declaration
public Restriction IdxProjectIdType(int projectId, AppointmentType type)
Parameters
Type Name Description
Int32 projectId
AppointmentType type
Returns
Type Description
Restriction

IdxProjectIdTypeActiveDate(Int32, AppointmentType, DateTime)

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

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

IdxProjectIdTypeActiveDateDocumentId(Int32, AppointmentType, DateTime, Int32)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

IdxRecurrenceRuleId(Int32)

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

FieldDescription
RecurrenceRuleIdPointer to recurrence rule, for recurring appointments, otherwise 0
Declaration
public Restriction IdxRecurrenceRuleId(int recurrenceRuleId)
Parameters
Type Name Description
Int32 recurrenceRuleId
Returns
Type Description
Restriction

IdxRecurrenceRuleIdActiveDate(Int32, DateTime)

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

FieldDescription
RecurrenceRuleIdPointer to recurrence rule, for recurring appointments, otherwise 0
ActiveDateThe date to be used for searching & showing
Declaration
public Restriction IdxRecurrenceRuleIdActiveDate(int recurrenceRuleId, DateTime activeDate)
Parameters
Type Name Description
Int32 recurrenceRuleId
DateTime activeDate
Returns
Type Description
Restriction

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)
Converters.MapEnums<From, To>(From)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top