SELECT
B.BranchName,
a.CashDropId,
a.CashDropDate,
A.TillNumber,
A.UserId,
A.DropAmount,
A.BranchId ,
BagNumber,
E.ReferenceNo,
E.[Date] AS CashupDate
FROM CashDrop A
INNER JOIN Branch B ON A.BranchId = B.BranchID
LEFT JOIN [EnvelopDetails] E ON E.CashDropId = A.CashDropId
WHERE A.PickupDate IS NULL
AND A.CashDropId NOT IN (SELECT CashDropId FROM EnvelopDetails)
And A.BranchId IN (Select BranchId From Branches
WHERE BranchType = 'Branch'
AND ISNULL(bTouchPOS,0) = 1
AND ISNULL(UseNewCashup,0) = 1)
AND B.BranchID = 'BAB68CF2-BCE6-458B-AD26-43F58B73E753'
ORDER BY CashDropDate DESC
