PurchaseOrderLineItems
Query PurchaseOrderLines within Sage UK 50 Accounts.
Table Specific Information
Select
The PurchaseOrderLineItems table returns purchase order line item information for a Sage 50 UK company dataset.
SELECT * FROM PurchaseOrderLineItems WHERE PurchaseOrderNumber = 'PO123'
Columns
| Name | Type | Description |
| PurchaseOrderLineItemUUID [KEY] | String | PurchaseOrderLine UUID |
| CommodityUUID | String | PurchaseOrderLine Commodity UUID |
| CommodityProductCode | String | PurchaseOrderLine Commodity Product Code |
| CommodityName | String | PurchaseOrderLine Commodity Name |
| PurchaseOrderNumber | String | PurchaseOrderLine Reference |
| LineNumber | Decimal | PurchaseOrderLine Number |
| DueDate | Date | PurchaseOrderLine Due Date |
| Description | String | PurchaseOrderLine Text |
| Quantity | Decimal | PurchaseOrderLine Quantity |
| InitialPrice | Decimal | PurchaseOrderLine Initial Price |
| ActualPrice | Decimal | PurchaseOrderLine Actual Price |
| NetTotal | Decimal | PurchaseOrderLine Net Total |
| DiscountTotal | Decimal | PurchaseOrderLine Discount Total |
| TaxTotal | Decimal | PurchaseOrderLine Tax Total |
| GrossTotal | Decimal | PurchaseOrderLine Gross Total |
| UnitDescription | String | PurchaseOrderLine UnitOfMeasure Description |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Updated | Datetime | An input used internally to filter records updated at a specific datetime. |