JDBC Driver for Sage 50 UK

Build 22.0.8462

PurchaseOrderDeliveries

Query PurchaseOrderDeliveries within Sage UK 50 Accounts.

Table Specific Information

Select

The PurchaseOrderDeliveries table returns purchase order delivery information for a Sage 50 UK company dataset.

SELECT * FROM PurchaseOrderDeliveries

Columns

Name Type Description
PODeliveryUUID [KEY] String PurchaseOrderDelivery UUID
PurchaseOrderUUID String PurchaseOrderDelivery PurchaseOrder UUID
TradingAccountUUID String PurchaseOrderDelivery Trading Account UUID
GoodsReceivedNumber String PurchaseOrderDelivery Reference
SupplierReference String PurchaseOrderDelivery Supplier reference
CarrierReference String PurchaseOrderDelivery Carrier reference
Currency String PurchaseOrderDelivery Currency
OCCurrency String PurchaseOrderDelivery Operating Company Currency
OCCurrencyExchangeRate Decimal PurchaseOrderDelivery Operating Company Currency Exchange Rate
OCCurrencyExchangeRateOperator String PurchaseOrderDelivery Operating Company Currency Exchange Rate Operator
RequestedDeliveryDate Date PurchaseOrderDelivery Requested Delivery Date
ActualDeliveryDate Date PurchaseOrderDelivery Actual Delivery Date
LineCount Decimal PurchaseOrderDelivery Line Count
PostalAddressUUID String PurchaseOrderDelivery PostalAddress UUID
PostalAddressActive Boolean PurchaseOrderDelivery PostalAddress Active Flag
PostalAddressReference String PurchaseOrderDelivery PostalAddress Reference
PostalAddressName String PurchaseOrderDelivery PostalAddress Name
PostalAddressDescription String PurchaseOrderDelivery PostalAddress Description
PostalAddressAddress1 String PurchaseOrderDelivery PostalAddress Address 1
PostalAddressAddress2 String PurchaseOrderDelivery PostalAddress Address 2
PostalAddressAddress3 String PurchaseOrderDelivery PostalAddress Address 3
PostalAddressAddress4 String PurchaseOrderDelivery PostalAddress Address 4
PostalAddressTownCity String PurchaseOrderDelivery PostalAddress TownCity
PostalAddressCounty String PurchaseOrderDelivery PostalAddress County
PostalAddressStateRegion String PurchaseOrderDelivery PostalAddress StateRegion
PostalAddressZipPostCode String PurchaseOrderDelivery PostalAddress ZipPost Code
PostalAddressCountry String PurchaseOrderDelivery PostalAddress Country
PostalAddressPrimacyIndicator Boolean PurchaseOrderDelivery PostalAddress Primacy Indicator
PostalAddressType String PurchaseOrderDelivery 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