{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-08-29","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":24,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1273","block_room_bookings":[{"confirmation_number":"SJ12646427749","room_stay_from":"2021-08-29","room_stay_to":"2021-09-04","bundle_room":"0","product_id":"1273"}],"bundle_block_count":"1271,1272,1267,1268,1302,1303,1307,1308,1269,1270,1309,1310,1262,1263,1304,1305,1311,1312,1260,1261,1291,1711","bundle_block_bookings":[{"confirmation_number":"SJB12622691107","room_stay_from":"2021-08-29","room_stay_to":"2021-09-04","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12673498524","room_stay_from":"2021-08-28","room_stay_to":"2021-08-31","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12671244121","room_stay_from":"2021-08-29","room_stay_to":"2021-09-01","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12667632319","room_stay_from":"2021-08-29","room_stay_to":"2021-09-01","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12646996445","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12623981484","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12631023049","room_stay_from":"2021-08-29","room_stay_to":"2021-09-01","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12646372362","room_stay_from":"2021-08-26","room_stay_to":"2021-08-30","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12668829385","room_stay_from":"2021-08-26","room_stay_to":"2021-08-30","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12623330869","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJB12620878185","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","bundle_room":"0","product_id":"1263"},{"confirmation_number":"SJB12687738602","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12688100329","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12622617110","room_stay_from":"2021-08-27","room_stay_to":"2021-08-30","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12651854780","room_stay_from":"2021-08-27","room_stay_to":"2021-08-30","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12681129839","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12693143015","room_stay_from":"2021-08-29","room_stay_to":"2021-09-02","bundle_room":"1","product_id":"1714"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3271952","reservation_id":"117847","confirmation_number":"SJ12652480145","room_stay_from":"2021-08-29","room_stay_to":"2021-09-01","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"151.27,151.27,151.27","nightly_discount":"0,0,0","subtotal":"453.81","grand_total":"510.54","paid_amount":"510.54","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-3150531508","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":"124824","customer_id":"124824","source_of_creation":"Booking.com","reservation_created_date":"2021-06-22 18:33:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"95.19","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"151.27","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":"3272640","reservation_id":"117930","confirmation_number":"SJ12618152709","room_stay_from":"2021-08-25","room_stay_to":"2021-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,230.30,230.30,160.30,160.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1143.80","grand_total":"1286.78","paid_amount":"203.97","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3269772448","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":"124923","customer_id":"124923","source_of_creation":"Booking.com","reservation_created_date":"2021-06-23 23:50:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"232.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.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":"3284965","reservation_id":"119425","confirmation_number":"SJ12656723896","room_stay_from":"2021-08-28","room_stay_to":"2021-09-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,160.30,160.30,160.30,153.30","nightly_discount":"0,0,0,0,0","subtotal":"864.50","grand_total":"972.57","paid_amount":"972.57","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-3308992229","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":"126567","customer_id":"126567","source_of_creation":"Booking.com","reservation_created_date":"2021-07-16 00:59:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"178.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.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":"3287232","reservation_id":"119726","confirmation_number":"SJ12621028438","room_stay_from":"2021-08-28","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.54,129.84,129.84,129.84,124.17,124.17,186.54,203.55","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1214.49","grand_total":"1366.30","paid_amount":"1366.30","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-2136730789","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":"126919","customer_id":"126919","source_of_creation":"Booking.com","reservation_created_date":"2021-07-20 18:10:29","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"254.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"129.84","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3290537","reservation_id":"119739","confirmation_number":"SJ12675467876","room_stay_from":"2021-08-28","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.54,129.84,129.84,129.84,124.17,124.17,186.54,203.55","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1214.49","grand_total":"1366.30","paid_amount":"1366.30","room_type_id":"319","product_id":"1276","siteminder_id":"BDC-2793188004","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":"126933","customer_id":"126933","source_of_creation":"Booking.com","reservation_created_date":"2021-07-20 20:28:57","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":"129.84","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3302830","reservation_id":"121217","confirmation_number":"SJ12626808876","room_stay_from":"2021-08-29","room_stay_to":"2021-09-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"154.58,134.33,134.33","nightly_discount":"0,0,0","subtotal":"423.24","grand_total":"476.14","paid_amount":"476.14","room_type_id":"413","product_id":"1269","siteminder_id":"BDC-3438303941","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":"128684","customer_id":"128684","source_of_creation":"Booking.com","reservation_created_date":"2021-08-15 05:48:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"89.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"154.58","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":"4151078","reservation_id":"115765","confirmation_number":"SJ12627565711","room_stay_from":"2021-08-23","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.37,125.37,125.37,125.37,188.37,188.37,125.37","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1003.59","grand_total":"1129.04","paid_amount":"1129.04","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-3927548053","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":"122542","customer_id":"122542","source_of_creation":"Booking.com","reservation_created_date":"2021-05-24 01:46:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"212.15","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"125.37","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":"5303929","reservation_id":"121977","confirmation_number":"SJ12662082596","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"171.44","nightly_discount":"0","subtotal":"171.44","grand_total":"192.87","paid_amount":"192.87","room_type_id":"320","product_id":"1321","siteminder_id":"BDC-3448957797","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":"129517","customer_id":"129517","source_of_creation":"Booking.com","reservation_created_date":"2021-08-26 22:14:12","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 208+209","ota_service_fee_amount":"0","commision_charges":"70.72","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1262,1263","currentDayPrice":"171.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303933","reservation_id":"121977","confirmation_number":"SJ12676633464","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"171.44","nightly_discount":"0","subtotal":"171.44","grand_total":"192.87","paid_amount":"192.87","room_type_id":"320","product_id":"1329","siteminder_id":"BDC-3448957797","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":"129517","customer_id":"129517","source_of_creation":"Booking.com","reservation_created_date":"2021-08-26 22:14:18","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"70.72","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"171.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5304751","reservation_id":"119419","confirmation_number":"SJ12699381618","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.01","nightly_discount":"0","subtotal":"137.01","grand_total":"154.14","paid_amount":"154.14","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-2639773755","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":"126560","customer_id":"126560","source_of_creation":"Booking.com","reservation_created_date":"2021-07-15 22:13:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"29.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"137.01","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":"5305793","reservation_id":"121209","confirmation_number":"SJ12613695328","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"230.30,230.30,160.30,139.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"760.20","grand_total":"855.23","paid_amount":"855.23","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-3790077817","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":"128679","customer_id":"128679","source_of_creation":"Booking.com","reservation_created_date":"2021-08-15 01:01:18","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","currentDayPrice":"160.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5305657","reservation_id":"113273","confirmation_number":"SJ12617941038","room_stay_from":"2021-09-17","room_stay_to":"2021-09-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.83,201.83,134.33,134.33,134.33","nightly_discount":"0,0,0,0,0","subtotal":"806.65","grand_total":"907.48","paid_amount":"230.85","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-2995318889","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":"119862","customer_id":"119862","source_of_creation":"Booking.com","reservation_created_date":"2021-04-18 01:13:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[{"room_stay_id":"5304885","reservation_id":"121588","confirmation_number":"SJ12686523609","room_stay_from":"2021-08-28","room_stay_to":"2021-08-31","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"224.25,149.25,149.25","nightly_discount":"0,0,0","subtotal":"522.75","grand_total":"588.10","paid_amount":"167.90","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-2111625187","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":"129080","customer_id":"129080","source_of_creation":"Booking.com","reservation_created_date":"2021-08-20 19:34:19","service_canceled_date_time":"2021-08-29 21:22:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"room_dates_changed","total_paid_amount":"252.28","sub_hotel_id":"126","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3300689","reservation_id":"118527","confirmation_number":"SJ12626265103","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"1","nightly_price":"279.44,279.44,223.44,223.44","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1005.76","grand_total":"1131.48","paid_amount":"1131.48","room_type_id":"320","product_id":"1330","siteminder_id":"EXP-1794684960","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":"125560","customer_id":"125560","source_of_creation":"Expedia","reservation_created_date":"2021-07-02 15:21:07","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":"223.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5294311","reservation_id":"117027","confirmation_number":"SJ12615383475","room_stay_from":"2021-08-24","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.04,145.04,145.04,184.24,184.24,128.24","nightly_discount":"0,0,0,0,0,0","subtotal":"931.84","grand_total":"1048.32","paid_amount":"1048.32","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1783877373","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"123967","customer_id":"123967","source_of_creation":"Expedia","reservation_created_date":"2021-06-11 16:01:17","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"186.37","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"128.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3241166","reservation_id":"113795","confirmation_number":"SJ12617087770","room_stay_from":"2021-08-26","room_stay_to":"2021-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.26,144.99,144.99,107.26,107.26","nightly_discount":"0,0,0,0,0","subtotal":"611.76","grand_total":"688.23","paid_amount":"688.23","room_type_id":"413","product_id":"1268","siteminder_id":"GAM-R2471843451","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":"120408","customer_id":"120408","source_of_creation":"Getaroom.com","reservation_created_date":"2021-04-24 18:17:10","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"107.26","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":"5304417","reservation_id":"119139","confirmation_number":"SJ12680645831","room_stay_from":"2021-08-27","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"276.14,276.14,214.64","nightly_discount":"0.00,0.00,0.00","subtotal":"766.92","grand_total":"862.79","paid_amount":"862.79","room_type_id":"320","product_id":"1332","siteminder_id":"GAM-R2652976348","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":"126259","customer_id":"126259","source_of_creation":"Getaroom.com","reservation_created_date":"2021-07-11 20:11:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"214.64","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5305041","reservation_id":"122013","confirmation_number":"SJ12677081658","room_stay_from":"2021-08-28","room_stay_to":"2021-09-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"72.96,231.83,231.83,231.83","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"768.45","grand_total":"915.20","paid_amount":"915.20","room_type_id":"319","product_id":"1756","siteminder_id":"ABB-HMHPHCBXZH","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"927.32","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129551","customer_id":"129551","source_of_creation":"Airbnb","reservation_created_date":"2021-08-27 17:49:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"28.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"231.83","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":"5.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"5305445","reservation_id":"122150","confirmation_number":"SJ12691345875","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"179.07","nightly_discount":"0.00","subtotal":"179.07","grand_total":"215.80","paid_amount":"215.80","room_type_id":"413","product_id":"1266","siteminder_id":"ABB-HM3YQSYFQ5","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"208.58","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129722","customer_id":"129722","source_of_creation":"Airbnb","reservation_created_date":"2021-08-29 17:26:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"6.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"179.07","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"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"5305070","reservation_id":"118676","confirmation_number":"SJ12613128135","room_stay_from":"2021-08-28","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.90,215.90","nightly_discount":"0.00,0.00","subtotal":"516.80","grand_total":"581.40","paid_amount":"581.40","room_type_id":"412","product_id":"1316","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":"125750","customer_id":"125750","source_of_creation":"FE","reservation_created_date":"2021-07-04 18:39:43","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"215.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5303872","reservation_id":"121296","confirmation_number":"SJ12636090665","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.25,269.25,194.25,171.75","nightly_discount":"13.46,13.46,9.71,8.59","subtotal":"904.50","grand_total":"966.69","paid_amount":"966.69","room_type_id":"319","product_id":"1917","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128772","customer_id":"128772","source_of_creation":"PMS","reservation_created_date":"2021-08-16 21:00:02","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":"FLRES","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"194.25","currentDayDiscount":"9.71","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303914","reservation_id":"119684","confirmation_number":"SJ12684842435","room_stay_from":"2021-08-26","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"284.50,284.55,284.55,284.55","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1138.15","grand_total":"1280.42","paid_amount":"1280.42","room_type_id":"320","product_id":"1910","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":"126882","customer_id":"126882","source_of_creation":"PMS","reservation_created_date":"2021-07-20 00:48:36","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1309,1310","currentDayPrice":"284.55","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5305141","reservation_id":"119307","confirmation_number":"SJ12642302177","room_stay_from":"2021-08-28","room_stay_to":"2021-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"246.75,171.75,171.75","nightly_discount":"24.68,17.18,17.18","subtotal":"590.25","grand_total":"597.61","paid_amount":"597.61","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":"126438","customer_id":"126438","source_of_creation":"PMS","reservation_created_date":"2021-07-14 14:47:57","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":"special123","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"171.75","currentDayDiscount":"17.18","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5305196","reservation_id":"122131","confirmation_number":"SJ12628064481","room_stay_from":"2021-08-29","room_stay_to":"2021-09-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.15,169.15,169.15","nightly_discount":"0.00,0.00,0.00","subtotal":"507.45","grand_total":"570.88","paid_amount":"570.88","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129701","customer_id":"129701","source_of_creation":"PMS","reservation_created_date":"2021-08-28 23:58:31","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"169.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5305412","reservation_id":"122146","confirmation_number":"SJ12627373574","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.15","nightly_discount":"0.00","subtotal":"169.15","grand_total":"190.30","paid_amount":"190.30","room_type_id":"413","product_id":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129640","customer_id":"129640","source_of_creation":"PMS","reservation_created_date":"2021-08-29 15:14:52","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","currentDayPrice":"169.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[{"room_stay_id":"3301398","reservation_id":"121063","confirmation_number":"SJ12672465911","room_stay_from":"2021-08-28","room_stay_to":"2021-09-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"480.00","grand_total":"540.00","paid_amount":"540.00","room_type_id":"413","product_id":"1267","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2021-08-11 18:09:10","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":"96.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"}]}],"negotiated_non_taxable":[{"room_stay_id":"3265711","reservation_id":"117037","confirmation_number":"SJ12683471302","room_stay_from":"2021-08-29","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.85,111.85,111.85,111.85,111.85,111.85,111.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"783.00","grand_total":"783.00","paid_amount":"0.00","room_type_id":"319","product_id":"1286","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-06-11 17:47:28","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","group_rooms":null,"currentDayPrice":"111.85","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":"3276411","reservation_id":"118469","confirmation_number":"SJ12647800824","room_stay_from":"2021-08-28","room_stay_to":"2021-09-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,96.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"672.00","grand_total":"672.00","paid_amount":"672.00","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2021-07-01 17:26:03","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"96.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":"5302824","reservation_id":"113233","confirmation_number":"SJ12644556392","room_stay_from":"2021-08-29","room_stay_to":"2021-09-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"522.00","grand_total":"522.00","paid_amount":"168.75","room_type_id":"413","product_id":"1271","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-17 18:20:44","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303034","reservation_id":"117109","confirmation_number":"SJ12652318238","room_stay_from":"2021-08-27","room_stay_to":"2021-09-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-06-12 20:24:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5304651","reservation_id":"115585","confirmation_number":"SJ12625515998","room_stay_from":"2021-08-27","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1943","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-20 22:52:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5304776","reservation_id":"116046","confirmation_number":"SJ12682923588","room_stay_from":"2021-08-29","room_stay_to":"2021-09-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-28 00:13:25","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":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5305234","reservation_id":"116038","confirmation_number":"SJ12639868735","room_stay_from":"2021-08-29","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0,0,0,0,0","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1291","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-27 23:30:59","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3300692","reservation_id":"118527","confirmation_number":"SJ12621765096","room_confirmation_number":"SJ12626265103","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0,0,0,0","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"125560","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-08-09 21:02:10","reservation_modified_date_time":"2021-08-09 21:02:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125560","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"50","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":"5305433","reservation_id":"122150","confirmation_number":"SJ12631442004","room_confirmation_number":"SJ12691345875","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"25.15","paid_amount":"25.15","product_id":"1777","service_quantity":"1","customer_traveller_id":"129722","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-08-29 17:26:10","reservation_modified_date_time":"2021-08-29 17:26:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129722","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"0.59","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"5305794","reservation_id":"121209","confirmation_number":"SJ12683767829","room_confirmation_number":"SJ12613695328","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","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":"128679","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-08-29 23:50:28","reservation_modified_date_time":"2021-08-29 23:50:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128679","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"Reservation created with partial past date","deltaChange":"50.00","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":"3241167","reservation_id":"113795","confirmation_number":"SJ12638813940","room_confirmation_number":"SJ12617087770","room_stay_from":"2021-08-26","room_stay_to":"2021-08-31","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":"120408","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-24 18:17:10","reservation_modified_date_time":"2021-04-24 18:17:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120408","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":"3265712","reservation_id":"117037","confirmation_number":"SJ12690846240","room_confirmation_number":"SJ12683471302","room_stay_from":"2021-08-29","room_stay_to":"2021-09-05","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"123975","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-11 17:47:28","reservation_modified_date_time":"2021-06-11 17:47:28","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":"3271953","reservation_id":"117847","confirmation_number":"SJ12682057427","room_confirmation_number":"SJ12652480145","room_stay_from":"2021-08-29","room_stay_to":"2021-09-01","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":"124824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-22 18:33:11","reservation_modified_date_time":"2021-06-22 18:33:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124824","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":"3272641","reservation_id":"117930","confirmation_number":"SJ12638790025","room_confirmation_number":"SJ12618152709","room_stay_from":"2021-08-25","room_stay_to":"2021-08-31","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124923","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-23 23:50:13","reservation_modified_date_time":"2021-06-23 23:50:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124923","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":"3276412","reservation_id":"118469","confirmation_number":"SJ12638518959","room_confirmation_number":"SJ12647800824","room_stay_from":"2021-08-28","room_stay_to":"2021-09-04","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":"125501","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-01 17:26:03","reservation_modified_date_time":"2021-07-01 17:26:03","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74459","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":"3284966","reservation_id":"119425","confirmation_number":"SJ12672952710","room_confirmation_number":"SJ12656723896","room_stay_from":"2021-08-28","room_stay_to":"2021-09-02","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":"126567","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-16 00:59:09","reservation_modified_date_time":"2021-07-16 00:59:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126567","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":"3287233","reservation_id":"119726","confirmation_number":"SJ12633658215","room_confirmation_number":"SJ12621028438","room_stay_from":"2021-08-28","room_stay_to":"2021-09-05","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126919","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-20 18:10:29","reservation_modified_date_time":"2021-07-20 21:33:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126919","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":"3290536","reservation_id":"119739","confirmation_number":"SJ12625742911","room_confirmation_number":"SJ12675467876","room_stay_from":"2021-08-28","room_stay_to":"2021-09-05","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126933","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-20 20:28:57","reservation_modified_date_time":"2021-07-26 19:11:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126933","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":"3300693","reservation_id":"118527","confirmation_number":"SJ12676895078","room_confirmation_number":"SJ12626265103","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","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":"125560","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-02 15:21:07","reservation_modified_date_time":"2021-08-09 21:02:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125560","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":"3301399","reservation_id":"121063","confirmation_number":"SJ12699355961","room_confirmation_number":"SJ12672465911","room_stay_from":"2021-08-28","room_stay_to":"2021-09-02","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":"128488","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-11 18:09:10","reservation_modified_date_time":"2021-08-11 18:09:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","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":"3302831","reservation_id":"121217","confirmation_number":"SJ12613598724","room_confirmation_number":"SJ12626808876","room_stay_from":"2021-08-29","room_stay_to":"2021-09-01","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":"128684","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-15 05:48:11","reservation_modified_date_time":"2021-08-15 05:48:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128684","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":"4151088","reservation_id":"115765","confirmation_number":"SJ12648855885","room_confirmation_number":"SJ12627565711","room_stay_from":"2021-08-23","room_stay_to":"2021-08-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"122542","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-24 01:46:11","reservation_modified_date_time":"2021-08-21 18:58:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122542","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":"5294312","reservation_id":"117027","confirmation_number":"SJ12637911978","room_confirmation_number":"SJ12615383475","room_stay_from":"2021-08-24","room_stay_to":"2021-08-30","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":"123967","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-11 16:01:17","reservation_modified_date_time":"2021-08-24 15:36:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123967","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5302823","reservation_id":"113233","confirmation_number":"SJ12662941514","room_confirmation_number":"SJ12644556392","room_stay_from":"2021-08-29","room_stay_to":"2021-09-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119825","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 18:20:44","reservation_modified_date_time":"2021-08-25 19:06:13","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":"5303033","reservation_id":"117109","confirmation_number":"SJ12641798094","room_confirmation_number":"SJ12652318238","room_stay_from":"2021-08-27","room_stay_to":"2021-09-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124044","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-12 20:24:53","reservation_modified_date_time":"2021-08-25 19:06:16","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":"5303873","reservation_id":"121296","confirmation_number":"SJ12676047550","room_confirmation_number":"SJ12636090665","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","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":"128772","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-16 21:00:02","reservation_modified_date_time":"2021-08-26 20:41:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128772","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":"5303917","reservation_id":"119684","confirmation_number":"SJ12693815257","room_confirmation_number":"SJ12684842435","room_stay_from":"2021-08-26","room_stay_to":"2021-08-30","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":"126882","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-20 00:48:36","reservation_modified_date_time":"2021-08-26 21:28:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126882","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":"5303930","reservation_id":"121977","confirmation_number":"SJ12674235959","room_confirmation_number":"SJ12662082596","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","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":"129517","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-26 22:14:12","reservation_modified_date_time":"2021-08-26 22:14:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129517","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":"5303934","reservation_id":"121977","confirmation_number":"SJ12699226036","room_confirmation_number":"SJ12676633464","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","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":"129517","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-26 22:14:18","reservation_modified_date_time":"2021-08-26 22:14:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129517","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":"5304420","reservation_id":"119139","confirmation_number":"SJ12663164553","room_confirmation_number":"SJ12680645831","room_stay_from":"2021-08-27","room_stay_to":"2021-08-30","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"126259","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-11 20:11:11","reservation_modified_date_time":"2021-08-27 21:07:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126259","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":"5304652","reservation_id":"115585","confirmation_number":"SJ12651089318","room_confirmation_number":"SJ12625515998","room_stay_from":"2021-08-27","room_stay_to":"2021-08-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"122337","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-20 22:52:10","reservation_modified_date_time":"2021-08-28 00:54:51","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5304753","reservation_id":"119419","confirmation_number":"SJ12655422357","room_confirmation_number":"SJ12699381618","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","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":"126560","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-15 22:13:08","reservation_modified_date_time":"2021-08-28 14:00:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126560","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":"5304777","reservation_id":"116046","confirmation_number":"SJ12628699031","room_confirmation_number":"SJ12682923588","room_stay_from":"2021-08-29","room_stay_to":"2021-09-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"122855","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-28 00:13:25","reservation_modified_date_time":"2021-08-28 14:16:49","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":"5305042","reservation_id":"122013","confirmation_number":"SJ12665392057","room_confirmation_number":"SJ12677081658","room_stay_from":"2021-08-28","room_stay_to":"2021-09-01","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":"129551","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-27 17:49:07","reservation_modified_date_time":"2021-08-28 19:35:25","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129551","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"5305071","reservation_id":"118676","confirmation_number":"SJ12649725073","room_confirmation_number":"SJ12613128135","room_stay_from":"2021-08-28","room_stay_to":"2021-08-30","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":"125750","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-04 18:39:43","reservation_modified_date_time":"2021-08-28 20:18:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125750","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":"5305142","reservation_id":"119307","confirmation_number":"SJ12678100684","room_confirmation_number":"SJ12642302177","room_stay_from":"2021-08-28","room_stay_to":"2021-08-31","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":"126438","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-14 14:47:57","reservation_modified_date_time":"2021-08-28 22:30:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126438","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":"5305197","reservation_id":"122131","confirmation_number":"SJ12672167857","room_confirmation_number":"SJ12628064481","room_stay_from":"2021-08-29","room_stay_to":"2021-09-01","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":"129701","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-28 23:58:31","reservation_modified_date_time":"2021-08-28 23:58:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129701","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":"5305236","reservation_id":"116038","confirmation_number":"SJ12673197210","room_confirmation_number":"SJ12639868735","room_stay_from":"2021-08-29","room_stay_to":"2021-09-05","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":"122845","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-27 23:30:59","reservation_modified_date_time":"2021-08-29 01:49:46","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":"5305413","reservation_id":"122146","confirmation_number":"SJ12680338817","room_confirmation_number":"SJ12627373574","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","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":"129640","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-29 15:14:52","reservation_modified_date_time":"2021-08-29 15:14:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129640","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":"5305446","reservation_id":"122150","confirmation_number":"SJ12626817459","room_confirmation_number":"SJ12691345875","room_stay_from":"2021-08-29","room_stay_to":"2021-08-30","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"129722","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-29 17:26:10","reservation_modified_date_time":"2021-08-29 17:44:49","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129722","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","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":"5305795","reservation_id":"121209","confirmation_number":"SJ12619479469","room_confirmation_number":"SJ12613695328","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","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":"128679","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-15 01:01:18","reservation_modified_date_time":"2021-08-29 23:50:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128679","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":"5305658","reservation_id":"113273","confirmation_number":"SJ12635014180","room_confirmation_number":"SJ12617941038","room_stay_from":"2021-09-17","room_stay_to":"2021-09-22","room_stay_status":"Active","nightly_price":"25,25,25,25,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119862","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-18 01:13:11","reservation_modified_date_time":"2021-08-29 19:36:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119862","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":"5304886","reservation_id":"121588","confirmation_number":"SJ12666500696","room_confirmation_number":"SJ12686523609","room_stay_from":"2021-08-28","room_stay_to":"2021-08-31","room_stay_status":"Canceled","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","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-20 19:34:19","reservation_modified_date_time":"2021-08-28 16:20:56","customer_id":"129080","parentCustTravId":"129080","customer_traveller_id":"129080","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-08-29 21:22:11","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","parentRoomStayFrom":"2021-08-28","sub_hotel_id":"126","deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}