to check the folio has send to guest or not.

select top 100 * from tbReservationDetails where ReservationNumber='41848472'


select distinct ActionGroup  from tbNLog where ReservationNameID='28986502' 



select top 100 * from TbAuditTrailHeader where GroupIdentifier='41824745' order by AuditHeaderID desc