Class AppointmentRecordData
POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the appointment table.
Inherited Members
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class AppointmentRecordData
Remarks
Please use this class instead of a full AppointmentRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding AppointmentTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Constructors
AppointmentRecordData()
Declaration
public AppointmentRecordData()
Fields
ActiveDate
The date to be used for searching & showing
Declaration
public DateTime ActiveDate
Field Value
Type | Description |
---|---|
DateTime |
ActiveLinks
Number of active links to documents, other appointments, and such
Declaration
public uint ActiveLinks
Field Value
Type | Description |
---|---|
UInt32 |
Alarm
Alarm leadtime, the alarm flag has moved to hasAlarm
Declaration
public short Alarm
Field Value
Type | Description |
---|---|
Int16 |
AlldayEvent
Is this an all day event: 0 = No, 1 = Yes
Declaration
public AllDayEvent AlldayEvent
Field Value
Type | Description |
---|---|
AllDayEvent |
AppointmentId
Primary key
Declaration
public int AppointmentId
Field Value
Type | Description |
---|---|
Int32 |
AssignedBy
Who (last) assigned this appointment to associate_id?
Declaration
public int AssignedBy
Field Value
Type | Description |
---|---|
Int32 |
AssociateId
ID of associate whose diary the appointment is in, REQUIRED
Declaration
public int AssociateId
Field Value
Type | Description |
---|---|
Int32 |
CautionWarning
Status field to indicate appointments that have some sort of problem
Declaration
public AppointmentCautionWarning CautionWarning
Field Value
Type | Description |
---|---|
AppointmentCautionWarning |
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 string CentralserviceVideomeetId
Field Value
Type | Description |
---|---|
String |
ColorIndex
Appointment colour, used only in Japanese versions. Western versions take colour from Task
Declaration
public short ColorIndex
Field Value
Type | Description |
---|---|
Int16 |
ContactId
Contact ID of owning contact, may be 0
Declaration
public int ContactId
Field Value
Type | Description |
---|---|
Int32 |
DoBy
date + start time planned
Declaration
public DateTime DoBy
Field Value
Type | Description |
---|---|
DateTime |
DocumentId
Points to document record; 0 for non-document appointments!
Declaration
public int DocumentId
Field Value
Type | Description |
---|---|
Int32 |
Done
date + start time this task was done
Declaration
public DateTime Done
Field Value
Type | Description |
---|---|
DateTime |
EmailId
If invitation and status changes should be mailed, this is the ID of the email address used
Declaration
public int EmailId
Field Value
Type | Description |
---|---|
Int32 |
EndDate
Date + end time planned
Declaration
public DateTime EndDate
Field Value
Type | Description |
---|---|
DateTime |
FreeBusy
What kind of time is this: 0 = Busy, 1 = Free
Declaration
public FreeBusy FreeBusy
Field Value
Type | Description |
---|---|
FreeBusy |
GroupIdx
Group of owning associate at the time tha ppnt was created
Declaration
public int GroupIdx
Field Value
Type | Description |
---|---|
Int32 |
HasAlarm
Does this appointment have an alarm
Declaration
public short HasAlarm
Field Value
Type | Description |
---|---|
Int16 |
InvitedPersonId
Valid when mother_id != 0 && mother_id != id
Declaration
public int InvitedPersonId
Field Value
Type | Description |
---|---|
Int32 |
IsMilestone
Is this appointment a milestone?
Declaration
public short IsMilestone
Field Value
Type | Description |
---|---|
Int16 |
JoinVideomeetUrl
Blank when not a video meeting. Filled with Join Meeting URL when created.
Declaration
public string JoinVideomeetUrl
Field Value
Type | Description |
---|---|
String |
LagTime
as leadtime, but after the end - time blocked for travel etc.
Declaration
public short LagTime
Field Value
Type | Description |
---|---|
Int16 |
Leadtime
Time blocked (minutes) BEFORE starttime
Declaration
public short Leadtime
Field Value
Type | Description |
---|---|
Int16 |
Location
Location for appointment, defaulted from invited resource of type place and other rules, but you can write anything you want here
Declaration
public string Location
Field Value
Type | Description |
---|---|
String |
MotherAssociateId
Associate/owner of the mother appointment
Declaration
public int MotherAssociateId
Field Value
Type | Description |
---|---|
Int32 |
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 int MotherId
Field Value
Type | Description |
---|---|
Int32 |
OriginalStartDate
The original start date for an appointment in a recurring series
Declaration
public DateTime OriginalStartDate
Field Value
Type | Description |
---|---|
DateTime |
PersonId
Person ID of person the appointment is with, may be 0
Declaration
public int PersonId
Field Value
Type | Description |
---|---|
Int32 |
PreferredTZLocation
Preferred timezone location to use when displaying/editing this appointment
Declaration
public int PreferredTZLocation
Field Value
Type | Description |
---|---|
Int32 |
PriorityIdx
Link to priority list
Declaration
public int PriorityIdx
Field Value
Type | Description |
---|---|
Int32 |
Private
Obsolete, but still maintained field for appointment privacy; denormalization of visiblefor status
Declaration
public AppointmentPrivate Private
Field Value
Type | Description |
---|---|
AppointmentPrivate |
ProjectId
ID of project referred to, may be 0
Declaration
public int ProjectId
Field Value
Type | Description |
---|---|
Int32 |
RecurrenceRuleId
Pointer to recurrence rule, for recurring appointments, otherwise 0
Declaration
public int RecurrenceRuleId
Field Value
Type | Description |
---|---|
Int32 |
Registered
Registered date in UTC.
Declaration
public DateTime Registered
Field Value
Type | Description |
---|---|
DateTime |
RegisteredAssociateId
Registered by whom
Declaration
public int RegisteredAssociateId
Field Value
Type | Description |
---|---|
Int32 |
RejectCounter
How many invitees have rejected this appointment
Declaration
public short RejectCounter
Field Value
Type | Description |
---|---|
Int16 |
RejectReason
Why was this booking or assignment rejected, the RejectReason list is a source of suggestions but you can write anything here
Declaration
public string RejectReason
Field Value
Type | Description |
---|---|
String |
SaleId
Owning sale, if any (may be 0)
Declaration
public int SaleId
Field Value
Type | Description |
---|---|
Int32 |
Source
For future integration use; source of record
Declaration
public short Source
Field Value
Type | Description |
---|---|
Int16 |
Status
status=done,started, not started, hidden
Declaration
public AppointmentStatus Status
Field Value
Type | Description |
---|---|
AppointmentStatus |
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 int SuggestedAppointmentId
Field Value
Type | Description |
---|---|
Int32 |
SuggestedDocumentId
Suggested guide item that this document is an instance of (Note: NOT valid for appointments, they have their own link)
Declaration
public int SuggestedDocumentId
Field Value
Type | Description |
---|---|
Int32 |
TaskIdx
Link to Task list, OR to DocTmpl list, if this is a document
Declaration
public int TaskIdx
Field Value
Type | Description |
---|---|
Int32 |
TextId
ID of record containing appointment text
Declaration
public int TextId
Field Value
Type | Description |
---|---|
Int32 |
Type
where=no start time,note,docin, docout
Declaration
public AppointmentType Type
Field Value
Type | Description |
---|---|
AppointmentType |
Updated
Updated date in UTC.
Declaration
public DateTime Updated
Field Value
Type | Description |
---|---|
DateTime |
UpdatedAssociateId
Updated by who
Declaration
public int UpdatedAssociateId
Field Value
Type | Description |
---|---|
Int32 |
UpdatedCount
Number of updates made to this record
Declaration
public short UpdatedCount
Field Value
Type | Description |
---|---|
Int16 |
Userdef2Id
User defined table record 2 (for future use)
Declaration
public int Userdef2Id
Field Value
Type | Description |
---|---|
Int32 |
UserdefId
User defined table record 1 (for future use)
Declaration
public int UserdefId
Field Value
Type | Description |
---|---|
Int32 |