{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-06-24","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":15,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1306","block_room_bookings":[{"confirmation_number":"SJ12697968136","room_stay_from":"2021-06-24","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1306"}],"bundle_block_count":"1267,1268,1309,1310,1271,1272,1302,1303,1269,1270,1307,1308,1304,1305,1311,1312,1260,1261,1262,1263,1291,1711","bundle_block_bookings":[{"confirmation_number":"SJB12627470219","room_stay_from":"2021-06-18","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12621831691","room_stay_from":"2021-06-18","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12642074276","room_stay_from":"2021-06-24","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12664553777","room_stay_from":"2021-06-24","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12676244812","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12673500549","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12695219115","room_stay_from":"2021-06-21","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12670775139","room_stay_from":"2021-06-21","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12669939732","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12623484702","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12689618963","room_stay_from":"2021-06-19","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12668426996","room_stay_from":"2021-06-19","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12619200530","room_stay_from":"2021-06-24","room_stay_to":"2021-06-25","bundle_room":"1","product_id":"1329"},{"confirmation_number":"SJB12695826466","room_stay_from":"2021-06-19","room_stay_to":"2021-06-26","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12680126055","room_stay_from":"2021-06-19","room_stay_to":"2021-06-26","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12618487477","room_stay_from":"2021-06-23","room_stay_to":"2021-06-27","bundle_room":"0","product_id":"1260"},{"confirmation_number":"SJB12674297824","room_stay_from":"2021-06-23","room_stay_to":"2021-06-27","bundle_room":"0","product_id":"1261"},{"confirmation_number":"SJB12682128059","room_stay_from":"2021-06-24","room_stay_to":"2021-06-27","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJB12644413773","room_stay_from":"2021-06-24","room_stay_to":"2021-06-27","bundle_room":"0","product_id":"1263"},{"confirmation_number":"SJB12610024396","room_stay_from":"2021-06-24","room_stay_to":"2021-06-27","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12618831484","room_stay_from":"2021-06-24","room_stay_to":"2021-06-27","bundle_room":"0","product_id":"1711"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3183859","reservation_id":"106015","confirmation_number":"SJ12685534994","room_stay_from":"2021-06-18","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"272.30,272.30,230.30,230.30,230.30,230.30,230.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1696.10","grand_total":"1908.12","paid_amount":"1908.12","room_type_id":"320","product_id":"1322","siteminder_id":"BDC-3756311611","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":"112438","customer_id":"112438","source_of_creation":"Booking.com","reservation_created_date":"2021-01-24 21:59:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"336.80","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1267,1268","currentDayPrice":"230.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":"3230260","reservation_id":"107409","confirmation_number":"SJ12666572414","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"265.50,265.50,265.50","nightly_discount":"0,0,0","subtotal":"796.50","grand_total":"896.07","paid_amount":"896.07","room_type_id":"320","product_id":"1324","siteminder_id":"BDC-2751648204","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":"113867","customer_id":"113867","source_of_creation":"Booking.com","reservation_created_date":"2021-02-12 03:22:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"156.87","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1271,1272","currentDayPrice":"265.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":"3230410","reservation_id":"112413","confirmation_number":"SJ12641246500","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"146.85,146.85,169.53,169.53,186.54","nightly_discount":"0,0,0,0,0","subtotal":"819.30","grand_total":"921.72","paid_amount":"921.72","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-2592988668","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":"118986","customer_id":"118986","source_of_creation":"Booking.com","reservation_created_date":"2021-04-08 02:15:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"352.71","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"186.54","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3230412","reservation_id":"112413","confirmation_number":"SJ12623893989","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"161.03,161.03,183.71,183.71,200.72","nightly_discount":"0,0,0,0,0","subtotal":"890.20","grand_total":"1001.48","paid_amount":"1001.48","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-2592988668","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":"118986","customer_id":"118986","source_of_creation":"Booking.com","reservation_created_date":"2021-04-08 02:15:29","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"352.71","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"200.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":"3232393","reservation_id":"112655","confirmation_number":"SJ12656158758","room_stay_from":"2021-06-21","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"195.30,230.30,230.30,230.30","nightly_discount":"0,0,0,0","subtotal":"886.20","grand_total":"996.98","paid_amount":"996.98","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3031296597","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":"119242","customer_id":"119242","source_of_creation":"Booking.com","reservation_created_date":"2021-04-11 03:39:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"177.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.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":"3251905","reservation_id":"112384","confirmation_number":"SJ12614910525","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.85,146.85,169.53,169.53,186.54","nightly_discount":"0,0,0,0,0","subtotal":"819.30","grand_total":"921.72","paid_amount":"921.72","room_type_id":"319","product_id":"1314","siteminder_id":"BDC-3475142648","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":"118956","customer_id":"118956","source_of_creation":"Booking.com","reservation_created_date":"2021-04-07 20:56:39","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"169.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"186.54","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3251909","reservation_id":"112382","confirmation_number":"SJ12656012249","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"214.89,214.89,237.57,237.57,254.58","nightly_discount":"0,0,0,0,0","subtotal":"1159.50","grand_total":"1304.44","paid_amount":"1304.44","room_type_id":"320","product_id":"1323","siteminder_id":"BDC-2760166081","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":"118955","customer_id":"118955","source_of_creation":"Booking.com","reservation_created_date":"2021-04-07 20:45:17","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"231.20","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1269,1270","currentDayPrice":"254.58","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":"3271365","reservation_id":"112385","confirmation_number":"SJ12682275778","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.85,146.85,169.53,169.53,186.54","nightly_discount":"0,0,0,0,0","subtotal":"819.30","grand_total":"921.72","paid_amount":"921.72","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-3214014144","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":"118957","customer_id":"118957","source_of_creation":"Booking.com","reservation_created_date":"2021-04-07 21:00:13","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"169.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"186.54","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3271981","reservation_id":"117848","confirmation_number":"SJ12613472947","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,299.25,299.25","nightly_discount":"0,0,0","subtotal":"897.75","grand_total":"1009.97","paid_amount":"1009.97","room_type_id":"319","product_id":"1304","siteminder_id":"BDC-2767202322","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":"124833","customer_id":"124825","source_of_creation":"Booking.com","reservation_created_date":"2021-06-22 19:18:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"175.09","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"299.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":"3273134","reservation_id":"118010","confirmation_number":"SJ12680175738","room_stay_from":"2021-06-24","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"284.14","nightly_discount":"0","subtotal":"284.14","grand_total":"319.66","paid_amount":"319.66","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-3259022448","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125000","customer_id":"125000","source_of_creation":"Booking.com","reservation_created_date":"2021-06-24 22:10:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"60.15","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"284.14","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":"3227106","reservation_id":"110720","confirmation_number":"SJ12613155638","room_stay_from":"2021-06-22","room_stay_to":"2021-06-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"195.30,195.30,195.30,223.30","nightly_discount":"0,0,0,0","subtotal":"809.20","grand_total":"910.35","paid_amount":"910.35","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-2878775983","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":"117231","customer_id":"117231","source_of_creation":"Booking.com","reservation_created_date":"2021-03-19 15:46:20","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"163.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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":"3227130","reservation_id":"108321","confirmation_number":"SJ12659982746","room_stay_from":"2021-06-24","room_stay_to":"2021-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"246.75,291.75,291.75","nightly_discount":"0,0,0","subtotal":"830.25","grand_total":"934.03","paid_amount":"934.03","room_type_id":"320","product_id":"1321","siteminder_id":"BDC-3005990463","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":"114776","customer_id":"114776","source_of_creation":"Booking.com","reservation_created_date":"2021-02-22 23:53:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 208+209","ota_service_fee_amount":"0","commision_charges":"162.94","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1262,1263","currentDayPrice":"246.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":"3217509","reservation_id":"110509","confirmation_number":"SJ12631801725","room_stay_from":"2021-06-24","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"261.80,289.80,310.80,261.80","nightly_discount":"0,0,0,0","subtotal":"1124.20","grand_total":"1264.73","paid_amount":"1264.73","room_type_id":"320","product_id":"1910","siteminder_id":"BDC-2680617338","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":"117020","customer_id":"117020","source_of_creation":"Booking.com","reservation_created_date":"2021-03-17 14:27:15","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":"126","group_rooms":"1309,1310","currentDayPrice":"261.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":"3272840","reservation_id":"117931","confirmation_number":"SJ12627851050","room_stay_from":"2021-12-28","room_stay_to":"2022-01-07","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"319.20,319.20,319.20,351.20,351.20,239.20,239.20,239.20,239.20,239.20","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"2856.00","grand_total":"3213.00","paid_amount":"359.10","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-2780634819","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":"124924","customer_id":"124924","source_of_creation":"Booking.com","reservation_created_date":"2021-06-24 00:04:31","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":"","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":"3272953","reservation_id":"117592","confirmation_number":"SJ12634469415","room_stay_from":"2021-06-23","room_stay_to":"2021-06-24","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"267.12","nightly_discount":"0","subtotal":"267.12","grand_total":"300.51","paid_amount":"300.51","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-2427937856","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":"124963","customer_id":"124963","source_of_creation":"Booking.com","reservation_created_date":"2021-06-18 23:27:12","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"52.58","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3264814","reservation_id":"116732","confirmation_number":"SJ12613355067","room_stay_from":"2021-06-21","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.08,178.08,178.08,178.08","nightly_discount":"0,0,0,0","subtotal":"712.32","grand_total":"801.36","paid_amount":"801.36","room_type_id":"319","product_id":"1943","siteminder_id":"EXP-1781746424","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":"123635","customer_id":"123635","source_of_creation":"Expedia","reservation_created_date":"2021-06-07 17:21:19","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":"178.08","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":"3206922","reservation_id":"108957","confirmation_number":"SJ12698893079","room_stay_from":"2021-06-19","room_stay_to":"2021-06-26","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"3","nightly_price":"303.3,254.3,254.3,254.3,254.3,254.3,282.3","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1857.10","grand_total":"2089.24","paid_amount":"2089.24","room_type_id":"320","product_id":"1332","siteminder_id":"EXP-1742852571","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"175.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115419","customer_id":"115419","source_of_creation":"Expedia","reservation_created_date":"2021-03-01 20:32:12","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"254.3","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":"3273101","reservation_id":"116274","confirmation_number":"SJ12655806025","room_stay_from":"2021-06-24","room_stay_to":"2021-06-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.56,271.36","nightly_discount":"0.00,0.00","subtotal":"497.92","grand_total":"560.16","paid_amount":"560.16","room_type_id":"413","product_id":"1273","siteminder_id":"EXP-1778558988","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":"123133","customer_id":"123133","source_of_creation":"Expedia","reservation_created_date":"2021-05-31 21:06:28","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","currentDayPrice":"226.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3215097","reservation_id":"110208","confirmation_number":"SJ12693047496","room_stay_from":"2021-06-23","room_stay_to":"2021-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"114.44,114.44,136.84,153.64","nightly_discount":"0,0,0,0","subtotal":"519.36","grand_total":"584.28","paid_amount":"584.28","room_type_id":"319","product_id":"1942","siteminder_id":"EXP-1747160040","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":"116720","customer_id":"116720","source_of_creation":"Expedia","reservation_created_date":"2021-03-13 16:42:14","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":"114.44","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":"3227126","reservation_id":"105177","confirmation_number":"SJ12629292463","room_stay_from":"2021-06-23","room_stay_to":"2021-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"265.30,265.30,307.30,307.30","nightly_discount":"0,0,0,0","subtotal":"1145.20","grand_total":"1288.35","paid_amount":"1288.35","room_type_id":"320","product_id":"1320","siteminder_id":"EXP-1729151840","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":"111551","customer_id":"111551","source_of_creation":"Expedia","reservation_created_date":"2021-01-11 16:36:11","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":"126","group_rooms":"1260,1261","currentDayPrice":"265.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":"3272851","reservation_id":"115703","confirmation_number":"SJ12624300069","room_stay_from":"2021-06-24","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"223.44,257.04,257.04,212.24","nightly_discount":"0,0,0,0","subtotal":"949.76","grand_total":"1068.48","paid_amount":"1068.48","room_type_id":"319","product_id":"1313","siteminder_id":"EXP-1774597664","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":"122477","customer_id":"122477","source_of_creation":"Expedia","reservation_created_date":"2021-05-23 00:41:10","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"223.44","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":"3272812","reservation_id":"117926","confirmation_number":"SJ12619829057","room_stay_from":"2022-02-22","room_stay_to":"2022-02-25","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"186.75,186.75,201.75","nightly_discount":"0,0,0","subtotal":"575.25","grand_total":"647.15","paid_amount":"210.10","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1790176984","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":"124918","customer_id":"124918","source_of_creation":"Expedia","reservation_created_date":"2021-06-23 22:51:30","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3273047","reservation_id":"117987","confirmation_number":"SJ12636280895","room_stay_from":"2021-06-24","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"236.28","nightly_discount":"0","subtotal":"236.28","grand_total":"265.81","paid_amount":"265.81","room_type_id":"319","product_id":"1305","siteminder_id":"HTN-165284717-7ZZC3W","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":"124981","customer_id":"124981","source_of_creation":"HotelTonight","reservation_created_date":"2021-06-24 18:50:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","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","currentDayPrice":"236.28","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3272469","reservation_id":"108220","confirmation_number":"SJ12695602736","room_stay_from":"2021-06-23","room_stay_to":"2021-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.48,96.48,128.82,128.82","nightly_discount":"0,0,0,0","subtotal":"450.60","grand_total":"506.93","paid_amount":"506.93","room_type_id":"412","product_id":"1315","siteminder_id":"GAM-R2340865257","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":"114684","customer_id":"114684","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-21 23:10:09","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":"96.48","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3270270","reservation_id":"108519","confirmation_number":"SJ12679730734","room_stay_from":"2021-06-19","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"319.27,330.99,330.99,330.99,330.99,330.99","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1974.22","grand_total":"2287.84","paid_amount":"2287.84","room_type_id":"320","product_id":"1330","siteminder_id":"ABB-HM5E8BSN2A","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1985.94","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114959","customer_id":"114959","source_of_creation":"Airbnb","reservation_created_date":"2021-02-25 05:04:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"58.41","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"330.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3221870","reservation_id":"111202","confirmation_number":"SJ12637915642","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"194.25,194.25,194.25","nightly_discount":"0.00,0.00,0.00","subtotal":"582.75","grand_total":"655.60","paid_amount":"655.60","room_type_id":"319","product_id":"1301","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117736","customer_id":"117736","source_of_creation":"FE","reservation_created_date":"2021-03-24 20:21:38","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":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"194.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":"3237878","reservation_id":"113451","confirmation_number":"SJ12674373034","room_stay_from":"2021-06-21","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"4","nightly_price":"299.25,336.75,336.75,336.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1309.50","grand_total":"1473.19","paid_amount":"1473.19","room_type_id":"320","product_id":"1328","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120043","customer_id":"120043","source_of_creation":"FE","reservation_created_date":"2021-04-20 01:58:46","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":"0","group_rooms":"1302,1303","currentDayPrice":"336.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":"3272971","reservation_id":"108988","confirmation_number":"SJ12691624252","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"190.50,190.50,190.50,190.50,190.50","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"952.50","grand_total":"1071.57","paid_amount":"1071.57","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":"115443","customer_id":"115443","source_of_creation":"FE","reservation_created_date":"2021-03-02 01:28:37","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"190.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":"3273126","reservation_id":"117596","confirmation_number":"SJ12618357615","room_stay_from":"2021-06-24","room_stay_to":"2021-06-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"360.40,411.40","nightly_discount":"18.02,20.57","subtotal":"771.80","grand_total":"824.86","paid_amount":"824.86","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":"124565","customer_id":"124565","source_of_creation":"FE","reservation_created_date":"2021-06-19 01:03:37","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":"AAA","sub_hotel_id":"0","currentDayPrice":"360.40","currentDayDiscount":"18.02","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3268951","reservation_id":"108234","confirmation_number":"SJ12681402852","room_stay_from":"2021-06-24","room_stay_to":"2021-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.25,134.25,134.25","nightly_discount":"0.00,0,0","subtotal":"402.75","grand_total":"453.10","paid_amount":"453.10","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114700","customer_id":"114700","source_of_creation":"FE","reservation_created_date":"2021-02-22 01:28:21","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":"0","group_rooms":null,"currentDayPrice":"134.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":"3272969","reservation_id":"112210","confirmation_number":"SJ12619287066","room_stay_from":"2021-06-23","room_stay_to":"2021-06-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"265.50,295.50,295.50,213.00,213.00,213.00,213.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1708.50","grand_total":"1922.07","paid_amount":"1922.07","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":"118776","customer_id":"118776","source_of_creation":"FE","reservation_created_date":"2021-04-05 23:52:28","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","currentDayPrice":"295.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3210811","reservation_id":"109624","confirmation_number":"SJ12650865253","room_stay_from":"2021-06-18","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"185.30,185.30,185.30,185.30,185.30,185.30,185.30","nightly_discount":"9.27,9.27,9.27,9.27,9.27,9.27,9.27","subtotal":"1297.10","grand_total":"1386.24","paid_amount":"1386.24","room_type_id":"319","product_id":"1286","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"75782","customer_id":"75782","source_of_creation":"PMS","reservation_created_date":"2021-03-06 23:19:39","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":"FLRES","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"185.30","currentDayDiscount":"9.27","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3231013","reservation_id":"112480","confirmation_number":"SJ12651077260","room_stay_from":"2021-06-23","room_stay_to":"2021-06-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.75,224.25,254.25","nightly_discount":"10.09,11.21,12.71","subtotal":"680.25","grand_total":"727.02","paid_amount":"727.02","room_type_id":"413","product_id":"1265","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":"119053","customer_id":"119053","source_of_creation":"PMS","reservation_created_date":"2021-04-09 00:08:32","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":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"224.25","currentDayDiscount":"11.21","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3273094","reservation_id":"118002","confirmation_number":"SJ12634078006","room_stay_from":"2021-06-24","room_stay_to":"2021-06-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"360.40,411.40","nightly_discount":"0.00,0.00","subtotal":"771.80","grand_total":"868.28","paid_amount":"868.28","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":"124992","customer_id":"124992","source_of_creation":"PMS","reservation_created_date":"2021-06-24 21:02:45","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":"","sub_hotel_id":"0","currentDayPrice":"360.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202488","reservation_id":"108236","confirmation_number":"SJ12693421970","room_stay_from":"2021-06-23","room_stay_to":"2021-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"156.75,156.75,201.75,201.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"717.00","grand_total":"806.63","paid_amount":"806.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":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114703","customer_id":"114703","source_of_creation":"PMS","reservation_created_date":"2021-02-22 01:50:21","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":"156.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":"3273117","reservation_id":"108530","confirmation_number":"SJ12691009691","room_stay_from":"2021-06-24","room_stay_to":"2021-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"1","nightly_price":"261.75,291.75,314.25","nightly_discount":"13.09,14.59,15.71","subtotal":"867.75","grand_total":"927.41","paid_amount":"927.41","room_type_id":"320","product_id":"1714","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114968","customer_id":"114968","source_of_creation":"PMS","reservation_created_date":"2021-02-25 13:40:46","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":"AAA","sub_hotel_id":"0","currentDayPrice":"261.75","currentDayDiscount":"13.09","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3271031","reservation_id":"112261","confirmation_number":"SJ12691116073","room_stay_from":"2021-06-24","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,276.75,276.75,194.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"994.50","grand_total":"1118.82","paid_amount":"1118.82","room_type_id":"412","product_id":"1294","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":"118836","customer_id":"118836","source_of_creation":"PMS","reservation_created_date":"2021-04-06 18:45:26","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"246.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3208265","reservation_id":"109190","confirmation_number":"SJ12641075542","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","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":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 20:02:50","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":"86.67","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":"3208267","reservation_id":"109191","confirmation_number":"SJ12657847331","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1277","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":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 20:06:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","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":"86.67","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":"3271395","reservation_id":"108355","confirmation_number":"SJ12681599348","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0,0","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"318","product_id":"1281","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":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-23 02:01:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3272023","reservation_id":"110998","confirmation_number":"SJ12618422665","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1275","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":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-22 19:15:34","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","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":"3208292","reservation_id":"109194","confirmation_number":"SJ12673488560","room_stay_from":"2021-06-23","room_stay_to":"2021-06-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 20:31:42","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":"86.67","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":"3208304","reservation_id":"109195","confirmation_number":"SJ12610788862","room_stay_from":"2021-06-23","room_stay_to":"2021-06-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 20:35:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","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":"3214303","reservation_id":"110116","confirmation_number":"SJ12677911713","room_stay_from":"2021-06-23","room_stay_to":"2021-06-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-12 02:55:25","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":"86.67","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":"3272379","reservation_id":"110115","confirmation_number":"SJ12628536124","room_stay_from":"2021-06-23","room_stay_to":"2021-06-26","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-12 02:54:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","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":"3250996","reservation_id":"110133","confirmation_number":"SJ12677971177","room_stay_from":"2021-06-20","room_stay_to":"2021-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.71,106.71,106.71,106.71,106.71,106.71,106.74","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"747.00","grand_total":"747.00","paid_amount":"0.00","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"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-03-12 13:11:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"106.71","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":"3251000","reservation_id":"110701","confirmation_number":"SJ12677229694","room_stay_from":"2021-06-20","room_stay_to":"2021-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.71,106.71,106.71,106.71,106.71,106.71,106.74","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"747.00","grand_total":"747.00","paid_amount":"0.00","room_type_id":"319","product_id":"1917","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-03-19 13:51:23","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":"106.71","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":"3273067","reservation_id":"109321","confirmation_number":"SJ12626151709","room_stay_from":"2021-06-24","room_stay_to":"2021-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1915","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-04 14:50:18","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":"0","currentDayPrice":"86.67","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":"3271375","reservation_id":"108377","confirmation_number":"SJ12627707689","room_stay_from":"2021-06-23","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0,0,0,0","subtotal":"435.00","grand_total":"435.00","paid_amount":"215.63","room_type_id":"413","product_id":"1266","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-23 02:41:17","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3272885","reservation_id":"111341","confirmation_number":"SJ12656545344","room_stay_from":"2021-06-18","room_stay_to":"2021-06-24","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.71,106.71,106.71,106.71,106.71,213.42","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"746.97","grand_total":"746.97","paid_amount":"0.00","room_type_id":"319","product_id":"1306","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-03-26 14:26:10","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","changedComment":"To date changed","deltaChange":"106.71","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3273135","reservation_id":"118010","confirmation_number":"SJ12666471947","room_confirmation_number":"SJ12680175738","room_stay_from":"2021-06-24","room_stay_to":"2021-06-25","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"125000","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-24 22:23:05","reservation_modified_date_time":"2021-06-24 22:23:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125000","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"3206923","reservation_id":"108957","confirmation_number":"SJ12655046706","room_confirmation_number":"SJ12698893079","room_stay_from":"2021-06-19","room_stay_to":"2021-06-26","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","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":"1777","service_quantity":"1","customer_traveller_id":"115419","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-03-01 20:32:12","reservation_modified_date_time":"2021-03-01 20:32:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115419","canceled_nights_data":"","posAmt_airbnb_taxpaid":"175.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":"3215095","reservation_id":"110208","confirmation_number":"SJ12690037499","room_confirmation_number":"SJ12693047496","room_stay_from":"2021-06-23","room_stay_to":"2021-06-27","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"116720","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-03-13 18:23:30","reservation_modified_date_time":"2021-03-13 18:23:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116720","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":"3273120","reservation_id":"108530","confirmation_number":"SJ12640491463","room_confirmation_number":"SJ12691009691","room_stay_from":"2021-06-24","room_stay_to":"2021-06-27","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":"114968","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-24 21:43:57","reservation_modified_date_time":"2021-06-24 21:43:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114968","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3183860","reservation_id":"106015","confirmation_number":"SJ12673852249","room_confirmation_number":"SJ12685534994","room_stay_from":"2021-06-18","room_stay_to":"2021-06-25","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":"112438","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-24 21:59:10","reservation_modified_date_time":"2021-01-24 21:59:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112438","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":"3208266","reservation_id":"109190","confirmation_number":"SJ12688008672","room_confirmation_number":"SJ12641075542","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","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":"115659","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 20:02:50","reservation_modified_date_time":"2021-03-03 20:02:50","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":"3208268","reservation_id":"109191","confirmation_number":"SJ12686601234","room_confirmation_number":"SJ12657847331","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","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":"115661","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 20:06:20","reservation_modified_date_time":"2021-03-03 20:06:20","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":"3210812","reservation_id":"109624","confirmation_number":"SJ12620723095","room_confirmation_number":"SJ12650865253","room_stay_from":"2021-06-18","room_stay_to":"2021-06-25","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":"75782","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-06 23:19:39","reservation_modified_date_time":"2021-03-06 23:19:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75782","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":"3221871","reservation_id":"111202","confirmation_number":"SJ12690840208","room_confirmation_number":"SJ12637915642","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","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":"117736","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 20:21:38","reservation_modified_date_time":"2021-03-24 20:21:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117736","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":"3230263","reservation_id":"107409","confirmation_number":"SJ12649018206","room_confirmation_number":"SJ12666572414","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","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":"113867","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 03:22:10","reservation_modified_date_time":"2021-04-07 21:49:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113867","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":"3230411","reservation_id":"112413","confirmation_number":"SJ12639534177","room_confirmation_number":"SJ12641246500","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","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":"118986","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-08 02:15:25","reservation_modified_date_time":"2021-04-08 02:15:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118986","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":"3230413","reservation_id":"112413","confirmation_number":"SJ12672712221","room_confirmation_number":"SJ12623893989","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","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":"118986","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-08 02:15:29","reservation_modified_date_time":"2021-04-08 02:15:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118986","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":"3232394","reservation_id":"112655","confirmation_number":"SJ12613714880","room_confirmation_number":"SJ12656158758","room_stay_from":"2021-06-21","room_stay_to":"2021-06-25","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":"119242","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-11 03:39:07","reservation_modified_date_time":"2021-04-11 03:39:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119242","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":"3237879","reservation_id":"113451","confirmation_number":"SJ12692246982","room_confirmation_number":"SJ12674373034","room_stay_from":"2021-06-21","room_stay_to":"2021-06-25","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":"120043","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-20 01:58:46","reservation_modified_date_time":"2021-04-20 01:58:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120043","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":"3251906","reservation_id":"112384","confirmation_number":"SJ12625424301","room_confirmation_number":"SJ12614910525","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","room_stay_status":"Active","nightly_price":"25,25,25,25,25","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":"118956","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 20:56:39","reservation_modified_date_time":"2021-05-14 21:18:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118956","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":"3251912","reservation_id":"112382","confirmation_number":"SJ12692961267","room_confirmation_number":"SJ12656012249","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","room_stay_status":"Active","nightly_price":"25,25,25,25,25","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":"118955","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 20:45:17","reservation_modified_date_time":"2021-05-14 21:19:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118955","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":"3264813","reservation_id":"116732","confirmation_number":"SJ12610703394","room_confirmation_number":"SJ12613355067","room_stay_from":"2021-06-21","room_stay_to":"2021-06-25","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":"123635","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-07 17:21:19","reservation_modified_date_time":"2021-06-09 22:55:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123635","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":"3270273","reservation_id":"108519","confirmation_number":"SJ12673520017","room_confirmation_number":"SJ12679730734","room_stay_from":"2021-06-19","room_stay_to":"2021-06-25","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":"114959","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-25 05:04:11","reservation_modified_date_time":"2021-06-19 15:25:06","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114959","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3271366","reservation_id":"112385","confirmation_number":"SJ12653968504","room_confirmation_number":"SJ12682275778","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","room_stay_status":"Active","nightly_price":"25,25,25,25,25","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":"118957","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 21:00:13","reservation_modified_date_time":"2021-06-21 14:24:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118957","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":"3271396","reservation_id":"108355","confirmation_number":"SJ12699690938","room_confirmation_number":"SJ12681599348","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","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":"114807","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 02:01:18","reservation_modified_date_time":"2021-06-21 15:08:25","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":"3271982","reservation_id":"117848","confirmation_number":"SJ12674625909","room_confirmation_number":"SJ12613472947","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","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":"124833","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-22 19:18:14","reservation_modified_date_time":"2021-06-22 19:18:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124825","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":"3272025","reservation_id":"110998","confirmation_number":"SJ12630701275","room_confirmation_number":"SJ12618422665","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","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":"117537","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 19:15:34","reservation_modified_date_time":"2021-06-22 20:16:54","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":"3272972","reservation_id":"108988","confirmation_number":"SJ12648155151","room_confirmation_number":"SJ12691624252","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","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":"115443","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-02 01:28:37","reservation_modified_date_time":"2021-06-24 15:53:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115443","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3273048","reservation_id":"117987","confirmation_number":"SJ12611884091","room_confirmation_number":"SJ12636280895","room_stay_from":"2021-06-24","room_stay_to":"2021-06-25","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":"124981","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-24 18:50:14","reservation_modified_date_time":"2021-06-24 18:50:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124981","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":"3273136","reservation_id":"118010","confirmation_number":"SJ12691358190","room_confirmation_number":"SJ12680175738","room_stay_from":"2021-06-24","room_stay_to":"2021-06-25","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"125000","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-24 22:10:12","reservation_modified_date_time":"2021-06-24 22:23:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125000","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"3206924","reservation_id":"108957","confirmation_number":"SJ12641232644","room_confirmation_number":"SJ12698893079","room_stay_from":"2021-06-19","room_stay_to":"2021-06-26","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":"115419","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-01 20:32:12","reservation_modified_date_time":"2021-03-01 20:32:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115419","canceled_nights_data":"","posAmt_airbnb_taxpaid":"175.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":"3208293","reservation_id":"109194","confirmation_number":"SJ12696811901","room_confirmation_number":"SJ12673488560","room_stay_from":"2021-06-23","room_stay_to":"2021-06-26","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":"115664","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 20:31:42","reservation_modified_date_time":"2021-03-03 20:31:42","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":"3208305","reservation_id":"109195","confirmation_number":"SJ12681189536","room_confirmation_number":"SJ12610788862","room_stay_from":"2021-06-23","room_stay_to":"2021-06-26","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":"115665","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 20:35:13","reservation_modified_date_time":"2021-03-03 20:35:13","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":"3214304","reservation_id":"110116","confirmation_number":"SJ12686772362","room_confirmation_number":"SJ12677911713","room_stay_from":"2021-06-23","room_stay_to":"2021-06-26","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":"116621","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-12 02:55:25","reservation_modified_date_time":"2021-03-12 03:00:43","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":"3227107","reservation_id":"110720","confirmation_number":"SJ12627999593","room_confirmation_number":"SJ12613155638","room_stay_from":"2021-06-22","room_stay_to":"2021-06-26","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"117231","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 15:46:20","reservation_modified_date_time":"2021-04-03 17:27:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117231","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":"3231014","reservation_id":"112480","confirmation_number":"SJ12674097280","room_confirmation_number":"SJ12651077260","room_stay_from":"2021-06-23","room_stay_to":"2021-06-26","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":"119053","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-09 00:08:32","reservation_modified_date_time":"2021-04-09 00:08:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119053","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":"3272383","reservation_id":"110115","confirmation_number":"SJ12666740660","room_confirmation_number":"SJ12628536124","room_stay_from":"2021-06-23","room_stay_to":"2021-06-26","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":"116621","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-12 02:54:57","reservation_modified_date_time":"2021-06-23 20:22:47","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":"3273095","reservation_id":"118002","confirmation_number":"SJ12668734756","room_confirmation_number":"SJ12634078006","room_stay_from":"2021-06-24","room_stay_to":"2021-06-26","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":"124992","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-24 21:02:45","reservation_modified_date_time":"2021-06-24 21:02:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124992","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":"3273102","reservation_id":"116274","confirmation_number":"SJ12644670644","room_confirmation_number":"SJ12655806025","room_stay_from":"2021-06-24","room_stay_to":"2021-06-26","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":"123133","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-31 21:06:28","reservation_modified_date_time":"2021-06-24 21:13:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123133","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":"3273127","reservation_id":"117596","confirmation_number":"SJ12648898740","room_confirmation_number":"SJ12618357615","room_stay_from":"2021-06-24","room_stay_to":"2021-06-26","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":"124565","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-19 01:03:37","reservation_modified_date_time":"2021-06-24 21:57:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124565","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":"3202489","reservation_id":"108236","confirmation_number":"SJ12664129332","room_confirmation_number":"SJ12693421970","room_stay_from":"2021-06-23","room_stay_to":"2021-06-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"114703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 01:50:21","reservation_modified_date_time":"2021-02-22 01:50:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114703","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":"3215096","reservation_id":"110208","confirmation_number":"SJ12610231304","room_confirmation_number":"SJ12693047496","room_stay_from":"2021-06-23","room_stay_to":"2021-06-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"116720","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-13 16:42:14","reservation_modified_date_time":"2021-03-13 18:23:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116720","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":"3227129","reservation_id":"105177","confirmation_number":"SJ12692311055","room_confirmation_number":"SJ12629292463","room_stay_from":"2021-06-23","room_stay_to":"2021-06-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"111551","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-11 16:36:11","reservation_modified_date_time":"2021-04-03 17:29:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111551","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":"3227133","reservation_id":"108321","confirmation_number":"SJ12693449280","room_confirmation_number":"SJ12659982746","room_stay_from":"2021-06-24","room_stay_to":"2021-06-27","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":"114776","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 23:53:07","reservation_modified_date_time":"2021-04-03 17:29:41","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114776","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":"3250995","reservation_id":"110133","confirmation_number":"SJ12695154691","room_confirmation_number":"SJ12677971177","room_stay_from":"2021-06-20","room_stay_to":"2021-06-27","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":"116639","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-12 13:11:22","reservation_modified_date_time":"2021-05-12 22:47:12","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":"3250999","reservation_id":"110701","confirmation_number":"SJ12689345369","room_confirmation_number":"SJ12677229694","room_stay_from":"2021-06-20","room_stay_to":"2021-06-27","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":"117212","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 13:51:24","reservation_modified_date_time":"2021-05-12 22:47:12","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":"3268952","reservation_id":"108234","confirmation_number":"SJ12624569193","room_confirmation_number":"SJ12681402852","room_stay_from":"2021-06-24","room_stay_to":"2021-06-27","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":"114700","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 01:28:21","reservation_modified_date_time":"2021-06-17 11:41:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114700","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":"3272470","reservation_id":"108220","confirmation_number":"SJ12657877767","room_confirmation_number":"SJ12695602736","room_stay_from":"2021-06-23","room_stay_to":"2021-06-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"114684","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-21 23:10:09","reservation_modified_date_time":"2021-06-23 21:31:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114684","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":"3273068","reservation_id":"109321","confirmation_number":"SJ12668588204","room_confirmation_number":"SJ12626151709","room_stay_from":"2021-06-24","room_stay_to":"2021-06-27","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":"115786","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 14:50:18","reservation_modified_date_time":"2021-06-24 19:17:10","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":"3273121","reservation_id":"108530","confirmation_number":"SJ12692866065","room_confirmation_number":"SJ12691009691","room_stay_from":"2021-06-24","room_stay_to":"2021-06-27","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":"114968","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-25 13:40:46","reservation_modified_date_time":"2021-06-24 21:43:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114968","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":"3217508","reservation_id":"110509","confirmation_number":"SJ12620858322","room_confirmation_number":"SJ12631801725","room_stay_from":"2021-06-24","room_stay_to":"2021-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"117095","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 14:27:15","reservation_modified_date_time":"2021-03-17 19:03:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117020","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":"3271032","reservation_id":"112261","confirmation_number":"SJ12646370717","room_confirmation_number":"SJ12691116073","room_stay_from":"2021-06-24","room_stay_to":"2021-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"118836","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-06 18:45:26","reservation_modified_date_time":"2021-06-20 20:46:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118836","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":"3271376","reservation_id":"108377","confirmation_number":"SJ12651517074","room_confirmation_number":"SJ12627707689","room_stay_from":"2021-06-23","room_stay_to":"2021-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114828","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 02:41:17","reservation_modified_date_time":"2021-06-21 14:29:09","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":"3272850","reservation_id":"115703","confirmation_number":"SJ12656757079","room_confirmation_number":"SJ12624300069","room_stay_from":"2021-06-24","room_stay_to":"2021-06-28","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"122477","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-23 00:41:10","reservation_modified_date_time":"2021-06-24 13:24:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122477","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3272970","reservation_id":"112210","confirmation_number":"SJ12662808743","room_confirmation_number":"SJ12619287066","room_stay_from":"2021-06-23","room_stay_to":"2021-06-30","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":"118776","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-05 23:52:28","reservation_modified_date_time":"2021-06-24 15:51:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118776","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":"3272814","reservation_id":"117926","confirmation_number":"SJ12666305536","room_confirmation_number":"SJ12619829057","room_stay_from":"2022-02-22","room_stay_to":"2022-02-25","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":"124918","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-23 22:51:30","reservation_modified_date_time":"2021-06-24 13:12:38","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124918","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":"3272839","reservation_id":"117931","confirmation_number":"SJ12612075279","room_confirmation_number":"SJ12627851050","room_stay_from":"2021-12-28","room_stay_to":"2022-01-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,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124924","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-24 00:04:31","reservation_modified_date_time":"2021-06-24 13:15:41","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124924","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":"3272886","reservation_id":"111341","confirmation_number":"SJ12695391812","room_confirmation_number":"SJ12656545344","room_stay_from":"2021-06-18","room_stay_to":"2021-06-24","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":"117875","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-26 14:26:10","reservation_modified_date_time":"2021-06-24 13:49:59","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","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":"3272952","reservation_id":"117592","confirmation_number":"SJ12644370254","room_confirmation_number":"SJ12634469415","room_stay_from":"2021-06-23","room_stay_to":"2021-06-24","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"124963","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-18 23:27:12","reservation_modified_date_time":"2021-06-24 15:40:16","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124963","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":[{"room_stay_id":"3230264","reservation_id":"107409","confirmation_number":"SJ12649018206","room_confirmation_number":"SJ12666572414","room_stay_from":"2021-06-22","room_stay_to":"2021-06-25","room_stay_status":"Active","nightly_price":"25,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":"113867","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 03:22:10","reservation_modified_date_time":"2021-04-07 21:49:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113867","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[]}],"gift_shop_taxable":[{"room_stay_id":"3272887","reservation_id":"111341","confirmation_number":"SJ12671230953","room_confirmation_number":"SJ12656545344","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":"28.13","paid_amount":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-06-24 13:50:09","reservation_modified_date_time":"2021-06-24 13:50:09","customer_id":"77106","parentCustTravId":"77106","customer_traveller_id":"117875","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-06-18","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3273210","reservation_id":"118025","confirmation_number":"SJ12666035294","room_confirmation_number":"SJ12661631532","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.86","grand_total":"4.00","paid_amount":"4.00","product_id":"1660","service_quantity":"2","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2021-06-25 01:59:59","reservation_modified_date_time":"2021-06-25 01:59:59","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3272977","reservation_id":"112797","confirmation_number":"SJ12625368153","room_confirmation_number":"SJ12635001016","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"75.00","paid_amount":"0.00","product_id":"1704","service_quantity":"1","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-06-24 16:09:45","reservation_modified_date_time":"2021-06-24 16:09:45","customer_id":"82465","parentCustTravId":"122254","customer_traveller_id":"119388","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-07-17","sub_hotel_id":"0","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}