{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-07-03","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":7,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1264,1307,1943,1305","block_room_bookings":[{"confirmation_number":"SJ12637517785","room_stay_from":"2020-07-03","room_stay_to":"2020-07-08","bundle_room":"0"},{"confirmation_number":"SJ12664166752","room_stay_from":"2020-06-07","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-04","room_stay_to":"2020-09-01","bundle_room":"0"},{"confirmation_number":"SJ12612307368","room_stay_from":"2020-06-29","room_stay_to":"2020-09-01","bundle_room":"0"}],"bundle_block_count":"1260,1261,1309,1310,1302,1303,1269,1270,1271,1272,1311,1312,1262,1263,1267,1268,1291,1711,1304,1305,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12698663177","room_stay_from":"2020-07-03","room_stay_to":"2020-07-04","bundle_room":"1"},{"confirmation_number":"SJB12691464218","room_stay_from":"2020-06-29","room_stay_to":"2020-07-04","bundle_room":"1"},{"confirmation_number":"SJB12617835322","room_stay_from":"2020-07-03","room_stay_to":"2020-07-04","bundle_room":"1"},{"confirmation_number":"SJB12644339714","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","bundle_room":"1"},{"confirmation_number":"SJB12655915245","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","bundle_room":"1"},{"confirmation_number":"SJB12660798417","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","bundle_room":"1"},{"confirmation_number":"SJB12662269070","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","bundle_room":"1"},{"confirmation_number":"SJB12657141702","room_stay_from":"2020-07-01","room_stay_to":"2020-07-06","bundle_room":"1"},{"confirmation_number":"SJB12642303387","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","bundle_room":"1"},{"confirmation_number":"SJB12616638718","room_stay_from":"2020-06-29","room_stay_to":"2020-07-13","bundle_room":"1"},{"confirmation_number":"SJB12647698945","room_stay_from":"2020-06-29","room_stay_to":"2020-07-28","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3102243","reservation_id":"95666","confirmation_number":"SJ12673501277","room_stay_from":"2020-06-25","room_stay_to":"2020-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.40,173.60,173.60,150.40,150.40,150.40,169.60,195.20,336.80","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"1650.40","grand_total":"1856.70","paid_amount":"1856.70","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-2977837625","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101845","customer_id":"101845","source_of_creation":"Booking.com","reservation_created_date":"2020-05-30 21:26:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"67.51","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"336.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3083253","reservation_id":"93480","confirmation_number":"SJ12643889829","room_stay_from":"2020-07-01","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"199,179,259,259","nightly_discount":"0,0,0,0","subtotal":"896.00","grand_total":"1008.00","paid_amount":"1008.00","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-2985554637","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99706","customer_id":"99706","source_of_creation":"Booking.com","reservation_created_date":"2020-03-18 02:22:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"197.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"259","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":"3110696","reservation_id":"97196","confirmation_number":"SJ12635438453","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"358.40,358.40","nightly_discount":"0,0","subtotal":"716.80","grand_total":"806.40","paid_amount":"806.40","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3759789891","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":"103297","customer_id":"103297","source_of_creation":"Booking.com","reservation_created_date":"2020-06-28 20:02:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"138.02","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"358.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3111089","reservation_id":"97050","confirmation_number":"SJ12693051696","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"320.80,307.20","nightly_discount":"0,0","subtotal":"628.00","grand_total":"706.50","paid_amount":"706.50","room_type_id":"319","product_id":"1311","siteminder_id":"BDC-2526995150","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":"103170","customer_id":"103170","source_of_creation":"Booking.com","reservation_created_date":"2020-06-25 00:06:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"122.04","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"320.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3111158","reservation_id":"97079","confirmation_number":"SJ12699145726","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"320.80,320.80,320.80","nightly_discount":"0,0,0","subtotal":"962.40","grand_total":"1082.70","paid_amount":"1082.70","room_type_id":"319","product_id":"1304","siteminder_id":"BDC-3308784239","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":"103200","customer_id":"103200","source_of_creation":"Booking.com","reservation_created_date":"2020-06-25 22:00:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"186.73","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"320.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3111163","reservation_id":"97205","confirmation_number":"SJ12614842282","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"358.40,358.40","nightly_discount":"0,0","subtotal":"716.80","grand_total":"806.40","paid_amount":"806.40","room_type_id":"319","product_id":"1312","siteminder_id":"BDC-2344145997","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":"103307","customer_id":"103307","source_of_creation":"Booking.com","reservation_created_date":"2020-06-29 00:33:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"138.02","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"358.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3111692","reservation_id":"97098","confirmation_number":"SJ12684370690","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"340.80,340.80,340.80","nightly_discount":"0.00,0.00,0.00","subtotal":"1022.40","grand_total":"1150.20","paid_amount":"1150.20","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-3975647963","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":"103218","customer_id":"103218","source_of_creation":"Booking.com","reservation_created_date":"2020-06-26 02:55:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"98.77","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"340.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":"3111823","reservation_id":"95925","confirmation_number":"SJ12670257455","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"195.20,336.80,336.80","nightly_discount":"0,0,0","subtotal":"868.80","grand_total":"977.40","paid_amount":"977.40","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2789570535","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":"102069","customer_id":"102069","source_of_creation":"Booking.com","reservation_created_date":"2020-06-05 00:58:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"169.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"336.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3112213","reservation_id":"97339","confirmation_number":"SJ12646909661","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"320.80,320.80","nightly_discount":"0,0","subtotal":"641.60","grand_total":"721.80","paid_amount":"721.80","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-3821410290","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":"103424","customer_id":"103424","source_of_creation":"Booking.com","reservation_created_date":"2020-07-03 15:20:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"62.24","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"320.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103075","reservation_id":"96016","confirmation_number":"SJ12670455624","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"312.4,312.4,153.2","nightly_discount":"0,0,0","subtotal":"778.00","grand_total":"875.25","paid_amount":"875.25","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3861001962","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102149","customer_id":"102149","source_of_creation":"Booking.com","reservation_created_date":"2020-06-06 21:59:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"180.54","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"312.4","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3111414","reservation_id":"97249","confirmation_number":"SJ12630744264","room_stay_from":"2020-07-02","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"320.80,320.80,268.80,268.80","nightly_discount":"0,0,0,0","subtotal":"1179.20","grand_total":"1326.60","paid_amount":"1326.60","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-3716259504","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":"103348","customer_id":"103348","source_of_creation":"Booking.com","reservation_created_date":"2020-06-30 18:45:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"177.37","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"320.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3111196","reservation_id":"95309","confirmation_number":"SJ12615497878","room_stay_from":"2020-07-03","room_stay_to":"2020-07-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"297.60,297.60,297.60,270.40,237.60,237.60,237.60","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1876.00","grand_total":"2110.50","paid_amount":"2110.50","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-3069669247","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":"101497","customer_id":"101497","source_of_creation":"Booking.com","reservation_created_date":"2020-05-23 23:26:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"369.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"297.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[{"room_stay_id":"3111234","reservation_id":"95249","confirmation_number":"SJ12685533675","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.40,230.40,230.40","nightly_discount":"0,0,0","subtotal":"691.20","grand_total":"777.60","paid_amount":"259.20","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-3069600588","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":"101433","customer_id":"101433","source_of_creation":"Booking.com","reservation_created_date":"2020-05-22 19:36:09","service_canceled_date_time":"2020-06-30 22:22:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"137.91","deltaChange":"259.20","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3095499","reservation_id":"95126","confirmation_number":"SJ12627321751","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"139.20,139.20","nightly_discount":"0,0","subtotal":"278.40","grand_total":"313.20","paid_amount":"313.20","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1665007581","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":"101310","customer_id":"101310","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 15:56:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.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":"3108036","reservation_id":"94933","confirmation_number":"SJ12665223625","room_stay_from":"2020-07-01","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.20,103.20,119.20,119.20","nightly_discount":"0,0,0,0","subtotal":"444.80","grand_total":"500.40","paid_amount":"500.40","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1664579921","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":"101125","customer_id":"101125","source_of_creation":"Expedia","reservation_created_date":"2020-05-18 02:12:10","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":"119.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110857","reservation_id":"95079","confirmation_number":"SJ12682756926","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.56,95.36,95.36","nightly_discount":"0,0,0","subtotal":"273.28","grand_total":"307.44","paid_amount":"307.44","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1664900801","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":"101262","customer_id":"101262","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 23:21:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.36","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3111832","reservation_id":"97300","confirmation_number":"SJ12675601843","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"335.8,335.8","nightly_discount":"0,0","subtotal":"671.60","grand_total":"755.55","paid_amount":"755.55","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1675913578","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":"103388","customer_id":"103388","source_of_creation":"Expedia","reservation_created_date":"2020-07-02 15:49:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"335.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":"3111844","reservation_id":"97302","confirmation_number":"SJ12678380545","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"1265","siteminder_id":"EXP-1675916393","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":"103389","customer_id":"103389","source_of_creation":"Expedia","reservation_created_date":"2020-07-02 15:59:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3112237","reservation_id":"95123","confirmation_number":"SJ12675573985","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"139.20,139.20","nightly_discount":"0,0","subtotal":"278.40","grand_total":"313.20","paid_amount":"313.20","room_type_id":"319","product_id":"1308","siteminder_id":"EXP-1665004138","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":"101307","customer_id":"101307","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 15:32:08","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":"139.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":"3112288","reservation_id":"95125","confirmation_number":"SJ12686545684","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"139.20,139.20","nightly_discount":"0,0","subtotal":"278.40","grand_total":"313.20","paid_amount":"313.20","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1665007446","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":"101309","customer_id":"101309","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 15:52:10","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":"139.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":"3093080","reservation_id":"94698","confirmation_number":"SJ12668445244","room_stay_from":"2020-07-01","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"151.20,151.20,215.20,215.20,151.20","nightly_discount":"0,0,0,0,0","subtotal":"884.00","grand_total":"994.50","paid_amount":"994.50","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1663752372","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":"100898","customer_id":"100898","source_of_creation":"Expedia","reservation_created_date":"2020-05-12 13:31:13","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":"215.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":"3108034","reservation_id":"94697","confirmation_number":"SJ12644261210","room_stay_from":"2020-07-01","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"151.20,151.20,215.20,215.20,151.20","nightly_discount":"0,0,0,0,0","subtotal":"884.00","grand_total":"994.50","paid_amount":"994.50","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1663752600","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":"100897","customer_id":"100897","source_of_creation":"Expedia","reservation_created_date":"2020-05-12 13:31:08","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":"215.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":"3109917","reservation_id":"97102","confirmation_number":"SJ12624140200","room_stay_from":"2020-07-03","room_stay_to":"2020-07-07","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"285.2,285.2,233.2,233.2","nightly_discount":"0,0,0,0","subtotal":"1036.80","grand_total":"1166.40","paid_amount":"1166.40","room_type_id":"319","product_id":"1319","siteminder_id":"EXP-1674092968","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103222","customer_id":"103222","source_of_creation":"Expedia","reservation_created_date":"2020-06-26 12:52:04","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":"285.2","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"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":"3109113","reservation_id":"96615","confirmation_number":"SJ12675334618","room_stay_from":"2020-07-03","room_stay_to":"2020-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"430.05","nightly_discount":"0.00","subtotal":"430.05","grand_total":"483.80","paid_amount":"483.80","room_type_id":"319","product_id":"1917","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102728","customer_id":"102728","source_of_creation":"FE","reservation_created_date":"2020-06-16 14:21:33","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":"430.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":"3111076","reservation_id":"96617","confirmation_number":"SJ12615778515","room_stay_from":"2020-07-03","room_stay_to":"2020-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"342.18","nightly_discount":"0.00","subtotal":"342.18","grand_total":"384.95","paid_amount":"384.95","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":"102729","customer_id":"102729","source_of_creation":"FE","reservation_created_date":"2020-06-16 14:24:52","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":"342.18","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3111745","reservation_id":"97289","confirmation_number":"SJ12671479455","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"314.00,314.00","nightly_discount":"0.00,0.00","subtotal":"628.00","grand_total":"706.50","paid_amount":"706.50","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":"103381","customer_id":"103381","source_of_creation":"FE","reservation_created_date":"2020-07-02 01:24:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"314.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3111951","reservation_id":"97317","confirmation_number":"SJ12662534602","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"349.00,349.00","nightly_discount":"0.00,0.00","subtotal":"698.00","grand_total":"785.25","paid_amount":"785.25","room_type_id":"411","product_id":"1296","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103398","customer_id":"103398","source_of_creation":"FE","reservation_created_date":"2020-07-02 20:13:07","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":"349.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":"3111084","reservation_id":"96458","confirmation_number":"SJ12689515637","room_stay_from":"2020-07-03","room_stay_to":"2020-07-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"411.07,411.07,274.97,240.91,190.45,190.45","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1718.92","grand_total":"1933.79","paid_amount":"1933.79","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":"102567","customer_id":"102567","source_of_creation":"FE","reservation_created_date":"2020-06-13 22:34:59","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":"411.07","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3111254","reservation_id":"97255","confirmation_number":"SJ12643263177","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"314.00,314.00","nightly_discount":"0.00,0.00","subtotal":"628.00","grand_total":"706.50","paid_amount":"706.50","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":"103355","customer_id":"103355","source_of_creation":"PMS","reservation_created_date":"2020-06-30 23:31:58","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":"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":"3111358","reservation_id":"97048","confirmation_number":"SJ12653334111","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"314.00,314.00","nightly_discount":"31.40,31.40","subtotal":"628.00","grand_total":"635.85","paid_amount":"635.85","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":"103168","customer_id":"103168","source_of_creation":"PMS","reservation_created_date":"2020-06-24 21:45:06","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":"314.00","currentDayDiscount":"31.40","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3111677","reservation_id":"97288","confirmation_number":"SJ12665815266","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"278.75,278.75,278.75","nightly_discount":"0.00,0.00,0.00","subtotal":"836.25","grand_total":"940.78","paid_amount":"940.78","room_type_id":"318","product_id":"1289","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103379","customer_id":"103379","source_of_creation":"PMS","reservation_created_date":"2020-07-02 00:12:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"278.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":"3112235","reservation_id":"97226","confirmation_number":"SJ12647154240","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"301.00,301.00","nightly_discount":"0.00,0.00","subtotal":"602.00","grand_total":"677.25","paid_amount":"677.25","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":"103328","customer_id":"103328","source_of_creation":"PMS","reservation_created_date":"2020-06-29 19:47:04","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":"301.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":"3112286","reservation_id":"97255","confirmation_number":"SJ12650790614","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"314.00,314.00","nightly_discount":"0.00,0.00","subtotal":"628.00","grand_total":"706.50","paid_amount":"706.50","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":"103355","customer_id":"103355","source_of_creation":"PMS","reservation_created_date":"2020-06-30 23:31:58","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":"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":"3111804","reservation_id":"97018","confirmation_number":"SJ12626792344","room_stay_from":"2020-07-02","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.15,344.60,344.60,189.05","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1076.40","grand_total":"1210.95","paid_amount":"1210.95","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":"103194","customer_id":"103194","source_of_creation":"PMS","reservation_created_date":"2020-06-24 00:24:18","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":"344.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":"3112291","reservation_id":"95861","confirmation_number":"SJ12689745534","room_stay_from":"2020-07-01","room_stay_to":"2020-07-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.74,175.65,262.59,262.59,175.65,175.65,138.85","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1343.72","grand_total":"1511.69","paid_amount":"1511.69","room_type_id":"413","product_id":"1263","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102017","customer_id":"102017","source_of_creation":"PMS","reservation_created_date":"2020-06-03 17:20:31","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"262.59","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3112294","reservation_id":"96447","confirmation_number":"SJ12629074751","room_stay_from":"2020-07-03","room_stay_to":"2020-07-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"303.30,303.30,202.88,202.88,160.38,160.38,160.38,160.38,160.38,139.46,139.46,139.46,139.46,139.46","nightly_discount":"30.33,30.33,20.28,20.28,16.03,16.03,16.03,16.03,16.03,13.94,13.94,13.94,0,0","subtotal":"2511.56","grand_total":"2574.42","paid_amount":"2574.42","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":"102558","customer_id":"102558","source_of_creation":"PMS","reservation_created_date":"2020-06-13 20:39:15","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"303.30","currentDayDiscount":"30.33","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3112164","reservation_id":"96038","confirmation_number":"SJ12629265738","room_stay_from":"2020-07-20","room_stay_to":"2020-07-23","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"178.50,178.50,178.50","nightly_discount":"0.00,0.00,0.00","subtotal":"535.50","grand_total":"602.44","paid_amount":"0.00","room_type_id":"319","product_id":"1916","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":"99511","customer_id":"99511","source_of_creation":"PMS","reservation_created_date":"2020-06-07 14:34:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"-151.20","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3109070","reservation_id":"96547","confirmation_number":"SJ12681847899","room_stay_from":"2020-06-28","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.58,103.57,103.57,103.57,103.57,103.57,103.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"725.00","grand_total":"725.00","paid_amount":"0.00","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-15 15:34:58","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":"103.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[{"room_stay_id":"3111328","reservation_id":"95407","confirmation_number":"SJ12682763247","room_stay_from":"2020-07-01","room_stay_to":"2020-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00,95.00,95.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"475.00","grand_total":"534.38","paid_amount":"140.63","room_type_id":"319","product_id":"1291","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-05-26 13:51:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[{"room_stay_id":"3102479","reservation_id":"95424","confirmation_number":"SJ12682602763","room_stay_from":"2020-06-27","room_stay_to":"2020-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-26 16:23:40","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3102484","reservation_id":"95425","confirmation_number":"SJ12665917896","room_stay_from":"2020-06-27","room_stay_to":"2020-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-26 16:25:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107807","reservation_id":"96844","confirmation_number":"SJ12677431559","room_stay_from":"2020-07-01","room_stay_to":"2020-07-04","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":"1302","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 01:42:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3110841","reservation_id":"96317","confirmation_number":"SJ12649529156","room_stay_from":"2020-06-29","room_stay_to":"2020-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.00","paid_amount":"140.63","room_type_id":"319","product_id":"1309","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-12 02:05:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110845","reservation_id":"96318","confirmation_number":"SJ12617533143","room_stay_from":"2020-06-29","room_stay_to":"2020-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.00","paid_amount":"140.63","room_type_id":"319","product_id":"1310","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-12 02:12:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3106329","reservation_id":"96660","confirmation_number":"SJ12621284119","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 22:19:35","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":"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":"3110854","reservation_id":"96779","confirmation_number":"SJ12617605836","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"413","product_id":"1272","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 16:56:33","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3111193","reservation_id":"96843","confirmation_number":"SJ12675320412","room_stay_from":"2020-06-30","room_stay_to":"2020-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.00","paid_amount":"140.63","room_type_id":"319","product_id":"1303","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 01:40:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3102481","reservation_id":"95468","confirmation_number":"SJ12622106885","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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":"413","product_id":"1270","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 14:39:28","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":"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":"3106325","reservation_id":"95467","confirmation_number":"SJ12687341443","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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-05-27 14:37:42","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":"3106331","reservation_id":"96661","confirmation_number":"SJ12657170184","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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-16 22:21:32","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":"3106340","reservation_id":"96663","confirmation_number":"SJ12636567735","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 22:24:34","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":"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":"3111326","reservation_id":"96662","confirmation_number":"SJ12639210405","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"0.00","room_type_id":"412","product_id":"1294","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 22:22:56","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":"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":"3105960","reservation_id":"96578","confirmation_number":"SJ12675266876","room_stay_from":"2020-07-03","room_stay_to":"2020-07-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 00:38:49","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":"3111077","reservation_id":"96617","confirmation_number":"SJ12691271984","room_confirmation_number":"SJ12615778515","room_stay_from":"2020-07-03","room_stay_to":"2020-07-04","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"102729","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-06-29 23:19:21","reservation_modified_date_time":"2020-06-29 23:19:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102729","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3083254","reservation_id":"93480","confirmation_number":"SJ12668923833","room_confirmation_number":"SJ12643889829","room_stay_from":"2020-07-01","room_stay_to":"2020-07-05","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"99706","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-03-18 02:22:08","reservation_modified_date_time":"2020-03-18 02:22:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99706","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"3111833","reservation_id":"97300","confirmation_number":"SJ12628003989","room_confirmation_number":"SJ12675601843","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"103388","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-07-02 15:49:07","reservation_modified_date_time":"2020-07-02 15:49:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103388","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3103077","reservation_id":"96016","confirmation_number":"SJ12692297765","room_confirmation_number":"SJ12670455624","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"102149","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-06-08 22:32:04","reservation_modified_date_time":"2020-06-08 22:32:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102149","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109918","reservation_id":"97102","confirmation_number":"SJ12673984927","room_confirmation_number":"SJ12624140200","room_stay_from":"2020-07-03","room_stay_to":"2020-07-07","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"103222","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-06-26 12:52:04","reservation_modified_date_time":"2020-06-26 12:52:04","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103222","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3102242","reservation_id":"95666","confirmation_number":"SJ12674848047","room_confirmation_number":"SJ12673501277","room_stay_from":"2020-06-25","room_stay_to":"2020-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"101845","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-30 21:26:12","reservation_modified_date_time":"2020-06-06 22:14:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101845","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3102480","reservation_id":"95424","confirmation_number":"SJ12627581383","room_confirmation_number":"SJ12682602763","room_stay_from":"2020-06-27","room_stay_to":"2020-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98577","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 16:23:40","reservation_modified_date_time":"2020-06-07 14:38:21","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3102485","reservation_id":"95425","confirmation_number":"SJ12637822636","room_confirmation_number":"SJ12665917896","room_stay_from":"2020-06-27","room_stay_to":"2020-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101614","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 16:25:46","reservation_modified_date_time":"2020-06-07 14:39:02","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107808","reservation_id":"96844","confirmation_number":"SJ12632669601","room_confirmation_number":"SJ12677431559","room_stay_from":"2020-07-01","room_stay_to":"2020-07-04","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":"102971","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-20 01:42:22","reservation_modified_date_time":"2020-06-20 01:42:22","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":"3109114","reservation_id":"96615","confirmation_number":"SJ12680924857","room_confirmation_number":"SJ12675334618","room_stay_from":"2020-07-03","room_stay_to":"2020-07-04","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":"102728","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 14:21:33","reservation_modified_date_time":"2020-06-23 18:34:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102728","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":"3110844","reservation_id":"96317","confirmation_number":"SJ12647504940","room_confirmation_number":"SJ12649529156","room_stay_from":"2020-06-29","room_stay_to":"2020-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102441","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 02:05:09","reservation_modified_date_time":"2020-06-29 11:48:00","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":"3110846","reservation_id":"96318","confirmation_number":"SJ12691846749","room_confirmation_number":"SJ12617533143","room_stay_from":"2020-06-29","room_stay_to":"2020-07-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102442","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 02:12:13","reservation_modified_date_time":"2020-06-29 11:49:09","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":"3111078","reservation_id":"96617","confirmation_number":"SJ12618262770","room_confirmation_number":"SJ12615778515","room_stay_from":"2020-07-03","room_stay_to":"2020-07-04","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":"102729","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 14:24:52","reservation_modified_date_time":"2020-06-29 23:19:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102729","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":"3083255","reservation_id":"93480","confirmation_number":"SJ12623720848","room_confirmation_number":"SJ12643889829","room_stay_from":"2020-07-01","room_stay_to":"2020-07-05","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":"99706","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-18 02:22:08","reservation_modified_date_time":"2020-03-18 02:22:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99706","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3095500","reservation_id":"95126","confirmation_number":"SJ12623083136","room_confirmation_number":"SJ12627321751","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"101310","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 15:56:08","reservation_modified_date_time":"2020-05-20 15:56:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101310","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":"3106330","reservation_id":"96660","confirmation_number":"SJ12661682979","room_confirmation_number":"SJ12621284119","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"102777","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 22:19:35","reservation_modified_date_time":"2020-06-16 22: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":"3108037","reservation_id":"94933","confirmation_number":"SJ12624389390","room_confirmation_number":"SJ12665223625","room_stay_from":"2020-07-01","room_stay_to":"2020-07-05","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":"101125","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 02:12:10","reservation_modified_date_time":"2020-06-20 20:55:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101125","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":"3109069","reservation_id":"96547","confirmation_number":"SJ12638809064","room_confirmation_number":"SJ12681847899","room_stay_from":"2020-06-28","room_stay_to":"2020-07-05","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102653","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 15:34:58","reservation_modified_date_time":"2020-06-23 16:29:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3110697","reservation_id":"97196","confirmation_number":"SJ12693677284","room_confirmation_number":"SJ12635438453","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103297","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-28 20:02:07","reservation_modified_date_time":"2020-06-28 20:02:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103297","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":"3110856","reservation_id":"96779","confirmation_number":"SJ12659570641","room_confirmation_number":"SJ12617605836","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"102892","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 16:56:33","reservation_modified_date_time":"2020-06-29 11:54:51","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":"3110858","reservation_id":"95079","confirmation_number":"SJ12667788710","room_confirmation_number":"SJ12682756926","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"101262","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 23:21:08","reservation_modified_date_time":"2020-06-29 11:55:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101262","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":"3111090","reservation_id":"97050","confirmation_number":"SJ12699748636","room_confirmation_number":"SJ12693051696","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103170","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-25 00:06:08","reservation_modified_date_time":"2020-06-29 23:29:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103170","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":"3111159","reservation_id":"97079","confirmation_number":"SJ12622866940","room_confirmation_number":"SJ12699145726","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"103200","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-25 22:00:09","reservation_modified_date_time":"2020-06-30 14:41:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103200","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":"3111164","reservation_id":"97205","confirmation_number":"SJ12622251533","room_confirmation_number":"SJ12614842282","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103307","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-29 00:33:10","reservation_modified_date_time":"2020-06-30 14:44:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103307","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":"3111195","reservation_id":"96843","confirmation_number":"SJ12678560523","room_confirmation_number":"SJ12675320412","room_stay_from":"2020-06-30","room_stay_to":"2020-07-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102970","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-20 01:40:20","reservation_modified_date_time":"2020-06-30 16:53: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":"3111255","reservation_id":"97255","confirmation_number":"SJ12616824491","room_confirmation_number":"SJ12643263177","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103355","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-30 23:31:58","reservation_modified_date_time":"2020-06-30 23:31:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103355","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":"3111359","reservation_id":"97048","confirmation_number":"SJ12659114105","room_confirmation_number":"SJ12653334111","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103168","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-24 21:45:06","reservation_modified_date_time":"2020-07-01 12:35:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103168","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":"3111678","reservation_id":"97288","confirmation_number":"SJ12659669220","room_confirmation_number":"SJ12665815266","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"103379","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-02 00:12:38","reservation_modified_date_time":"2020-07-02 00:12:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103379","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":"3111693","reservation_id":"97098","confirmation_number":"SJ12615455121","room_confirmation_number":"SJ12684370690","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"103218","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 02:55:15","reservation_modified_date_time":"2020-07-02 00:45:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103218","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":"3111746","reservation_id":"97289","confirmation_number":"SJ12631433395","room_confirmation_number":"SJ12671479455","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103381","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-02 01:24:14","reservation_modified_date_time":"2020-07-02 01:24:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103381","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":"3111825","reservation_id":"95925","confirmation_number":"SJ12661014794","room_confirmation_number":"SJ12670257455","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"102069","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-05 00:58:10","reservation_modified_date_time":"2020-07-02 15:03:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102069","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":"3111834","reservation_id":"97300","confirmation_number":"SJ12672051729","room_confirmation_number":"SJ12675601843","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103388","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-02 15:49:07","reservation_modified_date_time":"2020-07-02 15:49:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103388","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3111845","reservation_id":"97302","confirmation_number":"SJ12660772747","room_confirmation_number":"SJ12678380545","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103389","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-02 15:59:09","reservation_modified_date_time":"2020-07-02 15:59:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103389","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":"3111952","reservation_id":"97317","confirmation_number":"SJ12610175338","room_confirmation_number":"SJ12662534602","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103398","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-02 20:13:07","reservation_modified_date_time":"2020-07-02 20:13:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103398","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":"3112165","reservation_id":"96038","confirmation_number":"SJ12632184179","room_confirmation_number":"SJ12629265738","room_stay_from":"2020-07-02","room_stay_to":"2020-07-05","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":"99511","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-07 14:34:20","reservation_modified_date_time":"2020-07-03 16:36:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99511","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"Nightly price or discount changed","deltaChange":"25.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":"3112214","reservation_id":"97339","confirmation_number":"SJ12696995656","room_confirmation_number":"SJ12646909661","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103424","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-03 15:20:07","reservation_modified_date_time":"2020-07-03 17:36:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103424","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":"3112236","reservation_id":"97226","confirmation_number":"SJ12653348305","room_confirmation_number":"SJ12647154240","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103328","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-29 19:47:04","reservation_modified_date_time":"2020-07-03 19:09:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103328","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":"3112238","reservation_id":"95123","confirmation_number":"SJ12637356234","room_confirmation_number":"SJ12675573985","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"101307","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 15:32:08","reservation_modified_date_time":"2020-07-03 19:09:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101307","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":"3112287","reservation_id":"97255","confirmation_number":"SJ12642332590","room_confirmation_number":"SJ12650790614","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"103355","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-30 23:31:58","reservation_modified_date_time":"2020-07-03 21:32:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103355","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":"3112289","reservation_id":"95125","confirmation_number":"SJ12668367531","room_confirmation_number":"SJ12686545684","room_stay_from":"2020-07-03","room_stay_to":"2020-07-05","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":"101309","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 15:52:10","reservation_modified_date_time":"2020-07-03 21:32:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101309","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":"3093081","reservation_id":"94698","confirmation_number":"SJ12613175805","room_confirmation_number":"SJ12668445244","room_stay_from":"2020-07-01","room_stay_to":"2020-07-06","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":"100898","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-12 13:31:13","reservation_modified_date_time":"2020-05-12 13:31:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100898","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":"3102483","reservation_id":"95468","confirmation_number":"SJ12655391966","room_confirmation_number":"SJ12622106885","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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":"101660","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 14:39:28","reservation_modified_date_time":"2020-06-07 14:38:46","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103078","reservation_id":"96016","confirmation_number":"SJ12621157566","room_confirmation_number":"SJ12670455624","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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":"102149","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-06 21:59:08","reservation_modified_date_time":"2020-06-08 22:32:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102149","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3106326","reservation_id":"95467","confirmation_number":"SJ12663044568","room_confirmation_number":"SJ12687341443","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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":"101659","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 14:37:42","reservation_modified_date_time":"2020-06-16 22:18:06","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3106332","reservation_id":"96661","confirmation_number":"SJ12639990778","room_confirmation_number":"SJ12657170184","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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":"102778","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 22:21:32","reservation_modified_date_time":"2020-06-16 22:21:32","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":"3106341","reservation_id":"96663","confirmation_number":"SJ12632570870","room_confirmation_number":"SJ12636567735","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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":"102780","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 22:24:34","reservation_modified_date_time":"2020-06-16 22:24:34","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":"3108035","reservation_id":"94697","confirmation_number":"SJ12647935426","room_confirmation_number":"SJ12644261210","room_stay_from":"2020-07-01","room_stay_to":"2020-07-06","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":"100897","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-12 13:31:08","reservation_modified_date_time":"2020-06-20 20:55:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100897","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":"3111327","reservation_id":"96662","confirmation_number":"SJ12690556036","room_confirmation_number":"SJ12639210405","room_stay_from":"2020-07-03","room_stay_to":"2020-07-06","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":"102779","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 22:22:56","reservation_modified_date_time":"2020-07-01 11:26:10","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":"3111330","reservation_id":"95407","confirmation_number":"SJ12688279570","room_confirmation_number":"SJ12682763247","room_stay_from":"2020-07-01","room_stay_to":"2020-07-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101601","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 13:51:12","reservation_modified_date_time":"2020-07-01 11:28:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3111415","reservation_id":"97249","confirmation_number":"SJ12690121356","room_confirmation_number":"SJ12630744264","room_stay_from":"2020-07-02","room_stay_to":"2020-07-06","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":"103348","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-30 18:45:06","reservation_modified_date_time":"2020-07-01 15:18:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103348","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":"3111805","reservation_id":"97018","confirmation_number":"SJ12654790135","room_confirmation_number":"SJ12626792344","room_stay_from":"2020-07-02","room_stay_to":"2020-07-06","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":"103194","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-24 00:24:18","reservation_modified_date_time":"2020-07-02 14:48:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103194","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":"3109919","reservation_id":"97102","confirmation_number":"SJ12667318095","room_confirmation_number":"SJ12624140200","room_stay_from":"2020-07-03","room_stay_to":"2020-07-07","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":"103222","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 12:52:04","reservation_modified_date_time":"2020-06-26 12:52:04","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103222","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3112292","reservation_id":"95861","confirmation_number":"SJ12672656665","room_confirmation_number":"SJ12689745534","room_stay_from":"2020-07-01","room_stay_to":"2020-07-08","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":"102017","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-03 17:20:31","reservation_modified_date_time":"2020-07-03 22:04:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102017","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":"3111086","reservation_id":"96458","confirmation_number":"SJ12669061423","room_confirmation_number":"SJ12689515637","room_stay_from":"2020-07-03","room_stay_to":"2020-07-09","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":"102567","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-13 22:34:59","reservation_modified_date_time":"2020-06-29 23:21:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102567","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":"3105961","reservation_id":"96578","confirmation_number":"SJ12697433762","room_confirmation_number":"SJ12675266876","room_stay_from":"2020-07-03","room_stay_to":"2020-07-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102691","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 00:38:49","reservation_modified_date_time":"2020-06-16 00:38:49","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":"3111197","reservation_id":"95309","confirmation_number":"SJ12650316874","room_confirmation_number":"SJ12615497878","room_stay_from":"2020-07-03","room_stay_to":"2020-07-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":"101497","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-23 23:26:09","reservation_modified_date_time":"2020-06-30 16:54:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101497","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":"3112295","reservation_id":"96447","confirmation_number":"SJ12662818514","room_confirmation_number":"SJ12629074751","room_stay_from":"2020-07-03","room_stay_to":"2020-07-17","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,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,0.00","subtotal":"350.00","grand_total":"393.75","paid_amount":"393.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"102558","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-13 20:39:15","reservation_modified_date_time":"2020-07-03 22:18:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102558","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3112054","reservation_id":"97335","confirmation_number":"SJ12681088769","room_confirmation_number":"SJ12622230891","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"7.50","paid_amount":"7.50","product_id":null,"service_quantity":"3","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-03 13:44:16","reservation_modified_date_time":"2020-07-03 13:44:16","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":"6.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[{"room_stay_id":"3112056","reservation_id":"97336","confirmation_number":"SJ12666077617","room_confirmation_number":"SJ12699736022","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-03 13:44:38","reservation_modified_date_time":"2020-07-03 13:44:38","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}