Navigatie: Schema: OfferLineItems > Tables

OfferParameterIdsByOfferId

Find one

Catalog: Robaws

Schema: OfferLineItems

This is a read-only table function. The Robaws API may not support changing the data or the Invantive SQL driver for Robaws does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Robaws API.

Select Robaws API URL: /api/v2/offers/{offerId}/line-items/{id}

Insert Robaws API URL: /api/v2/offers/{offerId}/line-items/{id}

Update Robaws API URL: /api/v2/offers/{offerId}/line-items/{id}

Delete Robaws API URL: /api/v2/offers/{offerId}/line-items/{id}

Field Selection Method: NotRequired

Base Path: parameters[*]

Select Robaws API Operation: get /api/v2/offers/{offerId}/line-items/{id}

Table Function Columns

The columns of the table function OfferParameterIdsByOfferId are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required	Documentation
agreementType	string	Agreement Type	☐
archivedAt	datetime		☐
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 stockis available for sale.When reading, only present if requested via 'include' query parameter, otherwise null.
article_barcode	string	Article Bar Code	☐
article_brand	string		☐
article_costPrice	decimal		☐
article_costPriceStrategy	string		☐
article_createdAt	datetime		☐
article_deletedAt	datetime		☐
article_description	string		☐
article_group_archivedAt	datetime		☐
article_group_createdAt	datetime		☐
article_group_deletedAt	datetime		☐
article_group_id	string		☐
article_group_image_archivedAt	datetime		☐
article_group_image_contentType	string		☐
article_group_image_createdAt	datetime		☐
article_group_image_deletedAt	datetime		☐
article_group_image_directory	boolean		☐
article_group_image_id	string		☐
article_group_image_name	string		☐
article_group_image_parentId	string		☐
article_group_image_previewUrl	string		☐
article_group_image_size	int64		☐
article_group_image_updatedAt	datetime		☐
article_group_image_url	string		☐
article_group_name	string		☐
article_group_parentId	string		☐
article_group_updatedAt	datetime		☐
article_id	string	Article 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_name	string		☐
article_image_parentId	string		☐
article_image_previewUrl	string		☐
article_image_size	int64		☐
article_image_updatedAt	datetime		☐
article_image_url	string		☐
article_name	string		☐
article_saleName	string		☐
article_salePrice	decimal		☐
article_salePriceStrategy	string		☐
article_stockArticle	boolean		☐
article_stockPlace	string		☐
article_timeOperation	boolean		☐
article_totalStock	decimal		☐	When reading, only present if requested via 'include' query parameter, otherwise null.
article_unitType	string		☐
article_updatedAt	datetime		☐
article_vatTariffId	string		☐
articleId	string		☐
chapter	string	Chapter	☐
createdAt	datetime		☐
deletedAt	datetime		☐
description_1	string		☐
description	string	Description	☐
discount	decimal	Discount	☐
extendedDescription	string		☐
extendedDescriptionRendered	string		☐	When reading, only present if requested via 'include' query parameter, otherwise null.
formula	string	Formula	☐
id	string	ID	☐
image_archivedAt	datetime		☐
image_contentType	string		☐
image_createdAt	datetime		☐
image_deletedAt	datetime		☐
image_directory	boolean		☐
image_id	string		☐
image_name	string		☐
image_parentId	string		☐
image_previewUrl	string		☐
image_size	int64		☐
image_updatedAt	datetime		☐
image_url	string		☐
material_archivedAt	datetime		☐
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 stockis available for sale.When reading, only present if requested via 'include' query parameter, otherwise null.
material_article_barcode	string		☐
material_article_brand	string		☐
material_article_costPrice	decimal		☐
material_article_costPriceStrategy	string		☐
material_article_createdAt	datetime		☐
material_article_deletedAt	datetime		☐
material_article_description	string		☐
material_article_group_archivedAt	datetime		☐
material_article_group_createdAt	datetime		☐
material_article_group_deletedAt	datetime		☐
material_article_group_id	string		☐
material_article_group_image_archivedAt	datetime		☐
material_article_group_image_contentType	string		☐
material_article_group_image_createdAt	datetime		☐
material_article_group_image_deletedAt	datetime		☐
material_article_group_image_directory	boolean		☐
material_article_group_image_id	string		☐
material_article_group_image_name	string		☐
material_article_group_image_parentId	string		☐
material_article_group_image_previewUrl	string		☐
material_article_group_image_size	int64		☐
material_article_group_image_updatedAt	datetime		☐
material_article_group_image_url	string		☐
material_article_group_name	string		☐
material_article_group_parentId	string		☐
material_article_group_updatedAt	datetime		☐
material_article_id	string		☐
material_article_image_archivedAt	datetime		☐
material_article_image_contentType	string		☐
material_article_image_createdAt	datetime		☐
material_article_image_deletedAt	datetime		☐
material_article_image_directory	boolean		☐
material_article_image_id	string		☐
material_article_image_name	string		☐
material_article_image_parentId	string		☐
material_article_image_previewUrl	string		☐
material_article_image_size	int64		☐
material_article_image_updatedAt	datetime		☐
material_article_image_url	string		☐
material_article_name	string		☐
material_article_saleName	string		☐
material_article_salePrice	decimal		☐
material_article_salePriceStrategy	string		☐
material_article_stockArticle	boolean		☐
material_article_stockPlace	string		☐
material_article_timeOperation	boolean		☐
material_article_totalStock	decimal		☐	When reading, only present if requested via 'include' query parameter, otherwise null.
material_article_unitType	string		☐
material_article_updatedAt	datetime		☐
material_article_vatTariffId	string		☐
material_articleId	string		☐
material_assignedClient_address_addressLine1	string		☐
material_assignedClient_address_addressLine2	string		☐
material_assignedClient_address_city	string		☐
material_assignedClient_address_country	string		☐
material_assignedClient_address_latitude	double		☐
material_assignedClient_address_longitude	double		☐
material_assignedClient_address_postalCode	string		☐
material_assignedClient_archivedAt	datetime		☐
material_assignedClient_assignedUserId	string		☐
material_assignedClient_createdAt	datetime		☐
material_assignedClient_deletedAt	datetime		☐
material_assignedClient_email	string		☐
material_assignedClient_fax	string		☐
material_assignedClient_generalLedgerAccount_archivedAt	datetime		☐
material_assignedClient_generalLedgerAccount_code	string		☐
material_assignedClient_generalLedgerAccount_createdAt	datetime		☐
material_assignedClient_generalLedgerAccount_deletedAt	datetime		☐
material_assignedClient_generalLedgerAccount_id	string		☐
material_assignedClient_generalLedgerAccount_name	string		☐
material_assignedClient_generalLedgerAccount_updatedAt	datetime		☐
material_assignedClient_generalLedgerAccountId	string		☐
material_assignedClient_gsm	string		☐
material_assignedClient_id	string		☐
material_assignedClient_invoiceAddress_addressLine1	string		☐
material_assignedClient_invoiceAddress_addressLine2	string		☐
material_assignedClient_invoiceAddress_city	string		☐
material_assignedClient_invoiceAddress_country	string		☐
material_assignedClient_invoiceAddress_latitude	double		☐
material_assignedClient_invoiceAddress_longitude	double		☐
material_assignedClient_invoiceAddress_postalCode	string		☐
material_assignedClient_invoiceEmail	string		☐
material_assignedClient_language	string		☐
material_assignedClient_legalForm_archivedAt	datetime		☐
material_assignedClient_legalForm_createdAt	datetime		☐
material_assignedClient_legalForm_deletedAt	datetime		☐
material_assignedClient_legalForm_id	string		☐
material_assignedClient_legalForm_legalAbbreviation	string		☐
material_assignedClient_legalForm_name	string		☐
material_assignedClient_legalForm_updatedAt	datetime		☐
material_assignedClient_legalForm_vatLiable	boolean		☐
material_assignedClient_legalFormId	string		☐
material_assignedClient_name	string		☐
material_assignedClient_paymentCondition_archivedAt	datetime		☐
material_assignedClient_paymentCondition_createdAt	datetime		☐
material_assignedClient_paymentCondition_deletedAt	datetime		☐
material_assignedClient_paymentCondition_id	string		☐
material_assignedClient_paymentCondition_name	string		☐
material_assignedClient_paymentCondition_purchase	boolean		☐
material_assignedClient_paymentCondition_sales	boolean		☐
material_assignedClient_paymentCondition_updatedAt	datetime		☐
material_assignedClient_paymentConditionId	string		☐
material_assignedClient_status	string		☐
material_assignedClient_statusDetails_color	string		☐
material_assignedClient_statusDetails_name	string		☐
material_assignedClient_tel	string		☐
material_assignedClient_title	string		☐
material_assignedClient_updatedAt	datetime		☐
material_assignedClient_vatIdNumber	string		☐
material_assignedClient_vatTariff_additionalMention	string		☐
material_assignedClient_vatTariff_archivedAt	datetime		☐
material_assignedClient_vatTariff_category	string		☐
material_assignedClient_vatTariff_createdAt	datetime		☐
material_assignedClient_vatTariff_deletedAt	datetime		☐
material_assignedClient_vatTariff_description	string		☐
material_assignedClient_vatTariff_id	string		☐
material_assignedClient_vatTariff_name	string		☐
material_assignedClient_vatTariff_percentage	decimal		☐
material_assignedClient_vatTariff_updatedAt	datetime		☐
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_deletedAt	datetime		☐
material_assignedEmployee_dimonaExpirationDate	datetime		☐
material_assignedEmployee_dimonaNumber	string		☐
material_assignedEmployee_distance	decimal		☐
material_assignedEmployee_domicileAddress_addressLine1	string		☐
material_assignedEmployee_domicileAddress_addressLine2	string		☐
material_assignedEmployee_domicileAddress_city	string		☐
material_assignedEmployee_domicileAddress_country	string		☐
material_assignedEmployee_domicileAddress_latitude	double		☐
material_assignedEmployee_domicileAddress_longitude	double		☐
material_assignedEmployee_domicileAddress_postalCode	string		☐
material_assignedEmployee_driverLicense	string		☐
material_assignedEmployee_email	string		☐
material_assignedEmployee_emergencyTel	string		☐
material_assignedEmployee_employeeRole_archivedAt	datetime		☐
material_assignedEmployee_employeeRole_createdAt	datetime		☐
material_assignedEmployee_employeeRole_deletedAt	datetime		☐
material_assignedEmployee_employeeRole_id	string		☐
material_assignedEmployee_employeeRole_name	string		☐
material_assignedEmployee_employeeRole_updatedAt	datetime		☐
material_assignedEmployee_employeeRoleId	string		☐
material_assignedEmployee_employer_archivedAt	datetime		☐
material_assignedEmployee_employer_createdAt	datetime		☐
material_assignedEmployee_employer_deletedAt	datetime		☐
material_assignedEmployee_employer_email	string		☐
material_assignedEmployee_employer_fax	string		☐
material_assignedEmployee_employer_generalLedgerAccount_archivedAt	datetime		☐
material_assignedEmployee_employer_generalLedgerAccount_code	string		☐
material_assignedEmployee_employer_generalLedgerAccount_createdAt	datetime		☐
material_assignedEmployee_employer_generalLedgerAccount_deletedAt	datetime		☐
material_assignedEmployee_employer_generalLedgerAccount_id	string		☐
material_assignedEmployee_employer_generalLedgerAccount_name	string		☐
material_assignedEmployee_employer_generalLedgerAccount_updatedAt	datetime		☐
material_assignedEmployee_employer_generalLedgerAccountId	string		☐
material_assignedEmployee_employer_gsm	string		☐
material_assignedEmployee_employer_iban	string		☐
material_assignedEmployee_employer_id	string		☐
material_assignedEmployee_employer_invoiceAddress_addressLine1	string		☐
material_assignedEmployee_employer_invoiceAddress_addressLine2	string		☐
material_assignedEmployee_employer_invoiceAddress_city	string		☐
material_assignedEmployee_employer_invoiceAddress_country	string		☐
material_assignedEmployee_employer_invoiceAddress_latitude	double		☐
material_assignedEmployee_employer_invoiceAddress_longitude	double		☐
material_assignedEmployee_employer_invoiceAddress_postalCode	string		☐
material_assignedEmployee_employer_invoiceRemarks	string		☐
material_assignedEmployee_employer_kvk	string		☐
material_assignedEmployee_employer_language	string		☐
material_assignedEmployee_employer_legalForm_archivedAt	datetime		☐
material_assignedEmployee_employer_legalForm_createdAt	datetime		☐
material_assignedEmployee_employer_legalForm_deletedAt	datetime		☐
material_assignedEmployee_employer_legalForm_id	string		☐
material_assignedEmployee_employer_legalForm_legalAbbreviation	string		☐
material_assignedEmployee_employer_legalForm_name	string		☐
material_assignedEmployee_employer_legalForm_updatedAt	datetime		☐
material_assignedEmployee_employer_legalForm_vatLiable	boolean		☐
material_assignedEmployee_employer_legalFormId	string		☐
material_assignedEmployee_employer_logicId	string		☐
material_assignedEmployee_employer_name	string		☐
material_assignedEmployee_employer_paymentConditionId	string		☐
material_assignedEmployee_employer_planningEmail	string		☐
material_assignedEmployee_employer_status	string		☐
material_assignedEmployee_employer_supplyOrderRemarks	string		☐
material_assignedEmployee_employer_tel	string		☐
material_assignedEmployee_employer_updatedAt	datetime		☐
material_assignedEmployee_employer_vatIdNumber	string		☐
material_assignedEmployee_employer_vatTariff_additionalMention	string		☐
material_assignedEmployee_employer_vatTariff_archivedAt	datetime		☐
material_assignedEmployee_employer_vatTariff_category	string		☐
material_assignedEmployee_employer_vatTariff_createdAt	datetime		☐
material_assignedEmployee_employer_vatTariff_deletedAt	datetime		☐
material_assignedEmployee_employer_vatTariff_description	string		☐
material_assignedEmployee_employer_vatTariff_id	string		☐
material_assignedEmployee_employer_vatTariff_name	string		☐
material_assignedEmployee_employer_vatTariff_percentage	decimal		☐
material_assignedEmployee_employer_vatTariff_updatedAt	datetime		☐
material_assignedEmployee_employer_vatTariffId	string		☐
material_assignedEmployee_employer_website	string		☐
material_assignedEmployee_employerId	string		☐
material_assignedEmployee_grossSalary	decimal		☐
material_assignedEmployee_gsm	string		☐
material_assignedEmployee_id	string		☐
material_assignedEmployee_identityCardExpirationDate	datetime		☐
material_assignedEmployee_identityCardNumber	string		☐
material_assignedEmployee_image_archivedAt	datetime		☐
material_assignedEmployee_image_contentType	string		☐
material_assignedEmployee_image_createdAt	datetime		☐
material_assignedEmployee_image_deletedAt	datetime		☐
material_assignedEmployee_image_directory	boolean		☐
material_assignedEmployee_image_id	string		☐
material_assignedEmployee_image_name	string		☐
material_assignedEmployee_image_parentId	string		☐
material_assignedEmployee_image_previewUrl	string		☐
material_assignedEmployee_image_size	int64		☐
material_assignedEmployee_image_updatedAt	datetime		☐
material_assignedEmployee_image_url	string		☐
material_assignedEmployee_independentRegistration	boolean		☐
material_assignedEmployee_limosaExpirationDate	datetime		☐
material_assignedEmployee_limosaNumber	string		☐
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_client_address_addressLine1	string		☐
material_assignedProject_client_address_addressLine2	string		☐
material_assignedProject_client_address_city	string		☐
material_assignedProject_client_address_country	string		☐
material_assignedProject_client_address_latitude	double		☐
material_assignedProject_client_address_longitude	double		☐
material_assignedProject_client_address_postalCode	string		☐
material_assignedProject_client_archivedAt	datetime		☐
material_assignedProject_client_assignedUserId	string		☐
material_assignedProject_client_createdAt	datetime		☐
material_assignedProject_client_deletedAt	datetime		☐
material_assignedProject_client_email	string		☐
material_assignedProject_client_fax	string		☐
material_assignedProject_client_generalLedgerAccount_archivedAt	datetime		☐
material_assignedProject_client_generalLedgerAccount_code	string		☐
material_assignedProject_client_generalLedgerAccount_createdAt	datetime		☐
material_assignedProject_client_generalLedgerAccount_deletedAt	datetime		☐
material_assignedProject_client_generalLedgerAccount_id	string		☐
material_assignedProject_client_generalLedgerAccount_name	string		☐
material_assignedProject_client_generalLedgerAccount_updatedAt	datetime		☐
material_assignedProject_client_generalLedgerAccountId	string		☐
material_assignedProject_client_gsm	string		☐
material_assignedProject_client_id	string		☐
material_assignedProject_client_invoiceAddress_addressLine1	string		☐
material_assignedProject_client_invoiceAddress_addressLine2	string		☐
material_assignedProject_client_invoiceAddress_city	string		☐
material_assignedProject_client_invoiceAddress_country	string		☐
material_assignedProject_client_invoiceAddress_latitude	double		☐
material_assignedProject_client_invoiceAddress_longitude	double		☐
material_assignedProject_client_invoiceAddress_postalCode	string		☐
material_assignedProject_client_invoiceEmail	string		☐
material_assignedProject_client_language	string		☐
material_assignedProject_client_legalForm_archivedAt	datetime		☐
material_assignedProject_client_legalForm_createdAt	datetime		☐
material_assignedProject_client_legalForm_deletedAt	datetime		☐
material_assignedProject_client_legalForm_id	string		☐
material_assignedProject_client_legalForm_legalAbbreviation	string		☐
material_assignedProject_client_legalForm_name	string		☐
material_assignedProject_client_legalForm_updatedAt	datetime		☐
material_assignedProject_client_legalForm_vatLiable	boolean		☐
material_assignedProject_client_legalFormId	string		☐
material_assignedProject_client_name	string		☐
material_assignedProject_client_paymentCondition_archivedAt	datetime		☐
material_assignedProject_client_paymentCondition_createdAt	datetime		☐
material_assignedProject_client_paymentCondition_deletedAt	datetime		☐
material_assignedProject_client_paymentCondition_id	string		☐
material_assignedProject_client_paymentCondition_name	string		☐
material_assignedProject_client_paymentCondition_purchase	boolean		☐
material_assignedProject_client_paymentCondition_sales	boolean		☐
material_assignedProject_client_paymentCondition_updatedAt	datetime		☐
material_assignedProject_client_paymentConditionId	string		☐
material_assignedProject_client_status	string		☐
material_assignedProject_client_statusDetails_color	string		☐
material_assignedProject_client_statusDetails_name	string		☐
material_assignedProject_client_tel	string		☐
material_assignedProject_client_title	string		☐
material_assignedProject_client_updatedAt	datetime		☐
material_assignedProject_client_vatIdNumber	string		☐
material_assignedProject_client_vatTariff_additionalMention	string		☐
material_assignedProject_client_vatTariff_archivedAt	datetime		☐
material_assignedProject_client_vatTariff_category	string		☐
material_assignedProject_client_vatTariff_createdAt	datetime		☐
material_assignedProject_client_vatTariff_deletedAt	datetime		☐
material_assignedProject_client_vatTariff_description	string		☐
material_assignedProject_client_vatTariff_id	string		☐
material_assignedProject_client_vatTariff_name	string		☐
material_assignedProject_client_vatTariff_percentage	decimal		☐
material_assignedProject_client_vatTariff_updatedAt	datetime		☐
material_assignedProject_client_vatTariffId	string		☐
material_assignedProject_client_website	string		☐
material_assignedProject_clientContact_archivedAt	datetime		☐
material_assignedProject_clientContact_createdAt	datetime		☐
material_assignedProject_clientContact_deletedAt	datetime		☐
material_assignedProject_clientContact_email	string		☐
material_assignedProject_clientContact_gsm	string		☐
material_assignedProject_clientContact_id	string		☐
material_assignedProject_clientContact_name	string		☐
material_assignedProject_clientContact_position	string		☐
material_assignedProject_clientContact_surname	string		☐
material_assignedProject_clientContact_tel	string		☐
material_assignedProject_clientContact_title	string		☐
material_assignedProject_clientContact_updatedAt	datetime		☐
material_assignedProject_clientContactId	string		☐
material_assignedProject_clientId	string		☐
material_assignedProject_clientReference	string		☐
material_assignedProject_createdAt	datetime		☐
material_assignedProject_date	datetime		☐
material_assignedProject_deletedAt	datetime		☐
material_assignedProject_distance	int32		☐
material_assignedProject_endClient_address_addressLine1	string		☐
material_assignedProject_endClient_address_addressLine2	string		☐
material_assignedProject_endClient_address_city	string		☐
material_assignedProject_endClient_address_country	string		☐
material_assignedProject_endClient_address_latitude	double		☐
material_assignedProject_endClient_address_longitude	double		☐
material_assignedProject_endClient_address_postalCode	string		☐
material_assignedProject_endClient_archivedAt	datetime		☐
material_assignedProject_endClient_assignedUserId	string		☐
material_assignedProject_endClient_createdAt	datetime		☐
material_assignedProject_endClient_deletedAt	datetime		☐
material_assignedProject_endClient_email	string		☐
material_assignedProject_endClient_fax	string		☐
material_assignedProject_endClient_generalLedgerAccount_archivedAt	datetime		☐
material_assignedProject_endClient_generalLedgerAccount_code	string		☐
material_assignedProject_endClient_generalLedgerAccount_createdAt	datetime		☐
material_assignedProject_endClient_generalLedgerAccount_deletedAt	datetime		☐
material_assignedProject_endClient_generalLedgerAccount_id	string		☐
material_assignedProject_endClient_generalLedgerAccount_name	string		☐
material_assignedProject_endClient_generalLedgerAccount_updatedAt	datetime		☐
material_assignedProject_endClient_generalLedgerAccountId	string		☐
material_assignedProject_endClient_gsm	string		☐
material_assignedProject_endClient_id	string		☐
material_assignedProject_endClient_invoiceAddress_addressLine1	string		☐
material_assignedProject_endClient_invoiceAddress_addressLine2	string		☐
material_assignedProject_endClient_invoiceAddress_city	string		☐
material_assignedProject_endClient_invoiceAddress_country	string		☐
material_assignedProject_endClient_invoiceAddress_latitude	double		☐
material_assignedProject_endClient_invoiceAddress_longitude	double		☐
material_assignedProject_endClient_invoiceAddress_postalCode	string		☐
material_assignedProject_endClient_invoiceEmail	string		☐
material_assignedProject_endClient_language	string		☐
material_assignedProject_endClient_legalForm_archivedAt	datetime		☐
material_assignedProject_endClient_legalForm_createdAt	datetime		☐
material_assignedProject_endClient_legalForm_deletedAt	datetime		☐
material_assignedProject_endClient_legalForm_id	string		☐
material_assignedProject_endClient_legalForm_legalAbbreviation	string		☐
material_assignedProject_endClient_legalForm_name	string		☐
material_assignedProject_endClient_legalForm_updatedAt	datetime		☐
material_assignedProject_endClient_legalForm_vatLiable	boolean		☐
material_assignedProject_endClient_legalFormId	string		☐
material_assignedProject_endClient_name	string		☐
material_assignedProject_endClient_paymentCondition_archivedAt	datetime		☐
material_assignedProject_endClient_paymentCondition_createdAt	datetime		☐
material_assignedProject_endClient_paymentCondition_deletedAt	datetime		☐
material_assignedProject_endClient_paymentCondition_id	string		☐
material_assignedProject_endClient_paymentCondition_name	string		☐
material_assignedProject_endClient_paymentCondition_purchase	boolean		☐
material_assignedProject_endClient_paymentCondition_sales	boolean		☐
material_assignedProject_endClient_paymentCondition_updatedAt	datetime		☐
material_assignedProject_endClient_paymentConditionId	string		☐
material_assignedProject_endClient_status	string		☐
material_assignedProject_endClient_statusDetails_color	string		☐
material_assignedProject_endClient_statusDetails_name	string		☐
material_assignedProject_endClient_tel	string		☐
material_assignedProject_endClient_title	string		☐
material_assignedProject_endClient_updatedAt	datetime		☐
material_assignedProject_endClient_vatIdNumber	string		☐
material_assignedProject_endClient_vatTariff_additionalMention	string		☐
material_assignedProject_endClient_vatTariff_archivedAt	datetime		☐
material_assignedProject_endClient_vatTariff_category	string		☐
material_assignedProject_endClient_vatTariff_createdAt	datetime		☐
material_assignedProject_endClient_vatTariff_deletedAt	datetime		☐
material_assignedProject_endClient_vatTariff_description	string		☐
material_assignedProject_endClient_vatTariff_id	string		☐
material_assignedProject_endClient_vatTariff_name	string		☐
material_assignedProject_endClient_vatTariff_percentage	decimal		☐
material_assignedProject_endClient_vatTariff_updatedAt	datetime		☐
material_assignedProject_endClient_vatTariffId	string		☐
material_assignedProject_endClient_website	string		☐
material_assignedProject_endClientContact_archivedAt	datetime		☐
material_assignedProject_endClientContact_createdAt	datetime		☐
material_assignedProject_endClientContact_deletedAt	datetime		☐
material_assignedProject_endClientContact_email	string		☐
material_assignedProject_endClientContact_gsm	string		☐
material_assignedProject_endClientContact_id	string		☐
material_assignedProject_endClientContact_name	string		☐
material_assignedProject_endClientContact_position	string		☐
material_assignedProject_endClientContact_surname	string		☐
material_assignedProject_endClientContact_tel	string		☐
material_assignedProject_endClientContact_title	string		☐
material_assignedProject_endClientContact_updatedAt	datetime		☐
material_assignedProject_endClientContactId	string		☐
material_assignedProject_endClientId	string		☐
material_assignedProject_id	string		☐
material_assignedProject_logicId	string		☐
material_assignedProject_nssoDeclarationOfWorks	string		☐
material_assignedProject_planningName	string		☐
material_assignedProject_siteAddress_addressLine1	string		☐
material_assignedProject_siteAddress_addressLine2	string		☐
material_assignedProject_siteAddress_city	string		☐
material_assignedProject_siteAddress_country	string		☐
material_assignedProject_siteAddress_latitude	double		☐
material_assignedProject_siteAddress_longitude	double		☐
material_assignedProject_siteAddress_postalCode	string		☐
material_assignedProject_siteManager_archivedAt	datetime		☐
material_assignedProject_siteManager_createdAt	datetime		☐
material_assignedProject_siteManager_deletedAt	datetime		☐
material_assignedProject_siteManager_email	string		☐
material_assignedProject_siteManager_fullName	string		☐
material_assignedProject_siteManager_id	string		☐
material_assignedProject_siteManager_locked	boolean		☐
material_assignedProject_siteManager_updatedAt	datetime		☐
material_assignedProject_siteManagerId	string		☐
material_assignedProject_siteNssoIdNumber	string		☐
material_assignedProject_status	string		☐
material_assignedProject_statusDetails_color	string		☐
material_assignedProject_statusDetails_name	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_fax	string		☐
material_assignedSubcontractor_generalLedgerAccount_archivedAt	datetime		☐
material_assignedSubcontractor_generalLedgerAccount_code	string		☐
material_assignedSubcontractor_generalLedgerAccount_createdAt	datetime		☐
material_assignedSubcontractor_generalLedgerAccount_deletedAt	datetime		☐
material_assignedSubcontractor_generalLedgerAccount_id	string		☐
material_assignedSubcontractor_generalLedgerAccount_name	string		☐
material_assignedSubcontractor_generalLedgerAccount_updatedAt	datetime		☐
material_assignedSubcontractor_generalLedgerAccountId	string		☐
material_assignedSubcontractor_gsm	string		☐
material_assignedSubcontractor_iban	string		☐
material_assignedSubcontractor_id	string		☐
material_assignedSubcontractor_invoiceAddress_addressLine1	string		☐
material_assignedSubcontractor_invoiceAddress_addressLine2	string		☐
material_assignedSubcontractor_invoiceAddress_city	string		☐
material_assignedSubcontractor_invoiceAddress_country	string		☐
material_assignedSubcontractor_invoiceAddress_latitude	double		☐
material_assignedSubcontractor_invoiceAddress_longitude	double		☐
material_assignedSubcontractor_invoiceAddress_postalCode	string		☐
material_assignedSubcontractor_invoiceRemarks	string		☐
material_assignedSubcontractor_kvk	string		☐
material_assignedSubcontractor_language	string		☐
material_assignedSubcontractor_legalForm_archivedAt	datetime		☐
material_assignedSubcontractor_legalForm_createdAt	datetime		☐
material_assignedSubcontractor_legalForm_deletedAt	datetime		☐
material_assignedSubcontractor_legalForm_id	string		☐
material_assignedSubcontractor_legalForm_legalAbbreviation	string		☐
material_assignedSubcontractor_legalForm_name	string		☐
material_assignedSubcontractor_legalForm_updatedAt	datetime		☐
material_assignedSubcontractor_legalForm_vatLiable	boolean		☐
material_assignedSubcontractor_legalFormId	string		☐
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_updatedAt	datetime		☐
material_assignedSubcontractor_vatIdNumber	string		☐
material_assignedSubcontractor_vatTariff_additionalMention	string		☐
material_assignedSubcontractor_vatTariff_archivedAt	datetime		☐
material_assignedSubcontractor_vatTariff_category	string		☐
material_assignedSubcontractor_vatTariff_createdAt	datetime		☐
material_assignedSubcontractor_vatTariff_deletedAt	datetime		☐
material_assignedSubcontractor_vatTariff_description	string		☐
material_assignedSubcontractor_vatTariff_id	string		☐
material_assignedSubcontractor_vatTariff_name	string		☐
material_assignedSubcontractor_vatTariff_percentage	decimal		☐
material_assignedSubcontractor_vatTariff_updatedAt	datetime		☐
material_assignedSubcontractor_vatTariffId	string		☐
material_assignedSubcontractor_website	string		☐
material_assignedSubcontractorId	string		☐
material_brand	string		☐
material_createdAt	datetime		☐
material_deletedAt	datetime		☐
material_id	string		☐
material_installation	boolean		☐
material_name	string		☐
material_serialNumber	string		☐
material_status	string		☐
material_supplier_archivedAt	datetime		☐
material_supplier_createdAt	datetime		☐
material_supplier_deletedAt	datetime		☐
material_supplier_email	string		☐
material_supplier_fax	string		☐
material_supplier_generalLedgerAccount_archivedAt	datetime		☐
material_supplier_generalLedgerAccount_code	string		☐
material_supplier_generalLedgerAccount_createdAt	datetime		☐
material_supplier_generalLedgerAccount_deletedAt	datetime		☐
material_supplier_generalLedgerAccount_id	string		☐
material_supplier_generalLedgerAccount_name	string		☐
material_supplier_generalLedgerAccount_updatedAt	datetime		☐
material_supplier_generalLedgerAccountId	string		☐
material_supplier_gsm	string		☐
material_supplier_iban	string		☐
material_supplier_id	string		☐
material_supplier_invoiceAddress_addressLine1	string		☐
material_supplier_invoiceAddress_addressLine2	string		☐
material_supplier_invoiceAddress_city	string		☐
material_supplier_invoiceAddress_country	string		☐
material_supplier_invoiceAddress_latitude	double		☐
material_supplier_invoiceAddress_longitude	double		☐
material_supplier_invoiceAddress_postalCode	string		☐
material_supplier_invoiceRemarks	string		☐
material_supplier_kvk	string		☐
material_supplier_language	string		☐
material_supplier_legalForm_archivedAt	datetime		☐
material_supplier_legalForm_createdAt	datetime		☐
material_supplier_legalForm_deletedAt	datetime		☐
material_supplier_legalForm_id	string		☐
material_supplier_legalForm_legalAbbreviation	string		☐
material_supplier_legalForm_name	string		☐
material_supplier_legalForm_updatedAt	datetime		☐
material_supplier_legalForm_vatLiable	boolean		☐
material_supplier_legalFormId	string		☐
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_updatedAt	datetime		☐
material_supplier_vatIdNumber	string		☐
material_supplier_vatTariff_additionalMention	string		☐
material_supplier_vatTariff_archivedAt	datetime		☐
material_supplier_vatTariff_category	string		☐
material_supplier_vatTariff_createdAt	datetime		☐
material_supplier_vatTariff_deletedAt	datetime		☐
material_supplier_vatTariff_description	string		☐
material_supplier_vatTariff_id	string		☐
material_supplier_vatTariff_name	string		☐
material_supplier_vatTariff_percentage	decimal		☐
material_supplier_vatTariff_updatedAt	datetime		☐
material_supplier_vatTariffId	string		☐
material_supplier_website	string		☐
material_supplierId	string		☐
material_updatedAt	datetime		☐
materialId	string		☐
name	string	Name	☐
number	string		☐
price	decimal	Price	☐
quantity	decimal		☐
quantityFormula	string		☐
styleName	string		☐
textValue	string	Text Value	☐
totalExclVat	decimal		☐
type	string	Type	☐
unitType	string	Unit Type	☐
updatedAt	datetime		☐
value	decimal	Value	☐
vatTariff_additionalMention	string		☐
vatTariff_archivedAt	datetime		☐
vatTariff_category	string		☐
vatTariff_createdAt	datetime		☐
vatTariff_deletedAt	datetime		☐
vatTariff_description	string		☐
vatTariff_id	string		☐
vatTariff_name	string		☐
vatTariff_percentage	decimal		☐
vatTariff_updatedAt	datetime		☐
vatTariffId	string		☐

17-06-2022 11:59 Version 22.1.46-BETA+3385

Schakel JavaScript in om deze site te bekijken.

Robaws API Data Model

OfferParameterIdsByOfferId

Table Function Columns

Belangrijke Informatie over Veiligheid en Gebruik