{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-01-03","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":28,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1289","block_room_bookings":[{"confirmation_number":"SJ12615466762","room_stay_from":"2021-01-01","room_stay_to":"2021-01-26","bundle_room":"0"}],"bundle_block_count":"1260,1261,1309,1310,1307,1308,1302,1303,1271,1272","bundle_block_bookings":[{"confirmation_number":"SJB12624852747","room_stay_from":"2021-01-02","room_stay_to":"2021-01-04","bundle_room":"1"},{"confirmation_number":"SJB12645709592","room_stay_from":"2021-01-02","room_stay_to":"2021-01-04","bundle_room":"0"},{"confirmation_number":"SJB12633908543","room_stay_from":"2021-01-02","room_stay_to":"2021-01-04","bundle_room":"0"},{"confirmation_number":"SJB12634284108","room_stay_from":"2021-01-02","room_stay_to":"2021-01-04","bundle_room":"0"},{"confirmation_number":"SJB12630720048","room_stay_from":"2021-01-02","room_stay_to":"2021-01-04","bundle_room":"0"},{"confirmation_number":"SJB12675284105","room_stay_from":"2021-01-03","room_stay_to":"2021-01-04","bundle_room":"0"},{"confirmation_number":"SJB12666334180","room_stay_from":"2021-01-03","room_stay_to":"2021-01-04","bundle_room":"0"},{"confirmation_number":"SJB12635240984","room_stay_from":"2021-01-03","room_stay_to":"2021-01-05","bundle_room":"0"},{"confirmation_number":"SJB12647449525","room_stay_from":"2021-01-03","room_stay_to":"2021-01-05","bundle_room":"0"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3173320","reservation_id":"104610","confirmation_number":"SJ12687342015","room_stay_from":"2021-01-03","room_stay_to":"2021-01-05","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"272.88,258.48","nightly_discount":"0,0","subtotal":"531.36","grand_total":"597.78","paid_amount":"597.78","room_type_id":"320","product_id":"1324","siteminder_id":"BDC-2698110240","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":"110964","customer_id":"110964","source_of_creation":"Booking.com","reservation_created_date":"2021-01-02 22:58:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"104.64","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","currentDayPrice":"272.88","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3172801","reservation_id":"104254","confirmation_number":"SJ12639274529","room_stay_from":"2021-01-02","room_stay_to":"2021-01-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,160.30,146.30,146.30","nightly_discount":"0,0,0,0","subtotal":"662.20","grand_total":"744.98","paid_amount":"744.98","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-2180259947","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":"110603","customer_id":"110603","source_of_creation":"Booking.com","reservation_created_date":"2020-12-26 17:56:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"137.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.30","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":"3167231","reservation_id":"103977","confirmation_number":"SJ12664684739","room_stay_from":"2020-12-31","room_stay_to":"2021-01-02","room_stay_status":"Canceled","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"365.2,365.2","nightly_discount":"0,0","subtotal":"730.40","grand_total":"821.70","paid_amount":"0.00","room_type_id":"319","product_id":"1311","siteminder_id":"BDC-2516456043","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110287","customer_id":"110287","source_of_creation":"Booking.com","reservation_created_date":"2020-12-19 09:39:15","service_canceled_date_time":"2021-01-03 18:06:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"316.94","reservation_status_type":"","total_paid_amount":"0.00","deltaChange":-730.4,"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"}]},{"room_stay_id":"3169738","reservation_id":"103977","confirmation_number":"SJ12640785281","room_stay_from":"2020-12-31","room_stay_to":"2021-01-02","room_stay_status":"Canceled","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"365.2,365.2","nightly_discount":"0,0","subtotal":"730.40","grand_total":"821.70","paid_amount":"0.00","room_type_id":"319","product_id":"1312","siteminder_id":"BDC-2516456043","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110287","customer_id":"110287","source_of_creation":"Booking.com","reservation_created_date":"2020-12-19 09:39:11","service_canceled_date_time":"2021-01-03 18:06:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"316.94","reservation_status_type":"room_dates_changed","total_paid_amount":"0.00","deltaChange":-730.4,"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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3173692","reservation_id":"104669","confirmation_number":"SJ12681376789","room_stay_from":"2021-01-03","room_stay_to":"2021-01-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"291.72","nightly_discount":"0","subtotal":"291.72","grand_total":"328.19","paid_amount":"328.19","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1727316089","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":"111022","customer_id":"111022","source_of_creation":"Expedia","reservation_created_date":"2021-01-03 22:31:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"58.34","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","currentDayPrice":"291.72","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170792","reservation_id":"104293","confirmation_number":"SJ12688411107","room_stay_from":"2020-12-30","room_stay_to":"2021-01-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"469.00,469.00,469.00,230.30,181.30,167.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1985.90","grand_total":"2234.14","paid_amount":"2234.14","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1725588537","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":"110649","customer_id":"110649","source_of_creation":"Expedia","reservation_created_date":"2020-12-27 14:41:09","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":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"181.30","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":"3171833","reservation_id":"104417","confirmation_number":"SJ12678232848","room_stay_from":"2021-01-02","room_stay_to":"2021-01-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.44,128.24,117.04,117.04","nightly_discount":"0,0,0,0","subtotal":"529.76","grand_total":"595.98","paid_amount":"595.98","room_type_id":"319","product_id":"1942","siteminder_id":"EXP-1726210548","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":"110766","customer_id":"110766","source_of_creation":"Expedia","reservation_created_date":"2020-12-30 02:36:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"128.24","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":"3171841","reservation_id":"104418","confirmation_number":"SJ12690804482","room_stay_from":"2021-01-02","room_stay_to":"2021-01-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.44,128.24,117.04,117.04","nightly_discount":"0,0,0,0","subtotal":"529.76","grand_total":"595.98","paid_amount":"595.98","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1726210622","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":"110767","customer_id":"110767","source_of_creation":"Expedia","reservation_created_date":"2020-12-30 02:36:16","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"128.24","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":"3173303","reservation_id":"104552","confirmation_number":"SJ12630527792","room_stay_from":"2021-02-15","room_stay_to":"2021-02-19","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.44,139.44,139.44,139.44","nightly_discount":"0,0,0,0","subtotal":"557.76","grand_total":"627.48","paid_amount":"0.00","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1726909789","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":"110902","customer_id":"110902","source_of_creation":"Expedia","reservation_created_date":"2021-01-02 00:41:18","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":"","promotion_code":"0","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":"3173481","reservation_id":"104503","confirmation_number":"SJ12662093693","room_stay_from":"2021-01-16","room_stay_to":"2021-01-20","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.30,160.30,146.30,146.30","nightly_discount":"0,0,0,0","subtotal":"627.20","grand_total":"705.60","paid_amount":"196.09","room_type_id":"319","product_id":"1305","siteminder_id":"EXP-1726754641","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":"110858","customer_id":"110858","source_of_creation":"Expedia","reservation_created_date":"2021-01-01 08:01:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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"}]}],"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":[{"room_stay_id":"3172626","reservation_id":"102871","confirmation_number":"SJ12671598490","room_stay_from":"2021-01-01","room_stay_to":"2021-01-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,209.30,121.15","nightly_discount":"0.00,0.00,0.00","subtotal":"539.75","grand_total":"726.34","paid_amount":"726.34","room_type_id":"412","product_id":"1297","siteminder_id":"ABB-HMFZKA2ZRR","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"627.90","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109007","customer_id":"109007","source_of_creation":"Airbnb","reservation_created_date":"2020-11-20 05:06:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"96.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"121.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3172733","reservation_id":"104461","confirmation_number":"SJ12633748844","room_stay_from":"2021-01-01","room_stay_to":"2021-01-04","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"295.80,295.80,290.48","nightly_discount":"0.00,0.00,0.00","subtotal":"882.08","grand_total":"1022.20","paid_amount":"1022.20","room_type_id":"413","product_id":"1261","siteminder_id":"ABB-HMCTH5P2AK","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"887.40","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110814","customer_id":"110814","source_of_creation":"Airbnb","reservation_created_date":"2020-12-31 03:07:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"26.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"290.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3173555","reservation_id":"104363","confirmation_number":"SJ12634076352","room_stay_from":"2021-01-03","room_stay_to":"2021-01-07","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"223.89,223.89,223.89,218.52","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"890.19","grand_total":"1031.60","paid_amount":"1031.60","room_type_id":"319","product_id":"1306","siteminder_id":"ABB-HMQBJXW8JB","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"895.56","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110713","customer_id":"110713","source_of_creation":"Airbnb","reservation_created_date":"2020-12-29 03:21:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"26.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","currentDayPrice":"223.89","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3173448","reservation_id":"104615","confirmation_number":"SJ12688823497","room_stay_from":"2021-01-02","room_stay_to":"2021-01-03","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.12","nightly_discount":"0.00","subtotal":"300.12","grand_total":"347.80","paid_amount":"347.80","room_type_id":"319","product_id":"1274","siteminder_id":"ABB-HMSWTRHDYZ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"301.92","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110971","customer_id":"110971","source_of_creation":"Airbnb","reservation_created_date":"2021-01-02 23:32:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"8.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"changedComment":"Nightly price or discount changed","deltaChange":"-1.80","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3173464","reservation_id":"104414","confirmation_number":"SJ12688948753","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"398.31,398.31,398.31,388.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1583.68","grand_total":"1835.27","paid_amount":"1835.27","room_type_id":"318","product_id":"1282","siteminder_id":"ABB-HMWK4CXSSN","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1593.24","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110763","customer_id":"110763","source_of_creation":"Airbnb","reservation_created_date":"2020-12-30 01:48:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"46.86","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"changedComment":"Nightly price or discount changed","deltaChange":"-9.56","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3171921","reservation_id":"104001","confirmation_number":"SJ12673169799","room_stay_from":"2021-01-03","room_stay_to":"2021-01-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0","subtotal":"99.00","grand_total":"111.38","paid_amount":"111.38","room_type_id":"413","product_id":"1266","siteminder_id":"HWR-302974875","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":"110323","customer_id":"110323","source_of_creation":"Hotwire","reservation_created_date":"2020-12-20 02:30:12","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"99.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3173673","reservation_id":"104497","confirmation_number":"SJ12638945988","room_stay_from":"2021-01-03","room_stay_to":"2021-01-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,119.00,119.00,99.00,99.00,99.00,99.00,99.00,119.00,119.00,99.00,99.00,99.00","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1763.00","grand_total":"1983.38","paid_amount":"1983.38","room_type_id":"319","product_id":"1916","siteminder_id":"HWR-303010168","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":"110851","customer_id":"110851","source_of_creation":"Hotwire","reservation_created_date":"2021-01-01 00:33:32","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":"","promotion_code":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"99.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"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3173574","reservation_id":"104555","confirmation_number":"SJ12619421820","room_stay_from":"2021-01-02","room_stay_to":"2021-01-04","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"381.65,322.15","nightly_discount":"0.00,0.00","subtotal":"703.80","grand_total":"791.78","paid_amount":"791.78","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":"110905","customer_id":"110905","source_of_creation":"PMS","reservation_created_date":"2021-01-02 01:18:21","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":"","promotion_code":"","currentDayPrice":"322.15","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":"3173578","reservation_id":"104555","confirmation_number":"SJ12697615165","room_stay_from":"2021-01-02","room_stay_to":"2021-01-04","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"381.65,322.15","nightly_discount":"0.00,0.00","subtotal":"703.80","grand_total":"791.78","paid_amount":"791.78","room_type_id":"320","product_id":"1330","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":"110905","customer_id":"110905","source_of_creation":"PMS","reservation_created_date":"2021-01-02 01:18:22","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","currentDayPrice":"322.15","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":"3173437","reservation_id":"104451","confirmation_number":"SJ12669188249","room_stay_from":"2021-01-02","room_stay_to":"2021-01-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"238.15,174.65,159.65,159.65,159.65,159.65,190.65","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1242.05","grand_total":"1397.30","paid_amount":"1397.30","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":"110804","customer_id":"110804","source_of_creation":"PMS","reservation_created_date":"2020-12-30 21:49:45","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":"","promotion_code":"","currentDayPrice":"174.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3173439","reservation_id":"104579","confirmation_number":"SJ12678290462","room_stay_from":"2021-01-02","room_stay_to":"2021-01-03","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.74","nightly_discount":"0.00","subtotal":"228.74","grand_total":"257.34","paid_amount":"0.00","room_type_id":"413","product_id":"1260","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":"110927","customer_id":"110927","source_of_creation":"PMS","reservation_created_date":"2021-01-02 16:54:44","service_canceled_date_time":"2021-01-03 17:20:29","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"canceled resv status changed","total_paid_amount":"0.00","deltaChange":-228.74,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3173324","reservation_id":"103548","confirmation_number":"SJ12699284992","room_stay_from":"2021-01-03","room_stay_to":"2021-01-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.33,113.33,113.33","nightly_discount":"0.00,0.00,0.00","subtotal":"339.99","grand_total":"339.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-06 22:45:46","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":"","promotion_code":"","currentDayPrice":"113.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":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3171922","reservation_id":"104001","confirmation_number":"SJ12695952112","room_confirmation_number":"SJ12673169799","room_stay_from":"2021-01-03","room_stay_to":"2021-01-04","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":"110323","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-20 02:30:12","reservation_modified_date_time":"2020-12-30 16:39:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110323","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":"3172627","reservation_id":"102871","confirmation_number":"SJ12651813152","room_confirmation_number":"SJ12671598490","room_stay_from":"2021-01-01","room_stay_to":"2021-01-04","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":"109007","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-20 05:06:06","reservation_modified_date_time":"2021-01-01 20:24:33","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109007","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3172735","reservation_id":"104461","confirmation_number":"SJ12673946854","room_confirmation_number":"SJ12633748844","room_stay_from":"2021-01-01","room_stay_to":"2021-01-04","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"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":"110814","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-31 03:07:06","reservation_modified_date_time":"2021-01-01 23:48:56","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110814","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3173577","reservation_id":"104555","confirmation_number":"SJ12652630121","room_confirmation_number":"SJ12619421820","room_stay_from":"2021-01-02","room_stay_to":"2021-01-04","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":"110905","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 01:18:21","reservation_modified_date_time":"2021-01-03 21:29:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110905","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":"3173581","reservation_id":"104555","confirmation_number":"SJ12690239836","room_confirmation_number":"SJ12697615165","room_stay_from":"2021-01-02","room_stay_to":"2021-01-04","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":"110905","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 01:18:22","reservation_modified_date_time":"2021-01-03 21:29:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110905","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":"3173695","reservation_id":"104669","confirmation_number":"SJ12687114946","room_confirmation_number":"SJ12681376789","room_stay_from":"2021-01-03","room_stay_to":"2021-01-04","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"111022","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-03 22:31:11","reservation_modified_date_time":"2021-01-03 23:14:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111022","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.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":"3170793","reservation_id":"104293","confirmation_number":"SJ12667211257","room_confirmation_number":"SJ12688411107","room_stay_from":"2020-12-30","room_stay_to":"2021-01-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"110649","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-27 14:41:09","reservation_modified_date_time":"2020-12-27 15:27:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110649","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":"3173323","reservation_id":"104610","confirmation_number":"SJ12621606361","room_confirmation_number":"SJ12687342015","room_stay_from":"2021-01-03","room_stay_to":"2021-01-05","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":"110964","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 22:58:13","reservation_modified_date_time":"2021-01-03 14:37:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110964","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":"3171834","reservation_id":"104417","confirmation_number":"SJ12689283431","room_confirmation_number":"SJ12678232848","room_stay_from":"2021-01-02","room_stay_to":"2021-01-06","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":"110766","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-30 02:36:11","reservation_modified_date_time":"2020-12-30 12:44:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110766","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":"3171842","reservation_id":"104418","confirmation_number":"SJ12676668399","room_confirmation_number":"SJ12690804482","room_stay_from":"2021-01-02","room_stay_to":"2021-01-06","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":"110767","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-30 02:36:16","reservation_modified_date_time":"2020-12-30 12:45:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110767","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":"3172802","reservation_id":"104254","confirmation_number":"SJ12695102890","room_confirmation_number":"SJ12639274529","room_stay_from":"2021-01-02","room_stay_to":"2021-01-06","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":"110603","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-26 17:56:07","reservation_modified_date_time":"2021-01-02 06:08:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110603","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":"3173325","reservation_id":"103548","confirmation_number":"SJ12662219486","room_confirmation_number":"SJ12699284992","room_stay_from":"2021-01-03","room_stay_to":"2021-01-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109782","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-06 22:45:46","reservation_modified_date_time":"2021-01-03 14:39:16","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3173556","reservation_id":"104363","confirmation_number":"SJ12662407141","room_confirmation_number":"SJ12634076352","room_stay_from":"2021-01-03","room_stay_to":"2021-01-07","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"110713","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-29 03:21:06","reservation_modified_date_time":"2021-01-03 20:39:38","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110713","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3173438","reservation_id":"104451","confirmation_number":"SJ12674592597","room_confirmation_number":"SJ12669188249","room_stay_from":"2021-01-02","room_stay_to":"2021-01-09","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":"110804","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-30 21:49:45","reservation_modified_date_time":"2021-01-03 17:19:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110804","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":"3173674","reservation_id":"104497","confirmation_number":"SJ12670070920","room_confirmation_number":"SJ12638945988","room_stay_from":"2021-01-03","room_stay_to":"2021-01-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"425.00","grand_total":"478.13","paid_amount":"478.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"110851","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-01 00:33:32","reservation_modified_date_time":"2021-01-03 22:38:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110851","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":"3173302","reservation_id":"104552","confirmation_number":"SJ12666383379","room_confirmation_number":"SJ12630527792","room_stay_from":"2021-02-15","room_stay_to":"2021-02-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110902","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 00:41:18","reservation_modified_date_time":"2021-01-03 13:54:20","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110902","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":"3173449","reservation_id":"104615","confirmation_number":"SJ12636282918","room_confirmation_number":"SJ12688823497","room_stay_from":"2021-01-02","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110971","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 23:32:08","reservation_modified_date_time":"2021-01-03 17:22:25","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110971","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"Nightly price or discount changed","deltaChange":"-25.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3173482","reservation_id":"104503","confirmation_number":"SJ12659561144","room_confirmation_number":"SJ12662093693","room_stay_from":"2021-01-16","room_stay_to":"2021-01-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110858","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-01 08:01:22","reservation_modified_date_time":"2021-01-03 19:01:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110858","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":"3173169","reservation_id":"104579","confirmation_number":"SJ12681017818","room_confirmation_number":"SJ12678290462","room_stay_from":"2021-01-02","room_stay_to":"2021-01-03","room_stay_status":"Canceled","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-02 16:54:44","reservation_modified_date_time":"2021-01-02 23:21:30","customer_id":"110927","parentCustTravId":"110927","customer_traveller_id":"110927","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-01-03 17:20:30","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","parentRoomStayFrom":"2021-01-02","deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3173291","reservation_id":"104632","confirmation_number":"SJ12675946659","room_confirmation_number":"SJ12635109007","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.99","grand_total":"5.36","paid_amount":"5.36","product_id":"1904","service_quantity":"1","product_name":"Key Lime Soap","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-03 13:47:48","reservation_modified_date_time":"2021-01-03 13:47:48","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,"parentRoomStayFrom":"1970-01-01","currentDayPrice":"4.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3173525","reservation_id":"104651","confirmation_number":"SJ12650561400","room_confirmation_number":"SJ12624327967","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-03 19:37:11","reservation_modified_date_time":"2021-01-03 19:37:11","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,"parentRoomStayFrom":"1970-01-01","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3173526","reservation_id":"104651","confirmation_number":"SJ12633280722","room_confirmation_number":"SJ12624327967","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":"20.00","paid_amount":"20.00","product_id":"1662","service_quantity":"2","product_name":"Extra Chair or Umbrella","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-03 19:37:11","reservation_modified_date_time":"2021-01-03 19:37:11","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,"parentRoomStayFrom":"1970-01-01","currentDayPrice":"18.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3173730","reservation_id":"104681","confirmation_number":"SJ12634563269","room_confirmation_number":"SJ12654481832","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"15.00","paid_amount":"15.00","product_id":"1654","service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-04 01:25:33","reservation_modified_date_time":"2021-01-04 01:25:33","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,"parentRoomStayFrom":"1970-01-01","currentDayPrice":"13.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}