JDBC Driver for Sage 50 UK

Build 22.0.8462

SalesOrderDeliveryLineItems

Query SalesOrderDeliveryLineItems within Sage UK 50 Accounts.

Table Specific Information

Select

The SalesOrderDeliveryLineItems table returns sales order delivery line item information for a Sage 50 UK company dataset.

SELECT * FROM SalesOrderDeliveryLineItems WHERE GoodsDespatchedNumber = '987'

Columns

Name Type Description
SODeliveryLineItemUUID [KEY] String SalesOrderDeliveryLine UUID
CommodityUUID String SalesOrderDeliveryLine Commodity UUID
CommodityProductCode String SalesOrderDeliveryLine Commodity Product Code
CommodityName String SalesOrderDeliveryLine Commodity Name
SalesOrderNumber String SalesOrderDeliveryLine Sales Order Number
GoodsDespatchedNumber String SalesOrderDeliveryLine Reference
Reference2 String SalesOrderDeliveryLine Reference2
LineNumber Decimal SalesOrderDeliveryLine Number
Text String SalesOrderDeliveryLine Text
RequestedDeliveryDate Date SalesOrderDeliveryLine Requested Delivery Date
ActualDeliveryDate Date SalesOrderDeliveryLine Actual Delivery Date
RequestedQuantity Decimal SalesOrderDeliveryLine Requested Quantity
DeliveredQuantity Decimal SalesOrderDeliveryLine Delivered Quantity
UnitDescription String SalesOrderDeliveryLine 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