{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-11-28","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":20,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1269,1270,1319,1274,1866,1307","block_room_bookings":[{"confirmation_number":"SJ12644557764","room_stay_from":"2020-11-28","room_stay_to":"2020-12-01","bundle_room":"0"},{"confirmation_number":"SJ12687263701","room_stay_from":"2020-11-28","room_stay_to":"2020-12-01","bundle_room":"0"},{"confirmation_number":"SJ12635186372","room_stay_from":"2020-11-28","room_stay_to":"2020-12-02","bundle_room":"0"},{"confirmation_number":"SJ12637317516","room_stay_from":"2020-11-28","room_stay_to":"2020-12-04","bundle_room":"0"},{"confirmation_number":"SJ12649223434","room_stay_from":"2020-11-28","room_stay_to":"2020-12-07","bundle_room":"0"},{"confirmation_number":"SJ12676533150","room_stay_from":"2020-08-07","room_stay_to":"2020-12-08","bundle_room":"0"}],"bundle_block_count":"1267,1268,1271,1272,1302,1303,1304,1305,1311,1312,1262,1263,1260,1261,1269,1270,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12613007913","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","bundle_room":"0"},{"confirmation_number":"SJB12674011811","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","bundle_room":"0"},{"confirmation_number":"SJB12632816756","room_stay_from":"2020-11-28","room_stay_to":"2020-11-29","bundle_room":"1"},{"confirmation_number":"SJB12617832059","room_stay_from":"2020-11-28","room_stay_to":"2020-11-29","bundle_room":"1"},{"confirmation_number":"SJB12621838896","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","bundle_room":"0"},{"confirmation_number":"SJB12678106402","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","bundle_room":"0"},{"confirmation_number":"SJB12674879335","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","bundle_room":"0"},{"confirmation_number":"SJB12630606141","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","bundle_room":"0"},{"confirmation_number":"SJB12679764312","room_stay_from":"2020-11-28","room_stay_to":"2020-11-29","bundle_room":"1"},{"confirmation_number":"SJB12656915720","room_stay_from":"2020-11-28","room_stay_to":"2020-11-30","bundle_room":"1"},{"confirmation_number":"SJB12676211954","room_stay_from":"2020-11-28","room_stay_to":"2020-12-01","bundle_room":"1"},{"confirmation_number":"SJB12641869279","room_stay_from":"2020-10-22","room_stay_to":"2020-12-08","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3159986","reservation_id":"103237","confirmation_number":"SJ12613253157","room_stay_from":"2020-11-28","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"220.58","nightly_discount":"0","subtotal":"220.58","grand_total":"248.15","paid_amount":"248.15","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-3225228139","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":"109402","customer_id":"109402","source_of_creation":"Booking.com","reservation_created_date":"2020-11-29 00:44:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"44.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"220.58","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":"3157470","reservation_id":"102493","confirmation_number":"SJ12612740853","room_stay_from":"2020-11-28","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"237.60","nightly_discount":"0","subtotal":"237.60","grand_total":"267.30","paid_amount":"267.30","room_type_id":"319","product_id":"1303","siteminder_id":"EXP-1715041527","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":"108656","customer_id":"108656","source_of_creation":"Expedia","reservation_created_date":"2020-11-10 16:14:07","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":"237.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":"3159293","reservation_id":"102451","confirmation_number":"SJ12663138692","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"316.08,316.08","nightly_discount":"0.00,0.00","subtotal":"632.16","grand_total":"711.18","paid_amount":"711.18","room_type_id":"320","product_id":"1329","siteminder_id":"EXP-1714602577","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":"108616","customer_id":"108616","source_of_creation":"Expedia","reservation_created_date":"2020-11-08 23:05:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"316.08","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":"3159310","reservation_id":"102561","confirmation_number":"SJ12672312108","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.18,255.18","nightly_discount":"0,0","subtotal":"510.36","grand_total":"574.16","paid_amount":"574.16","room_type_id":"320","product_id":"1332","siteminder_id":"EXP-1715455021","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":"108716","customer_id":"108716","source_of_creation":"Expedia","reservation_created_date":"2020-11-12 02:33:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"255.18","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":"3153041","reservation_id":"102401","confirmation_number":"SJ12668612670","room_stay_from":"2020-11-26","room_stay_to":"2020-11-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"162.56,188.16,188.16,143.36","nightly_discount":"0,0,0,0","subtotal":"682.24","grand_total":"767.52","paid_amount":"767.52","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1714340552","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":"108565","customer_id":"108565","source_of_creation":"Expedia","reservation_created_date":"2020-11-07 19:00:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"188.16","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":"3152863","reservation_id":"102389","confirmation_number":"SJ12687839488","room_stay_from":"2020-11-27","room_stay_to":"2020-12-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.20,235.20,179.20,179.20","nightly_discount":"0,0,0,0","subtotal":"828.80","grand_total":"932.40","paid_amount":"932.40","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1714291054","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":"108550","customer_id":"108550","source_of_creation":"Expedia","reservation_created_date":"2020-11-07 14:25:09","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":"235.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":"3100509","reservation_id":"95840","confirmation_number":"SJ12622883880","room_stay_from":"2020-11-25","room_stay_to":"2020-12-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.60,145.60,161.60,161.60,161.60,145.60,145.60,145.60,145.60","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"1358.40","grand_total":"1528.20","paid_amount":"1528.20","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1667650856","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":"109271","customer_id":"101997","source_of_creation":"Expedia","reservation_created_date":"2020-06-03 00:56:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"161.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3157437","reservation_id":"102828","confirmation_number":"SJ12651743416","room_stay_from":"2020-11-26","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.10,122.58,147.22","nightly_discount":"0,0,0","subtotal":"373.90","grand_total":"420.64","paid_amount":"420.64","room_type_id":"319","product_id":"1942","siteminder_id":"GAM-R2216915887","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":"108968","customer_id":"108968","source_of_creation":"Getaroom.com","reservation_created_date":"2020-11-19 01:12:10","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":"147.22","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":"3157988","reservation_id":"103070","confirmation_number":"SJ12643652076","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.06,149.06","nightly_discount":"0,0","subtotal":"298.12","grand_total":"335.39","paid_amount":"335.39","room_type_id":"413","product_id":"1264","siteminder_id":"GAM-R2223164214","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":"109204","customer_id":"109204","source_of_creation":"Getaroom.com","reservation_created_date":"2020-11-24 14:47:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.06","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":"3159287","reservation_id":"103198","confirmation_number":"SJ12635612987","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.06,149.06","nightly_discount":"0,0","subtotal":"298.12","grand_total":"335.39","paid_amount":"335.39","room_type_id":"413","product_id":"1266","siteminder_id":"GAM-R2226361178","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":"109350","customer_id":"109350","source_of_creation":"Getaroom.com","reservation_created_date":"2020-11-27 20:42:12","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":"149.06","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3156949","reservation_id":"102936","confirmation_number":"SJ12693163561","room_stay_from":"2020-11-25","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"99.00,99.00,129.00,129.00","nightly_discount":"0,0,0,0","subtotal":"456.00","grand_total":"513.00","paid_amount":"513.00","room_type_id":"413","product_id":"1271","siteminder_id":"HWR-302895558","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":"109065","customer_id":"109065","source_of_creation":"Hotwire","reservation_created_date":"2020-11-21 16:07:19","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.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":"3159374","reservation_id":"103122","confirmation_number":"SJ12690379704","room_stay_from":"2020-11-28","room_stay_to":"2020-11-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"129.00,99.00","nightly_discount":"0,0","subtotal":"228.00","grand_total":"256.50","paid_amount":"256.50","room_type_id":"319","product_id":"1275","siteminder_id":"HWR-302894672","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":"109262","customer_id":"109262","source_of_creation":"Hotwire","reservation_created_date":"2020-11-25 17:26:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.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"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3148861","reservation_id":"101949","confirmation_number":"SJ12687146944","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"335.38,335.38","nightly_discount":"0.00,0.00","subtotal":"670.76","grand_total":"754.61","paid_amount":"754.61","room_type_id":"320","product_id":"1322","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":"108070","customer_id":"108070","source_of_creation":"FE","reservation_created_date":"2020-10-26 13:05:38","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"335.38","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":"3156813","reservation_id":"102455","confirmation_number":"SJ12619839118","room_stay_from":"2020-11-27","room_stay_to":"2020-11-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.20,215.20,159.20","nightly_discount":"0.00,0.00,0.00","subtotal":"589.60","grand_total":"663.30","paid_amount":"663.30","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":"108621","customer_id":"108621","source_of_creation":"FE","reservation_created_date":"2020-11-09 02:33:07","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":"215.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":"3158253","reservation_id":"101983","confirmation_number":"SJ12625868045","room_stay_from":"2020-11-27","room_stay_to":"2020-11-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"207.20,207.20,159.20","nightly_discount":"0.00,0.00,0.00","subtotal":"573.60","grand_total":"645.30","paid_amount":"645.30","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":"108100","customer_id":"108100","source_of_creation":"FE","reservation_created_date":"2020-10-27 13:09: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":"","currentDayPrice":"207.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":"3157432","reservation_id":"102764","confirmation_number":"SJ12655604486","room_stay_from":"2020-11-26","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"183.20,215.20,215.20","nightly_discount":"0.00,0.00,0.00","subtotal":"613.60","grand_total":"690.30","paid_amount":"690.30","room_type_id":"413","product_id":"1272","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":"108905","customer_id":"108905","source_of_creation":"PMS","reservation_created_date":"2020-11-17 13:54:42","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"215.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":"3158201","reservation_id":"102900","confirmation_number":"SJ12615733455","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.60,173.60,173.60,173.60,173.60","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"868.00","grand_total":"976.50","paid_amount":"976.50","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":"102312","customer_id":"102312","source_of_creation":"PMS","reservation_created_date":"2020-11-20 19:39:11","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":"","currentDayPrice":"173.60","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":"3158857","reservation_id":"103154","confirmation_number":"SJ12656915594","room_stay_from":"2020-11-28","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.98","nightly_discount":"39.59","subtotal":"195.98","grand_total":"175.94","paid_amount":"175.94","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":"109303","customer_id":"109303","source_of_creation":"PMS","reservation_created_date":"2020-11-26 15:41:07","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":"195.98","currentDayDiscount":"39.59","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":"3158895","reservation_id":"102725","confirmation_number":"SJ12616705685","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"163.15,163.15","nightly_discount":"0.00,0.00","subtotal":"326.30","grand_total":"367.09","paid_amount":"367.09","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":"108868","customer_id":"108868","source_of_creation":"PMS","reservation_created_date":"2020-11-16 15:30:52","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":"163.15","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":"3159244","reservation_id":"103044","confirmation_number":"SJ12686924574","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"228.65,228.65","nightly_discount":"45.63,45.63","subtotal":"457.30","grand_total":"411.79","paid_amount":"411.79","room_type_id":"318","product_id":"1281","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":"107667","customer_id":"107667","source_of_creation":"PMS","reservation_created_date":"2020-11-23 22:54:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"228.65","currentDayDiscount":"45.63","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":"3159339","reservation_id":"102772","confirmation_number":"SJ12666758731","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.00,186.00","nightly_discount":"0.00,0.00","subtotal":"372.00","grand_total":"418.50","paid_amount":"418.50","room_type_id":"412","product_id":"1297","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":"108914","customer_id":"108914","source_of_creation":"PMS","reservation_created_date":"2020-11-17 16:42:09","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":"186.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":"3159366","reservation_id":"103203","confirmation_number":"SJ12650397536","room_stay_from":"2020-11-28","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"220.58","nightly_discount":"0.00","subtotal":"220.58","grand_total":"248.15","paid_amount":"248.15","room_type_id":"319","product_id":"1308","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":"109357","customer_id":"109357","source_of_creation":"PMS","reservation_created_date":"2020-11-27 23:31:10","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":"220.58","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":"3159372","reservation_id":"103189","confirmation_number":"SJ12672132857","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.65,228.65","nightly_discount":"0.00,0.00","subtotal":"457.30","grand_total":"514.47","paid_amount":"514.47","room_type_id":"319","product_id":"1916","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":"109360","customer_id":"109360","source_of_creation":"PMS","reservation_created_date":"2020-11-27 17:54:11","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":"228.65","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":"3159687","reservation_id":"103144","confirmation_number":"SJ12676274410","room_stay_from":"2020-11-25","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.20,183.20,215.20,215.20","nightly_discount":"0.00,0.00,0.00,0","subtotal":"828.80","grand_total":"932.40","paid_amount":"932.40","room_type_id":"318","product_id":"1289","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":"109296","customer_id":"109296","source_of_creation":"PMS","reservation_created_date":"2020-11-28 20:40:54","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Reservation created with partial past date","deltaChange":"613.60","currentDayPrice":"215.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":"3159377","reservation_id":"103204","confirmation_number":"SJ12615094624","room_stay_from":"2020-11-28","room_stay_to":"2020-11-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.15,109.85","nightly_discount":"0.00,0.00","subtotal":"313.00","grand_total":"352.13","paid_amount":"352.13","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":"109361","customer_id":"109361","source_of_creation":"PMS","reservation_created_date":"2020-11-28 00:02:05","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":"203.15","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":"3159689","reservation_id":"103144","confirmation_number":"SJ12696538752","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.20,215.20,215.20","nightly_discount":"0.00,0.00,0.00","subtotal":"613.60","grand_total":"690.30","paid_amount":"690.30","room_type_id":"319","product_id":"1287","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":"109296","customer_id":"109296","source_of_creation":"PMS","reservation_created_date":"2020-11-26 02:33:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","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":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":"3150556","reservation_id":"102139","confirmation_number":"SJ12651340546","room_stay_from":"2020-11-22","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.28,94.28,94.28,94.28,94.28,94.30,94.30","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"660.00","grand_total":"660.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":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-10-31 01:20:34","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":"94.30","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":"3150724","reservation_id":"101082","confirmation_number":"SJ12687744274","room_stay_from":"2020-11-27","room_stay_to":"2020-12-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"101.43,101.43,101.43,101.43,101.43,101.43,101.42","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"710.00","grand_total":"710.00","paid_amount":"0.00","room_type_id":"319","product_id":"1915","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":"106240","customer_id":"106240","source_of_creation":"PMS","reservation_created_date":"2020-10-02 22:52:53","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":"101.43","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":"3159481","reservation_id":"97902","confirmation_number":"SJ12694200498","room_stay_from":"2020-11-28","room_stay_to":"2020-12-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"705.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0,0,0","subtotal":"705.00","grand_total":"705.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":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-07-18 02:37:32","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":"","currentDayPrice":"705.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":"3080275","reservation_id":"91869","confirmation_number":"SJ12687873142","room_stay_from":"2020-11-28","room_stay_to":"2020-12-01","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"201.38","room_type_id":"319","product_id":"1302","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":"98015","customer_id":"98015","source_of_creation":"PMS","reservation_created_date":"2020-02-12 19:02:36","service_canceled_date_time":"2020-10-22 10:58:00","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"201.38","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3152264","reservation_id":"101750","confirmation_number":"SJ12669388318","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","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":"75.94","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-10-19 23:28:57","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.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":"3157960","reservation_id":"102754","confirmation_number":"SJ12695792026","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","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":"75.94","room_type_id":"319","product_id":"1943","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-11-17 01:29:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","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":"3158971","reservation_id":"103164","confirmation_number":"SJ12669460657","room_stay_from":"2020-11-26","room_stay_to":"2020-11-29","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":"45.57","room_type_id":"319","product_id":"1313","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-11-26 21:10:02","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","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":"3152282","reservation_id":"99188","confirmation_number":"SJ12669226988","room_stay_from":"2020-11-25","room_stay_to":"2020-11-30","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":"75.94","room_type_id":"413","product_id":"1260","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-08-17 20:34:25","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","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":"3158688","reservation_id":"99526","confirmation_number":"SJ12660750856","room_stay_from":"2020-11-25","room_stay_to":"2020-11-30","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":"75.94","room_type_id":"413","product_id":"1261","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-08-26 00:08:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","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":"3159360","reservation_id":"101751","confirmation_number":"SJ12655495721","room_stay_from":"2020-11-28","room_stay_to":"2020-12-03","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":"75.94","room_type_id":"319","product_id":"1286","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-10-19 23:44:50","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":"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":"3159948","reservation_id":"96772","confirmation_number":"SJ12667347340","room_stay_from":"2020-10-07","room_stay_to":"2020-10-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.34","nightly_discount":"0.00,0.00,0.00","subtotal":"235.00","grand_total":"235.00","paid_amount":"235.00","room_type_id":"413","product_id":"1263","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-18 15:47:29","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":"","changedComment":"Nightly price or discount changed","deltaChange":"0.01","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"}]},{"room_stay_id":"3159951","reservation_id":"100944","confirmation_number":"SJ12637500962","room_stay_from":"2020-10-08","room_stay_to":"2020-10-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.34","nightly_discount":"0.00,0.00,0.00","subtotal":"235.00","grand_total":"235.00","paid_amount":"235.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":"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-09-28 23:19:51","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":"","changedComment":"Nightly price or discount changed","deltaChange":"0.01","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"}]},{"room_stay_id":"3159953","reservation_id":"98517","confirmation_number":"SJ12662091887","room_stay_from":"2020-10-15","room_stay_to":"2020-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.34","nightly_discount":"0.00,0.00,0.00","subtotal":"235.00","grand_total":"235.00","paid_amount":"235.00","room_type_id":"319","product_id":"1286","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-08-02 22:49:20","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":"","changedComment":"Nightly price or discount changed","deltaChange":"0.01","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"}]},{"room_stay_id":"3159956","reservation_id":"100946","confirmation_number":"SJ12625100864","room_stay_from":"2020-10-15","room_stay_to":"2020-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.34","nightly_discount":"0.00,0.00,0.00","subtotal":"235.00","grand_total":"235.00","paid_amount":"235.00","room_type_id":"319","product_id":"1302","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-09-28 23:31:40","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":"","changedComment":"Nightly price or discount changed","deltaChange":"0.01","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"}]},{"room_stay_id":"3159959","reservation_id":"99757","confirmation_number":"SJ12676431719","room_stay_from":"2020-10-16","room_stay_to":"2020-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.34","nightly_discount":"0.00,0.00,0.00","subtotal":"235.00","grand_total":"235.00","paid_amount":"235.00","room_type_id":"412","product_id":"1297","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-08-30 22:12:01","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":"","changedComment":"Nightly price or discount changed","deltaChange":"0.01","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"}]},{"room_stay_id":"3159966","reservation_id":"100950","confirmation_number":"SJ12647636254","room_stay_from":"2020-10-16","room_stay_to":"2020-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,101.84","nightly_discount":"0.00,0.00,0.00","subtotal":"258.50","grand_total":"258.50","paid_amount":"258.50","room_type_id":"319","product_id":"1306","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-09-28 23:58:39","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":"Nightly price or discount changed","deltaChange":"23.51","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"}]},{"room_stay_id":"3159968","reservation_id":"101745","confirmation_number":"SJ12668791130","room_stay_from":"2020-10-29","room_stay_to":"2020-11-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.34","nightly_discount":"0.00,0.00,0.00","subtotal":"235.00","grand_total":"235.00","paid_amount":"235.00","room_type_id":"319","product_id":"1287","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-10-19 23:16:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"0.01","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"}]},{"room_stay_id":"3159971","reservation_id":"101184","confirmation_number":"SJ12628052248","room_stay_from":"2020-10-30","room_stay_to":"2020-11-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.34","nightly_discount":"0.00,0.00,0.00","subtotal":"235.00","grand_total":"235.00","paid_amount":"235.00","room_type_id":"319","product_id":"1288","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-10-05 23:00:51","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":"","changedComment":"Nightly price or discount changed","deltaChange":"0.01","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"}]},{"room_stay_id":"3159973","reservation_id":"98511","confirmation_number":"SJ12680897217","room_stay_from":"2020-10-06","room_stay_to":"2020-10-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"78.33,78.33,78.34","nightly_discount":"0.00,0.00,0.00","subtotal":"235.00","grand_total":"235.00","paid_amount":"235.00","room_type_id":"319","product_id":"1286","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-08-02 22:13:14","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":"","changedComment":"Nightly price or discount changed","deltaChange":"0.01","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"}]},{"room_stay_id":"3159977","reservation_id":"98914","confirmation_number":"SJ12681056942","room_stay_from":"2020-10-02","room_stay_to":"2020-10-16","room_stay_status":"Closed","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,77.86,77.86,77.86,77.86,77.86,77.86,77.82","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1090.00","grand_total":"1090.00","paid_amount":"1090.00","room_type_id":"319","product_id":"1287","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-08-12 01:27:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"-0.04","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"}]},{"room_stay_id":"3159980","reservation_id":"98518","confirmation_number":"SJ12644874982","room_stay_from":"2020-10-16","room_stay_to":"2020-10-23","room_stay_status":"Closed","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.84","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.00","grand_total":"545.00","paid_amount":"545.00","room_type_id":"413","product_id":"1265","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-08-02 22:54:12","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":"","changedComment":"Nightly price or discount changed","deltaChange":"-0.02","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"}]},{"room_stay_id":"3159982","reservation_id":"95484","confirmation_number":"SJ12627380621","room_stay_from":"2020-10-18","room_stay_to":"2020-10-25","room_stay_status":"Closed","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.84","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.00","grand_total":"545.00","paid_amount":"545.00","room_type_id":"413","product_id":"1264","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 16:21:36","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"-0.02","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"}]},{"room_stay_id":"3159984","reservation_id":"101512","confirmation_number":"SJ12625792051","room_stay_from":"2020-10-23","room_stay_to":"2020-10-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00,78.00,77.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.00","grand_total":"545.00","paid_amount":"545.00","room_type_id":"319","product_id":"1915","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-10-14 01:22:04","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":"","changedComment":"Nightly price or discount changed","deltaChange":"-1.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":"3159245","reservation_id":"103044","confirmation_number":"SJ12669171969","room_confirmation_number":"SJ12686924574","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"107667","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-11-27 20:03:46","reservation_modified_date_time":"2020-11-27 20:03:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107667","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25","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":"3148862","reservation_id":"101949","confirmation_number":"SJ12645357658","room_confirmation_number":"SJ12687146944","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","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":"108070","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-26 13:05:38","reservation_modified_date_time":"2020-10-26 13:05:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108070","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":"3150557","reservation_id":"102139","confirmation_number":"SJ12686986577","room_confirmation_number":"SJ12651340546","room_stay_from":"2020-11-22","room_stay_to":"2020-11-29","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":"108276","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-31 01:20:34","reservation_modified_date_time":"2020-10-31 01:32:47","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":"3152265","reservation_id":"101750","confirmation_number":"SJ12634241505","room_confirmation_number":"SJ12669388318","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50,11.50","subtotal":"125.00","grand_total":"75.94","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"107846","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-19 23:28:57","reservation_modified_date_time":"2020-11-05 19:54:28","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":"11.50","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":"3156948","reservation_id":"102936","confirmation_number":"SJ12615839038","room_confirmation_number":"SJ12693163561","room_stay_from":"2020-11-25","room_stay_to":"2020-11-29","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109065","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-21 16:07:19","reservation_modified_date_time":"2020-11-21 16:18:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109065","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":"3157433","reservation_id":"102764","confirmation_number":"SJ12693572283","room_confirmation_number":"SJ12655604486","room_stay_from":"2020-11-26","room_stay_to":"2020-11-29","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":"108905","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-17 13:54:42","reservation_modified_date_time":"2020-11-22 20:53:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108905","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":"3157438","reservation_id":"102828","confirmation_number":"SJ12699191193","room_confirmation_number":"SJ12651743416","room_stay_from":"2020-11-26","room_stay_to":"2020-11-29","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":"108968","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-19 01:12:10","reservation_modified_date_time":"2020-11-22 20:54:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108968","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":"3157472","reservation_id":"102493","confirmation_number":"SJ12642119679","room_confirmation_number":"SJ12612740853","room_stay_from":"2020-11-28","room_stay_to":"2020-11-29","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":"108656","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-10 16:14:07","reservation_modified_date_time":"2020-11-22 21:03:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108656","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":"3157961","reservation_id":"102754","confirmation_number":"SJ12642522303","room_confirmation_number":"SJ12695792026","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50,11.50","subtotal":"125.00","grand_total":"75.94","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"108896","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-17 01:29:46","reservation_modified_date_time":"2020-11-24 13:53:01","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":"11.50","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":"3157989","reservation_id":"103070","confirmation_number":"SJ12640274276","room_confirmation_number":"SJ12643652076","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","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":"109204","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-24 14:47:12","reservation_modified_date_time":"2020-11-24 14:47:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109204","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":"3158202","reservation_id":"102900","confirmation_number":"SJ12675310612","room_confirmation_number":"SJ12615733455","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","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":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"102312","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-20 19:39:11","reservation_modified_date_time":"2020-11-24 20:18:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102312","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":"3158858","reservation_id":"103154","confirmation_number":"SJ12667635811","room_confirmation_number":"SJ12656915594","room_stay_from":"2020-11-28","room_stay_to":"2020-11-29","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":"109303","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-26 15:41:07","reservation_modified_date_time":"2020-11-26 16:13:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109303","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":"3158896","reservation_id":"102725","confirmation_number":"SJ12628118774","room_confirmation_number":"SJ12616705685","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","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":"108868","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-16 15:30:52","reservation_modified_date_time":"2020-11-26 17:30:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108868","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":"3158972","reservation_id":"103164","confirmation_number":"SJ12674605364","room_confirmation_number":"SJ12669460657","room_stay_from":"2020-11-26","room_stay_to":"2020-11-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50","subtotal":"75.00","grand_total":"45.57","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109312","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-26 21:10:02","reservation_modified_date_time":"2020-11-26 21:11:00","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":"11.50","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":"3159246","reservation_id":"103044","confirmation_number":"SJ12685903039","room_confirmation_number":"SJ12686924574","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","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":"107667","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-23 22:54:05","reservation_modified_date_time":"2020-11-27 20:03:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107667","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":"3159288","reservation_id":"103198","confirmation_number":"SJ12629452289","room_confirmation_number":"SJ12635612987","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","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":"109350","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-27 20:42:12","reservation_modified_date_time":"2020-11-27 20:42:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109350","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":"3159296","reservation_id":"102451","confirmation_number":"SJ12657453549","room_confirmation_number":"SJ12663138692","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","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":"1776","service_quantity":"1","customer_traveller_id":"108616","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-08 23:05:07","reservation_modified_date_time":"2020-11-27 20:42:58","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108616","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.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":"3159313","reservation_id":"102561","confirmation_number":"SJ12643495774","room_confirmation_number":"SJ12672312108","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","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":"108716","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-12 02:33:09","reservation_modified_date_time":"2020-11-27 21:12:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108716","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":"3159340","reservation_id":"102772","confirmation_number":"SJ12661497407","room_confirmation_number":"SJ12666758731","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","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":"108914","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-17 16:42:09","reservation_modified_date_time":"2020-11-27 22:43:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108914","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":"3159367","reservation_id":"103203","confirmation_number":"SJ12669129243","room_confirmation_number":"SJ12650397536","room_stay_from":"2020-11-28","room_stay_to":"2020-11-29","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":"109358","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-27 23:31:10","reservation_modified_date_time":"2020-11-27 23:31:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109357","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":"3159371","reservation_id":"103189","confirmation_number":"SJ12687679475","room_confirmation_number":"SJ12672132857","room_stay_from":"2020-11-27","room_stay_to":"2020-11-29","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":"109360","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-27 17:54:11","reservation_modified_date_time":"2020-11-27 23:39:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109360","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":"3159688","reservation_id":"103144","confirmation_number":"SJ12688661448","room_confirmation_number":"SJ12676274410","room_stay_from":"2020-11-25","room_stay_to":"2020-11-29","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":"109296","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-28 20:40:54","reservation_modified_date_time":"2020-11-28 20:45:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109296","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"Reservation created with partial past date","deltaChange":"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":"3159987","reservation_id":"103237","confirmation_number":"SJ12686194972","room_confirmation_number":"SJ12613253157","room_stay_from":"2020-11-28","room_stay_to":"2020-11-29","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":"109402","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-29 00:44:10","reservation_modified_date_time":"2020-11-29 02:14:01","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109402","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":"3152284","reservation_id":"99188","confirmation_number":"SJ12616472676","room_confirmation_number":"SJ12669226988","room_stay_from":"2020-11-25","room_stay_to":"2020-11-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50,11.50","subtotal":"125.00","grand_total":"75.94","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"105166","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-17 20:34:25","reservation_modified_date_time":"2020-11-05 20:10:04","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":"11.50","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":"3153042","reservation_id":"102401","confirmation_number":"SJ12614103530","room_confirmation_number":"SJ12668612670","room_stay_from":"2020-11-26","room_stay_to":"2020-11-30","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":"108565","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-07 19:00:11","reservation_modified_date_time":"2020-11-07 19:00:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108565","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":"3156814","reservation_id":"102455","confirmation_number":"SJ12661315828","room_confirmation_number":"SJ12619839118","room_stay_from":"2020-11-27","room_stay_to":"2020-11-30","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":"108621","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-09 02:33:07","reservation_modified_date_time":"2020-11-21 01:58:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108621","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":"3158254","reservation_id":"101983","confirmation_number":"SJ12628789368","room_confirmation_number":"SJ12625868045","room_stay_from":"2020-11-27","room_stay_to":"2020-11-30","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":"108100","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-27 13:09:06","reservation_modified_date_time":"2020-11-24 21:59:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108100","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":"3158691","reservation_id":"99526","confirmation_number":"SJ12676136717","room_confirmation_number":"SJ12660750856","room_stay_from":"2020-11-25","room_stay_to":"2020-11-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50,11.50","subtotal":"125.00","grand_total":"75.94","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"105166","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-26 00:08:07","reservation_modified_date_time":"2020-11-25 23:29:55","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":"11.50","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":"3159376","reservation_id":"103122","confirmation_number":"SJ12692243219","room_confirmation_number":"SJ12690379704","room_stay_from":"2020-11-28","room_stay_to":"2020-11-30","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":"109262","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-25 17:26:10","reservation_modified_date_time":"2020-11-27 23:58:33","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109262","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":"3159378","reservation_id":"103204","confirmation_number":"SJ12665290541","room_confirmation_number":"SJ12615094624","room_stay_from":"2020-11-28","room_stay_to":"2020-11-30","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":"109361","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-28 00:02:05","reservation_modified_date_time":"2020-11-28 00:02:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109361","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":"3152864","reservation_id":"102389","confirmation_number":"SJ12698649760","room_confirmation_number":"SJ12687839488","room_stay_from":"2020-11-27","room_stay_to":"2020-12-01","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":"108550","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-07 14:25:09","reservation_modified_date_time":"2020-11-07 14:25:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108550","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":"3159362","reservation_id":"101751","confirmation_number":"SJ12669987737","room_confirmation_number":"SJ12655495721","room_stay_from":"2020-11-28","room_stay_to":"2020-12-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50,11.50","subtotal":"125.00","grand_total":"75.94","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"107847","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-19 23:44:50","reservation_modified_date_time":"2020-11-27 23:00: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":"11.50","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":"3100510","reservation_id":"95840","confirmation_number":"SJ12670769330","room_confirmation_number":"SJ12622883880","room_stay_from":"2020-11-25","room_stay_to":"2020-12-04","room_stay_status":"Active","nightly_price":"25.00,25.00,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,0.00,0.00","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"109271","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-03 00:56:06","reservation_modified_date_time":"2020-06-03 00:56:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101997","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":"3150725","reservation_id":"101082","confirmation_number":"SJ12656075962","room_confirmation_number":"SJ12687744274","room_stay_from":"2020-11-27","room_stay_to":"2020-12-04","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":"107144","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-02 22:52:53","reservation_modified_date_time":"2020-10-31 19:15:05","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"106240","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":"3159482","reservation_id":"97902","confirmation_number":"SJ12635323915","room_confirmation_number":"SJ12694200498","room_stay_from":"2020-11-28","room_stay_to":"2020-12-12","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103969","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-18 02:37:32","reservation_modified_date_time":"2020-11-28 14:26:58","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":"3159587","reservation_id":"102787","confirmation_number":"SJ12668387412","room_confirmation_number":"SJ12649458856","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,25.00,25.00","subtotal":"75.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"108927","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-17 22:44:48","reservation_modified_date_time":"2020-11-28 17:33:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108927","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"Nightly price or discount changed","deltaChange":"-50.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":"3159691","reservation_id":"103144","confirmation_number":"SJ12641359377","room_confirmation_number":"SJ12696538752","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","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":"109296","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-26 02:33:09","reservation_modified_date_time":"2020-11-28 20:46:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109296","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"}]},{"room_stay_id":"3159967","reservation_id":"100950","confirmation_number":"SJ12683818468","room_confirmation_number":"SJ12647636254","room_stay_from":"2020-10-16","room_stay_to":"2020-10-19","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"106983","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-28 23:58:39","reservation_modified_date_time":"2020-11-29 01:36:19","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"Nightly price or discount changed","deltaChange":"-75.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":"3159516","reservation_id":"103215","confirmation_number":"SJ12647543854","room_confirmation_number":"SJ12634296224","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-11-28 15:53:15","reservation_modified_date_time":"2020-11-28 15:53:15","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,"parentRoomStayFrom":"1970-01-01","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":"3159595","reservation_id":"103220","confirmation_number":"SJ12630566143","room_confirmation_number":"SJ12623125378","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":"16.00","paid_amount":"16.00","product_id":"1663","service_quantity":"4","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-11-28 17:46:57","reservation_modified_date_time":"2020-11-28 17:46:57","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,"parentRoomStayFrom":"1970-01-01","currentDayPrice":"14.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3159945","reservation_id":"103239","confirmation_number":"SJ12676529608","room_confirmation_number":"SJ12665995587","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-11-29 01:12:08","reservation_modified_date_time":"2020-11-29 01:12:08","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,"parentRoomStayFrom":"1970-01-01","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":"3159993","reservation_id":"103242","confirmation_number":"SJ12667197854","room_confirmation_number":"SJ12659964166","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-11-29 03:38:10","reservation_modified_date_time":"2020-11-29 03:38:10","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,"parentRoomStayFrom":"1970-01-01","currentDayPrice":"7.44","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":[]}}