invantive documentation
Invantive Support ForumsLog In / Sign Up

BookingLineContactHoursByProject: Bouw7 Booking Line Contact Hours by Project

read only REST

  • Catalog: Bouw7
  • Schema: Booking
  • Label: Booking Line Contact Hours 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 BookingLineContactHoursByProject 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.
comment varchar2 Comment writable, comment The comments for this invoice booking.
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 cost price.
hourTypeName varchar2 Hour Type Name writable, hourTypeName The hour type name.
id int64 ID writable, id The ID of hourLog.
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.
logDate datetime Log Date writable, logDate The log date of this booking in ATOM format.
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.

Release Notes

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