{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-02-25","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":20,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1293,1297","block_room_bookings":[{"confirmation_number":"SJ12618518113","room_stay_from":"2021-02-25","room_stay_to":"2021-02-26","bundle_room":"0","product_id":"1293"},{"confirmation_number":"SJ12680392580","room_stay_from":"2021-02-18","room_stay_to":"2021-03-04","bundle_room":"0","product_id":"1297"}],"bundle_block_count":"1267,1268,1311,1312,1269,1270,1307,1308,1260,1261,1309,1310,1291,1711,1304,1305,1262,1263,1271,1272,1302,1303","bundle_block_bookings":[{"confirmation_number":"SJB12629776051","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12662439332","room_stay_from":"2021-02-25","room_stay_to":"2021-02-26","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12618919276","room_stay_from":"2021-02-25","room_stay_to":"2021-02-26","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12686255054","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12671736056","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12634390202","room_stay_from":"2021-02-25","room_stay_to":"2021-02-26","bundle_room":"1","product_id":"1330"},{"confirmation_number":"SJB12697477345","room_stay_from":"2021-02-23","room_stay_to":"2021-02-26","bundle_room":"0","product_id":"1260"},{"confirmation_number":"SJB12616993937","room_stay_from":"2021-02-23","room_stay_to":"2021-02-26","bundle_room":"0","product_id":"1261"},{"confirmation_number":"SJB12661999033","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12627848662","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12619084967","room_stay_from":"2021-02-25","room_stay_to":"2021-02-28","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12667168362","room_stay_from":"2021-02-25","room_stay_to":"2021-02-28","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12658437341","room_stay_from":"2021-02-25","room_stay_to":"2021-02-28","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12621713620","room_stay_from":"2021-02-25","room_stay_to":"2021-02-28","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12671983593","room_stay_from":"2021-02-24","room_stay_to":"2021-02-28","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12652036760","room_stay_from":"2021-02-25","room_stay_to":"2021-03-01","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12612334921","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12662873179","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","bundle_room":"0","product_id":"1303"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3194885","reservation_id":"104679","confirmation_number":"SJ12636630959","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.30,174.30,174.30,174.30","nightly_discount":"0,0,0,0","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-2513680211","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":"111033","customer_id":"111033","source_of_creation":"Booking.com","reservation_created_date":"2021-01-04 00:53:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"143.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.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":"3204779","reservation_id":"108581","confirmation_number":"SJ12651925713","room_stay_from":"2021-02-25","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"260.94","nightly_discount":"0","subtotal":"260.94","grand_total":"293.56","paid_amount":"293.56","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-3535020480","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":"115020","customer_id":"115020","source_of_creation":"Booking.com","reservation_created_date":"2021-02-26 00:03:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"51.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"260.94","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":"3179464","reservation_id":"104587","confirmation_number":"SJ12686301450","room_stay_from":"2021-02-19","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.30,202.30,174.30,174.30,174.30,174.30,174.30,202.30","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1478.40","grand_total":"1663.20","paid_amount":"1663.20","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-2331247034","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":"114516","customer_id":"110936","source_of_creation":"Booking.com","reservation_created_date":"2021-01-02 18:01:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"302.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.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":"3184971","reservation_id":"106179","confirmation_number":"SJ12615389852","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.67,194.67,175.77,175.77,175.77,200.97","nightly_discount":"0,0,0,0,0,0","subtotal":"1117.62","grand_total":"1257.32","paid_amount":"1257.32","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2126163221","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":"112586","customer_id":"112586","source_of_creation":"Booking.com","reservation_created_date":"2021-01-26 18:01:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"228.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"175.77","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3185358","reservation_id":"106238","confirmation_number":"SJ12692614301","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"287.28,316.08","nightly_discount":"0,0","subtotal":"603.36","grand_total":"678.78","paid_amount":"678.78","room_type_id":"320","product_id":"1910","siteminder_id":"BDC-2862928838","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":"112646","customer_id":"112646","source_of_creation":"Booking.com","reservation_created_date":"2021-01-27 05:46:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"235.20","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1309,1310","currentDayPrice":"287.28","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":"3186164","reservation_id":"106238","confirmation_number":"SJ12678218563","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"287.28,316.08","nightly_discount":"0,0","subtotal":"603.36","grand_total":"678.78","paid_amount":"678.78","room_type_id":"320","product_id":"1332","siteminder_id":"BDC-2862928838","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":"112646","customer_id":"112646","source_of_creation":"Booking.com","reservation_created_date":"2021-01-27 05:46:23","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":"126","group_rooms":"1311,1312","currentDayPrice":"287.28","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":"3195900","reservation_id":"107333","confirmation_number":"SJ12627759033","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"298.2,298.2","nightly_discount":"0,0","subtotal":"596.40","grand_total":"670.95","paid_amount":"670.95","room_type_id":"413","product_id":"1272","siteminder_id":"BDC-2352393144","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":"113793","customer_id":"113793","source_of_creation":"Booking.com","reservation_created_date":"2021-02-11 05:02:23","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","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":"298.2","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":"3200914","reservation_id":"106188","confirmation_number":"SJ12640825161","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"238.77,194.67,194.67,175.77,175.77,175.77,200.97","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1356.39","grand_total":"1525.94","paid_amount":"1525.94","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3239349705","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":"112595","customer_id":"112595","source_of_creation":"Booking.com","reservation_created_date":"2021-01-26 19:37:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"275.66","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"175.77","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204631","reservation_id":"108572","confirmation_number":"SJ12643299742","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"303.20,303.20","nightly_discount":"0,0","subtotal":"606.40","grand_total":"682.20","paid_amount":"682.20","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-3779251959","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":"115012","customer_id":"115012","source_of_creation":"Booking.com","reservation_created_date":"2021-02-25 20:40:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"118.15","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"303.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":"3175509","reservation_id":"104947","confirmation_number":"SJ12669015705","room_stay_from":"2021-02-25","room_stay_to":"2021-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.30,202.30,202.30,174.30","nightly_discount":"0,0,0,0","subtotal":"753.20","grand_total":"847.35","paid_amount":"847.35","room_type_id":"413","product_id":"1271","siteminder_id":"BDC-2708970547","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":"111307","customer_id":"111307","source_of_creation":"Booking.com","reservation_created_date":"2021-01-07 16:20:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"153.58","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3176699","reservation_id":"104843","confirmation_number":"SJ12684726620","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.44,139.44,139.44,139.44,139.44","nightly_discount":"0,0,0,0,0","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1727876153","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":"111193","customer_id":"111193","source_of_creation":"Expedia","reservation_created_date":"2021-01-06 03:56:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"139.44","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181206","reservation_id":"105308","confirmation_number":"SJ12644139433","room_stay_from":"2021-02-20","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.24,156.24,156.24,156.24,156.24,156.24","nightly_discount":"0,0,0,0,0,0","subtotal":"993.44","grand_total":"1117.62","paid_amount":"1117.62","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1729820159","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":"111696","customer_id":"111696","source_of_creation":"Expedia","reservation_created_date":"2021-01-14 03:16:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"156.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3183966","reservation_id":"106038","confirmation_number":"SJ12656697395","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.24,170.24,170.24,170.24,170.24,170.24,192.64","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1270.08","grand_total":"1428.84","paid_amount":"1428.84","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1732504814","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":"112465","customer_id":"112465","source_of_creation":"Expedia","reservation_created_date":"2021-01-25 02:27:07","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"170.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3185224","reservation_id":"106207","confirmation_number":"SJ12611640099","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"243.20,275.20","nightly_discount":"0,0","subtotal":"518.40","grand_total":"583.20","paid_amount":"583.20","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1732992205","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":"112616","customer_id":"112616","source_of_creation":"Expedia","reservation_created_date":"2021-01-27 00:11:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"243.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":"3190748","reservation_id":"106769","confirmation_number":"SJ12635013549","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.24,201.04,201.04,201.04,201.04,201.04,184.24","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1401.68","grand_total":"1576.89","paid_amount":"1576.89","room_type_id":"413","product_id":"1262","siteminder_id":"EXP-1734776504","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":"113191","customer_id":"113191","source_of_creation":"Expedia","reservation_created_date":"2021-02-02 21:56:31","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":"126","group_rooms":null,"currentDayPrice":"201.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":"3200911","reservation_id":"105363","confirmation_number":"SJ12669033208","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.44,139.44,139.44,139.44,139.44,161.84","nightly_discount":"0,0,0,0,0,0","subtotal":"859.04","grand_total":"966.42","paid_amount":"966.42","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1730104359","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":"111754","customer_id":"111754","source_of_creation":"Expedia","reservation_created_date":"2021-01-15 04:56:29","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202480","reservation_id":"108233","confirmation_number":"SJ12634553366","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"223.36,223.36","nightly_discount":"0,0","subtotal":"446.72","grand_total":"502.56","paid_amount":"502.56","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1740337856","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":"114699","customer_id":"114699","source_of_creation":"Expedia","reservation_created_date":"2021-02-22 01:22:06","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"223.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":"3204537","reservation_id":"107666","confirmation_number":"SJ12686995602","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"242.56,242.56","nightly_discount":"0,0","subtotal":"485.12","grand_total":"545.76","paid_amount":"545.76","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1738349304","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":"114124","customer_id":"114124","source_of_creation":"Expedia","reservation_created_date":"2021-02-15 15:42:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"242.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192725","reservation_id":"106116","confirmation_number":"SJ12611310083","room_stay_from":"2021-02-25","room_stay_to":"2021-02-28","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.40,191.40,191.40","nightly_discount":"0,0,0","subtotal":"550.20","grand_total":"618.98","paid_amount":"618.98","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1732735950","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":"112534","customer_id":"112534","source_of_creation":"Expedia","reservation_created_date":"2021-01-26 00:16: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":"126","group_rooms":null,"currentDayPrice":"167.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":"3201226","reservation_id":"105309","confirmation_number":"SJ12614372867","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.30,195.30,195.30,195.30,195.30,223.30,223.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1423.10","grand_total":"1600.99","paid_amount":"1600.99","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1729820610","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":"111697","customer_id":"111697","source_of_creation":"Expedia","reservation_created_date":"2021-01-14 03:16:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.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":"3193091","reservation_id":"106372","confirmation_number":"SJ12686082311","room_stay_from":"2021-02-25","room_stay_to":"2021-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.75,216.75,216.75,211.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"831.50","grand_total":"935.44","paid_amount":"935.44","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1733526574","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":"112769","customer_id":"112769","source_of_creation":"Expedia","reservation_created_date":"2021-01-29 00:31:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"186.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":"3198672","reservation_id":"107237","confirmation_number":"SJ12640042220","room_stay_from":"2021-02-25","room_stay_to":"2021-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.68,169.68,169.68,127.68","nightly_discount":"0,0,0,0","subtotal":"636.72","grand_total":"716.31","paid_amount":"716.31","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1736637957","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":"113698","customer_id":"113698","source_of_creation":"Expedia","reservation_created_date":"2021-02-09 19:15:16","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"169.68","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":"3203037","reservation_id":"108308","confirmation_number":"SJ12618108956","room_stay_from":"2021-02-25","room_stay_to":"2021-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.24,212.24,212.24,156.24,161.84","nightly_discount":"0,0,0,0,0","subtotal":"954.80","grand_total":"1074.15","paid_amount":"1074.15","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1740564232","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":"114764","customer_id":"114764","source_of_creation":"Expedia","reservation_created_date":"2021-02-22 20:07:29","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"212.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3185958","reservation_id":"104383","confirmation_number":"SJ12651559501","room_stay_from":"2021-02-25","room_stay_to":"2021-03-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.44,161.84,161.84,139.44,145.04,145.04","nightly_discount":"0,0,0,0,0,0","subtotal":"892.64","grand_total":"1004.22","paid_amount":"1004.22","room_type_id":"319","product_id":"1943","siteminder_id":"EXP-1726105849","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":"110736","customer_id":"110736","source_of_creation":"Expedia","reservation_created_date":"2020-12-29 19:11:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3187532","reservation_id":"106452","confirmation_number":"SJ12685026731","room_stay_from":"2021-02-25","room_stay_to":"2021-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"268.80,247.80,247.80,212.80,219.80,219.80,219.80","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1636.60","grand_total":"1841.18","paid_amount":"1841.18","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1733791092","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":"112859","customer_id":"112859","source_of_creation":"Expedia","reservation_created_date":"2021-01-29 23:46:23","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"268.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":"3174677","reservation_id":"104119","confirmation_number":"SJ12640591791","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.44,167.44,167.44,167.44,167.44,184.24,184.24,167.44,171.92,171.92,171.92,171.92,188.72,188.72","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"2438.24","grand_total":"2743.02","paid_amount":"2743.02","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1724692080","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":"110451","customer_id":"110451","source_of_creation":"Expedia","reservation_created_date":"2020-12-22 19:01:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"167.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204768","reservation_id":"106152","confirmation_number":"SJ12646784630","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,181.30,181.30,181.30","nightly_discount":"0,0,0,0","subtotal":"753.20","grand_total":"847.35","paid_amount":"235.47","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1732857623","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112566","customer_id":"112566","source_of_creation":"Expedia","reservation_created_date":"2021-01-26 14:21:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3184649","reservation_id":"106127","confirmation_number":"SJ12669887556","room_stay_from":"2021-02-24","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"153.38,153.38","nightly_discount":"0,0","subtotal":"306.76","grand_total":"345.11","paid_amount":"345.11","room_type_id":"413","product_id":"1273","siteminder_id":"GAM-R2297027240","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":"112543","customer_id":"112543","source_of_creation":"Getaroom.com","reservation_created_date":"2021-01-26 02:19:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"153.38","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3202551","reservation_id":"105150","confirmation_number":"SJ12687256596","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.48,228.48,228.48,223.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"908.44","grand_total":"1052.76","paid_amount":"1052.76","room_type_id":"413","product_id":"1268","siteminder_id":"ABB-HMQKHR3ACY","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"913.92","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111533","customer_id":"111533","source_of_creation":"Airbnb","reservation_created_date":"2021-01-11 03:09:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"26.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"223.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":"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":"3203311","reservation_id":"105433","confirmation_number":"SJ12664244391","room_stay_from":"2021-02-23","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"366.18,366.18,359.70","nightly_discount":"0.00,0.00,0.00","subtotal":"1092.06","grand_total":"1265.53","paid_amount":"1265.53","room_type_id":"320","product_id":"1320","siteminder_id":"ABB-HMM3SH5JJP","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1098.54","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111839","customer_id":"111839","source_of_creation":"Airbnb","reservation_created_date":"2021-01-16 04:02:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","ota_service_fee_amount":"0","commision_charges":"32.31","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1260,1261","currentDayPrice":"359.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3203733","reservation_id":"106413","confirmation_number":"SJ12622756284","room_stay_from":"2021-02-24","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"274.38,274.38,274.38,267.79","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1090.93","grand_total":"1264.25","paid_amount":"1264.25","room_type_id":"318","product_id":"1281","siteminder_id":"ABB-HMRHFJAB5Q","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1097.52","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112809","customer_id":"112809","source_of_creation":"Airbnb","reservation_created_date":"2021-01-29 14:43:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"32.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"274.38","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3200484","reservation_id":"106481","confirmation_number":"SJ12636657303","room_stay_from":"2021-02-25","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0","subtotal":"99.00","grand_total":"111.38","paid_amount":"111.38","room_type_id":"319","product_id":"1277","siteminder_id":"HWR-303188857","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":"112890","customer_id":"112890","source_of_creation":"Hotwire","reservation_created_date":"2021-01-30 16:37:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"99.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3201238","reservation_id":"105326","confirmation_number":"SJ12622881704","room_stay_from":"2021-02-24","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0,0","subtotal":"198.00","grand_total":"222.75","paid_amount":"222.75","room_type_id":"319","product_id":"1287","siteminder_id":"HWR-303119362","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":"111714","customer_id":"111714","source_of_creation":"Hotwire","reservation_created_date":"2021-01-14 18:00:07","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":"126","group_rooms":null,"currentDayPrice":"99.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202079","reservation_id":"107210","confirmation_number":"SJ12643419361","room_stay_from":"2021-02-25","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"129.00","nightly_discount":"0","subtotal":"129.00","grand_total":"145.13","paid_amount":"145.13","room_type_id":"319","product_id":"1308","siteminder_id":"HWR-303227551","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":"113674","customer_id":"113674","source_of_creation":"Hotwire","reservation_created_date":"2021-02-09 11:32:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"129.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3201719","reservation_id":"106560","confirmation_number":"SJ12674147604","room_stay_from":"2021-02-25","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,149.00,149.00","nightly_discount":"0,0,0","subtotal":"427.00","grand_total":"480.38","paid_amount":"480.38","room_type_id":"319","product_id":"1313","siteminder_id":"HWR-303189066","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":"112978","customer_id":"112978","source_of_creation":"Hotwire","reservation_created_date":"2021-01-31 18:31:07","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":"129.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3204509","reservation_id":"108172","confirmation_number":"SJ12666905677","room_stay_from":"2021-02-28","room_stay_to":"2021-03-03","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"237.15,245.65,322.15","nightly_discount":"0.00,0.00,0.00","subtotal":"804.95","grand_total":"905.57","paid_amount":"628.80","room_type_id":"319","product_id":"1305","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":"114637","customer_id":"114637","source_of_creation":"FE","reservation_created_date":"2021-02-21 14:48:59","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","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":"3181777","reservation_id":"105481","confirmation_number":"SJ12642034519","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.75,186.75,186.75,186.75,186.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"933.75","grand_total":"1050.47","paid_amount":"1050.47","room_type_id":"319","product_id":"1275","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":"111896","customer_id":"111896","source_of_creation":"PMS","reservation_created_date":"2021-01-16 23:23:32","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":"186.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":"3189104","reservation_id":"105218","confirmation_number":"SJ12663846226","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"139.25,299.25,299.25,299.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1037.00","grand_total":"1166.63","paid_amount":"1166.63","room_type_id":"320","product_id":"1323","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111580","customer_id":"111580","source_of_creation":"PMS","reservation_created_date":"2021-01-12 14:49:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1269,1270","currentDayPrice":"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":"3199260","reservation_id":"107804","confirmation_number":"SJ12680777526","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"305.15,305.15,305.15,322.15","nightly_discount":"15.25,15.25,15.25,16.10","subtotal":"1237.60","grand_total":"1322.72","paid_amount":"1322.72","room_type_id":"319","product_id":"1307","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":"114260","customer_id":"114260","source_of_creation":"PMS","reservation_created_date":"2021-02-16 16:22:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","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":"322.15","currentDayDiscount":"16.10","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3203869","reservation_id":"108475","confirmation_number":"SJ12666134205","room_stay_from":"2021-02-25","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"322.15","nightly_discount":"0.00","subtotal":"322.15","grand_total":"362.42","paid_amount":"362.42","room_type_id":"319","product_id":"1286","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114922","customer_id":"114922","source_of_creation":"PMS","reservation_created_date":"2021-02-24 20:04:44","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"322.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3174453","reservation_id":"104774","confirmation_number":"SJ12626267927","room_stay_from":"2021-02-25","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"209.15,373.15,373.15","nightly_discount":"0.00,0.00,0.00","subtotal":"955.45","grand_total":"1074.88","paid_amount":"1074.88","room_type_id":"320","product_id":"1714","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111127","customer_id":"111127","source_of_creation":"PMS","reservation_created_date":"2021-01-05 16:18:34","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1291,1711","currentDayPrice":"209.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3174457","reservation_id":"104775","confirmation_number":"SJ12634265909","room_stay_from":"2021-02-25","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.15,200.15,200.15","nightly_discount":"0.00,0.00,0.00","subtotal":"559.45","grand_total":"629.38","paid_amount":"629.38","room_type_id":"318","product_id":"1289","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":"111127","customer_id":"111127","source_of_creation":"PMS","reservation_created_date":"2021-01-05 16:22:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"159.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3175766","reservation_id":"104961","confirmation_number":"SJ12629311096","room_stay_from":"2021-02-25","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"305.05,335.84,335.84","nightly_discount":"0.00,0.00,0.00","subtotal":"976.73","grand_total":"1098.82","paid_amount":"1098.82","room_type_id":"320","product_id":"1329","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":"111328","customer_id":"111328","source_of_creation":"PMS","reservation_created_date":"2021-01-07 21:45:41","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1304,1305","currentDayPrice":"305.05","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3177487","reservation_id":"104655","confirmation_number":"SJ12645800618","room_stay_from":"2021-02-24","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.65,211.65,245.65,245.65","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"914.60","grand_total":"1028.93","paid_amount":"1028.93","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":"111009","customer_id":"111009","source_of_creation":"PMS","reservation_created_date":"2021-01-03 20:02:48","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":"211.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":"3190726","reservation_id":"103654","confirmation_number":"SJ12650839404","room_stay_from":"2021-02-24","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.65,211.65,245.65,245.65","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"914.60","grand_total":"1028.93","paid_amount":"1028.93","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109903","customer_id":"109903","source_of_creation":"PMS","reservation_created_date":"2020-12-09 20:35:37","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"211.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":"3189341","reservation_id":"106562","confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101703","customer_id":"101703","source_of_creation":"PMS","reservation_created_date":"2021-01-31 18:54:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"0.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3200997","reservation_id":"105427","confirmation_number":"SJ12621975795","room_stay_from":"2021-02-19","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.00,178.00,178.00,178.00,178.00,178.00,178.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1246.00","grand_total":"1246.00","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-01-16 02:43:22","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":"178.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3197141","reservation_id":"106999","confirmation_number":"SJ12640521255","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.00,178.00,178.00,178.00,178.00,178.00,178.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1246.00","grand_total":"1246.00","paid_amount":"0.00","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"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-05 23:59:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"178.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3175939","reservation_id":"104910","confirmation_number":"SJ12659738538","room_stay_from":"2021-02-23","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"570.00","grand_total":"570.00","paid_amount":"140.63","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-01-07 00:38:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181214","reservation_id":"105605","confirmation_number":"SJ12628104872","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"798.00","grand_total":"798.00","paid_amount":"196.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-01-19 02:53:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3195898","reservation_id":"107333","confirmation_number":"SJ12692561760","room_confirmation_number":"SJ12627759033","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"113793","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-11 15:55:06","reservation_modified_date_time":"2021-02-11 15:55:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113793","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":"3204308","reservation_id":"106594","confirmation_number":"SJ12693071258","room_confirmation_number":"SJ12655845080","room_stay_from":"2021-03-21","room_stay_to":"2021-03-23","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"100.60","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"113017","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-25 14:44:34","reservation_modified_date_time":"2021-02-25 14:44:34","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113017","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3176701","reservation_id":"104843","confirmation_number":"SJ12693309515","room_confirmation_number":"SJ12684726620","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","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":"111193","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-06 03:56:12","reservation_modified_date_time":"2021-01-09 17:01:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111193","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":"3181207","reservation_id":"105308","confirmation_number":"SJ12681754001","room_confirmation_number":"SJ12644139433","room_stay_from":"2021-02-20","room_stay_to":"2021-02-26","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":"111696","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 03:16:11","reservation_modified_date_time":"2021-01-19 02:49:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111696","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":"3181779","reservation_id":"105481","confirmation_number":"SJ12644308877","room_confirmation_number":"SJ12642034519","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","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":"111896","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 23:23:32","reservation_modified_date_time":"2021-01-20 16:02:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111896","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":"3184650","reservation_id":"106127","confirmation_number":"SJ12664995330","room_confirmation_number":"SJ12669887556","room_stay_from":"2021-02-24","room_stay_to":"2021-02-26","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":"112543","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 02:19:07","reservation_modified_date_time":"2021-01-26 02:19:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112543","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":"3189107","reservation_id":"105218","confirmation_number":"SJ12693939092","room_confirmation_number":"SJ12663846226","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","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":"111580","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-12 14:49:13","reservation_modified_date_time":"2021-02-01 15:13:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111580","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":"3194886","reservation_id":"104679","confirmation_number":"SJ12624597771","room_confirmation_number":"SJ12636630959","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"111033","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-04 00:53:08","reservation_modified_date_time":"2021-02-09 18:44:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111033","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":"3199262","reservation_id":"107804","confirmation_number":"SJ12675909966","room_confirmation_number":"SJ12680777526","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","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":"114260","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-16 16:22:57","reservation_modified_date_time":"2021-02-16 19:53:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114260","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":"3200485","reservation_id":"106481","confirmation_number":"SJ12664811068","room_confirmation_number":"SJ12636657303","room_stay_from":"2021-02-25","room_stay_to":"2021-02-26","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":"112890","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-30 16:37:08","reservation_modified_date_time":"2021-02-18 18:06:03","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112890","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":"3200998","reservation_id":"105427","confirmation_number":"SJ12660982518","room_confirmation_number":"SJ12621975795","room_stay_from":"2021-02-19","room_stay_to":"2021-02-26","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":"111831","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 02:43:22","reservation_modified_date_time":"2021-02-19 17:05:21","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":"3201239","reservation_id":"105326","confirmation_number":"SJ12692900827","room_confirmation_number":"SJ12622881704","room_stay_from":"2021-02-24","room_stay_to":"2021-02-26","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":"111714","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 18:00:07","reservation_modified_date_time":"2021-02-20 00:27:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111714","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":"3202080","reservation_id":"107210","confirmation_number":"SJ12679188128","room_confirmation_number":"SJ12643419361","room_stay_from":"2021-02-25","room_stay_to":"2021-02-26","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":"113674","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-09 11:32:09","reservation_modified_date_time":"2021-02-21 15:33:43","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113674","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":"3202552","reservation_id":"105150","confirmation_number":"SJ12652347574","room_confirmation_number":"SJ12687256596","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111533","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-11 03:09:07","reservation_modified_date_time":"2021-02-22 13:35:14","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111533","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":"3203314","reservation_id":"105433","confirmation_number":"SJ12684354044","room_confirmation_number":"SJ12664244391","room_stay_from":"2021-02-23","room_stay_to":"2021-02-26","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":"111839","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 04:02:09","reservation_modified_date_time":"2021-02-23 15:42:51","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111839","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":"3203870","reservation_id":"108475","confirmation_number":"SJ12631072096","room_confirmation_number":"SJ12666134205","room_stay_from":"2021-02-25","room_stay_to":"2021-02-26","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":"114922","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-24 20:04:44","reservation_modified_date_time":"2021-02-24 20:04:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114922","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":"3204780","reservation_id":"108581","confirmation_number":"SJ12610871449","room_confirmation_number":"SJ12651925713","room_stay_from":"2021-02-25","room_stay_to":"2021-02-26","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":"115020","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 00:03:11","reservation_modified_date_time":"2021-02-26 00:03:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115020","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":"3179465","reservation_id":"104587","confirmation_number":"SJ12610374391","room_confirmation_number":"SJ12686301450","room_stay_from":"2021-02-19","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"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","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114516","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 18:01:07","reservation_modified_date_time":"2021-01-15 21:59:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110936","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":"3183967","reservation_id":"106038","confirmation_number":"SJ12681308912","room_confirmation_number":"SJ12656697395","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","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":"112465","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-25 02:27:07","reservation_modified_date_time":"2021-01-25 02:27:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112465","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":"3184972","reservation_id":"106179","confirmation_number":"SJ12692312293","room_confirmation_number":"SJ12615389852","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","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":"112586","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 18:01:08","reservation_modified_date_time":"2021-01-26 18:01:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112586","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":"3185225","reservation_id":"106207","confirmation_number":"SJ12692213691","room_confirmation_number":"SJ12611640099","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","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":"112616","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 00:11:10","reservation_modified_date_time":"2021-01-27 00:11:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112616","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":"3185359","reservation_id":"106238","confirmation_number":"SJ12679683279","room_confirmation_number":"SJ12692614301","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","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":"112646","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 05:46:11","reservation_modified_date_time":"2021-01-27 05:46:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112646","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":"3186163","reservation_id":"106238","confirmation_number":"SJ12688300634","room_confirmation_number":"SJ12678218563","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","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":"112646","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 05:46:23","reservation_modified_date_time":"2021-01-27 14:58:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112646","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":"3190747","reservation_id":"106769","confirmation_number":"SJ12644796727","room_confirmation_number":"SJ12635013549","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","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":"113191","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-02 21:56:31","reservation_modified_date_time":"2021-02-02 22:45:49","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113191","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":"3195899","reservation_id":"107333","confirmation_number":"SJ12673547952","room_confirmation_number":"SJ12627759033","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","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":"113793","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-11 05:02:23","reservation_modified_date_time":"2021-02-11 15:55:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113793","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":"3197142","reservation_id":"106999","confirmation_number":"SJ12610375317","room_confirmation_number":"SJ12640521255","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","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":"113438","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 23:59:52","reservation_modified_date_time":"2021-02-13 04:17:21","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":"3200912","reservation_id":"105363","confirmation_number":"SJ12689363160","room_confirmation_number":"SJ12669033208","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","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":"111754","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 04:56:29","reservation_modified_date_time":"2021-02-19 14:24:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111754","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":"3200915","reservation_id":"106188","confirmation_number":"SJ12672572211","room_confirmation_number":"SJ12640825161","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"112595","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 19:37:08","reservation_modified_date_time":"2021-02-19 14:25:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112595","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":"3202481","reservation_id":"108233","confirmation_number":"SJ12623374051","room_confirmation_number":"SJ12634553366","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","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":"114699","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 01:22:06","reservation_modified_date_time":"2021-02-22 01:22:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114699","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":"3204538","reservation_id":"107666","confirmation_number":"SJ12638633457","room_confirmation_number":"SJ12686995602","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","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":"114124","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-15 15:42:37","reservation_modified_date_time":"2021-02-25 18:03:46","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114124","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":"3204632","reservation_id":"108572","confirmation_number":"SJ12665902874","room_confirmation_number":"SJ12643299742","room_stay_from":"2021-02-25","room_stay_to":"2021-02-27","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":"115012","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-25 20:40:11","reservation_modified_date_time":"2021-02-25 20:40:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115012","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":"3174454","reservation_id":"104774","confirmation_number":"SJ12670789289","room_confirmation_number":"SJ12626267927","room_stay_from":"2021-02-25","room_stay_to":"2021-02-28","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":"111127","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 16:18:34","reservation_modified_date_time":"2021-01-05 16:18:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111127","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":"3174458","reservation_id":"104775","confirmation_number":"SJ12681134199","room_confirmation_number":"SJ12634265909","room_stay_from":"2021-02-25","room_stay_to":"2021-02-28","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":"111127","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 16:22:32","reservation_modified_date_time":"2021-01-05 16:22:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111127","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":"3175767","reservation_id":"104961","confirmation_number":"SJ12633358518","room_confirmation_number":"SJ12629311096","room_stay_from":"2021-02-25","room_stay_to":"2021-02-28","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":"111328","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-07 21:45:41","reservation_modified_date_time":"2021-01-07 21:45:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111328","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":"3175940","reservation_id":"104910","confirmation_number":"SJ12637893694","room_confirmation_number":"SJ12659738538","room_stay_from":"2021-02-23","room_stay_to":"2021-02-28","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":"111264","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-07 00:38:17","reservation_modified_date_time":"2021-01-08 01:52:22","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":"3177488","reservation_id":"104655","confirmation_number":"SJ12625670286","room_confirmation_number":"SJ12645800618","room_stay_from":"2021-02-24","room_stay_to":"2021-02-28","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":"111009","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-03 20:02:48","reservation_modified_date_time":"2021-01-11 15:49:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111009","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":"3181215","reservation_id":"105605","confirmation_number":"SJ12644459719","room_confirmation_number":"SJ12628104872","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","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":"112026","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-19 02:53:46","reservation_modified_date_time":"2021-01-19 02:53:46","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190728","reservation_id":"103654","confirmation_number":"SJ12627689976","room_confirmation_number":"SJ12650839404","room_stay_from":"2021-02-24","room_stay_to":"2021-02-28","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":"109903","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-09 20:35:37","reservation_modified_date_time":"2021-02-02 22:45:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109903","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":"3192726","reservation_id":"106116","confirmation_number":"SJ12610039821","room_confirmation_number":"SJ12611310083","room_stay_from":"2021-02-25","room_stay_to":"2021-02-28","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":"112534","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 00:16:08","reservation_modified_date_time":"2021-02-05 23:53:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112534","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":"3201230","reservation_id":"105309","confirmation_number":"SJ12665982658","room_confirmation_number":"SJ12614372867","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","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":"111697","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 03:16:15","reservation_modified_date_time":"2021-02-20 00:23:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111697","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":"3201720","reservation_id":"106560","confirmation_number":"SJ12696830593","room_confirmation_number":"SJ12674147604","room_stay_from":"2021-02-25","room_stay_to":"2021-02-28","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":"112978","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 18:31:07","reservation_modified_date_time":"2021-02-20 21:56:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112978","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":"3203734","reservation_id":"106413","confirmation_number":"SJ12611889072","room_confirmation_number":"SJ12622756284","room_stay_from":"2021-02-24","room_stay_to":"2021-02-28","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112809","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 14:43:05","reservation_modified_date_time":"2021-02-24 16:47:49","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112809","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":"3175510","reservation_id":"104947","confirmation_number":"SJ12621461051","room_confirmation_number":"SJ12669015705","room_stay_from":"2021-02-25","room_stay_to":"2021-03-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"111307","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-07 16:20:10","reservation_modified_date_time":"2021-01-07 16:20:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111307","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":"3193092","reservation_id":"106372","confirmation_number":"SJ12629074452","room_confirmation_number":"SJ12686082311","room_stay_from":"2021-02-25","room_stay_to":"2021-03-01","room_stay_status":"Active","nightly_price":"25,25,25,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":"112848","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 00:31:12","reservation_modified_date_time":"2021-02-06 17:50:52","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112769","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":"3198673","reservation_id":"107237","confirmation_number":"SJ12699046561","room_confirmation_number":"SJ12640042220","room_stay_from":"2021-02-25","room_stay_to":"2021-03-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"113698","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-09 19:15:16","reservation_modified_date_time":"2021-02-15 21:20:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113698","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":"3203036","reservation_id":"108308","confirmation_number":"SJ12642719954","room_confirmation_number":"SJ12618108956","room_stay_from":"2021-02-25","room_stay_to":"2021-03-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"114764","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 20:07:29","reservation_modified_date_time":"2021-02-22 21:33:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114764","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":"3185959","reservation_id":"104383","confirmation_number":"SJ12662263854","room_confirmation_number":"SJ12651559501","room_stay_from":"2021-02-25","room_stay_to":"2021-03-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"110736","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-29 19:11:08","reservation_modified_date_time":"2021-01-27 23:46:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110736","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":"3187531","reservation_id":"106452","confirmation_number":"SJ12688461630","room_confirmation_number":"SJ12685026731","room_stay_from":"2021-02-25","room_stay_to":"2021-03-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"112859","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 23:46:23","reservation_modified_date_time":"2021-01-30 01:03:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112859","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":"3174680","reservation_id":"104119","confirmation_number":"SJ12691944516","room_confirmation_number":"SJ12640591791","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"350.00","grand_total":"393.75","paid_amount":"393.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"110451","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-22 19:01:07","reservation_modified_date_time":"2021-01-05 20:56:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110451","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3189342","reservation_id":"106562","confirmation_number":"SJ12674501286","room_confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 18:54:06","reservation_modified_date_time":"2021-02-01 18:35:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101703","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204510","reservation_id":"108172","confirmation_number":"SJ12654612342","room_confirmation_number":"SJ12666905677","room_stay_from":"2021-02-28","room_stay_to":"2021-03-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114637","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-21 14:48:59","reservation_modified_date_time":"2021-02-25 17:35:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114637","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":"3204769","reservation_id":"106152","confirmation_number":"SJ12641759516","room_confirmation_number":"SJ12646784630","room_stay_from":"2021-03-08","room_stay_to":"2021-03-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112566","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 14:21:27","reservation_modified_date_time":"2021-02-25 23:33:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112566","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}