JDBC Driver for Sage 50 UK

Build 22.0.8462

PurchaseOrderLineItems

Query PurchaseOrderLines within Sage UK 50 Accounts.

Table Specific Information

Select

The PurchaseOrderLineItems table returns purchase order line item information for a Sage 50 UK company dataset.

SELECT * FROM PurchaseOrderLineItems WHERE PurchaseOrderNumber = 'PO123'

Columns

Name Type Description
PurchaseOrderLineItemUUID [KEY] String PurchaseOrderLine UUID
CommodityUUID String PurchaseOrderLine Commodity UUID
CommodityProductCode String PurchaseOrderLine Commodity Product Code
CommodityName String PurchaseOrderLine Commodity Name
PurchaseOrderNumber String PurchaseOrderLine Reference
LineNumber Decimal PurchaseOrderLine Number
DueDate Date PurchaseOrderLine Due Date
Description String PurchaseOrderLine Text
Quantity Decimal PurchaseOrderLine Quantity
InitialPrice Decimal PurchaseOrderLine Initial Price
ActualPrice Decimal PurchaseOrderLine Actual Price
NetTotal Decimal PurchaseOrderLine Net Total
DiscountTotal Decimal PurchaseOrderLine Discount Total
TaxTotal Decimal PurchaseOrderLine Tax Total
GrossTotal Decimal PurchaseOrderLine Gross Total
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