JDBC Driver for Sage 50 UK

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462