{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-06-13","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":9,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1262,1307,1297,1943","block_room_bookings":[{"confirmation_number":"SJ12672097396","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","bundle_room":"0"},{"confirmation_number":"SJ12664166752","room_stay_from":"2020-06-07","room_stay_to":"2020-06-18","bundle_room":"0"},{"confirmation_number":"SJ12640607785","room_stay_from":"2020-06-07","room_stay_to":"2020-06-22","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-04","room_stay_to":"2020-06-27","bundle_room":"0"}],"bundle_block_count":"1260,1261,1302,1303,1304,1305,1267,1268,1271,1272,1309,1310,1311,1312,1262,1263,1291,1711,1269,1270,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12663825370","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","bundle_room":"1"},{"confirmation_number":"SJB12680276506","room_stay_from":"2020-06-10","room_stay_to":"2020-06-14","bundle_room":"1"},{"confirmation_number":"SJB12633057221","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","bundle_room":"1"},{"confirmation_number":"SJB12695919421","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","bundle_room":"0"},{"confirmation_number":"SJB12617565631","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","bundle_room":"0"},{"confirmation_number":"SJB12637535378","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","bundle_room":"1"},{"confirmation_number":"SJB12648387374","room_stay_from":"2020-06-10","room_stay_to":"2020-06-14","bundle_room":"1"},{"confirmation_number":"SJB12660450079","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","bundle_room":"1"},{"confirmation_number":"SJB12696220569","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","bundle_room":"1"},{"confirmation_number":"SJB12687781177","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","bundle_room":"1"},{"confirmation_number":"SJB12665801229","room_stay_from":"2020-06-13","room_stay_to":"2020-06-16","bundle_room":"1"},{"confirmation_number":"SJB12627926228","room_stay_from":"2020-06-07","room_stay_to":"2020-06-18","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3087168","reservation_id":"93860","confirmation_number":"SJ12631421790","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"151.20,175.20","nightly_discount":"0,0","subtotal":"326.40","grand_total":"367.20","paid_amount":"367.20","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-3594650265","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":"100094","customer_id":"100094","source_of_creation":"Booking.com","reservation_created_date":"2020-04-15 22:48:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"67.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"175.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3097648","reservation_id":"95148","confirmation_number":"SJ12661112643","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.80,136.80","nightly_discount":"0,0","subtotal":"273.60","grand_total":"307.80","paid_amount":"307.80","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-3257551490","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":"101330","customer_id":"101330","source_of_creation":"Booking.com","reservation_created_date":"2020-05-20 19:52:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"58.25","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136.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":"3098368","reservation_id":"95543","confirmation_number":"SJ12652060899","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"149.2,179.6","nightly_discount":"0,0","subtotal":"328.80","grand_total":"369.90","paid_amount":"369.90","room_type_id":"319","product_id":"1291","siteminder_id":"BDC-2285804153","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101726","customer_id":"101726","source_of_creation":"Booking.com","reservation_created_date":"2020-05-28 14:50:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"78.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.6","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3102277","reservation_id":"94755","confirmation_number":"SJ12667074048","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.88,164.88","nightly_discount":"0,0","subtotal":"329.76","grand_total":"370.98","paid_amount":"370.98","room_type_id":"319","product_id":"1293","siteminder_id":"BDC-2298024853","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":"100958","customer_id":"100958","source_of_creation":"Booking.com","reservation_created_date":"2020-05-13 20:05:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"68.36","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"164.88","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":"3103561","reservation_id":"94979","confirmation_number":"SJ12684983236","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,119.20","nightly_discount":"0,0","subtotal":"238.40","grand_total":"268.20","paid_amount":"268.20","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-2526210495","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":"101479","customer_id":"101479","source_of_creation":"Booking.com","reservation_created_date":"2020-05-18 19:18:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"51.91","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"}]},{"room_stay_id":"3103776","reservation_id":"96232","confirmation_number":"SJ12627738528","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.40,239.20,274.40","nightly_discount":"0,0,0","subtotal":"680.00","grand_total":"765.00","paid_amount":"765.00","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3831564864","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":"102354","customer_id":"102354","source_of_creation":"Booking.com","reservation_created_date":"2020-06-10 17:02:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"45.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"274.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3104093","reservation_id":"95392","confirmation_number":"SJ12668941161","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.60","nightly_discount":"0","subtotal":"173.60","grand_total":"195.30","paid_amount":"195.30","room_type_id":"319","product_id":"1311","siteminder_id":"BDC-2285806198","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":"101584","customer_id":"101584","source_of_creation":"Booking.com","reservation_created_date":"2020-05-25 19:34:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"35.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"173.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3098356","reservation_id":"95543","confirmation_number":"SJ12689441604","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"149.2,179.6,100.4","nightly_discount":"0,0,0","subtotal":"429.20","grand_total":"482.85","paid_amount":"482.85","room_type_id":"319","product_id":"1711","siteminder_id":"BDC-2285804153","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101726","customer_id":"101726","source_of_creation":"Booking.com","reservation_created_date":"2020-05-28 14:50:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"235.51","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.6","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103267","reservation_id":"96164","confirmation_number":"SJ12685413781","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"233.2,276.4,196.4","nightly_discount":"0,0,0","subtotal":"706.00","grand_total":"794.25","paid_amount":"794.25","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-3831545816","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102292","customer_id":"102292","source_of_creation":"Booking.com","reservation_created_date":"2020-06-09 16:02:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"335.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"276.4","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":"3103286","reservation_id":"96164","confirmation_number":"SJ12627275590","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"233.2,276.4,196.4","nightly_discount":"0,0,0","subtotal":"706.00","grand_total":"794.25","paid_amount":"794.25","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-3831545816","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102292","customer_id":"102292","source_of_creation":"Booking.com","reservation_created_date":"2020-06-09 16:02:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"335.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"276.4","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":"3103930","reservation_id":"95385","confirmation_number":"SJ12673158128","room_stay_from":"2020-06-11","room_stay_to":"2020-06-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"136.80,181.60,181.60,136.80,136.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"773.60","grand_total":"870.30","paid_amount":"870.30","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-2637477104","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":"101577","customer_id":"101577","source_of_creation":"Booking.com","reservation_created_date":"2020-05-25 18:04:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"44.21","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"181.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3105131","reservation_id":"96206","confirmation_number":"SJ12647932372","room_stay_from":"2020-08-25","room_stay_to":"2020-08-27","room_stay_status":"Active","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"84,84","nightly_discount":"0,0","subtotal":"168.00","grand_total":"189.00","paid_amount":"133.88","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-3120256849","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102328","customer_id":"102328","source_of_creation":"Booking.com","reservation_created_date":"2020-06-10 01:48:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"48.24","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"}]},{"room_stay_id":"3105148","reservation_id":"94485","confirmation_number":"SJ12662278872","room_stay_from":"2020-06-14","room_stay_to":"2020-06-15","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"151.20","nightly_discount":"0","subtotal":"151.20","grand_total":"170.10","paid_amount":"0.00","room_type_id":"413","product_id":"1262","siteminder_id":"BDC-3936528206","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":"100695","customer_id":"100695","source_of_creation":"Booking.com","reservation_created_date":"2020-05-06 12:50:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"31.72","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3090867","reservation_id":"94388","confirmation_number":"SJ12688187984","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.76,149.76","nightly_discount":"0,0","subtotal":"299.52","grand_total":"336.96","paid_amount":"336.96","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1662687714","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":"100602","customer_id":"100602","source_of_creation":"Expedia","reservation_created_date":"2020-05-03 18:02:05","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.76","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":"3094933","reservation_id":"94989","confirmation_number":"SJ12624639946","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"201.60,201.60","nightly_discount":"0,0","subtotal":"403.20","grand_total":"453.60","paid_amount":"453.60","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1664712520","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":"101182","customer_id":"101182","source_of_creation":"Expedia","reservation_created_date":"2020-05-18 22:07:09","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":"201.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3096147","reservation_id":"95152","confirmation_number":"SJ12637124362","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.80,136.80","nightly_discount":"0,0","subtotal":"273.60","grand_total":"307.80","paid_amount":"307.80","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1665055147","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":"101335","customer_id":"101335","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 20:57:10","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":"136.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":"3098220","reservation_id":"94990","confirmation_number":"SJ12623489824","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"161.28,161.28","nightly_discount":"0,0","subtotal":"322.56","grand_total":"362.88","paid_amount":"362.88","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1664712862","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":"101183","customer_id":"101183","source_of_creation":"Expedia","reservation_created_date":"2020-05-18 22:11:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"161.28","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101246","reservation_id":"95016","confirmation_number":"SJ12617280067","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,119.20","nightly_discount":"0,0","subtotal":"238.40","grand_total":"268.20","paid_amount":"268.20","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1664757425","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":"101206","customer_id":"101206","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 02:36:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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"}]},{"room_stay_id":"3103633","reservation_id":"95137","confirmation_number":"SJ12632821326","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.60,185.60","nightly_discount":"0,0","subtotal":"371.20","grand_total":"417.60","paid_amount":"417.60","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1665033728","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":"101318","customer_id":"101318","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 18:47: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":"185.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103834","reservation_id":"95088","confirmation_number":"SJ12651485681","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.56,95.36,95.36","nightly_discount":"0,0,0","subtotal":"273.28","grand_total":"307.44","paid_amount":"307.44","room_type_id":"319","product_id":"1305","siteminder_id":"EXP-1664919290","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":"101270","customer_id":"101270","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 01:12:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.36","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103935","reservation_id":"95113","confirmation_number":"SJ12690148968","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.72,91.52,91.52","nightly_discount":"0,0,0","subtotal":"261.76","grand_total":"294.48","paid_amount":"294.48","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1664988932","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":"101296","customer_id":"101296","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 13:41:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.52","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":"3104704","reservation_id":"96272","confirmation_number":"SJ12691609174","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"191.36,219.52","nightly_discount":"0,0","subtotal":"410.88","grand_total":"462.24","paid_amount":"462.24","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1669779733","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":"102395","customer_id":"102395","source_of_creation":"Expedia","reservation_created_date":"2020-06-11 12:16:09","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":"219.52","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":"3103818","reservation_id":"95047","confirmation_number":"SJ12654129472","room_stay_from":"2020-06-11","room_stay_to":"2020-06-15","room_stay_status":"Checked-In","room_stay_guest_count":"1","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":"1304","siteminder_id":"EXP-1664827429","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":"101234","customer_id":"101234","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 15:41:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.52","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":[{"room_stay_id":"3104964","reservation_id":"92209","confirmation_number":"SJ12697296697","room_stay_from":"2020-06-13","room_stay_to":"2020-06-17","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.20,135.20,135.20,135.20","nightly_discount":"0,0,0,0","subtotal":"724.00","grand_total":"814.50","paid_amount":"814.50","room_type_id":"319","product_id":"1312","siteminder_id":"EXP-1644850985","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":"98396","customer_id":"98396","source_of_creation":"Expedia","reservation_created_date":"2020-02-19 20:18:09","service_canceled_date_time":"2020-06-13 17:13:35","canceled_nights_data":"a:7:{s:6:\"nights\";a:1:{i:0;s:10:\"2020-06-12\";}s:13:\"nightly_price\";a:1:{i:0;s:6:\"159.20\";}s:18:\"orig_nightly_price\";a:1:{i:0;s:6:\"159.20\";}s:16:\"nightly_discount\";a:1:{i:0;s:1:\"0\";}s:13:\"rate_plan_ids\";a:1:{i:0;s:6:\"NR3EPA\";}s:24:\"product_discount_comment\";a:1:{i:0;s:0:\"\";}s:11:\"fromToNight\";a:1:{i:0;s:4:\"from\";}}","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"814.50","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"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":"3104120","reservation_id":"70676","confirmation_number":"SJ12689249249","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.74,189.74,189.74","nightly_discount":"0.00,0.00,0.00","subtotal":"569.22","grand_total":"640.37","paid_amount":"640.37","room_type_id":"319","product_id":"1301","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82532","customer_id":"82532","source_of_creation":"FE","reservation_created_date":"2019-03-01 23:47:31","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":"189.74","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":"3104682","reservation_id":"96209","confirmation_number":"SJ12694006888","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"243.24,279.73","nightly_discount":"0.00,0.00","subtotal":"522.97","grand_total":"588.34","paid_amount":"588.34","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":"102280","customer_id":"102280","source_of_creation":"FE","reservation_created_date":"2020-06-10 03:01:29","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":"279.73","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":"3104677","reservation_id":"96152","confirmation_number":"SJ12695098983","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"232.02,266.82,201.76","nightly_discount":"0.00,0.00,0.00","subtotal":"700.60","grand_total":"788.18","paid_amount":"788.18","room_type_id":"319","product_id":"1275","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":"102279","customer_id":"102279","source_of_creation":"FE","reservation_created_date":"2020-06-09 02:43:00","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"266.82","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":"3094736","reservation_id":"94946","confirmation_number":"SJ12666968800","room_stay_from":"2020-06-13","room_stay_to":"2020-06-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"142.55,122.55,122.55","nightly_discount":"0.00,0.00,0.00","subtotal":"387.65","grand_total":"436.10","paid_amount":"436.10","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101136","customer_id":"101136","source_of_creation":"FE","reservation_created_date":"2020-05-18 12:06:42","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":"142.55","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":"3095073","reservation_id":"95033","confirmation_number":"SJ12682052493","room_stay_from":"2020-06-13","room_stay_to":"2020-06-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"142.55,122.55,122.55","nightly_discount":"0.00,0.00,0.00","subtotal":"387.65","grand_total":"436.10","paid_amount":"436.10","room_type_id":"413","product_id":"1269","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":"101165","customer_id":"101165","source_of_creation":"FE","reservation_created_date":"2020-05-19 13:06:23","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"142.55","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":"3099775","reservation_id":"93004","confirmation_number":"SJ12697538082","room_stay_from":"2020-06-13","room_stay_to":"2020-06-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.73,211.51,185.33","nightly_discount":"0.00,0.00,0.00","subtotal":"676.57","grand_total":"761.14","paid_amount":"761.14","room_type_id":"412","product_id":"1866","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":"99178","customer_id":"99178","source_of_creation":"FE","reservation_created_date":"2020-03-06 02:20:42","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":"279.73","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":"3096230","reservation_id":"95237","confirmation_number":"SJ12625663064","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.52,175.52","nightly_discount":"0.00,0.00","subtotal":"351.04","grand_total":"394.92","paid_amount":"394.92","room_type_id":"413","product_id":"1260","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":"101423","source_of_creation":"PMS","reservation_created_date":"2020-05-22 15:11:58","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"175.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":"3096233","reservation_id":"95237","confirmation_number":"SJ12682104638","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.52,175.52","nightly_discount":"0.00,0.00","subtotal":"351.04","grand_total":"394.92","paid_amount":"394.92","room_type_id":"413","product_id":"1261","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":"101423","source_of_creation":"PMS","reservation_created_date":"2020-05-22 15:11:58","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"175.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":"3098354","reservation_id":"95307","confirmation_number":"SJ12696900183","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"197.05,197.05","nightly_discount":"0.00,0.00","subtotal":"394.10","grand_total":"443.37","paid_amount":"443.37","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101494","customer_id":"101494","source_of_creation":"PMS","reservation_created_date":"2020-05-23 21:38:30","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":"197.05","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":"3103055","reservation_id":"96122","confirmation_number":"SJ12638773559","room_stay_from":"2020-06-10","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.33,185.33,243.24,279.73","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"893.63","grand_total":"1005.33","paid_amount":"1005.33","room_type_id":"319","product_id":"1310","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102249","customer_id":"102249","source_of_creation":"PMS","reservation_created_date":"2020-06-08 21:10:08","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":"279.73","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":"3103555","reservation_id":"96188","confirmation_number":"SJ12659392304","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"200.00,200.00,200.00","nightly_discount":"0.00,0.00,0.00","subtotal":"600.00","grand_total":"675.00","paid_amount":"675.00","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102312","customer_id":"102312","source_of_creation":"PMS","reservation_created_date":"2020-06-09 22:38:14","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"200.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":"3103566","reservation_id":"95914","confirmation_number":"SJ12655825060","room_stay_from":"2020-06-10","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.45,160.45,214.63,246.82","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"782.35","grand_total":"880.15","paid_amount":"880.15","room_type_id":"319","product_id":"1302","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88571","customer_id":"88571","source_of_creation":"PMS","reservation_created_date":"2020-06-04 20:37:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"246.82","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":"3103660","reservation_id":"96217","confirmation_number":"SJ12681102837","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"202.47,232.84","nightly_discount":"0.00,0.00","subtotal":"435.31","grand_total":"489.73","paid_amount":"489.73","room_type_id":"319","product_id":"1942","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":"102339","customer_id":"102339","source_of_creation":"PMS","reservation_created_date":"2020-06-10 13:47:30","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":"232.84","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":"3103828","reservation_id":"95915","confirmation_number":"SJ12698014034","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.45,214.63,246.82","nightly_discount":"0.00,0.00,0.00","subtotal":"621.90","grand_total":"699.64","paid_amount":"699.64","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":"88530","customer_id":"88530","source_of_creation":"PMS","reservation_created_date":"2020-06-04 20:40:13","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":"246.82","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":"3103909","reservation_id":"96267","confirmation_number":"SJ12638081565","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"465.68","nightly_discount":"0.00","subtotal":"465.68","grand_total":"523.89","paid_amount":"523.89","room_type_id":"320","product_id":"1322","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102390","customer_id":"102390","source_of_creation":"PMS","reservation_created_date":"2020-06-11 01:43:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"465.68","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":"3104100","reservation_id":"96293","confirmation_number":"SJ12679744243","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"232.84","nightly_discount":"0.00","subtotal":"232.84","grand_total":"261.94","paid_amount":"261.94","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":"102418","customer_id":"102418","source_of_creation":"PMS","reservation_created_date":"2020-06-11 21:11:39","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"232.84","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":"3104114","reservation_id":"96297","confirmation_number":"SJ12627344172","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.47,232.84","nightly_discount":"0.00,0.00","subtotal":"435.31","grand_total":"489.73","paid_amount":"489.73","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":"102422","customer_id":"102422","source_of_creation":"PMS","reservation_created_date":"2020-06-11 21:41:36","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":"","currentDayPrice":"232.84","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":"3104160","reservation_id":"96302","confirmation_number":"SJ12662103385","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"243.24,279.73","nightly_discount":"60.81,69.93","subtotal":"522.97","grand_total":"441.26","paid_amount":"441.26","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":"102427","customer_id":"102427","source_of_creation":"PMS","reservation_created_date":"2020-06-11 22:49:42","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":"279.73","currentDayDiscount":"69.93","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3104366","reservation_id":"96345","confirmation_number":"SJ12611863132","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"292.63","nightly_discount":"0.00","subtotal":"292.63","grand_total":"329.21","paid_amount":"329.21","room_type_id":"411","product_id":"1296","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102458","customer_id":"102458","source_of_creation":"PMS","reservation_created_date":"2020-06-12 14:30:15","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"292.63","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":"3105105","reservation_id":"96450","confirmation_number":"SJ12653990499","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.00","nightly_discount":"0.00","subtotal":"280.00","grand_total":"315.00","paid_amount":"315.00","room_type_id":"319","product_id":"1313","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":"102161","customer_id":"102161","source_of_creation":"PMS","reservation_created_date":"2020-06-13 20:47:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"280.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":"3105107","reservation_id":"96451","confirmation_number":"SJ12678662769","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"292.63","nightly_discount":"0.00","subtotal":"292.63","grand_total":"329.21","paid_amount":"329.21","room_type_id":"319","product_id":"1312","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":"102161","customer_id":"102161","source_of_creation":"PMS","reservation_created_date":"2020-06-13 20:52:18","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":"292.63","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":"3105157","reservation_id":"96456","confirmation_number":"SJ12628093984","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"292.63","nightly_discount":"0.00","subtotal":"292.63","grand_total":"329.21","paid_amount":"329.21","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":"102566","customer_id":"102566","source_of_creation":"PMS","reservation_created_date":"2020-06-13 22:19:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"292.63","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":"3103552","reservation_id":"95746","confirmation_number":"SJ12687052278","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,179.00,179.00","nightly_discount":"0.00,0.00,0.00","subtotal":"573.00","grand_total":"644.63","paid_amount":"644.63","room_type_id":"319","product_id":"1308","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96738","customer_id":"96738","source_of_creation":"PMS","reservation_created_date":"2020-06-01 15:46:50","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":"179.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":"3104725","reservation_id":"89522","confirmation_number":"SJ12674994384","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.52,188.52,162.07","nightly_discount":"188.52,40.99,0.00","subtotal":"539.11","grand_total":"348.30","paid_amount":"348.30","room_type_id":"319","product_id":"1915","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84865","customer_id":"84865","source_of_creation":"PMS","reservation_created_date":"2020-01-07 21:15:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"188.52","currentDayDiscount":"40.99","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3105166","reservation_id":"96460","confirmation_number":"SJ12671446611","room_stay_from":"2020-06-13","room_stay_to":"2020-06-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"292.63,221.27","nightly_discount":"0.00,0.00","subtotal":"513.90","grand_total":"578.14","paid_amount":"578.14","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102569","customer_id":"102569","source_of_creation":"PMS","reservation_created_date":"2020-06-13 23:05:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"292.63","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":"3105202","reservation_id":"96116","confirmation_number":"SJ12613967995","room_stay_from":"2020-06-10","room_stay_to":"2020-06-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.33,185.33,243.24,279.73,279.73","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"1173.36","grand_total":"1320.03","paid_amount":"1005.33","room_type_id":"319","product_id":"1309","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102238","customer_id":"102238","source_of_creation":"PMS","reservation_created_date":"2020-06-08 19:27:53","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"279.73","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":"3104437","reservation_id":"96181","confirmation_number":"SJ12650988608","room_stay_from":"2020-06-12","room_stay_to":"2020-06-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"119.20,119.20,103.20,103.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"444.80","grand_total":"500.40","paid_amount":"500.40","room_type_id":"413","product_id":"1272","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102307","customer_id":"102307","source_of_creation":"PMS","reservation_created_date":"2020-06-09 19:37:14","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3104050","reservation_id":"96190","confirmation_number":"SJ12680438479","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"292.63","nightly_discount":"0.00","subtotal":"292.63","grand_total":"329.21","paid_amount":"329.21","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":"102315","customer_id":"102315","source_of_creation":"PMS","reservation_created_date":"2020-06-09 22:45:14","service_canceled_date_time":"2020-06-13 15:04:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"329.21","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3104428","reservation_id":"96295","confirmation_number":"SJ12677435087","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"0.00","room_type_id":"319","product_id":"1314","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-11 21:37:51","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.33","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3097650","reservation_id":"95419","confirmation_number":"SJ12686780250","room_stay_from":"2020-06-13","room_stay_to":"2020-06-20","room_stay_status":"Active","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":"0.00","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-26 16:12:06","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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3098366","reservation_id":"95543","confirmation_number":"SJ12636605718","room_confirmation_number":"SJ12652060899","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"101726","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-05-28 15:15:03","reservation_modified_date_time":"2020-05-28 15:15:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101726","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","currentDayPrice":"50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103911","reservation_id":"96267","confirmation_number":"SJ12685433287","room_confirmation_number":"SJ12638081565","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Active","nightly_price":"50.00","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"102390","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-06-11 01:43:08","reservation_modified_date_time":"2020-06-11 01:43:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102390","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"50.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":"3098358","reservation_id":"95543","confirmation_number":"SJ12670023921","room_confirmation_number":"SJ12689441604","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"101726","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-05-28 15:14:46","reservation_modified_date_time":"2020-05-28 15:14:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101726","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103268","reservation_id":"96164","confirmation_number":"SJ12673643337","room_confirmation_number":"SJ12685413781","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"102292","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-06-09 16:02:10","reservation_modified_date_time":"2020-06-09 16:02:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102292","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103287","reservation_id":"96164","confirmation_number":"SJ12633391423","room_confirmation_number":"SJ12627275590","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"102292","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-06-09 16:27:37","reservation_modified_date_time":"2020-06-09 16:27:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102292","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3087169","reservation_id":"93860","confirmation_number":"SJ12639198242","room_confirmation_number":"SJ12631421790","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"100094","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-04-15 22:48:11","reservation_modified_date_time":"2020-04-15 22:48:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100094","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":"3090868","reservation_id":"94388","confirmation_number":"SJ12625460691","room_confirmation_number":"SJ12688187984","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"100602","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-03 18:02:05","reservation_modified_date_time":"2020-05-03 18:02:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100602","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":"3094934","reservation_id":"94989","confirmation_number":"SJ12695484963","room_confirmation_number":"SJ12624639946","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"101182","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 22:07:09","reservation_modified_date_time":"2020-05-18 22:07:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101182","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":"3096146","reservation_id":"95152","confirmation_number":"SJ12682450147","room_confirmation_number":"SJ12637124362","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"101335","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 20:57:10","reservation_modified_date_time":"2020-05-20 20:57:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101335","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":"3096231","reservation_id":"95237","confirmation_number":"SJ12661659955","room_confirmation_number":"SJ12625663064","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"84865","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-22 15:11:58","reservation_modified_date_time":"2020-05-22 15:11:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101423","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":"3096234","reservation_id":"95237","confirmation_number":"SJ12615870357","room_confirmation_number":"SJ12682104638","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"84865","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-22 15:11:58","reservation_modified_date_time":"2020-05-22 15:11:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101423","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":"3097649","reservation_id":"95148","confirmation_number":"SJ12694564408","room_confirmation_number":"SJ12661112643","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"101330","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 19:52:10","reservation_modified_date_time":"2020-05-26 16:10:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101330","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":"3098221","reservation_id":"94990","confirmation_number":"SJ12626779806","room_confirmation_number":"SJ12623489824","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"101183","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 22:11:06","reservation_modified_date_time":"2020-05-27 20:10:18","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101183","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":"3098355","reservation_id":"95307","confirmation_number":"SJ12649678259","room_confirmation_number":"SJ12696900183","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"101494","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-23 21:38:30","reservation_modified_date_time":"2020-05-28 15:14:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101494","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":"3098367","reservation_id":"95543","confirmation_number":"SJ12692753084","room_confirmation_number":"SJ12652060899","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"101726","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 14:50:17","reservation_modified_date_time":"2020-05-28 15:15:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101726","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3101248","reservation_id":"95016","confirmation_number":"SJ12637811808","room_confirmation_number":"SJ12617280067","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"101206","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 02:36:10","reservation_modified_date_time":"2020-06-04 20:38:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101206","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":"3102278","reservation_id":"94755","confirmation_number":"SJ12691025718","room_confirmation_number":"SJ12667074048","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"100958","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-13 20:05:10","reservation_modified_date_time":"2020-06-06 22:39:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100958","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":"3103056","reservation_id":"96122","confirmation_number":"SJ12636091874","room_confirmation_number":"SJ12638773559","room_stay_from":"2020-06-10","room_stay_to":"2020-06-14","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":"102249","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-08 21:10:08","reservation_modified_date_time":"2020-06-08 21:10:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102249","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":"3103556","reservation_id":"96188","confirmation_number":"SJ12649475624","room_confirmation_number":"SJ12659392304","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","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":"102312","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-09 22:38:14","reservation_modified_date_time":"2020-06-10 11:29:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102312","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103562","reservation_id":"94979","confirmation_number":"SJ12698701609","room_confirmation_number":"SJ12684983236","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"101479","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 19:18:07","reservation_modified_date_time":"2020-06-10 11:31:41","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101479","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":"3103569","reservation_id":"95914","confirmation_number":"SJ12616483239","room_confirmation_number":"SJ12655825060","room_stay_from":"2020-06-10","room_stay_to":"2020-06-14","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":"88571","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-04 20:37:46","reservation_modified_date_time":"2020-06-10 11:32:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88571","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":"3103635","reservation_id":"95137","confirmation_number":"SJ12684558454","room_confirmation_number":"SJ12632821326","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"101318","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 18:47:10","reservation_modified_date_time":"2020-06-10 13:10:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101318","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":"3103661","reservation_id":"96217","confirmation_number":"SJ12650725316","room_confirmation_number":"SJ12681102837","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"102339","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-10 13:47:30","reservation_modified_date_time":"2020-06-10 13:55:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102339","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":"3103775","reservation_id":"96232","confirmation_number":"SJ12651901710","room_confirmation_number":"SJ12627738528","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"102354","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-10 17:02:11","reservation_modified_date_time":"2020-06-10 17:51:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102354","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":"3103829","reservation_id":"95915","confirmation_number":"SJ12626097273","room_confirmation_number":"SJ12698014034","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","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":"88530","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-04 20:40:13","reservation_modified_date_time":"2020-06-10 21:26:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88530","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":"3103835","reservation_id":"95088","confirmation_number":"SJ12649006473","room_confirmation_number":"SJ12651485681","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","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":"101270","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 01:12:14","reservation_modified_date_time":"2020-06-10 21:29:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101270","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":"3103910","reservation_id":"96267","confirmation_number":"SJ12635749286","room_confirmation_number":"SJ12638081565","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"102390","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-11 01:43:08","reservation_modified_date_time":"2020-06-11 01:43:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102390","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":"3103937","reservation_id":"95113","confirmation_number":"SJ12692623733","room_confirmation_number":"SJ12690148968","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","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":"101296","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 13:41:07","reservation_modified_date_time":"2020-06-11 11:22:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101296","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":"3104094","reservation_id":"95392","confirmation_number":"SJ12690570305","room_confirmation_number":"SJ12668941161","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"101584","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-25 19:34:10","reservation_modified_date_time":"2020-06-11 20:14:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101584","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":"3104101","reservation_id":"96293","confirmation_number":"SJ12695771535","room_confirmation_number":"SJ12679744243","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"102418","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-11 21:11:39","reservation_modified_date_time":"2020-06-11 21:11:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102418","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":"3104115","reservation_id":"96297","confirmation_number":"SJ12649986453","room_confirmation_number":"SJ12627344172","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"102422","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-11 21:41:36","reservation_modified_date_time":"2020-06-11 21:41:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102422","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":"3104161","reservation_id":"96302","confirmation_number":"SJ12628103899","room_confirmation_number":"SJ12662103385","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102427","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-11 22:49:42","reservation_modified_date_time":"2020-06-11 22:49:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102427","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":"3104367","reservation_id":"96345","confirmation_number":"SJ12615704634","room_confirmation_number":"SJ12611863132","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"102458","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 14:30:15","reservation_modified_date_time":"2020-06-12 14:30:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102458","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":"3104684","reservation_id":"96209","confirmation_number":"SJ12658546810","room_confirmation_number":"SJ12694006888","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"102280","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-10 03:01:29","reservation_modified_date_time":"2020-06-12 23:17:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102280","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":"3104703","reservation_id":"96272","confirmation_number":"SJ12646089638","room_confirmation_number":"SJ12691609174","room_stay_from":"2020-06-12","room_stay_to":"2020-06-14","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":"102510","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-11 12:16:09","reservation_modified_date_time":"2020-06-12 23:58:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102395","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":"3105106","reservation_id":"96450","confirmation_number":"SJ12612092831","room_confirmation_number":"SJ12653990499","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"102161","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-13 20:47:28","reservation_modified_date_time":"2020-06-13 20:47:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102161","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":"3105108","reservation_id":"96451","confirmation_number":"SJ12683447477","room_confirmation_number":"SJ12678662769","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"102161","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-13 20:52:18","reservation_modified_date_time":"2020-06-13 20:52:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102161","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":"3105158","reservation_id":"96456","confirmation_number":"SJ12693249302","room_confirmation_number":"SJ12628093984","room_stay_from":"2020-06-13","room_stay_to":"2020-06-14","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"102566","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-13 22:19:07","reservation_modified_date_time":"2020-06-13 22:19:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102566","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":"3098359","reservation_id":"95543","confirmation_number":"SJ12617195636","room_confirmation_number":"SJ12689441604","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","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":"101726","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 14:50:12","reservation_modified_date_time":"2020-05-28 15:14:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101726","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103269","reservation_id":"96164","confirmation_number":"SJ12642351294","room_confirmation_number":"SJ12685413781","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","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":"102292","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-09 16:02:10","reservation_modified_date_time":"2020-06-09 16:02:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102292","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103288","reservation_id":"96164","confirmation_number":"SJ12689185880","room_confirmation_number":"SJ12627275590","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","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":"102292","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-09 16:02:06","reservation_modified_date_time":"2020-06-09 16:27:38","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102292","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103554","reservation_id":"95746","confirmation_number":"SJ12654115789","room_confirmation_number":"SJ12687052278","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","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":"96738","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-01 15:46:50","reservation_modified_date_time":"2020-06-10 11:29:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96738","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":"3103821","reservation_id":"95047","confirmation_number":"SJ12678639902","room_confirmation_number":"SJ12654129472","room_stay_from":"2020-06-11","room_stay_to":"2020-06-15","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":"101234","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 15:41:07","reservation_modified_date_time":"2020-06-10 21:24:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101234","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":"3104429","reservation_id":"96295","confirmation_number":"SJ12645347627","room_confirmation_number":"SJ12677435087","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","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":"102421","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-11 21:37:51","reservation_modified_date_time":"2020-06-12 16:34:08","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":"3104678","reservation_id":"96152","confirmation_number":"SJ12636124191","room_confirmation_number":"SJ12695098983","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","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":"102279","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-09 02:43:00","reservation_modified_date_time":"2020-06-12 23:11:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102279","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":"3104728","reservation_id":"89522","confirmation_number":"SJ12619323940","room_confirmation_number":"SJ12674994384","room_stay_from":"2020-06-12","room_stay_to":"2020-06-15","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":"84865","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-07 21:15:25","reservation_modified_date_time":"2020-06-13 01:10:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84865","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":"3105167","reservation_id":"96460","confirmation_number":"SJ12644504323","room_confirmation_number":"SJ12671446611","room_stay_from":"2020-06-13","room_stay_to":"2020-06-15","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":"102569","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-13 23:05:07","reservation_modified_date_time":"2020-06-13 23:05:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102569","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":"3105204","reservation_id":"96116","confirmation_number":"SJ12670487911","room_confirmation_number":"SJ12613967995","room_stay_from":"2020-06-10","room_stay_to":"2020-06-15","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":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"102238","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-08 19:27:53","reservation_modified_date_time":"2020-06-14 01:16:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102238","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3094737","reservation_id":"94946","confirmation_number":"SJ12691190559","room_confirmation_number":"SJ12666968800","room_stay_from":"2020-06-13","room_stay_to":"2020-06-16","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":"101136","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 12:06:42","reservation_modified_date_time":"2020-05-18 12:06:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101136","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":"3095074","reservation_id":"95033","confirmation_number":"SJ12674251350","room_confirmation_number":"SJ12682052493","room_stay_from":"2020-06-13","room_stay_to":"2020-06-16","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":"101165","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 13:06:23","reservation_modified_date_time":"2020-05-19 13:06:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101165","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":"3099777","reservation_id":"93004","confirmation_number":"SJ12632864799","room_confirmation_number":"SJ12697538082","room_stay_from":"2020-06-13","room_stay_to":"2020-06-16","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":"99178","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-06 02:20:42","reservation_modified_date_time":"2020-06-01 14:49:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99178","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":"3103932","reservation_id":"95385","confirmation_number":"SJ12616403927","room_confirmation_number":"SJ12673158128","room_stay_from":"2020-06-11","room_stay_to":"2020-06-16","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":"101577","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-25 18:04:10","reservation_modified_date_time":"2020-06-11 11:21:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101577","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":"3104439","reservation_id":"96181","confirmation_number":"SJ12636561398","room_confirmation_number":"SJ12650988608","room_stay_from":"2020-06-12","room_stay_to":"2020-06-16","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":"102307","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-09 19:37:14","reservation_modified_date_time":"2020-06-12 16:41:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102307","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":"3097651","reservation_id":"95419","confirmation_number":"SJ12625107110","room_confirmation_number":"SJ12686780250","room_stay_from":"2020-06-13","room_stay_to":"2020-06-20","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":"101611","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 16:12:06","reservation_modified_date_time":"2020-05-26 16:12:06","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":"3105133","reservation_id":"96206","confirmation_number":"SJ12660485619","room_confirmation_number":"SJ12647932372","room_stay_from":"2020-08-25","room_stay_to":"2020-08-27","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102328","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-10 01:48:08","reservation_modified_date_time":"2020-06-13 21:24:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102328","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3105150","reservation_id":"94485","confirmation_number":"SJ12649574884","room_confirmation_number":"SJ12662278872","room_stay_from":"2020-06-14","room_stay_to":"2020-06-15","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"100695","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-06 12:50:06","reservation_modified_date_time":"2020-06-13 22:01:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100695","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3104868","reservation_id":"95137","confirmation_number":"SJ12652273376","room_confirmation_number":"SJ12632821326","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"21.50","paid_amount":"21.50","product_id":"1657","service_quantity":"1","product_name":"Visor","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-13 15:16:54","reservation_modified_date_time":"2020-06-13 15:16:54","customer_id":"101318","parentCustTravId":"101318","customer_traveller_id":"101318","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3104869","reservation_id":"95137","confirmation_number":"SJ12689508944","room_confirmation_number":"SJ12632821326","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"40.00","grand_total":"43.00","paid_amount":"43.00","product_id":"1659","service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-13 15:16:54","reservation_modified_date_time":"2020-06-13 15:16:54","customer_id":"101318","parentCustTravId":"101318","customer_traveller_id":"101318","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}