PurchaseOrderLines
When making larger requests for purchase order information, the Purchase Order Line Views resource is a faster alternative to the 'Purchase Orders' resource.
Table Specific Information
Select
The driver uses the Sage 200c Standard Online API to process all search criteria.
Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.
For example, the following queries are processed server side:
SELECT * FROM PurchaseOrderLines WHERE PurchaseOrderId=42101 SELECT * FROM PurchaseOrderLines WHERE CurrencyId='0000000001'
Columns
| Name | Type | References | Description |
| PurchaseOrderId [KEY] | Long | Unique ID of the purchase order. See _orders | |
| SupplierDocumentNo | String | Supplier purchase order document number. | |
| CurrencyId | Long | The Id for the currency used for the purchase order. See currencies | |
| CurrencyName | String | The name for the currency used for the purchase order. | |
| CurrencySymbol | String | The symbol of the currency used for the purchase order. | |
| SubtotalValue | Decimal | The subtotal value for the order. | |
| SubtotalDiscountValue | Decimal | The subtotal discount value for the order. | |
| SubtotalLandedCostsValue | Decimal | The subtotal landed costs value for the order. | |
| LineId | Long | Associated purchase order line Id. See _order_lines | |
| LineNumber | Short | Purchase order line number. | |
| LineType | String | Purchase order line type. See order_return_line_types | |
| LineProductCode | String | Purchase order line product code. | |
| LineProductDescription | String | Purchase order line product description. This could be stock item description, free text, additional charge or comment. | |
| LineQuantity | Decimal | The quantity ordered. | |
| LineUnitPrice | Decimal | The buying price per item. | |
| LineUnitDiscountPercent | Decimal | The percentage discount per item. | |
| LineUnitDiscountValue | Decimal | The discount value per item. | |
| LineTotalValue | Decimal | The total value of the line. | |
| LineDiscountedUnitPrice | Decimal | The discounted unit price of the line. This is calculated by subtracting the _order_line_unit_discount_value from the _order_line_unit_price. | |
| LineLandedCostsValue | Decimal | The value of landed costs for the order. | |
| LineAnalysisCode1 | String | Analysis code 1. | |
| LineAnalysisCode2 | String | Analysis code 2. | |
| LineAnalysisCode3 | String | Analysis code 3. | |
| LineAnalysisCode4 | String | Analysis code 4. | |
| LineAnalysisCode5 | String | Analysis code 5. | |
| LineAnalysisCode6 | String | Analysis code 6. | |
| LineAnalysisCode7 | String | Analysis code 7. | |
| LineAnalysisCode8 | String | Analysis code 8. | |
| LineAnalysisCode9 | String | Analysis code 9. | |
| LineAnalysisCode10 | String | Analysis code 10. | |
| LineAnalysisCode11 | String | Analysis code 11. | |
| LineAnalysisCode12 | String | Analysis code 12. | |
| LineAnalysisCode13 | String | Analysis code 13. | |
| LineAnalysisCode14 | String | Analysis code 14. | |
| LineAnalysisCode15 | String | Analysis code 15. | |
| LineAnalysisCode16 | String | Analysis code 16. | |
| LineAnalysisCode17 | String | Analysis code 17. | |
| LineAnalysisCode18 | String | Analysis code 18. | |
| LineAnalysisCode19 | String | Analysis code 19. | |
| LineAnalysisCode20 | String | Analysis code 20. | |
| LineDateTimeUpdated | Datetime | The date and time the order line was last updated (UTC). | |
| LineForDirectDelivery | Bool | Indicates if line is marked for direct delivery | |
| LineShowOnSupplierDocs | Bool | Indicates if line will show on supplier documents. | |
| DeliveryAddrPostalName | String | delivery address name. | |
| DeliveryAddrDescription | String | delivery address description. | |
| DeliveryAddrAddress1 | String | delivery address line 1. | |
| DeliveryAddrAddress2 | String | delivery address line 2. | |
| DeliveryAddrAddress3 | String | delivery address line 3. | |
| DeliveryAddrAddress4 | String | delivery address line 4. | |
| DeliveryAddrCity | String | delivery address city. | |
| DeliveryAddrCounty | String | delivery address county. | |
| DeliveryAddrPostCode | String | delivery address post code | |
| DeliveryAddrCountry | String | delivery address country. | |
| DeliveryAddrContact | String | delivery address contact | |
| DeliveryAddrTelephone | String | delivery address telephone number | |
| DeliveryAddrFax | String | delivery address line fax number... | |
| DeliveryAddrEmail | String | delivery address line email. | |
| SupplierId | Long | The associated supplier record Id. See suppliers | |
| SupplierReference | String | The associated supplier account reference. | |
| SupplierName | String | The associated supplier name. | |
| ProductId | Long | The associated product record Id. Only returned where _order_line_type = EnumLineTypeStandard. See products | |
| ProductCode | String | The code of the product ordered. Only returned where _order_line_type = EnumLineTypeStandard | |
| ProductName | String | The name of the product ordered. Only returned where _order_line_type = EnumLineTypeStandard | |
| ProductDescription | String | The associated product description. Only returned where _order_line_type = EnumLineTypeStandard | |
| WarehouseId | Long | The id of the warehouse the product is stored in. Only returned where _order_line_type = EnumLineTypeStandard. See warehouses | |
| WarehouseName | String | The name of the warehouse. Only returned where _order_line_type = EnumLineTypeStandard | |
| TaxCodeId | Long | The id of the tax code set on the line. See tax_codes | |
| TaxCodeCode | Short | The associated tax code. | |
| TaxCodeName | String | The associated tax code name. | |
| TaxCodeRate | Decimal | The associated tax rate. |