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. |