{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-07-26","total_rooms_exist":"1281,1282,1289,1274,1275,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":10,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1916,1307,1943","block_room_bookings":[{"confirmation_number":"SJ12674656130","room_stay_from":"2020-07-25","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJ12676533150","room_stay_from":"2020-07-11","room_stay_to":"2020-08-05","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-04","room_stay_to":"2020-09-01","bundle_room":"0"}],"bundle_block_count":"1260,1261,1262,1263,1309,1310,1302,1303,1291,1711,1304,1305,1307,1308,1311,1312,1269,1270,1267,1268","bundle_block_bookings":[{"confirmation_number":"SJB12612641876","room_stay_from":"2020-07-24","room_stay_to":"2020-07-27","bundle_room":"1"},{"confirmation_number":"SJB12656776927","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","bundle_room":"1"},{"confirmation_number":"SJB12680591042","room_stay_from":"2020-07-26","room_stay_to":"2020-07-28","bundle_room":"1"},{"confirmation_number":"SJB12686984844","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","bundle_room":"1"},{"confirmation_number":"SJB12631240958","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJB12683410610","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJB12623036528","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJB12615618970","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJB12630929587","room_stay_from":"2020-07-21","room_stay_to":"2020-07-28","bundle_room":"1"},{"confirmation_number":"SJB12688176377","room_stay_from":"2020-07-24","room_stay_to":"2020-07-29","bundle_room":"1"},{"confirmation_number":"SJB12655547477","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","bundle_room":"0"},{"confirmation_number":"SJB12658861740","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","bundle_room":"0"},{"confirmation_number":"SJB12679187448","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3119973","reservation_id":"98172","confirmation_number":"SJ12662272752","room_stay_from":"2020-07-25","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"286.40,200.00","nightly_discount":"0,0","subtotal":"486.40","grand_total":"547.20","paid_amount":"547.20","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-3409094298","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":"104238","customer_id":"104238","source_of_creation":"Booking.com","reservation_created_date":"2020-07-25 18:26:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"96.55","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"200.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120119","reservation_id":"95095","confirmation_number":"SJ12664636390","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"98.40,114.40,114.40,98.40","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"425.60","grand_total":"478.80","paid_amount":"478.80","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-3829323920","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101276","customer_id":"101276","source_of_creation":"Booking.com","reservation_created_date":"2020-05-20 01:32:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"94.61","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"150.00","currentDayPrice":"98.40","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":"3120141","reservation_id":"95093","confirmation_number":"SJ12642228518","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"98.40,114.40,114.40,98.40","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"425.60","grand_total":"478.80","paid_amount":"478.80","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-3829345140","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101274","customer_id":"101274","source_of_creation":"Booking.com","reservation_created_date":"2020-05-20 01:28:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"94.61","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"150.00","currentDayPrice":"98.40","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":"3119652","reservation_id":"97585","confirmation_number":"SJ12645665642","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"267.20,267.20,172.80,172.80","nightly_discount":"0,0,0,0","subtotal":"880.00","grand_total":"990.00","paid_amount":"990.00","room_type_id":"413","product_id":"1262","siteminder_id":"BDC-2162244087","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":"103661","customer_id":"103661","source_of_creation":"Booking.com","reservation_created_date":"2020-07-09 19:29:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"58.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.80","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":"3119939","reservation_id":"98152","confirmation_number":"SJ12642248693","room_stay_from":"2020-07-25","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.40,138.40,203.24","nightly_discount":"0.00,0.00,0.00","subtotal":"480.04","grand_total":"540.04","paid_amount":"540.04","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2449827342","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":"104229","customer_id":"104229","source_of_creation":"Booking.com","reservation_created_date":"2020-07-25 14:44:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"58.82","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.40","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":"3120160","reservation_id":"95550","confirmation_number":"SJ12617408885","room_stay_from":"2020-07-26","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.80,176.80","nightly_discount":"0,0","subtotal":"353.60","grand_total":"397.80","paid_amount":"397.80","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-3980284800","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":"101732","customer_id":"101732","source_of_creation":"Booking.com","reservation_created_date":"2020-05-28 17:01:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"72.65","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"176.80","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":"3113363","reservation_id":"93587","confirmation_number":"SJ12696472420","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"247.20,119.20,119.20,186.40,186.40,191.20,151.20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1200.80","grand_total":"1350.90","paid_amount":"1350.90","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3169083708","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":"99816","customer_id":"99816","source_of_creation":"Booking.com","reservation_created_date":"2020-03-24 21:57:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"247.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3116754","reservation_id":"95003","confirmation_number":"SJ12677057928","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.72,91.52,91.52,78.72","nightly_discount":"0,0,0,0","subtotal":"340.48","grand_total":"383.04","paid_amount":"383.04","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1664734816","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":"101196","customer_id":"101196","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 00:21:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.72","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":"3119316","reservation_id":"95004","confirmation_number":"SJ12640169917","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.72,91.52,91.52,78.72","nightly_discount":"0,0,0,0","subtotal":"340.48","grand_total":"383.04","paid_amount":"383.04","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1664737422","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":"101197","customer_id":"101197","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 00:37:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.72","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":"3120010","reservation_id":"97998","confirmation_number":"SJ12682072401","room_stay_from":"2020-07-25","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"221.44,155.52","nightly_discount":"0.00,0.00","subtotal":"376.96","grand_total":"424.08","paid_amount":"424.08","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1681427229","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":"104067","customer_id":"104067","source_of_creation":"Expedia","reservation_created_date":"2020-07-21 00:28:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"155.52","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":"3120488","reservation_id":"97811","confirmation_number":"SJ12664944560","room_stay_from":"2020-07-24","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"229.12,229.12,182.92","nightly_discount":"0.00,0.00,0.00","subtotal":"641.16","grand_total":"721.31","paid_amount":"721.31","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1680007746","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":"103882","customer_id":"103882","source_of_creation":"Expedia","reservation_created_date":"2020-07-16 11:38:10","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":"","changedComment":"Nightly price or discount changed","deltaChange":"-55.36","currentDayPrice":"182.92","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":"3119530","reservation_id":"91368","confirmation_number":"SJ12617390124","room_stay_from":"2020-07-25","room_stay_to":"2020-07-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"243.20,184.00,166.40,166.40,166.40,171.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1097.60","grand_total":"1234.80","paid_amount":"1234.80","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1636094352","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":"97495","customer_id":"97495","source_of_creation":"Expedia","reservation_created_date":"2020-02-05 18:48:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"184.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":"3107027","reservation_id":"96523","confirmation_number":"SJ12671312898","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"293.12,264.32,229.76,229.76,229.76,254.72","nightly_discount":"0,0,0,0,0,0","subtotal":"1501.44","grand_total":"1689.12","paid_amount":"1689.12","room_type_id":"319","product_id":"1942","siteminder_id":"EXP-1670772078","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":"102629","customer_id":"102629","source_of_creation":"Expedia","reservation_created_date":"2020-06-15 02:29:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"293.12","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120152","reservation_id":"95012","confirmation_number":"SJ12652680590","room_stay_from":"2020-07-25","room_stay_to":"2020-07-27","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,103.20","nightly_discount":"0,0","subtotal":"222.40","grand_total":"250.20","paid_amount":"0.00","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1664749272","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":"101203","customer_id":"101203","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 01:46:10","service_canceled_date_time":"2020-07-26 12:39:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"undo no show night","total_paid_amount":"0.00","deltaChange":-119.2,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3114178","reservation_id":"97466","confirmation_number":"SJ12675924202","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"290.00,290.00,178.50,178.50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"937.00","grand_total":"1054.13","paid_amount":"1054.13","room_type_id":"319","product_id":"1303","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103545","customer_id":"103545","source_of_creation":"FE","reservation_created_date":"2020-07-06 23:49:00","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"178.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119245","reservation_id":"97670","confirmation_number":"SJ12669827674","room_stay_from":"2020-07-25","room_stay_to":"2020-07-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"232.00,142.80,142.80,191.25,191.25","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"900.10","grand_total":"1012.62","paid_amount":"1012.62","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103746","customer_id":"103746","source_of_creation":"FE","reservation_created_date":"2020-07-11 20:36:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"142.80","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":"3094799","reservation_id":"94959","confirmation_number":"SJ12673001401","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"450.00,406.00,406.00,406.00,418.00,448.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2534.00","grand_total":"2850.75","paid_amount":"2850.75","room_type_id":"320","product_id":"1323","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":"101147","customer_id":"101147","source_of_creation":"FE","reservation_created_date":"2020-05-18 15:48:50","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"450.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3117502","reservation_id":"97920","confirmation_number":"SJ12663196097","room_stay_from":"2020-07-24","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"256.80,256.80,163.88","nightly_discount":"0.00,0.00,0.00","subtotal":"677.48","grand_total":"762.16","paid_amount":"762.16","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":"103988","customer_id":"103988","source_of_creation":"PMS","reservation_created_date":"2020-07-18 19:16:01","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"163.88","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":"3119349","reservation_id":"98115","confirmation_number":"SJ12673936438","room_stay_from":"2020-07-25","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"211.20,125.12","nightly_discount":"0.00,0.00","subtotal":"336.32","grand_total":"378.36","paid_amount":"378.36","room_type_id":"413","product_id":"1266","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":"104185","customer_id":"104185","source_of_creation":"PMS","reservation_created_date":"2020-07-24 12:12:52","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"125.12","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":"3119504","reservation_id":"98127","confirmation_number":"SJ12646648378","room_stay_from":"2020-07-25","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.20,159.12","nightly_discount":"0.00,0.00","subtotal":"410.32","grand_total":"461.61","paid_amount":"461.61","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":"104196","customer_id":"104196","source_of_creation":"PMS","reservation_created_date":"2020-07-24 17:16:42","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"159.12","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":"3119942","reservation_id":"98169","confirmation_number":"SJ12626149083","room_stay_from":"2020-07-25","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.20,182.92","nightly_discount":"27.90,18.29","subtotal":"462.12","grand_total":"467.92","paid_amount":"467.92","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104236","customer_id":"104236","source_of_creation":"PMS","reservation_created_date":"2020-07-25 18:04:27","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"182.92","currentDayDiscount":"18.29","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":"3116839","reservation_id":"97853","confirmation_number":"SJ12620030798","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"295.12,411.20,411.20,295.12,295.12","nightly_discount":"29.50,41.12,41.12,29.50,29.50","subtotal":"1707.76","grand_total":"1729.15","paid_amount":"1729.15","room_type_id":"320","product_id":"1714","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":"103919","customer_id":"103919","source_of_creation":"PMS","reservation_created_date":"2020-07-17 11:26:45","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"295.12","currentDayDiscount":"29.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118654","reservation_id":"97846","confirmation_number":"SJ12639459090","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"295.12,411.20,411.20,295.12,295.12","nightly_discount":"29.50,41.12,41.12,29.50,29.50","subtotal":"1707.76","grand_total":"1729.15","paid_amount":"1729.15","room_type_id":"320","product_id":"1329","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":"103914","customer_id":"103914","source_of_creation":"PMS","reservation_created_date":"2020-07-17 00:55:37","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"295.12","currentDayDiscount":"29.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117642","reservation_id":"97941","confirmation_number":"SJ12645743914","room_stay_from":"2020-07-24","room_stay_to":"2020-07-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"221.60,221.60,133.96,133.96,170.00,180.20,180.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1241.52","grand_total":"1396.71","paid_amount":"1396.71","room_type_id":"319","product_id":"1756","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":"104009","customer_id":"104009","source_of_creation":"PMS","reservation_created_date":"2020-07-19 01:19:45","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"133.96","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":"3118830","reservation_id":"98051","confirmation_number":"SJ12684507683","room_stay_from":"2020-07-26","room_stay_to":"2020-07-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"142.80,142.80,191.25,191.25,191.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"859.35","grand_total":"966.77","paid_amount":"966.77","room_type_id":"318","product_id":"1282","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":"104115","customer_id":"104115","source_of_creation":"PMS","reservation_created_date":"2020-07-22 16:42:33","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"142.80","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":"3105741","reservation_id":"96540","confirmation_number":"SJ12648416794","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.72,125.72,125.72,125.71,125.71,125.71,125.71","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"990.00","paid_amount":"0.00","room_type_id":"319","product_id":"1319","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":"84637","customer_id":"84637","source_of_creation":"PMS","reservation_created_date":"2020-06-15 15:05:07","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":"","currentDayPrice":"125.72","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":"3119927","reservation_id":"97689","confirmation_number":"SJ12668652431","room_stay_from":"2020-07-25","room_stay_to":"2020-08-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"221.60,133.96,133.96,180.20,180.20,180.20,277.00,277.00,144.16","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1728.28","grand_total":"1944.31","paid_amount":"1944.31","room_type_id":"413","product_id":"1264","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":"103760","customer_id":"103760","source_of_creation":"PMS","reservation_created_date":"2020-07-12 12:33:42","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"133.96","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":"3120304","reservation_id":"97825","confirmation_number":"SJ12666215686","room_stay_from":"2020-07-30","room_stay_to":"2020-08-03","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.00,290.00,290.00,153.00","nightly_discount":"21.10,0.00,0.00,0.00","subtotal":"944.00","grand_total":"1038.27","paid_amount":"326.25","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84865","customer_id":"84865","source_of_creation":"PMS","reservation_created_date":"2020-07-16 19:27:15","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":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120371","reservation_id":"97694","confirmation_number":"SJ12631152138","room_stay_from":"2020-07-30","room_stay_to":"2020-08-01","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"191.25,191.25","nightly_discount":"0.00,0.00","subtotal":"382.50","grand_total":"430.32","paid_amount":"402.19","room_type_id":"318","product_id":"1281","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103766","customer_id":"103766","source_of_creation":"PMS","reservation_created_date":"2020-07-12 17:19:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120434","reservation_id":"98046","confirmation_number":"SJ12652139180","room_stay_from":"2020-07-27","room_stay_to":"2020-07-31","room_stay_status":"Active","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"191.25,191.25,191.25,290.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"863.75","grand_total":"971.72","paid_amount":"215.16","room_type_id":"318","product_id":"1289","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104112","customer_id":"104112","source_of_creation":"PMS","reservation_created_date":"2020-07-22 16:01:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"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"}]}],"pms_non_taxable":[{"room_stay_id":"3119413","reservation_id":"97022","confirmation_number":"SJ12690712901","room_stay_from":"2020-07-24","room_stay_to":"2020-07-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.71,125.71,125.71,125.71,125.72,125.72,125.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"880.00","paid_amount":"0.00","room_type_id":"319","product_id":"1308","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-24 00:56:51","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"125.71","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":"3114387","reservation_id":"97118","confirmation_number":"SJ12648875545","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","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","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":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-26 17:53:20","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":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[{"room_stay_id":"3111525","reservation_id":"97282","confirmation_number":"SJ12679975597","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.44,84.44,84.44,84.44,84.44","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"422.20","grand_total":"474.98","paid_amount":"140.63","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-07-01 21:56:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.44","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":"3119250","reservation_id":"97199","confirmation_number":"SJ12655710304","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.44,84.44,84.44,84.44,84.44","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"422.20","grand_total":"474.98","paid_amount":"140.63","room_type_id":"319","product_id":"1286","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-06-28 21:44:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.44","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":"3109026","reservation_id":"96710","confirmation_number":"SJ12674033126","room_stay_from":"2020-07-24","room_stay_to":"2020-07-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.44,84.44,84.44,84.44,84.44","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"422.20","grand_total":"474.98","paid_amount":"140.63","room_type_id":"319","product_id":"1311","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-06-17 16:34:14","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":"","currentDayPrice":"84.44","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":"3109029","reservation_id":"96711","confirmation_number":"SJ12611267945","room_stay_from":"2020-07-24","room_stay_to":"2020-07-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.44,84.44,84.44,84.44,84.44","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"422.20","grand_total":"474.98","paid_amount":"140.63","room_type_id":"319","product_id":"1312","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-06-17 16:40:11","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":"","currentDayPrice":"84.44","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":"3113312","reservation_id":"97056","confirmation_number":"SJ12614917915","room_stay_from":"2020-07-26","room_stay_to":"2020-07-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00","nightly_discount":"0.00,0.00,0.00","subtotal":"285.00","grand_total":"320.63","paid_amount":"0.00","room_type_id":"319","product_id":"1309","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-06-25 01:43:50","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.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":"3113327","reservation_id":"97057","confirmation_number":"SJ12642720104","room_stay_from":"2020-07-26","room_stay_to":"2020-07-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00","nightly_discount":"0.00,0.00,0.00","subtotal":"285.00","grand_total":"320.63","paid_amount":"84.38","room_type_id":"319","product_id":"1310","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-06-25 01:46:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.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"}]}],"negotiated_non_taxable":[{"room_stay_id":"3116608","reservation_id":"96596","confirmation_number":"SJ12637201830","room_stay_from":"2020-07-22","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.00","paid_amount":"0.00","room_type_id":"412","product_id":"1866","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 02:10:12","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":"","currentDayPrice":"78.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3105999","reservation_id":"96588","confirmation_number":"SJ12693034191","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 01:36:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3106004","reservation_id":"96589","confirmation_number":"SJ12655511190","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 01:38:33","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107011","reservation_id":"96590","confirmation_number":"SJ12696030417","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"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":"2020-06-16 01:39:59","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107020","reservation_id":"96591","confirmation_number":"SJ12644077479","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"413","product_id":"1268","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 01:44:03","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3114180","reservation_id":"97466","confirmation_number":"SJ12616041468","room_confirmation_number":"SJ12675924202","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"103545","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-07-09 17:27:30","reservation_modified_date_time":"2020-07-09 17:27:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103545","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3116609","reservation_id":"96596","confirmation_number":"SJ12653186227","room_confirmation_number":"SJ12637201830","room_stay_from":"2020-07-22","room_stay_to":"2020-07-27","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":"102707","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 02:10:12","reservation_modified_date_time":"2020-07-16 20:41:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116756","reservation_id":"95003","confirmation_number":"SJ12691666835","room_confirmation_number":"SJ12677057928","room_stay_from":"2020-07-23","room_stay_to":"2020-07-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":"101196","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 00:21:09","reservation_modified_date_time":"2020-07-17 01:45:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101196","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117503","reservation_id":"97920","confirmation_number":"SJ12623689214","room_confirmation_number":"SJ12663196097","room_stay_from":"2020-07-24","room_stay_to":"2020-07-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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"103988","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-18 19:16:01","reservation_modified_date_time":"2020-07-18 19:16:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103988","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119317","reservation_id":"95004","confirmation_number":"SJ12653785807","room_confirmation_number":"SJ12640169917","room_stay_from":"2020-07-23","room_stay_to":"2020-07-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":"101197","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 00:37:07","reservation_modified_date_time":"2020-07-23 23:39:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101197","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119350","reservation_id":"98115","confirmation_number":"SJ12684413366","room_confirmation_number":"SJ12673936438","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104185","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-24 12:12:52","reservation_modified_date_time":"2020-07-24 12:12:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104185","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119505","reservation_id":"98127","confirmation_number":"SJ12628910829","room_confirmation_number":"SJ12646648378","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104196","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-24 17:16:42","reservation_modified_date_time":"2020-07-24 17:16:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104196","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119943","reservation_id":"98169","confirmation_number":"SJ12629438636","room_confirmation_number":"SJ12626149083","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-25 18:04:27","reservation_modified_date_time":"2020-07-25 18:04:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104236","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119974","reservation_id":"98172","confirmation_number":"SJ12697935248","room_confirmation_number":"SJ12662272752","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104238","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-25 18:26:12","reservation_modified_date_time":"2020-07-25 18:26:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104238","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120012","reservation_id":"97998","confirmation_number":"SJ12682072402","room_confirmation_number":"SJ12682072401","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104067","product_attribute_values":"resort_fee#&#flat_rate#&#25.00","reservation_created_date":"2020-07-21 00:28:09","reservation_modified_date_time":"2020-07-25 20:28:49","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104067","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120122","reservation_id":"95095","confirmation_number":"SJ12643103331","room_confirmation_number":"SJ12664636390","room_stay_from":"2020-07-23","room_stay_to":"2020-07-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":"101276","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 01:32:12","reservation_modified_date_time":"2020-07-26 12:08:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101276","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.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":"3120144","reservation_id":"95093","confirmation_number":"SJ12693461394","room_confirmation_number":"SJ12642228518","room_stay_from":"2020-07-23","room_stay_to":"2020-07-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":"101274","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 01:28:15","reservation_modified_date_time":"2020-07-26 12:14:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101274","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.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":"3120489","reservation_id":"97811","confirmation_number":"SJ12673909476","room_confirmation_number":"SJ12664944560","room_stay_from":"2020-07-24","room_stay_to":"2020-07-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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"103882","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-16 11:38:10","reservation_modified_date_time":"2020-07-26 23:18:03","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103882","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3111526","reservation_id":"97282","confirmation_number":"SJ12668606718","room_confirmation_number":"SJ12679975597","room_stay_from":"2020-07-23","room_stay_to":"2020-07-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":"103375","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-01 21:56:09","reservation_modified_date_time":"2020-07-01 21:56:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3114181","reservation_id":"97466","confirmation_number":"SJ12654219319","room_confirmation_number":"SJ12675924202","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","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":"103545","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-06 23:49:00","reservation_modified_date_time":"2020-07-09 17:27:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103545","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116840","reservation_id":"97853","confirmation_number":"SJ12645710375","room_confirmation_number":"SJ12620030798","room_stay_from":"2020-07-23","room_stay_to":"2020-07-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":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"103919","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-17 11:26:45","reservation_modified_date_time":"2020-07-17 11:26:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103919","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118657","reservation_id":"97846","confirmation_number":"SJ12652574952","room_confirmation_number":"SJ12639459090","room_stay_from":"2020-07-23","room_stay_to":"2020-07-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":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"103914","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-17 00:55:37","reservation_modified_date_time":"2020-07-21 22:00:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103914","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119251","reservation_id":"97199","confirmation_number":"SJ12695091303","room_confirmation_number":"SJ12655710304","room_stay_from":"2020-07-23","room_stay_to":"2020-07-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":"103300","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-28 21:44:20","reservation_modified_date_time":"2020-07-23 21:06:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119655","reservation_id":"97585","confirmation_number":"SJ12636425611","room_confirmation_number":"SJ12645665642","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"103661","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-09 19:29:07","reservation_modified_date_time":"2020-07-24 19:58:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103661","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119940","reservation_id":"98152","confirmation_number":"SJ12682149766","room_confirmation_number":"SJ12642248693","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104229","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-25 14:44:11","reservation_modified_date_time":"2020-07-25 17:49:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104229","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120161","reservation_id":"95550","confirmation_number":"SJ12692871346","room_confirmation_number":"SJ12617408885","room_stay_from":"2020-07-26","room_stay_to":"2020-07-28","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":"101732","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 17:01:06","reservation_modified_date_time":"2020-07-26 12:57:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101732","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109028","reservation_id":"96710","confirmation_number":"SJ12683393251","room_confirmation_number":"SJ12674033126","room_stay_from":"2020-07-24","room_stay_to":"2020-07-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-17 16:34:14","reservation_modified_date_time":"2020-06-23 16:10:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109030","reservation_id":"96711","confirmation_number":"SJ12651852339","room_confirmation_number":"SJ12611267945","room_stay_from":"2020-07-24","room_stay_to":"2020-07-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-17 16:40:11","reservation_modified_date_time":"2020-06-23 16:11:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3113314","reservation_id":"97056","confirmation_number":"SJ12685886352","room_confirmation_number":"SJ12614917915","room_stay_from":"2020-07-26","room_stay_to":"2020-07-29","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103175","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-25 01:43:50","reservation_modified_date_time":"2020-07-06 20:39:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3113328","reservation_id":"97057","confirmation_number":"SJ12689549506","room_confirmation_number":"SJ12642720104","room_stay_from":"2020-07-26","room_stay_to":"2020-07-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-25 01:46:52","reservation_modified_date_time":"2020-07-06 20:42:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119249","reservation_id":"97670","confirmation_number":"SJ12670607075","room_confirmation_number":"SJ12669827674","room_stay_from":"2020-07-25","room_stay_to":"2020-07-30","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":"103746","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-11 20:36:37","reservation_modified_date_time":"2020-07-23 21:05:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103746","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117643","reservation_id":"97941","confirmation_number":"SJ12612551353","room_confirmation_number":"SJ12645743914","room_stay_from":"2020-07-24","room_stay_to":"2020-07-31","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":"104009","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-19 01:19:45","reservation_modified_date_time":"2020-07-19 01:19:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104009","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118831","reservation_id":"98051","confirmation_number":"SJ12659177887","room_confirmation_number":"SJ12684507683","room_stay_from":"2020-07-26","room_stay_to":"2020-07-31","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":"104115","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-22 16:42:33","reservation_modified_date_time":"2020-07-22 16:42:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104115","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119414","reservation_id":"97022","confirmation_number":"SJ12644558317","room_confirmation_number":"SJ12690712901","room_stay_from":"2020-07-24","room_stay_to":"2020-07-31","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":"103142","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-24 00:56:51","reservation_modified_date_time":"2020-07-24 12:53:08","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119531","reservation_id":"91368","confirmation_number":"SJ12637207607","room_confirmation_number":"SJ12617390124","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"97495","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-05 18:48:10","reservation_modified_date_time":"2020-07-24 17:38:29","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97495","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3094800","reservation_id":"94959","confirmation_number":"SJ12649441442","room_confirmation_number":"SJ12673001401","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","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":"101147","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 15:48:50","reservation_modified_date_time":"2020-05-18 15:48:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101147","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3105742","reservation_id":"96540","confirmation_number":"SJ12647498418","room_confirmation_number":"SJ12648416794","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"102647","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 15:05:07","reservation_modified_date_time":"2020-06-15 15:05:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84637","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3106000","reservation_id":"96588","confirmation_number":"SJ12686722107","room_confirmation_number":"SJ12693034191","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"102702","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:36:52","reservation_modified_date_time":"2020-06-16 01:36:52","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3106005","reservation_id":"96589","confirmation_number":"SJ12684164813","room_confirmation_number":"SJ12655511190","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"102703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:38:33","reservation_modified_date_time":"2020-06-16 01:38:33","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107028","reservation_id":"96523","confirmation_number":"SJ12620317592","room_confirmation_number":"SJ12671312898","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","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":"102629","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 02:29:09","reservation_modified_date_time":"2020-06-18 12:47:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102629","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3113367","reservation_id":"93587","confirmation_number":"SJ12637257008","room_confirmation_number":"SJ12696472420","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"99816","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-24 21:57:09","reservation_modified_date_time":"2020-07-06 20:53:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99816","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3114388","reservation_id":"97118","confirmation_number":"SJ12643657961","room_confirmation_number":"SJ12648875545","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"103236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 17:53:20","reservation_modified_date_time":"2020-07-10 01:05:11","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107014","reservation_id":"96590","confirmation_number":"SJ12626622188","room_confirmation_number":"SJ12696030417","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","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":"102704","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:39:59","reservation_modified_date_time":"2020-06-18 12:41:46","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107022","reservation_id":"96591","confirmation_number":"SJ12624927899","room_confirmation_number":"SJ12644077479","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","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":"102704","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:44:03","reservation_modified_date_time":"2020-06-18 12:45:58","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119928","reservation_id":"97689","confirmation_number":"SJ12613152976","room_confirmation_number":"SJ12668652431","room_stay_from":"2020-07-25","room_stay_to":"2020-08-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"103760","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-12 12:33:42","reservation_modified_date_time":"2020-07-25 17:33:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103760","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120305","reservation_id":"97825","confirmation_number":"SJ12611917303","room_confirmation_number":"SJ12666215686","room_stay_from":"2020-07-30","room_stay_to":"2020-08-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"84865","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-16 19:27:15","reservation_modified_date_time":"2020-07-26 16:28:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84865","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120372","reservation_id":"97694","confirmation_number":"SJ12626179722","room_confirmation_number":"SJ12631152138","room_stay_from":"2020-07-30","room_stay_to":"2020-08-01","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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"103766","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-12 17:19:46","reservation_modified_date_time":"2020-07-26 20:43:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103766","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120437","reservation_id":"98046","confirmation_number":"SJ12629100382","room_confirmation_number":"SJ12652139180","room_stay_from":"2020-07-27","room_stay_to":"2020-07-31","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"104112","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-22 16:01:32","reservation_modified_date_time":"2020-07-26 22:12:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104112","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120153","reservation_id":"95012","confirmation_number":"SJ12621976071","room_confirmation_number":"SJ12652680590","room_stay_from":"2020-07-25","room_stay_to":"2020-07-27","room_stay_status":"Canceled","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-19 01:46:10","reservation_modified_date_time":"2020-07-26 12:39:19","customer_id":"101203","parentCustTravId":"101203","customer_traveller_id":"101203","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-07-26 12:39:25","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","deltaChange":-25,"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":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[{"room_stay_id":"3117608","reservation_id":"96887","confirmation_number":"SJ12634598202","room_confirmation_number":"SJ12635200399","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"268.75","grand_total":"268.75","paid_amount":"0.00","product_id":"1231","service_quantity":"1","product_name":"Boat Slip47A 07\/15-07\/19","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-18 23:46:34","reservation_modified_date_time":"2020-07-18 23:46:34","customer_id":"103011","parentCustTravId":"103011","customer_traveller_id":"103011","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-07-26 14:18:43","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-268.75,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"bar_taxable":[{"room_stay_id":"3120324","reservation_id":"98210","confirmation_number":"SJ12690475823","room_confirmation_number":"SJ12687783523","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-26 17:38:41","reservation_modified_date_time":"2020-07-26 17:38:41","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}