{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-03-16","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1278,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":15,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1942,1943","block_room_bookings":[{"confirmation_number":"SJ12622180244","room_stay_from":"2020-03-03","room_stay_to":"2020-04-01","bundle_room":"0"},{"confirmation_number":"SJ12665142275","room_stay_from":"2020-01-14","room_stay_to":"2020-04-01","bundle_room":"0"}],"bundle_block_count":"1269,1270,1309,1310,1260,1261,1302,1303,1311,1312,1271,1272,1267,1268,1291,1711,1307,1308,1304,1305,1262,1263","bundle_block_bookings":[{"confirmation_number":"SJB12690392095","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","bundle_room":"1"},{"confirmation_number":"SJB12633211593","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","bundle_room":"1"},{"confirmation_number":"SJB12675934596","room_stay_from":"2020-03-16","room_stay_to":"2020-03-17","bundle_room":"1"},{"confirmation_number":"SJB12694001339","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","bundle_room":"1"},{"confirmation_number":"SJB12635209414","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","bundle_room":"1"},{"confirmation_number":"SJB12676108902","room_stay_from":"2020-03-16","room_stay_to":"2020-03-17","bundle_room":"1"},{"confirmation_number":"SJB12680722886","room_stay_from":"2020-03-16","room_stay_to":"2020-03-17","bundle_room":"1"},{"confirmation_number":"SJB12698794759","room_stay_from":"2020-03-10","room_stay_to":"2020-03-18","bundle_room":"1"},{"confirmation_number":"SJB12637279231","room_stay_from":"2020-03-15","room_stay_to":"2020-03-18","bundle_room":"1"},{"confirmation_number":"SJB12660653965","room_stay_from":"2020-03-13","room_stay_to":"2020-03-19","bundle_room":"1"},{"confirmation_number":"SJB12612393777","room_stay_from":"2020-03-15","room_stay_to":"2020-03-19","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3069026","reservation_id":"90934","confirmation_number":"SJ12653596319","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"215.00,179.00,179.00","nightly_discount":"0,0,0","subtotal":"573.00","grand_total":"644.63","paid_amount":"644.63","room_type_id":"319","product_id":"1310","siteminder_id":"BDC-3569270005","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":"97030","customer_id":"97030","source_of_creation":"Booking.com","reservation_created_date":"2020-01-30 14:30:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"118.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.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":"3080546","reservation_id":"90993","confirmation_number":"SJ12679419332","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"111.1,111.1","nightly_discount":"0,0","subtotal":"222.20","grand_total":"249.98","paid_amount":"249.98","room_type_id":"319","product_id":"1302","siteminder_id":"BDC-2421172299","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97086","customer_id":"97086","source_of_creation":"Booking.com","reservation_created_date":"2020-01-31 10:48:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"68.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.1","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":"3081310","reservation_id":"93277","confirmation_number":"SJ12624895000","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00","nightly_discount":"0,0","subtotal":"510.00","grand_total":"573.75","paid_amount":"573.75","room_type_id":"319","product_id":"1312","siteminder_id":"BDC-3803151301","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":"99488","customer_id":"99488","source_of_creation":"Booking.com","reservation_created_date":"2020-03-13 13:15:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"100.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"255.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":"3082258","reservation_id":"93385","confirmation_number":"SJ12694253855","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00","nightly_discount":"0,0","subtotal":"510.00","grand_total":"573.75","paid_amount":"573.75","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-2985564820","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":"99599","customer_id":"99599","source_of_creation":"Booking.com","reservation_created_date":"2020-03-15 19:43:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"100.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"255.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":"3082441","reservation_id":"91202","confirmation_number":"SJ12621747667","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"168.50,136.10,185.00","nightly_discount":"0.00,0.00,0.00","subtotal":"489.60","grand_total":"550.80","paid_amount":"550.80","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-2469458089","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97325","customer_id":"97325","source_of_creation":"Booking.com","reservation_created_date":"2020-02-03 08:35:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"36.98","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"185.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":"3082888","reservation_id":"93447","confirmation_number":"SJ12698781004","room_stay_from":"2020-03-16","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00","nightly_discount":"0","subtotal":"210.00","grand_total":"236.25","paid_amount":"236.25","room_type_id":"413","product_id":"1267","siteminder_id":"BDC-3720930873","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":"99677","customer_id":"99677","source_of_creation":"Booking.com","reservation_created_date":"2020-03-17 02:42:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"42.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"210.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":"3082566","reservation_id":"93123","confirmation_number":"SJ12688243234","room_stay_from":"2020-03-16","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00,210.00","nightly_discount":"0,0","subtotal":"420.00","grand_total":"472.50","paid_amount":"472.50","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-2459916890","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":"99649","customer_id":"99649","source_of_creation":"Booking.com","reservation_created_date":"2020-03-09 00:24:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"84.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"210.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":"3082873","reservation_id":"93445","confirmation_number":"SJ12659985719","room_stay_from":"2020-03-16","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00","nightly_discount":"0,0","subtotal":"510.00","grand_total":"573.75","paid_amount":"573.75","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-3043315293","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":"99676","customer_id":"99676","source_of_creation":"Booking.com","reservation_created_date":"2020-03-17 01:16:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"50.40","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"255.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":"3080663","reservation_id":"93242","confirmation_number":"SJ12645107032","room_stay_from":"2020-03-15","room_stay_to":"2020-03-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"210.00,210.00,210.00,210.00","nightly_discount":"0,0,0,0","subtotal":"840.00","grand_total":"945.00","paid_amount":"945.00","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-2682272346","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":"99448","customer_id":"99448","source_of_creation":"Booking.com","reservation_created_date":"2020-03-11 23:10:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"169.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"210.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":"3082633","reservation_id":"91879","confirmation_number":"SJ12641935797","room_stay_from":"2020-03-16","room_stay_to":"2020-03-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"179.00,179.00,179.00","nightly_discount":"0,0,0","subtotal":"537.00","grand_total":"604.13","paid_amount":"604.13","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-3895831319","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":"99661","customer_id":"99661","source_of_creation":"Booking.com","reservation_created_date":"2020-02-12 20:41:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"55.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.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":"3067874","reservation_id":"91651","confirmation_number":"SJ12654546375","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"247,247,247,247,300","nightly_discount":"0,0,0,0,0","subtotal":"1288.00","grand_total":"1449.00","paid_amount":"1449.00","room_type_id":"412","product_id":"1297","siteminder_id":"BDC-2721399518","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"250.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97788","customer_id":"97788","source_of_creation":"Booking.com","reservation_created_date":"2020-02-09 17:50:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"302.15","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"247","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":"3081407","reservation_id":"93316","confirmation_number":"SJ12656730721","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.00,210.00,210.00,210.00,210.00,210.00,245.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1540.00","grand_total":"1732.50","paid_amount":"1732.50","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-2690176829","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":"99527","customer_id":"99527","source_of_creation":"Booking.com","reservation_created_date":"2020-03-14 00:01:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"77.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"210.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":"3082385","reservation_id":"90606","confirmation_number":"SJ12689555882","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","room_stay_status":"Checked-Out","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"190,154","nightly_discount":"0,0","subtotal":"344.00","grand_total":"387.00","paid_amount":"157.49","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-3531068529","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96680","customer_id":"96680","source_of_creation":"Booking.com","reservation_created_date":"2020-01-26 05:10:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"118.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[{"room_stay_id":"3082406","reservation_id":"93155","confirmation_number":"SJ12632309407","room_stay_from":"2020-03-16","room_stay_to":"2020-03-17","room_stay_status":"Canceled","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"160.00","nightly_discount":"0.00","subtotal":"160.00","grand_total":"180.00","paid_amount":"180.00","room_type_id":"413","product_id":"1267","siteminder_id":"BDC-3435396425","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":"99353","customer_id":"99353","source_of_creation":"Booking.com","reservation_created_date":"2020-03-09 19:27:06","service_canceled_date_time":"2020-03-16 17:17:01","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"42.30","deltaChange":"180.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3060900","reservation_id":"90426","confirmation_number":"SJ12655655891","room_stay_from":"2020-03-16","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20","nightly_discount":"0","subtotal":"143.20","grand_total":"161.10","paid_amount":"161.10","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1628351551","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":"96477","customer_id":"96477","source_of_creation":"Expedia","reservation_created_date":"2020-01-23 15:23:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.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":"3062127","reservation_id":"90672","confirmation_number":"SJ12671439064","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20","nightly_discount":"0,0","subtotal":"286.40","grand_total":"322.20","paid_amount":"322.20","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1630390171","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":"96755","customer_id":"96755","source_of_creation":"Expedia","reservation_created_date":"2020-01-27 04:08:10","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":"143.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":"3075034","reservation_id":"91943","confirmation_number":"SJ12686482783","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20","nightly_discount":"0,0","subtotal":"338.40","grand_total":"380.70","paid_amount":"380.70","room_type_id":"319","product_id":"1313","siteminder_id":"EXP-1641198469","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":"98086","customer_id":"98086","source_of_creation":"Expedia","reservation_created_date":"2020-02-13 21:59:07","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":"169.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":"3080740","reservation_id":"90540","confirmation_number":"SJ12675363272","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"163.20,163.20","nightly_discount":"0,0","subtotal":"326.40","grand_total":"367.20","paid_amount":"367.20","room_type_id":"319","product_id":"1303","siteminder_id":"EXP-1629314743","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":"96602","customer_id":"96602","source_of_creation":"Expedia","reservation_created_date":"2020-01-25 01:53:05","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":"163.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":"3081627","reservation_id":"92234","confirmation_number":"SJ12625263320","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"244.00,244.00","nightly_discount":"0,0","subtotal":"488.00","grand_total":"549.00","paid_amount":"549.00","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1645070146","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":"98420","customer_id":"98420","source_of_creation":"Expedia","reservation_created_date":"2020-02-20 03:08:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"97.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"244.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":"3067095","reservation_id":"91486","confirmation_number":"SJ12611429751","room_stay_from":"2020-03-10","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,169.20,187.20,187.20,169.20,169.20,169.20","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1389.60","grand_total":"1563.30","paid_amount":"1563.30","room_type_id":"319","product_id":"1291","siteminder_id":"EXP-1637238795","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":"97615","customer_id":"97615","source_of_creation":"Expedia","reservation_created_date":"2020-02-07 14:38:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"277.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"169.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":"3068686","reservation_id":"91102","confirmation_number":"SJ12670787957","room_stay_from":"2020-03-14","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"228.00,208.00,208.00,208.00","nightly_discount":"0,0,0,0","subtotal":"852.00","grand_total":"958.50","paid_amount":"958.50","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1633951119","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":"97227","customer_id":"97227","source_of_creation":"Expedia","reservation_created_date":"2020-02-02 02:23:09","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":"208.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":"3069078","reservation_id":"91837","confirmation_number":"SJ12635330045","room_stay_from":"2020-03-16","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20","nightly_discount":"0,0","subtotal":"286.40","grand_total":"322.20","paid_amount":"322.20","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1640029260","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":"97989","customer_id":"97989","source_of_creation":"Expedia","reservation_created_date":"2020-02-12 03:23:05","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":"143.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":"3073635","reservation_id":"92491","confirmation_number":"SJ12684487074","room_stay_from":"2020-03-14","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"187.6,169.6,169.6,169.6","nightly_discount":"0,0,0,0","subtotal":"696.40","grand_total":"783.45","paid_amount":"783.45","room_type_id":"319","product_id":"1308","siteminder_id":"EXP-1647754042","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98652","customer_id":"98652","source_of_creation":"Expedia","reservation_created_date":"2020-02-24 18:38:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"169.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":"3076384","reservation_id":"89652","confirmation_number":"SJ12644072525","room_stay_from":"2020-03-16","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.20,239.20","nightly_discount":"0,0","subtotal":"478.40","grand_total":"538.20","paid_amount":"538.20","room_type_id":"319","product_id":"1319","siteminder_id":"EXP-1620106026","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":"95637","customer_id":"95637","source_of_creation":"Expedia","reservation_created_date":"2020-01-09 18:43:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"239.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":"3077665","reservation_id":"92940","confirmation_number":"SJ12661649081","room_stay_from":"2020-03-11","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"215.20,204.00,224.00,224.00,204.00,204.00,215.20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1490.40","grand_total":"1676.70","paid_amount":"1676.70","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1652818230","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":"99105","customer_id":"99105","source_of_creation":"Expedia","reservation_created_date":"2020-03-04 14:19:08","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":"204.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":"3079553","reservation_id":"91487","confirmation_number":"SJ12643636295","room_stay_from":"2020-03-10","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"169.20,169.20,169.20,187.20,187.20,169.20,169.20,169.20","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1389.60","grand_total":"1563.30","paid_amount":"1563.30","room_type_id":"319","product_id":"1711","siteminder_id":"EXP-1637238799","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":"97616","customer_id":"97616","source_of_creation":"Expedia","reservation_created_date":"2020-02-07 14:38:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"277.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"169.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":"3080015","reservation_id":"91860","confirmation_number":"SJ12679190526","room_stay_from":"2020-03-11","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,187.20,187.20,169.20,169.20,169.20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1220.40","grand_total":"1372.95","paid_amount":"1372.95","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1640338173","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":"98008","customer_id":"98008","source_of_creation":"Expedia","reservation_created_date":"2020-02-12 16:44:13","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":"169.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":"3082608","reservation_id":"91834","confirmation_number":"SJ12653601472","room_stay_from":"2020-03-15","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,179.00","nightly_discount":"0,0,0","subtotal":"537.00","grand_total":"604.13","paid_amount":"604.13","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1640007470","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":"97986","customer_id":"97986","source_of_creation":"Expedia","reservation_created_date":"2020-02-12 02:43:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"179.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":"3080514","reservation_id":"92907","confirmation_number":"SJ12642602756","room_stay_from":"2020-03-15","room_stay_to":"2020-03-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00,210.00,210.00,210.00","nightly_discount":"0,0,0,0","subtotal":"840.00","grand_total":"945.00","paid_amount":"945.00","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1652294512","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":"99064","customer_id":"99064","source_of_creation":"Expedia","reservation_created_date":"2020-03-03 15:59:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"210.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":"3081652","reservation_id":"91168","confirmation_number":"SJ12676681644","room_stay_from":"2020-03-14","room_stay_to":"2020-03-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"256.50,256.50,256.50,256.50,256.50","nightly_discount":"0,0,0,0,0","subtotal":"1282.50","grand_total":"1442.82","paid_amount":"1442.82","room_type_id":"319","product_id":"1287","siteminder_id":"EXP-1634320847","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":"97291","customer_id":"97291","source_of_creation":"Expedia","reservation_created_date":"2020-02-02 21:28:10","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":"256.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":"3076373","reservation_id":"92746","confirmation_number":"SJ12669412921","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"183.60,183.60,183.60,183.60","nightly_discount":"0,0,0,0","subtotal":"734.40","grand_total":"826.20","paid_amount":"826.20","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1650458161","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":"98892","customer_id":"98892","source_of_creation":"Expedia","reservation_created_date":"2020-02-29 01:24:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"183.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":"3081797","reservation_id":"93321","confirmation_number":"SJ12686729977","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"204.00,204.00,204.00,204.00","nightly_discount":"0,0,0,0","subtotal":"816.00","grand_total":"918.00","paid_amount":"918.00","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1657504924","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":"99531","customer_id":"99531","source_of_creation":"Expedia","reservation_created_date":"2020-03-14 01:22:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"204.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":"3082640","reservation_id":"92687","confirmation_number":"SJ12682510155","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,183.60,183.60,183.60","nightly_discount":"0,0,0,0","subtotal":"734.40","grand_total":"826.20","paid_amount":"826.20","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1649764156","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":"99664","customer_id":"99664","source_of_creation":"Expedia","reservation_created_date":"2020-02-27 21:58:10","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":"183.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":"3068720","reservation_id":"90592","confirmation_number":"SJ12626181334","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,179.00,179.00,215.00","nightly_discount":"0,0,0,0,0","subtotal":"931.00","grand_total":"1047.38","paid_amount":"1047.38","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1629730423","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":"96662","customer_id":"96662","source_of_creation":"Expedia","reservation_created_date":"2020-01-25 22:03:09","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":"179.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":"3082827","reservation_id":"93386","confirmation_number":"SJ12684603802","room_stay_from":"2020-03-17","room_stay_to":"2020-03-24","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"168.00,168.00,168.00,196.00,196.00,168.00,168.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1232.00","grand_total":"1386.00","paid_amount":"0.00","room_type_id":"413","product_id":"1272","siteminder_id":"EXP-1657946966","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":"99600","customer_id":"99600","source_of_creation":"Expedia","reservation_created_date":"2020-03-15 19:52:10","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3082855","reservation_id":"92234","confirmation_number":"SJ12612896424","room_stay_from":"2020-03-17","room_stay_to":"2020-03-19","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"244.00,244.00","nightly_discount":"0,0","subtotal":"488.00","grand_total":"549.00","paid_amount":"0.00","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1645070146","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":"98420","customer_id":"98420","source_of_creation":"Expedia","reservation_created_date":"2020-03-11 10:41:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"48.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3082498","reservation_id":"93306","confirmation_number":"SJ12697554329","room_stay_from":"2020-05-20","room_stay_to":"2020-05-24","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,183.60,201.60,201.60","nightly_discount":"0,0,0,0","subtotal":"770.40","grand_total":"866.70","paid_amount":"0.00","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1657401355","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":"99514","customer_id":"99514","source_of_creation":"Expedia","reservation_created_date":"2020-03-13 19:47:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3082492","reservation_id":"92500","confirmation_number":"SJ12617487476","room_stay_from":"2020-03-17","room_stay_to":"2020-03-20","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"297.00,350.00,350.00","nightly_discount":"0,0,0","subtotal":"997.00","grand_total":"1121.63","paid_amount":"334.13","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1647841869","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":"98667","customer_id":"98667","source_of_creation":"Expedia","reservation_created_date":"2020-02-24 21:03:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]}],"exp_non_taxable":[{"room_stay_id":"3075031","reservation_id":"91932","confirmation_number":"SJ12647795571","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"183,183,183,183,183,203","nightly_discount":"0,0,0,0,0,0","subtotal":"1118.00","grand_total":"1257.75","paid_amount":"1257.75","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1641065382","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98074","customer_id":"98074","source_of_creation":"Expedia","reservation_created_date":"2020-02-13 18:14:09","service_canceled_date_time":"2020-03-16 12:22:32","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"1051.88","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[{"room_stay_id":"3081943","reservation_id":"93363","confirmation_number":"SJ12617668422","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.98,108.49","nightly_discount":"0,0","subtotal":"263.47","grand_total":"296.40","paid_amount":"296.40","room_type_id":"319","product_id":"1301","siteminder_id":"HTN-123302105-ZJ66PN","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":"99583","customer_id":"99583","source_of_creation":"HotelTonight","reservation_created_date":"2020-03-15 12:29:08","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":"108.49","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":"3082590","reservation_id":"93398","confirmation_number":"SJ12656797916","room_stay_from":"2020-03-16","room_stay_to":"2020-03-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.98,154.98,154.98","nightly_discount":"0,0,0","subtotal":"464.94","grand_total":"523.06","paid_amount":"523.06","room_type_id":"319","product_id":"1276","siteminder_id":"HTN-123398614-4M3XWF","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":"99631","customer_id":"99631","source_of_creation":"HotelTonight","reservation_created_date":"2020-03-16 13:24:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"154.98","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":"3082349","reservation_id":"93136","confirmation_number":"SJ12611900663","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.48,139.48,139.48,139.48,139.48,185.98","nightly_discount":"0,0,0,0,0,0","subtotal":"883.38","grand_total":"993.80","paid_amount":"993.80","room_type_id":"412","product_id":"1866","siteminder_id":"HTN-122544494-GXLRDA","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":"99334","customer_id":"99334","source_of_creation":"HotelTonight","reservation_created_date":"2020-03-09 14:59:08","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":"139.48","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"}]}],"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":"3081928","reservation_id":"93217","confirmation_number":"SJ12644010353","room_stay_from":"2020-03-15","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00,255.00","nightly_discount":"0.00,0.00,0.00","subtotal":"765.00","grand_total":"860.63","paid_amount":"860.63","room_type_id":"413","product_id":"1271","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":"99423","customer_id":"99423","source_of_creation":"FE","reservation_created_date":"2020-03-11 03:30:01","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"255.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":"3067548","reservation_id":"91610","confirmation_number":"SJ12625555606","room_stay_from":"2020-03-13","room_stay_to":"2020-03-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"260.00,260.00,235.00,235.00,235.00,235.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1460.00","grand_total":"1642.50","paid_amount":"1642.50","room_type_id":"319","product_id":"1304","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":"97745","customer_id":"97745","source_of_creation":"FE","reservation_created_date":"2020-02-08 21:39:58","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":"235.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":"3081506","reservation_id":"93249","confirmation_number":"SJ12632202376","room_stay_from":"2020-03-14","room_stay_to":"2020-03-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"350.00,255.00,255.00,255.00,255.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1370.00","grand_total":"1541.25","paid_amount":"1541.25","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":"99455","customer_id":"99455","source_of_creation":"FE","reservation_created_date":"2020-03-12 02:19:15","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":"255.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3079555","reservation_id":"91539","confirmation_number":"SJ12663567468","room_stay_from":"2020-03-12","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,187.20,187.20,169.20,169.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"882.00","grand_total":"992.25","paid_amount":"992.25","room_type_id":"319","product_id":"1293","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":"97673","customer_id":"97673","source_of_creation":"PMS","reservation_created_date":"2020-02-08 00:56:50","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"169.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081391","reservation_id":"91917","confirmation_number":"SJ12673969913","room_stay_from":"2020-03-16","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00","nightly_discount":"0.00","subtotal":"179.00","grand_total":"201.38","paid_amount":"201.38","room_type_id":"413","product_id":"1272","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98061","customer_id":"98061","source_of_creation":"PMS","reservation_created_date":"2020-02-13 15:22:42","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3081829","reservation_id":"93347","confirmation_number":"SJ12660078453","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.00,210.00,210.00","nightly_discount":"24.50,21.00,21.00","subtotal":"665.00","grand_total":"673.32","paid_amount":"673.32","room_type_id":"413","product_id":"1262","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99565","customer_id":"99565","source_of_creation":"PMS","reservation_created_date":"2020-03-14 20:17:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"210.00","currentDayDiscount":"21.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":"3082363","reservation_id":"93305","confirmation_number":"SJ12624196495","room_stay_from":"2020-03-16","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"205.00","nightly_discount":"0.00","subtotal":"205.00","grand_total":"230.63","paid_amount":"230.63","room_type_id":"412","product_id":"1294","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":"99513","customer_id":"99513","source_of_creation":"PMS","reservation_created_date":"2020-03-13 19:45:38","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":"205.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":"3081889","reservation_id":"93357","confirmation_number":"SJ12644798121","room_stay_from":"2020-03-15","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00,255.00","nightly_discount":"0.00,0.00,0.00","subtotal":"765.00","grand_total":"860.63","paid_amount":"860.63","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":"99578","customer_id":"99578","source_of_creation":"PMS","reservation_created_date":"2020-03-15 00:49:52","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":"255.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":"3067565","reservation_id":"91612","confirmation_number":"SJ12689117206","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"260.00,235.00,235.00,235.00,235.00,235.00,260.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1695.00","grand_total":"1906.88","paid_amount":"1906.88","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":"97749","customer_id":"97749","source_of_creation":"PMS","reservation_created_date":"2020-02-08 21:57:42","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"235.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3074573","reservation_id":"90326","confirmation_number":"SJ12617869467","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1278","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"74797","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2020-01-21 21:54:40","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3080798","reservation_id":"93257","confirmation_number":"SJ12645290249","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2020-03-12 15:02:36","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081531","reservation_id":"90995","confirmation_number":"SJ12627554229","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.71,160.71,160.71,160.71,160.72,160.72,160.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1125.00","grand_total":"1125.00","paid_amount":"0.00","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-01-31 12:43:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.71","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3080317","reservation_id":"92463","confirmation_number":"SJ12677973065","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-02-24 01:21:02","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":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3082358","reservation_id":"92871","confirmation_number":"SJ12623092937","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1314","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-03-02 19:24:10","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":"","changedComment":"Nightly price or discount changed","deltaChange":"-1125.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3082443","reservation_id":"92926","confirmation_number":"SJ12670536820","room_stay_from":"2020-03-14","room_stay_to":"2020-03-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"","nightly_discount":"","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-03-03 23:10:47","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3081068","reservation_id":"92805","confirmation_number":"SJ12683040098","room_stay_from":"2020-03-13","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"495.00","grand_total":"495.00","paid_amount":"140.64","room_type_id":"319","product_id":"1307","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-03-01 03:31:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3082301","reservation_id":"92637","confirmation_number":"SJ12647140911","room_stay_from":"2020-03-15","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00","subtotal":"300.00","grand_total":"300.00","paid_amount":"84.38","room_type_id":"319","product_id":"1275","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-02-27 03:45:38","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":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3082379","reservation_id":"92641","confirmation_number":"SJ12665458362","room_stay_from":"2020-03-15","room_stay_to":"2020-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"495.00","grand_total":"495.00","paid_amount":"0.00","room_type_id":"319","product_id":"1305","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-02-27 03:55:06","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":"","changedComment":"Nightly price or discount changed","deltaChange":"99.00","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3080547","reservation_id":"90993","confirmation_number":"SJ12618682896","room_confirmation_number":"SJ12679419332","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"97086","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-11 14:56:58","reservation_modified_date_time":"2020-03-11 14:56:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97086","canceled_nights_data":"","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":"3082435","reservation_id":"91202","confirmation_number":"SJ12650438576","room_confirmation_number":"SJ12621747667","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"97325","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-16 15:05:13","reservation_modified_date_time":"2020-03-16 15:05:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97325","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"50.00","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3073636","reservation_id":"92491","confirmation_number":"SJ12623338120","room_confirmation_number":"SJ12684487074","room_stay_from":"2020-03-14","room_stay_to":"2020-03-18","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"98652","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-24 18:38:10","reservation_modified_date_time":"2020-02-24 18:38:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98652","canceled_nights_data":"","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":"3067875","reservation_id":"91651","confirmation_number":"SJ12669349708","room_confirmation_number":"SJ12654546375","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"50,50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"97788","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-09 17:50:10","reservation_modified_date_time":"2020-02-09 17:50:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97788","canceled_nights_data":"","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":"3082386","reservation_id":"90606","confirmation_number":"SJ12685358180","room_confirmation_number":"SJ12689555882","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"96680","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-16 13:16:06","reservation_modified_date_time":"2020-03-16 13:16:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96680","canceled_nights_data":"","changedComment":"Reservation created for complete past date","deltaChange":"50.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075032","reservation_id":"91932","confirmation_number":"SJ12620098418","room_confirmation_number":"SJ12647795571","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Canceled","nightly_price":"25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-27 14:01:35","reservation_modified_date_time":"2020-02-27 14:01:35","customer_id":"98074","parentCustTravId":"98074","customer_traveller_id":"98074","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-03-16 12:22:32","canceled_nights_data":"","product_attribute_values":"extra_person#&#25","deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3060901","reservation_id":"90426","confirmation_number":"SJ12679797449","room_confirmation_number":"SJ12655655891","room_stay_from":"2020-03-16","room_stay_to":"2020-03-17","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":"96477","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-23 15:23:07","reservation_modified_date_time":"2020-01-23 15:23:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96477","canceled_nights_data":"","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":"3062128","reservation_id":"90672","confirmation_number":"SJ12653372395","room_confirmation_number":"SJ12671439064","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","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":"96755","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-27 04:08:10","reservation_modified_date_time":"2020-01-27 04:08:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96755","canceled_nights_data":"","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":"3069030","reservation_id":"90934","confirmation_number":"SJ12665498437","room_confirmation_number":"SJ12653596319","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","room_stay_status":"Active","nightly_price":"28.12,28.12,28.12","nightly_discount":"0.00,0.00,0.00","subtotal":"84.36","grand_total":"94.90","paid_amount":"94.90","product_id":"1776","service_quantity":"1","customer_traveller_id":"97030","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-01-30 14:30:09","reservation_modified_date_time":"2020-02-12 00:52:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97030","canceled_nights_data":"","currentDayPrice":"28.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075035","reservation_id":"91943","confirmation_number":"SJ12669630466","room_confirmation_number":"SJ12686482783","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","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":"98086","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-13 21:59:07","reservation_modified_date_time":"2020-02-27 14:03:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98086","canceled_nights_data":"","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":"3079556","reservation_id":"91539","confirmation_number":"SJ12620696931","room_confirmation_number":"SJ12663567468","room_stay_from":"2020-03-12","room_stay_to":"2020-03-17","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":"97673","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 00:56:50","reservation_modified_date_time":"2020-03-09 11:27:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97673","canceled_nights_data":"","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":"3080548","reservation_id":"90993","confirmation_number":"SJ12675303328","room_confirmation_number":"SJ12679419332","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","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":"97086","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 10:48:12","reservation_modified_date_time":"2020-03-11 14:56:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97086","canceled_nights_data":"","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":"3080741","reservation_id":"90540","confirmation_number":"SJ12643460866","room_confirmation_number":"SJ12675363272","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","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":"96602","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 01:53:05","reservation_modified_date_time":"2020-03-12 13:07:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96602","canceled_nights_data":"","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":"3081312","reservation_id":"93277","confirmation_number":"SJ12614450074","room_confirmation_number":"SJ12624895000","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","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":"99488","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-13 13:15:09","reservation_modified_date_time":"2020-03-13 21:34:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99488","canceled_nights_data":"","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":"3081392","reservation_id":"91917","confirmation_number":"SJ12664099015","room_confirmation_number":"SJ12673969913","room_stay_from":"2020-03-16","room_stay_to":"2020-03-17","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":"98061","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-13 15:22:42","reservation_modified_date_time":"2020-03-14 00:17:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98061","canceled_nights_data":"","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":"3081628","reservation_id":"92234","confirmation_number":"SJ12688138184","room_confirmation_number":"SJ12625263320","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","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":"98420","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-20 03:08:05","reservation_modified_date_time":"2020-03-14 15:12:04","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98420","canceled_nights_data":"","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":"3081830","reservation_id":"93347","confirmation_number":"SJ12636152046","room_confirmation_number":"SJ12660078453","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","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":"99565","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-14 20:17:15","reservation_modified_date_time":"2020-03-14 20:17:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99565","canceled_nights_data":"","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":"3081944","reservation_id":"93363","confirmation_number":"SJ12695647228","room_confirmation_number":"SJ12617668422","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","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":"99583","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-15 12:29:08","reservation_modified_date_time":"2020-03-15 12:29:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99583","canceled_nights_data":"","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":"3082259","reservation_id":"93385","confirmation_number":"SJ12629542594","room_confirmation_number":"SJ12694253855","room_stay_from":"2020-03-15","room_stay_to":"2020-03-17","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":"99599","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-15 19:43:10","reservation_modified_date_time":"2020-03-15 19:43:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99599","canceled_nights_data":"","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":"3082364","reservation_id":"93305","confirmation_number":"SJ12682445311","room_confirmation_number":"SJ12624196495","room_stay_from":"2020-03-16","room_stay_to":"2020-03-17","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":"99513","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-13 19:45:38","reservation_modified_date_time":"2020-03-16 11:58:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99513","canceled_nights_data":"","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":"3082442","reservation_id":"91202","confirmation_number":"SJ12688201953","room_confirmation_number":"SJ12621747667","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","room_stay_status":"Active","nightly_price":"28.12,28.12,28.12","nightly_discount":"0.00,0.00,0.00","subtotal":"84.36","grand_total":"94.91","paid_amount":"94.91","product_id":"1776","service_quantity":"1","customer_traveller_id":"97325","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-02-03 08:35:09","reservation_modified_date_time":"2020-03-16 15:28:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97325","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"28.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3082889","reservation_id":"93447","confirmation_number":"SJ12698320435","room_confirmation_number":"SJ12698781004","room_stay_from":"2020-03-16","room_stay_to":"2020-03-17","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":"99677","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-17 02:42:08","reservation_modified_date_time":"2020-03-17 02:42:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99677","canceled_nights_data":"","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":"3067097","reservation_id":"91486","confirmation_number":"SJ12616999370","room_confirmation_number":"SJ12611429751","room_stay_from":"2020-03-10","room_stay_to":"2020-03-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"97615","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-07 14:38:09","reservation_modified_date_time":"2020-02-07 23:38:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97615","canceled_nights_data":"","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":"3068687","reservation_id":"91102","confirmation_number":"SJ12682616535","room_confirmation_number":"SJ12670787957","room_stay_from":"2020-03-14","room_stay_to":"2020-03-18","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":"97227","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 02:23:09","reservation_modified_date_time":"2020-02-11 02:34:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97227","canceled_nights_data":"","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":"3069079","reservation_id":"91837","confirmation_number":"SJ12611785094","room_confirmation_number":"SJ12635330045","room_stay_from":"2020-03-16","room_stay_to":"2020-03-18","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":"97989","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 03:23:05","reservation_modified_date_time":"2020-02-12 03:23:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97989","canceled_nights_data":"","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":"3073637","reservation_id":"92491","confirmation_number":"SJ12694795782","room_confirmation_number":"SJ12684487074","room_stay_from":"2020-03-14","room_stay_to":"2020-03-18","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":"98652","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-24 18:38:10","reservation_modified_date_time":"2020-02-24 18:38:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98652","canceled_nights_data":"","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":"3076385","reservation_id":"89652","confirmation_number":"SJ12649810745","room_confirmation_number":"SJ12644072525","room_stay_from":"2020-03-16","room_stay_to":"2020-03-18","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":"95637","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-09 18:43:09","reservation_modified_date_time":"2020-02-29 20:28:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95637","canceled_nights_data":"","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":"3077664","reservation_id":"92940","confirmation_number":"SJ12668825240","room_confirmation_number":"SJ12661649081","room_stay_from":"2020-03-11","room_stay_to":"2020-03-18","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,0,0,0,0","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"99105","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-04 14:19:08","reservation_modified_date_time":"2020-03-04 14:27:04","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99105","canceled_nights_data":"","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":"3079554","reservation_id":"91487","confirmation_number":"SJ12635852465","room_confirmation_number":"SJ12643636295","room_stay_from":"2020-03-10","room_stay_to":"2020-03-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"97616","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-07 14:38:12","reservation_modified_date_time":"2020-03-09 11:26:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97616","canceled_nights_data":"","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":"3080016","reservation_id":"91860","confirmation_number":"SJ12622623975","room_confirmation_number":"SJ12679190526","room_stay_from":"2020-03-11","room_stay_to":"2020-03-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"98008","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 16:44:13","reservation_modified_date_time":"2020-03-10 13:10:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98008","canceled_nights_data":"","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":"3081070","reservation_id":"92805","confirmation_number":"SJ12647246979","room_confirmation_number":"SJ12683040098","room_stay_from":"2020-03-13","room_stay_to":"2020-03-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98955","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-01 03:31:08","reservation_modified_date_time":"2020-03-13 11:21:22","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","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":"3081890","reservation_id":"93357","confirmation_number":"SJ12629908709","room_confirmation_number":"SJ12644798121","room_stay_from":"2020-03-15","room_stay_to":"2020-03-18","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":"99578","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-15 00:49:52","reservation_modified_date_time":"2020-03-15 00:49:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99578","canceled_nights_data":"","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":"3081930","reservation_id":"93217","confirmation_number":"SJ12652137755","room_confirmation_number":"SJ12644010353","room_stay_from":"2020-03-15","room_stay_to":"2020-03-18","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":"99423","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-11 03:30:01","reservation_modified_date_time":"2020-03-15 11:12:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99423","canceled_nights_data":"","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":"3082302","reservation_id":"92637","confirmation_number":"SJ12683774818","room_confirmation_number":"SJ12647140911","room_stay_from":"2020-03-15","room_stay_to":"2020-03-18","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":"98791","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-27 03:45:38","reservation_modified_date_time":"2020-03-15 21:17:34","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","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":"3082565","reservation_id":"93123","confirmation_number":"SJ12649179031","room_confirmation_number":"SJ12688243234","room_stay_from":"2020-03-16","room_stay_to":"2020-03-18","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":"99649","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-09 00:24:09","reservation_modified_date_time":"2020-03-16 19:36:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99649","canceled_nights_data":"","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":"3082610","reservation_id":"91834","confirmation_number":"SJ12649835482","room_confirmation_number":"SJ12653601472","room_stay_from":"2020-03-15","room_stay_to":"2020-03-18","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":"97986","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 02:43:09","reservation_modified_date_time":"2020-03-16 20:32:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97986","canceled_nights_data":"","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":"3082872","reservation_id":"93445","confirmation_number":"SJ12673163824","room_confirmation_number":"SJ12659985719","room_stay_from":"2020-03-16","room_stay_to":"2020-03-18","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":"99676","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-17 01:16:11","reservation_modified_date_time":"2020-03-17 01:59:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99676","canceled_nights_data":"","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":"3067549","reservation_id":"91610","confirmation_number":"SJ12635453264","room_confirmation_number":"SJ12625555606","room_stay_from":"2020-03-13","room_stay_to":"2020-03-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"97745","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 21:39:58","reservation_modified_date_time":"2020-02-08 21:39:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97745","canceled_nights_data":"","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":"3080515","reservation_id":"92907","confirmation_number":"SJ12677116940","room_confirmation_number":"SJ12642602756","room_stay_from":"2020-03-15","room_stay_to":"2020-03-19","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":"99064","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-03 15:59:10","reservation_modified_date_time":"2020-03-11 14:26:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99064","canceled_nights_data":"","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":"3080664","reservation_id":"93242","confirmation_number":"SJ12657354801","room_confirmation_number":"SJ12645107032","room_stay_from":"2020-03-15","room_stay_to":"2020-03-19","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":"99448","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-11 23:10:10","reservation_modified_date_time":"2020-03-11 23:10:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99448","canceled_nights_data":"","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":"3081507","reservation_id":"93249","confirmation_number":"SJ12682744202","room_confirmation_number":"SJ12632202376","room_stay_from":"2020-03-14","room_stay_to":"2020-03-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"99455","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-12 02:19:15","reservation_modified_date_time":"2020-03-14 11:07:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99455","canceled_nights_data":"","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":"3081655","reservation_id":"91168","confirmation_number":"SJ12644397592","room_confirmation_number":"SJ12676681644","room_stay_from":"2020-03-14","room_stay_to":"2020-03-19","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":"97291","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 21:28:10","reservation_modified_date_time":"2020-03-14 15:34:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97291","canceled_nights_data":"","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":"3082589","reservation_id":"93398","confirmation_number":"SJ12646394858","room_confirmation_number":"SJ12656797916","room_stay_from":"2020-03-16","room_stay_to":"2020-03-19","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":"99631","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-16 13:24:10","reservation_modified_date_time":"2020-03-16 20:04:49","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99631","canceled_nights_data":"","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":"3082632","reservation_id":"91879","confirmation_number":"SJ12681894303","room_confirmation_number":"SJ12641935797","room_stay_from":"2020-03-16","room_stay_to":"2020-03-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"99661","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 20:41:09","reservation_modified_date_time":"2020-03-16 21:27:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99661","canceled_nights_data":"","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":"3076375","reservation_id":"92746","confirmation_number":"SJ12675434923","room_confirmation_number":"SJ12669412921","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","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":"98892","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-29 01:24:10","reservation_modified_date_time":"2020-02-29 20:22:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98892","canceled_nights_data":"","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":"3081798","reservation_id":"93321","confirmation_number":"SJ12643720585","room_confirmation_number":"SJ12686729977","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","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":"99531","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-14 01:22:09","reservation_modified_date_time":"2020-03-14 19:48:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99531","canceled_nights_data":"","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":"3082381","reservation_id":"92641","confirmation_number":"SJ12695614638","room_confirmation_number":"SJ12665458362","room_stay_from":"2020-03-15","room_stay_to":"2020-03-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98794","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-27 03:55:06","reservation_modified_date_time":"2020-03-16 12:48:11","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","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":"3082639","reservation_id":"92687","confirmation_number":"SJ12634142512","room_confirmation_number":"SJ12682510155","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","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":"99664","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-27 21:58:10","reservation_modified_date_time":"2020-03-16 21:43:03","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99664","canceled_nights_data":"","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":"3067566","reservation_id":"91612","confirmation_number":"SJ12677964477","room_confirmation_number":"SJ12689117206","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"97749","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 21:57:42","reservation_modified_date_time":"2020-02-08 22:21:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97749","canceled_nights_data":"","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":"3067876","reservation_id":"91651","confirmation_number":"SJ12647988341","room_confirmation_number":"SJ12654546375","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","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":"97788","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 17:50:10","reservation_modified_date_time":"2020-02-09 17:50:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97788","canceled_nights_data":"","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":"3068723","reservation_id":"90592","confirmation_number":"SJ12635637752","room_confirmation_number":"SJ12626181334","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","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":"96662","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 22:03:09","reservation_modified_date_time":"2020-02-11 02:46:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96662","canceled_nights_data":"","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":"3074574","reservation_id":"90326","confirmation_number":"SJ12693267413","room_confirmation_number":"SJ12617869467","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"96375","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-21 21:54:40","reservation_modified_date_time":"2020-02-26 14:08:08","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","canceled_nights_data":"","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":"3080799","reservation_id":"93257","confirmation_number":"SJ12668992347","room_confirmation_number":"SJ12645290249","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"99463","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-12 15:02:36","reservation_modified_date_time":"2020-03-12 15:02:36","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","canceled_nights_data":"","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":"3081406","reservation_id":"93316","confirmation_number":"SJ12636037045","room_confirmation_number":"SJ12656730721","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"99527","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-14 00:01:08","reservation_modified_date_time":"2020-03-14 00:22:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99527","canceled_nights_data":"","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":"3082348","reservation_id":"93136","confirmation_number":"SJ12676528499","room_confirmation_number":"SJ12611900663","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"99590","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-09 14:59:08","reservation_modified_date_time":"2020-03-16 01:53:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99334","canceled_nights_data":"","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":"3080318","reservation_id":"92463","confirmation_number":"SJ12668720388","room_confirmation_number":"SJ12677973065","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98628","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-24 01:21:02","reservation_modified_date_time":"2020-03-10 20:52:56","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","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":"3082359","reservation_id":"92871","confirmation_number":"SJ12692980193","room_confirmation_number":"SJ12623092937","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"99023","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-02 19:24:10","reservation_modified_date_time":"2020-03-16 11:22:49","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","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":"3082387","reservation_id":"90606","confirmation_number":"SJ12648646643","room_confirmation_number":"SJ12689555882","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"96680","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-26 05:10:07","reservation_modified_date_time":"2020-03-16 13:16:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96680","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3082444","reservation_id":"92926","confirmation_number":"SJ12690628682","room_confirmation_number":"SJ12670536820","room_stay_from":"2020-03-14","room_stay_to":"2020-03-14","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"99089","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-03 23:10:47","reservation_modified_date_time":"2020-03-16 15:53:53","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3082493","reservation_id":"92500","confirmation_number":"SJ12644664537","room_confirmation_number":"SJ12617487476","room_stay_from":"2020-03-17","room_stay_to":"2020-03-20","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":"98667","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-24 21:03:09","reservation_modified_date_time":"2020-03-16 18:29:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98667","canceled_nights_data":"","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":"3082499","reservation_id":"93306","confirmation_number":"SJ12626414178","room_confirmation_number":"SJ12697554329","room_stay_from":"2020-05-20","room_stay_to":"2020-05-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"99514","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-13 19:47:08","reservation_modified_date_time":"2020-03-16 18:32:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99514","canceled_nights_data":"","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":"3082826","reservation_id":"93386","confirmation_number":"SJ12684854886","room_confirmation_number":"SJ12684603802","room_stay_from":"2020-03-17","room_stay_to":"2020-03-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"99600","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-15 19:52:10","reservation_modified_date_time":"2020-03-16 22:55:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99600","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3082854","reservation_id":"92234","confirmation_number":"SJ12652572624","room_confirmation_number":"SJ12612896424","room_stay_from":"2020-03-17","room_stay_to":"2020-03-19","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98420","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-11 10:41:10","reservation_modified_date_time":"2020-03-17 00:26:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98420","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075033","reservation_id":"91932","confirmation_number":"SJ12631470685","room_confirmation_number":"SJ12647795571","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Canceled","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-13 18:14:09","reservation_modified_date_time":"2020-02-27 14:01:36","customer_id":"98074","parentCustTravId":"98074","customer_traveller_id":"98074","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-03-16 12:22:32","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[{"room_stay_id":"3081532","reservation_id":"90995","confirmation_number":"SJ12693986498","room_confirmation_number":"SJ12627554229","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"97088","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 12:43:41","reservation_modified_date_time":"2020-03-14 12:01:23","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"77106","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gift_shop_taxable":[{"room_stay_id":"3082414","reservation_id":"93401","confirmation_number":"SJ12697451041","room_confirmation_number":"SJ12624580085","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"29.99","grand_total":"32.24","paid_amount":"32.24","product_id":null,"service_quantity":"1","product_name":"Beach Buggy package","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-16 14:26:59","reservation_modified_date_time":"2020-03-16 14:26:59","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"29.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[{"room_stay_id":"3082887","reservation_id":"93446","confirmation_number":"SJ12673986722","room_confirmation_number":"SJ12642893536","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-17 02:32:54","reservation_modified_date_time":"2020-03-17 02:32:54","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}