SalesTeamSales: Simplicate Sales Team Sales
read only REST
- Catalog:
Simplicate - Schema:
Sales - Label: Sales Team Sales
Fetches all sales
Can only retrieve data.
API Source
- Endpoint:
/sales/sales - Operation:
get /sales/sales
Table Columns
The columns of the table SalesTeamSales 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_ |
double |
Chance to Score | |||
contact_ |
varchar2 |
Contact Family Name | |||
contact_ |
varchar2 |
Contact Family Name Prefix | |||
contact_ |
varchar2 |
Contact First Name | |||
contact_ |
varchar2 |
Contact ID | |||
contact_ |
varchar2 |
itgen_spe_contact_id_2 | |||
contact_ |
char |
itgen_spe_contact_is_active | |||
contact_ |
varchar2 |
Contact Person ID | |||
contact_ |
varchar2 |
Contact Work Email | |||
contact_ |
varchar2 |
Contact Work Function | |||
contact_ |
varchar2 |
Contact Work Mobile | |||
contact_ |
varchar2 |
Contact Work Phone | |||
created |
varchar2 |
Created | |||
created_ |
varchar2 |
Created at | |||
expected_ |
varchar2 |
Expected Closing Date | |||
expected_ |
double |
Expected Revenue | |||
id |
varchar2 |
ID | |||
id_2 |
varchar2 |
itgen_spe_id_2 | |||
linked_ |
char |
itgen_spe_linked_project_has_register_mileage_enabled | |||
linked_ |
varchar2 |
Linked Project ID | |||
linked_ |
varchar2 |
Linked Project Name | |||
linked_ |
varchar2 |
Linked Project Organisation ID | |||
linked_ |
varchar2 |
Linked Project Organisation Name | |||
linked_ |
varchar2 |
itgen_spe_linked_project_organization_relation_number | |||
linked_ |
varchar2 |
Linked Project Person Full Name | |||
linked_ |
varchar2 |
Linked Project Person ID | |||
linked_ |
varchar2 |
itgen_spe_linked_project_person_relation_number | |||
linked_ |
double |
itgen_spe_linked_project_project_manager_amount | |||
linked_ |
varchar2 |
itgen_spe_linked_project_project_manager_declarable | |||
linked_ |
varchar2 |
itgen_spe_linked_project_project_manager_employee_id | |||
linked_ |
varchar2 |
itgen_spe_linked_project_project_manager_id | |||
linked_ |
varchar2 |
itgen_spe_linked_project_project_manager_name | |||
linked_ |
varchar2 |
itgen_spe_linked_project_project_manager_person_id | Added in order to comply with the original sales/sales responsible_employee response | ||
linked_ |
double |
itgen_spe_linked_project_project_manager_tariff | |||
linked_ |
varchar2 |
Linked Project Number | |||
lost_ |
varchar2 |
Lost to Competitor ID | |||
lost_ |
varchar2 |
Lost to Competitor Name | |||
modified |
varchar2 |
Modified | |||
my_ |
varchar2 |
My Organisation Profile ID | |||
name |
varchar2 |
Name | |||
note |
varchar2 |
Note | |||
organization_ |
varchar2 |
Organisation ID | |||
organization_ |
varchar2 |
itgen_spe_organization_id_2 | |||
organization_ |
varchar2 |
Organisation Name | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_number | |||
person_ |
varchar2 |
Person Full Name | |||
person_ |
varchar2 |
Person ID | |||
person_ |
varchar2 |
itgen_spe_person_id_2 | |||
person_ |
varchar2 |
itgen_spe_person_relation_number | |||
progress_ |
double |
Progress Chance to Score | |||
progress_ |
varchar2 |
Progress Colour | |||
progress_ |
varchar2 |
Progress ID | |||
progress_ |
varchar2 |
Progress Label | |||
progress_ |
int64 |
Progress Position | |||
reason_ |
char |
itgen_spe_reason_blocked | |||
reason_ |
varchar2 |
Reason ID | |||
reason_ |
varchar2 |
Reason Name | |||
responsible_ |
double |
itgen_spe_responsible_employee_amount | |||
responsible_ |
varchar2 |
itgen_spe_responsible_employee_declarable | |||
responsible_ |
varchar2 |
itgen_spe_responsible_employee_employee_id | |||
responsible_ |
varchar2 |
itgen_spe_responsible_employee_id | |||
responsible_ |
varchar2 |
itgen_spe_responsible_employee_name | |||
responsible_ |
varchar2 |
itgen_spe_responsible_employee_person_id | Added in order to comply with the original sales/sales responsible_employee response | ||
responsible_ |
double |
itgen_spe_responsible_employee_tariff | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_organization_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_organization_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_organization_relation_number | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_person_full_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_person_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_person_relation_number | |||
separate_ |
char |
itgen_spe_separate_invoice_recipient_is_separate_invoice_recipient | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_organization_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_organization_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_organization_relation_number | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_person_full_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_person_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_person_relation_number | |||
simplicate_ |
varchar2 |
Simplicate URL | |||
source_ |
varchar2 |
Source ID | |||
source_ |
varchar2 |
Source Name | |||
start_ |
varchar2 |
Start Date | |||
status_ |
varchar2 |
Status ID | |||
status_ |
varchar2 |
Status Label | |||
status_ |
varchar2 |
Status Updated at | |||
subject |
varchar2 |
Subject | |||
timeline_ |
varchar2 |
Timeline Email Address | |||
updated_ |
varchar2 |
Updated at |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: