invantive documentation
Invantive Support ForumsLog In / Sign Up

BookingLineGarbagesByProject: Bouw7 Booking Line Garbages by Project

read only REST

  • Catalog: Bouw7
  • Schema: Booking
  • Label: Booking Line Garbages 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 BookingLineGarbagesByProject 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
amount varchar2 Amount writable, amount The unit amount of the Booking object.
code varchar2 Code writable, code The article number of the resource entity.
comment varchar2 Comment writable, comment The comments for this invoice booking.
costPrice varchar2 Costprice writable, costPrice The cost price.
id int64 ID writable, id The ID of the WasteBooking.
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 of the booking item.
invoiceLineId int64 Invoice Line ID writable, invoiceLineId The id of the invoice line the booking line is linked to.
isMutable char itgen_bouw7_ismutable writable, isMutable Whether the waste booking is mutable.
logDate datetime Log Date writable, logDate The log date of this booking in ATOM format.
name varchar2 Name writable, name The name of the resource.
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.
totalCostPrice varchar2 Total Cost Price writable, totalCostPrice Total cost price.
unitName varchar2 Unit Name writable, unitName The name of the unit.

Release Notes

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