# Tasks: Gripp CRM Tasks - Catalog: `GrippCrm` - Primary Keys: `id` - Label: Tasks - Retrieve: True ## Table Columns The columns of the table `Tasks` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `checklist` | `varchar2` | Checklist | ☐ | | | `company_discr` | `varchar2` | | ☐ | | | `company_id` | `int32` | Company ID | ☐ | | | `company_searchname` | `varchar2` | Company Search Name | ☐ | | | `completedon_date` | `datetime` | Completed on (Date) | ☐ | | | `completedon_timezone_type` | `int32` | Completed on (Timezone Type) | ☐ | | | `completedon_timezone` | `varchar2` | Completed on (Timezone) | ☐ | | | `content` | `varchar2` | Content | ☐ | | | `createdon_date` | `datetime` | Created on Date | ☐ | | | `createdon_timezone_type` | `int32` | Created on Timezone Type | ☐ | | | `createdon_timezone` | `varchar2` | Created on Timezone | ☐ | | | `deadlinedate_date` | `datetime` | Deadline Date (Date) | ☐ | | | `deadlinedate_timezone_type` | `int32` | Deadline Date (Timezone Type) | ☐ | | | `deadlinedate_timezone` | `varchar2` | Deadline Date (Timezone) | ☐ | | | `deadlinetime` | `datetime` | Deadline Time | ☐ | | | `description` | `varchar2` | Description | ☐ | | | `estimatedhours` | `double` | Estimated Hours | ☐ | | | `extendedproperties` | `varchar2` | Extended Properties | ☐ | | | `id` | `int32` | ID | ☐ | | | `isafgerond` | `char` | | ☐ | | | `number` | `int32` | Number | ☐ | | | `offerprojectbase_discr` | `varchar2` | | ☐ | | | `offerprojectbase_id` | `int32` | Offer Project Base ID | ☐ | | | `offerprojectbase_searchname` | `varchar2` | Offer Project Base Search Name | ☐ | | | `offerprojectline_discr` | `varchar2` | | ☐ | | | `offerprojectline_id` | `int32` | Offer Project Line ID | ☐ | | | `offerprojectline_searchname` | `varchar2` | Offer Project Line Search Name | ☐ | | | `phase_discr` | `varchar2` | | ☐ | | | `phase_id` | `int32` | Phase ID | ☐ | | | `phase_searchname` | `varchar2` | Phase Search Name | ☐ | | | `searchname` | `varchar2` | Search Name | ☐ | | | `startdate_date` | `datetime` | Start Date Date | ☐ | | | `startdate_timezone_type` | `int32` | Start Date Timezone Type | ☐ | | | `startdate_timezone` | `varchar2` | Start Date Timezone | ☐ | | | `type_discr` | `varchar2` | | ☐ | | | `type_id` | `int32` | Type ID | ☐ | | | `type_searchname` | `varchar2` | Type Search Name | ☐ | | | `updatedon_date` | `datetime` | Updated on Date | ☐ | | | `updatedon_timezone_type` | `int32` | Updated on Timezone Type | ☐ | | | `updatedon_timezone` | `varchar2` | Updated on Timezone | ☐ | |