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

# PurchaseInvoiceLines: Bouw7 Purchase Invoice Lines

`read only`

- Catalog: `Bouw7`
- Schema: `Views`
- Label: Purchase Invoice Lines

Can only retrieve data.

## 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.

## Table Columns

The columns of the table `PurchaseInvoiceLines` 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 |
|---|---|---|:---:|---|---|
| `approval_canApprove` | `char` | itgen_bouw7_approval_canapprove | [ ] | filters on the platform, writable | Whether or not the current authenticated user can approve the approval. |
| `approval_createdAt` | `datetime` | itgen_bouw7_approval_createdat | [ ] | filters on the platform, writable | The creation time of the entity. |
| `approval_createdBy` | `varchar2` | itgen_bouw7_approval_createdby | [ ] | filters on the platform, writable | The user that created the entity. |
| `approval_currentApprover_approvalDate` | `datetime` | itgen_bouw7_approval_currentapprover_approvaldate | [ ] | filters on the platform, writable | The date at which the approver denied/approved the approval. |
| `approval_currentApprover_approvalStatus` | `int64` | itgen_bouw7_approval_currentapprover_approvalstatus | [ ] | filters on the platform, writable | The approval status of this approver. |
| `approval_currentApprover_comment` | `varchar2` | itgen_bouw7_approval_currentapprover_comment | [ ] | filters on the platform, writable | Comment left by the approver. Can be null. |
| `approval_currentApprover_createdAt` | `datetime` | itgen_bouw7_approval_currentapprover_createdat | [ ] | filters on the platform, writable | The creation time of the entity. |
| `approval_currentApprover_createdBy` | `varchar2` | itgen_bouw7_approval_currentapprover_createdby | [ ] | filters on the platform, writable | The user that created the entity. |
| `approval_currentApprover_id` | `int64` | itgen_bouw7_approval_currentapprover_id | [ ] | filters on the platform, writable | ID of the approver. |
| `approval_currentApprover_index` | `int64` | itgen_bouw7_approval_currentapprover_index | [ ] | filters on the platform, writable | Current index of the approver. |
| `approval_currentApprover_updatedAt` | `datetime` | itgen_bouw7_approval_currentapprover_updatedat | [ ] | filters on the platform, writable | The last updated time of the entity. |
| `approval_currentApprover_updatedBy` | `varchar2` | itgen_bouw7_approval_currentapprover_updatedby | [ ] | filters on the platform, writable | The user that last updated the entity. |
| `approval_currentIndex` | `int64` | itgen_bouw7_approval_currentindex | [ ] | filters on the platform, writable | 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 | ID of the approval. |
| `approval_isApproved` | `char` | itgen_bouw7_approval_isapproved | [ ] | filters on the platform, writable | Whether or not the approval has been approved. |
| `approval_lastActionDate` | `datetime` | itgen_bouw7_approval_lastactiondate | [ ] | filters on the platform, writable | 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 | The last updated time of the entity. |
| `approval_updatedBy` | `varchar2` | itgen_bouw7_approval_updatedby | [ ] | filters on the platform, writable | The user that last updated the entity. |
| `approval_workflowId` | `int64` | itgen_bouw7_approval_workflowid | [ ] | filters on the platform, writable | The workflow that this approval is based of. |
| `bookNumber` | `int64` | Book Number | [ ] | filters on the platform, writable | The booknumber of the purchase invoice. |
| `branch_code` | `varchar2` | Branch Code | [ ] | filters on the platform, writable | The code for this branch |
| `branch_division_description` | `varchar2` | itgen_bouw7_branch_division_description | [ ] | filters on the platform, writable | The description of the division. |
| `branch_division_exactDivisionId` | `varchar2` | itgen_bouw7_branch_division_exactdivisionid | [ ] | filters on the platform, writable | The division ID of an Exact Online environment. |
| `branch_division_glAccountCode` | `varchar2` | itgen_bouw7_branch_division_glaccountcode | [ ] | filters on the platform, writable | A default general ledger account code to use for sales related items. |
| `branch_division_glAccountCodePurchase` | `varchar2` | itgen_bouw7_branch_division_glaccountcodepurchase | [ ] | filters on the platform, writable | A default general ledger account code to use for purchase related items. |
| `branch_division_id` | `int64` | itgen_bouw7_branch_division_id | [ ] | filters on the platform, writable | The ID of the division. |
| `branch_division_journalCode` | `varchar2` | itgen_bouw7_branch_division_journalcode | [ ] | filters on the platform, writable | A default journal code to use for sales related items. |
| `branch_division_journalCodePurchase` | `varchar2` | itgen_bouw7_branch_division_journalcodepurchase | [ ] | filters on the platform, writable | A default journal code to use for purchase related items. |
| `branch_division_salesInvoiceNumberPrefix` | `varchar2(3)` | itgen_bouw7_branch_division_salesinvoicenumberprefix | [ ] | filters on the platform, writable | The prefix (3 digits) used to generate invoice number range per division. |
| `branch_id` | `int64` | Branch ID | [ ] | filters on the platform, writable | The ID of the branch. |
| `branch_name` | `varchar2` | Branch Name | [ ] | filters on the platform, writable | The name of this branch |
| `canBeDeleted` | `char` | Can Be Deleted | [ ] | filters on the platform, writable | Whether the invoice can be deleted. |
| `canBeEdited` | `char` | Can Be Edited | [ ] | writable | Whether the line can be edited or removed. |
| `canBookToExact` | `char` | Can Book to Exact | [ ] | filters on the platform, writable | Whether it is allowed to book to Exact. |
| `canBookToTwinfield` | `char` | Can Book to Twinfield | [ ] | filters on the platform, writable | Whether it is allowed to book to Twinfield. |
| `canUseCostCenter` | `char` | Can Use Cost Centre | [ ] | filters on the platform, writable | True if the user can use cost center functionality. |
| `chainLiabilityDocumentExpirationDate` | `datetime` | Chain Liability Document Expiration Date | [ ] | filters on the platform, writable | The newest expiration date of the chain liability document(s) associated with the contact, in ATOM format. |
| `comments` | `varchar2` | Comments | [ ] | filters on the platform, writable | Comment associated with the purchase invoice. |
| `contact_contactType_id` | `int64` | Contact Contact Type ID | [ ] | filters on the platform, writable | The ID of contact type. |
| `contact_contactType_name` | `varchar2` | Contact Contact Type Name | [ ] | filters on the platform, writable | The name of contact type. |
| `contact_email` | `varchar2` | Contact Email | [ ] | filters on the platform, writable | The email address. |
| `contact_id` | `int64` | Contact ID | [ ] | filters on the platform, writable | ID of contact. |
| `contact_isVatShifted` | `char` | Contact Is VAT Shifted | [ ] | filters on the platform, writable | Whether VAT is shifted for the contact. |
| `contact_name` | `varchar2` | Contact Name | [ ] | filters on the platform, writable | Name of contact. |
| `contact_phoneNumber` | `varchar2` | Contact Phone Number | [ ] | filters on the platform, writable | The phone number of the contact. |
| `costCenter` | `varchar2` | Cost Centre | [ ] | writable | A reference to the cost center associated with the invoice line. |
| `createDeliveryTicket` | `char` | Create Delivery Ticket | [ ] | filters on the platform, writable | Whether or not to create a delivery ticket. |
| `createDeliveryTicketForRemainingCosts` | `char` | Create Delivery Ticket for Remaining Costs | [ ] | writable | Whether or not to create a delivery ticket for remaining costs between this line and the delivery ticket |
| `createDeliveryTicketForRemainingCosts_2` | `char` | itgen_bouw7_createdeliveryticketforremainingcosts_2 | [ ] | filters on the platform, writable | Whether or not to create a delivery ticket for the remaining costs. |
| `createdAt` | `datetime` | Created at | [ ] | writable | The creation time of the entity. |
| `createdAt_2` | `datetime` | Created at | [ ] | filters on the platform, writable | The creation time of the entity. |
| `createdBy` | `varchar2` | Created by | [ ] | writable | The user that created the entity. |
| `createdBy_2` | `varchar2` | Created by | [ ] | filters on the platform, writable | The user that created the entity. |
| `date` | `datetime` | Date | [ ] | filters on the platform, writable | Purchase invoice date. |
| `datePaid` | `varchar2` | Date Paid | [ ] | filters on the platform, writable | Purchase invoice paid date. |
| `deliveryTicket_cost` | `varchar2` | Delivery Ticket Cost | [ ] | writable | The costs for this delivery ticket. |
| `deliveryTicket_cost_2` | `varchar2` | itgen_bouw7_deliveryticket_cost_2 | [ ] | filters on the platform, writable | The costs for this delivery ticket. |
| `deliveryTicket_id` | `int64` | Delivery Ticket ID | [ ] | writable | The ID of delivery ticket. |
| `deliveryTicket_id_2` | `int64` | itgen_bouw7_deliveryticket_id_2 | [ ] | filters on the platform, writable | The ID of delivery ticket. |
| `deliveryTicket_initialCost` | `varchar2` | Delivery Ticket Initial Cost | [ ] | writable | The initial costs for this delivery ticket. |
| `deliveryTicket_initialCost_2` | `varchar2` | itgen_bouw7_deliveryticket_initialcost_2 | [ ] | filters on the platform, writable | The initial costs for this delivery ticket. |
| `deliveryTicket_processed` | `char` | Delivery Ticket Processed | [ ] | writable | Whether the delivery ticket has been processed. |
| `deliveryTicket_processed_2` | `char` | itgen_bouw7_deliveryticket_processed_2 | [ ] | filters on the platform, writable | Whether the delivery ticket has been processed. |
| `deliveryTicket_ticketDate` | `datetime` | Delivery Ticket Ticket Date | [ ] | writable | The date for which the delivery ticket were logged. |
| `deliveryTicket_ticketDate_2` | `datetime` | itgen_bouw7_deliveryticket_ticketdate_2 | [ ] | filters on the platform, writable | The date for which the delivery ticket were logged. |
| `deliveryTicket_ticketNumber` | `varchar2` | Delivery Ticket Ticket Number | [ ] | writable | Ticket number of delivery ticket. |
| `deliveryTicket_ticketNumber_2` | `varchar2` | itgen_bouw7_deliveryticket_ticketnumber_2 | [ ] | filters on the platform, writable | Ticket number of delivery ticket. |
| `description` | `varchar2(255)` | Description | [ ] | writable | The description of the purchase invoice line. |
| `division_description` | `varchar2` | Division Description | [ ] | filters on the platform, writable | The description of the division. |
| `division_exactDivisionId` | `varchar2` | Division Exact Division ID | [ ] | filters on the platform, writable | The division ID of an Exact Online environment. |
| `division_glAccountCode` | `varchar2` | Division General Ledger Account Code | [ ] | filters on the platform, writable | A default general ledger account code to use for sales related items. |
| `division_glAccountCodePurchase` | `varchar2` | Division General Ledger Account Code Purchase | [ ] | filters on the platform, writable | A default general ledger account code to use for purchase related items. |
| `division_id` | `int64` | Division ID | [ ] | filters on the platform, writable | The ID of the division. |
| `division_journalCode` | `varchar2` | Division Journal Code | [ ] | filters on the platform, writable | A default journal code to use for sales related items. |
| `division_journalCodePurchase` | `varchar2` | Division Journal Code Purchase | [ ] | filters on the platform, writable | A default journal code to use for purchase related items. |
| `division_salesInvoiceNumberPrefix` | `varchar2(3)` | Division Sales Invoice Number Prefix | [ ] | filters on the platform, writable | The prefix (3 digits) used to generate invoice number range per division. |
| `dueDate` | `datetime` | Due Date | [ ] | filters on the platform, writable | Purchase invoice due date. |
| `exactFinancialPeriod_endDate` | `datetime` | itgen_bouw7_exactfinancialperiod_enddate | [ ] | filters on the platform, writable | The end date of the exact financial period in Y-m-d format. |
| `exactFinancialPeriod_financialPeriod` | `int64` | itgen_bouw7_exactfinancialperiod_financialperiod | [ ] | filters on the platform, writable | The period of the exact financial period. |
| `exactFinancialPeriod_financialYear` | `int64` | itgen_bouw7_exactfinancialperiod_financialyear | [ ] | filters on the platform, writable | The year of the exact financial period. |
| `exactFinancialPeriod_id` | `int64` | itgen_bouw7_exactfinancialperiod_id | [ ] | filters on the platform, writable | The ID of the exact financial period. |
| `exactFinancialPeriod_startDate` | `datetime` | itgen_bouw7_exactfinancialperiod_startdate | [ ] | filters on the platform, writable | The start date of the exact financial period in Y-m-d format. |
| `exactPaymentCondition` | `varchar2(255)` | Exact Payment Condition | [ ] | filters on the platform, writable | The code of the Exact Online payment condition for this purchase invoice. |
| `file_createdAt` | `datetime` | File Created at | [ ] | filters on the platform, writable | The creation time of the entity. |
| `file_createdBy` | `varchar2` | File Created by | [ ] | filters on the platform, writable | The user that created the entity. |
| `file_extension` | `varchar2` | File Extension | [ ] | filters on the platform, writable | The extension of the file. |
| `file_id` | `int64` | File ID | [ ] | filters on the platform, writable | The ID of this file |
| `file_modelId` | `int64` | File Model ID | [ ] | filters on the platform, writable | The ID of the associated type. |
| `file_modelType` | `varchar2` | File Model Type | [ ] | filters on the platform, writable | The category of the file. |
| `file_name` | `varchar2` | File Name | [ ] | filters on the platform, writable | The public name of the file. |
| `file_secureHash` | `varchar2` | itgen_bouw7_file_securehash | [ ] | filters on the platform, writable | 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 | The size of the file in bytes. |
| `file_updatedAt` | `datetime` | File Updated at | [ ] | filters on the platform, writable | The last updated time of the entity. |
| `file_updatedBy` | `varchar2` | File Updated by | [ ] | filters on the platform, writable | The user that last updated the entity. |
| `file_uri` | `varchar2` | File URI | [ ] | filters on the platform, writable | The URI of the file, used to fetch the contents. |
| `fromBasecone` | `char` | From Basecone | [ ] | filters on the platform, writable | Whether the invoice is imported from Basecone. |
| `gAccountAmount` | `varchar2` | G-Account Amount | [ ] | filters on the platform, writable | The g account amount of the purchase invoice. |
| `grossPrice` | `varchar2` | Gross Price | [ ] | writable | The gross price of the purchase invoice line. |
| `id` | `int64` | ID | [ ] | writable | The ID of the purchase invoice line. Must be omitted to create a new purchase invoice line. |
| `id_2` | `int64` | ID | [ ] | filters on the platform, writable | The ID of purchase invoice. |
| `invoiceNumber` | `varchar2` | Invoice Number | [ ] | filters on the platform, writable | The invoice number of purchase invoice. |
| `invoice_branch_id` | `int64` | Branch ID | [ ] | filters on the platform, writable | The ID of the branch. |
| `invoice_branch_name` | `varchar2` | Branch Name | [ ] | filters on the platform, writable | The name of the branch. |
| `invoice_chainLiabilityDocumentExpirationDate` | `datetime` | This field is dynamically hydrated by the 'addChainLiabilityDocumentExpirationDate'-method in the schema factory. | [ ] | filters on the platform, writable | The newest expiration date of the chain liability document(s) associated with the contact, in ATOM format. |
| `invoice_comment` | `varchar2` | Comment | [ ] | filters on the platform, writable | A comment placed on this purchase invoice. |
| `invoice_createdAt` | `datetime` | Created at | [ ] | filters on the platform, writable | The creation date of the object in ATOM/ISO-8601 format |
| `invoice_createdBy_id` | `int64` | Created by ID | [ ] | filters on the platform, writable | The ID of the user. |
| `invoice_createdBy_username` | `varchar2` | Created by User Name | [ ] | filters on the platform, writable | The username of the user. |
| `invoice_currentApprover` | `varchar2` | This field is dynamically hydrated by the 'addCurrentApprover'-method in the schema factory. | [ ] | filters on the platform, writable | The full name of the current approver. |
| `invoice_date` | `datetime` | Date | [ ] | filters on the platform, writable | The entry date of this purchase invoice. |
| `invoice_datePaid` | `varchar2` | Date Paid | [ ] | filters on the platform, writable | The date this purchase invoice was paid. |
| `invoice_deliveryTicket_bookingStatus` | `int64` | Delivery Ticket Booking Status | [ ] | filters on the platform, writable | The current booking status. 0 = Registered, 1 = Invoiced, 2 = Not billable, 3 = Credited. |
| `invoice_deliveryTicket_date` | `datetime` | Delivery Ticket Date | [ ] | filters on the platform, writable | The date of the delivery ticket, represented in ATOM-format. |
| `invoice_deliveryTicket_description` | `varchar2` | Delivery Ticket Description | [ ] | filters on the platform, writable | The description of this delivery ticket. May contain HTML content. |
| `invoice_deliveryTicket_id` | `int64` | Delivery Ticket ID | [ ] | filters on the platform, writable | The ID of this delivery ticket. |
| `invoice_deliveryTicket_isProcessed` | `char` | Delivery Ticket Is Processed | [ ] | filters on the platform, writable | Whether this delivery ticket has been processed. |
| `invoice_deliveryTicket_number` | `varchar2` | Delivery Ticket Number | [ ] | filters on the platform, writable | The ticket number of this delivery ticket. |
| `invoice_deliveryTicket_price` | `varchar2` | Delivery Ticket Price | [ ] | filters on the platform, writable | The price of this delivery ticket. |
| `invoice_deliveryTicket_purchaseTypeId` | `int64` | Delivery Ticket Purchase Type ID | [ ] | filters on the platform, writable | The ID of the purchase type of this delivery ticket. |
| `invoice_deliveryTicket_purchaseTypeName` | `varchar2` | Delivery Ticket Purchase Type Name | [ ] | filters on the platform, writable | The name of the purchase type of this delivery ticket. |
| `invoice_division_description` | `varchar2` | Division Description | [ ] | filters on the platform, writable | The description of the division. |
| `invoice_division_exactDivisionId` | `varchar2` | Division Exact Division ID | [ ] | filters on the platform, writable | The division ID of an Exact Online environment. |
| `invoice_division_glAccountCode` | `varchar2` | Division General Ledger Account Code | [ ] | filters on the platform, writable | A default general ledger account code to use for sales related items. |
| `invoice_division_glAccountCodePurchase` | `varchar2` | Division General Ledger Account Code Purchase | [ ] | filters on the platform, writable | A default general ledger account code to use for purchase related items. |
| `invoice_division_id` | `int64` | Division ID | [ ] | filters on the platform, writable | The ID of the division. |
| `invoice_division_journalCode` | `varchar2` | Division Journal Code | [ ] | filters on the platform, writable | A default journal code to use for sales related items. |
| `invoice_division_journalCodePurchase` | `varchar2` | Division Journal Code Purchase | [ ] | filters on the platform, writable | A default journal code to use for purchase related items. |
| `invoice_dueDate` | `datetime` | Due Date | [ ] | filters on the platform, writable | The due date of this purchase invoice. |
| `invoice_entryNumber` | `int64` | Entry Number | [ ] | filters on the platform, writable | A sequential tracking number assigned to this purchase invoice. Also known as voucher number, serial number or tracking number. |
| `invoice_id` | `int64` | ID | [ ] | filters on the platform, writable | The ID of this purchase invoice. |
| `invoice_invoiceNumber` | `varchar2` | Invoice Number | [ ] | filters on the platform, writable | The invoice number of this purchase invoice. |
| `invoice_isBookedInExact` | `char` | Is Booked in Exact | [ ] | filters on the platform, writable | Whether this purchase invoice is booked in Exact. |
| `invoice_isBookedInTwinfield` | `char` | Is Booked in Twinfield | [ ] | filters on the platform, writable | Whether this purchase invoice is booked in Twinfield. |
| `invoice_isMutable` | `char` | itgen_bouw7_ismutable | [ ] | filters on the platform, writable | Whether the purchase invoice is mutable. |
| `invoice_isOriginatingFromBasecone` | `char` | Is Originating from Basecone | [ ] | filters on the platform, writable | Whether this purchase invoice originates from Basecone. |
| `invoice_orderNumber` | `varchar2` | Order Number | [ ] | filters on the platform, writable | The order number associated with this purchase invoice. |
| `invoice_paymentReference` | `varchar2` | Payment Reference | [ ] | filters on the platform, writable | The payment reference of this purchase invoice. |
| `invoice_project_branchId` | `int64` | Project Branch ID | [ ] | filters on the platform, writable | The ID of the branch of this project. |
| `invoice_project_categoryId` | `int64` | Project Category ID | [ ] | filters on the platform, writable | The ID of the category of this project. |
| `invoice_project_divisionId` | `int64` | Project Division ID | [ ] | filters on the platform, writable | The ID of the division of this project. |
| `invoice_project_id` | `int64` | Project ID | [ ] | filters on the platform, writable | The ID of the project. |
| `invoice_project_name` | `varchar2` | Project Name | [ ] | filters on the platform, writable | The name of the project. |
| `invoice_project_number` | `varchar2` | Project Number | [ ] | filters on the platform, writable | The number of the project. |
| `invoice_project_status` | `varchar2` | Project Status | [ ] | filters on the platform, writable | The name of the current status of this project. |
| `invoice_project_statusId` | `int64` | Project Status ID | [ ] | filters on the platform, writable | The ID of the status of this project. |
| `invoice_status` | `int64` | Status | [ ] | filters on the platform, writable | The status of this purchase invoice. (0 = New, 1 = Approved, 2 = Open, 3 = Expired, 4 = Paid, 5 = Declined) |
| `invoice_subTotal` | `varchar2` | This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | [ ] | filters on the platform, writable | The sum of all purchase invoice line subtotals, excluding VAT. |
| `invoice_supplier_emailAddress` | `varchar2` | Supplier Email Address | [ ] | filters on the platform, writable | The email address of the contact. |
| `invoice_supplier_id` | `int64` | Supplier ID | [ ] | filters on the platform, writable | The ID of the contact. |
| `invoice_supplier_name` | `varchar2` | Supplier Name | [ ] | filters on the platform, writable | The name of this contact. |
| `invoice_supplier_type` | `varchar2` | Supplier Type | [ ] | filters on the platform, writable | The type of this contact. |
| `invoice_supplier_typeId` | `int64` | Supplier Type ID | [ ] | filters on the platform, writable | The type ID of this contact. |
| `invoice_total` | `varchar2` | This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | [ ] | filters on the platform, writable | The sum of all purchase invoice line subtotals, including VAT. |
| `invoice_updatedAt` | `datetime` | Updated At | [ ] | filters on the platform, writable | The creation date of the object in ATOM/ISO-8601 format |
| `invoice_updatedBy_id` | `int64` | Updated by ID | [ ] | filters on the platform, writable | The ID of the user. |
| `invoice_updatedBy_username` | `varchar2` | Updated by User Name | [ ] | filters on the platform, writable | The username of the user. |
| `invoice_vatTotal` | `varchar2` | This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | [ ] | filters on the platform, writable | The sum of all purchase invoice line VAT totals. |
| `isBooked` | `char` | Is Booked | [ ] | filters on the platform, writable | Whether the invoice is already booked. |
| `isMutable` | `char` | itgen_bouw7_ismutable | [ ] | filters on the platform, writable | Whether the purchase invoice is mutable. |
| `ledger` | `varchar2` | Ledger | [ ] | writable | A reference to the ledger of the purchase invoice line. |
| `modelId` | `int64` | Model ID | [ ] | writable | The model ID. Will be the ID of the selected modelType. |
| `modelType` | `int64` | Model Type | [ ] | writable | The model type, possible options: 1 = SubcontractorContract / 2 = PurchaseOrderContract / 3 = Project. |
| `nextPurchaseInvoiceId` | `int64` | Next Purchase Invoice ID | [ ] | filters on the platform, writable | The ID of the next purchase invoice starting from this purchase invoice. Null when no next purchase invoice available. |
| `orderNumber` | `varchar2` | Order Number | [ ] | filters on the platform, writable | The order number of the purchase invoice. |
| `paymentReference` | `varchar2` | Payment Reference | [ ] | filters on the platform, writable | The payment reference of the purchase invoice. |
| `previousPurchaseInvoiceId` | `int64` | Previous Purchase Invoice ID | [ ] | filters on the platform, writable | The ID of the previous purchase invoice starting from this purchase invoice. Null when no previous purchase invoice available. |
| `project_branch_code` | `varchar2` | itgen_bouw7_project_branch_code | [ ] | filters on the platform, writable | The code for this branch |
| `project_branch_id` | `int64` | itgen_bouw7_project_branch_id | [ ] | filters on the platform, writable | The ID of the branch. |
| `project_branch_name` | `varchar2` | itgen_bouw7_project_branch_name | [ ] | filters on the platform, writable | The name of this branch |
| `project_category_code` | `varchar2` | itgen_bouw7_project_category_code | [ ] | filters on the platform, writable | The code for the category. |
| `project_category_createdAt` | `datetime` | itgen_bouw7_project_category_createdat | [ ] | filters on the platform, writable | The creation time of the entity. |
| `project_category_createdBy` | `varchar2` | itgen_bouw7_project_category_createdby | [ ] | filters on the platform, writable | The user that created the entity. |
| `project_category_generalCostsOrProfit` | `varchar2` | itgen_bouw7_project_category_generalcostsorprofit | [ ] | filters on the platform, writable | The general costs or profit for the category. |
| `project_category_generalCostsPercentage` | `varchar2` | itgen_bouw7_project_category_generalcostspercentage | [ ] | filters on the platform, writable | The general costs percentage for the category. |
| `project_category_grossProfitMargin` | `varchar2` | itgen_bouw7_project_category_grossprofitmargin | [ ] | filters on the platform, writable | The gross profit margin for the category. |
| `project_category_id` | `int64` | itgen_bouw7_project_category_id | [ ] | filters on the platform, writable | The ID of the category. |
| `project_category_name` | `varchar2` | itgen_bouw7_project_category_name | [ ] | filters on the platform, writable | The name of the category. |
| `project_category_updatedAt` | `datetime` | itgen_bouw7_project_category_updatedat | [ ] | filters on the platform, writable | The last updated time of the entity. |
| `project_category_updatedBy` | `varchar2` | itgen_bouw7_project_category_updatedby | [ ] | filters on the platform, writable | The user that last updated the entity. |
| `project_city` | `varchar2` | Project City | [ ] | filters on the platform, writable | The city of the project. |
| `project_contact_email` | `varchar2` | Project Contact Email | [ ] | filters on the platform, writable | The email address. |
| `project_contact_id` | `int64` | Project Contact ID | [ ] | filters on the platform, writable | ID of contact. |
| `project_contact_isVatShifted` | `char` | itgen_bouw7_project_contact_isvatshifted | [ ] | filters on the platform, writable | Whether VAT is shifted for the contact. |
| `project_contact_name` | `varchar2` | Project Contact Name | [ ] | filters on the platform, writable | Name of contact. |
| `project_contact_phoneNumber` | `varchar2` | itgen_bouw7_project_contact_phonenumber | [ ] | filters on the platform, writable | The phone number of the contact. |
| `project_createdAt` | `datetime` | Project Created at | [ ] | filters on the platform, writable | The creation time of the entity. |
| `project_createdBy` | `varchar2` | Project Created by | [ ] | filters on the platform, writable | The user that created the entity. |
| `project_deliveryDate` | `datetime` | Project Delivery Date | [ ] | filters on the platform, writable | Delivery date for the project. |
| `project_endDate` | `datetime` | Project End Date | [ ] | filters on the platform, writable | End date for the project. |
| `project_fullProjectNumber` | `varchar2` | Project Full Project Number | [ ] | filters on the platform, writable | The full project number including year. |
| `project_houseNumber` | `varchar2` | Project House Number | [ ] | filters on the platform, writable | The house number for the project. |
| `project_id` | `int64` | Project ID | [ ] | filters on the platform, writable | The ID of the project. |
| `project_information` | `varchar2` | Project Information | [ ] | filters on the platform, writable | The information of the project. |
| `project_name` | `varchar2` | Project Name | [ ] | filters on the platform, writable | The name of the project. |
| `project_projectNumber` | `varchar2` | Project  Project Number | [ ] | filters on the platform, writable | The project number. |
| `project_reference` | `varchar2` | Project Reference | [ ] | filters on the platform, writable | The reference of the project. |
| `project_startDate` | `datetime` | Project Start Date | [ ] | filters on the platform, writable | Start date for the project. |
| `project_status_closesProject` | `char` | Project Status Closes Project | [ ] | filters on the platform, writable | Whether or not this status closes a project. |
| `project_status_createdAt` | `datetime` | Project Status Created at | [ ] | filters on the platform, writable | The creation time of the entity. |
| `project_status_createdBy` | `varchar2` | Project Status Created by | [ ] | filters on the platform, writable | The user that created the entity. |
| `project_status_id` | `int64` | Project Status ID | [ ] | filters on the platform, writable | The ID of the status. |
| `project_status_invoicesProject` | `char` | Project Status Invoices Project | [ ] | filters on the platform, writable | Whether or not this status invoices a project. |
| `project_status_name` | `varchar2` | Project Status Name | [ ] | filters on the platform, writable | The name of the status. |
| `project_status_plansProject` | `char` | Project Status Plans Project | [ ] | filters on the platform, writable | Whether or not this status plans a project. |
| `project_status_updatedAt` | `datetime` | Project Status Updated at | [ ] | filters on the platform, writable | The last updated time of the entity. |
| `project_status_updatedBy` | `varchar2` | Project Status Updated by | [ ] | filters on the platform, writable | The user that last updated the entity. |
| `project_streetName` | `varchar2` | Project Street Name | [ ] | filters on the platform, writable | The street name for the project. |
| `project_updatedAt` | `datetime` | Project Updated at | [ ] | filters on the platform, writable | The last updated time of the entity. |
| `project_updatedBy` | `varchar2` | Project Updated by | [ ] | filters on the platform, writable | The user that last updated the entity. |
| `project_zipCode` | `varchar2` | Project ZIP Code | [ ] | filters on the platform, writable | The zip code for the project. |
| `quantity` | `varchar2` | Quantity | [ ] | writable | The unit quantity of the purchase invoice line. |
| `status` | `int64` | Status | [ ] | filters on the platform, writable | Status of the purchase invoice. |
| `subTotal` | `varchar2` | Subtotal | [ ] | writable | The sub-total price of the purchase invoice line. |
| `unitName` | `varchar2` | Unit Name | [ ] | writable | The name of the unit in the purchase invoice line. |
| `unitPrice` | `varchar2` | Unit Price | [ ] | writable | The unit price of the purchase invoice line. |
| `updatedAt` | `datetime` | Updated At | [ ] | writable | The last updated time of the entity. |
| `updatedAt_2` | `datetime` | Updated at | [ ] | filters on the platform, writable | The last updated time of the entity. |
| `updatedBy` | `varchar2` | Updated by | [ ] | writable | The user that last updated the entity. |
| `updatedBy_2` | `varchar2` | Updated by | [ ] | filters on the platform, writable | The user that last updated the entity. |
| `vatTariffId` | `int64` | VAT Tariff ID | [ ] | writable | The VAT-tariff ID used on the purchase invoice line. |
| `vatTariffPercentage` | `varchar2` | VAT Tariff Percentage | [ ] | writable | The VAT-tariff percentage used on the purchase invoice line. Must be set to 0 if VAT is shifted. |



## Release Notes

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

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

