{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-06-27","total_rooms_exist":"1281,1282,1289,1274,1275,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":10,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1305,1943,1307","block_room_bookings":[{"confirmation_number":"SJ12612307368","room_stay_from":"2020-06-15","room_stay_to":"2020-07-01","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-04","room_stay_to":"2020-07-10","bundle_room":"0"},{"confirmation_number":"SJ12664166752","room_stay_from":"2020-06-07","room_stay_to":"2020-07-11","bundle_room":"0"}],"bundle_block_count":"1267,1268,1269,1270,1271,1272,1291,1711,1302,1303,1262,1263,1309,1310,1260,1261,1307,1308,1304,1305,1311,1312","bundle_block_bookings":[{"confirmation_number":"SJB12656235495","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","bundle_room":"0"},{"confirmation_number":"SJB12683834279","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","bundle_room":"0"},{"confirmation_number":"SJB12620712061","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","bundle_room":"1"},{"confirmation_number":"SJB12686907165","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","bundle_room":"0"},{"confirmation_number":"SJB12686690477","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","bundle_room":"0"},{"confirmation_number":"SJB12640781917","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","bundle_room":"1"},{"confirmation_number":"SJB12670942263","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","bundle_room":"1"},{"confirmation_number":"SJB12634614398","room_stay_from":"2020-06-27","room_stay_to":"2020-06-28","bundle_room":"1"},{"confirmation_number":"SJB12689822845","room_stay_from":"2020-06-25","room_stay_to":"2020-06-28","bundle_room":"1"},{"confirmation_number":"SJB12646108803","room_stay_from":"2020-06-25","room_stay_to":"2020-06-28","bundle_room":"1"},{"confirmation_number":"SJB12699999904","room_stay_from":"2020-06-26","room_stay_to":"2020-06-29","bundle_room":"1"},{"confirmation_number":"SJB12652633851","room_stay_from":"2020-06-25","room_stay_to":"2020-06-29","bundle_room":"1"},{"confirmation_number":"SJB12683562411","room_stay_from":"2020-06-27","room_stay_to":"2020-07-03","bundle_room":"0"},{"confirmation_number":"SJB12659020752","room_stay_from":"2020-06-27","room_stay_to":"2020-07-03","bundle_room":"0"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3098263","reservation_id":"95520","confirmation_number":"SJ12694119094","room_stay_from":"2020-06-26","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"173.60,173.60","nightly_discount":"0,0","subtotal":"347.20","grand_total":"390.60","paid_amount":"390.60","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-2342993116","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":"101707","customer_id":"101707","source_of_creation":"Booking.com","reservation_created_date":"2020-05-28 02:06:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"71.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"173.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3104792","reservation_id":"96384","confirmation_number":"SJ12640002984","room_stay_from":"2020-06-26","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"190.40,190.40","nightly_discount":"0,0","subtotal":"380.80","grand_total":"428.40","paid_amount":"428.40","room_type_id":"319","product_id":"1942","siteminder_id":"BDC-3582471041","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":"102495","customer_id":"102495","source_of_creation":"Booking.com","reservation_created_date":"2020-06-12 21:39:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"38.77","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"190.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3105569","reservation_id":"96512","confirmation_number":"SJ12614433935","room_stay_from":"2020-06-27","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"222.40","nightly_discount":"0","subtotal":"222.40","grand_total":"250.20","paid_amount":"250.20","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-2308457314","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":"102618","customer_id":"102618","source_of_creation":"Booking.com","reservation_created_date":"2020-06-14 22:48:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"44.53","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"222.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109297","reservation_id":"95738","confirmation_number":"SJ12651266777","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"150.40,150.40,173.60,173.60","nightly_discount":"0,0,0,0","subtotal":"648.00","grand_total":"729.00","paid_amount":"729.00","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-3942262947","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":"101907","customer_id":"101907","source_of_creation":"Booking.com","reservation_created_date":"2020-06-01 12:58:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"33.66","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"173.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109674","reservation_id":"97062","confirmation_number":"SJ12662798747","room_stay_from":"2020-06-26","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"320.80,320.80","nightly_discount":"0,0","subtotal":"641.60","grand_total":"721.80","paid_amount":"721.80","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3377456680","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":"103181","customer_id":"103181","source_of_creation":"Booking.com","reservation_created_date":"2020-06-25 14:13:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"124.49","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"320.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109799","reservation_id":"95519","confirmation_number":"SJ12668284360","room_stay_from":"2020-06-26","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"123.6,123.6","nightly_discount":"0,0","subtotal":"247.20","grand_total":"278.10","paid_amount":"278.10","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-3925047699","collect_which":"channel_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":"101706","customer_id":"101706","source_of_creation":"Booking.com","reservation_created_date":"2020-05-28 01:54:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"71.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"123.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":"3109981","reservation_id":"97113","confirmation_number":"SJ12649956236","room_stay_from":"2020-06-27","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"267.20","nightly_discount":"0","subtotal":"267.20","grand_total":"300.60","paid_amount":"300.60","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-2234252804","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":"103230","customer_id":"103230","source_of_creation":"Booking.com","reservation_created_date":"2020-06-26 17:22:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"52.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"267.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":"3110229","reservation_id":"97149","confirmation_number":"SJ12646273278","room_stay_from":"2020-06-27","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"360.80","nightly_discount":"0","subtotal":"360.80","grand_total":"405.90","paid_amount":"405.90","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-3922557544","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":"103263","customer_id":"103263","source_of_creation":"Booking.com","reservation_created_date":"2020-06-27 13:59:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"138.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"360.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110252","reservation_id":"97149","confirmation_number":"SJ12658959705","room_stay_from":"2020-06-27","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"360.80","nightly_discount":"0","subtotal":"360.80","grand_total":"405.90","paid_amount":"405.90","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-3922557544","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":"103263","customer_id":"103263","source_of_creation":"Booking.com","reservation_created_date":"2020-06-27 13:59:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"138.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"360.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110391","reservation_id":"97159","confirmation_number":"SJ12643955924","room_stay_from":"2020-06-27","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"320.80","nightly_discount":"0","subtotal":"320.80","grand_total":"360.90","paid_amount":"360.90","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-2638365078","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":"103270","customer_id":"103270","source_of_creation":"Booking.com","reservation_created_date":"2020-06-27 18:50:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"62.24","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"320.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108829","reservation_id":"95832","confirmation_number":"SJ12670586217","room_stay_from":"2020-06-27","room_stay_to":"2020-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"173.60,150.40","nightly_discount":"0,0","subtotal":"324.00","grand_total":"364.50","paid_amount":"364.50","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-2707665673","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":"101987","customer_id":"101987","source_of_creation":"Booking.com","reservation_created_date":"2020-06-02 22:48:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"67.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"173.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108729","reservation_id":"94945","confirmation_number":"SJ12669703256","room_stay_from":"2020-06-25","room_stay_to":"2020-06-30","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"53.2,69.2,69.2,53.2,53.2","nightly_discount":"0,0,0,0,0","subtotal":"298.00","grand_total":"335.25","paid_amount":"335.25","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-3190586456","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":"101135","customer_id":"101135","source_of_creation":"Booking.com","reservation_created_date":"2020-05-18 10:18:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"121.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.2","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":"3097604","reservation_id":"95245","confirmation_number":"SJ12623483344","room_stay_from":"2020-06-27","room_stay_to":"2020-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"107.6,86.8,86.8,86.8,104.4,104.4","nightly_discount":"0,0,0,0,0,0","subtotal":"576.80","grand_total":"648.90","paid_amount":"648.90","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3146344069","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"300.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101429","customer_id":"101429","source_of_creation":"Booking.com","reservation_created_date":"2020-05-22 18:47:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"184.82","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"107.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":"3102243","reservation_id":"95666","confirmation_number":"SJ12673501277","room_stay_from":"2020-06-25","room_stay_to":"2020-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.40,173.60,173.60,150.40,150.40,150.40,169.60,195.20,336.80","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"1650.40","grand_total":"1856.70","paid_amount":"1856.70","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-2977837625","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":"101845","customer_id":"101845","source_of_creation":"Booking.com","reservation_created_date":"2020-05-30 21:26:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"67.51","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"173.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3094871","reservation_id":"94974","confirmation_number":"SJ12665101773","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"270.72,270.72,309.12,309.12","nightly_discount":"0,0,0,0","subtotal":"1159.68","grand_total":"1304.64","paid_amount":"1304.64","room_type_id":"320","product_id":"1322","siteminder_id":"EXP-1664670638","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":"101164","customer_id":"101164","source_of_creation":"Expedia","reservation_created_date":"2020-05-18 18:02:12","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"309.12","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3097601","reservation_id":"95028","confirmation_number":"SJ12632113970","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.48,116.48,129.28,129.28","nightly_discount":"0,0,0,0","subtotal":"491.52","grand_total":"552.96","paid_amount":"552.96","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1664669885","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":"101218","customer_id":"101218","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 08:09:08","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":"129.28","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3097607","reservation_id":"95029","confirmation_number":"SJ12689707385","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.48,116.48,129.28,129.28","nightly_discount":"0,0,0,0","subtotal":"491.52","grand_total":"552.96","paid_amount":"552.96","room_type_id":"413","product_id":"1270","siteminder_id":"EXP-1664669888","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":"101219","customer_id":"101219","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 08:11:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.28","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109496","reservation_id":"94973","confirmation_number":"SJ12652904221","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"286.72,286.72,325.12,325.12","nightly_discount":"0,0,0,0","subtotal":"1223.68","grand_total":"1376.64","paid_amount":"1376.64","room_type_id":"320","product_id":"1324","siteminder_id":"EXP-1664670637","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":"101163","customer_id":"101163","source_of_creation":"Expedia","reservation_created_date":"2020-05-18 18:02:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"325.12","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109742","reservation_id":"97071","confirmation_number":"SJ12681682512","room_stay_from":"2020-06-27","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"286.72","nightly_discount":"0","subtotal":"286.72","grand_total":"322.56","paid_amount":"322.56","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1673872861","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":"103192","customer_id":"103192","source_of_creation":"Expedia","reservation_created_date":"2020-06-25 18:27:05","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":"286.72","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109306","reservation_id":"96004","confirmation_number":"SJ12626785575","room_stay_from":"2020-06-25","room_stay_to":"2020-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.32,138.88,138.88,120.32","nightly_discount":"0,0,0,0","subtotal":"518.40","grand_total":"583.20","paid_amount":"583.20","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1668539331","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":"102138","customer_id":"102138","source_of_creation":"Expedia","reservation_created_date":"2020-06-06 19:06:10","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":"138.88","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109591","reservation_id":"96568","confirmation_number":"SJ12610772679","room_stay_from":"2020-06-25","room_stay_to":"2020-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.20,213.76,213.76,235.52","nightly_discount":"0,0,0,0","subtotal":"874.24","grand_total":"983.52","paid_amount":"983.52","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1671000013","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":"102679","customer_id":"102679","source_of_creation":"Expedia","reservation_created_date":"2020-06-15 21:44:07","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":"213.76","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108690","reservation_id":"92834","confirmation_number":"SJ12625658794","room_stay_from":"2020-06-26","room_stay_to":"2020-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.20,179.20,179.20,160.64,160.64,181.76","nightly_discount":"0,0,0,0,0,0","subtotal":"1040.64","grand_total":"1170.72","paid_amount":"1170.72","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1651325724","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":"98983","customer_id":"98983","source_of_creation":"Expedia","reservation_created_date":"2020-03-01 22:09:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"208.13","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3109594","reservation_id":"96215","confirmation_number":"SJ12680935180","room_stay_from":"2020-06-25","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.33,211.51,211.51","nightly_discount":"0.00,0.00,0.00","subtotal":"608.35","grand_total":"684.40","paid_amount":"684.40","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":"102337","customer_id":"102337","source_of_creation":"FE","reservation_created_date":"2020-06-10 13:11:01","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":"211.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110036","reservation_id":"95008","confirmation_number":"SJ12642068326","room_stay_from":"2020-06-26","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"149.00,149.00","nightly_discount":"0.00,0.00","subtotal":"298.00","grand_total":"335.25","paid_amount":"335.25","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85469","customer_id":"85469","source_of_creation":"FE","reservation_created_date":"2020-05-19 01:21:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.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":"3108602","reservation_id":"96634","confirmation_number":"SJ12687916627","room_stay_from":"2020-06-25","room_stay_to":"2020-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.66,251.51,251.51,264.39","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"999.07","grand_total":"1123.95","paid_amount":"1123.95","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"102748","customer_id":"102748","source_of_creation":"FE","reservation_created_date":"2020-06-16 17:08:31","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"251.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108692","reservation_id":"96599","confirmation_number":"SJ12688248788","room_stay_from":"2020-06-26","room_stay_to":"2020-06-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.51,251.51,264.39,231.66","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"999.07","grand_total":"1123.95","paid_amount":"1123.95","room_type_id":"412","product_id":"1316","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102712","customer_id":"102712","source_of_creation":"FE","reservation_created_date":"2020-06-16 10:40:33","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"251.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3107419","reservation_id":"96702","confirmation_number":"SJ12675808399","room_stay_from":"2020-06-26","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"238.80,238.80","nightly_discount":"0.00,0.00","subtotal":"477.60","grand_total":"537.30","paid_amount":"537.30","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":"102816","customer_id":"102816","source_of_creation":"PMS","reservation_created_date":"2020-06-17 15:09:30","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":"238.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108357","reservation_id":"96913","confirmation_number":"SJ12632583388","room_stay_from":"2020-06-26","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"287.40,287.40","nightly_discount":"0.00,0.00","subtotal":"574.80","grand_total":"646.65","paid_amount":"646.65","room_type_id":"319","product_id":"1313","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103032","customer_id":"103032","source_of_creation":"PMS","reservation_created_date":"2020-06-21 19:57:41","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":"287.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108960","reservation_id":"96499","confirmation_number":"SJ12686702093","room_stay_from":"2020-06-25","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"185.33,251.51,251.51","nightly_discount":"0.00,0.00,0.00","subtotal":"688.35","grand_total":"774.40","paid_amount":"774.40","room_type_id":"319","product_id":"1302","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102605","customer_id":"102605","source_of_creation":"PMS","reservation_created_date":"2020-06-14 19:18:49","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"251.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109303","reservation_id":"95991","confirmation_number":"SJ12699653097","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.33,185.33,211.51,211.51","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"793.68","grand_total":"892.89","paid_amount":"892.89","room_type_id":"413","product_id":"1261","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102008","customer_id":"102008","source_of_creation":"PMS","reservation_created_date":"2020-06-06 15:09:51","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":"211.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109309","reservation_id":"95851","confirmation_number":"SJ12621028562","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.33,185.33,211.51,211.51","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"793.68","grand_total":"892.89","paid_amount":"892.89","room_type_id":"413","product_id":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102008","customer_id":"102008","source_of_creation":"PMS","reservation_created_date":"2020-06-03 14:11:28","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":"211.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109718","reservation_id":"97067","confirmation_number":"SJ12653815137","room_stay_from":"2020-06-25","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00,290.00,290.00","nightly_discount":"25.00,29.00,29.00","subtotal":"805.00","grand_total":"812.25","paid_amount":"812.25","room_type_id":"318","product_id":"1289","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103186","customer_id":"103186","source_of_creation":"PMS","reservation_created_date":"2020-06-25 17:04:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"290.00","currentDayDiscount":"29.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110389","reservation_id":"97152","confirmation_number":"SJ12692710049","room_stay_from":"2020-06-27","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"334.80","nightly_discount":"33.48","subtotal":"334.80","grand_total":"338.99","paid_amount":"338.99","room_type_id":"319","product_id":"1286","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":"103264","customer_id":"103264","source_of_creation":"PMS","reservation_created_date":"2020-06-27 15:44:54","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"334.80","currentDayDiscount":"33.48","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108899","reservation_id":"96974","confirmation_number":"SJ12626043654","room_stay_from":"2020-06-25","room_stay_to":"2020-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"254.83,276.66,276.66,264.39","nightly_discount":"25.48,27.66,27.66,27.66","subtotal":"1072.54","grand_total":"1084.59","paid_amount":"1084.59","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103101","customer_id":"103101","source_of_creation":"PMS","reservation_created_date":"2020-06-23 03:42:26","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":"276.66","currentDayDiscount":"27.66","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108901","reservation_id":"96974","confirmation_number":"SJ12693409809","room_stay_from":"2020-06-25","room_stay_to":"2020-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"254.83,276.66,276.66,264.39","nightly_discount":"25.48,27.66,27.66,26.43","subtotal":"1072.54","grand_total":"1085.98","paid_amount":"1085.98","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103101","customer_id":"103101","source_of_creation":"PMS","reservation_created_date":"2020-06-23 03:46:27","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":"276.66","currentDayDiscount":"27.66","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110088","reservation_id":"97068","confirmation_number":"SJ12617761192","room_stay_from":"2020-06-26","room_stay_to":"2020-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"314.00,314.00,314.00","nightly_discount":"0.00,0.00,0","subtotal":"942.00","grand_total":"1059.75","paid_amount":"1059.75","room_type_id":"318","product_id":"1282","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85468","customer_id":"85468","source_of_creation":"PMS","reservation_created_date":"2020-06-25 17:14:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"314.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":"3107435","reservation_id":"96701","confirmation_number":"SJ12649311990","room_stay_from":"2020-06-26","room_stay_to":"2020-06-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"238.80,238.80,238.80,238.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"955.20","grand_total":"1074.60","paid_amount":"1074.60","room_type_id":"413","product_id":"1263","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102816","customer_id":"102816","source_of_creation":"PMS","reservation_created_date":"2020-06-17 15:06:36","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"238.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108850","reservation_id":"96566","confirmation_number":"SJ12644404587","room_stay_from":"2020-06-26","room_stay_to":"2020-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.51,251.51,264.39,231.66,231.66","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1230.73","grand_total":"1384.57","paid_amount":"1384.57","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102678","customer_id":"102678","source_of_creation":"PMS","reservation_created_date":"2020-06-15 21:00:56","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"251.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3106660","reservation_id":"92476","confirmation_number":"SJ12653314597","room_stay_from":"2020-06-27","room_stay_to":"2020-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"331.20,331.20,331.20,331.20,331.20,331.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1987.00","grand_total":"2235.38","paid_amount":"2235.38","room_type_id":"320","product_id":"1332","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":"98643","customer_id":"98643","source_of_creation":"PMS","reservation_created_date":"2020-02-24 13:35:27","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"331.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":"3110359","reservation_id":"97136","confirmation_number":"SJ12611108421","room_stay_from":"2020-07-01","room_stay_to":"2020-07-03","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00,199.00","nightly_discount":"0.00,0","subtotal":"398.00","grand_total":"447.75","paid_amount":"223.88","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":"103255","customer_id":"103255","source_of_creation":"PMS","reservation_created_date":"2020-06-26 23:02:56","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":"","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":"3110276","reservation_id":"95503","confirmation_number":"SJ12673054340","room_stay_from":"2020-07-22","room_stay_to":"2020-07-24","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.27,179.27","nightly_discount":"0.00,0","subtotal":"358.54","grand_total":"403.36","paid_amount":"201.68","room_type_id":"319","product_id":"1288","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":"101691","customer_id":"101691","source_of_creation":"PMS","reservation_created_date":"2020-05-27 19:14:01","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3109068","reservation_id":"96543","confirmation_number":"SJ12616896695","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.58,103.57,103.57,103.57,103.57,103.57,103.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"725.00","grand_total":"725.00","paid_amount":"0.00","room_type_id":"319","product_id":"1303","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-15 15:30:39","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":"103.57","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":"3109072","reservation_id":"96542","confirmation_number":"SJ12694445048","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.58,103.57,103.57,103.57,103.57,103.57,103.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"725.00","grand_total":"725.00","paid_amount":"0.00","room_type_id":"319","product_id":"1309","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-15 15:25:17","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":"103.57","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":"3109074","reservation_id":"96929","confirmation_number":"SJ12688032336","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.57,103.57,103.57,103.57,103.57,103.57,103.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"725.00","grand_total":"725.00","paid_amount":"0.00","room_type_id":"319","product_id":"1310","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"103049","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-22 04:22:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103.58","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":"3109064","reservation_id":"96538","confirmation_number":"SJ12686244037","room_stay_from":"2020-06-26","room_stay_to":"2020-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.57,103.57,103.57,103.57,103.57,103.57,103.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"725.00","grand_total":"725.00","paid_amount":"0.00","room_type_id":"319","product_id":"1319","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-15 14:55:15","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":"103.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3097664","reservation_id":"95422","confirmation_number":"SJ12681033452","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"319","product_id":"1711","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-26 16:19:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3097667","reservation_id":"95423","confirmation_number":"SJ12669328888","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"319","product_id":"1291","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-26 16:20:36","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3104240","reservation_id":"96324","confirmation_number":"SJ12699465336","room_stay_from":"2020-06-26","room_stay_to":"2020-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"84.38","room_type_id":"319","product_id":"1915","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-12 02:24:45","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":"78.33","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3104246","reservation_id":"96326","confirmation_number":"SJ12612466661","room_stay_from":"2020-06-26","room_stay_to":"2020-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"84.38","room_type_id":"319","product_id":"1308","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-12 02:26:07","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":"78.33","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3102479","reservation_id":"95424","confirmation_number":"SJ12682602763","room_stay_from":"2020-06-27","room_stay_to":"2020-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-26 16:23:40","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":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3102484","reservation_id":"95425","confirmation_number":"SJ12665917896","room_stay_from":"2020-06-27","room_stay_to":"2020-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-26 16:25:46","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":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3104210","reservation_id":"96316","confirmation_number":"SJ12615138321","room_stay_from":"2020-06-25","room_stay_to":"2020-06-30","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.00","paid_amount":"0.00","room_type_id":"319","product_id":"1286","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-12 02:03:19","service_canceled_date_time":"2020-06-27 11:57:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"","total_paid_amount":"0.00","deltaChange":-156,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3109800","reservation_id":"95519","confirmation_number":"SJ12633008797","room_confirmation_number":"SJ12668284360","room_stay_from":"2020-06-26","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"101706","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-06-25 21:29:31","reservation_modified_date_time":"2020-06-25 21:29:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101706","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108731","reservation_id":"94945","confirmation_number":"SJ12642504448","room_confirmation_number":"SJ12669703256","room_stay_from":"2020-06-25","room_stay_to":"2020-06-30","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":"101135","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-06-22 18:01:38","reservation_modified_date_time":"2020-06-22 18:01:38","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101135","canceled_nights_data":"","posAmt_airbnb_taxpaid":"250.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3097605","reservation_id":"95245","confirmation_number":"SJ12698203407","room_confirmation_number":"SJ12623483344","room_stay_from":"2020-06-27","room_stay_to":"2020-07-03","room_stay_status":"Active","nightly_price":"50,50,50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"300.00","grand_total":"337.50","paid_amount":"337.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"101429","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-05-26 14:31:45","reservation_modified_date_time":"2020-05-26 14:31:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101429","canceled_nights_data":"","posAmt_airbnb_taxpaid":"300.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3094872","reservation_id":"94974","confirmation_number":"SJ12660728254","room_confirmation_number":"SJ12665101773","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"101164","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 18:02:12","reservation_modified_date_time":"2020-05-18 18:02:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101164","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3097603","reservation_id":"95028","confirmation_number":"SJ12635702421","room_confirmation_number":"SJ12632113970","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"101218","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 08:09:08","reservation_modified_date_time":"2020-05-26 14:31:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101218","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3097608","reservation_id":"95029","confirmation_number":"SJ12627556705","room_confirmation_number":"SJ12689707385","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"101219","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 08:11:09","reservation_modified_date_time":"2020-05-26 14:32:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101219","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3097665","reservation_id":"95422","confirmation_number":"SJ12691430516","room_confirmation_number":"SJ12681033452","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101613","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 16:19:27","reservation_modified_date_time":"2020-05-26 16:19:27","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3097668","reservation_id":"95423","confirmation_number":"SJ12620136082","room_confirmation_number":"SJ12669328888","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101613","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 16:20:36","reservation_modified_date_time":"2020-05-26 16:20:36","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3098264","reservation_id":"95520","confirmation_number":"SJ12689957870","room_confirmation_number":"SJ12694119094","room_stay_from":"2020-06-26","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"101707","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 02:06:10","reservation_modified_date_time":"2020-05-28 02:06:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101707","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3104791","reservation_id":"96384","confirmation_number":"SJ12629721560","room_confirmation_number":"SJ12640002984","room_stay_from":"2020-06-26","room_stay_to":"2020-06-28","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":"102495","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 21:39:10","reservation_modified_date_time":"2020-06-13 03:27:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102495","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3105570","reservation_id":"96512","confirmation_number":"SJ12614545523","room_confirmation_number":"SJ12614433935","room_stay_from":"2020-06-27","room_stay_to":"2020-06-28","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":"102618","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-14 22:48:11","reservation_modified_date_time":"2020-06-14 22:48:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102618","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107421","reservation_id":"96702","confirmation_number":"SJ12687312313","room_confirmation_number":"SJ12675808399","room_stay_from":"2020-06-26","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"102816","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-17 15:09:30","reservation_modified_date_time":"2020-06-19 03:06:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102816","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108358","reservation_id":"96913","confirmation_number":"SJ12646316065","room_confirmation_number":"SJ12632583388","room_stay_from":"2020-06-26","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"103032","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-21 19:57:41","reservation_modified_date_time":"2020-06-21 19:57:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103032","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108961","reservation_id":"96499","confirmation_number":"SJ12634722940","room_confirmation_number":"SJ12686702093","room_stay_from":"2020-06-25","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"102605","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-14 19:18:49","reservation_modified_date_time":"2020-06-23 14:25:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102605","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109067","reservation_id":"96543","confirmation_number":"SJ12656129645","room_confirmation_number":"SJ12616896695","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102651","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 15:30:39","reservation_modified_date_time":"2020-06-23 16:29:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109071","reservation_id":"96542","confirmation_number":"SJ12643915172","room_confirmation_number":"SJ12694445048","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102649","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 15:25:17","reservation_modified_date_time":"2020-06-23 16:29:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109073","reservation_id":"96929","confirmation_number":"SJ12636441819","room_confirmation_number":"SJ12688032336","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103050","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-22 04:22:22","reservation_modified_date_time":"2020-06-23 16:29:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109299","reservation_id":"95738","confirmation_number":"SJ12621707748","room_confirmation_number":"SJ12651266777","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"101907","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-01 12:58:06","reservation_modified_date_time":"2020-06-23 22:39:38","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101907","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109305","reservation_id":"95991","confirmation_number":"SJ12674294147","room_confirmation_number":"SJ12699653097","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"102008","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-06 15:09:51","reservation_modified_date_time":"2020-06-23 22:39:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102008","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109310","reservation_id":"95851","confirmation_number":"SJ12681755390","room_confirmation_number":"SJ12621028562","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"102008","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-03 14:11:28","reservation_modified_date_time":"2020-06-23 22:40:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102008","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109495","reservation_id":"94973","confirmation_number":"SJ12617841544","room_confirmation_number":"SJ12652904221","room_stay_from":"2020-06-24","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"102756","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 18:02:09","reservation_modified_date_time":"2020-06-24 20:36:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101163","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109595","reservation_id":"96215","confirmation_number":"SJ12635473829","room_confirmation_number":"SJ12680935180","room_stay_from":"2020-06-25","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"102337","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-10 13:11:01","reservation_modified_date_time":"2020-06-25 11:07:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102337","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109675","reservation_id":"97062","confirmation_number":"SJ12695974815","room_confirmation_number":"SJ12662798747","room_stay_from":"2020-06-26","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"103181","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-25 14:13:10","reservation_modified_date_time":"2020-06-25 14:13:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103181","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109719","reservation_id":"97067","confirmation_number":"SJ12658950750","room_confirmation_number":"SJ12653815137","room_stay_from":"2020-06-25","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"103186","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-25 17:04:16","reservation_modified_date_time":"2020-06-25 17:04:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103186","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109743","reservation_id":"97071","confirmation_number":"SJ12655482926","room_confirmation_number":"SJ12681682512","room_stay_from":"2020-06-27","room_stay_to":"2020-06-28","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":"103192","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-25 18:27:05","reservation_modified_date_time":"2020-06-25 18:27:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103192","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109801","reservation_id":"95519","confirmation_number":"SJ12684572994","room_confirmation_number":"SJ12668284360","room_stay_from":"2020-06-26","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101706","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 01:54:09","reservation_modified_date_time":"2020-06-25 21:29:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101706","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109982","reservation_id":"97113","confirmation_number":"SJ12663687860","room_confirmation_number":"SJ12649956236","room_stay_from":"2020-06-27","room_stay_to":"2020-06-28","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":"103230","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 17:22:06","reservation_modified_date_time":"2020-06-26 17:22:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103230","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110038","reservation_id":"95008","confirmation_number":"SJ12649143769","room_confirmation_number":"SJ12642068326","room_stay_from":"2020-06-26","room_stay_to":"2020-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"85469","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 01:21:38","reservation_modified_date_time":"2020-06-26 18:40:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85469","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110230","reservation_id":"97149","confirmation_number":"SJ12650327022","room_confirmation_number":"SJ12646273278","room_stay_from":"2020-06-27","room_stay_to":"2020-06-28","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":"103263","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-27 13:59:14","reservation_modified_date_time":"2020-06-27 13:59:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103263","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110253","reservation_id":"97149","confirmation_number":"SJ12680441640","room_confirmation_number":"SJ12658959705","room_stay_from":"2020-06-27","room_stay_to":"2020-06-28","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":"103263","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-27 13:59:10","reservation_modified_date_time":"2020-06-27 15:16:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103263","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110390","reservation_id":"97152","confirmation_number":"SJ12673797559","room_confirmation_number":"SJ12692710049","room_stay_from":"2020-06-27","room_stay_to":"2020-06-28","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":"103264","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-27 15:44:54","reservation_modified_date_time":"2020-06-27 21:19:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103264","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110392","reservation_id":"97159","confirmation_number":"SJ12623948729","room_confirmation_number":"SJ12643955924","room_stay_from":"2020-06-27","room_stay_to":"2020-06-28","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":"103270","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-27 18:50:07","reservation_modified_date_time":"2020-06-27 21:19:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103270","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3104241","reservation_id":"96324","confirmation_number":"SJ12669464606","room_confirmation_number":"SJ12699465336","room_stay_from":"2020-06-26","room_stay_to":"2020-06-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102448","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 02:24:45","reservation_modified_date_time":"2020-06-12 02:24:45","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3104247","reservation_id":"96326","confirmation_number":"SJ12626408461","room_confirmation_number":"SJ12612466661","room_stay_from":"2020-06-26","room_stay_to":"2020-06-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102450","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 02:26:07","reservation_modified_date_time":"2020-06-12 02:26:07","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108603","reservation_id":"96634","confirmation_number":"SJ12620372827","room_confirmation_number":"SJ12687916627","room_stay_from":"2020-06-25","room_stay_to":"2020-06-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"102748","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 17:08:31","reservation_modified_date_time":"2020-06-22 14:38:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102748","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108830","reservation_id":"95832","confirmation_number":"SJ12678821951","room_confirmation_number":"SJ12670586217","room_stay_from":"2020-06-27","room_stay_to":"2020-06-29","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"101987","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-02 22:48:07","reservation_modified_date_time":"2020-06-22 21:54:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101987","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108900","reservation_id":"96974","confirmation_number":"SJ12648857659","room_confirmation_number":"SJ12626043654","room_stay_from":"2020-06-25","room_stay_to":"2020-06-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"103101","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-23 03:42:26","reservation_modified_date_time":"2020-06-23 03:42:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103101","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108902","reservation_id":"96974","confirmation_number":"SJ12643769935","room_confirmation_number":"SJ12693409809","room_stay_from":"2020-06-25","room_stay_to":"2020-06-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"103101","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-23 03:46:27","reservation_modified_date_time":"2020-06-23 03:46:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103101","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109308","reservation_id":"96004","confirmation_number":"SJ12665189604","room_confirmation_number":"SJ12626785575","room_stay_from":"2020-06-25","room_stay_to":"2020-06-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"102138","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-06 19:06:10","reservation_modified_date_time":"2020-06-23 22:40:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102138","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109593","reservation_id":"96568","confirmation_number":"SJ12634812945","room_confirmation_number":"SJ12610772679","room_stay_from":"2020-06-25","room_stay_to":"2020-06-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"102679","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 21:44:07","reservation_modified_date_time":"2020-06-25 11:06:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102679","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110089","reservation_id":"97068","confirmation_number":"SJ12623379118","room_confirmation_number":"SJ12617761192","room_stay_from":"2020-06-26","room_stay_to":"2020-06-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"103188","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-25 17:14:22","reservation_modified_date_time":"2020-06-26 20:10:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85468","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107438","reservation_id":"96701","confirmation_number":"SJ12621206302","room_confirmation_number":"SJ12649311990","room_stay_from":"2020-06-26","room_stay_to":"2020-06-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"102816","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-17 15:06:36","reservation_modified_date_time":"2020-06-19 03:16:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102816","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108693","reservation_id":"96599","confirmation_number":"SJ12630034934","room_confirmation_number":"SJ12688248788","room_stay_from":"2020-06-26","room_stay_to":"2020-06-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"102712","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 10:40:33","reservation_modified_date_time":"2020-06-22 17:20:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102712","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108732","reservation_id":"94945","confirmation_number":"SJ12680847302","room_confirmation_number":"SJ12669703256","room_stay_from":"2020-06-25","room_stay_to":"2020-06-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"101135","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 10:18:06","reservation_modified_date_time":"2020-06-22 18:01:38","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101135","canceled_nights_data":"","posAmt_airbnb_taxpaid":"250.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":"3108851","reservation_id":"96566","confirmation_number":"SJ12666855454","room_confirmation_number":"SJ12644404587","room_stay_from":"2020-06-26","room_stay_to":"2020-07-01","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":"102678","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 21:00:56","reservation_modified_date_time":"2020-06-22 23:07:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102678","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108691","reservation_id":"92834","confirmation_number":"SJ12677819207","room_confirmation_number":"SJ12625658794","room_stay_from":"2020-06-26","room_stay_to":"2020-07-02","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":"98983","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-01 22:09:10","reservation_modified_date_time":"2020-06-22 17:19:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98983","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3097606","reservation_id":"95245","confirmation_number":"SJ12655673795","room_confirmation_number":"SJ12623483344","room_stay_from":"2020-06-27","room_stay_to":"2020-07-03","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":"101429","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-22 18:47:06","reservation_modified_date_time":"2020-05-26 14:31:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101429","canceled_nights_data":"","posAmt_airbnb_taxpaid":"300.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":"3106663","reservation_id":"92476","confirmation_number":"SJ12665492970","room_confirmation_number":"SJ12653314597","room_stay_from":"2020-06-27","room_stay_to":"2020-07-03","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":"98643","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-24 13:35:27","reservation_modified_date_time":"2020-06-17 17:36:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98643","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109063","reservation_id":"96538","confirmation_number":"SJ12689731215","room_confirmation_number":"SJ12686244037","room_stay_from":"2020-06-26","room_stay_to":"2020-07-03","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":"102645","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 14:55:15","reservation_modified_date_time":"2020-06-23 16:29:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3102242","reservation_id":"95666","confirmation_number":"SJ12674848047","room_confirmation_number":"SJ12673501277","room_stay_from":"2020-06-25","room_stay_to":"2020-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"101845","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-30 21:26:12","reservation_modified_date_time":"2020-06-06 22:14:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101845","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3102480","reservation_id":"95424","confirmation_number":"SJ12627581383","room_confirmation_number":"SJ12682602763","room_stay_from":"2020-06-27","room_stay_to":"2020-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98577","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 16:23:40","reservation_modified_date_time":"2020-06-07 14:38:21","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3102485","reservation_id":"95425","confirmation_number":"SJ12637822636","room_confirmation_number":"SJ12665917896","room_stay_from":"2020-06-27","room_stay_to":"2020-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101614","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 16:25:46","reservation_modified_date_time":"2020-06-07 14:39:02","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110360","reservation_id":"97136","confirmation_number":"SJ12638138691","room_confirmation_number":"SJ12611108421","room_stay_from":"2020-07-01","room_stay_to":"2020-07-03","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103255","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 23:02:56","reservation_modified_date_time":"2020-06-27 20:36:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103255","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110277","reservation_id":"95503","confirmation_number":"SJ12649184074","room_confirmation_number":"SJ12673054340","room_stay_from":"2020-07-22","room_stay_to":"2020-07-24","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101691","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 19:14:01","reservation_modified_date_time":"2020-06-27 16:48:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101691","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3104211","reservation_id":"96316","confirmation_number":"SJ12683549516","room_confirmation_number":"SJ12615138321","room_stay_from":"2020-06-25","room_stay_to":"2020-06-30","room_stay_status":"Canceled","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-12 02:03:19","reservation_modified_date_time":"2020-06-12 02:03:19","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"102440","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-06-27 11:57:53","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","deltaChange":-50,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3110423","reservation_id":"97169","confirmation_number":"SJ12623960116","room_confirmation_number":"SJ12670842015","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"27.91","grand_total":"30.00","paid_amount":"30.00","product_id":null,"service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-28 00:57:09","reservation_modified_date_time":"2020-06-28 00:57:09","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":"27.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3110424","reservation_id":"97169","confirmation_number":"SJ12658288158","room_confirmation_number":"SJ12670842015","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"60.00","paid_amount":"60.00","product_id":null,"service_quantity":"4","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-28 00:57:09","reservation_modified_date_time":"2020-06-28 00:57:09","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":"55.80","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":"3110226","reservation_id":"97148","confirmation_number":"SJ12632602352","room_confirmation_number":"SJ12656942637","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-27 13:54:07","reservation_modified_date_time":"2020-06-27 13:54:07","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}