invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

ProjectCustomFieldOptions: Simplicate itgen_spe_projectcustomfieldoptions_plural

read only REST

  • Catalogus: Simplicate
  • Schema: Projects
  • Label: itgen_spe_projectcustomfieldoptions_plural

Haalt alle projecten op

Kan alleen gegevens ophalen.

API-bron

  • Eindpunt: /projects/project
  • Operatie: get /projects/project

Tabelkolommen

De kolommen van de tabel ProjectCustomFieldOptions 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_address char Abnormaal Adres
abnormal_contact_id varchar2 Abnormaal contact-ID
abnormal_organization_id varchar2 Abnormale Organisatie ID
abnormal_person_id varchar2 Abnormaal Persoon ID
billable char Billable
budget_costs_value_budget double itgen_spe_budget_costs_value_budget
budget_costs_value_spent double itgen_spe_budget_costs_value_spent
budget_hours_amount_budget double itgen_spe_budget_hours_amount_budget
budget_hours_amount_spent double itgen_spe_budget_hours_amount_spent
budget_hours_value_budget double itgen_spe_budget_hours_value_budget
budget_hours_value_spent double itgen_spe_budget_hours_value_spent
budget_total_value_budget double itgen_spe_budget_total_value_budget
budget_total_value_invoiced double itgen_spe_budget_total_value_invoiced
budget_total_value_spent double itgen_spe_budget_total_value_spent
can_register_mileage char Kan Kilometerstand Registreren
contact_id varchar2 Contactpersoon ID
contact_id_2 varchar2 itgen_spe_contact_id_2
contact_organization_id varchar2 Contact Organisatie ID
contact_organization_name varchar2 Naam Contactorganisatie
contact_organization_relation_number varchar2 itgen_spe_contact_organization_relation_number
contact_person_full_name varchar2 Volledige naam contactpersoon
contact_person_id varchar2 Contactpersoon ID
contact_person_relation_number varchar2 itgen_spe_contact_person_relation_number
copied_from_project_has_register_mileage_enabled char itgen_spe_copied_from_project_has_register_mileage_enabled
copied_from_project_id varchar2 itgen_spe_copied_from_project_id
copied_from_project_name varchar2 itgen_spe_copied_from_project_name
copied_from_project_organization_id varchar2 itgen_spe_copied_from_project_organization_id
copied_from_project_organization_name varchar2 itgen_spe_copied_from_project_organization_name
copied_from_project_organization_relation_number varchar2 itgen_spe_copied_from_project_organization_relation_number
copied_from_project_person_full_name varchar2 itgen_spe_copied_from_project_person_full_name
copied_from_project_person_id varchar2 itgen_spe_copied_from_project_person_id
copied_from_project_person_relation_number varchar2 itgen_spe_copied_from_project_person_relation_number
copied_from_project_project_manager_amount double itgen_spe_copied_from_project_project_manager_amount
copied_from_project_project_manager_declarable varchar2 itgen_spe_copied_from_project_project_manager_declarable
copied_from_project_project_manager_employee_id varchar2 itgen_spe_copied_from_project_project_manager_employee_id
copied_from_project_project_manager_id varchar2 itgen_spe_copied_from_project_project_manager_id
copied_from_project_project_manager_name varchar2 itgen_spe_copied_from_project_project_manager_name
copied_from_project_project_manager_person_id varchar2 itgen_spe_copied_from_project_project_manager_person_id Toegevoegd om te voldoen aan de oorspronkelijke sales/sales responsible_employee-reactie
copied_from_project_project_manager_tariff double itgen_spe_copied_from_project_project_manager_tariff
copied_from_project_project_number varchar2 itgen_spe_copied_from_project_project_number
created varchar2 Created
created_at varchar2 Aangemaakt op
custom_field_group_id varchar2 Maatwerkveldgroep ID
custom_field_group_model_id varchar2 Maatwerkveldgroep Model ID
custom_field_group_model_label varchar2 Maatwerkveldgroep Modellabel
custom_field_group_name varchar2 Aangepast Veldgroepnaam
custom_field_group_position varchar2 Maatwerkveld Groeppositie
custom_field_group_type varchar2 Aangepast Veldgroepsoort
divergent_payment_term_days int64 Afwijkende Betalingstermijn (dagen)
divergent_payment_term_id varchar2 Afwijkende Betalingstermijn-ID
divergent_payment_term_method varchar2 Uiteenlopende Betalingstermijn Methode
divergent_payment_term_name varchar2 Afwijkende Betalingstermijn Naam
end_date varchar2 Einddatum
filterable char Filterable
hours_rate_type varchar2 Uren Tariefsoort
id varchar2 ID
id_2 varchar2 itgen_spe_id_2
id_3 varchar2 itgen_spe_id_3
invoice_reference varchar2 Factuur Referentie
is_invoice_approval char Is Factuurgoedkeuring
is_reverse_billing char Is omgekeerde facturering
label varchar2 Label
label_2 varchar2 itgen_spe_label_2
mandatory char itgen_spe_mandatory
modified varchar2 Modified
my_organization_profile_id varchar2 Mijn Organisatieprofiel ID
my_organization_profile_id_2 varchar2 itgen_spe_my_organization_profile_id_2
my_organization_profile_organization_id varchar2 itgen_spe_my_organization_profile_organization_id
my_organization_profile_organization_name varchar2 itgen_spe_my_organization_profile_organization_name
my_organization_profile_organization_relation_number varchar2 itgen_spe_my_organization_profile_organization_relation_number
name varchar2 Name
name_2 varchar2 itgen_spe_name_2
note varchar2 Note
organization_id varchar2 Organisatie ID
organization_id_2 varchar2 itgen_spe_organization_id_2
organization_name varchar2 Organisatienaam
organization_relation_number varchar2 itgen_spe_organization_relation_number
person_full_name varchar2 Volledige Naam Persoon
person_id varchar2 Persoon 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
project_manager_amount double itgen_spe_project_manager_amount
project_manager_declarable varchar2 itgen_spe_project_manager_declarable
project_manager_employee_id varchar2 itgen_spe_project_manager_employee_id
project_manager_id varchar2 itgen_spe_project_manager_id
project_manager_name varchar2 itgen_spe_project_manager_name
project_manager_person_id varchar2 itgen_spe_project_manager_person_id Toegevoegd om te voldoen aan de oorspronkelijke sales/sales responsible_employee-reactie
project_manager_tariff double itgen_spe_project_manager_tariff
project_number varchar2 Projectnummer
project_status_color varchar2 Kleur Projectstatus
project_status_id varchar2 Projectstatus-ID
project_status_label varchar2 Projectstatuslabel
render_type varchar2 Rendertype
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
start_date varchar2 Startdatum
timeline_email_address varchar2 Tijdlijn e-mailadres
type varchar2 Type
updated_at varchar2 Bijgewerkt op
value varchar2 Value
value_2 varchar2 itgen_spe_value_2
value_type varchar2 Waardesoort

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: