# Units: Gripp CRM Units
- Catalog: `GrippCrm`
- Primary Keys: `id`
- Label: Units
- Retrieve: True
## Table Columns
The columns of the table `Units` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `createdon_date` | `datetime` | Created on Date | ☐ | |
| `createdon_timezone_type` | `int32` | Created on Timezone Type | ☐ | |
| `createdon_timezone` | `varchar2` | Created on Timezone | ☐ | |
| `extendedproperties` | `varchar2` | Extended Properties | ☐ | |
| `hoursperunit` | `double` | Hours per Unit | ☐ | |
| `id` | `int32` | ID | ☐ | |
| `name` | `varchar2` | Name | ☐ | |
| `searchname` | `varchar2` | Search Name | ☐ | |
| `unittype_discr` | `varchar2` | | ☐ | |
| `unittype_id` | `int32` | Unit Type ID | ☐ | |
| `unittype_searchname` | `varchar2` | Unit Type Search Name | ☐ | |
| `updatedon_date` | `datetime` | Updated on Date | ☐ | |
| `updatedon_timezone_type` | `int32` | Updated on Timezone Type | ☐ | |
| `updatedon_timezone` | `varchar2` | Updated on Timezone | ☐ | |