ODBC Driver for Sage 50 UK

Build 23.0.8839


Query SalesCreditLineItems within Sage UK 50 Accounts.

Table Specific Information


The SalesCreditLineItems table returns sales credit line item information for a Sage 50 UK company dataset.

SELECT * FROM SalesCreditLineItems WHERE CreditNumber = 'CR123'


Name Type Description
SalesCreditLineItemsUUID [KEY] String SalesCreditLine UUID
CommodityUUID String SalesCreditLine Commodity UUID
CommodityProductCode String SalesCreditLine Commodity Product Code
CommodityName String SalesCreditLine Commodity Name
CreditNumber String SalesCredit Reference
Reference2 String SalesCreditLine Reference2
Type String SalesCreditLine Type
Number Decimal SalesCreditLine Number
Description String SalesCreditLine Text
DeliveryDate Date SalesCreditLine Delivery Date
Quantity Decimal SalesCreditLine Quantity
InitialPrice Decimal SalesCreditLine Initial Price
InvoiceLineDiscountAmount Decimal SalesCreditLine Invoice Line Discount Amount
InvoiceLineDiscountPercent Decimal SalesCreditLine Invoice Line Discount Percent
ActualPrice Decimal SalesCreditLine Actual Price
NetTotal Decimal SalesCreditLine Net Total
DiscountTotal Decimal SalesCreditLine Discount Total
TaxTotal Decimal SalesCreditLine Tax Total
GrossTotal Decimal SalesCreditLine Gross Total
UnitDescription String SalesCreditLine UnitOfMeasure Description


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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839