{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-11-26","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":1,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1268,1306,1866,1297,1286,1307,1916","block_room_bookings":[{"confirmation_number":"SJ12644061864","room_stay_from":"2020-11-25","room_stay_to":"2020-11-27","bundle_room":"0"},{"confirmation_number":"SJ12656464948","room_stay_from":"2020-11-26","room_stay_to":"2020-11-27","bundle_room":"0"},{"confirmation_number":"SJ12649223434","room_stay_from":"2020-11-20","room_stay_to":"2020-11-29","bundle_room":"0"},{"confirmation_number":"SJ12699637883","room_stay_from":"2020-11-24","room_stay_to":"2020-11-30","bundle_room":"0"},{"confirmation_number":"SJ12624647364","room_stay_from":"2020-11-23","room_stay_to":"2020-12-01","bundle_room":"0"},{"confirmation_number":"SJ12676533150","room_stay_from":"2020-08-07","room_stay_to":"2020-12-02","bundle_room":"0"},{"confirmation_number":"SJ12648809896","room_stay_from":"2020-11-09","room_stay_to":"2020-12-19","bundle_room":"0"}],"bundle_block_count":"1304,1305,1309,1310,1267,1268,1269,1270,1302,1303,1271,1272,1291,1711,1260,1261,1262,1263,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12650507785","room_stay_from":"2020-11-23","room_stay_to":"2020-11-27","bundle_room":"0"},{"confirmation_number":"SJB12699583204","room_stay_from":"2020-11-23","room_stay_to":"2020-11-27","bundle_room":"0"},{"confirmation_number":"SJB12642312964","room_stay_from":"2020-11-24","room_stay_to":"2020-11-27","bundle_room":"0"},{"confirmation_number":"SJB12679607135","room_stay_from":"2020-11-24","room_stay_to":"2020-11-27","bundle_room":"0"},{"confirmation_number":"SJB12639787282","room_stay_from":"2020-11-26","room_stay_to":"2020-11-27","bundle_room":"1"},{"confirmation_number":"SJB12688266823","room_stay_from":"2020-11-21","room_stay_to":"2020-11-28","bundle_room":"1"},{"confirmation_number":"SJB12633099317","room_stay_from":"2020-11-22","room_stay_to":"2020-11-28","bundle_room":"0"},{"confirmation_number":"SJB12688303935","room_stay_from":"2020-11-22","room_stay_to":"2020-11-28","bundle_room":"0"},{"confirmation_number":"SJB12613483840","room_stay_from":"2020-11-26","room_stay_to":"2020-11-28","bundle_room":"1"},{"confirmation_number":"SJB12655813480","room_stay_from":"2020-11-23","room_stay_to":"2020-11-28","bundle_room":"0"},{"confirmation_number":"SJB12658615362","room_stay_from":"2020-11-23","room_stay_to":"2020-11-28","bundle_room":"0"},{"confirmation_number":"SJB12698420412","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","bundle_room":"1"},{"confirmation_number":"SJB12695604038","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","bundle_room":"1"},{"confirmation_number":"SJB12624336456","room_stay_from":"2020-10-22","room_stay_to":"2020-12-02","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3157473","reservation_id":"101674","confirmation_number":"SJ12692545076","room_stay_from":"2020-11-26","room_stay_to":"2020-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.18","nightly_discount":"0","subtotal":"163.18","grand_total":"183.58","paid_amount":"183.58","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3123788328","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":"107769","customer_id":"107769","source_of_creation":"Booking.com","reservation_created_date":"2020-10-18 02:31:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"33.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"163.18","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":"3158255","reservation_id":"102818","confirmation_number":"SJ12610058064","room_stay_from":"2020-11-25","room_stay_to":"2020-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.58,163.18","nightly_discount":"0,0","subtotal":"301.76","grand_total":"339.48","paid_amount":"339.48","room_type_id":"319","product_id":"1308","siteminder_id":"BDC-2122789300","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":"108957","customer_id":"108957","source_of_creation":"Booking.com","reservation_created_date":"2020-11-18 20:15:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"63.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"163.18","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":"3158809","reservation_id":"102877","confirmation_number":"SJ12625182814","room_stay_from":"2020-11-26","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.98,195.98","nightly_discount":"0,0","subtotal":"391.96","grand_total":"440.96","paid_amount":"440.96","room_type_id":"319","product_id":"1756","siteminder_id":"BDC-3167780887","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":"109013","customer_id":"109013","source_of_creation":"Booking.com","reservation_created_date":"2020-11-20 12:46:22","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":"195.98","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3155241","reservation_id":"102622","confirmation_number":"SJ12637746070","room_stay_from":"2020-11-21","room_stay_to":"2020-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,127.00,127.00,127.00,127.00,149.00","nightly_discount":"0,0,0,0,0,0","subtotal":"836.00","grand_total":"940.50","paid_amount":"940.50","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1715910419","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":"108767","customer_id":"108767","source_of_creation":"Expedia","reservation_created_date":"2020-11-13 21:03:11","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":"149.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":"3156587","reservation_id":"102014","confirmation_number":"SJ12657703974","room_stay_from":"2020-11-26","room_stay_to":"2020-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.22","nightly_discount":"0","subtotal":"150.22","grand_total":"169.00","paid_amount":"169.00","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1711684942","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":"108129","customer_id":"108129","source_of_creation":"Expedia","reservation_created_date":"2020-10-28 00:58:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"150.22","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":"3158758","reservation_id":"101833","confirmation_number":"SJ12660593724","room_stay_from":"2020-11-25","room_stay_to":"2020-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.42,130.54","nightly_discount":"0,0","subtotal":"247.96","grand_total":"278.96","paid_amount":"278.96","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1710181937","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":"107929","customer_id":"107929","source_of_creation":"Expedia","reservation_created_date":"2020-10-22 11:33:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"49.59","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.54","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":"3152803","reservation_id":"94387","confirmation_number":"SJ12636362871","room_stay_from":"2020-11-22","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20,143.20,143.20,143.20,179.20","nightly_discount":"0,0,0,0,0,0","subtotal":"895.20","grand_total":"1007.10","paid_amount":"1007.10","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1662686104","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":"100601","customer_id":"100601","source_of_creation":"Expedia","reservation_created_date":"2020-05-03 17:47:08","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":"143.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3153041","reservation_id":"102401","confirmation_number":"SJ12668612670","room_stay_from":"2020-11-26","room_stay_to":"2020-11-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"162.56,188.16,188.16,143.36","nightly_discount":"0,0,0,0","subtotal":"682.24","grand_total":"767.52","paid_amount":"767.52","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1714340552","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":"108565","customer_id":"108565","source_of_creation":"Expedia","reservation_created_date":"2020-11-07 19:00:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"162.56","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":"3100509","reservation_id":"95840","confirmation_number":"SJ12622883880","room_stay_from":"2020-11-25","room_stay_to":"2020-12-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.60,145.60,161.60,161.60,161.60,145.60,145.60,145.60,145.60","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"1358.40","grand_total":"1528.20","paid_amount":"1528.20","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1667650856","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":"109271","customer_id":"101997","source_of_creation":"Expedia","reservation_created_date":"2020-06-03 00:56:06","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":"145.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3157437","reservation_id":"102828","confirmation_number":"SJ12651743416","room_stay_from":"2020-11-26","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.10,122.58,147.22","nightly_discount":"0,0,0","subtotal":"373.90","grand_total":"420.64","paid_amount":"420.64","room_type_id":"319","product_id":"1942","siteminder_id":"GAM-R2216915887","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":"108968","customer_id":"108968","source_of_creation":"Getaroom.com","reservation_created_date":"2020-11-19 01:12:10","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":"104.10","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3158319","reservation_id":"102848","confirmation_number":"SJ12613149848","room_stay_from":"2020-11-24","room_stay_to":"2020-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"288.47,288.47,288.47","nightly_discount":"0,0,0","subtotal":"865.41","grand_total":"1122.59","paid_amount":"870.52","room_type_id":"320","product_id":"1910","siteminder_id":"ABB-HMN5SJMEPA","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"865.41","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108984","customer_id":"108984","source_of_creation":"Airbnb","reservation_created_date":"2020-11-19 18:20:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"133.14","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"288.47","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3158826","reservation_id":"102722","confirmation_number":"SJ12651922923","room_stay_from":"2020-11-26","room_stay_to":"2020-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"160.64","nightly_discount":"0","subtotal":"160.64","grand_total":"215.65","paid_amount":"186.41","room_type_id":"413","product_id":"1264","siteminder_id":"ABB-HMC5C5QH3X","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"160.64","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108864","customer_id":"108864","source_of_creation":"Airbnb","reservation_created_date":"2020-11-16 15:00:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"28.56","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.64","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3158466","reservation_id":"103118","confirmation_number":"SJ12662115810","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"230.23,230.23,230.23","nightly_discount":"0.00,0.00,0.00","subtotal":"690.69","grand_total":"895.95","paid_amount":"891.83","room_type_id":"319","product_id":"1314","siteminder_id":"ABB-HMJA4PXED4","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"690.69","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109257","customer_id":"109257","source_of_creation":"Airbnb","reservation_created_date":"2020-11-25 15:47:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"106.26","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"230.23","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3158918","reservation_id":"103073","confirmation_number":"SJ12692374470","room_stay_from":"2020-11-26","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"215.72,215.72","nightly_discount":"0.00,0.00","subtotal":"431.44","grand_total":"588.76","paid_amount":"430.84","room_type_id":"319","product_id":"1293","siteminder_id":"ABB-HM8PWH2ZHM","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"431.44","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109208","customer_id":"109208","source_of_creation":"Airbnb","reservation_created_date":"2020-11-24 15:30:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"81.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"215.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[{"room_stay_id":"3158630","reservation_id":"103133","confirmation_number":"SJ12694741431","room_stay_from":"2020-11-25","room_stay_to":"2020-12-04","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.16,160.16,160.16,160.16,160.16,160.16,160.16,160.16,160.16","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"1441.44","grand_total":"1869.85","paid_amount":"1861.20","room_type_id":"413","product_id":"1265","siteminder_id":"ABB-HMKCPSEKJQ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1441.44","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109278","customer_id":"109278","source_of_creation":"Airbnb","reservation_created_date":"2020-11-25 20:58:06","service_canceled_date_time":"2020-11-26 16:40:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"221.76","reservation_status_type":"","total_paid_amount":"1861.20","deltaChange":"1700.08","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"hwr_taxable":[{"room_stay_id":"3156949","reservation_id":"102936","confirmation_number":"SJ12693163561","room_stay_from":"2020-11-25","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"99.00,99.00,129.00,129.00","nightly_discount":"0,0,0,0","subtotal":"456.00","grand_total":"513.00","paid_amount":"513.00","room_type_id":"413","product_id":"1271","siteminder_id":"HWR-302895558","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":"109065","customer_id":"109065","source_of_creation":"Hotwire","reservation_created_date":"2020-11-21 16:07:19","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":"99.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"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3155348","reservation_id":"102123","confirmation_number":"SJ12652494171","room_stay_from":"2020-11-23","room_stay_to":"2020-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"263.20,263.20,263.20,293.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1082.80","grand_total":"1218.15","paid_amount":"1218.15","room_type_id":"320","product_id":"1329","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108257","customer_id":"108257","source_of_creation":"FE","reservation_created_date":"2020-10-30 18:25:19","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"293.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3149237","reservation_id":"101999","confirmation_number":"SJ12625032624","room_stay_from":"2020-11-24","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.20,167.20,183.20,231.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"748.80","grand_total":"842.40","paid_amount":"842.40","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":"108114","customer_id":"108114","source_of_creation":"FE","reservation_created_date":"2020-10-27 19:36:16","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":"183.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3155246","reservation_id":"101743","confirmation_number":"SJ12667398379","room_stay_from":"2020-11-24","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"143.20,143.20,159.20,207.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"652.80","grand_total":"734.40","paid_amount":"734.40","room_type_id":"319","product_id":"1319","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107836","customer_id":"107836","source_of_creation":"FE","reservation_created_date":"2020-10-19 21:42:16","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":"159.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3155720","reservation_id":"102787","confirmation_number":"SJ12649458856","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.20,183.20,215.20","nightly_discount":"0.00,0.00,0.00","subtotal":"557.60","grand_total":"627.30","paid_amount":"627.30","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":"108927","customer_id":"108927","source_of_creation":"FE","reservation_created_date":"2020-11-17 22:44:48","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":"183.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3156781","reservation_id":"102918","confirmation_number":"SJ12653728621","room_stay_from":"2020-11-22","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"255.20,255.20,255.20,279.20,311.20,311.20","nightly_discount":"25.52,25.52,25.52,27.92,31.12,31.12","subtotal":"1667.20","grand_total":"1688.04","paid_amount":"1688.04","room_type_id":"320","product_id":"1328","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109049","customer_id":"109049","source_of_creation":"PMS","reservation_created_date":"2020-11-20 23:52:53","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"311.20","currentDayDiscount":"31.12","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3158121","reservation_id":"100998","confirmation_number":"SJ12659853253","room_stay_from":"2020-11-23","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"279.20,279.20,279.20,279.20,299.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1415.80","grand_total":"1592.78","paid_amount":"1368.90","room_type_id":"320","product_id":"1714","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":"107037","customer_id":"107037","source_of_creation":"PMS","reservation_created_date":"2020-09-30 15:26:15","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"279.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3158508","reservation_id":"102378","confirmation_number":"SJ12667900150","room_stay_from":"2020-11-26","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00","nightly_discount":"0.00,0.00","subtotal":"238.00","grand_total":"267.75","paid_amount":"267.75","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":"108540","customer_id":"108540","source_of_creation":"PMS","reservation_created_date":"2020-11-06 23:49:35","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":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3158762","reservation_id":"103144","confirmation_number":"SJ12657993863","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.20,215.20,215.20","nightly_discount":"0.00,0.00,0.00","subtotal":"613.60","grand_total":"690.30","paid_amount":"690.30","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":"109296","customer_id":"109296","source_of_creation":"PMS","reservation_created_date":"2020-11-26 02:33:09","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":"215.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3158899","reservation_id":"102803","confirmation_number":"SJ12690268182","room_stay_from":"2020-11-23","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.20,95.20,95.20,114.20,114.20","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"514.00","grand_total":"578.25","paid_amount":"578.25","room_type_id":"413","product_id":"1270","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108946","customer_id":"108946","source_of_creation":"PMS","reservation_created_date":"2020-11-18 14:16:08","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"114.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3157432","reservation_id":"102764","confirmation_number":"SJ12655604486","room_stay_from":"2020-11-26","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"183.20,215.20,215.20","nightly_discount":"0.00,0.00,0.00","subtotal":"613.60","grand_total":"690.30","paid_amount":"690.30","room_type_id":"413","product_id":"1272","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108905","customer_id":"108905","source_of_creation":"PMS","reservation_created_date":"2020-11-17 13:54:42","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"183.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3158201","reservation_id":"102900","confirmation_number":"SJ12615733455","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.60,173.60,173.60,173.60,173.60","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"868.00","grand_total":"976.50","paid_amount":"976.50","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102312","customer_id":"102312","source_of_creation":"PMS","reservation_created_date":"2020-11-20 19:39:11","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":"173.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":"3158764","reservation_id":"103144","confirmation_number":"SJ12696538752","room_stay_from":"2020-11-25","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.20,215.20,215.20,215.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"828.80","grand_total":"932.40","paid_amount":"932.40","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109296","customer_id":"109296","source_of_creation":"PMS","reservation_created_date":"2020-11-26 02:33:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"215.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3150556","reservation_id":"102139","confirmation_number":"SJ12651340546","room_stay_from":"2020-11-22","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.28,94.28,94.28,94.28,94.28,94.30,94.30","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"660.00","grand_total":"660.00","paid_amount":"0.00","room_type_id":"319","product_id":"1913","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-10-31 01:20:34","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":"94.28","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3152182","reservation_id":"100952","confirmation_number":"SJ12694249915","room_stay_from":"2020-11-21","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"106.32","room_type_id":"413","product_id":"1263","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-09-29 00:00:30","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":"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":"3152224","reservation_id":"101515","confirmation_number":"SJ12655289739","room_stay_from":"2020-11-21","room_stay_to":"2020-11-28","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,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"546.00","grand_total":"546.00","paid_amount":"175.00","room_type_id":"413","product_id":"1269","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-10-14 01:28:24","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":"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":"3156580","reservation_id":"100359","confirmation_number":"SJ12612731934","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","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":"413","product_id":"1266","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-09-14 00:29:41","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":"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":"3158692","reservation_id":"99187","confirmation_number":"SJ12668022544","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","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":"45.57","room_type_id":"413","product_id":"1262","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-08-17 20:26:06","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":"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":"3152264","reservation_id":"101750","confirmation_number":"SJ12669388318","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","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":"75.94","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-10-19 23:28:57","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":"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":"3157960","reservation_id":"102754","confirmation_number":"SJ12695792026","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","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":"75.94","room_type_id":"319","product_id":"1943","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-11-17 01:29:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3158971","reservation_id":"103164","confirmation_number":"SJ12669460657","room_stay_from":"2020-11-26","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"45.57","room_type_id":"319","product_id":"1313","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-11-26 21:10:02","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":"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":"3152282","reservation_id":"99188","confirmation_number":"SJ12669226988","room_stay_from":"2020-11-25","room_stay_to":"2020-11-30","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":"75.94","room_type_id":"413","product_id":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-08-17 20:34:25","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3158688","reservation_id":"99526","confirmation_number":"SJ12660750856","room_stay_from":"2020-11-25","room_stay_to":"2020-11-30","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":"75.94","room_type_id":"413","product_id":"1261","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-08-26 00:08:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3158828","reservation_id":"102722","confirmation_number":"SJ12676078490","room_confirmation_number":"SJ12651922923","room_stay_from":"2020-11-26","room_stay_to":"2020-11-27","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"25.15","paid_amount":"25.15","product_id":"1777","service_quantity":"1","customer_traveller_id":"108864","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-11-26 13:56:53","reservation_modified_date_time":"2020-11-26 13:56:53","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108864","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3158006","reservation_id":"103073","confirmation_number":"SJ12639843636","room_confirmation_number":"SJ12692374470","room_stay_from":"2020-11-26","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"100.60","paid_amount":"100.60","product_id":"1777","service_quantity":"1","customer_traveller_id":"109208","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-11-24 15:30:09","reservation_modified_date_time":"2020-11-24 15:30:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109208","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"0.60","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3155242","reservation_id":"102622","confirmation_number":"SJ12672474881","room_confirmation_number":"SJ12637746070","room_stay_from":"2020-11-21","room_stay_to":"2020-11-27","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":"108767","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-13 21:03:11","reservation_modified_date_time":"2020-11-15 20:37:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108767","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":"3155351","reservation_id":"102123","confirmation_number":"SJ12629223543","room_confirmation_number":"SJ12652494171","room_stay_from":"2020-11-23","room_stay_to":"2020-11-27","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":"108257","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-30 18:25:19","reservation_modified_date_time":"2020-11-16 14:17:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108257","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":"3156588","reservation_id":"102014","confirmation_number":"SJ12651033571","room_confirmation_number":"SJ12657703974","room_stay_from":"2020-11-26","room_stay_to":"2020-11-27","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":"108129","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-28 00:58:06","reservation_modified_date_time":"2020-11-20 17:50:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108129","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":"3157474","reservation_id":"101674","confirmation_number":"SJ12611488912","room_confirmation_number":"SJ12692545076","room_stay_from":"2020-11-26","room_stay_to":"2020-11-27","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":"107769","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-18 02:31:07","reservation_modified_date_time":"2020-11-22 21:05:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107769","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":"3158256","reservation_id":"102818","confirmation_number":"SJ12654710480","room_confirmation_number":"SJ12610058064","room_stay_from":"2020-11-25","room_stay_to":"2020-11-27","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"108957","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-18 20:15:07","reservation_modified_date_time":"2020-11-24 21:59:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108957","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":"3158322","reservation_id":"102848","confirmation_number":"SJ12626603063","room_confirmation_number":"SJ12613149848","room_stay_from":"2020-11-24","room_stay_to":"2020-11-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"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":"108984","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-19 18:20:10","reservation_modified_date_time":"2020-11-25 01:05:13","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108984","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3158759","reservation_id":"101833","confirmation_number":"SJ12699701146","room_confirmation_number":"SJ12660593724","room_stay_from":"2020-11-25","room_stay_to":"2020-11-27","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":"1776","service_quantity":"1","customer_traveller_id":"107929","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-22 11:33:10","reservation_modified_date_time":"2020-11-26 00:55:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107929","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3158829","reservation_id":"102722","confirmation_number":"SJ12621253074","room_confirmation_number":"SJ12651922923","room_stay_from":"2020-11-26","room_stay_to":"2020-11-27","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":"108864","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-16 15:00:13","reservation_modified_date_time":"2020-11-26 13:56:53","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108864","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3149238","reservation_id":"101999","confirmation_number":"SJ12664849410","room_confirmation_number":"SJ12625032624","room_stay_from":"2020-11-24","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"108114","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-27 19:36:16","reservation_modified_date_time":"2020-10-27 19:36:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108114","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":"3152184","reservation_id":"100952","confirmation_number":"SJ12686353605","room_confirmation_number":"SJ12694249915","room_stay_from":"2020-11-21","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50,11.50,11.50,11.50","subtotal":"175.00","grand_total":"106.32","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"106985","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-29 00:00:30","reservation_modified_date_time":"2020-11-05 19:39:54","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":"11.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3152226","reservation_id":"101515","confirmation_number":"SJ12672456298","room_confirmation_number":"SJ12655289739","room_stay_from":"2020-11-21","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50,11.50,11.50,11.50","subtotal":"175.00","grand_total":"106.32","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"107593","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-14 01:28:24","reservation_modified_date_time":"2020-11-05 19:44: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":"11.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3152804","reservation_id":"94387","confirmation_number":"SJ12622921078","room_confirmation_number":"SJ12636362871","room_stay_from":"2020-11-22","room_stay_to":"2020-11-28","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":"100601","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-03 17:47:08","reservation_modified_date_time":"2020-11-06 23:46:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100601","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":"3155247","reservation_id":"101743","confirmation_number":"SJ12621700859","room_confirmation_number":"SJ12667398379","room_stay_from":"2020-11-24","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"107836","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-19 21:42:16","reservation_modified_date_time":"2020-11-15 20:38:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107836","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":"3155721","reservation_id":"102787","confirmation_number":"SJ12668387412","room_confirmation_number":"SJ12649458856","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"108927","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-17 22:44:48","reservation_modified_date_time":"2020-11-17 22:44:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108927","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":"3156581","reservation_id":"100359","confirmation_number":"SJ12629808508","room_confirmation_number":"SJ12612731934","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50","subtotal":"75.00","grand_total":"45.57","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"105668","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-14 00:29:41","reservation_modified_date_time":"2020-11-20 17:42: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":"11.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3156782","reservation_id":"102918","confirmation_number":"SJ12693527542","room_confirmation_number":"SJ12653728621","room_stay_from":"2020-11-22","room_stay_to":"2020-11-28","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":"109049","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-20 23:52:53","reservation_modified_date_time":"2020-11-20 23:52:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109049","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":"3158124","reservation_id":"100998","confirmation_number":"SJ12617720193","room_confirmation_number":"SJ12659853253","room_stay_from":"2020-11-23","room_stay_to":"2020-11-28","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":"107037","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-30 15:26:15","reservation_modified_date_time":"2020-11-24 18:13:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107037","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":"3158467","reservation_id":"103118","confirmation_number":"SJ12676999805","room_confirmation_number":"SJ12662115810","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"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":"109257","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-25 15:47:06","reservation_modified_date_time":"2020-11-25 16:51:42","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109257","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3158509","reservation_id":"102378","confirmation_number":"SJ12679012319","room_confirmation_number":"SJ12667900150","room_stay_from":"2020-11-26","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"108540","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-06 23:49:35","reservation_modified_date_time":"2020-11-25 18:14:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108540","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":"3158693","reservation_id":"99187","confirmation_number":"SJ12685019503","room_confirmation_number":"SJ12668022544","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50","subtotal":"75.00","grand_total":"45.57","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"105164","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-17 20:26:06","reservation_modified_date_time":"2020-11-25 23:30:04","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":"11.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3158763","reservation_id":"103144","confirmation_number":"SJ12687442109","room_confirmation_number":"SJ12657993863","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"109296","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-26 02:33:09","reservation_modified_date_time":"2020-11-26 02:33:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109296","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":"3158810","reservation_id":"102877","confirmation_number":"SJ12635559938","room_confirmation_number":"SJ12625182814","room_stay_from":"2020-11-26","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"109013","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-20 12:46:22","reservation_modified_date_time":"2020-11-26 13:36:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109013","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":"3158900","reservation_id":"102803","confirmation_number":"SJ12610665311","room_confirmation_number":"SJ12690268182","room_stay_from":"2020-11-23","room_stay_to":"2020-11-28","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":"108946","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-18 14:16:08","reservation_modified_date_time":"2020-11-26 17:33:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108946","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3158919","reservation_id":"103073","confirmation_number":"SJ12668074638","room_confirmation_number":"SJ12692374470","room_stay_from":"2020-11-26","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109208","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-24 15:30:09","reservation_modified_date_time":"2020-11-26 18:24:42","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109208","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3150557","reservation_id":"102139","confirmation_number":"SJ12686986577","room_confirmation_number":"SJ12651340546","room_stay_from":"2020-11-22","room_stay_to":"2020-11-29","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":"108276","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-31 01:20:34","reservation_modified_date_time":"2020-10-31 01:32:47","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":"3152265","reservation_id":"101750","confirmation_number":"SJ12634241505","room_confirmation_number":"SJ12669388318","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50,11.50","subtotal":"125.00","grand_total":"75.94","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"107846","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-19 23:28:57","reservation_modified_date_time":"2020-11-05 19:54:28","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"11.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3156948","reservation_id":"102936","confirmation_number":"SJ12615839038","room_confirmation_number":"SJ12693163561","room_stay_from":"2020-11-25","room_stay_to":"2020-11-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109065","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-21 16:07:19","reservation_modified_date_time":"2020-11-21 16:18:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109065","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":"3157433","reservation_id":"102764","confirmation_number":"SJ12693572283","room_confirmation_number":"SJ12655604486","room_stay_from":"2020-11-26","room_stay_to":"2020-11-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"108905","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-17 13:54:42","reservation_modified_date_time":"2020-11-22 20:53:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108905","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":"3157438","reservation_id":"102828","confirmation_number":"SJ12699191193","room_confirmation_number":"SJ12651743416","room_stay_from":"2020-11-26","room_stay_to":"2020-11-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"108968","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-19 01:12:10","reservation_modified_date_time":"2020-11-22 20:54:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108968","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":"3157961","reservation_id":"102754","confirmation_number":"SJ12642522303","room_confirmation_number":"SJ12695792026","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50,11.50","subtotal":"125.00","grand_total":"75.94","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"108896","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-17 01:29:46","reservation_modified_date_time":"2020-11-24 13:53:01","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":"11.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3158202","reservation_id":"102900","confirmation_number":"SJ12675310612","room_confirmation_number":"SJ12615733455","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","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":"102312","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-20 19:39:11","reservation_modified_date_time":"2020-11-24 20:18:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102312","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3158765","reservation_id":"103144","confirmation_number":"SJ12641359377","room_confirmation_number":"SJ12696538752","room_stay_from":"2020-11-25","room_stay_to":"2020-11-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"109296","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-26 02:33:09","reservation_modified_date_time":"2020-11-26 02:33:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109296","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":"3158972","reservation_id":"103164","confirmation_number":"SJ12674605364","room_confirmation_number":"SJ12669460657","room_stay_from":"2020-11-26","room_stay_to":"2020-11-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50","subtotal":"75.00","grand_total":"45.57","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109312","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-26 21:10:02","reservation_modified_date_time":"2020-11-26 21:11: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":"11.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3152284","reservation_id":"99188","confirmation_number":"SJ12616472676","room_confirmation_number":"SJ12669226988","room_stay_from":"2020-11-25","room_stay_to":"2020-11-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50,11.50","subtotal":"125.00","grand_total":"75.94","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"105166","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-17 20:34:25","reservation_modified_date_time":"2020-11-05 20:10:04","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":"11.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3153042","reservation_id":"102401","confirmation_number":"SJ12614103530","room_confirmation_number":"SJ12668612670","room_stay_from":"2020-11-26","room_stay_to":"2020-11-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"108565","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-07 19:00:11","reservation_modified_date_time":"2020-11-07 19:00:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108565","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":"3158691","reservation_id":"99526","confirmation_number":"SJ12676136717","room_confirmation_number":"SJ12660750856","room_stay_from":"2020-11-25","room_stay_to":"2020-11-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50,11.50","subtotal":"125.00","grand_total":"75.94","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"105166","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-26 00:08:07","reservation_modified_date_time":"2020-11-25 23:29:55","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":"11.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3100510","reservation_id":"95840","confirmation_number":"SJ12670769330","room_confirmation_number":"SJ12622883880","room_stay_from":"2020-11-25","room_stay_to":"2020-12-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.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"109271","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-03 00:56:06","reservation_modified_date_time":"2020-06-03 00:56:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101997","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":"3158631","reservation_id":"103133","confirmation_number":"SJ12636214981","room_confirmation_number":"SJ12694741431","room_stay_from":"2020-11-25","room_stay_to":"2020-12-04","room_stay_status":"Canceled","nightly_price":"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","subtotal":"225.00","grand_total":"253.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-11-25 20:58:06","reservation_modified_date_time":"2020-11-25 20:58:06","customer_id":"109278","parentCustTravId":"109278","customer_traveller_id":"109278","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-11-26 16:40:08","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","parentRoomStayFrom":"2020-11-25","deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3158944","reservation_id":"103163","confirmation_number":"SJ12613569101","room_confirmation_number":"SJ12630388951","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":"16.00","paid_amount":"16.00","product_id":"1663","service_quantity":"4","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-11-26 19:10:44","reservation_modified_date_time":"2020-11-26 19:10:44","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,"parentRoomStayFrom":"1970-01-01","currentDayPrice":"14.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3159050","reservation_id":"103171","confirmation_number":"SJ12663931482","room_confirmation_number":"SJ12655885697","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":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-11-27 03:42:47","reservation_modified_date_time":"2020-11-27 03:42:47","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,"parentRoomStayFrom":"1970-01-01","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}