{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-12-30","total_rooms_exist":"1281,1282,1289,1274,1275,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":15,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1272","block_room_bookings":[{"confirmation_number":"SJ12650067376","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","bundle_room":"0"}],"bundle_block_count":"1291,1711,1311,1312,1269,1270,1271,1272,1302,1303,1307,1308,1309,1310,1267,1268,1304,1305","bundle_block_bookings":[{"confirmation_number":"SJB12666599386","room_stay_from":"2020-12-29","room_stay_to":"2020-12-31","bundle_room":"0"},{"confirmation_number":"SJB12690738030","room_stay_from":"2020-12-29","room_stay_to":"2020-12-31","bundle_room":"0"},{"confirmation_number":"SJB12655005671","room_stay_from":"2020-12-29","room_stay_to":"2020-12-31","bundle_room":"0"},{"confirmation_number":"SJB12631156226","room_stay_from":"2020-12-29","room_stay_to":"2020-12-31","bundle_room":"0"},{"confirmation_number":"SJB12640979238","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","bundle_room":"1"},{"confirmation_number":"SJB12684310208","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","bundle_room":"1"},{"confirmation_number":"SJB12664160685","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","bundle_room":"0"},{"confirmation_number":"SJB12670410030","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","bundle_room":"0"},{"confirmation_number":"SJB12686072323","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","bundle_room":"1"},{"confirmation_number":"SJB12653566913","room_stay_from":"2020-12-27","room_stay_to":"2021-01-02","bundle_room":"0"},{"confirmation_number":"SJB12659810324","room_stay_from":"2020-12-27","room_stay_to":"2021-01-02","bundle_room":"0"},{"confirmation_number":"SJB12699144844","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","bundle_room":"0"},{"confirmation_number":"SJB12651817263","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","bundle_room":"0"},{"confirmation_number":"SJB12656771494","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","bundle_room":"0"},{"confirmation_number":"SJB12621069051","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","bundle_room":"0"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3172149","reservation_id":"102256","confirmation_number":"SJ12618513018","room_stay_from":"2020-12-29","room_stay_to":"2020-12-31","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"287.28,287.28","nightly_discount":"0,0","subtotal":"574.56","grand_total":"646.38","paid_amount":"2035.44","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-3742946209","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":"108415","customer_id":"108415","source_of_creation":"Booking.com","reservation_created_date":"2020-11-03 19:22:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"112.42","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"287.28","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":"3165859","reservation_id":"103181","confirmation_number":"SJ12639424000","room_stay_from":"2020-12-27","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"343.20,343.20,343.20,343.20,343.20","nightly_discount":"0,0,0,0,0","subtotal":"1716.00","grand_total":"1930.50","paid_amount":"1930.50","room_type_id":"319","product_id":"1307","siteminder_id":"BDC-2628802841","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":"109333","customer_id":"109333","source_of_creation":"Booking.com","reservation_created_date":"2020-11-27 15:49:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"331.38","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"343.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170611","reservation_id":"102894","confirmation_number":"SJ12662571034","room_stay_from":"2020-12-28","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"343.20,343.20,343.20,343.20","nightly_discount":"0,0,0,0","subtotal":"1372.80","grand_total":"1544.40","paid_amount":"1544.40","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-3372657390","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":"109026","customer_id":"109026","source_of_creation":"Booking.com","reservation_created_date":"2020-11-20 18:39:22","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"265.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"343.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3163068","reservation_id":"103595","confirmation_number":"SJ12691111785","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"413.28,413.28,442.08","nightly_discount":"0,0,0","subtotal":"1268.64","grand_total":"1427.22","paid_amount":"1427.22","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-3370388875","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":"109841","customer_id":"109841","source_of_creation":"Booking.com","reservation_created_date":"2020-12-08 03:03:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"241.86","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"413.28","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":"3165850","reservation_id":"103359","confirmation_number":"SJ12667756358","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"343.20,343.20,343.20,343.20,343.20,343.20,375.20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"2434.40","grand_total":"2738.70","paid_amount":"2738.70","room_type_id":"319","product_id":"1308","siteminder_id":"BDC-2916961103","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":"109530","customer_id":"109530","source_of_creation":"Booking.com","reservation_created_date":"2020-12-01 20:51:27","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"343.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170174","reservation_id":"102806","confirmation_number":"SJ12676225026","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"383.20,383.20,383.20,383.20,383.20,383.20,415.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2714.40","grand_total":"3053.70","paid_amount":"3053.70","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2974326312","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"350.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108949","customer_id":"108949","source_of_creation":"Booking.com","reservation_created_date":"2020-11-18 14:39:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"520.09","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"383.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":"3171896","reservation_id":"103800","confirmation_number":"SJ12677289410","room_stay_from":"2021-05-21","room_stay_to":"2021-05-24","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.58,181.58,134.33","nightly_discount":"0,0,0","subtotal":"497.49","grand_total":"559.67","paid_amount":"260.10","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3132464293","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":"110073","customer_id":"110073","source_of_creation":"Booking.com","reservation_created_date":"2020-12-14 16:05:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"103.05","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[{"room_stay_id":"3067220","reservation_id":"91557","confirmation_number":"SJ12628888803","room_stay_from":"2020-12-30","room_stay_to":"2021-01-01","room_stay_status":"Canceled","room_stay_guest_count":"7","room_stay_child_count":"0","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"576.79","room_type_id":"320","product_id":"1320","siteminder_id":"BDC-2370503813","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97691","customer_id":"97691","source_of_creation":"Booking.com","reservation_created_date":"2020-02-08 12:08:11","service_canceled_date_time":"2020-08-07 11:09:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","ota_service_fee_amount":"0","commision_charges":"211.98","deltaChange":"576.79","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3144220","reservation_id":"101400","confirmation_number":"SJ12682613926","room_stay_from":"2020-12-29","room_stay_to":"2020-12-31","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"479.20,479.20","nightly_discount":"0,0","subtotal":"958.40","grand_total":"1078.20","paid_amount":"1078.20","room_type_id":"320","product_id":"1714","siteminder_id":"EXP-1707011940","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":"107481","customer_id":"107481","source_of_creation":"Expedia","reservation_created_date":"2020-10-11 15:22:10","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":"479.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171528","reservation_id":"102446","confirmation_number":"SJ12655772268","room_stay_from":"2020-12-27","room_stay_to":"2020-12-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"395.20,395.20,395.20,395.20","nightly_discount":"0,0,0,0","subtotal":"1580.80","grand_total":"1778.40","paid_amount":"1778.40","room_type_id":"319","product_id":"1942","siteminder_id":"EXP-1714587449","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"250.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108610","customer_id":"108610","source_of_creation":"Expedia","reservation_created_date":"2020-11-08 21:50:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"316.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"395.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171907","reservation_id":"103966","confirmation_number":"SJ12648980816","room_stay_from":"2020-12-30","room_stay_to":"2020-12-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"298.52","nightly_discount":"0","subtotal":"298.52","grand_total":"335.84","paid_amount":"335.84","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1723909799","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":"110274","customer_id":"110274","source_of_creation":"Expedia","reservation_created_date":"2020-12-19 00:36:10","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":"","currentDayPrice":"298.52","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":"3153220","reservation_id":"102032","confirmation_number":"SJ12695810025","room_stay_from":"2020-12-28","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"424.00,424.00,424.00,424.00","nightly_discount":"0,0,0,0","subtotal":"1696.00","grand_total":"1908.00","paid_amount":"1908.00","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1711808488","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":"108151","customer_id":"108151","source_of_creation":"Expedia","reservation_created_date":"2020-10-28 14:59:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"424.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":"3168833","reservation_id":"104102","confirmation_number":"SJ12621329822","room_stay_from":"2020-12-27","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"271.4,271.4,271.4,271.4,271.4","nightly_discount":"0,0,0,0,0","subtotal":"1357.00","grand_total":"1526.63","paid_amount":"1526.63","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1724622327","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"125.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110436","customer_id":"110436","source_of_creation":"Expedia","reservation_created_date":"2020-12-22 10:01:07","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"271.4","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3169733","reservation_id":"102832","confirmation_number":"SJ12622754069","room_stay_from":"2020-12-30","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"359.10,359.10","nightly_discount":"0,0","subtotal":"718.20","grand_total":"807.98","paid_amount":"807.98","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1717141440","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":"108971","customer_id":"108971","source_of_creation":"Expedia","reservation_created_date":"2020-11-19 02:03: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":"359.10","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":"3167904","reservation_id":"104016","confirmation_number":"SJ12685124954","room_stay_from":"2020-12-27","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"278.40,278.40,278.40,278.40,278.40,278.40","nightly_discount":"0,0,0,0,0,0","subtotal":"1670.40","grand_total":"1879.20","paid_amount":"1879.20","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1724240014","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":"110339","customer_id":"110339","source_of_creation":"Expedia","reservation_created_date":"2020-12-20 17:26:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"278.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170744","reservation_id":"104034","confirmation_number":"SJ12683191956","room_stay_from":"2020-12-28","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"296.40,296.40,296.40,296.40,296.40","nightly_discount":"0,0,0,0,0","subtotal":"1482.00","grand_total":"1667.25","paid_amount":"1667.25","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1724312609","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":"110366","customer_id":"110366","source_of_creation":"Expedia","reservation_created_date":"2020-12-21 00:11:07","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"296.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170892","reservation_id":"102450","confirmation_number":"SJ12633528958","room_stay_from":"2020-12-27","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"7","room_stay_child_count":"0","nightly_price":"479.20,479.20,479.20,479.20,479.20,511.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2907.20","grand_total":"3270.60","paid_amount":"3270.60","room_type_id":"320","product_id":"1910","siteminder_id":"EXP-1714598226","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":"108615","customer_id":"108615","source_of_creation":"Expedia","reservation_created_date":"2020-11-08 22:45:26","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1309,1310","currentDayPrice":"479.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":"3170926","reservation_id":"104306","confirmation_number":"SJ12618570825","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"318.92,375.20,375.20","nightly_discount":"0,0,0","subtotal":"1069.32","grand_total":"1202.99","paid_amount":"1202.99","room_type_id":"319","product_id":"1756","siteminder_id":"EXP-1725634360","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":"110660","customer_id":"110660","source_of_creation":"Expedia","reservation_created_date":"2020-12-27 19:21:08","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"318.92","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171137","reservation_id":"104052","confirmation_number":"SJ12685641931","room_stay_from":"2020-12-28","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"348.00,348.00,348.00,348.00,348.00","nightly_discount":"0,0,0,0,0","subtotal":"1740.00","grand_total":"1957.50","paid_amount":"1957.50","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1724412884","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":"110384","customer_id":"110384","source_of_creation":"Expedia","reservation_created_date":"2020-12-21 14:19:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"348.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":"3171756","reservation_id":"103797","confirmation_number":"SJ12646173411","room_stay_from":"2020-12-29","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"365.2,365.2,365.2,365.2,282.16","nightly_discount":"0,0,0,0,0","subtotal":"1742.96","grand_total":"1960.83","paid_amount":"1960.83","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1722856106","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"250.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110727","customer_id":"110071","source_of_creation":"Expedia","reservation_created_date":"2020-12-14 15:16:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"365.2","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170792","reservation_id":"104293","confirmation_number":"SJ12688411107","room_stay_from":"2020-12-30","room_stay_to":"2021-01-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"469.00,469.00,469.00,230.30,181.30,167.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1985.90","grand_total":"2234.14","paid_amount":"2234.14","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1725588537","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110649","customer_id":"110649","source_of_creation":"Expedia","reservation_created_date":"2020-12-27 14:41:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"469.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"}]}],"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":"3171856","reservation_id":"104414","confirmation_number":"SJ12688948753","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"398.31,398.31,398.31,398.31","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1593.24","grand_total":"1844.83","paid_amount":"1835.27","room_type_id":"318","product_id":"1282","siteminder_id":"ABB-HMWK4CXSSN","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1593.24","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110763","customer_id":"110763","source_of_creation":"Airbnb","reservation_created_date":"2020-12-30 01:48:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"46.86","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"currentDayPrice":"398.31","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":"3172139","reservation_id":"102093","confirmation_number":"SJ12638499642","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"4","nightly_price":"575.34,575.34,575.34,460.27","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"2186.29","grand_total":"3221.90","paid_amount":"3221.90","room_type_id":"320","product_id":"1329","siteminder_id":"ABB-HMXBTXX9WF","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"2301.36","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108225","customer_id":"108225","source_of_creation":"Airbnb","reservation_created_date":"2020-10-30 00:23:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"345.2","commision_charges":"374.64","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"currentDayPrice":"575.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"5.00","abb_tax_paid_sm":"0.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3169735","reservation_id":"96198","confirmation_number":"SJ12634219277","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.04,239.04,239.04,239.04,239.04,239.04,239.04","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1673.28","grand_total":"1882.44","paid_amount":"1882.44","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102321","customer_id":"102321","source_of_creation":"FE","reservation_created_date":"2020-06-09 23:53:34","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"239.04","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":"3171913","reservation_id":"103525","confirmation_number":"SJ12639810697","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"466.65,466.65,500.65","nightly_discount":"0.00,0.00,0.00","subtotal":"1433.95","grand_total":"1613.20","paid_amount":"1613.20","room_type_id":"320","product_id":"1322","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":"109755","customer_id":"109755","source_of_creation":"FE","reservation_created_date":"2020-12-06 14:01:32","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","currentDayPrice":"466.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3168968","reservation_id":"104122","confirmation_number":"SJ12673366310","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"370.50,370.50,370.50,370.50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1482.00","grand_total":"1667.25","paid_amount":"1667.25","room_type_id":"411","product_id":"1296","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":"110455","customer_id":"110455","source_of_creation":"FE","reservation_created_date":"2020-12-22 20:25:05","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":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"370.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171972","reservation_id":"102441","confirmation_number":"SJ12639882424","room_stay_from":"2021-02-05","room_stay_to":"2021-02-09","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.20,231.20,186.75,186.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"835.90","grand_total":"940.39","paid_amount":"224.10","room_type_id":"413","product_id":"1262","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":"108604","customer_id":"108604","source_of_creation":"FE","reservation_created_date":"2020-11-08 19:34:38","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":"","changedComment":"both dates 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":"3171033","reservation_id":"104326","confirmation_number":"SJ12637389628","room_stay_from":"2020-12-29","room_stay_to":"2020-12-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"500.65,500.65","nightly_discount":"75.09,75.09","subtotal":"1001.30","grand_total":"957.51","paid_amount":"957.51","room_type_id":"320","product_id":"1332","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110682","customer_id":"110682","source_of_creation":"PMS","reservation_created_date":"2020-12-28 04:02:32","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":"1311,1312","currentDayPrice":"500.65","currentDayDiscount":"75.09","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":"3171999","reservation_id":"102442","confirmation_number":"SJ12633108468","room_stay_from":"2020-12-27","room_stay_to":"2020-12-30","room_stay_status":"Checked-Out","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"399.00,399.00,399.00","nightly_discount":"39.90,39.90,39.90","subtotal":"1197.00","grand_total":"1211.97","paid_amount":"2468.93","room_type_id":"413","product_id":"1261","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108607","customer_id":"108607","source_of_creation":"PMS","reservation_created_date":"2020-11-08 20:43:52","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":null,"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":"3172005","reservation_id":"102442","confirmation_number":"SJ12631978185","room_stay_from":"2020-12-27","room_stay_to":"2020-12-30","room_stay_status":"Checked-Out","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"399.00,399.00,399.00","nightly_discount":"39.90,39.90,39.90","subtotal":"1197.00","grand_total":"1211.97","paid_amount":"2468.93","room_type_id":"413","product_id":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108607","customer_id":"108607","source_of_creation":"PMS","reservation_created_date":"2020-11-08 20:43:52","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":null,"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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3146856","reservation_id":"96857","confirmation_number":"SJ12641178022","room_stay_from":"2020-12-27","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.00","paid_amount":"140.63","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-20 02:30:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"78.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3162645","reservation_id":"97094","confirmation_number":"SJ12626056536","room_stay_from":"2020-12-25","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.57,113.57,113.57,113.57,113.57,113.57,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"794.99","grand_total":"794.99","paid_amount":"196.88","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-26 00:21:44","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.57","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":"3168576","reservation_id":"95495","confirmation_number":"SJ12674753883","room_stay_from":"2020-12-29","room_stay_to":"2021-01-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.99","paid_amount":"84.38","room_type_id":"319","product_id":"1306","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-27 16:46:41","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":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"78.33","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146704","reservation_id":"95487","confirmation_number":"SJ12673847493","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"580.73","grand_total":"580.73","paid_amount":"196.88","room_type_id":"413","product_id":"1269","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-27 16:28:02","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146706","reservation_id":"95488","confirmation_number":"SJ12637731060","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"580.73","grand_total":"580.73","paid_amount":"196.88","room_type_id":"413","product_id":"1270","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-27 16:28:43","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","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":"0","group_rooms":null,"currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146708","reservation_id":"95489","confirmation_number":"SJ12619590336","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"580.73","grand_total":"580.73","paid_amount":"196.88","room_type_id":"413","product_id":"1271","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-27 16:29:39","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3153337","reservation_id":"102019","confirmation_number":"SJ12621765128","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00,78.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"582.00","grand_total":"582.00","paid_amount":"196.88","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-10-28 01:26:53","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":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"78.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146850","reservation_id":"96755","confirmation_number":"SJ12627282701","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,113.57,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"616.44","grand_total":"616.44","paid_amount":"196.88","room_type_id":"319","product_id":"1915","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-18 14:24:52","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":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146852","reservation_id":"96755","confirmation_number":"SJ12622659123","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,113.57,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"616.44","grand_total":"616.44","paid_amount":"196.88","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-18 14:24:51","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":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146854","reservation_id":"96755","confirmation_number":"SJ12637553566","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,113.57,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"616.44","grand_total":"616.44","paid_amount":"196.88","room_type_id":"319","product_id":"1286","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-18 14:24:51","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":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3152361","reservation_id":"95494","confirmation_number":"SJ12621861390","room_stay_from":"2020-12-29","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"462.00","grand_total":"462.00","paid_amount":"140.63","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-27 16:45:02","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"78.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170673","reservation_id":"101518","confirmation_number":"SJ12651133298","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"618.00","grand_total":"618.00","paid_amount":"196.88","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-10-14 01:33:37","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":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"78.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170931","reservation_id":"100153","confirmation_number":"SJ12668031535","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"77.86,77.86,77.86,77.86,77.86,113.57,113.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"616.44","grand_total":"616.44","paid_amount":"196.88","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-09-09 00:33:49","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"77.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3168834","reservation_id":"104102","confirmation_number":"SJ12645508437","room_confirmation_number":"SJ12621329822","room_stay_from":"2020-12-27","room_stay_to":"2021-01-01","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":"1777","service_quantity":"1","customer_traveller_id":"110436","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-12-22 10:01:07","reservation_modified_date_time":"2020-12-22 10:01:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110436","canceled_nights_data":"","posAmt_airbnb_taxpaid":"125.00","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171757","reservation_id":"103797","confirmation_number":"SJ12626106280","room_confirmation_number":"SJ12646173411","room_stay_from":"2020-12-29","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"50,50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"110727","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-12-29 22:07:08","reservation_modified_date_time":"2020-12-29 22:07:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110071","canceled_nights_data":"","posAmt_airbnb_taxpaid":"250.00","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3144221","reservation_id":"101400","confirmation_number":"SJ12679184597","room_confirmation_number":"SJ12682613926","room_stay_from":"2020-12-29","room_stay_to":"2020-12-31","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":"107481","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-11 15:22:10","reservation_modified_date_time":"2020-10-11 15:22:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107481","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171034","reservation_id":"104326","confirmation_number":"SJ12641133585","room_confirmation_number":"SJ12637389628","room_stay_from":"2020-12-29","room_stay_to":"2020-12-31","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":"110682","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-28 04:02:32","reservation_modified_date_time":"2020-12-28 04:02:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110682","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171529","reservation_id":"102446","confirmation_number":"SJ12695626302","room_confirmation_number":"SJ12655772268","room_stay_from":"2020-12-27","room_stay_to":"2020-12-31","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"108610","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-08 21:50:09","reservation_modified_date_time":"2020-12-29 14:43:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108610","canceled_nights_data":"","posAmt_airbnb_taxpaid":"250.00","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171908","reservation_id":"103966","confirmation_number":"SJ12650428901","room_confirmation_number":"SJ12648980816","room_stay_from":"2020-12-30","room_stay_to":"2020-12-31","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":"110274","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-19 00:36:10","reservation_modified_date_time":"2020-12-30 16:36:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110274","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3172150","reservation_id":"102256","confirmation_number":"SJ12628618335","room_confirmation_number":"SJ12618513018","room_stay_from":"2020-12-29","room_stay_to":"2020-12-31","room_stay_status":"Active","nightly_price":"25,25","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":"108415","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-03 19:22:13","reservation_modified_date_time":"2020-12-31 00:02:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108415","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146855","reservation_id":"96857","confirmation_number":"SJ12640738224","room_confirmation_number":"SJ12641178022","room_stay_from":"2020-12-27","room_stay_to":"2021-01-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102873","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-20 02:30:57","reservation_modified_date_time":"2020-10-17 22:06:32","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3153221","reservation_id":"102032","confirmation_number":"SJ12644617436","room_confirmation_number":"SJ12695810025","room_stay_from":"2020-12-28","room_stay_to":"2021-01-01","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":"108151","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-28 14:59:06","reservation_modified_date_time":"2020-11-08 17:45:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108151","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3162646","reservation_id":"97094","confirmation_number":"SJ12689407031","room_confirmation_number":"SJ12626056536","room_stay_from":"2020-12-25","room_stay_to":"2021-01-01","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":"103214","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 00:21:44","reservation_modified_date_time":"2020-12-07 14:41:06","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3165860","reservation_id":"103181","confirmation_number":"SJ12670210606","room_confirmation_number":"SJ12639424000","room_stay_from":"2020-12-27","room_stay_to":"2021-01-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"109333","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-27 15:49:10","reservation_modified_date_time":"2020-12-16 16:17:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109333","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3168577","reservation_id":"95495","confirmation_number":"SJ12644924635","room_confirmation_number":"SJ12674753883","room_stay_from":"2020-12-29","room_stay_to":"2021-01-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101684","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 16:46:41","reservation_modified_date_time":"2020-12-21 19:26:02","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3168835","reservation_id":"104102","confirmation_number":"SJ12651477408","room_confirmation_number":"SJ12621329822","room_stay_from":"2020-12-27","room_stay_to":"2021-01-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"110436","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-22 10:01:07","reservation_modified_date_time":"2020-12-22 10:01:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110436","canceled_nights_data":"","posAmt_airbnb_taxpaid":"125.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3169734","reservation_id":"102832","confirmation_number":"SJ12699028407","room_confirmation_number":"SJ12622754069","room_stay_from":"2020-12-30","room_stay_to":"2021-01-01","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":"108971","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-19 02:03:10","reservation_modified_date_time":"2020-12-24 19:40:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108971","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170612","reservation_id":"102894","confirmation_number":"SJ12679514419","room_confirmation_number":"SJ12662571034","room_stay_from":"2020-12-28","room_stay_to":"2021-01-01","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"109026","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-20 18:39:22","reservation_modified_date_time":"2020-12-26 23:34:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109026","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146703","reservation_id":"95487","confirmation_number":"SJ12631629088","room_confirmation_number":"SJ12673847493","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","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":"101678","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 16:28:02","reservation_modified_date_time":"2020-10-17 22:06:31","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146705","reservation_id":"95488","confirmation_number":"SJ12641723483","room_confirmation_number":"SJ12637731060","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","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":"101678","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 16:28:43","reservation_modified_date_time":"2020-10-17 22:06:31","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146707","reservation_id":"95489","confirmation_number":"SJ12687269033","room_confirmation_number":"SJ12619590336","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","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":"101678","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 16:29:39","reservation_modified_date_time":"2020-10-17 22:06:31","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3153338","reservation_id":"102019","confirmation_number":"SJ12683695838","room_confirmation_number":"SJ12621765128","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","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":"108137","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-28 01:26:53","reservation_modified_date_time":"2020-11-08 20:52:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3163069","reservation_id":"103595","confirmation_number":"SJ12629632631","room_confirmation_number":"SJ12691111785","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","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":"109841","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-08 03:03:09","reservation_modified_date_time":"2020-12-08 03:03:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109841","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3165851","reservation_id":"103359","confirmation_number":"SJ12658912222","room_confirmation_number":"SJ12667756358","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","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":"109530","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-01 20:51:27","reservation_modified_date_time":"2020-12-16 16:13:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109530","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3167905","reservation_id":"104016","confirmation_number":"SJ12614226892","room_confirmation_number":"SJ12685124954","room_stay_from":"2020-12-27","room_stay_to":"2021-01-02","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":"110339","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-20 17:26:12","reservation_modified_date_time":"2020-12-20 17:26:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110339","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3169737","reservation_id":"96198","confirmation_number":"SJ12678366034","room_confirmation_number":"SJ12634219277","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","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":"102321","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-09 23:53:34","reservation_modified_date_time":"2020-12-24 19:43:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102321","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170176","reservation_id":"102806","confirmation_number":"SJ12699468217","room_confirmation_number":"SJ12676225026","room_stay_from":"2020-12-26","room_stay_to":"2021-01-02","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":"108949","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-18 14:39:12","reservation_modified_date_time":"2020-12-26 14:38:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108949","canceled_nights_data":"","posAmt_airbnb_taxpaid":"350.00","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170745","reservation_id":"104034","confirmation_number":"SJ12614836396","room_confirmation_number":"SJ12683191956","room_stay_from":"2020-12-28","room_stay_to":"2021-01-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"110366","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-21 00:11:07","reservation_modified_date_time":"2020-12-27 12:34:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110366","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170895","reservation_id":"102450","confirmation_number":"SJ12638405517","room_confirmation_number":"SJ12633528958","room_stay_from":"2020-12-27","room_stay_to":"2021-01-02","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":"108615","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-08 22:45:26","reservation_modified_date_time":"2020-12-27 18:37:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108615","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170927","reservation_id":"104306","confirmation_number":"SJ12613535687","room_confirmation_number":"SJ12618570825","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","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":"110660","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-27 19:21:08","reservation_modified_date_time":"2020-12-27 19:21:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110660","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171138","reservation_id":"104052","confirmation_number":"SJ12634056432","room_confirmation_number":"SJ12685641931","room_stay_from":"2020-12-28","room_stay_to":"2021-01-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"110384","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-21 14:19:07","reservation_modified_date_time":"2020-12-28 17:18:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110384","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171916","reservation_id":"103525","confirmation_number":"SJ12641295891","room_confirmation_number":"SJ12639810697","room_stay_from":"2020-12-30","room_stay_to":"2021-01-02","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":"109755","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-06 14:01:32","reservation_modified_date_time":"2020-12-30 16:38:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109755","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146849","reservation_id":"96755","confirmation_number":"SJ12616352970","room_confirmation_number":"SJ12627282701","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","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":"102873","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 14:24:52","reservation_modified_date_time":"2020-10-17 22:06:32","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146851","reservation_id":"96755","confirmation_number":"SJ12679356732","room_confirmation_number":"SJ12622659123","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","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":"102873","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 14:24:51","reservation_modified_date_time":"2020-10-17 22:06:32","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3146853","reservation_id":"96755","confirmation_number":"SJ12680575456","room_confirmation_number":"SJ12637553566","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","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":"102873","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 14:24:51","reservation_modified_date_time":"2020-10-17 22:06:32","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3152363","reservation_id":"95494","confirmation_number":"SJ12641268815","room_confirmation_number":"SJ12621861390","room_stay_from":"2020-12-29","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101683","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-27 16:45:02","reservation_modified_date_time":"2020-11-05 20:38:43","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3168969","reservation_id":"104122","confirmation_number":"SJ12620990003","room_confirmation_number":"SJ12673366310","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","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":"110455","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-22 20:25:05","reservation_modified_date_time":"2020-12-22 20:25:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110455","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170674","reservation_id":"101518","confirmation_number":"SJ12636012730","room_confirmation_number":"SJ12651133298","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","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":"107596","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-14 01:33:37","reservation_modified_date_time":"2020-12-26 23:51:18","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3170932","reservation_id":"100153","confirmation_number":"SJ12697579487","room_confirmation_number":"SJ12668031535","room_stay_from":"2020-12-27","room_stay_to":"2021-01-03","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":"106171","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-09 00:33:49","reservation_modified_date_time":"2020-12-27 19:39:39","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171758","reservation_id":"103797","confirmation_number":"SJ12667160271","room_confirmation_number":"SJ12646173411","room_stay_from":"2020-12-29","room_stay_to":"2021-01-03","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":"110727","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-14 15:16:09","reservation_modified_date_time":"2020-12-29 22:07:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110071","canceled_nights_data":"","posAmt_airbnb_taxpaid":"250.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171857","reservation_id":"104414","confirmation_number":"SJ12671179752","room_confirmation_number":"SJ12688948753","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","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":"110763","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-30 01:48:07","reservation_modified_date_time":"2020-12-30 13:09:26","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110763","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3172142","reservation_id":"102093","confirmation_number":"SJ12646382893","room_confirmation_number":"SJ12638499642","room_stay_from":"2020-12-30","room_stay_to":"2021-01-03","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":"108225","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-30 00:23:09","reservation_modified_date_time":"2020-12-30 23:05:44","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108225","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3170793","reservation_id":"104293","confirmation_number":"SJ12667211257","room_confirmation_number":"SJ12688411107","room_stay_from":"2020-12-30","room_stay_to":"2021-01-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"110649","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-27 14:41:09","reservation_modified_date_time":"2020-12-27 15:27:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110649","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3171898","reservation_id":"103800","confirmation_number":"SJ12643886900","room_confirmation_number":"SJ12677289410","room_stay_from":"2021-05-21","room_stay_to":"2021-05-24","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110073","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-14 16:05:10","reservation_modified_date_time":"2020-12-30 16:05:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110073","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"both dates 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":"3171974","reservation_id":"102441","confirmation_number":"SJ12672197922","room_confirmation_number":"SJ12639882424","room_stay_from":"2021-02-05","room_stay_to":"2021-02-09","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"108604","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-08 19:34:38","reservation_modified_date_time":"2020-12-30 17:41:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108604","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"both dates 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":"3172000","reservation_id":"102442","confirmation_number":"SJ12654930249","room_confirmation_number":"SJ12633108468","room_stay_from":"2020-12-27","room_stay_to":"2020-12-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"108607","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-08 20:43:52","reservation_modified_date_time":"2020-12-30 18:27:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108607","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3172007","reservation_id":"102442","confirmation_number":"SJ12681783429","room_confirmation_number":"SJ12631978185","room_stay_from":"2020-12-27","room_stay_to":"2020-12-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"108607","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-08 20:43:52","reservation_modified_date_time":"2020-12-30 18:29:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108607","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3171993","reservation_id":"104437","confirmation_number":"SJ12654748717","room_confirmation_number":"SJ12670400085","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.65","grand_total":"5.00","paid_amount":"5.00","product_id":"2073","service_quantity":"1","product_name":"Face Mask","parentTypeOfRes":"reservation","reservation_created_date":"2020-12-30 18:18:56","reservation_modified_date_time":"2020-12-30 18:18:56","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","currentDayPrice":"4.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3171994","reservation_id":"104437","confirmation_number":"SJ12674172300","room_confirmation_number":"SJ12670400085","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-12-30 18:18:56","reservation_modified_date_time":"2020-12-30 18:18:56","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}