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

InvoiceLineItemCompositeLinesByInvoiceId

Contents Previous Home Next More

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

get

Catalog: Robaws

Schema: Invoices

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): lineItems[*].compositeLines[*]

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

Name	Data Type	Label	Required
activity	string	Activity	☐
advanceDiscountPercentage	double		☐
advancePayment	boolean	Advance Payment	☐
advancePercentage	double	Advance (%)	☐
agreementType	string	Agreement Type	☐
amount	double	Amount	☐
amountCalculation	string	Amount Calculation	☐
amountReceived	double	Amount Received	☐
assigneeName	string	Assignee Name	☐
barcode	string	Bar Code	☐
body	string	Body	☐
booked	boolean	Booked	☐
calculatedTotalCost	double	Calculated Total Cost	☐
calculationType	string	Calculation Type	☐
calculationTypeString	string	Calculation Type	☐
chapter	string	Chapter	☐
clientLegalName	string	Customer Legal Name	☐
clientName	string	Customer Name	☐
clientReference	string	Customer Reference	☐
compositeLineItem	boolean	Composite Line Item	☐
contactPersonName	string	Contact Person Name	☐
conversion	double	Conversion	☐
costPrice	double	Cost Price	☐
creditLimitDays	int32	Credit Limit Days	☐
creditLimitEnabled	boolean	Credit Limit Enabled	☐
creditLimitPercent	double	Credit Limit (%)	☐
credLimit	double	Credit Limit	☐
currencySymbol	string	Currency Symbol	☐
customPrice	boolean	Custom Price	☐
date	datetime	Date	☐
description	string	Description	☐
descriptionCalculation	string		☐
descriptionExtended	string		☐
descriptionExtendedWithReplacedFormulas	string		☐
diary	string	Diary	☐
discount	double	Discount	☐
discount_1	double		☐
expireDate	datetime	Expiry Date	☐
finalPayment	boolean	Final Payment	☐
financialDiscountDays	int32	Financial Discount (days)	☐
financialDiscountEnabled	boolean	Financial Discount Enabled	☐
financialDiscountPercent	double	Financial Discount (%)	☐
headerLevel	string	Header Level	☐
id	int64	ID	☐
id_1	int64		☐
indirectCostFactor	double	Indirect Cost Factor	☐
invoiceType	string	Invoice Type	☐
lineNumber	string	Line Number	☐
lineType	string	Line Type	☐
location	string	Location	☐
logicId	string	Logical ID	☐
margin	double	Margin	☐
newPage	boolean	New Page	☐
openTotal	double	Open Total	☐
paidOn	datetime	Paid on	☐
paidTotal	double	Paid Total	☐
paymentInstructionId	string		☐
peppolSentDate	datetime		☐
percentageDone	int32	Done (%)	☐
percentagePrevious	int32	Previous (%)	☐
poNumber	string	PO Number	☐
price	double	Price	☐
priceAdjustment	double	Price Adjustment	☐
projectInfo	string	Project Information	☐
purchasePrice	double	Purchase Price	☐
receivedTotalExclBtw	double	Received Total excl. VAT	☐
remark	string	Remark	☐
scanned	datetime	Scanned	☐
sentToAccountant	boolean	Sent to Accountant	☐
status	string	Status	☐
taxPercent	double	Tax (%)	☐
totalBtw	double	Total VAT	☐
totalBTW_1	double		☐
totalExcBTW	double	Total excl. VAT	☐
totalExclBtw	double	Total excl. VAT	☐
totalIncBtw	double	Total incl. VAT	☐
totalIncBTW_1	double		☐
totality	boolean	Totality	☐
unitType	string	Unit Type	☐
vatTarif	string	VAT Code	☐
version	int64	Version	☐
version_1	int64		☐
withRespectTo	string	With Respect To	☐
yardLeaders	string		☐
year	int32	Year	☐
yearNumber	int32	Year	☐

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

Please enable JavaScript to view this site.

ROBAWS API Data Model

InvoiceLineItemCompositeLinesByInvoiceId

Table Function Parameters

Table Columns