Here are the queries that I picked up with SQL Profiler that are running when opening SO Manager and clicking the item Tab:
SELECT ID, ItemLookUpCode, ItemType as ItemTypeText, Description, AvailableQuantity = Quantity - QuantityCommitted, Price, PictureName FROM Item Where Inactive = 0 UNION
SELECT ID, ItemLookUpCode, CASE ClassType WHEN 0 THEN 2 WHEN 1 THEN 8 WHEN 2 THEN 4 END, Description, null, null, '' FROM ItemClass WITH(NOLOCK) ORDER BY ItemLookupCode
GO
SELECT ID, ItemLookUpCode, ItemType as ItemTypeText, Description,CASE Inactive WHEN 0 THEN 'Active' ELSE 'Inactive' END As Status, AvailableQuantity = Quantity - QuantityCommitted, Price, PictureName FROM Item WHERE Inactive = 0 UNION
SELECT ID, ItemLookUpCode, CASE ClassType WHEN 0 THEN 2 WHEN 1 THEN 8 WHEN 2 THEN 4 END, Description,null, null, null, '' FROM ItemClass WITH(NOLOCK) ORDER BY ItemLookupCode
GO
SELECT Item.ID, ItemLookUpCode,ItemType as ItemTypeText, Supplierlist.reordernumber, Item.description,AvailableQuantity = Quantity - QuantityCommitted, SupplierList.Cost,Item.SupplierID as PrimarySupplierID,SupplierList.SupplierID FROM Item left join supplierlist on Item.ID = Supplierlist.ItemID
WHERE Inactive = 0
UNION
SELECT ID, ItemLookUpCode, CASE ClassType WHEN 0 THEN 2 WHEN 1 THEN 8 WHEN 2 THEN 4 END, null,Description, null, null,null,SupplierID FROM ItemClass WITH(NOLOCK) ORDER BY ItemLookupCode
GO
SELECT ID, ItemLookUpCode, ItemType as ItemTypeText, Description,CASE Inactive WHEN 0 THEN 'Active' ELSE 'Inactive' END As Status, AvailableQuantity = Quantity - QuantityCommitted, Price, PictureName FROM Item UNION
SELECT ID, ItemLookUpCode, CASE ClassType WHEN 0 THEN 2 WHEN 1 THEN 8 WHEN 2 THEN 4 END, Description,null, null, null, '' FROM ItemClass WITH(NOLOCK) ORDER BY ItemLookupCode
