{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-07-23","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":5,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1915,1261,1307,1943","block_room_bookings":[{"confirmation_number":"SJ12699552861","room_stay_from":"2020-07-23","room_stay_to":"2020-07-24","bundle_room":"0"},{"confirmation_number":"SJ12614704332","room_stay_from":"2020-07-23","room_stay_to":"2020-07-24","bundle_room":"0"},{"confirmation_number":"SJ12676533150","room_stay_from":"2020-07-11","room_stay_to":"2020-08-05","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-04","room_stay_to":"2020-09-01","bundle_room":"0"}],"bundle_block_count":"1260,1261,1271,1272,1302,1303,1267,1268,1269,1270,1309,1310,1262,1263,1291,1711,1304,1305,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12685383857","room_stay_from":"2020-07-21","room_stay_to":"2020-07-24","bundle_room":"1"},{"confirmation_number":"SJB12644285903","room_stay_from":"2020-07-21","room_stay_to":"2020-07-24","bundle_room":"1"},{"confirmation_number":"SJB12630511760","room_stay_from":"2020-07-23","room_stay_to":"2020-07-24","bundle_room":"0"},{"confirmation_number":"SJB12696119220","room_stay_from":"2020-07-23","room_stay_to":"2020-07-24","bundle_room":"0"},{"confirmation_number":"SJB12699512255","room_stay_from":"2020-07-22","room_stay_to":"2020-07-25","bundle_room":"1"},{"confirmation_number":"SJB12688812929","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","bundle_room":"1"},{"confirmation_number":"SJB12678863036","room_stay_from":"2020-07-23","room_stay_to":"2020-07-26","bundle_room":"1"},{"confirmation_number":"SJB12632559221","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","bundle_room":"1"},{"confirmation_number":"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"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3116666","reservation_id":"97658","confirmation_number":"SJ12689790755","room_stay_from":"2020-07-23","room_stay_to":"2020-07-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.40","nightly_discount":"0","subtotal":"138.40","grand_total":"155.70","paid_amount":"155.70","room_type_id":"413","product_id":"1272","siteminder_id":"BDC-3226594917","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":"103735","customer_id":"103735","source_of_creation":"Booking.com","reservation_created_date":"2020-07-11 18:39:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"29.41","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.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":"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":"48.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":"3119313","reservation_id":"95095","confirmation_number":"SJ12664636390","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","room_stay_status":"Active","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":"54.45","room_type_id":"319","product_id":"1313","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":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"94.61","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3094653","reservation_id":"94921","confirmation_number":"SJ12633883298","room_stay_from":"2020-07-21","room_stay_to":"2020-07-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.56,82.56,82.56","nightly_discount":"0,0,0","subtotal":"247.68","grand_total":"278.64","paid_amount":"278.64","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1664551350","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":"101112","customer_id":"101112","source_of_creation":"Expedia","reservation_created_date":"2020-05-17 22:41:05","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"82.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119076","reservation_id":"97806","confirmation_number":"SJ12682290535","room_stay_from":"2020-07-18","room_stay_to":"2020-07-24","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"205.44,139.52,139.52,139.52,139.52,139.52","nightly_discount":"0,0,0,0,0,0","subtotal":"903.04","grand_total":"1015.92","paid_amount":"1015.92","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1679905036","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":"103878","customer_id":"103878","source_of_creation":"Expedia","reservation_created_date":"2020-07-16 01:18:08","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"139.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":"3117461","reservation_id":"95005","confirmation_number":"SJ12696624914","room_stay_from":"2020-07-17","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.36,95.36,82.56,82.56,82.56,82.56,82.56,95.36","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"698.88","grand_total":"786.24","paid_amount":"786.24","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1664737254","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101198","customer_id":"101198","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 00:37:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"82.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117845","reservation_id":"97831","confirmation_number":"SJ12639864923","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"138.40,213.60","nightly_discount":"0,0","subtotal":"352.00","grand_total":"396.00","paid_amount":"396.00","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1680159108","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103904","customer_id":"103904","source_of_creation":"Expedia","reservation_created_date":"2020-07-16 21:03:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.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":"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":"78.72","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"78.72","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3117895","reservation_id":"95157","confirmation_number":"SJ12679746112","room_stay_from":"2020-07-20","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.55,122.55,142.55,142.55,142.55","nightly_discount":"0.00,0.00,0.00,0,0","subtotal":"672.75","grand_total":"756.85","paid_amount":"756.85","room_type_id":"413","product_id":"1268","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"86804","customer_id":"86804","source_of_creation":"FE","reservation_created_date":"2020-05-20 21:36:34","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"142.55","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119023","reservation_id":"97945","confirmation_number":"SJ12679053577","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.12,251.20","nightly_discount":"0.00,0.00","subtotal":"410.32","grand_total":"461.61","paid_amount":"461.61","room_type_id":"412","product_id":"1294","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104013","customer_id":"104013","source_of_creation":"FE","reservation_created_date":"2020-07-19 13:54:23","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"159.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117837","reservation_id":"97598","confirmation_number":"SJ12678409956","room_stay_from":"2020-07-23","room_stay_to":"2020-07-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.50,290.00,290.00","nightly_discount":"0.00,0.00,0.00","subtotal":"758.50","grand_total":"853.32","paid_amount":"853.32","room_type_id":"319","product_id":"1309","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103678","customer_id":"103678","source_of_creation":"FE","reservation_created_date":"2020-07-10 00:30:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"178.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":"3119245","reservation_id":"97670","confirmation_number":"SJ12669827674","room_stay_from":"2020-07-25","room_stay_to":"2020-07-30","room_stay_status":"Active","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":"261.00","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3113861","reservation_id":"97543","confirmation_number":"SJ12612018357","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,215.00,111.75,111.75,111.75,111.75,111.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"988.75","grand_total":"1112.35","paid_amount":"1112.35","room_type_id":"413","product_id":"1271","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":"103616","customer_id":"103616","source_of_creation":"PMS","reservation_created_date":"2020-07-08 18:07:25","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":"111.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117522","reservation_id":"97925","confirmation_number":"SJ12671417152","room_stay_from":"2020-07-23","room_stay_to":"2020-07-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"328.44","nightly_discount":"0.00","subtotal":"328.44","grand_total":"369.49","paid_amount":"369.49","room_type_id":"320","product_id":"1328","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103995","customer_id":"103995","source_of_creation":"PMS","reservation_created_date":"2020-07-18 20:19:23","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"328.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":"3119203","reservation_id":"98010","confirmation_number":"SJ12636381800","room_stay_from":"2020-07-23","room_stay_to":"2020-07-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"159.12","nightly_discount":"0.00","subtotal":"159.12","grand_total":"179.01","paid_amount":"179.01","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"103995","customer_id":"103995","source_of_creation":"PMS","reservation_created_date":"2020-07-21 15:26:09","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":"159.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119260","reservation_id":"95503","confirmation_number":"SJ12673054340","room_stay_from":"2020-07-23","room_stay_to":"2020-07-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.27","nightly_discount":"0.00","subtotal":"149.27","grand_total":"167.93","paid_amount":"167.93","room_type_id":"318","product_id":"1282","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":"101691","customer_id":"101691","source_of_creation":"PMS","reservation_created_date":"2020-05-27 19:14:01","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.27","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3100255","reservation_id":"95803","confirmation_number":"SJ12660150713","room_stay_from":"2020-07-22","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.39,164.90,220.58","nightly_discount":"0.00,0.00,0.00","subtotal":"528.87","grand_total":"594.98","paid_amount":"594.98","room_type_id":"413","product_id":"1267","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87380","customer_id":"87380","source_of_creation":"PMS","reservation_created_date":"2020-06-02 15:28:22","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"164.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108746","reservation_id":"96946","confirmation_number":"SJ12684548331","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"156.65,228.88","nightly_discount":"0.00,0.00","subtotal":"385.53","grand_total":"433.72","paid_amount":"433.72","room_type_id":"413","product_id":"1270","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103070","customer_id":"103070","source_of_creation":"PMS","reservation_created_date":"2020-06-22 18:21:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"156.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117380","reservation_id":"97910","confirmation_number":"SJ12639285784","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"125.12,211.20","nightly_discount":"0.00,0.00","subtotal":"336.32","grand_total":"378.36","paid_amount":"378.36","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103978","customer_id":"103978","source_of_creation":"PMS","reservation_created_date":"2020-07-18 14:27:05","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"125.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117898","reservation_id":"96950","confirmation_number":"SJ12678092206","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"156.65,228.88","nightly_discount":"0.00,0.00","subtotal":"385.53","grand_total":"433.72","paid_amount":"433.72","room_type_id":"413","product_id":"1266","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103074","customer_id":"103074","source_of_creation":"PMS","reservation_created_date":"2020-06-22 18:54:04","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"156.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"295.12","currentDayDiscount":"29.50","productIsTaxExempt":false,"taxes":[{"tax_id":"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":"295.12","currentDayDiscount":"29.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119132","reservation_id":"95502","confirmation_number":"SJ12663049071","room_stay_from":"2020-09-04","room_stay_to":"2020-09-10","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.16,123.16,105.16,105.16,105.16,105.16","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0","subtotal":"666.96","grand_total":"750.33","paid_amount":"138.56","room_type_id":"318","product_id":"1282","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":"82027","customer_id":"82027","source_of_creation":"PMS","reservation_created_date":"2020-05-27 18:55:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3116730","reservation_id":"97429","confirmation_number":"SJ12665901478","room_stay_from":"2020-07-18","room_stay_to":"2020-07-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"413","product_id":"1269","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-07-06 01:13:22","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"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"}]}],"negotiated_non_taxable":[{"room_stay_id":"3109865","reservation_id":"97090","confirmation_number":"SJ12623685175","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","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":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-26 00:13:36","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":"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":"3109867","reservation_id":"97091","confirmation_number":"SJ12693369595","room_stay_from":"2020-07-19","room_stay_to":"2020-07-24","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":"140.63","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-26 00:16:16","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":"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":"3112155","reservation_id":"96853","confirmation_number":"SJ12673840595","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","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":"1293","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-20 02:23:05","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":"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":"3116608","reservation_id":"96596","confirmation_number":"SJ12637201830","room_stay_from":"2020-07-22","room_stay_to":"2020-07-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.00","paid_amount":"0.00","room_type_id":"412","product_id":"1866","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-16 02:10:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3117381","reservation_id":"97910","confirmation_number":"SJ12642256014","room_confirmation_number":"SJ12639285784","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"103978","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-07-18 14:27:05","reservation_modified_date_time":"2020-07-18 14:27:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103978","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119290","reservation_id":"95093","confirmation_number":"SJ12630761123","room_confirmation_number":"SJ12642228518","room_stay_from":"2020-07-23","room_stay_to":"2020-07-27","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"101274","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-07-23 22:51:04","reservation_modified_date_time":"2020-07-23 22:51:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101274","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119314","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":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"101276","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-07-23 23:39:00","reservation_modified_date_time":"2020-07-23 23:39:00","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3094654","reservation_id":"94921","confirmation_number":"SJ12629234571","room_confirmation_number":"SJ12633883298","room_stay_from":"2020-07-21","room_stay_to":"2020-07-24","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":"101112","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-17 22:41:05","reservation_modified_date_time":"2020-05-17 22:41:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101112","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":"3109866","reservation_id":"97090","confirmation_number":"SJ12699029325","room_confirmation_number":"SJ12623685175","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","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":"103210","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 00:13:36","reservation_modified_date_time":"2020-06-26 00:13:36","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":"3109868","reservation_id":"97091","confirmation_number":"SJ12659687426","room_confirmation_number":"SJ12693369595","room_stay_from":"2020-07-19","room_stay_to":"2020-07-24","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":"103211","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 00:16:16","reservation_modified_date_time":"2020-06-26 00:16:16","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":"3112156","reservation_id":"96853","confirmation_number":"SJ12647401310","room_confirmation_number":"SJ12673840595","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","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":"102982","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-20 02:23:05","reservation_modified_date_time":"2020-07-03 16:33: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":"3113863","reservation_id":"97543","confirmation_number":"SJ12672171083","room_confirmation_number":"SJ12612018357","room_stay_from":"2020-07-17","room_stay_to":"2020-07-24","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":"103616","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-08 18:07:25","reservation_modified_date_time":"2020-07-08 18:17:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103616","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":"3116667","reservation_id":"97658","confirmation_number":"SJ12620231540","room_confirmation_number":"SJ12689790755","room_stay_from":"2020-07-23","room_stay_to":"2020-07-24","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":"103735","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-11 18:39:09","reservation_modified_date_time":"2020-07-16 22:20:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103735","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":"3117523","reservation_id":"97925","confirmation_number":"SJ12654346210","room_confirmation_number":"SJ12671417152","room_stay_from":"2020-07-23","room_stay_to":"2020-07-24","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":"103995","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-18 20:19:23","reservation_modified_date_time":"2020-07-18 20:19:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103995","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":"3119077","reservation_id":"97806","confirmation_number":"SJ12626230046","room_confirmation_number":"SJ12682290535","room_stay_from":"2020-07-18","room_stay_to":"2020-07-24","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":"103878","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-16 01:18:08","reservation_modified_date_time":"2020-07-23 16:08:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103878","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":"3119204","reservation_id":"98010","confirmation_number":"SJ12644945759","room_confirmation_number":"SJ12636381800","room_stay_from":"2020-07-23","room_stay_to":"2020-07-24","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":"103995","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-21 15:26:09","reservation_modified_date_time":"2020-07-23 19:26:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103995","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":"3119261","reservation_id":"95503","confirmation_number":"SJ12649184074","room_confirmation_number":"SJ12673054340","room_stay_from":"2020-07-23","room_stay_to":"2020-07-24","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101691","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 19:14:01","reservation_modified_date_time":"2020-07-23 21:38:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101691","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":"3100257","reservation_id":"95803","confirmation_number":"SJ12666502676","room_confirmation_number":"SJ12660150713","room_stay_from":"2020-07-22","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"87380","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-02 15:28:22","reservation_modified_date_time":"2020-06-02 15:32:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87380","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108747","reservation_id":"96946","confirmation_number":"SJ12697543130","room_confirmation_number":"SJ12684548331","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"103070","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-22 18:21:10","reservation_modified_date_time":"2020-06-22 18:21:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103070","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3116732","reservation_id":"97429","confirmation_number":"SJ12625155325","room_confirmation_number":"SJ12665901478","room_stay_from":"2020-07-18","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103516","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-06 01:13:22","reservation_modified_date_time":"2020-07-17 01:41:31","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117382","reservation_id":"97910","confirmation_number":"SJ12655386556","room_confirmation_number":"SJ12639285784","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"103978","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-18 14:27:05","reservation_modified_date_time":"2020-07-18 14:27:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103978","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117460","reservation_id":"95005","confirmation_number":"SJ12630760262","room_confirmation_number":"SJ12696624914","room_stay_from":"2020-07-17","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102619","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 00:37:09","reservation_modified_date_time":"2020-07-18 17:35:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101198","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117846","reservation_id":"97831","confirmation_number":"SJ12685617535","room_confirmation_number":"SJ12639864923","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"103904","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-16 21:03:09","reservation_modified_date_time":"2020-07-19 20:15:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103904","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117897","reservation_id":"95157","confirmation_number":"SJ12623063876","room_confirmation_number":"SJ12679746112","room_stay_from":"2020-07-20","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"86804","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 21:36:34","reservation_modified_date_time":"2020-07-20 00:25:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86804","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3117899","reservation_id":"96950","confirmation_number":"SJ12694779702","room_confirmation_number":"SJ12678092206","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"103074","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-22 18:54:04","reservation_modified_date_time":"2020-07-20 00:25:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103074","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119024","reservation_id":"97945","confirmation_number":"SJ12628142233","room_confirmation_number":"SJ12679053577","room_stay_from":"2020-07-23","room_stay_to":"2020-07-25","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"104013","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-19 13:54:23","reservation_modified_date_time":"2020-07-23 13:15:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104013","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"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":"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":"3119315","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":"0.00","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-23 23:39:01","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":"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":"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":"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":"3119133","reservation_id":"95502","confirmation_number":"SJ12683249058","room_confirmation_number":"SJ12663049071","room_stay_from":"2020-09-04","room_stay_to":"2020-09-10","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"82027","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 18:55:24","reservation_modified_date_time":"2020-07-23 17:17:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82027","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"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":"0.00","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[{"room_stay_id":"3119239","reservation_id":"96946","confirmation_number":"SJ12690516169","room_confirmation_number":"SJ12684548331","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-23 21:02:54","reservation_modified_date_time":"2020-07-23 21:02:54","customer_id":"103070","parentCustTravId":"103070","customer_traveller_id":"103070","static_pos_type":"drinks","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":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3119081","reservation_id":"98090","confirmation_number":"SJ12631038589","room_confirmation_number":"SJ12658921901","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-23 16:10:13","reservation_modified_date_time":"2020-07-23 16:10:13","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":"3.72","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":[]}}