ROBAWS API Data Model

Zoom Window Out
Larger Text | Smaller Text
Hide Page Header
Show Expanding Text
Print Topic
Send Mail Feedback
Share This Topic
Save Permalink URL

Navigation: Schema: Invoices > Tables

InvoiceOrderExtraFieldsByInvoiceId: Invoice Order Extra Fields by Invoice ID

Contents Previous Home Next More

https://cloud.invantive.com/robaws/Sql

get

Catalog: Robaws

Schema: Invoices

Label: Invoice Order Extra Fields by Invoice ID

Select: true

Insert: false

Update: false

Delete: false

Select Service URL (OData-specific): /api/v1/invoices/{id}

Insert Service URL (OData-specific): /api/v1/invoices/{id}

Update Service URL (OData-specific): /api/v1/invoices/{id}

Delete Service URL (OData-specific): /api/v1/invoices/{id}

Field Selection Method (OData-specific): NotRequired

Base Path (OData-specific): orders[*].extraFields[*]

Select Operation (Swagger-specific): get /api/v1/invoices/{id}

Table Function Parameters

The following parameters can be used to control the behaviour of the table function InvoiceOrderExtraFieldsByInvoiceId. 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
id	int64	☑		id

Table Columns

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

Name	Data Type	Label	Required
advanceDiscountPercentage	double		☐
advancePayment	boolean	Advance Payment	☐
advancePercentage	double	Advance (%)	☐
assignee_avatar_availableForWappy	boolean		☐
assignee_avatar_directory	boolean		☐
assignee_avatar_documentDate	datetime		☐
assignee_avatar_expirationDate	datetime		☐
assignee_avatar_filename	string		☐
assignee_avatar_fileSize	int64		☐
assignee_avatar_id	int64		☐
assignee_avatar_mimeType	string		☐
assignee_avatar_objectRef_objectId	int64		☐
assignee_avatar_objectRef_objectType	string		☐
assignee_avatar_parentId	int64		☐
assignee_avatar_path	string		☐
assignee_avatar_uuid	string		☐
assignee_avatar_version	int64		☐
assignee_avatar_wappy	boolean		☐
assignee_email	string	Assignee Email	☐
assignee_emailAccount_emailAccountType	string		☐
assignee_emailAccount_emailBcc	string		☐
assignee_emailAccount_emailFrom	string		☐
assignee_emailAccount_emailFromName	string		☐
assignee_emailAccount_emailHost	string		☐
assignee_emailAccount_emailPass	string		☐
assignee_emailAccount_emailPort	string		☐
assignee_emailAccount_emailUser	string		☐
assignee_emailAccount_starttls	boolean		☐
assignee_emailAccount_uuid	string		☐
assignee_employee_address_city	string		☐
assignee_employee_address_country	string		☐
assignee_employee_address_latLng_defined	boolean		☐
assignee_employee_address_latLng_lat	double		☐
assignee_employee_address_latLng_lng	double		☐
assignee_employee_address_street	string		☐
assignee_employee_address_streetBase	string		☐
assignee_employee_address_streetExtra	string		☐
assignee_employee_address_streetNumber	string		☐
assignee_employee_address_zipcode	string		☐
assignee_employee_bankaccountNr	string		☐
assignee_employee_birthDate	datetime		☐
assignee_employee_civilStatus	string		☐
assignee_employee_competenceLevel	string		☐
assignee_employee_costPerHour	double		☐
assignee_employee_defaultMobility_id	int64		☐
assignee_employee_defaultMobility_name	string		☐
assignee_employee_defaultMobility_version	int64		☐
assignee_employee_defaultOperation_accountancyCode_code	string		☐
assignee_employee_defaultOperation_accountancyCode_externalId	string		☐
assignee_employee_defaultOperation_accountancyCode_id	int64		☐
assignee_employee_defaultOperation_accountancyCode_name	string		☐
assignee_employee_defaultOperation_accountancyCode_version	int64		☐
assignee_employee_defaultOperation_accountancyCodePurchase_code	string		☐
assignee_employee_defaultOperation_accountancyCodePurchase_externalId	string		☐
assignee_employee_defaultOperation_accountancyCodePurchase_id	int64		☐
assignee_employee_defaultOperation_accountancyCodePurchase_name	string		☐
assignee_employee_defaultOperation_accountancyCodePurchase_version	int64		☐
assignee_employee_defaultOperation_activity	string		☐
assignee_employee_defaultOperation_agreementType	string		☐
assignee_employee_defaultOperation_articleGroup_contextPath	string		☐
assignee_employee_defaultOperation_articleGroup_id	int64		☐
assignee_employee_defaultOperation_articleGroup_name	string		☐
assignee_employee_defaultOperation_articleGroup_photo_availableForWappy	boolean		☐
assignee_employee_defaultOperation_articleGroup_photo_directory	boolean		☐
assignee_employee_defaultOperation_articleGroup_photo_documentDate	datetime		☐
assignee_employee_defaultOperation_articleGroup_photo_expirationDate	datetime		☐
assignee_employee_defaultOperation_articleGroup_photo_filename	string		☐
assignee_employee_defaultOperation_articleGroup_photo_fileSize	int64		☐
assignee_employee_defaultOperation_articleGroup_photo_id	int64		☐
assignee_employee_defaultOperation_articleGroup_photo_mimeType	string		☐
assignee_employee_defaultOperation_articleGroup_photo_parentId	int64		☐
assignee_employee_defaultOperation_articleGroup_photo_path	string		☐
assignee_employee_defaultOperation_articleGroup_photo_uuid	string		☐
assignee_employee_defaultOperation_articleGroup_photo_version	int64		☐
assignee_employee_defaultOperation_articleGroup_photo_wappy	boolean		☐
assignee_employee_defaultOperation_articleGroup_version	int64		☐
assignee_employee_defaultOperation_articleNumber	string		☐
assignee_employee_defaultOperation_articleType	string		☐
assignee_employee_defaultOperation_barcode	string		☐
assignee_employee_defaultOperation_brand	string		☐
assignee_employee_defaultOperation_calc	boolean		☐
assignee_employee_defaultOperation_calcDescription	string		☐
assignee_employee_defaultOperation_calculationType	string		☐
assignee_employee_defaultOperation_chapter	string		☐
assignee_employee_defaultOperation_costPrice	double		☐
assignee_employee_defaultOperation_costPriceStrategy	string		☐
assignee_employee_defaultOperation_currencySymbol	string		☐
assignee_employee_defaultOperation_description	string		☐
assignee_employee_defaultOperation_deviantSalesName	string		☐
assignee_employee_defaultOperation_headerLevel	string		☐
assignee_employee_defaultOperation_id	int64		☐
assignee_employee_defaultOperation_indirectCostFactor	double		☐
assignee_employee_defaultOperation_internalPhoto	boolean		☐
assignee_employee_defaultOperation_lineType	string		☐
assignee_employee_defaultOperation_margin	double		☐
assignee_employee_defaultOperation_materialInstallation	boolean		☐
assignee_employee_defaultOperation_minimumSaleAmount	double		☐
assignee_employee_defaultOperation_minimumStockAmount	double		☐
assignee_employee_defaultOperation_name	string		☐
assignee_employee_defaultOperation_newPage	boolean		☐
assignee_employee_defaultOperation_photo_availableForWappy	boolean		☐
assignee_employee_defaultOperation_photo_directory	boolean		☐
assignee_employee_defaultOperation_photo_documentDate	datetime		☐
assignee_employee_defaultOperation_photo_expirationDate	datetime		☐
assignee_employee_defaultOperation_photo_filename	string		☐
assignee_employee_defaultOperation_photo_fileSize	int64		☐
assignee_employee_defaultOperation_photo_id	int64		☐
assignee_employee_defaultOperation_photo_mimeType	string		☐
assignee_employee_defaultOperation_photo_objectRef_objectId	int64		☐
assignee_employee_defaultOperation_photo_objectRef_objectType	string		☐
assignee_employee_defaultOperation_photo_parentId	int64		☐
assignee_employee_defaultOperation_photo_path	string		☐
assignee_employee_defaultOperation_photo_uuid	string		☐
assignee_employee_defaultOperation_photo_version	int64		☐
assignee_employee_defaultOperation_photo_wappy	boolean		☐
assignee_employee_defaultOperation_saleName	string		☐
assignee_employee_defaultOperation_salePrice	double		☐
assignee_employee_defaultOperation_salePriceStrategy	string		☐
assignee_employee_defaultOperation_stockAmount	double		☐
assignee_employee_defaultOperation_stockChanges	string		☐
assignee_employee_defaultOperation_stockLocation	string		☐
assignee_employee_defaultOperation_supplierNames	string		☐
assignee_employee_defaultOperation_timeOperation	boolean		☐
assignee_employee_defaultOperation_unitType	string		☐
assignee_employee_defaultOperation_vatTarif	string		☐
assignee_employee_defaultOperation_version	int64		☐
assignee_employee_dependentChildren	int32		☐
assignee_employee_detachment	boolean		☐
assignee_employee_dimona	string		☐
assignee_employee_dimonaExpireDate	datetime		☐
assignee_employee_distance	double		☐
assignee_employee_documentRsz	int64		☐
assignee_employee_documentRszPayment	int64		☐
assignee_employee_documentRszValidTill	datetime		☐
assignee_employee_driverLicense	string		☐
assignee_employee_email	string		☐
assignee_employee_emergencyTel	string		☐
assignee_employee_employeeGone	datetime		☐
assignee_employee_employeeRole_id	int64		☐
assignee_employee_employeeRole_name	string		☐
assignee_employee_employeeRole_version	int64		☐
assignee_employee_employeeSince	datetime		☐
assignee_employee_employeeStatute	string		☐
assignee_employee_expireDateRszPayment	datetime		☐
assignee_employee_fullname	string		☐
assignee_employee_function	string		☐
assignee_employee_gender	string		☐
assignee_employee_grossSalary	double		☐
assignee_employee_gsm	string		☐
assignee_employee_gsmOrTel	string		☐
assignee_employee_id	int64		☐
assignee_employee_independentCertificate	boolean		☐
assignee_employee_independentConnection	boolean		☐
assignee_employee_insz	string		☐
assignee_employee_limosaExpireDate	datetime		☐
assignee_employee_limosaNr	string		☐
assignee_employee_name	string		☐
assignee_employee_nameAndState	string		☐
assignee_employee_nationality	string		☐
assignee_employee_objectDescription	string		☐
assignee_employee_passportExpireDate	datetime		☐
assignee_employee_passportNr	string		☐
assignee_employee_paymentRsz	boolean		☐
assignee_employee_planningGroup	string		☐
assignee_employee_startDate	datetime		☐
assignee_employee_status	string		☐
assignee_employee_subType	string		☐
assignee_employee_supplier_accountancyCodePurchase_code	string		☐
assignee_employee_supplier_accountancyCodePurchase_externalId	string		☐
assignee_employee_supplier_accountancyCodePurchase_id	int64		☐
assignee_employee_supplier_accountancyCodePurchase_name	string		☐
assignee_employee_supplier_accountancyCodePurchase_version	int64		☐
assignee_employee_supplier_accountNr	string		☐
assignee_employee_supplier_addressString	string		☐
assignee_employee_supplier_bank	string		☐
assignee_employee_supplier_btwNumber	string		☐
assignee_employee_supplier_currencySymbol	string		☐
assignee_employee_supplier_email	string		☐
assignee_employee_supplier_externalId	string		☐
assignee_employee_supplier_fax	string		☐
assignee_employee_supplier_gsm	string		☐
assignee_employee_supplier_id	int64		☐
assignee_employee_supplier_invoiceAddress_city	string		☐
assignee_employee_supplier_invoiceAddress_country	string		☐
assignee_employee_supplier_invoiceAddress_latLng_defined	boolean		☐
assignee_employee_supplier_invoiceAddress_latLng_lat	double		☐
assignee_employee_supplier_invoiceAddress_latLng_lng	double		☐
assignee_employee_supplier_invoiceAddress_street	string		☐
assignee_employee_supplier_invoiceAddress_streetBase	string		☐
assignee_employee_supplier_invoiceAddress_streetExtra	string		☐
assignee_employee_supplier_invoiceAddress_streetNumber	string		☐
assignee_employee_supplier_invoiceAddress_zipcode	string		☐
assignee_employee_supplier_invoiceRemarks	string		☐
assignee_employee_supplier_language	string		☐
assignee_employee_supplier_legalForm_hasVat	boolean		☐
assignee_employee_supplier_legalForm_id	int64		☐
assignee_employee_supplier_legalForm_name	string		☐
assignee_employee_supplier_legalForm_pdfName	string		☐
assignee_employee_supplier_legalForm_version	int64		☐
assignee_employee_supplier_legalName	string		☐
assignee_employee_supplier_logicId	string		☐
assignee_employee_supplier_name	string		☐
assignee_employee_supplier_planningEmail	string		☐
assignee_employee_supplier_status	string		☐
assignee_employee_supplier_supplyOrderRemarks	string		☐
assignee_employee_supplier_tel	string		☐
assignee_employee_supplier_vat_ublSchemeId	string		☐
assignee_employee_supplier_vat_vatCode	string		☐
assignee_employee_supplier_vat_vatCountry	string		☐
assignee_employee_supplier_vat_vatValid	boolean		☐
assignee_employee_supplier_vatNr	string		☐
assignee_employee_supplier_vatTarif	string		☐
assignee_employee_supplier_version	int64		☐
assignee_employee_supplier_website	string		☐
assignee_employee_supplierName	string		☐
assignee_employee_surname	string		☐
assignee_employee_tel	string		☐
assignee_employee_type	string		☐
assignee_employee_version	int64		☐
assignee_employeeId	int64		☐
assignee_fullname	string	Assignee Full Name	☐
assignee_id	int64	Assignee ID	☐
assignee_schema	string	Assignee Schema	☐
assignee_signature	string	Assignee Signature	☐
assignee_useEmailAccount	boolean		☐
assignee_username	string		☐
assignee_userRole_id	int64		☐
assignee_userRole_name	string		☐
assignee_userRole_version	int64		☐
assignee_userRoleString	string		☐
assignee_version	int64	Assignee Version	☐
assigneeName	string	Assignee Name	☐
assigneeName_1	string		☐
body	string	Body	☐
booked	boolean	Booked	☐
boolValue	boolean	Boolean Value	☐
btw	double	VAT	☐
client_accountNr	string		☐
client_address_city	string		☐
client_address_country	string		☐
client_address_latLng_defined	boolean		☐
client_address_latLng_lat	double		☐
client_address_latLng_lng	double		☐
client_address_street	string		☐
client_address_streetBase	string		☐
client_address_streetExtra	string		☐
client_address_streetNumber	string		☐
client_address_zipcode	string		☐
client_addressString	string		☐
client_assignee_avatar_availableForWappy	boolean		☐
client_assignee_avatar_directory	boolean		☐
client_assignee_avatar_documentDate	datetime		☐
client_assignee_avatar_expirationDate	datetime		☐
client_assignee_avatar_filename	string		☐
client_assignee_avatar_fileSize	int64		☐
client_assignee_avatar_id	int64		☐
client_assignee_avatar_mimeType	string		☐
client_assignee_avatar_objectRef_objectId	int64		☐
client_assignee_avatar_objectRef_objectType	string		☐
client_assignee_avatar_parentId	int64		☐
client_assignee_avatar_path	string		☐
client_assignee_avatar_uuid	string		☐
client_assignee_avatar_version	int64		☐
client_assignee_avatar_wappy	boolean		☐
client_assignee_email	string		☐
client_assignee_emailAccount_emailAccountType	string		☐
client_assignee_emailAccount_emailBcc	string		☐
client_assignee_emailAccount_emailFrom	string		☐
client_assignee_emailAccount_emailFromName	string		☐
client_assignee_emailAccount_emailHost	string		☐
client_assignee_emailAccount_emailPass	string		☐
client_assignee_emailAccount_emailPort	string		☐
client_assignee_emailAccount_emailUser	string		☐
client_assignee_emailAccount_starttls	boolean		☐
client_assignee_emailAccount_uuid	string		☐
client_assignee_employee_address_city	string		☐
client_assignee_employee_address_country	string		☐
client_assignee_employee_address_latLng_defined	boolean		☐
client_assignee_employee_address_latLng_lat	double		☐
client_assignee_employee_address_latLng_lng	double		☐
client_assignee_employee_address_street	string		☐
client_assignee_employee_address_streetBase	string		☐
client_assignee_employee_address_streetExtra	string		☐
client_assignee_employee_address_streetNumber	string		☐
client_assignee_employee_address_zipcode	string		☐
client_assignee_employee_bankaccountNr	string		☐
client_assignee_employee_birthDate	datetime		☐
client_assignee_employee_civilStatus	string		☐
client_assignee_employee_competenceLevel	string		☐
client_assignee_employee_costPerHour	double		☐
client_assignee_employee_defaultMobility_id	int64		☐
client_assignee_employee_defaultMobility_name	string		☐
client_assignee_employee_defaultMobility_version	int64		☐
client_assignee_employee_defaultOperation_accountancyCode_code	string		☐
client_assignee_employee_defaultOperation_accountancyCode_externalId	string		☐
client_assignee_employee_defaultOperation_accountancyCode_id	int64		☐
client_assignee_employee_defaultOperation_accountancyCode_name	string		☐
client_assignee_employee_defaultOperation_accountancyCode_version	int64		☐
client_assignee_employee_defaultOperation_accountancyCodePurchase_code	string		☐
client_assignee_employee_defaultOperation_accountancyCodePurchase_externalId	string		☐
client_assignee_employee_defaultOperation_accountancyCodePurchase_id	int64		☐
client_assignee_employee_defaultOperation_accountancyCodePurchase_name	string		☐
client_assignee_employee_defaultOperation_accountancyCodePurchase_version	int64		☐
client_assignee_employee_defaultOperation_activity	string		☐
client_assignee_employee_defaultOperation_agreementType	string		☐
client_assignee_employee_defaultOperation_articleGroup_contextPath	string		☐
client_assignee_employee_defaultOperation_articleGroup_id	int64		☐
client_assignee_employee_defaultOperation_articleGroup_name	string		☐
client_assignee_employee_defaultOperation_articleGroup_version	int64		☐
client_assignee_employee_defaultOperation_articleNumber	string		☐
client_assignee_employee_defaultOperation_articleType	string		☐
client_assignee_employee_defaultOperation_barcode	string		☐
client_assignee_employee_defaultOperation_brand	string		☐
client_assignee_employee_defaultOperation_calc	boolean		☐
client_assignee_employee_defaultOperation_calcDescription	string		☐
client_assignee_employee_defaultOperation_calculationType	string		☐
client_assignee_employee_defaultOperation_chapter	string		☐
client_assignee_employee_defaultOperation_costPrice	double		☐
client_assignee_employee_defaultOperation_costPriceStrategy	string		☐
client_assignee_employee_defaultOperation_currencySymbol	string		☐
client_assignee_employee_defaultOperation_description	string		☐
client_assignee_employee_defaultOperation_deviantSalesName	string		☐
client_assignee_employee_defaultOperation_headerLevel	string		☐
client_assignee_employee_defaultOperation_id	int64		☐
client_assignee_employee_defaultOperation_indirectCostFactor	double		☐
client_assignee_employee_defaultOperation_internalPhoto	boolean		☐
client_assignee_employee_defaultOperation_lineType	string		☐
client_assignee_employee_defaultOperation_margin	double		☐
client_assignee_employee_defaultOperation_materialInstallation	boolean		☐
client_assignee_employee_defaultOperation_minimumSaleAmount	double		☐
client_assignee_employee_defaultOperation_minimumStockAmount	double		☐
client_assignee_employee_defaultOperation_name	string		☐
client_assignee_employee_defaultOperation_newPage	boolean		☐
client_assignee_employee_defaultOperation_photo_availableForWappy	boolean		☐
client_assignee_employee_defaultOperation_photo_directory	boolean		☐
client_assignee_employee_defaultOperation_photo_documentDate	datetime		☐
client_assignee_employee_defaultOperation_photo_expirationDate	datetime		☐
client_assignee_employee_defaultOperation_photo_filename	string		☐
client_assignee_employee_defaultOperation_photo_fileSize	int64		☐
client_assignee_employee_defaultOperation_photo_id	int64		☐
client_assignee_employee_defaultOperation_photo_mimeType	string		☐
client_assignee_employee_defaultOperation_photo_parentId	int64		☐
client_assignee_employee_defaultOperation_photo_path	string		☐
client_assignee_employee_defaultOperation_photo_uuid	string		☐
client_assignee_employee_defaultOperation_photo_version	int64		☐
client_assignee_employee_defaultOperation_photo_wappy	boolean		☐
client_assignee_employee_defaultOperation_saleName	string		☐
client_assignee_employee_defaultOperation_salePrice	double		☐
client_assignee_employee_defaultOperation_salePriceStrategy	string		☐
client_assignee_employee_defaultOperation_stockAmount	double		☐
client_assignee_employee_defaultOperation_stockChanges	string		☐
client_assignee_employee_defaultOperation_stockLocation	string		☐
client_assignee_employee_defaultOperation_supplierNames	string		☐
client_assignee_employee_defaultOperation_timeOperation	boolean		☐
client_assignee_employee_defaultOperation_unitType	string		☐
client_assignee_employee_defaultOperation_vatTarif	string		☐
client_assignee_employee_defaultOperation_version	int64		☐
client_assignee_employee_dependentChildren	int32		☐
client_assignee_employee_detachment	boolean		☐
client_assignee_employee_dimona	string		☐
client_assignee_employee_dimonaExpireDate	datetime		☐
client_assignee_employee_distance	double		☐
client_assignee_employee_documentRsz	int64		☐
client_assignee_employee_documentRszPayment	int64		☐
client_assignee_employee_documentRszValidTill	datetime		☐
client_assignee_employee_driverLicense	string		☐
client_assignee_employee_email	string		☐
client_assignee_employee_emergencyTel	string		☐
client_assignee_employee_employeeGone	datetime		☐
client_assignee_employee_employeeRole_id	int64		☐
client_assignee_employee_employeeRole_name	string		☐
client_assignee_employee_employeeRole_version	int64		☐
client_assignee_employee_employeeSince	datetime		☐
client_assignee_employee_employeeStatute	string		☐
client_assignee_employee_expireDateRszPayment	datetime		☐
client_assignee_employee_fullname	string		☐
client_assignee_employee_function	string		☐
client_assignee_employee_gender	string		☐
client_assignee_employee_grossSalary	double		☐
client_assignee_employee_gsm	string		☐
client_assignee_employee_gsmOrTel	string		☐
client_assignee_employee_id	int64		☐
client_assignee_employee_independentCertificate	boolean		☐
client_assignee_employee_independentConnection	boolean		☐
client_assignee_employee_insz	string		☐
client_assignee_employee_limosaExpireDate	datetime		☐
client_assignee_employee_limosaNr	string		☐
client_assignee_employee_name	string		☐
client_assignee_employee_nameAndState	string		☐
client_assignee_employee_nationality	string		☐
client_assignee_employee_objectDescription	string		☐
client_assignee_employee_passportExpireDate	datetime		☐
client_assignee_employee_passportNr	string		☐
client_assignee_employee_paymentRsz	boolean		☐
client_assignee_employee_planningGroup	string		☐
client_assignee_employee_startDate	datetime		☐
client_assignee_employee_status	string		☐
client_assignee_employee_subType	string		☐
client_assignee_employee_supplier_accountancyCodePurchase_code	string		☐
client_assignee_employee_supplier_accountancyCodePurchase_externalId	string		☐
client_assignee_employee_supplier_accountancyCodePurchase_id	int64		☐
client_assignee_employee_supplier_accountancyCodePurchase_name	string		☐
client_assignee_employee_supplier_accountancyCodePurchase_version	int64		☐
client_assignee_employee_supplier_accountNr	string		☐
client_assignee_employee_supplier_addressString	string		☐
client_assignee_employee_supplier_bank	string		☐
client_assignee_employee_supplier_btwNumber	string		☐
client_assignee_employee_supplier_currencySymbol	string		☐
client_assignee_employee_supplier_email	string		☐
client_assignee_employee_supplier_externalId	string		☐
client_assignee_employee_supplier_fax	string		☐
client_assignee_employee_supplier_gsm	string		☐
client_assignee_employee_supplier_id	int64		☐
client_assignee_employee_supplier_invoiceAddress_city	string		☐
client_assignee_employee_supplier_invoiceAddress_country	string		☐
client_assignee_employee_supplier_invoiceAddress_street	string		☐
client_assignee_employee_supplier_invoiceAddress_streetBase	string		☐
client_assignee_employee_supplier_invoiceAddress_streetExtra	string		☐
client_assignee_employee_supplier_invoiceAddress_streetNumber	string		☐
client_assignee_employee_supplier_invoiceAddress_zipcode	string		☐
client_assignee_employee_supplier_invoiceRemarks	string		☐
client_assignee_employee_supplier_language	string		☐
client_assignee_employee_supplier_legalForm_hasVat	boolean		☐
client_assignee_employee_supplier_legalForm_id	int64		☐
client_assignee_employee_supplier_legalForm_name	string		☐
client_assignee_employee_supplier_legalForm_pdfName	string		☐
client_assignee_employee_supplier_legalForm_version	int64		☐
client_assignee_employee_supplier_legalName	string		☐
client_assignee_employee_supplier_logicId	string		☐
client_assignee_employee_supplier_name	string		☐
client_assignee_employee_supplier_planningEmail	string		☐
client_assignee_employee_supplier_status	string		☐
client_assignee_employee_supplier_supplyOrderRemarks	string		☐
client_assignee_employee_supplier_tel	string		☐
client_assignee_employee_supplier_vat_ublSchemeId	string		☐
client_assignee_employee_supplier_vat_vatCode	string		☐
client_assignee_employee_supplier_vat_vatCountry	string		☐
client_assignee_employee_supplier_vat_vatValid	boolean		☐
client_assignee_employee_supplier_vatNr	string		☐
client_assignee_employee_supplier_vatTarif	string		☐
client_assignee_employee_supplier_version	int64		☐
client_assignee_employee_supplier_website	string		☐
client_assignee_employee_supplierName	string		☐
client_assignee_employee_surname	string		☐
client_assignee_employee_tel	string		☐
client_assignee_employee_type	string		☐
client_assignee_employee_version	int64		☐
client_assignee_employeeId	int64		☐
client_assignee_fullname	string		☐
client_assignee_id	int64		☐
client_assignee_schema	string		☐
client_assignee_signature	string		☐
client_assignee_useEmailAccount	boolean		☐
client_assignee_username	string		☐
client_assignee_userRole_id	int64		☐
client_assignee_userRole_name	string		☐
client_assignee_userRole_version	int64		☐
client_assignee_userRoleString	string		☐
client_assignee_version	int64		☐
client_assigneeName	string		☐
client_bank	string	Client Bank	☐
client_contactMedium	string		☐
client_creditDate	datetime		☐
client_creditInfo	string		☐
client_creditLimit	double		☐
client_creditStatus	string		☐
client_currencySymbol	string		☐
client_email	string	Client Email	☐
client_emailPermissionDate	datetime		☐
client_emailPermissionFrom	string		☐
client_expireDate_expireDatePeriodType	string		☐
client_expireDate_id	int64		☐
client_expireDate_name	string		☐
client_expireDate_plusDays	int32		☐
client_expireDate_version	int64		☐
client_externalId	string		☐
client_fax	string	Client Fax	☐
client_finalAddress_city	string		☐
client_finalAddress_country	string		☐
client_finalAddress_latLng_defined	boolean		☐
client_finalAddress_latLng_lat	double		☐
client_finalAddress_latLng_lng	double		☐
client_finalAddress_street	string		☐
client_finalAddress_streetBase	string		☐
client_finalAddress_streetExtra	string		☐
client_finalAddress_streetNumber	string		☐
client_finalAddress_zipcode	string		☐
client_followUpDate	datetime		☐
client_gsm	string	Client Mobile	☐
client_id	int64	Client ID	☐
client_invoiceAddress_city	string		☐
client_invoiceAddress_country	string		☐
client_invoiceAddress_latLng_defined	boolean		☐
client_invoiceAddress_latLng_lat	double		☐
client_invoiceAddress_latLng_lng	double		☐
client_invoiceAddress_street	string		☐
client_invoiceAddress_streetBase	string		☐
client_invoiceAddress_streetExtra	string		☐
client_invoiceAddress_streetNumber	string		☐
client_invoiceAddress_zipcode	string		☐
client_invoiceEmail	string		☐
client_invoiceRemarks	string		☐
client_language	string		☐
client_legalForm_hasVat	boolean		☐
client_legalForm_id	int64		☐
client_legalForm_name	string		☐
client_legalForm_pdfName	string		☐
client_legalForm_version	int64		☐
client_legalName	string		☐
client_logicId	string		☐
client_name	string		☐
client_priceGroup_id	int64		☐
client_priceGroup_name	string		☐
client_priceGroup_version	int64		☐
client_seperateInvoicePage	boolean		☐
client_status	string		☐
client_tel	string		☐
client_title	string		☐
client_useInvoiceAddress	boolean		☐
client_usePeppol	boolean		☐
client_vat_ublSchemeId	string		☐
client_vat_vatCode	string		☐
client_vat_vatCountry	string		☐
client_vat_vatValid	boolean		☐
client_vatNr	string		☐
client_vatTarif	string		☐
client_version	int64		☐
client_website	string		☐
client_withRespectTo	string		☐
clientLegalName	string	Customer Legal Name	☐
clientLegalName_1	string		☐
clientName	string	Customer Name	☐
clientName_1	string		☐
clientReference	string	Customer Reference	☐
clientReference_1	string		☐
company_address_city	string		☐
company_address_country	string		☐
company_address_latLng_defined	boolean		☐
company_address_latLng_lat	double		☐
company_address_latLng_lng	double		☐
company_address_street	string		☐
company_address_streetBase	string		☐
company_address_streetExtra	string		☐
company_address_streetNumber	string		☐
company_address_zipcode	string		☐
company_addressString	string		☐
company_backgroundPage_background_availableForWappy	boolean		☐
company_backgroundPage_background_directory	boolean		☐
company_backgroundPage_background_documentDate	datetime		☐
company_backgroundPage_background_expirationDate	datetime		☐
company_backgroundPage_background_filename	string		☐
company_backgroundPage_background_fileSize	int64		☐
company_backgroundPage_background_id	int64		☐
company_backgroundPage_background_mimeType	string		☐
company_backgroundPage_background_objectRef_objectId	int64		☐
company_backgroundPage_background_objectRef_objectType	string		☐
company_backgroundPage_background_parentId	int64		☐
company_backgroundPage_background_path	string		☐
company_backgroundPage_background_uuid	string		☐
company_backgroundPage_background_version	int64		☐
company_backgroundPage_background_wappy	boolean		☐
company_backgroundPage_bottomMargin	int32		☐
company_backgroundPage_leftMargin	int32		☐
company_backgroundPage_rightMargin	int32		☐
company_backgroundPage_topMargin	int32		☐
company_id	int64		☐
company_landscapeBackgroundPage_background_availableForWappy	boolean		☐
company_landscapeBackgroundPage_background_directory	boolean		☐
company_landscapeBackgroundPage_background_documentDate	datetime		☐
company_landscapeBackgroundPage_background_expirationDate	datetime		☐
company_landscapeBackgroundPage_background_filename	string		☐
company_landscapeBackgroundPage_background_fileSize	int64		☐
company_landscapeBackgroundPage_background_id	int64		☐
company_landscapeBackgroundPage_background_mimeType	string		☐
company_landscapeBackgroundPage_background_objectRef_objectId	int64		☐
company_landscapeBackgroundPage_background_objectRef_objectType	string		☐
company_landscapeBackgroundPage_background_parentId	int64		☐
company_landscapeBackgroundPage_background_path	string		☐
company_landscapeBackgroundPage_background_uuid	string		☐
company_landscapeBackgroundPage_background_version	int64		☐
company_landscapeBackgroundPage_background_wappy	boolean		☐
company_landscapeBackgroundPage_bottomMargin	int32		☐
company_landscapeBackgroundPage_leftMargin	int32		☐
company_landscapeBackgroundPage_rightMargin	int32		☐
company_landscapeBackgroundPage_topMargin	int32		☐
company_logo_availableForWappy	boolean		☐
company_logo_directory	boolean		☐
company_logo_documentDate	datetime		☐
company_logo_expirationDate	datetime		☐
company_logo_filename	string		☐
company_logo_fileSize	int64		☐
company_logo_id	int64		☐
company_logo_mimeType	string		☐
company_logo_objectRef_objectId	int64		☐
company_logo_objectRef_objectType	string		☐
company_logo_parentId	int64		☐
company_logo_path	string		☐
company_logo_uuid	string		☐
company_logo_version	int64		☐
company_logo_wappy	boolean		☐
company_name	string		☐
company_shortHand	string		☐
company_vat	string		☐
company_version	int64		☐
contactPerson_email	string		☐
contactPerson_fullName	string	Contact Person Full Name	☐
contactPerson_function	string		☐
contactPerson_gsm	string	Contact Person Mobile	☐
contactPerson_gsmOrTel	string		☐
contactPerson_id	int64	Contact Person ID	☐
contactPerson_name	string		☐
contactPerson_surname	string		☐
contactPerson_tel	string		☐
contactPerson_title	string		☐
contactPerson_version	int64		☐
contactPersonName	string	Contact Person Name	☐
contactPersonName_1	string		☐
conversion	double	Conversion	☐
conversion_1	double		☐
creditLimitDays	int32	Credit Limit Days	☐
creditLimitEnabled	boolean	Credit Limit Enabled	☐
creditLimitPercent	double	Credit Limit (%)	☐
credLimit	double	Credit Limit	☐
currencySymbol	string	Currency Symbol	☐
currencySymbol_1	string		☐
date	datetime	Date	☐
date_1	datetime		☐
dateValue	datetime	Date Value	☐
diary	string	Diary	☐
discount	double	Discount	☐
doubleValue	double	Double Value	☐
endClient_accountNr	string		☐
endClient_address_city	string		☐
endClient_address_country	string		☐
endClient_address_latLng_defined	boolean		☐
endClient_address_latLng_lat	double		☐
endClient_address_latLng_lng	double		☐
endClient_address_street	string		☐
endClient_address_streetBase	string		☐
endClient_address_streetExtra	string		☐
endClient_address_streetNumber	string		☐
endClient_address_zipcode	string		☐
endClient_addressString	string		☐
endClient_assignee_avatar_availableForWappy	boolean		☐
endClient_assignee_avatar_directory	boolean		☐
endClient_assignee_avatar_documentDate	datetime		☐
endClient_assignee_avatar_expirationDate	datetime		☐
endClient_assignee_avatar_filename	string		☐
endClient_assignee_avatar_fileSize	int64		☐
endClient_assignee_avatar_id	int64		☐
endClient_assignee_avatar_mimeType	string		☐
endClient_assignee_avatar_objectRef_objectId	int64		☐
endClient_assignee_avatar_objectRef_objectType	string		☐
endClient_assignee_avatar_parentId	int64		☐
endClient_assignee_avatar_path	string		☐
endClient_assignee_avatar_uuid	string		☐
endClient_assignee_avatar_version	int64		☐
endClient_assignee_avatar_wappy	boolean		☐
endClient_assignee_email	string		☐
endClient_assignee_emailAccount_emailAccountType	string		☐
endClient_assignee_emailAccount_emailBcc	string		☐
endClient_assignee_emailAccount_emailFrom	string		☐
endClient_assignee_emailAccount_emailFromName	string		☐
endClient_assignee_emailAccount_emailHost	string		☐
endClient_assignee_emailAccount_emailPass	string		☐
endClient_assignee_emailAccount_emailPort	string		☐
endClient_assignee_emailAccount_emailUser	string		☐
endClient_assignee_emailAccount_starttls	boolean		☐
endClient_assignee_emailAccount_uuid	string		☐
endClient_assignee_employee_address_city	string		☐
endClient_assignee_employee_address_country	string		☐
endClient_assignee_employee_address_latLng_defined	boolean		☐
endClient_assignee_employee_address_latLng_lat	double		☐
endClient_assignee_employee_address_latLng_lng	double		☐
endClient_assignee_employee_address_street	string		☐
endClient_assignee_employee_address_streetBase	string		☐
endClient_assignee_employee_address_streetExtra	string		☐
endClient_assignee_employee_address_streetNumber	string		☐
endClient_assignee_employee_address_zipcode	string		☐
endClient_assignee_employee_bankaccountNr	string		☐
endClient_assignee_employee_birthDate	datetime		☐
endClient_assignee_employee_civilStatus	string		☐
endClient_assignee_employee_competenceLevel	string		☐
endClient_assignee_employee_costPerHour	double		☐
endClient_assignee_employee_defaultMobility_id	int64		☐
endClient_assignee_employee_defaultMobility_name	string		☐
endClient_assignee_employee_defaultMobility_version	int64		☐
endClient_assignee_employee_defaultOperation_accountancyCode_code	string		☐
endClient_assignee_employee_defaultOperation_accountancyCode_externalId	string		☐
endClient_assignee_employee_defaultOperation_accountancyCode_id	int64		☐
endClient_assignee_employee_defaultOperation_accountancyCode_name	string		☐
endClient_assignee_employee_defaultOperation_accountancyCode_version	int64		☐
endClient_assignee_employee_defaultOperation_accountancyCodePurchase_code	string		☐
endClient_assignee_employee_defaultOperation_accountancyCodePurchase_externalId	string		☐
endClient_assignee_employee_defaultOperation_accountancyCodePurchase_id	int64		☐
endClient_assignee_employee_defaultOperation_accountancyCodePurchase_name	string		☐
endClient_assignee_employee_defaultOperation_accountancyCodePurchase_version	int64		☐
endClient_assignee_employee_defaultOperation_activity	string		☐
endClient_assignee_employee_defaultOperation_agreementType	string		☐
endClient_assignee_employee_defaultOperation_articleGroup_contextPath	string		☐
endClient_assignee_employee_defaultOperation_articleGroup_id	int64		☐
endClient_assignee_employee_defaultOperation_articleGroup_name	string		☐
endClient_assignee_employee_defaultOperation_articleGroup_version	int64		☐
endClient_assignee_employee_defaultOperation_articleNumber	string		☐
endClient_assignee_employee_defaultOperation_articleType	string		☐
endClient_assignee_employee_defaultOperation_barcode	string		☐
endClient_assignee_employee_defaultOperation_brand	string		☐
endClient_assignee_employee_defaultOperation_calc	boolean		☐
endClient_assignee_employee_defaultOperation_calcDescription	string		☐
endClient_assignee_employee_defaultOperation_calculationType	string		☐
endClient_assignee_employee_defaultOperation_chapter	string		☐
endClient_assignee_employee_defaultOperation_costPrice	double		☐
endClient_assignee_employee_defaultOperation_costPriceStrategy	string		☐
endClient_assignee_employee_defaultOperation_currencySymbol	string		☐
endClient_assignee_employee_defaultOperation_description	string		☐
endClient_assignee_employee_defaultOperation_deviantSalesName	string		☐
endClient_assignee_employee_defaultOperation_headerLevel	string		☐
endClient_assignee_employee_defaultOperation_id	int64		☐
endClient_assignee_employee_defaultOperation_indirectCostFactor	double		☐
endClient_assignee_employee_defaultOperation_internalPhoto	boolean		☐
endClient_assignee_employee_defaultOperation_lineType	string		☐
endClient_assignee_employee_defaultOperation_margin	double		☐
endClient_assignee_employee_defaultOperation_materialInstallation	boolean		☐
endClient_assignee_employee_defaultOperation_minimumSaleAmount	double		☐
endClient_assignee_employee_defaultOperation_minimumStockAmount	double		☐
endClient_assignee_employee_defaultOperation_name	string		☐
endClient_assignee_employee_defaultOperation_newPage	boolean		☐
endClient_assignee_employee_defaultOperation_photo_availableForWappy	boolean		☐
endClient_assignee_employee_defaultOperation_photo_directory	boolean		☐
endClient_assignee_employee_defaultOperation_photo_documentDate	datetime		☐
endClient_assignee_employee_defaultOperation_photo_expirationDate	datetime		☐
endClient_assignee_employee_defaultOperation_photo_filename	string		☐
endClient_assignee_employee_defaultOperation_photo_fileSize	int64		☐
endClient_assignee_employee_defaultOperation_photo_id	int64		☐
endClient_assignee_employee_defaultOperation_photo_mimeType	string		☐
endClient_assignee_employee_defaultOperation_photo_parentId	int64		☐
endClient_assignee_employee_defaultOperation_photo_path	string		☐
endClient_assignee_employee_defaultOperation_photo_uuid	string		☐
endClient_assignee_employee_defaultOperation_photo_version	int64		☐
endClient_assignee_employee_defaultOperation_photo_wappy	boolean		☐
endClient_assignee_employee_defaultOperation_saleName	string		☐
endClient_assignee_employee_defaultOperation_salePrice	double		☐
endClient_assignee_employee_defaultOperation_salePriceStrategy	string		☐
endClient_assignee_employee_defaultOperation_stockAmount	double		☐
endClient_assignee_employee_defaultOperation_stockChanges	string		☐
endClient_assignee_employee_defaultOperation_stockLocation	string		☐
endClient_assignee_employee_defaultOperation_supplierNames	string		☐
endClient_assignee_employee_defaultOperation_timeOperation	boolean		☐
endClient_assignee_employee_defaultOperation_unitType	string		☐
endClient_assignee_employee_defaultOperation_vatTarif	string		☐
endClient_assignee_employee_defaultOperation_version	int64		☐
endClient_assignee_employee_dependentChildren	int32		☐
endClient_assignee_employee_detachment	boolean		☐
endClient_assignee_employee_dimona	string		☐
endClient_assignee_employee_dimonaExpireDate	datetime		☐
endClient_assignee_employee_distance	double		☐
endClient_assignee_employee_documentRsz	int64		☐
endClient_assignee_employee_documentRszPayment	int64		☐
endClient_assignee_employee_documentRszValidTill	datetime		☐
endClient_assignee_employee_driverLicense	string		☐
endClient_assignee_employee_email	string		☐
endClient_assignee_employee_emergencyTel	string		☐
endClient_assignee_employee_employeeGone	datetime		☐
endClient_assignee_employee_employeeRole_id	int64		☐
endClient_assignee_employee_employeeRole_name	string		☐
endClient_assignee_employee_employeeRole_version	int64		☐
endClient_assignee_employee_employeeSince	datetime		☐
endClient_assignee_employee_employeeStatute	string		☐
endClient_assignee_employee_expireDateRszPayment	datetime		☐
endClient_assignee_employee_fullname	string		☐
endClient_assignee_employee_function	string		☐
endClient_assignee_employee_gender	string		☐
endClient_assignee_employee_grossSalary	double		☐
endClient_assignee_employee_gsm	string		☐
endClient_assignee_employee_gsmOrTel	string		☐
endClient_assignee_employee_id	int64		☐
endClient_assignee_employee_independentCertificate	boolean		☐
endClient_assignee_employee_independentConnection	boolean		☐
endClient_assignee_employee_insz	string		☐
endClient_assignee_employee_limosaExpireDate	datetime		☐
endClient_assignee_employee_limosaNr	string		☐
endClient_assignee_employee_name	string		☐
endClient_assignee_employee_nameAndState	string		☐
endClient_assignee_employee_nationality	string		☐
endClient_assignee_employee_objectDescription	string		☐
endClient_assignee_employee_passportExpireDate	datetime		☐
endClient_assignee_employee_passportNr	string		☐
endClient_assignee_employee_paymentRsz	boolean		☐
endClient_assignee_employee_planningGroup	string		☐
endClient_assignee_employee_startDate	datetime		☐
endClient_assignee_employee_status	string		☐
endClient_assignee_employee_subType	string		☐
endClient_assignee_employee_supplier_accountancyCodePurchase_code	string		☐
endClient_assignee_employee_supplier_accountancyCodePurchase_externalId	string		☐
endClient_assignee_employee_supplier_accountancyCodePurchase_id	int64		☐
endClient_assignee_employee_supplier_accountancyCodePurchase_name	string		☐
endClient_assignee_employee_supplier_accountancyCodePurchase_version	int64		☐
endClient_assignee_employee_supplier_accountNr	string		☐
endClient_assignee_employee_supplier_addressString	string		☐
endClient_assignee_employee_supplier_bank	string		☐
endClient_assignee_employee_supplier_btwNumber	string		☐
endClient_assignee_employee_supplier_currencySymbol	string		☐
endClient_assignee_employee_supplier_email	string		☐
endClient_assignee_employee_supplier_externalId	string		☐
endClient_assignee_employee_supplier_fax	string		☐
endClient_assignee_employee_supplier_gsm	string		☐
endClient_assignee_employee_supplier_id	int64		☐
endClient_assignee_employee_supplier_invoiceAddress_city	string		☐
endClient_assignee_employee_supplier_invoiceAddress_country	string		☐
endClient_assignee_employee_supplier_invoiceAddress_street	string		☐
endClient_assignee_employee_supplier_invoiceAddress_streetBase	string		☐
endClient_assignee_employee_supplier_invoiceAddress_streetExtra	string		☐
endClient_assignee_employee_supplier_invoiceAddress_streetNumber	string		☐
endClient_assignee_employee_supplier_invoiceAddress_zipcode	string		☐
endClient_assignee_employee_supplier_invoiceRemarks	string		☐
endClient_assignee_employee_supplier_language	string		☐
endClient_assignee_employee_supplier_legalForm_hasVat	boolean		☐
endClient_assignee_employee_supplier_legalForm_id	int64		☐
endClient_assignee_employee_supplier_legalForm_name	string		☐
endClient_assignee_employee_supplier_legalForm_pdfName	string		☐
endClient_assignee_employee_supplier_legalForm_version	int64		☐
endClient_assignee_employee_supplier_legalName	string		☐
endClient_assignee_employee_supplier_logicId	string		☐
endClient_assignee_employee_supplier_name	string		☐
endClient_assignee_employee_supplier_planningEmail	string		☐
endClient_assignee_employee_supplier_status	string		☐
endClient_assignee_employee_supplier_supplyOrderRemarks	string		☐
endClient_assignee_employee_supplier_tel	string		☐
endClient_assignee_employee_supplier_vat_ublSchemeId	string		☐
endClient_assignee_employee_supplier_vat_vatCode	string		☐
endClient_assignee_employee_supplier_vat_vatCountry	string		☐
endClient_assignee_employee_supplier_vat_vatValid	boolean		☐
endClient_assignee_employee_supplier_vatNr	string		☐
endClient_assignee_employee_supplier_vatTarif	string		☐
endClient_assignee_employee_supplier_version	int64		☐
endClient_assignee_employee_supplier_website	string		☐
endClient_assignee_employee_supplierName	string		☐
endClient_assignee_employee_surname	string		☐
endClient_assignee_employee_tel	string		☐
endClient_assignee_employee_type	string		☐
endClient_assignee_employee_version	int64		☐
endClient_assignee_employeeId	int64		☐
endClient_assignee_fullname	string		☐
endClient_assignee_id	int64		☐
endClient_assignee_schema	string		☐
endClient_assignee_signature	string		☐
endClient_assignee_useEmailAccount	boolean		☐
endClient_assignee_username	string		☐
endClient_assignee_userRole_id	int64		☐
endClient_assignee_userRole_name	string		☐
endClient_assignee_userRole_version	int64		☐
endClient_assignee_userRoleString	string		☐
endClient_assignee_version	int64		☐
endClient_assigneeName	string		☐
endClient_bank	string		☐
endClient_contactMedium	string		☐
endClient_creditDate	datetime		☐
endClient_creditInfo	string		☐
endClient_creditLimit	double		☐
endClient_creditStatus	string		☐
endClient_currencySymbol	string		☐
endClient_email	string		☐
endClient_emailPermissionDate	datetime		☐
endClient_emailPermissionFrom	string		☐
endClient_expireDate_expireDatePeriodType	string		☐
endClient_expireDate_id	int64		☐
endClient_expireDate_name	string		☐
endClient_expireDate_plusDays	int32		☐
endClient_expireDate_version	int64		☐
endClient_externalId	string		☐
endClient_fax	string		☐
endClient_finalAddress_city	string		☐
endClient_finalAddress_country	string		☐
endClient_finalAddress_latLng_defined	boolean		☐
endClient_finalAddress_latLng_lat	double		☐
endClient_finalAddress_latLng_lng	double		☐
endClient_finalAddress_street	string		☐
endClient_finalAddress_streetBase	string		☐
endClient_finalAddress_streetExtra	string		☐
endClient_finalAddress_streetNumber	string		☐
endClient_finalAddress_zipcode	string		☐
endClient_followUpDate	datetime		☐
endClient_gsm	string		☐
endClient_id	int64		☐
endClient_invoiceAddress_city	string		☐
endClient_invoiceAddress_country	string		☐
endClient_invoiceAddress_latLng_defined	boolean		☐
endClient_invoiceAddress_latLng_lat	double		☐
endClient_invoiceAddress_latLng_lng	double		☐
endClient_invoiceAddress_street	string		☐
endClient_invoiceAddress_streetBase	string		☐
endClient_invoiceAddress_streetExtra	string		☐
endClient_invoiceAddress_streetNumber	string		☐
endClient_invoiceAddress_zipcode	string		☐
endClient_invoiceEmail	string		☐
endClient_invoiceRemarks	string		☐
endClient_language	string		☐
endClient_legalForm_hasVat	boolean		☐
endClient_legalForm_id	int64		☐
endClient_legalForm_name	string		☐
endClient_legalForm_pdfName	string		☐
endClient_legalForm_version	int64		☐
endClient_legalName	string		☐
endClient_logicId	string		☐
endClient_name	string		☐
endClient_priceGroup_id	int64		☐
endClient_priceGroup_name	string		☐
endClient_priceGroup_version	int64		☐
endClient_seperateInvoicePage	boolean		☐
endClient_status	string		☐
endClient_tel	string		☐
endClient_title	string		☐
endClient_useInvoiceAddress	boolean		☐
endClient_usePeppol	boolean		☐
endClient_vat_ublSchemeId	string		☐
endClient_vat_vatCode	string		☐
endClient_vat_vatCountry	string		☐
endClient_vat_vatValid	boolean		☐
endClient_vatNr	string		☐
endClient_vatTarif	string		☐
endClient_version	int64		☐
endClient_website	string		☐
endClient_withRespectTo	string		☐
endClientContactPerson_email	string		☐
endClientContactPerson_fullName	string		☐
endClientContactPerson_function	string		☐
endClientContactPerson_gsm	string		☐
endClientContactPerson_gsmOrTel	string		☐
endClientContactPerson_id	int64		☐
endClientContactPerson_name	string		☐
endClientContactPerson_surname	string		☐
endClientContactPerson_tel	string		☐
endClientContactPerson_title	string		☐
endClientContactPerson_version	int64		☐
endClientContactPersonName	string		☐
endClientName	string	End Client Name	☐
expireDate	datetime	Expiry Date	☐
finalPayment	boolean	Final Payment	☐
financialDiscountDays	int32	Financial Discount (days)	☐
financialDiscountEnabled	boolean	Financial Discount Enabled	☐
financialDiscountPercent	double	Financial Discount (%)	☐
id	int64	ID	☐
id_1	int64		☐
id_2	int64		☐
integerValue	int32	Integer Value	☐
invoiceType	string	Invoice Type	☐
logicId	string	Logical ID	☐
logicId_1	string		☐
openTotal	double	Open Total	☐
orderNr	int64	Order Number	☐
paidOn	datetime	Paid on	☐
paidTotal	double	Paid Total	☐
paymentInstructionId	string		☐
peppolSentDate	datetime		☐
poNumber	string	PO Number	☐
project_addressString	string		☐
project_checkInAtWork	string		☐
project_client_accountNr	string		☐
project_client_address_city	string		☐
project_client_address_country	string		☐
project_client_address_latLng_defined	boolean		☐
project_client_address_latLng_lat	double		☐
project_client_address_latLng_lng	double		☐
project_client_address_street	string		☐
project_client_address_streetBase	string		☐
project_client_address_streetExtra	string		☐
project_client_address_streetNumber	string		☐
project_client_address_zipcode	string		☐
project_client_addressString	string		☐
project_client_assignee_avatar_availableForWappy	boolean		☐
project_client_assignee_avatar_directory	boolean		☐
project_client_assignee_avatar_documentDate	datetime		☐
project_client_assignee_avatar_expirationDate	datetime		☐
project_client_assignee_avatar_filename	string		☐
project_client_assignee_avatar_fileSize	int64		☐
project_client_assignee_avatar_id	int64		☐
project_client_assignee_avatar_mimeType	string		☐
project_client_assignee_avatar_objectRef_objectId	int64		☐
project_client_assignee_avatar_objectRef_objectType	string		☐
project_client_assignee_avatar_parentId	int64		☐
project_client_assignee_avatar_path	string		☐
project_client_assignee_avatar_uuid	string		☐
project_client_assignee_avatar_version	int64		☐
project_client_assignee_avatar_wappy	boolean		☐
project_client_assignee_email	string		☐
project_client_assignee_emailAccount_emailAccountType	string		☐
project_client_assignee_emailAccount_emailBcc	string		☐
project_client_assignee_emailAccount_emailFrom	string		☐
project_client_assignee_emailAccount_emailFromName	string		☐
project_client_assignee_emailAccount_emailHost	string		☐
project_client_assignee_emailAccount_emailPass	string		☐
project_client_assignee_emailAccount_emailPort	string		☐
project_client_assignee_emailAccount_emailUser	string		☐
project_client_assignee_emailAccount_starttls	boolean		☐
project_client_assignee_emailAccount_uuid	string		☐
project_client_assignee_employee_address_city	string		☐
project_client_assignee_employee_address_country	string		☐
project_client_assignee_employee_address_street	string		☐
project_client_assignee_employee_address_streetBase	string		☐
project_client_assignee_employee_address_streetExtra	string		☐
project_client_assignee_employee_address_streetNumber	string		☐
project_client_assignee_employee_address_zipcode	string		☐
project_client_assignee_employee_bankaccountNr	string		☐
project_client_assignee_employee_birthDate	datetime		☐
project_client_assignee_employee_civilStatus	string		☐
project_client_assignee_employee_competenceLevel	string		☐
project_client_assignee_employee_costPerHour	double		☐
project_client_assignee_employee_defaultMobility_id	int64		☐
project_client_assignee_employee_defaultMobility_name	string		☐
project_client_assignee_employee_defaultMobility_version	int64		☐
project_client_assignee_employee_defaultOperation_activity	string		☐
project_client_assignee_employee_defaultOperation_agreementType	string		☐
project_client_assignee_employee_defaultOperation_articleNumber	string		☐
project_client_assignee_employee_defaultOperation_articleType	string		☐
project_client_assignee_employee_defaultOperation_barcode	string		☐
project_client_assignee_employee_defaultOperation_brand	string		☐
project_client_assignee_employee_defaultOperation_calc	boolean		☐
project_client_assignee_employee_defaultOperation_calcDescription	string		☐
project_client_assignee_employee_defaultOperation_calculationType	string		☐
project_client_assignee_employee_defaultOperation_chapter	string		☐
project_client_assignee_employee_defaultOperation_costPrice	double		☐
project_client_assignee_employee_defaultOperation_costPriceStrategy	string		☐
project_client_assignee_employee_defaultOperation_currencySymbol	string		☐
project_client_assignee_employee_defaultOperation_description	string		☐
project_client_assignee_employee_defaultOperation_deviantSalesName	string		☐
project_client_assignee_employee_defaultOperation_headerLevel	string		☐
project_client_assignee_employee_defaultOperation_id	int64		☐
project_client_assignee_employee_defaultOperation_indirectCostFactor	double		☐
project_client_assignee_employee_defaultOperation_internalPhoto	boolean		☐
project_client_assignee_employee_defaultOperation_lineType	string		☐
project_client_assignee_employee_defaultOperation_margin	double		☐
project_client_assignee_employee_defaultOperation_materialInstallation	boolean		☐
project_client_assignee_employee_defaultOperation_minimumSaleAmount	double		☐
project_client_assignee_employee_defaultOperation_minimumStockAmount	double		☐
project_client_assignee_employee_defaultOperation_name	string		☐
project_client_assignee_employee_defaultOperation_newPage	boolean		☐
project_client_assignee_employee_defaultOperation_saleName	string		☐
project_client_assignee_employee_defaultOperation_salePrice	double		☐
project_client_assignee_employee_defaultOperation_salePriceStrategy	string		☐
project_client_assignee_employee_defaultOperation_stockAmount	double		☐
project_client_assignee_employee_defaultOperation_stockChanges	string		☐
project_client_assignee_employee_defaultOperation_stockLocation	string		☐
project_client_assignee_employee_defaultOperation_supplierNames	string		☐
project_client_assignee_employee_defaultOperation_timeOperation	boolean		☐
project_client_assignee_employee_defaultOperation_unitType	string		☐
project_client_assignee_employee_defaultOperation_vatTarif	string		☐
project_client_assignee_employee_defaultOperation_version	int64		☐
project_client_assignee_employee_dependentChildren	int32		☐
project_client_assignee_employee_detachment	boolean		☐
project_client_assignee_employee_dimona	string		☐
project_client_assignee_employee_dimonaExpireDate	datetime		☐
project_client_assignee_employee_distance	double		☐
project_client_assignee_employee_documentRsz	int64		☐
project_client_assignee_employee_documentRszPayment	int64		☐
project_client_assignee_employee_documentRszValidTill	datetime		☐
project_client_assignee_employee_driverLicense	string		☐
project_client_assignee_employee_email	string		☐
project_client_assignee_employee_emergencyTel	string		☐
project_client_assignee_employee_employeeGone	datetime		☐
project_client_assignee_employee_employeeRole_id	int64		☐
project_client_assignee_employee_employeeRole_name	string		☐
project_client_assignee_employee_employeeRole_version	int64		☐
project_client_assignee_employee_employeeSince	datetime		☐
project_client_assignee_employee_employeeStatute	string		☐
project_client_assignee_employee_expireDateRszPayment	datetime		☐
project_client_assignee_employee_fullname	string		☐
project_client_assignee_employee_function	string		☐
project_client_assignee_employee_gender	string		☐
project_client_assignee_employee_grossSalary	double		☐
project_client_assignee_employee_gsm	string		☐
project_client_assignee_employee_gsmOrTel	string		☐
project_client_assignee_employee_id	int64		☐
project_client_assignee_employee_independentCertificate	boolean		☐
project_client_assignee_employee_independentConnection	boolean		☐
project_client_assignee_employee_insz	string		☐
project_client_assignee_employee_limosaExpireDate	datetime		☐
project_client_assignee_employee_limosaNr	string		☐
project_client_assignee_employee_name	string		☐
project_client_assignee_employee_nameAndState	string		☐
project_client_assignee_employee_nationality	string		☐
project_client_assignee_employee_objectDescription	string		☐
project_client_assignee_employee_passportExpireDate	datetime		☐
project_client_assignee_employee_passportNr	string		☐
project_client_assignee_employee_paymentRsz	boolean		☐
project_client_assignee_employee_planningGroup	string		☐
project_client_assignee_employee_startDate	datetime		☐
project_client_assignee_employee_status	string		☐
project_client_assignee_employee_subType	string		☐
project_client_assignee_employee_supplier_accountNr	string		☐
project_client_assignee_employee_supplier_addressString	string		☐
project_client_assignee_employee_supplier_bank	string		☐
project_client_assignee_employee_supplier_btwNumber	string		☐
project_client_assignee_employee_supplier_currencySymbol	string		☐
project_client_assignee_employee_supplier_email	string		☐
project_client_assignee_employee_supplier_externalId	string		☐
project_client_assignee_employee_supplier_fax	string		☐
project_client_assignee_employee_supplier_gsm	string		☐
project_client_assignee_employee_supplier_id	int64		☐
project_client_assignee_employee_supplier_invoiceRemarks	string		☐
project_client_assignee_employee_supplier_language	string		☐
project_client_assignee_employee_supplier_legalName	string		☐
project_client_assignee_employee_supplier_logicId	string		☐
project_client_assignee_employee_supplier_name	string		☐
project_client_assignee_employee_supplier_planningEmail	string		☐
project_client_assignee_employee_supplier_status	string		☐
project_client_assignee_employee_supplier_supplyOrderRemarks	string		☐
project_client_assignee_employee_supplier_tel	string		☐
project_client_assignee_employee_supplier_vatNr	string		☐
project_client_assignee_employee_supplier_vatTarif	string		☐
project_client_assignee_employee_supplier_version	int64		☐
project_client_assignee_employee_supplier_website	string		☐
project_client_assignee_employee_supplierName	string		☐
project_client_assignee_employee_surname	string		☐
project_client_assignee_employee_tel	string		☐
project_client_assignee_employee_type	string		☐
project_client_assignee_employee_version	int64		☐
project_client_assignee_employeeId	int64		☐
project_client_assignee_fullname	string		☐
project_client_assignee_id	int64		☐
project_client_assignee_schema	string		☐
project_client_assignee_signature	string		☐
project_client_assignee_useEmailAccount	boolean		☐
project_client_assignee_username	string		☐
project_client_assignee_userRole_id	int64		☐
project_client_assignee_userRole_name	string		☐
project_client_assignee_userRole_version	int64		☐
project_client_assignee_userRoleString	string		☐
project_client_assignee_version	int64		☐
project_client_assigneeName	string		☐
project_client_bank	string		☐
project_client_contactMedium	string		☐
project_client_creditDate	datetime		☐
project_client_creditInfo	string		☐
project_client_creditLimit	double		☐
project_client_creditStatus	string		☐
project_client_currencySymbol	string		☐
project_client_email	string		☐
project_client_emailPermissionDate	datetime		☐
project_client_emailPermissionFrom	string		☐
project_client_expireDate_expireDatePeriodType	string		☐
project_client_expireDate_id	int64		☐
project_client_expireDate_name	string		☐
project_client_expireDate_plusDays	int32		☐
project_client_expireDate_version	int64		☐
project_client_externalId	string		☐
project_client_fax	string		☐
project_client_finalAddress_city	string		☐
project_client_finalAddress_country	string		☐
project_client_finalAddress_latLng_defined	boolean		☐
project_client_finalAddress_latLng_lat	double		☐
project_client_finalAddress_latLng_lng	double		☐
project_client_finalAddress_street	string		☐
project_client_finalAddress_streetBase	string		☐
project_client_finalAddress_streetExtra	string		☐
project_client_finalAddress_streetNumber	string		☐
project_client_finalAddress_zipcode	string		☐
project_client_followUpDate	datetime		☐
project_client_gsm	string		☐
project_client_id	int64		☐
project_client_invoiceAddress_city	string		☐
project_client_invoiceAddress_country	string		☐
project_client_invoiceAddress_latLng_defined	boolean		☐
project_client_invoiceAddress_latLng_lat	double		☐
project_client_invoiceAddress_latLng_lng	double		☐
project_client_invoiceAddress_street	string		☐
project_client_invoiceAddress_streetBase	string		☐
project_client_invoiceAddress_streetExtra	string		☐
project_client_invoiceAddress_streetNumber	string		☐
project_client_invoiceAddress_zipcode	string		☐
project_client_invoiceEmail	string		☐
project_client_invoiceRemarks	string		☐
project_client_language	string		☐
project_client_legalForm_hasVat	boolean		☐
project_client_legalForm_id	int64		☐
project_client_legalForm_name	string		☐
project_client_legalForm_pdfName	string		☐
project_client_legalForm_version	int64		☐
project_client_legalName	string		☐
project_client_logicId	string		☐
project_client_name	string		☐
project_client_priceGroup_id	int64		☐
project_client_priceGroup_name	string		☐
project_client_priceGroup_version	int64		☐
project_client_seperateInvoicePage	boolean		☐
project_client_status	string		☐
project_client_tel	string		☐
project_client_title	string		☐
project_client_useInvoiceAddress	boolean		☐
project_client_usePeppol	boolean		☐
project_client_vat_ublSchemeId	string		☐
project_client_vat_vatCode	string		☐
project_client_vat_vatCountry	string		☐
project_client_vat_vatValid	boolean		☐
project_client_vatNr	string		☐
project_client_vatTarif	string		☐
project_client_version	int64		☐
project_client_website	string		☐
project_client_withRespectTo	string		☐
project_clientMail	string		☐
project_clientName	string		☐
project_clientReference	string		☐
project_clientTel	string		☐
project_company_address_city	string		☐
project_company_address_country	string		☐
project_company_address_latLng_defined	boolean		☐
project_company_address_latLng_lat	double		☐
project_company_address_latLng_lng	double		☐
project_company_address_street	string		☐
project_company_address_streetBase	string		☐
project_company_address_streetExtra	string		☐
project_company_address_streetNumber	string		☐
project_company_address_zipcode	string		☐
project_company_addressString	string		☐
project_company_backgroundPage_background_availableForWappy	boolean		☐
project_company_backgroundPage_background_directory	boolean		☐
project_company_backgroundPage_background_documentDate	datetime		☐
project_company_backgroundPage_background_expirationDate	datetime		☐
project_company_backgroundPage_background_filename	string		☐
project_company_backgroundPage_background_fileSize	int64		☐
project_company_backgroundPage_background_id	int64		☐
project_company_backgroundPage_background_mimeType	string		☐
project_company_backgroundPage_background_objectRef_objectId	int64		☐
project_company_backgroundPage_background_objectRef_objectType	string		☐
project_company_backgroundPage_background_parentId	int64		☐
project_company_backgroundPage_background_path	string		☐
project_company_backgroundPage_background_uuid	string		☐
project_company_backgroundPage_background_version	int64		☐
project_company_backgroundPage_background_wappy	boolean		☐
project_company_backgroundPage_bottomMargin	int32		☐
project_company_backgroundPage_leftMargin	int32		☐
project_company_backgroundPage_rightMargin	int32		☐
project_company_backgroundPage_topMargin	int32		☐
project_company_id	int64		☐
project_company_landscapeBackgroundPage_background_availableForWappy	boolean		☐
project_company_landscapeBackgroundPage_background_directory	boolean		☐
project_company_landscapeBackgroundPage_background_documentDate	datetime		☐
project_company_landscapeBackgroundPage_background_expirationDate	datetime		☐
project_company_landscapeBackgroundPage_background_filename	string		☐
project_company_landscapeBackgroundPage_background_fileSize	int64		☐
project_company_landscapeBackgroundPage_background_id	int64		☐
project_company_landscapeBackgroundPage_background_mimeType	string		☐
project_company_landscapeBackgroundPage_background_objectRef_objectId	int64		☐
project_company_landscapeBackgroundPage_background_objectRef_objectType	string		☐
project_company_landscapeBackgroundPage_background_parentId	int64		☐
project_company_landscapeBackgroundPage_background_path	string		☐
project_company_landscapeBackgroundPage_background_uuid	string		☐
project_company_landscapeBackgroundPage_background_version	int64		☐
project_company_landscapeBackgroundPage_background_wappy	boolean		☐
project_company_landscapeBackgroundPage_bottomMargin	int32		☐
project_company_landscapeBackgroundPage_leftMargin	int32		☐
project_company_landscapeBackgroundPage_rightMargin	int32		☐
project_company_landscapeBackgroundPage_topMargin	int32		☐
project_company_logo_availableForWappy	boolean		☐
project_company_logo_directory	boolean		☐
project_company_logo_documentDate	datetime		☐
project_company_logo_expirationDate	datetime		☐
project_company_logo_filename	string		☐
project_company_logo_fileSize	int64		☐
project_company_logo_id	int64		☐
project_company_logo_mimeType	string		☐
project_company_logo_objectRef_objectId	int64		☐
project_company_logo_objectRef_objectType	string		☐
project_company_logo_parentId	int64		☐
project_company_logo_path	string		☐
project_company_logo_uuid	string		☐
project_company_logo_version	int64		☐
project_company_logo_wappy	boolean		☐
project_company_name	string		☐
project_company_shortHand	string		☐
project_company_vat	string		☐
project_company_version	int64		☐
project_contactPerson_email	string		☐
project_contactPerson_fullName	string		☐
project_contactPerson_function	string		☐
project_contactPerson_gsm	string		☐
project_contactPerson_gsmOrTel	string		☐
project_contactPerson_id	int64		☐
project_contactPerson_name	string		☐
project_contactPerson_surname	string		☐
project_contactPerson_tel	string		☐
project_contactPerson_title	string		☐
project_contactPerson_version	int64		☐
project_contactPersonMail	string		☐
project_contactPersonName	string		☐
project_contactPersonTel	string		☐
project_date	datetime		☐
project_endClient_accountNr	string		☐
project_endClient_address_city	string		☐
project_endClient_address_country	string		☐
project_endClient_address_latLng_defined	boolean		☐
project_endClient_address_latLng_lat	double		☐
project_endClient_address_latLng_lng	double		☐
project_endClient_address_street	string		☐
project_endClient_address_streetBase	string		☐
project_endClient_address_streetExtra	string		☐
project_endClient_address_streetNumber	string		☐
project_endClient_address_zipcode	string		☐
project_endClient_addressString	string		☐
project_endClient_assignee_avatar_availableForWappy	boolean		☐
project_endClient_assignee_avatar_directory	boolean		☐
project_endClient_assignee_avatar_documentDate	datetime		☐
project_endClient_assignee_avatar_expirationDate	datetime		☐
project_endClient_assignee_avatar_filename	string		☐
project_endClient_assignee_avatar_fileSize	int64		☐
project_endClient_assignee_avatar_id	int64		☐
project_endClient_assignee_avatar_mimeType	string		☐
project_endClient_assignee_avatar_objectRef_objectId	int64		☐
project_endClient_assignee_avatar_objectRef_objectType	string		☐
project_endClient_assignee_avatar_parentId	int64		☐
project_endClient_assignee_avatar_path	string		☐
project_endClient_assignee_avatar_uuid	string		☐
project_endClient_assignee_avatar_version	int64		☐
project_endClient_assignee_avatar_wappy	boolean		☐
project_endClient_assignee_email	string		☐
project_endClient_assignee_emailAccount_emailAccountType	string		☐
project_endClient_assignee_emailAccount_emailBcc	string		☐
project_endClient_assignee_emailAccount_emailFrom	string		☐
project_endClient_assignee_emailAccount_emailFromName	string		☐
project_endClient_assignee_emailAccount_emailHost	string		☐
project_endClient_assignee_emailAccount_emailPass	string		☐
project_endClient_assignee_emailAccount_emailPort	string		☐
project_endClient_assignee_emailAccount_emailUser	string		☐
project_endClient_assignee_emailAccount_starttls	boolean		☐
project_endClient_assignee_emailAccount_uuid	string		☐
project_endClient_assignee_employee_address_city	string		☐
project_endClient_assignee_employee_address_country	string		☐
project_endClient_assignee_employee_address_street	string		☐
project_endClient_assignee_employee_address_streetBase	string		☐
project_endClient_assignee_employee_address_streetExtra	string		☐
project_endClient_assignee_employee_address_streetNumber	string		☐
project_endClient_assignee_employee_address_zipcode	string		☐
project_endClient_assignee_employee_bankaccountNr	string		☐
project_endClient_assignee_employee_birthDate	datetime		☐
project_endClient_assignee_employee_civilStatus	string		☐
project_endClient_assignee_employee_competenceLevel	string		☐
project_endClient_assignee_employee_costPerHour	double		☐
project_endClient_assignee_employee_defaultMobility_id	int64		☐
project_endClient_assignee_employee_defaultMobility_name	string		☐
project_endClient_assignee_employee_defaultMobility_version	int64		☐
project_endClient_assignee_employee_defaultOperation_activity	string		☐
project_endClient_assignee_employee_defaultOperation_agreementType	string		☐
project_endClient_assignee_employee_defaultOperation_articleNumber	string		☐
project_endClient_assignee_employee_defaultOperation_articleType	string		☐
project_endClient_assignee_employee_defaultOperation_barcode	string		☐
project_endClient_assignee_employee_defaultOperation_brand	string		☐
project_endClient_assignee_employee_defaultOperation_calc	boolean		☐
project_endClient_assignee_employee_defaultOperation_calcDescription	string		☐
project_endClient_assignee_employee_defaultOperation_calculationType	string		☐
project_endClient_assignee_employee_defaultOperation_chapter	string		☐
project_endClient_assignee_employee_defaultOperation_costPrice	double		☐
project_endClient_assignee_employee_defaultOperation_costPriceStrategy	string		☐
project_endClient_assignee_employee_defaultOperation_currencySymbol	string		☐
project_endClient_assignee_employee_defaultOperation_description	string		☐
project_endClient_assignee_employee_defaultOperation_deviantSalesName	string		☐
project_endClient_assignee_employee_defaultOperation_headerLevel	string		☐
project_endClient_assignee_employee_defaultOperation_id	int64		☐
project_endClient_assignee_employee_defaultOperation_indirectCostFactor	double		☐
project_endClient_assignee_employee_defaultOperation_internalPhoto	boolean		☐
project_endClient_assignee_employee_defaultOperation_lineType	string		☐
project_endClient_assignee_employee_defaultOperation_margin	double		☐
project_endClient_assignee_employee_defaultOperation_materialInstallation	boolean		☐
project_endClient_assignee_employee_defaultOperation_minimumSaleAmount	double		☐
project_endClient_assignee_employee_defaultOperation_minimumStockAmount	double		☐
project_endClient_assignee_employee_defaultOperation_name	string		☐
project_endClient_assignee_employee_defaultOperation_newPage	boolean		☐
project_endClient_assignee_employee_defaultOperation_saleName	string		☐
project_endClient_assignee_employee_defaultOperation_salePrice	double		☐
project_endClient_assignee_employee_defaultOperation_salePriceStrategy	string		☐
project_endClient_assignee_employee_defaultOperation_stockAmount	double		☐
project_endClient_assignee_employee_defaultOperation_stockChanges	string		☐
project_endClient_assignee_employee_defaultOperation_stockLocation	string		☐
project_endClient_assignee_employee_defaultOperation_supplierNames	string		☐
project_endClient_assignee_employee_defaultOperation_timeOperation	boolean		☐
project_endClient_assignee_employee_defaultOperation_unitType	string		☐
project_endClient_assignee_employee_defaultOperation_vatTarif	string		☐
project_endClient_assignee_employee_defaultOperation_version	int64		☐
project_endClient_assignee_employee_dependentChildren	int32		☐
project_endClient_assignee_employee_detachment	boolean		☐
project_endClient_assignee_employee_dimona	string		☐
project_endClient_assignee_employee_dimonaExpireDate	datetime		☐
project_endClient_assignee_employee_distance	double		☐
project_endClient_assignee_employee_documentRsz	int64		☐
project_endClient_assignee_employee_documentRszPayment	int64		☐
project_endClient_assignee_employee_documentRszValidTill	datetime		☐
project_endClient_assignee_employee_driverLicense	string		☐
project_endClient_assignee_employee_email	string		☐
project_endClient_assignee_employee_emergencyTel	string		☐
project_endClient_assignee_employee_employeeGone	datetime		☐
project_endClient_assignee_employee_employeeRole_id	int64		☐
project_endClient_assignee_employee_employeeRole_name	string		☐
project_endClient_assignee_employee_employeeRole_version	int64		☐
project_endClient_assignee_employee_employeeSince	datetime		☐
project_endClient_assignee_employee_employeeStatute	string		☐
project_endClient_assignee_employee_expireDateRszPayment	datetime		☐
project_endClient_assignee_employee_fullname	string		☐
project_endClient_assignee_employee_function	string		☐
project_endClient_assignee_employee_gender	string		☐
project_endClient_assignee_employee_grossSalary	double		☐
project_endClient_assignee_employee_gsm	string		☐
project_endClient_assignee_employee_gsmOrTel	string		☐
project_endClient_assignee_employee_id	int64		☐
project_endClient_assignee_employee_independentCertificate	boolean		☐
project_endClient_assignee_employee_independentConnection	boolean		☐
project_endClient_assignee_employee_insz	string		☐
project_endClient_assignee_employee_limosaExpireDate	datetime		☐
project_endClient_assignee_employee_limosaNr	string		☐
project_endClient_assignee_employee_name	string		☐
project_endClient_assignee_employee_nameAndState	string		☐
project_endClient_assignee_employee_nationality	string		☐
project_endClient_assignee_employee_objectDescription	string		☐
project_endClient_assignee_employee_passportExpireDate	datetime		☐
project_endClient_assignee_employee_passportNr	string		☐
project_endClient_assignee_employee_paymentRsz	boolean		☐
project_endClient_assignee_employee_planningGroup	string		☐
project_endClient_assignee_employee_startDate	datetime		☐
project_endClient_assignee_employee_status	string		☐
project_endClient_assignee_employee_subType	string		☐
project_endClient_assignee_employee_supplier_accountNr	string		☐
project_endClient_assignee_employee_supplier_addressString	string		☐
project_endClient_assignee_employee_supplier_bank	string		☐
project_endClient_assignee_employee_supplier_btwNumber	string		☐
project_endClient_assignee_employee_supplier_currencySymbol	string		☐
project_endClient_assignee_employee_supplier_email	string		☐
project_endClient_assignee_employee_supplier_externalId	string		☐
project_endClient_assignee_employee_supplier_fax	string		☐
project_endClient_assignee_employee_supplier_gsm	string		☐
project_endClient_assignee_employee_supplier_id	int64		☐
project_endClient_assignee_employee_supplier_invoiceRemarks	string		☐
project_endClient_assignee_employee_supplier_language	string		☐
project_endClient_assignee_employee_supplier_legalName	string		☐
project_endClient_assignee_employee_supplier_logicId	string		☐
project_endClient_assignee_employee_supplier_name	string		☐
project_endClient_assignee_employee_supplier_planningEmail	string		☐
project_endClient_assignee_employee_supplier_status	string		☐
project_endClient_assignee_employee_supplier_supplyOrderRemarks	string		☐
project_endClient_assignee_employee_supplier_tel	string		☐
project_endClient_assignee_employee_supplier_vatNr	string		☐
project_endClient_assignee_employee_supplier_vatTarif	string		☐
project_endClient_assignee_employee_supplier_version	int64		☐
project_endClient_assignee_employee_supplier_website	string		☐
project_endClient_assignee_employee_supplierName	string		☐
project_endClient_assignee_employee_surname	string		☐
project_endClient_assignee_employee_tel	string		☐
project_endClient_assignee_employee_type	string		☐
project_endClient_assignee_employee_version	int64		☐
project_endClient_assignee_employeeId	int64		☐
project_endClient_assignee_fullname	string		☐
project_endClient_assignee_id	int64		☐
project_endClient_assignee_schema	string		☐
project_endClient_assignee_signature	string		☐
project_endClient_assignee_useEmailAccount	boolean		☐
project_endClient_assignee_username	string		☐
project_endClient_assignee_userRole_id	int64		☐
project_endClient_assignee_userRole_name	string		☐
project_endClient_assignee_userRole_version	int64		☐
project_endClient_assignee_userRoleString	string		☐
project_endClient_assignee_version	int64		☐
project_endClient_assigneeName	string		☐
project_endClient_bank	string		☐
project_endClient_contactMedium	string		☐
project_endClient_creditDate	datetime		☐
project_endClient_creditInfo	string		☐
project_endClient_creditLimit	double		☐
project_endClient_creditStatus	string		☐
project_endClient_currencySymbol	string		☐
project_endClient_email	string		☐
project_endClient_emailPermissionDate	datetime		☐
project_endClient_emailPermissionFrom	string		☐
project_endClient_expireDate_expireDatePeriodType	string		☐
project_endClient_expireDate_id	int64		☐
project_endClient_expireDate_name	string		☐
project_endClient_expireDate_plusDays	int32		☐
project_endClient_expireDate_version	int64		☐
project_endClient_externalId	string		☐
project_endClient_fax	string		☐
project_endClient_finalAddress_city	string		☐
project_endClient_finalAddress_country	string		☐
project_endClient_finalAddress_latLng_defined	boolean		☐
project_endClient_finalAddress_latLng_lat	double		☐
project_endClient_finalAddress_latLng_lng	double		☐
project_endClient_finalAddress_street	string		☐
project_endClient_finalAddress_streetBase	string		☐
project_endClient_finalAddress_streetExtra	string		☐
project_endClient_finalAddress_streetNumber	string		☐
project_endClient_finalAddress_zipcode	string		☐
project_endClient_followUpDate	datetime		☐
project_endClient_gsm	string		☐
project_endClient_id	int64		☐
project_endClient_invoiceAddress_city	string		☐
project_endClient_invoiceAddress_country	string		☐
project_endClient_invoiceAddress_latLng_defined	boolean		☐
project_endClient_invoiceAddress_latLng_lat	double		☐
project_endClient_invoiceAddress_latLng_lng	double		☐
project_endClient_invoiceAddress_street	string		☐
project_endClient_invoiceAddress_streetBase	string		☐
project_endClient_invoiceAddress_streetExtra	string		☐
project_endClient_invoiceAddress_streetNumber	string		☐
project_endClient_invoiceAddress_zipcode	string		☐
project_endClient_invoiceEmail	string		☐
project_endClient_invoiceRemarks	string		☐
project_endClient_language	string		☐
project_endClient_legalForm_hasVat	boolean		☐
project_endClient_legalForm_id	int64		☐
project_endClient_legalForm_name	string		☐
project_endClient_legalForm_pdfName	string		☐
project_endClient_legalForm_version	int64		☐
project_endClient_legalName	string		☐
project_endClient_logicId	string		☐
project_endClient_name	string		☐
project_endClient_priceGroup_id	int64		☐
project_endClient_priceGroup_name	string		☐
project_endClient_priceGroup_version	int64		☐
project_endClient_seperateInvoicePage	boolean		☐
project_endClient_status	string		☐
project_endClient_tel	string		☐
project_endClient_title	string		☐
project_endClient_useInvoiceAddress	boolean		☐
project_endClient_usePeppol	boolean		☐
project_endClient_vat_ublSchemeId	string		☐
project_endClient_vat_vatCode	string		☐
project_endClient_vat_vatCountry	string		☐
project_endClient_vat_vatValid	boolean		☐
project_endClient_vatNr	string		☐
project_endClient_vatTarif	string		☐
project_endClient_version	int64		☐
project_endClient_website	string		☐
project_endClient_withRespectTo	string		☐
project_endClientContactPerson_email	string		☐
project_endClientContactPerson_fullName	string		☐
project_endClientContactPerson_function	string		☐
project_endClientContactPerson_gsm	string		☐
project_endClientContactPerson_gsmOrTel	string		☐
project_endClientContactPerson_id	int64		☐
project_endClientContactPerson_name	string		☐
project_endClientContactPerson_surname	string		☐
project_endClientContactPerson_tel	string		☐
project_endClientContactPerson_title	string		☐
project_endClientContactPerson_version	int64		☐
project_endClientContactPersonName	string		☐
project_endClientName	string		☐
project_id	int64		☐
project_kilometers	int32		☐
project_km	double		☐
project_logicId	string		☐
project_objectDescription	string		☐
project_planningGroup	string		☐
project_planningName	string		☐
project_site_city	string		☐
project_site_country	string		☐
project_site_latLng_defined	boolean		☐
project_site_latLng_lat	double		☐
project_site_latLng_lng	double		☐
project_site_street	string		☐
project_site_streetBase	string		☐
project_site_streetExtra	string		☐
project_site_streetNumber	string		☐
project_site_zipcode	string		☐
project_siteNotification	string		☐
project_siteRsz	string		☐
project_siteRszStripped	string		☐
project_status	string		☐
project_version	int64		☐
project_werfleider_avatar_availableForWappy	boolean		☐
project_werfleider_avatar_directory	boolean		☐
project_werfleider_avatar_documentDate	datetime		☐
project_werfleider_avatar_expirationDate	datetime		☐
project_werfleider_avatar_filename	string		☐
project_werfleider_avatar_fileSize	int64		☐
project_werfleider_avatar_id	int64		☐
project_werfleider_avatar_mimeType	string		☐
project_werfleider_avatar_objectRef_objectId	int64		☐
project_werfleider_avatar_objectRef_objectType	string		☐
project_werfleider_avatar_parentId	int64		☐
project_werfleider_avatar_path	string		☐
project_werfleider_avatar_uuid	string		☐
project_werfleider_avatar_version	int64		☐
project_werfleider_avatar_wappy	boolean		☐
project_werfleider_email	string		☐
project_werfleider_emailAccount_emailAccountType	string		☐
project_werfleider_emailAccount_emailBcc	string		☐
project_werfleider_emailAccount_emailFrom	string		☐
project_werfleider_emailAccount_emailFromName	string		☐
project_werfleider_emailAccount_emailHost	string		☐
project_werfleider_emailAccount_emailPass	string		☐
project_werfleider_emailAccount_emailPort	string		☐
project_werfleider_emailAccount_emailUser	string		☐
project_werfleider_emailAccount_starttls	boolean		☐
project_werfleider_emailAccount_uuid	string		☐
project_werfleider_employee_address_city	string		☐
project_werfleider_employee_address_country	string		☐
project_werfleider_employee_address_latLng_defined	boolean		☐
project_werfleider_employee_address_latLng_lat	double		☐
project_werfleider_employee_address_latLng_lng	double		☐
project_werfleider_employee_address_street	string		☐
project_werfleider_employee_address_streetBase	string		☐
project_werfleider_employee_address_streetExtra	string		☐
project_werfleider_employee_address_streetNumber	string		☐
project_werfleider_employee_address_zipcode	string		☐
project_werfleider_employee_bankaccountNr	string		☐
project_werfleider_employee_birthDate	datetime		☐
project_werfleider_employee_civilStatus	string		☐
project_werfleider_employee_competenceLevel	string		☐
project_werfleider_employee_costPerHour	double		☐
project_werfleider_employee_defaultMobility_id	int64		☐
project_werfleider_employee_defaultMobility_name	string		☐
project_werfleider_employee_defaultMobility_version	int64		☐
project_werfleider_employee_defaultOperation_accountancyCode_code	string		☐
project_werfleider_employee_defaultOperation_accountancyCode_externalId	string		☐
project_werfleider_employee_defaultOperation_accountancyCode_id	int64		☐
project_werfleider_employee_defaultOperation_accountancyCode_name	string		☐
project_werfleider_employee_defaultOperation_accountancyCode_version	int64		☐
project_werfleider_employee_defaultOperation_accountancyCodePurchase_code	string		☐
project_werfleider_employee_defaultOperation_accountancyCodePurchase_externalId	string		☐
project_werfleider_employee_defaultOperation_accountancyCodePurchase_id	int64		☐
project_werfleider_employee_defaultOperation_accountancyCodePurchase_name	string		☐
project_werfleider_employee_defaultOperation_accountancyCodePurchase_version	int64		☐
project_werfleider_employee_defaultOperation_activity	string		☐
project_werfleider_employee_defaultOperation_agreementType	string		☐
project_werfleider_employee_defaultOperation_articleGroup_contextPath	string		☐
project_werfleider_employee_defaultOperation_articleGroup_id	int64		☐
project_werfleider_employee_defaultOperation_articleGroup_name	string		☐
project_werfleider_employee_defaultOperation_articleGroup_version	int64		☐
project_werfleider_employee_defaultOperation_articleNumber	string		☐
project_werfleider_employee_defaultOperation_articleType	string		☐
project_werfleider_employee_defaultOperation_barcode	string		☐
project_werfleider_employee_defaultOperation_brand	string		☐
project_werfleider_employee_defaultOperation_calc	boolean		☐
project_werfleider_employee_defaultOperation_calcDescription	string		☐
project_werfleider_employee_defaultOperation_calculationType	string		☐
project_werfleider_employee_defaultOperation_chapter	string		☐
project_werfleider_employee_defaultOperation_costPrice	double		☐
project_werfleider_employee_defaultOperation_costPriceStrategy	string		☐
project_werfleider_employee_defaultOperation_currencySymbol	string		☐
project_werfleider_employee_defaultOperation_description	string		☐
project_werfleider_employee_defaultOperation_deviantSalesName	string		☐
project_werfleider_employee_defaultOperation_headerLevel	string		☐
project_werfleider_employee_defaultOperation_id	int64		☐
project_werfleider_employee_defaultOperation_indirectCostFactor	double		☐
project_werfleider_employee_defaultOperation_internalPhoto	boolean		☐
project_werfleider_employee_defaultOperation_lineType	string		☐
project_werfleider_employee_defaultOperation_margin	double		☐
project_werfleider_employee_defaultOperation_materialInstallation	boolean		☐
project_werfleider_employee_defaultOperation_minimumSaleAmount	double		☐
project_werfleider_employee_defaultOperation_minimumStockAmount	double		☐
project_werfleider_employee_defaultOperation_name	string		☐
project_werfleider_employee_defaultOperation_newPage	boolean		☐
project_werfleider_employee_defaultOperation_photo_availableForWappy	boolean		☐
project_werfleider_employee_defaultOperation_photo_directory	boolean		☐
project_werfleider_employee_defaultOperation_photo_documentDate	datetime		☐
project_werfleider_employee_defaultOperation_photo_expirationDate	datetime		☐
project_werfleider_employee_defaultOperation_photo_filename	string		☐
project_werfleider_employee_defaultOperation_photo_fileSize	int64		☐
project_werfleider_employee_defaultOperation_photo_id	int64		☐
project_werfleider_employee_defaultOperation_photo_mimeType	string		☐
project_werfleider_employee_defaultOperation_photo_parentId	int64		☐
project_werfleider_employee_defaultOperation_photo_path	string		☐
project_werfleider_employee_defaultOperation_photo_uuid	string		☐
project_werfleider_employee_defaultOperation_photo_version	int64		☐
project_werfleider_employee_defaultOperation_photo_wappy	boolean		☐
project_werfleider_employee_defaultOperation_saleName	string		☐
project_werfleider_employee_defaultOperation_salePrice	double		☐
project_werfleider_employee_defaultOperation_salePriceStrategy	string		☐
project_werfleider_employee_defaultOperation_stockAmount	double		☐
project_werfleider_employee_defaultOperation_stockChanges	string		☐
project_werfleider_employee_defaultOperation_stockLocation	string		☐
project_werfleider_employee_defaultOperation_supplierNames	string		☐
project_werfleider_employee_defaultOperation_timeOperation	boolean		☐
project_werfleider_employee_defaultOperation_unitType	string		☐
project_werfleider_employee_defaultOperation_vatTarif	string		☐
project_werfleider_employee_defaultOperation_version	int64		☐
project_werfleider_employee_dependentChildren	int32		☐
project_werfleider_employee_detachment	boolean		☐
project_werfleider_employee_dimona	string		☐
project_werfleider_employee_dimonaExpireDate	datetime		☐
project_werfleider_employee_distance	double		☐
project_werfleider_employee_documentRsz	int64		☐
project_werfleider_employee_documentRszPayment	int64		☐
project_werfleider_employee_documentRszValidTill	datetime		☐
project_werfleider_employee_driverLicense	string		☐
project_werfleider_employee_email	string		☐
project_werfleider_employee_emergencyTel	string		☐
project_werfleider_employee_employeeGone	datetime		☐
project_werfleider_employee_employeeRole_id	int64		☐
project_werfleider_employee_employeeRole_name	string		☐
project_werfleider_employee_employeeRole_version	int64		☐
project_werfleider_employee_employeeSince	datetime		☐
project_werfleider_employee_employeeStatute	string		☐
project_werfleider_employee_expireDateRszPayment	datetime		☐
project_werfleider_employee_fullname	string		☐
project_werfleider_employee_function	string		☐
project_werfleider_employee_gender	string		☐
project_werfleider_employee_grossSalary	double		☐
project_werfleider_employee_gsm	string		☐
project_werfleider_employee_gsmOrTel	string		☐
project_werfleider_employee_id	int64		☐
project_werfleider_employee_independentCertificate	boolean		☐
project_werfleider_employee_independentConnection	boolean		☐
project_werfleider_employee_insz	string		☐
project_werfleider_employee_limosaExpireDate	datetime		☐
project_werfleider_employee_limosaNr	string		☐
project_werfleider_employee_name	string		☐
project_werfleider_employee_nameAndState	string		☐
project_werfleider_employee_nationality	string		☐
project_werfleider_employee_objectDescription	string		☐
project_werfleider_employee_passportExpireDate	datetime		☐
project_werfleider_employee_passportNr	string		☐
project_werfleider_employee_paymentRsz	boolean		☐
project_werfleider_employee_planningGroup	string		☐
project_werfleider_employee_startDate	datetime		☐
project_werfleider_employee_status	string		☐
project_werfleider_employee_subType	string		☐
project_werfleider_employee_supplier_accountancyCodePurchase_code	string		☐
project_werfleider_employee_supplier_accountancyCodePurchase_externalId	string		☐
project_werfleider_employee_supplier_accountancyCodePurchase_id	int64		☐
project_werfleider_employee_supplier_accountancyCodePurchase_name	string		☐
project_werfleider_employee_supplier_accountancyCodePurchase_version	int64		☐
project_werfleider_employee_supplier_accountNr	string		☐
project_werfleider_employee_supplier_addressString	string		☐
project_werfleider_employee_supplier_bank	string		☐
project_werfleider_employee_supplier_btwNumber	string		☐
project_werfleider_employee_supplier_currencySymbol	string		☐
project_werfleider_employee_supplier_email	string		☐
project_werfleider_employee_supplier_externalId	string		☐
project_werfleider_employee_supplier_fax	string		☐
project_werfleider_employee_supplier_gsm	string		☐
project_werfleider_employee_supplier_id	int64		☐
project_werfleider_employee_supplier_invoiceAddress_city	string		☐
project_werfleider_employee_supplier_invoiceAddress_country	string		☐
project_werfleider_employee_supplier_invoiceAddress_street	string		☐
project_werfleider_employee_supplier_invoiceAddress_streetBase	string		☐
project_werfleider_employee_supplier_invoiceAddress_streetExtra	string		☐
project_werfleider_employee_supplier_invoiceAddress_streetNumber	string		☐
project_werfleider_employee_supplier_invoiceAddress_zipcode	string		☐
project_werfleider_employee_supplier_invoiceRemarks	string		☐
project_werfleider_employee_supplier_language	string		☐
project_werfleider_employee_supplier_legalForm_hasVat	boolean		☐
project_werfleider_employee_supplier_legalForm_id	int64		☐
project_werfleider_employee_supplier_legalForm_name	string		☐
project_werfleider_employee_supplier_legalForm_pdfName	string		☐
project_werfleider_employee_supplier_legalForm_version	int64		☐
project_werfleider_employee_supplier_legalName	string		☐
project_werfleider_employee_supplier_logicId	string		☐
project_werfleider_employee_supplier_name	string		☐
project_werfleider_employee_supplier_planningEmail	string		☐
project_werfleider_employee_supplier_status	string		☐
project_werfleider_employee_supplier_supplyOrderRemarks	string		☐
project_werfleider_employee_supplier_tel	string		☐
project_werfleider_employee_supplier_vat_ublSchemeId	string		☐
project_werfleider_employee_supplier_vat_vatCode	string		☐
project_werfleider_employee_supplier_vat_vatCountry	string		☐
project_werfleider_employee_supplier_vat_vatValid	boolean		☐
project_werfleider_employee_supplier_vatNr	string		☐
project_werfleider_employee_supplier_vatTarif	string		☐
project_werfleider_employee_supplier_version	int64		☐
project_werfleider_employee_supplier_website	string		☐
project_werfleider_employee_supplierName	string		☐
project_werfleider_employee_surname	string		☐
project_werfleider_employee_tel	string		☐
project_werfleider_employee_type	string		☐
project_werfleider_employee_version	int64		☐
project_werfleider_employeeId	int64		☐
project_werfleider_fullname	string		☐
project_werfleider_id	int64		☐
project_werfleider_schema	string		☐
project_werfleider_signature	string		☐
project_werfleider_useEmailAccount	boolean		☐
project_werfleider_username	string		☐
project_werfleider_userRole_id	int64		☐
project_werfleider_userRole_name	string		☐
project_werfleider_userRole_version	int64		☐
project_werfleider_userRoleString	string		☐
project_werfleider_version	int64		☐
project_werfleiderName	string		☐
project_workOrderInfo	string		☐
project_yearNumber	int32		☐
projectInfo	string	Project Information	☐
projectInfo_1	string		☐
referenceValue	string	Reference Value	☐
remark	string	Remark	☐
remark_1	string		☐
sentToAccountant	boolean	Sent to Accountant	☐
signature_availableForWappy	boolean		☐
signature_directory	boolean		☐
signature_documentDate	datetime		☐
signature_expirationDate	datetime		☐
signature_filename	string		☐
signature_fileSize	int64		☐
signature_id	int64		☐
signature_mimeType	string		☐
signature_objectRef_objectId	int64		☐
signature_objectRef_objectType	string		☐
signature_parentId	int64		☐
signature_path	string		☐
signature_uuid	string		☐
signature_version	int64		☐
signature_wappy	boolean		☐
status	string	Status	☐
status_1	string		☐
string	string	String	☐
textAreaValue	string	Text Area Value	☐
textValue	string	Text Value	☐
totalBTW	double	Total VAT	☐
totalBTW_1	double		☐
totalExcBTW	double	Total excl. VAT	☐
totalExcBTW_1	double		☐
totalIncBTW	double	Total incl. VAT	☐
totalIncBTW_1	double		☐
version	int64	Version	☐
version_1	int64		☐
version_2	int64		☐
withRespectTo	string	With Respect To	☐
yardLeaders	string		☐
year	int32	Year	☐
yearNumber	int32	Year	☐
yearNumber_1	int32		☐

17-11-2020 16:0920.1.279-BETA+2990

Please enable JavaScript to view this site.

ROBAWS API Data Model

InvoiceOrderExtraFieldsByInvoiceId: Invoice Order Extra Fields by Invoice ID

Table Function Parameters

Table Columns