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