{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-08-25","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,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":11,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1273,1264,1274,1270,1293,1711,1311,1312,1309,1310,1307,1308,1302,1303,1282,1314,1306,1289","block_room_bookings":[{"confirmation_number":"SJ12646427749","room_stay_from":"2021-08-13","room_stay_to":"2021-08-30","bundle_room":"0","product_id":"1273"},{"confirmation_number":"SJ12629008906","room_stay_from":"2021-08-25","room_stay_to":"2021-08-27","bundle_room":"0","product_id":"1264"},{"confirmation_number":"SJ12639732709","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1274"},{"confirmation_number":"SJ12633915615","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJ12619045282","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1293"},{"confirmation_number":"SJ12611457745","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJ12680202706","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"1","product_id":"1332"},{"confirmation_number":"SJ12667785406","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJ12641844335","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"1","product_id":"1330"},{"confirmation_number":"SJ12613262688","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"1","product_id":"1328"},{"confirmation_number":"SJ12638857454","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1282"},{"confirmation_number":"SJ12623315282","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1314"},{"confirmation_number":"SJ12652314941","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1306"},{"confirmation_number":"SJ12667586038","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1289"}],"bundle_block_count":"1271,1272,1304,1305,1262,1263,1269,1270,1291,1711,1260,1261,1267,1268,1311,1312,1309,1310,1307,1308,1302,1303","bundle_block_bookings":[{"confirmation_number":"SJB12668002879","room_stay_from":"2021-08-25","room_stay_to":"2021-08-28","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12637171200","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12688828514","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12669306396","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12640531383","room_stay_from":"2021-08-24","room_stay_to":"2021-08-27","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12694268722","room_stay_from":"2021-08-25","room_stay_to":"2021-08-27","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12684383837","room_stay_from":"2021-08-25","room_stay_to":"2021-08-28","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12652353990","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12689548631","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12695076776","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12670848459","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12616204176","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12659314803","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12658070761","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12665370534","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12645350888","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","bundle_room":"0","product_id":"1303"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3244056","reservation_id":"114186","confirmation_number":"SJ12627199091","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"244.30,244.30,244.30,244.30,244.30,314.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1535.80","grand_total":"1727.78","paid_amount":"1727.78","room_type_id":"320","product_id":"1329","siteminder_id":"BDC-3749509754","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":"120827","customer_id":"120827","source_of_creation":"Booking.com","reservation_created_date":"2021-04-30 02:13:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"303.44","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"244.30","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":"3272640","reservation_id":"117930","confirmation_number":"SJ12618152709","room_stay_from":"2021-08-25","room_stay_to":"2021-08-31","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,230.30,230.30,160.30,160.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1143.80","grand_total":"1286.78","paid_amount":"203.97","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3269772448","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":"124923","customer_id":"124923","source_of_creation":"Booking.com","reservation_created_date":"2021-06-23 23:50:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"232.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"181.30","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":"3293904","reservation_id":"120488","confirmation_number":"SJ12678815947","room_stay_from":"2021-08-20","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.30,300.30,230.30,230.30,230.30,230.30,230.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1752.10","grand_total":"1971.12","paid_amount":"1971.12","room_type_id":"319","product_id":"1943","siteminder_id":"BDC-3035373619","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":"127802","customer_id":"127802","source_of_creation":"Booking.com","reservation_created_date":"2021-07-31 20:58:37","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.30","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":"3300440","reservation_id":"120923","confirmation_number":"SJ12627898509","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.83,201.83,201.83","nightly_discount":"0,0,0","subtotal":"605.49","grand_total":"681.17","paid_amount":"681.17","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-3946308228","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":"128334","customer_id":"128334","source_of_creation":"Booking.com","reservation_created_date":"2021-08-08 02:26:22","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"201.83","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":"3306001","reservation_id":"115491","confirmation_number":"SJ12621853839","room_stay_from":"2021-08-25","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.28,143.28","nightly_discount":"0,0","subtotal":"286.56","grand_total":"322.38","paid_amount":"322.38","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-2911503231","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":"122231","customer_id":"122231","source_of_creation":"Booking.com","reservation_created_date":"2021-05-19 04:04:14","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"143.28","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":"4151078","reservation_id":"115765","confirmation_number":"SJ12627565711","room_stay_from":"2021-08-23","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.37,125.37,125.37,125.37,188.37,188.37,125.37","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1003.59","grand_total":"1129.04","paid_amount":"1129.04","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-3927548053","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":"122542","customer_id":"122542","source_of_creation":"Booking.com","reservation_created_date":"2021-05-24 01:46:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"212.15","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"125.37","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":"5303542","reservation_id":"121921","confirmation_number":"SJ12649997880","room_stay_from":"2021-08-25","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.95,128.95","nightly_discount":"0,0","subtotal":"257.90","grand_total":"290.14","paid_amount":"290.14","room_type_id":"413","product_id":"1267","siteminder_id":"BDC-2900852657","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":"129456","customer_id":"129456","source_of_creation":"Booking.com","reservation_created_date":"2021-08-25 21:37:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"55.42","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"128.95","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":"5294606","reservation_id":"121817","confirmation_number":"SJ12612405504","room_stay_from":"2021-12-14","room_stay_to":"2021-12-19","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"191.52,191.52,191.52,223.02,223.02","nightly_discount":"0,0,0,0,0","subtotal":"1020.60","grand_total":"1148.18","paid_amount":"201.29","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-3955843799","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":"129339","customer_id":"129339","source_of_creation":"Booking.com","reservation_created_date":"2021-08-24 01:34:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"206.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"5294311","reservation_id":"117027","confirmation_number":"SJ12615383475","room_stay_from":"2021-08-24","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.04,145.04,145.04,184.24,184.24,128.24","nightly_discount":"0,0,0,0,0,0","subtotal":"931.84","grand_total":"1048.32","paid_amount":"1048.32","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1783877373","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":"123967","customer_id":"123967","source_of_creation":"Expedia","reservation_created_date":"2021-06-11 16:01:17","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"186.37","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"145.04","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"5303584","reservation_id":"121926","confirmation_number":"SJ12683798455","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"183.08","nightly_discount":"0.00","subtotal":"183.08","grand_total":"215.79","paid_amount":"215.79","room_type_id":"413","product_id":"1268","siteminder_id":"ABB-HM8SZNH382","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"183.08","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129462","customer_id":"129462","source_of_creation":"Airbnb","reservation_created_date":"2021-08-25 22:34:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"6.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"183.08","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3293167","reservation_id":"120464","confirmation_number":"SJ12650427639","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75,246.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"987.00","grand_total":"1110.38","paid_amount":"1110.38","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":"127768","customer_id":"127768","source_of_creation":"FE","reservation_created_date":"2021-07-31 13:51:19","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"246.75","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":"3305297","reservation_id":"116002","confirmation_number":"SJ12622216430","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.25,149.25,149.25,149.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"597.00","grand_total":"671.63","paid_amount":"671.63","room_type_id":"412","product_id":"1316","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":"122811","customer_id":"122811","source_of_creation":"FE","reservation_created_date":"2021-05-27 19:50:54","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"149.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":"5294534","reservation_id":"119424","confirmation_number":"SJ12624636090","room_stay_from":"2021-08-25","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.25,194.25,246.75","nightly_discount":"0.00,0.00,0.00","subtotal":"635.25","grand_total":"714.65","paid_amount":"714.65","room_type_id":"319","product_id":"1301","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":"126540","customer_id":"126540","source_of_creation":"FE","reservation_created_date":"2021-07-16 00:54:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"194.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3223325","reservation_id":"111426","confirmation_number":"SJ12674055602","room_stay_from":"2021-08-24","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.15,152.15,152.15,203.15,203.15","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"862.75","grand_total":"970.60","paid_amount":"970.60","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"109507","customer_id":"109507","source_of_creation":"PMS","reservation_created_date":"2021-03-27 14:31:34","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"152.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":"3305921","reservation_id":"120114","confirmation_number":"SJ12656866521","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"227.15,227.15,201.65","nightly_discount":"22.72,22.72,20.17","subtotal":"655.95","grand_total":"664.14","paid_amount":"664.14","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112991","customer_id":"112991","source_of_creation":"PMS","reservation_created_date":"2021-07-26 17:07:49","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":"","promotion_code":"special123","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"201.65","currentDayDiscount":"20.17","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":"5294615","reservation_id":"121894","confirmation_number":"SJ12628042288","room_stay_from":"2021-08-25","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.65,194.65","nightly_discount":"0.00,0.00","subtotal":"389.30","grand_total":"437.97","paid_amount":"437.97","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":"129422","customer_id":"129422","source_of_creation":"PMS","reservation_created_date":"2021-08-25 15:04:20","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":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"194.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":"5303526","reservation_id":"121917","confirmation_number":"SJ12637213622","room_stay_from":"2021-08-21","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"489.38","paid_amount":"140.63","room_type_id":"411","product_id":"1296","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":"129452","customer_id":"129452","source_of_creation":"PMS","reservation_created_date":"2021-08-25 21:07:05","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"Reservation created with partial past date","deltaChange":"348.00","currentDayPrice":"87.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3251038","reservation_id":"114466","confirmation_number":"SJ12687913738","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.28,102.28,102.28,102.28,102.28,102.28,102.32","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"716.00","grand_total":"716.00","paid_amount":"0.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":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-05-04 00:24:43","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"102.28","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":"3251042","reservation_id":"114476","confirmation_number":"SJ12623629284","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.28,102.28,102.28,102.28,102.28,102.28,102.32","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"716.00","grand_total":"716.00","paid_amount":"0.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":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-05-04 01:34:06","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"102.28","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":"3251044","reservation_id":"114477","confirmation_number":"SJ12668182506","room_stay_from":"2021-08-20","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.28,102.28,102.28,102.28,102.28,102.28,102.32","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"716.00","grand_total":"716.00","paid_amount":"0.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":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-05-04 01:37:16","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"102.28","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":"3305301","reservation_id":"116636","confirmation_number":"SJ12658926127","room_stay_from":"2021-08-22","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.00,102.00,102.00,102.00,102.00,102.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"716.00","grand_total":"716.00","paid_amount":"0.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":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-06-06 01:33:41","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"102.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":"5302724","reservation_id":"112046","confirmation_number":"SJ12684603680","room_stay_from":"2021-08-24","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"0.00","room_type_id":"413","product_id":"1269","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":"2021-04-04 01:23:24","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-10.83,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"86.67","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":"5302776","reservation_id":"112822","confirmation_number":"SJ12658283043","room_stay_from":"2021-08-25","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1272","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":"2021-04-12 22:54:30","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":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"86.67","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":"5302836","reservation_id":"110723","confirmation_number":"SJ12645910859","room_stay_from":"2021-08-21","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"0.00","room_type_id":"319","product_id":"1276","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":"2021-03-19 15:58:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-43.5,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"87.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":"5302904","reservation_id":"115170","confirmation_number":"SJ12658016821","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","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":"2021-05-13 22:45:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-21.75,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"87.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":"5302906","reservation_id":"115171","confirmation_number":"SJ12620798016","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-13 22:55:27","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":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-21.75,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"87.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":"5302976","reservation_id":"116034","confirmation_number":"SJ12673544332","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1942","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":"2021-05-27 22:26:38","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":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-43.5,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"87.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":"5303142","reservation_id":"112341","confirmation_number":"SJ12632582113","room_stay_from":"2021-08-24","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","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":"2021-04-07 15:46:22","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":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-10.83,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"86.67","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":"5303288","reservation_id":"109238","confirmation_number":"SJ12697338412","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","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":"2021-03-04 00:23:31","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":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-21.67,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"86.67","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":"5303302","reservation_id":"113232","confirmation_number":"SJ12657567420","room_stay_from":"2021-08-24","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-17 18:13:56","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-10.83,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"86.67","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":"5303340","reservation_id":"109237","confirmation_number":"SJ12637814402","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","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":"2021-03-04 00:21:21","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":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-21.67,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"86.67","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":"5303344","reservation_id":"113203","confirmation_number":"SJ12618451415","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"412","product_id":"1294","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":"2021-04-17 16:55:59","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":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-43.5,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"87.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":"5303346","reservation_id":"115465","confirmation_number":"SJ12633728053","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1319","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":"2021-05-18 20:42:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-21.75,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"87.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":"5303374","reservation_id":"113556","confirmation_number":"SJ12666552314","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1262","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":"2021-04-21 19:21:01","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":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-21.67,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"86.67","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":"5303376","reservation_id":"110546","confirmation_number":"SJ12630285376","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1277","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":"2021-03-17 18:43:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-21.67,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"86.67","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":"5303380","reservation_id":"116764","confirmation_number":"SJ12639083898","room_stay_from":"2021-08-24","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"83.48","room_type_id":"413","product_id":"1271","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":"2021-06-07 23:51:01","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":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-10.83,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"86.67","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":"5303385","reservation_id":"112812","confirmation_number":"SJ12656847200","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67,86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"520.02","grand_total":"520.02","paid_amount":"168.75","room_type_id":"413","product_id":"1266","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":"2021-04-12 22:05:51","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":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-32.5,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":"86.67","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":"5303440","reservation_id":"108366","confirmation_number":"SJ12671647227","room_stay_from":"2021-08-25","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1291","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-23 02:27:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"86.67","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":"5303501","reservation_id":"109239","confirmation_number":"SJ12647852573","room_stay_from":"2021-08-25","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.66","nightly_discount":"0.00,0.00,0.00","subtotal":"260.00","grand_total":"260.00","paid_amount":"234.38","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":"2021-03-04 00:26:24","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":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"86.67","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":"5296404","reservation_id":"116608","confirmation_number":"SJ12698046361","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1274","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":"2021-06-05 19:26:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-54.38,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5297292","reservation_id":"115356","confirmation_number":"SJ12610691787","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1711","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-16 23:19:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-54.38,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5299927","reservation_id":"113196","confirmation_number":"SJ12611002764","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1312","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":"2021-04-17 16:16:43","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-32.5,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5301681","reservation_id":"112820","confirmation_number":"SJ12688775751","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.66","nightly_discount":"0.00,0.00,0.00","subtotal":"260.00","grand_total":"260.00","paid_amount":"84.38","room_type_id":"319","product_id":"1311","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":"2021-04-12 22:49:58","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-32.5,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5302565","reservation_id":"121699","confirmation_number":"SJ12691790189","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"159.38","room_type_id":"413","product_id":"1267","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":"2021-08-22 18:09:25","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","taxExmptApplied":-32.5,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3263303","reservation_id":"116679","confirmation_number":"SJ12698204146","room_stay_from":"2021-08-22","room_stay_to":"2021-08-29","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.00,102.00,102.00,102.00,104.00,102.00,102.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"716.00","grand_total":"716.00","paid_amount":"0.00","room_type_id":"319","product_id":"1917","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-06-06 20:41:47","service_canceled_date_time":"2021-08-25 12:14:33","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"","total_paid_amount":"0.00","sub_hotel_id":"0","deltaChange":-306,"changedComment":"reservation is canceled","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":"5303318","reservation_id":"116025","confirmation_number":"SJ12684052436","room_stay_from":"2021-08-21","room_stay_to":"2021-08-26","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"0.00","room_type_id":"411","product_id":"1296","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":"2021-05-27 22:07:22","service_canceled_date_time":"2021-08-25 21:05:01","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"tax_exempted_indicator_1","total_paid_amount":"0.00","sub_hotel_id":"0","deltaChange":-348,"changedComment":"reservation is canceled","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":"5303561","reservation_id":"121926","confirmation_number":"SJ12627325129","room_confirmation_number":"SJ12683798455","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"25.15","paid_amount":"23.91","product_id":"1777","service_quantity":"1","customer_traveller_id":"129462","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-08-25 22:34:11","reservation_modified_date_time":"2021-08-25 22:34:11","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129462","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"0.60","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3223326","reservation_id":"111426","confirmation_number":"SJ12657222609","room_confirmation_number":"SJ12674055602","room_stay_from":"2021-08-24","room_stay_to":"2021-08-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":"109507","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-27 14:31:34","reservation_modified_date_time":"2021-03-27 14:32:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109507","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3244057","reservation_id":"114186","confirmation_number":"SJ12648021467","room_confirmation_number":"SJ12627199091","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"120827","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-30 02:13:08","reservation_modified_date_time":"2021-04-30 02:13:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120827","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3251037","reservation_id":"114466","confirmation_number":"SJ12686060898","room_confirmation_number":"SJ12687913738","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121160","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-04 00:24:43","reservation_modified_date_time":"2021-05-12 22:47:13","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3251041","reservation_id":"114476","confirmation_number":"SJ12617705605","room_confirmation_number":"SJ12623629284","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121172","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-04 01:34:06","reservation_modified_date_time":"2021-05-12 22:47:13","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3251043","reservation_id":"114477","confirmation_number":"SJ12616665124","room_confirmation_number":"SJ12668182506","room_stay_from":"2021-08-20","room_stay_to":"2021-08-27","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":"121173","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-04 01:37:16","reservation_modified_date_time":"2021-05-12 22:47:13","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3272641","reservation_id":"117930","confirmation_number":"SJ12638790025","room_confirmation_number":"SJ12618152709","room_stay_from":"2021-08-25","room_stay_to":"2021-08-31","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124923","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-23 23:50:13","reservation_modified_date_time":"2021-06-23 23:50:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124923","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3293168","reservation_id":"120464","confirmation_number":"SJ12668105463","room_confirmation_number":"SJ12650427639","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","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":"127768","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-31 13:51:19","reservation_modified_date_time":"2021-07-31 13:51:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127768","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3293903","reservation_id":"120488","confirmation_number":"SJ12648395364","room_confirmation_number":"SJ12678815947","room_stay_from":"2021-08-20","room_stay_to":"2021-08-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"127802","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-31 20:58:37","reservation_modified_date_time":"2021-07-31 22:30:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127802","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3300439","reservation_id":"120923","confirmation_number":"SJ12624907432","room_confirmation_number":"SJ12627898509","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","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":"128334","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-08 02:26:22","reservation_modified_date_time":"2021-08-09 15:26:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128334","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3305298","reservation_id":"116002","confirmation_number":"SJ12689953781","room_confirmation_number":"SJ12622216430","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","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":"122811","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-27 19:50:54","reservation_modified_date_time":"2021-08-20 12:57:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122811","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3305302","reservation_id":"116636","confirmation_number":"SJ12673565883","room_confirmation_number":"SJ12658926127","room_stay_from":"2021-08-22","room_stay_to":"2021-08-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":"123528","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-06 01:33:41","reservation_modified_date_time":"2021-08-20 12:57:18","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3305922","reservation_id":"120114","confirmation_number":"SJ12698292301","room_confirmation_number":"SJ12656866521","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","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":"112991","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-26 17:07:49","reservation_modified_date_time":"2021-08-21 13:06:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112991","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3306002","reservation_id":"115491","confirmation_number":"SJ12688337351","room_confirmation_number":"SJ12621853839","room_stay_from":"2021-08-25","room_stay_to":"2021-08-27","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":"122231","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-19 04:04:14","reservation_modified_date_time":"2021-08-21 14:29:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122231","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"4151088","reservation_id":"115765","confirmation_number":"SJ12648855885","room_confirmation_number":"SJ12627565711","room_stay_from":"2021-08-23","room_stay_to":"2021-08-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"122542","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-24 01:46:11","reservation_modified_date_time":"2021-08-21 18:58:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122542","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5294312","reservation_id":"117027","confirmation_number":"SJ12637911978","room_confirmation_number":"SJ12615383475","room_stay_from":"2021-08-24","room_stay_to":"2021-08-30","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"123967","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-11 16:01:17","reservation_modified_date_time":"2021-08-24 15:36:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123967","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5294535","reservation_id":"119424","confirmation_number":"SJ12641668653","room_confirmation_number":"SJ12624636090","room_stay_from":"2021-08-25","room_stay_to":"2021-08-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":"126540","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-16 00:54:53","reservation_modified_date_time":"2021-08-25 01:16:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126540","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5294616","reservation_id":"121894","confirmation_number":"SJ12618989035","room_confirmation_number":"SJ12628042288","room_stay_from":"2021-08-25","room_stay_to":"2021-08-27","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":"129422","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-25 15:04:20","reservation_modified_date_time":"2021-08-25 15:04:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129422","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5302723","reservation_id":"112046","confirmation_number":"SJ12640348288","room_confirmation_number":"SJ12684603680","room_stay_from":"2021-08-24","room_stay_to":"2021-08-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"118615","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-04 01:23:24","reservation_modified_date_time":"2021-08-25 19:06:11","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5302775","reservation_id":"112822","confirmation_number":"SJ12665460364","room_confirmation_number":"SJ12658283043","room_stay_from":"2021-08-25","room_stay_to":"2021-08-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119409","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-12 22:54:30","reservation_modified_date_time":"2021-08-25 19:06:12","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5302835","reservation_id":"110723","confirmation_number":"SJ12676370179","room_confirmation_number":"SJ12645910859","room_stay_from":"2021-08-21","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117234","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 15:58:17","reservation_modified_date_time":"2021-08-25 19:06:13","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5302903","reservation_id":"115170","confirmation_number":"SJ12660256326","room_confirmation_number":"SJ12658016821","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121878","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-13 22:45:08","reservation_modified_date_time":"2021-08-25 19:06:14","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5302905","reservation_id":"115171","confirmation_number":"SJ12687735657","room_confirmation_number":"SJ12620798016","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121879","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-13 22:55:27","reservation_modified_date_time":"2021-08-25 19:06:14","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5302975","reservation_id":"116034","confirmation_number":"SJ12684069053","room_confirmation_number":"SJ12673544332","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"122844","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-27 22:26:38","reservation_modified_date_time":"2021-08-25 19:06:15","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303141","reservation_id":"112341","confirmation_number":"SJ12661839065","room_confirmation_number":"SJ12632582113","room_stay_from":"2021-08-24","room_stay_to":"2021-08-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"118910","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 15:46:22","reservation_modified_date_time":"2021-08-25 19:06:18","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303287","reservation_id":"109238","confirmation_number":"SJ12659147387","room_confirmation_number":"SJ12697338412","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115706","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 00:23:31","reservation_modified_date_time":"2021-08-25 19:06:21","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303301","reservation_id":"113232","confirmation_number":"SJ12641304906","room_confirmation_number":"SJ12657567420","room_stay_from":"2021-08-24","room_stay_to":"2021-08-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119823","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 18:13:56","reservation_modified_date_time":"2021-08-25 19:06:21","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303339","reservation_id":"109237","confirmation_number":"SJ12678762603","room_confirmation_number":"SJ12637814402","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115705","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 00:21:21","reservation_modified_date_time":"2021-08-25 19:06:22","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303343","reservation_id":"113203","confirmation_number":"SJ12646508609","room_confirmation_number":"SJ12618451415","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119793","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 16:55:59","reservation_modified_date_time":"2021-08-25 19:06:22","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303345","reservation_id":"115465","confirmation_number":"SJ12660676634","room_confirmation_number":"SJ12633728053","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"122207","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-18 20:42:52","reservation_modified_date_time":"2021-08-25 19:06:22","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303373","reservation_id":"113556","confirmation_number":"SJ12648012742","room_confirmation_number":"SJ12666552314","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120157","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 19:21:01","reservation_modified_date_time":"2021-08-25 19:06:22","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303375","reservation_id":"110546","confirmation_number":"SJ12678297463","room_confirmation_number":"SJ12630285376","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117058","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 18:43:57","reservation_modified_date_time":"2021-08-25 19:06:22","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303379","reservation_id":"116764","confirmation_number":"SJ12659349924","room_confirmation_number":"SJ12639083898","room_stay_from":"2021-08-24","room_stay_to":"2021-08-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"123671","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-07 23:51:01","reservation_modified_date_time":"2021-08-25 19:06:22","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303384","reservation_id":"112812","confirmation_number":"SJ12662187630","room_confirmation_number":"SJ12656847200","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119400","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-12 22:05:51","reservation_modified_date_time":"2021-08-25 19:06:23","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303439","reservation_id":"108366","confirmation_number":"SJ12633793431","room_confirmation_number":"SJ12671647227","room_stay_from":"2021-08-25","room_stay_to":"2021-08-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114817","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 02:27:07","reservation_modified_date_time":"2021-08-25 19:06:24","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303504","reservation_id":"109239","confirmation_number":"SJ12657309896","room_confirmation_number":"SJ12647852573","room_stay_from":"2021-08-25","room_stay_to":"2021-08-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115707","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 00:26:24","reservation_modified_date_time":"2021-08-25 20:21:35","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303527","reservation_id":"121917","confirmation_number":"SJ12668567738","room_confirmation_number":"SJ12637213622","room_stay_from":"2021-08-21","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"129452","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-25 21:07:05","reservation_modified_date_time":"2021-08-25 21:07:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129452","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"Reservation created with partial past date","deltaChange":"100.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":"5303543","reservation_id":"121921","confirmation_number":"SJ12619330237","room_confirmation_number":"SJ12649997880","room_stay_from":"2021-08-25","room_stay_to":"2021-08-27","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":"129456","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-25 21:37:08","reservation_modified_date_time":"2021-08-25 21:37:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129456","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5303585","reservation_id":"121926","confirmation_number":"SJ12611839777","room_confirmation_number":"SJ12683798455","room_stay_from":"2021-08-25","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"129462","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-25 22:34:11","reservation_modified_date_time":"2021-08-25 23:38:06","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129462","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"5294607","reservation_id":"121817","confirmation_number":"SJ12611865068","room_confirmation_number":"SJ12612405504","room_stay_from":"2021-12-14","room_stay_to":"2021-12-19","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"129339","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-24 01:34:11","reservation_modified_date_time":"2021-08-25 14:50:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129339","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303317","reservation_id":"116025","confirmation_number":"SJ12632554861","room_confirmation_number":"SJ12684052436","room_stay_from":"2021-08-21","room_stay_to":"2021-08-26","room_stay_status":"Canceled","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-05-27 22:07:22","reservation_modified_date_time":"2021-08-25 19:06:21","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"122839","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-08-25 21:05:01","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","parentRoomStayFrom":"2021-08-21","sub_hotel_id":"0","deltaChange":-100,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":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":[{"room_stay_id":"5303439","reservation_id":"108366","confirmation_number":"SJ12633793431","room_confirmation_number":"SJ12671647227","room_stay_from":"2021-08-25","room_stay_to":"2021-08-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114817","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 02:27:07","reservation_modified_date_time":"2021-08-25 19:06:24","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[]}],"gift_shop_taxable":[],"gift_shop_non_taxable":[{"room_stay_id":"5303478","reservation_id":"121906","confirmation_number":"SJ12652351813","room_confirmation_number":"SJ12633421976","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"75.00","paid_amount":"0.00","product_id":"1704","service_quantity":"1","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-25 19:45:19","reservation_modified_date_time":"2021-08-25 19:45:19","customer_id":"129438","parentCustTravId":"129438","customer_traveller_id":"129438","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-21","sub_hotel_id":"0","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"5303500","reservation_id":"109239","confirmation_number":"SJ12680762006","room_confirmation_number":"SJ12647852573","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"150.00","paid_amount":"0.00","product_id":"1704","service_quantity":"2","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-25 20:20:06","reservation_modified_date_time":"2021-08-25 20:20:06","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"115707","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-25","sub_hotel_id":"0","currentDayPrice":"150.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}