PlanningResourcesByPlanningId: ROBAWS Hulpbronnen voor planning per plannings-ID |
Find one
Catalogus: Robaws
Schema: PlanningItems
Label: Hulpbronnen voor planning per plannings-ID
Dit is een alleen-lezen tabelfunctie. De ROBAWS API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive SQL-stuurprogramma voor ROBAWS ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de ROBAWS-API.
Parameters van de tabelfunctie
De volgende parameters kunnen worden gebruikt om het gedrag van de tabelfunctie PlanningResourcesByPlanningId in te stellen. Voor verplichte parameters moet altijd een waarde worden opgegeven, maar optionele parameters hoeven in het algemeen geen waarde te hebben en de uitvoering zal standaard een vooraf bepaald gedrag vertonen. Waarden kunnen worden gespecificeerd op basis van positie en naam. In beide gevallen worden alle niet-gespecificeerde parameters geëvalueerd aan de hand van hun standaardwaarden.
Waardespecificatie op positie gebeurt door alle waarden van de eerste tot de laatste benodigde waarde op te sommen. Bijvoorbeeld: een `select * uit tabel(waarde1, waarde2, waarde3)` op een tabel met vier parameters zal de standaardwaarde voor de vierde parameter gebruiken en de opgegeven waarden voor de eerste drie.
Waardespecificatie op naam gebeurt door alle waarden die een waarde vereisen op te sommen. Bijvoorbeeld met `selecteer * uit tabel(naam1 => waarde1, naam3 => waarde3)` op dezelfde tabel zullen de standaardwaarden voor de tweede en vierde parameter worden gebruikt en de opgegeven waarden voor de eerste en derde.
Naam |
Datatype |
Verplicht |
Standaardwaarde |
Documentatie |
---|---|---|---|---|
id |
string |
☐ |
|
|
Kolommen van Tabelfunctie
De kolommen van de tabelfunctie PlanningResourcesByPlanningId worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
address_addressLine1 |
string |
Adresregel 1 |
☐ |
|
address_addressLine2 |
string |
Adresregel 2 |
☐ |
|
address_city |
string |
Plaats |
☐ |
|
address_country |
string |
Land |
☐ |
|
address_latitude |
double |
|
☐ |
|
address_longitude |
double |
|
☐ |
|
address_postalCode |
string |
|
☐ |
|
archivedAt_1 |
datetime |
Gearchiveerd op |
☐ |
|
archivedAt |
datetime |
Gearchiveerd op |
☐ |
|
basePlanningItem__metadata_description |
string |
|
☐ |
|
basePlanningItem__metadata_href |
string |
|
☐ |
|
basePlanningItem__metadata_resource |
string |
|
☐ |
|
basePlanningItem__metadata_resourceTypeId |
string |
|
☐ |
|
basePlanningItem_address_addressLine1 |
string |
|
☐ |
|
basePlanningItem_address_addressLine2 |
string |
|
☐ |
|
basePlanningItem_address_city |
string |
|
☐ |
|
basePlanningItem_address_country |
string |
|
☐ |
|
basePlanningItem_address_latitude |
double |
|
☐ |
|
basePlanningItem_address_longitude |
double |
|
☐ |
|
basePlanningItem_address_postalCode |
string |
|
☐ |
|
basePlanningItem_archivedAt |
datetime |
|
☐ |
|
basePlanningItem_basePlanningItem_archivedAt |
datetime |
|
☐ |
|
basePlanningItem_basePlanningItem_basePlanningItemId |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_clientId |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_contactId |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_createdAt |
datetime |
|
☐ |
|
basePlanningItem_basePlanningItem_deletedAt |
datetime |
|
☐ |
|
basePlanningItem_basePlanningItem_description |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_endDate |
datetime |
|
☐ |
|
basePlanningItem_basePlanningItem_executionPhaseDetail |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_executionPhaseId |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_externalId |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_extraFields |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_id |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_lockedAt |
datetime |
|
☐ |
|
basePlanningItem_basePlanningItem_numberOfWorkOrders |
int32 |
|
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
basePlanningItem_basePlanningItem_phaseId |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_planningTypeId |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_projectId |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_recurrenceEndDate |
datetime |
|
☐ |
|
basePlanningItem_basePlanningItem_recurrenceRule |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_recurring |
boolean |
|
☐ |
|
basePlanningItem_basePlanningItem_recurringMode |
string |
|
☐ |
Deprecated, use recurrenceType instead. |
basePlanningItem_basePlanningItem_startDate |
datetime |
|
☐ |
|
basePlanningItem_basePlanningItem_summary |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_timeAndMaterial |
boolean |
|
☐ |
|
basePlanningItem_basePlanningItem_transportId |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_unavailableReason |
string |
|
☐ |
|
basePlanningItem_basePlanningItem_updatedAt |
datetime |
|
☐ |
|
basePlanningItem_basePlanningItemId |
string |
|
☐ |
|
basePlanningItem_client_archivedAt |
datetime |
|
☐ |
|
basePlanningItem_client_assignedUserId |
string |
|
☐ |
|
basePlanningItem_client_createdAt |
datetime |
|
☐ |
|
basePlanningItem_client_creditStatus |
string |
|
☐ |
|
basePlanningItem_client_deletedAt |
datetime |
|
☐ |
|
basePlanningItem_client_email |
string |
|
☐ |
|
basePlanningItem_client_extraFields |
string |
|
☐ |
|
basePlanningItem_client_fax |
string |
|
☐ |
|
basePlanningItem_client_followUpDate |
datetime |
|
☐ |
|
basePlanningItem_client_generalLedgerAccountId |
string |
|
☐ |
|
basePlanningItem_client_gsm |
string |
|
☐ |
|
basePlanningItem_client_id |
string |
|
☐ |
|
basePlanningItem_client_invoiceEmail |
string |
|
☐ |
|
basePlanningItem_client_language |
string |
|
☐ |
|
basePlanningItem_client_legalFormId |
string |
|
☐ |
|
basePlanningItem_client_lockedAt |
datetime |
|
☐ |
|
basePlanningItem_client_name |
string |
|
☐ |
|
basePlanningItem_client_paymentConditionId |
string |
|
☐ |
|
basePlanningItem_client_priceGroupId |
string |
|
☐ |
|
basePlanningItem_client_status |
string |
|
☐ |
|
basePlanningItem_client_tel |
string |
|
☐ |
|
basePlanningItem_client_title |
string |
|
☐ |
|
basePlanningItem_client_updatedAt |
datetime |
|
☐ |
|
basePlanningItem_client_vatIdNumber |
string |
|
☐ |
|
basePlanningItem_client_vatTariffId |
string |
|
☐ |
|
basePlanningItem_client_website |
string |
|
☐ |
|
basePlanningItem_clientId |
string |
|
☐ |
|
basePlanningItem_contact_archivedAt |
datetime |
|
☐ |
|
basePlanningItem_contact_createdAt |
datetime |
|
☐ |
|
basePlanningItem_contact_deletedAt |
datetime |
|
☐ |
|
basePlanningItem_contact_email |
string |
|
☐ |
|
basePlanningItem_contact_extraFields |
string |
|
☐ |
|
basePlanningItem_contact_gsm |
string |
|
☐ |
|
basePlanningItem_contact_id |
string |
|
☐ |
|
basePlanningItem_contact_lockedAt |
datetime |
|
☐ |
|
basePlanningItem_contact_name |
string |
|
☐ |
|
basePlanningItem_contact_position |
string |
|
☐ |
|
basePlanningItem_contact_surname |
string |
|
☐ |
|
basePlanningItem_contact_tel |
string |
|
☐ |
|
basePlanningItem_contact_title |
string |
|
☐ |
|
basePlanningItem_contact_updatedAt |
datetime |
|
☐ |
|
basePlanningItem_contactId |
string |
|
☐ |
|
basePlanningItem_createdAt |
datetime |
|
☐ |
|
basePlanningItem_deletedAt |
datetime |
|
☐ |
|
basePlanningItem_description |
string |
|
☐ |
|
basePlanningItem_endDate |
datetime |
|
☐ |
|
basePlanningItem_executionPhase_archivedAt |
datetime |
|
☐ |
|
basePlanningItem_executionPhase_createdAt |
datetime |
|
☐ |
|
basePlanningItem_executionPhase_deletedAt |
datetime |
|
☐ |
|
basePlanningItem_executionPhase_extraFields |
string |
|
☐ |
|
basePlanningItem_executionPhase_id |
string |
|
☐ |
|
basePlanningItem_executionPhase_lockedAt |
datetime |
|
☐ |
|
basePlanningItem_executionPhase_name |
string |
|
☐ |
|
basePlanningItem_executionPhase_planningGroup |
string |
|
☐ |
|
basePlanningItem_executionPhase_updatedAt |
datetime |
|
☐ |
|
basePlanningItem_executionPhaseDetail |
string |
|
☐ |
|
basePlanningItem_executionPhaseId |
string |
|
☐ |
|
basePlanningItem_externalId |
string |
|
☐ |
|
basePlanningItem_extraFields |
string |
|
☐ |
|
basePlanningItem_id |
string |
|
☐ |
|
basePlanningItem_lockedAt |
datetime |
|
☐ |
|
basePlanningItem_numberOfWorkOrders |
int32 |
|
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
basePlanningItem_phase_archivedAt |
datetime |
|
☐ |
|
basePlanningItem_phase_createdAt |
datetime |
|
☐ |
|
basePlanningItem_phase_deletedAt |
datetime |
|
☐ |
|
basePlanningItem_phase_endDate |
datetime |
|
☐ |
|
basePlanningItem_phase_extraFields |
string |
|
☐ |
|
basePlanningItem_phase_id |
string |
|
☐ |
|
basePlanningItem_phase_lockedAt |
datetime |
|
☐ |
|
basePlanningItem_phase_name |
string |
|
☐ |
|
basePlanningItem_phase_offerId |
string |
|
☐ |
Only present when obtained via offer bulk endpoint |
basePlanningItem_phase_projectId |
string |
|
☐ |
Only present when obtained via project bulk endpoint |
basePlanningItem_phase_settlementId |
string |
|
☐ |
Only present when obtained via settlements bulk endpoint |
basePlanningItem_phase_startDate |
datetime |
|
☐ |
|
basePlanningItem_phase_updatedAt |
datetime |
|
☐ |
|
basePlanningItem_phase_workingDays |
int32 |
|
☐ |
|
basePlanningItem_phaseId |
string |
|
☐ |
|
basePlanningItem_planningType_archivedAt |
datetime |
|
☐ |
|
basePlanningItem_planningType_color |
string |
|
☐ |
|
basePlanningItem_planningType_createdAt |
datetime |
|
☐ |
|
basePlanningItem_planningType_deletedAt |
datetime |
|
☐ |
|
basePlanningItem_planningType_extraFields |
string |
|
☐ |
|
basePlanningItem_planningType_id |
string |
|
☐ |
|
basePlanningItem_planningType_lockedAt |
datetime |
|
☐ |
|
basePlanningItem_planningType_name |
string |
|
☐ |
|
basePlanningItem_planningType_updatedAt |
datetime |
|
☐ |
|
basePlanningItem_planningTypeId |
string |
|
☐ |
|
basePlanningItem_project_archivedAt |
datetime |
|
☐ |
|
basePlanningItem_project_checkInAtWork |
string |
|
☐ |
|
basePlanningItem_project_clientContactId |
string |
|
☐ |
|
basePlanningItem_project_clientId |
string |
|
☐ |
|
basePlanningItem_project_clientReference |
string |
|
☐ |
|
basePlanningItem_project_companyId |
string |
|
☐ |
|
basePlanningItem_project_createdAt |
datetime |
|
☐ |
|
basePlanningItem_project_date |
datetime |
|
☐ |
|
basePlanningItem_project_deletedAt |
datetime |
|
☐ |
|
basePlanningItem_project_distance |
int32 |
|
☐ |
|
basePlanningItem_project_endClientContactId |
string |
|
☐ |
|
basePlanningItem_project_endClientId |
string |
|
☐ |
|
basePlanningItem_project_extraFields |
string |
|
☐ |
|
basePlanningItem_project_geofence |
string |
|
☐ |
|
basePlanningItem_project_id |
string |
|
☐ |
|
basePlanningItem_project_lockedAt |
datetime |
|
☐ |
|
basePlanningItem_project_logicId |
string |
|
☐ |
|
basePlanningItem_project_nssoDeclarationOfWorks |
string |
|
☐ |
|
basePlanningItem_project_planningGroup |
string |
|
☐ |
|
basePlanningItem_project_planningName |
string |
|
☐ |
|
basePlanningItem_project_siteManagerId |
string |
|
☐ |
|
basePlanningItem_project_siteNssoIdNumber |
string |
|
☐ |
|
basePlanningItem_project_status |
string |
|
☐ |
|
basePlanningItem_project_updatedAt |
datetime |
|
☐ |
|
basePlanningItem_projectId |
string |
|
☐ |
|
basePlanningItem_recurrenceEndDate |
datetime |
|
☐ |
|
basePlanningItem_recurrenceRule |
string |
|
☐ |
|
basePlanningItem_recurring |
boolean |
|
☐ |
|
basePlanningItem_recurringMode |
string |
|
☐ |
Deprecated, use recurrenceType instead. |
basePlanningItem_startDate |
datetime |
|
☐ |
|
basePlanningItem_summary |
string |
|
☐ |
|
basePlanningItem_timeAndMaterial |
boolean |
|
☐ |
|
basePlanningItem_transportId |
string |
|
☐ |
|
basePlanningItem_unavailableReason |
string |
|
☐ |
|
basePlanningItem_updatedAt |
datetime |
|
☐ |
|
basePlanningItemId |
string |
Basisplanning Item ID |
☐ |
|
c_metadata_description_1 |
string |
|
☐ |
|
c_metadata_description |
string |
|
☐ |
|
c_metadata_href_1 |
string |
|
☐ |
|
c_metadata_href |
string |
|
☐ |
|
c_metadata_resource_1 |
string |
|
☐ |
|
c_metadata_resource |
string |
|
☐ |
|
c_metadata_resourceTypeId_1 |
string |
|
☐ |
|
c_metadata_resourceTypeId |
string |
|
☐ |
|
client__metadata_description |
string |
|
☐ |
|
client__metadata_href |
string |
|
☐ |
|
client__metadata_resource |
string |
|
☐ |
|
client__metadata_resourceTypeId |
string |
|
☐ |
|
client_address_addressLine1 |
string |
|
☐ |
|
client_address_addressLine2 |
string |
|
☐ |
|
client_address_city |
string |
|
☐ |
|
client_address_country |
string |
|
☐ |
|
client_address_latitude |
double |
|
☐ |
|
client_address_longitude |
double |
|
☐ |
|
client_address_postalCode |
string |
|
☐ |
|
client_archivedAt |
datetime |
|
☐ |
|
client_assignedUser_archivedAt |
datetime |
|
☐ |
|
client_assignedUser_createdAt |
datetime |
|
☐ |
|
client_assignedUser_deletedAt |
datetime |
|
☐ |
|
client_assignedUser_email |
string |
|
☐ |
|
client_assignedUser_emailAccountActive |
boolean |
|
☐ |
|
client_assignedUser_extraFields |
string |
|
☐ |
|
client_assignedUser_fullName |
string |
|
☐ |
|
client_assignedUser_id |
string |
|
☐ |
|
client_assignedUser_locale |
string |
|
☐ |
|
client_assignedUser_locked |
boolean |
|
☐ |
|
client_assignedUser_lockedAt |
datetime |
|
☐ |
|
client_assignedUser_updatedAt |
datetime |
|
☐ |
|
client_assignedUserId |
string |
|
☐ |
|
client_createdAt |
datetime |
|
☐ |
|
client_creditStatus |
string |
|
☐ |
|
client_deletedAt |
datetime |
|
☐ |
|
client_email |
string |
Klant E-mail |
☐ |
|
client_extraFields |
string |
|
☐ |
|
client_fax |
string |
Klant Fax |
☐ |
|
client_followUpDate |
datetime |
|
☐ |
|
client_generalLedgerAccount_archivedAt |
datetime |
|
☐ |
|
client_generalLedgerAccount_code |
string |
|
☐ |
|
client_generalLedgerAccount_createdAt |
datetime |
|
☐ |
|
client_generalLedgerAccount_deletedAt |
datetime |
|
☐ |
|
client_generalLedgerAccount_extraFields |
string |
|
☐ |
|
client_generalLedgerAccount_id |
string |
|
☐ |
|
client_generalLedgerAccount_lockedAt |
datetime |
|
☐ |
|
client_generalLedgerAccount_name |
string |
|
☐ |
|
client_generalLedgerAccount_updatedAt |
datetime |
|
☐ |
|
client_generalLedgerAccountId |
string |
|
☐ |
|
client_gsm |
string |
Klant Mobiel |
☐ |
|
client_id |
string |
Client ID |
☐ |
|
client_invoiceAddress_addressLine1 |
string |
|
☐ |
|
client_invoiceAddress_addressLine2 |
string |
|
☐ |
|
client_invoiceAddress_city |
string |
|
☐ |
|
client_invoiceAddress_country |
string |
|
☐ |
|
client_invoiceAddress_latitude |
double |
|
☐ |
|
client_invoiceAddress_longitude |
double |
|
☐ |
|
client_invoiceAddress_postalCode |
string |
|
☐ |
|
client_invoiceEmail |
string |
|
☐ |
|
client_language |
string |
|
☐ |
|
client_legalForm_archivedAt |
datetime |
|
☐ |
|
client_legalForm_createdAt |
datetime |
|
☐ |
|
client_legalForm_deletedAt |
datetime |
|
☐ |
|
client_legalForm_extraFields |
string |
|
☐ |
|
client_legalForm_id |
string |
|
☐ |
|
client_legalForm_legalAbbreviation |
string |
|
☐ |
|
client_legalForm_lockedAt |
datetime |
|
☐ |
|
client_legalForm_name |
string |
|
☐ |
|
client_legalForm_updatedAt |
datetime |
|
☐ |
|
client_legalForm_vatLiable |
boolean |
|
☐ |
|
client_legalFormId |
string |
|
☐ |
|
client_lockedAt |
datetime |
|
☐ |
|
client_name |
string |
|
☐ |
|
client_paymentCondition_archivedAt |
datetime |
|
☐ |
|
client_paymentCondition_createdAt |
datetime |
|
☐ |
|
client_paymentCondition_deletedAt |
datetime |
|
☐ |
|
client_paymentCondition_extraFields |
string |
|
☐ |
|
client_paymentCondition_id |
string |
|
☐ |
|
client_paymentCondition_lockedAt |
datetime |
|
☐ |
|
client_paymentCondition_name |
string |
|
☐ |
|
client_paymentCondition_purchase |
boolean |
|
☐ |
|
client_paymentCondition_sales |
boolean |
|
☐ |
|
client_paymentCondition_updatedAt |
datetime |
|
☐ |
|
client_paymentConditionId |
string |
|
☐ |
|
client_priceGroupId |
string |
|
☐ |
|
client_status |
string |
|
☐ |
|
client_statusDetails_color |
string |
|
☐ |
|
client_statusDetails_name |
string |
|
☐ |
|
client_tel |
string |
|
☐ |
|
client_title |
string |
|
☐ |
|
client_updatedAt |
datetime |
|
☐ |
|
client_vatIdNumber |
string |
|
☐ |
|
client_vatTariff_additionalMention |
string |
|
☐ |
|
client_vatTariff_archivedAt |
datetime |
|
☐ |
|
client_vatTariff_category |
string |
|
☐ |
|
client_vatTariff_createdAt |
datetime |
|
☐ |
|
client_vatTariff_deletedAt |
datetime |
|
☐ |
|
client_vatTariff_description |
string |
|
☐ |
|
client_vatTariff_excludedFromFinancialDiscount |
boolean |
|
☐ |
|
client_vatTariff_extraFields |
string |
|
☐ |
|
client_vatTariff_id |
string |
|
☐ |
|
client_vatTariff_inclusive |
boolean |
|
☐ |
|
client_vatTariff_lockedAt |
datetime |
|
☐ |
|
client_vatTariff_name |
string |
|
☐ |
|
client_vatTariff_percentage |
decimal |
|
☐ |
|
client_vatTariff_updatedAt |
datetime |
|
☐ |
|
client_vatTariffId |
string |
|
☐ |
|
client_website |
string |
|
☐ |
|
clientId |
string |
Klant ID |
☐ |
|
contact__metadata_description |
string |
|
☐ |
|
contact__metadata_href |
string |
|
☐ |
|
contact__metadata_resource |
string |
|
☐ |
|
contact__metadata_resourceTypeId |
string |
|
☐ |
|
contact_archivedAt |
datetime |
|
☐ |
|
contact_createdAt |
datetime |
|
☐ |
|
contact_deletedAt |
datetime |
|
☐ |
|
contact_email |
string |
|
☐ |
|
contact_extraFields |
string |
|
☐ |
|
contact_gsm |
string |
|
☐ |
|
contact_id |
string |
|
☐ |
|
contact_lockedAt |
datetime |
|
☐ |
|
contact_name |
string |
|
☐ |
|
contact_position |
string |
|
☐ |
|
contact_surname |
string |
|
☐ |
|
contact_tel |
string |
|
☐ |
|
contact_title |
string |
|
☐ |
|
contact_updatedAt |
datetime |
|
☐ |
|
contactId |
string |
Contact ID |
☐ |
|
createdAt_1 |
datetime |
Gemaakt op |
☐ |
|
createdAt |
datetime |
Gemaakt op |
☐ |
|
deletedAt_1 |
datetime |
Geschrapt bij |
☐ |
|
deletedAt |
datetime |
Geschrapt bij |
☐ |
|
description |
string |
Omschrijving |
☐ |
|
endDate |
datetime |
Einddatum |
☐ |
|
executionPhase__metadata_description |
string |
|
☐ |
|
executionPhase__metadata_href |
string |
|
☐ |
|
executionPhase__metadata_resource |
string |
|
☐ |
|
executionPhase__metadata_resourceTypeId |
string |
|
☐ |
|
executionPhase_archivedAt |
datetime |
|
☐ |
|
executionPhase_createdAt |
datetime |
|
☐ |
|
executionPhase_deletedAt |
datetime |
|
☐ |
|
executionPhase_extraFields |
string |
|
☐ |
|
executionPhase_id |
string |
|
☐ |
|
executionPhase_lockedAt |
datetime |
|
☐ |
|
executionPhase_name |
string |
|
☐ |
|
executionPhase_planningGroup |
string |
|
☐ |
|
executionPhase_updatedAt |
datetime |
|
☐ |
|
executionPhaseDetail |
string |
Detail uitvoeringsfase |
☐ |
|
executionPhaseId |
string |
Uitvoeringsfase-ID |
☐ |
|
externalId |
string |
Externe ID |
☐ |
|
extraFields_1 |
string |
Extra velden |
☐ |
|
extraFields |
string |
Extra velden |
☐ |
|
id_1 |
string |
ID |
☐ |
|
id |
string |
ID |
☐ |
|
lockedAt_1 |
datetime |
Gesloten op |
☐ |
|
lockedAt |
datetime |
Gesloten op |
☐ |
|
name |
string |
Naam |
☐ |
|
numberOfWorkOrders |
int32 |
Aantal werkorders |
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
phase__metadata_description |
string |
|
☐ |
|
phase__metadata_href |
string |
|
☐ |
|
phase__metadata_resource |
string |
|
☐ |
|
phase__metadata_resourceTypeId |
string |
|
☐ |
|
phase_archivedAt |
datetime |
|
☐ |
|
phase_createdAt |
datetime |
|
☐ |
|
phase_deletedAt |
datetime |
|
☐ |
|
phase_endDate |
datetime |
|
☐ |
|
phase_extraFields |
string |
|
☐ |
|
phase_id |
string |
|
☐ |
|
phase_lockedAt |
datetime |
|
☐ |
|
phase_name |
string |
|
☐ |
|
phase_offerId |
string |
|
☐ |
Only present when obtained via offer bulk endpoint |
phase_projectId |
string |
|
☐ |
Only present when obtained via project bulk endpoint |
phase_settlementId |
string |
|
☐ |
Only present when obtained via settlements bulk endpoint |
phase_startDate |
datetime |
|
☐ |
|
phase_updatedAt |
datetime |
|
☐ |
|
phase_workingDays |
int32 |
|
☐ |
|
phaseId |
string |
Fase ID |
☐ |
|
planningGroup |
string |
Planninggroep |
☐ |
|
planningType__metadata_description |
string |
|
☐ |
|
planningType__metadata_href |
string |
|
☐ |
|
planningType__metadata_resource |
string |
|
☐ |
|
planningType__metadata_resourceTypeId |
string |
|
☐ |
|
planningType_archivedAt |
datetime |
|
☐ |
|
planningType_color |
string |
|
☐ |
|
planningType_createdAt |
datetime |
|
☐ |
|
planningType_deletedAt |
datetime |
|
☐ |
|
planningType_extraFields |
string |
|
☐ |
|
planningType_id |
string |
|
☐ |
|
planningType_lockedAt |
datetime |
|
☐ |
|
planningType_name |
string |
|
☐ |
|
planningType_updatedAt |
datetime |
|
☐ |
|
planningTypeId |
string |
Planning Type ID |
☐ |
|
project__metadata_description |
string |
|
☐ |
|
project__metadata_href |
string |
|
☐ |
|
project__metadata_resource |
string |
|
☐ |
|
project__metadata_resourceTypeId |
string |
|
☐ |
|
project_archivedAt |
datetime |
|
☐ |
|
project_checkInAtWork |
string |
|
☐ |
|
project_client_archivedAt |
datetime |
|
☐ |
|
project_client_assignedUserId |
string |
|
☐ |
|
project_client_createdAt |
datetime |
|
☐ |
|
project_client_creditStatus |
string |
|
☐ |
|
project_client_deletedAt |
datetime |
|
☐ |
|
project_client_email |
string |
|
☐ |
|
project_client_extraFields |
string |
|
☐ |
|
project_client_fax |
string |
|
☐ |
|
project_client_followUpDate |
datetime |
|
☐ |
|
project_client_generalLedgerAccountId |
string |
|
☐ |
|
project_client_gsm |
string |
|
☐ |
|
project_client_id |
string |
|
☐ |
|
project_client_invoiceEmail |
string |
|
☐ |
|
project_client_language |
string |
|
☐ |
|
project_client_legalFormId |
string |
|
☐ |
|
project_client_lockedAt |
datetime |
|
☐ |
|
project_client_name |
string |
|
☐ |
|
project_client_paymentConditionId |
string |
|
☐ |
|
project_client_priceGroupId |
string |
|
☐ |
|
project_client_status |
string |
|
☐ |
|
project_client_tel |
string |
|
☐ |
|
project_client_title |
string |
|
☐ |
|
project_client_updatedAt |
datetime |
|
☐ |
|
project_client_vatIdNumber |
string |
|
☐ |
|
project_client_vatTariffId |
string |
|
☐ |
|
project_client_website |
string |
|
☐ |
|
project_clientContact_archivedAt |
datetime |
|
☐ |
|
project_clientContact_createdAt |
datetime |
|
☐ |
|
project_clientContact_deletedAt |
datetime |
|
☐ |
|
project_clientContact_email |
string |
|
☐ |
|
project_clientContact_extraFields |
string |
|
☐ |
|
project_clientContact_gsm |
string |
|
☐ |
|
project_clientContact_id |
string |
|
☐ |
|
project_clientContact_lockedAt |
datetime |
|
☐ |
|
project_clientContact_name |
string |
|
☐ |
|
project_clientContact_position |
string |
|
☐ |
|
project_clientContact_surname |
string |
|
☐ |
|
project_clientContact_tel |
string |
|
☐ |
|
project_clientContact_title |
string |
|
☐ |
|
project_clientContact_updatedAt |
datetime |
|
☐ |
|
project_clientContactId |
string |
|
☐ |
|
project_clientId |
string |
|
☐ |
|
project_clientReference |
string |
|
☐ |
|
project_company_archivedAt |
datetime |
|
☐ |
|
project_company_createdAt |
datetime |
|
☐ |
|
project_company_deletedAt |
datetime |
|
☐ |
|
project_company_extraFields |
string |
|
☐ |
|
project_company_id |
string |
|
☐ |
|
project_company_lockedAt |
datetime |
|
☐ |
|
project_company_name |
string |
|
☐ |
|
project_company_updatedAt |
datetime |
|
☐ |
|
project_companyId |
string |
|
☐ |
|
project_createdAt |
datetime |
|
☐ |
|
project_date |
datetime |
|
☐ |
|
project_deletedAt |
datetime |
|
☐ |
|
project_distance |
int32 |
|
☐ |
|
project_endClient_archivedAt |
datetime |
|
☐ |
|
project_endClient_assignedUserId |
string |
|
☐ |
|
project_endClient_createdAt |
datetime |
|
☐ |
|
project_endClient_creditStatus |
string |
|
☐ |
|
project_endClient_deletedAt |
datetime |
|
☐ |
|
project_endClient_email |
string |
|
☐ |
|
project_endClient_extraFields |
string |
|
☐ |
|
project_endClient_fax |
string |
|
☐ |
|
project_endClient_followUpDate |
datetime |
|
☐ |
|
project_endClient_generalLedgerAccountId |
string |
|
☐ |
|
project_endClient_gsm |
string |
|
☐ |
|
project_endClient_id |
string |
|
☐ |
|
project_endClient_invoiceEmail |
string |
|
☐ |
|
project_endClient_language |
string |
|
☐ |
|
project_endClient_legalFormId |
string |
|
☐ |
|
project_endClient_lockedAt |
datetime |
|
☐ |
|
project_endClient_name |
string |
|
☐ |
|
project_endClient_paymentConditionId |
string |
|
☐ |
|
project_endClient_priceGroupId |
string |
|
☐ |
|
project_endClient_status |
string |
|
☐ |
|
project_endClient_tel |
string |
|
☐ |
|
project_endClient_title |
string |
|
☐ |
|
project_endClient_updatedAt |
datetime |
|
☐ |
|
project_endClient_vatIdNumber |
string |
|
☐ |
|
project_endClient_vatTariffId |
string |
|
☐ |
|
project_endClient_website |
string |
|
☐ |
|
project_endClientContact_archivedAt |
datetime |
|
☐ |
|
project_endClientContact_createdAt |
datetime |
|
☐ |
|
project_endClientContact_deletedAt |
datetime |
|
☐ |
|
project_endClientContact_email |
string |
|
☐ |
|
project_endClientContact_extraFields |
string |
|
☐ |
|
project_endClientContact_gsm |
string |
|
☐ |
|
project_endClientContact_id |
string |
|
☐ |
|
project_endClientContact_lockedAt |
datetime |
|
☐ |
|
project_endClientContact_name |
string |
|
☐ |
|
project_endClientContact_position |
string |
|
☐ |
|
project_endClientContact_surname |
string |
|
☐ |
|
project_endClientContact_tel |
string |
|
☐ |
|
project_endClientContact_title |
string |
|
☐ |
|
project_endClientContact_updatedAt |
datetime |
|
☐ |
|
project_endClientContactId |
string |
|
☐ |
|
project_endClientId |
string |
|
☐ |
|
project_extraFields |
string |
|
☐ |
|
project_geofence |
string |
|
☐ |
|
project_id |
string |
|
☐ |
|
project_lockedAt |
datetime |
|
☐ |
|
project_logicId |
string |
|
☐ |
|
project_nssoDeclarationOfWorks |
string |
|
☐ |
|
project_planningGroup |
string |
|
☐ |
|
project_planningName |
string |
|
☐ |
|
project_siteAddress_addressLine1 |
string |
|
☐ |
|
project_siteAddress_addressLine2 |
string |
|
☐ |
|
project_siteAddress_city |
string |
|
☐ |
|
project_siteAddress_country |
string |
|
☐ |
|
project_siteAddress_latitude |
double |
|
☐ |
|
project_siteAddress_longitude |
double |
|
☐ |
|
project_siteAddress_postalCode |
string |
|
☐ |
|
project_siteManager_archivedAt |
datetime |
|
☐ |
|
project_siteManager_createdAt |
datetime |
|
☐ |
|
project_siteManager_deletedAt |
datetime |
|
☐ |
|
project_siteManager_email |
string |
|
☐ |
|
project_siteManager_emailAccountActive |
boolean |
|
☐ |
|
project_siteManager_extraFields |
string |
|
☐ |
|
project_siteManager_fullName |
string |
|
☐ |
|
project_siteManager_id |
string |
|
☐ |
|
project_siteManager_locale |
string |
|
☐ |
|
project_siteManager_locked |
boolean |
|
☐ |
|
project_siteManager_lockedAt |
datetime |
|
☐ |
|
project_siteManager_updatedAt |
datetime |
|
☐ |
|
project_siteManagerId |
string |
|
☐ |
|
project_siteNssoIdNumber |
string |
|
☐ |
|
project_status |
string |
|
☐ |
|
project_statusDetails_color |
string |
|
☐ |
|
project_statusDetails_name |
string |
|
☐ |
|
project_updatedAt |
datetime |
|
☐ |
|
projectId |
string |
Project ID |
☐ |
|
recurrenceEndDate |
datetime |
Einddatum van herhaling |
☐ |
|
recurrenceRule |
string |
Regel voor herhaling |
☐ |
|
recurring |
boolean |
Terugkerend |
☐ |
|
recurringMode |
string |
Terugkerende modus |
☐ |
Deprecated, use recurrenceType instead. |
startDate |
datetime |
Startdatum |
☐ |
|
summary |
string |
Samenvatting |
☐ |
|
timeAndMaterial |
boolean |
Tijd en materiaal |
☐ |
|
transportId |
string |
Transport ID |
☐ |
|
unavailableReason |
string |
Niet beschikbaar Reden |
☐ |
|
updatedAt_1 |
datetime |
Bijgewerkt op |
☐ |
|
updatedAt |
datetime |
Bijgewerkt op |
☐ |
|
30-09-2023 07:40 Versie 23.0.49-PROD+4237