{"hotel_id":"126","sub_hotel_id":0,"room_type":"villa","date":"2020-07-03","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":"1989,1990","hold_room_bookings":[{"confirmation_number":"SJ12622191496","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","bundle_room":"1"}],"block_room_count":"1997,1998,1255,1256,1246,1936,1967,1236,1253,1986,1988,1992,1994,1971,1973,1245,1935,1934,1944,1946,1950,1952,1953,1956,1957,1958,1959,1960,1962,1252,1968,1974,1976,1982,1985","block_room_bookings":[{"confirmation_number":"SJ12623311142","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"1"},{"confirmation_number":"SJ12616780319","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJ12655847829","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"1"},{"confirmation_number":"SJ12697162815","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"1"},{"confirmation_number":"SJ12680658712","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJ12617233377","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJ12643113694","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"1"},{"confirmation_number":"SJ12648143559","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"1"},{"confirmation_number":"SJ12650697890","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"1"},{"confirmation_number":"SJ12635628045","room_stay_from":"2020-06-14","room_stay_to":"2020-08-31","bundle_room":"0"},{"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":"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":"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":"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":"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":"1963,1964,1251,1979,1989,1990,1997,1998,1255,1245,1256,1246,1936,1967,1986,1988,1992,1994,1971,1973,1944,1946,1950,1952,1953,1955,1956,1957,1958,1959,1960,1962,1252,1982,1968,1970,1974,1976,1253,1985","bundle_block_bookings":[{"confirmation_number":"SJB12636157360","room_stay_from":"2020-06-30","room_stay_to":"2020-07-05","bundle_room":"1"},{"confirmation_number":"SJB12612169355","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","bundle_room":"0"},{"confirmation_number":"SJB12614109560","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","bundle_room":"0"},{"confirmation_number":"SJB12695755308","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","bundle_room":"0"},{"confirmation_number":"SJB12680841721","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","bundle_room":"0"},{"confirmation_number":"SJB12636525798","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJB12639850321","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJB12617058778","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"1"},{"confirmation_number":"SJB12671588879","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJB12672778917","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJB12683042848","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJB12657826307","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJB12619481482","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJB12615122646","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJB12671191908","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJB12662424969","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJB12698797723","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJB12664524876","room_stay_from":"2020-06-01","room_stay_to":"2020-08-31","bundle_room":"0"},{"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":"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"}]},"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":"3111906","reservation_id":"97309","confirmation_number":"SJ12626193358","room_stay_from":"2020-06-30","room_stay_to":"2020-07-05","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"332","product_id":"1963","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":"99779","customer_id":"99779","source_of_creation":"PMS","reservation_created_date":"2020-07-02 19:15:22","canceled_nights_data":"","product_name":"Canal View One Bedroom Villa 114","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"}]},{"room_stay_id":"3111914","reservation_id":"97311","confirmation_number":"SJ12681258782","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"69.00,69.00,69.00","nightly_discount":"0.00,0.00,0.00","subtotal":"207.00","grand_total":"232.88","paid_amount":"232.88","room_type_id":"333","product_id":"1970","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":"103395","customer_id":"103395","source_of_creation":"PMS","reservation_created_date":"2020-07-02 19:18:46","canceled_nights_data":"","product_name":"Garden View One Bedroom Villa 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.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":"3111934","reservation_id":"97313","confirmation_number":"SJ12651234618","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,110.00,110.00","nightly_discount":"0.00,0.00,0.00","subtotal":"330.00","grand_total":"371.25","paid_amount":"371.25","room_type_id":"409","product_id":"1977","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":"103395","customer_id":"103395","source_of_creation":"PMS","reservation_created_date":"2020-07-02 19:39:35","canceled_nights_data":"","product_name":"Canal View Two Bedroom Villa 127+128","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"110.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":"3112033","reservation_id":"97308","confirmation_number":"SJ12645831418","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","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":"103393","customer_id":"103393","source_of_creation":"PMS","reservation_created_date":"2020-07-02 19:10:32","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":"","changedComment":"From date changed","deltaChange":"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":"3112035","reservation_id":"97310","confirmation_number":"SJ12654607604","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"332","product_id":"1964","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":"103393","customer_id":"103393","source_of_creation":"PMS","reservation_created_date":"2020-07-02 19:16:44","canceled_nights_data":"","product_name":"Canal View One Bedroom Villa 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"From date changed","deltaChange":"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"}]}],"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":"3111907","reservation_id":"97309","confirmation_number":"SJ12642307083","room_confirmation_number":"SJ12626193358","room_stay_from":"2020-06-30","room_stay_to":"2020-07-05","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"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":"99779","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-02 19:15:22","reservation_modified_date_time":"2020-07-02 19:15:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99779","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":"3111915","reservation_id":"97311","confirmation_number":"SJ12699728299","room_confirmation_number":"SJ12681258782","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"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":"103395","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-02 19:18:46","reservation_modified_date_time":"2020-07-02 19:19:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103395","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":"3111937","reservation_id":"97313","confirmation_number":"SJ12691882749","room_confirmation_number":"SJ12651234618","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"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":"103395","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-02 19:39:35","reservation_modified_date_time":"2020-07-02 19:40:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103395","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":"3112034","reservation_id":"97308","confirmation_number":"SJ12688161605","room_confirmation_number":"SJ12645831418","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103393","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-02 19:10:32","reservation_modified_date_time":"2020-07-03 12:02:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103393","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"From date changed","deltaChange":"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":"3112036","reservation_id":"97310","confirmation_number":"SJ12646712540","room_confirmation_number":"SJ12654607604","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103393","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-02 19:16:44","reservation_modified_date_time":"2020-07-03 12:02:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103393","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"From date changed","deltaChange":"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":[]}}