DeliveryTickets: Bouw7 Delivery Tickets
popular read only REST
- Catalog:
Bouw7 - Schema:
DeliveryTicket - Label: Delivery Tickets
Returns a list of delivery tickets associated with your organization. Returns a list of delivery tickets associated your organization.
Can only retrieve data.
Summary
Returns a list of delivery tickets associated your organization.
API Source
- Endpoint:
/list/delivery-tickets - Operation:
get /list/delivery-tickets
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 90 |
| Full scan rows per minute | 502,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 DeliveryTickets 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 current booking status. 0 = Registered, 1 = Invoiced, 2 = Not billable, 3 = Credited. | |
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 date of the delivery ticket, represented in ATOM-format. | |
description |
varchar2 |
Description | filters on the platform, writable, description |
The description of this delivery ticket. May contain HTML content. | |
file |
varchar2 |
This field is dynamically hydrated by the 'addFileAndPurchaseInvoiceInformation'-method in the schema factory. | filters on the platform, writable, file |
The hash of the file associated with the DeliveryTicket. | |
file |
varchar2 |
This field is dynamically hydrated by the 'addFileAndPurchaseInvoiceInformation'-method in the schema factory. | filters on the platform, writable, file |
The name of the file associated with the DeliveryTicket. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of this delivery ticket. | |
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. | |
is |
char |
Is Processed | filters on the platform, writable, is |
Whether this delivery ticket has been processed. | |
number |
varchar2 |
Number | filters on the platform, writable, number |
The ticket number of this delivery ticket. | |
price |
varchar2 |
Price | filters on the platform, writable, price |
The price of this delivery ticket. | |
project |
varchar2 |
Project Security Link Code | filters on the platform, writable, project |
The security code. | |
project |
int64 |
itgen_bouw7_projectsecuritylink_costtype | filters on the platform, writable, project |
The name of the cost type. | |
project |
int64 |
Project Security Link ID | filters on the platform, writable, project |
The ID of the project security link. | |
project |
varchar2 |
Project Security Link Name | filters on the platform, writable, project |
The name of the project security link. | |
project |
varchar2 |
itgen_bouw7_projectsecuritylink_parentname | filters on the platform, writable, project |
The name of the security code. | |
project |
int64 |
Project Security Link Project ID | filters on the platform, writable, project |
The ID of the project associated with this security code. | |
project |
int64 |
Project Security Link Status | filters on the platform, writable, project |
The status of the project security link. | |
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. | |
purchase |
int64 |
This field is dynamically hydrated by the 'addFileAndPurchaseInvoiceInformation'-method in the schema factory. | filters on the platform, writable, purchase |
The ID of the PurchaseInvoice associated with the DeliveryTicket. | |
purchase |
varchar2 |
This field is dynamically hydrated by the 'addFileAndPurchaseInvoiceInformation'-method in the schema factory. | filters on the platform, writable, purchase |
The PurchaseInvoice invoice number associated with the DeliveryTicket. | |
purchase |
int64 |
Purchase Type ID | filters on the platform, writable, purchase |
The ID of the purchase type of this delivery ticket. | |
purchase |
varchar2 |
Purchase Type Name | filters on the platform, writable, purchase |
The name of the purchase type of this delivery ticket. | |
secure |
varchar2 |
This field is dynamically hydrated by the 'addFileAndPurchaseInvoiceInformation'-method in the schema factory. | filters on the platform, writable, secure |
A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. | |
supplier_ |
varchar2 |
Supplier Email Address | filters on the platform, writable, supplier. |
The email address of the contact. | |
supplier_ |
int64 |
Supplier ID | filters on the platform, writable, supplier. |
The ID of the contact. | |
supplier_ |
varchar2 |
Supplier Name | filters on the platform, writable, supplier. |
The name of this contact. | |
supplier_ |
varchar2 |
Supplier Type | filters on the platform, writable, supplier. |
The type of this contact. | |
supplier_ |
int64 |
Supplier Type ID | filters on the platform, writable, supplier. |
The type ID of this contact. | |
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: