{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-08-28","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,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":22,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1273,1262,1915,1916,1291,1866,1282,1289,1313,1314","block_room_bookings":[{"confirmation_number":"SJ12646427749","room_stay_from":"2021-08-13","room_stay_to":"2021-09-02","bundle_room":"0","product_id":"1273"},{"confirmation_number":"SJ12621013614","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJ12684695201","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1915"},{"confirmation_number":"SJ12635511007","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1916"},{"confirmation_number":"SJ12674097679","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJ12685321405","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1866"},{"confirmation_number":"SJ12623483006","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1282"},{"confirmation_number":"SJ12635918059","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1289"},{"confirmation_number":"SJ12625950769","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1313"},{"confirmation_number":"SJ12620872636","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1314"}],"bundle_block_count":"1267,1268,1302,1303,1307,1308,1304,1305,1309,1310,1271,1272,1260,1261,1311,1312,1262,1263,1291,1711,1269,1270","bundle_block_bookings":[{"confirmation_number":"SJB12673498524","room_stay_from":"2021-08-28","room_stay_to":"2021-08-31","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12646318930","room_stay_from":"2021-08-26","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12691792978","room_stay_from":"2021-08-26","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12646996445","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12623981484","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12679462179","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12622757387","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12646372362","room_stay_from":"2021-08-26","room_stay_to":"2021-08-30","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12668829385","room_stay_from":"2021-08-26","room_stay_to":"2021-08-30","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12644427365","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12659357229","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12627784353","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12622617110","room_stay_from":"2021-08-27","room_stay_to":"2021-08-30","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12651854780","room_stay_from":"2021-08-27","room_stay_to":"2021-08-30","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12658042837","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12682879752","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12670317189","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12643835296","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","bundle_room":"0","product_id":"1270"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3272640","reservation_id":"117930","confirmation_number":"SJ12618152709","room_stay_from":"2021-08-25","room_stay_to":"2021-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,230.30,230.30,160.30,160.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1143.80","grand_total":"1286.78","paid_amount":"203.97","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3269772448","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":"124923","customer_id":"124923","source_of_creation":"Booking.com","reservation_created_date":"2021-06-23 23:50:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"232.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.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":"3284965","reservation_id":"119425","confirmation_number":"SJ12656723896","room_stay_from":"2021-08-28","room_stay_to":"2021-09-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,160.30,160.30,160.30,153.30","nightly_discount":"0,0,0,0,0","subtotal":"864.50","grand_total":"972.57","paid_amount":"972.57","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-3308992229","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":"126567","customer_id":"126567","source_of_creation":"Booking.com","reservation_created_date":"2021-07-16 00:59:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"178.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.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":"3287076","reservation_id":"119716","confirmation_number":"SJ12687554564","room_stay_from":"2021-08-26","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"230.24,272.77,272.77","nightly_discount":"0,0,0","subtotal":"775.78","grand_total":"872.75","paid_amount":"872.75","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-2266092744","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":"126912","customer_id":"126912","source_of_creation":"Booking.com","reservation_created_date":"2021-07-20 16:54:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"153.14","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"272.77","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":"3287232","reservation_id":"119726","confirmation_number":"SJ12621028438","room_stay_from":"2021-08-28","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.54,129.84,129.84,129.84,124.17,124.17,186.54,203.55","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1214.49","grand_total":"1366.30","paid_amount":"1366.30","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-2136730789","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":"126919","customer_id":"126919","source_of_creation":"Booking.com","reservation_created_date":"2021-07-20 18:10:29","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"254.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"186.54","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":"3290537","reservation_id":"119739","confirmation_number":"SJ12675467876","room_stay_from":"2021-08-28","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.54,129.84,129.84,129.84,124.17,124.17,186.54,203.55","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1214.49","grand_total":"1366.30","paid_amount":"1366.30","room_type_id":"319","product_id":"1276","siteminder_id":"BDC-2793188004","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":"126933","customer_id":"126933","source_of_creation":"Booking.com","reservation_created_date":"2021-07-20 20:28:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","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":"186.54","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":"4151078","reservation_id":"115765","confirmation_number":"SJ12627565711","room_stay_from":"2021-08-23","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.37,125.37,125.37,125.37,188.37,188.37,125.37","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1003.59","grand_total":"1129.04","paid_amount":"1129.04","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-3927548053","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":"122542","customer_id":"122542","source_of_creation":"Booking.com","reservation_created_date":"2021-05-24 01:46:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"212.15","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"188.37","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":"5294554","reservation_id":"121882","confirmation_number":"SJ12638089792","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"205.86","nightly_discount":"0","subtotal":"205.86","grand_total":"231.59","paid_amount":"231.59","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-3043902367","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":"129406","customer_id":"129406","source_of_creation":"Booking.com","reservation_created_date":"2021-08-25 02:08:13","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"41.55","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"205.86","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":"5303677","reservation_id":"120147","confirmation_number":"SJ12683038898","room_stay_from":"2021-08-26","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"151.83,185.58,185.58","nightly_discount":"0,0,0","subtotal":"522.99","grand_total":"588.36","paid_amount":"588.36","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-2861037759","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"127402","customer_id":"127402","source_of_creation":"Booking.com","reservation_created_date":"2021-07-26 21:36:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"134.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"185.58","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":"5303961","reservation_id":"121080","confirmation_number":"SJ12683044860","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"309.14","nightly_discount":"0","subtotal":"309.14","grand_total":"347.79","paid_amount":"347.79","room_type_id":"320","product_id":"1324","siteminder_id":"BDC-3411622202","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":"128512","customer_id":"128512","source_of_creation":"Booking.com","reservation_created_date":"2021-08-12 00:48:14","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"60.15","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1271,1272","currentDayPrice":"309.14","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":"5304109","reservation_id":"121756","confirmation_number":"SJ12635172341","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"296.65","nightly_discount":"0","subtotal":"296.65","grand_total":"333.73","paid_amount":"333.73","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-3227152606","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":"129297","customer_id":"129297","source_of_creation":"Booking.com","reservation_created_date":"2021-08-23 16:11:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"57.90","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"296.65","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":"5304367","reservation_id":"121209","confirmation_number":"SJ12613695328","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"230.30,230.30,160.30,139.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"760.20","grand_total":"855.23","paid_amount":"855.23","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-3790077817","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":"128679","customer_id":"128679","source_of_creation":"Booking.com","reservation_created_date":"2021-08-15 01:01:18","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.30","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":"5304638","reservation_id":"122056","confirmation_number":"SJ12680394796","room_stay_from":"2021-08-27","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"193.75,193.75","nightly_discount":"0,0","subtotal":"387.50","grand_total":"435.94","paid_amount":"435.94","room_type_id":"319","product_id":"1711","siteminder_id":"BDC-2687495875","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":"129607","customer_id":"129607","source_of_creation":"Booking.com","reservation_created_date":"2021-08-28 00:30:30","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","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":"193.75","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":"5304669","reservation_id":"120946","confirmation_number":"SJ12682500759","room_stay_from":"2021-08-27","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"287.28,287.28","nightly_discount":"0.00,0.00","subtotal":"574.56","grand_total":"646.38","paid_amount":"646.38","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-2387908862","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":"128360","customer_id":"128360","source_of_creation":"Booking.com","reservation_created_date":"2021-08-08 18:21:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"287.28","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":"5304689","reservation_id":"122062","confirmation_number":"SJ12695844335","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"419.99","nightly_discount":"0","subtotal":"419.99","grand_total":"472.49","paid_amount":"472.49","room_type_id":"320","product_id":"1323","siteminder_id":"BDC-3350102242","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":"129615","customer_id":"129615","source_of_creation":"Booking.com","reservation_created_date":"2021-08-28 02:47:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"80.10","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1269,1270","currentDayPrice":"419.99","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":"5304885","reservation_id":"121588","confirmation_number":"SJ12686523609","room_stay_from":"2021-08-28","room_stay_to":"2021-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"224.25,149.25,149.25","nightly_discount":"0,0,0","subtotal":"522.75","grand_total":"588.10","paid_amount":"167.90","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-2111625187","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":"129080","customer_id":"129080","source_of_creation":"Booking.com","reservation_created_date":"2021-08-20 19:34:19","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":"","sub_hotel_id":"126","currentDayPrice":"224.25","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":"5305068","reservation_id":"121890","confirmation_number":"SJ12623799311","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"205.86","nightly_discount":"0","subtotal":"205.86","grand_total":"231.59","paid_amount":"231.59","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-3067101824","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":"129417","customer_id":"129417","source_of_creation":"Booking.com","reservation_created_date":"2021-08-25 14:38:13","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"41.55","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"205.86","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":"5305189","reservation_id":"113273","confirmation_number":"SJ12617941038","room_stay_from":"2021-09-17","room_stay_to":"2021-09-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.83,201.83,134.33,134.33","nightly_discount":"0,0,0,0","subtotal":"672.32","grand_total":"756.36","paid_amount":"230.85","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-2995318889","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":"119862","customer_id":"119862","source_of_creation":"Booking.com","reservation_created_date":"2021-04-18 01:13:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[{"room_stay_id":"3195958","reservation_id":"107355","confirmation_number":"SJ12611683543","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","room_stay_status":"Canceled","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"321.56","room_type_id":"320","product_id":"1320","siteminder_id":"BDC-2116424903","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113813","customer_id":"113813","source_of_creation":"Booking.com","reservation_created_date":"2021-02-11 17:58:07","service_canceled_date_time":"2021-07-28 12:47:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","ota_service_fee_amount":"0","commision_charges":"64.95","sub_hotel_id":"126","deltaChange":"321.56","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3300689","reservation_id":"118527","confirmation_number":"SJ12626265103","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"1","nightly_price":"279.44,279.44,223.44,223.44","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1005.76","grand_total":"1131.48","paid_amount":"1131.48","room_type_id":"320","product_id":"1330","siteminder_id":"EXP-1794684960","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":"125560","customer_id":"125560","source_of_creation":"Expedia","reservation_created_date":"2021-07-02 15:21:07","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":null,"sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"279.44","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":"4165427","reservation_id":"120368","confirmation_number":"SJ12660255677","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"6","nightly_price":"407.32","nightly_discount":"0","subtotal":"407.32","grand_total":"458.24","paid_amount":"458.24","room_type_id":"320","product_id":"1329","siteminder_id":"EXP-1808791684","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":"127645","customer_id":"127645","source_of_creation":"Expedia","reservation_created_date":"2021-07-29 22:06:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"407.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":"5294311","reservation_id":"117027","confirmation_number":"SJ12615383475","room_stay_from":"2021-08-24","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.04,145.04,145.04,184.24,184.24,128.24","nightly_discount":"0,0,0,0,0,0","subtotal":"931.84","grand_total":"1048.32","paid_amount":"1048.32","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1783877373","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":"123967","customer_id":"123967","source_of_creation":"Expedia","reservation_created_date":"2021-06-11 16:01:17","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"186.37","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"184.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":"5303874","reservation_id":"121935","confirmation_number":"SJ12666144417","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.20","nightly_discount":"0","subtotal":"179.20","grand_total":"201.60","paid_amount":"201.60","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1821257857","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":"129654","customer_id":"129474","source_of_creation":"Expedia","reservation_created_date":"2021-08-26 01:16:17","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":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"179.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3241166","reservation_id":"113795","confirmation_number":"SJ12617087770","room_stay_from":"2021-08-26","room_stay_to":"2021-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.26,144.99,144.99,107.26,107.26","nightly_discount":"0,0,0,0,0","subtotal":"611.76","grand_total":"688.23","paid_amount":"688.23","room_type_id":"413","product_id":"1268","siteminder_id":"GAM-R2471843451","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":"120408","customer_id":"120408","source_of_creation":"Getaroom.com","reservation_created_date":"2021-04-24 18:17:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"144.99","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":"5304417","reservation_id":"119139","confirmation_number":"SJ12680645831","room_stay_from":"2021-08-27","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"276.14,276.14,214.64","nightly_discount":"0.00,0.00,0.00","subtotal":"766.92","grand_total":"862.79","paid_amount":"862.79","room_type_id":"320","product_id":"1332","siteminder_id":"GAM-R2652976348","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":"126259","customer_id":"126259","source_of_creation":"Getaroom.com","reservation_created_date":"2021-07-11 20:11:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"276.14","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"5304715","reservation_id":"122052","confirmation_number":"SJ12687326108","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"244.63","nightly_discount":"0.00","subtotal":"244.63","grand_total":"287.96","paid_amount":"287.96","room_type_id":"413","product_id":"1260","siteminder_id":"ABB-HM3KXK5FTP","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"274.38","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129602","customer_id":"129602","source_of_creation":"Airbnb","reservation_created_date":"2021-08-27 23:48:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"8.07","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"244.63","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.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"5305041","reservation_id":"122013","confirmation_number":"SJ12677081658","room_stay_from":"2021-08-28","room_stay_to":"2021-09-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"72.96,231.83,231.83,231.83","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"768.45","grand_total":"915.20","paid_amount":"915.20","room_type_id":"319","product_id":"1756","siteminder_id":"ABB-HMHPHCBXZH","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"927.32","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129551","customer_id":"129551","source_of_creation":"Airbnb","reservation_created_date":"2021-08-27 17:49:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"28.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"72.96","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":"5.00","abb_tax_paid_sm":"0.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"5305070","reservation_id":"118676","confirmation_number":"SJ12613128135","room_stay_from":"2021-08-28","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.90,215.90","nightly_discount":"0.00,0.00","subtotal":"516.80","grand_total":"581.40","paid_amount":"581.40","room_type_id":"412","product_id":"1316","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125750","customer_id":"125750","source_of_creation":"FE","reservation_created_date":"2021-07-04 18:39:43","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":"","sub_hotel_id":"0","currentDayPrice":"300.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3223325","reservation_id":"111426","confirmation_number":"SJ12674055602","room_stay_from":"2021-08-24","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.15,152.15,152.15,203.15,203.15","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"862.75","grand_total":"970.60","paid_amount":"970.60","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109507","customer_id":"109507","source_of_creation":"PMS","reservation_created_date":"2021-03-27 14:31:34","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"203.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":"5303872","reservation_id":"121296","confirmation_number":"SJ12636090665","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.25,269.25,194.25,171.75","nightly_discount":"13.46,13.46,9.71,8.59","subtotal":"904.50","grand_total":"966.69","paid_amount":"966.69","room_type_id":"319","product_id":"1917","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":"128772","customer_id":"128772","source_of_creation":"PMS","reservation_created_date":"2021-08-16 21:00:02","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":"FLRES","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"269.25","currentDayDiscount":"13.46","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":"5303914","reservation_id":"119684","confirmation_number":"SJ12684842435","room_stay_from":"2021-08-26","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"284.50,284.55,284.55,284.55","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1138.15","grand_total":"1280.42","paid_amount":"1280.42","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":"126882","customer_id":"126882","source_of_creation":"PMS","reservation_created_date":"2021-07-20 00:48:36","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":"","sub_hotel_id":"0","group_rooms":"1309,1310","currentDayPrice":"284.55","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":"5304288","reservation_id":"122018","confirmation_number":"SJ12656151871","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.33","nightly_discount":"0.00","subtotal":"203.33","grand_total":"228.75","paid_amount":"228.75","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129556","customer_id":"129556","source_of_creation":"PMS","reservation_created_date":"2021-08-27 18:25:23","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"203.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":"5304797","reservation_id":"122080","confirmation_number":"SJ12649781420","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00","nightly_discount":"0.00","subtotal":"215.00","grand_total":"241.88","paid_amount":"241.88","room_type_id":"319","product_id":"1287","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":"121923","customer_id":"121923","source_of_creation":"PMS","reservation_created_date":"2021-08-28 14:47:47","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"215.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":"5304801","reservation_id":"122081","confirmation_number":"SJ12656876632","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00","nightly_discount":"0.00","subtotal":"215.00","grand_total":"241.88","paid_amount":"241.88","room_type_id":"319","product_id":"1286","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":"125896","customer_id":"125896","source_of_creation":"PMS","reservation_created_date":"2021-08-28 14:49:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"215.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":"5305141","reservation_id":"119307","confirmation_number":"SJ12642302177","room_stay_from":"2021-08-28","room_stay_to":"2021-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"246.75,171.75,171.75","nightly_discount":"24.68,17.18,17.18","subtotal":"590.25","grand_total":"597.61","paid_amount":"597.61","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126438","customer_id":"126438","source_of_creation":"PMS","reservation_created_date":"2021-07-14 14:47:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"special123","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"246.75","currentDayDiscount":"24.68","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[{"room_stay_id":"3301398","reservation_id":"121063","confirmation_number":"SJ12672465911","room_stay_from":"2021-08-28","room_stay_to":"2021-09-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"480.00","grand_total":"540.00","paid_amount":"540.00","room_type_id":"413","product_id":"1267","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2021-08-11 18:09:10","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"96.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"}]}],"negotiated_non_taxable":[{"room_stay_id":"3276411","reservation_id":"118469","confirmation_number":"SJ12647800824","room_stay_from":"2021-08-28","room_stay_to":"2021-09-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,96.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"672.00","grand_total":"672.00","paid_amount":"672.00","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2021-07-01 17:26:03","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":"0","group_rooms":null,"currentDayPrice":"96.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5302958","reservation_id":"116012","confirmation_number":"SJ12630564519","room_stay_from":"2021-08-26","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1277","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":"2021-05-27 20:50:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303034","reservation_id":"117109","confirmation_number":"SJ12652318238","room_stay_from":"2021-08-27","room_stay_to":"2021-09-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1288","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":"2021-06-12 20:24:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303372","reservation_id":"116486","confirmation_number":"SJ12677692283","room_stay_from":"2021-08-26","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"412","product_id":"1315","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":"2021-06-03 22:48:59","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303378","reservation_id":"113926","confirmation_number":"SJ12687881952","room_stay_from":"2021-08-26","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1306","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":"2021-04-26 18:25:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303979","reservation_id":"116030","confirmation_number":"SJ12693196808","room_stay_from":"2021-08-26","room_stay_to":"2021-08-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.66","nightly_discount":"0.00,0.00,0.00","subtotal":"260.00","grand_total":"260.00","paid_amount":"112.51","room_type_id":"319","product_id":"1293","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":"2021-05-27 22:16:42","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.66","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5304651","reservation_id":"115585","confirmation_number":"SJ12625515998","room_stay_from":"2021-08-27","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1943","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":"2021-05-20 22:52:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5304887","reservation_id":"112806","confirmation_number":"SJ12689848645","room_stay_from":"2021-08-08","room_stay_to":"2021-08-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"86.67,86.67,86.66","nightly_discount":"0.00,0.00,0.00","subtotal":"260.00","grand_total":"260.00","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":"2021-04-12 21:46:02","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":"","sub_hotel_id":"0","changedComment":"Nightly price or discount changed","deltaChange":"-0.01","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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3300692","reservation_id":"118527","confirmation_number":"SJ12621765096","room_confirmation_number":"SJ12626265103","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0,0,0,0","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"125560","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-08-09 21:02:10","reservation_modified_date_time":"2021-08-09 21:02:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125560","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"50","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":"5303678","reservation_id":"120147","confirmation_number":"SJ12683001069","room_confirmation_number":"SJ12683038898","room_stay_from":"2021-08-26","room_stay_to":"2021-08-29","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"127402","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-08-26 14:30:12","reservation_modified_date_time":"2021-08-26 14:30:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127402","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","currentDayPrice":"50","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":"5304368","reservation_id":"121209","confirmation_number":"SJ12683767829","room_confirmation_number":"SJ12613695328","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"128679","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-08-27 20:24:14","reservation_modified_date_time":"2021-08-27 20:24:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128679","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","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":"5304670","reservation_id":"120946","confirmation_number":"SJ12668643160","room_confirmation_number":"SJ12682500759","room_stay_from":"2021-08-27","room_stay_to":"2021-08-29","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"128360","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-08-28 01:16:34","reservation_modified_date_time":"2021-08-28 01:16:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128360","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"50","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3223326","reservation_id":"111426","confirmation_number":"SJ12657222609","room_confirmation_number":"SJ12674055602","room_stay_from":"2021-08-24","room_stay_to":"2021-08-29","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":"109507","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-27 14:31:34","reservation_modified_date_time":"2021-03-27 14:32:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109507","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3241167","reservation_id":"113795","confirmation_number":"SJ12638813940","room_confirmation_number":"SJ12617087770","room_stay_from":"2021-08-26","room_stay_to":"2021-08-31","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":"120408","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-24 18:17:10","reservation_modified_date_time":"2021-04-24 18:17:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120408","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3272641","reservation_id":"117930","confirmation_number":"SJ12638790025","room_confirmation_number":"SJ12618152709","room_stay_from":"2021-08-25","room_stay_to":"2021-08-31","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124923","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-23 23:50:13","reservation_modified_date_time":"2021-06-23 23:50:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124923","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3276412","reservation_id":"118469","confirmation_number":"SJ12638518959","room_confirmation_number":"SJ12647800824","room_stay_from":"2021-08-28","room_stay_to":"2021-09-04","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":"125501","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-01 17:26:03","reservation_modified_date_time":"2021-07-01 17:26:03","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3284966","reservation_id":"119425","confirmation_number":"SJ12672952710","room_confirmation_number":"SJ12656723896","room_stay_from":"2021-08-28","room_stay_to":"2021-09-02","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":"126567","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-16 00:59:09","reservation_modified_date_time":"2021-07-16 00:59:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126567","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3287077","reservation_id":"119716","confirmation_number":"SJ12684102986","room_confirmation_number":"SJ12687554564","room_stay_from":"2021-08-26","room_stay_to":"2021-08-29","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":"126912","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-20 16:54:13","reservation_modified_date_time":"2021-07-20 16:54:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126912","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3287233","reservation_id":"119726","confirmation_number":"SJ12633658215","room_confirmation_number":"SJ12621028438","room_stay_from":"2021-08-28","room_stay_to":"2021-09-05","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126919","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-20 18:10:29","reservation_modified_date_time":"2021-07-20 21:33:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126919","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3290536","reservation_id":"119739","confirmation_number":"SJ12625742911","room_confirmation_number":"SJ12675467876","room_stay_from":"2021-08-28","room_stay_to":"2021-09-05","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126933","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-20 20:28:57","reservation_modified_date_time":"2021-07-26 19:11:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126933","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3300693","reservation_id":"118527","confirmation_number":"SJ12676895078","room_confirmation_number":"SJ12626265103","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","room_stay_status":"Active","nightly_price":"25,25,25,25","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":"125560","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-02 15:21:07","reservation_modified_date_time":"2021-08-09 21:02:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125560","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3301399","reservation_id":"121063","confirmation_number":"SJ12699355961","room_confirmation_number":"SJ12672465911","room_stay_from":"2021-08-28","room_stay_to":"2021-09-02","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":"128488","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-11 18:09:10","reservation_modified_date_time":"2021-08-11 18:09:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"4151088","reservation_id":"115765","confirmation_number":"SJ12648855885","room_confirmation_number":"SJ12627565711","room_stay_from":"2021-08-23","room_stay_to":"2021-08-30","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":"122542","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-24 01:46:11","reservation_modified_date_time":"2021-08-21 18:58:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122542","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"4166237","reservation_id":"120368","confirmation_number":"SJ12648743701","room_confirmation_number":"SJ12660255677","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","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":"127645","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-29 22:06:11","reservation_modified_date_time":"2021-08-21 19:00:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127645","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5294312","reservation_id":"117027","confirmation_number":"SJ12637911978","room_confirmation_number":"SJ12615383475","room_stay_from":"2021-08-24","room_stay_to":"2021-08-30","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25","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":"123967","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-11 16:01:17","reservation_modified_date_time":"2021-08-24 15:36:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123967","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5294555","reservation_id":"121882","confirmation_number":"SJ12615608053","room_confirmation_number":"SJ12638089792","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","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":"129406","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-25 02:08:13","reservation_modified_date_time":"2021-08-25 02:08:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129406","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5302957","reservation_id":"116012","confirmation_number":"SJ12618720475","room_confirmation_number":"SJ12630564519","room_stay_from":"2021-08-26","room_stay_to":"2021-08-29","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":"122823","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-27 20:50:19","reservation_modified_date_time":"2021-08-25 19:06:15","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303033","reservation_id":"117109","confirmation_number":"SJ12641798094","room_confirmation_number":"SJ12652318238","room_stay_from":"2021-08-27","room_stay_to":"2021-09-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124044","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-12 20:24:53","reservation_modified_date_time":"2021-08-25 19:06:16","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303371","reservation_id":"116486","confirmation_number":"SJ12647865161","room_confirmation_number":"SJ12677692283","room_stay_from":"2021-08-26","room_stay_to":"2021-08-29","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":"123358","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-03 22:48:59","reservation_modified_date_time":"2021-08-25 19:06:22","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303377","reservation_id":"113926","confirmation_number":"SJ12663271336","room_confirmation_number":"SJ12687881952","room_stay_from":"2021-08-26","room_stay_to":"2021-08-29","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":"120561","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-26 18:25:25","reservation_modified_date_time":"2021-08-25 19:06:22","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303679","reservation_id":"120147","confirmation_number":"SJ12667183593","room_confirmation_number":"SJ12683038898","room_stay_from":"2021-08-26","room_stay_to":"2021-08-29","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":"127402","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-26 21:36:15","reservation_modified_date_time":"2021-08-26 14:30:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127402","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","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":"5303873","reservation_id":"121296","confirmation_number":"SJ12676047550","room_confirmation_number":"SJ12636090665","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","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":"128772","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-16 21:00:02","reservation_modified_date_time":"2021-08-26 20:41:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128772","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303875","reservation_id":"121935","confirmation_number":"SJ12645185959","room_confirmation_number":"SJ12666144417","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","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":"129654","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-26 01:16:17","reservation_modified_date_time":"2021-08-26 20:42:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129474","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5303917","reservation_id":"119684","confirmation_number":"SJ12693815257","room_confirmation_number":"SJ12684842435","room_stay_from":"2021-08-26","room_stay_to":"2021-08-30","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":"126882","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-20 00:48:36","reservation_modified_date_time":"2021-08-26 21:28:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126882","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5303964","reservation_id":"121080","confirmation_number":"SJ12649490769","room_confirmation_number":"SJ12683044860","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","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":"128512","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-12 00:48:14","reservation_modified_date_time":"2021-08-26 22:25:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128512","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5303981","reservation_id":"116030","confirmation_number":"SJ12682317046","room_confirmation_number":"SJ12693196808","room_stay_from":"2021-08-26","room_stay_to":"2021-08-29","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":"122840","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-27 22:16:42","reservation_modified_date_time":"2021-08-26 22:33:51","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5304111","reservation_id":"121756","confirmation_number":"SJ12626982449","room_confirmation_number":"SJ12635172341","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","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":"129297","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-23 16:11:15","reservation_modified_date_time":"2021-08-27 12:11:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129297","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5304289","reservation_id":"122018","confirmation_number":"SJ12677367383","room_confirmation_number":"SJ12656151871","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","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":"129556","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-27 18:25:23","reservation_modified_date_time":"2021-08-27 18:26:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129556","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5304369","reservation_id":"121209","confirmation_number":"SJ12619479469","room_confirmation_number":"SJ12613695328","room_stay_from":"2021-08-27","room_stay_to":"2021-08-31","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":"128679","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-15 01:01:18","reservation_modified_date_time":"2021-08-27 20:24:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128679","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5304420","reservation_id":"119139","confirmation_number":"SJ12663164553","room_confirmation_number":"SJ12680645831","room_stay_from":"2021-08-27","room_stay_to":"2021-08-30","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":"1776","service_quantity":"1","customer_traveller_id":"126259","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-11 20:11:11","reservation_modified_date_time":"2021-08-27 21:07:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126259","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5304637","reservation_id":"122056","confirmation_number":"SJ12699560465","room_confirmation_number":"SJ12680394796","room_stay_from":"2021-08-27","room_stay_to":"2021-08-29","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":"129607","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-28 00:30:30","reservation_modified_date_time":"2021-08-28 00:39:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129607","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5304652","reservation_id":"115585","confirmation_number":"SJ12651089318","room_confirmation_number":"SJ12625515998","room_stay_from":"2021-08-27","room_stay_to":"2021-08-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"122337","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-20 22:52:10","reservation_modified_date_time":"2021-08-28 00:54:51","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5304671","reservation_id":"120946","confirmation_number":"SJ12657122980","room_confirmation_number":"SJ12682500759","room_stay_from":"2021-08-27","room_stay_to":"2021-08-29","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":"128360","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-08 18:21:15","reservation_modified_date_time":"2021-08-28 01:16:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128360","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5304690","reservation_id":"122062","confirmation_number":"SJ12680392951","room_confirmation_number":"SJ12695844335","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","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":"129615","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-28 02:47:10","reservation_modified_date_time":"2021-08-28 02:47:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129615","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5304716","reservation_id":"122052","confirmation_number":"SJ12690514834","room_confirmation_number":"SJ12687326108","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","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":"129602","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-27 23:48:11","reservation_modified_date_time":"2021-08-28 12:51:26","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129602","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","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":"5304798","reservation_id":"122080","confirmation_number":"SJ12658001611","room_confirmation_number":"SJ12649781420","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","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":"121923","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-28 14:47:47","reservation_modified_date_time":"2021-08-28 14:47:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121923","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5304802","reservation_id":"122081","confirmation_number":"SJ12643958283","room_confirmation_number":"SJ12656876632","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","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":"125896","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-28 14:49:12","reservation_modified_date_time":"2021-08-28 14:49:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125896","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5304886","reservation_id":"121588","confirmation_number":"SJ12666500696","room_confirmation_number":"SJ12686523609","room_stay_from":"2021-08-28","room_stay_to":"2021-08-31","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"129080","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 19:34:19","reservation_modified_date_time":"2021-08-28 16:20:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129080","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5305042","reservation_id":"122013","confirmation_number":"SJ12665392057","room_confirmation_number":"SJ12677081658","room_stay_from":"2021-08-28","room_stay_to":"2021-09-01","room_stay_status":"Active","nightly_price":"25,25,25,25","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":"129551","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-27 17:49:07","reservation_modified_date_time":"2021-08-28 19:35:25","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129551","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","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":"5305069","reservation_id":"121890","confirmation_number":"SJ12625322795","room_confirmation_number":"SJ12623799311","room_stay_from":"2021-08-28","room_stay_to":"2021-08-29","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":"129417","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-25 14:38:13","reservation_modified_date_time":"2021-08-28 20:17:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129417","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"5305071","reservation_id":"118676","confirmation_number":"SJ12649725073","room_confirmation_number":"SJ12613128135","room_stay_from":"2021-08-28","room_stay_to":"2021-08-30","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"125750","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-04 18:39:43","reservation_modified_date_time":"2021-08-28 20:18:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125750","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5305142","reservation_id":"119307","confirmation_number":"SJ12678100684","room_confirmation_number":"SJ12642302177","room_stay_from":"2021-08-28","room_stay_to":"2021-08-31","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"126438","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-14 14:47:57","reservation_modified_date_time":"2021-08-28 22:30:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126438","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"5305190","reservation_id":"113273","confirmation_number":"SJ12635014180","room_confirmation_number":"SJ12617941038","room_stay_from":"2021-09-17","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"25,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":"119862","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-18 01:13:11","reservation_modified_date_time":"2021-08-28 23:24:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119862","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}