{"hotel_id":"126","sub_hotel_id":0,"room_type":"villa","date":"2020-09-07","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":4,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1986,1988,1253,1971,1973,1997,1998,1936,1967,1256,1246,1963,1935,1934,1944,1946,1950,1952,1953,1956,1957,1958,1959,1960,1962,1252,1968,1974,1976,1985","block_room_bookings":[{"confirmation_number":"SJ12671006246","room_stay_from":"2020-09-05","room_stay_to":"2020-09-08","bundle_room":"1"},{"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":"SJ12655847829","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"}],"bundle_block_count":"1986,1988,1989,1990,1971,1973,1997,1998,1936,1967,1256,1246,1963,1964,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":"SJB12672811675","room_stay_from":"2020-09-05","room_stay_to":"2020-09-08","bundle_room":"0"},{"confirmation_number":"SJB12687870307","room_stay_from":"2020-09-05","room_stay_to":"2020-09-08","bundle_room":"0"},{"confirmation_number":"SJB12698668200","room_stay_from":"2020-09-05","room_stay_to":"2020-09-08","bundle_room":"0"},{"confirmation_number":"SJB12610408780","room_stay_from":"2020-09-05","room_stay_to":"2020-09-08","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":"SJB12648069159","room_stay_from":"2020-06-01","room_stay_to":"2020-09-26","bundle_room":"0"},{"confirmation_number":"SJB12692649973","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":"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":"3135089","reservation_id":"100008","confirmation_number":"SJ12640873135","room_stay_from":"2020-09-05","room_stay_to":"2020-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00","nightly_discount":"0.00,0.00,0","subtotal":"297.00","grand_total":"334.13","paid_amount":"334.13","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":"106014","customer_id":"106014","source_of_creation":"PMS","reservation_created_date":"2020-09-05 13:32:46","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"99.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":"3133526","reservation_id":"99895","confirmation_number":"SJ12635739419","room_stay_from":"2020-09-03","room_stay_to":"2020-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"42.90,42.85,42.85,42.85,42.85,42.85,42.85","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"300.00","grand_total":"337.50","paid_amount":"337.50","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":"105898","customer_id":"105898","source_of_creation":"PMS","reservation_created_date":"2020-09-02 20:58:32","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":"42.85","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.71","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":"3135092","reservation_id":"100008","confirmation_number":"SJ12636271340","room_confirmation_number":"SJ12640873135","room_stay_from":"2020-09-05","room_stay_to":"2020-09-08","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":"106014","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-05 13:32:46","reservation_modified_date_time":"2020-09-07 15:21:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106014","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To 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":"3133527","reservation_id":"99895","confirmation_number":"SJ12674147118","room_confirmation_number":"SJ12635739419","room_stay_from":"2020-09-03","room_stay_to":"2020-09-10","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":"105898","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-02 20:58:32","reservation_modified_date_time":"2020-09-02 20:58:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105898","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":[]}}