PurchaseOrderDeliveryLineItems
Query PurchaseOrderDeliveryLineItems within Sage UK 50 Accounts.
Table Specific Information
Select
The PurchaseOrderDeliveryLineItems table returns purchase order delivery line item information for a Sage 50 UK company dataset.
SELECT * FROM PurchaseOrderDeliveryLineItems WHERE GoodsReceivedNumber = '123'
Columns
| Name | Type | Description |
| PODeliveryLineItemUUID [KEY] | String | PurchaseOrderDeliveryLine UUID |
| CommodityUUID | String | PurchaseOrderDeliveryLine Commodity UUID |
| CommodityProductCode | String | PurchaseOrderDeliveryLine Commodity Product Code |
| CommodityName | String | PurchaseOrderDeliveryLine Commodity Name |
| GoodsReceivedNumber | String | PurchaseOrderDeliveryLine Reference |
| Reference2 | String | PurchaseOrderDeliveryLine Reference2 |
| LineNumber | Decimal | PurchaseOrderDeliveryLine Number |
| Text | String | PurchaseOrderDeliveryLine Text |
| RequestedQuantity | Decimal | PurchaseOrderDeliveryLine Requested Quantity |
| DeliveredQuantity | Decimal | PurchaseOrderDeliveryLine Delivered Quantity |
| 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. |