Projecten: Simplicate Projecten
insert update delete REST
- Catalogus:
Simplicate - Schema:
Projects - Primaire sleutels:
id - Label: Projecten
Haalt alle projecten op
Je kunt gegevens ophalen en wijzigen met insert, update en delete.
API-bron
- Eindpunt:
/projects/project - Operatie:
get /projects/project
Tabelkolommen
De kolommen van de tabel Projects worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
abnormal_ |
char |
Abnormaal Adres | |||
abnormal_ |
varchar2 |
Abnormaal contact-ID | |||
abnormal_ |
varchar2 |
Abnormale Organisatie ID | |||
abnormal_ |
varchar2 |
Abnormaal Persoon ID | |||
billable |
char |
Billable | |||
budget_ |
double |
itgen_spe_budget_costs_value_budget | |||
budget_ |
double |
itgen_spe_budget_costs_value_spent | |||
budget_ |
double |
itgen_spe_budget_hours_amount_budget | |||
budget_ |
double |
itgen_spe_budget_hours_amount_spent | |||
budget_ |
double |
itgen_spe_budget_hours_value_budget | |||
budget_ |
double |
itgen_spe_budget_hours_value_spent | |||
budget_ |
double |
itgen_spe_budget_total_value_budget | |||
budget_ |
double |
itgen_spe_budget_total_value_invoiced | |||
budget_ |
double |
itgen_spe_budget_total_value_spent | |||
can_ |
char |
Kan Kilometerstand Registreren | |||
contact_ |
varchar2 |
Contactpersoon ID | |||
contact_ |
varchar2 |
itgen_spe_contact_id_2 | |||
contact_ |
varchar2 |
Contact Organisatie ID | |||
contact_ |
varchar2 |
Naam Contactorganisatie | |||
contact_ |
varchar2 |
itgen_spe_contact_organization_relation_number | |||
contact_ |
varchar2 |
Volledige naam contactpersoon | |||
contact_ |
varchar2 |
Contactpersoon ID | |||
contact_ |
varchar2 |
itgen_spe_contact_person_relation_number | |||
copied_ |
char |
itgen_spe_copied_from_project_has_register_mileage_enabled | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_organization_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_organization_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_organization_relation_number | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_person_full_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_person_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_person_relation_number | |||
copied_ |
double |
itgen_spe_copied_from_project_project_manager_amount | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_declarable | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_employee_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_person_id | Toegevoegd om te voldoen aan de oorspronkelijke sales/sales responsible_employee-reactie | ||
copied_ |
double |
itgen_spe_copied_from_project_project_manager_tariff | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_number | |||
created |
varchar2 |
Created | |||
created_ |
varchar2 |
Aangemaakt op | |||
divergent_ |
int64 |
Afwijkende Betalingstermijn (dagen) | |||
divergent_ |
varchar2 |
Afwijkende Betalingstermijn-ID | |||
divergent_ |
varchar2 |
Uiteenlopende Betalingstermijn Methode | |||
divergent_ |
varchar2 |
Afwijkende Betalingstermijn Naam | |||
end_ |
varchar2 |
Einddatum | |||
hours_ |
varchar2 |
Uren Tariefsoort | |||
id |
varchar2 |
ID | |||
invoice_ |
varchar2 |
Factuur Referentie | |||
is_ |
char |
Is Factuurgoedkeuring | |||
is_ |
char |
Is omgekeerde facturering | |||
modified |
varchar2 |
Modified | |||
my_ |
varchar2 |
Mijn Organisatieprofiel ID | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_id_2 | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_organization_id | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_organization_name | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_organization_relation_number | |||
name |
varchar2 |
Name | |||
note |
varchar2 |
Note | |||
organization_ |
varchar2 |
Organisatie ID | |||
organization_ |
varchar2 |
itgen_spe_organization_id_2 | |||
organization_ |
varchar2 |
Organisatienaam | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_number | |||
person_ |
varchar2 |
Volledige Naam Persoon | |||
person_ |
varchar2 |
Persoon ID | |||
person_ |
varchar2 |
itgen_spe_person_id_2 | |||
person_ |
varchar2 |
itgen_spe_person_relation_number | |||
project_ |
double |
itgen_spe_project_manager_amount | |||
project_ |
varchar2 |
itgen_spe_project_manager_declarable | |||
project_ |
varchar2 |
itgen_spe_project_manager_employee_id | |||
project_ |
varchar2 |
itgen_spe_project_manager_id | |||
project_ |
varchar2 |
itgen_spe_project_manager_name | |||
project_ |
varchar2 |
itgen_spe_project_manager_person_id | Toegevoegd om te voldoen aan de oorspronkelijke sales/sales responsible_employee-reactie | ||
project_ |
double |
itgen_spe_project_manager_tariff | |||
project_ |
varchar2 |
Projectnummer | |||
project_ |
varchar2 |
Kleur Projectstatus | |||
project_ |
varchar2 |
Projectstatus-ID | |||
project_ |
varchar2 |
Projectstatuslabel | |||
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 | |||
start_ |
varchar2 |
Startdatum | |||
timeline_ |
varchar2 |
Tijdlijn e-mailadres | |||
updated_ |
varchar2 |
Bijgewerkt op |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: