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

# PurchaseOrder_CommonAttachments: Bouw7 itgen_bouw7_purchaseorder_commonattachments_plural

`read only` `REST`

- Catalog: `Bouw7`
- Schema: `Contract`
- Label: itgen_bouw7_purchaseorder_commonattachments_plural

Returns a single purchase order contract based on the given ID.
Returns a single purchase order contract based on the given ID.

Can only retrieve data.

## Summary

Returns a single purchase order contract based on the given ID.

## API Source

- Endpoint: `/contracts/purchase-order/{id}`
- Operation: `get /contracts/purchase-order/{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 `PurchaseOrder_CommonAttachments` 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 |
|---|---|---|:---:|---|---|
| `acceptedAt` | `varchar2` | Accepted at | [ ] | filters on the platform, writable, `::ancestor.acceptedAt` | Datetime when contract was accepted. |
| `approval_canApprove` | `char` | itgen_bouw7_approval_canapprove | [ ] | filters on the platform, writable, `::ancestor.approval.canApprove` | Whether or not the current authenticated user can approve the approval. |
| `approval_createdAt` | `datetime` | itgen_bouw7_approval_createdat | [ ] | filters on the platform, writable, `::ancestor.approval.createdAt` | The creation time of the entity. |
| `approval_createdBy` | `varchar2` | itgen_bouw7_approval_createdby | [ ] | filters on the platform, writable, `::ancestor.approval.createdBy` | The user that created the entity. |
| `approval_currentApprover_approvalDate` | `datetime` | itgen_bouw7_approval_currentapprover_approvaldate | [ ] | filters on the platform, writable, `::ancestor.approval.currentApprover.approvalDate` | The date at which the approver denied/approved the approval. |
| `approval_currentApprover_approvalStatus` | `int64` | itgen_bouw7_approval_currentapprover_approvalstatus | [ ] | filters on the platform, writable, `::ancestor.approval.currentApprover.approvalStatus` | The approval status of this approver. |
| `approval_currentApprover_comment` | `varchar2` | itgen_bouw7_approval_currentapprover_comment | [ ] | filters on the platform, writable, `::ancestor.approval.currentApprover.comment` | Comment left by the approver. Can be null. |
| `approval_currentApprover_createdAt` | `datetime` | itgen_bouw7_approval_currentapprover_createdat | [ ] | filters on the platform, writable, `::ancestor.approval.currentApprover.createdAt` | The creation time of the entity. |
| `approval_currentApprover_createdBy` | `varchar2` | itgen_bouw7_approval_currentapprover_createdby | [ ] | filters on the platform, writable, `::ancestor.approval.currentApprover.createdBy` | The user that created the entity. |
| `approval_currentApprover_id` | `int64` | itgen_bouw7_approval_currentapprover_id | [ ] | filters on the platform, writable, `::ancestor.approval.currentApprover.id` | ID of the approver. |
| `approval_currentApprover_index` | `int64` | itgen_bouw7_approval_currentapprover_index | [ ] | filters on the platform, writable, `::ancestor.approval.currentApprover.index` | Current index of the approver. |
| `approval_currentApprover_updatedAt` | `datetime` | itgen_bouw7_approval_currentapprover_updatedat | [ ] | filters on the platform, writable, `::ancestor.approval.currentApprover.updatedAt` | The last updated time of the entity. |
| `approval_currentApprover_updatedBy` | `varchar2` | itgen_bouw7_approval_currentapprover_updatedby | [ ] | filters on the platform, writable, `::ancestor.approval.currentApprover.updatedBy` | The user that last updated the entity. |
| `approval_currentIndex` | `int64` | itgen_bouw7_approval_currentindex | [ ] | filters on the platform, writable, `::ancestor.approval.currentIndex` | The current index of the approver which turn it is to vote on the approval. |
| `approval_id` | `int64` | itgen_bouw7_approval_id | [ ] | filters on the platform, writable, `::ancestor.approval.id` | ID of the approval. |
| `approval_isApproved` | `char` | itgen_bouw7_approval_isapproved | [ ] | filters on the platform, writable, `::ancestor.approval.isApproved` | Whether or not the approval has been approved. |
| `approval_lastActionDate` | `datetime` | itgen_bouw7_approval_lastactiondate | [ ] | filters on the platform, writable, `::ancestor.approval.lastActionDate` | Date of the last action done to this approval. Will be null when no action has been made. |
| `approval_updatedAt` | `datetime` | itgen_bouw7_approval_updatedat | [ ] | filters on the platform, writable, `::ancestor.approval.updatedAt` | The last updated time of the entity. |
| `approval_updatedBy` | `varchar2` | itgen_bouw7_approval_updatedby | [ ] | filters on the platform, writable, `::ancestor.approval.updatedBy` | The user that last updated the entity. |
| `approval_workflowId` | `int64` | itgen_bouw7_approval_workflowid | [ ] | filters on the platform, writable, `::ancestor.approval.workflowId` | The workflow that this approval is based of. |
| `calledReceipts` | `int64` | Called Receipts | [ ] | filters on the platform, writable, `::ancestor.calledReceipts` | The amount of called receipt documents. |
| `contractNumber` | `varchar2` | Contract Number | [ ] | filters on the platform, writable, `::ancestor.contractNumber` | The contract number of the contract. |
| `cost` | `varchar2` | Cost | [ ] | filters on the platform, writable, `::ancestor.cost` | The cost of the contract. |
| `createDeliveryTicket` | `char` | Create Delivery Ticket | [ ] | filters on the platform, writable, `::ancestor.createDeliveryTicket` | Whether or not to create a delivery ticket. |
| `createdAt` | `datetime` | Created at | [ ] | filters on the platform, writable, `::ancestor.createdAt` | The creation time of the entity. |
| `createdBy` | `varchar2` | Created by | [ ] | filters on the platform, writable, `::ancestor.createdBy` | The user that created the entity. |
| `deliveryAddress` | `varchar2` | Delivery Address | [ ] | filters on the platform, writable, `::ancestor.deliveryAddress` | Delivery address of the purchase order contract. |
| `deliveryDate` | `datetime` | Delivery Date | [ ] | filters on the platform, writable, `::ancestor.deliveryDate` | Delivery date of the purchase order contract. |
| `deliveryDateText` | `varchar2` | Delivery Date Text | [ ] | filters on the platform, writable, `::ancestor.deliveryDateText` | Delivery date text of the purchase order contract. |
| `deniedAt` | `varchar2` | Denied at | [ ] | filters on the platform, writable, `::ancestor.deniedAt` | Datetime when contract was denied. |
| `description` | `varchar2` | Description | [ ] | filters on the platform, writable, `::ancestor.description` | The description of the contract. |
| `id` | `int64` | ID | [ ] | writable, `id` | The ID of the common contract attachment. |
| `id_2` | `int64` | ID | [ ] | filters on the platform, writable, `::ancestor.id` | The ID of the purchase order contract. |
| `internalNote` | `varchar2` | Internal Note | [ ] | filters on the platform, writable, `::ancestor.internalNote` | Internal note about the contract. |
| `language` | `varchar2` | Language | [ ] | filters on the platform, writable, `::ancestor.language` | The locale used by this contract, e.g.: nl-NL. |
| `linkedDeliveryTicket_cost` | `varchar2` | itgen_bouw7_linkeddeliveryticket_cost | [ ] | filters on the platform, writable, `::ancestor.linkedDeliveryTicket.cost` | The costs for this delivery ticket. |
| `linkedDeliveryTicket_id` | `int64` | Linked Delivery Ticket ID | [ ] | filters on the platform, writable, `::ancestor.linkedDeliveryTicket.id` | The ID of delivery ticket. |
| `linkedDeliveryTicket_initialCost` | `varchar2` | itgen_bouw7_linkeddeliveryticket_initialcost | [ ] | filters on the platform, writable, `::ancestor.linkedDeliveryTicket.initialCost` | The initial costs for this delivery ticket. |
| `linkedDeliveryTicket_processed` | `char` | itgen_bouw7_linkeddeliveryticket_processed | [ ] | filters on the platform, writable, `::ancestor.linkedDeliveryTicket.processed` | Whether the delivery ticket has been processed. |
| `linkedDeliveryTicket_ticketDate` | `datetime` | itgen_bouw7_linkeddeliveryticket_ticketdate | [ ] | filters on the platform, writable, `::ancestor.linkedDeliveryTicket.ticketDate` | The date for which the delivery ticket were logged. |
| `linkedDeliveryTicket_ticketNumber` | `varchar2` | itgen_bouw7_linkeddeliveryticket_ticketnumber | [ ] | filters on the platform, writable, `::ancestor.linkedDeliveryTicket.ticketNumber` | Ticket number of delivery ticket. |
| `logEntries` | `int64` | Log Entries | [ ] | filters on the platform, writable, `::ancestor.logEntries` | The amount of log entries. |
| `mailSent` | `char` | Mail Sent | [ ] | filters on the platform, writable, `::ancestor.mailSent` | Flag to indicate if mail was sent. |
| `mailSentAt` | `varchar2` | Mail Sent at | [ ] | filters on the platform, writable, `::ancestor.mailSentAt` | The date the contract was sent. |
| `mailSentBy` | `varchar2` | Mail Sent by | [ ] | filters on the platform, writable, `::ancestor.mailSentBy` | The user that sent the email. |
| `name` | `varchar2(255)` | Name | [ ] | filters on the platform, writable, `::ancestor.name` | The name of the contract. |
| `number` | `varchar2` | Number | [ ] | filters on the platform, writable, `::ancestor.number` | Number of the contract. |
| `paymentAgreement` | `varchar2` | Payment Agreement | [ ] | filters on the platform, writable, `::ancestor.paymentAgreement` | The payment agreement of the contract. |
| `projectSecurityLink_code` | `varchar2` | Project Security Link Code | [ ] | filters on the platform, writable, `::ancestor.projectSecurityLink.code` | The code of the security code. |
| `projectSecurityLink_id` | `int64` | Project Security Link ID | [ ] | filters on the platform, writable, `::ancestor.projectSecurityLink.id` | The unique identifier of the project security link. |
| `projectSecurityLink_name` | `varchar2` | Project Security Link Name | [ ] | filters on the platform, writable, `::ancestor.projectSecurityLink.name` | The name of the project security link. |
| `project_branch_code` | `varchar2` | itgen_bouw7_project_branch_code | [ ] | filters on the platform, writable, `::ancestor.project.branch.code` | The code for this branch |
| `project_branch_id` | `int64` | itgen_bouw7_project_branch_id | [ ] | filters on the platform, writable, `::ancestor.project.branch.id` | The ID of the branch. |
| `project_branch_name` | `varchar2` | itgen_bouw7_project_branch_name | [ ] | filters on the platform, writable, `::ancestor.project.branch.name` | The name of this branch |
| `project_category_code` | `varchar2` | itgen_bouw7_project_category_code | [ ] | filters on the platform, writable, `::ancestor.project.category.code` | The code for the category. |
| `project_category_createdAt` | `datetime` | itgen_bouw7_project_category_createdat | [ ] | filters on the platform, writable, `::ancestor.project.category.createdAt` | The creation time of the entity. |
| `project_category_createdBy` | `varchar2` | itgen_bouw7_project_category_createdby | [ ] | filters on the platform, writable, `::ancestor.project.category.createdBy` | The user that created the entity. |
| `project_category_generalCostsOrProfit` | `varchar2` | itgen_bouw7_project_category_generalcostsorprofit | [ ] | filters on the platform, writable, `::ancestor.project.category.generalCostsOrProfit` | The general costs or profit for the category. |
| `project_category_generalCostsPercentage` | `varchar2` | itgen_bouw7_project_category_generalcostspercentage | [ ] | filters on the platform, writable, `::ancestor.project.category.generalCostsPercentage` | The general costs percentage for the category. |
| `project_category_grossProfitMargin` | `varchar2` | itgen_bouw7_project_category_grossprofitmargin | [ ] | filters on the platform, writable, `::ancestor.project.category.grossProfitMargin` | The gross profit margin for the category. |
| `project_category_id` | `int64` | itgen_bouw7_project_category_id | [ ] | filters on the platform, writable, `::ancestor.project.category.id` | The ID of the category. |
| `project_category_name` | `varchar2` | itgen_bouw7_project_category_name | [ ] | filters on the platform, writable, `::ancestor.project.category.name` | The name of the category. |
| `project_category_updatedAt` | `datetime` | itgen_bouw7_project_category_updatedat | [ ] | filters on the platform, writable, `::ancestor.project.category.updatedAt` | The last updated time of the entity. |
| `project_category_updatedBy` | `varchar2` | itgen_bouw7_project_category_updatedby | [ ] | filters on the platform, writable, `::ancestor.project.category.updatedBy` | The user that last updated the entity. |
| `project_city` | `varchar2` | Project City | [ ] | filters on the platform, writable, `::ancestor.project.city` | The city of the project. |
| `project_contact_email` | `varchar2` | Project Contact Email | [ ] | filters on the platform, writable, `::ancestor.project.contact.email` | The email address. |
| `project_contact_id` | `int64` | Project Contact ID | [ ] | filters on the platform, writable, `::ancestor.project.contact.id` | ID of contact. |
| `project_contact_isVatShifted` | `char` | itgen_bouw7_project_contact_isvatshifted | [ ] | filters on the platform, writable, `::ancestor.project.contact.isVatShifted` | Whether VAT is shifted for the contact. |
| `project_contact_name` | `varchar2` | Project Contact Name | [ ] | filters on the platform, writable, `::ancestor.project.contact.name` | Name of contact. |
| `project_contact_phoneNumber` | `varchar2` | itgen_bouw7_project_contact_phonenumber | [ ] | filters on the platform, writable, `::ancestor.project.contact.phoneNumber` | The phone number of the contact. |
| `project_createdAt` | `datetime` | Project Created at | [ ] | filters on the platform, writable, `::ancestor.project.createdAt` | The creation time of the entity. |
| `project_createdBy` | `varchar2` | Project Created by | [ ] | filters on the platform, writable, `::ancestor.project.createdBy` | The user that created the entity. |
| `project_deliveryDate` | `datetime` | Project Delivery Date | [ ] | filters on the platform, writable, `::ancestor.project.deliveryDate` | Delivery date for the project. |
| `project_endDate` | `datetime` | Project End Date | [ ] | filters on the platform, writable, `::ancestor.project.endDate` | End date for the project. |
| `project_fullProjectNumber` | `varchar2` | Project Full Project Number | [ ] | filters on the platform, writable, `::ancestor.project.fullProjectNumber` | The full project number including year. |
| `project_houseNumber` | `varchar2` | Project House Number | [ ] | filters on the platform, writable, `::ancestor.project.houseNumber` | The house number for the project. |
| `project_id` | `int64` | Project ID | [ ] | filters on the platform, writable, `::ancestor.project.id` | The ID of the project. |
| `project_information` | `varchar2` | Project Information | [ ] | filters on the platform, writable, `::ancestor.project.information` | The information of the project. |
| `project_name` | `varchar2` | Project Name | [ ] | filters on the platform, writable, `::ancestor.project.name` | The name of the project. |
| `project_projectNumber` | `varchar2` | Project  Project Number | [ ] | filters on the platform, writable, `::ancestor.project.projectNumber` | The project number. |
| `project_reference` | `varchar2` | Project Reference | [ ] | filters on the platform, writable, `::ancestor.project.reference` | The reference of the project. |
| `project_startDate` | `datetime` | Project Start Date | [ ] | filters on the platform, writable, `::ancestor.project.startDate` | Start date for the project. |
| `project_status_closesProject` | `char` | Project Status Closes Project | [ ] | filters on the platform, writable, `::ancestor.project.status.closesProject` | Whether or not this status closes a project. |
| `project_status_createdAt` | `datetime` | Project Status Created at | [ ] | filters on the platform, writable, `::ancestor.project.status.createdAt` | The creation time of the entity. |
| `project_status_createdBy` | `varchar2` | Project Status Created by | [ ] | filters on the platform, writable, `::ancestor.project.status.createdBy` | The user that created the entity. |
| `project_status_id` | `int64` | Project Status ID | [ ] | filters on the platform, writable, `::ancestor.project.status.id` | The ID of the status. |
| `project_status_invoicesProject` | `char` | Project Status Invoices Project | [ ] | filters on the platform, writable, `::ancestor.project.status.invoicesProject` | Whether or not this status invoices a project. |
| `project_status_name` | `varchar2` | Project Status Name | [ ] | filters on the platform, writable, `::ancestor.project.status.name` | The name of the status. |
| `project_status_plansProject` | `char` | Project Status Plans Project | [ ] | filters on the platform, writable, `::ancestor.project.status.plansProject` | Whether or not this status plans a project. |
| `project_status_updatedAt` | `datetime` | Project Status Updated at | [ ] | filters on the platform, writable, `::ancestor.project.status.updatedAt` | The last updated time of the entity. |
| `project_status_updatedBy` | `varchar2` | Project Status Updated by | [ ] | filters on the platform, writable, `::ancestor.project.status.updatedBy` | The user that last updated the entity. |
| `project_streetName` | `varchar2` | Project Street Name | [ ] | filters on the platform, writable, `::ancestor.project.streetName` | The street name for the project. |
| `project_updatedAt` | `datetime` | Project Updated at | [ ] | filters on the platform, writable, `::ancestor.project.updatedAt` | The last updated time of the entity. |
| `project_updatedBy` | `varchar2` | Project Updated by | [ ] | filters on the platform, writable, `::ancestor.project.updatedBy` | The user that last updated the entity. |
| `project_zipCode` | `varchar2` | Project ZIP Code | [ ] | filters on the platform, writable, `::ancestor.project.zipCode` | The zip code for the project. |
| `purchaseType` | `int64` | Purchase Type | [ ] | filters on the platform, writable, `::ancestor.purchaseType` | The purchase type of the purchase order contract. |
| `status` | `int64` | Status | [ ] | filters on the platform, writable, `::ancestor.status` | Status of the contract. |
| `supplier_contactType_id` | `int64` | Supplier Contact Type ID | [ ] | filters on the platform, writable, `::ancestor.supplier.contactType.id` | The ID of contact type. |
| `supplier_contactType_name` | `varchar2` | Supplier Contact Type Name | [ ] | filters on the platform, writable, `::ancestor.supplier.contactType.name` | The name of contact type. |
| `supplier_email` | `varchar2` | Supplier Email | [ ] | filters on the platform, writable, `::ancestor.supplier.email` | The email address. |
| `supplier_id` | `int64` | Supplier ID | [ ] | filters on the platform, writable, `::ancestor.supplier.id` | ID of contact. |
| `supplier_isVatShifted` | `char` | itgen_bouw7_supplier_isvatshifted | [ ] | filters on the platform, writable, `::ancestor.supplier.isVatShifted` | Whether VAT is shifted for the contact. |
| `supplier_name` | `varchar2` | Supplier Name | [ ] | filters on the platform, writable, `::ancestor.supplier.name` | Name of contact. |
| `supplier_phoneNumber` | `varchar2` | itgen_bouw7_supplier_phonenumber | [ ] | filters on the platform, writable, `::ancestor.supplier.phoneNumber` | The phone number of the contact. |
| `type` | `int64` | Type | [ ] | filters on the platform, writable, `::ancestor.type` | Type of the contract. |
| `updatedAt` | `datetime` | Updated At | [ ] | filters on the platform, writable, `::ancestor.updatedAt` | The last updated time of the entity. |
| `updatedBy` | `varchar2` | Updated by | [ ] | filters on the platform, writable, `::ancestor.updatedBy` | The user that last updated the entity. |



## Release Notes

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

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

