{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-03-11","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":14,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1302,1303,1307,1308,1304,1305,1267,1268,1260,1261,1309,1310,1271,1272,1291,1711,1269,1270,1262,1263,1311,1312","bundle_block_bookings":[{"confirmation_number":"SJB12645533016","room_stay_from":"2021-03-07","room_stay_to":"2021-03-12","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12652483951","room_stay_from":"2021-03-07","room_stay_to":"2021-03-12","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12671132231","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12697050429","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12651873810","room_stay_from":"2021-03-10","room_stay_to":"2021-03-12","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12612257914","room_stay_from":"2021-03-10","room_stay_to":"2021-03-12","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12662143500","room_stay_from":"2021-03-07","room_stay_to":"2021-03-12","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12633274365","room_stay_from":"2021-03-11","room_stay_to":"2021-03-12","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12672693559","room_stay_from":"2021-03-11","room_stay_to":"2021-03-12","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12657649085","room_stay_from":"2021-03-06","room_stay_to":"2021-03-13","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12683755032","room_stay_from":"2021-03-06","room_stay_to":"2021-03-13","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12651602383","room_stay_from":"2021-03-06","room_stay_to":"2021-03-13","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12646436467","room_stay_from":"2021-03-11","room_stay_to":"2021-03-14","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12678968073","room_stay_from":"2021-03-11","room_stay_to":"2021-03-14","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12633542890","room_stay_from":"2021-03-09","room_stay_to":"2021-03-14","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJB12675995781","room_stay_from":"2021-03-09","room_stay_to":"2021-03-14","bundle_room":"0","product_id":"1263"},{"confirmation_number":"SJB12630060022","room_stay_from":"2021-03-11","room_stay_to":"2021-03-18","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12617638594","room_stay_from":"2021-03-11","room_stay_to":"2021-03-18","bundle_room":"0","product_id":"1312"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3178643","reservation_id":"105272","confirmation_number":"SJ12627571864","room_stay_from":"2021-03-05","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,209.30,181.30,181.30,181.30,181.30,181.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1325.10","grand_total":"1490.74","paid_amount":"1490.74","room_type_id":"319","product_id":"1276","siteminder_id":"BDC-3103410106","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":"111657","customer_id":"111657","source_of_creation":"Booking.com","reservation_created_date":"2021-01-13 16:23:53","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":"181.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":"3185175","reservation_id":"106181","confirmation_number":"SJ12669214863","room_stay_from":"2021-03-11","room_stay_to":"2021-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.30,230.30,230.30,202.30","nightly_discount":"0,0,0,0","subtotal":"865.20","grand_total":"973.35","paid_amount":"973.35","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-3316238552","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":"112588","customer_id":"112588","source_of_creation":"Booking.com","reservation_created_date":"2021-01-26 18:08:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"347.48","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"202.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":"3191687","reservation_id":"106897","confirmation_number":"SJ12677733366","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"3","nightly_price":"304.92,304.92,304.92,304.92","nightly_discount":"0,0,0,0","subtotal":"1219.68","grand_total":"1372.14","paid_amount":"1372.14","room_type_id":"320","product_id":"1329","siteminder_id":"BDC-3480599885","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":"113326","customer_id":"113326","source_of_creation":"Booking.com","reservation_created_date":"2021-02-04 16:14:24","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"304.92","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":"3193487","reservation_id":"105509","confirmation_number":"SJ12662125810","room_stay_from":"2021-03-10","room_stay_to":"2021-03-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,209.30,209.30,181.30,181.30,181.30,181.30,181.30,209.30","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"1897.00","grand_total":"2134.13","paid_amount":"2134.13","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2346008640","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":"111924","customer_id":"111924","source_of_creation":"Booking.com","reservation_created_date":"2021-01-17 16:46:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"181.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":"3196161","reservation_id":"107396","confirmation_number":"SJ12689394958","room_stay_from":"2021-03-10","room_stay_to":"2021-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.56,193.79,218.09","nightly_discount":"0,0,0","subtotal":"587.44","grand_total":"660.87","paid_amount":"660.87","room_type_id":"319","product_id":"1314","siteminder_id":"BDC-3864019945","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":"116481","customer_id":"113853","source_of_creation":"Booking.com","reservation_created_date":"2021-02-12 01:26:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"119.24","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"193.79","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":"3196856","reservation_id":"107369","confirmation_number":"SJ12623999260","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.86,146.85,146.85,163.86","nightly_discount":"0,0,0,0","subtotal":"621.42","grand_total":"699.10","paid_amount":"699.10","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-3094628637","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":"113825","customer_id":"113825","source_of_creation":"Booking.com","reservation_created_date":"2021-02-11 20:30:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"129.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"163.86","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":"3201694","reservation_id":"107921","confirmation_number":"SJ12673632852","room_stay_from":"2021-03-09","room_stay_to":"2021-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"194.8,194.8,215.8,243.8","nightly_discount":"0,0,0,0","subtotal":"849.20","grand_total":"955.35","paid_amount":"955.35","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-2170269521","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":"114383","customer_id":"114383","source_of_creation":"Booking.com","reservation_created_date":"2021-02-17 21:56:35","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"215.8","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":"3204048","reservation_id":"105823","confirmation_number":"SJ12698854669","room_stay_from":"2021-03-11","room_stay_to":"2021-03-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.08,222.08,222.08","nightly_discount":"0,0,0","subtotal":"639.24","grand_total":"719.14","paid_amount":"719.14","room_type_id":"319","product_id":"1756","siteminder_id":"BDC-3010702494","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":"112228","customer_id":"112228","source_of_creation":"Booking.com","reservation_created_date":"2021-01-22 02:06:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"128.56","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.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":"3212825","reservation_id":"105486","confirmation_number":"SJ12698820859","room_stay_from":"2021-03-10","room_stay_to":"2021-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.17,163.17,188.37,188.37,163.17","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"866.25","grand_total":"974.53","paid_amount":"974.53","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-2929037812","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":"111901","customer_id":"111901","source_of_creation":"Booking.com","reservation_created_date":"2021-01-17 00:37:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"178.43","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"163.17","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3213785","reservation_id":"100486","confirmation_number":"SJ12626904822","room_stay_from":"2021-03-11","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"336.00","nightly_discount":"0","subtotal":"336.00","grand_total":"378.00","paid_amount":"378.00","room_type_id":"319","product_id":"1942","siteminder_id":"BDC-3077578594","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":"106505","customer_id":"106505","source_of_creation":"Booking.com","reservation_created_date":"2020-09-17 16:45:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"64.98","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"336.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3214080","reservation_id":"106181","confirmation_number":"SJ12625383329","room_stay_from":"2021-03-11","room_stay_to":"2021-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"202.30,230.30,230.30,202.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"865.20","grand_total":"973.35","paid_amount":"973.35","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-3316238552","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":"112588","customer_id":"112588","source_of_creation":"Booking.com","reservation_created_date":"2021-01-26 18:08:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"347.48","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"202.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":"3214189","reservation_id":"109997","confirmation_number":"SJ12653852523","room_stay_from":"2021-03-10","room_stay_to":"2021-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"266.98,266.98,266.98","nightly_discount":"0,0,0","subtotal":"800.94","grand_total":"901.06","paid_amount":"901.06","room_type_id":"319","product_id":"1943","siteminder_id":"BDC-3914653582","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":"116487","customer_id":"116487","source_of_creation":"Booking.com","reservation_created_date":"2021-03-10 21:19:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"52.56","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"266.98","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":"3179380","reservation_id":"105388","confirmation_number":"SJ12664179352","room_stay_from":"2021-03-11","room_stay_to":"2021-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"123.04,145.44,145.44,123.04,123.04,123.04,123.04","nightly_discount":"0,0,0,0,0,0,0","subtotal":"906.08","grand_total":"1019.34","paid_amount":"1019.34","room_type_id":"413","product_id":"1273","siteminder_id":"EXP-1730260085","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"350.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111786","customer_id":"111786","source_of_creation":"Expedia","reservation_created_date":"2021-01-15 20:51:09","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"123.04","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":"3180209","reservation_id":"105491","confirmation_number":"SJ12619960936","room_stay_from":"2021-03-11","room_stay_to":"2021-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"4","nightly_price":"257.04,279.44,279.44,257.04,257.04,257.04,257.04","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1844.08","grand_total":"2074.59","paid_amount":"2074.59","room_type_id":"320","product_id":"1332","siteminder_id":"EXP-1730591094","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":"111906","customer_id":"111906","source_of_creation":"Expedia","reservation_created_date":"2021-01-17 03:12: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":"257.04","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":"3180411","reservation_id":"104538","confirmation_number":"SJ12649150289","room_stay_from":"2021-03-09","room_stay_to":"2021-03-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,181.30,209.30,209.30,181.30,181.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1325.10","grand_total":"1490.74","paid_amount":"1490.74","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1726858080","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":"110891","customer_id":"110891","source_of_creation":"Expedia","reservation_created_date":"2021-01-01 21:06:12","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":"126","group_rooms":null,"currentDayPrice":"181.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":"3190200","reservation_id":"105014","confirmation_number":"SJ12665244487","room_stay_from":"2021-03-07","room_stay_to":"2021-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.04,145.04,145.04,145.04,145.04,167.44","nightly_discount":"0,0,0,0,0,0","subtotal":"892.64","grand_total":"1004.22","paid_amount":"1004.22","room_type_id":"319","product_id":"1291","siteminder_id":"EXP-1728481731","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":"111381","customer_id":"111381","source_of_creation":"Expedia","reservation_created_date":"2021-01-08 18:06:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"178.53","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"145.04","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":"3202394","reservation_id":"108213","confirmation_number":"SJ12690781345","room_stay_from":"2021-03-10","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"207.20,231.20","nightly_discount":"0,0","subtotal":"438.40","grand_total":"493.20","paid_amount":"493.20","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1740282406","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":"114677","customer_id":"114677","source_of_creation":"Expedia","reservation_created_date":"2021-02-21 21:57:10","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"231.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":"3204768","reservation_id":"106152","confirmation_number":"SJ12646784630","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,181.30,181.30,181.30","nightly_discount":"0,0,0,0","subtotal":"753.20","grand_total":"847.35","paid_amount":"847.35","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1732857623","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":"112566","customer_id":"112566","source_of_creation":"Expedia","reservation_created_date":"2021-01-26 14:21:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"181.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":"3207816","reservation_id":"107927","confirmation_number":"SJ12661839986","room_stay_from":"2021-03-11","room_stay_to":"2021-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.20,287.20","nightly_discount":"0,0","subtotal":"542.40","grand_total":"610.20","paid_amount":"610.20","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1739136623","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":"114390","customer_id":"114390","source_of_creation":"Expedia","reservation_created_date":"2021-02-17 23:07:21","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","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":"255.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":"3210964","reservation_id":"104807","confirmation_number":"SJ12626941891","room_stay_from":"2021-03-06","room_stay_to":"2021-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"279.44,257.04,257.04,257.04,257.04,257.04,279.44","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1844.08","grand_total":"2074.59","paid_amount":"2074.59","room_type_id":"320","product_id":"1324","siteminder_id":"EXP-1727781688","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":"116173","customer_id":"116173","source_of_creation":"Expedia","reservation_created_date":"2021-01-05 21:01:12","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1271,1272","currentDayPrice":"257.04","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":"3212188","reservation_id":"105045","confirmation_number":"SJ12617155812","room_stay_from":"2021-03-11","room_stay_to":"2021-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"147.76,173.36","nightly_discount":"0,0","subtotal":"321.12","grand_total":"361.26","paid_amount":"361.26","room_type_id":"319","product_id":"1313","siteminder_id":"EXP-1728608837","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":"111421","customer_id":"111421","source_of_creation":"Expedia","reservation_created_date":"2021-01-09 02:51:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"147.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":"3212516","reservation_id":"109039","confirmation_number":"SJ12694011435","room_stay_from":"2021-03-11","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.60","nightly_discount":"0","subtotal":"209.60","grand_total":"235.80","paid_amount":"235.80","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1743210008","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":"115503","customer_id":"115503","source_of_creation":"Expedia","reservation_created_date":"2021-03-02 20:02:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"41.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"209.60","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":"3213262","reservation_id":"108144","confirmation_number":"SJ12664196022","room_stay_from":"2021-03-10","room_stay_to":"2021-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"216.75,239.25,269.25","nightly_discount":"0,0,0","subtotal":"725.25","grand_total":"815.90","paid_amount":"815.90","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1740025797","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":"114611","customer_id":"114611","source_of_creation":"Expedia","reservation_created_date":"2021-02-20 22:22:35","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"239.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":"3213264","reservation_id":"109647","confirmation_number":"SJ12698359016","room_stay_from":"2021-03-11","room_stay_to":"2021-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"322.15,364.65","nightly_discount":"0,0","subtotal":"686.80","grand_total":"772.65","paid_amount":"772.65","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1744827832","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":"116133","customer_id":"116133","source_of_creation":"Expedia","reservation_created_date":"2021-03-07 05:32:26","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"322.15","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":"3213852","reservation_id":"110033","confirmation_number":"SJ12643882128","room_stay_from":"2021-04-08","room_stay_to":"2021-04-11","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,276.75,276.75","nightly_discount":"0,0,0","subtotal":"800.25","grand_total":"900.28","paid_amount":"277.60","room_type_id":"319","product_id":"1943","siteminder_id":"EXP-1746272125","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":"116528","customer_id":"116528","source_of_creation":"Expedia","reservation_created_date":"2021-03-11 04:37:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3213933","reservation_id":"109682","confirmation_number":"SJ12681922802","room_stay_from":"2021-03-22","room_stay_to":"2021-03-25","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"207.4,207.4,207.4","nightly_discount":"0,0,0","subtotal":"622.20","grand_total":"699.98","paid_amount":"0.00","room_type_id":"319","product_id":"1756","siteminder_id":"EXP-1744953277","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":"116169","customer_id":"116169","source_of_creation":"Expedia","reservation_created_date":"2021-03-07 18:47:40","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3181140","reservation_id":"105587","confirmation_number":"SJ12687092015","room_stay_from":"2021-03-11","room_stay_to":"2021-03-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.25,190.81,190.81,169.25,169.25","nightly_discount":"0,0,0,0,0","subtotal":"889.37","grand_total":"1000.54","paid_amount":"1000.54","room_type_id":"411","product_id":"1296","siteminder_id":"GAM-R2287674337","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":"112008","customer_id":"112008","source_of_creation":"Getaroom.com","reservation_created_date":"2021-01-19 00:04:12","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":"169.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":"3187992","reservation_id":"106494","confirmation_number":"SJ12681860916","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"220.45,220.45,220.45,220.45","nightly_discount":"0,0,0,0","subtotal":"881.80","grand_total":"992.03","paid_amount":"992.03","room_type_id":"320","product_id":"1330","siteminder_id":"GAM-R2303528168","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":"112905","customer_id":"112905","source_of_creation":"Getaroom.com","reservation_created_date":"2021-01-30 19:14:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"220.45","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3194786","reservation_id":"107224","confirmation_number":"SJ12667975514","room_stay_from":"2021-03-07","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.94,171.94,155.77,155.77,171.94","nightly_discount":"0,0,0,0,0","subtotal":"827.36","grand_total":"930.78","paid_amount":"930.78","room_type_id":"318","product_id":"1282","siteminder_id":"GAM-R2318975156","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":"113236","customer_id":"113236","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-09 17:16:09","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"171.94","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3212399","reservation_id":"106925","confirmation_number":"SJ12638567757","room_stay_from":"2021-03-09","room_stay_to":"2021-03-14","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"390.05,390.05,390.05,390.05,378.35","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1938.55","grand_total":"2246.50","paid_amount":"2246.50","room_type_id":"320","product_id":"1321","siteminder_id":"ABB-HMDEZWWC2Y","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1950.25","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113361","customer_id":"113361","source_of_creation":"Airbnb","reservation_created_date":"2021-02-04 22:24:29","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 208+209","ota_service_fee_amount":"0","commision_charges":"57.35","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1262,1263","currentDayPrice":"390.05","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3212943","reservation_id":"109868","confirmation_number":"SJ12643301016","room_stay_from":"2021-03-09","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"341.61,347.82,347.82","nightly_discount":"0.00,0.00,0.00","subtotal":"1037.25","grand_total":"1202.03","paid_amount":"1202.03","room_type_id":"319","product_id":"1310","siteminder_id":"ABB-HMJK4RFD55","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1043.46","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116357","customer_id":"116357","source_of_creation":"Airbnb","reservation_created_date":"2021-03-09 18:28:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"30.69","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"347.82","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":"3213912","reservation_id":"105383","confirmation_number":"SJ12633984714","room_stay_from":"2021-03-11","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"236.26","nightly_discount":"0.00","subtotal":"236.26","grand_total":"273.79","paid_amount":"273.79","room_type_id":"319","product_id":"1309","siteminder_id":"ABB-HM2QPHHQ9W","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"237.66","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111779","customer_id":"111779","source_of_creation":"Airbnb","reservation_created_date":"2021-01-15 18:59:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"6.99","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"236.26","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":"3213918","reservation_id":"107625","confirmation_number":"SJ12617542867","room_stay_from":"2021-03-11","room_stay_to":"2021-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"311.10,307.37","nightly_discount":"0.00,0.00","subtotal":"618.47","grand_total":"716.72","paid_amount":"716.72","room_type_id":"319","product_id":"1319","siteminder_id":"ABB-HMWSF2ETD9","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"622.20","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114081","customer_id":"114081","source_of_creation":"Airbnb","reservation_created_date":"2021-02-14 20:18:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"18.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"311.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3214287","reservation_id":"109951","confirmation_number":"SJ12615168970","room_stay_from":"2021-03-11","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"290.23","nightly_discount":"0.00","subtotal":"290.23","grand_total":"340.81","paid_amount":"340.81","room_type_id":"413","product_id":"1266","siteminder_id":"ABB-HMJBMTQEBK","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"320.28","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116448","customer_id":"116448","source_of_creation":"Airbnb","reservation_created_date":"2021-03-10 14:28:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"9.42","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"290.23","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":"3182163","reservation_id":"105770","confirmation_number":"SJ12667254541","room_stay_from":"2021-03-11","room_stay_to":"2021-03-14","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"306.75,336.75,336.75","nightly_discount":"0.00,0.00,0.00","subtotal":"980.25","grand_total":"1102.78","paid_amount":"1102.78","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":"112171","customer_id":"112171","source_of_creation":"FE","reservation_created_date":"2021-01-21 02:22: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":"306.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":"3183030","reservation_id":"105898","confirmation_number":"SJ12647896967","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"216.75,216.75,216.75,216.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"867.00","grand_total":"975.38","paid_amount":"975.38","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112285","customer_id":"112285","source_of_creation":"FE","reservation_created_date":"2021-01-23 01:06:24","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":"216.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":"3184777","reservation_id":"106151","confirmation_number":"SJ12628649828","room_stay_from":"2021-03-07","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"306.75,306.75,306.75,306.75,306.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1533.75","grand_total":"1725.47","paid_amount":"1725.47","room_type_id":"320","product_id":"1328","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112565","customer_id":"112565","source_of_creation":"FE","reservation_created_date":"2021-01-26 14:12:14","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1302,1303","currentDayPrice":"306.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":"3197348","reservation_id":"107515","confirmation_number":"SJ12632825089","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"216.75,194.25,194.25,216.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"822.00","grand_total":"924.75","paid_amount":"924.75","room_type_id":"413","product_id":"1267","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":"113971","customer_id":"113971","source_of_creation":"FE","reservation_created_date":"2021-02-13 16:22:49","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","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":"216.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":"3214045","reservation_id":"110072","confirmation_number":"SJ12637407321","room_stay_from":"2021-03-11","room_stay_to":"2021-03-12","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"343.40","nightly_discount":"0.00","subtotal":"343.40","grand_total":"386.33","paid_amount":"386.33","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116576","customer_id":"116576","source_of_creation":"FE","reservation_created_date":"2021-03-11 20:15:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"343.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3189341","reservation_id":"106562","confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1913","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":"101703","customer_id":"101703","source_of_creation":"PMS","reservation_created_date":"2021-01-31 18:54:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"0.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3193453","reservation_id":"107086","confirmation_number":"SJ12629734074","room_stay_from":"2021-03-09","room_stay_to":"2021-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"216.75,216.75,239.25,269.25,269.25,246.75","nightly_discount":"10.84,10.84,11.96,13.46,13.46,12.34","subtotal":"1458.00","grand_total":"1558.24","paid_amount":"1558.24","room_type_id":"319","product_id":"1287","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":"113536","customer_id":"113536","source_of_creation":"PMS","reservation_created_date":"2021-02-07 16:12:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"239.25","currentDayDiscount":"11.96","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3193660","reservation_id":"107096","confirmation_number":"SJ12631412131","room_stay_from":"2021-03-09","room_stay_to":"2021-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"216.75,216.75,239.25,269.25,269.25,246.75","nightly_discount":"10.84,10.84,11.96,13.46,13.46,12.34","subtotal":"1458.00","grand_total":"1558.24","paid_amount":"1558.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":"113549","customer_id":"113549","source_of_creation":"PMS","reservation_created_date":"2021-02-07 19:10:01","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":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"239.25","currentDayDiscount":"11.96","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3193723","reservation_id":"107065","confirmation_number":"SJ12636316672","room_stay_from":"2021-03-06","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"220.00,220.00,220.00,220.00,220.00,220.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1320.00","grand_total":"1485.00","paid_amount":"1485.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":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113512","customer_id":"113512","source_of_creation":"PMS","reservation_created_date":"2021-02-07 00:37:22","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":"220.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":"3202290","reservation_id":"108191","confirmation_number":"SJ12645704152","room_stay_from":"2021-03-09","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.00,224.00,224.00","nightly_discount":"0.00,0.00,0.00","subtotal":"672.00","grand_total":"756.00","paid_amount":"756.00","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":"114657","customer_id":"114657","source_of_creation":"PMS","reservation_created_date":"2021-02-21 18:41:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"224.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":"3207820","reservation_id":"106747","confirmation_number":"SJ12686628950","room_stay_from":"2021-03-06","room_stay_to":"2021-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.30,212.30,212.30,212.30,212.30,212.30,212.30","nightly_discount":"0.00,0.00,0.00,0.00,0,0,0","subtotal":"1486.10","grand_total":"1671.87","paid_amount":"1671.87","room_type_id":"318","product_id":"1281","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":"113168","customer_id":"113168","source_of_creation":"PMS","reservation_created_date":"2021-02-02 18:25:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"212.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":"3213267","reservation_id":"109627","confirmation_number":"SJ12617657554","room_stay_from":"2021-03-10","room_stay_to":"2021-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116103","customer_id":"116103","source_of_creation":"PMS","reservation_created_date":"2021-03-06 23:27:40","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"0.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3213768","reservation_id":"108831","confirmation_number":"SJ12627091441","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.75,261.75,261.75,299.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1084.50","grand_total":"1220.07","paid_amount":"313.88","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":"115289","customer_id":"115289","source_of_creation":"PMS","reservation_created_date":"2021-02-28 16:21:42","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","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3213821","reservation_id":"109878","confirmation_number":"SJ12629778153","room_stay_from":"2021-03-09","room_stay_to":"2021-03-11","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"250.00,0.00","nightly_discount":"0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116370","customer_id":"116370","source_of_creation":"PMS","reservation_created_date":"2021-03-09 20:28:35","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3214174","reservation_id":"108092","confirmation_number":"SJ12681091358","room_stay_from":"2021-04-14","room_stay_to":"2021-04-19","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.25,224.25,224.25,194.25,194.25","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"1031.25","grand_total":"1160.15","paid_amount":"218.53","room_type_id":"319","product_id":"1943","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":"114559","customer_id":"114559","source_of_creation":"PMS","reservation_created_date":"2021-02-20 02:59:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3186182","reservation_id":"106288","confirmation_number":"SJ12641587355","room_stay_from":"2021-03-11","room_stay_to":"2021-03-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.33,113.33,113.33","nightly_discount":"0.00,0.00,0","subtotal":"339.99","grand_total":"339.99","paid_amount":"84.38","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-01-27 23:17:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.33","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3194581","reservation_id":"106276","confirmation_number":"SJ12662472678","room_stay_from":"2021-03-11","room_stay_to":"2021-03-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.33,113.33,113.33","nightly_discount":"0.00,0.00,0.00","subtotal":"339.99","grand_total":"339.99","paid_amount":"339.99","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-01-27 22:44:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.33","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3211122","reservation_id":"105423","confirmation_number":"SJ12697224644","room_stay_from":"2021-03-06","room_stay_to":"2021-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.57,165.57,165.57,165.57,165.57,165.57,165.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1159.00","grand_total":"1159.00","paid_amount":"0.00","room_type_id":"319","product_id":"1711","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-01-16 02:33:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"165.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3211143","reservation_id":"108561","confirmation_number":"SJ12616916396","room_stay_from":"2021-02-26","room_stay_to":"2021-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.57,165.57,165.57,165.57,165.57,165.57,165.58,165.57,165.57,165.57,165.57,165.57,165.57,165.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2318.00","grand_total":"2318.00","paid_amount":"0.00","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-02-25 19:10:26","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"165.58","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":"3211509","reservation_id":"103544","confirmation_number":"SJ12662068198","room_stay_from":"2021-03-07","room_stay_to":"2021-03-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"798.00","grand_total":"798.00","paid_amount":"196.88","room_type_id":"413","product_id":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-12-06 22:11:28","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":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3211511","reservation_id":"103542","confirmation_number":"SJ12627064263","room_stay_from":"2021-03-07","room_stay_to":"2021-03-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0,0,0,0,0,0","subtotal":"798.00","grand_total":"798.00","paid_amount":"196.88","room_type_id":"413","product_id":"1268","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-12-06 22:08:46","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.00","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3201695","reservation_id":"107921","confirmation_number":"SJ12627580076","room_confirmation_number":"SJ12673632852","room_stay_from":"2021-03-09","room_stay_to":"2021-03-13","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"114383","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-20 21:39:59","reservation_modified_date_time":"2021-02-20 21:39:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114383","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":"3212189","reservation_id":"105045","confirmation_number":"SJ12648149116","room_confirmation_number":"SJ12617155812","room_stay_from":"2021-03-11","room_stay_to":"2021-03-13","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":"111421","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-03-08 22:59:14","reservation_modified_date_time":"2021-03-08 22:59:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111421","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":"3179381","reservation_id":"105388","confirmation_number":"SJ12685305604","room_confirmation_number":"SJ12664179352","room_stay_from":"2021-03-11","room_stay_to":"2021-03-18","room_stay_status":"Active","nightly_price":"50,50,50,50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"350.00","grand_total":"393.75","paid_amount":"393.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"111786","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-01-15 20:51:09","reservation_modified_date_time":"2021-01-15 20:51:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111786","canceled_nights_data":"","posAmt_airbnb_taxpaid":"350.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3178642","reservation_id":"105272","confirmation_number":"SJ12659829541","room_confirmation_number":"SJ12627571864","room_stay_from":"2021-03-05","room_stay_to":"2021-03-12","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":"111657","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-13 16:23:53","reservation_modified_date_time":"2021-01-13 21:37:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111657","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":"3183031","reservation_id":"105898","confirmation_number":"SJ12610598610","room_confirmation_number":"SJ12647896967","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","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":"112285","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-23 01:06:24","reservation_modified_date_time":"2021-01-23 01:06:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112285","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":"3184778","reservation_id":"106151","confirmation_number":"SJ12627627113","room_confirmation_number":"SJ12628649828","room_stay_from":"2021-03-07","room_stay_to":"2021-03-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.62","paid_amount":"140.62","product_id":"1776","service_quantity":"1","customer_traveller_id":"112565","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 14:12:14","reservation_modified_date_time":"2021-01-26 14:12:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112565","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":"3187993","reservation_id":"106494","confirmation_number":"SJ12658773794","room_confirmation_number":"SJ12681860916","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112905","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-30 19:14:09","reservation_modified_date_time":"2021-01-30 19:14:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112905","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":"3191686","reservation_id":"106897","confirmation_number":"SJ12612945238","room_confirmation_number":"SJ12677733366","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","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":"113326","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-04 16:14:24","reservation_modified_date_time":"2021-02-04 16:14:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113326","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":"3193724","reservation_id":"107065","confirmation_number":"SJ12626866930","room_confirmation_number":"SJ12636316672","room_stay_from":"2021-03-06","room_stay_to":"2021-03-12","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":"113512","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-07 00:37:22","reservation_modified_date_time":"2021-02-07 20:24:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113512","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":"3194787","reservation_id":"107224","confirmation_number":"SJ12689099508","room_confirmation_number":"SJ12667975514","room_stay_from":"2021-03-07","room_stay_to":"2021-03-12","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":"113236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-09 17:16:09","reservation_modified_date_time":"2021-02-09 17:16:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113236","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":"3196859","reservation_id":"107369","confirmation_number":"SJ12619486802","room_confirmation_number":"SJ12623999260","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"113825","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-11 20:30:12","reservation_modified_date_time":"2021-02-12 20:00:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113825","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":"3197349","reservation_id":"107515","confirmation_number":"SJ12668788183","room_confirmation_number":"SJ12632825089","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","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":"113971","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-13 16:22:49","reservation_modified_date_time":"2021-02-13 16:22:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113971","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":"3202291","reservation_id":"108191","confirmation_number":"SJ12655928360","room_confirmation_number":"SJ12645704152","room_stay_from":"2021-03-09","room_stay_to":"2021-03-12","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":"114657","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-21 18:41:06","reservation_modified_date_time":"2021-02-21 18:41:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114657","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":"3202395","reservation_id":"108213","confirmation_number":"SJ12615776804","room_confirmation_number":"SJ12690781345","room_stay_from":"2021-03-10","room_stay_to":"2021-03-12","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":"114677","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-21 21:57:10","reservation_modified_date_time":"2021-02-21 21:57:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114677","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":"3204769","reservation_id":"106152","confirmation_number":"SJ12641759516","room_confirmation_number":"SJ12646784630","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","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":"112566","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 14:21:27","reservation_modified_date_time":"2021-02-25 23:33:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112566","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":"3211142","reservation_id":"108561","confirmation_number":"SJ12663336095","room_confirmation_number":"SJ12616916396","room_stay_from":"2021-02-26","room_stay_to":"2021-03-12","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114946","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-25 19:10:26","reservation_modified_date_time":"2021-03-07 15:18:15","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3212517","reservation_id":"109039","confirmation_number":"SJ12647110283","room_confirmation_number":"SJ12694011435","room_stay_from":"2021-03-11","room_stay_to":"2021-03-12","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"115503","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-02 20:02:11","reservation_modified_date_time":"2021-03-09 15:37:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115503","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":"3212944","reservation_id":"109868","confirmation_number":"SJ12694606888","room_confirmation_number":"SJ12643301016","room_stay_from":"2021-03-09","room_stay_to":"2021-03-12","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"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":"116357","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-09 18:28:09","reservation_modified_date_time":"2021-03-10 00:09:01","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116357","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":"3213787","reservation_id":"100486","confirmation_number":"SJ12644304006","room_confirmation_number":"SJ12626904822","room_stay_from":"2021-03-11","room_stay_to":"2021-03-12","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":"106505","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-17 16:45:08","reservation_modified_date_time":"2021-03-11 13:43:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106505","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":"3213913","reservation_id":"105383","confirmation_number":"SJ12611084152","room_confirmation_number":"SJ12633984714","room_stay_from":"2021-03-11","room_stay_to":"2021-03-12","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":"111779","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 18:59:09","reservation_modified_date_time":"2021-03-11 17:02:28","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111779","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":"3214046","reservation_id":"110072","confirmation_number":"SJ12653158476","room_confirmation_number":"SJ12637407321","room_stay_from":"2021-03-11","room_stay_to":"2021-03-12","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.12","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116576","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-11 20:15:07","reservation_modified_date_time":"2021-03-11 20:15:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116576","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":"3214288","reservation_id":"109951","confirmation_number":"SJ12629917555","room_confirmation_number":"SJ12615168970","room_stay_from":"2021-03-11","room_stay_to":"2021-03-12","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"116448","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-10 14:28:10","reservation_modified_date_time":"2021-03-12 02:50:15","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116448","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","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":"3190202","reservation_id":"105014","confirmation_number":"SJ12678513564","room_confirmation_number":"SJ12665244487","room_stay_from":"2021-03-07","room_stay_to":"2021-03-13","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":"111381","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-08 18:06:13","reservation_modified_date_time":"2021-02-02 17:20:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111381","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":"3196162","reservation_id":"107396","confirmation_number":"SJ12661861280","room_confirmation_number":"SJ12689394958","room_stay_from":"2021-03-10","room_stay_to":"2021-03-13","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":"116481","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 01:26:10","reservation_modified_date_time":"2021-02-12 01:26:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113853","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":"3201696","reservation_id":"107921","confirmation_number":"SJ12629333092","room_confirmation_number":"SJ12673632852","room_stay_from":"2021-03-09","room_stay_to":"2021-03-13","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":"114383","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-17 21:56:35","reservation_modified_date_time":"2021-02-20 21:40:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114383","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":"3207817","reservation_id":"107927","confirmation_number":"SJ12678518033","room_confirmation_number":"SJ12661839986","room_stay_from":"2021-03-11","room_stay_to":"2021-03-13","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":"114390","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-17 23:07:21","reservation_modified_date_time":"2021-03-03 15:22:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114390","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":"3207821","reservation_id":"106747","confirmation_number":"SJ12671047267","room_confirmation_number":"SJ12686628950","room_stay_from":"2021-03-06","room_stay_to":"2021-03-13","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":"113168","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-02 18:25:41","reservation_modified_date_time":"2021-03-03 15:22:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113168","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":"3210963","reservation_id":"104807","confirmation_number":"SJ12617737742","room_confirmation_number":"SJ12626941891","room_stay_from":"2021-03-06","room_stay_to":"2021-03-13","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":"111151","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 21:01:12","reservation_modified_date_time":"2021-03-07 02:17:45","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116173","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":"3211121","reservation_id":"105423","confirmation_number":"SJ12624219133","room_confirmation_number":"SJ12697224644","room_stay_from":"2021-03-06","room_stay_to":"2021-03-13","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111825","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 02:33:17","reservation_modified_date_time":"2021-03-07 15:18:15","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"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":"3212190","reservation_id":"105045","confirmation_number":"SJ12635844076","room_confirmation_number":"SJ12617155812","room_stay_from":"2021-03-11","room_stay_to":"2021-03-13","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":"111421","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-09 02:51:06","reservation_modified_date_time":"2021-03-08 22:59:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111421","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":"3213263","reservation_id":"108144","confirmation_number":"SJ12611535772","room_confirmation_number":"SJ12664196022","room_stay_from":"2021-03-10","room_stay_to":"2021-03-13","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":"114611","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-20 22:22:35","reservation_modified_date_time":"2021-03-10 17:28:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114611","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":"3213265","reservation_id":"109647","confirmation_number":"SJ12666551375","room_confirmation_number":"SJ12698359016","room_stay_from":"2021-03-11","room_stay_to":"2021-03-13","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":"116133","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-07 05:32:26","reservation_modified_date_time":"2021-03-10 17:28:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116133","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":"3213268","reservation_id":"109627","confirmation_number":"SJ12667085420","room_confirmation_number":"SJ12617657554","room_stay_from":"2021-03-10","room_stay_to":"2021-03-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"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":"116103","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-06 23:27:40","reservation_modified_date_time":"2021-03-10 17:30:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116103","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":"3213919","reservation_id":"107625","confirmation_number":"SJ12659715520","room_confirmation_number":"SJ12617542867","room_stay_from":"2021-03-11","room_stay_to":"2021-03-13","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":"114081","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 20:18:22","reservation_modified_date_time":"2021-03-11 17:05:34","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114081","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":"3214190","reservation_id":"109997","confirmation_number":"SJ12636853821","room_confirmation_number":"SJ12653852523","room_stay_from":"2021-03-10","room_stay_to":"2021-03-13","room_stay_status":"Active","nightly_price":"25,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"116487","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-10 21:19:09","reservation_modified_date_time":"2021-03-11 23:32:33","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116487","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3182164","reservation_id":"105770","confirmation_number":"SJ12645669027","room_confirmation_number":"SJ12667254541","room_stay_from":"2021-03-11","room_stay_to":"2021-03-14","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":"112171","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-21 02:22:28","reservation_modified_date_time":"2021-01-21 02:22:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112171","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":"3186183","reservation_id":"106288","confirmation_number":"SJ12640599881","room_confirmation_number":"SJ12641587355","room_stay_from":"2021-03-11","room_stay_to":"2021-03-14","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":"112692","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 23:17:28","reservation_modified_date_time":"2021-01-28 12:45:52","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":"3194582","reservation_id":"106276","confirmation_number":"SJ12647922852","room_confirmation_number":"SJ12662472678","room_stay_from":"2021-03-11","room_stay_to":"2021-03-14","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":"112685","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 22:44:13","reservation_modified_date_time":"2021-02-09 02:28:58","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":"3204049","reservation_id":"105823","confirmation_number":"SJ12616845323","room_confirmation_number":"SJ12698854669","room_stay_from":"2021-03-11","room_stay_to":"2021-03-14","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":"112228","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-22 02:06:13","reservation_modified_date_time":"2021-02-25 02:09:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112228","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":"3211510","reservation_id":"103544","confirmation_number":"SJ12637440327","room_confirmation_number":"SJ12662068198","room_stay_from":"2021-03-07","room_stay_to":"2021-03-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109774","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-06 22:11:28","reservation_modified_date_time":"2021-03-07 20:47:58","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":"3211512","reservation_id":"103542","confirmation_number":"SJ12633364541","room_confirmation_number":"SJ12627064263","room_stay_from":"2021-03-07","room_stay_to":"2021-03-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109771","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-06 22:08:46","reservation_modified_date_time":"2021-03-07 20:48:10","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3212402","reservation_id":"106925","confirmation_number":"SJ12612619601","room_confirmation_number":"SJ12638567757","room_stay_from":"2021-03-09","room_stay_to":"2021-03-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"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":"113361","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-04 22:24:29","reservation_modified_date_time":"2021-03-09 14:05:31","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113361","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":"3185176","reservation_id":"106181","confirmation_number":"SJ12623742663","room_confirmation_number":"SJ12669214863","room_stay_from":"2021-03-11","room_stay_to":"2021-03-15","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":"112588","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 18:08:13","reservation_modified_date_time":"2021-01-26 21:50:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112588","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":"3193454","reservation_id":"107086","confirmation_number":"SJ12679663814","room_confirmation_number":"SJ12629734074","room_stay_from":"2021-03-09","room_stay_to":"2021-03-15","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":"113536","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-07 16:12:12","reservation_modified_date_time":"2021-02-07 16:43:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113536","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":"3193661","reservation_id":"107096","confirmation_number":"SJ12666326895","room_confirmation_number":"SJ12631412131","room_stay_from":"2021-03-09","room_stay_to":"2021-03-15","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":"113549","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-07 19:10:01","reservation_modified_date_time":"2021-02-07 19:10:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113549","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":"3212826","reservation_id":"105486","confirmation_number":"SJ12675751003","room_confirmation_number":"SJ12698820859","room_stay_from":"2021-03-10","room_stay_to":"2021-03-15","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":"111901","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-17 00:37:10","reservation_modified_date_time":"2021-03-09 21:27:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111901","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":"3214082","reservation_id":"106181","confirmation_number":"SJ12693063597","room_confirmation_number":"SJ12625383329","room_stay_from":"2021-03-11","room_stay_to":"2021-03-15","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":"112588","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 18:08:07","reservation_modified_date_time":"2021-03-11 20:43:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112588","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":"3180412","reservation_id":"104538","confirmation_number":"SJ12618512709","room_confirmation_number":"SJ12649150289","room_stay_from":"2021-03-09","room_stay_to":"2021-03-16","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":"110891","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-01 21:06:12","reservation_modified_date_time":"2021-01-17 18:01:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110891","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":"3181141","reservation_id":"105587","confirmation_number":"SJ12617556155","room_confirmation_number":"SJ12687092015","room_stay_from":"2021-03-11","room_stay_to":"2021-03-16","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"112008","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-19 00:04:12","reservation_modified_date_time":"2021-01-19 00:04:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112008","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":"3179382","reservation_id":"105388","confirmation_number":"SJ12666891249","room_confirmation_number":"SJ12664179352","room_stay_from":"2021-03-11","room_stay_to":"2021-03-18","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":"111786","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 20:51:09","reservation_modified_date_time":"2021-01-15 20:51:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111786","canceled_nights_data":"","posAmt_airbnb_taxpaid":"350.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":"3180210","reservation_id":"105491","confirmation_number":"SJ12694335950","room_confirmation_number":"SJ12619960936","room_stay_from":"2021-03-11","room_stay_to":"2021-03-18","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":"111906","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-17 03:12:12","reservation_modified_date_time":"2021-01-17 03:12:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111906","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":"3193488","reservation_id":"105509","confirmation_number":"SJ12683960264","room_confirmation_number":"SJ12662125810","room_stay_from":"2021-03-10","room_stay_to":"2021-03-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"111924","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-17 16:46:28","reservation_modified_date_time":"2021-02-07 16:49:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111924","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":"3189342","reservation_id":"106562","confirmation_number":"SJ12674501286","room_confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 18:54:06","reservation_modified_date_time":"2021-02-01 18:35:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101703","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":"3213771","reservation_id":"108831","confirmation_number":"SJ12611009634","room_confirmation_number":"SJ12627091441","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115289","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-28 16:21:43","reservation_modified_date_time":"2021-03-11 12:12:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115289","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3213822","reservation_id":"109878","confirmation_number":"SJ12650595531","room_confirmation_number":"SJ12629778153","room_stay_from":"2021-03-09","room_stay_to":"2021-03-11","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":"116370","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-09 20:28:35","reservation_modified_date_time":"2021-03-11 14:21:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116370","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3213851","reservation_id":"110033","confirmation_number":"SJ12656747168","room_confirmation_number":"SJ12643882128","room_stay_from":"2021-04-08","room_stay_to":"2021-04-11","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":"116528","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-11 04:37:20","reservation_modified_date_time":"2021-03-11 15:20:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116528","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3213932","reservation_id":"109682","confirmation_number":"SJ12693424074","room_confirmation_number":"SJ12681922802","room_stay_from":"2021-03-22","room_stay_to":"2021-03-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116169","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-07 18:47:40","reservation_modified_date_time":"2021-03-11 17:31:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116169","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3214175","reservation_id":"108092","confirmation_number":"SJ12671576272","room_confirmation_number":"SJ12681091358","room_stay_from":"2021-04-14","room_stay_to":"2021-04-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114559","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-20 02:59:46","reservation_modified_date_time":"2021-03-11 22:44:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114559","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3213901","reservation_id":"109997","confirmation_number":"SJ12619300586","room_confirmation_number":"SJ12653852523","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"10.00","paid_amount":"10.00","product_id":"1662","service_quantity":"1","product_name":"Extra Chair or Umbrella","parentTypeOfRes":"reservation","reservation_created_date":"2021-03-11 16:46:43","reservation_modified_date_time":"2021-03-11 16:46:43","customer_id":"116487","parentCustTravId":"116487","customer_traveller_id":"116487","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-03-10","sub_hotel_id":"126","currentDayPrice":"9.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}