{"hotel_id":"121","sub_hotel_id":0,"room_type":"hotel","date":"2021-06-13","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":"850,840,843,848","block_room_bookings":[{"confirmation_number":"VV12136927497","room_stay_from":"2021-06-12","room_stay_to":"2021-06-14","bundle_room":"0","product_id":"850"},{"confirmation_number":"VV12189488580","room_stay_from":"2021-06-13","room_stay_to":"2021-06-14","bundle_room":"0","product_id":"840"},{"confirmation_number":"VV12126002432","room_stay_from":"2021-05-21","room_stay_to":"2021-06-19","bundle_room":"0","product_id":"843"},{"confirmation_number":"VV12132236340","room_stay_from":"2021-02-01","room_stay_to":"2021-11-14","bundle_room":"0","product_id":"848"}],"bundle_block_count":"841,842,839,840,850,851,845,846","bundle_block_bookings":[{"confirmation_number":"VVB12152581221","room_stay_from":"2021-06-11","room_stay_to":"2021-06-14","bundle_room":"0","product_id":"841"},{"confirmation_number":"VVB12125359084","room_stay_from":"2021-06-11","room_stay_to":"2021-06-14","bundle_room":"0","product_id":"842"},{"confirmation_number":"VVB12169737857","room_stay_from":"2021-06-13","room_stay_to":"2021-06-14","bundle_room":"1","product_id":"854"},{"confirmation_number":"VVB12191884239","room_stay_from":"2021-06-12","room_stay_to":"2021-06-15","bundle_room":"1","product_id":"857"},{"confirmation_number":"VVB12156554185","room_stay_from":"2021-06-05","room_stay_to":"2021-06-20","bundle_room":"1","product_id":"856"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3262007","reservation_id":"116541","confirmation_number":"VV12145096773","room_stay_from":"2021-06-11","room_stay_to":"2021-06-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.42,255.42,235.62","nightly_discount":"0,0,0","subtotal":"746.46","grand_total":"843.50","paid_amount":"843.50","room_type_id":"280","product_id":"855","siteminder_id":"BDC-2233650763","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":"123423","customer_id":"123423","source_of_creation":"Booking.com","reservation_created_date":"2021-06-04 19:47:10","canceled_nights_data":"","product_name":"Island Delight - 2 Bedroom (VV3+3A)","ota_service_fee_amount":"0","commision_charges":"111.97","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"121","group_rooms":"841,842","currentDayPrice":"235.62","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":"3263716","reservation_id":"116661","confirmation_number":"VV12153177006","room_stay_from":"2021-06-07","room_stay_to":"2021-06-09","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"153.75,153.75","nightly_discount":"0.00,0.00","subtotal":"307.50","grand_total":"347.48","paid_amount":"347.48","room_type_id":"274","product_id":"849","siteminder_id":"BDC-3297740098","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":"123553","customer_id":"123553","source_of_creation":"Booking.com","reservation_created_date":"2021-06-06 16:26:11","service_canceled_date_time":"2021-06-13 22:38:10","canceled_nights_data":"","product_name":"London - 1 Bedroom (R6)","ota_service_fee_amount":"0","commision_charges":"37.12","reservation_status_type":"Room-Night-1-prices","total_paid_amount":"347.48","sub_hotel_id":"121","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3261133","reservation_id":"116429","confirmation_number":"VV12122029791","room_stay_from":"2021-06-09","room_stay_to":"2021-06-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.92,144.92,163.62,163.62,144.92","nightly_discount":"0,0,0,0,0","subtotal":"762.00","grand_total":"861.06","paid_amount":"861.06","room_type_id":"272","product_id":"847","siteminder_id":"EXP-1779753835","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":"123298","customer_id":"123298","source_of_creation":"Expedia","reservation_created_date":"2021-06-03 07:25:09","canceled_nights_data":"","product_name":"Italian - 1 Bedroom (VV1)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"121","group_rooms":null,"currentDayPrice":"144.92","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":"3259578","reservation_id":"116217","confirmation_number":"VV12159633845","room_stay_from":"2021-06-12","room_stay_to":"2021-06-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.55,123.75,123.30","nightly_discount":"0,0,0","subtotal":"390.60","grand_total":"441.38","paid_amount":"441.38","room_type_id":"276","product_id":"851","siteminder_id":"EXP-1778131624","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":"123064","customer_id":"123064","source_of_creation":"Expedia","reservation_created_date":"2021-05-30 21:25:15","canceled_nights_data":"","product_name":"Miami Classic - Hotel Room (VV8A)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"121","group_rooms":null,"currentDayPrice":"123.75","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":"3246921","reservation_id":"114552","confirmation_number":"VV12110405525","room_stay_from":"2021-06-11","room_stay_to":"2021-06-16","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.62,163.62,144.92,144.92,144.92","nightly_discount":"0,0,0,0,0","subtotal":"762.00","grand_total":"861.06","paid_amount":"861.06","room_type_id":"269","product_id":"844","siteminder_id":"EXP-1767212642","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":"121246","customer_id":"121246","source_of_creation":"Expedia","reservation_created_date":"2021-05-05 01:40:11","canceled_nights_data":"","product_name":"Capri - 1 Bedroom (R2)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"121","group_rooms":null,"currentDayPrice":"144.92","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":[{"room_stay_id":"3257507","reservation_id":"115953","confirmation_number":"VV12132855746","room_stay_from":"2021-06-11","room_stay_to":"2021-06-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.08,159.08,159.08,159.08","nightly_discount":"0,0,0,0","subtotal":"636.32","grand_total":"830.23","paid_amount":"830.23","room_type_id":"278","product_id":"853","siteminder_id":"ABB-HMJ2WPY35J","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"636.32","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122750","customer_id":"122750","source_of_creation":"Airbnb","reservation_created_date":"2021-05-26 22:40:10","canceled_nights_data":"","product_name":"South Beach - 1 Bedroom (R1)","ota_service_fee_amount":"88.95","commision_charges":"19.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"121","group_rooms":null,"currentDayPrice":"159.08","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]},{"room_stay_id":"3265493","reservation_id":"117009","confirmation_number":"VV12198905824","room_stay_from":"2021-06-12","room_stay_to":"2021-06-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.52,155.52,155.52","nightly_discount":"0,0,0","subtotal":"466.56","grand_total":"608.74","paid_amount":"608.74","room_type_id":"264","product_id":"839","siteminder_id":"ABB-HMQ3MCPZAM","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"466.56","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"123948","customer_id":"123948","source_of_creation":"Airbnb","reservation_created_date":"2021-06-11 03:48:11","canceled_nights_data":"","product_name":"French Country - 1 Bedroom (VV7)","ota_service_fee_amount":"65.22","commision_charges":"14.43","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"121","group_rooms":null,"currentDayPrice":"155.52","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"125","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"124","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3260874","reservation_id":"116391","confirmation_number":"VV12195373914","room_stay_from":"2021-06-10","room_stay_to":"2021-06-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"299.20,321.20,321.20,299.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1240.80","grand_total":"1402.11","paid_amount":"1402.11","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":"123257","customer_id":"123257","source_of_creation":"FE","reservation_created_date":"2021-06-02 17:34:59","canceled_nights_data":"","product_name":"Santa Fe Suite - 2 Bedroom (VV5)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"299.20","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":"3255500","reservation_id":"115662","confirmation_number":"VV12196611966","room_stay_from":"2021-06-12","room_stay_to":"2021-06-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.90,152.90,152.90","nightly_discount":"0.00,0.00,0.00","subtotal":"480.70","grand_total":"543.19","paid_amount":"543.19","room_type_id":"274","product_id":"849","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":"122427","customer_id":"122427","source_of_creation":"FE","reservation_created_date":"2021-05-22 03:51:07","canceled_nights_data":"","product_name":"London - 1 Bedroom (R6)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"152.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":"3216520","reservation_id":"110440","confirmation_number":"VV12120059253","room_stay_from":"2021-06-04","room_stay_to":"2021-06-20","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.90,152.90,152.90,152.90,152.90,152.90,152.90,152.90,152.90,152.90,152.90,152.90,152.90,152.90,152.90,152.90","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","subtotal":"2446.40","grand_total":"2764.43","paid_amount":"2764.43","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":"12674","customer_id":"12674","source_of_creation":"FE","reservation_created_date":"2021-03-16 17:56:10","canceled_nights_data":"","product_name":"The Floridian - 1 Bedroom (VV4)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"152.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":"3266444","reservation_id":"87884","confirmation_number":"VV12154053796","room_stay_from":"2021-07-07","room_stay_to":"2021-07-11","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,139.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"556.00","grand_total":"628.28","paid_amount":"202.04","room_type_id":"283","product_id":"864","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":"75809","customer_id":"75809","source_of_creation":"FE","reservation_created_date":"2019-12-05 18:12:58","canceled_nights_data":"","product_name":"VV WALK","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"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":"3266445","reservation_id":"87886","confirmation_number":"VV12125098150","room_stay_from":"2021-07-03","room_stay_to":"2021-07-07","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,139.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"556.00","grand_total":"628.28","paid_amount":"211.54","room_type_id":"283","product_id":"864","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":"78526","customer_id":"78526","source_of_creation":"FE","reservation_created_date":"2019-12-05 18:31:49","canceled_nights_data":"","product_name":"VV WALK","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"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":"3266446","reservation_id":"91691","confirmation_number":"VV12169079344","room_stay_from":"2021-06-28","room_stay_to":"2021-07-03","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,159.00,159.00,159.00,156.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"792.00","grand_total":"894.96","paid_amount":"894.96","room_type_id":"283","product_id":"864","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":"95357","customer_id":"95357","source_of_creation":"FE","reservation_created_date":"2020-02-10 01:13:53","canceled_nights_data":"","product_name":"VV WALK","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"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":"3264944","reservation_id":"116914","confirmation_number":"VV12184529042","room_stay_from":"2021-06-11","room_stay_to":"2021-06-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"400.00","grand_total":"452.00","paid_amount":"452.00","room_type_id":"271","product_id":"846","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":"102155","customer_id":"102155","source_of_creation":"PMS","reservation_created_date":"2021-06-10 00:14:39","canceled_nights_data":"","product_name":"The Floridian - Hotel Room (VV4A)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"100.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":[]}}