{"hotel_id":"116","sub_hotel_id":0,"room_type":"hotel","date":"2021-05-29","total_rooms_exist":"322,323,324,327,328,340,346,347,348,349,350,1883,1884,1885,1886","departureCount":6,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"324","block_room_bookings":[{"confirmation_number":"MH11618490681","room_stay_from":"2021-05-29","room_stay_to":"2021-06-03","bundle_room":"0","product_id":"324"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3253030","reservation_id":"115390","confirmation_number":"MH11620436388","room_stay_from":"2021-05-27","room_stay_to":"2021-05-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.00,230.00,230.00,230.00","nightly_discount":"0,0,0,0","subtotal":"920.00","grand_total":"1039.60","paid_amount":"1039.60","room_type_id":"202","product_id":"350","siteminder_id":"BDC-2237070411","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":"122817","customer_id":"122817","source_of_creation":"Booking.com","reservation_created_date":"2021-05-17 15:40:11","canceled_nights_data":"","product_name":"Apartment 204","ota_service_fee_amount":"0","commision_charges":"138.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"116","group_rooms":null,"currentDayPrice":"230.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"}]},{"room_stay_id":"3257631","reservation_id":"115975","confirmation_number":"MH11649402902","room_stay_from":"2021-05-29","room_stay_to":"2021-05-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.00,230.00","nightly_discount":"0,0","subtotal":"460.00","grand_total":"519.80","paid_amount":"519.80","room_type_id":"183","product_id":"322","siteminder_id":"BDC-3278863475","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":"123006","customer_id":"123006","source_of_creation":"Booking.com","reservation_created_date":"2021-05-27 06:58:11","canceled_nights_data":"","product_name":"Apartment 101","ota_service_fee_amount":"0","commision_charges":"69.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"116","group_rooms":null,"currentDayPrice":"230.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":"3252018","reservation_id":"115246","confirmation_number":"MH11623738984","room_stay_from":"2021-05-29","room_stay_to":"2021-05-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"350.00,350.00","nightly_discount":"0,0","subtotal":"700.00","grand_total":"791.00","paid_amount":"791.00","room_type_id":"186","product_id":"327","siteminder_id":"EXP-1771218118","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":"123003","customer_id":"123003","source_of_creation":"Expedia","reservation_created_date":"2021-05-15 01:30:11","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":null,"sub_hotel_id":"116","group_rooms":null,"currentDayPrice":"350.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"}]},{"room_stay_id":"3258986","reservation_id":"115082","confirmation_number":"MH11696750727","room_stay_from":"2021-05-29","room_stay_to":"2021-05-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"250.00","nightly_discount":"0","subtotal":"250.00","grand_total":"282.50","paid_amount":"282.50","room_type_id":"200","product_id":"348","siteminder_id":"EXP-1770184666","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":"122990","customer_id":"122990","source_of_creation":"Expedia","reservation_created_date":"2021-05-12 17:50:12","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":null,"sub_hotel_id":"116","currentDayPrice":"250.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"}]},{"room_stay_id":"3258988","reservation_id":"115077","confirmation_number":"MH11615932331","room_stay_from":"2021-05-29","room_stay_to":"2021-05-30","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"350.00","nightly_discount":"0.00","subtotal":"350.00","grand_total":"395.50","paid_amount":"395.50","room_type_id":"199","product_id":"347","siteminder_id":"EXP-1770144553","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":"122991","customer_id":"122991","source_of_creation":"Expedia","reservation_created_date":"2021-05-12 16:05:21","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":null,"sub_hotel_id":"116","currentDayPrice":"350.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"}]}],"exp_non_taxable":[{"room_stay_id":"3251121","reservation_id":"115112","confirmation_number":"MH11641862962","room_stay_from":"2021-05-29","room_stay_to":"2021-05-31","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"190.00,190.00","nightly_discount":"0,0","subtotal":"380.00","grand_total":"429.40","paid_amount":"214.70","room_type_id":"184","product_id":"323","siteminder_id":"EXP-1770421863","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":"121821","customer_id":"121821","source_of_creation":"Expedia","reservation_created_date":"2021-05-13 03:50:11","service_canceled_date_time":"2021-05-25 00:55:06","canceled_nights_data":"","product_name":"Apartment 103","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"116","deltaChange":"214.70","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3253846","reservation_id":"115495","confirmation_number":"MH11644170652","room_stay_from":"2021-05-29","room_stay_to":"2021-05-30","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.00","nightly_discount":"0","subtotal":"230.00","grand_total":"259.90","paid_amount":"259.90","room_type_id":"183","product_id":"322","siteminder_id":"EXP-1772945987","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":"122235","customer_id":"122235","source_of_creation":"Expedia","reservation_created_date":"2021-05-19 05:55:11","service_canceled_date_time":"2021-05-27 04:25:05","canceled_nights_data":"","product_name":"Apartment 101","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"116","deltaChange":"259.90","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[{"room_stay_id":"3258862","reservation_id":"115486","confirmation_number":"MH11637578242","room_stay_from":"2021-05-29","room_stay_to":"2021-05-30","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"223.10","nightly_discount":"0","subtotal":"223.10","grand_total":"291.09","paid_amount":"191.09","room_type_id":"184","product_id":"323","siteminder_id":"ABB-HMQFTHCCDY","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"223.10","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122226","customer_id":"122226","source_of_creation":"Airbnb","reservation_created_date":"2021-05-19 01:57:05","service_canceled_date_time":"2021-05-29 20:51:32","canceled_nights_data":"","product_name":"Apartment 103","ota_service_fee_amount":"31.19","commision_charges":"6.90","sub_hotel_id":"116","deltaChange":"191.09","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3226222","reservation_id":"111855","confirmation_number":"MH11636263616","room_stay_from":"2021-05-29","room_stay_to":"2021-05-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.00","nightly_discount":"0.00","subtotal":"300.00","grand_total":"339.00","paid_amount":"339.00","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":"118417","customer_id":"118417","source_of_creation":"FE","reservation_created_date":"2021-04-02 00:06:21","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":"300.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":"3238253","reservation_id":"113509","confirmation_number":"MH11614286568","room_stay_from":"2021-05-28","room_stay_to":"2021-05-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.00,195.00,195.00","nightly_discount":"0.00,0.00,0.00","subtotal":"585.00","grand_total":"661.05","paid_amount":"661.05","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":"120105","customer_id":"120105","source_of_creation":"FE","reservation_created_date":"2021-04-21 00:53:12","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":"195.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":"3205659","reservation_id":"106731","confirmation_number":"MH11638316801","room_stay_from":"2021-05-21","room_stay_to":"2021-06-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"250.00,250.00,250.00,250.00,250.00,250.00,250.00,250.00,250.00,250.00,250.00,250.00,250.00,250.00,250.00,250.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0","subtotal":"4000.00","grand_total":"4520.00","paid_amount":"4520.00","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":"113143","customer_id":"113143","source_of_creation":"PMS","reservation_created_date":"2021-02-02 16:02:21","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":"250.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":"3254733","reservation_id":"115561","confirmation_number":"MH11666549483","room_stay_from":"2021-05-27","room_stay_to":"2021-05-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.00,195.00,195.00,195.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"780.00","grand_total":"881.40","paid_amount":"881.40","room_type_id":"198","product_id":"346","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":"122313","customer_id":"122313","source_of_creation":"PMS","reservation_created_date":"2021-05-20 18:46:29","canceled_nights_data":"","product_name":"Apartment 203","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":"195.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":"3259134","reservation_id":"116161","confirmation_number":"MH11638368619","room_stay_from":"2021-05-29","room_stay_to":"2021-05-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00","nightly_discount":"0.00","subtotal":"225.00","grand_total":"254.25","paid_amount":"254.25","room_type_id":"184","product_id":"323","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":"123004","customer_id":"123004","source_of_creation":"PMS","reservation_created_date":"2021-05-29 21:03:49","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":"","sub_hotel_id":"0","currentDayPrice":"225.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":[{"room_stay_id":"3258987","reservation_id":"115077","confirmation_number":"MH11625935429","room_confirmation_number":"MH11615932331","room_stay_from":"2021-05-29","room_stay_to":"2021-05-30","room_stay_status":"Active","nightly_price":"40","nightly_discount":"0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"374","service_quantity":"1","customer_traveller_id":"122991","product_attribute_values":"extra_person#&#20.00","reservation_created_date":"2021-05-28 14:29:31","reservation_modified_date_time":"2021-05-29 18:32:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122991","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"116","currentDayPrice":"40","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"}]}],"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":[]}}