{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-02-22","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":17,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1286,1297","block_room_bookings":[{"confirmation_number":"SJ12636364020","room_stay_from":"2021-02-22","room_stay_to":"2021-02-23","bundle_room":"0","product_id":"1286"},{"confirmation_number":"SJ12680392580","room_stay_from":"2021-02-18","room_stay_to":"2021-02-28","bundle_room":"0","product_id":"1297"}],"bundle_block_count":"1260,1261,1304,1305,1309,1310,1262,1263,1291,1711,1271,1272,1311,1312,1307,1308,1267,1268,1269,1270,1302,1303","bundle_block_bookings":[{"confirmation_number":"SJB12690136283","room_stay_from":"2021-02-21","room_stay_to":"2021-02-23","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12660715736","room_stay_from":"2021-02-18","room_stay_to":"2021-02-23","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12610562601","room_stay_from":"2021-02-18","room_stay_to":"2021-02-23","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12669558217","room_stay_from":"2021-02-21","room_stay_to":"2021-02-23","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12699607765","room_stay_from":"2021-02-20","room_stay_to":"2021-02-24","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12657578174","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12664365860","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12681415744","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12666901296","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12634496058","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","bundle_room":"1","product_id":"1332"},{"confirmation_number":"SJB12654035203","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","bundle_room":"1","product_id":"1330"},{"confirmation_number":"SJB12629776051","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12686255054","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12671736056","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12612334921","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12662873179","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","bundle_room":"0","product_id":"1303"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3202354","reservation_id":"108182","confirmation_number":"SJ12687587181","room_stay_from":"2021-02-21","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.15,213.19","nightly_discount":"0,0","subtotal":"439.34","grand_total":"494.26","paid_amount":"494.26","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3102839523","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":"114647","customer_id":"114647","source_of_creation":"Booking.com","reservation_created_date":"2021-02-21 17:40:20","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","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":"213.19","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":"3192731","reservation_id":"105778","confirmation_number":"SJ12643903300","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"151.26,151.26,151.26","nightly_discount":"0,0,0","subtotal":"453.78","grand_total":"510.50","paid_amount":"510.50","room_type_id":"319","product_id":"1311","siteminder_id":"BDC-2471178951","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":"112180","customer_id":"112180","source_of_creation":"Booking.com","reservation_created_date":"2021-01-21 06:30:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"95.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"151.26","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":"3201094","reservation_id":"108050","confirmation_number":"SJ12626593000","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"242.33,242.33,242.33","nightly_discount":"0,0,0","subtotal":"726.99","grand_total":"817.86","paid_amount":"817.86","room_type_id":"319","product_id":"1308","siteminder_id":"BDC-3352818358","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":"114517","customer_id":"114517","source_of_creation":"Booking.com","reservation_created_date":"2021-02-19 18:12:36","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"242.33","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":"3194885","reservation_id":"104679","confirmation_number":"SJ12636630959","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.30,174.30,174.30,174.30","nightly_discount":"0,0,0,0","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-2513680211","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":"111033","customer_id":"111033","source_of_creation":"Booking.com","reservation_created_date":"2021-01-04 00:53:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"143.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.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":"3179464","reservation_id":"104587","confirmation_number":"SJ12686301450","room_stay_from":"2021-02-19","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.30,202.30,174.30,174.30,174.30,174.30,174.30,202.30","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1478.40","grand_total":"1663.20","paid_amount":"1663.20","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-2331247034","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":"114516","customer_id":"110936","source_of_creation":"Booking.com","reservation_created_date":"2021-01-02 18:01:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"302.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.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":"3184971","reservation_id":"106179","confirmation_number":"SJ12615389852","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.67,194.67,175.77,175.77,175.77,200.97","nightly_discount":"0,0,0,0,0,0","subtotal":"1117.62","grand_total":"1257.32","paid_amount":"1257.32","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2126163221","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":"112586","customer_id":"112586","source_of_creation":"Booking.com","reservation_created_date":"2021-01-26 18:01:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"228.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"194.67","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":"3200914","reservation_id":"106188","confirmation_number":"SJ12640825161","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"238.77,194.67,194.67,175.77,175.77,175.77,200.97","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1356.39","grand_total":"1525.94","paid_amount":"1525.94","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3239349705","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":"112595","customer_id":"112595","source_of_creation":"Booking.com","reservation_created_date":"2021-01-26 19:37:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"275.66","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"194.67","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":"3202920","reservation_id":"107433","confirmation_number":"SJ12695963627","room_stay_from":"2021-03-31","room_stay_to":"2021-04-04","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"271.15,271.15,330.55,305.15","nightly_discount":"0,0,0,0","subtotal":"1178.00","grand_total":"1325.25","paid_amount":"686.60","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-2999273003","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":"113888","customer_id":"113888","source_of_creation":"Booking.com","reservation_created_date":"2021-02-12 15:46:18","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":"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":[],"exp_taxable":[{"room_stay_id":"3174267","reservation_id":"104751","confirmation_number":"SJ12683537895","room_stay_from":"2021-02-18","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.30,202.30,202.30,174.30,174.30","nightly_discount":"0,0,0,0,0","subtotal":"927.50","grand_total":"1043.44","paid_amount":"1043.44","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1727606096","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":"111104","customer_id":"111104","source_of_creation":"Expedia","reservation_created_date":"2021-01-05 01:56:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"0","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.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":"3192531","reservation_id":"106990","confirmation_number":"SJ12684637228","room_stay_from":"2021-02-15","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.04,159.04,159.04,159.04,159.04,159.04,159.04,150.64","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1263.92","grand_total":"1421.91","paid_amount":"1421.91","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1735623211","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":"113427","customer_id":"113427","source_of_creation":"Expedia","reservation_created_date":"2021-02-05 22:15:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","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":"150.64","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":"3197129","reservation_id":"106517","confirmation_number":"SJ12673506797","room_stay_from":"2021-02-22","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"223.72","nightly_discount":"0","subtotal":"223.72","grand_total":"251.69","paid_amount":"251.69","room_type_id":"319","product_id":"1943","siteminder_id":"EXP-1734016807","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":"112926","customer_id":"112926","source_of_creation":"Expedia","reservation_created_date":"2021-01-30 22:31:08","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":"126","group_rooms":null,"currentDayPrice":"223.72","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3201160","reservation_id":"105087","confirmation_number":"SJ12688982589","room_stay_from":"2021-02-19","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"244.30,244.30,174.30,174.30","nightly_discount":"0,0,0,0","subtotal":"837.20","grand_total":"941.85","paid_amount":"941.85","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1728752820","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":"111461","customer_id":"111461","source_of_creation":"Expedia","reservation_created_date":"2021-01-09 20:36:13","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":"174.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":"3180456","reservation_id":"105515","confirmation_number":"SJ12650920347","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"223.44,223.44,223.44,223.44","nightly_discount":"0,0,0,0","subtotal":"893.76","grand_total":"1005.48","paid_amount":"1005.48","room_type_id":"320","product_id":"1714","siteminder_id":"EXP-1730698443","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":"111930","customer_id":"111930","source_of_creation":"Expedia","reservation_created_date":"2021-01-17 18:41:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1291,1711","currentDayPrice":"223.44","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":"3181138","reservation_id":"105583","confirmation_number":"SJ12657879374","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.30,195.30,195.30,195.30","nightly_discount":"0,0,0,0","subtotal":"781.20","grand_total":"878.85","paid_amount":"878.85","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1731006446","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":"112004","customer_id":"112004","source_of_creation":"Expedia","reservation_created_date":"2021-01-18 23:11:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.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":"3184773","reservation_id":"106060","confirmation_number":"SJ12657448160","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,299.25,299.25","nightly_discount":"0,0,0","subtotal":"897.75","grand_total":"1009.97","paid_amount":"1009.97","room_type_id":"320","product_id":"1324","siteminder_id":"EXP-1732603819","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":"112480","customer_id":"112480","source_of_creation":"Expedia","reservation_created_date":"2021-01-25 15:21:21","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","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":"1271,1272","currentDayPrice":"299.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":"3191344","reservation_id":"106859","confirmation_number":"SJ12631859348","room_stay_from":"2021-02-20","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.24,215.04,215.04,215.04,215.04","nightly_discount":"0,0,0,0,0","subtotal":"1086.40","grand_total":"1222.20","paid_amount":"1222.20","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1735109301","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":"113289","customer_id":"113289","source_of_creation":"Expedia","reservation_created_date":"2021-02-04 01:35:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"215.04","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":"3192502","reservation_id":"105584","confirmation_number":"SJ12613428247","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.30,174.30,174.30,174.30","nightly_discount":"0,0,0,0","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1731007797","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":"112005","customer_id":"112005","source_of_creation":"Expedia","reservation_created_date":"2021-01-18 23:16:18","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":"126","group_rooms":null,"currentDayPrice":"174.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":"3192728","reservation_id":"104790","confirmation_number":"SJ12621564410","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"128.44,128.44,128.44,128.44","nightly_discount":"0,0,0,0","subtotal":"513.76","grand_total":"577.98","paid_amount":"577.98","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1727743016","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111137","customer_id":"111137","source_of_creation":"Expedia","reservation_created_date":"2021-01-05 18:01:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"128.44","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":"3176699","reservation_id":"104843","confirmation_number":"SJ12684726620","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.44,139.44,139.44,139.44,139.44","nightly_discount":"0,0,0,0,0","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1727876153","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":"111193","customer_id":"111193","source_of_creation":"Expedia","reservation_created_date":"2021-01-06 03:56:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"139.44","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.44","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":"3181206","reservation_id":"105308","confirmation_number":"SJ12644139433","room_stay_from":"2021-02-20","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.24,156.24,156.24,156.24,156.24,156.24","nightly_discount":"0,0,0,0,0,0","subtotal":"993.44","grand_total":"1117.62","paid_amount":"1117.62","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1729820159","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":"111696","customer_id":"111696","source_of_creation":"Expedia","reservation_created_date":"2021-01-14 03:16:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"156.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":"3183966","reservation_id":"106038","confirmation_number":"SJ12656697395","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.24,170.24,170.24,170.24,170.24,170.24,192.64","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1270.08","grand_total":"1428.84","paid_amount":"1428.84","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1732504814","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":"112465","customer_id":"112465","source_of_creation":"Expedia","reservation_created_date":"2021-01-25 02:27:07","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","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":"170.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":"3190748","reservation_id":"106769","confirmation_number":"SJ12635013549","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.24,201.04,201.04,201.04,201.04,201.04,184.24","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1401.68","grand_total":"1576.89","paid_amount":"1576.89","room_type_id":"413","product_id":"1262","siteminder_id":"EXP-1734776504","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":"113191","customer_id":"113191","source_of_creation":"Expedia","reservation_created_date":"2021-02-02 21:56:31","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"201.04","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":"3200911","reservation_id":"105363","confirmation_number":"SJ12669033208","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.44,139.44,139.44,139.44,139.44,161.84","nightly_discount":"0,0,0,0,0,0","subtotal":"859.04","grand_total":"966.42","paid_amount":"966.42","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1730104359","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":"111754","customer_id":"111754","source_of_creation":"Expedia","reservation_created_date":"2021-01-15 04:56:29","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","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":"139.44","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":"3201226","reservation_id":"105309","confirmation_number":"SJ12614372867","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.30,195.30,195.30,195.30,195.30,223.30,223.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1423.10","grand_total":"1600.99","paid_amount":"1600.99","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1729820610","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":"111697","customer_id":"111697","source_of_creation":"Expedia","reservation_created_date":"2021-01-14 03:16:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.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":"3174677","reservation_id":"104119","confirmation_number":"SJ12640591791","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.44,167.44,167.44,167.44,167.44,184.24,184.24,167.44,171.92,171.92,171.92,171.92,188.72,188.72","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"2438.24","grand_total":"2743.02","paid_amount":"2743.02","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1724692080","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":"110451","customer_id":"110451","source_of_creation":"Expedia","reservation_created_date":"2020-12-22 19:01:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"167.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3200405","reservation_id":"102989","confirmation_number":"SJ12620479354","room_stay_from":"2021-02-18","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"329.77,339.79,339.79,339.79,339.79","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1688.93","grand_total":"2193.80","paid_amount":"2193.80","room_type_id":"320","product_id":"1329","siteminder_id":"ABB-HMTTNZCHEK","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1698.95","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109126","customer_id":"109126","source_of_creation":"Airbnb","reservation_created_date":"2020-11-22 19:54:05","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"261.38","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"339.79","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":"3201664","reservation_id":"105259","confirmation_number":"SJ12676286740","room_stay_from":"2021-02-20","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"259.08,259.08,254.42","nightly_discount":"0.00,0.00,0.00","subtotal":"772.58","grand_total":"895.31","paid_amount":"895.31","room_type_id":"413","product_id":"1273","siteminder_id":"ABB-HM2E2TB9Y4","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"777.24","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111643","customer_id":"111643","source_of_creation":"Airbnb","reservation_created_date":"2021-01-13 05:54:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"22.86","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"254.42","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3202058","reservation_id":"106209","confirmation_number":"SJ12642723123","room_stay_from":"2021-02-21","room_stay_to":"2021-02-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"242.40,246.84,246.84","nightly_discount":"0.00,0.00,0.00","subtotal":"736.08","grand_total":"853.01","paid_amount":"853.01","room_type_id":"319","product_id":"1287","siteminder_id":"ABB-HMQ42P2A3Q","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"740.52","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112618","customer_id":"112618","source_of_creation":"Airbnb","reservation_created_date":"2021-01-27 00:15:26","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"21.78","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"246.84","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3202551","reservation_id":"105150","confirmation_number":"SJ12687256596","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.48,228.48,228.48,223.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"908.44","grand_total":"1052.76","paid_amount":"1052.76","room_type_id":"413","product_id":"1268","siteminder_id":"ABB-HMQKHR3ACY","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"913.92","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111533","customer_id":"111533","source_of_creation":"Airbnb","reservation_created_date":"2021-01-11 03:09:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"26.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"228.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3202358","reservation_id":"106858","confirmation_number":"SJ12611298834","room_stay_from":"2021-02-21","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"290.25","paid_amount":"290.25","room_type_id":"319","product_id":"1309","siteminder_id":"HWR-303209653","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":"113288","customer_id":"113288","source_of_creation":"Hotwire","reservation_created_date":"2021-02-04 01:27:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"129.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":"3202867","reservation_id":"106334","confirmation_number":"SJ12630040327","room_stay_from":"2021-02-22","room_stay_to":"2021-02-24","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0,0","subtotal":"198.00","grand_total":"222.75","paid_amount":"222.75","room_type_id":"413","product_id":"1264","siteminder_id":"HWR-303191751","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":"112729","customer_id":"112729","source_of_creation":"Hotwire","reservation_created_date":"2021-01-28 16:47:08","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","currentDayPrice":"99.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3189282","reservation_id":"106001","confirmation_number":"SJ12656355183","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00","nightly_discount":"0,0,0","subtotal":"297.00","grand_total":"334.13","paid_amount":"334.13","room_type_id":"319","product_id":"1312","siteminder_id":"HWR-303121198","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":"112424","customer_id":"112424","source_of_creation":"Hotwire","reservation_created_date":"2021-01-24 19:37:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"99.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3190934","reservation_id":"106800","confirmation_number":"SJ12698761438","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"284.25,269.25,269.25,269.25,269.25,269.25,246.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1877.25","grand_total":"2111.90","paid_amount":"2111.90","room_type_id":"318","product_id":"1282","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":"113224","customer_id":"113224","source_of_creation":"FE","reservation_created_date":"2021-02-03 03:00:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","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":"269.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":"3202949","reservation_id":"107655","confirmation_number":"SJ12613835827","room_stay_from":"2021-03-03","room_stay_to":"2021-03-05","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.65,245.65","nightly_discount":"0.00,0","subtotal":"491.30","grand_total":"552.72","paid_amount":"276.35","room_type_id":"319","product_id":"1308","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114112","customer_id":"114112","source_of_creation":"FE","reservation_created_date":"2021-02-15 03:58:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3181958","reservation_id":"102496","confirmation_number":"SJ12671908496","room_stay_from":"2021-02-17","room_stay_to":"2021-02-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"199.20,199.20,231.20,231.20,199.20,199.20,199.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1458.40","grand_total":"1640.70","paid_amount":"1640.70","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":"108658","customer_id":"108658","source_of_creation":"PMS","reservation_created_date":"2020-11-10 18:04:18","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":"199.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192067","reservation_id":"105215","confirmation_number":"SJ12667678030","room_stay_from":"2021-02-17","room_stay_to":"2021-02-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,269.25,284.25,284.25,209.25,209.25,209.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1564.50","grand_total":"1760.07","paid_amount":"1760.07","room_type_id":"319","product_id":"1915","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":"111606","customer_id":"111606","source_of_creation":"PMS","reservation_created_date":"2021-01-12 14:04:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","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":"209.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":"3179754","reservation_id":"105032","confirmation_number":"SJ12630447918","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"230.47,230.47,230.47","nightly_discount":"0.00,0.00,0.00","subtotal":"691.41","grand_total":"777.84","paid_amount":"777.84","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":"111402","customer_id":"111402","source_of_creation":"PMS","reservation_created_date":"2021-01-08 23:10:10","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":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"230.47","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":"3181777","reservation_id":"105481","confirmation_number":"SJ12642034519","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.75,186.75,186.75,186.75,186.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"933.75","grand_total":"1050.47","paid_amount":"1050.47","room_type_id":"319","product_id":"1275","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":"111896","customer_id":"111896","source_of_creation":"PMS","reservation_created_date":"2021-01-16 23:23:32","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","group_rooms":null,"currentDayPrice":"186.75","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":"3189104","reservation_id":"105218","confirmation_number":"SJ12663846226","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"139.25,299.25,299.25,299.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1037.00","grand_total":"1166.63","paid_amount":"1166.63","room_type_id":"320","product_id":"1323","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":"111580","customer_id":"111580","source_of_creation":"PMS","reservation_created_date":"2021-01-12 14:49:13","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","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":"1269,1270","currentDayPrice":"139.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":"3199260","reservation_id":"107804","confirmation_number":"SJ12680777526","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"305.15,305.15,305.15,322.15","nightly_discount":"15.25,15.25,15.25,16.10","subtotal":"1237.60","grand_total":"1322.72","paid_amount":"1322.72","room_type_id":"319","product_id":"1307","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":"114260","customer_id":"114260","source_of_creation":"PMS","reservation_created_date":"2021-02-16 16:22:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","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":"305.15","currentDayDiscount":"15.25","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":"3189341","reservation_id":"106562","confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1913","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":"101703","customer_id":"101703","source_of_creation":"PMS","reservation_created_date":"2021-01-31 18:54:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","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":"0.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202634","reservation_id":"104782","confirmation_number":"SJ12675983125","room_stay_from":"2021-02-26","room_stay_to":"2021-02-28","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.15,200.15","nightly_discount":"0.00,0.00","subtotal":"359.30","grand_total":"404.22","paid_amount":"179.04","room_type_id":"319","product_id":"1293","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":"111127","customer_id":"111127","source_of_creation":"PMS","reservation_created_date":"2021-01-05 16:38:35","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","changedComment":"From 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"}]}],"pms_non_taxable":[{"room_stay_id":"3203017","reservation_id":"103584","confirmation_number":"SJ12638392410","room_stay_from":"2021-04-03","room_stay_to":"2021-04-09","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"318","product_id":"1282","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"114477","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2020-12-07 22:41:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","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":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3200997","reservation_id":"105427","confirmation_number":"SJ12621975795","room_stay_from":"2021-02-19","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.00,178.00,178.00,178.00,178.00,178.00,178.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1246.00","grand_total":"1246.00","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-01-16 02:43:22","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":"0","group_rooms":null,"currentDayPrice":"178.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":"3197141","reservation_id":"106999","confirmation_number":"SJ12640521255","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.00,178.00,178.00,178.00,178.00,178.00,178.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1246.00","grand_total":"1246.00","paid_amount":"0.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":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-02-05 23:59:52","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":"178.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":"3181214","reservation_id":"105605","confirmation_number":"SJ12628104872","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"798.00","grand_total":"798.00","paid_amount":"196.88","room_type_id":"319","product_id":"1756","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-01-19 02:53:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","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":"114.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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3192729","reservation_id":"104790","confirmation_number":"SJ12629250989","room_confirmation_number":"SJ12621564410","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","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":"1777","service_quantity":"1","customer_traveller_id":"111137","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-05 23:54:12","reservation_modified_date_time":"2021-02-05 23:54:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111137","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"3202937","reservation_id":"107652","confirmation_number":"SJ12682111443","room_confirmation_number":"SJ12694345132","room_stay_from":"2021-04-03","room_stay_to":"2021-04-06","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"114111","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-22 20:19:07","reservation_modified_date_time":"2021-02-22 20:19:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114111","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3174266","reservation_id":"104751","confirmation_number":"SJ12621772800","room_confirmation_number":"SJ12683537895","room_stay_from":"2021-02-18","room_stay_to":"2021-02-23","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":"111104","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 01:56:15","reservation_modified_date_time":"2021-01-05 02:44:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111104","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":"3192532","reservation_id":"106990","confirmation_number":"SJ12622170524","room_confirmation_number":"SJ12684637228","room_stay_from":"2021-02-15","room_stay_to":"2021-02-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113427","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 22:15:10","reservation_modified_date_time":"2021-02-05 22:15:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113427","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":"3197130","reservation_id":"106517","confirmation_number":"SJ12651211712","room_confirmation_number":"SJ12673506797","room_stay_from":"2021-02-22","room_stay_to":"2021-02-23","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":"112926","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-30 22:31:08","reservation_modified_date_time":"2021-02-13 04:12:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112926","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":"3200408","reservation_id":"102989","confirmation_number":"SJ12679339356","room_confirmation_number":"SJ12620479354","room_stay_from":"2021-02-18","room_stay_to":"2021-02-23","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109126","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-22 19:54:05","reservation_modified_date_time":"2021-02-18 16:42:40","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109126","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3201159","reservation_id":"105087","confirmation_number":"SJ12646792526","room_confirmation_number":"SJ12688982589","room_stay_from":"2021-02-19","room_stay_to":"2021-02-23","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":"114288","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-09 20:36:13","reservation_modified_date_time":"2021-02-19 22:05:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111461","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":"3201665","reservation_id":"105259","confirmation_number":"SJ12697648995","room_confirmation_number":"SJ12676286740","room_stay_from":"2021-02-20","room_stay_to":"2021-02-23","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111643","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-13 05:54:11","reservation_modified_date_time":"2021-02-20 21:29:44","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111643","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3202356","reservation_id":"108182","confirmation_number":"SJ12672356673","room_confirmation_number":"SJ12687587181","room_stay_from":"2021-02-21","room_stay_to":"2021-02-23","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":"114647","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-21 17:40:20","reservation_modified_date_time":"2021-02-21 20:52:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114647","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":"3202360","reservation_id":"106858","confirmation_number":"SJ12668657052","room_confirmation_number":"SJ12611298834","room_stay_from":"2021-02-21","room_stay_to":"2021-02-23","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"25.00,0.00","subtotal":"50.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"113288","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-04 01:27:06","reservation_modified_date_time":"2021-02-21 20:56:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113288","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":"3181959","reservation_id":"102496","confirmation_number":"SJ12676684265","room_confirmation_number":"SJ12671908496","room_stay_from":"2021-02-17","room_stay_to":"2021-02-24","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":"108658","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-10 18:04:18","reservation_modified_date_time":"2021-01-20 20:20:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108658","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":"3192068","reservation_id":"105215","confirmation_number":"SJ12662043715","room_confirmation_number":"SJ12667678030","room_stay_from":"2021-02-17","room_stay_to":"2021-02-24","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":"111606","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-12 14:04:32","reservation_modified_date_time":"2021-02-05 00:24:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111606","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":"3202059","reservation_id":"106209","confirmation_number":"SJ12616692859","room_confirmation_number":"SJ12642723123","room_stay_from":"2021-02-21","room_stay_to":"2021-02-24","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112618","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 00:15:26","reservation_modified_date_time":"2021-02-21 15:11:31","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112618","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3202868","reservation_id":"106334","confirmation_number":"SJ12615443600","room_confirmation_number":"SJ12630040327","room_stay_from":"2021-02-22","room_stay_to":"2021-02-24","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":"112729","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 16:47:08","reservation_modified_date_time":"2021-02-22 19:47:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112729","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":"3179755","reservation_id":"105032","confirmation_number":"SJ12639922507","room_confirmation_number":"SJ12630447918","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","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":"111402","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-08 23:10:10","reservation_modified_date_time":"2021-01-16 15:38:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111402","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":"3180457","reservation_id":"105515","confirmation_number":"SJ12696203551","room_confirmation_number":"SJ12650920347","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","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":"111930","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-17 18:41:08","reservation_modified_date_time":"2021-01-17 18:41:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111930","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":"3181139","reservation_id":"105583","confirmation_number":"SJ12617101576","room_confirmation_number":"SJ12657879374","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","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":"112004","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 23:11:08","reservation_modified_date_time":"2021-01-18 23:59:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112004","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":"3184776","reservation_id":"106060","confirmation_number":"SJ12648516344","room_confirmation_number":"SJ12657448160","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","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":"112480","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-25 15:21:21","reservation_modified_date_time":"2021-01-26 14:04:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112480","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":"3189285","reservation_id":"106001","confirmation_number":"SJ12680582912","room_confirmation_number":"SJ12656355183","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","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":"112424","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-24 19:37:20","reservation_modified_date_time":"2021-02-01 18:21:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112424","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":"3191345","reservation_id":"106859","confirmation_number":"SJ12615472133","room_confirmation_number":"SJ12631859348","room_stay_from":"2021-02-20","room_stay_to":"2021-02-25","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":"113289","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-04 01:35:07","reservation_modified_date_time":"2021-02-04 01:35:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113289","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":"3192503","reservation_id":"105584","confirmation_number":"SJ12617347483","room_confirmation_number":"SJ12613428247","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","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":"112005","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 23:16:18","reservation_modified_date_time":"2021-02-05 21:43:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112005","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":"3192730","reservation_id":"104790","confirmation_number":"SJ12629944003","room_confirmation_number":"SJ12621564410","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","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":"111137","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 18:01:08","reservation_modified_date_time":"2021-02-05 23:54:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111137","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"3192732","reservation_id":"105778","confirmation_number":"SJ12629002064","room_confirmation_number":"SJ12643903300","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","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":"112180","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-21 06:30:13","reservation_modified_date_time":"2021-02-05 23:54:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112180","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":"3201093","reservation_id":"108050","confirmation_number":"SJ12651596278","room_confirmation_number":"SJ12626593000","room_stay_from":"2021-02-22","room_stay_to":"2021-02-25","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":"114517","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-19 18:12:36","reservation_modified_date_time":"2021-02-19 20:08:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114517","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":"3176701","reservation_id":"104843","confirmation_number":"SJ12693309515","room_confirmation_number":"SJ12684726620","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","room_stay_status":"Active","nightly_price":"25,25,25,25,25","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":"111193","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-06 03:56:12","reservation_modified_date_time":"2021-01-09 17:01:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111193","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":"3181207","reservation_id":"105308","confirmation_number":"SJ12681754001","room_confirmation_number":"SJ12644139433","room_stay_from":"2021-02-20","room_stay_to":"2021-02-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"111696","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 03:16:11","reservation_modified_date_time":"2021-01-19 02:49:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111696","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":"3181779","reservation_id":"105481","confirmation_number":"SJ12644308877","room_confirmation_number":"SJ12642034519","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","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":"111896","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 23:23:32","reservation_modified_date_time":"2021-01-20 16:02:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111896","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":"3189107","reservation_id":"105218","confirmation_number":"SJ12693939092","room_confirmation_number":"SJ12663846226","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","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":"111580","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-12 14:49:13","reservation_modified_date_time":"2021-02-01 15:13:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111580","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":"3194886","reservation_id":"104679","confirmation_number":"SJ12624597771","room_confirmation_number":"SJ12636630959","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","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":"111033","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-04 00:53:08","reservation_modified_date_time":"2021-02-09 18:44:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111033","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":"3199262","reservation_id":"107804","confirmation_number":"SJ12675909966","room_confirmation_number":"SJ12680777526","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","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":"114260","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-16 16:22:57","reservation_modified_date_time":"2021-02-16 19:53:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114260","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":"3200998","reservation_id":"105427","confirmation_number":"SJ12660982518","room_confirmation_number":"SJ12621975795","room_stay_from":"2021-02-19","room_stay_to":"2021-02-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111831","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 02:43:22","reservation_modified_date_time":"2021-02-19 17:05:21","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","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":"3202552","reservation_id":"105150","confirmation_number":"SJ12652347574","room_confirmation_number":"SJ12687256596","room_stay_from":"2021-02-22","room_stay_to":"2021-02-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111533","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-11 03:09:07","reservation_modified_date_time":"2021-02-22 13:35:14","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111533","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3179465","reservation_id":"104587","confirmation_number":"SJ12610374391","room_confirmation_number":"SJ12686301450","room_stay_from":"2021-02-19","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114516","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 18:01:07","reservation_modified_date_time":"2021-01-15 21:59:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110936","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":"3183967","reservation_id":"106038","confirmation_number":"SJ12681308912","room_confirmation_number":"SJ12656697395","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","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":"112465","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-25 02:27:07","reservation_modified_date_time":"2021-01-25 02:27:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112465","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":"3184972","reservation_id":"106179","confirmation_number":"SJ12692312293","room_confirmation_number":"SJ12615389852","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"112586","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 18:01:08","reservation_modified_date_time":"2021-01-26 18:01:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112586","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":"3190747","reservation_id":"106769","confirmation_number":"SJ12644796727","room_confirmation_number":"SJ12635013549","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","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":"113191","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-02 21:56:31","reservation_modified_date_time":"2021-02-02 22:45:49","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113191","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":"3190935","reservation_id":"106800","confirmation_number":"SJ12617782738","room_confirmation_number":"SJ12698761438","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","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":"113224","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-03 03:00:11","reservation_modified_date_time":"2021-02-03 03:00:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113224","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":"3197142","reservation_id":"106999","confirmation_number":"SJ12610375317","room_confirmation_number":"SJ12640521255","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113438","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 23:59:52","reservation_modified_date_time":"2021-02-13 04:17:21","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","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":"3200912","reservation_id":"105363","confirmation_number":"SJ12689363160","room_confirmation_number":"SJ12669033208","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"111754","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 04:56:29","reservation_modified_date_time":"2021-02-19 14:24:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111754","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":"3200915","reservation_id":"106188","confirmation_number":"SJ12672572211","room_confirmation_number":"SJ12640825161","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","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":"112595","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 19:37:08","reservation_modified_date_time":"2021-02-19 14:25:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112595","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":"3181215","reservation_id":"105605","confirmation_number":"SJ12644459719","room_confirmation_number":"SJ12628104872","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112026","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-19 02:53:46","reservation_modified_date_time":"2021-01-19 02:53:46","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":"3201230","reservation_id":"105309","confirmation_number":"SJ12665982658","room_confirmation_number":"SJ12614372867","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","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":"111697","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 03:16:15","reservation_modified_date_time":"2021-02-20 00:23:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111697","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":"3174680","reservation_id":"104119","confirmation_number":"SJ12691944516","room_confirmation_number":"SJ12640591791","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"350.00","grand_total":"393.75","paid_amount":"393.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"110451","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-22 19:01:07","reservation_modified_date_time":"2021-01-05 20:56:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110451","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":"3189342","reservation_id":"106562","confirmation_number":"SJ12674501286","room_confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 18:54:06","reservation_modified_date_time":"2021-02-01 18:35:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101703","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":"3202635","reservation_id":"104782","confirmation_number":"SJ12689525253","room_confirmation_number":"SJ12675983125","room_stay_from":"2021-02-26","room_stay_to":"2021-02-28","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111127","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 16:38:35","reservation_modified_date_time":"2021-02-22 16:40:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111127","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202923","reservation_id":"107433","confirmation_number":"SJ12687381988","room_confirmation_number":"SJ12695963627","room_stay_from":"2021-03-31","room_stay_to":"2021-04-04","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113888","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 15:46:18","reservation_modified_date_time":"2021-02-22 20:17:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113888","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"}]},{"room_stay_id":"3202951","reservation_id":"107655","confirmation_number":"SJ12624517597","room_confirmation_number":"SJ12613835827","room_stay_from":"2021-03-03","room_stay_to":"2021-03-05","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114112","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-15 03:58:17","reservation_modified_date_time":"2021-02-22 20:22:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114112","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3203018","reservation_id":"103584","confirmation_number":"SJ12681911103","room_confirmation_number":"SJ12638392410","room_stay_from":"2021-04-03","room_stay_to":"2021-04-09","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103072","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-07 22:41:38","reservation_modified_date_time":"2021-02-22 21:21:13","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3202808","reservation_id":"108294","confirmation_number":"SJ12629642314","room_confirmation_number":"SJ12679153836","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"7.50","paid_amount":"7.50","product_id":"1660","service_quantity":"3","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-22 18:38:46","reservation_modified_date_time":"2021-02-22 18:38:46","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"6.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3202562","reservation_id":"108259","confirmation_number":"SJ12630205924","room_confirmation_number":"SJ12690345475","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"50.00","grand_total":"50.00","paid_amount":"50.00","product_id":"1231","service_quantity":"1","product_name":"Custom Beach Chairs 3 days","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-22 13:57:29","reservation_modified_date_time":"2021-02-22 13:57:29","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}