{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-03-10","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":"1866,1297","block_room_bookings":[{"confirmation_number":"SJ12615952583","room_stay_from":"2021-03-10","room_stay_to":"2021-03-11","bundle_room":"0","product_id":"1866"},{"confirmation_number":"SJ12629003029","room_stay_from":"2021-03-10","room_stay_to":"2021-03-13","bundle_room":"0","product_id":"1297"}],"bundle_block_count":"1269,1270,1260,1261,1311,1312,1309,1310,1302,1303,1307,1308,1304,1305,1267,1268,1271,1272,1291,1711,1262,1263","bundle_block_bookings":[{"confirmation_number":"SJB12687161006","room_stay_from":"2021-03-08","room_stay_to":"2021-03-11","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12626718499","room_stay_from":"2021-03-09","room_stay_to":"2021-03-11","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12632436077","room_stay_from":"2021-03-10","room_stay_to":"2021-03-11","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12664181266","room_stay_from":"2021-03-10","room_stay_to":"2021-03-11","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12686561707","room_stay_from":"2021-03-09","room_stay_to":"2021-03-11","bundle_room":"1","product_id":"1910"},{"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":"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":"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"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3194586","reservation_id":"107185","confirmation_number":"SJ12621070831","room_stay_from":"2021-03-07","room_stay_to":"2021-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"223.30,223.30,202.30,202.30","nightly_discount":"0,0,0,0","subtotal":"851.20","grand_total":"957.60","paid_amount":"957.60","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3546115044","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":"113646","customer_id":"113646","source_of_creation":"Booking.com","reservation_created_date":"2021-02-08 23:33:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"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":"3209855","reservation_id":"109075","confirmation_number":"SJ12681960057","room_stay_from":"2021-03-10","room_stay_to":"2021-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"424.15","nightly_discount":"0","subtotal":"424.15","grand_total":"477.17","paid_amount":"477.17","room_type_id":"320","product_id":"1332","siteminder_id":"BDC-3189152934","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":"115546","customer_id":"115546","source_of_creation":"Booking.com","reservation_created_date":"2021-03-03 02:40:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"80.85","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"424.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":"3209924","reservation_id":"107605","confirmation_number":"SJ12673134816","room_stay_from":"2021-03-09","room_stay_to":"2021-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.08,226.08","nightly_discount":"0,0","subtotal":"452.16","grand_total":"508.68","paid_amount":"508.68","room_type_id":"319","product_id":"1309","siteminder_id":"BDC-2907348181","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":"114060","customer_id":"114060","source_of_creation":"Booking.com","reservation_created_date":"2021-02-14 17:14:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"90.39","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"226.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":"3211308","reservation_id":"109415","confirmation_number":"SJ12629342286","room_stay_from":"2021-03-08","room_stay_to":"2021-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"318.4,318.4,318.4","nightly_discount":"0,0,0","subtotal":"955.20","grand_total":"1074.60","paid_amount":"1074.60","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-2366458498","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115879","customer_id":"115879","source_of_creation":"Booking.com","reservation_created_date":"2021-03-04 21:57:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"132.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"318.4","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3213546","reservation_id":"109997","confirmation_number":"SJ12653852523","room_stay_from":"2021-03-10","room_stay_to":"2021-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"266.98","nightly_discount":"0","subtotal":"266.98","grand_total":"300.35","paid_amount":"300.35","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","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"}]},{"room_stay_id":"3213668","reservation_id":"110011","confirmation_number":"SJ12652854855","room_stay_from":"2021-03-10","room_stay_to":"2021-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"266.99","nightly_discount":"0","subtotal":"266.99","grand_total":"300.36","paid_amount":"300.36","room_type_id":"319","product_id":"1756","siteminder_id":"BDC-2244353321","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":"116506","customer_id":"116506","source_of_creation":"Booking.com","reservation_created_date":"2021-03-11 00:39:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","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","currentDayPrice":"266.99","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":"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":"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":"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":"146.85","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"175.56","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":"194.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":"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":"3193487","reservation_id":"105509","confirmation_number":"SJ12662125810","room_stay_from":"2021-03-10","room_stay_to":"2021-03-20","room_stay_status":"Active","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":"203.97","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":"3213167","reservation_id":"109926","confirmation_number":"SJ12691003228","room_stay_from":"2021-04-19","room_stay_to":"2021-04-23","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,160.30,160.30,160.30","nightly_discount":"0,0,0,0","subtotal":"641.20","grand_total":"721.35","paid_amount":"180.34","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-2244347608","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":"116420","customer_id":"116420","source_of_creation":"Booking.com","reservation_created_date":"2021-03-10 02:23:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3213709","reservation_id":"109664","confirmation_number":"SJ12640857594","room_stay_from":"2021-04-08","room_stay_to":"2021-04-09","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"289.15","nightly_discount":"0","subtotal":"289.15","grand_total":"325.30","paid_amount":"325.30","room_type_id":"319","product_id":"1311","siteminder_id":"BDC-2114662805","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116151","customer_id":"116151","source_of_creation":"Booking.com","reservation_created_date":"2021-03-07 15:21:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"65.55","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3186976","reservation_id":"106405","confirmation_number":"SJ12659212374","room_stay_from":"2021-03-07","room_stay_to":"2021-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,181.30,181.30","nightly_discount":"0,0,0,0","subtotal":"725.20","grand_total":"815.85","paid_amount":"815.85","room_type_id":"413","product_id":"1270","siteminder_id":"EXP-1733651344","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":"112802","customer_id":"112802","source_of_creation":"Expedia","reservation_created_date":"2021-01-29 14:06:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","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":"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":"3210486","reservation_id":"103261","confirmation_number":"SJ12652753727","room_stay_from":"2021-03-08","room_stay_to":"2021-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"173.04,173.04,173.04","nightly_discount":"0,0,0","subtotal":"519.12","grand_total":"584.01","paid_amount":"584.01","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1719514744","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":"109424","customer_id":"109424","source_of_creation":"Expedia","reservation_created_date":"2020-11-29 18:36:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"173.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":"3211948","reservation_id":"107003","confirmation_number":"SJ12665153108","room_stay_from":"2021-03-08","room_stay_to":"2021-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"191.40,173.40,173.40","nightly_discount":"0,0,0","subtotal":"538.20","grand_total":"605.48","paid_amount":"605.48","room_type_id":"319","product_id":"1313","siteminder_id":"EXP-1735674040","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":"113443","customer_id":"113443","source_of_creation":"Expedia","reservation_created_date":"2021-02-06 01:25:09","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":"173.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3212219","reservation_id":"107420","confirmation_number":"SJ12637237264","room_stay_from":"2021-03-08","room_stay_to":"2021-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"181.40,163.40,163.42","nightly_discount":"0.00,0.00,0.00","subtotal":"508.22","grand_total":"571.75","paid_amount":"571.75","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1737434739","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":"113878","customer_id":"113878","source_of_creation":"Expedia","reservation_created_date":"2021-02-12 09:07:19","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"163.42","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3213001","reservation_id":"103260","confirmation_number":"SJ12616061810","room_stay_from":"2021-03-07","room_stay_to":"2021-03-11","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","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"580.16","grand_total":"652.68","paid_amount":"652.68","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1719514479","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":"109423","customer_id":"109423","source_of_creation":"Expedia","reservation_created_date":"2020-11-29 18:36:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"145.04","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"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":"207.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":"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":"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":"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","currentDayPrice":"216.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3213258","reservation_id":"109695","confirmation_number":"SJ12635256690","room_stay_from":"2021-03-10","room_stay_to":"2021-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"242.72","nightly_discount":"0","subtotal":"242.72","grand_total":"273.06","paid_amount":"273.06","room_type_id":"413","product_id":"1266","siteminder_id":"HTN-154419808-ZRKDJ6","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":"116185","customer_id":"116185","source_of_creation":"HotelTonight","reservation_created_date":"2021-03-07 20:18:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"242.72","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3193743","reservation_id":"105847","confirmation_number":"SJ12652633501","room_stay_from":"2021-03-08","room_stay_to":"2021-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.57,149.57,149.57","nightly_discount":"0,0,0","subtotal":"448.71","grand_total":"504.80","paid_amount":"504.80","room_type_id":"411","product_id":"1296","siteminder_id":"GAM-R2292162651","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":"112252","customer_id":"112252","source_of_creation":"Getaroom.com","reservation_created_date":"2021-01-22 13:50: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":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"149.57","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":"155.77","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":"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":"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"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"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":"194.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"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","changedComment":"From date changed","deltaChange":"0.00","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":"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":"216.75","currentDayDiscount":"10.84","productIsTaxExempt":false,"taxes":[{"tax_id":"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":"216.75","currentDayDiscount":"10.84","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"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":"3213538","reservation_id":"105794","confirmation_number":"SJ12633230040","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.65,279.65,279.65,279.65","nightly_discount":"0.00,0.00,0,0","subtotal":"1084.60","grand_total":"1220.18","paid_amount":"276.36","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":"112199","customer_id":"112199","source_of_creation":"PMS","reservation_created_date":"2021-01-21 18:09:56","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":"","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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"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.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":"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":"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":"3210259","reservation_id":"107420","confirmation_number":"SJ12650944170","room_confirmation_number":"SJ12637237264","room_stay_from":"2021-03-08","room_stay_to":"2021-03-11","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"113878","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-03-06 17:28:52","reservation_modified_date_time":"2021-03-06 17:28:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113878","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":"3211309","reservation_id":"109415","confirmation_number":"SJ12656437666","room_confirmation_number":"SJ12629342286","room_stay_from":"2021-03-08","room_stay_to":"2021-03-11","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"115879","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-03-07 18:15:30","reservation_modified_date_time":"2021-03-07 18:15:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115879","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3186977","reservation_id":"106405","confirmation_number":"SJ12620781465","room_confirmation_number":"SJ12659212374","room_stay_from":"2021-03-07","room_stay_to":"2021-03-11","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":"112802","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 14:06:13","reservation_modified_date_time":"2021-01-29 14:06:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112802","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":"3193745","reservation_id":"105847","confirmation_number":"SJ12675818221","room_confirmation_number":"SJ12652633501","room_stay_from":"2021-03-08","room_stay_to":"2021-03-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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"112252","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-22 13:50:12","reservation_modified_date_time":"2021-02-07 20:38:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112252","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":"3194585","reservation_id":"107185","confirmation_number":"SJ12614265266","room_confirmation_number":"SJ12621070831","room_stay_from":"2021-03-07","room_stay_to":"2021-03-11","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":"113646","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-08 23:33:22","reservation_modified_date_time":"2021-02-09 02:25:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113646","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":"3209858","reservation_id":"109075","confirmation_number":"SJ12619400539","room_confirmation_number":"SJ12681960057","room_stay_from":"2021-03-10","room_stay_to":"2021-03-11","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":"115546","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 02:40:08","reservation_modified_date_time":"2021-03-05 22:27:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115546","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":"3209926","reservation_id":"107605","confirmation_number":"SJ12657294979","room_confirmation_number":"SJ12673134816","room_stay_from":"2021-03-09","room_stay_to":"2021-03-11","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":"114060","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 17:14:14","reservation_modified_date_time":"2021-03-06 00:18:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114060","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":"3210487","reservation_id":"103261","confirmation_number":"SJ12626499638","room_confirmation_number":"SJ12652753727","room_stay_from":"2021-03-08","room_stay_to":"2021-03-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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"109424","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-29 18:36:14","reservation_modified_date_time":"2021-03-06 19:39:46","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109424","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":"3211310","reservation_id":"109415","confirmation_number":"SJ12623427401","room_confirmation_number":"SJ12629342286","room_stay_from":"2021-03-08","room_stay_to":"2021-03-11","room_stay_status":"Active","nightly_price":"25,25,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"115879","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 21:57:13","reservation_modified_date_time":"2021-03-07 18:15:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115879","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3211949","reservation_id":"107003","confirmation_number":"SJ12634930850","room_confirmation_number":"SJ12665153108","room_stay_from":"2021-03-08","room_stay_to":"2021-03-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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"113443","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-06 01:25:09","reservation_modified_date_time":"2021-03-08 17:43:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113443","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":"3212220","reservation_id":"107420","confirmation_number":"SJ12669811698","room_confirmation_number":"SJ12637237264","room_stay_from":"2021-03-08","room_stay_to":"2021-03-11","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":"113878","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 09:07:19","reservation_modified_date_time":"2021-03-08 23:28:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113878","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"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3213002","reservation_id":"103260","confirmation_number":"SJ12693200046","room_confirmation_number":"SJ12616061810","room_stay_from":"2021-03-07","room_stay_to":"2021-03-11","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":"109423","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-29 18:36:11","reservation_modified_date_time":"2021-03-10 01:23:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109423","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":"3213259","reservation_id":"109695","confirmation_number":"SJ12696099206","room_confirmation_number":"SJ12635256690","room_stay_from":"2021-03-10","room_stay_to":"2021-03-11","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":"116185","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-07 20:18:12","reservation_modified_date_time":"2021-03-10 17:27:34","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116185","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":"3213547","reservation_id":"109997","confirmation_number":"SJ12636853821","room_confirmation_number":"SJ12653852523","room_stay_from":"2021-03-10","room_stay_to":"2021-03-11","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":"116487","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-10 21:19:09","reservation_modified_date_time":"2021-03-10 22:55:37","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","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":"3213669","reservation_id":"110011","confirmation_number":"SJ12680726169","room_confirmation_number":"SJ12652854855","room_stay_from":"2021-03-10","room_stay_to":"2021-03-11","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":"116506","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-11 00:39:11","reservation_modified_date_time":"2021-03-11 01:18:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116506","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":"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":"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":"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":"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":"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":"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","changedComment":"From date changed","deltaChange":"0.00","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":"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":"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":"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":"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":"0.00","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":"3213166","reservation_id":"109926","confirmation_number":"SJ12675420316","room_confirmation_number":"SJ12691003228","room_stay_from":"2021-04-19","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116420","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-10 02:23:18","reservation_modified_date_time":"2021-03-10 15:18:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116420","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":"3213539","reservation_id":"105794","confirmation_number":"SJ12620652603","room_confirmation_number":"SJ12633230040","room_stay_from":"2021-03-18","room_stay_to":"2021-03-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112199","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-21 18:09:56","reservation_modified_date_time":"2021-03-10 22:38:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112199","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":"3213712","reservation_id":"109664","confirmation_number":"SJ12647283469","room_confirmation_number":"SJ12640857594","room_stay_from":"2021-04-08","room_stay_to":"2021-04-09","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116151","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-07 15:21:09","reservation_modified_date_time":"2021-03-11 03:05:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116151","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3213257","reservation_id":"109974","confirmation_number":"SJ12619109822","room_confirmation_number":"SJ12669860991","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"15.00","paid_amount":"15.00","product_id":"1654","service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2021-03-10 17:24:41","reservation_modified_date_time":"2021-03-10 17:24:41","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"13.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3213347","reservation_id":"109981","confirmation_number":"SJ12679653280","room_confirmation_number":"SJ12691793181","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"8.00","paid_amount":"8.00","product_id":"1663","service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-03-10 19:28:02","reservation_modified_date_time":"2021-03-10 19:28:02","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"7.44","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":[]}}