{"hotel_id":"126","sub_hotel_id":0,"room_type":"villa","date":"2020-09-11","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":"1253,1971,1973,1997,1998,1936,1967,1963,1935,1934,1944,1946,1950,1952,1953,1956,1957,1958,1959,1960,1962,1252,1968,1974,1976,1985,1256,1246","block_room_bookings":[{"confirmation_number":"SJ12696012008","room_stay_from":"2020-08-05","room_stay_to":"2020-09-15","bundle_room":"0"},{"confirmation_number":"SJ12650697890","room_stay_from":"2020-06-01","room_stay_to":"2020-09-23","bundle_room":"1"},{"confirmation_number":"SJ12623311142","room_stay_from":"2020-06-01","room_stay_to":"2020-09-25","bundle_room":"1"},{"confirmation_number":"SJ12697162815","room_stay_from":"2020-06-01","room_stay_to":"2020-09-26","bundle_room":"1"},{"confirmation_number":"SJ12627377195","room_stay_from":"2020-08-26","room_stay_to":"2020-10-01","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":"SJ12677976161","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12658350936","room_stay_from":"2020-09-10","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12673370136","room_stay_from":"2020-09-10","room_stay_to":"2021-01-01","bundle_room":"0"}],"bundle_block_count":"1255,1245,1251,1979,1971,1973,1997,1998,1936,1967,1963,1964,1256,1246,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":"SJB12688435650","room_stay_from":"2020-09-11","room_stay_to":"2020-09-12","bundle_room":"1"},{"confirmation_number":"SJB12686463068","room_stay_from":"2020-09-11","room_stay_to":"2020-09-13","bundle_room":"0"},{"confirmation_number":"SJB12673952505","room_stay_from":"2020-09-11","room_stay_to":"2020-09-13","bundle_room":"0"},{"confirmation_number":"SJB12639335351","room_stay_from":"2020-06-01","room_stay_to":"2020-09-23","bundle_room":"0"},{"confirmation_number":"SJB12632444377","room_stay_from":"2020-06-01","room_stay_to":"2020-09-23","bundle_room":"0"},{"confirmation_number":"SJB12682694351","room_stay_from":"2020-06-01","room_stay_to":"2020-09-25","bundle_room":"0"},{"confirmation_number":"SJB12681851655","room_stay_from":"2020-06-01","room_stay_to":"2020-09-25","bundle_room":"0"},{"confirmation_number":"SJB12669486644","room_stay_from":"2020-06-01","room_stay_to":"2020-09-26","bundle_room":"0"},{"confirmation_number":"SJB12682158333","room_stay_from":"2020-06-01","room_stay_to":"2020-09-26","bundle_room":"0"},{"confirmation_number":"SJB12636424273","room_stay_from":"2020-09-02","room_stay_to":"2020-10-01","bundle_room":"1"},{"confirmation_number":"SJB12611093074","room_stay_from":"2020-09-10","room_stay_to":"2020-10-21","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":"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":"3136335","reservation_id":"100293","confirmation_number":"SJ12668354880","room_stay_from":"2020-09-11","room_stay_to":"2020-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00","nightly_discount":"0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","room_type_id":"332","product_id":"1255","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":"106323","customer_id":"103564","source_of_creation":"PMS","reservation_created_date":"2020-09-12 03:23:10","canceled_nights_data":"","product_name":"Canal View One Bedroom Villa 141","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.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":"3136144","reservation_id":"100276","confirmation_number":"SJ12646491159","room_stay_from":"2020-09-11","room_stay_to":"2020-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,120.00","nightly_discount":"0.00,0.00","subtotal":"240.00","grand_total":"270.00","paid_amount":"270.00","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":"106296","customer_id":"106296","source_of_creation":"PMS","reservation_created_date":"2020-09-11 18:49:15","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":"120.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":"3134156","reservation_id":"99969","confirmation_number":"SJ12651146961","room_stay_from":"2020-09-07","room_stay_to":"2020-09-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"35.71,35.71,35.71,35.71,35.72,35.72,35.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"0.00","room_type_id":"333","product_id":"1982","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":"105499","customer_id":"105499","source_of_creation":"PMS","reservation_created_date":"2020-09-04 15:56:38","canceled_nights_data":"","product_name":"Garden View One Bedroom Villa 130","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"35.72","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":"3130205","reservation_id":"99497","confirmation_number":"SJ12634284544","room_stay_from":"2020-08-17","room_stay_to":"2020-09-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","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","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":"105499","customer_id":"105499","source_of_creation":"PMS","reservation_created_date":"2020-08-25 18:03:52","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.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":"3130212","reservation_id":"99500","confirmation_number":"SJ12680230123","room_stay_from":"2020-08-17","room_stay_to":"2020-09-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","nightly_discount":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"332","product_id":"1236","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":"105499","customer_id":"105499","source_of_creation":"PMS","reservation_created_date":"2020-08-25 18:31:21","canceled_nights_data":"","product_name":"Canal View One Bedroom Villa 116","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"}]}],"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":"3136336","reservation_id":"100293","confirmation_number":"SJ12617509211","room_confirmation_number":"SJ12668354880","room_stay_from":"2020-09-11","room_stay_to":"2020-09-12","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"106323","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-12 03:23:10","reservation_modified_date_time":"2020-09-12 03:23:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103564","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":"3136145","reservation_id":"100276","confirmation_number":"SJ12669969818","room_confirmation_number":"SJ12646491159","room_stay_from":"2020-09-11","room_stay_to":"2020-09-13","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":"106296","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-11 18:49:15","reservation_modified_date_time":"2020-09-11 18:49:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106296","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":"3134157","reservation_id":"99969","confirmation_number":"SJ12644586297","room_confirmation_number":"SJ12651146961","room_stay_from":"2020-09-07","room_stay_to":"2020-09-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":"105499","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-04 15:56:38","reservation_modified_date_time":"2020-09-04 23:16:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105499","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":"3130206","reservation_id":"99497","confirmation_number":"SJ12680467528","room_confirmation_number":"SJ12634284544","room_stay_from":"2020-08-17","room_stay_to":"2020-09-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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"105499","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-25 18:03:52","reservation_modified_date_time":"2020-08-25 18:24:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105499","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":"3130213","reservation_id":"99500","confirmation_number":"SJ12626619363","room_confirmation_number":"SJ12680230123","room_stay_from":"2020-08-17","room_stay_to":"2020-09-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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"105499","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-25 18:31:21","reservation_modified_date_time":"2020-08-25 18:35:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105499","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":[]}}