{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-08-28","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":1,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1272,1273,1267,1269,1271,1293,1866,1297,1942,1943,1270,1268,1275,1756,1274,1281,1316,1315,1921,1264,1310,1307","block_room_bookings":[{"confirmation_number":"SJ12656445087","room_stay_from":"2020-08-27","room_stay_to":"2020-08-29","bundle_room":"0"},{"confirmation_number":"SJ12617749905","room_stay_from":"2020-08-27","room_stay_to":"2020-08-29","bundle_room":"0"},{"confirmation_number":"SJ12661739459","room_stay_from":"2020-08-28","room_stay_to":"2020-08-29","bundle_room":"0"},{"confirmation_number":"SJ12672604629","room_stay_from":"2020-08-27","room_stay_to":"2020-08-29","bundle_room":"0"},{"confirmation_number":"SJ12623789908","room_stay_from":"2020-08-27","room_stay_to":"2020-08-29","bundle_room":"0"},{"confirmation_number":"SJ12637426822","room_stay_from":"2020-08-27","room_stay_to":"2020-08-29","bundle_room":"0"},{"confirmation_number":"SJ12666145473","room_stay_from":"2020-08-27","room_stay_to":"2020-08-29","bundle_room":"0"},{"confirmation_number":"SJ12640492175","room_stay_from":"2020-08-27","room_stay_to":"2020-08-29","bundle_room":"0"},{"confirmation_number":"SJ12669286392","room_stay_from":"2020-08-27","room_stay_to":"2020-08-29","bundle_room":"0"},{"confirmation_number":"SJ12611950751","room_stay_from":"2020-08-27","room_stay_to":"2020-08-29","bundle_room":"0"},{"confirmation_number":"SJ12611976310","room_stay_from":"2020-08-28","room_stay_to":"2020-08-29","bundle_room":"0"},{"confirmation_number":"SJ12627104923","room_stay_from":"2020-08-28","room_stay_to":"2020-08-29","bundle_room":"0"},{"confirmation_number":"SJ12642233447","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","bundle_room":"0"},{"confirmation_number":"SJ12639739772","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","bundle_room":"0"},{"confirmation_number":"SJ12639944135","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","bundle_room":"0"},{"confirmation_number":"SJ12671186290","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","bundle_room":"0"},{"confirmation_number":"SJ12612269776","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","bundle_room":"0"},{"confirmation_number":"SJ12694738921","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","bundle_room":"0"},{"confirmation_number":"SJ12637790408","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","bundle_room":"0"},{"confirmation_number":"SJ12641212884","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","bundle_room":"0"},{"confirmation_number":"SJ12668784403","room_stay_from":"2020-08-27","room_stay_to":"2020-09-05","bundle_room":"0"},{"confirmation_number":"SJ12676533150","room_stay_from":"2020-08-07","room_stay_to":"2020-09-23","bundle_room":"0"}],"bundle_block_count":"1260,1261,1267,1268,1269,1270,1271,1272,1302,1303,1262,1263,1304,1305,1309,1310,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12685019246","room_stay_from":"2020-08-28","room_stay_to":"2020-08-29","bundle_room":"1"},{"confirmation_number":"SJB12670801266","room_stay_from":"2020-08-28","room_stay_to":"2020-08-29","bundle_room":"1"},{"confirmation_number":"SJB12623649086","room_stay_from":"2020-08-28","room_stay_to":"2020-08-29","bundle_room":"1"},{"confirmation_number":"SJB12627754150","room_stay_from":"2020-08-27","room_stay_to":"2020-08-29","bundle_room":"1"},{"confirmation_number":"SJB12636743379","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","bundle_room":"0"},{"confirmation_number":"SJB12674952878","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","bundle_room":"0"},{"confirmation_number":"SJB12673518119","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","bundle_room":"1"},{"confirmation_number":"SJB12632101757","room_stay_from":"2020-08-28","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJB12698564333","room_stay_from":"2020-08-28","room_stay_to":"2020-08-31","bundle_room":"0"},{"confirmation_number":"SJB12659199206","room_stay_from":"2020-08-27","room_stay_to":"2020-09-05","bundle_room":"1"},{"confirmation_number":"SJB12666369553","room_stay_from":"2020-08-07","room_stay_to":"2020-09-23","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3131572","reservation_id":"99621","confirmation_number":"SJ12694354434","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"266.90,266.90","nightly_discount":"0,0","subtotal":"533.80","grand_total":"600.53","paid_amount":"600.53","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3146980032","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":"105618","customer_id":"105618","source_of_creation":"Booking.com","reservation_created_date":"2020-08-27 23:25:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"105.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"266.90","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":"3130070","reservation_id":"99450","confirmation_number":"SJ12666174178","room_stay_from":"2020-08-28","room_stay_to":"2020-09-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"191.20,191.20,126.40,126.40","nightly_discount":"0,0,0,0","subtotal":"635.20","grand_total":"714.60","paid_amount":"714.60","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-2870473565","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":"105450","customer_id":"105450","source_of_creation":"Booking.com","reservation_created_date":"2020-08-24 02:04:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"132.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"191.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3099622","reservation_id":"95726","confirmation_number":"SJ12659057467","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"98.40,98.40","nightly_discount":"0,0","subtotal":"196.80","grand_total":"221.40","paid_amount":"221.40","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1667213714","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":"101897","customer_id":"101897","source_of_creation":"Expedia","reservation_created_date":"2020-06-01 00:46:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"98.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":"3130002","reservation_id":"99478","confirmation_number":"SJ12644844967","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"280.96,280.96","nightly_discount":"0,0","subtotal":"561.92","grand_total":"632.16","paid_amount":"632.16","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1692506615","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":"105481","customer_id":"105481","source_of_creation":"Expedia","reservation_created_date":"2020-08-25 01:12:11","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":"280.96","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":"3130080","reservation_id":"98337","confirmation_number":"SJ12644997904","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.20,87.20","nightly_discount":"0,0","subtotal":"174.40","grand_total":"196.20","paid_amount":"196.20","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1684273166","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":"104373","customer_id":"104373","source_of_creation":"Expedia","reservation_created_date":"2020-07-29 21:45:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"87.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3131348","reservation_id":"96988","confirmation_number":"SJ12682907588","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.40,86.40","nightly_discount":"0,0","subtotal":"172.80","grand_total":"194.40","paid_amount":"194.40","room_type_id":"413","product_id":"1262","siteminder_id":"EXP-1673218790","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":"103111","customer_id":"103111","source_of_creation":"Expedia","reservation_created_date":"2020-06-23 16:17:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"86.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":"3131569","reservation_id":"99206","confirmation_number":"SJ12617408548","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"82.2,82.2","nightly_discount":"0,0","subtotal":"164.40","grand_total":"184.95","paid_amount":"184.95","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1690504857","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"105181","customer_id":"105181","source_of_creation":"Expedia","reservation_created_date":"2020-08-18 14:37:09","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":"82.2","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3131575","reservation_id":"99216","confirmation_number":"SJ12696119441","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"82.2,82.2","nightly_discount":"0,0","subtotal":"164.40","grand_total":"184.95","paid_amount":"184.95","room_type_id":"319","product_id":"1287","siteminder_id":"EXP-1690603492","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"105193","customer_id":"105193","source_of_creation":"Expedia","reservation_created_date":"2020-08-18 20:32:11","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":"82.2","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"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":"3129758","reservation_id":"95193","confirmation_number":"SJ12629318567","room_stay_from":"2020-08-25","room_stay_to":"2020-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.70,92.70,92.70,112.70","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"390.80","grand_total":"439.65","paid_amount":"439.65","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101236","customer_id":"101236","source_of_creation":"FE","reservation_created_date":"2020-05-21 17:22:59","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"112.70","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":"3130076","reservation_id":"98867","confirmation_number":"SJ12696698694","room_stay_from":"2020-08-28","room_stay_to":"2020-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"514.00,514.00,280.32","nightly_discount":"0.00,0.00,0.00","subtotal":"1308.32","grand_total":"1471.86","paid_amount":"1471.86","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":"104872","customer_id":"104872","source_of_creation":"FE","reservation_created_date":"2020-08-11 13:45:57","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":"514.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3130074","reservation_id":"98936","confirmation_number":"SJ12613874724","room_stay_from":"2020-08-28","room_stay_to":"2020-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.00,245.00,97.40","nightly_discount":"0.00,0.00,0.00","subtotal":"587.40","grand_total":"660.83","paid_amount":"660.83","room_type_id":"319","product_id":"1306","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":"104921","customer_id":"104921","source_of_creation":"PMS","reservation_created_date":"2020-08-12 16:54:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3131279","reservation_id":"98248","confirmation_number":"SJ12698682437","room_stay_from":"2020-08-28","room_stay_to":"2020-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","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":"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":"103852","customer_id":"103852","source_of_creation":"PMS","reservation_created_date":"2020-07-27 19:56:59","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":"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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3130778","reservation_id":"98508","confirmation_number":"SJ12654506213","room_stay_from":"2020-08-27","room_stay_to":"2020-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"84.38","room_type_id":"319","product_id":"1319","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-08-02 21:57:26","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":"78.33","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":"3125725","reservation_id":"98909","confirmation_number":"SJ12662478225","room_stay_from":"2020-08-28","room_stay_to":"2020-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"84.38","room_type_id":"413","product_id":"1263","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-08-12 01:03:40","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.33","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":"3131570","reservation_id":"99206","confirmation_number":"SJ12642735482","room_confirmation_number":"SJ12617408548","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"105181","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-08-28 21:37:47","reservation_modified_date_time":"2020-08-28 21:37:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105181","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3131576","reservation_id":"99216","confirmation_number":"SJ12696014867","room_confirmation_number":"SJ12696119441","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"105193","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-08-28 21:38:20","reservation_modified_date_time":"2020-08-28 21:38:20","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105193","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3129759","reservation_id":"95193","confirmation_number":"SJ12635809744","room_confirmation_number":"SJ12629318567","room_stay_from":"2020-08-25","room_stay_to":"2020-08-29","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":"101236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-21 17:22:59","reservation_modified_date_time":"2020-08-24 13:27:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101236","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":"3099624","reservation_id":"95726","confirmation_number":"SJ12631548585","room_confirmation_number":"SJ12659057467","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","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":"101897","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-01 00:46:10","reservation_modified_date_time":"2020-06-01 00:56:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101897","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":"3130003","reservation_id":"99478","confirmation_number":"SJ12615907084","room_confirmation_number":"SJ12644844967","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","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":"105481","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-25 01:12:11","reservation_modified_date_time":"2020-08-25 01:12:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105481","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":"3130081","reservation_id":"98337","confirmation_number":"SJ12617347460","room_confirmation_number":"SJ12644997904","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","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":"104373","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-29 21:45:09","reservation_modified_date_time":"2020-08-25 12:38:56","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104373","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":"3130779","reservation_id":"98508","confirmation_number":"SJ12637409063","room_confirmation_number":"SJ12654506213","room_stay_from":"2020-08-27","room_stay_to":"2020-08-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"104537","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-02 21:57:26","reservation_modified_date_time":"2020-08-27 11:25:41","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":"3131351","reservation_id":"96988","confirmation_number":"SJ12638157614","room_confirmation_number":"SJ12682907588","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","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":"103111","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-23 16:17:08","reservation_modified_date_time":"2020-08-28 14:34:39","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103111","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":"3131571","reservation_id":"99206","confirmation_number":"SJ12634285349","room_confirmation_number":"SJ12617408548","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","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":"105181","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-18 14:37:09","reservation_modified_date_time":"2020-08-28 21:37:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105181","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3131574","reservation_id":"99621","confirmation_number":"SJ12656412521","room_confirmation_number":"SJ12694354434","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","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":"105618","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-27 23:25:10","reservation_modified_date_time":"2020-08-28 21:38:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105618","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":"3131577","reservation_id":"99216","confirmation_number":"SJ12639512359","room_confirmation_number":"SJ12696119441","room_stay_from":"2020-08-28","room_stay_to":"2020-08-30","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":"105193","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-18 20:32:11","reservation_modified_date_time":"2020-08-28 21:38:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105193","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3125726","reservation_id":"98909","confirmation_number":"SJ12615246722","room_confirmation_number":"SJ12662478225","room_stay_from":"2020-08-28","room_stay_to":"2020-08-31","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"104903","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-12 01:03:40","reservation_modified_date_time":"2020-08-12 01:03:40","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":"3130075","reservation_id":"98936","confirmation_number":"SJ12656899789","room_confirmation_number":"SJ12613874724","room_stay_from":"2020-08-28","room_stay_to":"2020-08-31","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":"104921","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-12 16:54:28","reservation_modified_date_time":"2020-08-25 12:38:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104921","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":"3130079","reservation_id":"98867","confirmation_number":"SJ12613860393","room_confirmation_number":"SJ12696698694","room_stay_from":"2020-08-28","room_stay_to":"2020-08-31","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":"104872","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-11 13:45:57","reservation_modified_date_time":"2020-08-25 12:38:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104872","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":"3131280","reservation_id":"98248","confirmation_number":"SJ12636188817","room_confirmation_number":"SJ12698682437","room_stay_from":"2020-08-28","room_stay_to":"2020-08-31","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":"103852","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-27 19:56:59","reservation_modified_date_time":"2020-08-28 00:48:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103852","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":"3130071","reservation_id":"99450","confirmation_number":"SJ12680628385","room_confirmation_number":"SJ12666174178","room_stay_from":"2020-08-28","room_stay_to":"2020-09-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":"105450","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-24 02:04:12","reservation_modified_date_time":"2020-08-25 12:36:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105450","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3131670","reservation_id":"99661","confirmation_number":"SJ12684859108","room_confirmation_number":"SJ12685242471","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"1","product_name":"Face Mask","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-28 22:23:10","reservation_modified_date_time":"2020-08-28 22:23:10","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":"9.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3131781","reservation_id":"99676","confirmation_number":"SJ12667280429","room_confirmation_number":"SJ12668601353","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"27.91","grand_total":"30.00","paid_amount":"30.00","product_id":null,"service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-29 01:38:17","reservation_modified_date_time":"2020-08-29 01:38:17","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"27.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3131783","reservation_id":"98867","confirmation_number":"SJ12665435615","room_confirmation_number":"SJ12696698694","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":"16.00","paid_amount":"16.00","product_id":"1663","service_quantity":"4","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-29 01:44:11","reservation_modified_date_time":"2020-08-29 01:44:11","customer_id":"104872","parentCustTravId":"104872","customer_traveller_id":"104872","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","parentRoomStayFrom":"2020-08-28","currentDayPrice":"14.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[{"room_stay_id":"3131782","reservation_id":"99676","confirmation_number":"SJ12683865372","room_confirmation_number":"SJ12668601353","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"12.00","paid_amount":"12.00","product_id":null,"service_quantity":"3","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-29 01:38:17","reservation_modified_date_time":"2020-08-29 01:38:17","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"11.16","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}