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.
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("appointment")]
public class AppointmentTableInfo : TableInfo, ICloneable
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Fields
DictionaryTableName
Conceptual name of table Appointment in the database dictionary: appointment
Declaration
public const string DictionaryTableName = "appointment"
Field Value
Type | Description |
---|---|
String |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Properties
ActiveDate
Field 'activeDate' in table 'appointment': Dictionary type DateTime, .NET type: DateTime
The date to be used for searching & showingDeclaration
public DateTimeFieldInfo ActiveDate { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
ActiveLinks
Field 'activeLinks' in table 'appointment': Dictionary type UInt, .NET type: UInt32
Number of active links to documents, other appointments, and suchDeclaration
public FieldInfo ActiveLinks { get; }
Property Value
Type | Description |
---|---|
FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
AgendaTextId
Field 'agenda_text_id' in table 'appointment': Dictionary type FK, target: Text, .NET type: Int32
ID of record containing agenda textDeclaration
public Int32FieldInfo AgendaTextId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
AgendaTextId_InnerJoin_Text
Generated join from the foreign key AgendaTextId in this table, to its target table TextTableInfo.
Declaration
public TargetedInnerJoin<TextTableInfo> AgendaTextId_InnerJoin_Text { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<TextTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Alarm
Field 'alarm' in table 'appointment': Dictionary type UShort, .NET type: Int16
Alarm leadtime, the alarm flag has moved to hasAlarmDeclaration
public UInt16FieldInfo Alarm { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
AlldayEvent
Field 'alldayEvent' in table 'appointment': Dictionary type Enum, .NET type: AllDayEvent
Is this an all day event: 0 = No, 1 = YesDeclaration
public AllDayEventFieldInfo AlldayEvent { get; }
Property Value
Type | Description |
---|---|
AllDayEventFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
AppointmentId
Field 'appointment_id' in table 'appointment': Dictionary type PK, .NET type: Int32
Primary keyDeclaration
public Int32FieldInfo AppointmentId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
AssignedBy
Field 'assignedBy' in table 'appointment': Dictionary type FK, target: Associate, .NET type: Int32
Who (last) assigned this appointment to associate_id?Declaration
public Int32FieldInfo AssignedBy { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
AssignedBy_InnerJoin_Associate
Generated join from the foreign key AssignedBy in this table, to its target table AssociateTableInfo.
Declaration
public TargetedInnerJoin<AssociateTableInfo> AssignedBy_InnerJoin_Associate { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<AssociateTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
AssociateId
Field 'associate_id' in table 'appointment': Dictionary type FK, target: Associate, .NET type: Int32
ID of associate whose diary the appointment is in, REQUIREDDeclaration
public Int32FieldInfo AssociateId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
AssociateId_InnerJoin_Associate
Generated join from the foreign key AssociateId in this table, to its target table AssociateTableInfo.
Declaration
public TargetedInnerJoin<AssociateTableInfo> AssociateId_InnerJoin_Associate { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<AssociateTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
CautionWarning
Field 'cautionWarning' in table 'appointment': Dictionary type Enum, .NET type: AppointmentCautionWarning
Status field to indicate appointments that have some sort of problemDeclaration
public AppointmentCautionWarningFieldInfo CautionWarning { get; }
Property Value
Type | Description |
---|---|
AppointmentCautionWarningFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
CentralserviceVideomeetId
Field 'centralservice_videomeet_id' in table 'appointment': Dictionary type String[101], .NET type: String
GUID for video meeting in central services – this is set when we create meetings from SuperOffice. It is blank for incoming meetings created from inbox.Declaration
public StringFieldInfo CentralserviceVideomeetId { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
ColorIndex
Field 'color_index' in table 'appointment': Dictionary type UShort, .NET type: Int16
Appointment colour, used only in Japanese versions. Western versions take colour from TaskDeclaration
public UInt16FieldInfo ColorIndex { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
ContactId
Field 'contact_id' in table 'appointment': Dictionary type FK, target: Contact, .NET type: Int32
Contact ID of owning contact, may be 0Declaration
public Int32FieldInfo ContactId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
ContactId_InnerJoin_Contact
Generated join from the foreign key ContactId in this table, to its target table ContactTableInfo.
Declaration
public TargetedInnerJoin<ContactTableInfo> ContactId_InnerJoin_Contact { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<ContactTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
CreatedByWorkflowId
Field 'created_by_workflow_id' in table 'appointment': Dictionary type FK, target: Workflow, .NET type: Int32
The workflow this follow-up was created byDeclaration
public Int32FieldInfo CreatedByWorkflowId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
CreatedByWorkflowId_InnerJoin_Workflow
Generated join from the foreign key CreatedByWorkflowId in this table, to its target table WorkflowTableInfo.
Declaration
public TargetedInnerJoin<WorkflowTableInfo> CreatedByWorkflowId_InnerJoin_Workflow { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<WorkflowTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Overrides
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
DictionaryTableNumber
Table number for table Appointment in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database
Declaration
public int DictionaryTableNumber { get; }
Property Value
Type | Description |
---|---|
Int32 |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
DoBy
Field 'do_by' in table 'appointment': Dictionary type DateTime, .NET type: DateTime
date + start time plannedDeclaration
public DateTimeFieldInfo DoBy { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
DocumentId
Field 'document_id' in table 'appointment': Dictionary type FK, target: Document, .NET type: Int32
Points to document record; 0 for non-document appointments!Declaration
public Int32FieldInfo DocumentId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
DocumentId_InnerJoin_Document
Generated join from the foreign key DocumentId in this table, to its target table DocumentTableInfo.
Declaration
public TargetedInnerJoin<DocumentTableInfo> DocumentId_InnerJoin_Document { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<DocumentTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Done
Field 'done' in table 'appointment': Dictionary type DateTime, .NET type: DateTime
date + start time this task was doneDeclaration
public DateTimeFieldInfo Done { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
EmailId
Field 'emailId' in table 'appointment': Dictionary type FK, target: Email, .NET type: Int32
If invitation and status changes should be mailed, this is the ID of the email address usedDeclaration
public Int32FieldInfo EmailId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
EmailId_InnerJoin_Email
Generated join from the foreign key EmailId in this table, to its target table EmailTableInfo.
Declaration
public TargetedInnerJoin<EmailTableInfo> EmailId_InnerJoin_Email { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<EmailTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
EndDate
Field 'endDate' in table 'appointment': Dictionary type DateTime, .NET type: DateTime
Date + end time plannedDeclaration
public DateTimeFieldInfo EndDate { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
FreeBusy
Field 'freeBusy' in table 'appointment': Dictionary type Enum, .NET type: FreeBusy
What kind of time is this: 0 = Busy, 1 = FreeDeclaration
public FreeBusyFieldInfo FreeBusy { get; }
Property Value
Type | Description |
---|---|
FreeBusyFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
GroupIdx
Field 'group_idx' in table 'appointment': Dictionary type FK, target: UserGroup, .NET type: Int32
Group of owning associate at the time tha ppnt was createdDeclaration
public Int32FieldInfo GroupIdx { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
GroupIdx_InnerJoin_UserGroup
Generated join from the foreign key GroupIdx in this table, to its target table UserGroupTableInfo.
Declaration
public TargetedInnerJoin<UserGroupTableInfo> GroupIdx_InnerJoin_UserGroup { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<UserGroupTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
HasAlarm
Field 'hasAlarm' in table 'appointment': Dictionary type Bool, .NET type: Int16
Does this appointment have an alarmDeclaration
public UInt16FieldInfo HasAlarm { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
InternalNotesTextId
Field 'internal_notes_text_id' in table 'appointment': Dictionary type FK, target: Text, .NET type: Int32
ID of record containing internal notes textDeclaration
public Int32FieldInfo InternalNotesTextId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
InternalNotesTextId_InnerJoin_Text
Generated join from the foreign key InternalNotesTextId in this table, to its target table TextTableInfo.
Declaration
public TargetedInnerJoin<TextTableInfo> InternalNotesTextId_InnerJoin_Text { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<TextTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
InvitedPersonId
Field 'invitedPersonId' in table 'appointment': Dictionary type FK, target: Person, .NET type: Int32
Valid when mother_id != 0 && mother_id != idDeclaration
public Int32FieldInfo InvitedPersonId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
InvitedPersonId_InnerJoin_Person
Generated join from the foreign key InvitedPersonId in this table, to its target table PersonTableInfo.
Declaration
public TargetedInnerJoin<PersonTableInfo> InvitedPersonId_InnerJoin_Person { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<PersonTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IsMilestone
Field 'isMilestone' in table 'appointment': Dictionary type Bool, .NET type: Int16
Is this appointment a milestone?Declaration
public UInt16FieldInfo IsMilestone { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
JoinVideomeetUrl
Field 'join_videomeet_url' in table 'appointment': Dictionary type String[2001], .NET type: String
Blank when not a video meeting. Filled with Join Meeting URL when created.Declaration
public StringFieldInfo JoinVideomeetUrl { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LagTime
Field 'lagTime' in table 'appointment': Dictionary type UShort, .NET type: Int16
as leadtime, but after the end - time blocked for travel etc.Declaration
public UInt16FieldInfo LagTime { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Leadtime
Field 'leadtime' in table 'appointment': Dictionary type UShort, .NET type: Int16
Time blocked (minutes) BEFORE starttimeDeclaration
public UInt16FieldInfo Leadtime { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_Document_AppointmentId
Generated left outer join from the primary key AppointmentId on this table, to Document.AppointmentId.
Declaration
public TargetedLeftOuterJoin<DocumentTableInfo> LeftOuterJoin_Document_AppointmentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<DocumentTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_Email_AppointmentId
Generated left outer join from the primary key AppointmentId on this table, to Email.AppointmentId.
Declaration
public TargetedLeftOuterJoin<EmailTableInfo> LeftOuterJoin_Email_AppointmentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<EmailTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_EmailItem_AppointmentId
Generated left outer join from the primary key AppointmentId on this table, to EmailItem.AppointmentId.
Declaration
public TargetedLeftOuterJoin<EmailItemTableInfo> LeftOuterJoin_EmailItem_AppointmentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<EmailItemTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_Invitation_AppointmentId
Generated left outer join from the primary key AppointmentId on this table, to Invitation.AppointmentId.
Declaration
public TargetedLeftOuterJoin<InvitationTableInfo> LeftOuterJoin_Invitation_AppointmentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<InvitationTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_Project_NmdAppointmentId
Generated left outer join from the primary key AppointmentId on this table, to Project.NmdAppointmentId.
Declaration
public TargetedLeftOuterJoin<ProjectTableInfo> LeftOuterJoin_Project_NmdAppointmentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<ProjectTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_QuoteVersion_FollowupId
Generated left outer join from the primary key AppointmentId on this table, to QuoteVersion.FollowupId.
Declaration
public TargetedLeftOuterJoin<QuoteVersionTableInfo> LeftOuterJoin_QuoteVersion_FollowupId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<QuoteVersionTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_Sale_AppointmentId
Generated left outer join from the primary key AppointmentId on this table, to Sale.AppointmentId.
Declaration
public TargetedLeftOuterJoin<SaleTableInfo> LeftOuterJoin_Sale_AppointmentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<SaleTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_Sale_NddAppointmentId
Generated left outer join from the primary key AppointmentId on this table, to Sale.NddAppointmentId.
Declaration
public TargetedLeftOuterJoin<SaleTableInfo> LeftOuterJoin_Sale_NddAppointmentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<SaleTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_SaleHist_AppointmentId
Generated left outer join from the primary key AppointmentId on this table, to SaleHist.AppointmentId.
Declaration
public TargetedLeftOuterJoin<SaleHistTableInfo> LeftOuterJoin_SaleHist_AppointmentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<SaleHistTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_SaleHist_NddAppointmentId
Generated left outer join from the primary key AppointmentId on this table, to SaleHist.NddAppointmentId.
Declaration
public TargetedLeftOuterJoin<SaleHistTableInfo> LeftOuterJoin_SaleHist_NddAppointmentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<SaleHistTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_VisibleFor_AppointmentId
Generated left outer join from the primary key AppointmentId on this table, to VisibleFor.AppointmentId.
Declaration
public TargetedLeftOuterJoin<VisibleForTableInfo> LeftOuterJoin_VisibleFor_AppointmentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<VisibleForTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Location
Field 'location' in table 'appointment': Dictionary type String[255], .NET type: String
Location for appointment, defaulted from invited resource of type place and other rules, but you can write anything you want hereDeclaration
public StringFieldInfo Location { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
ModifiedAppointmentFields
Field 'modified_appointment_fields' in table 'appointment': Dictionary type Enum, .NET type: ModifiedAppointmentFields
Which important fields of an appointment have been changed. Used by notifications.Declaration
public ModifiedAppointmentFieldsFieldInfo ModifiedAppointmentFields { get; }
Property Value
Type | Description |
---|---|
ModifiedAppointmentFieldsFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
MotherAssociateId
Field 'mother_associate_id' in table 'appointment': Dictionary type FK, target: Associate, .NET type: Int32
Associate/owner of the mother appointmentDeclaration
public Int32FieldInfo MotherAssociateId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
MotherAssociateId_InnerJoin_Associate
Generated join from the foreign key MotherAssociateId in this table, to its target table AssociateTableInfo.
Declaration
public TargetedInnerJoin<AssociateTableInfo> MotherAssociateId_InnerJoin_Associate { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<AssociateTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
MotherId
Field 'mother_id' in table 'appointment': Dictionary type FK, target: Appointment, .NET type: Int32
ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBookingDeclaration
public Int32FieldInfo MotherId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
MotherId_InnerJoin_Appointment
Generated join from the foreign key MotherId in this table, to its target table AppointmentTableInfo.
Declaration
public TargetedInnerJoin<AppointmentTableInfo> MotherId_InnerJoin_Appointment { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<AppointmentTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
OriginalStartDate
Field 'original_start_date' in table 'appointment': Dictionary type DateTime, .NET type: DateTime
The original start date for an appointment in a recurring seriesDeclaration
public DateTimeFieldInfo OriginalStartDate { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
OwnedExternally
Field 'owned_externally' in table 'appointment': Dictionary type Enum, .NET type: AppointmentExternalOwner
Set if an external system owns this appointment.Declaration
public AppointmentExternalOwnerFieldInfo OwnedExternally { get; }
Property Value
Type | Description |
---|---|
AppointmentExternalOwnerFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
PersonId
Field 'person_id' in table 'appointment': Dictionary type FK, target: Person, .NET type: Int32
Person ID of person the appointment is with, may be 0Declaration
public Int32FieldInfo PersonId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
PersonId_InnerJoin_Person
Generated join from the foreign key PersonId in this table, to its target table PersonTableInfo.
Declaration
public TargetedInnerJoin<PersonTableInfo> PersonId_InnerJoin_Person { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<PersonTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
PreferredTZLocation
Field 'preferredTZLocation' in table 'appointment': Dictionary type FK, target: TZLocation, .NET type: Int32
Preferred timezone location to use when displaying/editing this appointmentDeclaration
public Int32FieldInfo PreferredTZLocation { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
PreferredTZLocation_InnerJoin_TZLocation
Generated join from the foreign key PreferredTZLocation in this table, to its target table TZLocationTableInfo.
Declaration
public TargetedInnerJoin<TZLocationTableInfo> PreferredTZLocation_InnerJoin_TZLocation { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<TZLocationTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
PriorityIdx
Field 'priority_idx' in table 'appointment': Dictionary type FK, target: Priority, .NET type: Int32
Link to priority listDeclaration
public Int32FieldInfo PriorityIdx { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
PriorityIdx_InnerJoin_Priority
Generated join from the foreign key PriorityIdx in this table, to its target table PriorityTableInfo.
Declaration
public TargetedInnerJoin<PriorityTableInfo> PriorityIdx_InnerJoin_Priority { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<PriorityTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Private
Field 'private' in table 'appointment': Dictionary type Enum, .NET type: AppointmentPrivate
Obsolete, but still maintained field for appointment privacy; denormalization of visiblefor statusDeclaration
public AppointmentPrivateFieldInfo Private { get; }
Property Value
Type | Description |
---|---|
AppointmentPrivateFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
ProjectId
Field 'project_id' in table 'appointment': Dictionary type FK, target: Project, .NET type: Int32
ID of project referred to, may be 0Declaration
public Int32FieldInfo ProjectId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
ProjectId_InnerJoin_Project
Generated join from the foreign key ProjectId in this table, to its target table ProjectTableInfo.
Declaration
public TargetedInnerJoin<ProjectTableInfo> ProjectId_InnerJoin_Project { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<ProjectTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
RecurrenceRuleId
Field 'recurrenceRuleId' in table 'appointment': Dictionary type FK, target: RecurrenceRule, .NET type: Int32
Pointer to recurrence rule, for recurring appointments, otherwise 0Declaration
public Int32FieldInfo RecurrenceRuleId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
RecurrenceRuleId_InnerJoin_RecurrenceRule
Generated join from the foreign key RecurrenceRuleId in this table, to its target table RecurrenceRuleTableInfo.
Declaration
public TargetedInnerJoin<RecurrenceRuleTableInfo> RecurrenceRuleId_InnerJoin_RecurrenceRule { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<RecurrenceRuleTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Registered
Field 'registered' in table 'appointment': Dictionary type UtcDateTime, .NET type: DateTime
Registered dateDeclaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
RegisteredAssociateId
Field 'registered_associate_id' in table 'appointment': Dictionary type FK, target: Associate, .NET type: Int32
Registered by whomDeclaration
public Int32FieldInfo RegisteredAssociateId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
RegisteredAssociateId_InnerJoin_Associate
Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.
Declaration
public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<AssociateTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
RejectCounter
Field 'rejectCounter' in table 'appointment': Dictionary type UShort, .NET type: Int16
How many invitees have rejected this appointmentDeclaration
public UInt16FieldInfo RejectCounter { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
RejectReason
Field 'rejectReason' in table 'appointment': Dictionary type String[255], .NET type: String
Why was this booking or assignment rejected, the RejectReason list is a source of suggestions but you can write anything hereDeclaration
public StringFieldInfo RejectReason { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
RuntimeDefinition
Definition of the table as described in the deployed runtime dictionary
Declaration
public static SoTable RuntimeDefinition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
SaleId
Field 'sale_id' in table 'appointment': Dictionary type FK, target: Sale, .NET type: Int32
Owning sale, if any (may be 0)Declaration
public Int32FieldInfo SaleId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
SaleId_InnerJoin_Sale
Generated join from the foreign key SaleId in this table, to its target table SaleTableInfo.
Declaration
public TargetedInnerJoin<SaleTableInfo> SaleId_InnerJoin_Sale { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<SaleTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
SendEmail
Field 'SendEmail' in table 'appointment': Dictionary type Bool, .NET type: Int16
Send invitation and appointment changes by e-mail to this participant.Declaration
public UInt16FieldInfo SendEmail { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Source
Field 'source' in table 'appointment': Dictionary type UShort, .NET type: Int16
For future integration use; source of recordDeclaration
public UInt16FieldInfo Source { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Status
Field 'status' in table 'appointment': Dictionary type Enum, .NET type: AppointmentStatus
status=done,started, not started, hiddenDeclaration
public AppointmentStatusFieldInfo Status { get; }
Property Value
Type | Description |
---|---|
AppointmentStatusFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
SuggestedAppointmentId
Field 'suggestedAppointmentId' in table 'appointment': Dictionary type FK, target: SuggestedAppointment, .NET type: Int32
Suggested guide item that this appointment is an instance of (Note: NOT VALID for document-type appointments, they have their own link)Declaration
public Int32FieldInfo SuggestedAppointmentId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
SuggestedAppointmentId_InnerJoin_SuggestedAppointment
Generated join from the foreign key SuggestedAppointmentId in this table, to its target table SuggestedAppointmentTableInfo.
Declaration
public TargetedInnerJoin<SuggestedAppointmentTableInfo> SuggestedAppointmentId_InnerJoin_SuggestedAppointment { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<SuggestedAppointmentTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
SuggestedDocumentId
Field 'suggestedDocumentId' in table 'appointment': Dictionary type FK, target: SuggestedDocument, .NET type: Int32
Suggested guide item that this document is an instance of (Note: NOT valid for appointments, they have their own link)Declaration
public Int32FieldInfo SuggestedDocumentId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
SuggestedDocumentId_InnerJoin_SuggestedDocument
Generated join from the foreign key SuggestedDocumentId in this table, to its target table SuggestedDocumentTableInfo.
Declaration
public TargetedInnerJoin<SuggestedDocumentTableInfo> SuggestedDocumentId_InnerJoin_SuggestedDocument { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<SuggestedDocumentTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
TaskIdx
Field 'task_idx' in table 'appointment': Dictionary type FK, target: Task, .NET type: Int32
Link to Task list, OR to DocTmpl list, if this is a documentDeclaration
public Int32FieldInfo TaskIdx { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
TaskIdx_InnerJoin_Task
Generated join from the foreign key TaskIdx in this table, to its target table TaskTableInfo.
Declaration
public TargetedInnerJoin<TaskTableInfo> TaskIdx_InnerJoin_Task { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<TaskTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
TextId
Field 'text_id' in table 'appointment': Dictionary type FK, target: Text, .NET type: Int32
ID of record containing appointment textDeclaration
public Int32FieldInfo TextId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
TextId_InnerJoin_Text
Generated join from the foreign key TextId in this table, to its target table TextTableInfo.
Declaration
public TargetedInnerJoin<TextTableInfo> TextId_InnerJoin_Text { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<TextTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Type
Field 'type' in table 'appointment': Dictionary type Enum, .NET type: AppointmentType
where=no start time,note,docin, docoutDeclaration
public AppointmentTypeFieldInfo Type { get; }
Property Value
Type | Description |
---|---|
AppointmentTypeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Updated
Field 'updated' in table 'appointment': Dictionary type UtcDateTime, .NET type: DateTime
Updated dateDeclaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
UpdatedAssociateId
Field 'updated_associate_id' in table 'appointment': Dictionary type FK, target: Associate, .NET type: Int32
Updated by whoDeclaration
public Int32FieldInfo UpdatedAssociateId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
UpdatedAssociateId_InnerJoin_Associate
Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.
Declaration
public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<AssociateTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
UpdatedCount
Field 'updatedCount' in table 'appointment': Dictionary type UShort, .NET type: Int16
Number of updates made to this recordDeclaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Userdef2Id
Field 'userdef2_id' in table 'appointment': Dictionary type FK, target: UDAppntLarge, .NET type: Int32
User defined table record 2 (for future use)Declaration
public Int32FieldInfo Userdef2Id { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Userdef2Id_InnerJoin_UDAppntLarge
Generated join from the foreign key Userdef2Id in this table, to its target table UDAppntLargeTableInfo.
Declaration
public TargetedInnerJoin<UDAppntLargeTableInfo> Userdef2Id_InnerJoin_UDAppntLarge { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<UDAppntLargeTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
UserdefId
Field 'userdef_id' in table 'appointment': Dictionary type FK, target: UDAppntSmall, .NET type: Int32
User defined table record 1 (for future use)Declaration
public Int32FieldInfo UserdefId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
UserdefId_InnerJoin_UDAppntSmall
Generated join from the foreign key UserdefId in this table, to its target table UDAppntSmallTableInfo.
Declaration
public TargetedInnerJoin<UDAppntSmallTableInfo> UserdefId_InnerJoin_UDAppntSmall { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<UDAppntSmallTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Methods
IdxAssociateId(Int32)
Shortcut method for looking up using the database index AssociateId, which spans the following fields:
Field | Description |
---|---|
AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
Declaration
public Restriction IdxAssociateId(int associateId)
Parameters
Type | Name | Description |
---|---|---|
Int32 | associateId |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxAssociateIdActiveDate(Int32, DateTime)
Shortcut method for looking up using the database index AssociateIdActiveDate, which spans the following fields:
Field | Description |
---|---|
AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
ActiveDate | The date to be used for searching & showing |
Declaration
public Restriction IdxAssociateIdActiveDate(int associateId, DateTime activeDate)
Parameters
Type | Name | Description |
---|---|---|
Int32 | associateId | |
DateTime | activeDate |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxAssociateIdActiveDateMotherId(Int32, DateTime, Int32)
Shortcut method for looking up using the database index AssociateIdActiveDateMotherId, which spans the following fields:
Field | Description |
---|---|
AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
ActiveDate | The date to be used for searching & showing |
MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
Declaration
public Restriction IdxAssociateIdActiveDateMotherId(int associateId, DateTime activeDate, int motherId)
Parameters
Type | Name | Description |
---|---|---|
Int32 | associateId | |
DateTime | activeDate | |
Int32 | motherId |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxAssociateIdStatus(Int32, AppointmentStatus)
Shortcut method for looking up using the database index AssociateIdStatus, which spans the following fields:
Field | Description |
---|---|
AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
Status | status=done,started, not started, hidden |
Declaration
public Restriction IdxAssociateIdStatus(int associateId, AppointmentStatus status)
Parameters
Type | Name | Description |
---|---|---|
Int32 | associateId | |
AppointmentStatus | status |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxAssociateIdStatusDoBy(Int32, AppointmentStatus, DateTime)
Shortcut method for looking up using the database index AssociateIdStatusDoBy, which spans the following fields:
Field | Description |
---|---|
AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
Status | status=done,started, not started, hidden |
DoBy | date + start time planned |
Declaration
public Restriction IdxAssociateIdStatusDoBy(int associateId, AppointmentStatus status, DateTime doBy)
Parameters
Type | Name | Description |
---|---|---|
Int32 | associateId | |
AppointmentStatus | status | |
DateTime | doBy |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxAssociateIdType(Int32, AppointmentType)
Shortcut method for looking up using the database index AssociateIdType, which spans the following fields:
Field | Description |
---|---|
AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
Type | where=no start time,note,docin, docout |
Declaration
public Restriction IdxAssociateIdType(int associateId, AppointmentType type)
Parameters
Type | Name | Description |
---|---|---|
Int32 | associateId | |
AppointmentType | type |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxAssociateIdTypeEndDate(Int32, AppointmentType, DateTime)
Shortcut method for looking up using the database index AssociateIdTypeEndDate, which spans the following fields:
Field | Description |
---|---|
AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
Type | where=no start time,note,docin, docout |
EndDate | Date + end time planned |
Declaration
public Restriction IdxAssociateIdTypeEndDate(int associateId, AppointmentType type, DateTime endDate)
Parameters
Type | Name | Description |
---|---|---|
Int32 | associateId | |
AppointmentType | type | |
DateTime | endDate |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxAssociateIdTypeStatus(Int32, AppointmentType, AppointmentStatus)
Shortcut method for looking up using the database index AssociateIdTypeStatus, which spans the following fields:
Field | Description |
---|---|
AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
Type | where=no start time,note,docin, docout |
Status | status=done,started, not started, hidden |
Declaration
public Restriction IdxAssociateIdTypeStatus(int associateId, AppointmentType type, AppointmentStatus status)
Parameters
Type | Name | Description |
---|---|---|
Int32 | associateId | |
AppointmentType | type | |
AppointmentStatus | status |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxContactId(Int32)
Shortcut method for looking up using the database index ContactId, which spans the following fields:
Field | Description |
---|---|
ContactId | Contact ID of owning contact, may be 0 |
Declaration
public Restriction IdxContactId(int contactId)
Parameters
Type | Name | Description |
---|---|---|
Int32 | contactId |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxMotherId(Int32)
Shortcut method for looking up using the database index MotherId, which spans the following fields:
Field | Description |
---|---|
MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
Declaration
public Restriction IdxMotherId(int motherId)
Parameters
Type | Name | Description |
---|---|---|
Int32 | motherId |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxMotherIdStatus(Int32, AppointmentStatus)
Shortcut method for looking up using the database index MotherIdStatus, which spans the following fields:
Field | Description |
---|---|
MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
Status | status=done,started, not started, hidden |
Declaration
public Restriction IdxMotherIdStatus(int motherId, AppointmentStatus status)
Parameters
Type | Name | Description |
---|---|---|
Int32 | motherId | |
AppointmentStatus | status |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxMotherIdStatusActiveDate(Int32, AppointmentStatus, DateTime)
Shortcut method for looking up using the database index MotherIdStatusActiveDate, which spans the following fields:
Field | Description |
---|---|
MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
Status | status=done,started, not started, hidden |
ActiveDate | The date to be used for searching & showing |
Declaration
public Restriction IdxMotherIdStatusActiveDate(int motherId, AppointmentStatus status, DateTime activeDate)
Parameters
Type | Name | Description |
---|---|---|
Int32 | motherId | |
AppointmentStatus | status | |
DateTime | activeDate |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxMotherIdStatusActiveDateRegisteredAssociateId(Int32, AppointmentStatus, DateTime, Int32)
Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateId, which spans the following fields:
Field | Description |
---|---|
MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
Status | status=done,started, not started, hidden |
ActiveDate | The date to be used for searching & showing |
RegisteredAssociateId | Registered by whom |
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateId(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId)
Parameters
Type | Name | Description |
---|---|---|
Int32 | motherId | |
AppointmentStatus | status | |
DateTime | activeDate | |
Int32 | registeredAssociateId |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxMotherIdStatusActiveDateRegisteredAssociateIdRegistered(Int32, AppointmentStatus, DateTime, Int32, DateTime)
Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateIdRegistered, which spans the following fields:
Field | Description |
---|---|
MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
Status | status=done,started, not started, hidden |
ActiveDate | The date to be used for searching & showing |
RegisteredAssociateId | Registered by whom |
Registered | Registered date |
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegistered(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered)
Parameters
Type | Name | Description |
---|---|---|
Int32 | motherId | |
AppointmentStatus | status | |
DateTime | activeDate | |
Int32 | registeredAssociateId | |
DateTime | registered |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedBy(Int32, AppointmentStatus, DateTime, Int32, DateTime, Int32)
Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedBy, which spans the following fields:
Field | Description |
---|---|
MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
Status | status=done,started, not started, hidden |
ActiveDate | The date to be used for searching & showing |
RegisteredAssociateId | Registered by whom |
Registered | Registered date |
AssignedBy | Who (last) assigned this appointment to associate_id? |
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedBy(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy)
Parameters
Type | Name | Description |
---|---|---|
Int32 | motherId | |
AppointmentStatus | status | |
DateTime | activeDate | |
Int32 | registeredAssociateId | |
DateTime | registered | |
Int32 | assignedBy |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdx(Int32, AppointmentStatus, DateTime, Int32, DateTime, Int32, Int32)
Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdx, which spans the following fields:
Field | Description |
---|---|
MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
Status | status=done,started, not started, hidden |
ActiveDate | The date to be used for searching & showing |
RegisteredAssociateId | Registered by whom |
Registered | Registered date |
AssignedBy | Who (last) assigned this appointment to associate_id? |
GroupIdx | Group of owning associate at the time tha ppnt was created |
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdx(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy, int groupIdx)
Parameters
Type | Name | Description |
---|---|---|
Int32 | motherId | |
AppointmentStatus | status | |
DateTime | activeDate | |
Int32 | registeredAssociateId | |
DateTime | registered | |
Int32 | assignedBy | |
Int32 | groupIdx |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType(Int32, AppointmentStatus, DateTime, Int32, DateTime, Int32, Int32, AppointmentType)
Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType, which spans the following fields:
Field | Description |
---|---|
MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
Status | status=done,started, not started, hidden |
ActiveDate | The date to be used for searching & showing |
RegisteredAssociateId | Registered by whom |
Registered | Registered date |
AssignedBy | Who (last) assigned this appointment to associate_id? |
GroupIdx | Group of owning associate at the time tha ppnt was created |
Type | where=no start time,note,docin, docout |
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy, int groupIdx, AppointmentType type)
Parameters
Type | Name | Description |
---|---|---|
Int32 | motherId | |
AppointmentStatus | status | |
DateTime | activeDate | |
Int32 | registeredAssociateId | |
DateTime | registered | |
Int32 | assignedBy | |
Int32 | groupIdx | |
AppointmentType | type |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxTypeAssociateId(Int32, AppointmentStatus, DateTime, Int32, DateTime, Int32, Int32, AppointmentType, Int32)
Shortcut method for looking up using the database index MotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxTypeAssociateId, which spans the following fields:
Field | Description |
---|---|
MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
Status | status=done,started, not started, hidden |
ActiveDate | The date to be used for searching & showing |
RegisteredAssociateId | Registered by whom |
Registered | Registered date |
AssignedBy | Who (last) assigned this appointment to associate_id? |
GroupIdx | Group of owning associate at the time tha ppnt was created |
Type | where=no start time,note,docin, docout |
AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
Declaration
public Restriction IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxTypeAssociateId(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy, int groupIdx, AppointmentType type, int associateId)
Parameters
Type | Name | Description |
---|---|---|
Int32 | motherId | |
AppointmentStatus | status | |
DateTime | activeDate | |
Int32 | registeredAssociateId | |
DateTime | registered | |
Int32 | assignedBy | |
Int32 | groupIdx | |
AppointmentType | type | |
Int32 | associateId |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxProjectId(Int32)
Shortcut method for looking up using the database index ProjectId, which spans the following fields:
Field | Description |
---|---|
ProjectId | ID of project referred to, may be 0 |
Declaration
public Restriction IdxProjectId(int projectId)
Parameters
Type | Name | Description |
---|---|---|
Int32 | projectId |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxProjectIdType(Int32, AppointmentType)
Shortcut method for looking up using the database index ProjectIdType, which spans the following fields:
Field | Description |
---|---|
ProjectId | ID of project referred to, may be 0 |
Type | where=no start time,note,docin, docout |
Declaration
public Restriction IdxProjectIdType(int projectId, AppointmentType type)
Parameters
Type | Name | Description |
---|---|---|
Int32 | projectId | |
AppointmentType | type |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxProjectIdTypeActiveDate(Int32, AppointmentType, DateTime)
Shortcut method for looking up using the database index ProjectIdTypeActiveDate, which spans the following fields:
Field | Description |
---|---|
ProjectId | ID of project referred to, may be 0 |
Type | where=no start time,note,docin, docout |
ActiveDate | The date to be used for searching & showing |
Declaration
public Restriction IdxProjectIdTypeActiveDate(int projectId, AppointmentType type, DateTime activeDate)
Parameters
Type | Name | Description |
---|---|---|
Int32 | projectId | |
AppointmentType | type | |
DateTime | activeDate |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxProjectIdTypeActiveDateDocumentId(Int32, AppointmentType, DateTime, Int32)
Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentId, which spans the following fields:
Field | Description |
---|---|
ProjectId | ID of project referred to, may be 0 |
Type | where=no start time,note,docin, docout |
ActiveDate | The date to be used for searching & showing |
DocumentId | Points to document record; 0 for non-document appointments! |
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentId(int projectId, AppointmentType type, DateTime activeDate, int documentId)
Parameters
Type | Name | Description |
---|---|---|
Int32 | projectId | |
AppointmentType | type | |
DateTime | activeDate | |
Int32 | documentId |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxProjectIdTypeActiveDateDocumentIdAssociateId(Int32, AppointmentType, DateTime, Int32, Int32)
Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateId, which spans the following fields:
Field | Description |
---|---|
ProjectId | ID of project referred to, may be 0 |
Type | where=no start time,note,docin, docout |
ActiveDate | The date to be used for searching & showing |
DocumentId | Points to document record; 0 for non-document appointments! |
AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateId(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId)
Parameters
Type | Name | Description |
---|---|---|
Int32 | projectId | |
AppointmentType | type | |
DateTime | activeDate | |
Int32 | documentId | |
Int32 | associateId |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdx(Int32, AppointmentType, DateTime, Int32, Int32, Int32)
Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdx, which spans the following fields:
Field | Description |
---|---|
ProjectId | ID of project referred to, may be 0 |
Type | where=no start time,note,docin, docout |
ActiveDate | The date to be used for searching & showing |
DocumentId | Points to document record; 0 for non-document appointments! |
AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
GroupIdx | Group of owning associate at the time tha ppnt was created |
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdx(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx)
Parameters
Type | Name | Description |
---|---|---|
Int32 | projectId | |
AppointmentType | type | |
DateTime | activeDate | |
Int32 | documentId | |
Int32 | associateId | |
Int32 | groupIdx |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherId(Int32, AppointmentType, DateTime, Int32, Int32, Int32, Int32)
Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherId, which spans the following fields:
Field | Description |
---|---|
ProjectId | ID of project referred to, may be 0 |
Type | where=no start time,note,docin, docout |
ActiveDate | The date to be used for searching & showing |
DocumentId | Points to document record; 0 for non-document appointments! |
AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
GroupIdx | Group of owning associate at the time tha ppnt was created |
MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherId(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId)
Parameters
Type | Name | Description |
---|---|---|
Int32 | projectId | |
AppointmentType | type | |
DateTime | activeDate | |
Int32 | documentId | |
Int32 | associateId | |
Int32 | groupIdx | |
Int32 | motherId |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy(Int32, AppointmentType, DateTime, Int32, Int32, Int32, Int32, Int32)
Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy, which spans the following fields:
Field | Description |
---|---|
ProjectId | ID of project referred to, may be 0 |
Type | where=no start time,note,docin, docout |
ActiveDate | The date to be used for searching & showing |
DocumentId | Points to document record; 0 for non-document appointments! |
AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
GroupIdx | Group of owning associate at the time tha ppnt was created |
MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
AssignedBy | Who (last) assigned this appointment to associate_id? |
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId, int assignedBy)
Parameters
Type | Name | Description |
---|---|---|
Int32 | projectId | |
AppointmentType | type | |
DateTime | activeDate | |
Int32 | documentId | |
Int32 | associateId | |
Int32 | groupIdx | |
Int32 | motherId | |
Int32 | assignedBy |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentId(Int32, AppointmentType, DateTime, Int32, Int32, Int32, Int32, Int32, Int32)
Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentId, which spans the following fields:
Field | Description |
---|---|
ProjectId | ID of project referred to, may be 0 |
Type | where=no start time,note,docin, docout |
ActiveDate | The date to be used for searching & showing |
DocumentId | Points to document record; 0 for non-document appointments! |
AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
GroupIdx | Group of owning associate at the time tha ppnt was created |
MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
AssignedBy | Who (last) assigned this appointment to associate_id? |
AppointmentId | Primary key |
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentId(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId, int assignedBy, int appointmentId)
Parameters
Type | Name | Description |
---|---|---|
Int32 | projectId | |
AppointmentType | type | |
DateTime | activeDate | |
Int32 | documentId | |
Int32 | associateId | |
Int32 | groupIdx | |
Int32 | motherId | |
Int32 | assignedBy | |
Int32 | appointmentId |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentIdRegistered(Int32, AppointmentType, DateTime, Int32, Int32, Int32, Int32, Int32, Int32, DateTime)
Shortcut method for looking up using the database index ProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentIdRegistered, which spans the following fields:
Field | Description |
---|---|
ProjectId | ID of project referred to, may be 0 |
Type | where=no start time,note,docin, docout |
ActiveDate | The date to be used for searching & showing |
DocumentId | Points to document record; 0 for non-document appointments! |
AssociateId | ID of associate whose diary the appointment is in, REQUIRED |
GroupIdx | Group of owning associate at the time tha ppnt was created |
MotherId | ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking |
AssignedBy | Who (last) assigned this appointment to associate_id? |
AppointmentId | Primary key |
Registered | Registered date |
Declaration
public Restriction IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedByAppointmentIdRegistered(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId, int assignedBy, int appointmentId, DateTime registered)
Parameters
Type | Name | Description |
---|---|---|
Int32 | projectId | |
AppointmentType | type | |
DateTime | activeDate | |
Int32 | documentId | |
Int32 | associateId | |
Int32 | groupIdx | |
Int32 | motherId | |
Int32 | assignedBy | |
Int32 | appointmentId | |
DateTime | registered |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxRecurrenceRuleId(Int32)
Shortcut method for looking up using the database index RecurrenceRuleId, which spans the following fields:
Field | Description |
---|---|
RecurrenceRuleId | Pointer to recurrence rule, for recurring appointments, otherwise 0 |
Declaration
public Restriction IdxRecurrenceRuleId(int recurrenceRuleId)
Parameters
Type | Name | Description |
---|---|---|
Int32 | recurrenceRuleId |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxRecurrenceRuleIdActiveDate(Int32, DateTime)
Shortcut method for looking up using the database index RecurrenceRuleIdActiveDate, which spans the following fields:
Field | Description |
---|---|
RecurrenceRuleId | Pointer to recurrence rule, for recurring appointments, otherwise 0 |
ActiveDate | The date to be used for searching & showing |
Declaration
public Restriction IdxRecurrenceRuleIdActiveDate(int recurrenceRuleId, DateTime activeDate)
Parameters
Type | Name | Description |
---|---|---|
Int32 | recurrenceRuleId | |
DateTime | activeDate |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
IdxType(AppointmentType)
Shortcut method for looking up using the database index Type, which spans the following fields:
Field | Description |
---|---|
Type | where=no start time,note,docin, docout |
Declaration
public Restriction IdxType(AppointmentType type)
Parameters
Type | Name | Description |
---|---|---|
AppointmentType | type |
Returns
Type | Description |
---|---|
Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling