invantive documentation
Invantive Support ForumsLog In / Sign Up

BookingLinePurchaseInvoiceLinesByProject: Bouw7 Booking Line Purchase Invoice Lines by Project

read only REST

  • Catalog: Bouw7
  • Schema: Booking
  • Label: Booking Line Purchase Invoice Lines by Project

Returns all available booking items based on its criteria. Returns all available booking items based on its criteria.

Can only retrieve data.

Summary

Returns all available booking items based on its criteria.

API Source

  • Endpoint: /project/{project}/booking-lines
  • Operation: get /project/{project}/booking-lines

Performance Characteristics

Characteristic Value
Average access latency (ms) 90
Full scan rows per minute 241,000
Point query rows per minute 666

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
endDate `` End date
findForCheckoutDocument `` Whether the booking lines should be retrieved for a checkout document. Available values: 0, 1.
project `` Project ID
startDate `` Start date
type `` Type bit mask

Table Columns

The columns of the table BookingLinePurchaseInvoiceLinesByProject are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
contact_email varchar2 Contact Email writable, contact.email The email address.
contact_id int64 Contact ID writable, contact.id ID of contact.
contact_isVatShifted char Contact Is VAT Shifted writable, contact.isVatShifted Whether VAT is shifted for the contact.
contact_name varchar2 Contact Name writable, contact.name Name of contact.
contact_phoneNumber varchar2 Contact Phone Number writable, contact.phoneNumber The phone number of the contact.
costPrice varchar2 Costprice writable, costPrice The booking price.
deliveryTicketId int64 Delivery Ticket ID writable, deliveryTicketId Internal ID of the delivery ticket.
description varchar2 Description writable, description The booking description.
grossPrice varchar2 Gross Price writable, grossPrice The gross price.
id int64 ID writable, id The ID of PurchaseInvoiceLineBooking.
invoiceAmount varchar2 Invoice Amount writable, invoiceAmount The amount that will be shown on the invoice.
invoiceCostStatusId int64 Invoice Cost Status ID writable, invoiceCostStatusId The invoice cost status id.
invoiceDescription varchar2 Invoice Description writable, invoiceDescription The invoice description.
invoiceLineId int64 Invoice Line ID writable, invoiceLineId The id of the invoice line the booking line is linked to.
logDate datetime Log Date writable, logDate The log date of this booking in ATOM format.
purchaseInvoiceBookNumber int64 Purchase Invoice Book Number writable, purchaseInvoiceBookNumber Book number of the purchase invoice.
purchaseInvoiceId int64 Purchase Invoice ID writable, purchaseInvoiceId Internal ID of the purchase invoice.
purchaseInvoiceNumber varchar2 The number of the purchase invoice. writable, purchaseInvoiceNumber Number of the purchase invoice.
quantity varchar2 Quantity writable, quantity The quantity.
sellingPrice varchar2 Selling Price writable, sellingPrice The selling price.
summary_amount varchar2 Summary Amount filters on the platform, writable, ::ancestor.summary.amount Total amount of all items in this category.
summary_contactHours_amount varchar2 Summary Contact Hours Amount filters on the platform, writable, ::ancestor.summary.contactHours.amount Total amount of all items in this category.
summary_contactHours_costPrice varchar2 Summary Contact Hours Cost Price filters on the platform, writable, ::ancestor.summary.contactHours.costPrice Total cost price of all items in this category.
summary_contactHours_invoiceAmount varchar2 Summary Contact Hours Invoice Amount filters on the platform, writable, ::ancestor.summary.contactHours.invoiceAmount Total invoice amount of all items in this category.
summary_contactHours_itemCount int64 Summary Contact Hours Item Count filters on the platform, writable, ::ancestor.summary.contactHours.itemCount Total amount of booking items in this category.
summary_contactHours_sellingPrice varchar2 Summary Contact Hours Selling Price filters on the platform, writable, ::ancestor.summary.contactHours.sellingPrice Total selling price of all items in this category.
summary_costPrice varchar2 Summary Cost Price filters on the platform, writable, ::ancestor.summary.costPrice Total cost price of all items in this category.
summary_deliveryTickets_amount varchar2 Summary Delivery Tickets Amount filters on the platform, writable, ::ancestor.summary.deliveryTickets.amount Total amount of all items in this category.
summary_deliveryTickets_costPrice varchar2 Summary Delivery Tickets Cost Price filters on the platform, writable, ::ancestor.summary.deliveryTickets.costPrice Total cost price of all items in this category.
summary_deliveryTickets_invoiceAmount varchar2 Summary Delivery Tickets Invoice Amount filters on the platform, writable, ::ancestor.summary.deliveryTickets.invoiceAmount Total invoice amount of all items in this category.
summary_deliveryTickets_itemCount int64 Summary Delivery Tickets Item Count filters on the platform, writable, ::ancestor.summary.deliveryTickets.itemCount Total amount of booking items in this category.
summary_deliveryTickets_sellingPrice varchar2 Summary Delivery Tickets Selling Price filters on the platform, writable, ::ancestor.summary.deliveryTickets.sellingPrice Total selling price of all items in this category.
summary_employeeHours_amount varchar2 Summary Employee Hours Amount filters on the platform, writable, ::ancestor.summary.employeeHours.amount Total amount of all items in this category.
summary_employeeHours_costPrice varchar2 Summary Employee Hours Cost Price filters on the platform, writable, ::ancestor.summary.employeeHours.costPrice Total cost price of all items in this category.
summary_employeeHours_invoiceAmount varchar2 Summary Employee Hours Invoice Amount filters on the platform, writable, ::ancestor.summary.employeeHours.invoiceAmount Total invoice amount of all items in this category.
summary_employeeHours_itemCount int64 Summary Employee Hours Item Count filters on the platform, writable, ::ancestor.summary.employeeHours.itemCount Total amount of booking items in this category.
summary_employeeHours_sellingPrice varchar2 Summary Employee Hours Selling Price filters on the platform, writable, ::ancestor.summary.employeeHours.sellingPrice Total selling price of all items in this category.
summary_equipment_amount varchar2 Summary Equipment Amount filters on the platform, writable, ::ancestor.summary.equipment.amount Total amount of all items in this category.
summary_equipment_costPrice varchar2 Summary Equipment Cost Price filters on the platform, writable, ::ancestor.summary.equipment.costPrice Total cost price of all items in this category.
summary_equipment_invoiceAmount varchar2 Summary Equipment Invoice Amount filters on the platform, writable, ::ancestor.summary.equipment.invoiceAmount Total invoice amount of all items in this category.
summary_equipment_itemCount int64 Summary Equipment Item Count filters on the platform, writable, ::ancestor.summary.equipment.itemCount Total amount of booking items in this category.
summary_equipment_sellingPrice varchar2 Summary Equipment Selling Price filters on the platform, writable, ::ancestor.summary.equipment.sellingPrice Total selling price of all items in this category.
summary_garbage_amount varchar2 Summary Garbage Amount filters on the platform, writable, ::ancestor.summary.garbage.amount Total amount of all items in this category.
summary_garbage_costPrice varchar2 Summary Garbage Cost Price filters on the platform, writable, ::ancestor.summary.garbage.costPrice Total cost price of all items in this category.
summary_garbage_invoiceAmount varchar2 Summary Garbage Invoice Amount filters on the platform, writable, ::ancestor.summary.garbage.invoiceAmount Total invoice amount of all items in this category.
summary_garbage_itemCount int64 Summary Garbage Item Count filters on the platform, writable, ::ancestor.summary.garbage.itemCount Total amount of booking items in this category.
summary_garbage_sellingPrice varchar2 Summary Garbage Selling Price filters on the platform, writable, ::ancestor.summary.garbage.sellingPrice Total selling price of all items in this category.
summary_invoiceAmount varchar2 Summary Invoice Amount filters on the platform, writable, ::ancestor.summary.invoiceAmount Total invoice amount of all items in this category.
summary_itemCount int64 Summary Item Count filters on the platform, writable, ::ancestor.summary.itemCount Total amount of booking items in this category.
summary_material_amount varchar2 Summary Material Amount filters on the platform, writable, ::ancestor.summary.material.amount Total amount of all items in this category.
summary_material_costPrice varchar2 Summary Material Cost Price filters on the platform, writable, ::ancestor.summary.material.costPrice Total cost price of all items in this category.
summary_material_invoiceAmount varchar2 Summary Material Invoice Amount filters on the platform, writable, ::ancestor.summary.material.invoiceAmount Total invoice amount of all items in this category.
summary_material_itemCount int64 Summary Material Item Count filters on the platform, writable, ::ancestor.summary.material.itemCount Total amount of booking items in this category.
summary_material_sellingPrice varchar2 Summary Material Selling Price filters on the platform, writable, ::ancestor.summary.material.sellingPrice Total selling price of all items in this category.
summary_profit varchar2 Summary Profit filters on the platform, writable, ::ancestor.summary.profit The profit.
summary_purchaseInvoiceLines_amount varchar2 Summary Purchase Invoice Lines Amount filters on the platform, writable, ::ancestor.summary.purchaseInvoiceLines.amount Total amount of all items in this category.
summary_purchaseInvoiceLines_costPrice varchar2 Summary Purchase Invoice Lines Cost Price filters on the platform, writable, ::ancestor.summary.purchaseInvoiceLines.costPrice Total cost price of all items in this category.
summary_purchaseInvoiceLines_invoiceAmount varchar2 Summary Purchase Invoice Lines Invoice Amount filters on the platform, writable, ::ancestor.summary.purchaseInvoiceLines.invoiceAmount Total invoice amount of all items in this category.
summary_purchaseInvoiceLines_itemCount int64 Summary Purchase Invoice Lines Item Count filters on the platform, writable, ::ancestor.summary.purchaseInvoiceLines.itemCount Total amount of booking items in this category.
summary_purchaseInvoiceLines_sellingPrice varchar2 Summary Purchase Invoice Lines Selling Price filters on the platform, writable, ::ancestor.summary.purchaseInvoiceLines.sellingPrice Total selling price of all items in this category.
summary_sellingPrice varchar2 Summary Selling Price filters on the platform, writable, ::ancestor.summary.sellingPrice Total selling price of all items in this category.
surchargePercentage varchar2 Surcharge Percentage writable, surchargePercentage Surcharge percentage.
totalCostPrice varchar2 Total Cost Price writable, totalCostPrice Total cost price.
unit varchar2 Unit writable, unit The booking unit.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: