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