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