{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-07-24","total_rooms_exist":"1281,1282,1289,1274,1275,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":11,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1288,1313,1307,1943","block_room_bookings":[{"confirmation_number":"SJ12641057599","room_stay_from":"2020-07-24","room_stay_to":"2020-07-25","bundle_room":"0"},{"confirmation_number":"SJ12655144711","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJ12676533150","room_stay_from":"2020-07-11","room_stay_to":"2020-08-05","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-04","room_stay_to":"2020-09-01","bundle_room":"0"}],"bundle_block_count":"1267,1268,1269,1270,1271,1272,1309,1310,1262,1263,1260,1261,1302,1303,1291,1711,1304,1305,1307,1308,1311,1312","bundle_block_bookings":[{"confirmation_number":"SJB12699512255","room_stay_from":"2020-07-22","room_stay_to":"2020-07-25","bundle_room":"1"},{"confirmation_number":"SJB12688812929","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","bundle_room":"1"},{"confirmation_number":"SJB12696546620","room_stay_from":"2020-07-24","room_stay_to":"2020-07-25","bundle_room":"1"},{"confirmation_number":"SJB12678863036","room_stay_from":"2020-07-23","room_stay_to":"2020-07-26","bundle_room":"1"},{"confirmation_number":"SJB12632559221","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","bundle_room":"1"},{"confirmation_number":"SJB12659467636","room_stay_from":"2020-07-24","room_stay_to":"2020-07-27","bundle_room":"1"},{"confirmation_number":"SJB12686984844","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","bundle_room":"1"},{"confirmation_number":"SJB12631240958","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJB12683410610","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJB12623036528","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJB12615618970","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","bundle_room":"0"},{"confirmation_number":"SJB12630929587","room_stay_from":"2020-07-21","room_stay_to":"2020-07-28","bundle_room":"1"},{"confirmation_number":"SJB12688176377","room_stay_from":"2020-07-24","room_stay_to":"2020-07-29","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3119289","reservation_id":"95093","confirmation_number":"SJ12642228518","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"48.4,64.4,64.4,48.4","nightly_discount":"0,0,0,0","subtotal":"225.60","grand_total":"253.80","paid_amount":"253.80","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-3829345140","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101274","customer_id":"101274","source_of_creation":"Booking.com","reservation_created_date":"2020-05-20 01:28:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"94.61","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"64.4","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":"3119357","reservation_id":"95095","confirmation_number":"SJ12664636390","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"48.4,64.4,64.4,48.4","nightly_discount":"0,0,0,0","subtotal":"225.60","grand_total":"253.80","paid_amount":"253.80","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-3829323920","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101276","customer_id":"101276","source_of_creation":"Booking.com","reservation_created_date":"2020-05-20 01:32:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"94.61","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"64.4","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":"3119652","reservation_id":"97585","confirmation_number":"SJ12645665642","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"267.20,267.20,172.80,172.80","nightly_discount":"0,0,0,0","subtotal":"880.00","grand_total":"990.00","paid_amount":"990.00","room_type_id":"413","product_id":"1262","siteminder_id":"BDC-2162244087","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":"103661","customer_id":"103661","source_of_creation":"Booking.com","reservation_created_date":"2020-07-09 19:29:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"58.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"267.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3117461","reservation_id":"95005","confirmation_number":"SJ12696624914","room_stay_from":"2020-07-17","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.36,95.36,82.56,82.56,82.56,82.56,82.56,95.36","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"698.88","grand_total":"786.24","paid_amount":"786.24","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1664737254","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":"101198","customer_id":"101198","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 00:37:09","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":"","currentDayPrice":"95.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":"3117845","reservation_id":"97831","confirmation_number":"SJ12639864923","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"138.40,213.60","nightly_discount":"0,0","subtotal":"352.00","grand_total":"396.00","paid_amount":"396.00","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1680159108","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":"103904","customer_id":"103904","source_of_creation":"Expedia","reservation_created_date":"2020-07-16 21:03:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"213.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118566","reservation_id":"95160","confirmation_number":"SJ12692878132","room_stay_from":"2020-07-24","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.64","nightly_discount":"0","subtotal":"160.64","grand_total":"180.72","paid_amount":"180.72","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1665067923","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":"101341","customer_id":"101341","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 22:17:07","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":"","currentDayPrice":"160.64","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3115684","reservation_id":"97738","confirmation_number":"SJ12685710016","room_stay_from":"2020-07-24","room_stay_to":"2020-07-26","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"163.84,163.84","nightly_discount":"0,0","subtotal":"327.68","grand_total":"368.64","paid_amount":"368.64","room_type_id":"413","product_id":"1272","siteminder_id":"EXP-1679224088","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":"103807","customer_id":"103807","source_of_creation":"Expedia","reservation_created_date":"2020-07-13 22:10:06","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":"","currentDayPrice":"163.84","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116356","reservation_id":"97811","confirmation_number":"SJ12664944560","room_stay_from":"2020-07-24","room_stay_to":"2020-07-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"229.12,229.12","nightly_discount":"0,0","subtotal":"458.24","grand_total":"515.52","paid_amount":"515.52","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1680007746","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":"103882","customer_id":"103882","source_of_creation":"Expedia","reservation_created_date":"2020-07-16 11:38:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"229.12","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118996","reservation_id":"98073","confirmation_number":"SJ12687847976","room_stay_from":"2020-07-24","room_stay_to":"2020-07-26","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"170.88,170.88","nightly_discount":"0,0","subtotal":"341.76","grand_total":"384.48","paid_amount":"384.48","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1682129013","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":"104142","customer_id":"104142","source_of_creation":"Expedia","reservation_created_date":"2020-07-23 02:35:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"170.88","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119243","reservation_id":"97739","confirmation_number":"SJ12671323592","room_stay_from":"2020-07-24","room_stay_to":"2020-07-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.84,163.84","nightly_discount":"0,0","subtotal":"327.68","grand_total":"368.64","paid_amount":"368.64","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1679225289","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":"103808","customer_id":"103808","source_of_creation":"Expedia","reservation_created_date":"2020-07-13 22:14:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"163.84","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119750","reservation_id":"98065","confirmation_number":"SJ12678375745","room_stay_from":"2020-07-24","room_stay_to":"2020-07-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"205.44,205.44","nightly_discount":"0,0","subtotal":"410.88","grand_total":"462.24","paid_amount":"462.24","room_type_id":"319","product_id":"1310","siteminder_id":"EXP-1682061740","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":"104132","customer_id":"104132","source_of_creation":"Expedia","reservation_created_date":"2020-07-22 22:40:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"82.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"205.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":"3116754","reservation_id":"95003","confirmation_number":"SJ12677057928","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.72,91.52,91.52,78.72","nightly_discount":"0,0,0,0","subtotal":"340.48","grand_total":"383.04","paid_amount":"383.04","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1664734816","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":"101196","customer_id":"101196","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 00:21:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.52","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119316","reservation_id":"95004","confirmation_number":"SJ12640169917","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.72,91.52,91.52,78.72","nightly_discount":"0,0,0,0","subtotal":"340.48","grand_total":"383.04","paid_amount":"383.04","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1664737422","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":"101197","customer_id":"101197","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 00:37:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.52","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3117895","reservation_id":"95157","confirmation_number":"SJ12679746112","room_stay_from":"2020-07-20","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.55,122.55,142.55,142.55,142.55","nightly_discount":"0.00,0.00,0.00,0,0","subtotal":"672.75","grand_total":"756.85","paid_amount":"756.85","room_type_id":"413","product_id":"1268","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"86804","customer_id":"86804","source_of_creation":"FE","reservation_created_date":"2020-05-20 21:36:34","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"142.55","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":"3119023","reservation_id":"97945","confirmation_number":"SJ12679053577","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.12,251.20","nightly_discount":"0.00,0.00","subtotal":"410.32","grand_total":"461.61","paid_amount":"461.61","room_type_id":"412","product_id":"1294","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":"104013","customer_id":"104013","source_of_creation":"FE","reservation_created_date":"2020-07-19 13:54:23","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":"","currentDayPrice":"251.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117837","reservation_id":"97598","confirmation_number":"SJ12678409956","room_stay_from":"2020-07-23","room_stay_to":"2020-07-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.50,290.00,290.00","nightly_discount":"0.00,0.00,0.00","subtotal":"758.50","grand_total":"853.32","paid_amount":"853.32","room_type_id":"319","product_id":"1309","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":"103678","customer_id":"103678","source_of_creation":"FE","reservation_created_date":"2020-07-10 00:30:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"290.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":"3114178","reservation_id":"97466","confirmation_number":"SJ12675924202","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"290.00,290.00,178.50,178.50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"937.00","grand_total":"1054.13","paid_amount":"1054.13","room_type_id":"319","product_id":"1303","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":"103545","customer_id":"103545","source_of_creation":"FE","reservation_created_date":"2020-07-06 23:49:00","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"290.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3100255","reservation_id":"95803","confirmation_number":"SJ12660150713","room_stay_from":"2020-07-22","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.39,164.90,220.58","nightly_discount":"0.00,0.00,0.00","subtotal":"528.87","grand_total":"594.98","paid_amount":"594.98","room_type_id":"413","product_id":"1267","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87380","customer_id":"87380","source_of_creation":"PMS","reservation_created_date":"2020-06-02 15:28:22","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"220.58","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108746","reservation_id":"96946","confirmation_number":"SJ12684548331","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"156.65,228.88","nightly_discount":"0.00,0.00","subtotal":"385.53","grand_total":"433.72","paid_amount":"433.72","room_type_id":"413","product_id":"1270","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":"103070","customer_id":"103070","source_of_creation":"PMS","reservation_created_date":"2020-06-22 18:21:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"228.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117380","reservation_id":"97910","confirmation_number":"SJ12639285784","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"125.12,211.20","nightly_discount":"0.00,0.00","subtotal":"336.32","grand_total":"378.36","paid_amount":"378.36","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":"103978","customer_id":"103978","source_of_creation":"PMS","reservation_created_date":"2020-07-18 14:27:05","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":"","currentDayPrice":"211.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117898","reservation_id":"96950","confirmation_number":"SJ12678092206","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"156.65,228.88","nightly_discount":"0.00,0.00","subtotal":"385.53","grand_total":"433.72","paid_amount":"433.72","room_type_id":"413","product_id":"1266","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":"103074","customer_id":"103074","source_of_creation":"PMS","reservation_created_date":"2020-06-22 18:54:04","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":"","currentDayPrice":"228.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119365","reservation_id":"95901","confirmation_number":"SJ12633597316","room_stay_from":"2020-07-24","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.55","nightly_discount":"0.00","subtotal":"230.55","grand_total":"259.37","paid_amount":"259.37","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85026","customer_id":"85026","source_of_creation":"PMS","reservation_created_date":"2020-06-04 15:27:42","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"230.55","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119748","reservation_id":"95308","confirmation_number":"SJ12690243415","room_stay_from":"2020-07-24","room_stay_to":"2020-07-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.00","nightly_discount":"0.00","subtotal":"155.00","grand_total":"174.38","paid_amount":"0.00","room_type_id":"319","product_id":"1302","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":"101495","customer_id":"101495","source_of_creation":"PMS","reservation_created_date":"2020-05-23 21:40:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"155.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":"3117506","reservation_id":"97917","confirmation_number":"SJ12635826040","room_stay_from":"2020-07-24","room_stay_to":"2020-07-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.20,279.20","nightly_discount":"0.00,0.00","subtotal":"558.40","grand_total":"628.20","paid_amount":"628.20","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103988","customer_id":"103988","source_of_creation":"PMS","reservation_created_date":"2020-07-18 18:50:59","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":"","currentDayPrice":"279.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117502","reservation_id":"97920","confirmation_number":"SJ12663196097","room_stay_from":"2020-07-24","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"256.80,256.80,163.88","nightly_discount":"0.00,0.00,0.00","subtotal":"677.48","grand_total":"762.16","paid_amount":"762.16","room_type_id":"412","product_id":"1316","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103988","customer_id":"103988","source_of_creation":"PMS","reservation_created_date":"2020-07-18 19:16:01","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":"","currentDayPrice":"256.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116839","reservation_id":"97853","confirmation_number":"SJ12620030798","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"295.12,411.20,411.20,295.12,295.12","nightly_discount":"29.50,41.12,41.12,29.50,29.50","subtotal":"1707.76","grand_total":"1729.15","paid_amount":"1729.15","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":"103919","customer_id":"103919","source_of_creation":"PMS","reservation_created_date":"2020-07-17 11:26:45","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":"","currentDayPrice":"411.20","currentDayDiscount":"41.12","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118654","reservation_id":"97846","confirmation_number":"SJ12639459090","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"295.12,411.20,411.20,295.12,295.12","nightly_discount":"29.50,41.12,41.12,29.50,29.50","subtotal":"1707.76","grand_total":"1729.15","paid_amount":"1729.15","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":"103914","customer_id":"103914","source_of_creation":"PMS","reservation_created_date":"2020-07-17 00:55:37","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":"","currentDayPrice":"411.20","currentDayDiscount":"41.12","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117642","reservation_id":"97941","confirmation_number":"SJ12645743914","room_stay_from":"2020-07-24","room_stay_to":"2020-07-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"221.60,221.60,133.96,133.96,170.00,180.20,180.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1241.52","grand_total":"1396.71","paid_amount":"1396.71","room_type_id":"319","product_id":"1756","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":"104009","customer_id":"104009","source_of_creation":"PMS","reservation_created_date":"2020-07-19 01:19:45","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":"","currentDayPrice":"221.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3116730","reservation_id":"97429","confirmation_number":"SJ12665901478","room_stay_from":"2020-07-18","room_stay_to":"2020-07-25","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","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","room_type_id":"413","product_id":"1269","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-07-06 01:13:22","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.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":"3119413","reservation_id":"97022","confirmation_number":"SJ12690712901","room_stay_from":"2020-07-24","room_stay_to":"2020-07-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.71,125.71,125.71,125.71,125.72,125.72,125.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"880.00","paid_amount":"0.00","room_type_id":"319","product_id":"1308","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-24 00:56:51","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":"","currentDayPrice":"125.71","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"}]}],"negotiated_taxable":[{"room_stay_id":"3111525","reservation_id":"97282","confirmation_number":"SJ12679975597","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.44,84.44,84.44,84.44,84.44","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"422.20","grand_total":"474.98","paid_amount":"140.63","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-07-01 21:56:09","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":"","currentDayPrice":"84.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119250","reservation_id":"97199","confirmation_number":"SJ12655710304","room_stay_from":"2020-07-23","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.44,84.44,84.44,84.44,84.44","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"422.20","grand_total":"474.98","paid_amount":"140.63","room_type_id":"319","product_id":"1286","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-06-28 21:44:19","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":"","currentDayPrice":"84.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109026","reservation_id":"96710","confirmation_number":"SJ12674033126","room_stay_from":"2020-07-24","room_stay_to":"2020-07-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.44,84.44,84.44,84.44,84.44","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"422.20","grand_total":"474.98","paid_amount":"140.63","room_type_id":"319","product_id":"1311","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-06-17 16:34:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109029","reservation_id":"96711","confirmation_number":"SJ12611267945","room_stay_from":"2020-07-24","room_stay_to":"2020-07-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.44,84.44,84.44,84.44,84.44","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"422.20","grand_total":"474.98","paid_amount":"140.63","room_type_id":"319","product_id":"1312","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-06-17 16:40:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[{"room_stay_id":"3116608","reservation_id":"96596","confirmation_number":"SJ12637201830","room_stay_from":"2020-07-22","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.00","paid_amount":"0.00","room_type_id":"412","product_id":"1866","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 02:10:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.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":"3117381","reservation_id":"97910","confirmation_number":"SJ12642256014","room_confirmation_number":"SJ12639285784","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"103978","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-07-18 14:27:05","reservation_modified_date_time":"2020-07-18 14:27:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103978","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119290","reservation_id":"95093","confirmation_number":"SJ12630761123","room_confirmation_number":"SJ12642228518","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"101274","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-07-23 22:51:04","reservation_modified_date_time":"2020-07-23 22:51:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101274","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119358","reservation_id":"95095","confirmation_number":"SJ12636849305","room_confirmation_number":"SJ12664636390","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"101276","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-07-24 12:47:45","reservation_modified_date_time":"2020-07-24 12:47:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101276","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","changedComment":"Reservation created with partial past date","deltaChange":"50.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3114180","reservation_id":"97466","confirmation_number":"SJ12616041468","room_confirmation_number":"SJ12675924202","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"103545","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-07-09 17:27:30","reservation_modified_date_time":"2020-07-09 17:27:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103545","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3100257","reservation_id":"95803","confirmation_number":"SJ12666502676","room_confirmation_number":"SJ12660150713","room_stay_from":"2020-07-22","room_stay_to":"2020-07-25","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":"87380","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-02 15:28:22","reservation_modified_date_time":"2020-06-02 15:32:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87380","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108747","reservation_id":"96946","confirmation_number":"SJ12697543130","room_confirmation_number":"SJ12684548331","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","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":"103070","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-22 18:21:10","reservation_modified_date_time":"2020-06-22 18:21:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103070","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116732","reservation_id":"97429","confirmation_number":"SJ12625155325","room_confirmation_number":"SJ12665901478","room_stay_from":"2020-07-18","room_stay_to":"2020-07-25","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":"103516","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-06 01:13:22","reservation_modified_date_time":"2020-07-17 01:41:31","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117382","reservation_id":"97910","confirmation_number":"SJ12655386556","room_confirmation_number":"SJ12639285784","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","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":"103978","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-18 14:27:05","reservation_modified_date_time":"2020-07-18 14:27:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103978","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117460","reservation_id":"95005","confirmation_number":"SJ12630760262","room_confirmation_number":"SJ12696624914","room_stay_from":"2020-07-17","room_stay_to":"2020-07-25","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":"102619","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 00:37:09","reservation_modified_date_time":"2020-07-18 17:35:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101198","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117846","reservation_id":"97831","confirmation_number":"SJ12685617535","room_confirmation_number":"SJ12639864923","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"103904","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-16 21:03:09","reservation_modified_date_time":"2020-07-19 20:15:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103904","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.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":"3117897","reservation_id":"95157","confirmation_number":"SJ12623063876","room_confirmation_number":"SJ12679746112","room_stay_from":"2020-07-20","room_stay_to":"2020-07-25","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":"86804","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 21:36:34","reservation_modified_date_time":"2020-07-20 00:25:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86804","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117899","reservation_id":"96950","confirmation_number":"SJ12694779702","room_confirmation_number":"SJ12678092206","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","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":"103074","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-22 18:54:04","reservation_modified_date_time":"2020-07-20 00:25:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103074","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118567","reservation_id":"95160","confirmation_number":"SJ12673547333","room_confirmation_number":"SJ12692878132","room_stay_from":"2020-07-24","room_stay_to":"2020-07-25","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":"101341","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 22:17:07","reservation_modified_date_time":"2020-07-21 20:27:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101341","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119024","reservation_id":"97945","confirmation_number":"SJ12628142233","room_confirmation_number":"SJ12679053577","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","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":"104013","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-19 13:54:23","reservation_modified_date_time":"2020-07-23 13:15:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104013","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119366","reservation_id":"95901","confirmation_number":"SJ12628652592","room_confirmation_number":"SJ12633597316","room_stay_from":"2020-07-24","room_stay_to":"2020-07-25","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":"85026","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-04 15:27:42","reservation_modified_date_time":"2020-07-24 12:48:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85026","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119749","reservation_id":"95308","confirmation_number":"SJ12614409740","room_confirmation_number":"SJ12690243415","room_stay_from":"2020-07-24","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101495","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-23 21:40:10","reservation_modified_date_time":"2020-07-25 01:16:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101495","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3115685","reservation_id":"97738","confirmation_number":"SJ12644621220","room_confirmation_number":"SJ12685710016","room_stay_from":"2020-07-24","room_stay_to":"2020-07-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":"103807","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-13 22:10:06","reservation_modified_date_time":"2020-07-13 22:10:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103807","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116357","reservation_id":"97811","confirmation_number":"SJ12673909476","room_confirmation_number":"SJ12664944560","room_stay_from":"2020-07-24","room_stay_to":"2020-07-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":"103882","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-16 11:38:10","reservation_modified_date_time":"2020-07-16 11:38:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103882","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117507","reservation_id":"97917","confirmation_number":"SJ12652469277","room_confirmation_number":"SJ12635826040","room_stay_from":"2020-07-24","room_stay_to":"2020-07-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":"103988","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-18 18:50:59","reservation_modified_date_time":"2020-07-18 19:18:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103988","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117839","reservation_id":"97598","confirmation_number":"SJ12631714704","room_confirmation_number":"SJ12678409956","room_stay_from":"2020-07-23","room_stay_to":"2020-07-26","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":"103678","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-10 00:30:41","reservation_modified_date_time":"2020-07-19 19:48:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103678","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118997","reservation_id":"98073","confirmation_number":"SJ12683219384","room_confirmation_number":"SJ12687847976","room_stay_from":"2020-07-24","room_stay_to":"2020-07-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":"104142","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-23 02:35:09","reservation_modified_date_time":"2020-07-23 02:35:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104142","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119244","reservation_id":"97739","confirmation_number":"SJ12617407109","room_confirmation_number":"SJ12671323592","room_stay_from":"2020-07-24","room_stay_to":"2020-07-26","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"103808","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-13 22:14:05","reservation_modified_date_time":"2020-07-23 21:05:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103808","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.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":"3119751","reservation_id":"98065","confirmation_number":"SJ12658945785","room_confirmation_number":"SJ12678375745","room_stay_from":"2020-07-24","room_stay_to":"2020-07-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":"104132","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-22 22:40:08","reservation_modified_date_time":"2020-07-25 01:17:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104132","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116609","reservation_id":"96596","confirmation_number":"SJ12653186227","room_confirmation_number":"SJ12637201830","room_stay_from":"2020-07-22","room_stay_to":"2020-07-27","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":"102707","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 02:10:12","reservation_modified_date_time":"2020-07-16 20:41:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116756","reservation_id":"95003","confirmation_number":"SJ12691666835","room_confirmation_number":"SJ12677057928","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","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":"101196","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 00:21:09","reservation_modified_date_time":"2020-07-17 01:45:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101196","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117503","reservation_id":"97920","confirmation_number":"SJ12623689214","room_confirmation_number":"SJ12663196097","room_stay_from":"2020-07-24","room_stay_to":"2020-07-27","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":"103988","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-18 19:16:01","reservation_modified_date_time":"2020-07-18 19:16:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103988","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119291","reservation_id":"95093","confirmation_number":"SJ12693461394","room_confirmation_number":"SJ12642228518","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","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":"101274","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 01:28:15","reservation_modified_date_time":"2020-07-23 22:51:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101274","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119317","reservation_id":"95004","confirmation_number":"SJ12653785807","room_confirmation_number":"SJ12640169917","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","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":"101197","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 00:37:07","reservation_modified_date_time":"2020-07-23 23:39:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101197","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119359","reservation_id":"95095","confirmation_number":"SJ12643103331","room_confirmation_number":"SJ12664636390","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","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":"101276","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 01:32:12","reservation_modified_date_time":"2020-07-24 12:47:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101276","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3111526","reservation_id":"97282","confirmation_number":"SJ12668606718","room_confirmation_number":"SJ12679975597","room_stay_from":"2020-07-23","room_stay_to":"2020-07-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":"103375","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-01 21:56:09","reservation_modified_date_time":"2020-07-01 21:56:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3114181","reservation_id":"97466","confirmation_number":"SJ12654219319","room_confirmation_number":"SJ12675924202","room_stay_from":"2020-07-24","room_stay_to":"2020-07-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":"103545","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-06 23:49:00","reservation_modified_date_time":"2020-07-09 17:27:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103545","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116840","reservation_id":"97853","confirmation_number":"SJ12645710375","room_confirmation_number":"SJ12620030798","room_stay_from":"2020-07-23","room_stay_to":"2020-07-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":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"103919","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-17 11:26:45","reservation_modified_date_time":"2020-07-17 11:26:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103919","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118657","reservation_id":"97846","confirmation_number":"SJ12652574952","room_confirmation_number":"SJ12639459090","room_stay_from":"2020-07-23","room_stay_to":"2020-07-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":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"103914","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-17 00:55:37","reservation_modified_date_time":"2020-07-21 22:00:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103914","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119251","reservation_id":"97199","confirmation_number":"SJ12695091303","room_confirmation_number":"SJ12655710304","room_stay_from":"2020-07-23","room_stay_to":"2020-07-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":"103300","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-28 21:44:20","reservation_modified_date_time":"2020-07-23 21:06:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119655","reservation_id":"97585","confirmation_number":"SJ12636425611","room_confirmation_number":"SJ12645665642","room_stay_from":"2020-07-24","room_stay_to":"2020-07-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"103661","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-09 19:29:07","reservation_modified_date_time":"2020-07-24 19:58:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103661","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109028","reservation_id":"96710","confirmation_number":"SJ12683393251","room_confirmation_number":"SJ12674033126","room_stay_from":"2020-07-24","room_stay_to":"2020-07-29","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":"102824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-17 16:34:14","reservation_modified_date_time":"2020-06-23 16:10:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3109030","reservation_id":"96711","confirmation_number":"SJ12651852339","room_confirmation_number":"SJ12611267945","room_stay_from":"2020-07-24","room_stay_to":"2020-07-29","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":"102824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-17 16:40:11","reservation_modified_date_time":"2020-06-23 16:11:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117643","reservation_id":"97941","confirmation_number":"SJ12612551353","room_confirmation_number":"SJ12645743914","room_stay_from":"2020-07-24","room_stay_to":"2020-07-31","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":"104009","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-19 01:19:45","reservation_modified_date_time":"2020-07-19 01:19:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104009","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119414","reservation_id":"97022","confirmation_number":"SJ12644558317","room_confirmation_number":"SJ12690712901","room_stay_from":"2020-07-24","room_stay_to":"2020-07-31","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":"103142","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-24 00:56:51","reservation_modified_date_time":"2020-07-24 12:53:08","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[{"room_stay_id":"3119498","reservation_id":"98125","confirmation_number":"SJ12618223354","room_confirmation_number":"SJ12658177396","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-24 16:30:52","reservation_modified_date_time":"2020-07-24 16:30:52","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}