---
title: "PurchaseOrderLines (Exact Online)"
description: "Purchase Order Lines"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineREST.PurchaseOrder.PurchaseOrderLines
original: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineREST.PurchaseOrder.PurchaseOrderLines
updated: 2026-11-01T17:55:09Z
license: https://documentation.invantive.eu/en/
---

# PurchaseOrderLines: Exact Online Purchase Order Lines

`insert` `update` `delete` `per partition` `webhook` `REST`

- Catalog: `ExactOnlineREST`
- Schema: `PurchaseOrder`
- Primary Keys: `ID`
- Label: Purchase Order Lines

The data in this table is partitioned per value of the `Division` column.

Can retrieve data and change data using `insert`, `update` and `delete`.

Changes arrive through the webhook topic `PurchaseOrders` on `PurchaseOrderID`.

## API Source

- Endpoint: `/api/v1/{division}/purchaseorder/PurchaseOrderLines`
- Metadata: `/api/v1/{division}/purchaseorder/$metadata`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 5 |
| Full scan rows per minute | 7,200 |
| Point query rows per minute | 300 |
| Write rows per minute | 300 |

The result can be cached on the client.

## Table Columns

The columns of the table `PurchaseOrderLines` 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 |
|---|---|---|:---:|---|---|
| `AmountDC` | `double` | Amount Division Currency | [ ] | filters on the platform, writable | Amount in the default currency of the company. |
| `AmountFC` | `double` | Amount Foreign Currency | [ ] | filters on the platform, writable | Amount in the currency of the transaction. |
| `CostCenter` | `varchar2(8)` | Cost Centre | [ ] | filters on the platform, writable | Reference to Cost center. |
| `CostCenterDescription` | `varchar2(60)` | Cost Centre Description | [ ] | filters on the platform, writable | Description of CostCenter. |
| `CostUnit` | `varchar2(8)` | Cost Unit | [ ] | filters on the platform, writable | Reference to Cost unit. |
| `CostUnitDescription` | `varchar2(60)` | Cost Unit Description | [ ] | filters on the platform, writable | Description of CostUnit. |
| `Created` | `datetime` | Created | [ ] | filters on the platform, writable | Creation date. |
| `CreatedUtc` | `datetime` | Created (UTC) | [ ] | writable | Creation date in UTC. |
| `Creator` | `guid` | Creator | [ ] | filters on the platform, writable | User ID of creator. |
| `CreatorFullName` | `varchar2(240)` | Creator Full Name | [ ] | filters on the platform, writable | Name of creator. |
| `CustomField` | `varchar2` | Custom Field | [ ] | writable |  |
| `Description` | `varchar2` | Description | [ ] | filters on the platform, writable | Description of the purchase order line. |
| `Discount` | `double` | Discount | [ ] | filters on the platform, writable | Discount in percentage for item. |
| `Division` | `int32` | Division | [ ] |  | Division code. |
| `DivisionCompanyCoCNumber` | `varchar2(60)` | Division Chamber of Commerce Number | [ ] | writable | Chamber of commerce number of the Exact Online division. |
| `DivisionCompanyIBANNumber` | `varchar2(50)` | Division IBAN Number | [ ] | writable | IBAN number of the Exact Online division. |
| `DivisionCompanyName` | `varchar2(50)` | Division Company Name | [x] | writable | Company name of the Exact Online division. |
| `DivisionCompanyRSINNumber` | `varchar2(9)` | Division RSIN Number | [ ] | writable | RSIN number of the Exact Online division. |
| `DivisionCompanyVATNumber` | `varchar2(35)` | Division VAT Number | [ ] | writable | VAT number of the Exact Online division. |
| `DivisionCompanyWageTaxNumber` | `varchar2(60)` | Division Wage Tax Number | [ ] | writable | Wage tax number of the Exact Online division. |
| `DivisionLabel` | `varchar2(128)` | Division Label | [x] | writable | Label of the Exact Online division. |
| `DivisionName` | `varchar2(50)` | Administration Name | [x] | writable | Name of the Exact Online division. |
| `DivisionOwnerCompanyName` | `varchar2(50)` | Subscription Holder Name | [x] | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionOwnerCompanyNumber` | `varchar2(18)` | Subscription Holder Number | [x] | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionShortName` | `int64` | Division Short Name | [x] | writable | Short name of the Exact Online division. |
| `Expense` | `guid` | Expense | [ ] | filters on the platform, writable | Expense related to the Work Breakdown Structure of the selected project. Only available with a professional service license. |
| `ExpenseDescription` | `varchar2` | Expense Description | [ ] | filters on the platform, writable | Description of expense. Only available with a professional service license. |
| `ID` | `guid` | ID | [x] | filters on the platform, writable | Primary key. |
| `InStock` | `double` | In Stock | [ ] | writable | The current stock level of items shown in stock unit. The information is displayed only for items with the stock property selected. |
| `InvoicedQuantity` | `double` | Invoiced Quantity | [ ] | writable | Quantity of item that has been invoiced. |
| `IsBatchNumberItem` | `int16` | Is Batch Number Item | [x] | filters on the platform |  |
| `IsSerialNumberItem` | `int16` | Is Serial Number Item | [x] | filters on the platform |  |
| `Item` | `guid` | Item | [ ] | filters on the platform, writable | Reference to the item for purchase order. |
| `ItemBarcode` | `varchar2` | Item Barcode | [ ] | filters on the platform |  |
| `ItemBarcodeAdditional` | `varchar2` | itgen_eol_itembarcodeadditional | [ ] | filters on the platform, writable |  |
| `ItemCode` | `varchar2(30)` | Item Code | [ ] | filters on the platform, writable | Item code. |
| `ItemDescription` | `varchar2(255)` | Item Description | [ ] | filters on the platform, writable | Description of item. |
| `ItemDivisable` | `char` | Item Divisable | [ ] | filters on the platform, writable | Indicates if fractional quantities of the item can be used, for example quantity = 0.4. |
| `LineNumber` | `int32` | Line Number | [ ] | filters on the platform, writable | Line number. |
| `Modified` | `datetime` | Modified | [ ] | filters on the platform, writable | Last modified date. |
| `ModifiedUtc` | `datetime` | Modified (UTC) | [ ] | writable | Last modified date in UTC. |
| `Modifier` | `guid` | Modifier | [ ] | filters on the platform, writable | User ID of modifier. |
| `ModifierFullName` | `varchar2(240)` | Modified Full Name | [ ] | filters on the platform, writable | Name of modifier. |
| `NetPrice` | `double` | Net Price | [ ] | filters on the platform, writable | The net price is the unit price (VAT code taken into account) with any discount applied. |
| `Notes` | `varchar2` | Notes | [ ] | filters on the platform, writable | Notes. |
| `Project` | `guid` | Project | [ ] | filters on the platform, writable | Reference to project. Only available with a professional service license. |
| `ProjectCode` | `varchar2(20)` | Project Code | [ ] | filters on the platform, writable | Project code. Only available with a professional service license. |
| `ProjectDescription` | `varchar2(60)` | Project Description | [ ] | filters on the platform, writable | Description of the project. Only available with a professional service license. |
| `ProjectedStock` | `double` | Projected Stock | [ ] | writable | The current stock level + the planned quantity to be received - the planned quantity to deliver shown in stock unit. |
| `PurchaseOrderID` | `guid` | Purchase Order ID | [x] | filters on the platform, writable | Identifies the purchase order. All the lines of a purchase order have the same PurchaseOrderID. |
| `Quantity` | `double` | Quantity | [ ] | filters on the platform, writable | Quantity in item units. |
| `QuantityInPurchaseUnits` | `double` | Quantity in Purchase Units | [ ] | writable | Quantity in purchase units. Use this field when creating a purchase order. |
| `Rebill` | `char` | Rebill | [ ] | filters on the platform, writable | Indicates whether the purchase order line needs to be rebilled. Only available with a professional service license. |
| `ReceiptDate` | `datetime` | Receipt Date | [ ] | filters on the platform, writable | Date the goods are expected to be received. |
| `ReceivedQuantity` | `double` | Received Quantity | [ ] | writable | Quantity of goods received. |
| `SalesOrder` | `guid` | Sales Order | [ ] | filters on the platform, writable | Sales order that is linked to a back to back sales order in purchase order. |
| `SalesOrderLine` | `guid` | Sales Order Line | [ ] | filters on the platform, writable | Sales order line of the sales order that is linked to a back to back sales order in purchase order. |
| `SalesOrderLineNumber` | `int32` | Sales Order Line Number | [ ] | filters on the platform, writable | Number of the sales order line. |
| `SalesOrderNumber` | `int32` | Sales Order Number | [ ] | filters on the platform, writable | Number of the sales order. |
| `ShopOrder` | `guid` | Shop Order | [ ] | filters on the platform, writable |  |
| `ShopOrderMaterialPlan` | `guid` | itgen_eol_shopordermaterialplan | [ ] | filters on the platform, writable |  |
| `ShopOrderMaterialPlanLineNumber` | `int32` | itgen_eol_shopordermaterialplanlinenumber | [ ] | filters on the platform |  |
| `ShopOrderNumber` | `int32` | Shop Order Number | [ ] | filters on the platform |  |
| `ShopOrderRoutingStepPlan` | `guid` | itgen_eol_shoporderroutingstepplan | [ ] | filters on the platform, writable |  |
| `ShopOrderRoutingStepPlanLineNumber` | `int32` | itgen_eol_shoporderroutingstepplanlinenumber | [ ] | filters on the platform |  |
| `SupplierItemCode` | `varchar2(240)` | Supplier Item Code | [ ] | writable | Code the supplier uses for this item. |
| `SupplierItemCopyRemarks` | `int16` | itgen_eol_supplieritemcopyremarks | [ ] | writable | Indicate if the notes content should be copied from SupplierItem's remarks. The default follows the CopyRemarks value from SupplierItem. Values: 0 = Do not copy remark, 1 = Copy remark. |
| `Unit` | `varchar2(8)` | Unit | [ ] | filters on the platform, writable | Code of item unit. |
| `UnitDescription` | `varchar2(60)` | Unit Description | [ ] | filters on the platform, writable | Description of unit. |
| `UnitPrice` | `double` | Unit Price | [ ] | writable | Item price per purchase unit. |
| `VATAmount` | `double` | VAT Amount | [ ] | filters on the platform, writable | Amount of VAT charges calculated from total amount and vat percentage. |
| `VATCode` | `varchar2(3)` | VAT Code | [ ] | filters on the platform, writable | The VAT code used when the invoice was registered. |
| `VATDescription` | `varchar2(60)` | VAT Description | [ ] | filters on the platform, writable | Description of the VAT code. |
| `VATPercentage` | `double` | VAT Percentage | [ ] | filters on the platform, writable | The VAT percentage of the VAT code. This is the percentage at the moment the invoice is created. It's also used by the default calculation of VAT amounts and VAT base amounts. |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `PurchaseOrderLines_CostCenter_Costcenters_fk` | `CostCenter` | [Costcenters](ExactOnlineREST.HRM.Costcenters)`.Code` | Key |  |
| `PurchaseOrderLines_CostUnit_Costunits_fk` | `CostUnit` | [Costunits](ExactOnlineREST.HRM.Costunits)`.Code` | Key |  |
| `PurchaseOrderLines_Creator_Users_fk` | `Creator` | [Users](ExactOnlineREST.Users.Users)`.UserID` | Key |  |
| `PurchaseOrderLines_Item_Items_fk` | `Item` | [Items](ExactOnlineREST.Logistics.Items)`.ID` | Key |  |
| `PurchaseOrderLines_Modifier_Users_fk` | `Modifier` | [Users](ExactOnlineREST.Users.Users)`.UserID` | Key |  |
| `PurchaseOrderLines_Project_Projects_fk` | `Project` | [Projects](ExactOnlineREST.Project.Projects)`.ID` | Key |  |
| `PurchaseOrderLines_PurchaseOrderID_PurchaseOrders_fk` | `PurchaseOrderID` | [PurchaseOrders](ExactOnlineREST.PurchaseOrder.PurchaseOrders)`.PurchaseOrderID` | Key |  |
| `PurchaseOrderLines_SalesOrderLine_SalesOrderLines_fk` | `SalesOrderLine` | [SalesOrderLines](ExactOnlineREST.SalesOrder.SalesOrderLines)`.ID` | Key |  |
| `PurchaseOrderLines_SalesOrder_SalesOrders_fk` | `SalesOrder` | [SalesOrders](ExactOnlineREST.SalesOrder.SalesOrders)`.OrderID` | Key |  |
| `PurchaseOrderLines_Unit_Units_fk` | `Unit` | [Units](ExactOnlineREST.Logistics.Units)`.Code` | Key |  |
| `PurchaseOrderLines_VATCode_VATCodes_fk` | `VATCode` | [VATCodes](ExactOnlineREST.VAT.VATCodes)`.Code` | Key |  |

## Referenced By

- [PurchaseInvoiceLines](ExactOnlineREST.Purchase.PurchaseInvoiceLines) `PurchaseOrderLine` (Key)
- [GoodsReceiptLines](ExactOnlineREST.PurchaseOrder.GoodsReceiptLines) `PurchaseOrderLineID` (Key)
- [SalesOrderLines](ExactOnlineREST.SalesOrder.SalesOrderLines) `PurchaseOrderLine` (Key)
- [SalesOrderLinesBulk](ExactOnlineREST.SalesOrder.SalesOrderLinesBulk) `PurchaseOrderLine` (Key)



## Release Notes

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

- [Exact Online](/en/release-notes/drivers?driver=exact-online)

