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 |
|---|---|---|---|---|
end |
`` | End date | ||
find |
`` | Whether the booking lines should be retrieved for a checkout document. Available values: 0, 1. | ||
project |
`` | Project ID | ||
start |
`` | 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_ |
varchar2 |
Contact Email | writable, contact. |
The email address. | |
contact_ |
int64 |
Contact ID | writable, contact. |
ID of contact. | |
contact_ |
char |
Contact Is VAT Shifted | writable, contact. |
Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Contact Name | writable, contact. |
Name of contact. | |
contact_ |
varchar2 |
Contact Phone Number | writable, contact. |
The phone number of the contact. | |
cost |
varchar2 |
Costprice | writable, cost |
The booking price. | |
delivery |
int64 |
Delivery Ticket ID | writable, delivery |
Internal ID of the delivery ticket. | |
description |
varchar2 |
Description | writable, description |
The booking description. | |
gross |
varchar2 |
Gross Price | writable, gross |
The gross price. | |
id |
int64 |
ID | writable, id |
The ID of PurchaseInvoiceLineBooking. | |
invoice |
varchar2 |
Invoice Amount | writable, invoice |
The amount that will be shown on the invoice. | |
invoice |
int64 |
Invoice Cost Status ID | writable, invoice |
The invoice cost status id. | |
invoice |
varchar2 |
Invoice Description | writable, invoice |
The invoice description. | |
invoice |
int64 |
Invoice Line ID | writable, invoice |
The id of the invoice line the booking line is linked to. | |
log |
datetime |
Log Date | writable, log |
The log date of this booking in ATOM format. | |
purchase |
int64 |
Purchase Invoice Book Number | writable, purchase |
Book number of the purchase invoice. | |
purchase |
int64 |
Purchase Invoice ID | writable, purchase |
Internal ID of the purchase invoice. | |
purchase |
varchar2 |
The number of the purchase invoice. | writable, purchase |
Number of the purchase invoice. | |
quantity |
varchar2 |
Quantity | writable, quantity |
The quantity. | |
selling |
varchar2 |
Selling Price | writable, selling |
The selling price. | |
summary_ |
varchar2 |
Summary Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Contact Hours Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Contact Hours Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Contact Hours Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Contact Hours Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Contact Hours Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
summary_ |
varchar2 |
Summary Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Delivery Tickets Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Delivery Tickets Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Delivery Tickets Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Delivery Tickets Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Delivery Tickets Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
summary_ |
varchar2 |
Summary Employee Hours Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Employee Hours Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Employee Hours Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Employee Hours Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Employee Hours Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
summary_ |
varchar2 |
Summary Equipment Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Equipment Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Equipment Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Equipment Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Equipment Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
summary_ |
varchar2 |
Summary Garbage Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Garbage Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Garbage Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Garbage Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Garbage Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
summary_ |
varchar2 |
Summary Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Material Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Material Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Material Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Material Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Material Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
summary_ |
varchar2 |
Summary Profit | filters on the platform, writable, ::ancestor. |
The profit. | |
summary_ |
varchar2 |
Summary Purchase Invoice Lines Amount | filters on the platform, writable, ::ancestor. |
Total amount of all items in this category. | |
summary_ |
varchar2 |
Summary Purchase Invoice Lines Cost Price | filters on the platform, writable, ::ancestor. |
Total cost price of all items in this category. | |
summary_ |
varchar2 |
Summary Purchase Invoice Lines Invoice Amount | filters on the platform, writable, ::ancestor. |
Total invoice amount of all items in this category. | |
summary_ |
int64 |
Summary Purchase Invoice Lines Item Count | filters on the platform, writable, ::ancestor. |
Total amount of booking items in this category. | |
summary_ |
varchar2 |
Summary Purchase Invoice Lines Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
summary_ |
varchar2 |
Summary Selling Price | filters on the platform, writable, ::ancestor. |
Total selling price of all items in this category. | |
surcharge |
varchar2 |
Surcharge Percentage | writable, surcharge |
Surcharge percentage. | |
total |
varchar2 |
Total Cost Price | writable, total |
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: