{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-06-05","total_rooms_exist":"1281,1282,1289,1274,1275,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":3,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1756,1307,1943,1297,1275","block_room_bookings":[{"confirmation_number":"SJ12655799357","room_stay_from":"2020-06-05","room_stay_to":"2020-06-11","bundle_room":"0"},{"confirmation_number":"SJ12664166752","room_stay_from":"2020-06-01","room_stay_to":"2020-06-12","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-04","room_stay_to":"2020-06-12","bundle_room":"0"},{"confirmation_number":"SJ12640607785","room_stay_from":"2020-06-04","room_stay_to":"2020-06-12","bundle_room":"0"},{"confirmation_number":"SJ12688349245","room_stay_from":"2020-06-05","room_stay_to":"2020-06-12","bundle_room":"0"}],"bundle_block_count":"1267,1268,1262,1263,1269,1270,1309,1310,1260,1261,1302,1303,1307,1308,1304,1305","bundle_block_bookings":[{"confirmation_number":"SJB12659092298","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","bundle_room":"1"},{"confirmation_number":"SJB12633328255","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","bundle_room":"1"},{"confirmation_number":"SJB12692724434","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","bundle_room":"1"},{"confirmation_number":"SJB12683342769","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","bundle_room":"1"},{"confirmation_number":"SJB12656175986","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","bundle_room":"0"},{"confirmation_number":"SJB12696759164","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","bundle_room":"0"},{"confirmation_number":"SJB12632318824","room_stay_from":"2020-06-05","room_stay_to":"2020-06-07","bundle_room":"1"},{"confirmation_number":"SJB12699752246","room_stay_from":"2020-06-01","room_stay_to":"2020-06-07","bundle_room":"1"},{"confirmation_number":"SJB12613178934","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3100090","reservation_id":"95740","confirmation_number":"SJ12629605329","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"159.6","nightly_discount":"0","subtotal":"159.60","grand_total":"179.55","paid_amount":"179.55","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-2832655434","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101909","customer_id":"101909","source_of_creation":"Booking.com","reservation_created_date":"2020-06-01 13:46:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"42.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"159.6","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":"3100151","reservation_id":"95792","confirmation_number":"SJ12628968764","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.60","nightly_discount":"0","subtotal":"209.60","grand_total":"235.80","paid_amount":"235.80","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-2926571841","collect_which":"hotel_collect","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":"101958","customer_id":"101958","source_of_creation":"Booking.com","reservation_created_date":"2020-06-02 04:30:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"42.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"209.60","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":"3101345","reservation_id":"95929","confirmation_number":"SJ12688082903","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"159.6","nightly_discount":"0","subtotal":"159.60","grand_total":"179.55","paid_amount":"179.55","room_type_id":"413","product_id":"1262","siteminder_id":"BDC-2355435652","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102073","customer_id":"102073","source_of_creation":"Booking.com","reservation_created_date":"2020-06-05 02:06:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"42.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"159.6","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":"3101799","reservation_id":"95975","confirmation_number":"SJ12616475590","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.60","nightly_discount":"0","subtotal":"209.60","grand_total":"235.80","paid_amount":"235.80","room_type_id":"413","product_id":"1269","siteminder_id":"BDC-3812685206","collect_which":"hotel_collect","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":"102112","customer_id":"102112","source_of_creation":"Booking.com","reservation_created_date":"2020-06-06 01:31:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"42.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"209.60","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":"3097875","reservation_id":"95395","confirmation_number":"SJ12689105696","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"192.00,258.40,258.40","nightly_discount":"0,0,0","subtotal":"708.80","grand_total":"797.40","paid_amount":"797.40","room_type_id":"319","product_id":"1309","siteminder_id":"BDC-3059293152","collect_which":"hotel_collect","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":"101589","customer_id":"101589","source_of_creation":"Booking.com","reservation_created_date":"2020-05-25 20:58:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"141.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"258.40","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":"3100737","reservation_id":"95699","confirmation_number":"SJ12669369263","room_stay_from":"2020-06-05","room_stay_to":"2020-06-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"284.00,284.00","nightly_discount":"0,0","subtotal":"568.00","grand_total":"639.00","paid_amount":"639.00","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3059309603","collect_which":"hotel_collect","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":"101878","customer_id":"101878","source_of_creation":"Booking.com","reservation_created_date":"2020-05-31 17:42:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"111.24","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"284.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":"3101159","reservation_id":"94988","confirmation_number":"SJ12635838723","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.20,119.20,119.20","nightly_discount":"0.00,0.00,0.00","subtotal":"341.60","grand_total":"384.30","paid_amount":"384.30","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-2196238555","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101181","customer_id":"101181","source_of_creation":"Booking.com","reservation_created_date":"2020-05-18 21:59:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"74.99","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.20","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":"3101537","reservation_id":"95942","confirmation_number":"SJ12625520719","room_stay_from":"2020-06-05","room_stay_to":"2020-06-07","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"184.6,184.6","nightly_discount":"0,0","subtotal":"369.20","grand_total":"415.35","paid_amount":"415.35","room_type_id":"319","product_id":"1308","siteminder_id":"BDC-3657893085","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102085","customer_id":"102085","source_of_creation":"Booking.com","reservation_created_date":"2020-06-05 13:58:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"84.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"184.6","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":"3099341","reservation_id":"95679","confirmation_number":"SJ12615614330","room_stay_from":"2020-06-05","room_stay_to":"2020-06-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"209.60,209.60,164.80,150.40","nightly_discount":"0,0,0,0","subtotal":"734.40","grand_total":"826.20","paid_amount":"826.20","room_type_id":"413","product_id":"1267","siteminder_id":"BDC-2572206993","collect_which":"hotel_collect","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":"101855","customer_id":"101855","source_of_creation":"Booking.com","reservation_created_date":"2020-05-31 13:14:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"150.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"209.60","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":"3101802","reservation_id":"95513","confirmation_number":"SJ12666984154","room_stay_from":"2020-08-09","room_stay_to":"2020-08-14","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"76,73,68,68,68","nightly_discount":"0,0,0,0,0","subtotal":"353.00","grand_total":"397.13","paid_amount":"82.13","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-2637477156","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"250.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101701","customer_id":"101701","source_of_creation":"Booking.com","reservation_created_date":"2020-05-27 22:20:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"131.05","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3096702","reservation_id":"95210","confirmation_number":"SJ12624310346","room_stay_from":"2020-06-03","room_stay_to":"2020-06-06","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"131.8,131.8,152.6","nightly_discount":"0,0,0","subtotal":"416.20","grand_total":"468.23","paid_amount":"468.23","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1665249631","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101478","customer_id":"101478","source_of_creation":"Expedia","reservation_created_date":"2020-05-21 22:07:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"152.6","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":"3101614","reservation_id":"95961","confirmation_number":"SJ12640439702","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.68","nightly_discount":"0","subtotal":"167.68","grand_total":"188.64","paid_amount":"188.64","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1668316012","collect_which":"channel_collect","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":"102096","customer_id":"102096","source_of_creation":"Expedia","reservation_created_date":"2020-06-05 20:02:05","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"167.68","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":"3100191","reservation_id":"95072","confirmation_number":"SJ12652394185","room_stay_from":"2020-06-05","room_stay_to":"2020-06-07","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"95.36,95.36","nightly_discount":"0,0","subtotal":"190.72","grand_total":"214.56","paid_amount":"214.56","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1664880717","collect_which":"channel_collect","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":"101255","customer_id":"101255","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 21:12:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.36","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":"3101447","reservation_id":"94966","confirmation_number":"SJ12641622681","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.56,95.36,95.36","nightly_discount":"0.00,0.00,0.00","subtotal":"273.28","grand_total":"307.44","paid_amount":"335.57","room_type_id":"319","product_id":"1304","siteminder_id":"EXP-1664657809","collect_which":"channel_collect","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":"101153","customer_id":"101153","source_of_creation":"Expedia","reservation_created_date":"2020-05-18 16:42:04","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.36","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":"3101560","reservation_id":"94962","confirmation_number":"SJ12665742362","room_stay_from":"2020-06-05","room_stay_to":"2020-06-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.36,95.36","nightly_discount":"0,0","subtotal":"190.72","grand_total":"214.56","paid_amount":"214.56","room_type_id":"319","product_id":"1305","siteminder_id":"EXP-1664653187","collect_which":"channel_collect","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":"101151","customer_id":"101151","source_of_creation":"Expedia","reservation_created_date":"2020-05-18 16:11:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"38.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.36","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":"3099869","reservation_id":"95071","confirmation_number":"SJ12617748076","room_stay_from":"2020-06-01","room_stay_to":"2020-06-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.20,103.20,103.20,103.20,119.20,119.20,103.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"754.40","grand_total":"848.70","paid_amount":"848.70","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1664879527","collect_which":"hotel_collect","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":"101254","customer_id":"101254","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 21:07:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.20","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":"3100183","reservation_id":"95073","confirmation_number":"SJ12656674634","room_stay_from":"2020-06-05","room_stay_to":"2020-06-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.36,95.36,82.56","nightly_discount":"0,0,0","subtotal":"273.28","grand_total":"307.44","paid_amount":"307.44","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1664882286","collect_which":"channel_collect","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":"101256","customer_id":"101256","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 21:22:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.36","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":"3101420","reservation_id":"93945","confirmation_number":"SJ12658919177","room_stay_from":"2020-06-05","room_stay_to":"2020-06-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"170.2,170.2,146.2","nightly_discount":"0,0,0","subtotal":"486.60","grand_total":"547.43","paid_amount":"547.43","room_type_id":"319","product_id":"1303","siteminder_id":"EXP-1661270183","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100186","customer_id":"100186","source_of_creation":"Expedia","reservation_created_date":"2020-04-18 18:31:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"170.2","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":"3101430","reservation_id":"93944","confirmation_number":"SJ12621899156","room_stay_from":"2020-06-05","room_stay_to":"2020-06-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"170.2,170.2,146.2","nightly_discount":"0,0,0","subtotal":"486.60","grand_total":"547.43","paid_amount":"547.43","room_type_id":"319","product_id":"1302","siteminder_id":"EXP-1661270182","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100185","customer_id":"100185","source_of_creation":"Expedia","reservation_created_date":"2020-04-18 18:31:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"170.2","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":"3101606","reservation_id":"95038","confirmation_number":"SJ12667730707","room_stay_from":"2020-06-06","room_stay_to":"2020-06-07","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.00","nightly_discount":"0.00","subtotal":"195.00","grand_total":"219.38","paid_amount":"28.13","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1664815633","collect_which":"channel_collect","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":"101226","customer_id":"101226","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 14:26:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","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,"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"}]}],"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":"3101608","reservation_id":"95959","confirmation_number":"SJ12651999913","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.00","nightly_discount":"0.00","subtotal":"195.00","grand_total":"219.38","paid_amount":"219.38","room_type_id":"319","product_id":"1306","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":"101226","customer_id":"101226","source_of_creation":"PMS","reservation_created_date":"2020-06-05 19:28:47","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"195.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":"3101650","reservation_id":"95964","confirmation_number":"SJ12618336205","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.00","nightly_discount":"0.00","subtotal":"202.00","grand_total":"227.25","paid_amount":"227.25","room_type_id":"319","product_id":"1917","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":"102100","customer_id":"102100","source_of_creation":"PMS","reservation_created_date":"2020-06-05 21:11:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"202.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":"3101834","reservation_id":"95980","confirmation_number":"SJ12692128447","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"267.73","nightly_discount":"150.00","subtotal":"267.73","grand_total":"132.45","paid_amount":"132.45","room_type_id":"319","product_id":"1274","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":"102118","customer_id":"102118","source_of_creation":"PMS","reservation_created_date":"2020-06-06 03:19:43","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"267.73","currentDayDiscount":"150.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":"3100098","reservation_id":"95780","confirmation_number":"SJ12620269196","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"4","nightly_price":"320.90,451.64,451.64","nightly_discount":"0.00,0.00,0.00","subtotal":"1224.18","grand_total":"1377.20","paid_amount":"1377.20","room_type_id":"320","product_id":"1320","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":"101947","customer_id":"101947","source_of_creation":"PMS","reservation_created_date":"2020-06-01 23:49:57","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"451.64","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":"3099951","reservation_id":"89559","confirmation_number":"SJ12692018262","room_stay_from":"2020-06-01","room_stay_to":"2020-06-07","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1913","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":"82876","customer_id":"82876","source_of_creation":"PMS","reservation_created_date":"2020-01-08 15:07:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","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":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":[{"room_stay_id":"3096700","reservation_id":"95210","confirmation_number":"SJ12634928598","room_confirmation_number":"SJ12624310346","room_stay_from":"2020-06-03","room_stay_to":"2020-06-06","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"101478","product_attribute_values":"extra_person#.00","reservation_created_date":"2020-05-21 22:07:07","reservation_modified_date_time":"2020-05-23 18:07:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101478","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.00","currentDayPrice":"25","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":"3100093","reservation_id":"95740","confirmation_number":"SJ12624335767","room_confirmation_number":"SJ12629605329","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"101909","product_attribute_values":"extra_person#","reservation_created_date":"2020-06-01 23:44:10","reservation_modified_date_time":"2020-06-01 23:44:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101909","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","currentDayPrice":"50","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":"3101346","reservation_id":"95929","confirmation_number":"SJ12682212376","room_confirmation_number":"SJ12688082903","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"102073","product_attribute_values":"extra_person#.00","reservation_created_date":"2020-06-05 02:06:08","reservation_modified_date_time":"2020-06-05 02:06:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102073","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","currentDayPrice":"50","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":"3101538","reservation_id":"95942","confirmation_number":"SJ12683888147","room_confirmation_number":"SJ12625520719","room_stay_from":"2020-06-05","room_stay_to":"2020-06-07","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"102085","product_attribute_values":"extra_person#","reservation_created_date":"2020-06-05 15:02:02","reservation_modified_date_time":"2020-06-05 15:02:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102085","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","currentDayPrice":"25","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":"3101422","reservation_id":"93945","confirmation_number":"SJ12620427232","room_confirmation_number":"SJ12658919177","room_stay_from":"2020-06-05","room_stay_to":"2020-06-08","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"100186","product_attribute_values":"extra_person#","reservation_created_date":"2020-06-05 13:15:17","reservation_modified_date_time":"2020-06-05 13:15:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100186","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.00","currentDayPrice":"25","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":"3101432","reservation_id":"93944","confirmation_number":"SJ12612293856","room_confirmation_number":"SJ12621899156","room_stay_from":"2020-06-05","room_stay_to":"2020-06-08","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"100185","product_attribute_values":"extra_person#","reservation_created_date":"2020-06-05 13:15:44","reservation_modified_date_time":"2020-06-05 13:15:44","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100185","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.00","currentDayPrice":"25","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3096701","reservation_id":"95210","confirmation_number":"SJ12662971396","room_confirmation_number":"SJ12624310346","room_stay_from":"2020-06-03","room_stay_to":"2020-06-06","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":"101478","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-21 22:07:07","reservation_modified_date_time":"2020-05-23 18:07:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101478","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.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":"3100094","reservation_id":"95740","confirmation_number":"SJ12627914852","room_confirmation_number":"SJ12629605329","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"101909","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-01 13:46:08","reservation_modified_date_time":"2020-06-01 23:44:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101909","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3100152","reservation_id":"95792","confirmation_number":"SJ12627268859","room_confirmation_number":"SJ12628968764","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"101958","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-02 04:30:11","reservation_modified_date_time":"2020-06-02 04:30:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101958","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":"3101347","reservation_id":"95929","confirmation_number":"SJ12642896297","room_confirmation_number":"SJ12688082903","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"102073","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-05 02:06:08","reservation_modified_date_time":"2020-06-05 02:06:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102073","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3101609","reservation_id":"95959","confirmation_number":"SJ12691455802","room_confirmation_number":"SJ12651999913","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"101226","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-05 19:28:47","reservation_modified_date_time":"2020-06-05 19:28:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101226","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":"3101615","reservation_id":"95961","confirmation_number":"SJ12646291368","room_confirmation_number":"SJ12640439702","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"102096","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-05 20:02:05","reservation_modified_date_time":"2020-06-05 20:02:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102096","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":"3101651","reservation_id":"95964","confirmation_number":"SJ12621501009","room_confirmation_number":"SJ12618336205","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"102100","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-05 21:11:15","reservation_modified_date_time":"2020-06-05 21:11:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102100","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":"3101800","reservation_id":"95975","confirmation_number":"SJ12687504861","room_confirmation_number":"SJ12616475590","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"102112","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-06 01:31:06","reservation_modified_date_time":"2020-06-06 01:31:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102112","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":"3101835","reservation_id":"95980","confirmation_number":"SJ12620656884","room_confirmation_number":"SJ12692128447","room_stay_from":"2020-06-05","room_stay_to":"2020-06-06","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"102118","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-06 03:19:43","reservation_modified_date_time":"2020-06-06 03:19:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102118","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":"3097877","reservation_id":"95395","confirmation_number":"SJ12669617653","room_confirmation_number":"SJ12689105696","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","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":"101589","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-25 20:58:11","reservation_modified_date_time":"2020-05-27 12:03:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101589","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":"3099952","reservation_id":"89559","confirmation_number":"SJ12657967662","room_confirmation_number":"SJ12692018262","room_stay_from":"2020-06-01","room_stay_to":"2020-06-07","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"95540","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-08 15:07:14","reservation_modified_date_time":"2020-06-01 19:26:12","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82876","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":"3100099","reservation_id":"95780","confirmation_number":"SJ12656771074","room_confirmation_number":"SJ12620269196","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","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":"101947","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-01 23:49:57","reservation_modified_date_time":"2020-06-01 23:49:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101947","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":"3100193","reservation_id":"95072","confirmation_number":"SJ12654600515","room_confirmation_number":"SJ12652394185","room_stay_from":"2020-06-05","room_stay_to":"2020-06-07","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"101255","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-19 21:12:10","reservation_modified_date_time":"2020-06-02 12:52:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101255","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":"3100738","reservation_id":"95699","confirmation_number":"SJ12672394607","room_confirmation_number":"SJ12669369263","room_stay_from":"2020-06-05","room_stay_to":"2020-06-07","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"101878","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-31 17:42:09","reservation_modified_date_time":"2020-06-03 19:25:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101878","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":"3101160","reservation_id":"94988","confirmation_number":"SJ12697357165","room_confirmation_number":"SJ12635838723","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","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":"101181","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-18 21:59:08","reservation_modified_date_time":"2020-06-04 17:45:52","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101181","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.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":"3101449","reservation_id":"94966","confirmation_number":"SJ12625531883","room_confirmation_number":"SJ12641622681","room_stay_from":"2020-06-04","room_stay_to":"2020-06-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"25.00,0.00,0.00","subtotal":"75.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"101153","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-18 16:42:04","reservation_modified_date_time":"2020-06-05 13:53:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"Nightly price or discount changed","deltaChange":"-25.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":"3101539","reservation_id":"95942","confirmation_number":"SJ12652119636","room_confirmation_number":"SJ12625520719","room_stay_from":"2020-06-05","room_stay_to":"2020-06-07","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"102085","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-05 13:58:11","reservation_modified_date_time":"2020-06-05 15:02:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102085","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3101561","reservation_id":"94962","confirmation_number":"SJ12697563210","room_confirmation_number":"SJ12665742362","room_stay_from":"2020-06-05","room_stay_to":"2020-06-07","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"101151","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-18 16:11:05","reservation_modified_date_time":"2020-06-05 16:06:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101151","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":"3099872","reservation_id":"95071","confirmation_number":"SJ12614827490","room_confirmation_number":"SJ12617748076","room_stay_from":"2020-06-01","room_stay_to":"2020-06-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"101254","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-19 21:07:08","reservation_modified_date_time":"2020-06-01 17:24:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101254","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":"3100184","reservation_id":"95073","confirmation_number":"SJ12692884986","room_confirmation_number":"SJ12656674634","room_stay_from":"2020-06-05","room_stay_to":"2020-06-08","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":"101256","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-19 21:22:09","reservation_modified_date_time":"2020-06-02 12:51:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101256","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":"3101424","reservation_id":"93945","confirmation_number":"SJ12680042596","room_confirmation_number":"SJ12658919177","room_stay_from":"2020-06-05","room_stay_to":"2020-06-08","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":"100186","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-04-18 18:31:14","reservation_modified_date_time":"2020-06-05 13:15:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100186","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.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":"3101433","reservation_id":"93944","confirmation_number":"SJ12676097941","room_confirmation_number":"SJ12621899156","room_stay_from":"2020-06-05","room_stay_to":"2020-06-08","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":"100185","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-04-18 18:31:09","reservation_modified_date_time":"2020-06-05 13:15:44","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100185","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.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":"3099342","reservation_id":"95679","confirmation_number":"SJ12619664420","room_confirmation_number":"SJ12615614330","room_stay_from":"2020-06-05","room_stay_to":"2020-06-09","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"101855","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-31 13:14:10","reservation_modified_date_time":"2020-05-31 13:14:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101855","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":"3101804","reservation_id":"95513","confirmation_number":"SJ12671992182","room_confirmation_number":"SJ12666984154","room_stay_from":"2020-08-09","room_stay_to":"2020-08-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101701","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-27 22:20:08","reservation_modified_date_time":"2020-06-06 01:40:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101701","canceled_nights_data":"","posAmt_airbnb_taxpaid":"250.00","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"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":"3101607","reservation_id":"95038","confirmation_number":"SJ12696588031","room_confirmation_number":"SJ12667730707","room_stay_from":"2020-06-06","room_stay_to":"2020-06-07","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101226","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-19 14:26:07","reservation_modified_date_time":"2020-06-05 19:25:55","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101226","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3101673","reservation_id":"95071","confirmation_number":"SJ12621269812","room_confirmation_number":"SJ12617748076","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"232.56","grand_total":"250.00","paid_amount":"250.00","product_id":"1704","service_quantity":"1","product_name":"Pet Penalty","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-05 22:01:13","reservation_modified_date_time":"2020-06-05 22:01:13","customer_id":"101254","parentCustTravId":"101254","customer_traveller_id":"101254","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"232.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}