{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-04-05","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,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":13,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1309,1310,1275","block_room_bookings":[{"confirmation_number":"SJ12622665231","room_stay_from":"2021-04-05","room_stay_to":"2021-04-09","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJ12632965439","room_stay_from":"2021-04-05","room_stay_to":"2021-04-10","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJ12618960500","room_stay_from":"2021-03-30","room_stay_to":"2021-04-11","bundle_room":"0","product_id":"1275"}],"bundle_block_count":"1260,1261,1291,1711,1307,1308,1262,1263,1267,1268,1311,1312,1271,1272,1304,1305,1302,1303,1269,1270","bundle_block_bookings":[{"confirmation_number":"SJB12610283712","room_stay_from":"2021-04-01","room_stay_to":"2021-04-06","bundle_room":"0","product_id":"1260"},{"confirmation_number":"SJB12659558402","room_stay_from":"2021-04-01","room_stay_to":"2021-04-06","bundle_room":"0","product_id":"1261"},{"confirmation_number":"SJB12634452720","room_stay_from":"2021-04-05","room_stay_to":"2021-04-07","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12660814431","room_stay_from":"2021-04-05","room_stay_to":"2021-04-07","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12613942983","room_stay_from":"2021-04-02","room_stay_to":"2021-04-07","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12672794861","room_stay_from":"2021-04-02","room_stay_to":"2021-04-07","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12670382272","room_stay_from":"2021-04-04","room_stay_to":"2021-04-08","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJB12675013132","room_stay_from":"2021-04-04","room_stay_to":"2021-04-08","bundle_room":"0","product_id":"1263"},{"confirmation_number":"SJB12653783942","room_stay_from":"2021-04-04","room_stay_to":"2021-04-08","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12653912799","room_stay_from":"2021-04-04","room_stay_to":"2021-04-08","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12615917105","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12616059818","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12658500387","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12639194377","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12640322029","room_stay_from":"2021-04-02","room_stay_to":"2021-04-09","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12695644949","room_stay_from":"2021-04-02","room_stay_to":"2021-04-09","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12689462322","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12670530520","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12625785638","room_stay_from":"2021-04-04","room_stay_to":"2021-04-10","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12696598078","room_stay_from":"2021-04-04","room_stay_to":"2021-04-10","bundle_room":"0","product_id":"1270"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3187209","reservation_id":"106124","confirmation_number":"SJ12671153111","room_stay_from":"2021-03-30","room_stay_to":"2021-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"219.80,219.80,233.80,261.80,261.80,233.80,233.80","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1664.60","grand_total":"1872.68","paid_amount":"1872.68","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3316278270","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":"112541","customer_id":"112541","source_of_creation":"Booking.com","reservation_created_date":"2021-01-26 01:34:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"331.13","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"233.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":"3198472","reservation_id":"107652","confirmation_number":"SJ12615056158","room_stay_from":"2021-04-03","room_stay_to":"2021-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"279.25,249.25,249.25","nightly_discount":"0,0,0","subtotal":"777.75","grand_total":"874.97","paid_amount":"874.97","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-2566880511","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":"114111","customer_id":"114111","source_of_creation":"Booking.com","reservation_created_date":"2021-02-15 02:55:29","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"348.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"249.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202935","reservation_id":"107652","confirmation_number":"SJ12694345132","room_stay_from":"2021-04-03","room_stay_to":"2021-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"256.75,226.75,226.75","nightly_discount":"0,0,0","subtotal":"710.25","grand_total":"799.03","paid_amount":"799.03","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-2566880511","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":"114111","customer_id":"114111","source_of_creation":"Booking.com","reservation_created_date":"2021-02-15 02:55:24","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"226.75","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":"3228096","reservation_id":"112120","confirmation_number":"SJ12654845176","room_stay_from":"2021-04-05","room_stay_to":"2021-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"278.19","nightly_discount":"0","subtotal":"278.19","grand_total":"312.96","paid_amount":"312.96","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3875328706","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":"118689","customer_id":"118689","source_of_creation":"Booking.com","reservation_created_date":"2021-04-04 22:42:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"63.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"278.19","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":"3223593","reservation_id":"107327","confirmation_number":"SJ12677941040","room_stay_from":"2021-03-29","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.80,261.80,261.80,261.80,289.80,289.80,261.80,261.80,240.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2391.20","grand_total":"2690.10","paid_amount":"2690.10","room_type_id":"319","product_id":"1277","siteminder_id":"BDC-3657384126","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":"113785","customer_id":"113785","source_of_creation":"Booking.com","reservation_created_date":"2021-02-11 02:54:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"470.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"261.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":"3224265","reservation_id":"108204","confirmation_number":"SJ12647250748","room_stay_from":"2021-04-05","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"242.35,242.35","nightly_discount":"0,0","subtotal":"484.70","grand_total":"545.29","paid_amount":"545.29","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-2827799343","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":"114668","customer_id":"114668","source_of_creation":"Booking.com","reservation_created_date":"2021-02-21 20:38:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"96.25","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"242.35","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":"3227992","reservation_id":"112107","confirmation_number":"SJ12658842540","room_stay_from":"2021-04-05","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"295.37,295.37","nightly_discount":"0,0","subtotal":"590.74","grand_total":"664.59","paid_amount":"664.59","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-3873207424","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":"118674","customer_id":"118674","source_of_creation":"Booking.com","reservation_created_date":"2021-04-04 19:25:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"115.33","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"295.37","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":"3192081","reservation_id":"106937","confirmation_number":"SJ12660023131","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"345.80,317.80,317.80,282.80,282.80","nightly_discount":"0,0,0,0,0","subtotal":"1547.00","grand_total":"1740.38","paid_amount":"1740.38","room_type_id":"320","product_id":"1332","siteminder_id":"BDC-3341394800","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":"113372","customer_id":"113372","source_of_creation":"Booking.com","reservation_created_date":"2021-02-05 01:26:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"300.96","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"317.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":"3214599","reservation_id":"110154","confirmation_number":"SJ12696259719","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"370.57,336.82,336.82,336.82,323.32","nightly_discount":"0,0,0,0,0","subtotal":"1704.35","grand_total":"1917.40","paid_amount":"1917.40","room_type_id":"320","product_id":"1324","siteminder_id":"BDC-3994456644","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":"116661","customer_id":"116661","source_of_creation":"Booking.com","reservation_created_date":"2021-03-12 19:17:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"329.28","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1271,1272","currentDayPrice":"336.82","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":"3094784","reservation_id":"94955","confirmation_number":"SJ12612653129","room_stay_from":"2021-04-05","room_stay_to":"2021-04-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"6.00,6.00,6.00,6.00","nightly_discount":"0,0,0,0","subtotal":"24.00","grand_total":"27.00","paid_amount":"27.00","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2196257226","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":"101144","customer_id":"101144","source_of_creation":"Booking.com","reservation_created_date":"2020-05-18 15:20:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"22.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"6.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":"3191788","reservation_id":"106746","confirmation_number":"SJ12655644327","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"279.30,279.30,251.30,251.30,216.30,216.30,216.30,244.30","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1954.40","grand_total":"2198.70","paid_amount":"2198.70","room_type_id":"319","product_id":"1314","siteminder_id":"BDC-3665180401","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":"113167","customer_id":"113167","source_of_creation":"Booking.com","reservation_created_date":"2021-02-02 18:16:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"387.79","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"251.30","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":"3202106","reservation_id":"107993","confirmation_number":"SJ12664003835","room_stay_from":"2021-04-04","room_stay_to":"2021-04-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"197.88,197.88,197.88,180.87,180.87,203.55","nightly_discount":"0,0,0,0,0,0","subtotal":"1158.93","grand_total":"1303.80","paid_amount":"1303.80","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-2600353681","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":"114455","customer_id":"114455","source_of_creation":"Booking.com","reservation_created_date":"2021-02-18 18:43:24","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"197.88","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3215077","reservation_id":"110212","confirmation_number":"SJ12640729143","room_stay_from":"2021-04-04","room_stay_to":"2021-04-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"374.25,374.25,374.25,359.25,359.25,389.25","nightly_discount":"0,0,0,0,0,0","subtotal":"2230.50","grand_total":"2509.32","paid_amount":"2509.32","room_type_id":"320","product_id":"1323","siteminder_id":"BDC-2193885559","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":"116725","customer_id":"116725","source_of_creation":"Booking.com","reservation_created_date":"2021-03-13 17:46:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"428.49","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1269,1270","currentDayPrice":"374.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3221779","reservation_id":"109959","confirmation_number":"SJ12662063432","room_stay_from":"2021-04-05","room_stay_to":"2021-04-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"284.25,284.25,269.25,269.25,299.25","nightly_discount":"0,0,0,0,0","subtotal":"1406.25","grand_total":"1582.03","paid_amount":"1582.03","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-3789965702","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":"116453","customer_id":"116453","source_of_creation":"Booking.com","reservation_created_date":"2021-03-10 15:02:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"275.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"284.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3228764","reservation_id":"105343","confirmation_number":"SJ12661931586","room_stay_from":"2021-04-05","room_stay_to":"2021-04-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"175.77,144.27,144.27,144.27,169.47,169.47,144.27,144.27","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1236.06","grand_total":"1390.56","paid_amount":"1390.56","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-2274444575","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":"111728","customer_id":"111728","source_of_creation":"Booking.com","reservation_created_date":"2021-01-14 20:38:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"258.49","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"175.77","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3228363","reservation_id":"112110","confirmation_number":"SJ12629852659","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","room_stay_status":"Active","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"208.28,232.58,232.58","nightly_discount":"0,0,0","subtotal":"673.44","grand_total":"757.62","paid_amount":"234.31","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2918442168","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":"118678","customer_id":"118678","source_of_creation":"Booking.com","reservation_created_date":"2021-04-04 19:47:26","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":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3228496","reservation_id":"112124","confirmation_number":"SJ12617525714","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"265.30,265.30,265.30,279.30","nightly_discount":"0,0,0,0","subtotal":"1075.20","grand_total":"1209.60","paid_amount":"298.47","room_type_id":"320","product_id":"1324","siteminder_id":"BDC-2357570489","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":"118693","customer_id":"118693","source_of_creation":"Booking.com","reservation_created_date":"2021-04-04 23:35:17","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[{"room_stay_id":"3132296","reservation_id":"99741","confirmation_number":"SJ12687867502","room_stay_from":"2021-04-05","room_stay_to":"2021-04-06","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"258.19","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3320409792","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":"105755","customer_id":"105755","source_of_creation":"Booking.com","reservation_created_date":"2020-08-30 15:42:08","service_canceled_date_time":"2021-02-21 15:06:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"45.81","sub_hotel_id":"126","deltaChange":"258.19","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3225741","reservation_id":"111808","confirmation_number":"SJ12627155802","room_stay_from":"2021-04-05","room_stay_to":"2021-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"291.72","nightly_discount":"0","subtotal":"291.72","grand_total":"328.19","paid_amount":"328.19","room_type_id":"319","product_id":"1301","siteminder_id":"EXP-1754540606","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":"118365","customer_id":"118365","source_of_creation":"Expedia","reservation_created_date":"2021-04-01 04:07:10","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":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"291.72","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3187244","reservation_id":"105744","confirmation_number":"SJ12664152263","room_stay_from":"2021-04-05","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"306.56,274.56","nightly_discount":"0,0","subtotal":"581.12","grand_total":"653.76","paid_amount":"653.76","room_type_id":"320","product_id":"1714","siteminder_id":"EXP-1731473776","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":"112140","customer_id":"112140","source_of_creation":"Expedia","reservation_created_date":"2021-01-20 21:41:09","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1291,1711","currentDayPrice":"306.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":"3200814","reservation_id":"107957","confirmation_number":"SJ12632080324","room_stay_from":"2021-04-03","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.30,223.30,223.30,223.30","nightly_discount":"0,0,0,0","subtotal":"921.20","grand_total":"1036.35","paid_amount":"1036.35","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1739284112","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":"114423","customer_id":"114423","source_of_creation":"Expedia","reservation_created_date":"2021-02-18 12:52:24","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"223.30","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":"3226065","reservation_id":"110924","confirmation_number":"SJ12692050848","room_stay_from":"2021-04-04","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"321.75,321.75,321.75","nightly_discount":"0,0,0","subtotal":"965.25","grand_total":"1085.90","paid_amount":"1085.90","room_type_id":"413","product_id":"1273","siteminder_id":"EXP-1750462699","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":"118717","customer_id":"117457","source_of_creation":"Expedia","reservation_created_date":"2021-03-21 22:17:07","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"321.75","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":"3174887","reservation_id":"104845","confirmation_number":"SJ12679735664","room_stay_from":"2021-04-04","room_stay_to":"2021-04-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"268.24,268.24,240.24,240.24","nightly_discount":"0,0,0,0","subtotal":"1016.96","grand_total":"1144.08","paid_amount":"1144.08","room_type_id":"320","product_id":"1321","siteminder_id":"EXP-1727879145","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":"111195","customer_id":"111195","source_of_creation":"Expedia","reservation_created_date":"2021-01-06 04:11:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 208+209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1262,1263","currentDayPrice":"268.24","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":"3190635","reservation_id":"104847","confirmation_number":"SJ12679359721","room_stay_from":"2021-04-04","room_stay_to":"2021-04-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"268.24,268.24,240.24,240.24","nightly_discount":"0,0,0,0","subtotal":"1016.96","grand_total":"1144.08","paid_amount":"1144.08","room_type_id":"320","product_id":"1322","siteminder_id":"EXP-1727890250","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":"111197","customer_id":"111197","source_of_creation":"Expedia","reservation_created_date":"2021-01-06 05:16:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1267,1268","currentDayPrice":"268.24","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":"3227628","reservation_id":"105574","confirmation_number":"SJ12622151053","room_stay_from":"2021-04-04","room_stay_to":"2021-04-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"184.24,184.24,156.24,156.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"680.92","grand_total":"766.04","paid_amount":"766.04","room_type_id":"319","product_id":"1942","siteminder_id":"EXP-1730985160","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":"111995","customer_id":"111995","source_of_creation":"Expedia","reservation_created_date":"2021-01-18 21:41: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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"184.24","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3189237","reservation_id":"104357","confirmation_number":"SJ12667088765","room_stay_from":"2021-04-03","room_stay_to":"2021-04-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.80,233.80,233.80,198.80,198.80,198.80","nightly_discount":"0,0,0,0,0,0","subtotal":"1325.80","grand_total":"1491.53","paid_amount":"1491.53","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1725953977","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":"110707","customer_id":"110707","source_of_creation":"Expedia","reservation_created_date":"2020-12-29 01:46:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"233.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":"3186135","reservation_id":"106309","confirmation_number":"SJ12631345302","room_stay_from":"2021-04-04","room_stay_to":"2021-04-10","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"195.30,195.30,160.30,160.30,160.30,188.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1059.80","grand_total":"1192.28","paid_amount":"1192.28","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1733272190","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":"112705","customer_id":"112705","source_of_creation":"Expedia","reservation_created_date":"2021-01-28 01:06:12","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":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.30","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":"3188742","reservation_id":"105296","confirmation_number":"SJ12640166141","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"328.30,328.30,300.30,300.30,265.30,265.30,265.30,293.30","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"2346.40","grand_total":"2639.70","paid_amount":"2639.70","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1729770005","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":"111683","customer_id":"111683","source_of_creation":"Expedia","reservation_created_date":"2021-01-13 23:56:08","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"300.30","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":"3192155","reservation_id":"106954","confirmation_number":"SJ12654770899","room_stay_from":"2021-04-03","room_stay_to":"2021-04-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.80,233.80,233.80,198.80,198.80,198.80,226.80","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1552.60","grand_total":"1746.68","paid_amount":"1746.68","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1735458935","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":"113388","customer_id":"113388","source_of_creation":"Expedia","reservation_created_date":"2021-02-05 07:00:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"233.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"}]}],"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":[{"room_stay_id":"3223571","reservation_id":"105852","confirmation_number":"SJ12644222050","room_stay_from":"2021-04-05","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"99.00,99.00","nightly_discount":"0,0","subtotal":"198.00","grand_total":"222.75","paid_amount":"222.75","room_type_id":"412","product_id":"1866","siteminder_id":"HWR-303123879","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":"112256","customer_id":"112256","source_of_creation":"Hotwire","reservation_created_date":"2021-01-22 15:25:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"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"}]},{"room_stay_id":"3191786","reservation_id":"106484","confirmation_number":"SJ12658393839","room_stay_from":"2021-04-05","room_stay_to":"2021-04-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00","nightly_discount":"0,0,0","subtotal":"297.00","grand_total":"334.13","paid_amount":"334.13","room_type_id":"319","product_id":"1943","siteminder_id":"HWR-303189164","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":"112892","customer_id":"112892","source_of_creation":"Hotwire","reservation_created_date":"2021-01-30 16:53:07","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"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":"3190655","reservation_id":"104722","confirmation_number":"SJ12627281713","room_stay_from":"2021-04-01","room_stay_to":"2021-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"3","nightly_price":"321.75,351.75,351.75,321.75,321.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1668.75","grand_total":"1877.35","paid_amount":"1877.35","room_type_id":"320","product_id":"1320","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":"111075","customer_id":"111075","source_of_creation":"FE","reservation_created_date":"2021-01-04 20:51:00","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1260,1261","currentDayPrice":"321.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":"3227044","reservation_id":"107624","confirmation_number":"SJ12678124037","room_stay_from":"2021-04-04","room_stay_to":"2021-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"296.65,296.65","nightly_discount":"0.00,0.00","subtotal":"593.30","grand_total":"667.47","paid_amount":"667.47","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":"114080","customer_id":"114080","source_of_creation":"FE","reservation_created_date":"2021-02-14 20:14:01","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"296.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3182167","reservation_id":"105771","confirmation_number":"SJ12692261223","room_stay_from":"2021-04-05","room_stay_to":"2021-04-08","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"321.75,284.25,284.25","nightly_discount":"0.00,0.00,0.00","subtotal":"890.25","grand_total":"1001.53","paid_amount":"1001.53","room_type_id":"320","product_id":"1910","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111818","customer_id":"111818","source_of_creation":"FE","reservation_created_date":"2021-01-21 02:29:47","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1309,1310","currentDayPrice":"321.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":"3190619","reservation_id":"105736","confirmation_number":"SJ12698787249","room_stay_from":"2021-04-02","room_stay_to":"2021-04-09","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"351.75,351.75,321.75,321.75,284.25,284.25,284.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2199.75","grand_total":"2474.72","paid_amount":"2474.72","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":"112130","customer_id":"112130","source_of_creation":"FE","reservation_created_date":"2021-01-20 19:49:58","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1304,1305","currentDayPrice":"321.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":"3196140","reservation_id":"107389","confirmation_number":"SJ12627980325","room_stay_from":"2021-04-05","room_stay_to":"2021-04-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.50,258.00,258.00,258.00,288.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1342.50","grand_total":"1510.32","paid_amount":"1510.32","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":"113845","customer_id":"113845","source_of_creation":"FE","reservation_created_date":"2021-02-12 00:28:39","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"280.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":"3207948","reservation_id":"107389","confirmation_number":"SJ12658466700","room_stay_from":"2021-04-05","room_stay_to":"2021-04-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.75,239.25,239.25,239.25,269.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1248.75","grand_total":"1404.85","paid_amount":"1404.85","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113845","customer_id":"113845","source_of_creation":"FE","reservation_created_date":"2021-02-12 00:28:38","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"261.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":"3228216","reservation_id":"112125","confirmation_number":"SJ12698585743","room_stay_from":"2021-07-11","room_stay_to":"2021-07-16","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.75,171.75,171.75,171.75,171.75","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"858.75","grand_total":"966.10","paid_amount":"193.22","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":"118694","customer_id":"118694","source_of_creation":"FE","reservation_created_date":"2021-04-04 23:58:34","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":"","promotion_code":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[{"room_stay_id":"3202240","reservation_id":"108184","confirmation_number":"SJ12687879513","room_stay_from":"2021-04-05","room_stay_to":"2021-04-09","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"261.75,261.75,239.25,239.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1002.00","grand_total":"1127.25","paid_amount":"0","room_type_id":"319","product_id":"1309","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114650","customer_id":"114650","source_of_creation":"FE","reservation_created_date":"2021-02-21 18:10:21","service_canceled_date_time":"2021-04-05 15:51:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"0","deltaChange":"0","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3227036","reservation_id":"107583","confirmation_number":"SJ12636266545","room_stay_from":"2021-04-04","room_stay_to":"2021-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"296.65,296.65","nightly_discount":"0.00,0.00","subtotal":"593.30","grand_total":"667.47","paid_amount":"667.47","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":"114040","customer_id":"114040","source_of_creation":"PMS","reservation_created_date":"2021-02-14 14:13:22","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"296.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3188167","reservation_id":"106521","confirmation_number":"SJ12648128637","room_stay_from":"2021-04-02","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"351.75,351.75,321.75,321.75,284.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1631.25","grand_total":"1835.15","paid_amount":"1835.15","room_type_id":"320","product_id":"1330","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112931","customer_id":"112931","source_of_creation":"PMS","reservation_created_date":"2021-01-30 22:57:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1307,1308","currentDayPrice":"321.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":"3188169","reservation_id":"106435","confirmation_number":"SJ12684423456","room_stay_from":"2021-04-02","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.25,239.25,209.25,209.25,171.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1068.75","grand_total":"1202.35","paid_amount":"1202.35","room_type_id":"319","product_id":"1306","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112933","customer_id":"112933","source_of_creation":"PMS","reservation_created_date":"2021-01-29 19:15:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"209.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":"3227046","reservation_id":"109822","confirmation_number":"SJ12681984236","room_stay_from":"2021-04-04","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"284.25,284.25,284.25","nightly_discount":"0.00,0.00,0.00","subtotal":"852.75","grand_total":"959.35","paid_amount":"959.35","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116309","customer_id":"116309","source_of_creation":"PMS","reservation_created_date":"2021-03-09 01:57:53","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"284.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":"3226058","reservation_id":"111838","confirmation_number":"SJ12682451023","room_stay_from":"2021-04-04","room_stay_to":"2021-04-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.75,261.75,261.75,246.75","nightly_discount":"26.18,26.18,26.18,24.68","subtotal":"1032.00","grand_total":"1044.88","paid_amount":"294.47","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":"118399","customer_id":"118399","source_of_creation":"PMS","reservation_created_date":"2021-04-01 19:23:10","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"special123","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"261.75","currentDayDiscount":"26.18","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3186729","reservation_id":"105522","confirmation_number":"SJ12657642008","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.25,239.25,209.25,209.25,171.75,171.75,171.75,201.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1614.00","grand_total":"1815.75","paid_amount":"1815.75","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":"111934","customer_id":"111934","source_of_creation":"PMS","reservation_created_date":"2021-01-17 20:41:56","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"209.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":"3228287","reservation_id":"111640","confirmation_number":"SJ12679279928","room_stay_from":"2021-05-05","room_stay_to":"2021-05-08","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,299.25,299.25","nightly_discount":"0.00,0.00,0.00","subtotal":"845.25","grand_total":"950.90","paid_amount":"277.59","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":"118196","customer_id":"118196","source_of_creation":"PMS","reservation_created_date":"2021-03-29 23:39:06","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":"","promotion_code":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3203017","reservation_id":"103584","confirmation_number":"SJ12638392410","room_stay_from":"2021-04-03","room_stay_to":"2021-04-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"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":"1","traveller_tax_exempt":"0","customer_traveller_id":"118564","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2020-12-07 22:41:38","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3199004","reservation_id":"107455","confirmation_number":"SJ12611730462","room_stay_from":"2021-04-05","room_stay_to":"2021-04-10","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.75,239.25,239.25,239.25,269.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1248.75","grand_total":"1404.85","paid_amount":"0","room_type_id":"319","product_id":"1310","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113910","customer_id":"113910","source_of_creation":"PMS","reservation_created_date":"2021-02-12 17:22:45","service_canceled_date_time":"2021-04-05 15:57:45","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"0","deltaChange":"0","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3196867","reservation_id":"104920","confirmation_number":"SJ12659889304","room_stay_from":"2021-04-04","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.33,113.33,113.34","nightly_discount":"0.00,0.00,0.00","subtotal":"340.00","grand_total":"340.00","paid_amount":"84.38","room_type_id":"319","product_id":"1286","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-01-07 01:08:50","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.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":"3210415","reservation_id":"107386","confirmation_number":"SJ12670355589","room_stay_from":"2021-04-04","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.33,113.33,113.33","nightly_discount":"0.00,0.00,0.00","subtotal":"339.99","grand_total":"339.99","paid_amount":"84.38","room_type_id":"319","product_id":"1276","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":"2021-02-12 00:15:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.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":"3211128","reservation_id":"106969","confirmation_number":"SJ12631038519","room_stay_from":"2021-04-02","room_stay_to":"2021-04-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.57,165.57,165.57,165.57,165.57,165.57,165.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1159.00","grand_total":"1159.00","paid_amount":"0.00","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-02-05 18:04:31","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"165.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3226084","reservation_id":"107579","confirmation_number":"SJ12669056485","room_stay_from":"2021-04-04","room_stay_to":"2021-04-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"570.00","grand_total":"570.00","paid_amount":"140.63","room_type_id":"319","product_id":"1274","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":"2021-02-14 11:15:10","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.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":"3198473","reservation_id":"107652","confirmation_number":"SJ12630687033","room_confirmation_number":"SJ12615056158","room_stay_from":"2021-04-03","room_stay_to":"2021-04-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":"114111","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-15 18:35:14","reservation_modified_date_time":"2021-02-15 18:35:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114111","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","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":"3202937","reservation_id":"107652","confirmation_number":"SJ12682111443","room_confirmation_number":"SJ12694345132","room_stay_from":"2021-04-03","room_stay_to":"2021-04-06","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"114111","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-22 20:19:07","reservation_modified_date_time":"2021-02-22 20:19:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114111","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3228097","reservation_id":"112120","confirmation_number":"SJ12684107490","room_confirmation_number":"SJ12654845176","room_stay_from":"2021-04-05","room_stay_to":"2021-04-06","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":"118689","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-04-04 22:42:12","reservation_modified_date_time":"2021-04-04 22:42:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118689","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","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":"3187211","reservation_id":"106124","confirmation_number":"SJ12664475305","room_confirmation_number":"SJ12671153111","room_stay_from":"2021-03-30","room_stay_to":"2021-04-06","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":"112541","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 01:34:07","reservation_modified_date_time":"2021-01-29 19:02:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112541","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3190658","reservation_id":"104722","confirmation_number":"SJ12625779531","room_confirmation_number":"SJ12627281713","room_stay_from":"2021-04-01","room_stay_to":"2021-04-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":"111075","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-04 20:51:00","reservation_modified_date_time":"2021-02-02 22:20:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111075","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3198474","reservation_id":"107652","confirmation_number":"SJ12650229017","room_confirmation_number":"SJ12615056158","room_stay_from":"2021-04-03","room_stay_to":"2021-04-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":"114111","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-15 02:55:29","reservation_modified_date_time":"2021-02-15 18:35:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114111","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","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":"3202938","reservation_id":"107652","confirmation_number":"SJ12642914244","room_confirmation_number":"SJ12694345132","room_stay_from":"2021-04-03","room_stay_to":"2021-04-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":"114111","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-15 02:55:24","reservation_modified_date_time":"2021-02-22 20:19:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114111","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3225742","reservation_id":"111808","confirmation_number":"SJ12684211656","room_confirmation_number":"SJ12627155802","room_stay_from":"2021-04-05","room_stay_to":"2021-04-06","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":"118365","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-01 04:07:10","reservation_modified_date_time":"2021-04-01 04:07:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118365","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3227037","reservation_id":"107583","confirmation_number":"SJ12664667719","room_confirmation_number":"SJ12636266545","room_stay_from":"2021-04-04","room_stay_to":"2021-04-06","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":"114040","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 14:13:22","reservation_modified_date_time":"2021-04-03 15:46:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114040","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3227045","reservation_id":"107624","confirmation_number":"SJ12684369887","room_confirmation_number":"SJ12678124037","room_stay_from":"2021-04-04","room_stay_to":"2021-04-06","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":"114080","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 20:14:01","reservation_modified_date_time":"2021-04-03 15:51:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114080","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3228098","reservation_id":"112120","confirmation_number":"SJ12610855133","room_confirmation_number":"SJ12654845176","room_stay_from":"2021-04-05","room_stay_to":"2021-04-06","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":"118689","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-04 22:42:12","reservation_modified_date_time":"2021-04-04 22:42:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118689","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","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":"3187247","reservation_id":"105744","confirmation_number":"SJ12651163686","room_confirmation_number":"SJ12664152263","room_stay_from":"2021-04-05","room_stay_to":"2021-04-07","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":"112140","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-20 21:41:09","reservation_modified_date_time":"2021-01-29 19:07:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112140","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3188166","reservation_id":"106521","confirmation_number":"SJ12687145113","room_confirmation_number":"SJ12648128637","room_stay_from":"2021-04-02","room_stay_to":"2021-04-07","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":"112931","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-30 22:57:13","reservation_modified_date_time":"2021-01-30 22:58:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112931","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3188168","reservation_id":"106435","confirmation_number":"SJ12623898262","room_confirmation_number":"SJ12684423456","room_stay_from":"2021-04-02","room_stay_to":"2021-04-07","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":"112933","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 19:15:32","reservation_modified_date_time":"2021-01-30 23:00:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112933","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3196869","reservation_id":"104920","confirmation_number":"SJ12657724756","room_confirmation_number":"SJ12659889304","room_stay_from":"2021-04-04","room_stay_to":"2021-04-07","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":"111276","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-07 01:08:50","reservation_modified_date_time":"2021-02-12 20:04:08","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3200815","reservation_id":"107957","confirmation_number":"SJ12682986397","room_confirmation_number":"SJ12632080324","room_stay_from":"2021-04-03","room_stay_to":"2021-04-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":"114423","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-18 12:52:24","reservation_modified_date_time":"2021-02-19 02:33:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114423","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3210416","reservation_id":"107386","confirmation_number":"SJ12695488275","room_confirmation_number":"SJ12670355589","room_stay_from":"2021-04-04","room_stay_to":"2021-04-07","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":"113842","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 00:15:10","reservation_modified_date_time":"2021-03-06 18:54:56","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3223572","reservation_id":"105852","confirmation_number":"SJ12615116362","room_confirmation_number":"SJ12644222050","room_stay_from":"2021-04-05","room_stay_to":"2021-04-07","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":"112256","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-22 15:25:11","reservation_modified_date_time":"2021-03-27 20:20:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112256","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3223594","reservation_id":"107327","confirmation_number":"SJ12697442895","room_confirmation_number":"SJ12677941040","room_stay_from":"2021-03-29","room_stay_to":"2021-04-07","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":"113785","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-11 02:54:11","reservation_modified_date_time":"2021-03-27 20:24:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113785","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3224266","reservation_id":"108204","confirmation_number":"SJ12687375273","room_confirmation_number":"SJ12647250748","room_stay_from":"2021-04-05","room_stay_to":"2021-04-07","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":"114668","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-21 20:38:18","reservation_modified_date_time":"2021-03-28 20:46:27","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114668","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3226066","reservation_id":"110924","confirmation_number":"SJ12660084057","room_confirmation_number":"SJ12692050848","room_stay_from":"2021-04-04","room_stay_to":"2021-04-07","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":"118717","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-21 22:17:07","reservation_modified_date_time":"2021-04-01 19:27:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117457","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3227047","reservation_id":"109822","confirmation_number":"SJ12615564284","room_confirmation_number":"SJ12681984236","room_stay_from":"2021-04-04","room_stay_to":"2021-04-07","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":"116309","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-09 01:57:53","reservation_modified_date_time":"2021-04-03 15:51:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116309","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3227993","reservation_id":"112107","confirmation_number":"SJ12685288576","room_confirmation_number":"SJ12658842540","room_stay_from":"2021-04-05","room_stay_to":"2021-04-07","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":"118674","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-04 19:25:10","reservation_modified_date_time":"2021-04-04 19:25:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118674","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3174888","reservation_id":"104845","confirmation_number":"SJ12693529877","room_confirmation_number":"SJ12679735664","room_stay_from":"2021-04-04","room_stay_to":"2021-04-08","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":"111195","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-06 04:11:11","reservation_modified_date_time":"2021-01-06 04:11:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111195","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3182168","reservation_id":"105771","confirmation_number":"SJ12627214686","room_confirmation_number":"SJ12692261223","room_stay_from":"2021-04-05","room_stay_to":"2021-04-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"111818","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-21 02:29:47","reservation_modified_date_time":"2021-01-21 02:29:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111818","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3190638","reservation_id":"104847","confirmation_number":"SJ12615239289","room_confirmation_number":"SJ12679359721","room_stay_from":"2021-04-04","room_stay_to":"2021-04-08","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":"111197","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-06 05:16:10","reservation_modified_date_time":"2021-02-02 22:18:49","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111197","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3191787","reservation_id":"106484","confirmation_number":"SJ12691497455","room_confirmation_number":"SJ12658393839","room_stay_from":"2021-04-05","room_stay_to":"2021-04-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"112892","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-30 16:53:07","reservation_modified_date_time":"2021-02-04 20:24:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112892","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3192082","reservation_id":"106937","confirmation_number":"SJ12668722382","room_confirmation_number":"SJ12660023131","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"113372","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 01:26:08","reservation_modified_date_time":"2021-02-05 01:26:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113372","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3214600","reservation_id":"110154","confirmation_number":"SJ12673289553","room_confirmation_number":"SJ12696259719","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"116661","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-12 19:17:08","reservation_modified_date_time":"2021-03-12 19:17:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116661","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3226059","reservation_id":"111838","confirmation_number":"SJ12664325044","room_confirmation_number":"SJ12682451023","room_stay_from":"2021-04-04","room_stay_to":"2021-04-08","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":"118399","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-01 19:23:10","reservation_modified_date_time":"2021-04-01 19:24:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118399","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3227629","reservation_id":"105574","confirmation_number":"SJ12664194356","room_confirmation_number":"SJ12622151053","room_stay_from":"2021-04-04","room_stay_to":"2021-04-08","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":"111995","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 21:41:10","reservation_modified_date_time":"2021-04-04 12:57:29","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111995","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3094785","reservation_id":"94955","confirmation_number":"SJ12647908150","room_confirmation_number":"SJ12612653129","room_stay_from":"2021-04-05","room_stay_to":"2021-04-09","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"101144","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 15:20:11","reservation_modified_date_time":"2020-05-18 15:20:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101144","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3189238","reservation_id":"104357","confirmation_number":"SJ12660626167","room_confirmation_number":"SJ12667088765","room_stay_from":"2021-04-03","room_stay_to":"2021-04-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":"110707","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-29 01:46:10","reservation_modified_date_time":"2021-02-01 17:48:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110707","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3190622","reservation_id":"105736","confirmation_number":"SJ12625542052","room_confirmation_number":"SJ12698787249","room_stay_from":"2021-04-02","room_stay_to":"2021-04-09","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":"112130","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-20 19:49:58","reservation_modified_date_time":"2021-02-02 22:15:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112130","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3203018","reservation_id":"103584","confirmation_number":"SJ12681911103","room_confirmation_number":"SJ12638392410","room_stay_from":"2021-04-03","room_stay_to":"2021-04-09","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103072","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-07 22:41:38","reservation_modified_date_time":"2021-02-22 21:21:13","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3211127","reservation_id":"106969","confirmation_number":"SJ12678619010","room_confirmation_number":"SJ12631038519","room_stay_from":"2021-04-02","room_stay_to":"2021-04-09","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":"113402","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 18:04:31","reservation_modified_date_time":"2021-03-07 15:18:15","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3226085","reservation_id":"107579","confirmation_number":"SJ12628266237","room_confirmation_number":"SJ12669056485","room_stay_from":"2021-04-04","room_stay_to":"2021-04-09","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114036","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 11:15:10","reservation_modified_date_time":"2021-04-01 19:33:53","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3186136","reservation_id":"106309","confirmation_number":"SJ12630283334","room_confirmation_number":"SJ12631345302","room_stay_from":"2021-04-04","room_stay_to":"2021-04-10","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":"112705","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 01:06:12","reservation_modified_date_time":"2021-01-28 01:06:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112705","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3186730","reservation_id":"105522","confirmation_number":"SJ12613505401","room_confirmation_number":"SJ12657642008","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111934","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-17 20:41:56","reservation_modified_date_time":"2021-01-29 02:55:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111934","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3188745","reservation_id":"105296","confirmation_number":"SJ12614024808","room_confirmation_number":"SJ12640166141","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111683","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-13 23:56:08","reservation_modified_date_time":"2021-01-31 20:39:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111683","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3191789","reservation_id":"106746","confirmation_number":"SJ12623293913","room_confirmation_number":"SJ12655644327","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113167","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-02 18:16:10","reservation_modified_date_time":"2021-02-04 20:25:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113167","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3192156","reservation_id":"106954","confirmation_number":"SJ12687922139","room_confirmation_number":"SJ12654770899","room_stay_from":"2021-04-03","room_stay_to":"2021-04-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":"113388","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 07:00:10","reservation_modified_date_time":"2021-02-05 07:00:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113388","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3196141","reservation_id":"107389","confirmation_number":"SJ12616637387","room_confirmation_number":"SJ12627980325","room_stay_from":"2021-04-05","room_stay_to":"2021-04-10","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.62","paid_amount":"140.62","product_id":"1776","service_quantity":"1","customer_traveller_id":"113845","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 00:28:39","reservation_modified_date_time":"2021-02-12 00:28:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113845","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3202107","reservation_id":"107993","confirmation_number":"SJ12652369336","room_confirmation_number":"SJ12664003835","room_stay_from":"2021-04-04","room_stay_to":"2021-04-10","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":"114455","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-18 18:43:24","reservation_modified_date_time":"2021-02-21 15:56:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114455","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3207949","reservation_id":"107389","confirmation_number":"SJ12643616614","room_confirmation_number":"SJ12658466700","room_stay_from":"2021-04-05","room_stay_to":"2021-04-10","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":"113845","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 00:28:38","reservation_modified_date_time":"2021-03-03 17:12:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113845","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3215078","reservation_id":"110212","confirmation_number":"SJ12668527617","room_confirmation_number":"SJ12640729143","room_stay_from":"2021-04-04","room_stay_to":"2021-04-10","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":"116725","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-13 17:46:13","reservation_modified_date_time":"2021-03-13 17:46:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116725","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3221780","reservation_id":"109959","confirmation_number":"SJ12672103009","room_confirmation_number":"SJ12662063432","room_stay_from":"2021-04-05","room_stay_to":"2021-04-10","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":"116453","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-10 15:02:10","reservation_modified_date_time":"2021-03-24 16:39:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116453","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3228765","reservation_id":"105343","confirmation_number":"SJ12680069244","room_confirmation_number":"SJ12661931586","room_stay_from":"2021-04-05","room_stay_to":"2021-04-13","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111728","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 20:38:10","reservation_modified_date_time":"2021-04-06 01:14:16","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111728","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3228217","reservation_id":"112125","confirmation_number":"SJ12670557490","room_confirmation_number":"SJ12698585743","room_stay_from":"2021-07-11","room_stay_to":"2021-07-16","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":"118694","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-04 23:58:34","reservation_modified_date_time":"2021-04-05 12:59:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118694","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3228288","reservation_id":"111640","confirmation_number":"SJ12631264525","room_confirmation_number":"SJ12679279928","room_stay_from":"2021-05-05","room_stay_to":"2021-05-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"118196","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-29 23:39:06","reservation_modified_date_time":"2021-04-05 15:22:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118196","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3228362","reservation_id":"112110","confirmation_number":"SJ12649204461","room_confirmation_number":"SJ12629852659","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"118678","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-04 19:47:26","reservation_modified_date_time":"2021-04-05 16:36:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118678","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3228499","reservation_id":"112124","confirmation_number":"SJ12685166691","room_confirmation_number":"SJ12617525714","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","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":"118693","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-04 23:35:17","reservation_modified_date_time":"2021-04-05 18:34:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118693","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3228450","reservation_id":"110468","confirmation_number":"SJ12639270976","room_confirmation_number":"SJ12669764845","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1710","service_quantity":"2","product_name":"Late Departure Check-Out","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-05 16:24:47","reservation_modified_date_time":"2021-04-05 17:58:04","customer_id":"116982","parentCustTravId":"116982","customer_traveller_id":"116982","static_pos_type":"latecheckoutfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-04-03","sub_hotel_id":"126","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"106","tax_name":"Lodging Tax","tax_percentage":"12.50"}]},{"room_stay_id":"3228524","reservation_id":"112173","confirmation_number":"SJ12684557074","room_confirmation_number":"SJ12639453954","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"7.00","paid_amount":"7.00","product_id":"2073","service_quantity":"1","product_name":"Face Mask","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-05 18:42:24","reservation_modified_date_time":"2021-04-05 18:42:24","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":"2.79","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"9.30","currentDayDiscount":"2.79","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":[]}}