{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-04-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":25,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1267,1268,1309,1310,1260,1261,1269,1270,1291,1711,1302,1303,1262,1263,1271,1272,1311,1312,1304,1305,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12622622547","room_stay_from":"2021-04-30","room_stay_to":"2021-05-01","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12660864207","room_stay_from":"2021-04-30","room_stay_to":"2021-05-01","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12649353866","room_stay_from":"2021-04-28","room_stay_to":"2021-05-01","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12611023958","room_stay_from":"2021-04-30","room_stay_to":"2021-05-02","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12628488881","room_stay_from":"2021-04-30","room_stay_to":"2021-05-02","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12684779870","room_stay_from":"2021-04-29","room_stay_to":"2021-05-02","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12686361906","room_stay_from":"2021-04-29","room_stay_to":"2021-05-02","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12623083042","room_stay_from":"2021-04-30","room_stay_to":"2021-05-02","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12653735419","room_stay_from":"2021-04-30","room_stay_to":"2021-05-03","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12681198079","room_stay_from":"2021-04-30","room_stay_to":"2021-05-03","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12681930353","room_stay_from":"2021-04-30","room_stay_to":"2021-05-03","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12696267591","room_stay_from":"2021-04-28","room_stay_to":"2021-05-03","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12699610411","room_stay_from":"2021-04-28","room_stay_to":"2021-05-03","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12630895290","room_stay_from":"2021-04-30","room_stay_to":"2021-05-04","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12673942620","room_stay_from":"2021-04-30","room_stay_to":"2021-05-04","bundle_room":"0","product_id":"1308"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3203103","reservation_id":"108281","confirmation_number":"SJ12636974410","room_stay_from":"2021-04-28","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.84,129.84,152.52,152.52,112.83","nightly_discount":"0,0,0,0,0","subtotal":"677.55","grand_total":"762.25","paid_amount":"762.25","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3004188921","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":"114740","customer_id":"114740","source_of_creation":"Booking.com","reservation_created_date":"2021-02-22 17:23:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"144.45","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"152.52","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":"3205910","reservation_id":"108800","confirmation_number":"SJ12650951171","room_stay_from":"2021-04-30","room_stay_to":"2021-05-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.20,239.20","nightly_discount":"0,0","subtotal":"478.40","grand_total":"538.20","paid_amount":"538.20","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-3535056429","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":"115259","customer_id":"115259","source_of_creation":"Booking.com","reservation_created_date":"2021-02-28 01:55:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"95.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"239.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3206543","reservation_id":"108625","confirmation_number":"SJ12656346023","room_stay_from":"2021-04-26","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.30,195.30,195.30,195.30,230.30,230.30,160.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1402.10","grand_total":"1577.37","paid_amount":"1577.37","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-2712943488","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":"115064","customer_id":"115064","source_of_creation":"Booking.com","reservation_created_date":"2021-02-26 04:07:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"283.85","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3215145","reservation_id":"110225","confirmation_number":"SJ12641959346","room_stay_from":"2021-04-30","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.37,251.37,163.17,163.17,163.17,163.17,163.17,207.27,207.27,163.17","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"1896.30","grand_total":"2133.34","paid_amount":"2133.34","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-3439332408","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":"116739","customer_id":"116739","source_of_creation":"Booking.com","reservation_created_date":"2021-03-13 20:21:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"386.33","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"251.37","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3225826","reservation_id":"111801","confirmation_number":"SJ12647895967","room_stay_from":"2021-04-29","room_stay_to":"2021-05-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.06,257.58,257.58,233.28,215.06,196.83,196.83","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1572.22","grand_total":"1768.75","paid_amount":"1768.75","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2261901630","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":"118358","customer_id":"118358","source_of_creation":"Booking.com","reservation_created_date":"2021-04-01 01:00:18","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"257.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3231992","reservation_id":"109124","confirmation_number":"SJ12616237128","room_stay_from":"2021-04-28","room_stay_to":"2021-05-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,160.30,160.30,160.30","nightly_discount":"0,0,0,0","subtotal":"641.20","grand_total":"721.35","paid_amount":"721.35","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-3189146732","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":"115597","customer_id":"115597","source_of_creation":"Booking.com","reservation_created_date":"2021-03-03 15:02:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"168.70","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":"3239838","reservation_id":"113251","confirmation_number":"SJ12643975878","room_stay_from":"2021-04-30","room_stay_to":"2021-05-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"277.99,277.99","nightly_discount":"0,0","subtotal":"555.98","grand_total":"625.48","paid_amount":"625.48","room_type_id":"319","product_id":"1291","siteminder_id":"BDC-2995316034","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":"119842","customer_id":"119842","source_of_creation":"Booking.com","reservation_created_date":"2021-04-17 19:53:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"277.99","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3240094","reservation_id":"113672","confirmation_number":"SJ12687594542","room_stay_from":"2021-04-29","room_stay_to":"2021-05-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"238.95,279.45,279.45","nightly_discount":"0,0,0","subtotal":"797.85","grand_total":"897.58","paid_amount":"897.58","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3790863937","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":"120280","customer_id":"120280","source_of_creation":"Booking.com","reservation_created_date":"2021-04-23 00:21:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"157.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"279.45","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3241271","reservation_id":"107325","confirmation_number":"SJ12622239414","room_stay_from":"2021-04-28","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"181.30,181.30,209.30,209.30,209.30","nightly_discount":"0,0,0,0,0","subtotal":"990.50","grand_total":"1114.32","paid_amount":"1114.32","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-3546181952","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":"113782","customer_id":"113782","source_of_creation":"Booking.com","reservation_created_date":"2021-02-11 01:37:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"191.97","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"209.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":"3242510","reservation_id":"113609","confirmation_number":"SJ12680402588","room_stay_from":"2021-04-30","room_stay_to":"2021-05-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"258.48,258.48","nightly_discount":"0,0","subtotal":"516.96","grand_total":"581.58","paid_amount":"581.58","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-3359450220","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":"120212","customer_id":"120212","source_of_creation":"Booking.com","reservation_created_date":"2021-04-22 03:35:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"102.06","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"258.48","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":"3242643","reservation_id":"112627","confirmation_number":"SJ12637426788","room_stay_from":"2021-04-30","room_stay_to":"2021-05-01","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"279.8","nightly_discount":"0","subtotal":"279.80","grand_total":"314.78","paid_amount":"314.78","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-2929797070","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119212","customer_id":"119212","source_of_creation":"Booking.com","reservation_created_date":"2021-04-10 20:17:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"63.86","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"279.8","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3242654","reservation_id":"113955","confirmation_number":"SJ12626329168","room_stay_from":"2021-04-29","room_stay_to":"2021-05-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"187.71,236.31,236.31","nightly_discount":"0,0,0","subtotal":"660.33","grand_total":"742.87","paid_amount":"742.87","room_type_id":"319","product_id":"1309","siteminder_id":"BDC-3981938105","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":"120588","customer_id":"120588","source_of_creation":"Booking.com","reservation_created_date":"2021-04-26 22:25:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","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":"236.31","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":"3243100","reservation_id":"113103","confirmation_number":"SJ12660994420","room_stay_from":"2021-04-29","room_stay_to":"2021-05-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"287.20,343.20","nightly_discount":"0,0","subtotal":"630.40","grand_total":"709.20","paid_amount":"709.20","room_type_id":"413","product_id":"1272","siteminder_id":"BDC-2803331579","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":"119687","customer_id":"119687","source_of_creation":"Booking.com","reservation_created_date":"2021-04-16 16:13:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"122.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"343.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3243743","reservation_id":"113448","confirmation_number":"SJ12696361524","room_stay_from":"2021-04-30","room_stay_to":"2021-05-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"311.20,311.20","nightly_discount":"0,0","subtotal":"622.40","grand_total":"700.20","paid_amount":"700.20","room_type_id":"319","product_id":"1942","siteminder_id":"BDC-2834881844","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":"120040","customer_id":"120040","source_of_creation":"Booking.com","reservation_created_date":"2021-04-20 01:47:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"121.03","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"311.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3244249","reservation_id":"108549","confirmation_number":"SJ12688310666","room_stay_from":"2021-04-29","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"149.25,224.25,224.25,149.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"747.00","grand_total":"840.38","paid_amount":"840.38","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2847907604","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":"114986","customer_id":"114986","source_of_creation":"Booking.com","reservation_created_date":"2021-02-25 16:56:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"121.09","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"From date changed","deltaChange":"149.25","currentDayPrice":"224.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":"3244452","reservation_id":"111874","confirmation_number":"SJ12659478758","room_stay_from":"2021-04-30","room_stay_to":"2021-05-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"319.20,319.20","nightly_discount":"0.00,0.00","subtotal":"638.40","grand_total":"718.20","paid_amount":"718.20","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-2460565403","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":"118439","customer_id":"118439","source_of_creation":"Booking.com","reservation_created_date":"2021-04-02 02:13:29","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"319.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3216288","reservation_id":"106884","confirmation_number":"SJ12614344447","room_stay_from":"2021-04-30","room_stay_to":"2021-05-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.30,139.30,139.30,139.30,139.30,139.30","nightly_discount":"0,0,0,0,0,0","subtotal":"884.80","grand_total":"995.40","paid_amount":"995.40","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1735215122","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":"113315","customer_id":"113315","source_of_creation":"Expedia","reservation_created_date":"2021-02-04 13:20:11","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":"188.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":"3235651","reservation_id":"109640","confirmation_number":"SJ12650723099","room_stay_from":"2021-04-30","room_stay_to":"2021-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.30,279.30,160.30,160.30","nightly_discount":"0,0,0,0","subtotal":"879.20","grand_total":"989.10","paid_amount":"989.10","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1744795391","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":"116126","customer_id":"116126","source_of_creation":"Expedia","reservation_created_date":"2021-03-07 03:18:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"279.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":"3235838","reservation_id":"113149","confirmation_number":"SJ12688568656","room_stay_from":"2021-04-30","room_stay_to":"2021-05-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"291.72","nightly_discount":"0","subtotal":"291.72","grand_total":"328.19","paid_amount":"328.19","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1760466285","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":"119737","customer_id":"119737","source_of_creation":"Expedia","reservation_created_date":"2021-04-16 23:18:09","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":"291.72","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239398","reservation_id":"113604","confirmation_number":"SJ12626353161","room_stay_from":"2021-04-30","room_stay_to":"2021-05-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"311.20,311.20","nightly_discount":"0,0","subtotal":"622.40","grand_total":"700.20","paid_amount":"700.20","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1762363901","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":"120208","customer_id":"120208","source_of_creation":"Expedia","reservation_created_date":"2021-04-22 02:24:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"311.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3240208","reservation_id":"113009","confirmation_number":"SJ12633973843","room_stay_from":"2021-04-28","room_stay_to":"2021-05-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.40,215.40,257.40","nightly_discount":"0,0,0","subtotal":"688.20","grand_total":"774.23","paid_amount":"774.23","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1759669913","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":"119593","customer_id":"119593","source_of_creation":"Expedia","reservation_created_date":"2021-04-14 23:18:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"257.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3241598","reservation_id":"113829","confirmation_number":"SJ12656879909","room_stay_from":"2021-04-30","room_stay_to":"2021-05-01","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"281.52","nightly_discount":"0","subtotal":"281.52","grand_total":"316.71","paid_amount":"316.71","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1763456918","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120453","customer_id":"120453","source_of_creation":"Expedia","reservation_created_date":"2021-04-25 03:19:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"281.52","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":"3243110","reservation_id":"113627","confirmation_number":"SJ12644629111","room_stay_from":"2021-04-30","room_stay_to":"2021-05-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"311.20,311.20","nightly_discount":"0,0","subtotal":"622.40","grand_total":"700.20","paid_amount":"700.20","room_type_id":"319","product_id":"1711","siteminder_id":"EXP-1762535670","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":"120225","customer_id":"120225","source_of_creation":"Expedia","reservation_created_date":"2021-04-22 16:19:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"311.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3243528","reservation_id":"109578","confirmation_number":"SJ12675188151","room_stay_from":"2021-04-28","room_stay_to":"2021-05-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.75,171.75,276.75","nightly_discount":"0.00,0.00,0.00","subtotal":"620.25","grand_total":"697.78","paid_amount":"697.78","room_type_id":"319","product_id":"1277","siteminder_id":"EXP-1744588488","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":"116059","customer_id":"116059","source_of_creation":"Expedia","reservation_created_date":"2021-03-06 16:02:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"276.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":"3243747","reservation_id":"110309","confirmation_number":"SJ12614119107","room_stay_from":"2021-04-29","room_stay_to":"2021-05-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.20,295.20","nightly_discount":"0,0","subtotal":"510.40","grand_total":"574.20","paid_amount":"574.20","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1747630483","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":"116827","customer_id":"116827","source_of_creation":"Expedia","reservation_created_date":"2021-03-14 22:22:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"295.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3243951","reservation_id":"114047","confirmation_number":"SJ12660287395","room_stay_from":"2021-04-30","room_stay_to":"2021-05-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"330.65","nightly_discount":"0","subtotal":"330.65","grand_total":"371.98","paid_amount":"371.98","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1764575966","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":"120683","customer_id":"120683","source_of_creation":"Expedia","reservation_created_date":"2021-04-28 03:40:07","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"330.65","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":"3240480","reservation_id":"113720","confirmation_number":"SJ12621179405","room_stay_from":"2021-04-30","room_stay_to":"2021-05-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"219.60","nightly_discount":"0","subtotal":"219.60","grand_total":"247.05","paid_amount":"247.05","room_type_id":"319","product_id":"1314","siteminder_id":"HTN-159100900-XM4HC2","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":"120331","customer_id":"120331","source_of_creation":"HotelTonight","reservation_created_date":"2021-04-23 18:47:07","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"219.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3243024","reservation_id":"110161","confirmation_number":"SJ12642208559","room_stay_from":"2021-04-28","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"413.92,413.92,413.92,413.92,401.50","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"2057.18","grand_total":"2384.00","paid_amount":"2384.00","room_type_id":"320","product_id":"1329","siteminder_id":"ABB-HMJNTJK9X5","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"2069.60","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116672","customer_id":"116672","source_of_creation":"Airbnb","reservation_created_date":"2021-03-12 21:57:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"60.87","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"413.92","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3243802","reservation_id":"110228","confirmation_number":"SJ12674585099","room_stay_from":"2021-04-29","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"311.10,303.63,311.10,311.10","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1236.93","grand_total":"1433.44","paid_amount":"1433.44","room_type_id":"319","product_id":"1319","siteminder_id":"ABB-HMYF2JMZ39","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1244.40","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116745","customer_id":"116745","source_of_creation":"Airbnb","reservation_created_date":"2021-03-13 21:08:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"36.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"303.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3244195","reservation_id":"113442","confirmation_number":"SJ12621752630","room_stay_from":"2021-04-30","room_stay_to":"2021-05-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"354.86","nightly_discount":"0.00","subtotal":"354.86","grand_total":"411.23","paid_amount":"411.23","room_type_id":"412","product_id":"1316","siteminder_id":"ABB-HM5JQEQZHY","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"357.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120035","customer_id":"120035","source_of_creation":"Airbnb","reservation_created_date":"2021-04-19 23:53:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"10.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"354.86","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":"3205299","reservation_id":"108701","confirmation_number":"SJ12614232516","room_stay_from":"2021-04-29","room_stay_to":"2021-05-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.65,254.15","nightly_discount":"0.00,0.00","subtotal":"465.80","grand_total":"524.03","paid_amount":"524.03","room_type_id":"413","product_id":"1267","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115152","customer_id":"115152","source_of_creation":"FE","reservation_created_date":"2021-02-27 01:42:56","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"254.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":"3230337","reservation_id":"112402","confirmation_number":"SJ12687596241","room_stay_from":"2021-04-30","room_stay_to":"2021-05-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"313.65,313.65","nightly_discount":"0.00,0.00","subtotal":"627.30","grand_total":"705.72","paid_amount":"705.72","room_type_id":"413","product_id":"1264","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":"118974","customer_id":"118974","source_of_creation":"FE","reservation_created_date":"2021-04-07 23:26:07","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":"0","group_rooms":null,"currentDayPrice":"313.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":"3231761","reservation_id":"109595","confirmation_number":"SJ12648440635","room_stay_from":"2021-04-30","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"389.25,389.25,261.75","nightly_discount":"0.00,0.00,0.00","subtotal":"1040.25","grand_total":"1170.28","paid_amount":"1170.28","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":"116074","customer_id":"116074","source_of_creation":"FE","reservation_created_date":"2021-03-06 19:33:31","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":"389.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":"3231868","reservation_id":"111805","confirmation_number":"SJ12699072097","room_stay_from":"2021-04-30","room_stay_to":"2021-05-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"339.15,339.15","nightly_discount":"0.00,0.00","subtotal":"678.30","grand_total":"763.09","paid_amount":"763.09","room_type_id":"319","product_id":"1310","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":"118362","customer_id":"118362","source_of_creation":"FE","reservation_created_date":"2021-04-01 02:56:49","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","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":"339.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":"3244125","reservation_id":"109484","confirmation_number":"SJ12662228157","room_stay_from":"2021-04-29","room_stay_to":"2021-05-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"284.25,389.25,389.25","nightly_discount":"0.00,0.00,0.00","subtotal":"1062.75","grand_total":"1195.60","paid_amount":"1195.60","room_type_id":"320","product_id":"1328","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115948","customer_id":"115948","source_of_creation":"FE","reservation_created_date":"2021-03-05 15:19:37","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"389.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":"3221802","reservation_id":"111191","confirmation_number":"SJ12664274142","room_stay_from":"2021-04-30","room_stay_to":"2021-05-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"360.40,360.40","nightly_discount":"18.02,18.02","subtotal":"720.80","grand_total":"770.36","paid_amount":"770.36","room_type_id":"412","product_id":"1921","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":"115562","customer_id":"115562","source_of_creation":"PMS","reservation_created_date":"2021-03-24 17:30:34","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":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"360.40","currentDayDiscount":"18.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"}]},{"room_stay_id":"3235944","reservation_id":"113174","confirmation_number":"SJ12659572514","room_stay_from":"2021-04-30","room_stay_to":"2021-05-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.65","nightly_discount":"13.98","subtotal":"279.65","grand_total":"298.88","paid_amount":"298.88","room_type_id":"319","product_id":"1943","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116312","customer_id":"116312","source_of_creation":"PMS","reservation_created_date":"2021-04-17 13:36:01","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":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"279.65","currentDayDiscount":"13.98","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3244481","reservation_id":"105455","confirmation_number":"SJ12626136886","room_stay_from":"2021-04-30","room_stay_to":"2021-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"288.00,288.00,288.00,288.00","nightly_discount":"14.40,14.40,14.40,14.40","subtotal":"1152.00","grand_total":"1231.20","paid_amount":"1231.20","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":"111862","customer_id":"111862","source_of_creation":"PMS","reservation_created_date":"2021-01-16 18:35:24","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":"AAA","sub_hotel_id":"0","currentDayPrice":"288.00","currentDayDiscount":"14.40","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3244510","reservation_id":"111773","confirmation_number":"SJ12685665985","room_stay_from":"2021-04-30","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"318.00,318.00,288.00","nightly_discount":"15.90,15.90,14.40","subtotal":"924.00","grand_total":"987.53","paid_amount":"987.53","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118331","customer_id":"118331","source_of_creation":"PMS","reservation_created_date":"2021-03-31 18:38:08","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":"AAA","sub_hotel_id":"0","currentDayPrice":"318.00","currentDayDiscount":"15.90","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3244514","reservation_id":"111771","confirmation_number":"SJ12683417778","room_stay_from":"2021-04-30","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"299.25,299.25,269.25","nightly_discount":"14.96,14.96,13.46","subtotal":"867.75","grand_total":"927.42","paid_amount":"927.42","room_type_id":"413","product_id":"1262","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118328","customer_id":"118328","source_of_creation":"PMS","reservation_created_date":"2021-03-31 17:50:39","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":"AAA","sub_hotel_id":"0","currentDayPrice":"299.25","currentDayDiscount":"14.96","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3244282","reservation_id":"111177","confirmation_number":"SJ12698925046","room_stay_from":"2021-06-10","room_stay_to":"2021-06-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.00,160.00,160.00,160.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"640.00","grand_total":"720.00","paid_amount":"691.87","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120493","customer_id":"74927","source_of_creation":"PMS","reservation_created_date":"2021-03-24 15:16:22","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3185832","reservation_id":"95536","confirmation_number":"SJ12645800076","room_stay_from":"2021-04-23","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.14,87.14,87.14,87.14,87.14,87.14,87.14,86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"869.99","grand_total":"869.99","paid_amount":"281.25","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-28 14:11:36","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3196188","reservation_id":"107405","confirmation_number":"SJ12640279491","room_stay_from":"2021-04-28","room_stay_to":"2021-05-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.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","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":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-12 02:48:16","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":"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":"3207592","reservation_id":"109094","confirmation_number":"SJ12690503352","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"413","product_id":"1271","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 04:06:59","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3207599","reservation_id":"109096","confirmation_number":"SJ12681391356","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"413","product_id":"1269","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 04:08:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","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":"3207602","reservation_id":"109097","confirmation_number":"SJ12642548247","room_stay_from":"2021-04-30","room_stay_to":"2021-05-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","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":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 04:09:17","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"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":"3207604","reservation_id":"109098","confirmation_number":"SJ12656139907","room_stay_from":"2021-04-30","room_stay_to":"2021-05-07","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.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","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":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 04:10:59","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3214010","reservation_id":"110066","confirmation_number":"SJ12646741731","room_stay_from":"2021-04-30","room_stay_to":"2021-05-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.85,111.85,111.85,111.85,111.85,111.85,111.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"783.00","grand_total":"783.00","paid_amount":"0.00","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-03-11 19:14:28","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":"0","group_rooms":null,"currentDayPrice":"111.85","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3220890","reservation_id":"111054","confirmation_number":"SJ12627016081","room_stay_from":"2021-04-30","room_stay_to":"2021-05-03","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00","subtotal":"297.00","grand_total":"297.00","paid_amount":"0.00","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-03-23 02:26:40","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"99.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":"3229909","reservation_id":"95534","confirmation_number":"SJ12616649969","room_stay_from":"2021-04-23","room_stay_to":"2021-05-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14","nightly_discount":"0.00,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1219.96","grand_total":"1219.96","paid_amount":"393.75","room_type_id":"412","product_id":"1866","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-28 14:06:38","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.14","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":"3237922","reservation_id":"109093","confirmation_number":"SJ12666630946","room_stay_from":"2021-04-30","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"3","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":"1268","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 04:05:58","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3243103","reservation_id":"107777","confirmation_number":"SJ12668344605","room_stay_from":"2021-04-28","room_stay_to":"2021-05-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.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-16 10:59:04","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":"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":"3244584","reservation_id":"110477","confirmation_number":"SJ12676629178","room_stay_from":"2021-04-30","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"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":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 02:24:33","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","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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3241599","reservation_id":"113829","confirmation_number":"SJ12639925915","room_confirmation_number":"SJ12656879909","room_stay_from":"2021-04-30","room_stay_to":"2021-05-01","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"120453","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-04-25 03:19:06","reservation_modified_date_time":"2021-04-25 03:19:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120453","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3242644","reservation_id":"112627","confirmation_number":"SJ12641287889","room_confirmation_number":"SJ12637426788","room_stay_from":"2021-04-30","room_stay_to":"2021-05-01","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"119212","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-27 18:15:20","reservation_modified_date_time":"2021-04-27 18:15:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119212","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3244484","reservation_id":"105455","confirmation_number":"SJ12698393753","room_confirmation_number":"SJ12626136886","room_stay_from":"2021-04-30","room_stay_to":"2021-05-04","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"111862","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-04-30 20:34:49","reservation_modified_date_time":"2021-04-30 20:34:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111862","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":[{"room_stay_id":"3237924","reservation_id":"109093","confirmation_number":"SJ12643100050","room_confirmation_number":"SJ12666630946","room_stay_from":"2021-04-30","room_stay_to":"2021-05-03","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"75.00","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"82465","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-04-20 13:17:54","reservation_modified_date_time":"2021-04-20 13:17: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","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_taxable":[{"room_stay_id":"3196189","reservation_id":"107405","confirmation_number":"SJ12623434806","room_confirmation_number":"SJ12640279491","room_stay_from":"2021-04-28","room_stay_to":"2021-05-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":"113861","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 02:48:16","reservation_modified_date_time":"2021-02-12 02:48: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":"3205300","reservation_id":"108701","confirmation_number":"SJ12696705304","room_confirmation_number":"SJ12614232516","room_stay_from":"2021-04-29","room_stay_to":"2021-05-01","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":"115152","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 01:42:56","reservation_modified_date_time":"2021-02-27 01:42:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115152","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":"3235839","reservation_id":"113149","confirmation_number":"SJ12667460557","room_confirmation_number":"SJ12688568656","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"119737","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-16 23:18:09","reservation_modified_date_time":"2021-04-16 23:18:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119737","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":"3235945","reservation_id":"113174","confirmation_number":"SJ12651973956","room_confirmation_number":"SJ12659572514","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"116312","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 13:36:01","reservation_modified_date_time":"2021-04-17 13:36:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116312","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":"3240209","reservation_id":"113009","confirmation_number":"SJ12627164402","room_confirmation_number":"SJ12633973843","room_stay_from":"2021-04-28","room_stay_to":"2021-05-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":"119593","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-14 23:18:09","reservation_modified_date_time":"2021-04-23 13:12:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119593","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":"3240481","reservation_id":"113720","confirmation_number":"SJ12675477228","room_confirmation_number":"SJ12621179405","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"120331","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-23 18:47:07","reservation_modified_date_time":"2021-04-23 18:47:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120331","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":"3241600","reservation_id":"113829","confirmation_number":"SJ12651216843","room_confirmation_number":"SJ12656879909","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"120453","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-25 03:19:06","reservation_modified_date_time":"2021-04-25 03:19:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120453","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3242645","reservation_id":"112627","confirmation_number":"SJ12625151578","room_confirmation_number":"SJ12637426788","room_stay_from":"2021-04-30","room_stay_to":"2021-05-01","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"119212","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 20:17:11","reservation_modified_date_time":"2021-04-27 18:15:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119212","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3243102","reservation_id":"113103","confirmation_number":"SJ12636925024","room_confirmation_number":"SJ12660994420","room_stay_from":"2021-04-29","room_stay_to":"2021-05-01","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":"119687","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-16 16:13:08","reservation_modified_date_time":"2021-04-28 16:09:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119687","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":"3243105","reservation_id":"107777","confirmation_number":"SJ12623686254","room_confirmation_number":"SJ12668344605","room_stay_from":"2021-04-28","room_stay_to":"2021-05-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":"120723","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-16 10:59:04","reservation_modified_date_time":"2021-04-28 16:09:36","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":"3243529","reservation_id":"109578","confirmation_number":"SJ12692646066","room_confirmation_number":"SJ12675188151","room_stay_from":"2021-04-28","room_stay_to":"2021-05-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":"116059","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-06 16:02:22","reservation_modified_date_time":"2021-04-28 22:58:01","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116059","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":"3243748","reservation_id":"110309","confirmation_number":"SJ12670994424","room_confirmation_number":"SJ12614119107","room_stay_from":"2021-04-29","room_stay_to":"2021-05-01","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":"116827","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-14 22:22:24","reservation_modified_date_time":"2021-04-29 16:04:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116827","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":"3243952","reservation_id":"114047","confirmation_number":"SJ12689836619","room_confirmation_number":"SJ12660287395","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"120683","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-28 03:40:07","reservation_modified_date_time":"2021-04-29 21:40:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120683","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":"3244196","reservation_id":"113442","confirmation_number":"SJ12695552399","room_confirmation_number":"SJ12621752630","room_stay_from":"2021-04-30","room_stay_to":"2021-05-01","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120035","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-19 23:53:07","reservation_modified_date_time":"2021-04-30 13:30:59","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120035","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":"3205911","reservation_id":"108800","confirmation_number":"SJ12645984174","room_confirmation_number":"SJ12650951171","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"115259","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-28 01:55:11","reservation_modified_date_time":"2021-02-28 01:55:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115259","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":"3221803","reservation_id":"111191","confirmation_number":"SJ12675091073","room_confirmation_number":"SJ12664274142","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"115562","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 17:30:34","reservation_modified_date_time":"2021-03-24 17:30:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115562","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":"3230338","reservation_id":"112402","confirmation_number":"SJ12669964065","room_confirmation_number":"SJ12687596241","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"118974","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 23:26:07","reservation_modified_date_time":"2021-04-07 23:26:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118974","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":"3231870","reservation_id":"111805","confirmation_number":"SJ12637036712","room_confirmation_number":"SJ12699072097","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"118362","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-01 02:56:49","reservation_modified_date_time":"2021-04-10 15:29:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118362","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":"3231993","reservation_id":"109124","confirmation_number":"SJ12699191686","room_confirmation_number":"SJ12616237128","room_stay_from":"2021-04-28","room_stay_to":"2021-05-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":"115597","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 15:02:10","reservation_modified_date_time":"2021-04-10 17:40:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115597","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":"3239399","reservation_id":"113604","confirmation_number":"SJ12676002392","room_confirmation_number":"SJ12626353161","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"120208","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-22 02:24:10","reservation_modified_date_time":"2021-04-22 02:24:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120208","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":"3239839","reservation_id":"113251","confirmation_number":"SJ12650991594","room_confirmation_number":"SJ12643975878","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"119842","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 19:53:19","reservation_modified_date_time":"2021-04-22 18:22:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119842","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":"3240095","reservation_id":"113672","confirmation_number":"SJ12697434314","room_confirmation_number":"SJ12687594542","room_stay_from":"2021-04-29","room_stay_to":"2021-05-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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"120280","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-23 00:21:09","reservation_modified_date_time":"2021-04-23 00:21:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120280","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":"3242511","reservation_id":"113609","confirmation_number":"SJ12684840590","room_confirmation_number":"SJ12680402588","room_stay_from":"2021-04-30","room_stay_to":"2021-05-02","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"120212","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-22 03:35:12","reservation_modified_date_time":"2021-04-27 14:05:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120212","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":"3242653","reservation_id":"113955","confirmation_number":"SJ12655118051","room_confirmation_number":"SJ12626329168","room_stay_from":"2021-04-29","room_stay_to":"2021-05-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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"120588","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-26 22:25:27","reservation_modified_date_time":"2021-04-27 18:16:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120588","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":"3243111","reservation_id":"113627","confirmation_number":"SJ12620558536","room_confirmation_number":"SJ12644629111","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"120225","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-22 16:19:10","reservation_modified_date_time":"2021-04-28 16:10:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120225","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":"3243744","reservation_id":"113448","confirmation_number":"SJ12685098789","room_confirmation_number":"SJ12696361524","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"120040","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-20 01:47:08","reservation_modified_date_time":"2021-04-29 16:03:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120040","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":"3244128","reservation_id":"109484","confirmation_number":"SJ12635626969","room_confirmation_number":"SJ12662228157","room_stay_from":"2021-04-29","room_stay_to":"2021-05-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":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"115950","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-05 15:19:37","reservation_modified_date_time":"2021-04-30 05:29:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115948","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":"3244453","reservation_id":"111874","confirmation_number":"SJ12627060299","room_confirmation_number":"SJ12659478758","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"118439","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-02 02:13:29","reservation_modified_date_time":"2021-04-30 19:30:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118439","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":"3185833","reservation_id":"95536","confirmation_number":"SJ12671781895","room_confirmation_number":"SJ12645800076","room_stay_from":"2021-04-23","room_stay_to":"2021-05-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101721","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 14:11:36","reservation_modified_date_time":"2021-01-27 21:49:53","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":"3203104","reservation_id":"108281","confirmation_number":"SJ12626701386","room_confirmation_number":"SJ12636974410","room_stay_from":"2021-04-28","room_stay_to":"2021-05-03","room_stay_status":"Active","nightly_price":"25,25,25,25,25","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":"114740","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 17:23:07","reservation_modified_date_time":"2021-02-23 00:03:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114740","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":"3206544","reservation_id":"108625","confirmation_number":"SJ12655239094","room_confirmation_number":"SJ12656346023","room_stay_from":"2021-04-26","room_stay_to":"2021-05-03","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":"115064","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 04:07:10","reservation_modified_date_time":"2021-03-01 01:53:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115064","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":"3207593","reservation_id":"109094","confirmation_number":"SJ12625006540","room_confirmation_number":"SJ12690503352","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"115569","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 04:06:59","reservation_modified_date_time":"2021-03-03 04:06:59","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":"3207600","reservation_id":"109096","confirmation_number":"SJ12685390345","room_confirmation_number":"SJ12681391356","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"115570","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 04:08:12","reservation_modified_date_time":"2021-03-03 04:08:12","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":"3220891","reservation_id":"111054","confirmation_number":"SJ12650962907","room_confirmation_number":"SJ12627016081","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"117595","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-23 02:26:40","reservation_modified_date_time":"2021-03-23 02:26:40","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3231764","reservation_id":"109595","confirmation_number":"SJ12676931228","room_confirmation_number":"SJ12648440635","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"116074","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-06 19:33:31","reservation_modified_date_time":"2021-04-10 14:01:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116074","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":"3237925","reservation_id":"109093","confirmation_number":"SJ12687596046","room_confirmation_number":"SJ12666630946","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"115568","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 04:05:58","reservation_modified_date_time":"2021-04-20 13:17: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":"3241272","reservation_id":"107325","confirmation_number":"SJ12665517166","room_confirmation_number":"SJ12622239414","room_stay_from":"2021-04-28","room_stay_to":"2021-05-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":"113782","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-11 01:37:11","reservation_modified_date_time":"2021-04-24 19:29:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113782","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":"3243027","reservation_id":"110161","confirmation_number":"SJ12686759595","room_confirmation_number":"SJ12642208559","room_stay_from":"2021-04-28","room_stay_to":"2021-05-03","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116672","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-12 21:57:08","reservation_modified_date_time":"2021-04-28 14:09:03","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116672","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":"3243803","reservation_id":"110228","confirmation_number":"SJ12672929794","room_confirmation_number":"SJ12674585099","room_stay_from":"2021-04-29","room_stay_to":"2021-05-03","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116745","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-13 21:08:10","reservation_modified_date_time":"2021-04-29 18:38:07","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116745","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":"3244250","reservation_id":"108549","confirmation_number":"SJ12693345963","room_confirmation_number":"SJ12688310666","room_stay_from":"2021-04-29","room_stay_to":"2021-05-03","room_stay_status":"Active","nightly_price":"25.00,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"114986","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-25 16:56:09","reservation_modified_date_time":"2021-04-30 15:02:41","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114986","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"From date changed","deltaChange":"25.00","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":"3244511","reservation_id":"111773","confirmation_number":"SJ12646910687","room_confirmation_number":"SJ12685665985","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"118331","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-31 18:38:08","reservation_modified_date_time":"2021-04-30 21:08:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118331","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":"3244515","reservation_id":"111771","confirmation_number":"SJ12673389300","room_confirmation_number":"SJ12683417778","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"118328","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-31 17:50:39","reservation_modified_date_time":"2021-04-30 21:14:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118328","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":"3244585","reservation_id":"110477","confirmation_number":"SJ12625572153","room_confirmation_number":"SJ12676629178","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"116990","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 02:24:33","reservation_modified_date_time":"2021-04-30 23:15: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":"3235652","reservation_id":"109640","confirmation_number":"SJ12679776776","room_confirmation_number":"SJ12650723099","room_stay_from":"2021-04-30","room_stay_to":"2021-05-04","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":"116126","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-07 03:18:13","reservation_modified_date_time":"2021-04-16 21:34:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116126","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":"3244485","reservation_id":"105455","confirmation_number":"SJ12686227287","room_confirmation_number":"SJ12626136886","room_stay_from":"2021-04-30","room_stay_to":"2021-05-04","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":"111862","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 18:35:24","reservation_modified_date_time":"2021-04-30 20:34:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111862","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":"3207603","reservation_id":"109097","confirmation_number":"SJ12626147228","room_confirmation_number":"SJ12642548247","room_stay_from":"2021-04-30","room_stay_to":"2021-05-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115571","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 04:09:17","reservation_modified_date_time":"2021-03-03 04:09: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":"3216289","reservation_id":"106884","confirmation_number":"SJ12688760424","room_confirmation_number":"SJ12614344447","room_stay_from":"2021-04-30","room_stay_to":"2021-05-06","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":"113315","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-04 13:20:11","reservation_modified_date_time":"2021-03-16 02:01:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113315","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":"3225825","reservation_id":"111801","confirmation_number":"SJ12614101482","room_confirmation_number":"SJ12647895967","room_stay_from":"2021-04-29","room_stay_to":"2021-05-06","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":"118358","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-01 01:00:18","reservation_modified_date_time":"2021-04-01 12:33:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118358","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":"3207605","reservation_id":"109098","confirmation_number":"SJ12668072513","room_confirmation_number":"SJ12656139907","room_stay_from":"2021-04-30","room_stay_to":"2021-05-07","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":"115572","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 04:10:59","reservation_modified_date_time":"2021-03-03 04:10:59","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":"3214011","reservation_id":"110066","confirmation_number":"SJ12642923280","room_confirmation_number":"SJ12646741731","room_stay_from":"2021-04-30","room_stay_to":"2021-05-07","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116569","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-11 19:14:28","reservation_modified_date_time":"2021-03-11 19:14:28","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3229910","reservation_id":"95534","confirmation_number":"SJ12670678562","room_confirmation_number":"SJ12616649969","room_stay_from":"2021-04-23","room_stay_to":"2021-05-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"350.00","grand_total":"393.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111672","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 14:06:38","reservation_modified_date_time":"2021-04-07 18:29: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":"3215146","reservation_id":"110225","confirmation_number":"SJ12695699378","room_confirmation_number":"SJ12641959346","room_stay_from":"2021-04-30","room_stay_to":"2021-05-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"116739","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-13 20:21:07","reservation_modified_date_time":"2021-03-13 20:21:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116739","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":"3244283","reservation_id":"111177","confirmation_number":"SJ12661216666","room_confirmation_number":"SJ12698925046","room_stay_from":"2021-06-10","room_stay_to":"2021-06-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"10.00,10.00,10.00,10.00","subtotal":"100.00","grand_total":"67.50","paid_amount":"95.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"120493","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 15:16:22","reservation_modified_date_time":"2021-04-30 15:43:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74927","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3244435","reservation_id":"112764","confirmation_number":"SJ12669045477","room_confirmation_number":"SJ12636725808","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.86","grand_total":"2.00","paid_amount":"2.00","product_id":"1660","service_quantity":"1","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-12 16:21:50","reservation_modified_date_time":"2021-04-30 18:47:12","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","changedComment":"price, discount or quantity changed","deltaChange":"-0.47","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3244447","reservation_id":"114223","confirmation_number":"SJ12686364073","room_confirmation_number":"SJ12643018225","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-30 19:03:05","reservation_modified_date_time":"2021-04-30 19:03:05","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3244492","reservation_id":"113911","confirmation_number":"SJ12667365924","room_confirmation_number":"SJ12614417374","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"27.91","grand_total":"30.00","paid_amount":"30.00","product_id":"1664","service_quantity":"1","product_name":"Beach Buggy package","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-26 15:12:44","reservation_modified_date_time":"2021-04-30 20:39:21","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","changedComment":"price, discount or quantity changed","deltaChange":"-2.08","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3244566","reservation_id":"114235","confirmation_number":"SJ12643746602","room_confirmation_number":"SJ12620672393","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"15.00","paid_amount":"15.00","product_id":"1654","service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-30 22:50:29","reservation_modified_date_time":"2021-04-30 22:50:29","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"13.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3241662","reservation_id":"113839","confirmation_number":"SJ12638959370","room_confirmation_number":"SJ12614430471","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"10.00","paid_amount":"0.00","product_id":"1657","service_quantity":"1","product_name":"Visor","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-25 14:30:22","reservation_modified_date_time":"2021-04-25 14:30:22","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-04-30 20:49:36","canceled_nights_data":"","product_attribute_values":null,"sub_hotel_id":"0","deltaChange":-9.3,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3241663","reservation_id":"113839","confirmation_number":"SJ12631279106","room_confirmation_number":"SJ12614430471","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"29.99","grand_total":"32.24","paid_amount":"0.00","product_id":"1664","service_quantity":"1","product_name":"Beach Buggy package","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-25 14:30:22","reservation_modified_date_time":"2021-04-25 14:30:22","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-04-30 20:49:33","canceled_nights_data":"","product_attribute_values":null,"sub_hotel_id":"0","deltaChange":-29.99,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3241667","reservation_id":"113840","confirmation_number":"SJ12645075627","room_confirmation_number":"SJ12652236210","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"10.00","paid_amount":"0.00","product_id":"1657","service_quantity":"1","product_name":"Visor","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-25 14:33:24","reservation_modified_date_time":"2021-04-25 14:33:24","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-04-30 20:49:45","canceled_nights_data":"","product_attribute_values":null,"sub_hotel_id":"0","deltaChange":-9.3,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3241036","reservation_id":"113785","confirmation_number":"SJ12630831062","room_confirmation_number":"SJ12631667033","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"15.00","grand_total":"30.00","paid_amount":"0.00","product_id":"1231","service_quantity":"2","product_name":"Shirt","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-24 17:24:28","reservation_modified_date_time":"2021-04-24 17:24:28","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-04-30 20:30:10","canceled_nights_data":"","product_attribute_values":null,"sub_hotel_id":"0","deltaChange":-30,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}