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. |