{"hotel_id":"121","sub_hotel_id":0,"room_type":"hotel","date":"2020-01-17","total_rooms_exist":"839,840,841,842,843,844,845,846,847,848,849,850,851,852,853","departureCount":3,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"850,844,848,849","block_room_bookings":[{"confirmation_number":"VV12187658520","room_stay_from":"2020-01-17","room_stay_to":"2020-01-18","bundle_room":"0"},{"confirmation_number":"VV12167027542","room_stay_from":"2020-03-15","room_stay_to":"2020-04-01","bundle_room":"0"},{"confirmation_number":"VV12166635747","room_stay_from":"2020-01-17","room_stay_to":"2020-01-18","bundle_room":"0"},{"confirmation_number":"B88541936","room_stay_from":"2018-12-10","room_stay_to":"2019-04-05","bundle_room":"0"}],"bundle_block_count":"850,851,841,842,839,840,845,846","bundle_block_bookings":[{"confirmation_number":"VVB12193110736","room_stay_from":"2020-01-17","room_stay_to":"2020-01-19","bundle_room":"1"},{"confirmation_number":"VVB12164343172","room_stay_from":"2020-01-17","room_stay_to":"2020-01-18","bundle_room":"1"},{"confirmation_number":"VVB12163283877","room_stay_from":"2020-01-16","room_stay_to":"2020-01-19","bundle_room":"1"},{"confirmation_number":"VVB12139471134","room_stay_from":"2020-01-12","room_stay_to":"2020-01-30","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3052614","reservation_id":"89070","confirmation_number":"VV12136236941","room_stay_from":"2020-01-17","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.06","nightly_discount":"0","subtotal":"183.06","grand_total":"206.85","paid_amount":"206.85","room_type_id":"264","product_id":"839","siteminder_id":"BDC-3708316575","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":"95130","customer_id":"95130","source_of_creation":"Booking.com","reservation_created_date":"2020-01-01 18:26:07","canceled_nights_data":"","product_name":"French Country 7","ota_service_fee_amount":"0","commision_charges":"27.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"183.06","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":"3055332","reservation_id":"89571","confirmation_number":"VV12197772392","room_stay_from":"2020-01-17","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"133.41","nightly_discount":"0","subtotal":"133.41","grand_total":"150.75","paid_amount":"150.75","room_type_id":"267","product_id":"842","siteminder_id":"BDC-2528036848","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":"95556","customer_id":"95556","source_of_creation":"Booking.com","reservation_created_date":"2020-01-08 18:21:10","canceled_nights_data":"","product_name":"Island Delight 3A","ota_service_fee_amount":"0","commision_charges":"20.01","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"133.41","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":"3059830","reservation_id":"89151","confirmation_number":"VV12147791120","room_stay_from":"2020-01-16","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"233.10,233.10","nightly_discount":"0,0","subtotal":"466.20","grand_total":"526.80","paid_amount":"526.80","room_type_id":"272","product_id":"847","siteminder_id":"BDC-2333851652","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":"95199","customer_id":"95199","source_of_creation":"Booking.com","reservation_created_date":"2020-01-02 21:18:08","canceled_nights_data":"","product_name":"Italian 1","ota_service_fee_amount":"0","commision_charges":"69.93","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"233.10","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":"3050931","reservation_id":"88748","confirmation_number":"VV12121768388","room_stay_from":"2020-01-16","room_stay_to":"2020-01-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.40,176.40,164.70","nightly_discount":"0,0,0","subtotal":"517.50","grand_total":"584.78","paid_amount":"584.78","room_type_id":"265","product_id":"840","siteminder_id":"BDC-2841753505","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":"94904","customer_id":"94904","source_of_creation":"Booking.com","reservation_created_date":"2019-12-27 00:49:08","canceled_nights_data":"","product_name":"French Country 7A","ota_service_fee_amount":"0","commision_charges":"77.63","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"176.40","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":[],"exp_taxable":[{"room_stay_id":"3053152","reservation_id":"89154","confirmation_number":"VV12156744653","room_stay_from":"2020-01-17","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.40","nightly_discount":"0","subtotal":"176.40","grand_total":"199.33","paid_amount":"199.33","room_type_id":"271","product_id":"846","siteminder_id":"EXP-1616317689","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":"95202","customer_id":"95202","source_of_creation":"Expedia","reservation_created_date":"2020-01-02 22:02:12","canceled_nights_data":"","product_name":"The Floridian 4A","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"176.40","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":[{"room_stay_id":"3058612","reservation_id":"89782","confirmation_number":"VV12133791176","room_stay_from":"2020-01-17","room_stay_to":"2020-01-18","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"250.20","nightly_discount":"0","subtotal":"250.20","grand_total":"282.72","paid_amount":"84.82","room_type_id":"283","product_id":"864","siteminder_id":"EXP-1621307107","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":"95801","customer_id":"95801","source_of_creation":"Expedia","reservation_created_date":"2020-01-11 22:18:09","service_canceled_date_time":"2020-01-16 23:18:08","canceled_nights_data":"","product_name":"VV WALK","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"84.82","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":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3051999","reservation_id":"88955","confirmation_number":"VV12184825651","room_stay_from":"2020-01-15","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.00,203.00,203.00","nightly_discount":"0.00,0.00,0.00","subtotal":"609.00","grand_total":"688.17","paid_amount":"688.17","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":"95038","customer_id":"95038","source_of_creation":"FE","reservation_created_date":"2019-12-30 11:32:28","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":"203.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":"3002401","reservation_id":"81310","confirmation_number":"VV12113310238","room_stay_from":"2020-01-11","room_stay_to":"2020-01-19","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1568.00","grand_total":"1771.84","paid_amount":"1771.84","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":"89315","customer_id":"89315","source_of_creation":"FE","reservation_created_date":"2019-07-24 01:10:59","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":"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":"3046110","reservation_id":"88169","confirmation_number":"VV12150518512","room_stay_from":"2020-01-17","room_stay_to":"2020-01-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.00,189.00,189.00","nightly_discount":"0.00,0.00,0.00","subtotal":"567.00","grand_total":"640.71","paid_amount":"640.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":"94492","customer_id":"94492","source_of_creation":"FE","reservation_created_date":"2019-12-11 18:35:37","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":"189.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":"3024899","reservation_id":"85047","confirmation_number":"VV12111039848","room_stay_from":"2020-01-17","room_stay_to":"2020-01-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"162.90,162.90","nightly_discount":"0.00,0.00","subtotal":"325.80","grand_total":"368.16","paid_amount":"368.16","room_type_id":"276","product_id":"851","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":"12978","customer_id":"12978","source_of_creation":"PMS","reservation_created_date":"2019-10-03 14:13:26","canceled_nights_data":"","product_name":"Miami Classic 8A","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"162.90","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"}]}],"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":[]}}