Navigatie: Schema: Offers > Tables

OfferLines

Catalog: Robaws

Schema: Offers

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

Insert Robaws API URL: /api/v2/offers

Update Robaws API URL: /api/v2/offers

Delete Robaws API URL: /api/v2/offers

Field Selection Method: NotRequired

Base Path: items[*].lineItems[*]

Select Robaws API Operation: get /api/v2/offers

Parameters of Table Function

The following parameters can be used to control the behaviour of the table function OfferLines. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name	Data Type	Required
calculated	boolean	☐
clientId	string	☐
projectId	string	☐
searchText	string	☐
sort	string	☐
updatedFrom	datetime	☐

Table Function Columns

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

Name	Data Type	Label	Required	Documentation
activeOnProject	boolean	Active on Project	☐
address_addressLine1	string		☐
address_addressLine2	string		☐
address_city	string	City	☐
address_country	string	Country	☐
address_latitude	double		☐
address_longitude	double		☐
address_postalCode	string		☐
addressDistance_unit	string		☐
addressDistance_value	int32		☐
agreementType	string	Agreement Type	☐
archivedAt_1	datetime		☐
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		☐
assignedUserId	string		☐
assignee_archivedAt	datetime		☐
assignee_createdAt	datetime		☐
assignee_deletedAt	datetime		☐
assignee_email	string	Assignee Email	☐
assignee_fullName	string	Assignee Full Name	☐
assignee_id	string	Assignee ID	☐
assignee_locked	boolean		☐
assignee_updatedAt	datetime		☐
calculated	boolean		☐
chapter	string	Chapter	☐
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_assignedUserId	string		☐
client_createdAt	datetime		☐
client_deletedAt	datetime		☐
client_email	string	Client Email	☐
client_fax	string	Client Fax	☐
client_generalLedgerAccount_archivedAt	datetime		☐
client_generalLedgerAccount_code	string		☐
client_generalLedgerAccount_createdAt	datetime		☐
client_generalLedgerAccount_deletedAt	datetime		☐
client_generalLedgerAccount_id	string		☐
client_generalLedgerAccount_name	string		☐
client_generalLedgerAccount_updatedAt	datetime		☐
client_generalLedgerAccountId	string		☐
client_gsm	string	Client Mobile	☐
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_id	string		☐
client_legalForm_legalAbbreviation	string		☐
client_legalForm_name	string		☐
client_legalForm_updatedAt	datetime		☐
client_legalForm_vatLiable	boolean		☐
client_legalFormId	string		☐
client_name	string		☐
client_paymentCondition_archivedAt	datetime		☐
client_paymentCondition_createdAt	datetime		☐
client_paymentCondition_deletedAt	datetime		☐
client_paymentCondition_id	string		☐
client_paymentCondition_name	string		☐
client_paymentCondition_purchase	boolean		☐
client_paymentCondition_sales	boolean		☐
client_paymentCondition_updatedAt	datetime		☐
client_paymentConditionId	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_id	string		☐
client_vatTariff_name	string		☐
client_vatTariff_percentage	decimal		☐
client_vatTariff_updatedAt	datetime		☐
client_vatTariffId	string		☐
client_website	string		☐
clientContact_archivedAt	datetime		☐
clientContact_createdAt	datetime		☐
clientContact_deletedAt	datetime		☐
clientContact_email	string		☐
clientContact_gsm	string		☐
clientContact_id	string		☐
clientContact_name	string		☐
clientContact_position	string		☐
clientContact_surname	string		☐
clientContact_tel	string		☐
clientContact_title	string		☐
clientContact_updatedAt	datetime		☐
clientContactId	string		☐
clientId	string		☐
clientReference	string	Customer Reference	☐
commission	decimal		☐
createdAt_1	datetime		☐
createdAt	datetime		☐
date	datetime	Date	☐
deletedAt_1	datetime		☐
deletedAt	datetime		☐
description	string	Description	☐
discount	decimal	Discount	☐
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_assignedUserId	string		☐
endClient_createdAt	datetime		☐
endClient_deletedAt	datetime		☐
endClient_email	string		☐
endClient_fax	string		☐
endClient_generalLedgerAccount_archivedAt	datetime		☐
endClient_generalLedgerAccount_code	string		☐
endClient_generalLedgerAccount_createdAt	datetime		☐
endClient_generalLedgerAccount_deletedAt	datetime		☐
endClient_generalLedgerAccount_id	string		☐
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_id	string		☐
endClient_legalForm_legalAbbreviation	string		☐
endClient_legalForm_name	string		☐
endClient_legalForm_updatedAt	datetime		☐
endClient_legalForm_vatLiable	boolean		☐
endClient_legalFormId	string		☐
endClient_name	string		☐
endClient_paymentCondition_archivedAt	datetime		☐
endClient_paymentCondition_createdAt	datetime		☐
endClient_paymentCondition_deletedAt	datetime		☐
endClient_paymentCondition_id	string		☐
endClient_paymentCondition_name	string		☐
endClient_paymentCondition_purchase	boolean		☐
endClient_paymentCondition_sales	boolean		☐
endClient_paymentCondition_updatedAt	datetime		☐
endClient_paymentConditionId	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_id	string		☐
endClient_vatTariff_name	string		☐
endClient_vatTariff_percentage	decimal		☐
endClient_vatTariff_updatedAt	datetime		☐
endClient_vatTariffId	string		☐
endClient_website	string		☐
endClientContact_archivedAt	datetime		☐
endClientContact_createdAt	datetime		☐
endClientContact_deletedAt	datetime		☐
endClientContact_email	string		☐
endClientContact_gsm	string		☐
endClientContact_id	string		☐
endClientContact_name	string		☐
endClientContact_position	string		☐
endClientContact_surname	string		☐
endClientContact_tel	string		☐
endClientContact_title	string		☐
endClientContact_updatedAt	datetime		☐
endClientContactId	string		☐
endClientId	string		☐
extendedDescription	string		☐
extendedDescriptionRendered	string		☐	When reading, only present if requested via 'include' query parameter, otherwise null.
id_1	string		☐
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		☐
logicId	string	Logical ID	☐
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		☐
number	string		☐
price	decimal	Price	☐
project_archivedAt	datetime		☐
project_checkInAtWork	string		☐
project_client_address_addressLine1	string		☐
project_client_address_addressLine2	string		☐
project_client_address_city	string		☐
project_client_address_country	string		☐
project_client_address_latitude	double		☐
project_client_address_longitude	double		☐
project_client_address_postalCode	string		☐
project_client_archivedAt	datetime		☐
project_client_assignedUserId	string		☐
project_client_createdAt	datetime		☐
project_client_deletedAt	datetime		☐
project_client_email	string		☐
project_client_fax	string		☐
project_client_generalLedgerAccount_archivedAt	datetime		☐
project_client_generalLedgerAccount_code	string		☐
project_client_generalLedgerAccount_createdAt	datetime		☐
project_client_generalLedgerAccount_deletedAt	datetime		☐
project_client_generalLedgerAccount_id	string		☐
project_client_generalLedgerAccount_name	string		☐
project_client_generalLedgerAccount_updatedAt	datetime		☐
project_client_generalLedgerAccountId	string		☐
project_client_gsm	string		☐
project_client_id	string		☐
project_client_invoiceAddress_addressLine1	string		☐
project_client_invoiceAddress_addressLine2	string		☐
project_client_invoiceAddress_city	string		☐
project_client_invoiceAddress_country	string		☐
project_client_invoiceAddress_latitude	double		☐
project_client_invoiceAddress_longitude	double		☐
project_client_invoiceAddress_postalCode	string		☐
project_client_invoiceEmail	string		☐
project_client_language	string		☐
project_client_legalForm_archivedAt	datetime		☐
project_client_legalForm_createdAt	datetime		☐
project_client_legalForm_deletedAt	datetime		☐
project_client_legalForm_id	string		☐
project_client_legalForm_legalAbbreviation	string		☐
project_client_legalForm_name	string		☐
project_client_legalForm_updatedAt	datetime		☐
project_client_legalForm_vatLiable	boolean		☐
project_client_legalFormId	string		☐
project_client_name	string		☐
project_client_paymentCondition_archivedAt	datetime		☐
project_client_paymentCondition_createdAt	datetime		☐
project_client_paymentCondition_deletedAt	datetime		☐
project_client_paymentCondition_id	string		☐
project_client_paymentCondition_name	string		☐
project_client_paymentCondition_purchase	boolean		☐
project_client_paymentCondition_sales	boolean		☐
project_client_paymentCondition_updatedAt	datetime		☐
project_client_paymentConditionId	string		☐
project_client_status	string		☐
project_client_statusDetails_color	string		☐
project_client_statusDetails_name	string		☐
project_client_tel	string		☐
project_client_title	string		☐
project_client_updatedAt	datetime		☐
project_client_vatIdNumber	string		☐
project_client_vatTariff_additionalMention	string		☐
project_client_vatTariff_archivedAt	datetime		☐
project_client_vatTariff_category	string		☐
project_client_vatTariff_createdAt	datetime		☐
project_client_vatTariff_deletedAt	datetime		☐
project_client_vatTariff_description	string		☐
project_client_vatTariff_id	string		☐
project_client_vatTariff_name	string		☐
project_client_vatTariff_percentage	decimal		☐
project_client_vatTariff_updatedAt	datetime		☐
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_gsm	string		☐
project_clientContact_id	string		☐
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_createdAt	datetime		☐
project_date	datetime		☐
project_deletedAt	datetime		☐
project_distance	int32		☐
project_endClient_address_addressLine1	string		☐
project_endClient_address_addressLine2	string		☐
project_endClient_address_city	string		☐
project_endClient_address_country	string		☐
project_endClient_address_latitude	double		☐
project_endClient_address_longitude	double		☐
project_endClient_address_postalCode	string		☐
project_endClient_archivedAt	datetime		☐
project_endClient_assignedUserId	string		☐
project_endClient_createdAt	datetime		☐
project_endClient_deletedAt	datetime		☐
project_endClient_email	string		☐
project_endClient_fax	string		☐
project_endClient_generalLedgerAccount_archivedAt	datetime		☐
project_endClient_generalLedgerAccount_code	string		☐
project_endClient_generalLedgerAccount_createdAt	datetime		☐
project_endClient_generalLedgerAccount_deletedAt	datetime		☐
project_endClient_generalLedgerAccount_id	string		☐
project_endClient_generalLedgerAccount_name	string		☐
project_endClient_generalLedgerAccount_updatedAt	datetime		☐
project_endClient_generalLedgerAccountId	string		☐
project_endClient_gsm	string		☐
project_endClient_id	string		☐
project_endClient_invoiceAddress_addressLine1	string		☐
project_endClient_invoiceAddress_addressLine2	string		☐
project_endClient_invoiceAddress_city	string		☐
project_endClient_invoiceAddress_country	string		☐
project_endClient_invoiceAddress_latitude	double		☐
project_endClient_invoiceAddress_longitude	double		☐
project_endClient_invoiceAddress_postalCode	string		☐
project_endClient_invoiceEmail	string		☐
project_endClient_language	string		☐
project_endClient_legalForm_archivedAt	datetime		☐
project_endClient_legalForm_createdAt	datetime		☐
project_endClient_legalForm_deletedAt	datetime		☐
project_endClient_legalForm_id	string		☐
project_endClient_legalForm_legalAbbreviation	string		☐
project_endClient_legalForm_name	string		☐
project_endClient_legalForm_updatedAt	datetime		☐
project_endClient_legalForm_vatLiable	boolean		☐
project_endClient_legalFormId	string		☐
project_endClient_name	string		☐
project_endClient_paymentCondition_archivedAt	datetime		☐
project_endClient_paymentCondition_createdAt	datetime		☐
project_endClient_paymentCondition_deletedAt	datetime		☐
project_endClient_paymentCondition_id	string		☐
project_endClient_paymentCondition_name	string		☐
project_endClient_paymentCondition_purchase	boolean		☐
project_endClient_paymentCondition_sales	boolean		☐
project_endClient_paymentCondition_updatedAt	datetime		☐
project_endClient_paymentConditionId	string		☐
project_endClient_status	string		☐
project_endClient_statusDetails_color	string		☐
project_endClient_statusDetails_name	string		☐
project_endClient_tel	string		☐
project_endClient_title	string		☐
project_endClient_updatedAt	datetime		☐
project_endClient_vatIdNumber	string		☐
project_endClient_vatTariff_additionalMention	string		☐
project_endClient_vatTariff_archivedAt	datetime		☐
project_endClient_vatTariff_category	string		☐
project_endClient_vatTariff_createdAt	datetime		☐
project_endClient_vatTariff_deletedAt	datetime		☐
project_endClient_vatTariff_description	string		☐
project_endClient_vatTariff_id	string		☐
project_endClient_vatTariff_name	string		☐
project_endClient_vatTariff_percentage	decimal		☐
project_endClient_vatTariff_updatedAt	datetime		☐
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_gsm	string		☐
project_endClientContact_id	string		☐
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_id	string		☐
project_logicId	string		☐
project_nssoDeclarationOfWorks	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_fullName	string		☐
project_siteManager_id	string		☐
project_siteManager_locked	boolean		☐
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	☐
quantity	decimal		☐
quantityFormula	string		☐
status	string	Status	☐
statusDetails_color	string		☐
statusDetails_name	string		☐
styleName	string		☐
title	string	Title	☐
totalExclVat_1	decimal		☐
totalExclVat	decimal		☐
totalInclVat	decimal		☐
type	string	Type	☐
unitType	string	Unit Type	☐
updatedAt_1	datetime		☐
updatedAt	datetime		☐
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

OfferLines

Parameters of Table Function

Table Function Columns

Belangrijke Informatie over Veiligheid en Gebruik