Class AppointmentRecordData

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the appointment table.

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.

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the appointment table.

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.

The date to be used for searching & showing

Type	Description
DateTime

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.

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

Type	Description
UInt32

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.

ID of record containing agenda text

Type	Description
Int32

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.

Alarm leadtime, the alarm flag has moved to hasAlarm

Type	Description
Int16

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.

Is this an all day event: 0 = No, 1 = Yes

Type	Description
AllDayEvent

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.

Primary key

Type	Description
Int32

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.

Who (last) assigned this appointment to associate_id?

Type	Description
Int32

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.

ID of associate whose diary the appointment is in, REQUIRED

Type	Description
Int32

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.

Status field to indicate appointments that have some sort of problem

Type	Description
AppointmentCautionWarning

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.

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.

Type	Description
String

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.

Appointment colour, used only in Japanese versions. Western versions take colour from Task

Type	Description
Int16

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.

Contact ID of owning contact, may be 0

Type	Description
Int32

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.

The workflow this follow-up was created by

Type	Description
Int32

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.

date + start time planned

Type	Description
DateTime

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.

Points to document record; 0 for non-document appointments!

Type	Description
Int32

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.

date + start time this task was done

Type	Description
DateTime

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.

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

Type	Description
Int32

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.

Date + end time planned

Type	Description
DateTime

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.

What kind of time is this: 0 = Busy, 1 = Free

Type	Description
FreeBusy

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.

Group of owning associate at the time tha ppnt was created

Type	Description
Int32

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.

Does this appointment have an alarm

Type	Description
Int16

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.

ID of record containing internal notes text

Type	Description
Int32

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.

Valid when mother_id != 0 && mother_id != id

Type	Description
Int32

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.

Is this appointment a milestone?

Type	Description
Int16

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.

Blank when not a video meeting. Filled with Join Meeting URL when created.

Type	Description
String

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.

as leadtime, but after the end - time blocked for travel etc.

Type	Description
Int16

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.

Time blocked (minutes) BEFORE starttime

Type	Description
Int16

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.

Location for appointment, defaulted from invited resource of type place and other rules, but you can write anything you want here

Type	Description
String

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.

Which important fields of an appointment have been changed. Used by notifications.

Type	Description
ModifiedAppointmentFields

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.

Associate/owner of the mother appointment

Type	Description
Int32

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.

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

Type	Description
Int32

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.

The original start date for an appointment in a recurring series

Type	Description
DateTime

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.

Set if an external system owns this appointment.

Type	Description
AppointmentExternalOwner

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.

Person ID of person the appointment is with, may be 0

Type	Description
Int32

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.

Preferred timezone location to use when displaying/editing this appointment

Type	Description
Int32

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.

Link to priority list

Type	Description
Int32

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.

Obsolete, but still maintained field for appointment privacy; denormalization of visiblefor status

Type	Description
AppointmentPrivate

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.

ID of project referred to, may be 0

Type	Description
Int32

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.

Pointer to recurrence rule, for recurring appointments, otherwise 0

Type	Description
Int32

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.

Registered date in UTC.

Type	Description
DateTime

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.

Registered by whom

Type	Description
Int32

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.

How many invitees have rejected this appointment

Type	Description
Int16

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.

Why was this booking or assignment rejected, the RejectReason list is a source of suggestions but you can write anything here

Type	Description
String

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.

Owning sale, if any (may be 0)

Type	Description
Int32

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.

Send invitation and appointment changes by e-mail to this participant.

Type	Description
Int16

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.

For future integration use; source of record

Type	Description
Int16

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.

status=done,started, not started, hidden

Type	Description
AppointmentStatus

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.

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

Type	Description
Int32

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.

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

Type	Description
Int32

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.

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

Type	Description
Int32

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.

ID of record containing appointment text

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.

where=no start time,note,docin, docout

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.

Updated date in UTC.

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.

Updated by who

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.

Number of updates made to this record

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.

User defined table record 2 (for future use)

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.

User defined table record 1 (for future use)

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.

Inheritance

Namespace: SuperOffice.CRM.Rows

Assembly: SoDataBase.dll

Syntax

Remarks

Constructors

AppointmentRecordData()

Declaration

Remarks

Fields

ActiveDate

Declaration

Field Value

Remarks

ActiveLinks

Declaration

Field Value

Remarks

AgendaTextId

Declaration

Field Value

Remarks

Alarm

Declaration

Field Value

Remarks

AlldayEvent

Declaration

Field Value

Remarks

AppointmentId

Declaration

Field Value

Remarks

AssignedBy

Declaration

Field Value

Remarks

AssociateId

Declaration

Field Value

Remarks

CautionWarning

Declaration

Field Value

Remarks

CentralserviceVideomeetId

Declaration

Field Value

Remarks

ColorIndex

Declaration

Field Value

Remarks

ContactId

Declaration

Field Value

Remarks

CreatedByWorkflowId

Declaration

Field Value

Remarks

DoBy

Declaration

Field Value

Remarks

DocumentId

Declaration

Field Value

Remarks

Done

Declaration

Field Value

Remarks

EmailId

Declaration

Field Value

Remarks

EndDate