WorkOrderTimeEntriesByWorkOrderId: ROBAWS Werkordertijdboekingen per werkorder-ID |
Find one
Catalogus: Robaws
Schema: WorkOrders
Label: Werkordertijdboekingen per werkorder-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 WorkOrderTimeEntriesByWorkOrderId 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 WorkOrderTimeEntriesByWorkOrderId 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 |
☐ |
|
breakMinutes |
decimal |
Pauze (minuten) |
☐ |
|
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 |
☐ |
|
clientReference |
string |
Referentie Klant |
☐ |
|
company__metadata_description |
string |
|
☐ |
|
company__metadata_href |
string |
|
☐ |
|
company__metadata_resource |
string |
|
☐ |
|
company__metadata_resourceTypeId |
string |
|
☐ |
|
company_address_addressLine1 |
string |
|
☐ |
|
company_address_addressLine2 |
string |
|
☐ |
|
company_address_city |
string |
|
☐ |
|
company_address_country |
string |
|
☐ |
|
company_address_latitude |
double |
|
☐ |
|
company_address_longitude |
double |
|
☐ |
|
company_address_postalCode |
string |
|
☐ |
|
company_archivedAt |
datetime |
|
☐ |
|
company_createdAt |
datetime |
|
☐ |
|
company_deletedAt |
datetime |
|
☐ |
|
company_extraFields |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
company_lockedAt |
datetime |
|
☐ |
|
company_name |
string |
|
☐ |
|
company_updatedAt |
datetime |
|
☐ |
|
companyId |
string |
Bedrijfs ID |
☐ |
|
costPrice |
decimal |
Kostprijs |
☐ |
|
createdAt_1 |
datetime |
Gemaakt op |
☐ |
|
createdAt |
datetime |
Gemaakt op |
☐ |
|
date |
datetime |
Datum |
☐ |
|
deletedAt_1 |
datetime |
Geschrapt bij |
☐ |
|
deletedAt |
datetime |
Geschrapt bij |
☐ |
|
employee_archivedAt |
datetime |
|
☐ |
|
employee_bankAccountNumber |
string |
|
☐ |
|
employee_civilStatus |
string |
|
☐ |
|
employee_collaborationEndDate |
datetime |
|
☐ |
|
employee_collaborationStartDate |
datetime |
|
☐ |
|
employee_competenceLevel |
string |
|
☐ |
|
employee_costPerHour |
decimal |
|
☐ |
|
employee_createdAt |
datetime |
|
☐ |
|
employee_dateOfBirth |
datetime |
|
☐ |
|
employee_defaultStockLocationId |
string |
|
☐ |
|
employee_defaultTimeOperationId |
string |
|
☐ |
|
employee_deletedAt |
datetime |
|
☐ |
|
employee_dimonaExpirationDate |
datetime |
|
☐ |
|
employee_dimonaNumber |
string |
|
☐ |
|
employee_distance |
decimal |
|
☐ |
|
employee_driverLicense |
string |
|
☐ |
|
employee_email |
string |
|
☐ |
|
employee_emergencyTel |
string |
|
☐ |
|
employee_employeeRoleId |
string |
|
☐ |
|
employee_employerId |
string |
|
☐ |
|
employee_extraFields |
string |
|
☐ |
|
employee_grossSalary |
decimal |
|
☐ |
|
employee_gsm |
string |
|
☐ |
|
employee_id |
string |
|
☐ |
|
employee_identityCardExpirationDate |
datetime |
|
☐ |
|
employee_identityCardNumber |
string |
|
☐ |
|
employee_independentRegistration |
boolean |
|
☐ |
|
employee_limosaExpirationDate |
datetime |
|
☐ |
|
employee_limosaNumber |
string |
|
☐ |
|
employee_lockedAt |
datetime |
|
☐ |
|
employee_name |
string |
|
☐ |
|
employee_nationality |
string |
|
☐ |
|
employee_nssoIdNumber |
string |
|
☐ |
|
employee_nssoPayment |
boolean |
|
☐ |
|
employee_nssoPaymentExpirationDate |
datetime |
|
☐ |
|
employee_numberOfDependents |
int32 |
|
☐ |
|
employee_planningGroup |
string |
|
☐ |
|
employee_position |
string |
|
☐ |
|
employee_secondment |
boolean |
|
☐ |
|
employee_status |
string |
|
☐ |
|
employee_statute |
string |
|
☐ |
|
employee_subType |
string |
|
☐ |
|
employee_surname |
string |
|
☐ |
|
employee_tel |
string |
|
☐ |
|
employee_type |
string |
|
☐ |
|
employee_updatedAt |
datetime |
|
☐ |
|
employeeId |
string |
Werknemer ID |
☐ |
|
endClient__metadata_description |
string |
|
☐ |
|
endClient__metadata_href |
string |
|
☐ |
|
endClient__metadata_resource |
string |
|
☐ |
|
endClient__metadata_resourceTypeId |
string |
|
☐ |
|
endClient_address_addressLine1 |
string |
|
☐ |
|
endClient_address_addressLine2 |
string |
|
☐ |
|
endClient_address_city |
string |
|
☐ |
|
endClient_address_country |
string |
|
☐ |
|
endClient_address_latitude |
double |
|
☐ |
|
endClient_address_longitude |
double |
|
☐ |
|
endClient_address_postalCode |
string |
|
☐ |
|
endClient_archivedAt |
datetime |
|
☐ |
|
endClient_assignedUser_archivedAt |
datetime |
|
☐ |
|
endClient_assignedUser_createdAt |
datetime |
|
☐ |
|
endClient_assignedUser_deletedAt |
datetime |
|
☐ |
|
endClient_assignedUser_email |
string |
|
☐ |
|
endClient_assignedUser_emailAccountActive |
boolean |
|
☐ |
|
endClient_assignedUser_extraFields |
string |
|
☐ |
|
endClient_assignedUser_fullName |
string |
|
☐ |
|
endClient_assignedUser_id |
string |
|
☐ |
|
endClient_assignedUser_locale |
string |
|
☐ |
|
endClient_assignedUser_locked |
boolean |
|
☐ |
|
endClient_assignedUser_lockedAt |
datetime |
|
☐ |
|
endClient_assignedUser_updatedAt |
datetime |
|
☐ |
|
endClient_assignedUserId |
string |
|
☐ |
|
endClient_createdAt |
datetime |
|
☐ |
|
endClient_creditStatus |
string |
|
☐ |
|
endClient_deletedAt |
datetime |
|
☐ |
|
endClient_email |
string |
|
☐ |
|
endClient_extraFields |
string |
|
☐ |
|
endClient_fax |
string |
|
☐ |
|
endClient_followUpDate |
datetime |
|
☐ |
|
endClient_generalLedgerAccount_archivedAt |
datetime |
|
☐ |
|
endClient_generalLedgerAccount_code |
string |
|
☐ |
|
endClient_generalLedgerAccount_createdAt |
datetime |
|
☐ |
|
endClient_generalLedgerAccount_deletedAt |
datetime |
|
☐ |
|
endClient_generalLedgerAccount_extraFields |
string |
|
☐ |
|
endClient_generalLedgerAccount_id |
string |
|
☐ |
|
endClient_generalLedgerAccount_lockedAt |
datetime |
|
☐ |
|
endClient_generalLedgerAccount_name |
string |
|
☐ |
|
endClient_generalLedgerAccount_updatedAt |
datetime |
|
☐ |
|
endClient_generalLedgerAccountId |
string |
|
☐ |
|
endClient_gsm |
string |
|
☐ |
|
endClient_id |
string |
|
☐ |
|
endClient_invoiceAddress_addressLine1 |
string |
|
☐ |
|
endClient_invoiceAddress_addressLine2 |
string |
|
☐ |
|
endClient_invoiceAddress_city |
string |
|
☐ |
|
endClient_invoiceAddress_country |
string |
|
☐ |
|
endClient_invoiceAddress_latitude |
double |
|
☐ |
|
endClient_invoiceAddress_longitude |
double |
|
☐ |
|
endClient_invoiceAddress_postalCode |
string |
|
☐ |
|
endClient_invoiceEmail |
string |
|
☐ |
|
endClient_language |
string |
|
☐ |
|
endClient_legalForm_archivedAt |
datetime |
|
☐ |
|
endClient_legalForm_createdAt |
datetime |
|
☐ |
|
endClient_legalForm_deletedAt |
datetime |
|
☐ |
|
endClient_legalForm_extraFields |
string |
|
☐ |
|
endClient_legalForm_id |
string |
|
☐ |
|
endClient_legalForm_legalAbbreviation |
string |
|
☐ |
|
endClient_legalForm_lockedAt |
datetime |
|
☐ |
|
endClient_legalForm_name |
string |
|
☐ |
|
endClient_legalForm_updatedAt |
datetime |
|
☐ |
|
endClient_legalForm_vatLiable |
boolean |
|
☐ |
|
endClient_legalFormId |
string |
|
☐ |
|
endClient_lockedAt |
datetime |
|
☐ |
|
endClient_name |
string |
|
☐ |
|
endClient_paymentCondition_archivedAt |
datetime |
|
☐ |
|
endClient_paymentCondition_createdAt |
datetime |
|
☐ |
|
endClient_paymentCondition_deletedAt |
datetime |
|
☐ |
|
endClient_paymentCondition_extraFields |
string |
|
☐ |
|
endClient_paymentCondition_id |
string |
|
☐ |
|
endClient_paymentCondition_lockedAt |
datetime |
|
☐ |
|
endClient_paymentCondition_name |
string |
|
☐ |
|
endClient_paymentCondition_purchase |
boolean |
|
☐ |
|
endClient_paymentCondition_sales |
boolean |
|
☐ |
|
endClient_paymentCondition_updatedAt |
datetime |
|
☐ |
|
endClient_paymentConditionId |
string |
|
☐ |
|
endClient_priceGroupId |
string |
|
☐ |
|
endClient_status |
string |
|
☐ |
|
endClient_statusDetails_color |
string |
|
☐ |
|
endClient_statusDetails_name |
string |
|
☐ |
|
endClient_tel |
string |
|
☐ |
|
endClient_title |
string |
|
☐ |
|
endClient_updatedAt |
datetime |
|
☐ |
|
endClient_vatIdNumber |
string |
|
☐ |
|
endClient_vatTariff_additionalMention |
string |
|
☐ |
|
endClient_vatTariff_archivedAt |
datetime |
|
☐ |
|
endClient_vatTariff_category |
string |
|
☐ |
|
endClient_vatTariff_createdAt |
datetime |
|
☐ |
|
endClient_vatTariff_deletedAt |
datetime |
|
☐ |
|
endClient_vatTariff_description |
string |
|
☐ |
|
endClient_vatTariff_excludedFromFinancialDiscount |
boolean |
|
☐ |
|
endClient_vatTariff_extraFields |
string |
|
☐ |
|
endClient_vatTariff_id |
string |
|
☐ |
|
endClient_vatTariff_inclusive |
boolean |
|
☐ |
|
endClient_vatTariff_lockedAt |
datetime |
|
☐ |
|
endClient_vatTariff_name |
string |
|
☐ |
|
endClient_vatTariff_percentage |
decimal |
|
☐ |
|
endClient_vatTariff_updatedAt |
datetime |
|
☐ |
|
endClient_vatTariffId |
string |
|
☐ |
|
endClient_website |
string |
|
☐ |
|
endClientId |
string |
ID eindklant |
☐ |
|
endTime_hour |
int32 |
|
☐ |
|
endTime_minute |
int32 |
|
☐ |
|
extraFields_1 |
string |
Extra velden |
☐ |
|
extraFields |
string |
Extra velden |
☐ |
|
hours |
decimal |
Uren |
☐ |
|
id_1 |
string |
ID |
☐ |
|
id |
string |
ID |
☐ |
|
lockedAt_1 |
datetime |
Gesloten op |
☐ |
|
lockedAt |
datetime |
Gesloten op |
☐ |
|
logicId |
string |
Logische ID |
☐ |
|
planningItem__metadata_description |
string |
|
☐ |
|
planningItem__metadata_href |
string |
|
☐ |
|
planningItem__metadata_resource |
string |
|
☐ |
|
planningItem__metadata_resourceTypeId |
string |
|
☐ |
|
planningItem_address_addressLine1 |
string |
|
☐ |
|
planningItem_address_addressLine2 |
string |
|
☐ |
|
planningItem_address_city |
string |
|
☐ |
|
planningItem_address_country |
string |
|
☐ |
|
planningItem_address_latitude |
double |
|
☐ |
|
planningItem_address_longitude |
double |
|
☐ |
|
planningItem_address_postalCode |
string |
|
☐ |
|
planningItem_archivedAt |
datetime |
|
☐ |
|
planningItem_basePlanningItem_archivedAt |
datetime |
|
☐ |
|
planningItem_basePlanningItem_basePlanningItemId |
string |
|
☐ |
|
planningItem_basePlanningItem_clientId |
string |
|
☐ |
|
planningItem_basePlanningItem_contactId |
string |
|
☐ |
|
planningItem_basePlanningItem_createdAt |
datetime |
|
☐ |
|
planningItem_basePlanningItem_deletedAt |
datetime |
|
☐ |
|
planningItem_basePlanningItem_description |
string |
|
☐ |
|
planningItem_basePlanningItem_endDate |
datetime |
|
☐ |
|
planningItem_basePlanningItem_executionPhaseDetail |
string |
|
☐ |
|
planningItem_basePlanningItem_executionPhaseId |
string |
|
☐ |
|
planningItem_basePlanningItem_externalId |
string |
|
☐ |
|
planningItem_basePlanningItem_extraFields |
string |
|
☐ |
|
planningItem_basePlanningItem_id |
string |
|
☐ |
|
planningItem_basePlanningItem_lockedAt |
datetime |
|
☐ |
|
planningItem_basePlanningItem_numberOfWorkOrders |
int32 |
|
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
planningItem_basePlanningItem_phaseId |
string |
|
☐ |
|
planningItem_basePlanningItem_planningTypeId |
string |
|
☐ |
|
planningItem_basePlanningItem_projectId |
string |
|
☐ |
|
planningItem_basePlanningItem_recurrenceEndDate |
datetime |
|
☐ |
|
planningItem_basePlanningItem_recurrenceRule |
string |
|
☐ |
|
planningItem_basePlanningItem_recurring |
boolean |
|
☐ |
|
planningItem_basePlanningItem_recurringMode |
string |
|
☐ |
Deprecated, use recurrenceType instead. |
planningItem_basePlanningItem_startDate |
datetime |
|
☐ |
|
planningItem_basePlanningItem_summary |
string |
|
☐ |
|
planningItem_basePlanningItem_timeAndMaterial |
boolean |
|
☐ |
|
planningItem_basePlanningItem_transportId |
string |
|
☐ |
|
planningItem_basePlanningItem_unavailableReason |
string |
|
☐ |
|
planningItem_basePlanningItem_updatedAt |
datetime |
|
☐ |
|
planningItem_basePlanningItemId |
string |
|
☐ |
|
planningItem_client_archivedAt |
datetime |
|
☐ |
|
planningItem_client_assignedUserId |
string |
|
☐ |
|
planningItem_client_createdAt |
datetime |
|
☐ |
|
planningItem_client_creditStatus |
string |
|
☐ |
|
planningItem_client_deletedAt |
datetime |
|
☐ |
|
planningItem_client_email |
string |
|
☐ |
|
planningItem_client_extraFields |
string |
|
☐ |
|
planningItem_client_fax |
string |
|
☐ |
|
planningItem_client_followUpDate |
datetime |
|
☐ |
|
planningItem_client_generalLedgerAccountId |
string |
|
☐ |
|
planningItem_client_gsm |
string |
|
☐ |
|
planningItem_client_id |
string |
|
☐ |
|
planningItem_client_invoiceEmail |
string |
|
☐ |
|
planningItem_client_language |
string |
|
☐ |
|
planningItem_client_legalFormId |
string |
|
☐ |
|
planningItem_client_lockedAt |
datetime |
|
☐ |
|
planningItem_client_name |
string |
|
☐ |
|
planningItem_client_paymentConditionId |
string |
|
☐ |
|
planningItem_client_priceGroupId |
string |
|
☐ |
|
planningItem_client_status |
string |
|
☐ |
|
planningItem_client_tel |
string |
|
☐ |
|
planningItem_client_title |
string |
|
☐ |
|
planningItem_client_updatedAt |
datetime |
|
☐ |
|
planningItem_client_vatIdNumber |
string |
|
☐ |
|
planningItem_client_vatTariffId |
string |
|
☐ |
|
planningItem_client_website |
string |
|
☐ |
|
planningItem_clientId |
string |
|
☐ |
|
planningItem_contact_archivedAt |
datetime |
|
☐ |
|
planningItem_contact_createdAt |
datetime |
|
☐ |
|
planningItem_contact_deletedAt |
datetime |
|
☐ |
|
planningItem_contact_email |
string |
|
☐ |
|
planningItem_contact_extraFields |
string |
|
☐ |
|
planningItem_contact_gsm |
string |
|
☐ |
|
planningItem_contact_id |
string |
|
☐ |
|
planningItem_contact_lockedAt |
datetime |
|
☐ |
|
planningItem_contact_name |
string |
|
☐ |
|
planningItem_contact_position |
string |
|
☐ |
|
planningItem_contact_surname |
string |
|
☐ |
|
planningItem_contact_tel |
string |
|
☐ |
|
planningItem_contact_title |
string |
|
☐ |
|
planningItem_contact_updatedAt |
datetime |
|
☐ |
|
planningItem_contactId |
string |
|
☐ |
|
planningItem_createdAt |
datetime |
|
☐ |
|
planningItem_deletedAt |
datetime |
|
☐ |
|
planningItem_description |
string |
|
☐ |
|
planningItem_endDate |
datetime |
|
☐ |
|
planningItem_executionPhase_archivedAt |
datetime |
|
☐ |
|
planningItem_executionPhase_createdAt |
datetime |
|
☐ |
|
planningItem_executionPhase_deletedAt |
datetime |
|
☐ |
|
planningItem_executionPhase_extraFields |
string |
|
☐ |
|
planningItem_executionPhase_id |
string |
|
☐ |
|
planningItem_executionPhase_lockedAt |
datetime |
|
☐ |
|
planningItem_executionPhase_name |
string |
|
☐ |
|
planningItem_executionPhase_planningGroup |
string |
|
☐ |
|
planningItem_executionPhase_updatedAt |
datetime |
|
☐ |
|
planningItem_executionPhaseDetail |
string |
|
☐ |
|
planningItem_executionPhaseId |
string |
|
☐ |
|
planningItem_externalId |
string |
|
☐ |
|
planningItem_extraFields |
string |
|
☐ |
|
planningItem_id |
string |
|
☐ |
|
planningItem_lockedAt |
datetime |
|
☐ |
|
planningItem_numberOfWorkOrders |
int32 |
|
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
planningItem_phase_archivedAt |
datetime |
|
☐ |
|
planningItem_phase_createdAt |
datetime |
|
☐ |
|
planningItem_phase_deletedAt |
datetime |
|
☐ |
|
planningItem_phase_endDate |
datetime |
|
☐ |
|
planningItem_phase_extraFields |
string |
|
☐ |
|
planningItem_phase_id |
string |
|
☐ |
|
planningItem_phase_lockedAt |
datetime |
|
☐ |
|
planningItem_phase_name |
string |
|
☐ |
|
planningItem_phase_offerId |
string |
|
☐ |
Only present when obtained via offer bulk endpoint |
planningItem_phase_projectId |
string |
|
☐ |
Only present when obtained via project bulk endpoint |
planningItem_phase_settlementId |
string |
|
☐ |
Only present when obtained via settlements bulk endpoint |
planningItem_phase_startDate |
datetime |
|
☐ |
|
planningItem_phase_updatedAt |
datetime |
|
☐ |
|
planningItem_phase_workingDays |
int32 |
|
☐ |
|
planningItem_phaseId |
string |
|
☐ |
|
planningItem_planningType_archivedAt |
datetime |
|
☐ |
|
planningItem_planningType_color |
string |
|
☐ |
|
planningItem_planningType_createdAt |
datetime |
|
☐ |
|
planningItem_planningType_deletedAt |
datetime |
|
☐ |
|
planningItem_planningType_extraFields |
string |
|
☐ |
|
planningItem_planningType_id |
string |
|
☐ |
|
planningItem_planningType_lockedAt |
datetime |
|
☐ |
|
planningItem_planningType_name |
string |
|
☐ |
|
planningItem_planningType_updatedAt |
datetime |
|
☐ |
|
planningItem_planningTypeId |
string |
|
☐ |
|
planningItem_project_archivedAt |
datetime |
|
☐ |
|
planningItem_project_checkInAtWork |
string |
|
☐ |
|
planningItem_project_clientContactId |
string |
|
☐ |
|
planningItem_project_clientId |
string |
|
☐ |
|
planningItem_project_clientReference |
string |
|
☐ |
|
planningItem_project_companyId |
string |
|
☐ |
|
planningItem_project_createdAt |
datetime |
|
☐ |
|
planningItem_project_date |
datetime |
|
☐ |
|
planningItem_project_deletedAt |
datetime |
|
☐ |
|
planningItem_project_distance |
int32 |
|
☐ |
|
planningItem_project_endClientContactId |
string |
|
☐ |
|
planningItem_project_endClientId |
string |
|
☐ |
|
planningItem_project_extraFields |
string |
|
☐ |
|
planningItem_project_geofence |
string |
|
☐ |
|
planningItem_project_id |
string |
|
☐ |
|
planningItem_project_lockedAt |
datetime |
|
☐ |
|
planningItem_project_logicId |
string |
|
☐ |
|
planningItem_project_nssoDeclarationOfWorks |
string |
|
☐ |
|
planningItem_project_planningGroup |
string |
|
☐ |
|
planningItem_project_planningName |
string |
|
☐ |
|
planningItem_project_siteManagerId |
string |
|
☐ |
|
planningItem_project_siteNssoIdNumber |
string |
|
☐ |
|
planningItem_project_status |
string |
|
☐ |
|
planningItem_project_updatedAt |
datetime |
|
☐ |
|
planningItem_projectId |
string |
|
☐ |
|
planningItem_recurrenceEndDate |
datetime |
|
☐ |
|
planningItem_recurrenceRule |
string |
|
☐ |
|
planningItem_recurring |
boolean |
|
☐ |
|
planningItem_recurringMode |
string |
|
☐ |
Deprecated, use recurrenceType instead. |
planningItem_startDate |
datetime |
|
☐ |
|
planningItem_summary |
string |
|
☐ |
|
planningItem_timeAndMaterial |
boolean |
|
☐ |
|
planningItem_transportId |
string |
|
☐ |
|
planningItem_unavailableReason |
string |
|
☐ |
|
planningItem_updatedAt |
datetime |
|
☐ |
|
planningItemId |
string |
Planning Punt 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 |
☐ |
|
remark_1 |
string |
Opmerking |
☐ |
|
remark |
string |
Opmerking |
☐ |
|
salePrice |
decimal |
Verkoopprijs |
☐ |
|
startTime_hour |
int32 |
|
☐ |
|
startTime_minute |
int32 |
|
☐ |
|
status |
string |
Status |
☐ |
|
timeAndMaterial |
boolean |
Tijd en materiaal |
☐ |
|
title |
string |
Titel |
☐ |
|
totalCostExclVat |
decimal |
Totale kosten exclusief btw |
☐ |
|
totalExclVat |
decimal |
Totaal exclusief BTW |
☐ |
|
updatedAt_1 |
datetime |
Bijgewerkt op |
☐ |
|
updatedAt |
datetime |
Bijgewerkt op |
☐ |
|
workOrderId |
string |
ID werkopdracht |
☐ |
Only present when obtained via bulk endpoint |
30-09-2023 07:40 Versie 23.0.49-PROD+4237