# Offers: Gripp CRM Offers - Catalog: `GrippCrm` - Primary Keys: `id` - Label: Offers - Retrieve: True ## Table Columns The columns of the table `Offers` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `acceptancestatus_discr` | `varchar2` | | ☐ | | | `acceptancestatus_id` | `int32` | Acceptance Status ID | ☐ | | | `acceptancestatus_searchname` | `varchar2` | Acceptance Status Search Name | ☐ | | | `acceptedon_date` | `datetime` | Accepted on (Date) | ☐ | | | `acceptedon_timezone_type` | `int32` | Accepted on (Timezone Type) | ☐ | | | `acceptedon_timezone` | `varchar2` | Accepted on (Timezone) | ☐ | | | `accountmanager_discr` | `varchar2` | | ☐ | | | `accountmanager_id` | `int32` | Accountmanager ID | ☐ | | | `accountmanager_searchname` | `varchar2` | Accountmanager Search Name | ☐ | | | `archived` | `char` | Archived | ☐ | | | `archivedon_date` | `datetime` | Archived on Date | ☐ | | | `archivedon_timezone_type` | `int32` | Archived on Timezone Type | ☐ | | | `archivedon_timezone` | `varchar2` | Archived on Timezone | ☐ | | | `chance` | `int32` | Chance | ☐ | | | `clientreference` | `varchar2` | Client Reference | ☐ | | | `company_discr` | `varchar2` | | ☐ | | | `company_id` | `int32` | Company ID | ☐ | | | `company_searchname` | `varchar2` | Company Search Name | ☐ | | | `contact_discr` | `varchar2` | | ☐ | | | `contact_id` | `int32` | Contact ID | ☐ | | | `contact_searchname` | `varchar2` | Contact Search Name | ☐ | | | `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 | ☐ | | | `deadline_date` | `datetime` | Deadline Date | ☐ | | | `deadline_timezone_type` | `int32` | Deadline Timezone Type | ☐ | | | `deadline_timezone` | `varchar2` | Deadline Timezone | ☐ | | | `description` | `varchar2` | Description | ☐ | | | `expectedterms` | `int32` | Expected Terms | ☐ | | | `extendedproperties` | `varchar2` | Extended Properties | ☐ | | | `extrapdf1_discr` | `varchar2` | | ☐ | | | `extrapdf1_id` | `int32` | | ☐ | | | `extrapdf1_searchname` | `varchar2` | | ☐ | | | `extrapdf2_discr` | `varchar2` | | ☐ | | | `extrapdf2_id` | `int32` | | ☐ | | | `extrapdf2_searchname` | `varchar2` | | ☐ | | | `filesavailableforclient` | `char` | | ☐ | | | `frequency_discr` | `varchar2` | | ☐ | | | `frequency_id` | `int32` | Frequency ID | ☐ | | | `frequency_searchname` | `varchar2` | Frequency Search Name | ☐ | | | `id` | `int32` | ID | ☐ | | | `identity_discr` | `varchar2` | | ☐ | | | `identity_id` | `int32` | Identity ID | ☐ | | | `identity_searchname` | `varchar2` | Identity Search Name | ☐ | | | `isbasis` | `char` | Is Basis | ☐ | | | `isopportunity` | `char` | Is Opportunity | ☐ | | | `name` | `varchar2` | Name | ☑ | | | `number` | `int32` | Number | ☐ | | | `paymentmethod_discr` | `varchar2` | | ☐ | | | `paymentmethod_id` | `int32` | Payment Method ID | ☐ | | | `paymentmethod_searchname` | `varchar2` | Payment Method Search Name | ☐ | | | `phase_discr` | `varchar2` | | ☐ | | | `phase_id` | `int32` | Phase ID | ☐ | | | `phase_searchname` | `varchar2` | Phase Search Name | ☐ | | | `renewautomatically` | `char` | Renew Automatically | ☐ | | | `renewperiods` | `int32` | Renew Periods | ☐ | | | `salesassociate_discr` | `varchar2` | | ☐ | | | `salesassociate_id` | `int32` | | ☐ | | | `salesassociate_searchname` | `varchar2` | | ☐ | | | `salesdistributiondatestart_date` | `datetime` | | ☐ | | | `salesdistributiondatestart_timezone_type` | `int32` | | ☐ | | | `salesdistributiondatestart_timezone` | `varchar2` | | ☐ | | | `salesdistributiondatestop_date` | `datetime` | | ☐ | | | `salesdistributiondatestop_timezone_type` | `int32` | | ☐ | | | `salesdistributiondatestop_timezone` | `varchar2` | | ☐ | | | `searchname` | `varchar2` | Search Name | ☐ | | | `sendmaxtimes` | `int32` | Send Max. Times | ☐ | | | `sendmaxtimescheckbox` | `char` | Send Max. Times Checkbox | ☐ | | | `signingenabled` | `char` | Signing Enabled | ☐ | | | `status_discr` | `varchar2` | | ☐ | | | `status_id` | `int32` | Status ID | ☐ | | | `status_searchname` | `varchar2` | Status Search Name | ☐ | | | `subject` | `varchar2` | Subject | ☐ | | | `template_discr` | `varchar2` | | ☐ | | | `template_id` | `int32` | Template ID | ☐ | | | `template_searchname` | `varchar2` | Template Search Name | ☐ | | | `totalexclvat` | `double` | Total excl. VAT | ☐ | | | `totalinclvat` | `double` | Total incl. VAT | ☐ | | | `umbrellaproject_discr` | `varchar2` | | ☐ | | | `umbrellaproject_id` | `int32` | Umbrella Project ID | ☐ | | | `umbrellaproject_searchname` | `varchar2` | Umbrella Project Search Name | ☐ | | | `updatedon_date` | `datetime` | Updated on Date | ☐ | | | `updatedon_timezone_type` | `int32` | Updated on Timezone Type | ☐ | | | `updatedon_timezone` | `varchar2` | Updated on Timezone | ☐ | | | `validfor_discr` | `varchar2` | | ☐ | | | `validfor_id` | `int32` | Valid for ID | ☐ | | | `validfor_searchname` | `varchar2` | Valid for Search Name | ☐ | | | `validity_discr` | `varchar2` | | ☐ | | | `validity_id` | `int32` | Validity ID | ☐ | | | `validity_searchname` | `varchar2` | Validity Search Name | ☐ | | | `workdeliveraddress` | `varchar2` | Work Deliver Address | ☐ | |