JDBC Driver for Sage 50 UK

Build 22.0.8462

SalesOrderLineItems

Query SalesOrderLineItems within Sage UK 50 Accounts.

Table Specific Information

Select

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

SELECT * FROM SalesOrderLineItems WHERE SalesOrderNumber = 'SO123'

Columns

Name Type Description
SalesOrderLineItemUUID [KEY] String SalesOrderLine UUID
CommodityUUID String SalesOrderLine Commodity UUID
CommodityProductCode String SalesOrderLine Commodity Product Code
CommodityName String SalesOrderLine Commodity Name
SalesOrderNumber String SalesOrderLine Reference
Reference2 String SalesOrderLine Reference2
LineNumber Decimal SalesOrderLine Number
Type String SalesOrderLine Type
Description String SalesOrderLine Text
DueDate Date SalesOrderLine Due Date
CarrierReference String SalesOrderLine Carrier reference
Quantity Decimal SalesOrderLine Quantity
InitialPrice Decimal SalesOrderLine Initial Price
OrderLineDiscountAmount Decimal SalesOrderLine Order Line Discount Amount
OrderLineDiscountPercent Decimal SalesOrderLine Order Line Discount Perecent
ActualPrice Decimal SalesOrderLine Actual Price
NetTotal Decimal SalesOrderLine Net Total
DiscountTotal Decimal SalesOrderLine Discount Total
TaxTotal Decimal SalesOrderLine Tax Total
GrossTotal Decimal SalesOrderLine Gross Total
UnitDescription String SalesOrderLine UnitOfMeasure Description
TaxCodeUUID String SalesOrderLine Tax Code UUID
TaxCodeReference String SalesOrderLine Tax Code
TaxCodeValue Decimal SalesOrderLine Tax Code Value
TaxCodeDescription String SalesOrderLine Tax Code Description
TaxCodeType String SalesOrderLine Tax Code Type

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