{"hotel_id":"116","sub_hotel_id":0,"room_type":"hotel","date":"2021-04-10","total_rooms_exist":"322,323,324,327,328,340,346,347,348,349,350,1883,1884,1885,1886","departureCount":4,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"324,347","block_room_bookings":[{"confirmation_number":"MH11626737722","room_stay_from":"2021-04-10","room_stay_to":"2021-04-11","bundle_room":"0","product_id":"324"},{"confirmation_number":"MH11638142730","room_stay_from":"2021-04-10","room_stay_to":"2021-04-11","bundle_room":"0","product_id":"347"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3230426","reservation_id":"112419","confirmation_number":"MH11631493928","room_stay_from":"2021-04-09","room_stay_to":"2021-04-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"284.00,284.00","nightly_discount":"0,0","subtotal":"568.00","grand_total":"641.84","paid_amount":"641.84","room_type_id":"183","product_id":"322","siteminder_id":"BDC-2291631956","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":"119120","customer_id":"119120","source_of_creation":"Booking.com","reservation_created_date":"2021-04-08 03:45:12","canceled_nights_data":"","product_name":"Apartment 101","ota_service_fee_amount":"0","commision_charges":"85.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"116","group_rooms":null,"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"}]},{"room_stay_id":"3231116","reservation_id":"112501","confirmation_number":"MH11616044994","room_stay_from":"2021-04-09","room_stay_to":"2021-04-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"284.00,284.00,284.00","nightly_discount":"0,0,0","subtotal":"852.00","grand_total":"962.76","paid_amount":"962.76","room_type_id":"202","product_id":"350","siteminder_id":"BDC-3158197718","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":"119130","customer_id":"119130","source_of_creation":"Booking.com","reservation_created_date":"2021-04-09 05:38:11","canceled_nights_data":"","product_name":"Apartment 204","ota_service_fee_amount":"0","commision_charges":"127.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"116","group_rooms":null,"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":"3229396","reservation_id":"112119","confirmation_number":"MH11634271323","room_stay_from":"2021-04-06","room_stay_to":"2021-04-11","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"335.00,335.00,335.00,335.00,335.00","nightly_discount":"0,0,0,0,0","subtotal":"1675.00","grand_total":"1892.75","paid_amount":"1892.75","room_type_id":"186","product_id":"327","siteminder_id":"EXP-1755809444","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":"118840","customer_id":"118884","source_of_creation":"Expedia","reservation_created_date":"2021-04-04 22:32:10","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":"335.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":"3232059","reservation_id":"112608","confirmation_number":"MH11692152598","room_stay_from":"2021-04-10","room_stay_to":"2021-04-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"307.40","nightly_discount":"0","subtotal":"307.40","grand_total":"347.36","paid_amount":"347.36","room_type_id":"187","product_id":"328","siteminder_id":"EXP-1758032139","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":"119204","customer_id":"119204","source_of_creation":"Expedia","reservation_created_date":"2021-04-10 16:19:08","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":null,"sub_hotel_id":"116","currentDayPrice":"307.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"}]},{"room_stay_id":"3232102","reservation_id":"112316","confirmation_number":"MH11676571275","room_stay_from":"2021-04-10","room_stay_to":"2021-04-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.20","nightly_discount":"0","subtotal":"255.20","grand_total":"288.37","paid_amount":"288.37","room_type_id":"184","product_id":"323","siteminder_id":"EXP-1756771717","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":"119208","customer_id":"119208","source_of_creation":"Expedia","reservation_created_date":"2021-04-07 11:52:11","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":"255.20","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":"3226971","reservation_id":"111393","confirmation_number":"MH11620013902","room_stay_from":"2021-04-03","room_stay_to":"2021-04-12","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"284.00,284.00,284.00,284.00,284.00,284.00,284.00,284.00,284.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2556.00","grand_total":"2888.28","paid_amount":"2888.28","room_type_id":"198","product_id":"346","siteminder_id":"EXP-1752535226","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"180.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118543","customer_id":"118543","source_of_creation":"Expedia","reservation_created_date":"2021-03-27 00:17:10","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":null,"sub_hotel_id":"116","group_rooms":null,"currentDayPrice":"284.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":[],"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":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3229260","reservation_id":"112289","confirmation_number":"MH11610379707","room_stay_from":"2021-04-08","room_stay_to":"2021-04-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"265.00,265.00,265.00","nightly_discount":"0.00,0.00,0.00","subtotal":"795.00","grand_total":"898.35","paid_amount":"898.35","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":"118856","customer_id":"118856","source_of_creation":"FE","reservation_created_date":"2021-04-07 00:03:00","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":"265.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":"3232152","reservation_id":"112616","confirmation_number":"MH11617758378","room_stay_from":"2021-04-10","room_stay_to":"2021-04-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00","nightly_discount":"22.50","subtotal":"225.00","grand_total":"228.83","paid_amount":"228.83","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":"119197","customer_id":"119197","source_of_creation":"FE","reservation_created_date":"2021-04-10 17:57:50","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","currentDayPrice":"225.00","currentDayDiscount":"22.50","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":"3231720","reservation_id":"110882","confirmation_number":"MH11639748549","room_stay_from":"2021-04-10","room_stay_to":"2021-04-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"300.00,300.00,300.00,300.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1200.00","grand_total":"1356.00","paid_amount":"1356.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":"117420","customer_id":"117420","source_of_creation":"PMS","reservation_created_date":"2021-03-21 15:02:01","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","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":"3231716","reservation_id":"111488","confirmation_number":"MH11687238366","room_stay_from":"2021-04-03","room_stay_to":"2021-04-10","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.00,175.00,175.00,175.00,175.00,175.00,175.00","nightly_discount":"0.00,0.00,0.00,0,0,0,0","subtotal":"1225.00","grand_total":"1384.25","paid_amount":"1384.25","room_type_id":"185","product_id":"324","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":"118053","customer_id":"118053","source_of_creation":"PMS","reservation_created_date":"2021-03-28 02:31:20","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":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3226970","reservation_id":"111393","confirmation_number":"MH11658656880","room_confirmation_number":"MH11620013902","room_stay_from":"2021-04-03","room_stay_to":"2021-04-12","room_stay_status":"Active","nightly_price":"40,40,40,40,40,40,40,40,40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"360.00","grand_total":"406.80","paid_amount":"406.80","product_id":"374","service_quantity":"1","customer_traveller_id":"118543","product_attribute_values":"extra_person#&#20","reservation_created_date":"2021-04-03 14:13:51","reservation_modified_date_time":"2021-04-03 14:22:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118543","canceled_nights_data":"","posAmt_airbnb_taxpaid":"180.00","sub_hotel_id":"116","currentDayPrice":"40","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"}]}],"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":[]}}