Materials: Robaws Materials |
Search
Catalog: Robaws
Schema: Materials
Label: Materials
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/materials
Insert Robaws API URL: /api/v2/materials
Update Robaws API URL: /api/v2/materials
Delete Robaws API URL: /api/v2/materials
Field Selection Method: NotRequired
Base Path: items[*]
Select Robaws API Operation: get /api/v2/materials
Parameters of Table Function
The following parameters can be used to control the behaviour of the table function Materials. 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 |
Default Value |
Documentation |
---|---|---|---|---|
installation |
boolean |
☐ |
|
|
searchText |
string |
☐ |
|
|
serialNumber |
string |
☐ |
|
|
sort |
string |
☐ |
|
|
updatedFrom |
datetime |
☐ |
|
|
Table Function Columns
The columns of the table function Materials are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
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 |
|
☐ |
|
assignedClient_address_addressLine1 |
string |
|
☐ |
|
assignedClient_address_addressLine2 |
string |
|
☐ |
|
assignedClient_address_city |
string |
|
☐ |
|
assignedClient_address_country |
string |
|
☐ |
|
assignedClient_address_latitude |
double |
|
☐ |
|
assignedClient_address_longitude |
double |
|
☐ |
|
assignedClient_address_postalCode |
string |
|
☐ |
|
assignedClient_archivedAt |
datetime |
|
☐ |
|
assignedClient_assignedUserId |
string |
|
☐ |
|
assignedClient_createdAt |
datetime |
|
☐ |
|
assignedClient_deletedAt |
datetime |
|
☐ |
|
assignedClient_email |
string |
|
☐ |
|
assignedClient_fax |
string |
|
☐ |
|
assignedClient_generalLedgerAccount_archivedAt |
datetime |
|
☐ |
|
assignedClient_generalLedgerAccount_code |
string |
|
☐ |
|
assignedClient_generalLedgerAccount_createdAt |
datetime |
|
☐ |
|
assignedClient_generalLedgerAccount_deletedAt |
datetime |
|
☐ |
|
assignedClient_generalLedgerAccount_id |
string |
|
☐ |
|
assignedClient_generalLedgerAccount_name |
string |
|
☐ |
|
assignedClient_generalLedgerAccount_updatedAt |
datetime |
|
☐ |
|
assignedClient_generalLedgerAccountId |
string |
|
☐ |
|
assignedClient_gsm |
string |
|
☐ |
|
assignedClient_id |
string |
|
☐ |
|
assignedClient_invoiceAddress_addressLine1 |
string |
|
☐ |
|
assignedClient_invoiceAddress_addressLine2 |
string |
|
☐ |
|
assignedClient_invoiceAddress_city |
string |
|
☐ |
|
assignedClient_invoiceAddress_country |
string |
|
☐ |
|
assignedClient_invoiceAddress_latitude |
double |
|
☐ |
|
assignedClient_invoiceAddress_longitude |
double |
|
☐ |
|
assignedClient_invoiceAddress_postalCode |
string |
|
☐ |
|
assignedClient_invoiceEmail |
string |
|
☐ |
|
assignedClient_language |
string |
|
☐ |
|
assignedClient_legalForm_archivedAt |
datetime |
|
☐ |
|
assignedClient_legalForm_createdAt |
datetime |
|
☐ |
|
assignedClient_legalForm_deletedAt |
datetime |
|
☐ |
|
assignedClient_legalForm_id |
string |
|
☐ |
|
assignedClient_legalForm_legalAbbreviation |
string |
|
☐ |
|
assignedClient_legalForm_name |
string |
|
☐ |
|
assignedClient_legalForm_updatedAt |
datetime |
|
☐ |
|
assignedClient_legalForm_vatLiable |
boolean |
|
☐ |
|
assignedClient_legalFormId |
string |
|
☐ |
|
assignedClient_name |
string |
|
☐ |
|
assignedClient_paymentCondition_archivedAt |
datetime |
|
☐ |
|
assignedClient_paymentCondition_createdAt |
datetime |
|
☐ |
|
assignedClient_paymentCondition_deletedAt |
datetime |
|
☐ |
|
assignedClient_paymentCondition_id |
string |
|
☐ |
|
assignedClient_paymentCondition_name |
string |
|
☐ |
|
assignedClient_paymentCondition_purchase |
boolean |
|
☐ |
|
assignedClient_paymentCondition_sales |
boolean |
|
☐ |
|
assignedClient_paymentCondition_updatedAt |
datetime |
|
☐ |
|
assignedClient_paymentConditionId |
string |
|
☐ |
|
assignedClient_status |
string |
|
☐ |
|
assignedClient_statusDetails_color |
string |
|
☐ |
|
assignedClient_statusDetails_name |
string |
|
☐ |
|
assignedClient_tel |
string |
|
☐ |
|
assignedClient_title |
string |
|
☐ |
|
assignedClient_updatedAt |
datetime |
|
☐ |
|
assignedClient_vatIdNumber |
string |
|
☐ |
|
assignedClient_vatTariff_additionalMention |
string |
|
☐ |
|
assignedClient_vatTariff_archivedAt |
datetime |
|
☐ |
|
assignedClient_vatTariff_category |
string |
|
☐ |
|
assignedClient_vatTariff_createdAt |
datetime |
|
☐ |
|
assignedClient_vatTariff_deletedAt |
datetime |
|
☐ |
|
assignedClient_vatTariff_description |
string |
|
☐ |
|
assignedClient_vatTariff_id |
string |
|
☐ |
|
assignedClient_vatTariff_name |
string |
|
☐ |
|
assignedClient_vatTariff_percentage |
decimal |
|
☐ |
|
assignedClient_vatTariff_updatedAt |
datetime |
|
☐ |
|
assignedClient_vatTariffId |
string |
|
☐ |
|
assignedClient_website |
string |
|
☐ |
|
assignedClientId |
string |
|
☐ |
|
assignedEmployee_archivedAt |
datetime |
|
☐ |
|
assignedEmployee_bankAccountNumber |
string |
|
☐ |
|
assignedEmployee_civilStatus |
string |
|
☐ |
|
assignedEmployee_collaborationEndDate |
datetime |
|
☐ |
|
assignedEmployee_collaborationStartDate |
datetime |
|
☐ |
|
assignedEmployee_competenceLevel |
string |
|
☐ |
|
assignedEmployee_costPerHour |
decimal |
|
☐ |
|
assignedEmployee_createdAt |
datetime |
|
☐ |
|
assignedEmployee_dateOfBirth |
datetime |
|
☐ |
|
assignedEmployee_deletedAt |
datetime |
|
☐ |
|
assignedEmployee_dimonaExpirationDate |
datetime |
|
☐ |
|
assignedEmployee_dimonaNumber |
string |
|
☐ |
|
assignedEmployee_distance |
decimal |
|
☐ |
|
assignedEmployee_domicileAddress_addressLine1 |
string |
|
☐ |
|
assignedEmployee_domicileAddress_addressLine2 |
string |
|
☐ |
|
assignedEmployee_domicileAddress_city |
string |
|
☐ |
|
assignedEmployee_domicileAddress_country |
string |
|
☐ |
|
assignedEmployee_domicileAddress_latitude |
double |
|
☐ |
|
assignedEmployee_domicileAddress_longitude |
double |
|
☐ |
|
assignedEmployee_domicileAddress_postalCode |
string |
|
☐ |
|
assignedEmployee_driverLicense |
string |
|
☐ |
|
assignedEmployee_email |
string |
|
☐ |
|
assignedEmployee_emergencyTel |
string |
|
☐ |
|
assignedEmployee_employeeRole_archivedAt |
datetime |
|
☐ |
|
assignedEmployee_employeeRole_createdAt |
datetime |
|
☐ |
|
assignedEmployee_employeeRole_deletedAt |
datetime |
|
☐ |
|
assignedEmployee_employeeRole_id |
string |
|
☐ |
|
assignedEmployee_employeeRole_name |
string |
|
☐ |
|
assignedEmployee_employeeRole_updatedAt |
datetime |
|
☐ |
|
assignedEmployee_employeeRoleId |
string |
|
☐ |
|
assignedEmployee_employer_archivedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_createdAt |
datetime |
|
☐ |
|
assignedEmployee_employer_deletedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_email |
string |
|
☐ |
|
assignedEmployee_employer_fax |
string |
|
☐ |
|
assignedEmployee_employer_generalLedgerAccount_archivedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_generalLedgerAccount_code |
string |
|
☐ |
|
assignedEmployee_employer_generalLedgerAccount_createdAt |
datetime |
|
☐ |
|
assignedEmployee_employer_generalLedgerAccount_deletedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_generalLedgerAccount_id |
string |
|
☐ |
|
assignedEmployee_employer_generalLedgerAccount_name |
string |
|
☐ |
|
assignedEmployee_employer_generalLedgerAccount_updatedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_generalLedgerAccountId |
string |
|
☐ |
|
assignedEmployee_employer_gsm |
string |
|
☐ |
|
assignedEmployee_employer_iban |
string |
|
☐ |
|
assignedEmployee_employer_id |
string |
|
☐ |
|
assignedEmployee_employer_invoiceAddress_addressLine1 |
string |
|
☐ |
|
assignedEmployee_employer_invoiceAddress_addressLine2 |
string |
|
☐ |
|
assignedEmployee_employer_invoiceAddress_city |
string |
|
☐ |
|
assignedEmployee_employer_invoiceAddress_country |
string |
|
☐ |
|
assignedEmployee_employer_invoiceAddress_latitude |
double |
|
☐ |
|
assignedEmployee_employer_invoiceAddress_longitude |
double |
|
☐ |
|
assignedEmployee_employer_invoiceAddress_postalCode |
string |
|
☐ |
|
assignedEmployee_employer_invoiceRemarks |
string |
|
☐ |
|
assignedEmployee_employer_kvk |
string |
|
☐ |
|
assignedEmployee_employer_language |
string |
|
☐ |
|
assignedEmployee_employer_legalForm_archivedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_legalForm_createdAt |
datetime |
|
☐ |
|
assignedEmployee_employer_legalForm_deletedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_legalForm_id |
string |
|
☐ |
|
assignedEmployee_employer_legalForm_legalAbbreviation |
string |
|
☐ |
|
assignedEmployee_employer_legalForm_name |
string |
|
☐ |
|
assignedEmployee_employer_legalForm_updatedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_legalForm_vatLiable |
boolean |
|
☐ |
|
assignedEmployee_employer_legalFormId |
string |
|
☐ |
|
assignedEmployee_employer_logicId |
string |
|
☐ |
|
assignedEmployee_employer_name |
string |
|
☐ |
|
assignedEmployee_employer_paymentConditionId |
string |
|
☐ |
|
assignedEmployee_employer_planningEmail |
string |
|
☐ |
|
assignedEmployee_employer_status |
string |
|
☐ |
|
assignedEmployee_employer_supplyOrderRemarks |
string |
|
☐ |
|
assignedEmployee_employer_tel |
string |
|
☐ |
|
assignedEmployee_employer_updatedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_vatIdNumber |
string |
|
☐ |
|
assignedEmployee_employer_vatTariff_additionalMention |
string |
|
☐ |
|
assignedEmployee_employer_vatTariff_archivedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_vatTariff_category |
string |
|
☐ |
|
assignedEmployee_employer_vatTariff_createdAt |
datetime |
|
☐ |
|
assignedEmployee_employer_vatTariff_deletedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_vatTariff_description |
string |
|
☐ |
|
assignedEmployee_employer_vatTariff_id |
string |
|
☐ |
|
assignedEmployee_employer_vatTariff_name |
string |
|
☐ |
|
assignedEmployee_employer_vatTariff_percentage |
decimal |
|
☐ |
|
assignedEmployee_employer_vatTariff_updatedAt |
datetime |
|
☐ |
|
assignedEmployee_employer_vatTariffId |
string |
|
☐ |
|
assignedEmployee_employer_website |
string |
|
☐ |
|
assignedEmployee_employerId |
string |
|
☐ |
|
assignedEmployee_grossSalary |
decimal |
|
☐ |
|
assignedEmployee_gsm |
string |
|
☐ |
|
assignedEmployee_id |
string |
|
☐ |
|
assignedEmployee_identityCardExpirationDate |
datetime |
|
☐ |
|
assignedEmployee_identityCardNumber |
string |
|
☐ |
|
assignedEmployee_image_archivedAt |
datetime |
|
☐ |
|
assignedEmployee_image_contentType |
string |
|
☐ |
|
assignedEmployee_image_createdAt |
datetime |
|
☐ |
|
assignedEmployee_image_deletedAt |
datetime |
|
☐ |
|
assignedEmployee_image_directory |
boolean |
|
☐ |
|
assignedEmployee_image_id |
string |
|
☐ |
|
assignedEmployee_image_name |
string |
|
☐ |
|
assignedEmployee_image_parentId |
string |
|
☐ |
|
assignedEmployee_image_previewUrl |
string |
|
☐ |
|
assignedEmployee_image_size |
int64 |
|
☐ |
|
assignedEmployee_image_updatedAt |
datetime |
|
☐ |
|
assignedEmployee_image_url |
string |
|
☐ |
|
assignedEmployee_independentRegistration |
boolean |
|
☐ |
|
assignedEmployee_limosaExpirationDate |
datetime |
|
☐ |
|
assignedEmployee_limosaNumber |
string |
|
☐ |
|
assignedEmployee_name |
string |
|
☐ |
|
assignedEmployee_nationality |
string |
|
☐ |
|
assignedEmployee_nssoIdNumber |
string |
|
☐ |
|
assignedEmployee_nssoPayment |
boolean |
|
☐ |
|
assignedEmployee_nssoPaymentExpirationDate |
datetime |
|
☐ |
|
assignedEmployee_numberOfDependents |
int32 |
|
☐ |
|
assignedEmployee_planningGroup |
string |
|
☐ |
|
assignedEmployee_position |
string |
|
☐ |
|
assignedEmployee_secondment |
boolean |
|
☐ |
|
assignedEmployee_status |
string |
|
☐ |
|
assignedEmployee_statute |
string |
|
☐ |
|
assignedEmployee_subType |
string |
|
☐ |
|
assignedEmployee_surname |
string |
|
☐ |
|
assignedEmployee_tel |
string |
|
☐ |
|
assignedEmployee_type |
string |
|
☐ |
|
assignedEmployee_updatedAt |
datetime |
|
☐ |
|
assignedEmployeeId |
string |
|
☐ |
|
assignedProject_archivedAt |
datetime |
|
☐ |
|
assignedProject_checkInAtWork |
string |
|
☐ |
|
assignedProject_client_address_addressLine1 |
string |
|
☐ |
|
assignedProject_client_address_addressLine2 |
string |
|
☐ |
|
assignedProject_client_address_city |
string |
|
☐ |
|
assignedProject_client_address_country |
string |
|
☐ |
|
assignedProject_client_address_latitude |
double |
|
☐ |
|
assignedProject_client_address_longitude |
double |
|
☐ |
|
assignedProject_client_address_postalCode |
string |
|
☐ |
|
assignedProject_client_archivedAt |
datetime |
|
☐ |
|
assignedProject_client_assignedUserId |
string |
|
☐ |
|
assignedProject_client_createdAt |
datetime |
|
☐ |
|
assignedProject_client_deletedAt |
datetime |
|
☐ |
|
assignedProject_client_email |
string |
|
☐ |
|
assignedProject_client_fax |
string |
|
☐ |
|
assignedProject_client_generalLedgerAccount_archivedAt |
datetime |
|
☐ |
|
assignedProject_client_generalLedgerAccount_code |
string |
|
☐ |
|
assignedProject_client_generalLedgerAccount_createdAt |
datetime |
|
☐ |
|
assignedProject_client_generalLedgerAccount_deletedAt |
datetime |
|
☐ |
|
assignedProject_client_generalLedgerAccount_id |
string |
|
☐ |
|
assignedProject_client_generalLedgerAccount_name |
string |
|
☐ |
|
assignedProject_client_generalLedgerAccount_updatedAt |
datetime |
|
☐ |
|
assignedProject_client_generalLedgerAccountId |
string |
|
☐ |
|
assignedProject_client_gsm |
string |
|
☐ |
|
assignedProject_client_id |
string |
|
☐ |
|
assignedProject_client_invoiceAddress_addressLine1 |
string |
|
☐ |
|
assignedProject_client_invoiceAddress_addressLine2 |
string |
|
☐ |
|
assignedProject_client_invoiceAddress_city |
string |
|
☐ |
|
assignedProject_client_invoiceAddress_country |
string |
|
☐ |
|
assignedProject_client_invoiceAddress_latitude |
double |
|
☐ |
|
assignedProject_client_invoiceAddress_longitude |
double |
|
☐ |
|
assignedProject_client_invoiceAddress_postalCode |
string |
|
☐ |
|
assignedProject_client_invoiceEmail |
string |
|
☐ |
|
assignedProject_client_language |
string |
|
☐ |
|
assignedProject_client_legalForm_archivedAt |
datetime |
|
☐ |
|
assignedProject_client_legalForm_createdAt |
datetime |
|
☐ |
|
assignedProject_client_legalForm_deletedAt |
datetime |
|
☐ |
|
assignedProject_client_legalForm_id |
string |
|
☐ |
|
assignedProject_client_legalForm_legalAbbreviation |
string |
|
☐ |
|
assignedProject_client_legalForm_name |
string |
|
☐ |
|
assignedProject_client_legalForm_updatedAt |
datetime |
|
☐ |
|
assignedProject_client_legalForm_vatLiable |
boolean |
|
☐ |
|
assignedProject_client_legalFormId |
string |
|
☐ |
|
assignedProject_client_name |
string |
|
☐ |
|
assignedProject_client_paymentCondition_archivedAt |
datetime |
|
☐ |
|
assignedProject_client_paymentCondition_createdAt |
datetime |
|
☐ |
|
assignedProject_client_paymentCondition_deletedAt |
datetime |
|
☐ |
|
assignedProject_client_paymentCondition_id |
string |
|
☐ |
|
assignedProject_client_paymentCondition_name |
string |
|
☐ |
|
assignedProject_client_paymentCondition_purchase |
boolean |
|
☐ |
|
assignedProject_client_paymentCondition_sales |
boolean |
|
☐ |
|
assignedProject_client_paymentCondition_updatedAt |
datetime |
|
☐ |
|
assignedProject_client_paymentConditionId |
string |
|
☐ |
|
assignedProject_client_status |
string |
|
☐ |
|
assignedProject_client_statusDetails_color |
string |
|
☐ |
|
assignedProject_client_statusDetails_name |
string |
|
☐ |
|
assignedProject_client_tel |
string |
|
☐ |
|
assignedProject_client_title |
string |
|
☐ |
|
assignedProject_client_updatedAt |
datetime |
|
☐ |
|
assignedProject_client_vatIdNumber |
string |
|
☐ |
|
assignedProject_client_vatTariff_additionalMention |
string |
|
☐ |
|
assignedProject_client_vatTariff_archivedAt |
datetime |
|
☐ |
|
assignedProject_client_vatTariff_category |
string |
|
☐ |
|
assignedProject_client_vatTariff_createdAt |
datetime |
|
☐ |
|
assignedProject_client_vatTariff_deletedAt |
datetime |
|
☐ |
|
assignedProject_client_vatTariff_description |
string |
|
☐ |
|
assignedProject_client_vatTariff_id |
string |
|
☐ |
|
assignedProject_client_vatTariff_name |
string |
|
☐ |
|
assignedProject_client_vatTariff_percentage |
decimal |
|
☐ |
|
assignedProject_client_vatTariff_updatedAt |
datetime |
|
☐ |
|
assignedProject_client_vatTariffId |
string |
|
☐ |
|
assignedProject_client_website |
string |
|
☐ |
|
assignedProject_clientContact_archivedAt |
datetime |
|
☐ |
|
assignedProject_clientContact_createdAt |
datetime |
|
☐ |
|
assignedProject_clientContact_deletedAt |
datetime |
|
☐ |
|
assignedProject_clientContact_email |
string |
|
☐ |
|
assignedProject_clientContact_gsm |
string |
|
☐ |
|
assignedProject_clientContact_id |
string |
|
☐ |
|
assignedProject_clientContact_name |
string |
|
☐ |
|
assignedProject_clientContact_position |
string |
|
☐ |
|
assignedProject_clientContact_surname |
string |
|
☐ |
|
assignedProject_clientContact_tel |
string |
|
☐ |
|
assignedProject_clientContact_title |
string |
|
☐ |
|
assignedProject_clientContact_updatedAt |
datetime |
|
☐ |
|
assignedProject_clientContactId |
string |
|
☐ |
|
assignedProject_clientId |
string |
|
☐ |
|
assignedProject_clientReference |
string |
|
☐ |
|
assignedProject_createdAt |
datetime |
|
☐ |
|
assignedProject_date |
datetime |
|
☐ |
|
assignedProject_deletedAt |
datetime |
|
☐ |
|
assignedProject_distance |
int32 |
|
☐ |
|
assignedProject_endClient_address_addressLine1 |
string |
|
☐ |
|
assignedProject_endClient_address_addressLine2 |
string |
|
☐ |
|
assignedProject_endClient_address_city |
string |
|
☐ |
|
assignedProject_endClient_address_country |
string |
|
☐ |
|
assignedProject_endClient_address_latitude |
double |
|
☐ |
|
assignedProject_endClient_address_longitude |
double |
|
☐ |
|
assignedProject_endClient_address_postalCode |
string |
|
☐ |
|
assignedProject_endClient_archivedAt |
datetime |
|
☐ |
|
assignedProject_endClient_assignedUserId |
string |
|
☐ |
|
assignedProject_endClient_createdAt |
datetime |
|
☐ |
|
assignedProject_endClient_deletedAt |
datetime |
|
☐ |
|
assignedProject_endClient_email |
string |
|
☐ |
|
assignedProject_endClient_fax |
string |
|
☐ |
|
assignedProject_endClient_generalLedgerAccount_archivedAt |
datetime |
|
☐ |
|
assignedProject_endClient_generalLedgerAccount_code |
string |
|
☐ |
|
assignedProject_endClient_generalLedgerAccount_createdAt |
datetime |
|
☐ |
|
assignedProject_endClient_generalLedgerAccount_deletedAt |
datetime |
|
☐ |
|
assignedProject_endClient_generalLedgerAccount_id |
string |
|
☐ |
|
assignedProject_endClient_generalLedgerAccount_name |
string |
|
☐ |
|
assignedProject_endClient_generalLedgerAccount_updatedAt |
datetime |
|
☐ |
|
assignedProject_endClient_generalLedgerAccountId |
string |
|
☐ |
|
assignedProject_endClient_gsm |
string |
|
☐ |
|
assignedProject_endClient_id |
string |
|
☐ |
|
assignedProject_endClient_invoiceAddress_addressLine1 |
string |
|
☐ |
|
assignedProject_endClient_invoiceAddress_addressLine2 |
string |
|
☐ |
|
assignedProject_endClient_invoiceAddress_city |
string |
|
☐ |
|
assignedProject_endClient_invoiceAddress_country |
string |
|
☐ |
|
assignedProject_endClient_invoiceAddress_latitude |
double |
|
☐ |
|
assignedProject_endClient_invoiceAddress_longitude |
double |
|
☐ |
|
assignedProject_endClient_invoiceAddress_postalCode |
string |
|
☐ |
|
assignedProject_endClient_invoiceEmail |
string |
|
☐ |
|
assignedProject_endClient_language |
string |
|
☐ |
|
assignedProject_endClient_legalForm_archivedAt |
datetime |
|
☐ |
|
assignedProject_endClient_legalForm_createdAt |
datetime |
|
☐ |
|
assignedProject_endClient_legalForm_deletedAt |
datetime |
|
☐ |
|
assignedProject_endClient_legalForm_id |
string |
|
☐ |
|
assignedProject_endClient_legalForm_legalAbbreviation |
string |
|
☐ |
|
assignedProject_endClient_legalForm_name |
string |
|
☐ |
|
assignedProject_endClient_legalForm_updatedAt |
datetime |
|
☐ |
|
assignedProject_endClient_legalForm_vatLiable |
boolean |
|
☐ |
|
assignedProject_endClient_legalFormId |
string |
|
☐ |
|
assignedProject_endClient_name |
string |
|
☐ |
|
assignedProject_endClient_paymentCondition_archivedAt |
datetime |
|
☐ |
|
assignedProject_endClient_paymentCondition_createdAt |
datetime |
|
☐ |
|
assignedProject_endClient_paymentCondition_deletedAt |
datetime |
|
☐ |
|
assignedProject_endClient_paymentCondition_id |
string |
|
☐ |
|
assignedProject_endClient_paymentCondition_name |
string |
|
☐ |
|
assignedProject_endClient_paymentCondition_purchase |
boolean |
|
☐ |
|
assignedProject_endClient_paymentCondition_sales |
boolean |
|
☐ |
|
assignedProject_endClient_paymentCondition_updatedAt |
datetime |
|
☐ |
|
assignedProject_endClient_paymentConditionId |
string |
|
☐ |
|
assignedProject_endClient_status |
string |
|
☐ |
|
assignedProject_endClient_statusDetails_color |
string |
|
☐ |
|
assignedProject_endClient_statusDetails_name |
string |
|
☐ |
|
assignedProject_endClient_tel |
string |
|
☐ |
|
assignedProject_endClient_title |
string |
|
☐ |
|
assignedProject_endClient_updatedAt |
datetime |
|
☐ |
|
assignedProject_endClient_vatIdNumber |
string |
|
☐ |
|
assignedProject_endClient_vatTariff_additionalMention |
string |
|
☐ |
|
assignedProject_endClient_vatTariff_archivedAt |
datetime |
|
☐ |
|
assignedProject_endClient_vatTariff_category |
string |
|
☐ |
|
assignedProject_endClient_vatTariff_createdAt |
datetime |
|
☐ |
|
assignedProject_endClient_vatTariff_deletedAt |
datetime |
|
☐ |
|
assignedProject_endClient_vatTariff_description |
string |
|
☐ |
|
assignedProject_endClient_vatTariff_id |
string |
|
☐ |
|
assignedProject_endClient_vatTariff_name |
string |
|
☐ |
|
assignedProject_endClient_vatTariff_percentage |
decimal |
|
☐ |
|
assignedProject_endClient_vatTariff_updatedAt |
datetime |
|
☐ |
|
assignedProject_endClient_vatTariffId |
string |
|
☐ |
|
assignedProject_endClient_website |
string |
|
☐ |
|
assignedProject_endClientContact_archivedAt |
datetime |
|
☐ |
|
assignedProject_endClientContact_createdAt |
datetime |
|
☐ |
|
assignedProject_endClientContact_deletedAt |
datetime |
|
☐ |
|
assignedProject_endClientContact_email |
string |
|
☐ |
|
assignedProject_endClientContact_gsm |
string |
|
☐ |
|
assignedProject_endClientContact_id |
string |
|
☐ |
|
assignedProject_endClientContact_name |
string |
|
☐ |
|
assignedProject_endClientContact_position |
string |
|
☐ |
|
assignedProject_endClientContact_surname |
string |
|
☐ |
|
assignedProject_endClientContact_tel |
string |
|
☐ |
|
assignedProject_endClientContact_title |
string |
|
☐ |
|
assignedProject_endClientContact_updatedAt |
datetime |
|
☐ |
|
assignedProject_endClientContactId |
string |
|
☐ |
|
assignedProject_endClientId |
string |
|
☐ |
|
assignedProject_id |
string |
|
☐ |
|
assignedProject_logicId |
string |
|
☐ |
|
assignedProject_nssoDeclarationOfWorks |
string |
|
☐ |
|
assignedProject_planningName |
string |
|
☐ |
|
assignedProject_siteAddress_addressLine1 |
string |
|
☐ |
|
assignedProject_siteAddress_addressLine2 |
string |
|
☐ |
|
assignedProject_siteAddress_city |
string |
|
☐ |
|
assignedProject_siteAddress_country |
string |
|
☐ |
|
assignedProject_siteAddress_latitude |
double |
|
☐ |
|
assignedProject_siteAddress_longitude |
double |
|
☐ |
|
assignedProject_siteAddress_postalCode |
string |
|
☐ |
|
assignedProject_siteManager_archivedAt |
datetime |
|
☐ |
|
assignedProject_siteManager_createdAt |
datetime |
|
☐ |
|
assignedProject_siteManager_deletedAt |
datetime |
|
☐ |
|
assignedProject_siteManager_email |
string |
|
☐ |
|
assignedProject_siteManager_fullName |
string |
|
☐ |
|
assignedProject_siteManager_id |
string |
|
☐ |
|
assignedProject_siteManager_locked |
boolean |
|
☐ |
|
assignedProject_siteManager_updatedAt |
datetime |
|
☐ |
|
assignedProject_siteManagerId |
string |
|
☐ |
|
assignedProject_siteNssoIdNumber |
string |
|
☐ |
|
assignedProject_status |
string |
|
☐ |
|
assignedProject_statusDetails_color |
string |
|
☐ |
|
assignedProject_statusDetails_name |
string |
|
☐ |
|
assignedProject_updatedAt |
datetime |
|
☐ |
|
assignedProjectId |
string |
|
☐ |
|
assignedSubcontractor_archivedAt |
datetime |
|
☐ |
|
assignedSubcontractor_createdAt |
datetime |
|
☐ |
|
assignedSubcontractor_deletedAt |
datetime |
|
☐ |
|
assignedSubcontractor_email |
string |
|
☐ |
|
assignedSubcontractor_fax |
string |
|
☐ |
|
assignedSubcontractor_generalLedgerAccount_archivedAt |
datetime |
|
☐ |
|
assignedSubcontractor_generalLedgerAccount_code |
string |
|
☐ |
|
assignedSubcontractor_generalLedgerAccount_createdAt |
datetime |
|
☐ |
|
assignedSubcontractor_generalLedgerAccount_deletedAt |
datetime |
|
☐ |
|
assignedSubcontractor_generalLedgerAccount_id |
string |
|
☐ |
|
assignedSubcontractor_generalLedgerAccount_name |
string |
|
☐ |
|
assignedSubcontractor_generalLedgerAccount_updatedAt |
datetime |
|
☐ |
|
assignedSubcontractor_generalLedgerAccountId |
string |
|
☐ |
|
assignedSubcontractor_gsm |
string |
|
☐ |
|
assignedSubcontractor_iban |
string |
|
☐ |
|
assignedSubcontractor_id |
string |
|
☐ |
|
assignedSubcontractor_invoiceAddress_addressLine1 |
string |
|
☐ |
|
assignedSubcontractor_invoiceAddress_addressLine2 |
string |
|
☐ |
|
assignedSubcontractor_invoiceAddress_city |
string |
|
☐ |
|
assignedSubcontractor_invoiceAddress_country |
string |
|
☐ |
|
assignedSubcontractor_invoiceAddress_latitude |
double |
|
☐ |
|
assignedSubcontractor_invoiceAddress_longitude |
double |
|
☐ |
|
assignedSubcontractor_invoiceAddress_postalCode |
string |
|
☐ |
|
assignedSubcontractor_invoiceRemarks |
string |
|
☐ |
|
assignedSubcontractor_kvk |
string |
|
☐ |
|
assignedSubcontractor_language |
string |
|
☐ |
|
assignedSubcontractor_legalForm_archivedAt |
datetime |
|
☐ |
|
assignedSubcontractor_legalForm_createdAt |
datetime |
|
☐ |
|
assignedSubcontractor_legalForm_deletedAt |
datetime |
|
☐ |
|
assignedSubcontractor_legalForm_id |
string |
|
☐ |
|
assignedSubcontractor_legalForm_legalAbbreviation |
string |
|
☐ |
|
assignedSubcontractor_legalForm_name |
string |
|
☐ |
|
assignedSubcontractor_legalForm_updatedAt |
datetime |
|
☐ |
|
assignedSubcontractor_legalForm_vatLiable |
boolean |
|
☐ |
|
assignedSubcontractor_legalFormId |
string |
|
☐ |
|
assignedSubcontractor_logicId |
string |
|
☐ |
|
assignedSubcontractor_name |
string |
|
☐ |
|
assignedSubcontractor_paymentConditionId |
string |
|
☐ |
|
assignedSubcontractor_planningEmail |
string |
|
☐ |
|
assignedSubcontractor_status |
string |
|
☐ |
|
assignedSubcontractor_supplyOrderRemarks |
string |
|
☐ |
|
assignedSubcontractor_tel |
string |
|
☐ |
|
assignedSubcontractor_updatedAt |
datetime |
|
☐ |
|
assignedSubcontractor_vatIdNumber |
string |
|
☐ |
|
assignedSubcontractor_vatTariff_additionalMention |
string |
|
☐ |
|
assignedSubcontractor_vatTariff_archivedAt |
datetime |
|
☐ |
|
assignedSubcontractor_vatTariff_category |
string |
|
☐ |
|
assignedSubcontractor_vatTariff_createdAt |
datetime |
|
☐ |
|
assignedSubcontractor_vatTariff_deletedAt |
datetime |
|
☐ |
|
assignedSubcontractor_vatTariff_description |
string |
|
☐ |
|
assignedSubcontractor_vatTariff_id |
string |
|
☐ |
|
assignedSubcontractor_vatTariff_name |
string |
|
☐ |
|
assignedSubcontractor_vatTariff_percentage |
decimal |
|
☐ |
|
assignedSubcontractor_vatTariff_updatedAt |
datetime |
|
☐ |
|
assignedSubcontractor_vatTariffId |
string |
|
☐ |
|
assignedSubcontractor_website |
string |
|
☐ |
|
assignedSubcontractorId |
string |
|
☐ |
|
brand |
string |
Brand |
☐ |
|
createdAt |
datetime |
|
☐ |
|
deletedAt |
datetime |
|
☐ |
|
id |
string |
ID |
☐ |
|
installation |
boolean |
|
☐ |
|
name |
string |
Name |
☐ |
|
serialNumber |
string |
|
☐ |
|
status |
string |
Status |
☐ |
|
supplier_archivedAt |
datetime |
|
☐ |
|
supplier_createdAt |
datetime |
|
☐ |
|
supplier_deletedAt |
datetime |
|
☐ |
|
supplier_email |
string |
|
☐ |
|
supplier_fax |
string |
|
☐ |
|
supplier_generalLedgerAccount_archivedAt |
datetime |
|
☐ |
|
supplier_generalLedgerAccount_code |
string |
|
☐ |
|
supplier_generalLedgerAccount_createdAt |
datetime |
|
☐ |
|
supplier_generalLedgerAccount_deletedAt |
datetime |
|
☐ |
|
supplier_generalLedgerAccount_id |
string |
|
☐ |
|
supplier_generalLedgerAccount_name |
string |
|
☐ |
|
supplier_generalLedgerAccount_updatedAt |
datetime |
|
☐ |
|
supplier_generalLedgerAccountId |
string |
|
☐ |
|
supplier_gsm |
string |
|
☐ |
|
supplier_iban |
string |
|
☐ |
|
supplier_id |
string |
|
☐ |
|
supplier_invoiceAddress_addressLine1 |
string |
|
☐ |
|
supplier_invoiceAddress_addressLine2 |
string |
|
☐ |
|
supplier_invoiceAddress_city |
string |
|
☐ |
|
supplier_invoiceAddress_country |
string |
|
☐ |
|
supplier_invoiceAddress_latitude |
double |
|
☐ |
|
supplier_invoiceAddress_longitude |
double |
|
☐ |
|
supplier_invoiceAddress_postalCode |
string |
|
☐ |
|
supplier_invoiceRemarks |
string |
|
☐ |
|
supplier_kvk |
string |
|
☐ |
|
supplier_language |
string |
|
☐ |
|
supplier_legalForm_archivedAt |
datetime |
|
☐ |
|
supplier_legalForm_createdAt |
datetime |
|
☐ |
|
supplier_legalForm_deletedAt |
datetime |
|
☐ |
|
supplier_legalForm_id |
string |
|
☐ |
|
supplier_legalForm_legalAbbreviation |
string |
|
☐ |
|
supplier_legalForm_name |
string |
|
☐ |
|
supplier_legalForm_updatedAt |
datetime |
|
☐ |
|
supplier_legalForm_vatLiable |
boolean |
|
☐ |
|
supplier_legalFormId |
string |
|
☐ |
|
supplier_logicId |
string |
|
☐ |
|
supplier_name |
string |
|
☐ |
|
supplier_paymentConditionId |
string |
|
☐ |
|
supplier_planningEmail |
string |
|
☐ |
|
supplier_status |
string |
|
☐ |
|
supplier_supplyOrderRemarks |
string |
|
☐ |
|
supplier_tel |
string |
|
☐ |
|
supplier_updatedAt |
datetime |
|
☐ |
|
supplier_vatIdNumber |
string |
|
☐ |
|
supplier_vatTariff_additionalMention |
string |
|
☐ |
|
supplier_vatTariff_archivedAt |
datetime |
|
☐ |
|
supplier_vatTariff_category |
string |
|
☐ |
|
supplier_vatTariff_createdAt |
datetime |
|
☐ |
|
supplier_vatTariff_deletedAt |
datetime |
|
☐ |
|
supplier_vatTariff_description |
string |
|
☐ |
|
supplier_vatTariff_id |
string |
|
☐ |
|
supplier_vatTariff_name |
string |
|
☐ |
|
supplier_vatTariff_percentage |
decimal |
|
☐ |
|
supplier_vatTariff_updatedAt |
datetime |
|
☐ |
|
supplier_vatTariffId |
string |
|
☐ |
|
supplier_website |
string |
|
☐ |
|
supplierId |
string |
|
☐ |
|
updatedAt |
datetime |
|
☐ |
|
17-06-2022 11:59 Version 22.1.46-BETA+3385