{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-05-08","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":17,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1318","block_room_bookings":[{"confirmation_number":"SJ12628550801","room_stay_from":"2021-05-08","room_stay_to":"2021-05-09","bundle_room":"0","product_id":"1318"}],"bundle_block_count":"1262,1263,1304,1305,1267,1268,1269,1270,1271,1272,1260,1261,1302,1303,1311,1312,1307,1308,1291,1711,1309,1310","bundle_block_bookings":[{"confirmation_number":"SJB12680511107","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12696595776","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12655354515","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12649960024","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12638186137","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12612603453","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12628250153","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12667406109","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12633084657","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12674157460","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12629818712","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12649939778","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12678695974","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12657595815","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12688959357","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12624212039","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12660100258","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12689853253","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12653204889","room_stay_from":"2021-05-08","room_stay_to":"2021-05-14","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12651992909","room_stay_from":"2021-05-08","room_stay_to":"2021-05-14","bundle_room":"0","product_id":"1310"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3229907","reservation_id":"111227","confirmation_number":"SJ12676864445","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.64,218.09,218.09","nightly_discount":"0,0,0","subtotal":"617.82","grand_total":"695.05","paid_amount":"695.05","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-3770510188","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":"117758","customer_id":"117758","source_of_creation":"Booking.com","reservation_created_date":"2021-03-25 00:45:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"124.71","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"218.09","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":"3239168","reservation_id":"113571","confirmation_number":"SJ12641128868","room_stay_from":"2021-05-08","room_stay_to":"2021-05-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"328.19","nightly_discount":"0","subtotal":"328.19","grand_total":"369.21","paid_amount":"369.21","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-2248009554","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":"120172","customer_id":"120172","source_of_creation":"Booking.com","reservation_created_date":"2021-04-21 21:08:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"63.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"328.19","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":"3243959","reservation_id":"112110","confirmation_number":"SJ12629852659","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"208.28,232.58,232.58","nightly_discount":"0.00,0.00,0.00","subtotal":"673.44","grand_total":"757.62","paid_amount":"757.62","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2918442168","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":"118678","customer_id":"118678","source_of_creation":"Booking.com","reservation_created_date":"2021-04-04 19:47:26","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"232.58","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3246893","reservation_id":"114539","confirmation_number":"SJ12659485266","room_stay_from":"2021-05-08","room_stay_to":"2021-05-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"324.36","nightly_discount":"0","subtotal":"324.36","grand_total":"364.91","paid_amount":"364.91","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-3741311124","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":"121233","customer_id":"121233","source_of_creation":"Booking.com","reservation_created_date":"2021-05-04 23:39:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"62.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"324.36","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":"3186655","reservation_id":"106369","confirmation_number":"SJ12638304106","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"5","nightly_price":"315.29,315.29,290.99","nightly_discount":"0,0,0","subtotal":"921.57","grand_total":"1036.77","paid_amount":"1036.77","room_type_id":"320","product_id":"1322","siteminder_id":"BDC-3542327806","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":"112766","customer_id":"112766","source_of_creation":"Booking.com","reservation_created_date":"2021-01-29 00:30:28","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"488.94","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1267,1268","currentDayPrice":"315.29","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":"3186710","reservation_id":"106369","confirmation_number":"SJ12623093770","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"234.92,234.92,210.62","nightly_discount":"0,0,0","subtotal":"680.46","grand_total":"765.51","paid_amount":"765.51","room_type_id":"320","product_id":"1323","siteminder_id":"BDC-3542327806","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112766","customer_id":"112766","source_of_creation":"Booking.com","reservation_created_date":"2021-01-29 00:30:20","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"488.94","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1269,1270","currentDayPrice":"234.92","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3186715","reservation_id":"106369","confirmation_number":"SJ12658997057","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"254.54,254.54,230.24","nightly_discount":"0,0,0","subtotal":"739.32","grand_total":"831.74","paid_amount":"831.74","room_type_id":"320","product_id":"1324","siteminder_id":"BDC-3542327806","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":"112766","customer_id":"112766","source_of_creation":"Booking.com","reservation_created_date":"2021-01-29 00:30:12","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"488.94","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1271,1272","currentDayPrice":"254.54","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":"207.27","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3220872","reservation_id":"111050","confirmation_number":"SJ12634835401","room_stay_from":"2021-05-03","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,209.30,209.30,209.30,251.30,251.30,209.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1549.10","grand_total":"1742.74","paid_amount":"1742.74","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3995442698","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":"117592","customer_id":"117592","source_of_creation":"Booking.com","reservation_created_date":"2021-03-23 01:57:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"310.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"251.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":"3229946","reservation_id":"108244","confirmation_number":"SJ12646989304","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"177.80,226.80,226.80,198.80","nightly_discount":"0,0,0,0","subtotal":"830.20","grand_total":"933.98","paid_amount":"933.98","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2657268158","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":"114713","customer_id":"114713","source_of_creation":"Booking.com","reservation_created_date":"2021-02-22 03:54:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"167.44","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"226.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3237992","reservation_id":"113469","confirmation_number":"SJ12621219875","room_stay_from":"2021-05-08","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"308.88,215.28","nightly_discount":"0,0","subtotal":"524.16","grand_total":"589.68","paid_amount":"589.68","room_type_id":"319","product_id":"1943","siteminder_id":"BDC-3837803565","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":"120063","customer_id":"120063","source_of_creation":"Booking.com","reservation_created_date":"2021-04-20 15:50:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"103.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"308.88","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":"3237345","reservation_id":"113094","confirmation_number":"SJ12658487927","room_stay_from":"2021-05-08","room_stay_to":"2021-05-12","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"315.50,218.00,218.00,218.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"969.50","grand_total":"1090.69","paid_amount":"1090.69","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-2651493356","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":"119677","customer_id":"119677","source_of_creation":"Booking.com","reservation_created_date":"2021-04-16 15:08:37","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":"315.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":"3248441","reservation_id":"110398","confirmation_number":"SJ12653392901","room_stay_from":"2021-05-08","room_stay_to":"2021-05-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,160.30,139.30,139.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"648.20","grand_total":"729.23","paid_amount":"729.23","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-3427364607","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":"116913","customer_id":"116913","source_of_creation":"Booking.com","reservation_created_date":"2021-03-16 00:29:18","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"209.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3237333","reservation_id":"113011","confirmation_number":"SJ12671187460","room_stay_from":"2021-05-08","room_stay_to":"2021-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"260.61,181.64,181.64,181.64,199.86","nightly_discount":"0,0,0,0,0","subtotal":"1005.39","grand_total":"1131.06","paid_amount":"1131.06","room_type_id":"319","product_id":"1942","siteminder_id":"BDC-3999431651","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":"119596","customer_id":"119596","source_of_creation":"Booking.com","reservation_created_date":"2021-04-15 00:39:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"203.45","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"260.61","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":"3229944","reservation_id":"107893","confirmation_number":"SJ12666604318","room_stay_from":"2021-05-07","room_stay_to":"2021-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,209.30,181.30,160.30,160.30,160.30,160.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1241.10","grand_total":"1396.24","paid_amount":"1396.24","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3924566244","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":"114354","customer_id":"114354","source_of_creation":"Booking.com","reservation_created_date":"2021-02-17 17:34:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"254.90","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":"3248349","reservation_id":"111272","confirmation_number":"SJ12657820967","room_stay_from":"2021-05-05","room_stay_to":"2021-05-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"219.3,219.3,261.3","nightly_discount":"0,0,0","subtotal":"699.90","grand_total":"787.39","paid_amount":"787.39","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-3475097379","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117805","customer_id":"117805","source_of_creation":"Booking.com","reservation_created_date":"2021-03-25 18:25:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"300.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3206549","reservation_id":"108895","confirmation_number":"SJ12631930281","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.40,212.40,212.40","nightly_discount":"0,0,0","subtotal":"577.20","grand_total":"649.35","paid_amount":"649.35","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1742639859","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":"115362","customer_id":"115362","source_of_creation":"Expedia","reservation_created_date":"2021-03-01 02:17:06","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"212.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":"3214852","reservation_id":"110189","confirmation_number":"SJ12688858476","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"242.40,284.40,284.40","nightly_discount":"0,0,0","subtotal":"811.20","grand_total":"912.60","paid_amount":"912.60","room_type_id":"320","product_id":"1329","siteminder_id":"EXP-1747108737","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":"116707","customer_id":"116707","source_of_creation":"Expedia","reservation_created_date":"2021-03-13 13:12:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"284.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":"3227708","reservation_id":"112059","confirmation_number":"SJ12698885499","room_stay_from":"2021-05-05","room_stay_to":"2021-05-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"194.40,230.40,254.40,254.40","nightly_discount":"0,0,0,0","subtotal":"933.60","grand_total":"1050.30","paid_amount":"1050.30","room_type_id":"318","product_id":"1282","siteminder_id":"EXP-1755605217","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":"118626","customer_id":"118626","source_of_creation":"Expedia","reservation_created_date":"2021-04-04 02:57:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"254.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":"3228350","reservation_id":"109201","confirmation_number":"SJ12616157182","room_stay_from":"2021-05-07","room_stay_to":"2021-05-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.20,179.20","nightly_discount":"0,0","subtotal":"358.40","grand_total":"403.20","paid_amount":"403.20","room_type_id":"319","product_id":"1301","siteminder_id":"EXP-1743603215","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":"115673","customer_id":"115673","source_of_creation":"Expedia","reservation_created_date":"2021-03-03 21:22:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"179.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":"3235703","reservation_id":"112563","confirmation_number":"SJ12697157851","room_stay_from":"2021-05-07","room_stay_to":"2021-05-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.36,255.36","nightly_discount":"0,0","subtotal":"510.72","grand_total":"574.56","paid_amount":"574.56","room_type_id":"319","product_id":"1313","siteminder_id":"EXP-1757822639","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":"119142","customer_id":"119142","source_of_creation":"Expedia","reservation_created_date":"2021-04-09 23:44:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"255.36","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":"3235712","reservation_id":"112677","confirmation_number":"SJ12640205818","room_stay_from":"2021-05-03","room_stay_to":"2021-05-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75,321.75,321.75,321.75","nightly_discount":"0,0,0,0,0,0","subtotal":"1705.50","grand_total":"1918.69","paid_amount":"1918.69","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1758351567","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":"120489","customer_id":"119266","source_of_creation":"Expedia","reservation_created_date":"2021-04-11 15:44:42","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":"126","group_rooms":null,"currentDayPrice":"321.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219447","reservation_id":"110766","confirmation_number":"SJ12611936199","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"359.25,314.25,284.25","nightly_discount":"0,0,0","subtotal":"957.75","grand_total":"1077.47","paid_amount":"1077.47","room_type_id":"320","product_id":"1714","siteminder_id":"EXP-1749714019","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":"121521","customer_id":"117278","source_of_creation":"Expedia","reservation_created_date":"2021-03-19 21:47:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1291,1711","currentDayPrice":"359.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3227777","reservation_id":"112071","confirmation_number":"SJ12661848392","room_stay_from":"2021-05-06","room_stay_to":"2021-05-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.25,299.25,299.25,224.25,224.25","nightly_discount":"0,0,0,0,0","subtotal":"1316.25","grand_total":"1480.78","paid_amount":"1480.78","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1755694807","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":"118638","customer_id":"118638","source_of_creation":"Expedia","reservation_created_date":"2021-04-04 14:42: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":"126","group_rooms":null,"currentDayPrice":"299.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3230435","reservation_id":"112423","confirmation_number":"SJ12654482186","room_stay_from":"2021-05-07","room_stay_to":"2021-05-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"284.40,284.40,224.40,224.40","nightly_discount":"0,0,0,0","subtotal":"1017.60","grand_total":"1144.80","paid_amount":"1144.80","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1757113043","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":"118996","customer_id":"118996","source_of_creation":"Expedia","reservation_created_date":"2021-04-08 04:22:12","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"284.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":"3219066","reservation_id":"110758","confirmation_number":"SJ12673721071","room_stay_from":"2021-05-08","room_stay_to":"2021-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.04,181.44,159.04,159.04,181.44,181.44","nightly_discount":"0,0,0,0,0,0","subtotal":"1077.44","grand_total":"1212.12","paid_amount":"1212.12","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1749702460","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":"117271","customer_id":"117271","source_of_creation":"Expedia","reservation_created_date":"2021-03-19 21:17:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"215.04","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3228336","reservation_id":"107196","confirmation_number":"SJ12665831114","room_stay_from":"2021-05-08","room_stay_to":"2021-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.30,160.30,139.30,139.30,139.30,139.30,188.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1094.10","grand_total":"1230.87","paid_amount":"1230.87","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1736436642","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":"113657","customer_id":"113657","source_of_creation":"Expedia","reservation_created_date":"2021-02-09 01:15:07","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":"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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3247834","reservation_id":"111337","confirmation_number":"SJ12672847440","room_stay_from":"2021-05-07","room_stay_to":"2021-05-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"325.51,329.46","nightly_discount":"0.00,0.00","subtotal":"654.97","grand_total":"759.02","paid_amount":"759.02","room_type_id":"319","product_id":"1756","siteminder_id":"ABB-HM92YW2SXW","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"658.92","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117869","customer_id":"117869","source_of_creation":"Airbnb","reservation_created_date":"2021-03-26 14:15:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"19.38","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"329.46","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":"3248283","reservation_id":"111964","confirmation_number":"SJ12674719329","room_stay_from":"2021-05-08","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"316.44,320.28","nightly_discount":"0.00,0.00","subtotal":"636.72","grand_total":"737.87","paid_amount":"737.87","room_type_id":"319","product_id":"1288","siteminder_id":"ABB-HMW8TNR22J","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"640.56","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118526","customer_id":"118526","source_of_creation":"Airbnb","reservation_created_date":"2021-04-03 03:34:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"18.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"316.44","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":"3248336","reservation_id":"111970","confirmation_number":"SJ12689687091","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.58,304.98,304.98","nightly_discount":"0.00,0.00,0.00","subtotal":"909.54","grand_total":"1054.03","paid_amount":"1054.03","room_type_id":"319","product_id":"1293","siteminder_id":"ABB-HMY8W45ZXZ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"914.94","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118532","customer_id":"118532","source_of_creation":"Airbnb","reservation_created_date":"2021-04-03 05:21:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"26.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"299.58","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3206470","reservation_id":"108881","confirmation_number":"SJ12692197742","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.25,224.25,224.25,171.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"769.50","grand_total":"865.69","paid_amount":"865.69","room_type_id":"413","product_id":"1263","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":"115345","customer_id":"115345","source_of_creation":"FE","reservation_created_date":"2021-03-01 00:18:46","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3207410","reservation_id":"109032","confirmation_number":"SJ12661565286","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"336.75,336.75,284.25","nightly_discount":"0.00,0.00,0.00","subtotal":"957.75","grand_total":"1077.47","paid_amount":"1077.47","room_type_id":"320","product_id":"1328","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115491","customer_id":"115491","source_of_creation":"FE","reservation_created_date":"2021-03-02 17:32:25","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1302,1303","currentDayPrice":"336.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":"3226974","reservation_id":"111980","confirmation_number":"SJ12611022747","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,299.25,224.25","nightly_discount":"0.00,0.00,0.00","subtotal":"822.75","grand_total":"925.60","paid_amount":"925.60","room_type_id":"318","product_id":"1281","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118545","customer_id":"118545","source_of_creation":"FE","reservation_created_date":"2021-04-03 14:49:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"299.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":"3216731","reservation_id":"109581","confirmation_number":"SJ12638613154","room_stay_from":"2021-05-08","room_stay_to":"2021-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"259.47,259.47,259.47,259.47,259.47,259.47","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1556.82","grand_total":"1751.42","paid_amount":"1751.42","room_type_id":"320","product_id":"1910","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116060","customer_id":"116060","source_of_creation":"FE","reservation_created_date":"2021-03-06 17:01:47","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1309,1310","currentDayPrice":"259.47","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3248277","reservation_id":"109732","confirmation_number":"SJ12686380705","room_stay_from":"2021-06-19","room_stay_to":"2021-06-23","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.75,149.25,149.25,149.25","nightly_discount":"0.00,0.00,0.00,0","subtotal":"649.50","grand_total":"730.69","paid_amount":"226.97","room_type_id":"319","product_id":"1942","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":"116200","customer_id":"116200","source_of_creation":"FE","reservation_created_date":"2021-03-08 01:18:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3218375","reservation_id":"110616","confirmation_number":"SJ12673310378","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"322.15,381.65,381.65,322.15","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1407.60","grand_total":"1583.55","paid_amount":"1583.55","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":"117129","customer_id":"117129","source_of_creation":"PMS","reservation_created_date":"2021-03-18 14:13:45","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":"381.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219678","reservation_id":"110835","confirmation_number":"SJ12666218882","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"314.25,359.25,359.25,314.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1347.00","grand_total":"1515.38","paid_amount":"1515.38","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":"117359","customer_id":"117359","source_of_creation":"PMS","reservation_created_date":"2021-03-20 21:12:15","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1307,1308","currentDayPrice":"359.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":"3221948","reservation_id":"111216","confirmation_number":"SJ12612511583","room_stay_from":"2021-05-08","room_stay_to":"2021-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00","nightly_discount":"20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40,20.40","subtotal":"2652.00","grand_total":"2685.15","paid_amount":"2685.15","room_type_id":"319","product_id":"1314","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102743","customer_id":"102743","source_of_creation":"PMS","reservation_created_date":"2021-03-24 23:11:28","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":"special123","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"204.00","currentDayDiscount":"20.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":"3248372","reservation_id":"111109","confirmation_number":"SJ12686507073","room_stay_from":"2021-06-08","room_stay_to":"2021-06-18","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00","nightly_discount":"0.00,0,0,0,0,0,0,0,0,0","subtotal":"1500.00","grand_total":"1687.50","paid_amount":"168.75","room_type_id":"413","product_id":"1268","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-23 20:02:09","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3204822","reservation_id":"108597","confirmation_number":"SJ12664186188","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","room_stay_status":"Active","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":"0.00","room_type_id":"413","product_id":"1262","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-26 01:42:18","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3207619","reservation_id":"109103","confirmation_number":"SJ12644046341","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","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":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-03 07:22:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3211151","reservation_id":"109515","confirmation_number":"SJ12660271212","room_stay_from":"2021-05-02","room_stay_to":"2021-05-09","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,110.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"782.00","grand_total":"782.00","paid_amount":"0.00","room_type_id":"319","product_id":"1915","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-05 19:15:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"110.90","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":"3217053","reservation_id":"110480","confirmation_number":"SJ12694076312","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","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":"1266","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:28:43","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"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":"3217055","reservation_id":"110481","confirmation_number":"SJ12642607741","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","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":"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":"2021-03-17 02:30:11","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":"3229766","reservation_id":"110985","confirmation_number":"SJ12675122375","room_stay_from":"2021-05-04","room_stay_to":"2021-05-09","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,0,0,0","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"412","product_id":"1297","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-22 18:20:33","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","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204825","reservation_id":"108598","confirmation_number":"SJ12666931534","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-26 01:46:19","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3217062","reservation_id":"110484","confirmation_number":"SJ12657273553","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"1916","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:40:27","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":"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":"3229905","reservation_id":"110482","confirmation_number":"SJ12638617405","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 02:31:43","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3229069","reservation_id":"109894","confirmation_number":"SJ12647133042","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","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-03-10 00:15:32","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":"3227768","reservation_id":"108702","confirmation_number":"SJ12674341216","room_stay_from":"2021-05-08","room_stay_to":"2021-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.85,108.85,108.85,108.85,108.85,108.85,108.85","nightly_discount":"0.00,0,0,0,0,0,0","subtotal":"761.95","grand_total":"761.95","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-02-27 01:46:00","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":"108.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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3243960","reservation_id":"112110","confirmation_number":"SJ12624293511","room_confirmation_number":"SJ12629852659","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"118678","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-29 21:51:04","reservation_modified_date_time":"2021-04-29 21:51:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118678","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3186713","reservation_id":"106369","confirmation_number":"SJ12665853162","room_confirmation_number":"SJ12623093770","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"112766","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-01-29 02:23:56","reservation_modified_date_time":"2021-01-29 02:23:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112766","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.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":"3237339","reservation_id":"113094","confirmation_number":"SJ12647039808","room_confirmation_number":"SJ12658487927","room_stay_from":"2021-05-08","room_stay_to":"2021-05-12","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"119677","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-19 14:58:02","reservation_modified_date_time":"2021-04-19 14:58:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119677","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3248350","reservation_id":"111272","confirmation_number":"SJ12656805247","room_confirmation_number":"SJ12657820967","room_stay_from":"2021-05-05","room_stay_to":"2021-05-08","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"117805","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-05-08 15:38:33","reservation_modified_date_time":"2021-05-08 15:38:33","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117805","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","changedComment":"Reservation created for complete past date","deltaChange":"75.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3248494","reservation_id":"114480","confirmation_number":"SJ12651789189","room_confirmation_number":"SJ12691024191","room_stay_from":"2021-05-07","room_stay_to":"2021-05-08","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":"121177","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-05-08 18:53:49","reservation_modified_date_time":"2021-05-08 18:53:49","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121177","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","changedComment":"Reservation created for complete past date","deltaChange":"25.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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3204823","reservation_id":"108597","confirmation_number":"SJ12661725512","room_confirmation_number":"SJ12664186188","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","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":"115035","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 01:42:18","reservation_modified_date_time":"2021-02-26 01:42:18","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":"3206550","reservation_id":"108895","confirmation_number":"SJ12671684233","room_confirmation_number":"SJ12631930281","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","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":"115362","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-01 02:17:06","reservation_modified_date_time":"2021-03-01 02:17:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115362","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":"3207620","reservation_id":"109103","confirmation_number":"SJ12613312762","room_confirmation_number":"SJ12644046341","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","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":"115578","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 07:22:19","reservation_modified_date_time":"2021-03-03 07:22:19","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":"3211150","reservation_id":"109515","confirmation_number":"SJ12656599701","room_confirmation_number":"SJ12660271212","room_stay_from":"2021-05-02","room_stay_to":"2021-05-09","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":"115986","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-05 19:15:08","reservation_modified_date_time":"2021-03-07 15:18:15","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3214853","reservation_id":"110189","confirmation_number":"SJ12687097484","room_confirmation_number":"SJ12688858476","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","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":"116707","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-13 13:12:11","reservation_modified_date_time":"2021-03-13 13:12:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116707","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":"3217054","reservation_id":"110480","confirmation_number":"SJ12674732200","room_confirmation_number":"SJ12694076312","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","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":"116993","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 02:28:43","reservation_modified_date_time":"2021-03-17 02:28:43","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":"3217056","reservation_id":"110481","confirmation_number":"SJ12654619861","room_confirmation_number":"SJ12642607741","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","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":"116994","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 02:30:11","reservation_modified_date_time":"2021-03-17 02:30:11","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":"3227707","reservation_id":"112059","confirmation_number":"SJ12693842531","room_confirmation_number":"SJ12698885499","room_stay_from":"2021-05-05","room_stay_to":"2021-05-09","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":"118626","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-04 02:57:25","reservation_modified_date_time":"2021-04-04 14:54:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118626","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":"3228351","reservation_id":"109201","confirmation_number":"SJ12614935349","room_confirmation_number":"SJ12616157182","room_stay_from":"2021-05-07","room_stay_to":"2021-05-09","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":"115673","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 21:22:08","reservation_modified_date_time":"2021-04-05 16:36:39","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115673","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":"3229767","reservation_id":"110985","confirmation_number":"SJ12627263408","room_confirmation_number":"SJ12675122375","room_stay_from":"2021-05-04","room_stay_to":"2021-05-09","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":"117524","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 18:20:33","reservation_modified_date_time":"2021-04-07 16:51:25","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3229908","reservation_id":"111227","confirmation_number":"SJ12636478889","room_confirmation_number":"SJ12676864445","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","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":"117758","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-25 00:45:07","reservation_modified_date_time":"2021-04-07 18:29:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117758","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":"3235704","reservation_id":"112563","confirmation_number":"SJ12627236661","room_confirmation_number":"SJ12697157851","room_stay_from":"2021-05-07","room_stay_to":"2021-05-09","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":"119142","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-09 23:44:38","reservation_modified_date_time":"2021-04-16 21:45:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119142","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":"3235711","reservation_id":"112677","confirmation_number":"SJ12688360202","room_confirmation_number":"SJ12640205818","room_stay_from":"2021-05-03","room_stay_to":"2021-05-09","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"120489","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-11 15:44:42","reservation_modified_date_time":"2021-04-16 21:33:44","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119266","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":"3239169","reservation_id":"113571","confirmation_number":"SJ12660288881","room_confirmation_number":"SJ12641128868","room_stay_from":"2021-05-08","room_stay_to":"2021-05-09","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":"120172","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 21:08:12","reservation_modified_date_time":"2021-04-21 21:08:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120172","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":"3243961","reservation_id":"112110","confirmation_number":"SJ12649204461","room_confirmation_number":"SJ12629852659","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","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":"118678","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-04 19:47:26","reservation_modified_date_time":"2021-04-29 21:51:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118678","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":"3246894","reservation_id":"114539","confirmation_number":"SJ12643921473","room_confirmation_number":"SJ12659485266","room_stay_from":"2021-05-08","room_stay_to":"2021-05-09","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":"121233","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-04 23:39:07","reservation_modified_date_time":"2021-05-04 23:39:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121233","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":"3247835","reservation_id":"111337","confirmation_number":"SJ12675598651","room_confirmation_number":"SJ12672847440","room_stay_from":"2021-05-07","room_stay_to":"2021-05-09","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117869","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-26 14:15:08","reservation_modified_date_time":"2021-05-07 13:14:44","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117869","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":"3186656","reservation_id":"106369","confirmation_number":"SJ12668588940","room_confirmation_number":"SJ12638304106","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"112766","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 00:30:28","reservation_modified_date_time":"2021-01-29 00:30:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112766","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":"3186714","reservation_id":"106369","confirmation_number":"SJ12681969494","room_confirmation_number":"SJ12623093770","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"112766","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 00:30:20","reservation_modified_date_time":"2021-01-29 02:23:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112766","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.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":"3186718","reservation_id":"106369","confirmation_number":"SJ12619817711","room_confirmation_number":"SJ12658997057","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"112766","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 00:30:12","reservation_modified_date_time":"2021-01-29 02:24:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112766","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":"3204826","reservation_id":"108598","confirmation_number":"SJ12620468288","room_confirmation_number":"SJ12666931534","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"115036","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 01:46:19","reservation_modified_date_time":"2021-02-26 01:46:19","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":"3206471","reservation_id":"108881","confirmation_number":"SJ12696235626","room_confirmation_number":"SJ12692197742","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","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":"115345","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-01 00:18:46","reservation_modified_date_time":"2021-03-01 00:18:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115345","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":"3207413","reservation_id":"109032","confirmation_number":"SJ12669713520","room_confirmation_number":"SJ12661565286","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"115517","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-02 17:32:25","reservation_modified_date_time":"2021-03-02 22:05:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115491","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":"3217063","reservation_id":"110484","confirmation_number":"SJ12621201721","room_confirmation_number":"SJ12657273553","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"116997","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 02:40:27","reservation_modified_date_time":"2021-03-17 02:40:27","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":"3218378","reservation_id":"110616","confirmation_number":"SJ12657946816","room_confirmation_number":"SJ12673310378","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","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":"117129","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-18 14:13:45","reservation_modified_date_time":"2021-03-18 21:58:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117129","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":"3219677","reservation_id":"110835","confirmation_number":"SJ12693443800","room_confirmation_number":"SJ12666218882","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","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":"117359","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-20 21:12:15","reservation_modified_date_time":"2021-03-20 21:21:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117359","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":"3220873","reservation_id":"111050","confirmation_number":"SJ12668424495","room_confirmation_number":"SJ12634835401","room_stay_from":"2021-05-03","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","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":"117592","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-23 01:57:07","reservation_modified_date_time":"2021-03-23 01:57:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117592","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":"3226975","reservation_id":"111980","confirmation_number":"SJ12694311854","room_confirmation_number":"SJ12611022747","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"118545","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 14:49:16","reservation_modified_date_time":"2021-04-03 14:49:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118545","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":"3229906","reservation_id":"110482","confirmation_number":"SJ12695614782","room_confirmation_number":"SJ12638617405","room_stay_from":"2021-05-07","room_stay_to":"2021-05-10","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":"116995","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 02:31:43","reservation_modified_date_time":"2021-04-07 18:28:09","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3229947","reservation_id":"108244","confirmation_number":"SJ12650352368","room_confirmation_number":"SJ12646989304","room_stay_from":"2021-05-06","room_stay_to":"2021-05-10","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":"114713","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 03:54:12","reservation_modified_date_time":"2021-04-07 19:25:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114713","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":"3237993","reservation_id":"113469","confirmation_number":"SJ12699562333","room_confirmation_number":"SJ12621219875","room_stay_from":"2021-05-08","room_stay_to":"2021-05-10","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":"120063","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-20 15:50:10","reservation_modified_date_time":"2021-04-20 15:50:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120063","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":"3248284","reservation_id":"111964","confirmation_number":"SJ12635565744","room_confirmation_number":"SJ12674719329","room_stay_from":"2021-05-08","room_stay_to":"2021-05-10","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"118526","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 03:34:08","reservation_modified_date_time":"2021-05-08 13:03:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118526","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":"3219450","reservation_id":"110766","confirmation_number":"SJ12655960819","room_confirmation_number":"SJ12611936199","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"121521","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 21:47:08","reservation_modified_date_time":"2021-03-20 17:27:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117278","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":"3227776","reservation_id":"112071","confirmation_number":"SJ12619350665","room_confirmation_number":"SJ12661848392","room_stay_from":"2021-05-06","room_stay_to":"2021-05-11","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":"118638","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-04 14:42:40","reservation_modified_date_time":"2021-04-04 14:42:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118638","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":"3229070","reservation_id":"109894","confirmation_number":"SJ12615271485","room_confirmation_number":"SJ12647133042","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116388","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-10 00:15:32","reservation_modified_date_time":"2021-04-06 19:15:08","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":"3230436","reservation_id":"112423","confirmation_number":"SJ12640868598","room_confirmation_number":"SJ12654482186","room_stay_from":"2021-05-07","room_stay_to":"2021-05-11","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"118996","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-08 04:22:12","reservation_modified_date_time":"2021-04-08 04:22:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118996","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":"3248337","reservation_id":"111970","confirmation_number":"SJ12612189156","room_confirmation_number":"SJ12689687091","room_stay_from":"2021-05-08","room_stay_to":"2021-05-11","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"118532","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 05:21:06","reservation_modified_date_time":"2021-05-08 15:14:13","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118532","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":"3237346","reservation_id":"113094","confirmation_number":"SJ12699819764","room_confirmation_number":"SJ12658487927","room_stay_from":"2021-05-08","room_stay_to":"2021-05-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"119677","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-16 15:08:37","reservation_modified_date_time":"2021-04-19 14:59:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119677","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":"3248442","reservation_id":"110398","confirmation_number":"SJ12694097655","room_confirmation_number":"SJ12653392901","room_stay_from":"2021-05-08","room_stay_to":"2021-05-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"116913","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-16 00:29:18","reservation_modified_date_time":"2021-05-08 17:26:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116913","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":"3237334","reservation_id":"113011","confirmation_number":"SJ12694592245","room_confirmation_number":"SJ12671187460","room_stay_from":"2021-05-08","room_stay_to":"2021-05-13","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":"119596","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-15 00:39:08","reservation_modified_date_time":"2021-04-19 14:57:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119596","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":"3216734","reservation_id":"109581","confirmation_number":"SJ12659341794","room_confirmation_number":"SJ12638613154","room_stay_from":"2021-05-08","room_stay_to":"2021-05-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"116060","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-06 17:01:47","reservation_modified_date_time":"2021-03-16 19:22:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116060","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":"3219067","reservation_id":"110758","confirmation_number":"SJ12667456995","room_confirmation_number":"SJ12673721071","room_stay_from":"2021-05-08","room_stay_to":"2021-05-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"117271","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 21:17:09","reservation_modified_date_time":"2021-03-19 21:17:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117271","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":"3229945","reservation_id":"107893","confirmation_number":"SJ12644276854","room_confirmation_number":"SJ12666604318","room_stay_from":"2021-05-07","room_stay_to":"2021-05-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"114354","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-17 17:34:12","reservation_modified_date_time":"2021-04-07 19:25:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114354","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":"3227769","reservation_id":"108702","confirmation_number":"SJ12649453863","room_confirmation_number":"SJ12674341216","room_stay_from":"2021-05-08","room_stay_to":"2021-05-15","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":"115153","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 01:46:00","reservation_modified_date_time":"2021-04-04 16:02:06","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":"3228337","reservation_id":"107196","confirmation_number":"SJ12659137670","room_confirmation_number":"SJ12665831114","room_stay_from":"2021-05-08","room_stay_to":"2021-05-15","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":"113657","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-09 01:15:07","reservation_modified_date_time":"2021-04-05 16:34:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113657","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":"3221949","reservation_id":"111216","confirmation_number":"SJ12699827433","room_confirmation_number":"SJ12612511583","room_stay_from":"2021-05-08","room_stay_to":"2021-05-21","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","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","subtotal":"325.00","grand_total":"365.63","paid_amount":"365.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"102743","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 23:11:28","reservation_modified_date_time":"2021-03-24 23:11:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102743","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":"3248278","reservation_id":"109732","confirmation_number":"SJ12641544083","room_confirmation_number":"SJ12686380705","room_stay_from":"2021-06-19","room_stay_to":"2021-06-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116200","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-08 01:18:27","reservation_modified_date_time":"2021-05-08 12:50:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116200","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3248351","reservation_id":"111272","confirmation_number":"SJ12651344644","room_confirmation_number":"SJ12657820967","room_stay_from":"2021-05-05","room_stay_to":"2021-05-08","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":"1009.01","product_id":"1776","service_quantity":"1","customer_traveller_id":"117805","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-25 18:25:08","reservation_modified_date_time":"2021-05-08 15:38:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117805","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3248375","reservation_id":"111109","confirmation_number":"SJ12676484917","room_confirmation_number":"SJ12686507073","room_stay_from":"2021-06-08","room_stay_to":"2021-06-18","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120493","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-23 20:02:09","reservation_modified_date_time":"2021-05-08 15:48:47","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":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[{"room_stay_id":"3248497","reservation_id":"114480","confirmation_number":"SJ12646783815","room_confirmation_number":"SJ12691024191","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"200.00","grand_total":"200.00","paid_amount":"171.88","product_id":"1231","service_quantity":"1","product_name":"late charge","parentTypeOfRes":"reservation","reservation_created_date":"2021-05-08 18:54:44","reservation_modified_date_time":"2021-05-08 18:54:44","customer_id":"121177","parentCustTravId":"121177","customer_traveller_id":"121177","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-05-07","sub_hotel_id":"126","currentDayPrice":"200.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3248288","reservation_id":"114761","confirmation_number":"SJ12660297140","room_confirmation_number":"SJ12630809048","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"25.00","paid_amount":"25.00","product_id":"1231","service_quantity":"1","product_name":"Water sports","parentTypeOfRes":"reservation","reservation_created_date":"2021-05-08 13:06:40","reservation_modified_date_time":"2021-05-08 13:06:40","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":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}