# UmbrellaProjects: Gripp CRM Umbrella Projects - Catalog: `GrippCrm` - Primary Keys: `id` - Label: Umbrella Projects - Retrieve: True ## Table Columns The columns of the table `UmbrellaProjects` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `archivedon_date` | `datetime` | Archived on Date | ☐ | | | `archivedon_timezone_type` | `int32` | Archived on Timezone Type | ☐ | | | `archivedon_timezone` | `varchar2` | Archived on Timezone | ☐ | | | `budget` | `double` | Budget | ☐ | | | `createdon_date` | `datetime` | Created on Date | ☐ | | | `createdon_timezone_type` | `int32` | Created on Timezone Type | ☐ | | | `createdon_timezone` | `varchar2` | Created on Timezone | ☐ | | | `deadline_date` | `datetime` | Deadline Date | ☐ | | | `deadline_timezone_type` | `int32` | Deadline Timezone Type | ☐ | | | `deadline_timezone` | `varchar2` | Deadline Timezone | ☐ | | | `deliverydate_date` | `datetime` | Delivery Date (Date) | ☐ | | | `deliverydate_timezone_type` | `int32` | Delivery Date (Timezone Type) | ☐ | | | `deliverydate_timezone` | `varchar2` | Delivery Date (Timezone) | ☐ | | | `enddate_date` | `datetime` | End Date (Date) | ☐ | | | `enddate_timezone_type` | `int32` | End Date (Timezone Type) | ☐ | | | `enddate_timezone` | `varchar2` | End Date (Timezone) | ☐ | | | `id` | `int32` | ID | ☐ | | | `internalnote` | `varchar2` | Internal Note | ☐ | | | `name` | `varchar2` | Name | ☐ | | | `number` | `int32` | Number | ☐ | | | `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 | ☐ | | | `updatedon_date` | `datetime` | Updated on Date | ☐ | | | `updatedon_timezone_type` | `int32` | Updated on Timezone Type | ☐ | | | `updatedon_timezone` | `varchar2` | Updated on Timezone | ☐ | |