{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-12-05","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":4,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1269,1270,1271,1319,1274,1272,1866,1307","block_room_bookings":[{"confirmation_number":"SJ12684450120","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","bundle_room":"0"},{"confirmation_number":"SJ12687263701","room_stay_from":"2020-12-04","room_stay_to":"2020-12-08","bundle_room":"0"},{"confirmation_number":"SJ12693802597","room_stay_from":"2020-12-04","room_stay_to":"2020-12-08","bundle_room":"0"},{"confirmation_number":"SJ12674665601","room_stay_from":"2020-12-04","room_stay_to":"2020-12-08","bundle_room":"0"},{"confirmation_number":"SJ12637317516","room_stay_from":"2020-12-04","room_stay_to":"2020-12-10","bundle_room":"0"},{"confirmation_number":"SJ12642915532","room_stay_from":"2020-12-04","room_stay_to":"2020-12-12","bundle_room":"0"},{"confirmation_number":"SJ12649223434","room_stay_from":"2020-12-04","room_stay_to":"2020-12-13","bundle_room":"0"},{"confirmation_number":"SJ12676533150","room_stay_from":"2020-08-07","room_stay_to":"2020-12-20","bundle_room":"0"}],"bundle_block_count":"1309,1310,1311,1312,1269,1270,1304,1305,1260,1261,1291,1711,1262,1263,1271,1272,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12625475241","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","bundle_room":"0"},{"confirmation_number":"SJB12632210733","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","bundle_room":"0"},{"confirmation_number":"SJB12684058879","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","bundle_room":"0"},{"confirmation_number":"SJB12651093036","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","bundle_room":"0"},{"confirmation_number":"SJB12670774409","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","bundle_room":"1"},{"confirmation_number":"SJB12687937276","room_stay_from":"2020-12-02","room_stay_to":"2020-12-07","bundle_room":"0"},{"confirmation_number":"SJB12650941756","room_stay_from":"2020-12-02","room_stay_to":"2020-12-07","bundle_room":"0"},{"confirmation_number":"SJB12640696686","room_stay_from":"2020-12-05","room_stay_to":"2020-12-08","bundle_room":"1"},{"confirmation_number":"SJB12668229664","room_stay_from":"2020-12-03","room_stay_to":"2020-12-11","bundle_room":"0"},{"confirmation_number":"SJB12644763079","room_stay_from":"2020-12-03","room_stay_to":"2020-12-11","bundle_room":"0"},{"confirmation_number":"SJB12625897070","room_stay_from":"2020-12-05","room_stay_to":"2020-12-12","bundle_room":"1"},{"confirmation_number":"SJB12671742699","room_stay_from":"2020-12-04","room_stay_to":"2020-12-12","bundle_room":"1"},{"confirmation_number":"SJB12653450421","room_stay_from":"2020-10-22","room_stay_to":"2020-12-20","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3161970","reservation_id":"103419","confirmation_number":"SJ12647358126","room_stay_from":"2021-02-16","room_stay_to":"2021-02-17","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"290.87","nightly_discount":"0","subtotal":"290.87","grand_total":"327.23","paid_amount":"0.00","room_type_id":"320","product_id":"1329","siteminder_id":"BDC-3391520259","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":"109610","customer_id":"109610","source_of_creation":"Booking.com","reservation_created_date":"2020-12-03 03:53:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"56.86","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3160969","reservation_id":"103365","confirmation_number":"SJ12686038130","room_stay_from":"2020-12-03","room_stay_to":"2020-12-11","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"192.64,231.84,231.84,192.64,192.64,192.64,192.64,192.64","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1619.52","grand_total":"1821.96","paid_amount":"1821.96","room_type_id":"320","product_id":"1714","siteminder_id":"EXP-1720081275","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":"109541","customer_id":"109541","source_of_creation":"Expedia","reservation_created_date":"2020-12-01 22:51:09","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":"231.84","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"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":"3154957","reservation_id":"102672","confirmation_number":"SJ12642939208","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"318.98,318.98","nightly_discount":"0.00,0.00","subtotal":"637.96","grand_total":"717.71","paid_amount":"717.71","room_type_id":"320","product_id":"1910","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":"108812","customer_id":"108812","source_of_creation":"FE","reservation_created_date":"2020-11-14 21:14:32","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"318.98","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":"3154961","reservation_id":"102672","confirmation_number":"SJ12645536448","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"318.98,318.98","nightly_discount":"0.00,0.00","subtotal":"637.96","grand_total":"717.71","paid_amount":"717.71","room_type_id":"320","product_id":"1332","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":"108812","customer_id":"108812","source_of_creation":"FE","reservation_created_date":"2020-11-14 21:14:33","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"318.98","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":[{"room_stay_id":"3086061","reservation_id":"92077","confirmation_number":"SJ12613954301","room_stay_from":"2020-12-05","room_stay_to":"2020-12-10","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"235.13","room_type_id":"413","product_id":"1261","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":"98251","customer_id":"98251","source_of_creation":"FE","reservation_created_date":"2020-02-17 01:12:17","service_canceled_date_time":"2020-10-06 23:38:29","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"235.13","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3160800","reservation_id":"101484","confirmation_number":"SJ12635806097","room_stay_from":"2020-12-03","room_stay_to":"2020-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.28,201.00,201.00","nightly_discount":"0.00,0.00,0.00","subtotal":"545.28","grand_total":"613.44","paid_amount":"613.44","room_type_id":"412","product_id":"1315","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":"102182","customer_id":"102182","source_of_creation":"PMS","reservation_created_date":"2020-10-13 16:32:57","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"201.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":"3161250","reservation_id":"95969","confirmation_number":"SJ12684112674","room_stay_from":"2020-12-02","room_stay_to":"2020-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"238.88,238.88,238.88,238.88,238.88","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1194.40","grand_total":"1343.70","paid_amount":"1343.70","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":"90934","customer_id":"90934","source_of_creation":"PMS","reservation_created_date":"2020-06-05 23:06: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":"238.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3156606","reservation_id":"102891","confirmation_number":"SJ12647173731","room_stay_from":"2020-12-04","room_stay_to":"2020-12-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.71,100.71,100.71,100.71,100.71,101.45,100.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"705.00","grand_total":"705.00","paid_amount":"0.00","room_type_id":"413","product_id":"1265","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-11-20 18:33:16","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":"100.71","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3160802","reservation_id":"101870","confirmation_number":"SJ12673441154","room_stay_from":"2020-12-04","room_stay_to":"2020-12-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"750.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":"750.00","grand_total":"750.00","paid_amount":"0.00","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_traveller_id":"106240","customer_id":"106240","source_of_creation":"PMS","reservation_created_date":"2020-10-23 12:39:54","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":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3159481","reservation_id":"97902","confirmation_number":"SJ12694200498","room_stay_from":"2020-11-28","room_stay_to":"2020-12-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"705.00,0.00,0.00,0.00,0.00,0.00,0.00,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,0,0,0,0,0,0,0","subtotal":"705.00","grand_total":"705.00","paid_amount":"0.00","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-07-18 02:37:32","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0","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":[],"negotiated_non_taxable":[{"room_stay_id":"3161339","reservation_id":"103169","confirmation_number":"SJ12684358224","room_stay_from":"2020-12-01","room_stay_to":"2020-12-06","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":"75.94","room_type_id":"413","product_id":"1266","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-11-27 00:41:05","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":"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":"3161697","reservation_id":"103370","confirmation_number":"SJ12626445503","room_stay_from":"2020-12-04","room_stay_to":"2020-12-07","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":"1275","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-12-02 00:37:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","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":"3146742","reservation_id":"96759","confirmation_number":"SJ12610623543","room_stay_from":"2020-12-05","room_stay_to":"2020-12-12","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":"1262","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-18 14:50:52","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":"","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":"3146770","reservation_id":"97475","confirmation_number":"SJ12655246875","room_stay_from":"2020-12-05","room_stay_to":"2020-12-12","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":"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-07-07 00:15:19","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":"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":"3162127","reservation_id":"95958","confirmation_number":"SJ12638409976","room_stay_from":"2020-12-05","room_stay_to":"2020-12-12","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":"0.00","room_type_id":"413","product_id":"1261","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-05 19:25:17","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":"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":"3162131","reservation_id":"95496","confirmation_number":"SJ12666061679","room_stay_from":"2020-12-05","room_stay_to":"2020-12-12","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":"1318","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-05-27 16:51:07","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":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3154960","reservation_id":"102672","confirmation_number":"SJ12683172813","room_confirmation_number":"SJ12642939208","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","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":"108811","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-14 21:14:32","reservation_modified_date_time":"2020-11-14 21:52:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108812","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":"3154964","reservation_id":"102672","confirmation_number":"SJ12637667822","room_confirmation_number":"SJ12645536448","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","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":"1","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-14 21:14:33","reservation_modified_date_time":"2020-11-14 21:52:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108812","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":"3160801","reservation_id":"101484","confirmation_number":"SJ12685223377","room_confirmation_number":"SJ12635806097","room_stay_from":"2020-12-03","room_stay_to":"2020-12-06","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":"102182","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-13 16:32:57","reservation_modified_date_time":"2020-12-01 17:37:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102182","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":"3161341","reservation_id":"103169","confirmation_number":"SJ12658097691","room_confirmation_number":"SJ12684358224","room_stay_from":"2020-12-01","room_stay_to":"2020-12-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50,11.50","subtotal":"125.00","grand_total":"75.94","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109322","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-27 00:41:05","reservation_modified_date_time":"2020-12-03 01:13:26","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":"11.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":"3161253","reservation_id":"95969","confirmation_number":"SJ12642747200","room_confirmation_number":"SJ12684112674","room_stay_from":"2020-12-02","room_stay_to":"2020-12-07","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":"90934","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-05 23:06:57","reservation_modified_date_time":"2020-12-02 20:59:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90934","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":"3161698","reservation_id":"103370","confirmation_number":"SJ12678780095","room_confirmation_number":"SJ12626445503","room_stay_from":"2020-12-04","room_stay_to":"2020-12-07","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":"109548","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-02 00:37:20","reservation_modified_date_time":"2020-12-04 13:04:18","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":"3156607","reservation_id":"102891","confirmation_number":"SJ12661116767","room_confirmation_number":"SJ12647173731","room_stay_from":"2020-12-04","room_stay_to":"2020-12-11","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":"109024","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-20 18:33:16","reservation_modified_date_time":"2020-11-20 18:33:16","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":"3160970","reservation_id":"103365","confirmation_number":"SJ12614989322","room_confirmation_number":"SJ12686038130","room_stay_from":"2020-12-03","room_stay_to":"2020-12-11","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":"109541","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-01 22:51:09","reservation_modified_date_time":"2020-12-01 22:51:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109541","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":"3146741","reservation_id":"96759","confirmation_number":"SJ12644473312","room_confirmation_number":"SJ12610623543","room_stay_from":"2020-12-05","room_stay_to":"2020-12-12","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":"99278","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 14:50:52","reservation_modified_date_time":"2020-10-17 22:06:32","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":"3146769","reservation_id":"97475","confirmation_number":"SJ12688911957","room_confirmation_number":"SJ12655246875","room_stay_from":"2020-12-05","room_stay_to":"2020-12-12","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":"103557","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-07 00:15:19","reservation_modified_date_time":"2020-10-17 22:06:32","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":"3159482","reservation_id":"97902","confirmation_number":"SJ12635323915","room_confirmation_number":"SJ12694200498","room_stay_from":"2020-11-28","room_stay_to":"2020-12-12","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,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,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":"103969","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-18 02:37:32","reservation_modified_date_time":"2020-11-28 14:26:58","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":"3162129","reservation_id":"95958","confirmation_number":"SJ12644587422","room_confirmation_number":"SJ12638409976","room_stay_from":"2020-12-05","room_stay_to":"2020-12-12","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":"99194","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-05 19:25:17","reservation_modified_date_time":"2020-12-05 21:58:11","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":"3162132","reservation_id":"95496","confirmation_number":"SJ12636483399","room_confirmation_number":"SJ12666061679","room_stay_from":"2020-12-05","room_stay_to":"2020-12-12","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":"101685","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 16:51:07","reservation_modified_date_time":"2020-12-05 22:09:15","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":"3161973","reservation_id":"103419","confirmation_number":"SJ12655875334","room_confirmation_number":"SJ12647358126","room_stay_from":"2021-02-16","room_stay_to":"2021-02-17","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109610","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-03 03:53:07","reservation_modified_date_time":"2020-12-05 07:43:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109610","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":[{"room_stay_id":"3160803","reservation_id":"101870","confirmation_number":"SJ12690822009","room_confirmation_number":"SJ12673441154","room_stay_from":"2020-12-04","room_stay_to":"2020-12-11","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":"107974","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-23 12:39:54","reservation_modified_date_time":"2020-12-01 17:38:28","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"106240","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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"}]}],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}