invantive documentation
Invantive Support ForumsLog In / Sign Up

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
bookingStatus int64 Booking Status filters on the platform, writable, bookingStatus The current booking status. 0 = Registered, 1 = Invoiced, 2 = Not billable, 3 = Credited.
createdAt datetime Created at filters on the platform, writable, createdAt The creation date of the object in ATOM/ISO-8601 format
createdBy_id int64 Created by ID filters on the platform, writable, createdBy.id The ID of the user.
createdBy_username varchar2 Created by User Name filters on the platform, writable, createdBy.username 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.
fileHash varchar2 This field is dynamically hydrated by the 'addFileAndPurchaseInvoiceInformation'-method in the schema factory. filters on the platform, writable, fileHash The hash of the file associated with the DeliveryTicket.
fileName varchar2 This field is dynamically hydrated by the 'addFileAndPurchaseInvoiceInformation'-method in the schema factory. filters on the platform, writable, fileName The name of the file associated with the DeliveryTicket.
id int64 ID filters on the platform, writable, id The ID of this delivery ticket.
invoiceLine_id int64 Invoice Line ID filters on the platform, writable, invoiceLine.id The ID of the invoice line.
invoiceLine_invoiceId int64 Invoice Line Invoice ID filters on the platform, writable, invoiceLine.invoiceId The ID of the invoice this invoice line belongs to.
invoiceLine_invoiceStatusId int64 Invoice Line Invoice Status ID filters on the platform, writable, invoiceLine.invoiceStatusId The ID of the status of the invoice this line belongs to.
isProcessed char Is Processed filters on the platform, writable, isProcessed 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.
projectSecurityLink_code varchar2 Project Security Link Code filters on the platform, writable, projectSecurityLink.code The security code.
projectSecurityLink_costType int64 itgen_bouw7_projectsecuritylink_costtype filters on the platform, writable, projectSecurityLink.costType The name of the cost type.
projectSecurityLink_id int64 Project Security Link ID filters on the platform, writable, projectSecurityLink.id The ID of the project security link.
projectSecurityLink_name varchar2 Project Security Link Name filters on the platform, writable, projectSecurityLink.name The name of the project security link.
projectSecurityLink_parentName varchar2 itgen_bouw7_projectsecuritylink_parentname filters on the platform, writable, projectSecurityLink.parentName The name of the security code.
projectSecurityLink_projectId int64 Project Security Link Project ID filters on the platform, writable, projectSecurityLink.projectId The ID of the project associated with this security code.
projectSecurityLink_status int64 Project Security Link Status filters on the platform, writable, projectSecurityLink.status The status of the project security link.
project_branchId int64 Project Branch ID filters on the platform, writable, project.branchId The ID of the branch of this project.
project_categoryId int64 Project Category ID filters on the platform, writable, project.categoryId The ID of the category of this project.
project_divisionId int64 Project Division ID filters on the platform, writable, project.divisionId The ID of the division of this project.
project_id int64 Project ID filters on the platform, writable, project.id The ID of the project.
project_name varchar2 Project Name filters on the platform, writable, project.name The name of the project.
project_number varchar2 Project Number filters on the platform, writable, project.number The number of the project.
project_status varchar2 Project Status filters on the platform, writable, project.status The name of the current status of this project.
project_statusId int64 Project Status ID filters on the platform, writable, project.statusId The ID of the status of this project.
purchaseInvoiceId int64 This field is dynamically hydrated by the 'addFileAndPurchaseInvoiceInformation'-method in the schema factory. filters on the platform, writable, purchaseInvoiceId The ID of the PurchaseInvoice associated with the DeliveryTicket.
purchaseInvoiceInvoiceNumber varchar2 This field is dynamically hydrated by the 'addFileAndPurchaseInvoiceInformation'-method in the schema factory. filters on the platform, writable, purchaseInvoiceInvoiceNumber The PurchaseInvoice invoice number associated with the DeliveryTicket.
purchaseTypeId int64 Purchase Type ID filters on the platform, writable, purchaseTypeId The ID of the purchase type of this delivery ticket.
purchaseTypeName varchar2 Purchase Type Name filters on the platform, writable, purchaseTypeName The name of the purchase type of this delivery ticket.
secureHash varchar2 This field is dynamically hydrated by the 'addFileAndPurchaseInvoiceInformation'-method in the schema factory. filters on the platform, writable, secureHash A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication.
supplier_emailAddress varchar2 Supplier Email Address filters on the platform, writable, supplier.emailAddress The email address of the contact.
supplier_id int64 Supplier ID filters on the platform, writable, supplier.id The ID of the contact.
supplier_name varchar2 Supplier Name filters on the platform, writable, supplier.name The name of this contact.
supplier_type varchar2 Supplier Type filters on the platform, writable, supplier.type The type of this contact.
supplier_typeId int64 Supplier Type ID filters on the platform, writable, supplier.typeId The type ID of this contact.
updatedAt datetime Updated At filters on the platform, writable, updatedAt The creation date of the object in ATOM/ISO-8601 format
updatedBy_id int64 Updated by ID filters on the platform, writable, updatedBy.id The ID of the user.
updatedBy_username varchar2 Updated by User Name filters on the platform, writable, updatedBy.username The username of the user.

Release Notes

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