GarbageBookings: Bouw7 Garbage Bookings
read only REST
- Catalog:
Bouw7 - Schema:
Resource - Label: Garbage Bookings
Returns a list of waste bookings made by the organization. Returns a list of waste bookings made by the organization.
Can only retrieve data.
Summary
Returns a list of waste bookings made by the organization.
API Source
- Endpoint:
/list/booking/garbage - Operation:
get /list/booking/garbage
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 94 |
| 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 |
|---|---|---|---|---|
q |
`` | A Heimdall Query Language string |
Table Columns
The columns of the table GarbageBookings 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 |
|---|---|---|---|---|---|
booking |
int64 |
Booking Status | filters on the platform, writable, booking |
The status of this booking. 0 = Registered, 1 = Invoiced, 2 = Not billable, 3 = Credited. | |
comment |
varchar2 |
Comment | filters on the platform, writable, comment |
The comment associated with this booked item. | |
cost |
varchar2 |
Costprice | filters on the platform, writable, cost |
The cost price of the booked item. | |
created |
datetime |
Created at | filters on the platform, writable, created |
The creation date of the object in ATOM/ISO-8601 format | |
created |
int64 |
Created by ID | filters on the platform, writable, created |
The ID of the user. | |
created |
varchar2 |
Created by User Name | filters on the platform, writable, created |
The username of the user. | |
date |
datetime |
Date | filters on the platform, writable, date |
The log date of the booked item. | |
exact |
varchar2 |
itgen_bouw7_exactupdatedat | filters on the platform, writable, exact |
The last time the entity was updated in Exact Online in ATOM format. | |
garbage_ |
varchar2 |
Garbage Article Number | filters on the platform, writable, garbage. |
The article number (usually EAN) of this bookable unit. | |
garbage_ |
varchar2 |
Garbage Cost Price | filters on the platform, writable, garbage. |
The cost price of this bookable unit. | |
garbage_ |
int64 |
Garbage ID | filters on the platform, writable, garbage. |
The ID of the waste-per-unit. | |
garbage_ |
char |
Garbage Is Active | filters on the platform, writable, garbage. |
The active state of this bookable unit. | |
garbage_ |
varchar2 |
Garbage Name | filters on the platform, writable, garbage. |
The name of the waste. | |
garbage_ |
varchar2 |
Garbage Selling Price | filters on the platform, writable, garbage. |
The selling price of this bookable unit. | |
garbage_ |
varchar2 |
Garbage Unit | filters on the platform, writable, garbage. |
The name of the unit which quantifies the waste. | |
garbage_ |
int64 |
Garbage Unit ID | filters on the platform, writable, garbage. |
The id of the unit which quantifies the waste. | |
garbage_ |
int64 |
Garbage Waste ID | filters on the platform, writable, garbage. |
The ID of the waste. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of this waste booking. | |
invoice |
int64 |
Invoice Line ID | filters on the platform, writable, invoice |
The ID of the invoice line. | |
invoice |
int64 |
Invoice Line Invoice ID | filters on the platform, writable, invoice |
The ID of the invoice this invoice line belongs to. | |
invoice |
int64 |
Invoice Line Invoice Status ID | filters on the platform, writable, invoice |
The ID of the status of the invoice this line belongs to. | |
invoiced |
varchar2 |
Invoiced Amount | filters on the platform, writable, invoiced |
The invoiced amount of the booked item. | |
is |
char |
itgen_bouw7_ismutable | filters on the platform, writable, is |
Whether the booked item is mutable. | |
project_ |
int64 |
Project Branch ID | filters on the platform, writable, project. |
The ID of the branch of this project. | |
project_ |
int64 |
Project Category ID | filters on the platform, writable, project. |
The ID of the category of this project. | |
project_ |
int64 |
Project Division ID | filters on the platform, writable, project. |
The ID of the division of this project. | |
project_ |
int64 |
Project ID | filters on the platform, writable, project. |
The ID of the project. | |
project_ |
varchar2 |
Project Name | filters on the platform, writable, project. |
The name of the project. | |
project_ |
varchar2 |
Project Number | filters on the platform, writable, project. |
The number of the project. | |
project_ |
varchar2 |
Project Status | filters on the platform, writable, project. |
The name of the current status of this project. | |
project_ |
int64 |
Project Status ID | filters on the platform, writable, project. |
The ID of the status of this project. | |
quantity |
varchar2 |
Quantity | filters on the platform, writable, quantity |
The quantity of the booked item. | |
selling |
varchar2 |
Selling Price | filters on the platform, writable, selling |
The selling price of the booked item. | |
total |
varchar2 |
Total Cost Price | filters on the platform, writable, total |
The total cost price of the booked item. | |
total |
varchar2 |
Total Selling Price | filters on the platform, writable, total |
The total selling price of the booked item. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The creation date of the object in ATOM/ISO-8601 format | |
updated |
int64 |
Updated by ID | filters on the platform, writable, updated |
The ID of the user. | |
updated |
varchar2 |
Updated by User Name | filters on the platform, writable, updated |
The username of the user. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: