{"hotel_id":"126","sub_hotel_id":0,"room_type":"villa","date":"2020-03-09","total_rooms_exist":"1236,1245,1251,1253,1255,1934,1935,1936,1944,1946,1953,1955,1958,1959,1963,1964,1967,1971,1973,1979,1985,1989,1990,1246,1252,1256,1950,1952,1956,1957,1960,1962,1968,1970,1974,1976,1982,1986,1988,1992,1994,1997,1998","departureCount":0,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1992,1994,1935,1934,1944,1946,1950,1952,1953,1955,1956,1957,1958,1959,1960,1962,1963,1252,1968,1970,1974,1976,1979,1982,1985","block_room_bookings":[{"confirmation_number":"SJ12631114488","room_stay_from":"2020-02-17","room_stay_to":"2020-03-15","bundle_room":"1"},{"confirmation_number":"SJ12649079193","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12685142670","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12647761185","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJ12688548693","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12678622886","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12611699920","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12669482631","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12610838194","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12613142878","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12662108543","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12698457195","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12687898538","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12699660853","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12622276065","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12630566464","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12699682337","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12653953829","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12625029318","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12636415562","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12646107189","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12679488133","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12677976161","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"}],"bundle_block_count":"1997,1998,1971,1973,1989,1990,1992,1994,1256,1246,1944,1946,1950,1952,1953,1955,1956,1957,1958,1959,1960,1962,1963,1964,1252,1982,1968,1970,1974,1976,1253,1985,1251,1979","bundle_block_bookings":[{"confirmation_number":"SJB12679154021","room_stay_from":"2020-03-04","room_stay_to":"2020-03-13","bundle_room":"0"},{"confirmation_number":"SJB12659782486","room_stay_from":"2020-03-04","room_stay_to":"2020-03-13","bundle_room":"0"},{"confirmation_number":"SJB12655248894","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","bundle_room":"0"},{"confirmation_number":"SJB12675223478","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","bundle_room":"0"},{"confirmation_number":"SJB12631361712","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","bundle_room":"0"},{"confirmation_number":"SJB12614412169","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","bundle_room":"0"},{"confirmation_number":"SJB12638516810","room_stay_from":"2020-02-17","room_stay_to":"2020-03-15","bundle_room":"0"},{"confirmation_number":"SJB12680912628","room_stay_from":"2020-02-17","room_stay_to":"2020-03-15","bundle_room":"0"},{"confirmation_number":"SJB12622851971","room_stay_from":"2020-01-16","room_stay_to":"2020-04-01","bundle_room":"1"},{"confirmation_number":"SJB12684262383","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJB12664384152","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJB12623120612","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12669275889","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12630688658","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12694565580","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12698121515","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12660327284","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12641033345","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12610359718","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12673674369","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12621355787","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12630427599","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[],"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":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3077675","reservation_id":"92590","confirmation_number":"SJ12659490433","room_stay_from":"2020-03-04","room_stay_to":"2020-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"410","product_id":"1995","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":"74162","customer_id":"74162","source_of_creation":"PMS","reservation_created_date":"2020-02-26 13:36:23","canceled_nights_data":"","product_name":"Garden View Two Bedroom Villa 139+140","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076779","reservation_id":"87569","confirmation_number":"SJ12620875524","room_stay_from":"2019-12-13","room_stay_to":"2020-04-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"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,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,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,0.00,0.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,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,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,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"333","product_id":"1246","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":"94078","customer_id":"94078","source_of_creation":"PMS","reservation_created_date":"2019-11-27 19:18:57","canceled_nights_data":"","product_name":"Garden View One Bedroom Villa 144","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3048054","reservation_id":"87356","confirmation_number":"SJ12636838196","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"409","product_id":"1707","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"74796","customer_id":"74796","source_of_creation":"PMS","reservation_created_date":"2019-11-20 16:35:16","canceled_nights_data":"","product_name":"Canal Villa one bedroom Suite 123\/124","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3060324","reservation_id":"90325","confirmation_number":"SJ12684564086","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"409","product_id":"1798","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"74797","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2020-01-21 21:38:25","canceled_nights_data":"","product_name":"Canal View Two Bedroom Villa 135+136","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3077678","reservation_id":"92590","confirmation_number":"SJ12696987483","room_confirmation_number":"SJ12659490433","room_stay_from":"2020-03-04","room_stay_to":"2020-03-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"74162","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-26 13:36:23","reservation_modified_date_time":"2020-03-04 15:23:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74162","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3048057","reservation_id":"87356","confirmation_number":"SJ12684309054","room_confirmation_number":"SJ12636838196","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"93905","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-20 16:35:16","reservation_modified_date_time":"2019-11-20 16:35:16","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74796","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3060325","reservation_id":"90325","confirmation_number":"SJ12641888054","room_confirmation_number":"SJ12684564086","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"96374","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-21 21:38:25","reservation_modified_date_time":"2020-01-21 21:38:25","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076782","reservation_id":"87569","confirmation_number":"SJ12650902986","room_confirmation_number":"SJ12620875524","room_stay_from":"2019-12-13","room_stay_to":"2020-04-01","room_stay_status":"Active","nightly_price":"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,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,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,0.00,0.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,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,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,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"94078","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-27 19:18:57","reservation_modified_date_time":"2020-03-01 17:09:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94078","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}