ROBAWS 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: Catalog: Robaws > Schemas > Schema: Invoices > Tables

Invoices: False

Contents Previous Home Next More

Name: Invoices

Catalog: Robaws

Schema: Invoices

Label: Invoices

Partition-specific: false

Select: true

Insert: true

Update: true

Delete: true

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[*]

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

Insert Operation (Swagger-specific): post /api/v1/invoices

Update Operation (Swagger-specific): put /api/v1/invoices/{id}

Delete Operation (Swagger-specific): delete /api/v1/invoices/{id}

Parameters

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

Name	Data Type	Label	Required
advancePayment	boolean	Advance Payment	☐
advancePercentage	double	Advance (%)	☐
assignee_email	string	Assignee Email	☐
assignee_employeeId	int64		☐
assignee_fullname	string	Assignee Full Name	☐
assignee_id	int64		☐
assignee_schema	string		☐
assignee_signature	string		☐
assignee_useEmailAccount	boolean		☐
assignee_username	string		☐
assignee_userRole_id	int64		☐
assignee_userRole_name	string		☐
assignee_userRole_version	int64		☐
assignee_userRoleString	string		☐
assignee_version	int64		☐
assigneeName	string	Assignee Name	☐
body	string	Body	☐
booked	boolean	Booked	☐
client_accountNr	string		☐
client_address_city	string		☐
client_address_country	string		☐
client_address_latLng_lat	double		☐
client_address_latLng_lng	double		☐
client_address_street	string		☐
client_address_streetExtra	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_contactMedium	string		☐
client_creditDate	datetime		☐
client_creditInfo	string		☐
client_creditLimit	double		☐
client_creditStatus	string		☐
client_currencySymbol	string		☐
client_email	string		☐
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_finalAddress_city	string		☐
client_finalAddress_country	string		☐
client_finalAddress_latLng_lat	double		☐
client_finalAddress_latLng_lng	double		☐
client_finalAddress_street	string		☐
client_finalAddress_streetExtra	string		☐
client_finalAddress_zipcode	string		☐
client_followUpDate	datetime		☐
client_gsm	string		☐
client_id	int64		☐
client_invoiceAddress_city	string		☐
client_invoiceAddress_country	string		☐
client_invoiceAddress_latLng_lat	double		☐
client_invoiceAddress_latLng_lng	double		☐
client_invoiceAddress_street	string		☐
client_invoiceAddress_streetExtra	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_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	☐
clientName	string	Customer Name	☐
clientReference	string	Customer Reference	☐
contactPersonName	string	Contact Person Name	☐
conversion	double		☐
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	☐
diary	string	Diary	☐
discount	double	Discount	☐
expireDate	datetime	Expiry Date	☐
finalPayment	boolean	Final Payment	☐
financialDiscountDays	int32		☐
financialDiscountEnabled	boolean		☐
financialDiscountPercent	double		☐
id	int64	ID	☐
invoiceType	string	Invoice Type	☐
logicId	string		☐
openTotal	double	Open Total	☐
originalInvoice_advancePayment	boolean		☐
originalInvoice_advancePercentage	double		☐
originalInvoice_assigneeName	string		☐
originalInvoice_body	string		☐
originalInvoice_booked	boolean		☐
originalInvoice_clientLegalName	string		☐
originalInvoice_clientName	string		☐
originalInvoice_clientReference	string		☐
originalInvoice_contactPersonName	string		☐
originalInvoice_conversion	double		☐
originalInvoice_creditLimitDays	int32		☐
originalInvoice_creditLimitEnabled	boolean		☐
originalInvoice_creditLimitPercent	double		☐
originalInvoice_credLimit	double		☐
originalInvoice_currencySymbol	string		☐
originalInvoice_date	datetime		☐
originalInvoice_diary	string		☐
originalInvoice_discount	double		☐
originalInvoice_expireDate	datetime		☐
originalInvoice_finalPayment	boolean		☐
originalInvoice_financialDiscountDays	int32		☐
originalInvoice_financialDiscountEnabled	boolean		☐
originalInvoice_financialDiscountPercent	double		☐
originalInvoice_id	int64		☐
originalInvoice_invoiceType	string		☐
originalInvoice_logicId	string		☐
originalInvoice_openTotal	double		☐
originalInvoice_paidOn	datetime		☐
originalInvoice_paidTotal	double		☐
originalInvoice_poNumber	string		☐
originalInvoice_projectInfo	string		☐
originalInvoice_remark	string		☐
originalInvoice_sentToAccountant	boolean		☐
originalInvoice_status	string		☐
originalInvoice_storedPaymentInstructionId	string		☐
originalInvoice_totalBTW	double		☐
originalInvoice_totalExcBTW	double		☐
originalInvoice_totalIncBTW	double		☐
originalInvoice_version	int64		☐
originalInvoice_withRespectTo	string		☐
originalInvoice_year	int32		☐
originalInvoice_yearNumber	int32		☐
paidOn	datetime	Paid on	☐
paidTotal	double	Paid Total	☐
poNumber	string	PO Number	☐
projectInfo	string	Project Information	☐
remark	string	Remark	☐
sentToAccountant	boolean	Sent to Accountant	☐
status	string	Status	☐
storedPaymentInstructionId	string		☐
totalBTW	double	Total VAT	☐
totalExcBTW	double	Total excl. VAT	☐
totalIncBTW	double	Total incl. VAT	☐
version	int64	Version	☐
withRespectTo	string		☐
year	int32	Year	☐
yearNumber	int32	Year	☐

25-05-2020 14:5220.1.44-BETA+2813

Please enable JavaScript to view this site.

ROBAWS Data Model

Parameters

Table Columns