# Sales: Simplicate Seller Fetches all sales - Catalog: `Simplicate` - Schema: `Sales` - Primary Keys: `id` - Label: Seller - Retrieve: true - Insert: true - Update: true - Delete: false ## Table Columns The columns of the table `Sales` 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 | ☐ | | | `expected_closing_date` | `string` | Expected Closing Date | ☐ | | | `expected_revenue` | `float` | Expected Revenue | ☐ | | | `id` | `string` | ID | ☐ | | | `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 | ☐ | | | `modified` | `string` | Modified | ☐ | | | `my_organization_profile_id` | `string` | My Organisation Profile ID | ☐ | | | `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` | | ☐ | | | `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 | ☐ | | | `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` | | ☐ | | | `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 | ☐ | | | `updated_at` | `string` | Updated On | ☐ | |