{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-06-20","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":29,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1313,1271,1272,1913,1281,1294,1866,1297","block_room_bookings":[{"confirmation_number":"SJ12612027109","room_stay_from":"2021-06-20","room_stay_to":"2021-06-21","bundle_room":"0","product_id":"1313"},{"confirmation_number":"SJ12656146966","room_stay_from":"2021-06-20","room_stay_to":"2021-06-21","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJ12640102139","room_stay_from":"2021-06-20","room_stay_to":"2021-06-21","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJ12643102643","room_stay_from":"2021-06-20","room_stay_to":"2021-06-21","bundle_room":"0","product_id":"1913"},{"confirmation_number":"SJ12688911837","room_stay_from":"2021-06-20","room_stay_to":"2021-06-21","bundle_room":"0","product_id":"1281"},{"confirmation_number":"SJ12613412229","room_stay_from":"2021-06-20","room_stay_to":"2021-06-21","bundle_room":"0","product_id":"1294"},{"confirmation_number":"SJ12695676953","room_stay_from":"2021-06-20","room_stay_to":"2021-06-21","bundle_room":"0","product_id":"1866"},{"confirmation_number":"SJ12645974240","room_stay_from":"2021-06-20","room_stay_to":"2021-06-21","bundle_room":"0","product_id":"1297"}],"bundle_block_count":"1262,1263,1302,1303,1271,1272,1260,1261,1309,1310,1291,1711,1267,1268,1304,1305,1269,1270,1307,1308,1311,1312","bundle_block_bookings":[{"confirmation_number":"SJB12681439763","room_stay_from":"2021-06-20","room_stay_to":"2021-06-21","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12627396623","room_stay_from":"2021-06-17","room_stay_to":"2021-06-21","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12656011544","room_stay_from":"2021-06-17","room_stay_to":"2021-06-21","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12646260636","room_stay_from":"2021-06-20","room_stay_to":"2021-06-21","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12655545541","room_stay_from":"2021-06-20","room_stay_to":"2021-06-22","bundle_room":"0","product_id":"1260"},{"confirmation_number":"SJB12663811734","room_stay_from":"2021-06-20","room_stay_to":"2021-06-22","bundle_room":"0","product_id":"1261"},{"confirmation_number":"SJB12699186340","room_stay_from":"2021-06-17","room_stay_to":"2021-06-23","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12613136221","room_stay_from":"2021-06-17","room_stay_to":"2021-06-23","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12614592332","room_stay_from":"2021-06-19","room_stay_to":"2021-06-24","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12643300151","room_stay_from":"2021-06-19","room_stay_to":"2021-06-24","bundle_room":"0","product_id":"1711"},{"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":"SJB12658724453","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12698755383","room_stay_from":"2021-06-20","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1305"},{"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":"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"}]},"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":"3227121","reservation_id":"111850","confirmation_number":"SJ12649168968","room_stay_from":"2021-06-20","room_stay_to":"2021-06-23","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"303.00,303.00,333.00","nightly_discount":"0,0,0","subtotal":"939.00","grand_total":"1056.38","paid_amount":"1056.38","room_type_id":"320","product_id":"1320","siteminder_id":"BDC-2974734730","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":"118411","customer_id":"118411","source_of_creation":"Booking.com","reservation_created_date":"2021-04-01 22:09:14","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":"303.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"146.85","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":"161.03","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":"3241571","reservation_id":"113821","confirmation_number":"SJ12615951194","room_stay_from":"2021-06-19","room_stay_to":"2021-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"222.07,188.32,188.32","nightly_discount":"0,0,0","subtotal":"598.71","grand_total":"673.55","paid_amount":"673.55","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-3390819297","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":"120445","customer_id":"120445","source_of_creation":"Booking.com","reservation_created_date":"2021-04-24 23:53:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"121.27","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"188.32","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":"3243641","reservation_id":"114116","confirmation_number":"SJ12659302837","room_stay_from":"2021-06-19","room_stay_to":"2021-06-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"247.80,212.80,212.80,247.80,247.80","nightly_discount":"0,0,0,0,0","subtotal":"1169.00","grand_total":"1315.13","paid_amount":"1315.13","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-2477699061","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":"120749","customer_id":"120749","source_of_creation":"Booking.com","reservation_created_date":"2021-04-28 22:26:27","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"212.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":"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":"146.85","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":"214.89","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":"3263929","reservation_id":"114129","confirmation_number":"SJ12675888561","room_stay_from":"2021-06-19","room_stay_to":"2021-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"222.08,188.33,188.33","nightly_discount":"0,0,0","subtotal":"598.74","grand_total":"673.59","paid_amount":"673.59","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-2206226474","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":"120764","customer_id":"120764","source_of_creation":"Booking.com","reservation_created_date":"2021-04-29 01:55:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"121.27","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"188.33","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":"3267098","reservation_id":"116704","confirmation_number":"SJ12648364770","room_stay_from":"2021-06-20","room_stay_to":"2021-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"258.68,258.68","nightly_discount":"0,0","subtotal":"517.36","grand_total":"582.03","paid_amount":"582.03","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-2303559170","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":"123605","customer_id":"123605","source_of_creation":"Booking.com","reservation_created_date":"2021-06-07 04:47:16","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"258.68","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":"3267483","reservation_id":"112511","confirmation_number":"SJ12666284571","room_stay_from":"2021-06-16","room_stay_to":"2021-06-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"212.80,212.80,275.80,275.80,198.80","nightly_discount":"0,0,0,0,0","subtotal":"1176.00","grand_total":"1323.00","paid_amount":"1323.00","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3354905966","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":"119081","customer_id":"119081","source_of_creation":"Booking.com","reservation_created_date":"2021-04-09 13:31:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"234.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"198.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":"3269935","reservation_id":"114387","confirmation_number":"SJ12614897416","room_stay_from":"2021-06-20","room_stay_to":"2021-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"222.07,222.07","nightly_discount":"0,0","subtotal":"444.14","grand_total":"499.66","paid_amount":"499.66","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-2754571405","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":"121057","customer_id":"121057","source_of_creation":"Booking.com","reservation_created_date":"2021-05-02 22:11:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"88.96","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"222.07","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":"3270471","reservation_id":"117649","confirmation_number":"SJ12657900408","room_stay_from":"2021-06-20","room_stay_to":"2021-06-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"282.28","nightly_discount":"0","subtotal":"282.28","grand_total":"317.56","paid_amount":"317.56","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-2326663707","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":"124626","customer_id":"124626","source_of_creation":"Booking.com","reservation_created_date":"2021-06-19 20:48:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"55.31","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"282.28","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3271054","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":"413","product_id":"1266","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":"Standard King One Bedroom Suite 214","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","currentDayPrice":"146.85","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":"3270638","reservation_id":"110060","confirmation_number":"SJ12644893091","room_stay_from":"2021-06-17","room_stay_to":"2021-06-20","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"219.87,245.07,527.93","nightly_discount":"0.00,0.00,0.00","subtotal":"992.87","grand_total":"1116.98","paid_amount":"1116.98","room_type_id":"320","product_id":"1324","siteminder_id":"BDC-2119969344","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":"116559","customer_id":"116559","source_of_creation":"Booking.com","reservation_created_date":"2021-03-11 18:31:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"188.78","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"263.96","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":"3203857","reservation_id":"108474","confirmation_number":"SJ12676192480","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":"223.44,223.44,223.44,223.44,223.44","nightly_discount":"0,0,0,0,0","subtotal":"1117.20","grand_total":"1256.85","paid_amount":"1256.85","room_type_id":"320","product_id":"1329","siteminder_id":"EXP-1741221105","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":"114921","customer_id":"114921","source_of_creation":"Expedia","reservation_created_date":"2021-02-24 20:02:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1304,1305","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":"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":"3247102","reservation_id":"114578","confirmation_number":"SJ12638712873","room_stay_from":"2021-06-19","room_stay_to":"2021-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"187.4,157.4,157.4","nightly_discount":"0,0,0","subtotal":"502.20","grand_total":"564.98","paid_amount":"564.98","room_type_id":"319","product_id":"1301","siteminder_id":"EXP-1767403366","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121269","customer_id":"121269","source_of_creation":"Expedia","reservation_created_date":"2021-05-05 15:50:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"157.4","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3253947","reservation_id":"114618","confirmation_number":"SJ12639465113","room_stay_from":"2021-06-20","room_stay_to":"2021-06-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"164.40,164.40,194.40","nightly_discount":"0,0,0","subtotal":"523.20","grand_total":"588.60","paid_amount":"588.60","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1767564497","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":"121308","customer_id":"121308","source_of_creation":"Expedia","reservation_created_date":"2021-05-05 23:00:28","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","group_rooms":null,"currentDayPrice":"164.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3268114","reservation_id":"113805","confirmation_number":"SJ12617416982","room_stay_from":"2021-06-17","room_stay_to":"2021-06-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,230.30,230.30,195.30","nightly_discount":"0,0,0,0","subtotal":"886.20","grand_total":"996.98","paid_amount":"996.98","room_type_id":"319","product_id":"1276","siteminder_id":"EXP-1763324066","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":"120423","customer_id":"120423","source_of_creation":"Expedia","reservation_created_date":"2021-04-24 19:59:11","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":"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":"3269129","reservation_id":"108095","confirmation_number":"SJ12644626701","room_stay_from":"2021-06-17","room_stay_to":"2021-06-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"4","nightly_price":"265.30,265.30,265.30,265.30","nightly_discount":"0,0,0,0","subtotal":"1061.20","grand_total":"1193.85","paid_amount":"1288.35","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1739835912","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":"114562","customer_id":"114562","source_of_creation":"Expedia","reservation_created_date":"2021-02-20 03:42:12","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"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":"3269176","reservation_id":"110128","confirmation_number":"SJ12656656585","room_stay_from":"2021-06-17","room_stay_to":"2021-06-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"279.30,307.30,328.30,279.30,279.30,279.30","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1752.80","grand_total":"1971.90","paid_amount":"1971.90","room_type_id":"320","product_id":"1910","siteminder_id":"EXP-1746734857","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":"116634","customer_id":"116634","source_of_creation":"Expedia","reservation_created_date":"2021-03-12 12:37:11","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":null,"sub_hotel_id":"126","group_rooms":"1309,1310","currentDayPrice":"279.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3270619","reservation_id":"115029","confirmation_number":"SJ12695888732","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"263.20,223.20","nightly_discount":"0,0","subtotal":"486.40","grand_total":"547.20","paid_amount":"547.20","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1769900119","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":"121744","customer_id":"121744","source_of_creation":"Expedia","reservation_created_date":"2021-05-12 00:11:11","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":"126","currentDayPrice":"223.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3270667","reservation_id":"116372","confirmation_number":"SJ12672817956","room_stay_from":"2021-06-18","room_stay_to":"2021-06-21","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"291.76,291.76,314.00","nightly_discount":"0.00,0.00,0.00","subtotal":"897.52","grand_total":"1009.71","paid_amount":"1009.71","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1779195310","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"123239","customer_id":"123239","source_of_creation":"Expedia","reservation_created_date":"2021-06-02 03:11:08","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":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"314.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3271117","reservation_id":"116274","confirmation_number":"SJ12655806025","room_stay_from":"2021-06-24","room_stay_to":"2021-06-26","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"226.56,271.36","nightly_discount":"0,0","subtotal":"497.92","grand_total":"560.16","paid_amount":"0.00","room_type_id":"319","product_id":"1318","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":"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":"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":"3271142","reservation_id":"115703","confirmation_number":"SJ12624300069","room_stay_from":"2021-06-25","room_stay_to":"2021-06-28","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"274.56,274.56,191.36","nightly_discount":"0,0,0","subtotal":"740.48","grand_total":"833.04","paid_amount":"0.00","room_type_id":"413","product_id":"1269","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":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"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"}]},{"room_stay_id":"3270291","reservation_id":"117377","confirmation_number":"SJ12647989381","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"412.17,417.18","nightly_discount":"0.00,0.00","subtotal":"829.35","grand_total":"961.11","paid_amount":"961.11","room_type_id":"319","product_id":"1943","siteminder_id":"ABB-HMMPTMXERT","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"834.36","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124336","customer_id":"124336","source_of_creation":"Airbnb","reservation_created_date":"2021-06-16 00:06:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"24.54","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"417.18","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3270653","reservation_id":"114388","confirmation_number":"SJ12660067939","room_stay_from":"2021-06-20","room_stay_to":"2021-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"256.02,252.95","nightly_discount":"0.00,0.00","subtotal":"508.97","grand_total":"589.82","paid_amount":"589.82","room_type_id":"319","product_id":"1915","siteminder_id":"ABB-HMTBWAHP5P","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"512.04","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121058","customer_id":"121058","source_of_creation":"Airbnb","reservation_created_date":"2021-05-02 22:18:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"15.06","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"256.02","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3270655","reservation_id":"116671","confirmation_number":"SJ12692617867","room_stay_from":"2021-06-20","room_stay_to":"2021-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"385.35,390.64","nightly_discount":"0.00,0.00","subtotal":"775.99","grand_total":"914.56","paid_amount":"914.56","room_type_id":"412","product_id":"1316","siteminder_id":"ABB-HMN8X5TEMZ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"781.28","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"123569","customer_id":"123569","source_of_creation":"Airbnb","reservation_created_date":"2021-06-06 19:37:05","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"25.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"385.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3248277","reservation_id":"109732","confirmation_number":"SJ12686380705","room_stay_from":"2021-06-19","room_stay_to":"2021-06-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.75,149.25,149.25,149.25","nightly_discount":"0.00,0.00,0.00,0","subtotal":"649.50","grand_total":"730.69","paid_amount":"730.69","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116200","customer_id":"116200","source_of_creation":"FE","reservation_created_date":"2021-03-08 01:18:27","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":"0","group_rooms":null,"currentDayPrice":"149.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":"3253991","reservation_id":"115322","confirmation_number":"SJ12653008988","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"364.65,254.15","nightly_discount":"0.00,0.00","subtotal":"618.80","grand_total":"696.15","paid_amount":"696.15","room_type_id":"413","product_id":"1262","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122035","customer_id":"122035","source_of_creation":"FE","reservation_created_date":"2021-05-16 13:26:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"254.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3263933","reservation_id":"114717","confirmation_number":"SJ12651198289","room_stay_from":"2021-06-20","room_stay_to":"2021-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"237.15,237.15","nightly_discount":"0.00,0.00","subtotal":"474.30","grand_total":"533.59","paid_amount":"533.59","room_type_id":"319","product_id":"1277","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":"121429","customer_id":"121429","source_of_creation":"FE","reservation_created_date":"2021-05-07 17:06:54","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":"237.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3270621","reservation_id":"114181","confirmation_number":"SJ12645514165","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"279.65,237.15","nightly_discount":"0.00,0.00","subtotal":"516.80","grand_total":"581.40","paid_amount":"581.40","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":"120821","customer_id":"120821","source_of_creation":"FE","reservation_created_date":"2021-04-30 01:07:36","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":"237.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3271025","reservation_id":"108988","confirmation_number":"SJ12691624252","room_stay_from":"2021-06-20","room_stay_to":"2021-06-24","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","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"762.00","grand_total":"857.25","paid_amount":"857.25","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.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3270942","reservation_id":"112210","confirmation_number":"SJ12619287066","room_stay_from":"2021-06-23","room_stay_to":"2021-06-30","room_stay_status":"Active","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","subtotal":"1708.50","grand_total":"1922.07","paid_amount":"298.69","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118776","customer_id":"118776","source_of_creation":"FE","reservation_created_date":"2021-04-05 23:52:28","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":"0","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"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":"3238983","reservation_id":"113546","confirmation_number":"SJ12612786309","room_stay_from":"2021-06-18","room_stay_to":"2021-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"265.50,265.50,228.00,228.00","nightly_discount":"13.28,13.28,11.40,11.40","subtotal":"987.00","grand_total":"1054.84","paid_amount":"1054.84","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102464","customer_id":"102464","source_of_creation":"PMS","reservation_created_date":"2021-04-21 18:03:00","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":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"228.00","currentDayDiscount":"11.40","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3270460","reservation_id":"109404","confirmation_number":"SJ12643545230","room_stay_from":"2021-06-19","room_stay_to":"2021-06-24","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"254.00,254.00,254.00,254.00,254.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1270.00","grand_total":"1428.75","paid_amount":"1428.75","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":"115871","customer_id":"115871","source_of_creation":"PMS","reservation_created_date":"2021-03-04 21:12:34","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1291,1711","currentDayPrice":"254.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3245501","reservation_id":"104486","confirmation_number":"SJ12662267680","room_stay_from":"2021-06-18","room_stay_to":"2021-06-23","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.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","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":"2020-12-31 20:18:03","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":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"3251014","reservation_id":"111341","confirmation_number":"SJ12656545344","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":"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":"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","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":"3263325","reservation_id":"110997","confirmation_number":"SJ12678753335","room_stay_from":"2021-06-20","room_stay_to":"2021-06-23","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-22 19:11:08","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":"3270703","reservation_id":"111343","confirmation_number":"SJ12660990216","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Checked-Out","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"747.00","nightly_discount":"0.00","subtotal":"747.00","grand_total":"747.00","paid_amount":"0.00","room_type_id":"319","product_id":"1313","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:30:17","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":"0","changedComment":"To date changed","deltaChange":"640.29","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":"3270622","reservation_id":"114181","confirmation_number":"SJ12691705320","room_confirmation_number":"SJ12645514165","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"120821","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-20 12:28:06","reservation_modified_date_time":"2021-06-20 12:28:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120821","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"Reservation created with partial past date","deltaChange":"50.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3270668","reservation_id":"116372","confirmation_number":"SJ12670985497","room_confirmation_number":"SJ12672817956","room_stay_from":"2021-06-18","room_stay_to":"2021-06-21","room_stay_status":"Active","nightly_price":"50.00,50.00,50.00","nightly_discount":"0.00,0.00,50.00","subtotal":"150.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"123239","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-20 14:23:34","reservation_modified_date_time":"2021-06-20 14:24:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123239","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","changedComment":"Reservation created with partial past date","deltaChange":"100.00","currentDayPrice":"50.00","currentDayDiscount":"50.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3247103","reservation_id":"114578","confirmation_number":"SJ12648420622","room_confirmation_number":"SJ12638712873","room_stay_from":"2021-06-19","room_stay_to":"2021-06-22","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"121269","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-05-05 15:50:09","reservation_modified_date_time":"2021-05-05 15:50:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121269","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.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":"3267096","reservation_id":"116704","confirmation_number":"SJ12640622952","room_confirmation_number":"SJ12648364770","room_stay_from":"2021-06-20","room_stay_to":"2021-06-22","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"123605","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-14 13:40:47","reservation_modified_date_time":"2021-06-14 13:40:47","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123605","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"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":"3270190","reservation_id":"116671","confirmation_number":"SJ12648649312","room_confirmation_number":"SJ12692617867","room_stay_from":"2021-06-20","room_stay_to":"2021-06-22","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"100.60","paid_amount":"100.60","product_id":"1777","service_quantity":"1","customer_traveller_id":"123569","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-19 14:15:23","reservation_modified_date_time":"2021-06-19 14:15:23","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123569","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3253990","reservation_id":"115322","confirmation_number":"SJ12672389350","room_confirmation_number":"SJ12653008988","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","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":"122035","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-16 13:26:06","reservation_modified_date_time":"2021-05-19 14:58:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122035","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":"3267484","reservation_id":"112511","confirmation_number":"SJ12659075480","room_confirmation_number":"SJ12666284571","room_stay_from":"2021-06-16","room_stay_to":"2021-06-21","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":"119081","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-09 13:31:09","reservation_modified_date_time":"2021-06-14 22:11:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119081","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":"3268115","reservation_id":"113805","confirmation_number":"SJ12681266036","room_confirmation_number":"SJ12617416982","room_stay_from":"2021-06-17","room_stay_to":"2021-06-21","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":"120423","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-24 19:59:11","reservation_modified_date_time":"2021-06-15 22:07:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120423","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":"3269132","reservation_id":"108095","confirmation_number":"SJ12659713817","room_confirmation_number":"SJ12644626701","room_stay_from":"2021-06-17","room_stay_to":"2021-06-21","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":"114562","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-20 03:42:12","reservation_modified_date_time":"2021-06-17 20:35:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114562","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":"3270292","reservation_id":"117377","confirmation_number":"SJ12694450118","room_confirmation_number":"SJ12647989381","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124336","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-16 00:06:19","reservation_modified_date_time":"2021-06-19 15:43:40","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124336","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":"3270472","reservation_id":"117649","confirmation_number":"SJ12699301402","room_confirmation_number":"SJ12657900408","room_stay_from":"2021-06-20","room_stay_to":"2021-06-21","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":"124626","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-19 20:48:10","reservation_modified_date_time":"2021-06-19 20:48:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124626","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":"3270620","reservation_id":"115029","confirmation_number":"SJ12663620272","room_confirmation_number":"SJ12695888732","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","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":"121744","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-12 00:11:11","reservation_modified_date_time":"2021-06-20 12:27:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121744","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":"3270623","reservation_id":"114181","confirmation_number":"SJ12629126875","room_confirmation_number":"SJ12645514165","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","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":"120821","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-30 01:07:36","reservation_modified_date_time":"2021-06-20 12:28:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120821","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":"3270669","reservation_id":"116372","confirmation_number":"SJ12654864226","room_confirmation_number":"SJ12672817956","room_stay_from":"2021-06-18","room_stay_to":"2021-06-21","room_stay_status":"Active","nightly_price":"25,25,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":"123239","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-02 03:11:08","reservation_modified_date_time":"2021-06-20 14:24:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123239","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","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":"3238984","reservation_id":"113546","confirmation_number":"SJ12632724781","room_confirmation_number":"SJ12612786309","room_stay_from":"2021-06-18","room_stay_to":"2021-06-22","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":"102464","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 18:03:00","reservation_modified_date_time":"2021-04-21 18:03:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102464","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":"3241572","reservation_id":"113821","confirmation_number":"SJ12635276087","room_confirmation_number":"SJ12615951194","room_stay_from":"2021-06-19","room_stay_to":"2021-06-22","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":"120445","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-24 23:53:08","reservation_modified_date_time":"2021-04-24 23:53:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120445","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":"3247104","reservation_id":"114578","confirmation_number":"SJ12699354904","room_confirmation_number":"SJ12638712873","room_stay_from":"2021-06-19","room_stay_to":"2021-06-22","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":"121269","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-05 15:50:09","reservation_modified_date_time":"2021-05-05 15:50:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121269","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.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":"3263930","reservation_id":"114129","confirmation_number":"SJ12696653402","room_confirmation_number":"SJ12675888561","room_stay_from":"2021-06-19","room_stay_to":"2021-06-22","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":"120764","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-29 01:55:08","reservation_modified_date_time":"2021-06-07 23:48:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120764","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":"3263934","reservation_id":"114717","confirmation_number":"SJ12661885945","room_confirmation_number":"SJ12651198289","room_stay_from":"2021-06-20","room_stay_to":"2021-06-22","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":"121429","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-07 17:06:54","reservation_modified_date_time":"2021-06-07 23:48:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121429","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":"3267097","reservation_id":"116704","confirmation_number":"SJ12693379810","room_confirmation_number":"SJ12648364770","room_stay_from":"2021-06-20","room_stay_to":"2021-06-22","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":"123605","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-07 04:47:16","reservation_modified_date_time":"2021-06-14 13:40:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123605","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":"3269936","reservation_id":"114387","confirmation_number":"SJ12652838457","room_confirmation_number":"SJ12614897416","room_stay_from":"2021-06-20","room_stay_to":"2021-06-22","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"121057","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-02 22:11:07","reservation_modified_date_time":"2021-06-19 00:04:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121057","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":"3270654","reservation_id":"114388","confirmation_number":"SJ12677824028","room_confirmation_number":"SJ12660067939","room_stay_from":"2021-06-20","room_stay_to":"2021-06-22","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121058","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-02 22:18:11","reservation_modified_date_time":"2021-06-20 14:04:15","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121058","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":"3270656","reservation_id":"116671","confirmation_number":"SJ12673135031","room_confirmation_number":"SJ12692617867","room_stay_from":"2021-06-20","room_stay_to":"2021-06-22","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"123569","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-06 19:37:05","reservation_modified_date_time":"2021-06-20 14:13:20","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123569","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"3227120","reservation_id":"111850","confirmation_number":"SJ12613137630","room_confirmation_number":"SJ12649168968","room_stay_from":"2021-06-20","room_stay_to":"2021-06-23","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":"118411","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-01 22:09:14","reservation_modified_date_time":"2021-04-03 17:28:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118411","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":"3245502","reservation_id":"104486","confirmation_number":"SJ12677204252","room_confirmation_number":"SJ12662267680","room_stay_from":"2021-06-18","room_stay_to":"2021-06-23","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":"110842","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-31 20:18:03","reservation_modified_date_time":"2021-05-02 16:19:11","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":"3248278","reservation_id":"109732","confirmation_number":"SJ12641544083","room_confirmation_number":"SJ12686380705","room_stay_from":"2021-06-19","room_stay_to":"2021-06-23","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":"116200","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-08 01:18:27","reservation_modified_date_time":"2021-05-08 12:50:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116200","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":"3253946","reservation_id":"114618","confirmation_number":"SJ12630187843","room_confirmation_number":"SJ12639465113","room_stay_from":"2021-06-20","room_stay_to":"2021-06-23","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":"121308","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-05 23:00:28","reservation_modified_date_time":"2021-05-19 14:43:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121308","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":"3263326","reservation_id":"110997","confirmation_number":"SJ12632728223","room_confirmation_number":"SJ12678753335","room_stay_from":"2021-06-20","room_stay_to":"2021-06-23","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":"117535","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 19:11:08","reservation_modified_date_time":"2021-06-06 21:12:18","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":"3269179","reservation_id":"110128","confirmation_number":"SJ12695314473","room_confirmation_number":"SJ12656656585","room_stay_from":"2021-06-17","room_stay_to":"2021-06-23","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"116634","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-12 12:37:11","reservation_modified_date_time":"2021-06-17 21:41:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116634","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":"3243640","reservation_id":"114116","confirmation_number":"SJ12619241569","room_confirmation_number":"SJ12659302837","room_stay_from":"2021-06-19","room_stay_to":"2021-06-24","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":"120749","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-28 22:26:27","reservation_modified_date_time":"2021-04-29 13:27:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120749","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":"3270463","reservation_id":"109404","confirmation_number":"SJ12634157859","room_confirmation_number":"SJ12643545230","room_stay_from":"2021-06-19","room_stay_to":"2021-06-24","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":"115871","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 21:12:34","reservation_modified_date_time":"2021-06-19 20:22:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115871","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":"3271026","reservation_id":"108988","confirmation_number":"SJ12648155151","room_confirmation_number":"SJ12691624252","room_stay_from":"2021-06-20","room_stay_to":"2021-06-24","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":"115443","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-02 01:28:37","reservation_modified_date_time":"2021-06-20 20:45:28","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":"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":"3203858","reservation_id":"108474","confirmation_number":"SJ12699006450","room_confirmation_number":"SJ12676192480","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":"114921","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-24 20:02:11","reservation_modified_date_time":"2021-02-24 20:02:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114921","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":"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":"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":"3251013","reservation_id":"111341","confirmation_number":"SJ12695391812","room_confirmation_number":"SJ12656545344","room_stay_from":"2021-06-18","room_stay_to":"2021-06-25","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":"117875","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-26 14:26:10","reservation_modified_date_time":"2021-05-12 22:47:13","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":"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":"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":"3271055","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-20 21:14:48","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":"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":"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":"3270641","reservation_id":"110060","confirmation_number":"SJ12660877607","room_confirmation_number":"SJ12644893091","room_stay_from":"2021-06-17","room_stay_to":"2021-06-20","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":"116559","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-11 18:31:10","reservation_modified_date_time":"2021-06-20 13:29:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116559","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":"3270705","reservation_id":"111343","confirmation_number":"SJ12673678965","room_confirmation_number":"SJ12660990216","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117876","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-26 14:30:17","reservation_modified_date_time":"2021-06-20 16:16:05","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":"3270943","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":"0.00","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-20 19:23:00","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","changedComment":"From 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":"3271116","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":"0.00","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-20 22:33:58","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","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":"3271141","reservation_id":"115703","confirmation_number":"SJ12656757079","room_confirmation_number":"SJ12624300069","room_stay_from":"2021-06-25","room_stay_to":"2021-06-28","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","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-20 23:26:31","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":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3270637","reservation_id":"110060","confirmation_number":"SJ12624164338","room_confirmation_number":"SJ12644893091","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":"28.13","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-06-20 13:28:46","reservation_modified_date_time":"2021-06-20 13:28:46","customer_id":"116559","parentCustTravId":"116559","customer_traveller_id":"116559","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-06-17","sub_hotel_id":"126","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":"3270920","reservation_id":"117702","confirmation_number":"SJ12631981972","room_confirmation_number":"SJ12624070902","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"12.00","paid_amount":"12.00","product_id":"1663","service_quantity":"3","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-06-20 18:49:58","reservation_modified_date_time":"2021-06-20 18:49:58","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":"11.16","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}