--SELECT * FROM tbFloatMovementType

--JAT Validation
SELECT StoreTimestamp, Amount, ManagerID, * FROm tbFloatMovement
WHERe EntityID=271 AND floatmovementdate='2023-01-27'
	AND FloatMovementTypeID=4 --4 = Deposited and 5=received

--get the user names 
SELECT FirstName + ' ' + LastName 
FROM tbUser WHERE UserID = 908546



--EXECUTE on CFARDS2
SELECT StoreTimestamp, Amount, ManagerID, * FROm tbFloatMovement
WHERe EntityID=875 AND floatmovementdate='2020-01=10'
AND FloatMovementTypeID=4 --4 = Deposited and 5=received

SELECT FirstName + ' ' + LastName 
FROM tbUser WHERE UserID = 908546 