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

InvoiceProjects: Invoice Projects

Contents Previous Home Next More

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

Catalog: Robaws

Schema: Invoices

Label: Invoice Projects

Select: true

Insert: false

Update: false

Delete: false

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

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

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

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

Field Selection Method (OData-specific): NotRequired

Base Path (OData-specific): content[*].projects[*]

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

Table Function Parameters

The following parameters can be used to control the behaviour of the table function InvoiceProjects. 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	Documentation
assigneeId	int64	☐	assigneeId
clientId	int64	☐	clientId
clientReference	string	☐	clientReference
fromDate	datetime	☐	fromDate
offset	int64	☐
paged	boolean	☐
pageNumber	int32	☐
searchText	string	☐	searchText
sentToAccountant	boolean	☐	sentToAccountant
size	int32	☐	Number of records per page.
sort.sorted	boolean	☐
sort.unsorted	boolean	☐
status	string	☐	status
toDate	datetime	☐	toDate
unpaged	boolean	☐
updatedFrom	datetime	☐	updatedFrom

Table Columns

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

Name	Data Type	Label	Required
addressString	string	Address	☐
advanceDiscountPercentage	double		☐
advancePayment	boolean	Advance Payment	☐
advancePercentage	double	Advance (%)	☐
assigneeName	string	Assignee Name	☐
body	string	Body	☐
booked	boolean	Booked	☐
checkInAtWork	string	Check-In at Work	☐
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_email	string		☐
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	☐
clientMail	string		☐
clientName	string	Customer Name	☐
clientName_1	string		☐
clientReference	string	Customer Reference	☐
clientReference_1	string		☐
clientTel	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_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_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_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		☐
contactPersonMail	string	Contact Person Email	☐
contactPersonName	string	Contact Person Name	☐
contactPersonName_1	string		☐
contactPersonTel	string	Contact Person Phone	☐
conversion	double	Conversion	☐
creditLimitDays	int32	Credit Limit Days	☐
creditLimitEnabled	boolean	Credit Limit Enabled	☐
creditLimitPercent	double	Credit Limit (%)	☐
credLimit	double	Credit Limit	☐
currencySymbol	string	Currency Symbol	☐
date	datetime	Date	☐
date_1	datetime		☐
diary	string	Diary	☐
discount	double	Discount	☐
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_email	string		☐
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_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		☐
invoiceType	string	Invoice Type	☐
kilometers	int32	Kilometers	☐
km	double	Kilometers	☐
logicId	string	Logical ID	☐
logicId_1	string		☐
objectDescription	string		☐
openTotal	double	Open Total	☐
paidOn	datetime	Paid on	☐
paidTotal	double	Paid Total	☐
paymentInstructionId	string		☐
peppolSentDate	datetime		☐
planningGroup	string	Planning Group	☐
planningName	string	Planning Name	☐
poNumber	string	PO Number	☐
projectInfo	string	Project Information	☐
remark	string	Remark	☐
sentToAccountant	boolean	Sent to Accountant	☐
site_city	string	Site City	☐
site_country	string	Site Country	☐
site_latLng_defined	boolean		☐
site_latLng_lat	double		☐
site_latLng_lng	double		☐
site_street	string	Site Street	☐
site_streetBase	string		☐
site_streetExtra	string	Site Street Extra	☐
site_streetNumber	string		☐
site_zipcode	string	Site ZIP Code	☐
siteNotification	string	Site Notification	☐
siteRsz	string		☐
siteRszStripped	string		☐
status	string	Status	☐
status_1	string		☐
totalBTW	double	Total VAT	☐
totalExcBTW	double	Total excl. VAT	☐
totalIncBTW	double	Total incl. VAT	☐
version	int64	Version	☐
version_1	int64		☐
werfleider_email	string		☐
werfleider_employeeId	int64		☐
werfleider_fullname	string		☐
werfleider_id	int64		☐
werfleider_schema	string		☐
werfleider_signature	string		☐
werfleider_useEmailAccount	boolean		☐
werfleider_username	string		☐
werfleider_userRole_id	int64		☐
werfleider_userRole_name	string		☐
werfleider_userRole_version	int64		☐
werfleider_userRoleString	string		☐
werfleider_version	int64		☐
werfleiderName	string		☐
withRespectTo	string	With Respect To	☐
workOrderInfo	string	Work Order Information	☐
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

InvoiceProjects: Invoice Projects

Table Function Parameters

Table Columns