{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-06-30","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":12,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1282,1286,1304","block_room_bookings":[{"confirmation_number":"SJ12686560076","room_stay_from":"2021-06-30","room_stay_to":"2021-07-01","bundle_room":"0","product_id":"1282"},{"confirmation_number":"SJ12645807054","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","bundle_room":"0","product_id":"1286"},{"confirmation_number":"SJ12675759026","room_stay_from":"2021-06-29","room_stay_to":"2021-07-04","bundle_room":"0","product_id":"1304"}],"bundle_block_count":"1302,1303,1311,1312,1269,1270,1262,1263,1260,1261,1309,1310,1271,1272,1307,1308,1291,1711,1267,1268,1304,1305","bundle_block_bookings":[{"confirmation_number":"SJB12622314205","room_stay_from":"2021-06-26","room_stay_to":"2021-07-01","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12651248539","room_stay_from":"2021-06-26","room_stay_to":"2021-07-01","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12643658267","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12694456161","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12633049585","room_stay_from":"2021-06-30","room_stay_to":"2021-07-01","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12684132960","room_stay_from":"2021-06-30","room_stay_to":"2021-07-01","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12642886615","room_stay_from":"2021-06-29","room_stay_to":"2021-07-01","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12655129290","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12664546988","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12690154160","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12691702315","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12655400355","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12618783356","room_stay_from":"2021-06-30","room_stay_to":"2021-07-02","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12672385239","room_stay_from":"2021-06-30","room_stay_to":"2021-07-02","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12672374981","room_stay_from":"2021-06-28","room_stay_to":"2021-07-03","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12635840573","room_stay_from":"2021-06-28","room_stay_to":"2021-07-03","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12688303794","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12667005822","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12684629838","room_stay_from":"2021-06-29","room_stay_to":"2021-07-04","bundle_room":"1","product_id":"1329"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3240302","reservation_id":"113701","confirmation_number":"SJ12685454450","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","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":"318","product_id":"1289","siteminder_id":"BDC-3562632381","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":"120311","customer_id":"120311","source_of_creation":"Booking.com","reservation_created_date":"2021-04-23 15:19:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"148.54","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":"3271506","reservation_id":"116723","confirmation_number":"SJ12649754495","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"265.30,265.30,265.30,286.30","nightly_discount":"0,0,0,0","subtotal":"1082.20","grand_total":"1217.48","paid_amount":"1217.48","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-2675041216","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":"123625","customer_id":"123625","source_of_creation":"Booking.com","reservation_created_date":"2021-06-07 14:58:31","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"286.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":"3273608","reservation_id":"112595","confirmation_number":"SJ12696601929","room_stay_from":"2021-06-25","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"275.80,275.80,198.80,198.80,198.80,198.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1346.80","grand_total":"1515.15","paid_amount":"1515.15","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-2398124566","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":"119175","customer_id":"119175","source_of_creation":"Booking.com","reservation_created_date":"2021-04-10 14:51:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"269.42","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"198.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3275216","reservation_id":"110793","confirmation_number":"SJ12616732724","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"195.30,195.30,195.30,195.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"781.20","grand_total":"878.85","paid_amount":"878.85","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-2881299124","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":"117303","customer_id":"117303","source_of_creation":"Booking.com","reservation_created_date":"2021-03-20 13:17:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"158.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.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":"3228496","reservation_id":"112124","confirmation_number":"SJ12617525714","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"265.30,265.30,265.30,279.30","nightly_discount":"0,0,0,0","subtotal":"1075.20","grand_total":"1209.60","paid_amount":"1209.60","room_type_id":"320","product_id":"1324","siteminder_id":"BDC-2357570489","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":"118693","customer_id":"118693","source_of_creation":"Booking.com","reservation_created_date":"2021-04-04 23:35:17","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":"","sub_hotel_id":"126","group_rooms":"1271,1272","currentDayPrice":"265.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3231742","reservation_id":"112574","confirmation_number":"SJ12675456502","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.27,144.27,144.27,144.27,144.27","nightly_discount":"0,0,0,0,0","subtotal":"721.35","grand_total":"811.52","paid_amount":"811.52","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2161126573","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":"119153","customer_id":"119153","source_of_creation":"Booking.com","reservation_created_date":"2021-04-10 02:14:24","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","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":"144.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":"3240562","reservation_id":"113719","confirmation_number":"SJ12617869053","room_stay_from":"2021-06-26","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,181.30,181.30,181.30,181.30,195.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1150.80","grand_total":"1294.65","paid_amount":"1294.65","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-3790806539","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":"120330","customer_id":"120330","source_of_creation":"Booking.com","reservation_created_date":"2021-04-23 18:43:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"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":"3249760","reservation_id":"114970","confirmation_number":"SJ12664749078","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.92,178.92,178.92,178.92,191.52","nightly_discount":"0,0,0,0,0","subtotal":"907.20","grand_total":"1020.60","paid_amount":"1020.60","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-2337402390","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":"121691","customer_id":"121691","source_of_creation":"Booking.com","reservation_created_date":"2021-05-11 01:14:09","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"185.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"178.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":"3252225","reservation_id":"113305","confirmation_number":"SJ12629389107","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","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":"412","product_id":"1294","siteminder_id":"BDC-2576395432","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":"119889","customer_id":"119889","source_of_creation":"Booking.com","reservation_created_date":"2021-04-18 17:07:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"151.06","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3226319","reservation_id":"110854","confirmation_number":"SJ12664628580","room_stay_from":"2021-06-26","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"1","nightly_price":"237.64,215.24,215.24,215.24,215.24","nightly_discount":"0,0,0,0,0","subtotal":"1098.60","grand_total":"1235.93","paid_amount":"1235.93","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1750162176","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":"117376","customer_id":"117376","source_of_creation":"Expedia","reservation_created_date":"2021-03-21 00:37:18","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"215.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"}]},{"room_stay_id":"3262180","reservation_id":"116312","confirmation_number":"SJ12656176513","room_stay_from":"2021-06-28","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"246.75,246.75,269.25","nightly_discount":"0,0,0","subtotal":"762.75","grand_total":"858.10","paid_amount":"858.10","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1778844866","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":"123174","customer_id":"123174","source_of_creation":"Expedia","reservation_created_date":"2021-06-01 14:21:28","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"269.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":"3276107","reservation_id":"114350","confirmation_number":"SJ12656450869","room_stay_from":"2021-06-30","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.12","nightly_discount":"0","subtotal":"176.12","grand_total":"198.14","paid_amount":"198.14","room_type_id":"319","product_id":"1313","siteminder_id":"EXP-1766235301","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":"121014","customer_id":"121014","source_of_creation":"Expedia","reservation_created_date":"2021-05-02 18:05:08","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":"176.12","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3228473","reservation_id":"111976","confirmation_number":"SJ12697263046","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.24,128.24,128.24,139.44","nightly_discount":"0,0,0,0","subtotal":"524.16","grand_total":"589.68","paid_amount":"589.68","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1755389957","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":"118540","customer_id":"118540","source_of_creation":"Expedia","reservation_created_date":"2021-04-03 13:57:41","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":"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"}]},{"room_stay_id":"3236459","reservation_id":"112835","confirmation_number":"SJ12694326082","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,160.30,160.30,174.30","nightly_discount":"0,0,0,0","subtotal":"655.20","grand_total":"737.10","paid_amount":"737.10","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1758913165","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":"119419","customer_id":"119419","source_of_creation":"Expedia","reservation_created_date":"2021-04-13 00:09:43","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","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":"3274896","reservation_id":"112143","confirmation_number":"SJ12668996453","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.24,128.24,128.24,139.44","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"524.16","grand_total":"589.68","paid_amount":"589.68","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1755976586","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":"118712","customer_id":"118712","source_of_creation":"Expedia","reservation_created_date":"2021-04-05 12:52:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"128.24","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3246200","reservation_id":"114423","confirmation_number":"SJ12689062824","room_stay_from":"2021-06-27","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.80,198.80,198.80,198.80,212.80,296.80","nightly_discount":"0,0,0,0,0,0","subtotal":"1304.80","grand_total":"1467.90","paid_amount":"1467.90","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1766568511","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":"121098","customer_id":"121098","source_of_creation":"Expedia","reservation_created_date":"2021-05-03 15:45:17","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"198.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3275552","reservation_id":"113861","confirmation_number":"SJ12661440393","room_stay_from":"2021-06-29","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"181.30,181.30,195.30,279.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"837.20","grand_total":"941.85","paid_amount":"941.85","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1763596228","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":"120485","customer_id":"120485","source_of_creation":"Expedia","reservation_created_date":"2021-04-25 17:44:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"181.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":"3272432","reservation_id":"111666","confirmation_number":"SJ12610771285","room_stay_from":"2021-06-30","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,195.30,230.30,230.30,230.30","nightly_discount":"0,0,0,0,0","subtotal":"1067.50","grand_total":"1200.94","paid_amount":"1200.94","room_type_id":"319","product_id":"1943","siteminder_id":"EXP-1753740236","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":"118222","customer_id":"118222","source_of_creation":"Expedia","reservation_created_date":"2021-03-30 04:17:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","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":"3276105","reservation_id":"118380","confirmation_number":"SJ12654040264","room_stay_from":"2021-06-30","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"237.64","nightly_discount":"0","subtotal":"237.64","grand_total":"267.34","paid_amount":"267.34","room_type_id":"412","product_id":"1315","siteminder_id":"HTN-165863025-FPYJZN","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":"125398","customer_id":"125398","source_of_creation":"HotelTonight","reservation_created_date":"2021-06-30 09:42:10","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","currentDayPrice":"237.64","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":"3275003","reservation_id":"111476","confirmation_number":"SJ12677242204","room_stay_from":"2021-06-27","room_stay_to":"2021-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"139.60,139.60,139.60,139.60,150.38,177.33,177.33","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1063.44","grand_total":"1196.37","paid_amount":"1196.37","room_type_id":"318","product_id":"1281","siteminder_id":"GAM-R2411890958","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":"125295","customer_id":"125295","source_of_creation":"Getaroom.com","reservation_created_date":"2021-03-28 00:09:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3274241","reservation_id":"114944","confirmation_number":"SJ12680919922","room_stay_from":"2021-06-27","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"3","nightly_price":"301.87,313.14,313.14,313.14,313.14,313.14","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1867.57","grand_total":"2164.26","paid_amount":"2164.26","room_type_id":"319","product_id":"1942","siteminder_id":"ABB-HMEJRRDNKW","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1878.84","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121666","customer_id":"121666","source_of_creation":"Airbnb","reservation_created_date":"2021-05-10 20:59:02","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"55.26","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"313.14","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":"3232912","reservation_id":"112735","confirmation_number":"SJ12662416516","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"284.25,284.25,284.25,284.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1137.00","grand_total":"1279.13","paid_amount":"1279.13","room_type_id":"320","product_id":"1332","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":"119327","customer_id":"119327","source_of_creation":"FE","reservation_created_date":"2021-04-11 23:59:28","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":"","sub_hotel_id":"0","group_rooms":"1311,1312","currentDayPrice":"284.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":"3248958","reservation_id":"114843","confirmation_number":"SJ12640766434","room_stay_from":"2021-06-30","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"220.15","nightly_discount":"0.00","subtotal":"220.15","grand_total":"247.67","paid_amount":"247.67","room_type_id":"319","product_id":"1314","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":"121579","customer_id":"121579","source_of_creation":"FE","reservation_created_date":"2021-05-09 20:16:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","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.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":"3232266","reservation_id":"112637","confirmation_number":"SJ12649037576","room_stay_from":"2021-06-30","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"322.15,339.15","nightly_discount":"0.00,0.00","subtotal":"661.30","grand_total":"743.97","paid_amount":"743.97","room_type_id":"320","product_id":"1330","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":"119222","customer_id":"119222","source_of_creation":"FE","reservation_created_date":"2021-04-10 22:22:14","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":"","sub_hotel_id":"0","group_rooms":"1307,1308","currentDayPrice":"322.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":"3275794","reservation_id":"105306","confirmation_number":"SJ12646031307","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"134.25,134.25,134.25,134.25,134.25","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"671.25","grand_total":"755.15","paid_amount":"755.15","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":"111692","customer_id":"111692","source_of_creation":"FE","reservation_created_date":"2021-01-14 02:13:51","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"134.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":"3228491","reservation_id":"110190","confirmation_number":"SJ12690257418","room_stay_from":"2021-06-28","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"2","nightly_price":"261.75,261.75,261.75,299.25,336.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1421.25","grand_total":"1598.90","paid_amount":"1598.90","room_type_id":"320","product_id":"1714","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116708","customer_id":"116708","source_of_creation":"FE","reservation_created_date":"2021-03-13 13:51:14","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1291,1711","currentDayPrice":"261.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":"3272334","reservation_id":"111482","confirmation_number":"SJ12659438467","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"284.25,299.25,336.75","nightly_discount":"0.00,0.00,0.00","subtotal":"920.25","grand_total":"1035.28","paid_amount":"1035.28","room_type_id":"320","product_id":"1322","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":"118029","customer_id":"118029","source_of_creation":"FE","reservation_created_date":"2021-03-28 01:11:43","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","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":"1267,1268","currentDayPrice":"284.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":"3253271","reservation_id":"115411","confirmation_number":"SJ12680691762","room_stay_from":"2021-06-30","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"8","room_stay_child_count":"0","nightly_price":"381.65","nightly_discount":"0.00","subtotal":"381.65","grand_total":"429.35","paid_amount":"429.35","room_type_id":"320","product_id":"1323","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122145","customer_id":"122145","source_of_creation":"PMS","reservation_created_date":"2021-05-17 21:43:31","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1269,1270","currentDayPrice":"381.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3224185","reservation_id":"108831","confirmation_number":"SJ12627091441","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.75,261.75,261.75,299.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1084.50","grand_total":"1220.07","paid_amount":"1220.07","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":"115289","customer_id":"115289","source_of_creation":"PMS","reservation_created_date":"2021-02-28 16:21:42","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 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":"261.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":"3260066","reservation_id":"116264","confirmation_number":"SJ12687282636","room_stay_from":"2021-06-27","room_stay_to":"2021-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.30,300.30,300.30,300.30,314.30,349.30,349.30","nightly_discount":"15.02,15.02,15.02,15.02,15.72,17.47,17.47","subtotal":"2214.10","grand_total":"2366.28","paid_amount":"2366.28","room_type_id":"413","product_id":"1273","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":"123123","customer_id":"123123","source_of_creation":"PMS","reservation_created_date":"2021-05-31 18:55:16","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"300.30","currentDayDiscount":"15.02","productIsTaxExempt":false,"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":"3271500","reservation_id":"102628","confirmation_number":"SJ12677271328","room_stay_from":"2021-06-26","room_stay_to":"2021-07-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":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-11-13 22:15:03","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":"3271965","reservation_id":"106700","confirmation_number":"SJ12634537256","room_stay_from":"2021-06-28","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0,0","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1301","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-02 00:04:21","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":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3273675","reservation_id":"110118","confirmation_number":"SJ12610545165","room_stay_from":"2021-06-28","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0,0","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1319","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-12 03:03:47","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":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3274770","reservation_id":"109197","confirmation_number":"SJ12617492196","room_stay_from":"2021-06-28","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0,0","subtotal":"260.01","grand_total":"260.01","paid_amount":"159.38","room_type_id":"319","product_id":"1915","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 20:40:05","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":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3274802","reservation_id":"108357","confirmation_number":"SJ12689160723","room_stay_from":"2021-06-28","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0,0","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1263","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-23 02:03:32","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0","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":"3276143","reservation_id":"109196","confirmation_number":"SJ12683647945","room_stay_from":"2021-06-29","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.66,173.34","nightly_discount":"0.00,0.00","subtotal":"260.00","grand_total":"260.00","paid_amount":"0.00","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 20:37:56","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"From date changed","deltaChange":"-86.68","currentDayPrice":"173.34","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":"3217780","reservation_id":"99180","confirmation_number":"SJ12696204199","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","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":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-08-17 19:33:02","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":"3271824","reservation_id":"110534","confirmation_number":"SJ12611391505","room_stay_from":"2021-06-25","room_stay_to":"2021-07-02","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.00,0.00,0,0,0","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 18:00:57","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":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3271838","reservation_id":"110535","confirmation_number":"SJ12655075815","room_stay_from":"2021-06-25","room_stay_to":"2021-07-02","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,0,0,0,0,0","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 18:12:07","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":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3275431","reservation_id":"109198","confirmation_number":"SJ12650305238","room_stay_from":"2021-06-29","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 20:41:31","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":"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":"3275602","reservation_id":"109200","confirmation_number":"SJ12619720102","room_stay_from":"2021-06-29","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1262","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 21:18:14","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3240567","reservation_id":"109222","confirmation_number":"SJ12690007735","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 23:39:58","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3271830","reservation_id":"109220","confirmation_number":"SJ12641803244","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 23:33:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3272438","reservation_id":"109221","confirmation_number":"SJ12696315862","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0,0","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1917","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 23:36:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3276164","reservation_id":"109220","confirmation_number":"SJ12677351266","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 23:33:25","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","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":"3260047","reservation_id":"108378","confirmation_number":"SJ12639516716","room_stay_from":"2021-06-29","room_stay_to":"2021-07-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","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":"1305","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-23 02:42:33","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","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":"3276077","reservation_id":"107534","confirmation_number":"SJ12687594274","room_stay_from":"2021-05-12","room_stay_to":"2021-05-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.66,173.34","nightly_discount":"0.00,0.00","subtotal":"260.00","grand_total":"260.00","paid_amount":"84.38","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-13 19:50:56","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":"0","changedComment":"Nightly price or discount changed","deltaChange":"-0.01","currentDayPrice":0,"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":"3226322","reservation_id":"110854","confirmation_number":"SJ12611787722","room_confirmation_number":"SJ12664628580","room_stay_from":"2021-06-26","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"0,0,0,0,0","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1777","service_quantity":"1","customer_traveller_id":"117376","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-02 02:38:42","reservation_modified_date_time":"2021-04-02 02:38:42","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117376","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":"3253272","reservation_id":"115411","confirmation_number":"SJ12697931056","room_confirmation_number":"SJ12680691762","room_stay_from":"2021-06-30","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"50.00","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"122145","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-05-17 21:43:31","reservation_modified_date_time":"2021-05-17 21:43:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122145","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"50.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":"3228494","reservation_id":"110190","confirmation_number":"SJ12637523949","room_confirmation_number":"SJ12690257418","room_stay_from":"2021-06-28","room_stay_to":"2021-07-03","room_stay_status":"Active","nightly_price":"50,50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"116708","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-05 18:33:56","reservation_modified_date_time":"2021-04-05 18:33:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116708","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3272337","reservation_id":"111482","confirmation_number":"SJ12689904306","room_confirmation_number":"SJ12659438467","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"118029","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-23 19:11:39","reservation_modified_date_time":"2021-06-23 19:11:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118029","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3226323","reservation_id":"110854","confirmation_number":"SJ12637011351","room_confirmation_number":"SJ12664628580","room_stay_from":"2021-06-26","room_stay_to":"2021-07-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":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"117376","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-21 00:37:18","reservation_modified_date_time":"2021-04-02 02:38:42","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117376","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":"3232913","reservation_id":"112735","confirmation_number":"SJ12697499549","room_confirmation_number":"SJ12662416516","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","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":"119327","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-11 23:59:28","reservation_modified_date_time":"2021-04-11 23:59:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119327","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":"3240303","reservation_id":"113701","confirmation_number":"SJ12637596500","room_confirmation_number":"SJ12685454450","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","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":"120311","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-23 15:19:11","reservation_modified_date_time":"2021-04-23 15:19:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120311","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":"3248959","reservation_id":"114843","confirmation_number":"SJ12680833465","room_confirmation_number":"SJ12640766434","room_stay_from":"2021-06-30","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.12","paid_amount":"28.12","product_id":"1776","service_quantity":"1","customer_traveller_id":"121579","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-09 20:16:18","reservation_modified_date_time":"2021-05-09 20:16:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121579","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":"3253273","reservation_id":"115411","confirmation_number":"SJ12656995585","room_confirmation_number":"SJ12680691762","room_stay_from":"2021-06-30","room_stay_to":"2021-07-01","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":"122145","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-17 21:43:31","reservation_modified_date_time":"2021-05-17 21:43:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122145","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":"3262179","reservation_id":"116312","confirmation_number":"SJ12696138616","room_confirmation_number":"SJ12656176513","room_stay_from":"2021-06-28","room_stay_to":"2021-07-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":"123174","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-01 14:21:28","reservation_modified_date_time":"2021-06-04 22:28:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123174","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":"3271501","reservation_id":"102628","confirmation_number":"SJ12643614116","room_confirmation_number":"SJ12677271328","room_stay_from":"2021-06-26","room_stay_to":"2021-07-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":"108774","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-13 22:15:03","reservation_modified_date_time":"2021-06-21 18:39:55","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":"3271507","reservation_id":"116723","confirmation_number":"SJ12674559147","room_confirmation_number":"SJ12649754495","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","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":"123625","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-07 14:58:31","reservation_modified_date_time":"2021-06-21 18:41:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123625","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":"3271966","reservation_id":"106700","confirmation_number":"SJ12622091007","room_confirmation_number":"SJ12634537256","room_stay_from":"2021-06-28","room_stay_to":"2021-07-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113120","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-02 00:04:21","reservation_modified_date_time":"2021-06-22 18:34: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":"3273609","reservation_id":"112595","confirmation_number":"SJ12698146074","room_confirmation_number":"SJ12696601929","room_stay_from":"2021-06-25","room_stay_to":"2021-07-01","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":"119175","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 14:51:08","reservation_modified_date_time":"2021-06-25 21:25:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119175","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":"3273676","reservation_id":"110118","confirmation_number":"SJ12627558094","room_confirmation_number":"SJ12610545165","room_stay_from":"2021-06-28","room_stay_to":"2021-07-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116623","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-12 03:03:47","reservation_modified_date_time":"2021-06-25 22:23:17","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":"3274771","reservation_id":"109197","confirmation_number":"SJ12661391495","room_confirmation_number":"SJ12617492196","room_stay_from":"2021-06-28","room_stay_to":"2021-07-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115667","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 20:40:05","reservation_modified_date_time":"2021-06-28 18:14:44","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":"3274803","reservation_id":"108357","confirmation_number":"SJ12644035367","room_confirmation_number":"SJ12689160723","room_stay_from":"2021-06-28","room_stay_to":"2021-07-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114809","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 02:03:32","reservation_modified_date_time":"2021-06-28 19:09:47","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":"3275217","reservation_id":"110793","confirmation_number":"SJ12688701975","room_confirmation_number":"SJ12616732724","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"25.00,25.00,0.00,0.00","subtotal":"100.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"117303","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-20 13:17:07","reservation_modified_date_time":"2021-06-29 15:40:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117303","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":"3276106","reservation_id":"118380","confirmation_number":"SJ12634844650","room_confirmation_number":"SJ12654040264","room_stay_from":"2021-06-30","room_stay_to":"2021-07-01","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":"125398","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-30 09:42:10","reservation_modified_date_time":"2021-06-30 21:04:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125398","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":"3276108","reservation_id":"114350","confirmation_number":"SJ12697486399","room_confirmation_number":"SJ12656450869","room_stay_from":"2021-06-30","room_stay_to":"2021-07-01","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":"121014","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-02 18:05:08","reservation_modified_date_time":"2021-06-30 21:04:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121014","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":"3276144","reservation_id":"109196","confirmation_number":"SJ12621956228","room_confirmation_number":"SJ12683647945","room_stay_from":"2021-06-29","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115666","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 20:37:56","reservation_modified_date_time":"2021-06-30 22:41:35","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"From date changed","deltaChange":"-50.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":"3217781","reservation_id":"99180","confirmation_number":"SJ12654750415","room_confirmation_number":"SJ12696204199","room_stay_from":"2021-06-27","room_stay_to":"2021-07-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"105159","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-17 19:33:02","reservation_modified_date_time":"2021-03-18 01:30:47","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":"3224188","reservation_id":"108831","confirmation_number":"SJ12611009634","room_confirmation_number":"SJ12627091441","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"115289","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-28 16:21:43","reservation_modified_date_time":"2021-03-28 18:43:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115289","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3228474","reservation_id":"111976","confirmation_number":"SJ12653212786","room_confirmation_number":"SJ12697263046","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"118540","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 13:57:41","reservation_modified_date_time":"2021-04-05 18:30:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118540","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":"3228499","reservation_id":"112124","confirmation_number":"SJ12685166691","room_confirmation_number":"SJ12617525714","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"118693","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-04 23:35:17","reservation_modified_date_time":"2021-04-05 18:34:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118693","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":"3231744","reservation_id":"112574","confirmation_number":"SJ12612322535","room_confirmation_number":"SJ12675456502","room_stay_from":"2021-06-27","room_stay_to":"2021-07-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":"119153","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 02:14:24","reservation_modified_date_time":"2021-04-10 13:50:27","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119153","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":"3232267","reservation_id":"112637","confirmation_number":"SJ12660820072","room_confirmation_number":"SJ12649037576","room_stay_from":"2021-06-30","room_stay_to":"2021-07-02","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":"119222","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 22:22:14","reservation_modified_date_time":"2021-04-10 22:22:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119222","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":"3236458","reservation_id":"112835","confirmation_number":"SJ12661990843","room_confirmation_number":"SJ12694326082","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"119419","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-13 00:09:43","reservation_modified_date_time":"2021-04-17 20:41:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119419","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":"3240561","reservation_id":"113719","confirmation_number":"SJ12628381146","room_confirmation_number":"SJ12617869053","room_stay_from":"2021-06-26","room_stay_to":"2021-07-02","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":"120330","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-23 18:43:25","reservation_modified_date_time":"2021-04-23 19:31:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120330","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":"3249761","reservation_id":"114970","confirmation_number":"SJ12620960775","room_confirmation_number":"SJ12664749078","room_stay_from":"2021-06-27","room_stay_to":"2021-07-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":"121691","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-11 01:14:09","reservation_modified_date_time":"2021-05-11 01:14:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121691","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":"3252226","reservation_id":"113305","confirmation_number":"SJ12675948005","room_confirmation_number":"SJ12629389107","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"119889","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-18 17:07:08","reservation_modified_date_time":"2021-05-15 15:15:32","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119889","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":"3271825","reservation_id":"110534","confirmation_number":"SJ12680818406","room_confirmation_number":"SJ12611391505","room_stay_from":"2021-06-25","room_stay_to":"2021-07-02","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":"117047","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 18:00:57","reservation_modified_date_time":"2021-06-22 15:09:54","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":"3271839","reservation_id":"110535","confirmation_number":"SJ12657000227","room_confirmation_number":"SJ12655075815","room_stay_from":"2021-06-25","room_stay_to":"2021-07-02","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":"117047","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 18:12:07","reservation_modified_date_time":"2021-06-22 15:15:05","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":"3274897","reservation_id":"112143","confirmation_number":"SJ12671826244","room_confirmation_number":"SJ12668996453","room_stay_from":"2021-06-28","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"118712","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-05 12:52:12","reservation_modified_date_time":"2021-06-28 21:49:32","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118712","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":"3275432","reservation_id":"109198","confirmation_number":"SJ12618455134","room_confirmation_number":"SJ12650305238","room_stay_from":"2021-06-29","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115668","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 20:41:31","reservation_modified_date_time":"2021-06-29 19:57:06","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":"3275603","reservation_id":"109200","confirmation_number":"SJ12670919179","room_confirmation_number":"SJ12619720102","room_stay_from":"2021-06-29","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115672","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 21:18:14","reservation_modified_date_time":"2021-06-29 22:55:41","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":"3275796","reservation_id":"105306","confirmation_number":"SJ12676811150","room_confirmation_number":"SJ12646031307","room_stay_from":"2021-06-27","room_stay_to":"2021-07-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":"111692","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 02:13:51","reservation_modified_date_time":"2021-06-30 13:53:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111692","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3228495","reservation_id":"110190","confirmation_number":"SJ12656243803","room_confirmation_number":"SJ12690257418","room_stay_from":"2021-06-28","room_stay_to":"2021-07-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":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"116708","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-13 13:51:14","reservation_modified_date_time":"2021-04-05 18:33:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116708","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":"3240568","reservation_id":"109222","confirmation_number":"SJ12648389914","room_confirmation_number":"SJ12690007735","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","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":"115690","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 23:39:58","reservation_modified_date_time":"2021-04-23 19:40:26","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":"3246199","reservation_id":"114423","confirmation_number":"SJ12688969029","room_confirmation_number":"SJ12689062824","room_stay_from":"2021-06-27","room_stay_to":"2021-07-03","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":"121098","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-03 15:45:17","reservation_modified_date_time":"2021-05-03 15:45:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121098","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":"3271831","reservation_id":"109220","confirmation_number":"SJ12677621745","room_confirmation_number":"SJ12641803244","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","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":"115688","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 23:33:25","reservation_modified_date_time":"2021-06-22 15:14:24","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":"3272338","reservation_id":"111482","confirmation_number":"SJ12657601918","room_confirmation_number":"SJ12659438467","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","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":"118029","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-28 01:11:43","reservation_modified_date_time":"2021-06-23 19:11:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118029","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":"3272439","reservation_id":"109221","confirmation_number":"SJ12644051344","room_confirmation_number":"SJ12696315862","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","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":"115689","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 23:36:13","reservation_modified_date_time":"2021-06-23 20:44:14","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":"3274242","reservation_id":"114944","confirmation_number":"SJ12613396407","room_confirmation_number":"SJ12680919922","room_stay_from":"2021-06-27","room_stay_to":"2021-07-03","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121666","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-10 20:59:02","reservation_modified_date_time":"2021-06-27 12:58:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121666","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":"3275553","reservation_id":"113861","confirmation_number":"SJ12657412357","room_confirmation_number":"SJ12661440393","room_stay_from":"2021-06-29","room_stay_to":"2021-07-03","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":"120485","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-25 17:44:09","reservation_modified_date_time":"2021-06-29 22:22:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120485","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":"3276165","reservation_id":"109220","confirmation_number":"SJ12669288440","room_confirmation_number":"SJ12677351266","room_stay_from":"2021-06-30","room_stay_to":"2021-07-03","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":"116656","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 23:33:25","reservation_modified_date_time":"2021-06-30 23:08:25","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":"3260049","reservation_id":"108378","confirmation_number":"SJ12688455501","room_confirmation_number":"SJ12639516716","room_stay_from":"2021-06-29","room_stay_to":"2021-07-04","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":"114829","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 02:42:33","reservation_modified_date_time":"2021-05-31 18:48:09","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":"3260067","reservation_id":"116264","confirmation_number":"SJ12621452758","room_confirmation_number":"SJ12687282636","room_stay_from":"2021-06-27","room_stay_to":"2021-07-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":"123123","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-31 18:55:16","reservation_modified_date_time":"2021-05-31 18:55:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123123","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":"3275001","reservation_id":"111476","confirmation_number":"SJ12639912371","room_confirmation_number":"SJ12677242204","room_stay_from":"2021-06-27","room_stay_to":"2021-07-04","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"125295","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-28 00:09:08","reservation_modified_date_time":"2021-06-28 22:33:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125295","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":"3272433","reservation_id":"111666","confirmation_number":"SJ12634566415","room_confirmation_number":"SJ12610771285","room_stay_from":"2021-06-30","room_stay_to":"2021-07-05","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":"118222","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-30 04:17:11","reservation_modified_date_time":"2021-06-23 20:43:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118222","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3276076","reservation_id":"107534","confirmation_number":"SJ12617020019","room_confirmation_number":"SJ12687594274","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-06-30 20:46:21","reservation_modified_date_time":"2021-06-30 20:46:21","customer_id":"82465","parentCustTravId":"122254","customer_traveller_id":"113993","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-05-12","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}