ProjectCustomFieldOptions |
Fetches all projects
Catalogus: Simplicate
Schema: Projects
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 ProjectCustomFieldOptions worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
abnormal_address |
boolean |
Abnormaal Adres |
☐ |
|
abnormal_contact_id |
string |
Abnormaal contact-ID |
☐ |
|
abnormal_organization_id |
string |
Abnormale Organisatie ID |
☐ |
|
abnormal_person_id |
string |
Abnormaal Persoon ID |
☐ |
|
billable |
boolean |
Facturabel |
☐ |
|
budget_costs_value_budget |
float |
|
☐ |
|
budget_costs_value_spent |
float |
|
☐ |
|
budget_hours_amount_budget |
float |
|
☐ |
|
budget_hours_amount_spent |
float |
|
☐ |
|
budget_hours_value_budget |
float |
|
☐ |
|
budget_hours_value_spent |
float |
|
☐ |
|
budget_total_value_budget |
float |
|
☐ |
|
budget_total_value_invoiced |
float |
|
☐ |
|
budget_total_value_spent |
float |
|
☐ |
|
can_register_mileage |
boolean |
Kan Kilometerstand Registreren |
☐ |
|
contact_id_2 |
string |
|
☐ |
|
contact_id |
string |
Contactpersoon ID |
☐ |
|
contact_organization_id |
string |
Contact Organisatie ID |
☐ |
|
contact_organization_name |
string |
Naam Contactorganisatie |
☐ |
|
contact_organization_relation_number |
string |
|
☐ |
|
contact_person_full_name |
string |
eiContact Person Full Name |
☐ |
|
contact_person_id |
string |
Contactpersoon ID |
☐ |
|
contact_person_relation_number |
string |
|
☐ |
|
copied_from_project_has_register_mileage_enabled |
boolean |
|
☐ |
|
copied_from_project_id |
string |
|
☐ |
|
copied_from_project_name |
string |
|
☐ |
|
copied_from_project_organization_id |
string |
|
☐ |
|
copied_from_project_organization_name |
string |
|
☐ |
|
copied_from_project_organization_relation_number |
string |
|
☐ |
|
copied_from_project_person_full_name |
string |
|
☐ |
|
copied_from_project_person_id |
string |
|
☐ |
|
copied_from_project_person_relation_number |
string |
|
☐ |
|
copied_from_project_project_manager_amount |
float |
|
☐ |
|
copied_from_project_project_manager_declarable |
string |
|
☐ |
|
copied_from_project_project_manager_employee_id |
string |
|
☐ |
|
copied_from_project_project_manager_id |
string |
|
☐ |
|
copied_from_project_project_manager_name |
string |
|
☐ |
|
copied_from_project_project_manager_person_id |
string |
|
☐ |
Added in order to comply with the original sales/sales responsible_employee response |
copied_from_project_project_manager_tariff |
float |
|
☐ |
|
copied_from_project_project_number |
string |
|
☐ |
|
created_at |
string |
Aangemaakt op |
☐ |
|
created |
string |
Gemaakt |
☐ |
|
custom_field_group_id |
string |
Maatwerkveldgroep ID |
☐ |
|
custom_field_group_model_id |
string |
Maatwerkveldgroep Model ID |
☐ |
|
custom_field_group_model_label |
string |
Maatwerkveldgroep Modellabel |
☐ |
|
custom_field_group_name |
string |
Aangepast Veldgroepnaam |
☐ |
|
custom_field_group_position |
string |
Maatwerkveld Groeppositie |
☐ |
|
custom_field_group_type |
string |
Aangepast Veldgroepsoort |
☐ |
|
divergent_payment_term_days |
int64 |
Afwijkende Betalingstermijn (dagen) |
☐ |
|
divergent_payment_term_id |
string |
Afwijkende Betalingstermijn-ID |
☐ |
|
divergent_payment_term_method |
string |
Uiteenlopende Betalingstermijn Methode |
☐ |
|
divergent_payment_term_name |
string |
Afwijkende Betalingstermijn Naam |
☐ |
|
end_date |
string |
Einddatum |
☐ |
|
filterable |
boolean |
Filterbaar |
☐ |
|
hours_rate_type |
string |
Uren Tariefsoort |
☐ |
|
id_2 |
string |
|
☐ |
|
id_3 |
string |
|
☐ |
|
id |
string |
ID |
☐ |
|
invoice_reference |
string |
Factuur Referentie |
☐ |
|
is_invoice_approval |
boolean |
Is Factuurgoedkeuring |
☐ |
|
is_reverse_billing |
boolean |
Is omgekeerde facturering |
☐ |
|
label_2 |
string |
|
☐ |
|
label |
string |
Label |
☐ |
|
mandatory |
boolean |
|
☐ |
|
modified |
string |
Gewijzigd |
☐ |
|
my_organization_profile_id_2 |
string |
|
☐ |
|
my_organization_profile_id |
string |
Mijn Organisatieprofiel ID |
☐ |
|
my_organization_profile_organization_id |
string |
|
☐ |
|
my_organization_profile_organization_name |
string |
|
☐ |
|
my_organization_profile_organization_relation_number |
string |
|
☐ |
|
name_2 |
string |
|
☐ |
|
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 |
|
☐ |
|
position_2 |
int64 |
|
☐ |
|
position |
int64 |
Positie |
☐ |
|
project_manager_amount |
float |
|
☐ |
|
project_manager_declarable |
string |
|
☐ |
|
project_manager_employee_id |
string |
|
☐ |
|
project_manager_id |
string |
|
☐ |
|
project_manager_name |
string |
|
☐ |
|
project_manager_person_id |
string |
|
☐ |
Added in order to comply with the original sales/sales responsible_employee response |
project_manager_tariff |
float |
|
☐ |
|
project_number |
string |
Projectnummer |
☐ |
|
project_status_color |
string |
Kleur Projectstatus |
☐ |
|
project_status_id |
string |
Projectstatus-ID |
☐ |
|
project_status_label |
string |
Projectstatuslabel |
☐ |
|
render_type |
string |
Rendertype |
☐ |
|
searchable |
boolean |
Doorzoekbaar |
☐ |
|
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 |
☐ |
|
start_date |
string |
Startdatum |
☐ |
|
timeline_email_address |
string |
Tijdlijn e-mailadres |
☐ |
|
type |
string |
Soort |
☐ |
|
updated_at |
string |
Bijgewerkt op |
☐ |
|
value_2 |
string |
|
☐ |
|
value_type |
string |
Waardesoort |
☐ |
|
value |
string |
Waarde |
☐ |
|
18-10-2024 06:48 Versie 24.0.345-PROD+4945