{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-08-07","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":3,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1307","block_room_bookings":[{"confirmation_number":"SJ12676533150","room_stay_from":"2020-07-31","room_stay_to":"2020-08-15","bundle_room":"0"}],"bundle_block_count":"1267,1268,1309,1310,1311,1312,1304,1305,1269,1270,1307,1308,1262,1263,1260,1261,1291,1711,1271,1272,1302,1303","bundle_block_bookings":[{"confirmation_number":"SJB12694777642","room_stay_from":"2020-08-07","room_stay_to":"2020-08-08","bundle_room":"1"},{"confirmation_number":"SJB12675379331","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","bundle_room":"0"},{"confirmation_number":"SJB12692328099","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","bundle_room":"0"},{"confirmation_number":"SJB12667567744","room_stay_from":"2020-08-07","room_stay_to":"2020-08-09","bundle_room":"1"},{"confirmation_number":"SJB12656450728","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","bundle_room":"0"},{"confirmation_number":"SJB12684822863","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","bundle_room":"0"},{"confirmation_number":"SJB12648192612","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","bundle_room":"1"},{"confirmation_number":"SJB12664178015","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","bundle_room":"1"},{"confirmation_number":"SJB12613531863","room_stay_from":"2020-08-07","room_stay_to":"2020-08-09","bundle_room":"1"},{"confirmation_number":"SJB12664211868","room_stay_from":"2020-08-07","room_stay_to":"2020-08-09","bundle_room":"1"},{"confirmation_number":"SJB12679908069","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","bundle_room":"1"},{"confirmation_number":"SJB12662439056","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","bundle_room":"0"},{"confirmation_number":"SJB12689441987","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","bundle_room":"0"},{"confirmation_number":"SJB12617094870","room_stay_from":"2020-08-06","room_stay_to":"2020-08-10","bundle_room":"0"},{"confirmation_number":"SJB12652547709","room_stay_from":"2020-08-06","room_stay_to":"2020-08-10","bundle_room":"0"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3122072","reservation_id":"96031","confirmation_number":"SJ12662652194","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"153.00,153.00,153.00","nightly_discount":"0,0,0","subtotal":"459.00","grand_total":"516.38","paid_amount":"516.38","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-3755639341","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":"102163","customer_id":"102163","source_of_creation":"Booking.com","reservation_created_date":"2020-06-07 03:55:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"64.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"153.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":"3122955","reservation_id":"98082","confirmation_number":"SJ12656578873","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"241.00,394.00,394.00","nightly_discount":"0,0,0","subtotal":"1029.00","grand_total":"1157.63","paid_amount":"1157.63","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-2282201150","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":"104149","customer_id":"104149","source_of_creation":"Booking.com","reservation_created_date":"2020-07-23 14:49:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"198.72","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"394.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":"3123893","reservation_id":"96104","confirmation_number":"SJ12621908645","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.00,163.00,163.00,163.00","nightly_discount":"0,0,0,0","subtotal":"652.00","grand_total":"733.50","paid_amount":"733.50","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3362490097","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":"102227","customer_id":"102227","source_of_creation":"Booking.com","reservation_created_date":"2020-06-08 16:34:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"67.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"163.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":"3122818","reservation_id":"95382","confirmation_number":"SJ12650481444","room_stay_from":"2020-08-03","room_stay_to":"2020-08-09","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.00,123.00,123.00,123.00,143.00,143.00","nightly_discount":"0,0,0,0,0,0","subtotal":"778.00","grand_total":"875.25","paid_amount":"0.00","room_type_id":"413","product_id":"1268","siteminder_id":"BDC-2359762740","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":"101573","customer_id":"101573","source_of_creation":"Booking.com","reservation_created_date":"2020-05-25 16:53:07","service_canceled_date_time":"2020-08-07 13:37:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"167.04","reservation_status_type":"room_dates_changed","total_paid_amount":"0.00","deltaChange":-492,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3123698","reservation_id":"98618","confirmation_number":"SJ12668340584","room_stay_from":"2020-08-06","room_stay_to":"2020-08-07","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"191.00","nightly_discount":"0","subtotal":"191.00","grand_total":"214.88","paid_amount":"0.00","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-2478582593","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":"104628","customer_id":"104628","source_of_creation":"Booking.com","reservation_created_date":"2020-08-05 17:55:07","service_canceled_date_time":"2020-08-07 11:17:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"38.88","reservation_status_type":"","total_paid_amount":"0.00","deltaChange":-191,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[{"room_stay_id":"3120774","reservation_id":"95936","confirmation_number":"SJ12684489850","room_stay_from":"2020-08-07","room_stay_to":"2020-08-08","room_stay_status":"Canceled","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"103","nightly_discount":"0","subtotal":"103.00","grand_total":"115.88","paid_amount":"115.88","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-3161760096","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102080","customer_id":"102080","source_of_creation":"Booking.com","reservation_created_date":"2020-06-05 12:11:05","service_canceled_date_time":"2020-08-07 21:35:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"32.04","deltaChange":"115.88","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3095227","reservation_id":"95064","confirmation_number":"SJ12610097089","room_stay_from":"2020-08-03","room_stay_to":"2020-08-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.48,116.48,116.48,116.48,129.28","nightly_discount":"0,0,0,0,0","subtotal":"595.20","grand_total":"669.60","paid_amount":"669.60","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1664872652","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":"101248","customer_id":"101248","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 20:22:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3123987","reservation_id":"98071","confirmation_number":"SJ12631862381","room_stay_from":"2020-08-06","room_stay_to":"2020-08-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.60,267.20","nightly_discount":"0,0","subtotal":"448.80","grand_total":"504.90","paid_amount":"504.90","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1682102712","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":"104140","customer_id":"104140","source_of_creation":"Expedia","reservation_created_date":"2020-07-23 01:05:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3121667","reservation_id":"98359","confirmation_number":"SJ12661912413","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"201.60,287.20,287.20","nightly_discount":"0,0,0","subtotal":"776.00","grand_total":"873.00","paid_amount":"873.00","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1684487894","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":"104654","customer_id":"104396","source_of_creation":"Expedia","reservation_created_date":"2020-07-30 15:10:12","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":"287.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":"3123865","reservation_id":"98390","confirmation_number":"SJ12633062975","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"188.4,310.8,310.8","nightly_discount":"0,0,0","subtotal":"810.00","grand_total":"911.25","paid_amount":"911.25","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1684604083","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104656","customer_id":"104414","source_of_creation":"Expedia","reservation_created_date":"2020-07-30 21:50:25","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"310.8","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":"3123890","reservation_id":"97552","confirmation_number":"SJ12614110206","room_stay_from":"2020-08-07","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"267.20,267.20","nightly_discount":"0,0","subtotal":"534.40","grand_total":"601.20","paid_amount":"601.20","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1677727212","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":"103626","customer_id":"103626","source_of_creation":"Expedia","reservation_created_date":"2020-07-08 21:14:12","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":"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":"3124409","reservation_id":"98698","confirmation_number":"SJ12622754751","room_stay_from":"2020-08-07","room_stay_to":"2020-08-09","room_stay_status":"Active","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"287.20,287.20","nightly_discount":"0.00,0.00","subtotal":"574.40","grand_total":"646.20","paid_amount":"323.11","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1687101586","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":"104703","customer_id":"104703","source_of_creation":"Expedia","reservation_created_date":"2020-08-07 18:32:19","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"287.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":"3115076","reservation_id":"96028","confirmation_number":"SJ12614821200","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"113.92,113.92,101.12","nightly_discount":"0,0,0","subtotal":"328.96","grand_total":"370.08","paid_amount":"370.08","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1668599756","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":"102159","customer_id":"102159","source_of_creation":"Expedia","reservation_created_date":"2020-06-07 00:01:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.92","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":"3122949","reservation_id":"98196","confirmation_number":"SJ12653037816","room_stay_from":"2020-08-06","room_stay_to":"2020-08-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"213.52,314.00","nightly_discount":"0.00,0.00","subtotal":"527.52","grand_total":"593.46","paid_amount":"593.46","room_type_id":"318","product_id":"1281","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104257","customer_id":"104257","source_of_creation":"FE","reservation_created_date":"2020-07-26 01:36:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3123058","reservation_id":"97519","confirmation_number":"SJ12612819897","room_stay_from":"2020-08-02","room_stay_to":"2020-08-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"235.00,115.60,115.60,159.80,159.80,159.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"945.60","grand_total":"1063.80","paid_amount":"1063.80","room_type_id":"412","product_id":"1866","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102907","customer_id":"102907","source_of_creation":"FE","reservation_created_date":"2020-07-07 22:39:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"159.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":"3123909","reservation_id":"98544","confirmation_number":"SJ12610329132","room_stay_from":"2020-08-07","room_stay_to":"2020-08-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"254.05","nightly_discount":"0.00","subtotal":"254.05","grand_total":"285.80","paid_amount":"285.80","room_type_id":"319","product_id":"1915","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104561","customer_id":"104561","source_of_creation":"FE","reservation_created_date":"2020-08-03 16:16:42","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":"254.05","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3124381","reservation_id":"98701","confirmation_number":"SJ12673987670","room_stay_from":"2020-08-07","room_stay_to":"2020-08-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"264.00","nightly_discount":"0.00","subtotal":"264.00","grand_total":"297.00","paid_amount":"297.00","room_type_id":"413","product_id":"1267","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":"82630","customer_id":"82630","source_of_creation":"FE","reservation_created_date":"2020-08-07 19:13:50","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"264.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":"3113754","reservation_id":"97528","confirmation_number":"SJ12657373231","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.60,245.00,245.00","nightly_discount":"0.00,0.00,0.00","subtotal":"656.60","grand_total":"738.68","paid_amount":"738.68","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89916","customer_id":"89916","source_of_creation":"FE","reservation_created_date":"2020-07-08 12:43:17","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"245.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":"3118873","reservation_id":"96682","confirmation_number":"SJ12622883041","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.29,122.29,164.29,164.29","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"573.16","grand_total":"644.81","paid_amount":"644.81","room_type_id":"319","product_id":"1301","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102798","customer_id":"102798","source_of_creation":"FE","reservation_created_date":"2020-06-17 01:17:49","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"164.29","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3122383","reservation_id":"98302","confirmation_number":"SJ12681986093","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"197.20,197.20,290.00,290.00","nightly_discount":"19.70,19.70,29.00,29.00","subtotal":"974.40","grand_total":"986.63","paid_amount":"986.63","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104343","customer_id":"104343","source_of_creation":"FE","reservation_created_date":"2020-07-29 01:09:49","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3122406","reservation_id":"98301","confirmation_number":"SJ12676034400","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"218.28,218.28,321.00,321.00","nightly_discount":"21.82,21.82,32.10,32.10","subtotal":"1078.56","grand_total":"1092.06","paid_amount":"1092.06","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":"75813","customer_id":"75813","source_of_creation":"FE","reservation_created_date":"2020-07-29 00:33:29","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":"321.00","currentDayDiscount":"32.10","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3123117","reservation_id":"96725","confirmation_number":"SJ12635130409","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.86,171.86,171.86","nightly_discount":"0.00,0.00,0","subtotal":"515.58","grand_total":"580.03","paid_amount":"580.03","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":"87832","customer_id":"87832","source_of_creation":"FE","reservation_created_date":"2020-06-17 19:22:12","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":"171.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3122173","reservation_id":"95864","confirmation_number":"SJ12673446290","room_stay_from":"2020-08-06","room_stay_to":"2020-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.29,164.29,164.29,164.29","nightly_discount":"0.00,0.00,0.00,0","subtotal":"615.16","grand_total":"692.06","paid_amount":"692.06","room_type_id":"413","product_id":"1270","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":"102018","customer_id":"102018","source_of_creation":"FE","reservation_created_date":"2020-06-03 17:52:01","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":"164.29","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3122213","reservation_id":"98118","confirmation_number":"SJ12621025545","room_stay_from":"2020-08-06","room_stay_to":"2020-08-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"208.76,307.00,307.00,164.56,164.56,164.56,164.56","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1481.00","grand_total":"1666.13","paid_amount":"1666.13","room_type_id":"319","product_id":"1306","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":"104188","customer_id":"104188","source_of_creation":"FE","reservation_created_date":"2020-07-24 13:35:54","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"307.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":"3122342","reservation_id":"96787","confirmation_number":"SJ12675103220","room_stay_from":"2020-08-02","room_stay_to":"2020-08-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.28,113.28,113.28,113.28,113.28,113.28,133.34,133.34,133.34,121.22,113.28,113.28,113.28","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1540.76","grand_total":"1733.36","paid_amount":"1733.36","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":"102907","customer_id":"102907","source_of_creation":"FE","reservation_created_date":"2020-06-18 19:48:21","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":"113.28","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":[{"room_stay_id":"3122371","reservation_id":"97321","confirmation_number":"SJ12636451373","room_stay_from":"2020-08-05","room_stay_to":"2020-08-08","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"197.20,197.20,290.00","nightly_discount":"0.00,0.00,0.00","subtotal":"684.40","grand_total":"769.95","paid_amount":"221.85","room_type_id":"319","product_id":"1915","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103405","customer_id":"103405","source_of_creation":"FE","reservation_created_date":"2020-07-02 22:14:08","service_canceled_date_time":"2020-08-07 13:48:29","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"room_dates_changed","total_paid_amount":"221.85","deltaChange":-197.2,"changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3075205","reservation_id":"92668","confirmation_number":"SJ12622276869","room_stay_from":"2020-08-07","room_stay_to":"2020-08-11","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"218.25","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":"98818","customer_id":"98818","source_of_creation":"FE","reservation_created_date":"2020-02-27 17:33:17","service_canceled_date_time":"2020-07-16 20:48:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"218.25","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3123823","reservation_id":"98627","confirmation_number":"SJ12630767011","room_stay_from":"2020-08-05","room_stay_to":"2020-08-08","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"172.20,172.20,290.00","nightly_discount":"0.00,0.00,0.00","subtotal":"634.40","grand_total":"713.70","paid_amount":"713.70","room_type_id":"319","product_id":"1319","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104636","customer_id":"104636","source_of_creation":"PMS","reservation_created_date":"2020-08-05 21:01:21","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":"290.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":"3124398","reservation_id":"98680","confirmation_number":"SJ12670193124","room_stay_from":"2020-08-07","room_stay_to":"2020-08-08","room_stay_status":"Active","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"264.00","nightly_discount":"0.00","subtotal":"264.00","grand_total":"297.00","paid_amount":"297.00","room_type_id":"413","product_id":"1266","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104687","customer_id":"104687","source_of_creation":"PMS","reservation_created_date":"2020-08-07 14:12:14","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"264.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":"3103604","reservation_id":"96212","confirmation_number":"SJ12646842827","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.29,122.29,149.35,149.35","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"543.28","grand_total":"611.19","paid_amount":"611.19","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":"102334","customer_id":"102334","source_of_creation":"PMS","reservation_created_date":"2020-06-10 12:40:04","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":"149.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3106643","reservation_id":"96713","confirmation_number":"SJ12687422248","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"286.58,286.58,286.58,286.58","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1146.32","grand_total":"1289.61","paid_amount":"1289.61","room_type_id":"320","product_id":"1910","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":"102827","customer_id":"102827","source_of_creation":"PMS","reservation_created_date":"2020-06-17 16:49:54","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"286.58","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3115082","reservation_id":"96517","confirmation_number":"SJ12667902120","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.29,149.35,149.35","nightly_discount":"0.00,0.00,0.00","subtotal":"420.99","grand_total":"473.61","paid_amount":"473.61","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":"102622","customer_id":"102622","source_of_creation":"PMS","reservation_created_date":"2020-06-15 00:06:07","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":"149.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117054","reservation_id":"97630","confirmation_number":"SJ12672958884","room_stay_from":"2020-08-07","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"295.00,295.00","nightly_discount":"0.00,0.00","subtotal":"590.00","grand_total":"663.75","paid_amount":"663.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":"103703","customer_id":"103703","source_of_creation":"PMS","reservation_created_date":"2020-07-10 22:51:26","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":"295.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":"3120941","reservation_id":"98102","confirmation_number":"SJ12617737440","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"349.52,349.52,514.00,514.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1727.04","grand_total":"1942.92","paid_amount":"1942.92","room_type_id":"320","product_id":"1329","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104168","customer_id":"104168","source_of_creation":"PMS","reservation_created_date":"2020-07-23 18:56:20","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"514.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":"3123254","reservation_id":"97915","confirmation_number":"SJ12673220645","room_stay_from":"2020-08-04","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.60,141.60,141.60,245.00,245.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"914.80","grand_total":"1029.15","paid_amount":"1029.15","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103987","customer_id":"103987","source_of_creation":"PMS","reservation_created_date":"2020-07-18 18:33:56","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"245.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":"3123857","reservation_id":"98044","confirmation_number":"SJ12669786862","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.40,166.60,166.60,166.60","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"622.20","grand_total":"699.98","paid_amount":"699.98","room_type_id":"319","product_id":"1943","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":"104109","customer_id":"104109","source_of_creation":"PMS","reservation_created_date":"2020-07-22 15:06:54","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"166.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3124177","reservation_id":"98377","confirmation_number":"SJ12695540292","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"7","room_stay_child_count":"0","nightly_price":"329.52,494.00,494.00","nightly_discount":"0.00,0.00,0.00","subtotal":"1317.52","grand_total":"1482.21","paid_amount":"1482.21","room_type_id":"320","product_id":"1324","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":"104408","customer_id":"104408","source_of_creation":"PMS","reservation_created_date":"2020-07-30 19:02:36","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":"","changedComment":"Nightly price or discount changed","deltaChange":"-25.00","currentDayPrice":"494.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":"3100230","reservation_id":"95800","confirmation_number":"SJ12695821317","room_stay_from":"2020-08-06","room_stay_to":"2020-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"4","nightly_price":"311.14,311.14,311.14,311.14","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1244.56","grand_total":"1400.13","paid_amount":"1400.13","room_type_id":"320","product_id":"1328","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":"85808","customer_id":"85808","source_of_creation":"PMS","reservation_created_date":"2020-06-02 14:29:28","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"311.14","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3114170","reservation_id":"97579","confirmation_number":"SJ12627323679","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"290.00,290.00,153.00","nightly_discount":"0.00,0.00,0.00","subtotal":"733.00","grand_total":"824.63","paid_amount":"824.63","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":"103654","customer_id":"103654","source_of_creation":"PMS","reservation_created_date":"2020-07-09 17:24:38","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":"290.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":"3114172","reservation_id":"97579","confirmation_number":"SJ12694008474","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"290.00,290.00,153.00","nightly_discount":"0.00,0.00,0.00","subtotal":"733.00","grand_total":"824.63","paid_amount":"824.63","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":"103654","customer_id":"103654","source_of_creation":"PMS","reservation_created_date":"2020-07-09 17:24:38","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":"290.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":"3114948","reservation_id":"96235","confirmation_number":"SJ12628796768","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"149.35,149.35,149.35","nightly_discount":"0.00,0.00,0.00","subtotal":"448.05","grand_total":"504.05","paid_amount":"504.05","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102357","customer_id":"102357","source_of_creation":"PMS","reservation_created_date":"2020-06-10 18:01:14","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":"149.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3114981","reservation_id":"97579","confirmation_number":"SJ12697747765","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"290.00,290.00,153.00","nightly_discount":"0.00,0.00,0.00","subtotal":"733.00","grand_total":"824.63","paid_amount":"824.63","room_type_id":"319","product_id":"1311","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103654","customer_id":"103654","source_of_creation":"PMS","reservation_created_date":"2020-07-09 17:24:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"290.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":"3114987","reservation_id":"97579","confirmation_number":"SJ12661747012","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"290.00,290.00,153.00","nightly_discount":"0.00,0.00,0.00","subtotal":"733.00","grand_total":"824.63","paid_amount":"824.63","room_type_id":"319","product_id":"1312","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103654","customer_id":"103654","source_of_creation":"PMS","reservation_created_date":"2020-07-09 17:24:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"290.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":"3122211","reservation_id":"96895","confirmation_number":"SJ12654328430","room_stay_from":"2020-08-03","room_stay_to":"2020-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"130.27,130.27,130.27,130.27,153.34,153.34,153.34","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"981.10","grand_total":"1103.74","paid_amount":"1103.74","room_type_id":"319","product_id":"1308","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103017","customer_id":"103017","source_of_creation":"PMS","reservation_created_date":"2020-06-21 13:48:21","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":"153.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3124251","reservation_id":"97118","confirmation_number":"SJ12648875545","room_stay_from":"2020-07-25","room_stay_to":"2020-07-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.00,176.00,176.00,176.00,176.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"880.00","paid_amount":"0.00","room_type_id":"319","product_id":"1301","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-26 17:53:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"880.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3100223","reservation_id":"88606","confirmation_number":"SJ12648085906","room_stay_from":"2020-08-07","room_stay_to":"2020-08-11","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"436.50","room_type_id":"320","product_id":"1330","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":"94798","customer_id":"94798","source_of_creation":"PMS","reservation_created_date":"2019-12-23 17:38:03","service_canceled_date_time":"2020-07-16 20:47:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"436.50","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3100227","reservation_id":"88606","confirmation_number":"SJ12635892282","room_stay_from":"2020-08-07","room_stay_to":"2020-08-11","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"218.25","room_type_id":"319","product_id":"1306","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":"94798","customer_id":"94798","source_of_creation":"PMS","reservation_created_date":"2019-12-23 17:38:03","service_canceled_date_time":"2020-07-16 20:55:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"218.25","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3111730","reservation_id":"89763","confirmation_number":"SJ12654798963","room_stay_from":"2020-08-07","room_stay_to":"2020-08-11","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"218.25","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95776","customer_id":"95776","source_of_creation":"PMS","reservation_created_date":"2020-01-11 18:58:21","service_canceled_date_time":"2020-07-17 13:58:56","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"218.25","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[{"room_stay_id":"3124200","reservation_id":"95815","confirmation_number":"SJ12638681997","room_stay_from":"2020-07-31","room_stay_to":"2020-08-07","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.82,76.82,76.82,76.83,76.83,76.83,76.83","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"537.78","grand_total":"605.00","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":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-06-02 18:17:24","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":"","changedComment":"Nightly price or discount changed","deltaChange":"537.78","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"}]}],"negotiated_non_taxable":[{"room_stay_id":"3115062","reservation_id":"96854","confirmation_number":"SJ12646811242","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","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":"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-06-20 02:24:48","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":"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":"3113421","reservation_id":"97468","confirmation_number":"SJ12657968463","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","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":"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-07-07 00:06:42","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":"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":"3113424","reservation_id":"97469","confirmation_number":"SJ12639829243","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","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":"1287","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-07-07 00:07:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3113430","reservation_id":"97470","confirmation_number":"SJ12679574158","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","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":"1288","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-07-07 00:08:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3122420","reservation_id":"98454","confirmation_number":"SJ12671947764","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","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":"411","product_id":"1296","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-08-01 01:31:33","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3124276","reservation_id":"97668","confirmation_number":"SJ12659704814","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.34","nightly_discount":"0.00,0.00,0.00","subtotal":"235.00","grand_total":"235.00","paid_amount":"84.38","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"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-07-11 20:01:08","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":"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":"3107135","reservation_id":"96764","confirmation_number":"SJ12673273791","room_stay_from":"2020-08-07","room_stay_to":"2020-08-14","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-06-18 15:19:35","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":"3123252","reservation_id":"95480","confirmation_number":"SJ12694405220","room_stay_from":"2020-08-07","room_stay_to":"2020-08-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-27 16:05:55","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3124399","reservation_id":"98680","confirmation_number":"SJ12619368359","room_confirmation_number":"SJ12670193124","room_stay_from":"2020-08-07","room_stay_to":"2020-08-08","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"104687","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-08-07 19:36:01","reservation_modified_date_time":"2020-08-07 19:36:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104687","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3123866","reservation_id":"98390","confirmation_number":"SJ12648762886","room_confirmation_number":"SJ12633062975","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"104656","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-08-06 00:29:26","reservation_modified_date_time":"2020-08-06 00:29:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104414","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","currentDayPrice":"50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3124181","reservation_id":"98377","confirmation_number":"SJ12613899766","room_confirmation_number":"SJ12695540292","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","room_stay_status":"Active","nightly_price":"75,75,75","nightly_discount":"0.00,0.00,0.00","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"104408","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-08-07 11:35:46","reservation_modified_date_time":"2020-08-07 11:35:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104408","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"Reservation created with partial past date","deltaChange":"75.00","currentDayPrice":"75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3114949","reservation_id":"96235","confirmation_number":"SJ12651425451","room_confirmation_number":"SJ12628796768","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"102357","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-07-11 19:42:09","reservation_modified_date_time":"2020-07-11 19:42:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102357","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3095228","reservation_id":"95064","confirmation_number":"SJ12668537449","room_confirmation_number":"SJ12610097089","room_stay_from":"2020-08-03","room_stay_to":"2020-08-08","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":"101248","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 20:22:09","reservation_modified_date_time":"2020-05-19 20:22:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101248","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":"3122950","reservation_id":"98196","confirmation_number":"SJ12668457948","room_confirmation_number":"SJ12653037816","room_stay_from":"2020-08-06","room_stay_to":"2020-08-08","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":"104257","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-26 01:36:28","reservation_modified_date_time":"2020-08-02 20:58:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104257","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":"3123060","reservation_id":"97519","confirmation_number":"SJ12680320343","room_confirmation_number":"SJ12612819897","room_stay_from":"2020-08-02","room_stay_to":"2020-08-08","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":"102907","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-07 22:39:08","reservation_modified_date_time":"2020-08-03 01:05:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102907","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":"3123824","reservation_id":"98627","confirmation_number":"SJ12622765509","room_confirmation_number":"SJ12630767011","room_stay_from":"2020-08-05","room_stay_to":"2020-08-08","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":"104636","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-05 21:01:21","reservation_modified_date_time":"2020-08-05 21:01:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104636","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":"3123910","reservation_id":"98544","confirmation_number":"SJ12632131279","room_confirmation_number":"SJ12610329132","room_stay_from":"2020-08-07","room_stay_to":"2020-08-08","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":"104561","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-03 16:16:42","reservation_modified_date_time":"2020-08-06 12:49:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104561","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":"3123986","reservation_id":"98071","confirmation_number":"SJ12620972318","room_confirmation_number":"SJ12631862381","room_stay_from":"2020-08-06","room_stay_to":"2020-08-08","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":"104651","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-23 01:05:13","reservation_modified_date_time":"2020-08-06 16:54:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104140","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":"3124382","reservation_id":"98701","confirmation_number":"SJ12666759805","room_confirmation_number":"SJ12673987670","room_stay_from":"2020-08-07","room_stay_to":"2020-08-08","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.12","paid_amount":"28.12","product_id":"1776","service_quantity":"1","customer_traveller_id":"82630","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-07 19:13:50","reservation_modified_date_time":"2020-08-07 19:13:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82630","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":"3124400","reservation_id":"98680","confirmation_number":"SJ12699950843","room_confirmation_number":"SJ12670193124","room_stay_from":"2020-08-07","room_stay_to":"2020-08-08","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":"104687","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-07 14:12:14","reservation_modified_date_time":"2020-08-07 19:36:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104687","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":"3103605","reservation_id":"96212","confirmation_number":"SJ12641402250","room_confirmation_number":"SJ12646842827","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"102334","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-10 12:40:04","reservation_modified_date_time":"2020-06-10 12:40:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102334","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":"3106644","reservation_id":"96713","confirmation_number":"SJ12664900531","room_confirmation_number":"SJ12687422248","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"102827","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-17 16:49:54","reservation_modified_date_time":"2020-06-17 16:49:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102827","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":"3113755","reservation_id":"97528","confirmation_number":"SJ12636377728","room_confirmation_number":"SJ12657373231","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","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":"89916","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-08 12:43:17","reservation_modified_date_time":"2020-07-08 12:43:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89916","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":"3115063","reservation_id":"96854","confirmation_number":"SJ12618915973","room_confirmation_number":"SJ12646811242","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","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":"102983","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-20 02:24:48","reservation_modified_date_time":"2020-07-11 21:32: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":"3115083","reservation_id":"96517","confirmation_number":"SJ12665495046","room_confirmation_number":"SJ12667902120","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","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":"102622","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 00:06:07","reservation_modified_date_time":"2020-07-11 21:38:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102622","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":"3117055","reservation_id":"97630","confirmation_number":"SJ12684952657","room_confirmation_number":"SJ12672958884","room_stay_from":"2020-08-07","room_stay_to":"2020-08-09","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":"103703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-10 22:51:26","reservation_modified_date_time":"2020-07-17 19:36:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103703","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":"3118874","reservation_id":"96682","confirmation_number":"SJ12626044277","room_confirmation_number":"SJ12622883041","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"102798","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-17 01:17:49","reservation_modified_date_time":"2020-07-22 18:46:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102798","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":"3120944","reservation_id":"98102","confirmation_number":"SJ12648224084","room_confirmation_number":"SJ12617737440","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"104168","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-23 18:56:20","reservation_modified_date_time":"2020-07-28 13:06:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104168","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":"3121668","reservation_id":"98359","confirmation_number":"SJ12695369621","room_confirmation_number":"SJ12661912413","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","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":"104654","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-30 15:10:12","reservation_modified_date_time":"2020-07-30 15:10:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104396","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":"3122074","reservation_id":"96031","confirmation_number":"SJ12627934716","room_confirmation_number":"SJ12662652194","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","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":"102163","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-07 03:55:09","reservation_modified_date_time":"2020-07-31 17:17:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102163","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":"3122384","reservation_id":"98302","confirmation_number":"SJ12696717874","room_confirmation_number":"SJ12681986093","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"104343","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-29 01:09:49","reservation_modified_date_time":"2020-08-01 00:27:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104343","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":"3122407","reservation_id":"98301","confirmation_number":"SJ12619550442","room_confirmation_number":"SJ12676034400","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"75813","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-29 00:33:29","reservation_modified_date_time":"2020-08-01 00:53:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75813","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":"3122956","reservation_id":"98082","confirmation_number":"SJ12615362788","room_confirmation_number":"SJ12656578873","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","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":"104149","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-23 14:49:12","reservation_modified_date_time":"2020-08-02 21:00:01","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104149","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":"3123119","reservation_id":"96725","confirmation_number":"SJ12627856132","room_confirmation_number":"SJ12635130409","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","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":"87832","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-17 19:22:12","reservation_modified_date_time":"2020-08-03 14:28:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87832","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":"3123255","reservation_id":"97915","confirmation_number":"SJ12632743307","room_confirmation_number":"SJ12673220645","room_stay_from":"2020-08-04","room_stay_to":"2020-08-09","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":"103987","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-18 18:33:56","reservation_modified_date_time":"2020-08-03 20:38:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103987","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":"3123858","reservation_id":"98044","confirmation_number":"SJ12615981853","room_confirmation_number":"SJ12669786862","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"104109","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-22 15:06:54","reservation_modified_date_time":"2020-08-06 00:22:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104109","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":"3123867","reservation_id":"98390","confirmation_number":"SJ12698933265","room_confirmation_number":"SJ12633062975","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"104656","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-30 21:50:25","reservation_modified_date_time":"2020-08-06 00:29:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104414","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3123892","reservation_id":"97552","confirmation_number":"SJ12625257892","room_confirmation_number":"SJ12614110206","room_stay_from":"2020-08-07","room_stay_to":"2020-08-09","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":"103626","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-08 21:14:12","reservation_modified_date_time":"2020-08-06 01:55:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103626","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":"3123895","reservation_id":"96104","confirmation_number":"SJ12631904807","room_confirmation_number":"SJ12621908645","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"102227","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-08 16:34:09","reservation_modified_date_time":"2020-08-06 01:55:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102227","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":"3124180","reservation_id":"98377","confirmation_number":"SJ12653161391","room_confirmation_number":"SJ12695540292","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","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":"104408","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-30 19:02:36","reservation_modified_date_time":"2020-08-07 12:34:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104408","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":"3124410","reservation_id":"98698","confirmation_number":"SJ12651066112","room_confirmation_number":"SJ12622754751","room_stay_from":"2020-08-07","room_stay_to":"2020-08-09","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":"104703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-07 18:32:19","reservation_modified_date_time":"2020-08-07 19:39:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104703","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":"3100233","reservation_id":"95800","confirmation_number":"SJ12698610885","room_confirmation_number":"SJ12695821317","room_stay_from":"2020-08-06","room_stay_to":"2020-08-10","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":"85808","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-02 14:29:28","reservation_modified_date_time":"2020-06-02 14:32:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85808","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":"3113422","reservation_id":"97468","confirmation_number":"SJ12696315630","room_confirmation_number":"SJ12657968463","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","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":"104700","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-07 00:06:42","reservation_modified_date_time":"2020-07-07 00:06:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3113425","reservation_id":"97469","confirmation_number":"SJ12612739215","room_confirmation_number":"SJ12639829243","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","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":"104700","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-07 00:07:28","reservation_modified_date_time":"2020-07-07 00:07:28","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":"3113431","reservation_id":"97470","confirmation_number":"SJ12660822153","room_confirmation_number":"SJ12679574158","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","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":"104700","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-07 00:08:07","reservation_modified_date_time":"2020-07-07 00:08: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":"3114171","reservation_id":"97579","confirmation_number":"SJ12630611841","room_confirmation_number":"SJ12627323679","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","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":"103654","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-09 17:24:38","reservation_modified_date_time":"2020-07-09 17:24:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103654","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":"3114173","reservation_id":"97579","confirmation_number":"SJ12615218958","room_confirmation_number":"SJ12694008474","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","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":"103654","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-09 17:24:38","reservation_modified_date_time":"2020-07-09 17:24:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103654","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":"3114950","reservation_id":"96235","confirmation_number":"SJ12677468812","room_confirmation_number":"SJ12628796768","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","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":"102357","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-10 18:01:14","reservation_modified_date_time":"2020-07-11 19:42:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102357","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":"3114983","reservation_id":"97579","confirmation_number":"SJ12670197878","room_confirmation_number":"SJ12697747765","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","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":"103654","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-09 17:24:38","reservation_modified_date_time":"2020-07-11 19:49:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103654","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":"3114988","reservation_id":"97579","confirmation_number":"SJ12647197575","room_confirmation_number":"SJ12661747012","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","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":"103654","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-09 17:24:38","reservation_modified_date_time":"2020-07-11 19:49:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103654","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":"3115077","reservation_id":"96028","confirmation_number":"SJ12684369401","room_confirmation_number":"SJ12614821200","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","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":"102159","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-07 00:01:08","reservation_modified_date_time":"2020-07-11 21:37:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102159","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":"3122175","reservation_id":"95864","confirmation_number":"SJ12678693341","room_confirmation_number":"SJ12673446290","room_stay_from":"2020-08-06","room_stay_to":"2020-08-10","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":"102018","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-03 17:52:01","reservation_modified_date_time":"2020-07-31 21:40:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102018","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":"3122212","reservation_id":"96895","confirmation_number":"SJ12682877626","room_confirmation_number":"SJ12654328430","room_stay_from":"2020-08-03","room_stay_to":"2020-08-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"103017","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-21 13:48:21","reservation_modified_date_time":"2020-07-31 22:09:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103017","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":"3122421","reservation_id":"98454","confirmation_number":"SJ12612268793","room_confirmation_number":"SJ12671947764","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","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":"104474","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-01 01:31:33","reservation_modified_date_time":"2020-08-01 01:31:33","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3124277","reservation_id":"97668","confirmation_number":"SJ12697318822","room_confirmation_number":"SJ12659704814","room_stay_from":"2020-08-07","room_stay_to":"2020-08-10","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":"103745","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-11 20:01:08","reservation_modified_date_time":"2020-08-07 16:29:26","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":"3122214","reservation_id":"98118","confirmation_number":"SJ12635898552","room_confirmation_number":"SJ12621025545","room_stay_from":"2020-08-06","room_stay_to":"2020-08-13","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"104188","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-24 13:35:54","reservation_modified_date_time":"2020-07-31 22:10:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104188","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":"3107136","reservation_id":"96764","confirmation_number":"SJ12690458485","room_confirmation_number":"SJ12673273791","room_stay_from":"2020-08-07","room_stay_to":"2020-08-14","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":"102880","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 15:19:35","reservation_modified_date_time":"2020-06-18 15:19:35","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":"3123253","reservation_id":"95480","confirmation_number":"SJ12650353893","room_confirmation_number":"SJ12694405220","room_stay_from":"2020-08-07","room_stay_to":"2020-08-14","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":"101672","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 16:05:55","reservation_modified_date_time":"2020-08-03 20:37:53","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":"3122343","reservation_id":"96787","confirmation_number":"SJ12640729762","room_confirmation_number":"SJ12675103220","room_stay_from":"2020-08-02","room_stay_to":"2020-08-15","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"325.00","grand_total":"365.63","paid_amount":"365.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"102907","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 19:48:21","reservation_modified_date_time":"2020-07-31 23:09:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102907","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":"3122372","reservation_id":"97321","confirmation_number":"SJ12621991815","room_confirmation_number":"SJ12636451373","room_stay_from":"2020-08-05","room_stay_to":"2020-08-08","room_stay_status":"Canceled","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","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-02 22:14:08","reservation_modified_date_time":"2020-08-01 00:19:51","customer_id":"103405","parentCustTravId":"103405","customer_traveller_id":"103405","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-08-07 13:48:29","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"}]},{"room_stay_id":"3122820","reservation_id":"95382","confirmation_number":"SJ12615023273","room_confirmation_number":"SJ12650481444","room_stay_from":"2020-08-03","room_stay_to":"2020-08-09","room_stay_status":"Canceled","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-25 16:53:07","reservation_modified_date_time":"2020-08-02 15:42:12","customer_id":"101573","parentCustTravId":"101573","customer_traveller_id":"101573","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-08-07 13:37:11","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","deltaChange":-100,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3123699","reservation_id":"98618","confirmation_number":"SJ12679292054","room_confirmation_number":"SJ12668340584","room_stay_from":"2020-08-06","room_stay_to":"2020-08-07","room_stay_status":"Canceled","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-05 17:55:07","reservation_modified_date_time":"2020-08-05 17:55:07","customer_id":"104628","parentCustTravId":"104628","customer_traveller_id":"104628","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-08-07 11:17:08","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3124230","reservation_id":"98682","confirmation_number":"SJ12659408654","room_confirmation_number":"SJ12625349496","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":"30.00","paid_amount":"30.00","product_id":null,"service_quantity":"2","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-07 14:22:35","reservation_modified_date_time":"2020-08-07 14:22:35","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.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3124290","reservation_id":"98695","confirmation_number":"SJ12667596315","room_confirmation_number":"SJ12646041126","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":"15.00","paid_amount":"15.00","product_id":null,"service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-07 17:19:12","reservation_modified_date_time":"2020-08-07 17:19:12","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":"13.95","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":"3124617","reservation_id":"98730","confirmation_number":"SJ12694804914","room_confirmation_number":"SJ12618984625","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-08-08 02:43:36","reservation_modified_date_time":"2020-08-08 02:43:36","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":[]}}