SELECT [DispatchOperator].[DeliveryId] AS [DeliveryId], [DispatchOperator].[OperatorLoginId] AS [OperatorLoginId], [DispatchOperator].[DeviceName] AS [DeviceName], [DispatchOperator].[PosPrinter] AS [PosPrinter], [DispatchOperator].[LastEdit] AS [LastEdit] FROM [dbo].[DispatchOperator] AS [DispatchOperator] SELECT [VAT].[VAT] AS [VAT] FROM [dbo].[VAT] AS [VAT] SELECT [vwClosedCustomerWorkloads].[WorkloadItemId] AS [WorkloadItemId], [vwClosedCustomerWorkloads].[WorkloadId] AS [WorkloadId], [vwClosedCustomerWorkloads].[CustomerInventoryId] AS [CustomerInventoryId], [vwClosedCustomerWorkloads].[ItemCount] AS [ItemCount], [vwClosedCustomerWorkloads].[CustomerLoginId] AS [CustomerLoginId], [vwClosedCustomerWorkloads].[OperatorLoginId] AS [OperatorLoginId], [vwClosedCustomerWorkloads].[TimeStamp] AS [TimeStamp] FROM [dbo].[vwClosedCustomerWorkloads] AS [vwClosedCustomerWorkloads] SELECT [vwCustomerBagsReadyToDispatch].[CustomerId] AS [CustomerId], [vwCustomerBagsReadyToDispatch].[DispatchId] AS [DispatchId], [vwCustomerBagsReadyToDispatch].[BagSeal] AS [BagSeal], [vwCustomerBagsReadyToDispatch].[DispatchPackagesCount] AS [DispatchPackagesCount], [vwCustomerBagsReadyToDispatch].[Name] AS [Name], [vwCustomerBagsReadyToDispatch].[WorkloadId] AS [WorkloadId] FROM [dbo].[vwCustomerBagsReadyToDispatch] AS [vwCustomerBagsReadyToDispatch] SELECT [vwCustomerBagsWaitingCounting].[CustomerId] AS [CustomerId], [vwCustomerBagsWaitingCounting].[Name] AS [Name], [vwCustomerBagsWaitingCounting].[BagCount] AS [BagCount], [vwCustomerBagsWaitingCounting].[CompanyID] AS [CompanyID] FROM [dbo].[vwCustomerBagsWaitingCounting] AS [vwCustomerBagsWaitingCounting] SELECT [vwCustomerInventory].[CustomerId] AS [CustomerId], [vwCustomerInventory].[CustomerInventoryId] AS [CustomerInventoryId], [vwCustomerInventory].[Category] AS [Category], [vwCustomerInventory].[ItemType] AS [ItemType], [vwCustomerInventory].[Size] AS [Size], [vwCustomerInventory].[TCOrderPriority] AS [TCOrderPriority], [vwCustomerInventory].[TSOrderPriority] AS [TSOrderPriority] FROM [dbo].[vwCustomerInventory] AS [vwCustomerInventory] SELECT [vwCustomerInventoryForWorkload].[CustomerId] AS [CustomerId], [vwCustomerInventoryForWorkload].[CustomerInventoryId] AS [CustomerInventoryId], [vwCustomerInventoryForWorkload].[Category] AS [Category], [vwCustomerInventoryForWorkload].[ItemType] AS [ItemType], [vwCustomerInventoryForWorkload].[Size] AS [Size], [vwCustomerInventoryForWorkload].[TCOrderPriority] AS [TCOrderPriority], [vwCustomerInventoryForWorkload].[TSOrderPriority] AS [TSOrderPriority] FROM [dbo].[vwCustomerInventoryForWorkload] AS [vwCustomerInventoryForWorkload] SELECT [vwCustomerInventoryWorkload].[WorkloadId] AS [WorkloadId], [vwCustomerInventoryWorkload].[InventoryItemTypeId] AS [InventoryItemTypeId], [vwCustomerInventoryWorkload].[CostGeneralWash] AS [CostGeneralWash], [vwCustomerInventoryWorkload].[CostRepeatWash] AS [CostRepeatWash], [vwCustomerInventoryWorkload].[CostStainWash] AS [CostStainWash], [vwCustomerInventoryWorkload].[ItemCount] AS [ItemCount] FROM [dbo].[vwCustomerInventoryWorkload] AS [vwCustomerInventoryWorkload] SELECT [vwDeliveryNoteCategoriesByBagSeal].[DispatchId] AS [DispatchId], [vwDeliveryNoteCategoriesByBagSeal].[InvoiceId] AS [InvoiceId], [vwDeliveryNoteCategoriesByBagSeal].[BagSeal] AS [BagSeal], [vwDeliveryNoteCategoriesByBagSeal].[Categories] AS [Categories] FROM [dbo].[vwDeliveryNoteCategoriesByBagSeal] AS [vwDeliveryNoteCategoriesByBagSeal] SELECT [vwDeliveryNoteCategoriesByBagSeal2].[DispatchId] AS [DispatchId], [vwDeliveryNoteCategoriesByBagSeal2].[InvoiceId] AS [InvoiceId], [vwDeliveryNoteCategoriesByBagSeal2].[BagSeal] AS [BagSeal], [vwDeliveryNoteCategoriesByBagSeal2].[Categories] AS [Categories], [vwDeliveryNoteCategoriesByBagSeal2].[WorkloadId] AS [WorkloadId], [vwDeliveryNoteCategoriesByBagSeal2].[DeliveryId] AS [DeliveryId] FROM [dbo].[vwDeliveryNoteCategoriesByBagSeal2] AS [vwDeliveryNoteCategoriesByBagSeal2] SELECT [vwDispatchBagPackageContents].[DispatchId] AS [DispatchId], [vwDispatchBagPackageContents].[PackageId] AS [PackageId], [vwDispatchBagPackageContents].[BagNumber] AS [BagNumber], [vwDispatchBagPackageContents].[ItemType] AS [ItemType], [vwDispatchBagPackageContents].[Category] AS [Category], [vwDispatchBagPackageContents].[Category_OrderPriority] AS [Category_OrderPriority], [vwDispatchBagPackageContents].[Size] AS [Size], [vwDispatchBagPackageContents].[Size_OrderPriority] AS [Size_OrderPriority], [vwDispatchBagPackageContents].[ItemCount] AS [ItemCount], [vwDispatchBagPackageContents].[ItemCountStain] AS [ItemCountStain] FROM [dbo].[vwDispatchBagPackageContents] AS [vwDispatchBagPackageContents] SELECT [vwDispatchesOutForDelivery].[InvoiceId] AS [InvoiceId] FROM [dbo].[vwDispatchesOutForDelivery] AS [vwDispatchesOutForDelivery] SELECT [vwDispatchesReadyToPrint].[DeliveryId] AS [DeliveryId], [vwDispatchesReadyToPrint].[CustomerId] AS [CustomerId], [vwDispatchesReadyToPrint].[WorkloadId] AS [WorkloadId], [vwDispatchesReadyToPrint].[DateCreated] AS [DateCreated], [vwDispatchesReadyToPrint].[DateDelivered] AS [DateDelivered], [vwDispatchesReadyToPrint].[Dispatch] AS [Dispatch] FROM [dbo].[vwDispatchesReadyToPrint] AS [vwDispatchesReadyToPrint] SELECT [vwExcelDataDump].[Date] AS [Date], [vwExcelDataDump].[Name] AS [Name], [vwExcelDataDump].[Type] AS [Type], [vwExcelDataDump].[ItemType] AS [ItemType], [vwExcelDataDump].[Size] AS [Size], [vwExcelDataDump].[ItemCount] AS [ItemCount] FROM [dbo].[vwExcelDataDump] AS [vwExcelDataDump] SELECT [vwInventoryItems].[InventoryItemTypeId] AS [InventoryItemTypeId], [vwInventoryItems].[ItemType] AS [ItemType], [vwInventoryItems].[Category] AS [Category], [vwInventoryItems].[Size] AS [Size], [vwInventoryItems].[Categories_OrderPriority] AS [Categories_OrderPriority], [vwInventoryItems].[Size_OrderPriority] AS [Size_OrderPriority] FROM [dbo].[vwInventoryItems] AS [vwInventoryItems] SELECT [vwInventoryItemTypes].[Category] AS [Category], [vwInventoryItemTypes].[ItemType] AS [ItemType] FROM [dbo].[vwInventoryItemTypes] AS [vwInventoryItemTypes] SELECT [vwInvoiceBagSealCategories].[DispatchId] AS [DispatchId], [vwInvoiceBagSealCategories].[InvoiceId] AS [InvoiceId], [vwInvoiceBagSealCategories].[BagSeal] AS [BagSeal], [vwInvoiceBagSealCategories].[Category] AS [Category], [vwInvoiceBagSealCategories].[DeliveryId] AS [DeliveryId] FROM [dbo].[vwInvoiceBagSealCategories] AS [vwInvoiceBagSealCategories] SELECT [vwInvoiceCountsCondemned].[InvoiceId] AS [InvoiceId], [vwInvoiceCountsCondemned].[WorkloadId] AS [WorkloadId], [vwInvoiceCountsCondemned].[InventoryItemTypeId] AS [InventoryItemTypeId], [vwInvoiceCountsCondemned].[ItemType] AS [ItemType], [vwInvoiceCountsCondemned].[Category] AS [Category], [vwInvoiceCountsCondemned].[Size] AS [Size], [vwInvoiceCountsCondemned].[InvoiceBadCount] AS [InvoiceBadCount], [vwInvoiceCountsCondemned].[CustomerItemCount] AS [CustomerItemCount], [vwInvoiceCountsCondemned].[Cost] AS [Cost], [vwInvoiceCountsCondemned].[CostGeneralWash] AS [CostGeneralWash], [vwInvoiceCountsCondemned].[CostRepeatWash] AS [CostRepeatWash], [vwInvoiceCountsCondemned].[CostStainWash] AS [CostStainWash], [vwInvoiceCountsCondemned].[Categories_OrderPriority] AS [Categories_OrderPriority], [vwInvoiceCountsCondemned].[Size_OrderPriority] AS [Size_OrderPriority] FROM [dbo].[vwInvoiceCountsCondemned] AS [vwInvoiceCountsCondemned] SELECT [vwInvoiceCountsRecon].[InvoiceId] AS [InvoiceId], [vwInvoiceCountsRecon].[WorkloadId] AS [WorkloadId], [vwInvoiceCountsRecon].[InventoryItemTypeId] AS [InventoryItemTypeId], [vwInvoiceCountsRecon].[ItemType] AS [ItemType], [vwInvoiceCountsRecon].[Category] AS [Category], [vwInvoiceCountsRecon].[Size] AS [Size], [vwInvoiceCountsRecon].[InvoiceItemCount] AS [InvoiceItemCount], [vwInvoiceCountsRecon].[CustomerItemCount] AS [CustomerItemCount], [vwInvoiceCountsRecon].[Cost] AS [Cost], [vwInvoiceCountsRecon].[CostGeneralWash] AS [CostGeneralWash], [vwInvoiceCountsRecon].[CostRepeatWash] AS [CostRepeatWash], [vwInvoiceCountsRecon].[CostStainWash] AS [CostStainWash], [vwInvoiceCountsRecon].[Categories_OrderPriority] AS [Categories_OrderPriority], [vwInvoiceCountsRecon].[Size_OrderPriority] AS [Size_OrderPriority] FROM [dbo].[vwInvoiceCountsRecon] AS [vwInvoiceCountsRecon] SELECT [vwInvoiceItemCounts].[InvoiceId] AS [InvoiceId], [vwInvoiceItemCounts].[Name] AS [Name], [vwInvoiceItemCounts].[WorkloadId] AS [WorkloadId], [vwInvoiceItemCounts].[DateCreated] AS [DateCreated], [vwInvoiceItemCounts].[ItemCount] AS [ItemCount] FROM [dbo].[vwInvoiceItemCounts] AS [vwInvoiceItemCounts] SELECT [vwInvoicesReadyToPrint].[Id] AS [Id], [vwInvoicesReadyToPrint].[CustomerId] AS [CustomerId], [vwInvoicesReadyToPrint].[WorkloadId] AS [WorkloadId], [vwInvoicesReadyToPrint].[DateCreated] AS [DateCreated], [vwInvoicesReadyToPrint].[OperatorLoginId] AS [OperatorLoginId], [vwInvoicesReadyToPrint].[InvoiceStatusId] AS [InvoiceStatusId], [vwInvoicesReadyToPrint].[InvoiceType] AS [InvoiceType], [vwInvoicesReadyToPrint].[InvoiceId] AS [InvoiceId] FROM [dbo].[vwInvoicesReadyToPrint] AS [vwInvoicesReadyToPrint] SELECT [vwInvoicesReadyToPrint2].[Id] AS [Id], [vwInvoicesReadyToPrint2].[CustomerId] AS [CustomerId], [vwInvoicesReadyToPrint2].[WorkloadId] AS [WorkloadId], [vwInvoicesReadyToPrint2].[DateCreated] AS [DateCreated], [vwInvoicesReadyToPrint2].[OperatorLoginId] AS [OperatorLoginId], [vwInvoicesReadyToPrint2].[InvoiceStatusId] AS [InvoiceStatusId], [vwInvoicesReadyToPrint2].[InvoiceType] AS [InvoiceType], [vwInvoicesReadyToPrint2].[InvoiceId] AS [InvoiceId], [vwInvoicesReadyToPrint2].[Invoice] AS [Invoice], [vwInvoicesReadyToPrint2].[Printed] AS [Printed] FROM [dbo].[vwInvoicesReadyToPrint2] AS [vwInvoicesReadyToPrint2] SELECT [vwOpenCustomerWorkloads].[WorkloadItemId] AS [WorkloadItemId], [vwOpenCustomerWorkloads].[WorkloadId] AS [WorkloadId], [vwOpenCustomerWorkloads].[CustomerInventoryId] AS [CustomerInventoryId], [vwOpenCustomerWorkloads].[ItemCount] AS [ItemCount], [vwOpenCustomerWorkloads].[CustomerLoginId] AS [CustomerLoginId], [vwOpenCustomerWorkloads].[OperatorLoginId] AS [OperatorLoginId], [vwOpenCustomerWorkloads].[TimeStamp] AS [TimeStamp] FROM [dbo].[vwOpenCustomerWorkloads] AS [vwOpenCustomerWorkloads] SELECT [vwPackageContents].[PackageId] AS [PackageId], [vwPackageContents].[InvoiceId] AS [InvoiceId], [vwPackageContents].[WorkloadId] AS [WorkloadId], [vwPackageContents].[Description] AS [Description] FROM [dbo].[vwPackageContents] AS [vwPackageContents] SELECT [vwPackagesReadyForDispatch].[PackageId] AS [PackageId], [vwPackagesReadyForDispatch].[InvoiceItemId] AS [InvoiceItemId], [vwPackagesReadyForDispatch].[ItemCount] AS [ItemCount], [vwPackagesReadyForDispatch].[OperatorLoginId] AS [OperatorLoginId], [vwPackagesReadyForDispatch].[DateCreated] AS [DateCreated] FROM [dbo].[vwPackagesReadyForDispatch] AS [vwPackagesReadyForDispatch] SELECT [vwWorkloadCategoryTypeCounts].[WorkloadId] AS [WorkloadId], [vwWorkloadCategoryTypeCounts].[Category] AS [Category], [vwWorkloadCategoryTypeCounts].[ItemType] AS [ItemType], [vwWorkloadCategoryTypeCounts].[ItemCount] AS [ItemCount] FROM [dbo].[vwWorkloadCategoryTypeCounts] AS [vwWorkloadCategoryTypeCounts] SELECT [vwWorkloadStatusReport].[WorkloadStatusId] AS [WorkloadStatusId], [vwWorkloadStatusReport].[Status] AS [Status], [vwWorkloadStatusReport].[Customers] AS [Customers], [vwWorkloadStatusReport].[TotalItems] AS [TotalItems] FROM [dbo].[vwWorkloadStatusReport] AS [vwWorkloadStatusReport] SELECT [vwWorkloadStatusReportWithCounts].[WorkloadStatusId] AS [WorkloadStatusId], [vwWorkloadStatusReportWithCounts].[Status] AS [Status], [vwWorkloadStatusReportWithCounts].[Customers] AS [Customers], [vwWorkloadStatusReportWithCounts].[Bags] AS [Bags], [vwWorkloadStatusReportWithCounts].[Items] AS [Items] FROM [dbo].[vwWorkloadStatusReportWithCounts] AS [vwWorkloadStatusReportWithCounts]