{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-07-25","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":"1313,1307,1916,1943","block_room_bookings":[{"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":"SJ12674656130","room_stay_from":"2020-07-25","room_stay_to":"2020-08-08","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-04","room_stay_to":"2020-09-01","bundle_room":"0"}],"bundle_block_count":"1309,1310,1271,1272,1262,1263,1260,1261,1302,1303,1291,1711,1304,1305,1307,1308,1311,1312","bundle_block_bookings":[{"confirmation_number":"SJB12678863036","room_stay_from":"2020-07-23","room_stay_to":"2020-07-26","bundle_room":"1"},{"confirmation_number":"SJB12651248777","room_stay_from":"2020-07-25","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":"3118740","reservation_id":"98033","confirmation_number":"SJ12682648092","room_stay_from":"2020-07-25","room_stay_to":"2020-07-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.12","nightly_discount":"0","subtotal":"231.12","grand_total":"260.01","paid_amount":"260.01","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3610903058","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":"104099","customer_id":"104099","source_of_creation":"Booking.com","reservation_created_date":"2020-07-22 02:34:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"46.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"231.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":"3119708","reservation_id":"98136","confirmation_number":"SJ12654700253","room_stay_from":"2020-07-25","room_stay_to":"2020-07-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"213.60","nightly_discount":"0","subtotal":"213.60","grand_total":"240.30","paid_amount":"240.30","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-2282205035","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":"104209","customer_id":"104209","source_of_creation":"Booking.com","reservation_created_date":"2020-07-24 21:56:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"42.95","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":"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":"3119973","reservation_id":"98172","confirmation_number":"SJ12662272752","room_stay_from":"2020-07-25","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"286.40,200.00","nightly_discount":"0,0","subtotal":"486.40","grand_total":"547.20","paid_amount":"547.20","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-3409094298","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":"104238","customer_id":"104238","source_of_creation":"Booking.com","reservation_created_date":"2020-07-25 18:26:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"96.55","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"286.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":"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"}]},{"room_stay_id":"3119939","reservation_id":"98152","confirmation_number":"SJ12642248693","room_stay_from":"2020-07-25","room_stay_to":"2020-07-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.40,138.40,203.24","nightly_discount":"0.00,0.00,0.00","subtotal":"480.04","grand_total":"540.04","paid_amount":"540.04","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2449827342","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":"104229","customer_id":"104229","source_of_creation":"Booking.com","reservation_created_date":"2020-07-25 14:44:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"58.82","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3113363","reservation_id":"93587","confirmation_number":"SJ12696472420","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"247.20,119.20,119.20,186.40,186.40,191.20,151.20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1200.80","grand_total":"1350.90","paid_amount":"1350.90","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3169083708","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":"99816","customer_id":"99816","source_of_creation":"Booking.com","reservation_created_date":"2020-03-24 21:57:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"247.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"247.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":"3119906","reservation_id":"96753","confirmation_number":"SJ12662071440","room_stay_from":"2020-07-31","room_stay_to":"2020-08-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"243.20,153.00","nightly_discount":"0.00,0.00","subtotal":"396.20","grand_total":"445.73","paid_amount":"273.60","room_type_id":"319","product_id":"1304","siteminder_id":"BDC-2625169346","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":"102871","customer_id":"102871","source_of_creation":"Booking.com","reservation_created_date":"2020-06-18 13:59:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"80.31","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"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":"3118996","reservation_id":"98073","confirmation_number":"SJ12687847976","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":"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":"3119062","reservation_id":"98085","confirmation_number":"SJ12681857968","room_stay_from":"2020-07-25","room_stay_to":"2020-07-26","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"237.44","nightly_discount":"0","subtotal":"237.44","grand_total":"267.12","paid_amount":"267.12","room_type_id":"319","product_id":"1302","siteminder_id":"EXP-1682271931","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104155","customer_id":"104155","source_of_creation":"Expedia","reservation_created_date":"2020-07-23 15:40:12","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":"237.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":"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":"3119258","reservation_id":"95012","confirmation_number":"SJ12652680590","room_stay_from":"2020-07-25","room_stay_to":"2020-07-27","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,103.20","nightly_discount":"0,0","subtotal":"222.40","grand_total":"250.20","paid_amount":"0.00","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1664749272","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":"101203","customer_id":"101203","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 01:46:10","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":"119.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":"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"}]},{"room_stay_id":"3119946","reservation_id":"97811","confirmation_number":"SJ12664944560","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,182.92","nightly_discount":"0.00,0.00,0.00","subtotal":"696.52","grand_total":"783.59","paid_amount":"783.59","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":"","changedComment":"To date changed","deltaChange":"27.68","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":"3120010","reservation_id":"97998","confirmation_number":"SJ12682072401","room_stay_from":"2020-07-25","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"221.44,155.52","nightly_discount":"0.00,0.00","subtotal":"376.96","grand_total":"424.08","paid_amount":"424.08","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1681427229","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":"104067","customer_id":"104067","source_of_creation":"Expedia","reservation_created_date":"2020-07-21 00:28:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"221.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":"3119530","reservation_id":"91368","confirmation_number":"SJ12617390124","room_stay_from":"2020-07-25","room_stay_to":"2020-07-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"243.20,184.00,166.40,166.40,166.40,171.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1097.60","grand_total":"1234.80","paid_amount":"1234.80","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1636094352","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":"97495","customer_id":"97495","source_of_creation":"Expedia","reservation_created_date":"2020-02-05 18:48:10","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":"243.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"}]}],"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":"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"}]},{"room_stay_id":"3119245","reservation_id":"97670","confirmation_number":"SJ12669827674","room_stay_from":"2020-07-25","room_stay_to":"2020-07-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"232.00,142.80,142.80,191.25,191.25","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"900.10","grand_total":"1012.62","paid_amount":"1012.62","room_type_id":"319","product_id":"1274","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":"103746","customer_id":"103746","source_of_creation":"FE","reservation_created_date":"2020-07-11 20:36:37","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":"","currentDayPrice":"232.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":"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":"3119950","reservation_id":"98171","confirmation_number":"SJ12694111840","room_stay_from":"2020-07-25","room_stay_to":"2020-07-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.20","nightly_discount":"45.10","subtotal":"251.20","grand_total":"231.87","paid_amount":"231.87","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104237","customer_id":"104237","source_of_creation":"PMS","reservation_created_date":"2020-07-25 18:09:28","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":"","currentDayPrice":"251.20","currentDayDiscount":"45.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":"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":"3119349","reservation_id":"98115","confirmation_number":"SJ12673936438","room_stay_from":"2020-07-25","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"211.20,125.12","nightly_discount":"0.00,0.00","subtotal":"336.32","grand_total":"378.36","paid_amount":"378.36","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":"104185","customer_id":"104185","source_of_creation":"PMS","reservation_created_date":"2020-07-24 12:12:52","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":"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":"3119504","reservation_id":"98127","confirmation_number":"SJ12646648378","room_stay_from":"2020-07-25","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.20,159.12","nightly_discount":"0.00,0.00","subtotal":"410.32","grand_total":"461.61","paid_amount":"461.61","room_type_id":"319","product_id":"1917","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":"104196","customer_id":"104196","source_of_creation":"PMS","reservation_created_date":"2020-07-24 17:16:42","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3119942","reservation_id":"98169","confirmation_number":"SJ12626149083","room_stay_from":"2020-07-25","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.20,182.92","nightly_discount":"27.90,18.29","subtotal":"462.12","grand_total":"467.92","paid_amount":"467.92","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104236","customer_id":"104236","source_of_creation":"PMS","reservation_created_date":"2020-07-25 18:04:27","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":"279.20","currentDayDiscount":"27.90","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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"}]},{"room_stay_id":"3105741","reservation_id":"96540","confirmation_number":"SJ12648416794","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.72,125.72,125.72,125.71,125.71,125.71,125.71","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"990.00","paid_amount":"0.00","room_type_id":"319","product_id":"1319","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":"84637","customer_id":"84637","source_of_creation":"PMS","reservation_created_date":"2020-06-15 15:05:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"125.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119927","reservation_id":"97689","confirmation_number":"SJ12668652431","room_stay_from":"2020-07-25","room_stay_to":"2020-08-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"221.60,133.96,133.96,180.20,180.20,180.20,277.00,277.00,144.16","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1728.28","grand_total":"1944.31","paid_amount":"1944.31","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":"103760","customer_id":"103760","source_of_creation":"PMS","reservation_created_date":"2020-07-12 12:33:42","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":"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"}]},{"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":"Canceled","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","service_canceled_date_time":"2020-07-25 18:26:51","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"room_dates_changed","total_paid_amount":"0.00","deltaChange":-155,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"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"}]},{"room_stay_id":"3114387","reservation_id":"97118","confirmation_number":"SJ12648875545","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"319","product_id":"1301","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-26 17:53:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]}],"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"}]},{"room_stay_id":"3105999","reservation_id":"96588","confirmation_number":"SJ12693034191","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"319","product_id":"1913","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 01:36:52","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":"77.86","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":"3106004","reservation_id":"96589","confirmation_number":"SJ12655511190","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 01:38:33","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":"","currentDayPrice":"77.86","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":"3119063","reservation_id":"98085","confirmation_number":"SJ12634546376","room_confirmation_number":"SJ12681857968","room_stay_from":"2020-07-25","room_stay_to":"2020-07-26","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"104155","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-07-23 15:40:12","reservation_modified_date_time":"2020-07-23 15:40:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104155","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"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","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":"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":"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":"3118741","reservation_id":"98033","confirmation_number":"SJ12697968998","room_confirmation_number":"SJ12682648092","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104099","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-22 02:34:09","reservation_modified_date_time":"2020-07-22 13:00:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104099","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":"3119064","reservation_id":"98085","confirmation_number":"SJ12642690183","room_confirmation_number":"SJ12681857968","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104155","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-23 15:40:12","reservation_modified_date_time":"2020-07-23 15:40:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104155","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"3119709","reservation_id":"98136","confirmation_number":"SJ12617327756","room_confirmation_number":"SJ12654700253","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104209","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-24 21:56:10","reservation_modified_date_time":"2020-07-24 21:56:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104209","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":"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":"3119951","reservation_id":"98171","confirmation_number":"SJ12662694220","room_confirmation_number":"SJ12694111840","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104237","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-25 18:09:28","reservation_modified_date_time":"2020-07-25 18:09:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104237","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":"3119259","reservation_id":"95012","confirmation_number":"SJ12621976071","room_confirmation_number":"SJ12652680590","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101203","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 01:46:10","reservation_modified_date_time":"2020-07-23 21:37:27","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101203","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":"3119350","reservation_id":"98115","confirmation_number":"SJ12684413366","room_confirmation_number":"SJ12673936438","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104185","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-24 12:12:52","reservation_modified_date_time":"2020-07-24 12:12:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104185","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":"3119505","reservation_id":"98127","confirmation_number":"SJ12628910829","room_confirmation_number":"SJ12646648378","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104196","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-24 17:16:42","reservation_modified_date_time":"2020-07-24 17:16:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104196","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":"3119943","reservation_id":"98169","confirmation_number":"SJ12629438636","room_confirmation_number":"SJ12626149083","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-25 18:04:27","reservation_modified_date_time":"2020-07-25 18:04:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104236","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":"3119947","reservation_id":"97811","confirmation_number":"SJ12673909476","room_confirmation_number":"SJ12664944560","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":"103882","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-16 11:38:10","reservation_modified_date_time":"2020-07-25 18:07:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103882","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119974","reservation_id":"98172","confirmation_number":"SJ12697935248","room_confirmation_number":"SJ12662272752","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104238","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-25 18:26:12","reservation_modified_date_time":"2020-07-25 18:26:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104238","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":"3120012","reservation_id":"97998","confirmation_number":"SJ12682072402","room_confirmation_number":"SJ12682072401","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104067","product_attribute_values":"resort_fee#&#flat_rate#&#25.00","reservation_created_date":"2020-07-21 00:28:09","reservation_modified_date_time":"2020-07-25 20:28:49","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104067","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":"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":"3119940","reservation_id":"98152","confirmation_number":"SJ12682149766","room_confirmation_number":"SJ12642248693","room_stay_from":"2020-07-25","room_stay_to":"2020-07-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":"104229","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-25 14:44:11","reservation_modified_date_time":"2020-07-25 17:49:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104229","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":"3119249","reservation_id":"97670","confirmation_number":"SJ12670607075","room_confirmation_number":"SJ12669827674","room_stay_from":"2020-07-25","room_stay_to":"2020-07-30","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":"103746","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-11 20:36:37","reservation_modified_date_time":"2020-07-23 21:05:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103746","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"}]},{"room_stay_id":"3119531","reservation_id":"91368","confirmation_number":"SJ12637207607","room_confirmation_number":"SJ12617390124","room_stay_from":"2020-07-25","room_stay_to":"2020-07-31","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":"97495","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-05 18:48:10","reservation_modified_date_time":"2020-07-24 17:38:29","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97495","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":"3105742","reservation_id":"96540","confirmation_number":"SJ12647498418","room_confirmation_number":"SJ12648416794","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"102647","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 15:05:07","reservation_modified_date_time":"2020-06-15 15:05:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84637","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":"3106000","reservation_id":"96588","confirmation_number":"SJ12686722107","room_confirmation_number":"SJ12693034191","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"102702","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:36:52","reservation_modified_date_time":"2020-06-16 01:36:52","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":"3106005","reservation_id":"96589","confirmation_number":"SJ12684164813","room_confirmation_number":"SJ12655511190","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"102703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:38:33","reservation_modified_date_time":"2020-06-16 01:38:33","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":"3113367","reservation_id":"93587","confirmation_number":"SJ12637257008","room_confirmation_number":"SJ12696472420","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"99816","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-24 21:57:09","reservation_modified_date_time":"2020-07-06 20:53:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99816","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":"3114388","reservation_id":"97118","confirmation_number":"SJ12643657961","room_confirmation_number":"SJ12648875545","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"103236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 17:53:20","reservation_modified_date_time":"2020-07-10 01:05:11","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":"3119928","reservation_id":"97689","confirmation_number":"SJ12613152976","room_confirmation_number":"SJ12668652431","room_stay_from":"2020-07-25","room_stay_to":"2020-08-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"103760","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-12 12:33:42","reservation_modified_date_time":"2020-07-25 17:33:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103760","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":"3119908","reservation_id":"96753","confirmation_number":"SJ12611260706","room_confirmation_number":"SJ12662071440","room_stay_from":"2020-07-31","room_stay_to":"2020-08-02","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102871","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 13:59:14","reservation_modified_date_time":"2020-07-25 17:15:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102871","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3120011","reservation_id":"97998","confirmation_number":"SJ12636357187","room_confirmation_number":"SJ12682072401","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"50.00","grand_total":"53.75","paid_amount":"53.75","product_id":"1704","service_quantity":"1","product_name":"Pet Penalty","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-25 20:28:41","reservation_modified_date_time":"2020-07-25 20:28:49","customer_id":"104067","parentCustTravId":"104067","customer_traveller_id":"104067","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3119862","reservation_id":"98154","confirmation_number":"SJ12647848139","room_confirmation_number":"SJ12620539629","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"15.00","paid_amount":"15.00","product_id":null,"service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-25 15:12:41","reservation_modified_date_time":"2020-07-25 15:12:41","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"13.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3119863","reservation_id":"98154","confirmation_number":"SJ12648164955","room_confirmation_number":"SJ12620539629","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"27.91","grand_total":"30.00","paid_amount":"30.00","product_id":null,"service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-25 15:12:41","reservation_modified_date_time":"2020-07-25 15:12:41","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"27.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3119872","reservation_id":"98157","confirmation_number":"SJ12634397837","room_confirmation_number":"SJ12673501915","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"27.91","grand_total":"30.00","paid_amount":"30.00","product_id":null,"service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-25 15:24:45","reservation_modified_date_time":"2020-07-25 15:24:45","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"27.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3119874","reservation_id":"98158","confirmation_number":"SJ12666827307","room_confirmation_number":"SJ12681032160","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"15.00","paid_amount":"15.00","product_id":null,"service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-25 15:27:22","reservation_modified_date_time":"2020-07-25 15:27:22","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"13.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3119994","reservation_id":"98178","confirmation_number":"SJ12692304589","room_confirmation_number":"SJ12645727143","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"15.00","paid_amount":"15.00","product_id":null,"service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-25 19:58:05","reservation_modified_date_time":"2020-07-25 19:58:05","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"13.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[{"room_stay_id":"3119995","reservation_id":"98178","confirmation_number":"SJ12698295598","room_confirmation_number":"SJ12645727143","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":"44.00","paid_amount":"44.00","product_id":null,"service_quantity":"11","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-25 19:58:05","reservation_modified_date_time":"2020-07-25 19:58:05","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":"40.92","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3120094","reservation_id":"98197","confirmation_number":"SJ12639757734","room_confirmation_number":"SJ12610287527","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":"12.00","paid_amount":"12.00","product_id":null,"service_quantity":"3","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-26 01:55:57","reservation_modified_date_time":"2020-07-26 01:55:57","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":"11.16","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":[]}}