Name | Description | Type | Additional information |
---|---|---|---|
appointmentID | integer |
None. |
|
appointmentCompanyID | integer |
None. |
|
appointmentUserID | integer |
None. |
|
appointmentClientID | integer |
None. |
|
appointmentQualificationLevel | string |
None. |
|
appointmentReferenceNumber | string |
None. |
|
appointmentDate | date |
None. |
|
appointmentStartTime | date |
None. |
|
appointmentEndTime | date |
None. |
|
appointmentStartPriority | integer |
None. |
|
appointmentStartTime_Marked | date |
None. |
|
appointmentEndTime_Marked | date |
None. |
|
appointmentStartTime_Actual | date |
None. |
|
appointmentEndTime_Actual | date |
None. |
|
appointmentDuration | integer |
None. |
|
appointmentNotes | string |
None. |
|
appointmentNotes_Carer | string |
None. |
|
appointmentNotes_Admin | string |
None. |
|
appointmentEstCarerCost | decimal number |
None. |
|
appointmentCost | decimal number |
None. |
|
appointmentShiftCode | string |
None. |
|
appointmentStatus1 | integer |
None. |
|
appointmentStatus2 | integer |
None. |
|
appointmentStatus3 | integer |
None. |
|
appointmentStatusTags | string |
None. |
|
appointmentTasks | string |
None. |
|
appointmentTaskBreakdown | string |
None. |
|
appointmentLastconfirmedStatus | string |
None. |
|
appointmentMedications | string |
None. |
|
appointmentMedicationDetails | string |
None. |
|
appointmentEquipment | string |
None. |
|
appointmentEquipmentDetails | string |
None. |
|
appointmentLastUpdated | date |
None. |
|
appointmentPhotos | string |
None. |
|
appointmentRepeat | boolean |
None. |
|
appointmentParentRepeatID | integer |
None. |
|
appointmentRepeatStart | date |
None. |
|
appointmentRepeatEnd | date |
None. |
|
appointmentRepeatFrequency | string |
None. |
|
appointmentKM1 | decimal number |
None. |
|
appointmentKM2 | decimal number |
None. |
|
appointmentFlexibility | string |
None. |
|
appointmentStatus4 | decimal number |
None. |
|
appointmentEndsNextDay | boolean |
None. |
|
appointmentPayrollCategory | integer |
None. |
|
appointmentServiceType | integer |
None. |
|
appointmentExtraCharge1 | string |
None. |
|
appointmentExtraCharge1_type | string |
None. |
|
appointmentChargeableCancellation | boolean |
None. |
|
appointmentChargeableCancellationDetails | string |
None. |
|
appointmentPackageOverride | integer |
None. |
|
appointmentTimeVarianceAccepted | boolean |
None. |
|
appointmentRepeatWeekday | string |
None. |
|
appointmentRepeatWeekCount | integer |
None. |
|
appointmentTravel1 | integer |
None. |
|
appointmentSignaturePath | string |
None. |
|
appointmentVehicleType | string |
None. |
|
appointmentExcludeFromPayroll | boolean |
None. |
|
appointmentMultiUserIDs | string |
None. |
|
appointmentMultiUser | boolean |
None. |
|
appointmentRejectedUserIDS | string |
None. |
|
appointmentTransport_Pickup | integer |
None. |
|
appointmentTransport_Dropoff | integer |
None. |
|
appointmentBranch | integer |
None. |
|
appointmentMultiClientIDS | string |
None. |
|
appointmentMultiClient | boolean |
None. |
|
appointmentTravelVariance | byte |
None. |
|
appointmentTravelVarianceDetails | string |
None. |
|
appointmentLocationOverride | integer |
None. |
|
appointmentCancellationReason | string |
None. |
|
appointmentCancellationReason_Note | string |
None. |
|
appointmentEquipmentChargesApproved | boolean |
None. |
|
appointmentCustomEntries | string |
None. |
|
appointmentPackageFixed | integer |
None. |
|
appointmentUnidentifiedClients | integer |
None. |
|
appointmentLeaveEntry | integer |
None. |
|
appointmentBreakDuration | integer |
None. |
|
appointmentTax | integer |
None. |