{"hotel_id":"121","sub_hotel_id":0,"room_type":"hotel","date":"2020-01-12","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":"848,844,849","block_room_bookings":[{"confirmation_number":"VV12169722908","room_stay_from":"2020-01-12","room_stay_to":"2020-01-13","bundle_room":"0"},{"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":"850,851,842,841,845,846,839,840","bundle_block_bookings":[{"confirmation_number":"VVB12194599518","room_stay_from":"2020-01-07","room_stay_to":"2020-01-17","bundle_room":"1"},{"confirmation_number":"VVB12177317996","room_stay_from":"2020-01-11","room_stay_to":"2020-01-16","bundle_room":"0"},{"confirmation_number":"VVB12173337304","room_stay_from":"2020-01-11","room_stay_to":"2020-01-16","bundle_room":"0"},{"confirmation_number":"VVB12139471134","room_stay_from":"2020-01-12","room_stay_to":"2020-01-30","bundle_room":"1"},{"confirmation_number":"VVB12137930772","room_stay_from":"2020-01-09","room_stay_to":"2020-01-14","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3041539","reservation_id":"87517","confirmation_number":"VV12176389609","room_stay_from":"2020-01-09","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"158.76,158.76,158.76,158.76,158.76","nightly_discount":"0,0,0,0,0","subtotal":"793.80","grand_total":"897.00","paid_amount":"897.00","room_type_id":"265","product_id":"840","siteminder_id":"BDC-3181894805","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":"94034","customer_id":"94034","source_of_creation":"Booking.com","reservation_created_date":"2019-11-25 19:57:07","canceled_nights_data":"","product_name":"French Country 7A","ota_service_fee_amount":"0","commision_charges":"119.07","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":"3052573","reservation_id":"89062","confirmation_number":"VV12172176110","room_stay_from":"2020-01-11","room_stay_to":"2020-01-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"233.10,233.10,233.10","nightly_discount":"0,0,0","subtotal":"699.30","grand_total":"790.21","paid_amount":"790.21","room_type_id":"272","product_id":"847","siteminder_id":"BDC-3995038420","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":"95123","customer_id":"95123","source_of_creation":"Booking.com","reservation_created_date":"2020-01-01 16:53:07","canceled_nights_data":"","product_name":"Italian 1","ota_service_fee_amount":"0","commision_charges":"104.90","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":"3015972","reservation_id":"83548","confirmation_number":"VV12148203109","room_stay_from":"2020-01-07","room_stay_to":"2020-01-15","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"218,218,218,218,218,218,218,218","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1744.00","grand_total":"1970.72","paid_amount":"1970.72","room_type_id":"268","product_id":"843","siteminder_id":"BDC-3820074326","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"160.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90844","customer_id":"90844","source_of_creation":"Booking.com","reservation_created_date":"2019-09-02 16:09:08","canceled_nights_data":"","product_name":"Belize R5","ota_service_fee_amount":"0","commision_charges":"285.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"218","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":"3056167","reservation_id":"84071","confirmation_number":"VV12136788778","room_stay_from":"2020-01-12","room_stay_to":"2020-01-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.70,164.70,164.70,164.70,164.70","nightly_discount":"0,0,0,0,0","subtotal":"823.50","grand_total":"930.56","paid_amount":"930.56","room_type_id":"264","product_id":"839","siteminder_id":"EXP-1342250399","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":"91597","customer_id":"91597","source_of_creation":"Expedia","reservation_created_date":"2019-09-14 09:52:11","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":"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"}]}],"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":"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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3043613","reservation_id":"87782","confirmation_number":"VV12149162376","room_stay_from":"2020-01-09","room_stay_to":"2020-01-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"350.00,350.00,350.00,350.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1400.00","grand_total":"1582.00","paid_amount":"1582.00","room_type_id":"277","product_id":"852","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":"81604","customer_id":"81604","source_of_creation":"PMS","reservation_created_date":"2019-12-02 19:55:59","canceled_nights_data":"","product_name":"Santa Fe Suite 5","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"350.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":"3048906","reservation_id":"83289","confirmation_number":"VV12190984571","room_stay_from":"2020-01-11","room_stay_to":"2020-01-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"270.00,270.00,270.00,270.00,270.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1350.00","grand_total":"1525.50","paid_amount":"1525.50","room_type_id":"280","product_id":"855","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":"12918","customer_id":"12918","source_of_creation":"PMS","reservation_created_date":"2019-08-27 15:45:22","canceled_nights_data":"","product_name":"Island Delight 3+3A","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"270.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":"3036419","reservation_id":"86853","confirmation_number":"VV12160467025","room_stay_from":"2020-01-07","room_stay_to":"2020-01-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"248.00,248.00,248.00,248.00,248.00,248.00,248.00,248.00,248.00,248.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2480.00","grand_total":"2802.40","paid_amount":"2802.40","room_type_id":"275","product_id":"850","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":"12651","customer_id":"12651","source_of_creation":"PMS","reservation_created_date":"2019-11-08 15:45:26","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":"248.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3015973","reservation_id":"83548","confirmation_number":"VV12122468957","room_confirmation_number":"VV12148203109","room_stay_from":"2020-01-07","room_stay_to":"2020-01-15","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1784","service_quantity":"1","customer_traveller_id":"90844","product_attribute_values":"extra_person#&#20.00","reservation_created_date":"2019-09-02 16:09:08","reservation_modified_date_time":"2019-09-02 16:09:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90844","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","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"}]}],"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":[]}}