{"hotel_id":"121","sub_hotel_id":0,"room_type":"hotel","date":"2021-07-24","total_rooms_exist":"839,840,841,842,843,844,845,846,847,848,849,850,851,852,853","departureCount":4,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"853,848","block_room_bookings":[{"confirmation_number":"VV12150198451","room_stay_from":"2021-07-19","room_stay_to":"2021-09-28","bundle_room":"0","product_id":"853"},{"confirmation_number":"VV12132236340","room_stay_from":"2021-02-01","room_stay_to":"2021-11-14","bundle_room":"0","product_id":"848"}],"bundle_block_count":"850,851,841,842,845,846,839,840","bundle_block_bookings":[{"confirmation_number":"VVB12123115305","room_stay_from":"2021-07-22","room_stay_to":"2021-07-25","bundle_room":"1","product_id":"857"},{"confirmation_number":"VVB12156003664","room_stay_from":"2021-07-22","room_stay_to":"2021-07-25","bundle_room":"1","product_id":"855"},{"confirmation_number":"VVB12114667479","room_stay_from":"2021-07-24","room_stay_to":"2021-07-25","bundle_room":"1","product_id":"856"},{"confirmation_number":"VVB12158418847","room_stay_from":"2021-07-24","room_stay_to":"2021-07-26","bundle_room":"1","product_id":"854"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3284351","reservation_id":"119373","confirmation_number":"VV12166987207","room_stay_from":"2021-07-22","room_stay_to":"2021-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"187.55,211.75,211.75","nightly_discount":"0,0,0","subtotal":"611.05","grand_total":"690.48","paid_amount":"690.48","room_type_id":"266","product_id":"841","siteminder_id":"BDC-3702542577","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":"127108","customer_id":"127108","source_of_creation":"Booking.com","reservation_created_date":"2021-07-15 11:00:10","canceled_nights_data":"","product_name":"Island Delight - 1 Bedroom (VV3)","ota_service_fee_amount":"0","commision_charges":"91.66","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"121","group_rooms":null,"currentDayPrice":"211.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":"3288632","reservation_id":"119928","confirmation_number":"VV12185784184","room_stay_from":"2021-07-24","room_stay_to":"2021-07-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"254.10","nightly_discount":"0","subtotal":"254.10","grand_total":"287.14","paid_amount":"287.14","room_type_id":"268","product_id":"843","siteminder_id":"BDC-2452726500","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":"127146","customer_id":"127146","source_of_creation":"Booking.com","reservation_created_date":"2021-07-23 21:30:11","canceled_nights_data":"","product_name":"Belize - 1 Bedroom  (R5)","ota_service_fee_amount":"0","commision_charges":"38.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"121","group_rooms":null,"currentDayPrice":"254.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":"3288933","reservation_id":"118435","confirmation_number":"VV12111856412","room_stay_from":"2021-07-24","room_stay_to":"2021-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"157.91","nightly_discount":"0","subtotal":"157.91","grand_total":"178.43","paid_amount":"178.43","room_type_id":"270","product_id":"845","siteminder_id":"BDC-3113563816","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":"127211","customer_id":"127211","source_of_creation":"Booking.com","reservation_created_date":"2021-07-01 02:04:12","canceled_nights_data":"","product_name":"The Floridian - 1 Bedroom (VV4)","ota_service_fee_amount":"0","commision_charges":"23.69","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"121","currentDayPrice":"157.91","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":"3272288","reservation_id":"117877","confirmation_number":"VV12131781868","room_stay_from":"2021-07-22","room_stay_to":"2021-07-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"170.50,192.50,192.50,170.50","nightly_discount":"0,0,0,0","subtotal":"726.00","grand_total":"820.38","paid_amount":"820.38","room_type_id":"264","product_id":"839","siteminder_id":"BDC-3150545822","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":"127099","customer_id":"127099","source_of_creation":"Booking.com","reservation_created_date":"2021-06-23 01:39:15","canceled_nights_data":"","product_name":"French Country - 1 Bedroom (VV7)","ota_service_fee_amount":"0","commision_charges":"189.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"121","group_rooms":null,"currentDayPrice":"192.50","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":"3286578","reservation_id":"117877","confirmation_number":"VV12153567307","room_stay_from":"2021-07-22","room_stay_to":"2021-07-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.75,143.55,143.55,123.75","nightly_discount":"0,0,0,0","subtotal":"534.60","grand_total":"604.10","paid_amount":"604.10","room_type_id":"265","product_id":"840","siteminder_id":"BDC-3150545822","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":"127099","customer_id":"127099","source_of_creation":"Booking.com","reservation_created_date":"2021-06-23 01:39:09","canceled_nights_data":"","product_name":"French Country - Hotel Room (VV7A)","ota_service_fee_amount":"0","commision_charges":"189.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"121","group_rooms":null,"currentDayPrice":"143.55","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":"3289035","reservation_id":"118167","confirmation_number":"VV12140638913","room_stay_from":"2021-07-24","room_stay_to":"2021-07-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.25,153.45,153.45,153.45,153.45","nightly_discount":"0,0,0,0,0","subtotal":"787.05","grand_total":"889.36","paid_amount":"889.36","room_type_id":"274","product_id":"849","siteminder_id":"EXP-1791793988","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":"127224","customer_id":"127224","source_of_creation":"Expedia","reservation_created_date":"2021-06-27 02:10:10","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":null,"sub_hotel_id":"121","currentDayPrice":"173.25","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":"3279682","reservation_id":"118835","confirmation_number":"VV12122685055","room_stay_from":"2021-07-24","room_stay_to":"2021-07-31","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.99,159.42,159.42,159.42,159.42,159.42,179.99","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1157.08","grand_total":"1307.50","paid_amount":"392.25","room_type_id":"268","product_id":"843","siteminder_id":"EXP-1796859719","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":"125920","customer_id":"125920","source_of_creation":"Expedia","reservation_created_date":"2021-07-07 00:40:13","service_canceled_date_time":"2021-07-23 19:35:09","canceled_nights_data":"","product_name":"Belize - 1 Bedroom  (R5)","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"121","deltaChange":"392.25","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":[{"room_stay_id":"3288533","reservation_id":"119907","confirmation_number":"VV12117864923","room_stay_from":"2021-07-24","room_stay_to":"2021-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.39","nightly_discount":"0","subtotal":"181.39","grand_total":"236.67","paid_amount":"236.67","room_type_id":"276","product_id":"851","siteminder_id":"ABB-HMKH4KBSSF","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"181.39","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"127121","customer_id":"127121","source_of_creation":"Airbnb","reservation_created_date":"2021-07-23 19:22:15","canceled_nights_data":"","product_name":"Miami Classic - Hotel Room (VV8A)","ota_service_fee_amount":"25.36","commision_charges":"5.61","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"121","group_rooms":null,"currentDayPrice":"181.39","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":"3215822","reservation_id":"110318","confirmation_number":"VV12147221627","room_stay_from":"2021-07-22","room_stay_to":"2021-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"152.90,174.90,174.90","nightly_discount":"0.00,0.00,0.00","subtotal":"502.70","grand_total":"568.05","paid_amount":"568.05","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":"22812","customer_id":"22812","source_of_creation":"FE","reservation_created_date":"2021-03-15 00:44:43","canceled_nights_data":"","product_name":"Miami Classic - 1 Bedroom  (VV8)","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":"174.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":"3270938","reservation_id":"117704","confirmation_number":"VV12186052570","room_stay_from":"2021-07-20","room_stay_to":"2021-07-26","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"299.20,299.20,299.20,321.20,321.20,299.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1839.20","grand_total":"2078.29","paid_amount":"2078.29","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":"124680","customer_id":"124680","source_of_creation":"FE","reservation_created_date":"2021-06-20 19:08:36","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":"321.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3287073","reservation_id":"118758","confirmation_number":"VV12174704608","room_stay_from":"2021-07-20","room_stay_to":"2021-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.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","subtotal":"1950.00","grand_total":"2203.50","paid_amount":"2203.50","room_type_id":"272","product_id":"847","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":"125845","customer_id":"125845","source_of_creation":"PMS","reservation_created_date":"2021-07-05 23:28:18","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":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"150.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":"3288826","reservation_id":"119327","confirmation_number":"VV12164554971","room_stay_from":"2021-07-30","room_stay_to":"2021-08-03","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.90,152.90,152.90,152.90","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"611.60","grand_total":"691.11","paid_amount":"384.72","room_type_id":"269","product_id":"844","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":"126458","customer_id":"126458","source_of_creation":"PMS","reservation_created_date":"2021-07-14 19:44:54","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":"","sub_hotel_id":"0","changedComment":"To date 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":"3288882","reservation_id":"109579","confirmation_number":"VV12149482660","room_stay_from":"2022-01-02","room_stay_to":"2022-01-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.00,185.00,196.90,185.00,185.00,185.00,185.00,185.00,185.00,185.00,185.00,185.00,185.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","subtotal":"2416.90","grand_total":"2731.09","paid_amount":"611.63","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":"12539","customer_id":"12539","source_of_creation":"PMS","reservation_created_date":"2021-03-06 16:05:57","canceled_nights_data":"","product_name":"Island Delight - 1 Bedroom (VV3)","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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3215823","reservation_id":"110318","confirmation_number":"VV12196348385","room_confirmation_number":"VV12147221627","room_stay_from":"2021-07-22","room_stay_to":"2021-07-25","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1784","service_quantity":"1","customer_traveller_id":"22812","product_attribute_values":"extra_person#&#20.00","reservation_created_date":"2021-03-15 00:44:43","reservation_modified_date_time":"2021-03-15 00:44:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"22812","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"20.00","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":[]}}