{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-08-01","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":16,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1915,1307","block_room_bookings":[{"confirmation_number":"SJ12687148651","room_stay_from":"2020-07-31","room_stay_to":"2020-08-05","bundle_room":"0"},{"confirmation_number":"SJ12676533150","room_stay_from":"2020-07-31","room_stay_to":"2020-08-15","bundle_room":"0"}],"bundle_block_count":"1267,1268,1311,1312,1262,1263,1302,1303,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12679187448","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","bundle_room":"1"},{"confirmation_number":"SJB12632608652","room_stay_from":"2020-07-30","room_stay_to":"2020-08-02","bundle_room":"1"},{"confirmation_number":"SJB12656611283","room_stay_from":"2020-07-31","room_stay_to":"2020-08-02","bundle_room":"1"},{"confirmation_number":"SJB12683029700","room_stay_from":"2020-08-01","room_stay_to":"2020-08-02","bundle_room":"1"},{"confirmation_number":"SJB12667137547","room_stay_from":"2020-07-31","room_stay_to":"2020-08-05","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3120914","reservation_id":"96753","confirmation_number":"SJ12662071440","room_stay_from":"2020-07-31","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","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":"445.73","room_type_id":"413","product_id":"1262","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":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"80.31","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"153.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":"3120918","reservation_id":"96753","confirmation_number":"SJ12667801643","room_stay_from":"2020-07-31","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"243.20,153.00","nightly_discount":"0,0","subtotal":"396.20","grand_total":"445.73","paid_amount":"445.73","room_type_id":"413","product_id":"1263","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:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"160.63","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"153.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3119916","reservation_id":"95886","confirmation_number":"SJ12613318392","room_stay_from":"2020-07-30","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"163.20,188.16,91.52","nightly_discount":"0,0,0","subtotal":"442.88","grand_total":"498.24","paid_amount":"498.24","room_type_id":"319","product_id":"1311","siteminder_id":"EXP-1667883420","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":"102038","customer_id":"102038","source_of_creation":"Expedia","reservation_created_date":"2020-06-04 01:01:06","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":"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":"3122470","reservation_id":"94440","confirmation_number":"SJ12651530268","room_stay_from":"2020-07-28","room_stay_to":"2020-08-01","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"170.40,170.40,175.20,374.40","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"890.40","grand_total":"1001.70","paid_amount":"1029.83","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1662881840","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":"100657","customer_id":"100657","source_of_creation":"Expedia","reservation_created_date":"2020-05-05 11:57:06","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":"","changedComment":"To date changed","deltaChange":"187.20","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"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":"3122064","reservation_id":"95553","confirmation_number":"SJ12663806196","room_stay_from":"2020-07-31","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.00,152.10","nightly_discount":"0.00,0.00","subtotal":"413.10","grand_total":"464.74","paid_amount":"464.74","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":"101735","customer_id":"101735","source_of_creation":"FE","reservation_created_date":"2020-05-28 18:16:25","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":"152.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120881","reservation_id":"95429","confirmation_number":"SJ12646568195","room_stay_from":"2020-07-31","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"249.50,145.39,145.39,127.39","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"667.67","grand_total":"751.13","paid_amount":"751.13","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":"101618","customer_id":"101618","source_of_creation":"FE","reservation_created_date":"2020-05-26 17:25:25","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":"145.39","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3122624","reservation_id":"91985","confirmation_number":"SJ12651278650","room_stay_from":"2020-07-28","room_stay_to":"2020-08-01","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"193.00,193.00,199.00,428.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1013.00","grand_total":"1139.63","paid_amount":"1167.76","room_type_id":"412","product_id":"1866","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":"98138","customer_id":"98138","source_of_creation":"FE","reservation_created_date":"2020-02-14 21:26:06","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":"","changedComment":"To date changed","deltaChange":"214.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":"3122598","reservation_id":"98475","confirmation_number":"SJ12673777403","room_stay_from":"2020-08-01","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.00","nightly_discount":"0.00","subtotal":"198.00","grand_total":"222.75","paid_amount":"222.75","room_type_id":"413","product_id":"1273","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":"104499","customer_id":"104499","source_of_creation":"PMS","reservation_created_date":"2020-08-01 19:01:01","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":"198.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":"3119927","reservation_id":"97689","confirmation_number":"SJ12668652431","room_stay_from":"2020-07-25","room_stay_to":"2020-08-03","room_stay_status":"Checked-Out","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":"277.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":"3120304","reservation_id":"97825","confirmation_number":"SJ12666215686","room_stay_from":"2020-07-30","room_stay_to":"2020-08-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.00,290.00,290.00,153.00","nightly_discount":"21.10,0.00,0.00,0.00","subtotal":"944.00","grand_total":"1038.27","paid_amount":"1038.27","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":"84865","customer_id":"84865","source_of_creation":"PMS","reservation_created_date":"2020-07-16 19:27:15","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":"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":"3121916","reservation_id":"98285","confirmation_number":"SJ12691641913","room_stay_from":"2020-07-31","room_stay_to":"2020-08-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"245.00,245.00,122.40","nightly_discount":"0.00,0.00,0.00","subtotal":"612.40","grand_total":"688.95","paid_amount":"688.95","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":"104325","customer_id":"104325","source_of_creation":"PMS","reservation_created_date":"2020-07-28 18:23:40","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":"245.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":"3122414","reservation_id":"98451","confirmation_number":"SJ12655435116","room_stay_from":"2020-08-01","room_stay_to":"2020-08-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.16,135.85","nightly_discount":"22.61,13.58","subtotal":"362.01","grand_total":"366.55","paid_amount":"366.55","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":"104471","customer_id":"104471","source_of_creation":"PMS","reservation_created_date":"2020-08-01 01:02:17","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":"226.16","currentDayDiscount":"22.61","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[{"room_stay_id":"3115080","reservation_id":"95815","confirmation_number":"SJ12638681997","room_stay_from":"2020-07-31","room_stay_to":"2020-08-07","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":"1756","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-02 18:17:24","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":"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":"3107838","reservation_id":"83912","confirmation_number":"SJ12695888446","room_stay_from":"2020-07-31","room_stay_to":"2020-08-07","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.83,76.83,76.83,76.83,76.83,76.83,76.83","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"537.81","grand_total":"605.04","paid_amount":"0.00","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":"2019-09-11 12:32:37","service_canceled_date_time":"2020-08-01 14:05:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"room_dates_changed","total_paid_amount":"0.00","deltaChange":-76.83,"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"}]}],"negotiated_non_taxable":[{"room_stay_id":"3107011","reservation_id":"96590","confirmation_number":"SJ12696030417","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","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":"1267","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:39:59","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":"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":"3107020","reservation_id":"96591","confirmation_number":"SJ12644077479","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","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":"1268","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:44:03","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":"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":"3121789","reservation_id":"98385","confirmation_number":"SJ12624245050","room_stay_from":"2020-07-30","room_stay_to":"2020-08-04","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":"319","product_id":"1917","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-07-30 20:06:08","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":"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":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3107014","reservation_id":"96590","confirmation_number":"SJ12626622188","room_confirmation_number":"SJ12696030417","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","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":"102704","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:39:59","reservation_modified_date_time":"2020-06-18 12:41:46","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":"3107022","reservation_id":"96591","confirmation_number":"SJ12624927899","room_confirmation_number":"SJ12644077479","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","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":"102704","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:44:03","reservation_modified_date_time":"2020-06-18 12:45:58","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":"3119918","reservation_id":"95886","confirmation_number":"SJ12687071353","room_confirmation_number":"SJ12613318392","room_stay_from":"2020-07-30","room_stay_to":"2020-08-02","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":"102038","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-04 01:01:06","reservation_modified_date_time":"2020-07-25 17:31:34","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102038","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":"3120917","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":"56.25","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-28 12:07:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102871","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":"3120919","reservation_id":"96753","confirmation_number":"SJ12641418680","room_confirmation_number":"SJ12667801643","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":"56.25","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:10","reservation_modified_date_time":"2020-07-28 12:07:44","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102871","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":"3122066","reservation_id":"95553","confirmation_number":"SJ12625091852","room_confirmation_number":"SJ12663806196","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":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"101735","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 18:16:25","reservation_modified_date_time":"2020-07-31 16:57:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101735","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":"3122599","reservation_id":"98475","confirmation_number":"SJ12615291609","room_confirmation_number":"SJ12673777403","room_stay_from":"2020-08-01","room_stay_to":"2020-08-02","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":"104499","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-01 19:01:01","reservation_modified_date_time":"2020-08-01 19:01:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104499","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":"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":"3120305","reservation_id":"97825","confirmation_number":"SJ12611917303","room_confirmation_number":"SJ12666215686","room_stay_from":"2020-07-30","room_stay_to":"2020-08-03","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":"84865","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-16 19:27:15","reservation_modified_date_time":"2020-07-26 16:28:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84865","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":"3121917","reservation_id":"98285","confirmation_number":"SJ12632814566","room_confirmation_number":"SJ12691641913","room_stay_from":"2020-07-31","room_stay_to":"2020-08-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"104325","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-28 18:23:40","reservation_modified_date_time":"2020-07-31 13:08:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104325","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":"3122415","reservation_id":"98451","confirmation_number":"SJ12655467632","room_confirmation_number":"SJ12655435116","room_stay_from":"2020-08-01","room_stay_to":"2020-08-03","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":"104471","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-01 01:02:17","reservation_modified_date_time":"2020-08-01 01:02:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104471","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":"3120883","reservation_id":"95429","confirmation_number":"SJ12615529036","room_confirmation_number":"SJ12646568195","room_stay_from":"2020-07-31","room_stay_to":"2020-08-04","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":"101618","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 17:25:25","reservation_modified_date_time":"2020-07-28 12:02:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101618","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":"3121790","reservation_id":"98385","confirmation_number":"SJ12696178382","room_confirmation_number":"SJ12624245050","room_stay_from":"2020-07-30","room_stay_to":"2020-08-04","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":"102708","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-30 20:06:08","reservation_modified_date_time":"2020-07-30 20:06:08","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":"3115081","reservation_id":"95815","confirmation_number":"SJ12654142157","room_confirmation_number":"SJ12638681997","room_stay_from":"2020-07-31","room_stay_to":"2020-08-07","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":"101971","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-02 18:17:24","reservation_modified_date_time":"2020-07-11 21:38:27","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":"3122471","reservation_id":"94440","confirmation_number":"SJ12683036904","room_confirmation_number":"SJ12651530268","room_stay_from":"2020-07-28","room_stay_to":"2020-08-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"100657","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-05 11:57:06","reservation_modified_date_time":"2020-08-01 13:59:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100657","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"}]},{"room_stay_id":"3122625","reservation_id":"91985","confirmation_number":"SJ12683377335","room_confirmation_number":"SJ12651278650","room_stay_from":"2020-07-28","room_stay_to":"2020-08-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"98138","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-14 21:26:06","reservation_modified_date_time":"2020-08-01 20:31:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98138","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":"3122472","reservation_id":"94440","confirmation_number":"SJ12628996201","room_confirmation_number":"SJ12651530268","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-01 14:00:04","reservation_modified_date_time":"2020-08-01 14:00:04","customer_id":"100657","parentCustTravId":"100657","customer_traveller_id":"100657","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3122626","reservation_id":"91985","confirmation_number":"SJ12643057645","room_confirmation_number":"SJ12651278650","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-01 20:31:48","reservation_modified_date_time":"2020-08-01 20:31:48","customer_id":"98138","parentCustTravId":"98138","customer_traveller_id":"98138","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3122604","reservation_id":"98477","confirmation_number":"SJ12694821013","room_confirmation_number":"SJ12669924684","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":"30.00","paid_amount":"30.00","product_id":null,"service_quantity":"2","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-01 19:15:59","reservation_modified_date_time":"2020-08-01 19:15:59","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.90","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":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}