{"hotel_id":"126","sub_hotel_id":0,"room_type":"villa","date":"2020-12-24","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":1,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1236,1979,1970,1252,1953,1959,1963,1967,1936,1934,1935,1253,1985,1952,1950,1957,1956,1962,1960,1968,1992,1982,1974,1976,1994,1256,1246,1944,1946,1971,1973,1255,1245,1997,1998,1251,1964","block_room_bookings":[{"confirmation_number":"SJ12669498536","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12674598015","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12667799734","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12618346991","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12636444105","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12610332897","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12688789565","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12640858131","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12653664183","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12638212058","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12613045393","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12656486605","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12692459120","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12611043073","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12647735024","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12694756091","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12694184095","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12655351097","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12694819829","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12616826933","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12611490820","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12628712894","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12689918749","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12661302664","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12639774949","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12642022543","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12660914070","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12684910646","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJ12629354905","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJ12694821090","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJ12610017315","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJ12632661298","room_stay_from":"2020-12-21","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJ12699582501","room_stay_from":"2020-12-24","room_stay_to":"2020-12-28","bundle_room":"0"}],"bundle_block_count":"1989,1990,1936,1967,1253,1985,1950,1952,1956,1957,1960,1962,1968,1970,1252,1982,1974,1976,1992,1994,1256,1246,1944,1946,1971,1973,1255,1245,1997,1998,1251,1979,1963,1964,1958,1959,1953,1955","bundle_block_bookings":[{"confirmation_number":"SJB12621465203","room_stay_from":"2020-12-24","room_stay_to":"2020-12-27","bundle_room":"0"},{"confirmation_number":"SJB12695334529","room_stay_from":"2020-12-24","room_stay_to":"2020-12-27","bundle_room":"0"},{"confirmation_number":"SJB12686081798","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJB12653495868","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJB12645580783","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJB12653282394","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJB12661976573","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJB12686009289","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJB12678108688","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJB12680026065","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJB12612477724","room_stay_from":"2020-12-17","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJB12614006683","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJB12613603791","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJB12668683475","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJB12654928164","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJB12647738332","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJB12640203345","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJB12695898296","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJB12670393462","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJB12632877765","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"0"},{"confirmation_number":"SJB12664656720","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJB12698473654","room_stay_from":"2020-12-23","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJB12620967070","room_stay_from":"2020-12-14","room_stay_to":"2020-12-28","bundle_room":"1"},{"confirmation_number":"SJB12677795967","room_stay_from":"2020-09-17","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":"3169576","reservation_id":"104058","confirmation_number":"SJ12621703120","room_stay_from":"2020-12-24","room_stay_to":"2020-12-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00,199.00,199.00","nightly_discount":"0.00,0.00,0.00","subtotal":"597.00","grand_total":"671.63","paid_amount":"671.63","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"110389","customer_id":"110389","source_of_creation":"PMS","reservation_created_date":"2020-12-21 15:18:21","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":"199.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":"3165114","reservation_id":"100508","confirmation_number":"SJ12683931108","room_stay_from":"2020-09-17","room_stay_to":"2021-01-17","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,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"332","product_id":"1955","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":"106521","customer_id":"106521","source_of_creation":"PMS","reservation_created_date":"2020-09-17 22:19:58","canceled_nights_data":"","product_name":"Canal View One Bedroom Villa 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0","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":"3169673","reservation_id":"104212","confirmation_number":"SJ12679604623","room_stay_from":"2020-12-24","room_stay_to":"2021-01-23","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,900.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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","subtotal":"900.00","grand_total":"1012.50","paid_amount":"1012.50","room_type_id":"332","product_id":"1958","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":"110512","customer_id":"110512","source_of_creation":"PMS","reservation_created_date":"2020-12-24 18:51:44","canceled_nights_data":"","product_name":"Canal View One Bedroom Villa 110","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":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3169579","reservation_id":"104058","confirmation_number":"SJ12658486903","room_confirmation_number":"SJ12621703120","room_stay_from":"2020-12-24","room_stay_to":"2020-12-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"110389","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-21 15:18:21","reservation_modified_date_time":"2020-12-24 16:35:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110389","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.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":"3165116","reservation_id":"100508","confirmation_number":"SJ12681379651","room_confirmation_number":"SJ12683931108","room_stay_from":"2020-09-17","room_stay_to":"2021-01-17","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,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,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":"106521","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-17 22:19:58","reservation_modified_date_time":"2020-12-14 20:24:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106521","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3169675","reservation_id":"104212","confirmation_number":"SJ12664023244","room_confirmation_number":"SJ12679604623","room_stay_from":"2020-12-24","room_stay_to":"2021-01-23","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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110512","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-24 18:51:44","reservation_modified_date_time":"2020-12-24 18:57:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110512","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":[]}}