{"hotel_id":"116","sub_hotel_id":0,"room_type":"hotel","date":"2021-03-20","total_rooms_exist":"322,323,324,327,328,340,346,347,348,349,350,1883,1884,1885,1886","departureCount":3,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3219596","reservation_id":"110491","confirmation_number":"MH11667237081","room_stay_from":"2021-03-19","room_stay_to":"2021-03-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"284.00,284.00,284.00,284.00,284.00,284.00,284.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1988.00","grand_total":"2246.44","paid_amount":"2246.44","room_type_id":"198","product_id":"346","siteminder_id":"BDC-3447463140","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117004","customer_id":"117004","source_of_creation":"Booking.com","reservation_created_date":"2021-03-17 03:29:08","canceled_nights_data":"","product_name":"Apartment 203","ota_service_fee_amount":"0","commision_charges":"298.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"116","currentDayPrice":"284.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"83","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"121","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3219588","reservation_id":"110163","confirmation_number":"MH11681296590","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"260.00,260.00","nightly_discount":"0,0","subtotal":"520.00","grand_total":"587.60","paid_amount":"587.60","room_type_id":"184","product_id":"323","siteminder_id":"EXP-1746922643","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117346","customer_id":"117346","source_of_creation":"Expedia","reservation_created_date":"2021-03-12 23:42:12","canceled_nights_data":"","product_name":"Apartment 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"116","currentDayPrice":"260.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"83","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"121","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[{"room_stay_id":"3218364","reservation_id":"110659","confirmation_number":"MH11654379134","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"284.00","nightly_discount":"0","subtotal":"284.00","grand_total":"320.92","paid_amount":"320.92","room_type_id":"185","product_id":"324","siteminder_id":"EXP-1749282354","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117168","customer_id":"117168","source_of_creation":"Expedia","reservation_created_date":"2021-03-18 21:57:10","service_canceled_date_time":"2021-03-19 15:37:09","canceled_nights_data":"","product_name":"Apartment 104","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"116","deltaChange":"320.92","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[{"room_stay_id":"3219428","reservation_id":"110751","confirmation_number":"MH11678276393","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"232.88","nightly_discount":"0","subtotal":"232.88","grand_total":"263.15","paid_amount":"263.15","room_type_id":"185","product_id":"324","siteminder_id":"HTN-155678915-RH3KE2","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117321","customer_id":"117321","source_of_creation":"HotelTonight","reservation_created_date":"2021-03-19 19:52:22","canceled_nights_data":"","product_name":"Apartment 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"116","currentDayPrice":"232.88","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"83","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"121","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3219586","reservation_id":"110772","confirmation_number":"MH11658202785","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"232.88","nightly_discount":"0","subtotal":"232.88","grand_total":"263.15","paid_amount":"263.15","room_type_id":"183","product_id":"322","siteminder_id":"HTN-155692240-J3P6DN","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117345","customer_id":"117345","source_of_creation":"HotelTonight","reservation_created_date":"2021-03-19 22:49:09","canceled_nights_data":"","product_name":"Apartment 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"116","currentDayPrice":"232.88","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"83","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"121","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3210224","reservation_id":"109582","confirmation_number":"MH11696247772","room_stay_from":"2021-03-20","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"295.00","nightly_discount":"0.00","subtotal":"295.00","grand_total":"333.35","paid_amount":"333.35","room_type_id":"187","product_id":"328","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116063","customer_id":"116063","source_of_creation":"FE","reservation_created_date":"2021-03-06 17:06:51","canceled_nights_data":"","product_name":"Apartment 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"295.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"83","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"121","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3203109","reservation_id":"108328","confirmation_number":"MH11616005313","room_stay_from":"2021-03-17","room_stay_to":"2021-03-24","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"325.00,325.00,325.00,325.00,325.00,325.00,325.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2275.00","grand_total":"2570.75","paid_amount":"2570.75","room_type_id":"199","product_id":"347","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114782","customer_id":"114782","source_of_creation":"FE","reservation_created_date":"2021-02-23 00:08:16","canceled_nights_data":"","product_name":"Apartment 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"325.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"83","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"121","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3206104","reservation_id":"108830","confirmation_number":"MH11662920740","room_stay_from":"2021-03-18","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"295.00,295.00,295.00","nightly_discount":"0.00,0.00,0.00","subtotal":"885.00","grand_total":"1000.05","paid_amount":"1000.05","room_type_id":"186","product_id":"327","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115287","customer_id":"115287","source_of_creation":"PMS","reservation_created_date":"2021-02-28 16:11:12","canceled_nights_data":"","product_name":"Apartment 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"295.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"83","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"121","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3209709","reservation_id":"109343","confirmation_number":"MH11692197301","room_stay_from":"2021-03-19","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"375.00,375.00","nightly_discount":"0.00,0.00","subtotal":"750.00","grand_total":"847.50","paid_amount":"847.50","room_type_id":"201","product_id":"349","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115808","customer_id":"115808","source_of_creation":"PMS","reservation_created_date":"2021-03-04 15:44:19","canceled_nights_data":"","product_name":"Apartment 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"375.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"83","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"121","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3215158","reservation_id":"110077","confirmation_number":"MH11635478860","room_stay_from":"2021-03-15","room_stay_to":"2021-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"260.00,260.00,260.00,260.00,260.00,260.00","nightly_discount":"26.00,26.00,26.00,26.00,26.00,26.00","subtotal":"1560.00","grand_total":"1586.52","paid_amount":"1586.52","room_type_id":"195","product_id":"340","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116594","customer_id":"116594","source_of_creation":"PMS","reservation_created_date":"2021-03-13 20:35:36","canceled_nights_data":"","product_name":"Apartment 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"260.00","currentDayDiscount":"26.00","productIsTaxExempt":false,"taxes":[{"tax_id":"83","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"121","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3208218","reservation_id":"109109","confirmation_number":"MH11696104652","room_stay_from":"2021-03-17","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"285.00,285.00,285.00,285.00,285.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1425.00","grand_total":"1610.25","paid_amount":"1610.25","room_type_id":"200","product_id":"348","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"915","customer_id":"915","source_of_creation":"PMS","reservation_created_date":"2021-03-03 11:53:53","canceled_nights_data":"","product_name":"Apartment 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"285.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"83","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"121","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3218949","reservation_id":"109425","confirmation_number":"MH11649153757","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"234.00,234.00,234.00,234.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"936.00","grand_total":"1057.68","paid_amount":"1057.68","room_type_id":"202","product_id":"350","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"135","customer_id":"135","source_of_creation":"PMS","reservation_created_date":"2021-03-04 22:14:37","canceled_nights_data":"","product_name":"Apartment 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"234.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"83","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"121","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}