---
title: "SalesCustomFieldOptions (Simplicate)"
description: "itgen_spe_salescustomfieldoptions_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Sales.SalesCustomFieldOptions
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Sales.SalesCustomFieldOptions
updated: 2024-10-18T06:48:11Z
license: https://documentation.invantive.eu/en/
---

# SalesCustomFieldOptions: Simplicate itgen_spe_salescustomfieldoptions_plural

`read only` `REST`

- Catalog: `Simplicate`
- Schema: `Sales`
- Label: itgen_spe_salescustomfieldoptions_plural

Fetches all sales

Can only retrieve data.

## API Source

- Endpoint: `/sales/sales`
- Operation: `get /sales/sales`

## Table Columns

The columns of the table `SalesCustomFieldOptions` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `chance_to_score` | `double` | Chance to Score | [ ] |  |  |
| `contact_family_name` | `varchar2` | Contact Family Name | [ ] |  |  |
| `contact_family_name_prefix` | `varchar2` | Contact Family Name Prefix | [ ] |  |  |
| `contact_first_name` | `varchar2` | Contact First Name | [ ] |  |  |
| `contact_id` | `varchar2` | Contact ID | [ ] |  |  |
| `contact_id_2` | `varchar2` | itgen_spe_contact_id_2 | [ ] |  |  |
| `contact_is_active` | `char` | itgen_spe_contact_is_active | [ ] |  |  |
| `contact_person_id` | `varchar2` | Contact Person ID | [ ] |  |  |
| `contact_work_email` | `varchar2` | Contact Work Email | [ ] |  |  |
| `contact_work_function` | `varchar2` | Contact Work Function | [ ] |  |  |
| `contact_work_mobile` | `varchar2` | Contact Work Mobile | [ ] |  |  |
| `contact_work_phone` | `varchar2` | Contact Work Phone | [ ] |  |  |
| `created` | `varchar2` | Created | [ ] |  |  |
| `created_at` | `varchar2` | Created at | [ ] |  |  |
| `custom_field_group_id` | `varchar2` | Custom Field Group ID | [ ] |  |  |
| `custom_field_group_model_id` | `varchar2` | Custom Field Group Model ID | [ ] |  |  |
| `custom_field_group_model_label` | `varchar2` | Custom Field Group Model Label | [ ] |  |  |
| `custom_field_group_name` | `varchar2` | Custom Field Group Name | [ ] |  |  |
| `custom_field_group_position` | `varchar2` | Custom Field Group Position | [ ] |  |  |
| `custom_field_group_type` | `varchar2` | Custom Field Group Type | [ ] |  |  |
| `expected_closing_date` | `varchar2` | Expected Closing Date | [ ] |  |  |
| `expected_revenue` | `double` | Expected Revenue | [ ] |  |  |
| `filterable` | `char` | Filterable | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `id_2` | `varchar2` | itgen_spe_id_2 | [ ] |  |  |
| `id_3` | `varchar2` | itgen_spe_id_3 | [ ] |  |  |
| `label` | `varchar2` | Label | [ ] |  |  |
| `label_2` | `varchar2` | itgen_spe_label_2 | [ ] |  |  |
| `linked_project_has_register_mileage_enabled` | `char` | itgen_spe_linked_project_has_register_mileage_enabled | [ ] |  |  |
| `linked_project_id` | `varchar2` | Linked Project ID | [ ] |  |  |
| `linked_project_name` | `varchar2` | Linked Project Name | [ ] |  |  |
| `linked_project_organization_id` | `varchar2` | Linked Project Organisation ID | [ ] |  |  |
| `linked_project_organization_name` | `varchar2` | Linked Project Organisation Name | [ ] |  |  |
| `linked_project_organization_relation_number` | `varchar2` | itgen_spe_linked_project_organization_relation_number | [ ] |  |  |
| `linked_project_person_full_name` | `varchar2` | Linked Project Person Full Name | [ ] |  |  |
| `linked_project_person_id` | `varchar2` | Linked Project Person ID | [ ] |  |  |
| `linked_project_person_relation_number` | `varchar2` | itgen_spe_linked_project_person_relation_number | [ ] |  |  |
| `linked_project_project_manager_amount` | `double` | itgen_spe_linked_project_project_manager_amount | [ ] |  |  |
| `linked_project_project_manager_declarable` | `varchar2` | itgen_spe_linked_project_project_manager_declarable | [ ] |  |  |
| `linked_project_project_manager_employee_id` | `varchar2` | itgen_spe_linked_project_project_manager_employee_id | [ ] |  |  |
| `linked_project_project_manager_id` | `varchar2` | itgen_spe_linked_project_project_manager_id | [ ] |  |  |
| `linked_project_project_manager_name` | `varchar2` | itgen_spe_linked_project_project_manager_name | [ ] |  |  |
| `linked_project_project_manager_person_id` | `varchar2` | itgen_spe_linked_project_project_manager_person_id | [ ] |  | Added in order to comply with the original sales/sales responsible_employee response |
| `linked_project_project_manager_tariff` | `double` | itgen_spe_linked_project_project_manager_tariff | [ ] |  |  |
| `linked_project_project_number` | `varchar2` | Linked Project Number | [ ] |  |  |
| `lost_to_competitor_id` | `varchar2` | Lost to Competitor ID | [ ] |  |  |
| `lost_to_competitor_name` | `varchar2` | Lost to Competitor Name | [ ] |  |  |
| `mandatory` | `char` | itgen_spe_mandatory | [ ] |  |  |
| `modified` | `varchar2` | Modified | [ ] |  |  |
| `my_organization_profile_id` | `varchar2` | My Organisation Profile ID | [ ] |  |  |
| `name` | `varchar2` | Name | [ ] |  |  |
| `note` | `varchar2` | Note | [ ] |  |  |
| `organization_id` | `varchar2` | Organisation ID | [ ] |  |  |
| `organization_id_2` | `varchar2` | itgen_spe_organization_id_2 | [ ] |  |  |
| `organization_name` | `varchar2` | Organisation Name | [ ] |  |  |
| `organization_relation_number` | `varchar2` | itgen_spe_organization_relation_number | [ ] |  |  |
| `person_full_name` | `varchar2` | Person Full Name | [ ] |  |  |
| `person_id` | `varchar2` | Person ID | [ ] |  |  |
| `person_id_2` | `varchar2` | itgen_spe_person_id_2 | [ ] |  |  |
| `person_relation_number` | `varchar2` | itgen_spe_person_relation_number | [ ] |  |  |
| `position` | `int64` | Position | [ ] |  |  |
| `position_2` | `int64` | itgen_spe_position_2 | [ ] |  |  |
| `progress_chance_to_score` | `double` | Progress Chance to Score | [ ] |  |  |
| `progress_color` | `varchar2` | Progress Colour | [ ] |  |  |
| `progress_id` | `varchar2` | Progress ID | [ ] |  |  |
| `progress_label` | `varchar2` | Progress Label | [ ] |  |  |
| `progress_position` | `int64` | Progress Position | [ ] |  |  |
| `reason_blocked` | `char` | itgen_spe_reason_blocked | [ ] |  |  |
| `reason_id` | `varchar2` | Reason ID | [ ] |  |  |
| `reason_name` | `varchar2` | Reason Name | [ ] |  |  |
| `render_type` | `varchar2` | Render Type | [ ] |  |  |
| `responsible_employee_amount` | `double` | itgen_spe_responsible_employee_amount | [ ] |  |  |
| `responsible_employee_declarable` | `varchar2` | itgen_spe_responsible_employee_declarable | [ ] |  |  |
| `responsible_employee_employee_id` | `varchar2` | itgen_spe_responsible_employee_employee_id | [ ] |  |  |
| `responsible_employee_id` | `varchar2` | itgen_spe_responsible_employee_id | [ ] |  |  |
| `responsible_employee_name` | `varchar2` | itgen_spe_responsible_employee_name | [ ] |  |  |
| `responsible_employee_person_id` | `varchar2` | itgen_spe_responsible_employee_person_id | [ ] |  | Added in order to comply with the original sales/sales responsible_employee response |
| `responsible_employee_tariff` | `double` | itgen_spe_responsible_employee_tariff | [ ] |  |  |
| `searchable` | `char` | Searchable | [ ] |  |  |
| `separate_invoice_recipient_contact_id` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_id | [ ] |  |  |
| `separate_invoice_recipient_contact_organization_id` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_organization_id | [ ] |  |  |
| `separate_invoice_recipient_contact_organization_name` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_organization_name | [ ] |  |  |
| `separate_invoice_recipient_contact_organization_relation_number` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_organization_relation_number | [ ] |  |  |
| `separate_invoice_recipient_contact_person_full_name` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_person_full_name | [ ] |  |  |
| `separate_invoice_recipient_contact_person_id` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_person_id | [ ] |  |  |
| `separate_invoice_recipient_contact_person_relation_number` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_person_relation_number | [ ] |  |  |
| `separate_invoice_recipient_is_separate_invoice_recipient` | `char` | itgen_spe_separate_invoice_recipient_is_separate_invoice_recipient | [ ] |  |  |
| `separate_invoice_recipient_organization_id` | `varchar2` | itgen_spe_separate_invoice_recipient_organization_id | [ ] |  |  |
| `separate_invoice_recipient_organization_name` | `varchar2` | itgen_spe_separate_invoice_recipient_organization_name | [ ] |  |  |
| `separate_invoice_recipient_organization_relation_number` | `varchar2` | itgen_spe_separate_invoice_recipient_organization_relation_number | [ ] |  |  |
| `separate_invoice_recipient_person_full_name` | `varchar2` | itgen_spe_separate_invoice_recipient_person_full_name | [ ] |  |  |
| `separate_invoice_recipient_person_id` | `varchar2` | itgen_spe_separate_invoice_recipient_person_id | [ ] |  |  |
| `separate_invoice_recipient_person_relation_number` | `varchar2` | itgen_spe_separate_invoice_recipient_person_relation_number | [ ] |  |  |
| `simplicate_url` | `varchar2` | Simplicate URL | [ ] |  |  |
| `source_id` | `varchar2` | Source ID | [ ] |  |  |
| `source_name` | `varchar2` | Source Name | [ ] |  |  |
| `start_date` | `varchar2` | Start Date | [ ] |  |  |
| `status_id` | `varchar2` | Status ID | [ ] |  |  |
| `status_label` | `varchar2` | Status Label | [ ] |  |  |
| `status_updated_at` | `varchar2` | Status Updated at | [ ] |  |  |
| `subject` | `varchar2` | Subject | [ ] |  |  |
| `timeline_email_address` | `varchar2` | Timeline Email Address | [ ] |  |  |
| `type` | `varchar2` | Type | [ ] |  |  |
| `updated_at` | `varchar2` | Updated at | [ ] |  |  |
| `value` | `varchar2` | Value | [ ] |  |  |
| `value_2` | `varchar2` | itgen_spe_value_2 | [ ] |  |  |
| `value_type` | `varchar2` | Value Type | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Simplicate](/en/release-notes/drivers?driver=simplicate)

