{"hotel_id":"121","sub_hotel_id":0,"room_type":"hotel","date":"2020-01-30","total_rooms_exist":"839,840,841,842,843,844,845,846,847,848,849,850,851,852,853","departureCount":1,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"844,849","block_room_bookings":[{"confirmation_number":"VV12167027542","room_stay_from":"2020-03-15","room_stay_to":"2020-04-01","bundle_room":"0"},{"confirmation_number":"B88541936","room_stay_from":"2018-12-10","room_stay_to":"2019-04-05","bundle_room":"0"}],"bundle_block_count":"841,842,839,840,850,851,845,846","bundle_block_bookings":[{"confirmation_number":"VVB12180819945","room_stay_from":"2020-01-29","room_stay_to":"2020-02-02","bundle_room":"1"},{"confirmation_number":"VVB12154540894","room_stay_from":"2020-01-29","room_stay_to":"2020-02-02","bundle_room":"1"},{"confirmation_number":"VVB12151810427","room_stay_from":"2020-01-28","room_stay_to":"2020-01-31","bundle_room":"1"},{"confirmation_number":"VVB12120468263","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3043567","reservation_id":"87771","confirmation_number":"VV12193492769","room_stay_from":"2020-01-28","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"148.23,158.76,158.76","nightly_discount":"0,0,0","subtotal":"465.75","grand_total":"526.30","paid_amount":"526.30","room_type_id":"276","product_id":"851","siteminder_id":"BDC-2687629395","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":"94214","customer_id":"94214","source_of_creation":"Booking.com","reservation_created_date":"2019-12-02 17:21:10","canceled_nights_data":"","product_name":"Miami Classic 8A","ota_service_fee_amount":"0","commision_charges":"69.86","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"158.76","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016922","reservation_id":"83714","confirmation_number":"VV12187605471","room_stay_from":"2020-01-28","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.00,183.00,183.00,190.00","nightly_discount":"0,0,0,0","subtotal":"739.00","grand_total":"835.07","paid_amount":"835.07","room_type_id":"271","product_id":"846","siteminder_id":"BDC-3207050810","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":"91087","customer_id":"96886","source_of_creation":"Booking.com","reservation_created_date":"2019-09-06 21:04:09","canceled_nights_data":"","product_name":"The Floridian 4A","ota_service_fee_amount":"0","commision_charges":"110.85","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"183.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2955707","reservation_id":"73025","confirmation_number":"VV12136792503","room_stay_from":"2020-01-30","room_stay_to":"2020-02-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"278.00,290.00,290.00","nightly_discount":"0,0,0","subtotal":"858.00","grand_total":"969.54","paid_amount":"969.54","room_type_id":"273","product_id":"848","siteminder_id":"BDC-3901685632","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":"83967","customer_id":"83967","source_of_creation":"Booking.com","reservation_created_date":"2019-03-24 09:05:10","canceled_nights_data":"","product_name":"Key West 2","ota_service_fee_amount":"0","commision_charges":"128.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"278.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022286","reservation_id":"84641","confirmation_number":"VV12179695509","room_stay_from":"2020-01-30","room_stay_to":"2020-02-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.79,220.50,220.50","nightly_discount":"0,0,0","subtotal":"650.79","grand_total":"735.40","paid_amount":"735.40","room_type_id":"272","product_id":"847","siteminder_id":"BDC-2978578087","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":"91976","customer_id":"97065","source_of_creation":"Booking.com","reservation_created_date":"2019-09-24 12:40:10","canceled_nights_data":"","product_name":"Italian 1","ota_service_fee_amount":"0","commision_charges":"97.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"209.79","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[{"room_stay_id":"2950979","reservation_id":"72138","confirmation_number":"VV12191509161","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.10,195.30","nightly_discount":"0,0","subtotal":"383.40","grand_total":"433.24","paid_amount":"129.97","room_type_id":"271","product_id":"846","siteminder_id":"BDC-1708245185","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":"83367","customer_id":"83367","source_of_creation":"Booking.com","reservation_created_date":"2019-03-16 13:59:07","service_canceled_date_time":"2019-09-03 16:39:07","canceled_nights_data":"","product_name":"The Floridian 4A","ota_service_fee_amount":"0","commision_charges":"57.51","deltaChange":"129.97","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3062144","reservation_id":"86832","confirmation_number":"VV12195898188","room_stay_from":"2020-01-28","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.70,164.70,164.70","nightly_discount":"0,0,0","subtotal":"494.10","grand_total":"558.34","paid_amount":"558.34","room_type_id":"275","product_id":"850","siteminder_id":"EXP-1376572833","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":"93472","customer_id":"96868","source_of_creation":"Expedia","reservation_created_date":"2019-11-08 05:06:08","canceled_nights_data":"","product_name":"Miami Classic 8","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"164.70","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2988817","reservation_id":"78789","confirmation_number":"VV12116881443","room_stay_from":"2020-01-30","room_stay_to":"2020-02-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.00,190.00,190.00","nightly_discount":"0,0,0","subtotal":"563.00","grand_total":"636.19","paid_amount":"636.19","room_type_id":"267","product_id":"842","siteminder_id":"EXP-1279191612","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":"95885","customer_id":"95885","source_of_creation":"Expedia","reservation_created_date":"2019-06-16 14:40:07","canceled_nights_data":"","product_name":"Island Delight 3A","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"183.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"124","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":"2952516","reservation_id":"72215","confirmation_number":"VV12193595249","room_stay_from":"2020-01-29","room_stay_to":"2020-02-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00,219.00,219.00,219.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"867.00","grand_total":"979.71","paid_amount":"979.71","room_type_id":"264","product_id":"839","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":"83411","customer_id":"83411","source_of_creation":"FE","reservation_created_date":"2019-03-16 22:44:28","canceled_nights_data":"","product_name":"French Country 7","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"219.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"},{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"2952518","reservation_id":"72217","confirmation_number":"VV12115580944","room_stay_from":"2020-01-29","room_stay_to":"2020-02-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00,219.00,219.00,219.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"867.00","grand_total":"979.71","paid_amount":"979.71","room_type_id":"266","product_id":"841","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":"83411","customer_id":"83411","source_of_creation":"FE","reservation_created_date":"2019-03-16 22:52:47","canceled_nights_data":"","product_name":"Island Delight 3","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"219.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"},{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3048909","reservation_id":"88491","confirmation_number":"VV12116310212","room_stay_from":"2020-01-26","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.00,200.00,200.00,200.00,200.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1000.00","grand_total":"1130.00","paid_amount":"1130.00","room_type_id":"278","product_id":"853","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":"13129","customer_id":"13129","source_of_creation":"PMS","reservation_created_date":"2019-12-20 17:02:25","canceled_nights_data":"","product_name":"South Beach R1","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"200.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"},{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3009142","reservation_id":"75810","confirmation_number":"VV12165013184","room_stay_from":"2020-01-12","room_stay_to":"2020-02-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.00,196.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.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"4704.00","grand_total":"5315.52","paid_amount":"5315.52","room_type_id":"270","product_id":"845","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":"75424","customer_id":"75424","source_of_creation":"PMS","reservation_created_date":"2019-05-04 18:12:09","canceled_nights_data":"","product_name":"The Floridian 4","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"196.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"},{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3077096","reservation_id":"84197","confirmation_number":"VV12128800078","room_stay_from":"2020-01-28","room_stay_to":"2020-03-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.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.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"5004.00","grand_total":"5654.52","paid_amount":"6911.08","room_type_id":"268","product_id":"843","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":"12489","customer_id":"12489","source_of_creation":"PMS","reservation_created_date":"2019-09-16 14:57:54","canceled_nights_data":"","product_name":"Belize R5","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00"},{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.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":[]}}