DeliveryTicketById: Bouw7 Delivery Ticket by ID
read only REST
- Catalog:
Bouw7 - Schema:
DeliveryTicket - Label: Delivery Ticket by ID
Returns a single delivery ticket based on the given ID. Returns a single delivery ticket based on the given ID.
Can only retrieve data.
Summary
Returns a single delivery ticket based on the given ID.
API Source
- Endpoint:
/project/delivery-ticket/{id} - Operation:
get /project/delivery-ticket/{id}
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 |
|---|---|---|---|---|
id |
`` |
Table Columns
The columns of the table DeliveryTicketById 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 |
|---|---|---|---|---|---|
can |
char |
Can Delete | filters on the platform, writable, can |
Whether this delivery ticket can be deleted. | |
contact_ |
int64 |
Contact Contact Type ID | filters on the platform, writable, contact. |
The ID of contact type. | |
contact_ |
varchar2 |
Contact Contact Type Name | filters on the platform, writable, contact. |
The name of contact type. | |
contact_ |
varchar2 |
Contact Email | filters on the platform, writable, contact. |
The email address. | |
contact_ |
int64 |
Contact ID | filters on the platform, writable, contact. |
ID of contact. | |
contact_ |
char |
Contact Is VAT Shifted | filters on the platform, writable, contact. |
Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Contact Name | filters on the platform, writable, contact. |
Name of contact. | |
contact_ |
varchar2 |
Contact Phone Number | filters on the platform, writable, contact. |
The phone number of the contact. | |
contract_ |
varchar2 |
Contract Number | filters on the platform, writable, contract. |
The number of the contract. | |
contract_ |
int64 |
Contract ID | filters on the platform, writable, contract. |
The ID of the contract. | |
contract_ |
int64 |
Contract Type | filters on the platform, writable, contract. |
Type of the contract. | |
cost |
varchar2 |
Cost | filters on the platform, writable, cost |
The costs for this delivery ticket. | |
created |
datetime |
Created at | filters on the platform, writable, created |
The creation time of the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, created |
The user that created the entity. | |
description |
varchar2 |
Description | filters on the platform, writable, description |
The description of this delivery ticket | |
file_ |
datetime |
File Created at | filters on the platform, writable, file. |
The creation time of the entity. | |
file_ |
varchar2 |
File Created by | filters on the platform, writable, file. |
The user that created the entity. | |
file_ |
varchar2 |
File Extension | filters on the platform, writable, file. |
The extension of the file. | |
file_ |
int64 |
File ID | filters on the platform, writable, file. |
The ID of this file | |
file_ |
int64 |
File Model ID | filters on the platform, writable, file. |
The ID of the associated type. | |
file_ |
varchar2 |
File Model Type | filters on the platform, writable, file. |
The category of the file. | |
file_ |
varchar2 |
File Name | filters on the platform, writable, file. |
The public name of the file. | |
file_ |
varchar2 |
itgen_bouw7_file_securehash | filters on the platform, writable, file. |
A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. | |
file_ |
int64 |
File Size | filters on the platform, writable, file. |
The size of the file in bytes. | |
file_ |
datetime |
File Updated at | filters on the platform, writable, file. |
The last updated time of the entity. | |
file_ |
varchar2 |
File Updated by | filters on the platform, writable, file. |
The user that last updated the entity. | |
file_ |
varchar2 |
File URI | filters on the platform, writable, file. |
The URI of the file, used to fetch the contents. | |
has |
char |
itgen_bouw7_hasbookedpurchaseinvoice | filters on the platform, writable, has |
Whether or not the purchase invoice has been booked to a bookkeeping system. | |
has |
char |
itgen_bouw7_hasimmutablepurchaseinvoice | filters on the platform, writable, has |
Whether the purchase invoice is mutable. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of the delivery ticket. | |
initial |
varchar2 |
Initial Cost | filters on the platform, writable, initial |
Initial cost of the delivery ticket. The value cannot be modified. | |
processed |
char |
Processed | filters on the platform, writable, processed |
Whether this delivery ticket is processed. | |
project |
varchar2 |
Project Security Link Code | filters on the platform, writable, project |
The code of the security code. | |
project |
int64 |
Project Security Link ID | filters on the platform, writable, project |
The unique identifier 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_project_branch_code | filters on the platform, writable, project. |
The code for this branch | |
project_ |
int64 |
itgen_bouw7_project_branch_id | filters on the platform, writable, project. |
The ID of the branch. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_name | filters on the platform, writable, project. |
The name of this branch | |
project_ |
varchar2 |
itgen_bouw7_project_category_code | filters on the platform, writable, project. |
The code for the category. | |
project_ |
datetime |
itgen_bouw7_project_category_createdat | filters on the platform, writable, project. |
The creation time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_createdby | filters on the platform, writable, project. |
The user that created the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostsorprofit | filters on the platform, writable, project. |
The general costs or profit for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostspercentage | filters on the platform, writable, project. |
The general costs percentage for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_grossprofitmargin | filters on the platform, writable, project. |
The gross profit margin for the category. | |
project_ |
int64 |
itgen_bouw7_project_category_id | filters on the platform, writable, project. |
The ID of the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_name | filters on the platform, writable, project. |
The name of the category. | |
project_ |
datetime |
itgen_bouw7_project_category_updatedat | filters on the platform, writable, project. |
The last updated time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_updatedby | filters on the platform, writable, project. |
The user that last updated the entity. | |
project_ |
varchar2 |
Project City | filters on the platform, writable, project. |
The city of the project. | |
project_ |
varchar2 |
Project Contact Email | filters on the platform, writable, project. |
The email address. | |
project_ |
int64 |
Project Contact ID | filters on the platform, writable, project. |
ID of contact. | |
project_ |
char |
itgen_bouw7_project_contact_isvatshifted | filters on the platform, writable, project. |
Whether VAT is shifted for the contact. | |
project_ |
varchar2 |
Project Contact Name | filters on the platform, writable, project. |
Name of contact. | |
project_ |
varchar2 |
itgen_bouw7_project_contact_phonenumber | filters on the platform, writable, project. |
The phone number of the contact. | |
project_ |
datetime |
Project Created at | filters on the platform, writable, project. |
The creation time of the entity. | |
project_ |
varchar2 |
Project Created by | filters on the platform, writable, project. |
The user that created the entity. | |
project_ |
datetime |
Project Delivery Date | filters on the platform, writable, project. |
Delivery date for the project. | |
project_ |
datetime |
Project End Date | filters on the platform, writable, project. |
End date for the project. | |
project_ |
varchar2 |
Project Full Project Number | filters on the platform, writable, project. |
The full project number including year. | |
project_ |
varchar2 |
Project House Number | filters on the platform, writable, project. |
The house number for the project. | |
project_ |
int64 |
Project ID | filters on the platform, writable, project. |
The ID of the project. | |
project_ |
varchar2 |
Project Information | filters on the platform, writable, project. |
The information of the project. | |
project_ |
varchar2 |
Project Name | filters on the platform, writable, project. |
The name of the project. | |
project_ |
varchar2 |
Project Project Number | filters on the platform, writable, project. |
The project number. | |
project_ |
varchar2 |
Project Reference | filters on the platform, writable, project. |
The reference of the project. | |
project_ |
datetime |
Project Start Date | filters on the platform, writable, project. |
Start date for the project. | |
project_ |
char |
Project Status Closes Project | filters on the platform, writable, project. |
Whether or not this status closes a project. | |
project_ |
datetime |
Project Status Created at | filters on the platform, writable, project. |
The creation time of the entity. | |
project_ |
varchar2 |
Project Status Created by | filters on the platform, writable, project. |
The user that created the entity. | |
project_ |
int64 |
Project Status ID | filters on the platform, writable, project. |
The ID of the status. | |
project_ |
char |
Project Status Invoices Project | filters on the platform, writable, project. |
Whether or not this status invoices a project. | |
project_ |
varchar2 |
Project Status Name | filters on the platform, writable, project. |
The name of the status. | |
project_ |
char |
Project Status Plans Project | filters on the platform, writable, project. |
Whether or not this status plans a project. | |
project_ |
datetime |
Project Status Updated at | filters on the platform, writable, project. |
The last updated time of the entity. | |
project_ |
varchar2 |
Project Status Updated by | filters on the platform, writable, project. |
The user that last updated the entity. | |
project_ |
varchar2 |
Project Street Name | filters on the platform, writable, project. |
The street name for the project. | |
project_ |
datetime |
Project Updated at | filters on the platform, writable, project. |
The last updated time of the entity. | |
project_ |
varchar2 |
Project Updated by | filters on the platform, writable, project. |
The user that last updated the entity. | |
project_ |
varchar2 |
Project ZIP Code | filters on the platform, writable, project. |
The zip code for the project. | |
purchase |
int64 |
itgen_bouw7_purchaseinvoice_booknumber | filters on the platform, writable, purchase |
The booknumber of the purchase invoice. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_branch_code | filters on the platform, writable, purchase |
The code for this branch | |
purchase |
int64 |
itgen_bouw7_purchaseinvoice_branch_id | filters on the platform, writable, purchase |
The ID of the branch. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_branch_name | filters on the platform, writable, purchase |
The name of this branch | |
purchase |
char |
itgen_bouw7_purchaseinvoice_canbedeleted | filters on the platform, writable, purchase |
Whether the invoice can be deleted. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_comments | filters on the platform, writable, purchase |
Comment associated with the purchase invoice. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_contact_email | filters on the platform, writable, purchase |
The email address. | |
purchase |
int64 |
itgen_bouw7_purchaseinvoice_contact_id | filters on the platform, writable, purchase |
ID of contact. | |
purchase |
char |
itgen_bouw7_purchaseinvoice_contact_isvatshifted | filters on the platform, writable, purchase |
Whether VAT is shifted for the contact. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_contact_name | filters on the platform, writable, purchase |
Name of contact. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_contact_phonenumber | filters on the platform, writable, purchase |
The phone number of the contact. | |
purchase |
datetime |
itgen_bouw7_purchaseinvoice_createdat | filters on the platform, writable, purchase |
The creation time of the entity. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_createdby | filters on the platform, writable, purchase |
The user that created the entity. | |
purchase |
datetime |
itgen_bouw7_purchaseinvoice_date | filters on the platform, writable, purchase |
Purchase invoice date. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_deliveryticket_cost | filters on the platform, writable, purchase |
The costs for this delivery ticket. | |
purchase |
int64 |
itgen_bouw7_purchaseinvoice_deliveryticket_id | filters on the platform, writable, purchase |
The ID of delivery ticket. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_deliveryticket_initialcost | filters on the platform, writable, purchase |
The initial costs for this delivery ticket. | |
purchase |
char |
itgen_bouw7_purchaseinvoice_deliveryticket_processed | filters on the platform, writable, purchase |
Whether the delivery ticket has been processed. | |
purchase |
datetime |
itgen_bouw7_purchaseinvoice_deliveryticket_ticketdate | filters on the platform, writable, purchase |
The date for which the delivery ticket were logged. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_deliveryticket_ticketnumber | filters on the platform, writable, purchase |
Ticket number of delivery ticket. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_division_description | filters on the platform, writable, purchase |
The description of the division. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_division_exactdivisionid | filters on the platform, writable, purchase |
The division ID of an Exact Online environment. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_division_glaccountcode | filters on the platform, writable, purchase |
A default general ledger account code to use for sales related items. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_division_glaccountcodepurchase | filters on the platform, writable, purchase |
A default general ledger account code to use for purchase related items. | |
purchase |
int64 |
itgen_bouw7_purchaseinvoice_division_id | filters on the platform, writable, purchase |
The ID of the division. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_division_journalcode | filters on the platform, writable, purchase |
A default journal code to use for sales related items. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_division_journalcodepurchase | filters on the platform, writable, purchase |
A default journal code to use for purchase related items. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_division_salesinvoicenumberprefix | filters on the platform, writable, purchase |
The prefix (3 digits) used to generate invoice number range per division. | |
purchase |
int64 |
itgen_bouw7_purchaseinvoice_id | filters on the platform, writable, purchase |
The ID of purchase invoice. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_invoicenumber | filters on the platform, writable, purchase |
The invoice number of purchase invoice. | |
purchase |
char |
itgen_bouw7_purchaseinvoice_isbooked | filters on the platform, writable, purchase |
Whether or not the purchase invoice has been booked to a bookkeeping system. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_ordernumber | filters on the platform, writable, purchase |
The order number of the purchase invoice. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_project_city | filters on the platform, writable, purchase |
The city of the project. | |
purchase |
datetime |
itgen_bouw7_purchaseinvoice_project_createdat | filters on the platform, writable, purchase |
The creation time of the entity. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_project_createdby | filters on the platform, writable, purchase |
The user that created the entity. | |
purchase |
datetime |
itgen_bouw7_purchaseinvoice_project_deliverydate | filters on the platform, writable, purchase |
Delivery date for the project. | |
purchase |
datetime |
itgen_bouw7_purchaseinvoice_project_enddate | filters on the platform, writable, purchase |
End date for the project. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_project_fullprojectnumber | filters on the platform, writable, purchase |
The full project number including year. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_project_housenumber | filters on the platform, writable, purchase |
The house number for the project. | |
purchase |
int64 |
itgen_bouw7_purchaseinvoice_project_id | filters on the platform, writable, purchase |
The ID of the project. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_project_information | filters on the platform, writable, purchase |
The information of the project. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_project_name | filters on the platform, writable, purchase |
The name of the project. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_project_projectnumber | filters on the platform, writable, purchase |
The project number. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_project_reference | filters on the platform, writable, purchase |
The reference of the project. | |
purchase |
datetime |
itgen_bouw7_purchaseinvoice_project_startdate | filters on the platform, writable, purchase |
Start date for the project. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_project_streetname | filters on the platform, writable, purchase |
The street name for the project. | |
purchase |
datetime |
itgen_bouw7_purchaseinvoice_project_updatedat | filters on the platform, writable, purchase |
The last updated time of the entity. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_project_updatedby | filters on the platform, writable, purchase |
The user that last updated the entity. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_project_zipcode | filters on the platform, writable, purchase |
The zip code for the project. | |
purchase |
int64 |
itgen_bouw7_purchaseinvoice_status | filters on the platform, writable, purchase |
Status of the purchase invoice. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_totalexcludingvat | filters on the platform, writable, purchase |
Price excluding VAT of the purchase invoice. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_totalincludingvat | filters on the platform, writable, purchase |
Price including VAT of the purchase invoice. | |
purchase |
datetime |
itgen_bouw7_purchaseinvoice_updatedat | filters on the platform, writable, purchase |
The last updated time of the entity. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoice_updatedby | filters on the platform, writable, purchase |
The user that last updated the entity. | |
purchase |
int64 |
Purchase Type | filters on the platform, writable, purchase |
The purchase type. | |
ticket |
datetime |
Ticket Date | filters on the platform, writable, ticket |
The date for which the delivery ticket were logged. | |
ticket |
varchar2 |
Ticket Number | filters on the platform, writable, ticket |
Ticket number of the delivery ticket. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, updated |
The user that last updated the entity. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: