Navigatie: Schema: PlanningItems > Tables

PlanningEmployeeSkillsByPlanningId: ROBAWS Vaardigheden planningsmedewerker per plannings-ID

Find one

Catalogus: Robaws

Schema: PlanningItems

Label: Vaardigheden planningsmedewerker 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 PlanningEmployeeSkillsByPlanningId 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 PlanningEmployeeSkillsByPlanningId 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	☐
bankAccountNumber	string	Bankrekeningnummer	☐
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		☐
civilStatus	string	Burgerlijke staat	☐
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	☐
collaborationEndDate	datetime	Einddatum samenwerking	☐
collaborationStartDate	datetime	Startdatum samenwerking	☐
competenceLevel	string	Bekwaamheidsniveau	☐
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	☐
costPerHour	decimal	Kosten per Uur	☐
createdAt_1	datetime	Gemaakt op	☐
createdAt	datetime	Gemaakt op	☐
dateOfBirth	datetime	Geboortedatum	☐
defaultStockLocation_archivedAt	datetime		☐
defaultStockLocation_createdAt	datetime		☐
defaultStockLocation_deletedAt	datetime		☐
defaultStockLocation_extraFields	string		☐
defaultStockLocation_id	string		☐
defaultStockLocation_lockedAt	datetime		☐
defaultStockLocation_name	string		☐
defaultStockLocation_updatedAt	datetime		☐
defaultStockLocationId	string	Standaard voorraadlocatie-ID	☐
defaultTimeOperation_activityId	string		☐
defaultTimeOperation_archivedAt	datetime		☐
defaultTimeOperation_articleGroupId	string		☐
defaultTimeOperation_articleNumber	string		☐
defaultTimeOperation_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.
defaultTimeOperation_backorderStock	decimal		☐	When reading, only present if requested via 'include' query parameter, otherwise null.
defaultTimeOperation_barcode	string		☐
defaultTimeOperation_brand	string		☐
defaultTimeOperation_calculationType	string		☐
defaultTimeOperation_costPrice	decimal		☐
defaultTimeOperation_costPriceStrategy	string		☐
defaultTimeOperation_createdAt	datetime		☐
defaultTimeOperation_deletedAt	datetime		☐
defaultTimeOperation_description	string		☐
defaultTimeOperation_descriptionTranslations	string		☐
defaultTimeOperation_extraFields	string		☐
defaultTimeOperation_id	string		☐
defaultTimeOperation_installation	boolean		☐
defaultTimeOperation_lockedAt	datetime		☐
defaultTimeOperation_margin	decimal		☐
defaultTimeOperation_minimumStock	decimal		☐
defaultTimeOperation_name	string		☐
defaultTimeOperation_nameTranslations	string		☐
defaultTimeOperation_purchaseGLAccountId	string		☐
defaultTimeOperation_reservedStock	decimal		☐	When reading, only present if requested via 'include' query parameter, otherwise null.
defaultTimeOperation_saleName	string		☐
defaultTimeOperation_salePrice	decimal		☐
defaultTimeOperation_salePriceStrategy	string		☐
defaultTimeOperation_salesGLAccountId	string		☐
defaultTimeOperation_stockArticle	boolean		☐
defaultTimeOperation_stockPlace	string		☐
defaultTimeOperation_targetStock	decimal		☐
defaultTimeOperation_timeOperation	boolean		☐
defaultTimeOperation_totalStock	decimal		☐	When reading, only present if requested via 'include' query parameter, otherwise null.
defaultTimeOperation_type	string		☐
defaultTimeOperation_unitType	string		☐
defaultTimeOperation_updatedAt	datetime		☐
defaultTimeOperation_vatTariffId	string		☐
defaultTimeOperation_wappy	boolean		☐
defaultTimeOperationId	string	Standaard tijd Operatie-ID	☐
deletedAt_1	datetime	Geschrapt bij	☐
deletedAt	datetime	Geschrapt bij	☐
description	string	Omschrijving	☐
dimonaExpirationDate	datetime		☐
dimonaNumber	string		☐
distance	decimal	Afstand	☐
domicileAddress_addressLine1	string	Adres Regel 1	☐
domicileAddress_addressLine2	string	Adres Regel 2	☐
domicileAddress_city	string		☐
domicileAddress_country	string		☐
domicileAddress_latitude	double		☐
domicileAddress_longitude	double		☐
domicileAddress_postalCode	string		☐
driverLicense	string	Rijbewijs	☐
email	string	E-mail	☐
emergencyTel	string	In Geval van Nood (telefoon)	☐
employeeRole_archivedAt	datetime		☐
employeeRole_createdAt	datetime		☐
employeeRole_deletedAt	datetime		☐
employeeRole_extraFields	string		☐
employeeRole_id	string		☐
employeeRole_lockedAt	datetime		☐
employeeRole_name	string		☐
employeeRole_updatedAt	datetime		☐
employeeRoleId	string	Rol-ID werknemer	☐
employer_archivedAt	datetime		☐
employer_createdAt	datetime		☐
employer_deletedAt	datetime		☐
employer_email	string		☐
employer_extraFields	string		☐
employer_fax	string		☐
employer_generalLedgerAccountId	string		☐
employer_gsm	string		☐
employer_iban	string		☐
employer_id	string		☐
employer_invoiceRemarks	string		☐
employer_kvk	string		☐
employer_language	string		☐
employer_legalFormId	string		☐
employer_lockedAt	datetime		☐
employer_logicId	string		☐
employer_name	string		☐
employer_paymentConditionId	string		☐
employer_planningEmail	string		☐
employer_status	string		☐
employer_supplyOrderRemarks	string		☐
employer_tel	string		☐
employer_type	string		☐
employer_updatedAt	datetime		☐
employer_vatIdNumber	string		☐
employer_vatTariffId	string		☐
employer_website	string		☐
employerId	string	Werkgever ID	☐
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	☐
grossSalary	decimal	Brutosalaris	☐
gsm	string	Mobiel	☐
id_1	string	ID	☐
id	string	ID	☐
identityCardExpirationDate	datetime	Vervaldatum identiteitskaart	☐
identityCardNumber	string	Identiteitskaartnummer	☐
image_archivedAt	datetime		☐
image_contentType	string		☐
image_createdAt	datetime		☐
image_deletedAt	datetime		☐
image_directory	boolean		☐
image_id	string		☐
image_lockedAt	datetime		☐
image_name	string		☐
image_parentId	string		☐
image_previewUrl	string		☐
image_size	int64		☐
image_updatedAt	datetime		☐
image_url	string		☐
independentRegistration	boolean	Onafhankelijke registratie	☐
limosaExpirationDate	datetime		☐
limosaNumber	string		☐
lockedAt_1	datetime	Gesloten op	☐
lockedAt	datetime	Gesloten op	☐
name	string	Naam	☐
nationality	string	Nationaliteit	☐
nssoIdNumber	string	ID-nummer NSSO	☐
nssoPayment	boolean	RSZ-betaling	☐
nssoPaymentExpirationDate	datetime	Vervaldatum RSZ-betaling	☐
numberOfDependents	int32	Aantal personen ten laste	☐
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	☐
position	string	Positie	☐
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.
secondment	boolean	Detachering	☐
startDate	datetime	Startdatum	☐
status	string	Status	☐
statute	string	Statuut	☐
subType	string	Deelsoort	☐
summary	string	Samenvatting	☐
surname	string	Achternaam	☐
tel	string	Telefoon	☐
TEXT	string	Tekst	☐
timeAndMaterial	boolean	Tijd en materiaal	☐
transportId	string	Transport ID	☐
type	string	Soort	☐
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

PlanningEmployeeSkillsByPlanningId: ROBAWS Vaardigheden planningsmedewerker per plannings-ID

Parameters van de tabelfunctie

Kolommen van Tabelfunctie

Belangrijke Informatie over Veiligheid en Gebruik