# SalesCustomFieldOptions Fetches all sales This is a read-only table. The Simplicate API may not support modifying the data, or the Invantive UniversalSQL driver for Simplicate does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the Simplicate API. - Catalog: `Simplicate` - Schema: `Sales` ## Table Columns The columns of the table `SalesCustomFieldOptions` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `chance_to_score` | `float` | Chance of Success | ☐ | | | `contact_family_name_prefix` | `string` | Contact Family Name Prefix | ☐ | | | `contact_family_name` | `string` | Contact Family Name | ☐ | | | `contact_first_name` | `string` | Contact Person First Name | ☐ | | | `contact_id_2` | `string` | | ☐ | | | `contact_id` | `string` | Contact Person ID | ☐ | | | `contact_is_active` | `boolean` | | ☐ | | | `contact_person_id` | `string` | Contact Person ID | ☐ | | | `contact_work_email` | `string` | Contact Work Email | ☐ | | | `contact_work_function` | `string` | Contact Person Work Job Title | ☐ | | | `contact_work_mobile` | `string` | Contact Person Work Mobile | ☐ | | | `contact_work_phone` | `string` | Contact Person Work Phone | ☐ | | | `created_at` | `string` | Created On | ☐ | | | `created` | `string` | Created | ☐ | | | `custom_field_group_id` | `string` | Custom Field Group ID | ☐ | | | `custom_field_group_model_id` | `string` | Custom Field Group Model ID | ☐ | | | `custom_field_group_model_label` | `string` | Custom Field Group Model Label | ☐ | | | `custom_field_group_name` | `string` | Custom Field Group Name | ☐ | | | `custom_field_group_position` | `string` | Custom Field Group Position | ☐ | | | `custom_field_group_type` | `string` | Custom Field Group Type | ☐ | | | `expected_closing_date` | `string` | Expected Closing Date | ☐ | | | `expected_revenue` | `float` | Expected Revenue | ☐ | | | `filterable` | `boolean` | Filterable | ☐ | | | `id_2` | `string` | | ☐ | | | `id_3` | `string` | | ☐ | | | `id` | `string` | ID | ☐ | | | `label_2` | `string` | | ☐ | | | `label` | `string` | Label | ☐ | | | `linked_project_has_register_mileage_enabled` | `boolean` | | ☐ | | | `linked_project_id` | `string` | Linked Project ID | ☐ | | | `linked_project_name` | `string` | Linked Project Name | ☐ | | | `linked_project_organization_id` | `string` | Linked Project Organisation ID | ☐ | | | `linked_project_organization_name` | `string` | Linked Project Organisation Name | ☐ | | | `linked_project_organization_relation_number` | `string` | | ☐ | | | `linked_project_person_full_name` | `string` | Linked Project Person Full Name | ☐ | | | `linked_project_person_id` | `string` | Linked Project Person ID | ☐ | | | `linked_project_person_relation_number` | `string` | | ☐ | | | `linked_project_project_manager_amount` | `float` | | ☐ | | | `linked_project_project_manager_declarable` | `string` | | ☐ | | | `linked_project_project_manager_employee_id` | `string` | | ☐ | | | `linked_project_project_manager_id` | `string` | | ☐ | | | `linked_project_project_manager_name` | `string` | | ☐ | | | `linked_project_project_manager_person_id` | `string` | | ☐ | Added in order to comply with the original sales/sales responsible_employee response | | `linked_project_project_manager_tariff` | `float` | | ☐ | | | `linked_project_project_number` | `string` | Linked Project Number | ☐ | | | `lost_to_competitor_id` | `string` | Lost to Competitor ID | ☐ | | | `lost_to_competitor_name` | `string` | Lost to Competitor Name | ☐ | | | `mandatory` | `boolean` | | ☐ | | | `modified` | `string` | Modified | ☐ | | | `my_organization_profile_id` | `string` | My Organisation Profile ID | ☐ | | | `name` | `string` | Name | ☐ | | | `note` | `string` | Note | ☐ | | | `organization_id_2` | `string` | | ☐ | | | `organization_id` | `string` | Organisation ID | ☐ | | | `organization_name` | `string` | Organisation Name | ☐ | | | `organization_relation_number` | `string` | | ☐ | | | `person_full_name` | `string` | Person Full Name | ☐ | | | `person_id_2` | `string` | | ☐ | | | `person_id` | `string` | Person ID | ☐ | | | `person_relation_number` | `string` | | ☐ | | | `position_2` | `int64` | | ☐ | | | `position` | `int64` | Position | ☐ | | | `progress_chance_to_score` | `float` | Progress Chance of Success | ☐ | | | `progress_color` | `string` | Progress Colour | ☐ | | | `progress_id` | `string` | Progress ID | ☐ | | | `progress_label` | `string` | Progress Label | ☐ | | | `progress_position` | `int64` | Progress Position | ☐ | | | `reason_blocked` | `boolean` | | ☐ | | | `reason_id` | `string` | Reason ID | ☐ | | | `reason_name` | `string` | Reason Name | ☐ | | | `render_type` | `string` | Render Type | ☐ | | | `responsible_employee_amount` | `float` | | ☐ | | | `responsible_employee_declarable` | `string` | | ☐ | | | `responsible_employee_employee_id` | `string` | | ☐ | | | `responsible_employee_id` | `string` | | ☐ | | | `responsible_employee_name` | `string` | | ☐ | | | `responsible_employee_person_id` | `string` | | ☐ | Added in order to comply with the original sales/sales responsible_employee response | | `responsible_employee_tariff` | `float` | | ☐ | | | `searchable` | `boolean` | Searchable | ☐ | | | `separate_invoice_recipient_contact_id` | `string` | | ☐ | | | `separate_invoice_recipient_contact_organization_id` | `string` | | ☐ | | | `separate_invoice_recipient_contact_organization_name` | `string` | | ☐ | | | `separate_invoice_recipient_contact_organization_relation_number` | `string` | | ☐ | | | `separate_invoice_recipient_contact_person_full_name` | `string` | | ☐ | | | `separate_invoice_recipient_contact_person_id` | `string` | | ☐ | | | `separate_invoice_recipient_contact_person_relation_number` | `string` | | ☐ | | | `separate_invoice_recipient_is_separate_invoice_recipient` | `boolean` | | ☐ | | | `separate_invoice_recipient_organization_id` | `string` | | ☐ | | | `separate_invoice_recipient_organization_name` | `string` | | ☐ | | | `separate_invoice_recipient_organization_relation_number` | `string` | | ☐ | | | `separate_invoice_recipient_person_full_name` | `string` | | ☐ | | | `separate_invoice_recipient_person_id` | `string` | | ☐ | | | `separate_invoice_recipient_person_relation_number` | `string` | | ☐ | | | `simplicate_url` | `string` | Simplicate URL | ☐ | | | `source_id` | `string` | Link ID | ☐ | | | `source_name` | `string` | Source Name | ☐ | | | `start_date` | `string` | Start Date | ☐ | | | `status_id` | `string` | Status ID | ☐ | | | `status_label` | `string` | Status Label | ☐ | | | `status_updated_at` | `string` | Status Updated On | ☐ | | | `subject` | `string` | Subject | ☐ | | | `timeline_email_address` | `string` | Timeline Email Address | ☐ | | | `type` | `string` | Type | ☐ | | | `updated_at` | `string` | Updated On | ☐ | | | `value_2` | `string` | | ☐ | | | `value_type` | `string` | Value Type | ☐ | | | `value` | `string` | Value | ☐ | |