PurchaseInvoiceLineIdsByPurchaseInvoiceId: ROBAWS Inkoopfactuurregel-ID's op inkoopfactuur-ID |
Find one
Catalogus: Robaws
Schema: PurchaseInvoiceLineItems
Label: Inkoopfactuurregel-ID's op inkoopfactuur-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 PurchaseInvoiceLineIdsByPurchaseInvoiceId 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 |
☐ |
|
|
purchaseInvoiceId |
string |
☐ |
|
|
Kolommen van Tabelfunctie
De kolommen van de tabelfunctie PurchaseInvoiceLineIdsByPurchaseInvoiceId worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
activity__metadata_description |
string |
|
☐ |
|
activity__metadata_href |
string |
|
☐ |
|
activity__metadata_resource |
string |
|
☐ |
|
activity__metadata_resourceTypeId |
string |
|
☐ |
|
activity_archivedAt |
datetime |
|
☐ |
|
activity_createdAt |
datetime |
|
☐ |
|
activity_deletedAt |
datetime |
|
☐ |
|
activity_extraFields |
string |
|
☐ |
|
activity_id |
string |
|
☐ |
|
activity_lockedAt |
datetime |
|
☐ |
|
activity_name |
string |
|
☐ |
|
activity_updatedAt |
datetime |
|
☐ |
|
activityId |
string |
Activiteit ID |
☐ |
|
archivedAt |
datetime |
Gearchiveerd op |
☐ |
|
article__metadata_description |
string |
|
☐ |
|
article__metadata_href |
string |
|
☐ |
|
article__metadata_resource |
string |
|
☐ |
|
article__metadata_resourceTypeId |
string |
|
☐ |
|
article_activity_archivedAt |
datetime |
|
☐ |
|
article_activity_createdAt |
datetime |
|
☐ |
|
article_activity_deletedAt |
datetime |
|
☐ |
|
article_activity_extraFields |
string |
|
☐ |
|
article_activity_id |
string |
|
☐ |
|
article_activity_lockedAt |
datetime |
|
☐ |
|
article_activity_name |
string |
|
☐ |
|
article_activity_updatedAt |
datetime |
|
☐ |
|
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_group_archivedAt |
datetime |
|
☐ |
|
article_group_createdAt |
datetime |
|
☐ |
|
article_group_deletedAt |
datetime |
|
☐ |
|
article_group_extraFields |
string |
|
☐ |
|
article_group_id |
string |
|
☐ |
|
article_group_lockedAt |
datetime |
|
☐ |
|
article_group_name |
string |
|
☐ |
|
article_group_parentId |
string |
|
☐ |
|
article_group_updatedAt |
datetime |
|
☐ |
|
article_group_wappy |
boolean |
|
☐ |
|
article_id |
string |
Artikel ID |
☐ |
|
article_image_archivedAt |
datetime |
|
☐ |
|
article_image_contentType |
string |
|
☐ |
|
article_image_createdAt |
datetime |
|
☐ |
|
article_image_deletedAt |
datetime |
|
☐ |
|
article_image_directory |
boolean |
|
☐ |
|
article_image_id |
string |
|
☐ |
|
article_image_lockedAt |
datetime |
|
☐ |
|
article_image_name |
string |
|
☐ |
|
article_image_parentId |
string |
|
☐ |
|
article_image_previewUrl |
string |
|
☐ |
|
article_image_size |
int64 |
|
☐ |
|
article_image_updatedAt |
datetime |
|
☐ |
|
article_image_url |
string |
|
☐ |
|
article_installation |
boolean |
|
☐ |
|
article_lockedAt |
datetime |
|
☐ |
|
article_margin |
decimal |
|
☐ |
|
article_minimumStock |
decimal |
|
☐ |
|
article_name |
string |
|
☐ |
|
article_nameTranslations |
string |
|
☐ |
|
article_purchaseGLAccount_archivedAt |
datetime |
|
☐ |
|
article_purchaseGLAccount_code |
string |
|
☐ |
|
article_purchaseGLAccount_createdAt |
datetime |
|
☐ |
|
article_purchaseGLAccount_deletedAt |
datetime |
|
☐ |
|
article_purchaseGLAccount_extraFields |
string |
|
☐ |
|
article_purchaseGLAccount_id |
string |
|
☐ |
|
article_purchaseGLAccount_lockedAt |
datetime |
|
☐ |
|
article_purchaseGLAccount_name |
string |
|
☐ |
|
article_purchaseGLAccount_updatedAt |
datetime |
|
☐ |
|
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_salesGLAccount_archivedAt |
datetime |
|
☐ |
|
article_salesGLAccount_code |
string |
|
☐ |
|
article_salesGLAccount_createdAt |
datetime |
|
☐ |
|
article_salesGLAccount_deletedAt |
datetime |
|
☐ |
|
article_salesGLAccount_extraFields |
string |
|
☐ |
|
article_salesGLAccount_id |
string |
|
☐ |
|
article_salesGLAccount_lockedAt |
datetime |
|
☐ |
|
article_salesGLAccount_name |
string |
|
☐ |
|
article_salesGLAccount_updatedAt |
datetime |
|
☐ |
|
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 |
☐ |
|
c_metadata_description |
string |
|
☐ |
|
c_metadata_href |
string |
|
☐ |
|
c_metadata_resource |
string |
|
☐ |
|
c_metadata_resourceTypeId |
string |
|
☐ |
|
createdAt |
datetime |
Gemaakt op |
☐ |
|
deletedAt |
datetime |
Geschrapt bij |
☐ |
|
description |
string |
Omschrijving |
☐ |
|
discount |
decimal |
Korting |
☐ |
|
extraFields |
string |
Extra velden |
☐ |
|
generalLedgerAccount__metadata_description |
string |
|
☐ |
|
generalLedgerAccount__metadata_href |
string |
|
☐ |
|
generalLedgerAccount__metadata_resource |
string |
|
☐ |
|
generalLedgerAccount__metadata_resourceTypeId |
string |
|
☐ |
|
generalLedgerAccount_archivedAt |
datetime |
|
☐ |
|
generalLedgerAccount_code |
string |
|
☐ |
|
generalLedgerAccount_createdAt |
datetime |
|
☐ |
|
generalLedgerAccount_deletedAt |
datetime |
|
☐ |
|
generalLedgerAccount_extraFields |
string |
|
☐ |
|
generalLedgerAccount_id |
string |
|
☐ |
|
generalLedgerAccount_lockedAt |
datetime |
|
☐ |
|
generalLedgerAccount_name |
string |
|
☐ |
|
generalLedgerAccount_updatedAt |
datetime |
|
☐ |
|
generalLedgerAccountId |
string |
ID grootboekrekening |
☐ |
|
id |
string |
ID |
☐ |
|
lockedAt |
datetime |
Gesloten op |
☐ |
|
material__metadata_description |
string |
|
☐ |
|
material__metadata_href |
string |
|
☐ |
|
material__metadata_resource |
string |
|
☐ |
|
material__metadata_resourceTypeId |
string |
|
☐ |
|
material_archivedAt |
datetime |
|
☐ |
|
material_article_activityId |
string |
|
☐ |
|
material_article_archivedAt |
datetime |
|
☐ |
|
material_article_articleGroupId |
string |
|
☐ |
|
material_article_articleNumber |
string |
|
☐ |
|
material_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. |
material_article_backorderStock |
decimal |
|
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
material_article_barcode |
string |
|
☐ |
|
material_article_brand |
string |
|
☐ |
|
material_article_calculationType |
string |
|
☐ |
|
material_article_costPrice |
decimal |
|
☐ |
|
material_article_costPriceStrategy |
string |
|
☐ |
|
material_article_createdAt |
datetime |
|
☐ |
|
material_article_deletedAt |
datetime |
|
☐ |
|
material_article_description |
string |
|
☐ |
|
material_article_descriptionTranslations |
string |
|
☐ |
|
material_article_extraFields |
string |
|
☐ |
|
material_article_id |
string |
|
☐ |
|
material_article_installation |
boolean |
|
☐ |
|
material_article_lockedAt |
datetime |
|
☐ |
|
material_article_margin |
decimal |
|
☐ |
|
material_article_minimumStock |
decimal |
|
☐ |
|
material_article_name |
string |
|
☐ |
|
material_article_nameTranslations |
string |
|
☐ |
|
material_article_purchaseGLAccountId |
string |
|
☐ |
|
material_article_reservedStock |
decimal |
|
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
material_article_saleName |
string |
|
☐ |
|
material_article_salePrice |
decimal |
|
☐ |
|
material_article_salePriceStrategy |
string |
|
☐ |
|
material_article_salesGLAccountId |
string |
|
☐ |
|
material_article_stockArticle |
boolean |
|
☐ |
|
material_article_stockPlace |
string |
|
☐ |
|
material_article_targetStock |
decimal |
|
☐ |
|
material_article_timeOperation |
boolean |
|
☐ |
|
material_article_totalStock |
decimal |
|
☐ |
When reading, only present if requested via 'include' query parameter, otherwise null. |
material_article_type |
string |
|
☐ |
|
material_article_unitType |
string |
|
☐ |
|
material_article_updatedAt |
datetime |
|
☐ |
|
material_article_vatTariffId |
string |
|
☐ |
|
material_article_wappy |
boolean |
|
☐ |
|
material_articleId |
string |
|
☐ |
|
material_assignedClient_archivedAt |
datetime |
|
☐ |
|
material_assignedClient_assignedUserId |
string |
|
☐ |
|
material_assignedClient_createdAt |
datetime |
|
☐ |
|
material_assignedClient_creditStatus |
string |
|
☐ |
|
material_assignedClient_deletedAt |
datetime |
|
☐ |
|
material_assignedClient_email |
string |
|
☐ |
|
material_assignedClient_extraFields |
string |
|
☐ |
|
material_assignedClient_fax |
string |
|
☐ |
|
material_assignedClient_followUpDate |
datetime |
|
☐ |
|
material_assignedClient_generalLedgerAccountId |
string |
|
☐ |
|
material_assignedClient_gsm |
string |
|
☐ |
|
material_assignedClient_id |
string |
|
☐ |
|
material_assignedClient_invoiceEmail |
string |
|
☐ |
|
material_assignedClient_language |
string |
|
☐ |
|
material_assignedClient_legalFormId |
string |
|
☐ |
|
material_assignedClient_lockedAt |
datetime |
|
☐ |
|
material_assignedClient_name |
string |
|
☐ |
|
material_assignedClient_paymentConditionId |
string |
|
☐ |
|
material_assignedClient_priceGroupId |
string |
|
☐ |
|
material_assignedClient_status |
string |
|
☐ |
|
material_assignedClient_tel |
string |
|
☐ |
|
material_assignedClient_title |
string |
|
☐ |
|
material_assignedClient_updatedAt |
datetime |
|
☐ |
|
material_assignedClient_vatIdNumber |
string |
|
☐ |
|
material_assignedClient_vatTariffId |
string |
|
☐ |
|
material_assignedClient_website |
string |
|
☐ |
|
material_assignedClientId |
string |
|
☐ |
|
material_assignedEmployee_archivedAt |
datetime |
|
☐ |
|
material_assignedEmployee_bankAccountNumber |
string |
|
☐ |
|
material_assignedEmployee_civilStatus |
string |
|
☐ |
|
material_assignedEmployee_collaborationEndDate |
datetime |
|
☐ |
|
material_assignedEmployee_collaborationStartDate |
datetime |
|
☐ |
|
material_assignedEmployee_competenceLevel |
string |
|
☐ |
|
material_assignedEmployee_costPerHour |
decimal |
|
☐ |
|
material_assignedEmployee_createdAt |
datetime |
|
☐ |
|
material_assignedEmployee_dateOfBirth |
datetime |
|
☐ |
|
material_assignedEmployee_defaultStockLocationId |
string |
|
☐ |
|
material_assignedEmployee_defaultTimeOperationId |
string |
|
☐ |
|
material_assignedEmployee_deletedAt |
datetime |
|
☐ |
|
material_assignedEmployee_dimonaExpirationDate |
datetime |
|
☐ |
|
material_assignedEmployee_dimonaNumber |
string |
|
☐ |
|
material_assignedEmployee_distance |
decimal |
|
☐ |
|
material_assignedEmployee_driverLicense |
string |
|
☐ |
|
material_assignedEmployee_email |
string |
|
☐ |
|
material_assignedEmployee_emergencyTel |
string |
|
☐ |
|
material_assignedEmployee_employeeRoleId |
string |
|
☐ |
|
material_assignedEmployee_employerId |
string |
|
☐ |
|
material_assignedEmployee_extraFields |
string |
|
☐ |
|
material_assignedEmployee_grossSalary |
decimal |
|
☐ |
|
material_assignedEmployee_gsm |
string |
|
☐ |
|
material_assignedEmployee_id |
string |
|
☐ |
|
material_assignedEmployee_identityCardExpirationDate |
datetime |
|
☐ |
|
material_assignedEmployee_identityCardNumber |
string |
|
☐ |
|
material_assignedEmployee_independentRegistration |
boolean |
|
☐ |
|
material_assignedEmployee_limosaExpirationDate |
datetime |
|
☐ |
|
material_assignedEmployee_limosaNumber |
string |
|
☐ |
|
material_assignedEmployee_lockedAt |
datetime |
|
☐ |
|
material_assignedEmployee_name |
string |
|
☐ |
|
material_assignedEmployee_nationality |
string |
|
☐ |
|
material_assignedEmployee_nssoIdNumber |
string |
|
☐ |
|
material_assignedEmployee_nssoPayment |
boolean |
|
☐ |
|
material_assignedEmployee_nssoPaymentExpirationDate |
datetime |
|
☐ |
|
material_assignedEmployee_numberOfDependents |
int32 |
|
☐ |
|
material_assignedEmployee_planningGroup |
string |
|
☐ |
|
material_assignedEmployee_position |
string |
|
☐ |
|
material_assignedEmployee_secondment |
boolean |
|
☐ |
|
material_assignedEmployee_status |
string |
|
☐ |
|
material_assignedEmployee_statute |
string |
|
☐ |
|
material_assignedEmployee_subType |
string |
|
☐ |
|
material_assignedEmployee_surname |
string |
|
☐ |
|
material_assignedEmployee_tel |
string |
|
☐ |
|
material_assignedEmployee_type |
string |
|
☐ |
|
material_assignedEmployee_updatedAt |
datetime |
|
☐ |
|
material_assignedEmployeeId |
string |
|
☐ |
|
material_assignedProject_archivedAt |
datetime |
|
☐ |
|
material_assignedProject_checkInAtWork |
string |
|
☐ |
|
material_assignedProject_clientContactId |
string |
|
☐ |
|
material_assignedProject_clientId |
string |
|
☐ |
|
material_assignedProject_clientReference |
string |
|
☐ |
|
material_assignedProject_companyId |
string |
|
☐ |
|
material_assignedProject_createdAt |
datetime |
|
☐ |
|
material_assignedProject_date |
datetime |
|
☐ |
|
material_assignedProject_deletedAt |
datetime |
|
☐ |
|
material_assignedProject_distance |
int32 |
|
☐ |
|
material_assignedProject_endClientContactId |
string |
|
☐ |
|
material_assignedProject_endClientId |
string |
|
☐ |
|
material_assignedProject_extraFields |
string |
|
☐ |
|
material_assignedProject_geofence |
string |
|
☐ |
|
material_assignedProject_id |
string |
|
☐ |
|
material_assignedProject_lockedAt |
datetime |
|
☐ |
|
material_assignedProject_logicId |
string |
|
☐ |
|
material_assignedProject_nssoDeclarationOfWorks |
string |
|
☐ |
|
material_assignedProject_planningGroup |
string |
|
☐ |
|
material_assignedProject_planningName |
string |
|
☐ |
|
material_assignedProject_siteManagerId |
string |
|
☐ |
|
material_assignedProject_siteNssoIdNumber |
string |
|
☐ |
|
material_assignedProject_status |
string |
|
☐ |
|
material_assignedProject_updatedAt |
datetime |
|
☐ |
|
material_assignedProjectId |
string |
|
☐ |
|
material_assignedSubcontractor_archivedAt |
datetime |
|
☐ |
|
material_assignedSubcontractor_createdAt |
datetime |
|
☐ |
|
material_assignedSubcontractor_deletedAt |
datetime |
|
☐ |
|
material_assignedSubcontractor_email |
string |
|
☐ |
|
material_assignedSubcontractor_extraFields |
string |
|
☐ |
|
material_assignedSubcontractor_fax |
string |
|
☐ |
|
material_assignedSubcontractor_generalLedgerAccountId |
string |
|
☐ |
|
material_assignedSubcontractor_gsm |
string |
|
☐ |
|
material_assignedSubcontractor_iban |
string |
|
☐ |
|
material_assignedSubcontractor_id |
string |
|
☐ |
|
material_assignedSubcontractor_invoiceRemarks |
string |
|
☐ |
|
material_assignedSubcontractor_kvk |
string |
|
☐ |
|
material_assignedSubcontractor_language |
string |
|
☐ |
|
material_assignedSubcontractor_legalFormId |
string |
|
☐ |
|
material_assignedSubcontractor_lockedAt |
datetime |
|
☐ |
|
material_assignedSubcontractor_logicId |
string |
|
☐ |
|
material_assignedSubcontractor_name |
string |
|
☐ |
|
material_assignedSubcontractor_paymentConditionId |
string |
|
☐ |
|
material_assignedSubcontractor_planningEmail |
string |
|
☐ |
|
material_assignedSubcontractor_status |
string |
|
☐ |
|
material_assignedSubcontractor_supplyOrderRemarks |
string |
|
☐ |
|
material_assignedSubcontractor_tel |
string |
|
☐ |
|
material_assignedSubcontractor_type |
string |
|
☐ |
|
material_assignedSubcontractor_updatedAt |
datetime |
|
☐ |
|
material_assignedSubcontractor_vatIdNumber |
string |
|
☐ |
|
material_assignedSubcontractor_vatTariffId |
string |
|
☐ |
|
material_assignedSubcontractor_website |
string |
|
☐ |
|
material_assignedSubcontractorId |
string |
|
☐ |
|
material_brand |
string |
|
☐ |
|
material_createdAt |
datetime |
|
☐ |
|
material_deletedAt |
datetime |
|
☐ |
|
material_extraFields |
string |
|
☐ |
|
material_id |
string |
|
☐ |
|
material_installation |
boolean |
|
☐ |
|
material_lockedAt |
datetime |
|
☐ |
|
material_name |
string |
|
☐ |
|
material_serialNumber |
string |
|
☐ |
|
material_status |
string |
|
☐ |
|
material_stockLocation_archivedAt |
datetime |
|
☐ |
|
material_stockLocation_createdAt |
datetime |
|
☐ |
|
material_stockLocation_deletedAt |
datetime |
|
☐ |
|
material_stockLocation_extraFields |
string |
|
☐ |
|
material_stockLocation_id |
string |
|
☐ |
|
material_stockLocation_lockedAt |
datetime |
|
☐ |
|
material_stockLocation_name |
string |
|
☐ |
|
material_stockLocation_updatedAt |
datetime |
|
☐ |
|
material_stockLocationId |
string |
|
☐ |
|
material_supplier_archivedAt |
datetime |
|
☐ |
|
material_supplier_createdAt |
datetime |
|
☐ |
|
material_supplier_deletedAt |
datetime |
|
☐ |
|
material_supplier_email |
string |
|
☐ |
|
material_supplier_extraFields |
string |
|
☐ |
|
material_supplier_fax |
string |
|
☐ |
|
material_supplier_generalLedgerAccountId |
string |
|
☐ |
|
material_supplier_gsm |
string |
|
☐ |
|
material_supplier_iban |
string |
|
☐ |
|
material_supplier_id |
string |
|
☐ |
|
material_supplier_invoiceRemarks |
string |
|
☐ |
|
material_supplier_kvk |
string |
|
☐ |
|
material_supplier_language |
string |
|
☐ |
|
material_supplier_legalFormId |
string |
|
☐ |
|
material_supplier_lockedAt |
datetime |
|
☐ |
|
material_supplier_logicId |
string |
|
☐ |
|
material_supplier_name |
string |
|
☐ |
|
material_supplier_paymentConditionId |
string |
|
☐ |
|
material_supplier_planningEmail |
string |
|
☐ |
|
material_supplier_status |
string |
|
☐ |
|
material_supplier_supplyOrderRemarks |
string |
|
☐ |
|
material_supplier_tel |
string |
|
☐ |
|
material_supplier_type |
string |
|
☐ |
|
material_supplier_updatedAt |
datetime |
|
☐ |
|
material_supplier_vatIdNumber |
string |
|
☐ |
|
material_supplier_vatTariffId |
string |
|
☐ |
|
material_supplier_website |
string |
|
☐ |
|
material_supplierId |
string |
|
☐ |
|
material_updatedAt |
datetime |
|
☐ |
|
materialId |
string |
Materiaal ID |
☐ |
|
postId |
string |
Post ID |
☐ |
|
price |
decimal |
Prijs |
☐ |
|
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 |
☐ |
|
purchaseInvoiceId |
string |
Aankoopfactuur ID |
☐ |
Only present when obtained via bulk endpoint |
quantity |
decimal |
Hoeveelheid |
☐ |
|
styleName |
string |
Stijl Naam |
☐ |
|
supplyOrderId |
string |
Leveringsbestel-ID |
☐ |
|
type |
string |
Soort |
☐ |
|
unitType |
string |
Unitsoort |
☐ |
|
updatedAt |
datetime |
Bijgewerkt op |
☐ |
|
vatTariff__metadata_description |
string |
|
☐ |
|
vatTariff__metadata_href |
string |
|
☐ |
|
vatTariff__metadata_resource |
string |
|
☐ |
|
vatTariff__metadata_resourceTypeId |
string |
|
☐ |
|
vatTariff_additionalMention |
string |
|
☐ |
|
vatTariff_archivedAt |
datetime |
|
☐ |
|
vatTariff_category |
string |
|
☐ |
|
vatTariff_createdAt |
datetime |
|
☐ |
|
vatTariff_deletedAt |
datetime |
|
☐ |
|
vatTariff_description |
string |
|
☐ |
|
vatTariff_excludedFromFinancialDiscount |
boolean |
|
☐ |
|
vatTariff_extraFields |
string |
|
☐ |
|
vatTariff_id |
string |
|
☐ |
|
vatTariff_inclusive |
boolean |
|
☐ |
|
vatTariff_lockedAt |
datetime |
|
☐ |
|
vatTariff_name |
string |
|
☐ |
|
vatTariff_percentage |
decimal |
|
☐ |
|
vatTariff_updatedAt |
datetime |
|
☐ |
|
vatTariffId |
string |
BTW-tarief-ID |
☐ |
|
30-09-2023 07:40 Versie 23.0.49-PROD+4237