Class DBC.AppointmentFields
Fields for 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.
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class AppointmentFields : ObjectFields
ActiveDate
Appointment.ActiveDate: The date to be used for searching & showing
Declaration
public const string ActiveDate = "activeDate"Field Value
| Type | Description |
|---|---|
| String |
ActiveLinks
Appointment.ActiveLinks: Number of active links to documents, other appointments, and such
Declaration
public const string ActiveLinks = "activeLinks"Field Value
| Type | Description |
|---|---|
| String |
AgendaTextId
Appointment.AgendaTextId: ID of record containing agenda text
Declaration
public const string AgendaTextId = "agenda_text_id"Field Value
| Type | Description |
|---|---|
| String |
Alarm
Appointment.Alarm: Alarm leadtime, the alarm flag has moved to hasAlarm
Declaration
public const string Alarm = "alarm"Field Value
| Type | Description |
|---|---|
| String |
AlldayEvent
Appointment.AlldayEvent: Is this an all day event: 0 = No, 1 = Yes
Declaration
public const string AlldayEvent = "alldayEvent"Field Value
| Type | Description |
|---|---|
| String |
AppointmentId
Appointment.AppointmentId: Primary key
Declaration
public const string AppointmentId = "appointment_id"Field Value
| Type | Description |
|---|---|
| String |
AssignedBy
Appointment.AssignedBy: Who (last) assigned this appointment to associate_id?
Declaration
public const string AssignedBy = "assignedBy"Field Value
| Type | Description |
|---|---|
| String |
AssociateId
Appointment.AssociateId: ID of associate whose diary the appointment is in, REQUIRED
Declaration
public const string AssociateId = "associate_id"Field Value
| Type | Description |
|---|---|
| String |
CautionWarning
Appointment.CautionWarning: Status field to indicate appointments that have some sort of problem
Declaration
public const string CautionWarning = "cautionWarning"Field Value
| Type | Description |
|---|---|
| String |
CentralserviceVideomeetId
Appointment.CentralserviceVideomeetId: 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 const string CentralserviceVideomeetId = "centralservice_videomeet_id"Field Value
| Type | Description |
|---|---|
| String |
ColorIndex
Appointment.ColorIndex: Appointment colour, used only in Japanese versions. Western versions take colour from Task
Declaration
public const string ColorIndex = "color_index"Field Value
| Type | Description |
|---|---|
| String |
ContactId
Appointment.ContactId: Contact ID of owning contact, may be 0
Declaration
public const string ContactId = "contact_id"Field Value
| Type | Description |
|---|---|
| String |
CreatedByWorkflowId
Appointment.CreatedByWorkflowId: The workflow this follow-up was created by
Declaration
public const string CreatedByWorkflowId = "created_by_workflow_id"Field Value
| Type | Description |
|---|---|
| String |
DoBy
Appointment.DoBy: date + start time planned
Declaration
public const string DoBy = "do_by"Field Value
| Type | Description |
|---|---|
| String |
DocumentId
Appointment.DocumentId: Points to document record; 0 for non-document appointments!
Declaration
public const string DocumentId = "document_id"Field Value
| Type | Description |
|---|---|
| String |
Done
Appointment.Done: date + start time this task was done
Declaration
public const string Done = "done"Field Value
| Type | Description |
|---|---|
| String |
EmailId
Appointment.EmailId: If invitation and status changes should be mailed, this is the ID of the email address used
Declaration
public const string EmailId = "emailId"Field Value
| Type | Description |
|---|---|
| String |
EndDate
Appointment.EndDate: Date + end time planned
Declaration
public const string EndDate = "endDate"Field Value
| Type | Description |
|---|---|
| String |
FreeBusy
Appointment.FreeBusy: What kind of time is this: 0 = Busy, 1 = Free
Declaration
public const string FreeBusy = "freeBusy"Field Value
| Type | Description |
|---|---|
| String |
GroupIdx
Appointment.GroupIdx: Group of owning associate at the time tha ppnt was created
Declaration
public const string GroupIdx = "group_idx"Field Value
| Type | Description |
|---|---|
| String |
HasAlarm
Appointment.HasAlarm: Does this appointment have an alarm
Declaration
public const string HasAlarm = "hasAlarm"Field Value
| Type | Description |
|---|---|
| String |
InternalNotesTextId
Appointment.InternalNotesTextId: ID of record containing internal notes text
Declaration
public const string InternalNotesTextId = "internal_notes_text_id"Field Value
| Type | Description |
|---|---|
| String |
InvitedPersonId
Appointment.InvitedPersonId: Valid when mother_id != 0 && mother_id != id
Declaration
public const string InvitedPersonId = "invitedPersonId"Field Value
| Type | Description |
|---|---|
| String |
IsMilestone
Appointment.IsMilestone: Is this appointment a milestone?
Declaration
public const string IsMilestone = "isMilestone"Field Value
| Type | Description |
|---|---|
| String |
JoinVideomeetUrl
Appointment.JoinVideomeetUrl: Blank when not a video meeting. Filled with Join Meeting URL when created.
Declaration
public const string JoinVideomeetUrl = "join_videomeet_url"Field Value
| Type | Description |
|---|---|
| String |
LagTime
Appointment.LagTime: as leadtime, but after the end - time blocked for travel etc.
Declaration
public const string LagTime = "lagTime"Field Value
| Type | Description |
|---|---|
| String |
Leadtime
Appointment.Leadtime: Time blocked (minutes) BEFORE starttime
Declaration
public const string Leadtime = "leadtime"Field Value
| Type | Description |
|---|---|
| String |
Location
Appointment.Location: Location for appointment, defaulted from invited resource of type place and other rules, but you can write anything you want here
Declaration
public const string Location = "location"Field Value
| Type | Description |
|---|---|
| String |
ModifiedAppointmentFields
Appointment.ModifiedAppointmentFields: Which important fields of an appointment have been changed. Used by notifications.
Declaration
public const string ModifiedAppointmentFields = "modified_appointment_fields"Field Value
| Type | Description |
|---|---|
| String |
MotherAssociateId
Appointment.MotherAssociateId: Associate/owner of the mother appointment
Declaration
public const string MotherAssociateId = "mother_associate_id"Field Value
| Type | Description |
|---|---|
| String |
MotherId
Appointment.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 const string MotherId = "mother_id"Field Value
| Type | Description |
|---|---|
| String |
OriginalStartDate
Appointment.OriginalStartDate: The original start date for an appointment in a recurring series
Declaration
public const string OriginalStartDate = "original_start_date"Field Value
| Type | Description |
|---|---|
| String |
PersonId
Appointment.PersonId: Person ID of person the appointment is with, may be 0
Declaration
public const string PersonId = "person_id"Field Value
| Type | Description |
|---|---|
| String |
PreferredTZLocation
Appointment.PreferredTZLocation: Preferred timezone location to use when displaying/editing this appointment
Declaration
public const string PreferredTZLocation = "preferredTZLocation"Field Value
| Type | Description |
|---|---|
| String |
PriorityIdx
Appointment.PriorityIdx: Link to priority list
Declaration
public const string PriorityIdx = "priority_idx"Field Value
| Type | Description |
|---|---|
| String |
Private
Appointment.Private: Obsolete, but still maintained field for appointment privacy; denormalization of visiblefor status
Declaration
public const string Private = "private"Field Value
| Type | Description |
|---|---|
| String |
ProjectId
Appointment.ProjectId: ID of project referred to, may be 0
Declaration
public const string ProjectId = "project_id"Field Value
| Type | Description |
|---|---|
| String |
RecurrenceRuleId
Appointment.RecurrenceRuleId: Pointer to recurrence rule, for recurring appointments, otherwise 0
Declaration
public const string RecurrenceRuleId = "recurrenceRuleId"Field Value
| Type | Description |
|---|---|
| String |
Registered
Appointment.Registered: Registered date
Declaration
public const string Registered = "registered"Field Value
| Type | Description |
|---|---|
| String |
RegisteredAssociateId
Appointment.RegisteredAssociateId: Registered by whom
Declaration
public const string RegisteredAssociateId = "registered_associate_id"Field Value
| Type | Description |
|---|---|
| String |
RejectCounter
Appointment.RejectCounter: How many invitees have rejected this appointment
Declaration
public const string RejectCounter = "rejectCounter"Field Value
| Type | Description |
|---|---|
| String |
RejectReason
Appointment.RejectReason: Why was this booking or assignment rejected, the RejectReason list is a source of suggestions but you can write anything here
Declaration
public const string RejectReason = "rejectReason"Field Value
| Type | Description |
|---|---|
| String |
SaleId
Appointment.SaleId: Owning sale, if any (may be 0)
Declaration
public const string SaleId = "sale_id"Field Value
| Type | Description |
|---|---|
| String |
SendEmail
Appointment.SendEmail: Send invitation and appointment changes by e-mail to this participant.
Declaration
public const string SendEmail = "SendEmail"Field Value
| Type | Description |
|---|---|
| String |
Source
Appointment.Source: For future integration use; source of record
Declaration
public const string Source = "source"Field Value
| Type | Description |
|---|---|
| String |
Status
Appointment.Status: status=done,started, not started, hidden
Declaration
public const string Status = "status"Field Value
| Type | Description |
|---|---|
| String |
SuggestedAppointmentId
Appointment.SuggestedAppointmentId: Suggested guide item that this appointment is an instance of (Note: NOT VALID for document-type appointments, they have their own link)
Declaration
public const string SuggestedAppointmentId = "suggestedAppointmentId"Field Value
| Type | Description |
|---|---|
| String |
SuggestedDocumentId
Appointment.SuggestedDocumentId: Suggested guide item that this document is an instance of (Note: NOT valid for appointments, they have their own link)
Declaration
public const string SuggestedDocumentId = "suggestedDocumentId"Field Value
| Type | Description |
|---|---|
| String |
TaskIdx
Appointment.TaskIdx: Link to Task list, OR to DocTmpl list, if this is a document
Declaration
public const string TaskIdx = "task_idx"Field Value
| Type | Description |
|---|---|
| String |
TextId
Appointment.TextId: ID of record containing appointment text
Declaration
public const string TextId = "text_id"Field Value
| Type | Description |
|---|---|
| String |
Type
Appointment.Type: where=no start time,note,docin, docout
Declaration
public const string Type = "type"Field Value
| Type | Description |
|---|---|
| String |
Updated
Appointment.Updated: Updated date
Declaration
public const string Updated = "updated"Field Value
| Type | Description |
|---|---|
| String |
UpdatedAssociateId
Appointment.UpdatedAssociateId: Updated by who
Declaration
public const string UpdatedAssociateId = "updated_associate_id"Field Value
| Type | Description |
|---|---|
| String |
UpdatedCount
Appointment.UpdatedCount: Number of updates made to this record
Declaration
public const string UpdatedCount = "updatedCount"Field Value
| Type | Description |
|---|---|
| String |
Userdef2Id
Appointment.Userdef2Id: User defined table record 2 (for future use)
Declaration
public const string Userdef2Id = "userdef2_id"Field Value
| Type | Description |
|---|---|
| String |
UserdefId
Appointment.UserdefId: User defined table record 1 (for future use)
Declaration
public const string UserdefId = "userdef_id"Field Value
| Type | Description |
|---|---|
| String |