Tasks

The CRM Fields custom field is available for the Tasks table.

Columns

Name Type Length Precision Scale References In Description
assigned_id NUMBER 39 0 Assigned to
date_created TIMESTAMP Date created
date_last_modified TIMESTAMP Date last modified (GMT)
due_date TIMESTAMP Due date
estimated_hours NUMBER 12 5 Initial Time Budget
estimated_hours_override NUMBER 12 5 Estimated Work
isinactive VARCHAR2 3 Inactive
message VARCHAR2 4000 Message
name VARCHAR2 256 Name
owner_id NUMBER 39 0 Owner ID
priority VARCHAR2 32 Priority
start_date TIMESTAMP Start date
status VARCHAR2 64 Status
task_extid VARCHAR2 255 Task external ID
task_id NUMBER 39 0 Task ID
taskorder NUMBER 39 0 Task order