Tasks

Customer-related tasks with assignment and due date tracking

Columns


Name	Type	ReadOnly	References	Description
TaskUuid [KEY]	String	True		Unique task identifier
CustomerUuid	String	False	Customers.Uuid	Associated customer ID
TaskDetails	String	False		Brief task description
Assignee	String	False		Assigned user email address
CompletedAt	Datetime	False		Completion timestamp (null for ongoing)
DueDate	Datetime	False		Task due date
CreatedAt	Datetime	True		Creation timestamp
UpdatedAt	Datetime	True		Last modification timestamp

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
IsCompleted	Boolean	Filter by completion status: true for completed tasks, false for ongoing tasks