---
title: "DeliveryTicket_ProjectCategoryDivisionSettings (Bouw7)"
description: "itgen_bouw7_deliveryticket_projectcategorydivisionsettings_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/exactonlinebouw/Bouw7.DeliveryTicket.DeliveryTicket_ProjectCategoryDivisionSettings
original: https://documentation.invantive.eu/en/datamodels/exactonlinebouw/Bouw7.DeliveryTicket.DeliveryTicket_ProjectCategoryDivisionSettings
updated: 2026-11-01T17:44:22Z
license: https://documentation.invantive.eu/en/
---

# DeliveryTicket_ProjectCategoryDivisionSettings: Bouw7 itgen_bouw7_deliveryticket_projectcategorydivisionsettings_plural

`read only` `REST`

- Catalog: `Bouw7`
- Schema: `DeliveryTicket`
- Label: itgen_bouw7_deliveryticket_projectcategorydivisionsettings_plural

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` | `` | [x] |  |  |

## Table Columns

The columns of the table `DeliveryTicket_ProjectCategoryDivisionSettings` 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 |
|---|---|---|:---:|---|---|
| `branch_code` | `varchar2` | Branch Code | [ ] | writable, `::ancestor.::ancestor.branch.code` | The code for this branch |
| `branch_id` | `int64` | Branch ID | [ ] | writable, `::ancestor.::ancestor.branch.id` | The ID of the branch. |
| `branch_name` | `varchar2` | Branch Name | [ ] | writable, `::ancestor.::ancestor.branch.name` | The name of this branch |
| `canDelete` | `char` | Can Delete | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.canDelete` | Whether this delivery ticket can be deleted. |
| `city` | `varchar2` | City | [ ] | writable, `::ancestor.::ancestor.city` | The city of the project. |
| `code` | `varchar2` | Code | [ ] | writable, `::ancestor.code` | The code for the category. |
| `contact_contactType_id` | `int64` | Contact Contact Type ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contact.contactType.id` | The ID of contact type. |
| `contact_contactType_name` | `varchar2` | Contact Contact Type Name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contact.contactType.name` | The name of contact type. |
| `contact_email` | `varchar2` | Contact Email | [ ] | writable, `::ancestor.::ancestor.contact.email` | The email address. |
| `contact_email_2` | `varchar2` | itgen_bouw7_contact_email_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contact.email` | The email address. |
| `contact_id` | `int64` | Contact ID | [ ] | writable, `::ancestor.::ancestor.contact.id` | ID of contact. |
| `contact_id_2` | `int64` | itgen_bouw7_contact_id_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contact.id` | ID of contact. |
| `contact_isVatShifted` | `char` | Contact Is VAT Shifted | [ ] | writable, `::ancestor.::ancestor.contact.isVatShifted` | Whether VAT is shifted for the contact. |
| `contact_isVatShifted_2` | `char` | itgen_bouw7_contact_isvatshifted_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contact.isVatShifted` | Whether VAT is shifted for the contact. |
| `contact_name` | `varchar2` | Contact Name | [ ] | writable, `::ancestor.::ancestor.contact.name` | Name of contact. |
| `contact_name_2` | `varchar2` | itgen_bouw7_contact_name_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contact.name` | Name of contact. |
| `contact_phoneNumber` | `varchar2` | Contact Phone Number | [ ] | writable, `::ancestor.::ancestor.contact.phoneNumber` | The phone number of the contact. |
| `contact_phoneNumber_2` | `varchar2` | itgen_bouw7_contact_phonenumber_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contact.phoneNumber` | The phone number of the contact. |
| `contract_contractNumber` | `varchar2` | Contract Number | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contract.contractNumber` | The number of the contract. |
| `contract_id` | `int64` | Contract ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contract.id` | The ID of the contract. |
| `contract_type` | `int64` | Contract Type | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.contract.type` | Type of the contract. |
| `cost` | `varchar2` | Cost | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.cost` | The costs for this delivery ticket. |
| `createdAt` | `datetime` | Created at | [ ] | writable, `::ancestor.createdAt` | The creation time of the entity. |
| `createdAt_2` | `datetime` | Created at | [ ] | writable, `::ancestor.::ancestor.createdAt` | The creation time of the entity. |
| `createdAt_3` | `datetime` | itgen_bouw7_createdat_3 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.createdAt` | The creation time of the entity. |
| `createdBy` | `varchar2` | Created by | [ ] | writable, `::ancestor.createdBy` | The user that created the entity. |
| `createdBy_2` | `varchar2` | Created by | [ ] | writable, `::ancestor.::ancestor.createdBy` | The user that created the entity. |
| `createdBy_3` | `varchar2` | itgen_bouw7_createdby_3 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.createdBy` | The user that created the entity. |
| `deliveryDate` | `datetime` | Delivery Date | [ ] | writable, `::ancestor.::ancestor.deliveryDate` | Delivery date for the project. |
| `description` | `varchar2` | Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.description` | The description of this delivery ticket |
| `endDate` | `datetime` | End Date | [ ] | writable, `::ancestor.::ancestor.endDate` | End date for the project. |
| `file_createdAt` | `datetime` | File Created at | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.createdAt` | The creation time of the entity. |
| `file_createdBy` | `varchar2` | File Created by | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.createdBy` | The user that created the entity. |
| `file_extension` | `varchar2` | File Extension | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.extension` | The extension of the file. |
| `file_id` | `int64` | File ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.id` | The ID of this file |
| `file_modelId` | `int64` | File Model ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.modelId` | The ID of the associated type. |
| `file_modelType` | `varchar2` | File Model Type | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.modelType` | The category of the file. |
| `file_name` | `varchar2` | File Name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.name` | The public name of the file. |
| `file_secureHash` | `varchar2` | itgen_bouw7_file_securehash | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.secureHash` | A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. |
| `file_size` | `int64` | File Size | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.size` | The size of the file in bytes. |
| `file_updatedAt` | `datetime` | File Updated at | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.updatedAt` | The last updated time of the entity. |
| `file_updatedBy` | `varchar2` | File Updated by | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.updatedBy` | The user that last updated the entity. |
| `file_uri` | `varchar2` | File URI | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.file.uri` | The URI of the file, used to fetch the contents. |
| `fullProjectNumber` | `varchar2` | Full Project Number | [ ] | writable, `::ancestor.::ancestor.fullProjectNumber` | The full project number including year. |
| `generalCostsOrProfit` | `varchar2` | General Costs or Profit | [ ] | writable, `::ancestor.generalCostsOrProfit` | The general costs or profit for the category. |
| `generalCostsPercentage` | `varchar2` | General Costs Percentage | [ ] | writable, `::ancestor.generalCostsPercentage` | The general costs percentage for the category. |
| `grossProfitMargin` | `varchar2` | Gross Profit Margin | [ ] | writable, `::ancestor.grossProfitMargin` | The gross profit margin for the category. |
| `hasBookedPurchaseInvoice` | `char` | itgen_bouw7_hasbookedpurchaseinvoice | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.hasBookedPurchaseInvoice` | Whether or not the purchase invoice has been booked to a bookkeeping system. |
| `hasImmutablePurchaseInvoice` | `char` | itgen_bouw7_hasimmutablepurchaseinvoice | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.hasImmutablePurchaseInvoice` | Whether the purchase invoice is mutable. |
| `houseNumber` | `varchar2` | House Number | [ ] | writable, `::ancestor.::ancestor.houseNumber` | The house number for the project. |
| `id` | `int64` | ID | [ ] | writable, `::ancestor.id` | The ID of the category. |
| `id_2` | `int64` | ID | [ ] | writable, `::ancestor.::ancestor.id` | The ID of the project. |
| `id_3` | `int64` | itgen_bouw7_id_3 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.id` | The ID of the delivery ticket. |
| `information` | `varchar2` | Information | [ ] | writable, `::ancestor.::ancestor.information` | The information of the project. |
| `initialCost` | `varchar2` | Initial Cost | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.initialCost` | Initial cost of the delivery ticket. The value cannot be modified. |
| `name` | `varchar2` | Name | [ ] | writable, `::ancestor.name` | The name of the category. |
| `name_2` | `varchar2` | itgen_bouw7_name_2 | [ ] | writable, `::ancestor.::ancestor.name` | The name of the project. |
| `processed` | `char` | Processed | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.processed` | Whether this delivery ticket is processed. |
| `projectNumber` | `varchar2` | Project Number | [ ] | writable, `::ancestor.::ancestor.projectNumber` | The project number. |
| `projectSecurityLink_code` | `varchar2` | Project Security Link Code | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.projectSecurityLink.code` | The code of the security code. |
| `projectSecurityLink_id` | `int64` | Project Security Link ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.projectSecurityLink.id` | The unique identifier of the project security link. |
| `projectSecurityLink_name` | `varchar2` | Project Security Link Name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.projectSecurityLink.name` | The name of the project security link. |
| `purchaseInvoice_bookNumber` | `int64` | itgen_bouw7_purchaseinvoice_booknumber | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.bookNumber` | The booknumber of the purchase invoice. |
| `purchaseInvoice_branch_code` | `varchar2` | itgen_bouw7_purchaseinvoice_branch_code | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.branch.code` | The code for this branch |
| `purchaseInvoice_branch_id` | `int64` | itgen_bouw7_purchaseinvoice_branch_id | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.branch.id` | The ID of the branch. |
| `purchaseInvoice_branch_name` | `varchar2` | itgen_bouw7_purchaseinvoice_branch_name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.branch.name` | The name of this branch |
| `purchaseInvoice_canBeDeleted` | `char` | itgen_bouw7_purchaseinvoice_canbedeleted | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.canBeDeleted` | Whether the invoice can be deleted. |
| `purchaseInvoice_comments` | `varchar2` | itgen_bouw7_purchaseinvoice_comments | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.comments` | Comment associated with the purchase invoice. |
| `purchaseInvoice_contact_email` | `varchar2` | itgen_bouw7_purchaseinvoice_contact_email | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.contact.email` | The email address. |
| `purchaseInvoice_contact_id` | `int64` | itgen_bouw7_purchaseinvoice_contact_id | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.contact.id` | ID of contact. |
| `purchaseInvoice_contact_isVatShifted` | `char` | itgen_bouw7_purchaseinvoice_contact_isvatshifted | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.contact.isVatShifted` | Whether VAT is shifted for the contact. |
| `purchaseInvoice_contact_name` | `varchar2` | itgen_bouw7_purchaseinvoice_contact_name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.contact.name` | Name of contact. |
| `purchaseInvoice_contact_phoneNumber` | `varchar2` | itgen_bouw7_purchaseinvoice_contact_phonenumber | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.contact.phoneNumber` | The phone number of the contact. |
| `purchaseInvoice_createdAt` | `datetime` | itgen_bouw7_purchaseinvoice_createdat | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.createdAt` | The creation time of the entity. |
| `purchaseInvoice_createdBy` | `varchar2` | itgen_bouw7_purchaseinvoice_createdby | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.createdBy` | The user that created the entity. |
| `purchaseInvoice_date` | `datetime` | itgen_bouw7_purchaseinvoice_date | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.date` | Purchase invoice date. |
| `purchaseInvoice_deliveryTicket_cost` | `varchar2` | itgen_bouw7_purchaseinvoice_deliveryticket_cost | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.deliveryTicket.cost` | The costs for this delivery ticket. |
| `purchaseInvoice_deliveryTicket_id` | `int64` | itgen_bouw7_purchaseinvoice_deliveryticket_id | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.deliveryTicket.id` | The ID of delivery ticket. |
| `purchaseInvoice_deliveryTicket_initialCost` | `varchar2` | itgen_bouw7_purchaseinvoice_deliveryticket_initialcost | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.deliveryTicket.initialCost` | The initial costs for this delivery ticket. |
| `purchaseInvoice_deliveryTicket_processed` | `char` | itgen_bouw7_purchaseinvoice_deliveryticket_processed | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.deliveryTicket.processed` | Whether the delivery ticket has been processed. |
| `purchaseInvoice_deliveryTicket_ticketDate` | `datetime` | itgen_bouw7_purchaseinvoice_deliveryticket_ticketdate | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.deliveryTicket.ticketDate` | The date for which the delivery ticket were logged. |
| `purchaseInvoice_deliveryTicket_ticketNumber` | `varchar2` | itgen_bouw7_purchaseinvoice_deliveryticket_ticketnumber | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.deliveryTicket.ticketNumber` | Ticket number of delivery ticket. |
| `purchaseInvoice_division_description` | `varchar2` | itgen_bouw7_purchaseinvoice_division_description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.division.description` | The description of the division. |
| `purchaseInvoice_division_exactDivisionId` | `varchar2` | itgen_bouw7_purchaseinvoice_division_exactdivisionid | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.division.exactDivisionId` | The division ID of an Exact Online environment. |
| `purchaseInvoice_division_glAccountCode` | `varchar2` | itgen_bouw7_purchaseinvoice_division_glaccountcode | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.division.glAccountCode` | A default general ledger account code to use for sales related items. |
| `purchaseInvoice_division_glAccountCodePurchase` | `varchar2` | itgen_bouw7_purchaseinvoice_division_glaccountcodepurchase | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.division.glAccountCodePurchase` | A default general ledger account code to use for purchase related items. |
| `purchaseInvoice_division_id` | `int64` | itgen_bouw7_purchaseinvoice_division_id | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.division.id` | The ID of the division. |
| `purchaseInvoice_division_journalCode` | `varchar2` | itgen_bouw7_purchaseinvoice_division_journalcode | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.division.journalCode` | A default journal code to use for sales related items. |
| `purchaseInvoice_division_journalCodePurchase` | `varchar2` | itgen_bouw7_purchaseinvoice_division_journalcodepurchase | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.division.journalCodePurchase` | A default journal code to use for purchase related items. |
| `purchaseInvoice_division_salesInvoiceNumberPrefix` | `varchar2(3)` | itgen_bouw7_purchaseinvoice_division_salesinvoicenumberprefix | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.division.salesInvoiceNumberPrefix` | The prefix (3 digits) used to generate invoice number range per division. |
| `purchaseInvoice_id` | `int64` | itgen_bouw7_purchaseinvoice_id | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.id` | The ID of purchase invoice. |
| `purchaseInvoice_invoiceNumber` | `varchar2` | itgen_bouw7_purchaseinvoice_invoicenumber | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.invoiceNumber` | The invoice number of purchase invoice. |
| `purchaseInvoice_isBooked` | `char` | itgen_bouw7_purchaseinvoice_isbooked | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.isBooked` | Whether or not the purchase invoice has been booked to a bookkeeping system. |
| `purchaseInvoice_orderNumber` | `varchar2` | itgen_bouw7_purchaseinvoice_ordernumber | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.orderNumber` | The order number of the purchase invoice. |
| `purchaseInvoice_project_city` | `varchar2` | itgen_bouw7_purchaseinvoice_project_city | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.city` | The city of the project. |
| `purchaseInvoice_project_createdAt` | `datetime` | itgen_bouw7_purchaseinvoice_project_createdat | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.createdAt` | The creation time of the entity. |
| `purchaseInvoice_project_createdBy` | `varchar2` | itgen_bouw7_purchaseinvoice_project_createdby | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.createdBy` | The user that created the entity. |
| `purchaseInvoice_project_deliveryDate` | `datetime` | itgen_bouw7_purchaseinvoice_project_deliverydate | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.deliveryDate` | Delivery date for the project. |
| `purchaseInvoice_project_endDate` | `datetime` | itgen_bouw7_purchaseinvoice_project_enddate | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.endDate` | End date for the project. |
| `purchaseInvoice_project_fullProjectNumber` | `varchar2` | itgen_bouw7_purchaseinvoice_project_fullprojectnumber | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.fullProjectNumber` | The full project number including year. |
| `purchaseInvoice_project_houseNumber` | `varchar2` | itgen_bouw7_purchaseinvoice_project_housenumber | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.houseNumber` | The house number for the project. |
| `purchaseInvoice_project_id` | `int64` | itgen_bouw7_purchaseinvoice_project_id | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.id` | The ID of the project. |
| `purchaseInvoice_project_information` | `varchar2` | itgen_bouw7_purchaseinvoice_project_information | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.information` | The information of the project. |
| `purchaseInvoice_project_name` | `varchar2` | itgen_bouw7_purchaseinvoice_project_name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.name` | The name of the project. |
| `purchaseInvoice_project_projectNumber` | `varchar2` | itgen_bouw7_purchaseinvoice_project_projectnumber | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.projectNumber` | The project number. |
| `purchaseInvoice_project_reference` | `varchar2` | itgen_bouw7_purchaseinvoice_project_reference | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.reference` | The reference of the project. |
| `purchaseInvoice_project_startDate` | `datetime` | itgen_bouw7_purchaseinvoice_project_startdate | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.startDate` | Start date for the project. |
| `purchaseInvoice_project_streetName` | `varchar2` | itgen_bouw7_purchaseinvoice_project_streetname | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.streetName` | The street name for the project. |
| `purchaseInvoice_project_updatedAt` | `datetime` | itgen_bouw7_purchaseinvoice_project_updatedat | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.updatedAt` | The last updated time of the entity. |
| `purchaseInvoice_project_updatedBy` | `varchar2` | itgen_bouw7_purchaseinvoice_project_updatedby | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.updatedBy` | The user that last updated the entity. |
| `purchaseInvoice_project_zipCode` | `varchar2` | itgen_bouw7_purchaseinvoice_project_zipcode | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.project.zipCode` | The zip code for the project. |
| `purchaseInvoice_status` | `int64` | itgen_bouw7_purchaseinvoice_status | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.status` | Status of the purchase invoice. |
| `purchaseInvoice_totalExcludingVat` | `varchar2` | itgen_bouw7_purchaseinvoice_totalexcludingvat | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.totalExcludingVat` | Price excluding VAT of the purchase invoice. |
| `purchaseInvoice_totalIncludingVat` | `varchar2` | itgen_bouw7_purchaseinvoice_totalincludingvat | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.totalIncludingVat` | Price including VAT of the purchase invoice. |
| `purchaseInvoice_updatedAt` | `datetime` | itgen_bouw7_purchaseinvoice_updatedat | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.updatedAt` | The last updated time of the entity. |
| `purchaseInvoice_updatedBy` | `varchar2` | itgen_bouw7_purchaseinvoice_updatedby | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseInvoice.updatedBy` | The user that last updated the entity. |
| `purchaseType` | `int64` | Purchase Type | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.purchaseType` | The purchase type. |
| `reference` | `varchar2` | Reference | [ ] | writable, `::ancestor.::ancestor.reference` | The reference of the project. |
| `startDate` | `datetime` | Start Date | [ ] | writable, `::ancestor.::ancestor.startDate` | Start date for the project. |
| `status_closesProject` | `char` | Status Closes Project | [ ] | writable, `::ancestor.::ancestor.status.closesProject` | Whether or not this status closes a project. |
| `status_createdAt` | `datetime` | Status Created at | [ ] | writable, `::ancestor.::ancestor.status.createdAt` | The creation time of the entity. |
| `status_createdBy` | `varchar2` | Status Created by | [ ] | writable, `::ancestor.::ancestor.status.createdBy` | The user that created the entity. |
| `status_id` | `int64` | Status ID | [ ] | writable, `::ancestor.::ancestor.status.id` | The ID of the status. |
| `status_invoicesProject` | `char` | Status Invoices Project | [ ] | writable, `::ancestor.::ancestor.status.invoicesProject` | Whether or not this status invoices a project. |
| `status_name` | `varchar2` | Status Name | [ ] | writable, `::ancestor.::ancestor.status.name` | The name of the status. |
| `status_plansProject` | `char` | Status Plans Project | [ ] | writable, `::ancestor.::ancestor.status.plansProject` | Whether or not this status plans a project. |
| `status_updatedAt` | `datetime` | Status Updated at | [ ] | writable, `::ancestor.::ancestor.status.updatedAt` | The last updated time of the entity. |
| `status_updatedBy` | `varchar2` | Status Updated by | [ ] | writable, `::ancestor.::ancestor.status.updatedBy` | The user that last updated the entity. |
| `streetName` | `varchar2` | Street Name | [ ] | writable, `::ancestor.::ancestor.streetName` | The street name for the project. |
| `ticketDate` | `datetime` | Ticket Date | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.ticketDate` | The date for which the delivery ticket were logged. |
| `ticketNumber` | `varchar2(256)` | Ticket Number | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.ticketNumber` | Ticket number of the delivery ticket. |
| `updatedAt` | `datetime` | Updated At | [ ] | writable, `::ancestor.updatedAt` | The last updated time of the entity. |
| `updatedAt_2` | `datetime` | Updated at | [ ] | writable, `::ancestor.::ancestor.updatedAt` | The last updated time of the entity. |
| `updatedAt_3` | `datetime` | itgen_bouw7_updatedat_3 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.updatedAt` | The last updated time of the entity. |
| `updatedBy` | `varchar2` | Updated by | [ ] | writable, `::ancestor.updatedBy` | The user that last updated the entity. |
| `updatedBy_2` | `varchar2` | Updated by | [ ] | writable, `::ancestor.::ancestor.updatedBy` | The user that last updated the entity. |
| `updatedBy_3` | `varchar2` | itgen_bouw7_updatedby_3 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.updatedBy` | The user that last updated the entity. |
| `zipCode` | `varchar2` | ZIP Code | [ ] | writable, `::ancestor.::ancestor.zipCode` | The zip code for the project. |



## Release Notes

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

- [Bouw7](/en/release-notes/drivers?driver=bouw7)

