{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-06-11","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":10,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1260,1261,1262,1297,1756,1307,1275,1943","block_room_bookings":[{"confirmation_number":"SJ12665826358","room_stay_from":"2020-06-10","room_stay_to":"2020-06-12","bundle_room":"1"},{"confirmation_number":"SJ12621372403","room_stay_from":"2020-06-09","room_stay_to":"2020-06-12","bundle_room":"0"},{"confirmation_number":"SJ12640607785","room_stay_from":"2020-06-07","room_stay_to":"2020-06-16","bundle_room":"0"},{"confirmation_number":"SJ12655799357","room_stay_from":"2020-06-07","room_stay_to":"2020-06-18","bundle_room":"0"},{"confirmation_number":"SJ12664166752","room_stay_from":"2020-06-07","room_stay_to":"2020-06-18","bundle_room":"0"},{"confirmation_number":"SJ12688349245","room_stay_from":"2020-06-07","room_stay_to":"2020-06-25","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-04","room_stay_to":"2020-06-27","bundle_room":"0"}],"bundle_block_count":"1311,1312,1269,1270,1260,1261,1262,1263,1267,1268,1304,1305,1302,1303,1271,1272,1309,1310,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12611633260","room_stay_from":"2020-06-06","room_stay_to":"2020-06-12","bundle_room":"1"},{"confirmation_number":"SJB12649654955","room_stay_from":"2020-06-10","room_stay_to":"2020-06-12","bundle_room":"1"},{"confirmation_number":"SJB12659784804","room_stay_from":"2020-06-10","room_stay_to":"2020-06-12","bundle_room":"0"},{"confirmation_number":"SJB12656776674","room_stay_from":"2020-06-10","room_stay_to":"2020-06-12","bundle_room":"0"},{"confirmation_number":"SJB12671910124","room_stay_from":"2020-06-09","room_stay_to":"2020-06-12","bundle_room":"1"},{"confirmation_number":"SJB12644753872","room_stay_from":"2020-06-10","room_stay_to":"2020-06-13","bundle_room":"1"},{"confirmation_number":"SJB12637929991","room_stay_from":"2020-06-11","room_stay_to":"2020-06-13","bundle_room":"1"},{"confirmation_number":"SJB12680276506","room_stay_from":"2020-06-10","room_stay_to":"2020-06-14","bundle_room":"1"},{"confirmation_number":"SJB12637535378","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","bundle_room":"1"},{"confirmation_number":"SJB12648387374","room_stay_from":"2020-06-10","room_stay_to":"2020-06-14","bundle_room":"1"},{"confirmation_number":"SJB12627926228","room_stay_from":"2020-06-07","room_stay_to":"2020-06-18","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3102810","reservation_id":"94915","confirmation_number":"SJ12683662249","room_stay_from":"2020-06-07","room_stay_to":"2020-06-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.40,138.40,138.40,138.40,138.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"708.00","grand_total":"796.50","paid_amount":"796.50","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-2526267389","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"250.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101107","customer_id":"101107","source_of_creation":"Booking.com","reservation_created_date":"2020-05-17 20:28:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"149.94","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.40","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":"3103110","reservation_id":"95142","confirmation_number":"SJ12612343365","room_stay_from":"2020-06-09","room_stay_to":"2020-06-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"118.40,118.40,118.40","nightly_discount":"0,0,0","subtotal":"355.20","grand_total":"399.60","paid_amount":"399.60","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-2854532864","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":"101324","customer_id":"101324","source_of_creation":"Booking.com","reservation_created_date":"2020-05-20 19:19:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"77.44","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"118.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":"3103575","reservation_id":"96131","confirmation_number":"SJ12690595007","room_stay_from":"2020-06-10","room_stay_to":"2020-06-13","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"141.4,141.4,192.6","nightly_discount":"0,0,0","subtotal":"475.40","grand_total":"534.83","paid_amount":"534.83","room_type_id":"413","product_id":"1268","siteminder_id":"BDC-2392845635","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102259","customer_id":"102259","source_of_creation":"Booking.com","reservation_created_date":"2020-06-08 23:11:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"112.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"141.4","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103943","reservation_id":"94968","confirmation_number":"SJ12675032863","room_stay_from":"2020-06-11","room_stay_to":"2020-06-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.20,119.20","nightly_discount":"0.00,0.00","subtotal":"222.40","grand_total":"250.20","paid_amount":"250.20","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-3587281112","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":"101155","customer_id":"101485","source_of_creation":"Booking.com","reservation_created_date":"2020-05-18 16:52:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"49.03","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103.20","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":"3103776","reservation_id":"96232","confirmation_number":"SJ12627738528","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.40,239.20,274.40","nightly_discount":"0,0,0","subtotal":"680.00","grand_total":"765.00","paid_amount":"765.00","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3831564864","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":"102354","customer_id":"102354","source_of_creation":"Booking.com","reservation_created_date":"2020-06-10 17:02:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"45.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"166.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":"3103930","reservation_id":"95385","confirmation_number":"SJ12673158128","room_stay_from":"2020-06-11","room_stay_to":"2020-06-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"136.80,181.60,181.60,136.80,136.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"773.60","grand_total":"870.30","paid_amount":"870.30","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-2637477104","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":"101577","customer_id":"101577","source_of_creation":"Booking.com","reservation_created_date":"2020-05-25 18:04:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"44.21","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136.80","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3102116","reservation_id":"95457","confirmation_number":"SJ12638863033","room_stay_from":"2020-06-06","room_stay_to":"2020-06-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.64,125.44,113.92,113.92,113.92,113.92,152.32","nightly_discount":"0,0,0,0,0,0,0","subtotal":"894.08","grand_total":"1005.84","paid_amount":"1005.84","room_type_id":"319","product_id":"1311","siteminder_id":"EXP-1666275333","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":"101649","customer_id":"101649","source_of_creation":"Expedia","reservation_created_date":"2020-05-27 13:31:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"178.82","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.92","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":"3102871","reservation_id":"96099","confirmation_number":"SJ12661317702","room_stay_from":"2020-06-10","room_stay_to":"2020-06-13","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"126.72,126.72,165.76","nightly_discount":"0,0,0","subtotal":"419.20","grand_total":"471.60","paid_amount":"471.60","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1668962726","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":"102222","customer_id":"102222","source_of_creation":"Expedia","reservation_created_date":"2020-06-08 15:36:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.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":"3103572","reservation_id":"95950","confirmation_number":"SJ12698824649","room_stay_from":"2020-06-10","room_stay_to":"2020-06-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.32,120.32,159.36","nightly_discount":"0,0,0","subtotal":"400.00","grand_total":"450.00","paid_amount":"450.00","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1668258155","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":"102091","customer_id":"102091","source_of_creation":"Expedia","reservation_created_date":"2020-06-05 15:51:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.32","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":"3103834","reservation_id":"95088","confirmation_number":"SJ12651485681","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.56,95.36,95.36","nightly_discount":"0,0,0","subtotal":"273.28","grand_total":"307.44","paid_amount":"307.44","room_type_id":"319","product_id":"1305","siteminder_id":"EXP-1664919290","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":"101270","customer_id":"101270","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 01:12:14","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":"","currentDayPrice":"82.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103935","reservation_id":"95113","confirmation_number":"SJ12690148968","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.72,91.52,91.52","nightly_discount":"0,0,0","subtotal":"261.76","grand_total":"294.48","paid_amount":"294.48","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1664988932","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":"101296","customer_id":"101296","source_of_creation":"Expedia","reservation_created_date":"2020-05-20 13:41:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.72","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103818","reservation_id":"95047","confirmation_number":"SJ12654129472","room_stay_from":"2020-06-11","room_stay_to":"2020-06-15","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"78.72,91.52,91.52,78.72","nightly_discount":"0,0,0,0","subtotal":"340.48","grand_total":"383.04","paid_amount":"383.04","room_type_id":"319","product_id":"1304","siteminder_id":"EXP-1664827429","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":"101234","customer_id":"101234","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 15:41:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.72","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103958","reservation_id":"96205","confirmation_number":"SJ12666669790","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.36,175.36,138.24","nightly_discount":"0,0,0","subtotal":"488.96","grand_total":"550.08","paid_amount":"0.00","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1669398131","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":"102327","customer_id":"102327","source_of_creation":"Expedia","reservation_created_date":"2020-06-10 01:36:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3104120","reservation_id":"70676","confirmation_number":"SJ12689249249","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.74,189.74,189.74","nightly_discount":"0.00,0.00,0.00","subtotal":"569.22","grand_total":"640.37","paid_amount":"640.37","room_type_id":"319","product_id":"1301","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82532","customer_id":"82532","source_of_creation":"FE","reservation_created_date":"2019-03-01 23:47:31","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"-567.00","currentDayPrice":"189.74","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":"3103980","reservation_id":"95843","confirmation_number":"SJ12630226163","room_stay_from":"2020-06-10","room_stay_to":"2020-06-11","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.07","nightly_discount":"0.00","subtotal":"195.07","grand_total":"219.45","paid_amount":"298.91","room_type_id":"319","product_id":"1308","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":"102000","customer_id":"102000","source_of_creation":"FE","reservation_created_date":"2020-06-03 02:11:55","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[{"room_stay_id":"3054951","reservation_id":"89483","confirmation_number":"SJ12655779372","room_stay_from":"2020-06-11","room_stay_to":"2020-06-13","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"201.38","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":"95463","customer_id":"95463","source_of_creation":"FE","reservation_created_date":"2020-01-07 01:38:27","service_canceled_date_time":"2020-05-13 20:33:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"201.38","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3104187","reservation_id":"96309","confirmation_number":"SJ12634814069","room_stay_from":"2020-06-11","room_stay_to":"2020-06-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.43","nightly_discount":"0.00","subtotal":"152.43","grand_total":"171.48","paid_amount":"171.48","room_type_id":"413","product_id":"1263","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":"102433","customer_id":"102433","source_of_creation":"PMS","reservation_created_date":"2020-06-12 01:22:54","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":"152.43","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":"3103055","reservation_id":"96122","confirmation_number":"SJ12638773559","room_stay_from":"2020-06-10","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.33,185.33,243.24,279.73","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"893.63","grand_total":"1005.33","paid_amount":"1005.33","room_type_id":"319","product_id":"1310","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":"102249","customer_id":"102249","source_of_creation":"PMS","reservation_created_date":"2020-06-08 21:10:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"185.33","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":"3103555","reservation_id":"96188","confirmation_number":"SJ12659392304","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"200.00,200.00,200.00","nightly_discount":"0.00,0.00,0.00","subtotal":"600.00","grand_total":"675.00","paid_amount":"675.00","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":"102312","customer_id":"102312","source_of_creation":"PMS","reservation_created_date":"2020-06-09 22:38:14","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":"200.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":"3103566","reservation_id":"95914","confirmation_number":"SJ12655825060","room_stay_from":"2020-06-10","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.45,160.45,214.63,246.82","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"782.35","grand_total":"880.15","paid_amount":"880.15","room_type_id":"319","product_id":"1302","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88571","customer_id":"88571","source_of_creation":"PMS","reservation_created_date":"2020-06-04 20:37:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.45","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":"3103828","reservation_id":"95915","confirmation_number":"SJ12698014034","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.45,214.63,246.82","nightly_discount":"0.00,0.00,0.00","subtotal":"621.90","grand_total":"699.64","paid_amount":"699.64","room_type_id":"319","product_id":"1303","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":"88530","customer_id":"88530","source_of_creation":"PMS","reservation_created_date":"2020-06-04 20:40:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.45","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":"3104156","reservation_id":"96116","confirmation_number":"SJ12613967995","room_stay_from":"2020-06-10","room_stay_to":"2020-06-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.33,185.33,243.24,279.73","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"893.63","grand_total":"1005.33","paid_amount":"1005.33","room_type_id":"319","product_id":"1309","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102238","customer_id":"102238","source_of_creation":"PMS","reservation_created_date":"2020-06-08 19:27:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"185.33","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":"3104006","reservation_id":"92243","confirmation_number":"SJ12627545003","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"1125.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":"1125.00","grand_total":"1125.00","paid_amount":"1125.00","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":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-02-20 13:30:47","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":"","changedComment":"Nightly price or discount changed","deltaChange":"1125.00","currentDayPrice":0,"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"}]},{"room_stay_id":"3104019","reservation_id":"92670","confirmation_number":"SJ12642460319","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"1125.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":"1125.00","grand_total":"1125.00","paid_amount":"1125.00","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":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-02-27 18:09:58","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":"","changedComment":"Nightly price or discount changed","deltaChange":"160.72","currentDayPrice":0,"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"}]},{"room_stay_id":"3104008","reservation_id":"92871","confirmation_number":"SJ12623092937","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"1125.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":"1125.00","grand_total":"1125.00","paid_amount":"1125.00","room_type_id":"319","product_id":"1314","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-03-02 19:24:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"1125.00","currentDayPrice":0,"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":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3103576","reservation_id":"96131","confirmation_number":"SJ12615685313","room_confirmation_number":"SJ12690595007","room_stay_from":"2020-06-10","room_stay_to":"2020-06-13","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"102259","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-06-10 11:34:05","reservation_modified_date_time":"2020-06-10 11:34:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102259","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.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":"3102811","reservation_id":"94915","confirmation_number":"SJ12633315373","room_confirmation_number":"SJ12683662249","room_stay_from":"2020-06-07","room_stay_to":"2020-06-12","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":"101107","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-17 20:28:10","reservation_modified_date_time":"2020-06-08 13:48:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101107","canceled_nights_data":"","posAmt_airbnb_taxpaid":"250.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":"3103111","reservation_id":"95142","confirmation_number":"SJ12635507931","room_confirmation_number":"SJ12612343365","room_stay_from":"2020-06-09","room_stay_to":"2020-06-12","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":"101324","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 19:19:09","reservation_modified_date_time":"2020-06-08 23:39:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101324","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":"3104188","reservation_id":"96309","confirmation_number":"SJ12699726207","room_confirmation_number":"SJ12634814069","room_stay_from":"2020-06-11","room_stay_to":"2020-06-12","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":"102433","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 01:22:54","reservation_modified_date_time":"2020-06-12 01:22:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102433","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":"3102118","reservation_id":"95457","confirmation_number":"SJ12673657748","room_confirmation_number":"SJ12638863033","room_stay_from":"2020-06-06","room_stay_to":"2020-06-13","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"101649","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 13:31:08","reservation_modified_date_time":"2020-06-06 18:33:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101649","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3102872","reservation_id":"96099","confirmation_number":"SJ12663768229","room_confirmation_number":"SJ12661317702","room_stay_from":"2020-06-10","room_stay_to":"2020-06-13","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":"102222","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-08 15:36:07","reservation_modified_date_time":"2020-06-08 15:36:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102222","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":"3103574","reservation_id":"95950","confirmation_number":"SJ12699641961","room_confirmation_number":"SJ12698824649","room_stay_from":"2020-06-10","room_stay_to":"2020-06-13","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":"102091","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-05 15:51:08","reservation_modified_date_time":"2020-06-10 11:33:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102091","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":"3103577","reservation_id":"96131","confirmation_number":"SJ12628150401","room_confirmation_number":"SJ12690595007","room_stay_from":"2020-06-10","room_stay_to":"2020-06-13","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":"102259","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-08 23:11:10","reservation_modified_date_time":"2020-06-10 11:34:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102259","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.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":"3103944","reservation_id":"94968","confirmation_number":"SJ12672689593","room_confirmation_number":"SJ12675032863","room_stay_from":"2020-06-11","room_stay_to":"2020-06-13","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":"101155","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 16:52:09","reservation_modified_date_time":"2020-06-11 11:31:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101485","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"3103056","reservation_id":"96122","confirmation_number":"SJ12636091874","room_confirmation_number":"SJ12638773559","room_stay_from":"2020-06-10","room_stay_to":"2020-06-14","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":"102249","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-08 21:10:08","reservation_modified_date_time":"2020-06-08 21:10:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102249","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":"3103556","reservation_id":"96188","confirmation_number":"SJ12649475624","room_confirmation_number":"SJ12659392304","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","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":"102312","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-09 22:38:14","reservation_modified_date_time":"2020-06-10 11:29:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102312","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":"3103569","reservation_id":"95914","confirmation_number":"SJ12616483239","room_confirmation_number":"SJ12655825060","room_stay_from":"2020-06-10","room_stay_to":"2020-06-14","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":"88571","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-04 20:37:46","reservation_modified_date_time":"2020-06-10 11:32:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88571","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":"3103775","reservation_id":"96232","confirmation_number":"SJ12651901710","room_confirmation_number":"SJ12627738528","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"102354","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-10 17:02:11","reservation_modified_date_time":"2020-06-10 17:51:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102354","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103829","reservation_id":"95915","confirmation_number":"SJ12626097273","room_confirmation_number":"SJ12698014034","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","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":"88530","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-04 20:40:13","reservation_modified_date_time":"2020-06-10 21:26:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88530","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":"3103835","reservation_id":"95088","confirmation_number":"SJ12649006473","room_confirmation_number":"SJ12651485681","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","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":"101270","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 01:12:14","reservation_modified_date_time":"2020-06-10 21:29:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101270","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":"3103937","reservation_id":"95113","confirmation_number":"SJ12692623733","room_confirmation_number":"SJ12690148968","room_stay_from":"2020-06-11","room_stay_to":"2020-06-14","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":"101296","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-20 13:41:07","reservation_modified_date_time":"2020-06-11 11:22:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101296","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":"3104157","reservation_id":"96116","confirmation_number":"SJ12670487911","room_confirmation_number":"SJ12613967995","room_stay_from":"2020-06-10","room_stay_to":"2020-06-14","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":"102238","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-08 19:27:53","reservation_modified_date_time":"2020-06-11 22:44:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102238","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":"3103821","reservation_id":"95047","confirmation_number":"SJ12678639902","room_confirmation_number":"SJ12654129472","room_stay_from":"2020-06-11","room_stay_to":"2020-06-15","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":"101234","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 15:41:07","reservation_modified_date_time":"2020-06-10 21:24:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101234","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":"3103932","reservation_id":"95385","confirmation_number":"SJ12616403927","room_confirmation_number":"SJ12673158128","room_stay_from":"2020-06-11","room_stay_to":"2020-06-16","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":"101577","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-25 18:04:10","reservation_modified_date_time":"2020-06-11 11:21:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101577","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":"3103981","reservation_id":"95843","confirmation_number":"SJ12629142723","room_confirmation_number":"SJ12630226163","room_stay_from":"2020-06-10","room_stay_to":"2020-06-11","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"102000","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-03 02:11:55","reservation_modified_date_time":"2020-06-11 15:13:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102000","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":"3103957","reservation_id":"96205","confirmation_number":"SJ12649315641","room_confirmation_number":"SJ12666669790","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102327","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-10 01:36:06","reservation_modified_date_time":"2020-06-11 12:46:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102327","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3103979","reservation_id":"95780","confirmation_number":"SJ12688676361","room_confirmation_number":"SJ12620269196","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"250.00","grand_total":"268.75","paid_amount":"268.75","product_id":"1709","service_quantity":"1","product_name":"Smoking Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-11 15:08:54","reservation_modified_date_time":"2020-06-11 15:08:54","customer_id":"101947","parentCustTravId":"101947","customer_traveller_id":"101947","static_pos_type":"smokingfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"250.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3103982","reservation_id":"95843","confirmation_number":"SJ12691482523","room_confirmation_number":"SJ12630226163","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-11 15:14:24","reservation_modified_date_time":"2020-06-11 15:14:24","customer_id":"102000","parentCustTravId":"102000","customer_traveller_id":"102000","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3104001","reservation_id":"95843","confirmation_number":"SJ12689480133","room_confirmation_number":"SJ12630226163","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"70.62","grand_total":"79.45","paid_amount":"0.00","product_id":"2052","service_quantity":"1","product_name":"Early Check-out Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-11 15:54:30","reservation_modified_date_time":"2020-06-11 15:54:30","customer_id":"102000","parentCustTravId":"102000","customer_traveller_id":"102000","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"70.62","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"106","tax_name":"Lodging Tax","tax_percentage":"12.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}