{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-06-19","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":23,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1269,1270,1260,1261,1304,1305,1262,1263,1302,1303,1271,1272,1309,1310,1291,1711,1267,1268,1307,1308,1311,1312","bundle_block_bookings":[{"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":"SJB12618043873","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12627396623","room_stay_from":"2021-06-17","room_stay_to":"2021-06-21","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12656011544","room_stay_from":"2021-06-17","room_stay_to":"2021-06-21","bundle_room":"0","product_id":"1303"},{"confirmation_number":"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":"SJB12614592332","room_stay_from":"2021-06-19","room_stay_to":"2021-06-24","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12643300151","room_stay_from":"2021-06-19","room_stay_to":"2021-06-24","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12627470219","room_stay_from":"2021-06-18","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12621831691","room_stay_from":"2021-06-18","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12689618963","room_stay_from":"2021-06-19","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12668426996","room_stay_from":"2021-06-19","room_stay_to":"2021-06-25","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12695826466","room_stay_from":"2021-06-19","room_stay_to":"2021-06-26","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12680126055","room_stay_from":"2021-06-19","room_stay_to":"2021-06-26","bundle_room":"0","product_id":"1312"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3183859","reservation_id":"106015","confirmation_number":"SJ12685534994","room_stay_from":"2021-06-18","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"272.30,272.30,230.30,230.30,230.30,230.30,230.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1696.10","grand_total":"1908.12","paid_amount":"1908.12","room_type_id":"320","product_id":"1322","siteminder_id":"BDC-3756311611","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112438","customer_id":"112438","source_of_creation":"Booking.com","reservation_created_date":"2021-01-24 21:59:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"336.80","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1267,1268","currentDayPrice":"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":"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":"3241571","reservation_id":"113821","confirmation_number":"SJ12615951194","room_stay_from":"2021-06-19","room_stay_to":"2021-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"222.07,188.32,188.32","nightly_discount":"0,0,0","subtotal":"598.71","grand_total":"673.55","paid_amount":"673.55","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-3390819297","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120445","customer_id":"120445","source_of_creation":"Booking.com","reservation_created_date":"2021-04-24 23:53:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"121.27","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"222.07","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3243641","reservation_id":"114116","confirmation_number":"SJ12659302837","room_stay_from":"2021-06-19","room_stay_to":"2021-06-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"247.80,212.80,212.80,247.80,247.80","nightly_discount":"0,0,0,0,0","subtotal":"1169.00","grand_total":"1315.13","paid_amount":"1315.13","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-2477699061","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120749","customer_id":"120749","source_of_creation":"Booking.com","reservation_created_date":"2021-04-28 22:26:27","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"247.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":"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":"3263929","reservation_id":"114129","confirmation_number":"SJ12675888561","room_stay_from":"2021-06-19","room_stay_to":"2021-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"222.08,188.33,188.33","nightly_discount":"0,0,0","subtotal":"598.74","grand_total":"673.59","paid_amount":"673.59","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-2206226474","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120764","customer_id":"120764","source_of_creation":"Booking.com","reservation_created_date":"2021-04-29 01:55:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"121.27","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"222.08","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"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":"263.97","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"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":"3269932","reservation_id":"116660","confirmation_number":"SJ12630328958","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"351.13","nightly_discount":"0","subtotal":"351.13","grand_total":"395.02","paid_amount":"395.02","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-2303584176","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":"123552","customer_id":"123552","source_of_creation":"Booking.com","reservation_created_date":"2021-06-06 16:22:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"67.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"351.13","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":"3206922","reservation_id":"108957","confirmation_number":"SJ12698893079","room_stay_from":"2021-06-19","room_stay_to":"2021-06-26","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"3","nightly_price":"303.3,254.3,254.3,254.3,254.3,254.3,282.3","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1857.10","grand_total":"2089.24","paid_amount":"2089.24","room_type_id":"320","product_id":"1332","siteminder_id":"EXP-1742852571","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"175.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115419","customer_id":"115419","source_of_creation":"Expedia","reservation_created_date":"2021-03-01 20:32:12","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"303.3","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"3247102","reservation_id":"114578","confirmation_number":"SJ12638712873","room_stay_from":"2021-06-19","room_stay_to":"2021-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"187.4,157.4,157.4","nightly_discount":"0,0,0","subtotal":"502.20","grand_total":"564.98","paid_amount":"564.98","room_type_id":"319","product_id":"1301","siteminder_id":"EXP-1767403366","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121269","customer_id":"121269","source_of_creation":"Expedia","reservation_created_date":"2021-05-05 15:50:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"187.4","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"3263381","reservation_id":"114880","confirmation_number":"SJ12689622235","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.32","nightly_discount":"0","subtotal":"203.32","grand_total":"228.74","paid_amount":"228.74","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1769118064","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":"121617","customer_id":"121617","source_of_creation":"Expedia","reservation_created_date":"2021-05-10 03:50:06","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","group_rooms":null,"currentDayPrice":"203.32","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"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":"3268084","reservation_id":"117367","confirmation_number":"SJ12650447093","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","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-1786010533","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":"124325","customer_id":"124325","source_of_creation":"Expedia","reservation_created_date":"2021-06-15 21:31:08","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":"328.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":"3270070","reservation_id":"117608","confirmation_number":"SJ12618476870","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"308.72","nightly_discount":"0","subtotal":"308.72","grand_total":"347.31","paid_amount":"347.31","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1787801577","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124577","customer_id":"124577","source_of_creation":"Expedia","reservation_created_date":"2021-06-19 04:26:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","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":"3270223","reservation_id":"117374","confirmation_number":"SJ12619179508","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"453.9","nightly_discount":"0","subtotal":"453.90","grand_total":"510.64","paid_amount":"510.64","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1786067188","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124332","customer_id":"124332","source_of_creation":"Expedia","reservation_created_date":"2021-06-15 23:31:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"453.9","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":"3270289","reservation_id":"115029","confirmation_number":"SJ12695888732","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"263.20,223.20","nightly_discount":"0,0","subtotal":"486.40","grand_total":"547.20","paid_amount":"547.20","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1769900119","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121744","customer_id":"121744","source_of_creation":"Expedia","reservation_created_date":"2021-05-12 00:11:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"263.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"}]}],"exp_non_taxable":[{"room_stay_id":"3211694","reservation_id":"109733","confirmation_number":"SJ12641947157","room_stay_from":"2021-06-19","room_stay_to":"2021-06-23","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"255.15","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1745075823","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":"116223","customer_id":"116223","source_of_creation":"Expedia","reservation_created_date":"2021-03-08 01:22:13","service_canceled_date_time":"2021-04-15 21:43:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"126","deltaChange":"255.15","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[{"room_stay_id":"3270256","reservation_id":"117624","confirmation_number":"SJ12640260573","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"248.20","nightly_discount":"0","subtotal":"248.20","grand_total":"279.23","paid_amount":"279.23","room_type_id":"318","product_id":"1281","siteminder_id":"HTN-164743473-MDXW2D","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":"124594","customer_id":"124594","source_of_creation":"HotelTonight","reservation_created_date":"2021-06-19 15:10:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"248.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"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3270194","reservation_id":"116925","confirmation_number":"SJ12615709230","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"418.77","nightly_discount":"0.00","subtotal":"418.77","grand_total":"485.29","paid_amount":"485.29","room_type_id":"318","product_id":"1289","siteminder_id":"ABB-HMDCABNYFX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"421.26","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"123854","customer_id":"123854","source_of_creation":"Airbnb","reservation_created_date":"2021-06-10 02:23:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"12.39","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"418.77","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":"3270270","reservation_id":"108519","confirmation_number":"SJ12679730734","room_stay_from":"2021-06-19","room_stay_to":"2021-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"319.27,330.99,330.99,330.99,330.99,330.99","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1974.22","grand_total":"2287.84","paid_amount":"2287.84","room_type_id":"320","product_id":"1330","siteminder_id":"ABB-HM5E8BSN2A","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1985.94","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114959","customer_id":"114959","source_of_creation":"Airbnb","reservation_created_date":"2021-02-25 05:04:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"58.41","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"319.27","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":"3270281","reservation_id":"117143","confirmation_number":"SJ12697883826","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"469.47","nightly_discount":"0.00","subtotal":"469.47","grand_total":"544.05","paid_amount":"544.05","room_type_id":"412","product_id":"1921","siteminder_id":"ABB-HM4EJSR9A3","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"472.26","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124082","customer_id":"124082","source_of_creation":"Airbnb","reservation_created_date":"2021-06-13 05:39:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"13.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"469.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":"3270291","reservation_id":"117377","confirmation_number":"SJ12647989381","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"412.17,417.18","nightly_discount":"0.00,0.00","subtotal":"829.35","grand_total":"961.11","paid_amount":"961.11","room_type_id":"319","product_id":"1943","siteminder_id":"ABB-HMMPTMXERT","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"834.36","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124336","customer_id":"124336","source_of_creation":"Airbnb","reservation_created_date":"2021-06-16 00:06:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"24.54","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"412.17","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"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":"356.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3248277","reservation_id":"109732","confirmation_number":"SJ12686380705","room_stay_from":"2021-06-19","room_stay_to":"2021-06-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.75,149.25,149.25,149.25","nightly_discount":"0.00,0.00,0.00,0","subtotal":"649.50","grand_total":"730.69","paid_amount":"730.69","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116200","customer_id":"116200","source_of_creation":"FE","reservation_created_date":"2021-03-08 01:18:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3253991","reservation_id":"115322","confirmation_number":"SJ12653008988","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"364.65,254.15","nightly_discount":"0.00,0.00","subtotal":"618.80","grand_total":"696.15","paid_amount":"696.15","room_type_id":"413","product_id":"1262","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122035","customer_id":"122035","source_of_creation":"FE","reservation_created_date":"2021-05-16 13:26:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"364.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":"3254037","reservation_id":"114739","confirmation_number":"SJ12624773830","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"279.65","nightly_discount":"0.00","subtotal":"279.65","grand_total":"314.60","paid_amount":"314.60","room_type_id":"319","product_id":"1917","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116495","customer_id":"116495","source_of_creation":"FE","reservation_created_date":"2021-05-07 21:39:44","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":"279.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":"3263343","reservation_id":"114181","confirmation_number":"SJ12645514165","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"279.65,237.15","nightly_discount":"0.00,0.00","subtotal":"516.80","grand_total":"581.40","paid_amount":"581.40","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120821","customer_id":"120821","source_of_creation":"FE","reservation_created_date":"2021-04-30 01:07:36","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 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":"279.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"}]}],"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":"3260806","reservation_id":"116379","confirmation_number":"SJ12654705028","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"364.65","nightly_discount":"0.00","subtotal":"364.65","grand_total":"410.23","paid_amount":"410.23","room_type_id":"413","product_id":"1260","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":"123244","customer_id":"123244","source_of_creation":"PMS","reservation_created_date":"2021-06-02 13:32:09","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":"364.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":"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":"3270226","reservation_id":"117415","confirmation_number":"SJ12644633748","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00","nightly_discount":"0.00","subtotal":"199.00","grand_total":"223.88","paid_amount":"223.88","room_type_id":"412","product_id":"1866","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":"124378","customer_id":"124378","source_of_creation":"PMS","reservation_created_date":"2021-06-16 16:26:48","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"199.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":"3270460","reservation_id":"109404","confirmation_number":"SJ12643545230","room_stay_from":"2021-06-19","room_stay_to":"2021-06-24","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"254.00,254.00,254.00,254.00,254.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1270.00","grand_total":"1428.75","paid_amount":"1428.75","room_type_id":"320","product_id":"1714","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115871","customer_id":"115871","source_of_creation":"PMS","reservation_created_date":"2021-03-04 21:12:34","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"254.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3245501","reservation_id":"104486","confirmation_number":"SJ12662267680","room_stay_from":"2021-06-18","room_stay_to":"2021-06-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-12-31 20:18:03","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"3270078","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","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":"3270550","reservation_id":"111343","confirmation_number":"SJ12660990216","room_stay_from":"2021-06-19","room_stay_to":"2021-06-26","room_stay_status":"Checked-In","room_stay_guest_count":"4","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":"1313","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-03-26 14:30:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"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":"3260807","reservation_id":"116379","confirmation_number":"SJ12687803636","room_confirmation_number":"SJ12654705028","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"123244","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-06-02 13:32:09","reservation_modified_date_time":"2021-06-02 13:32:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123244","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"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"}]},{"room_stay_id":"3270071","reservation_id":"117608","confirmation_number":"SJ12613593981","room_confirmation_number":"SJ12618476870","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"124577","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-06-19 04:26:14","reservation_modified_date_time":"2021-06-19 04:26:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124577","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3263344","reservation_id":"114181","confirmation_number":"SJ12691705320","room_confirmation_number":"SJ12645514165","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"120821","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-06 21:31:12","reservation_modified_date_time":"2021-06-06 21:31:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120821","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"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":"3247103","reservation_id":"114578","confirmation_number":"SJ12648420622","room_confirmation_number":"SJ12638712873","room_stay_from":"2021-06-19","room_stay_to":"2021-06-22","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"121269","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-05-05 15:50:09","reservation_modified_date_time":"2021-05-05 15:50:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121269","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3206923","reservation_id":"108957","confirmation_number":"SJ12655046706","room_confirmation_number":"SJ12698893079","room_stay_from":"2021-06-19","room_stay_to":"2021-06-26","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1777","service_quantity":"1","customer_traveller_id":"115419","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-03-01 20:32:12","reservation_modified_date_time":"2021-03-01 20:32:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115419","canceled_nights_data":"","posAmt_airbnb_taxpaid":"175.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[{"room_stay_id":"3270080","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":"75.00","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-19 05:25:28","reservation_modified_date_time":"2021-06-19 05:25:28","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","changedComment":"Reservation created with partial past date","deltaChange":"50.00","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"}]},{"room_stay_id":"3270551","reservation_id":"111343","confirmation_number":"SJ12640097387","room_confirmation_number":"SJ12660990216","room_stay_from":"2021-06-19","room_stay_to":"2021-06-26","room_stay_status":"Active","nightly_price":"50,50,50,50,50,50,50","nightly_discount":"0,0,0,0,0,0,0","subtotal":"350.00","grand_total":"350.00","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"77106","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-19 23:07:39","reservation_modified_date_time":"2021-06-19 23:07:39","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":"50","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":"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":"3254038","reservation_id":"114739","confirmation_number":"SJ12661508500","room_confirmation_number":"SJ12624773830","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","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":"116495","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-07 21:39:44","reservation_modified_date_time":"2021-05-19 15:13:04","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":"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":"3260808","reservation_id":"116379","confirmation_number":"SJ12649635666","room_confirmation_number":"SJ12654705028","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","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":"123244","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-02 13:32:09","reservation_modified_date_time":"2021-06-02 13:32:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123244","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":"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":"3263382","reservation_id":"114880","confirmation_number":"SJ12645026837","room_confirmation_number":"SJ12689622235","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","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":"121617","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-10 03:50:07","reservation_modified_date_time":"2021-06-06 21:44:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121617","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":"3268085","reservation_id":"117367","confirmation_number":"SJ12640686573","room_confirmation_number":"SJ12650447093","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","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":"124325","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-15 21:31:08","reservation_modified_date_time":"2021-06-15 21:31:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124325","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":"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":"3269933","reservation_id":"116660","confirmation_number":"SJ12618897289","room_confirmation_number":"SJ12630328958","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","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":"123552","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-06 16:22:13","reservation_modified_date_time":"2021-06-19 00:02:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123552","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":"3270072","reservation_id":"117608","confirmation_number":"SJ12639096286","room_confirmation_number":"SJ12618476870","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","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":"124577","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-19 04:26:14","reservation_modified_date_time":"2021-06-19 04:26:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124577","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"3270081","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-19 05:25:29","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":"3270195","reservation_id":"116925","confirmation_number":"SJ12679090422","room_confirmation_number":"SJ12615709230","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"123854","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-10 02:23:07","reservation_modified_date_time":"2021-06-19 14:19:23","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123854","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3270225","reservation_id":"117374","confirmation_number":"SJ12664613960","room_confirmation_number":"SJ12619179508","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","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":"124332","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-15 23:31:12","reservation_modified_date_time":"2021-06-19 14:30:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124332","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3270227","reservation_id":"117415","confirmation_number":"SJ12667320145","room_confirmation_number":"SJ12644633748","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","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":"124378","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-16 16:26:48","reservation_modified_date_time":"2021-06-19 14:31:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124378","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":"3270257","reservation_id":"117624","confirmation_number":"SJ12696539706","room_confirmation_number":"SJ12640260573","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","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":"124594","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-19 15:10:12","reservation_modified_date_time":"2021-06-19 15:10:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124594","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":"3270282","reservation_id":"117143","confirmation_number":"SJ12698013566","room_confirmation_number":"SJ12697883826","room_stay_from":"2021-06-19","room_stay_to":"2021-06-20","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124082","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-13 05:39:08","reservation_modified_date_time":"2021-06-19 15:29:05","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124082","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3253990","reservation_id":"115322","confirmation_number":"SJ12672389350","room_confirmation_number":"SJ12653008988","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"122035","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-16 13:26:06","reservation_modified_date_time":"2021-05-19 14:58:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122035","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3263345","reservation_id":"114181","confirmation_number":"SJ12629126875","room_confirmation_number":"SJ12645514165","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"120821","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-30 01:07:36","reservation_modified_date_time":"2021-06-06 21:31:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120821","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"3270290","reservation_id":"115029","confirmation_number":"SJ12663620272","room_confirmation_number":"SJ12695888732","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"121744","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-12 00:11:11","reservation_modified_date_time":"2021-06-19 15:43:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121744","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3270292","reservation_id":"117377","confirmation_number":"SJ12694450118","room_confirmation_number":"SJ12647989381","room_stay_from":"2021-06-19","room_stay_to":"2021-06-21","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124336","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-16 00:06:19","reservation_modified_date_time":"2021-06-19 15:43:40","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124336","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3238984","reservation_id":"113546","confirmation_number":"SJ12632724781","room_confirmation_number":"SJ12612786309","room_stay_from":"2021-06-18","room_stay_to":"2021-06-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"102464","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 18:03:00","reservation_modified_date_time":"2021-04-21 18:03:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102464","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3241572","reservation_id":"113821","confirmation_number":"SJ12635276087","room_confirmation_number":"SJ12615951194","room_stay_from":"2021-06-19","room_stay_to":"2021-06-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"120445","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-24 23:53:08","reservation_modified_date_time":"2021-04-24 23:53:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120445","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3247104","reservation_id":"114578","confirmation_number":"SJ12699354904","room_confirmation_number":"SJ12638712873","room_stay_from":"2021-06-19","room_stay_to":"2021-06-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"121269","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-05 15:50:09","reservation_modified_date_time":"2021-05-05 15:50:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121269","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3263930","reservation_id":"114129","confirmation_number":"SJ12696653402","room_confirmation_number":"SJ12675888561","room_stay_from":"2021-06-19","room_stay_to":"2021-06-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"120764","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-29 01:55:08","reservation_modified_date_time":"2021-06-07 23:48:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120764","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3245502","reservation_id":"104486","confirmation_number":"SJ12677204252","room_confirmation_number":"SJ12662267680","room_stay_from":"2021-06-18","room_stay_to":"2021-06-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110842","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-31 20:18:03","reservation_modified_date_time":"2021-05-02 16:19:11","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3248278","reservation_id":"109732","confirmation_number":"SJ12641544083","room_confirmation_number":"SJ12686380705","room_stay_from":"2021-06-19","room_stay_to":"2021-06-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"116200","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-08 01:18:27","reservation_modified_date_time":"2021-05-08 12:50:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116200","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3269179","reservation_id":"110128","confirmation_number":"SJ12695314473","room_confirmation_number":"SJ12656656585","room_stay_from":"2021-06-17","room_stay_to":"2021-06-23","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"116634","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-12 12:37:11","reservation_modified_date_time":"2021-06-17 21:41:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116634","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3243640","reservation_id":"114116","confirmation_number":"SJ12619241569","room_confirmation_number":"SJ12659302837","room_stay_from":"2021-06-19","room_stay_to":"2021-06-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"120749","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-28 22:26:27","reservation_modified_date_time":"2021-04-29 13:27:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120749","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3270463","reservation_id":"109404","confirmation_number":"SJ12634157859","room_confirmation_number":"SJ12643545230","room_stay_from":"2021-06-19","room_stay_to":"2021-06-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"115871","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 21:12:34","reservation_modified_date_time":"2021-06-19 20:22:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115871","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"3270273","reservation_id":"108519","confirmation_number":"SJ12673520017","room_confirmation_number":"SJ12679730734","room_stay_from":"2021-06-19","room_stay_to":"2021-06-25","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114959","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-25 05:04:11","reservation_modified_date_time":"2021-06-19 15:25:06","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114959","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3206924","reservation_id":"108957","confirmation_number":"SJ12641232644","room_confirmation_number":"SJ12698893079","room_stay_from":"2021-06-19","room_stay_to":"2021-06-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"115419","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-01 20:32:12","reservation_modified_date_time":"2021-03-01 20:32:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115419","canceled_nights_data":"","posAmt_airbnb_taxpaid":"175.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3251015","reservation_id":"111343","confirmation_number":"SJ12673678965","room_confirmation_number":"SJ12660990216","room_stay_from":"2021-06-19","room_stay_to":"2021-06-26","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":"117876","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-26 14:30:17","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}