{"hotel_id":"116","sub_hotel_id":0,"room_type":"hotel","date":"2019-05-02","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":"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":"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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"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":"2970651","reservation_id":"75453","confirmation_number":"MH11614178991","room_stay_from":"2019-05-02","room_stay_to":"2019-05-03","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"124.30","nightly_discount":"0","subtotal":"124.30","grand_total":"140.46","paid_amount":"140.46","room_type_id":"184","product_id":"323","siteminder_id":"EXP-1246093863","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":"85397","customer_id":"85397","source_of_creation":"Expedia","reservation_created_date":"2019-04-27 21:45: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":"124.30","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":"2920959","reservation_id":"67482","confirmation_number":"MH11663321449","room_stay_from":"2019-05-02","room_stay_to":"2019-05-05","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,144.00,144.00","nightly_discount":"0,0,0","subtotal":"414.00","grand_total":"467.82","paid_amount":"142.38","room_type_id":"202","product_id":"350","siteminder_id":"EXP-1183763649","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":"80688","customer_id":"80688","source_of_creation":"Expedia","reservation_created_date":"2019-01-21 19:31:10","service_canceled_date_time":"2019-04-16 08:21:08","canceled_nights_data":"","product_name":"Apartment 204","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"142.38","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":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"2972047","reservation_id":"70872","confirmation_number":"MH11693902073","room_stay_from":"2019-05-01","room_stay_to":"2019-05-04","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"158.00,159.88,160.00","nightly_discount":"0.00,0.00,0.00","subtotal":"477.88","grand_total":"540.00","paid_amount":"540.00","room_type_id":"183","product_id":"322","siteminder_id":"AGO-248451510","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82637","customer_id":"82637","source_of_creation":"Agoda","reservation_created_date":"2019-03-03 21:57:06","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":"159.88","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":"2972722","reservation_id":"73919","confirmation_number":"MH11648597788","room_stay_from":"2019-05-02","room_stay_to":"2019-05-04","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"279.01,180.00","nightly_discount":"0.00,0.00","subtotal":"459.01","grand_total":"518.68","paid_amount":"518.68","room_type_id":"198","product_id":"346","siteminder_id":"AGO-232165555","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":"84534","customer_id":"84534","source_of_creation":"Agoda","reservation_created_date":"2019-04-03 07:50:54","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":"279.01","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":[{"room_stay_id":"2972479","reservation_id":"67541","confirmation_number":"MH11624279442","room_stay_from":"2019-04-30","room_stay_to":"2019-05-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00,150.00,160.00","nightly_discount":"0.00,0.00,0.00","subtotal":"460.00","grand_total":"519.80","paid_amount":"519.80","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":"147","customer_id":"147","source_of_creation":"FE","reservation_created_date":"2019-01-22 14:30:31","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":"160.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":"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":"2972048","reservation_id":"70872","confirmation_number":"MH11655836447","room_confirmation_number":"MH11693902073","room_stay_from":"2019-05-01","room_stay_to":"2019-05-04","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"374","service_quantity":"1","customer_traveller_id":"82637","product_attribute_values":"extra_person#&#20.00","reservation_created_date":"2019-05-01 14:59:49","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82637","canceled_nights_data":"","currentDayPrice":"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":"2972723","reservation_id":"73919","confirmation_number":"MH11633044233","room_confirmation_number":"MH11648597788","room_stay_from":"2019-05-02","room_stay_to":"2019-05-04","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"374","service_quantity":"1","customer_traveller_id":"84534","product_attribute_values":"extra_person#&#20.00","reservation_created_date":"2019-05-03 14:44:25","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84534","canceled_nights_data":"","currentDayPrice":"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"}]}],"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":[]}}