# Hours: Gripp CRM Hours - Catalog: `GrippCrm` - Primary Keys: `id` - Label: Hours - Retrieve: True ## Table Columns The columns of the table `Hours` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `amount` | `double` | Amount | ☐ | | | `authorizedby_discr` | `varchar2` | | ☐ | | | `authorizedby_id` | `int32` | Authorized by ID | ☐ | | | `authorizedby_searchname` | `varchar2` | Authorized by Search Name | ☐ | | | `authorizedon_date` | `datetime` | Authorized on (Date) | ☐ | | | `authorizedon_timezone_type` | `int32` | Authorized on (Timezone Type) | ☐ | | | `authorizedon_timezone` | `varchar2` | Authorized on (Timezone) | ☐ | | | `createdon_date` | `datetime` | Created on Date | ☐ | | | `createdon_timezone_type` | `int32` | Created on Timezone Type | ☐ | | | `createdon_timezone` | `varchar2` | Created on Timezone | ☐ | | | `date_date` | `datetime` | Date Date | ☐ | | | `date_timezone_type` | `int32` | Date Timezone Type | ☐ | | | `date_timezone` | `varchar2` | Date Timezone | ☐ | | | `definitiveby_discr` | `varchar2` | | ☐ | | | `definitiveby_id` | `int32` | Definitive by ID | ☐ | | | `definitiveby_searchname` | `varchar2` | Definitive by Search Name | ☐ | | | `definitiveon_date` | `datetime` | Definitive on (Date) | ☐ | | | `definitiveon_timezone_type` | `int32` | Definitive on (Timezone Type) | ☐ | | | `definitiveon_timezone` | `varchar2` | Definitive on (Timezone) | ☐ | | | `description` | `varchar2` | Description | ☐ | | | `employee_discr` | `varchar2` | | ☐ | | | `employee_id` | `int32` | Employee ID | ☑ | | | `employee_searchname` | `varchar2` | Employee Search Name | ☑ | | | `extendedproperties` | `varchar2` | Extended Properties | ☐ | | | `id` | `int32` | ID | ☐ | | | `invoiceline_discr` | `varchar2` | | ☐ | | | `invoiceline_id` | `int32` | Invoice Line ID | ☐ | | | `invoiceline_searchname` | `varchar2` | Invoice Line Search Name | ☐ | | | `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 | ☐ | | | `searchname` | `varchar2` | Search Name | ☐ | | | `status_discr` | `varchar2` | | ☐ | | | `status_id` | `int32` | Status ID | ☐ | | | `status_searchname` | `varchar2` | Status Search Name | ☐ | | | `task_discr` | `varchar2` | | ☐ | | | `task_id` | `int32` | Task ID | ☐ | | | `task_searchname` | `varchar2` | Task Search Name | ☐ | | | `updatedon_date` | `datetime` | Updated on Date | ☐ | | | `updatedon_timezone_type` | `int32` | Updated on Timezone Type | ☐ | | | `updatedon_timezone` | `varchar2` | Updated on Timezone | ☐ | |