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