HHT.sql

USE TrioStaging
GO

DECLARE @HHTBatchQueueId INT = 576601;

SELECT *
FROM [HHTBatchQueue]
WHERE HHTBatchQueueId = @HHTBatchQueueId;

SELECT *
FROM [HHTCountingTransaction]
WHERE HHTBatchQueueId = @HHTBatchQueueId;

SELECT *
FROM [HHTGenericTransaction]
WHERE HHTBatchQueueId = @HHTBatchQueueId;

SELECT *
FROM [HHTOrderTransaction]
WHERE HHTBatchQueueId = @HHTBatchQueueId;

SELECT HandheldTransactionTypeNo TransNo
	,ctd.TEXT
FROM Trio..HandheldTransactionType htt
INNER JOIN Trio..CommonTextDetail ctd ON ctd.CommonTextMasterId = htt.DescriptionId
	AND ctd.CountryId = (SELECT CountryId FROM Trio..Country WHERE code = 'DK')
WHERE MenuNo IS NOT NULL
ORDER BY HandheldTransactionTypeNo

SELECT TOP 100 *
FROM Trio..HandheldDocument
ORDER BY CreatedDateTime desc

DECLARE @HandheldDocumentId UNIQUEIDENTIFIER = 'E099B6CA-C0F8-4184-94D5-A32C009B2ABF'

SELECT i.ItemNo, il.RetailUnitId, t.*
FROM Trio..HandheldCommonLine t
LEFT OUTER JOIN Trio..ItemLocal il ON il.ItemLocalId = t.ItemLocalId
LEFT OUTER JOIN Trio..Item i ON i.ItemId = il.ItemId
WHERE HandheldDocumentId = @HandheldDocumentId

SELECT *
FROM Trio..HandheldOrderLine
WHERE HandheldDocumentId = @HandheldDocumentId

SELECT *
FROM Trio..HandheldStockCountLine
WHERE HandheldDocumentId = @HandheldDocumentId