Navigatie: Schema: PlanningItems > Tables

PlanningMaterialsByPlanningId: ROBAWS Planningsmateriaal per plannings-ID

Find one

Catalogus: Robaws

Schema: PlanningItems

Label: Planningsmateriaal 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 PlanningMaterialsByPlanningId 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 PlanningMaterialsByPlanningId 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	☐
article_activityId	string		☐
article_archivedAt	datetime		☐
article_articleGroupId	string		☐
article_articleNumber	string		☐
article_availableStock	decimal		☐	This property should be used by third parties (for example webshops) that want to know how much stock is available for sale.When reading, only present if requested via 'include' query parameter, otherwise null.
article_backorderStock	decimal		☐	When reading, only present if requested via 'include' query parameter, otherwise null.
article_barcode	string	Artikel Streepjescode	☐
article_brand	string		☐
article_calculationType	string		☐
article_costPrice	decimal		☐
article_costPriceStrategy	string		☐
article_createdAt	datetime		☐
article_deletedAt	datetime		☐
article_description	string		☐
article_descriptionTranslations	string		☐
article_extraFields	string		☐
article_id	string	Artikel ID	☐
article_installation	boolean		☐
article_lockedAt	datetime		☐
article_margin	decimal		☐
article_minimumStock	decimal		☐
article_name	string		☐
article_nameTranslations	string		☐
article_purchaseGLAccountId	string		☐
article_reservedStock	decimal		☐	When reading, only present if requested via 'include' query parameter, otherwise null.
article_saleName	string		☐
article_salePrice	decimal		☐
article_salePriceStrategy	string		☐
article_salesGLAccountId	string		☐
article_stockArticle	boolean		☐
article_stockPlace	string		☐
article_targetStock	decimal		☐
article_timeOperation	boolean		☐
article_totalStock	decimal		☐	When reading, only present if requested via 'include' query parameter, otherwise null.
article_type	string		☐
article_unitType	string		☐
article_updatedAt	datetime		☐
article_vatTariffId	string		☐
article_wappy	boolean		☐
articleId	string	Artikel ID	☐
assignedClient_archivedAt	datetime		☐
assignedClient_assignedUserId	string		☐
assignedClient_createdAt	datetime		☐
assignedClient_creditStatus	string		☐
assignedClient_deletedAt	datetime		☐
assignedClient_email	string		☐
assignedClient_extraFields	string		☐
assignedClient_fax	string		☐
assignedClient_followUpDate	datetime		☐
assignedClient_generalLedgerAccountId	string		☐
assignedClient_gsm	string		☐
assignedClient_id	string		☐
assignedClient_invoiceEmail	string		☐
assignedClient_language	string		☐
assignedClient_legalFormId	string		☐
assignedClient_lockedAt	datetime		☐
assignedClient_name	string		☐
assignedClient_paymentConditionId	string		☐
assignedClient_priceGroupId	string		☐
assignedClient_status	string		☐
assignedClient_tel	string		☐
assignedClient_title	string		☐
assignedClient_updatedAt	datetime		☐
assignedClient_vatIdNumber	string		☐
assignedClient_vatTariffId	string		☐
assignedClient_website	string		☐
assignedClientId	string	Toegewezen klant-ID	☐
assignedEmployee_archivedAt	datetime		☐
assignedEmployee_bankAccountNumber	string		☐
assignedEmployee_civilStatus	string		☐
assignedEmployee_collaborationEndDate	datetime		☐
assignedEmployee_collaborationStartDate	datetime		☐
assignedEmployee_competenceLevel	string		☐
assignedEmployee_costPerHour	decimal		☐
assignedEmployee_createdAt	datetime		☐
assignedEmployee_dateOfBirth	datetime		☐
assignedEmployee_defaultStockLocationId	string		☐
assignedEmployee_defaultTimeOperationId	string		☐
assignedEmployee_deletedAt	datetime		☐
assignedEmployee_dimonaExpirationDate	datetime		☐
assignedEmployee_dimonaNumber	string		☐
assignedEmployee_distance	decimal		☐
assignedEmployee_driverLicense	string		☐
assignedEmployee_email	string		☐
assignedEmployee_emergencyTel	string		☐
assignedEmployee_employeeRoleId	string		☐
assignedEmployee_employerId	string		☐
assignedEmployee_extraFields	string		☐
assignedEmployee_grossSalary	decimal		☐
assignedEmployee_gsm	string		☐
assignedEmployee_id	string		☐
assignedEmployee_identityCardExpirationDate	datetime		☐
assignedEmployee_identityCardNumber	string		☐
assignedEmployee_independentRegistration	boolean		☐
assignedEmployee_limosaExpirationDate	datetime		☐
assignedEmployee_limosaNumber	string		☐
assignedEmployee_lockedAt	datetime		☐
assignedEmployee_name	string		☐
assignedEmployee_nationality	string		☐
assignedEmployee_nssoIdNumber	string		☐
assignedEmployee_nssoPayment	boolean		☐
assignedEmployee_nssoPaymentExpirationDate	datetime		☐
assignedEmployee_numberOfDependents	int32		☐
assignedEmployee_planningGroup	string		☐
assignedEmployee_position	string		☐
assignedEmployee_secondment	boolean		☐
assignedEmployee_status	string		☐
assignedEmployee_statute	string		☐
assignedEmployee_subType	string		☐
assignedEmployee_surname	string		☐
assignedEmployee_tel	string		☐
assignedEmployee_type	string		☐
assignedEmployee_updatedAt	datetime		☐
assignedEmployeeId	string	Toegewezen werknemers-ID	☐
assignedProject_archivedAt	datetime		☐
assignedProject_checkInAtWork	string		☐
assignedProject_clientContactId	string		☐
assignedProject_clientId	string		☐
assignedProject_clientReference	string		☐
assignedProject_companyId	string		☐
assignedProject_createdAt	datetime		☐
assignedProject_date	datetime		☐
assignedProject_deletedAt	datetime		☐
assignedProject_distance	int32		☐
assignedProject_endClientContactId	string		☐
assignedProject_endClientId	string		☐
assignedProject_extraFields	string		☐
assignedProject_geofence	string		☐
assignedProject_id	string		☐
assignedProject_lockedAt	datetime		☐
assignedProject_logicId	string		☐
assignedProject_nssoDeclarationOfWorks	string		☐
assignedProject_planningGroup	string		☐
assignedProject_planningName	string		☐
assignedProject_siteManagerId	string		☐
assignedProject_siteNssoIdNumber	string		☐
assignedProject_status	string		☐
assignedProject_updatedAt	datetime		☐
assignedProjectId	string	Toegewezen project-ID	☐
assignedSubcontractor_archivedAt	datetime		☐
assignedSubcontractor_createdAt	datetime		☐
assignedSubcontractor_deletedAt	datetime		☐
assignedSubcontractor_email	string		☐
assignedSubcontractor_extraFields	string		☐
assignedSubcontractor_fax	string		☐
assignedSubcontractor_generalLedgerAccountId	string		☐
assignedSubcontractor_gsm	string		☐
assignedSubcontractor_iban	string		☐
assignedSubcontractor_id	string		☐
assignedSubcontractor_invoiceRemarks	string		☐
assignedSubcontractor_kvk	string		☐
assignedSubcontractor_language	string		☐
assignedSubcontractor_legalFormId	string		☐
assignedSubcontractor_lockedAt	datetime		☐
assignedSubcontractor_logicId	string		☐
assignedSubcontractor_name	string		☐
assignedSubcontractor_paymentConditionId	string		☐
assignedSubcontractor_planningEmail	string		☐
assignedSubcontractor_status	string		☐
assignedSubcontractor_supplyOrderRemarks	string		☐
assignedSubcontractor_tel	string		☐
assignedSubcontractor_type	string		☐
assignedSubcontractor_updatedAt	datetime		☐
assignedSubcontractor_vatIdNumber	string		☐
assignedSubcontractor_vatTariffId	string		☐
assignedSubcontractor_website	string		☐
assignedSubcontractorId	string	ID toegewezen onderaannemer	☐
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	☐
brand	string	Merk	☐
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	☐
installation	boolean	Installatie	☐
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	☐
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.
serialNumber	string	Serienummer	☐
startDate	datetime	Startdatum	☐
status	string	Status	☐
stockLocation_archivedAt	datetime		☐
stockLocation_createdAt	datetime		☐
stockLocation_deletedAt	datetime		☐
stockLocation_extraFields	string		☐
stockLocation_id	string	Voorraadlocatie ID	☐
stockLocation_lockedAt	datetime		☐
stockLocation_name	string	Naam van Voorraadlocatie	☐
stockLocation_updatedAt	datetime		☐
stockLocationId	string	Voorraadlocatie-ID	☐
summary	string	Samenvatting	☐
supplier_archivedAt	datetime		☐
supplier_createdAt	datetime		☐
supplier_deletedAt	datetime		☐
supplier_email	string		☐
supplier_extraFields	string		☐
supplier_fax	string		☐
supplier_generalLedgerAccountId	string		☐
supplier_gsm	string		☐
supplier_iban	string		☐
supplier_id	string		☐
supplier_invoiceRemarks	string		☐
supplier_kvk	string		☐
supplier_language	string		☐
supplier_legalFormId	string		☐
supplier_lockedAt	datetime		☐
supplier_logicId	string		☐
supplier_name	string		☐
supplier_paymentConditionId	string		☐
supplier_planningEmail	string		☐
supplier_status	string		☐
supplier_supplyOrderRemarks	string		☐
supplier_tel	string		☐
supplier_type	string		☐
supplier_updatedAt	datetime		☐
supplier_vatIdNumber	string		☐
supplier_vatTariffId	string		☐
supplier_website	string		☐
supplierId	string	Leverancier-ID	☐
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

Schakel JavaScript in om deze site te bekijken.

ROBAWS API Data Model

PlanningMaterialsByPlanningId: ROBAWS Planningsmateriaal per plannings-ID

Parameters van de tabelfunctie

Kolommen van Tabelfunctie

Belangrijke Informatie over Veiligheid en Gebruik