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