{"hotel_id":"116","sub_hotel_id":0,"room_type":"hotel","date":"2019-05-05","total_rooms_exist":13,"departureCount":2,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"2","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2973135","reservation_id":"75808","confirmation_number":"MH11641016841","room_stay_from":"2019-05-04","room_stay_to":"2019-05-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"290.00,260.00","nightly_discount":"0,0","subtotal":"550.00","grand_total":"621.50","paid_amount":"621.50","room_type_id":"201","product_id":"349","siteminder_id":"BDC-3977076034","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":"85599","customer_id":"85599","source_of_creation":"Booking.com","reservation_created_date":"2019-05-04 17:53:09","canceled_nights_data":"","product_name":"Apartment 208","ota_service_fee_amount":"0","commision_charges":"82.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2913046","reservation_id":"65930","confirmation_number":"MH11661938243","room_stay_from":"2019-05-03","room_stay_to":"2019-05-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,126.00,111.00","nightly_discount":"0,0,0","subtotal":"363.00","grand_total":"410.19","paid_amount":"410.19","room_type_id":"184","product_id":"323","siteminder_id":"EXP-1175613518","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":"79647","customer_id":"79647","source_of_creation":"Expedia","reservation_created_date":"2019-01-08 10:30:10","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":"","currentDayPrice":"111.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":"2915043","reservation_id":"66317","confirmation_number":"MH11622118243","room_stay_from":"2019-05-02","room_stay_to":"2019-05-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,144.00,144.00,126.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"540.00","grand_total":"610.20","paid_amount":"610.20","room_type_id":"185","product_id":"324","siteminder_id":"EXP-1177378928","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":"80005","customer_id":"80005","source_of_creation":"Expedia","reservation_created_date":"2019-01-11 08:12:32","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":"","currentDayPrice":"126.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":"2930862","reservation_id":"68575","confirmation_number":"MH11659087831","room_stay_from":"2019-05-04","room_stay_to":"2019-05-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"144.00,126.00,126.00","nightly_discount":"0,0,0","subtotal":"396.00","grand_total":"447.48","paid_amount":"447.48","room_type_id":"183","product_id":"322","siteminder_id":"EXP-1191524656","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":"81411","customer_id":"81411","source_of_creation":"Expedia","reservation_created_date":"2019-02-03 23:19:10","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":"","currentDayPrice":"126.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":"2930874","reservation_id":"68580","confirmation_number":"MH11692248805","room_stay_from":"2019-05-04","room_stay_to":"2019-05-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"207.00,184.00,184.00,184.00,184.00","nightly_discount":"0,0,0,0,0","subtotal":"943.00","grand_total":"1065.59","paid_amount":"1065.59","room_type_id":"187","product_id":"328","siteminder_id":"EXP-1191545076","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":"81412","customer_id":"81412","source_of_creation":"Expedia","reservation_created_date":"2019-02-04 00:19:10","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":"","currentDayPrice":"184.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":[],"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":[{"room_stay_id":"2974297","reservation_id":"65750","confirmation_number":"MH11631548857","room_stay_from":"2019-05-05","room_stay_to":"2019-05-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"101.30,110.00,110.00","nightly_discount":"0.00,0.00,0.00","subtotal":"321.30","grand_total":"363.07","paid_amount":"363.07","room_type_id":"202","product_id":"350","siteminder_id":"AGO-226978091","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79568","customer_id":"79568","source_of_creation":"Agoda","reservation_created_date":"2019-01-06 17:45:08","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":"","currentDayPrice":"101.30","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"}]}],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2973194","reservation_id":"75819","confirmation_number":"MH11663740592","room_stay_from":"2019-04-30","room_stay_to":"2019-05-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"190.00,190.00,190.00,190.00,190.00,190.00,190.00,190.00","nightly_discount":"190.00,190.00,190.00,190.00,190.00,190.00,190.00,190.00","subtotal":"1520.00","grand_total":"0.00","paid_amount":"0.00","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":"85605","customer_id":"85605","source_of_creation":"PMS","reservation_created_date":"2019-05-04 22:34:54","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":"","currentDayPrice":"190.00","currentDayDiscount":"190.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":[]}}