JDBC Driver for Sage 50 UK

Build 22.0.8462

SalesOrderDeliveries

Query SalesOrderDeliveries within Sage UK 50 Accounts.

Table Specific Information

Select

The SalesOrderDeliveries table returns sales order delivery information for a Sage 50 UK company dataset.

SELECT * FROM SalesOrderDeliveries

Columns

Name Type Description
SODeliveryUUID [KEY] String SalesOrderDelivery UUID
SalesOrderUUID String SalesOrderDelivery SalesOrder UUID
TradingAccountUUID String SalesOrderDelivery Trading Account UUID
SalesOrderNumber String SalesOrderDelivery Reference
TradingAccountReference String SalesOrderDelivery Reference2
CustomerReference String SalesOrderDelivery Customer reference
CarrierReference String SalesOrderDelivery Carrier reference
Currency String SalesOrderDelivery Currency
OCCurrency String SalesOrderDelivery Operating Company Currency
CustomerCurrencyExchangeRate Decimal SalesOrderDelivery Customer Trading Account Currency Exchange Rate
CustomerCurrencyExchangeRateOperator String SalesOrderDelivery Customer Trading Account Currency Exchange Rate Operator
RequestedDeliveryDate Date SalesOrderDelivery Requested Delivery Date
ActualDeliveryDate Date SalesOrderDelivery Actual Delivery Date
LineCount Decimal SalesOrderDelivery Line Count
PostalAddressUUID String SalesOrderDelivery PostalAddress UUID
PostalAddressActive Boolean SalesOrderDelivery PostalAddress Active Flag
PostalAddressReference String SalesOrderDelivery PostalAddress Reference
PostalAddressName String SalesOrderDelivery PostalAddress Name
PostalAddressDescription String SalesOrderDelivery PostalAddress Description
PostalAddressAddress1 String SalesOrderDelivery PostalAddress Address 1
PostalAddressAddress2 String SalesOrderDelivery PostalAddress Address 2
PostalAddressAddress3 String SalesOrderDelivery PostalAddress Address 3
PostalAddressAddress4 String SalesOrderDelivery PostalAddress Address 4
PostalAddressTownCity String SalesOrderDelivery PostalAddress TownCity
PostalAddressCounty String SalesOrderDelivery PostalAddress County
PostalAddressStateRegion String SalesOrderDelivery PostalAddress StateRegion
PostalAddressZipPostCode String SalesOrderDelivery PostalAddress ZipPost Code
PostalAddressCountry String SalesOrderDelivery PostalAddress Country
PostalAddressPrimacyIndicator Boolean SalesOrderDelivery PostalAddress Primacy Indicator
PostalAddressType String SalesOrderDelivery PostalAddress Type. Sample values: Billing, Shipping.

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