SalesTeamSales: Simplicate Verkoop Team Verkoop |
Fetches all sales
Catalogus: Simplicate
Schema: Sales
Label: Verkoop Team Verkoop
Dit is een alleen-lezen tabel. De Simplicate API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive UniversalSQL-stuurprogramma voor Simplicate ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Simplicate-API.
Tabelkolommen
De kolommen van de tabel SalesTeamSales worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
chance_to_score |
float |
Slagingskans |
☐ |
|
contact_family_name_prefix |
string |
Contact Familienaam Voorvoegsel |
☐ |
|
contact_family_name |
string |
Contact Familienaam |
☐ |
|
contact_first_name |
string |
Contactpersoon Voornaam |
☐ |
|
contact_id_2 |
string |
|
☐ |
|
contact_id |
string |
Contactpersoon ID |
☐ |
|
contact_is_active |
boolean |
|
☐ |
|
contact_person_id |
string |
Contactpersoon ID |
☐ |
|
contact_work_email |
string |
Contact Werk E-mail |
☐ |
|
contact_work_function |
string |
Contactpersoon Werk Functie |
☐ |
|
contact_work_mobile |
string |
Contactpersoon Werk Mobiel |
☐ |
|
contact_work_phone |
string |
Contactpersoon Werktelefoon |
☐ |
|
created_at |
string |
Aangemaakt op |
☐ |
|
created |
string |
Gemaakt |
☐ |
|
expected_closing_date |
string |
Verwachte sluitingsdatum |
☐ |
|
expected_revenue |
float |
Verwachte Inkomsten |
☐ |
|
id_2 |
string |
|
☐ |
|
id |
string |
ID |
☐ |
|
linked_project_has_register_mileage_enabled |
boolean |
|
☐ |
|
linked_project_id |
string |
Gelinkt Project-ID |
☐ |
|
linked_project_name |
string |
Gelinkt Projectnaam |
☐ |
|
linked_project_organization_id |
string |
Gekoppeld project Organisatie ID |
☐ |
|
linked_project_organization_name |
string |
Gekoppeld Project Organisatienaam |
☐ |
|
linked_project_organization_relation_number |
string |
|
☐ |
|
linked_project_person_full_name |
string |
Volledige Naam van Gekoppelde Projectpersoon |
☐ |
|
linked_project_person_id |
string |
Gekoppeld Project Persoon 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 |
Gekoppeld Projectnummer |
☐ |
|
lost_to_competitor_id |
string |
Verloren aan Concurrent ID |
☐ |
|
lost_to_competitor_name |
string |
Verloren aan naam van concurrent |
☐ |
|
modified |
string |
Gewijzigd |
☐ |
|
my_organization_profile_id |
string |
Mijn Organisatieprofiel ID |
☐ |
|
name |
string |
Naam |
☐ |
|
note |
string |
Notitie |
☐ |
|
organization_id_2 |
string |
|
☐ |
|
organization_id |
string |
Organisatie ID |
☐ |
|
organization_name |
string |
Organisatienaam |
☐ |
|
organization_relation_number |
string |
|
☐ |
|
person_full_name |
string |
Volledige Naam Persoon |
☐ |
|
person_id_2 |
string |
|
☐ |
|
person_id |
string |
Persoon ID |
☐ |
|
person_relation_number |
string |
|
☐ |
|
progress_chance_to_score |
float |
Vooruitgang Kans om te Scoren |
☐ |
|
progress_color |
string |
Voortgangskleur |
☐ |
|
progress_id |
string |
Voortgangs-ID |
☐ |
|
progress_label |
string |
Voortgangslabel |
☐ |
|
progress_position |
int64 |
Voortgangspositie |
☐ |
|
reason_blocked |
boolean |
|
☐ |
|
reason_id |
string |
Reden ID |
☐ |
|
reason_name |
string |
Reden Naam |
☐ |
|
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 |
Koppelings-ID |
☐ |
|
source_name |
string |
Bronnaam |
☐ |
|
start_date |
string |
Startdatum |
☐ |
|
status_id |
string |
Status-ID |
☐ |
|
status_label |
string |
Statuslabel |
☐ |
|
status_updated_at |
string |
Status geüpdatet op |
☐ |
|
subject |
string |
Onderwerp |
☐ |
|
timeline_email_address |
string |
Tijdlijn e-mailadres |
☐ |
|
updated_at |
string |
Bijgewerkt op |
☐ |
|
18-10-2024 06:48 Versie 24.0.345-PROD+4945