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

InvoiceOrderLineItemsByInvoiceId: Invoice Order Line Items by Invoice ID

Contents Previous Home Next More

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

get

Catalog: Robaws

Schema: Invoices

Label: Invoice Order Line Items 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[*].lineItems[*]

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 InvoiceOrderLineItemsByInvoiceId. 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 InvoiceOrderLineItemsByInvoiceId are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required
advanceDiscountPercentage	double		☐
advancePayment	boolean	Advance Payment	☐
advancePercentage	double	Advance (%)	☐
assigneeName	string	Assignee Name	☐
assigneeName_1	string		☐
body	string	Body	☐
booked	boolean	Booked	☐
btw	double	VAT	☐
clientLegalName	string	Customer Legal Name	☐
clientLegalName_1	string		☐
clientName	string	Customer Name	☐
clientName_1	string		☐
clientReference	string	Customer Reference	☐
clientReference_1	string		☐
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		☐
diary	string	Diary	☐
discount	double	Discount	☐
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	☐
logicId	string	Logical ID	☐
logicId_1	string		☐
openTotal	double	Open Total	☐
orderNr	int64	Order Number	☐
originalInvoice_advanceDiscountPercentage	double		☐
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_paymentInstructionId	string		☐
originalInvoice_peppolSentDate	datetime		☐
originalInvoice_poNumber	string		☐
originalInvoice_projectInfo	string		☐
originalInvoice_remark	string		☐
originalInvoice_sentToAccountant	boolean		☐
originalInvoice_status	string		☐
originalInvoice_totalBTW	double		☐
originalInvoice_totalExcBTW	double		☐
originalInvoice_totalIncBTW	double		☐
originalInvoice_version	int64		☐
originalInvoice_withRespectTo	string		☐
originalInvoice_yardLeaders	string		☐
originalInvoice_year	int32		☐
originalInvoice_yearNumber	int32		☐
paidOn	datetime	Paid on	☐
paidTotal	double	Paid Total	☐
paymentInstructionId	string		☐
peppolSentDate	datetime		☐
poNumber	string	PO Number	☐
projectInfo	string	Project Information	☐
projectInfo_1	string		☐
remark	string	Remark	☐
remark_1	string		☐
sentToAccountant	boolean	Sent to Accountant	☐
status	string	Status	☐
status_1	string		☐
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		☐
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

InvoiceOrderLineItemsByInvoiceId: Invoice Order Line Items by Invoice ID

Table Function Parameters

Table Columns