{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-06-23","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":7,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1274,1305,1943,1307","block_room_bookings":[{"confirmation_number":"SJ12632755958","room_stay_from":"2020-06-23","room_stay_to":"2020-06-25","bundle_room":"0"},{"confirmation_number":"SJ12612307368","room_stay_from":"2020-06-15","room_stay_to":"2020-07-01","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-04","room_stay_to":"2020-07-10","bundle_room":"0"},{"confirmation_number":"SJ12664166752","room_stay_from":"2020-06-07","room_stay_to":"2020-07-11","bundle_room":"0"}],"bundle_block_count":"1267,1268,1304,1305,1309,1310,1262,1263,1307,1308,1291,1711,1302,1303","bundle_block_bookings":[{"confirmation_number":"SJB12656391722","room_stay_from":"2020-06-21","room_stay_to":"2020-06-24","bundle_room":"1"},{"confirmation_number":"SJB12667132276","room_stay_from":"2020-06-22","room_stay_to":"2020-06-24","bundle_room":"1"},{"confirmation_number":"SJB12683527831","room_stay_from":"2020-06-21","room_stay_to":"2020-06-25","bundle_room":"1"},{"confirmation_number":"SJB12683835634","room_stay_from":"2020-06-22","room_stay_to":"2020-06-25","bundle_room":"1"},{"confirmation_number":"SJB12639614415","room_stay_from":"2020-06-21","room_stay_to":"2020-06-26","bundle_room":"1"},{"confirmation_number":"SJB12640781917","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","bundle_room":"1"},{"confirmation_number":"SJB12670942263","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3108339","reservation_id":"96379","confirmation_number":"SJ12683550350","room_stay_from":"2020-06-21","room_stay_to":"2020-06-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"311.20,272.00,251.20","nightly_discount":"0.00,0.00,0.00","subtotal":"834.40","grand_total":"938.70","paid_amount":"938.70","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-2289438337","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":"102487","customer_id":"102487","source_of_creation":"Booking.com","reservation_created_date":"2020-06-12 20:29:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"163.69","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"251.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3109093","reservation_id":"95993","confirmation_number":"SJ12677844021","room_stay_from":"2020-06-21","room_stay_to":"2020-06-24","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.84,131.84,120.32","nightly_discount":"0,0,0","subtotal":"384.00","grand_total":"432.00","paid_amount":"432.00","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1668491986","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":"103036","customer_id":"103036","source_of_creation":"Expedia","reservation_created_date":"2020-06-06 15:11:07","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":"120.32","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":"3109095","reservation_id":"95994","confirmation_number":"SJ12654465938","room_stay_from":"2020-06-21","room_stay_to":"2020-06-24","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.84,131.84,120.32","nightly_discount":"0,0,0","subtotal":"384.00","grand_total":"432.00","paid_amount":"432.00","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1668491987","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":"103036","customer_id":"102800","source_of_creation":"Expedia","reservation_created_date":"2020-06-06 15:11:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.32","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":"3107408","reservation_id":"94983","confirmation_number":"SJ12686725295","room_stay_from":"2020-06-21","room_stay_to":"2020-06-25","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","nightly_discount":"0,0,0,0","subtotal":"412.80","grand_total":"464.40","paid_amount":"464.40","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1664694924","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":"101176","customer_id":"101176","source_of_creation":"Expedia","reservation_created_date":"2020-05-18 20:26:10","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":"103.20","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":"3108503","reservation_id":"96265","confirmation_number":"SJ12682545601","room_stay_from":"2020-06-22","room_stay_to":"2020-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.28,133.12,133.12","nightly_discount":"0,0,0","subtotal":"411.52","grand_total":"462.96","paid_amount":"462.96","room_type_id":"319","product_id":"1942","siteminder_id":"EXP-1669661421","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":"102386","customer_id":"102386","source_of_creation":"Expedia","reservation_created_date":"2020-06-10 23:57:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"133.12","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":"3108523","reservation_id":"94998","confirmation_number":"SJ12647174843","room_stay_from":"2020-06-22","room_stay_to":"2020-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"98.48,98.48,98.48","nightly_discount":"0.00,0.00,0.00","subtotal":"295.44","grand_total":"332.37","paid_amount":"332.37","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1664720132","collect_which":"channel_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":"101191","customer_id":"101191","source_of_creation":"Expedia","reservation_created_date":"2020-05-18 22:51:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"98.48","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"}]}],"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":[{"room_stay_id":"3095067","reservation_id":"95032","confirmation_number":"SJ12663544214","room_stay_from":"2020-06-20","room_stay_to":"2020-06-27","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,103.20,103.20,103.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"722.40","grand_total":"812.70","paid_amount":"812.70","room_type_id":"413","product_id":"1265","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":"101221","customer_id":"101221","source_of_creation":"FE","reservation_created_date":"2020-05-19 12:57:54","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103.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":"3099725","reservation_id":"94939","confirmation_number":"SJ12682977632","room_stay_from":"2020-06-21","room_stay_to":"2020-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,119.20,119.20,119.20,119.20,119.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"715.20","grand_total":"804.60","paid_amount":"804.60","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"85255","customer_id":"85255","source_of_creation":"FE","reservation_created_date":"2020-05-18 03:47:56","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":"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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3108716","reservation_id":"95963","confirmation_number":"SJ12612428077","room_stay_from":"2020-06-22","room_stay_to":"2020-06-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.78,150.89","nightly_discount":"16.18,15.09","subtotal":"312.67","grand_total":"316.58","paid_amount":"182.00","room_type_id":"412","product_id":"1315","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":"102097","customer_id":"102097","source_of_creation":"PMS","reservation_created_date":"2020-06-05 20:44:40","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"150.89","currentDayDiscount":"15.09","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":"3108915","reservation_id":"96962","confirmation_number":"SJ12659351542","room_stay_from":"2020-06-22","room_stay_to":"2020-06-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"268.23,268.23","nightly_discount":"0.00,0","subtotal":"536.46","grand_total":"603.51","paid_amount":"603.51","room_type_id":"319","product_id":"1318","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":"103086","customer_id":"103086","source_of_creation":"PMS","reservation_created_date":"2020-06-22 22:12:04","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"268.23","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":"3108648","reservation_id":"96936","confirmation_number":"SJ12623038950","room_stay_from":"2020-06-22","room_stay_to":"2020-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"198.56,180.51,198.56","nightly_discount":"0.00,0.00,0.00","subtotal":"577.63","grand_total":"649.83","paid_amount":"649.83","room_type_id":"413","product_id":"1262","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":"103058","customer_id":"103058","source_of_creation":"PMS","reservation_created_date":"2020-06-22 15:53:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"180.51","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":"3108651","reservation_id":"96936","confirmation_number":"SJ12679855470","room_stay_from":"2020-06-22","room_stay_to":"2020-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"198.56,180.51,198.56","nightly_discount":"0.00,0.00,0.00","subtotal":"577.63","grand_total":"649.83","paid_amount":"649.83","room_type_id":"413","product_id":"1263","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":"103058","customer_id":"103058","source_of_creation":"PMS","reservation_created_date":"2020-06-22 15:53:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"180.51","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":"3106993","reservation_id":"96437","confirmation_number":"SJ12670763368","room_stay_from":"2020-06-21","room_stay_to":"2020-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"232.66,203.86,185.33,185.33,185.33,251.51","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1244.02","grand_total":"1399.52","paid_amount":"1399.52","room_type_id":"319","product_id":"1288","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":"84466","customer_id":"84466","source_of_creation":"PMS","reservation_created_date":"2020-06-13 18:13:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"185.33","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":"3109068","reservation_id":"96543","confirmation_number":"SJ12616896695","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.58,103.57,103.57,103.57,103.57,103.57,103.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"725.00","grand_total":"725.00","paid_amount":"0.00","room_type_id":"319","product_id":"1303","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":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-15 15:30:39","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":"103.57","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"}]},{"room_stay_id":"3109072","reservation_id":"96542","confirmation_number":"SJ12694445048","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.58,103.57,103.57,103.57,103.57,103.57,103.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"725.00","grand_total":"725.00","paid_amount":"0.00","room_type_id":"319","product_id":"1309","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":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-15 15:25:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103.57","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"}]},{"room_stay_id":"3109074","reservation_id":"96929","confirmation_number":"SJ12688032336","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.57,103.57,103.57,103.57,103.57,103.57,103.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"725.00","grand_total":"725.00","paid_amount":"0.00","room_type_id":"319","product_id":"1310","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":"103049","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-22 04:22:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"32.14","currentDayPrice":"103.57","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":[{"room_stay_id":"3108893","reservation_id":"96323","confirmation_number":"SJ12634476011","room_stay_from":"2020-06-22","room_stay_to":"2020-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"0.00","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-12 02:22:31","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.33","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"}]},{"room_stay_id":"3104198","reservation_id":"96312","confirmation_number":"SJ12642458919","room_stay_from":"2020-06-19","room_stay_to":"2020-06-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"319","product_id":"1308","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-12 01:54:43","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","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"}]},{"room_stay_id":"3108283","reservation_id":"96315","confirmation_number":"SJ12684993363","room_stay_from":"2020-06-21","room_stay_to":"2020-06-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.00","paid_amount":"140.63","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-12 02:00:40","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":"78.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"}]},{"room_stay_id":"3104196","reservation_id":"96311","confirmation_number":"SJ12640191172","room_stay_from":"2020-06-20","room_stay_to":"2020-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-12 01:52:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","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"}]},{"room_stay_id":"3097664","reservation_id":"95422","confirmation_number":"SJ12681033452","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"319","product_id":"1711","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-26 16:19:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","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"}]},{"room_stay_id":"3097667","reservation_id":"95423","confirmation_number":"SJ12669328888","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"319","product_id":"1291","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-26 16:20:36","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","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"}]},{"room_stay_id":"3109125","reservation_id":"95461","confirmation_number":"SJ12631856417","room_stay_from":"2020-06-22","room_stay_to":"2020-06-23","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00","nightly_discount":"0.00","subtotal":"78.00","grand_total":"78.00","paid_amount":"0.00","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-27 14:01:55","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3108517","reservation_id":"94998","confirmation_number":"SJ12683447570","room_confirmation_number":"SJ12647174843","room_stay_from":"2020-06-22","room_stay_to":"2020-06-25","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"101191","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-06-22 11:37:31","reservation_modified_date_time":"2020-06-22 11:37:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101191","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","currentDayPrice":"50","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3108341","reservation_id":"96379","confirmation_number":"SJ12698209285","room_confirmation_number":"SJ12683550350","room_stay_from":"2020-06-21","room_stay_to":"2020-06-24","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":"102487","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 20:29:09","reservation_modified_date_time":"2020-06-21 18:50:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102487","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":"3108717","reservation_id":"95963","confirmation_number":"SJ12681787478","room_confirmation_number":"SJ12612428077","room_stay_from":"2020-06-22","room_stay_to":"2020-06-24","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102097","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-05 20:44:40","reservation_modified_date_time":"2020-06-22 17:35:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102097","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":"3108916","reservation_id":"96962","confirmation_number":"SJ12628732969","room_confirmation_number":"SJ12659351542","room_stay_from":"2020-06-22","room_stay_to":"2020-06-24","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":"103086","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-22 22:12:04","reservation_modified_date_time":"2020-06-23 13:03:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103086","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"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":"3109092","reservation_id":"95993","confirmation_number":"SJ12675240941","room_confirmation_number":"SJ12677844021","room_stay_from":"2020-06-21","room_stay_to":"2020-06-24","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":"103036","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-06 15:11:07","reservation_modified_date_time":"2020-06-23 16:53:46","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103036","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":"3109094","reservation_id":"95994","confirmation_number":"SJ12648241434","room_confirmation_number":"SJ12654465938","room_stay_from":"2020-06-21","room_stay_to":"2020-06-24","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":"103036","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-06 15:11:11","reservation_modified_date_time":"2020-06-23 16:54:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102800","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":"3107409","reservation_id":"94983","confirmation_number":"SJ12672998203","room_confirmation_number":"SJ12686725295","room_stay_from":"2020-06-21","room_stay_to":"2020-06-25","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":"101176","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 20:26:10","reservation_modified_date_time":"2020-06-19 03:01:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101176","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":"3108502","reservation_id":"96265","confirmation_number":"SJ12698997142","room_confirmation_number":"SJ12682545601","room_stay_from":"2020-06-22","room_stay_to":"2020-06-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"102386","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-10 23:57:07","reservation_modified_date_time":"2020-06-22 11:12:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102386","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":"3108524","reservation_id":"94998","confirmation_number":"SJ12615680771","room_confirmation_number":"SJ12647174843","room_stay_from":"2020-06-22","room_stay_to":"2020-06-25","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":"101191","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 22:51:10","reservation_modified_date_time":"2020-06-22 11:38:39","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101191","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":"3108649","reservation_id":"96936","confirmation_number":"SJ12699626752","room_confirmation_number":"SJ12623038950","room_stay_from":"2020-06-22","room_stay_to":"2020-06-25","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":"103058","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-22 15:53:15","reservation_modified_date_time":"2020-06-22 15:53:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103058","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":"3108652","reservation_id":"96936","confirmation_number":"SJ12633150675","room_confirmation_number":"SJ12679855470","room_stay_from":"2020-06-22","room_stay_to":"2020-06-25","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":"103058","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-22 15:53:15","reservation_modified_date_time":"2020-06-22 15:53:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103058","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":"3108894","reservation_id":"96323","confirmation_number":"SJ12616557964","room_confirmation_number":"SJ12634476011","room_stay_from":"2020-06-22","room_stay_to":"2020-06-25","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102447","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 02:22:31","reservation_modified_date_time":"2020-06-23 02:46:17","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3104199","reservation_id":"96312","confirmation_number":"SJ12671714455","room_confirmation_number":"SJ12642458919","room_stay_from":"2020-06-19","room_stay_to":"2020-06-26","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102436","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 01:54:43","reservation_modified_date_time":"2020-06-12 01:54:43","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3108284","reservation_id":"96315","confirmation_number":"SJ12638626722","room_confirmation_number":"SJ12684993363","room_stay_from":"2020-06-21","room_stay_to":"2020-06-26","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":"102439","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 02:00:40","reservation_modified_date_time":"2020-06-21 16:40:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3095068","reservation_id":"95032","confirmation_number":"SJ12632742266","room_confirmation_number":"SJ12663544214","room_stay_from":"2020-06-20","room_stay_to":"2020-06-27","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":"101221","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 12:57:54","reservation_modified_date_time":"2020-05-19 12:57:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101221","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":"3099726","reservation_id":"94939","confirmation_number":"SJ12657345565","room_confirmation_number":"SJ12682977632","room_stay_from":"2020-06-21","room_stay_to":"2020-06-27","room_stay_status":"Active","nightly_price":"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","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"85255","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 03:47:56","reservation_modified_date_time":"2020-06-01 14:42:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85255","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":"3104197","reservation_id":"96311","confirmation_number":"SJ12664606097","room_confirmation_number":"SJ12640191172","room_stay_from":"2020-06-20","room_stay_to":"2020-06-27","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102435","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 01:52:25","reservation_modified_date_time":"2020-06-12 01:52:25","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3106994","reservation_id":"96437","confirmation_number":"SJ12687275233","room_confirmation_number":"SJ12670763368","room_stay_from":"2020-06-21","room_stay_to":"2020-06-27","room_stay_status":"Active","nightly_price":"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","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"84466","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-13 18:13:10","reservation_modified_date_time":"2020-06-18 11:30:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84466","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":"3097665","reservation_id":"95422","confirmation_number":"SJ12691430516","room_confirmation_number":"SJ12681033452","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101613","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 16:19:27","reservation_modified_date_time":"2020-05-26 16:19:27","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3097668","reservation_id":"95423","confirmation_number":"SJ12620136082","room_confirmation_number":"SJ12669328888","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101613","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 16:20:36","reservation_modified_date_time":"2020-05-26 16:20:36","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3109067","reservation_id":"96543","confirmation_number":"SJ12656129645","room_confirmation_number":"SJ12616896695","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","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":"102651","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 15:30:39","reservation_modified_date_time":"2020-06-23 16:29:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","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":"3109071","reservation_id":"96542","confirmation_number":"SJ12643915172","room_confirmation_number":"SJ12694445048","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","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":"102649","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 15:25:17","reservation_modified_date_time":"2020-06-23 16:29:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","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":"3109073","reservation_id":"96929","confirmation_number":"SJ12636441819","room_confirmation_number":"SJ12688032336","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","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":"103050","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-22 04:22:22","reservation_modified_date_time":"2020-06-23 16:29:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","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":"3109126","reservation_id":"95461","confirmation_number":"SJ12696473395","room_confirmation_number":"SJ12631856417","room_stay_from":"2020-06-22","room_stay_to":"2020-06-23","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":"101653","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 14:01:55","reservation_modified_date_time":"2020-06-23 18:38:51","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To 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":"3109320","reservation_id":"97013","confirmation_number":"SJ12669709283","room_confirmation_number":"SJ12698655214","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"93.02","grand_total":"100.00","paid_amount":"100.00","product_id":null,"service_quantity":"1","product_name":"Champagne - Paul & Geanna","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-23 23:28:44","reservation_modified_date_time":"2020-06-23 23:28:44","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"93.02","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3109344","reservation_id":"97024","confirmation_number":"SJ12669450470","room_confirmation_number":"SJ12655722799","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"1","product_name":"Face Mask","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-24 01:55:04","reservation_modified_date_time":"2020-06-24 01:55:04","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"9.30","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":[{"room_stay_id":"3109143","reservation_id":"94939","confirmation_number":"SJ12692144643","room_confirmation_number":"SJ12682977632","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"8.00","paid_amount":"8.00","product_id":"1663","service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-23 19:46:12","reservation_modified_date_time":"2020-06-23 19:46:12","customer_id":"85255","parentCustTravId":"85255","customer_traveller_id":"85255","static_pos_type":"drinks","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":"7.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3108935","reservation_id":"96979","confirmation_number":"SJ12661997109","room_confirmation_number":"SJ12686970708","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-23 14:02:04","reservation_modified_date_time":"2020-06-23 14:02:04","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3108949","reservation_id":"96983","confirmation_number":"SJ12658136135","room_confirmation_number":"SJ12670223689","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-23 14:13:34","reservation_modified_date_time":"2020-06-23 14:13:34","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3109345","reservation_id":"97024","confirmation_number":"SJ12627857793","room_confirmation_number":"SJ12655722799","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-24 01:55:04","reservation_modified_date_time":"2020-06-24 01:55:04","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}