TRN:TranDate >= 77724 and TRN:TranDate <= 77725 and TRN:CadID = 1 and TRN:TranType <> 32 and TRN:IsDeleted = 0