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 AppointmentRecordDataRemarks
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 ActiveDateField Value
| Type | Description |
|---|---|
| DateTime |
ActiveLinks
Number of active links to documents, other appointments, and such
Declaration
public uint ActiveLinksField Value
| Type | Description |
|---|---|
| UInt32 |
Alarm
Alarm leadtime, the alarm flag has moved to hasAlarm
Declaration
public short AlarmField Value
| Type | Description |
|---|---|
| Int16 |
AlldayEvent
Is this an all day event: 0 = No, 1 = Yes
Declaration
public AllDayEvent AlldayEventField Value
| Type | Description |
|---|---|
| AllDayEvent |
AppointmentId
Primary key
Declaration
public int AppointmentIdField Value
| Type | Description |
|---|---|
| Int32 |
AssignedBy
Who (last) assigned this appointment to associate_id?
Declaration
public int AssignedByField Value
| Type | Description |
|---|---|
| Int32 |
AssociateId
ID of associate whose diary the appointment is in, REQUIRED
Declaration
public int AssociateIdField Value
| Type | Description |
|---|---|
| Int32 |
CautionWarning
Status field to indicate appointments that have some sort of problem
Declaration
public AppointmentCautionWarning CautionWarningField 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 CentralserviceVideomeetIdField Value
| Type | Description |
|---|---|
| String |
ColorIndex
Appointment colour, used only in Japanese versions. Western versions take colour from Task
Declaration
public short ColorIndexField Value
| Type | Description |
|---|---|
| Int16 |
ContactId
Contact ID of owning contact, may be 0
Declaration
public int ContactIdField Value
| Type | Description |
|---|---|
| Int32 |
DoBy
date + start time planned
Declaration
public DateTime DoByField Value
| Type | Description |
|---|---|
| DateTime |
DocumentId
Points to document record; 0 for non-document appointments!
Declaration
public int DocumentIdField Value
| Type | Description |
|---|---|
| Int32 |
Done
date + start time this task was done
Declaration
public DateTime DoneField 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 EmailIdField Value
| Type | Description |
|---|---|
| Int32 |
EndDate
Date + end time planned
Declaration
public DateTime EndDateField Value
| Type | Description |
|---|---|
| DateTime |
FreeBusy
What kind of time is this: 0 = Busy, 1 = Free
Declaration
public FreeBusy FreeBusyField Value
| Type | Description |
|---|---|
| FreeBusy |
GroupIdx
Group of owning associate at the time tha ppnt was created
Declaration
public int GroupIdxField Value
| Type | Description |
|---|---|
| Int32 |
HasAlarm
Does this appointment have an alarm
Declaration
public short HasAlarmField Value
| Type | Description |
|---|---|
| Int16 |
InvitedPersonId
Valid when mother_id != 0 && mother_id != id
Declaration
public int InvitedPersonIdField Value
| Type | Description |
|---|---|
| Int32 |
IsMilestone
Is this appointment a milestone?
Declaration
public short IsMilestoneField Value
| Type | Description |
|---|---|
| Int16 |
JoinVideomeetUrl
Blank when not a video meeting. Filled with Join Meeting URL when created.
Declaration
public string JoinVideomeetUrlField Value
| Type | Description |
|---|---|
| String |
LagTime
as leadtime, but after the end - time blocked for travel etc.
Declaration
public short LagTimeField Value
| Type | Description |
|---|---|
| Int16 |
Leadtime
Time blocked (minutes) BEFORE starttime
Declaration
public short LeadtimeField 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 LocationField Value
| Type | Description |
|---|---|
| String |
MotherAssociateId
Associate/owner of the mother appointment
Declaration
public int MotherAssociateIdField 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 MotherIdField Value
| Type | Description |
|---|---|
| Int32 |
OriginalStartDate
The original start date for an appointment in a recurring series
Declaration
public DateTime OriginalStartDateField Value
| Type | Description |
|---|---|
| DateTime |
PersonId
Person ID of person the appointment is with, may be 0
Declaration
public int PersonIdField Value
| Type | Description |
|---|---|
| Int32 |
PreferredTZLocation
Preferred timezone location to use when displaying/editing this appointment
Declaration
public int PreferredTZLocationField Value
| Type | Description |
|---|---|
| Int32 |
PriorityIdx
Link to priority list
Declaration
public int PriorityIdxField Value
| Type | Description |
|---|---|
| Int32 |
Private
Obsolete, but still maintained field for appointment privacy; denormalization of visiblefor status
Declaration
public AppointmentPrivate PrivateField Value
| Type | Description |
|---|---|
| AppointmentPrivate |
ProjectId
ID of project referred to, may be 0
Declaration
public int ProjectIdField Value
| Type | Description |
|---|---|
| Int32 |
RecurrenceRuleId
Pointer to recurrence rule, for recurring appointments, otherwise 0
Declaration
public int RecurrenceRuleIdField Value
| Type | Description |
|---|---|
| Int32 |
Registered
Registered date in UTC.
Declaration
public DateTime RegisteredField Value
| Type | Description |
|---|---|
| DateTime |
RegisteredAssociateId
Registered by whom
Declaration
public int RegisteredAssociateIdField Value
| Type | Description |
|---|---|
| Int32 |
RejectCounter
How many invitees have rejected this appointment
Declaration
public short RejectCounterField 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 RejectReasonField Value
| Type | Description |
|---|---|
| String |
SaleId
Owning sale, if any (may be 0)
Declaration
public int SaleIdField Value
| Type | Description |
|---|---|
| Int32 |
Source
For future integration use; source of record
Declaration
public short SourceField Value
| Type | Description |
|---|---|
| Int16 |
Status
status=done,started, not started, hidden
Declaration
public AppointmentStatus StatusField 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 SuggestedAppointmentIdField 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 SuggestedDocumentIdField Value
| Type | Description |
|---|---|
| Int32 |
TaskIdx
Link to Task list, OR to DocTmpl list, if this is a document
Declaration
public int TaskIdxField Value
| Type | Description |
|---|---|
| Int32 |
TextId
ID of record containing appointment text
Declaration
public int TextIdField Value
| Type | Description |
|---|---|
| Int32 |
Type
where=no start time,note,docin, docout
Declaration
public AppointmentType TypeField Value
| Type | Description |
|---|---|
| AppointmentType |
Updated
Updated date in UTC.
Declaration
public DateTime UpdatedField Value
| Type | Description |
|---|---|
| DateTime |
UpdatedAssociateId
Updated by who
Declaration
public int UpdatedAssociateIdField Value
| Type | Description |
|---|---|
| Int32 |
UpdatedCount
Number of updates made to this record
Declaration
public short UpdatedCountField Value
| Type | Description |
|---|---|
| Int16 |
Userdef2Id
User defined table record 2 (for future use)
Declaration
public int Userdef2IdField Value
| Type | Description |
|---|---|
| Int32 |
UserdefId
User defined table record 1 (for future use)
Declaration
public int UserdefIdField Value
| Type | Description |
|---|---|
| Int32 |