{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-06-18","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":24,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1281,1289,1266,1316","block_room_bookings":[{"confirmation_number":"SJ12674690072","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","bundle_room":"0","product_id":"1281"},{"confirmation_number":"SJ12654029330","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","bundle_room":"0","product_id":"1289"},{"confirmation_number":"SJ12617717000","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","bundle_room":"0","product_id":"1266"},{"confirmation_number":"SJ12686014326","room_stay_from":"2021-06-18","room_stay_to":"2021-06-23","bundle_room":"0","product_id":"1316"}],"bundle_block_count":"1262,1263,1307,1308,1291,1711,1311,1312,1269,1270,1260,1261,1304,1305,1302,1303,1271,1272,1309,1310,1267,1268","bundle_block_bookings":[{"confirmation_number":"SJB12688127577","room_stay_from":"2021-06-15","room_stay_to":"2021-06-19","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12686727164","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","bundle_room":"1","product_id":"1330"},{"confirmation_number":"SJB12626770743","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12691983100","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","bundle_room":"1","product_id":"1332"},{"confirmation_number":"SJB12611907947","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12694255646","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12642059718","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12665600830","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","bundle_room":"1","product_id":"1329"},{"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":"SJB12650217590","room_stay_from":"2021-06-17","room_stay_to":"2021-06-21","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12637979355","room_stay_from":"2021-06-17","room_stay_to":"2021-06-21","bundle_room":"0","product_id":"1272"},{"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":"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"}]},"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":"272.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":"3216601","reservation_id":"110436","confirmation_number":"SJ12648892982","room_stay_from":"2021-06-12","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,160.30,160.30,160.30,160.30,160.30,188.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1199.10","grand_total":"1348.99","paid_amount":"1348.99","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-3860610350","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":"116947","customer_id":"116947","source_of_creation":"Booking.com","reservation_created_date":"2021-03-16 17:11:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"247.31","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"188.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":"3219462","reservation_id":"110811","confirmation_number":"SJ12659166139","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"205.2,205.2","nightly_discount":"0,0","subtotal":"410.40","grand_total":"461.70","paid_amount":"461.70","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-3240717266","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117331","customer_id":"117331","source_of_creation":"Booking.com","reservation_created_date":"2021-03-20 17:40:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"100.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"205.2","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3237737","reservation_id":"113424","confirmation_number":"SJ12680385268","room_stay_from":"2021-06-16","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"197.88,214.89,214.89,214.89","nightly_discount":"0,0,0,0","subtotal":"842.55","grand_total":"947.87","paid_amount":"947.87","room_type_id":"319","product_id":"1314","siteminder_id":"BDC-3744001249","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":"120014","customer_id":"120014","source_of_creation":"Booking.com","reservation_created_date":"2021-04-19 21:07:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"169.66","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"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":"3238386","reservation_id":"113525","confirmation_number":"SJ12644806003","room_stay_from":"2021-06-15","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"244.30,244.30,265.30,265.30","nightly_discount":"0,0,0,0","subtotal":"1019.20","grand_total":"1146.60","paid_amount":"1146.60","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2248031128","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":"120120","customer_id":"120120","source_of_creation":"Booking.com","reservation_created_date":"2021-04-21 13:13:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"201.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"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":"3246318","reservation_id":"114452","confirmation_number":"SJ12631045682","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.51","nightly_discount":"0.00","subtotal":"226.51","grand_total":"254.83","paid_amount":"254.82","room_type_id":"319","product_id":"1308","siteminder_id":"BDC-2276457897","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":"121131","customer_id":"121131","source_of_creation":"Booking.com","reservation_created_date":"2021-05-03 21:58:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"226.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3254794","reservation_id":"115572","confirmation_number":"SJ12649297768","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"328.19","nightly_discount":"0","subtotal":"328.19","grand_total":"369.21","paid_amount":"369.21","room_type_id":"319","product_id":"1307","siteminder_id":"BDC-3671130851","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":"122323","customer_id":"122323","source_of_creation":"Booking.com","reservation_created_date":"2021-05-20 20:44:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"63.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"328.19","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3263380","reservation_id":"116662","confirmation_number":"SJ12649069425","room_stay_from":"2021-06-17","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"299.25,344.25,344.25","nightly_discount":"0,0,0","subtotal":"987.75","grand_total":"1111.22","paid_amount":"1111.22","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-3903103610","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":"123554","customer_id":"123554","source_of_creation":"Booking.com","reservation_created_date":"2021-06-06 16:42:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"344.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":"3267456","reservation_id":"117280","confirmation_number":"SJ12616339838","room_stay_from":"2021-06-17","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"287.28,330.48","nightly_discount":"0,0","subtotal":"617.76","grand_total":"694.98","paid_amount":"694.98","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-3812526327","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":"124233","customer_id":"124233","source_of_creation":"Booking.com","reservation_created_date":"2021-06-14 21:29:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"120.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"330.48","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"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":"275.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":"3267495","reservation_id":"112283","confirmation_number":"SJ12695764128","room_stay_from":"2021-06-14","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"163.17,163.17,175.77,175.77,232.47","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"910.35","grand_total":"1024.15","paid_amount":"1024.15","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-3158166426","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":"118853","customer_id":"118853","source_of_creation":"Booking.com","reservation_created_date":"2021-04-06 21:47:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"186.36","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"232.47","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3268959","reservation_id":"117473","confirmation_number":"SJ12664082615","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"350.45","nightly_discount":"0","subtotal":"350.45","grand_total":"394.25","paid_amount":"394.25","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-2209637863","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":"124440","customer_id":"124440","source_of_creation":"Booking.com","reservation_created_date":"2021-06-17 05:29:13","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"67.58","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"350.45","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":"3269195","reservation_id":"110060","confirmation_number":"SJ12644893091","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":"4","nightly_price":"219.87,245.07,263.97,263.97","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"992.88","grand_total":"1116.99","paid_amount":"1116.99","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","group_rooms":"1271,1272","currentDayPrice":"245.07","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3269275","reservation_id":"117176","confirmation_number":"SJ12613452401","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"288.63,288.63","nightly_discount":"0,0","subtotal":"577.26","grand_total":"649.41","paid_amount":"649.41","room_type_id":"319","product_id":"1305","siteminder_id":"BDC-2500912766","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":"124142","customer_id":"124142","source_of_creation":"Booking.com","reservation_created_date":"2021-06-13 18:49:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"121.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"288.63","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":"3269534","reservation_id":"115786","confirmation_number":"SJ12641745009","room_stay_from":"2021-08-01","room_stay_to":"2021-08-06","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"178.92,178.92,178.92,191.52,241.92","nightly_discount":"0,0,0,0,0","subtotal":"970.20","grand_total":"1091.48","paid_amount":"215.46","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-2215439763","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":"122562","customer_id":"122562","source_of_creation":"Booking.com","reservation_created_date":"2021-05-24 15:49:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"197.15","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","changedComment":"both dates 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":"3269546","reservation_id":"112503","confirmation_number":"SJ12626505357","room_stay_from":"2021-06-15","room_stay_to":"2021-06-18","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"163.17,175.77,408.23","nightly_discount":"0.00,0.00,0.00","subtotal":"747.17","grand_total":"840.57","paid_amount":"840.57","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-2809571070","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":"124348","customer_id":"124348","source_of_creation":"Booking.com","reservation_created_date":"2021-04-09 11:06:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"152.49","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"232.46","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":"3269718","reservation_id":"117096","confirmation_number":"SJ12659038910","room_stay_from":"2021-07-21","room_stay_to":"2021-07-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.30,251.30,321.30,279.30","nightly_discount":"0,0,0,0","subtotal":"1103.20","grand_total":"1241.10","paid_amount":"282.72","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-3991298638","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":"124027","customer_id":"124027","source_of_creation":"Booking.com","reservation_created_date":"2021-06-12 15:49:42","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","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":"3269757","reservation_id":"117242","confirmation_number":"SJ12616814523","room_stay_from":"2021-07-30","room_stay_to":"2021-08-01","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"295.20,263.20","nightly_discount":"0,0","subtotal":"558.40","grand_total":"628.20","paid_amount":"332.10","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-3738251078","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":"124189","customer_id":"124189","source_of_creation":"Booking.com","reservation_created_date":"2021-06-14 16:27:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"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":"3269829","reservation_id":"117441","confirmation_number":"SJ12631011944","room_stay_from":"2021-08-02","room_stay_to":"2021-08-04","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"173.2,173.2","nightly_discount":"0,0","subtotal":"346.40","grand_total":"389.70","paid_amount":"194.85","room_type_id":"319","product_id":"1756","siteminder_id":"BDC-2605252086","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":"124410","customer_id":"124410","source_of_creation":"Booking.com","reservation_created_date":"2021-06-16 21:03:24","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":"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":"3269981","reservation_id":"117407","confirmation_number":"SJ12641249498","room_stay_from":"2021-10-24","room_stay_to":"2021-10-26","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.20,183.20","nightly_discount":"0,0","subtotal":"342.40","grand_total":"385.20","paid_amount":"179.10","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-3351147628","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":"124367","customer_id":"124367","source_of_creation":"Booking.com","reservation_created_date":"2021-06-16 13:51:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","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":"3269995","reservation_id":"117511","confirmation_number":"SJ12643439505","room_stay_from":"2021-11-17","room_stay_to":"2021-11-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"139.30,174.30,209.30,174.30","nightly_discount":"0,0,0,0","subtotal":"697.20","grand_total":"784.35","paid_amount":"156.72","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3157003672","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":"124475","customer_id":"124475","source_of_creation":"Booking.com","reservation_created_date":"2021-06-17 23:41:16","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3177707","reservation_id":"105196","confirmation_number":"SJ12683747825","room_stay_from":"2021-06-15","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.24,100.24,100.24,133.84","nightly_discount":"0,0,0,0","subtotal":"434.56","grand_total":"488.88","paid_amount":"488.88","room_type_id":"413","product_id":"1262","siteminder_id":"EXP-1729252856","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":"111574","customer_id":"111574","source_of_creation":"Expedia","reservation_created_date":"2021-01-11 23:31:08","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"133.84","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":"3242608","reservation_id":"113995","confirmation_number":"SJ12685145871","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"283.20,283.20","nightly_discount":"0,0","subtotal":"566.40","grand_total":"637.20","paid_amount":"637.20","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1764340644","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":"120627","customer_id":"120627","source_of_creation":"Expedia","reservation_created_date":"2021-04-27 16:45:14","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"283.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":"3258389","reservation_id":"110950","confirmation_number":"SJ12668799228","room_stay_from":"2021-06-17","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.75,201.75,201.75","nightly_discount":"0.00,0.00,0.00","subtotal":"575.25","grand_total":"647.15","paid_amount":"647.15","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1750581071","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":"117487","customer_id":"117487","source_of_creation":"Expedia","reservation_created_date":"2021-03-22 03:38:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"201.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3260786","reservation_id":"116372","confirmation_number":"SJ12672817956","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"291.76,291.76","nightly_discount":"0,0","subtotal":"583.52","grand_total":"656.46","paid_amount":"656.46","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"291.76","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":"3265914","reservation_id":"117064","confirmation_number":"SJ12637607984","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"367.20,367.20","nightly_discount":"0,0","subtotal":"734.40","grand_total":"826.20","paid_amount":"826.20","room_type_id":"319","product_id":"1304","siteminder_id":"EXP-1784119752","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":"124000","customer_id":"124000","source_of_creation":"Expedia","reservation_created_date":"2021-06-12 00:26:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","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":"367.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":"3267146","reservation_id":"116408","confirmation_number":"SJ12628385101","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"308.72","nightly_discount":"0","subtotal":"308.72","grand_total":"347.31","paid_amount":"347.31","room_type_id":"319","product_id":"1291","siteminder_id":"EXP-1779535345","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":"123275","customer_id":"123275","source_of_creation":"Expedia","reservation_created_date":"2021-06-02 21:31:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"308.72","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3267506","reservation_id":"116583","confirmation_number":"SJ12690120662","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"309.76,309.76","nightly_discount":"0,0","subtotal":"619.52","grand_total":"696.96","paid_amount":"696.96","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1780802191","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":"123470","customer_id":"123470","source_of_creation":"Expedia","reservation_created_date":"2021-06-05 14:40:09","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","group_rooms":null,"currentDayPrice":"309.76","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":"3267977","reservation_id":"117351","confirmation_number":"SJ12688363518","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"312.12","nightly_discount":"0","subtotal":"312.12","grand_total":"351.14","paid_amount":"351.14","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1785936733","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":"124310","customer_id":"124310","source_of_creation":"Expedia","reservation_created_date":"2021-06-15 19:06:19","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"312.12","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":"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":"3268134","reservation_id":"116689","confirmation_number":"SJ12637177778","room_stay_from":"2021-06-17","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,344.25,344.25","nightly_discount":"0,0,0","subtotal":"987.75","grand_total":"1111.22","paid_amount":"1111.22","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1781375182","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":"123589","customer_id":"123589","source_of_creation":"Expedia","reservation_created_date":"2021-06-06 21:51:33","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"344.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":"3268138","reservation_id":"113807","confirmation_number":"SJ12654078674","room_stay_from":"2021-06-17","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75","nightly_discount":"0,0,0","subtotal":"740.25","grand_total":"832.78","paid_amount":"832.78","room_type_id":"319","product_id":"1277","siteminder_id":"EXP-1763325501","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":"120424","customer_id":"120424","source_of_creation":"Expedia","reservation_created_date":"2021-04-24 20:04:12","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":"126","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"307.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":"3269691","reservation_id":"117504","confirmation_number":"SJ12674667506","room_stay_from":"2021-07-04","room_stay_to":"2021-07-06","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"290.56,226.56","nightly_discount":"0,0","subtotal":"517.12","grand_total":"581.76","paid_amount":"0.00","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1787060772","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":"124465","customer_id":"124465","source_of_creation":"Expedia","reservation_created_date":"2021-06-17 20:16:18","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","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":"3269889","reservation_id":"117412","confirmation_number":"SJ12661930195","room_stay_from":"2021-07-30","room_stay_to":"2021-08-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"271.32,250.92,155.72","nightly_discount":"0,0,0","subtotal":"677.96","grand_total":"762.71","paid_amount":"0.00","room_type_id":"319","product_id":"1301","siteminder_id":"EXP-1786397963","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":"124375","customer_id":"124375","source_of_creation":"Expedia","reservation_created_date":"2021-06-16 16:01:23","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"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":"3269906","reservation_id":"117388","confirmation_number":"SJ12614070155","room_stay_from":"2021-07-04","room_stay_to":"2021-07-08","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"257.04,201.04,201.04,201.04","nightly_discount":"0,0,0,0","subtotal":"860.16","grand_total":"967.68","paid_amount":"0.00","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1786134557","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":"124350","customer_id":"124350","source_of_creation":"Expedia","reservation_created_date":"2021-06-16 01:41:36","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":"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":"3269956","reservation_id":"117027","confirmation_number":"SJ12615383475","room_stay_from":"2021-08-17","room_stay_to":"2021-08-23","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.64,150.64,150.64,167.44,167.44,111.44","nightly_discount":"0,0,0,0,0,0","subtotal":"898.24","grand_total":"1010.52","paid_amount":"0.00","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1783877373","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":"123967","customer_id":"123967","source_of_creation":"Expedia","reservation_created_date":"2021-06-11 16:01:17","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","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":"3270029","reservation_id":"117512","confirmation_number":"SJ12661393275","room_stay_from":"2021-12-20","room_stay_to":"2022-01-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.20,239.20,239.20,239.20,351.20,351.20,319.20,319.20,319.20,319.20,319.20,351.20,351.20","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"3957.60","grand_total":"4452.30","paid_amount":"269.10","room_type_id":"319","product_id":"1319","siteminder_id":"EXP-1787161243","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":"124476","customer_id":"124476","source_of_creation":"Expedia","reservation_created_date":"2021-06-17 23:46:29","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":[{"room_stay_id":"3254581","reservation_id":"115536","confirmation_number":"SJ12613789819","room_stay_from":"2021-06-18","room_stay_to":"2021-06-22","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"314.30,314.30,244.30,244.30","nightly_discount":"0,0,0,0","subtotal":"1117.20","grand_total":"1256.85","paid_amount":"353.59","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1773326076","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":"122284","customer_id":"122284","source_of_creation":"Expedia","reservation_created_date":"2021-05-20 01:46:13","service_canceled_date_time":"2021-06-18 20:25:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"126","deltaChange":"353.59","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[{"room_stay_id":"3269767","reservation_id":"117590","confirmation_number":"SJ12616014267","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"285.80","nightly_discount":"0","subtotal":"285.80","grand_total":"321.53","paid_amount":"321.53","room_type_id":"319","product_id":"1311","siteminder_id":"HTN-164693375-XGNATF","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":"124557","customer_id":"124557","source_of_creation":"HotelTonight","reservation_created_date":"2021-06-18 23:05:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"285.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"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3263335","reservation_id":"116221","confirmation_number":"SJ12617186470","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.78","nightly_discount":"0","subtotal":"280.78","grand_total":"315.88","paid_amount":"315.88","room_type_id":"319","product_id":"1711","siteminder_id":"GAM-R2556329522","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":"123070","customer_id":"123070","source_of_creation":"Getaroom.com","reservation_created_date":"2021-05-30 21:50:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"280.78","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3269170","reservation_id":"117500","confirmation_number":"SJ12628228534","room_stay_from":"2021-06-17","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"394.72,394.72","nightly_discount":"5.30,0.00","subtotal":"789.44","grand_total":"924.00","paid_amount":"924.00","room_type_id":"319","product_id":"1313","siteminder_id":"ABB-HMXFZMDYA5","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"789.44","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124462","customer_id":"124462","source_of_creation":"Airbnb","reservation_created_date":"2021-06-17 18:50:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"26.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"394.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3269336","reservation_id":"116690","confirmation_number":"SJ12648044909","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"419.47","nightly_discount":"0.00","subtotal":"419.47","grand_total":"493.75","paid_amount":"493.75","room_type_id":"319","product_id":"1293","siteminder_id":"ABB-HMD3WSN8WY","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"422.26","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"123591","customer_id":"123591","source_of_creation":"Airbnb","reservation_created_date":"2021-06-06 22:27:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"13.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"419.47","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":"3269931","reservation_id":"117377","confirmation_number":"SJ12647989381","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"417.18,417.18","nightly_discount":"0.00,0","subtotal":"834.36","grand_total":"966.12","paid_amount":"0.00","room_type_id":"319","product_id":"1293","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 322","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","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","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":"3213641","reservation_id":"110005","confirmation_number":"SJ12660216371","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"330.65,356.15","nightly_discount":"0.00,0.00","subtotal":"686.80","grand_total":"772.65","paid_amount":"772.65","room_type_id":"320","product_id":"1323","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":"116495","customer_id":"116495","source_of_creation":"FE","reservation_created_date":"2021-03-10 23:34:28","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","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":"1269,1270","currentDayPrice":"330.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3216990","reservation_id":"110460","confirmation_number":"SJ12628876234","room_stay_from":"2021-06-12","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.25,171.75,171.75,171.75,171.75,171.75,201.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1284.75","grand_total":"1445.35","paid_amount":"1445.35","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116974","customer_id":"116974","source_of_creation":"FE","reservation_created_date":"2021-03-16 23:34:24","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":"201.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3268622","reservation_id":"117203","confirmation_number":"SJ12624077250","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"390.15","nightly_discount":"0.00","subtotal":"390.15","grand_total":"438.92","paid_amount":"438.92","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124149","customer_id":"124149","source_of_creation":"FE","reservation_created_date":"2021-06-13 23:13:19","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":"0","group_rooms":null,"currentDayPrice":"390.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"}]}],"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":"265.50","currentDayDiscount":"13.28","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3250095","reservation_id":"115018","confirmation_number":"SJ12688862658","room_stay_from":"2021-06-14","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"275.40,275.40,275.40,300.90,300.90,300.90","nightly_discount":"27.54,27.54,27.54,30.09,30.09,30.09","subtotal":"1728.90","grand_total":"1750.51","paid_amount":"1750.51","room_type_id":"412","product_id":"1294","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121729","customer_id":"121729","source_of_creation":"PMS","reservation_created_date":"2021-05-11 19:48:00","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"special123","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"300.90","currentDayDiscount":"30.09","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3268128","reservation_id":"111211","confirmation_number":"SJ12694294874","room_stay_from":"2021-06-17","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.75,201.75,201.75","nightly_discount":"17.18,20.18,20.18","subtotal":"575.25","grand_total":"582.43","paid_amount":"582.43","room_type_id":"319","product_id":"1915","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":"117742","customer_id":"117742","source_of_creation":"PMS","reservation_created_date":"2021-03-24 22:37:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"special123","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"201.75","currentDayDiscount":"20.18","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3270038","reservation_id":"117600","confirmation_number":"SJ12639307230","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"390.15","nightly_discount":"0.00","subtotal":"390.15","grand_total":"438.92","paid_amount":"438.92","room_type_id":"319","product_id":"1312","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":"124568","customer_id":"124568","source_of_creation":"PMS","reservation_created_date":"2021-06-19 01:22:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","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":"390.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3242773","reservation_id":"108376","confirmation_number":"SJ12664577238","room_stay_from":"2021-06-12","room_stay_to":"2021-06-19","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,87.00,87.00","nightly_discount":"0.00,0.00,0,0,0,0,0","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1917","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-23 02:40:14","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":"87.00","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3243629","reservation_id":"109175","confirmation_number":"SJ12628003128","room_stay_from":"2021-06-16","room_stay_to":"2021-06-19","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":"0.00","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 19:16:49","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"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":"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":"3266093","reservation_id":"110530","confirmation_number":"SJ12610717508","room_stay_from":"2021-06-14","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0,0,0,0","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"413","product_id":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 17:46:02","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3267127","reservation_id":"109174","confirmation_number":"SJ12667766176","room_stay_from":"2021-06-16","room_stay_to":"2021-06-19","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":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 19:12:55","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3268856","reservation_id":"113931","confirmation_number":"SJ12644845290","room_stay_from":"2021-06-16","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.66","nightly_discount":"0.00,0.00,0.00","subtotal":"260.00","grand_total":"260.00","paid_amount":"84.38","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-26 18:34:25","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":"86.66","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":"3268867","reservation_id":"117432","confirmation_number":"SJ12612899652","room_stay_from":"2021-06-16","room_stay_to":"2021-06-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.66","nightly_discount":"0.00,0.00,0.00","subtotal":"260.00","grand_total":"260.00","paid_amount":"84.38","room_type_id":"319","product_id":"1943","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"124545","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-06-16 19:33:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.66","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":"3269203","reservation_id":"108352","confirmation_number":"SJ12640303766","room_stay_from":"2021-06-17","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1263","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-23 01:58:59","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":"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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3263410","reservation_id":"116690","confirmation_number":"SJ12669992387","room_confirmation_number":"SJ12648044909","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"50.30","paid_amount":"50.30","product_id":"1777","service_quantity":"1","customer_traveller_id":"123591","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-06-06 22:27:10","reservation_modified_date_time":"2021-06-06 22:27:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123591","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"0.59","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3269062","reservation_id":"117500","confirmation_number":"SJ12616057407","room_confirmation_number":"SJ12628228534","room_stay_from":"2021-06-17","room_stay_to":"2021-06-19","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":"124462","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-06-17 18:50:11","reservation_modified_date_time":"2021-06-17 18:50:11","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124462","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"0.60","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3219463","reservation_id":"110811","confirmation_number":"SJ12690284261","room_confirmation_number":"SJ12659166139","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","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":"117331","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-03-20 17:40:12","reservation_modified_date_time":"2021-03-20 17:40:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117331","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"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3260787","reservation_id":"116372","confirmation_number":"SJ12670985497","room_confirmation_number":"SJ12672817956","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","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":"123239","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-06-02 03:11:08","reservation_modified_date_time":"2021-06-02 03:11:08","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","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":"3269276","reservation_id":"117176","confirmation_number":"SJ12636311033","room_confirmation_number":"SJ12613452401","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","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":"124142","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-18 02:39:11","reservation_modified_date_time":"2021-06-18 02:39:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124142","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"}]}],"extra_person_non_taxable":[{"room_stay_id":"3269205","reservation_id":"108352","confirmation_number":"SJ12695629613","room_confirmation_number":"SJ12640303766","room_stay_from":"2021-06-17","room_stay_to":"2021-06-20","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"122254","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-17 22:27:56","reservation_modified_date_time":"2021-06-17 22:27:56","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25","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"}]}],"resort_fee_taxable":[{"room_stay_id":"3177708","reservation_id":"105196","confirmation_number":"SJ12695189834","room_confirmation_number":"SJ12683747825","room_stay_from":"2021-06-15","room_stay_to":"2021-06-19","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":"111574","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-11 23:31:08","reservation_modified_date_time":"2021-01-11 23:31:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111574","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":"3216603","reservation_id":"110436","confirmation_number":"SJ12630681830","room_confirmation_number":"SJ12648892982","room_stay_from":"2021-06-12","room_stay_to":"2021-06-19","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":"1776","service_quantity":"1","customer_traveller_id":"116947","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-16 17:11:08","reservation_modified_date_time":"2021-03-16 18:38:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116947","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":"3216991","reservation_id":"110460","confirmation_number":"SJ12614983661","room_confirmation_number":"SJ12628876234","room_stay_from":"2021-06-12","room_stay_to":"2021-06-19","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":"116974","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-16 23:34:24","reservation_modified_date_time":"2021-03-16 23:34:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116974","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":"3238387","reservation_id":"113525","confirmation_number":"SJ12671488168","room_confirmation_number":"SJ12644806003","room_stay_from":"2021-06-15","room_stay_to":"2021-06-19","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":"120120","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 13:13:10","reservation_modified_date_time":"2021-04-21 13:13:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120120","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":"3242774","reservation_id":"108376","confirmation_number":"SJ12669463893","room_confirmation_number":"SJ12664577238","room_stay_from":"2021-06-12","room_stay_to":"2021-06-19","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":"114827","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 02:40:14","reservation_modified_date_time":"2021-04-27 20:36:01","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":"3243630","reservation_id":"109175","confirmation_number":"SJ12618675263","room_confirmation_number":"SJ12628003128","room_stay_from":"2021-06-16","room_stay_to":"2021-06-19","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":"115646","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 19:16:49","reservation_modified_date_time":"2021-04-29 13:26:51","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":"3246319","reservation_id":"114452","confirmation_number":"SJ12685583015","room_confirmation_number":"SJ12631045682","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121131","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-03 21:58:20","reservation_modified_date_time":"2021-05-03 22:01:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121131","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":"3254795","reservation_id":"115572","confirmation_number":"SJ12684660481","room_confirmation_number":"SJ12649297768","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","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":"122323","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-20 20:44:07","reservation_modified_date_time":"2021-05-20 20:44:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122323","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":"3263336","reservation_id":"116221","confirmation_number":"SJ12622667050","room_confirmation_number":"SJ12617186470","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","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":"123070","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-30 21:50:08","reservation_modified_date_time":"2021-06-06 21:24:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123070","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":"3266094","reservation_id":"110530","confirmation_number":"SJ12652049291","room_confirmation_number":"SJ12610717508","room_stay_from":"2021-06-14","room_stay_to":"2021-06-19","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":"117043","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 17:46:02","reservation_modified_date_time":"2021-06-12 15:26:34","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":"3267128","reservation_id":"109174","confirmation_number":"SJ12694438352","room_confirmation_number":"SJ12667766176","room_stay_from":"2021-06-16","room_stay_to":"2021-06-19","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":"115646","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 19:12:55","reservation_modified_date_time":"2021-06-14 13:45:03","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":"3267147","reservation_id":"116408","confirmation_number":"SJ12623230146","room_confirmation_number":"SJ12628385101","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","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":"123275","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-02 21:31:11","reservation_modified_date_time":"2021-06-14 14:18:39","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123275","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":"3267457","reservation_id":"117280","confirmation_number":"SJ12655846708","room_confirmation_number":"SJ12616339838","room_stay_from":"2021-06-17","room_stay_to":"2021-06-19","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":"124233","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-14 21:29:11","reservation_modified_date_time":"2021-06-14 21:29:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124233","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":"3267496","reservation_id":"112283","confirmation_number":"SJ12613193168","room_confirmation_number":"SJ12695764128","room_stay_from":"2021-06-14","room_stay_to":"2021-06-19","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":"118853","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-06 21:47:10","reservation_modified_date_time":"2021-06-14 22:13:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118853","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":"3267978","reservation_id":"117351","confirmation_number":"SJ12610485814","room_confirmation_number":"SJ12688363518","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","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":"124310","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-15 19:06:19","reservation_modified_date_time":"2021-06-15 19:06:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124310","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":"3268623","reservation_id":"117203","confirmation_number":"SJ12630531576","room_confirmation_number":"SJ12624077250","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","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":"124149","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-13 23:13:19","reservation_modified_date_time":"2021-06-16 19:24:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124149","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":"3268857","reservation_id":"113931","confirmation_number":"SJ12615246056","room_confirmation_number":"SJ12644845290","room_stay_from":"2021-06-16","room_stay_to":"2021-06-19","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":"120566","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-26 18:34:25","reservation_modified_date_time":"2021-06-16 22:45:56","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3268868","reservation_id":"117432","confirmation_number":"SJ12673180973","room_confirmation_number":"SJ12612899652","room_stay_from":"2021-06-16","room_stay_to":"2021-06-19","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":"124397","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-16 19:33:24","reservation_modified_date_time":"2021-06-16 22:48:27","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":"3268960","reservation_id":"117473","confirmation_number":"SJ12657017948","room_confirmation_number":"SJ12664082615","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"124440","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-17 05:29:13","reservation_modified_date_time":"2021-06-17 12:10:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124440","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":"3269171","reservation_id":"117500","confirmation_number":"SJ12646811406","room_confirmation_number":"SJ12628228534","room_stay_from":"2021-06-17","room_stay_to":"2021-06-19","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":"124462","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-17 18:50:11","reservation_modified_date_time":"2021-06-17 21:34:47","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124462","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":"3269337","reservation_id":"116690","confirmation_number":"SJ12636417115","room_confirmation_number":"SJ12648044909","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","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":"123591","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-06 22:27:10","reservation_modified_date_time":"2021-06-18 12:37:33","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123591","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3269768","reservation_id":"117590","confirmation_number":"SJ12652624163","room_confirmation_number":"SJ12616014267","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","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":"124557","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-18 23:05:08","reservation_modified_date_time":"2021-06-18 23:05:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124557","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":"3270039","reservation_id":"117600","confirmation_number":"SJ12666518919","room_confirmation_number":"SJ12639307230","room_stay_from":"2021-06-18","room_stay_to":"2021-06-19","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":"124568","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-19 01:22:16","reservation_modified_date_time":"2021-06-19 01:22:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124568","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":"3213642","reservation_id":"110005","confirmation_number":"SJ12624035381","room_confirmation_number":"SJ12660216371","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","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":"116495","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-10 23:34:28","reservation_modified_date_time":"2021-03-10 23:34:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116495","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":"3219464","reservation_id":"110811","confirmation_number":"SJ12625346387","room_confirmation_number":"SJ12659166139","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","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":"117331","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-20 17:40:12","reservation_modified_date_time":"2021-03-20 17:40:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117331","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"3237738","reservation_id":"113424","confirmation_number":"SJ12679110343","room_confirmation_number":"SJ12680385268","room_stay_from":"2021-06-16","room_stay_to":"2021-06-20","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":"120014","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-19 21:07:10","reservation_modified_date_time":"2021-04-19 21:07:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120014","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":"3242609","reservation_id":"113995","confirmation_number":"SJ12696853738","room_confirmation_number":"SJ12685145871","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","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":"120627","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-27 16:45:14","reservation_modified_date_time":"2021-04-27 16:45:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120627","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":"3250096","reservation_id":"115018","confirmation_number":"SJ12648434575","room_confirmation_number":"SJ12688862658","room_stay_from":"2021-06-14","room_stay_to":"2021-06-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"121729","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-11 19:48:00","reservation_modified_date_time":"2021-05-11 19:48:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121729","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":"3258390","reservation_id":"110950","confirmation_number":"SJ12637912411","room_confirmation_number":"SJ12668799228","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":"117487","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 03:38:12","reservation_modified_date_time":"2021-05-28 16:18:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117487","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":"3260788","reservation_id":"116372","confirmation_number":"SJ12654864226","room_confirmation_number":"SJ12672817956","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","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":"123239","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-02 03:11:08","reservation_modified_date_time":"2021-06-02 03:11:08","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","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":"3263379","reservation_id":"116662","confirmation_number":"SJ12627893526","room_confirmation_number":"SJ12649069425","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":"123554","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-06 16:42:32","reservation_modified_date_time":"2021-06-06 21:44:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123554","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":"3265915","reservation_id":"117064","confirmation_number":"SJ12688171997","room_confirmation_number":"SJ12637607984","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","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":"124000","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-12 00:26:12","reservation_modified_date_time":"2021-06-12 00:26:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124000","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":"3267507","reservation_id":"116583","confirmation_number":"SJ12687407739","room_confirmation_number":"SJ12690120662","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","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":"123470","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-05 14:40:09","reservation_modified_date_time":"2021-06-14 22:19:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123470","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":"3268129","reservation_id":"111211","confirmation_number":"SJ12650869909","room_confirmation_number":"SJ12694294874","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":"117742","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 22:37:24","reservation_modified_date_time":"2021-06-15 22:08:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117742","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":"3268135","reservation_id":"116689","confirmation_number":"SJ12657442504","room_confirmation_number":"SJ12637177778","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":"123589","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-06 21:51:33","reservation_modified_date_time":"2021-06-15 22:10:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123589","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":"3268139","reservation_id":"113807","confirmation_number":"SJ12669709533","room_confirmation_number":"SJ12654078674","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":"120424","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-24 20:04:12","reservation_modified_date_time":"2021-06-15 22:11:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120424","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":"3269206","reservation_id":"108352","confirmation_number":"SJ12698033718","room_confirmation_number":"SJ12640303766","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114804","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 01:58:59","reservation_modified_date_time":"2021-06-17 22:27:57","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":"3269277","reservation_id":"117176","confirmation_number":"SJ12611274615","room_confirmation_number":"SJ12613452401","room_stay_from":"2021-06-18","room_stay_to":"2021-06-20","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":"124142","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-13 18:49:25","reservation_modified_date_time":"2021-06-18 02:39:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124142","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":"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":"3269198","reservation_id":"110060","confirmation_number":"SJ12660877607","room_confirmation_number":"SJ12644893091","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":"116559","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-11 18:31:10","reservation_modified_date_time":"2021-06-17 22:21:17","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","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":"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":"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":"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":"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":"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":"3269535","reservation_id":"115786","confirmation_number":"SJ12634322887","room_confirmation_number":"SJ12641745009","room_stay_from":"2021-08-01","room_stay_to":"2021-08-06","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"122562","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-24 15:49:09","reservation_modified_date_time":"2021-06-18 18:06:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122562","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"both dates 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":"3269547","reservation_id":"112503","confirmation_number":"SJ12648865909","room_confirmation_number":"SJ12626505357","room_stay_from":"2021-06-15","room_stay_to":"2021-06-18","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":"124348","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-09 11:06:12","reservation_modified_date_time":"2021-06-18 18:29:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124348","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":"3269690","reservation_id":"117504","confirmation_number":"SJ12648838149","room_confirmation_number":"SJ12674667506","room_stay_from":"2021-07-04","room_stay_to":"2021-07-06","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124465","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-17 20:16:18","reservation_modified_date_time":"2021-06-18 22:20:20","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124465","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":"3269717","reservation_id":"117096","confirmation_number":"SJ12639706315","room_confirmation_number":"SJ12659038910","room_stay_from":"2021-07-21","room_stay_to":"2021-07-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124027","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-12 15:49:42","reservation_modified_date_time":"2021-06-18 22:45:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124027","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":"3269756","reservation_id":"117242","confirmation_number":"SJ12665169814","room_confirmation_number":"SJ12616814523","room_stay_from":"2021-07-30","room_stay_to":"2021-08-01","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":"124189","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-14 16:27:22","reservation_modified_date_time":"2021-06-18 22:58:52","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124189","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":"3269828","reservation_id":"117441","confirmation_number":"SJ12629387720","room_confirmation_number":"SJ12631011944","room_stay_from":"2021-08-02","room_stay_to":"2021-08-04","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":"124410","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-16 21:03:24","reservation_modified_date_time":"2021-06-18 23:26:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124410","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":"3269888","reservation_id":"117412","confirmation_number":"SJ12640988404","room_confirmation_number":"SJ12661930195","room_stay_from":"2021-07-30","room_stay_to":"2021-08-02","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":"124375","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-16 16:01:24","reservation_modified_date_time":"2021-06-18 23:46:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124375","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":"3269905","reservation_id":"117388","confirmation_number":"SJ12623015040","room_confirmation_number":"SJ12614070155","room_stay_from":"2021-07-04","room_stay_to":"2021-07-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124350","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-16 01:41:36","reservation_modified_date_time":"2021-06-18 23:52:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124350","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":"3269930","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 00:02:23","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","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","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":"3269955","reservation_id":"117027","confirmation_number":"SJ12637911978","room_confirmation_number":"SJ12615383475","room_stay_from":"2021-08-17","room_stay_to":"2021-08-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"123967","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-11 16:01:17","reservation_modified_date_time":"2021-06-19 00:25:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123967","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":"3269980","reservation_id":"117407","confirmation_number":"SJ12629839381","room_confirmation_number":"SJ12641249498","room_stay_from":"2021-10-24","room_stay_to":"2021-10-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":"124367","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-16 13:51:15","reservation_modified_date_time":"2021-06-19 00:31:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124367","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":"3269994","reservation_id":"117511","confirmation_number":"SJ12680809110","room_confirmation_number":"SJ12643439505","room_stay_from":"2021-11-17","room_stay_to":"2021-11-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124475","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-17 23:41:16","reservation_modified_date_time":"2021-06-19 00:34:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124475","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":"3270030","reservation_id":"117512","confirmation_number":"SJ12690769892","room_confirmation_number":"SJ12661393275","room_stay_from":"2021-12-20","room_stay_to":"2022-01-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"325.00","grand_total":"365.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124476","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-17 23:46:29","reservation_modified_date_time":"2021-06-19 00:39:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124476","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":"3269545","reservation_id":"112503","confirmation_number":"SJ12687090970","room_confirmation_number":"SJ12626505357","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-18 18:28:55","reservation_modified_date_time":"2021-06-18 18:28:55","customer_id":"124348","parentCustTravId":"124348","customer_traveller_id":"124348","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-15","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"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}