JDBC Driver for Sage 50 UK

Build 22.0.8462

SalesInvoiceLineItems

Query SalesInvoiceLineItems within Sage UK 50 Accounts.

Table Specific Information

Select

The SalesInvoiceLineItems table returns sales invoice line item information for a Sage 50 UK company dataset.

SELECT * FROM SalesInvoiceLineItems WHERE InvoiceNumber = 'INV123'

Columns

Name Type Description
SalesInvoiceLineItemUUID [KEY] String SalesInvoiceLine UUID
CommodityUUID String SalesInvoiceLine Commodity UUID
CommodityProductCode String SalesInvoiceLine Commodity Product Code
CommodityName String SalesInvoiceLine Commodity Name
InvoiceNumber String SalesInvoice Reference
Reference2 String SalesInvoice Reference2
Type String SalesInvoiceLine Type
LineNumber Integer SalesInvoiceLine Number
Text String SalesInvoiceLine Text
DeliveryDate Date SalesInvoiceLine Delivery Date
Quantity Decimal SalesInvoiceLine Quantity
InitialPrice Decimal SalesInvoiceLine Initial Price
InvoiceLineDiscountAmount Decimal SalesInvoiceLine Invoice Line Discount Amount
InvoiceLineDiscountPercent Decimal SalesInvoiceLine Invoice Line Discount Percent
ActualPrice Decimal SalesInvoiceLine Actual Price
NetTotal Decimal SalesInvoiceLine Net Total
ChargesTotal Decimal SalesInvoiceLine Charges Total
DiscountTotal Decimal SalesInvoiceLine Discount Total
TaxTotal Decimal SalesInvoiceLine Tax Total
GrossTotal Decimal SalesInvoiceLine Gross Total
UnitDescription String SalesInvoiceLine 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