{"hotel_id":"116","sub_hotel_id":0,"room_type":"hotel","date":"2019-05-04","total_rooms_exist":13,"departureCount":3,"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":"2921168","reservation_id":"67532","confirmation_number":"MH11665847505","room_stay_from":"2019-04-29","room_stay_to":"2019-05-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,126.00,126.00,126.00,144.00,144.00","nightly_discount":"0,0,0,0,0,0","subtotal":"792.00","grand_total":"894.96","paid_amount":"894.96","room_type_id":"195","product_id":"340","siteminder_id":"BDC-1072003250","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":"80733","customer_id":"80733","source_of_creation":"Booking.com","reservation_created_date":"2019-01-22 12:17:09","canceled_nights_data":"","product_name":"Apartment 201","ota_service_fee_amount":"0","commision_charges":"118.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.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":"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":"290.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":[{"room_stay_id":"2911211","reservation_id":"65570","confirmation_number":"MH11630212510","room_stay_from":"2019-04-19","room_stay_to":"2019-04-21","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,126.00","nightly_discount":"0,0","subtotal":"252.00","grand_total":"284.76","paid_amount":"142.38","room_type_id":"184","product_id":"323","siteminder_id":"BDC-1358869837","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":"79483","customer_id":"79483","source_of_creation":"Booking.com","reservation_created_date":"2019-01-05 01:24:13","service_canceled_date_time":"2019-05-04 23:18:06","canceled_nights_data":"","product_name":"Apartment 103","ota_service_fee_amount":"0","commision_charges":"37.80","deltaChange":"-142.38","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"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":"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":"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":"144.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":"144.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":"207.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":"2973161","reservation_id":"65785","confirmation_number":"MH11653454464","room_stay_from":"2019-05-04","room_stay_to":"2019-05-05","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"180.00","nightly_discount":"0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","room_type_id":"198","product_id":"346","siteminder_id":"AGO-240531398","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79580","customer_id":"79580","source_of_creation":"Agoda","reservation_created_date":"2019-01-06 22:03: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":"","currentDayPrice":"180.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"}]}],"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":[{"room_stay_id":"2968206","reservation_id":"65785","confirmation_number":"MH11630651222","room_confirmation_number":"MH11653454464","room_stay_from":"2019-05-04","room_stay_to":"2019-05-05","room_stay_status":"Active","nightly_price":"40","nightly_discount":"0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"374","service_quantity":"1","customer_traveller_id":"79580","product_attribute_values":"extra_person#&#20","reservation_created_date":"2019-04-21 18:15:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79580","canceled_nights_data":"","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":[]}}