CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
Duration | Duration | Calculated (calculated) | | Minutes from Start Time to End Time, calculated. Empty or 0 until both times are set, which in practice means until someone completes the task by hand. |
EndTime | End Time | TimeOnly | | Stamped by the server when the task's status is set to Completed. Because no delivered screen completes a task, it stays empty unless someone sets the status by hand. |
Id | Id | Guid | Yes | |
IsHidden | Is Hden | Boolean | Yes | Copied from the template entry's Hidden flag when the record is created. The visit screens decide whether to hide a task from the entry, not from this flag, and a task that already has a record stays visible even when its entry is hidden later. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | | The record's number, filled in automatically from the Visit Task Document Name Setting (series VT), which is delivered switched on. It is not the task's title: the visit screens title the card from Task Name. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PlannedDuration | Planned Duration | Calculated (calculated) | | Minutes between Planned Start Time and Planned End Time, calculated. Because nothing sets those times it is always 0; use Task Duration for the planned minutes. |
PlannedEndTime | Planned End Time | TimeOnly | | Not filled in by the visit screens or the server. |
PlannedStartTime | Planned Start Time | TimeOnly | | Not filled in by the visit screens or the server. The visit's own planned times are on the visit. |
RecordTypeId | Record Type | Guid, hidden | | |
SequenceNumber | Sequence Number | Number | | The task card's position on this visit, lowest first. Copied from the template entry's Sequence Number when the record is created. The visit screens sort a started task by this value, so changing it on the record reorders that visit only. |
StartTime | Start Time | TimeOnly | | When the task was first set to Started, stamped by the server from the current time. In practice it is the moment the first activity under the task was worked. |
Status | Status | PickList | | The task's state. The delivered values are Planned, Started, Completed and Cancelled, but the visit screens only ever write Started, each time an activity under the task is worked. No delivered screen writes Completed or Cancelled, and the visit screens show task progress from the activities, not from this field. Setting Completed by hand stamps End Time. Values: Planned, Started, Completed, Cancelled. |
TaskDuration | Task Duration | Calculated (calculated) | | The planned minutes for the task, read from the linked template entry's Task Duration (Mins). Not stored independently on the task. |
TaskName | TaskName | LongMultiLineText | | The task card title on the visit, copied from the template entry's Name when the record is created. Later changes to the entry's Name do not reach this record, and the visit screens title the card from this field once the record exists. |
TaskNumber | TaskNumber | Number | | Not used. Defaults to 0 and nothing reads it. |
TaskType | Task Type | PickList | | The kind of task, copied from the template entry. The only delivered value is Perform Visit Activities, and no screen behaves differently by type. Values: Perform Visit Activities. |
UIProps | UI Props | Text | | |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
VisitId | Visit | Lookup → Visit | Yes | The visit the task belongs to. Filled in automatically when the visit screen creates the record. |
VisitTaskTemplateEntryId | Visit Task Template Entry | Lookup → VisitTaskTemplateEntry | | The template entry this task was created from. The visit screens use it to match the record to its task card. Pointing it at another entry removes the activities already recorded under the task and creates nothing in their place; the card keeps its copied Task Name. |
