{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-02-21","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":23,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1297","block_room_bookings":[{"confirmation_number":"SJ12680392580","room_stay_from":"2021-02-18","room_stay_to":"2021-02-28","bundle_room":"0","product_id":"1297"}],"bundle_block_count":"1307,1308,1271,1272,1311,1312,1260,1261,1304,1305,1309,1310,1262,1263,1291,1711,1267,1268,1302,1303","bundle_block_bookings":[{"confirmation_number":"SJB12623894266","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12665041836","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12659617148","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12689777920","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12660502457","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12690136283","room_stay_from":"2021-02-21","room_stay_to":"2021-02-23","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12660715736","room_stay_from":"2021-02-18","room_stay_to":"2021-02-23","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12610562601","room_stay_from":"2021-02-18","room_stay_to":"2021-02-23","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12669558217","room_stay_from":"2021-02-21","room_stay_to":"2021-02-23","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12699607765","room_stay_from":"2021-02-20","room_stay_to":"2021-02-24","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12657578174","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12664365860","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12629776051","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12612334921","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12662873179","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","bundle_room":"0","product_id":"1303"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3180562","reservation_id":"105520","confirmation_number":"SJ12619332741","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.28,179.28","nightly_discount":"0,0","subtotal":"430.56","grand_total":"484.38","paid_amount":"484.38","room_type_id":"413","product_id":"1268","siteminder_id":"BDC-3262963722","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":"111932","customer_id":"111932","source_of_creation":"Booking.com","reservation_created_date":"2021-01-17 19:58:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"86.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"179.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":"3190789","reservation_id":"105175","confirmation_number":"SJ12660950234","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.28,179.28","nightly_discount":"0,0","subtotal":"430.56","grand_total":"484.38","paid_amount":"484.38","room_type_id":"413","product_id":"1272","siteminder_id":"BDC-3587185384","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":"111549","customer_id":"111549","source_of_creation":"Booking.com","reservation_created_date":"2021-01-11 16:24:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"86.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"179.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":"3194235","reservation_id":"107166","confirmation_number":"SJ12641925788","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.28,251.28","nightly_discount":"0,0","subtotal":"502.56","grand_total":"565.38","paid_amount":"565.38","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-2193617543","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":"113621","customer_id":"113621","source_of_creation":"Booking.com","reservation_created_date":"2021-02-08 17:50:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"99.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"251.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":"3199251","reservation_id":"107824","confirmation_number":"SJ12628428415","room_stay_from":"2021-02-19","room_stay_to":"2021-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.24,230.24,230.24","nightly_discount":"0,0,0","subtotal":"690.72","grand_total":"777.06","paid_amount":"777.06","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3924500240","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":"114282","customer_id":"114282","source_of_creation":"Booking.com","reservation_created_date":"2021-02-16 19:52:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"137.83","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3201654","reservation_id":"105173","confirmation_number":"SJ12692916777","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"399.20,319.20","nightly_discount":"0,0","subtotal":"718.40","grand_total":"808.20","paid_amount":"808.20","room_type_id":"320","product_id":"1332","siteminder_id":"BDC-2941459080","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":"111547","customer_id":"111547","source_of_creation":"Booking.com","reservation_created_date":"2021-01-11 16:13:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"138.31","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"319.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":"3202354","reservation_id":"108182","confirmation_number":"SJ12687587181","room_stay_from":"2021-02-21","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.15,213.19","nightly_discount":"0,0","subtotal":"439.34","grand_total":"494.26","paid_amount":"494.26","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3102839523","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114647","customer_id":"114647","source_of_creation":"Booking.com","reservation_created_date":"2021-02-21 17:40:20","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"226.15","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3179464","reservation_id":"104587","confirmation_number":"SJ12686301450","room_stay_from":"2021-02-19","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.30,202.30,174.30,174.30,174.30,174.30,174.30,202.30","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1478.40","grand_total":"1663.20","paid_amount":"1663.20","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-2331247034","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114516","customer_id":"110936","source_of_creation":"Booking.com","reservation_created_date":"2021-01-02 18:01:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"302.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3184971","reservation_id":"106179","confirmation_number":"SJ12615389852","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.67,194.67,175.77,175.77,175.77,200.97","nightly_discount":"0,0,0,0,0,0","subtotal":"1117.62","grand_total":"1257.32","paid_amount":"1257.32","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2126163221","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112586","customer_id":"112586","source_of_creation":"Booking.com","reservation_created_date":"2021-01-26 18:01:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"228.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"194.67","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3200914","reservation_id":"106188","confirmation_number":"SJ12640825161","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"238.77,194.67,194.67,175.77,175.77,175.77,200.97","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1356.39","grand_total":"1525.94","paid_amount":"1525.94","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3239349705","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112595","customer_id":"112595","source_of_creation":"Booking.com","reservation_created_date":"2021-01-26 19:37:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"275.66","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"194.67","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3184751","reservation_id":"105039","confirmation_number":"SJ12621517718","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"326.36,262.36","nightly_discount":"0,0","subtotal":"588.72","grand_total":"662.31","paid_amount":"662.31","room_type_id":"320","product_id":"1330","siteminder_id":"EXP-1728596683","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111413","customer_id":"111413","source_of_creation":"Expedia","reservation_created_date":"2021-01-09 02:01:06","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"262.36","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":"3197697","reservation_id":"105735","confirmation_number":"SJ12676758809","room_stay_from":"2021-02-18","room_stay_to":"2021-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.84,212.24,212.24,156.24","nightly_discount":"0,0,0,0","subtotal":"770.56","grand_total":"866.88","paid_amount":"866.88","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1731448754","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":"112131","customer_id":"112131","source_of_creation":"Expedia","reservation_created_date":"2021-01-20 19:46:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"156.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3200496","reservation_id":"107077","confirmation_number":"SJ12681766931","room_stay_from":"2021-02-18","room_stay_to":"2021-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"265.30,265.30,265.30,265.30","nightly_discount":"0,0,0,0","subtotal":"1061.20","grand_total":"1193.85","paid_amount":"1193.85","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1736003005","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":"113525","customer_id":"113525","source_of_creation":"Expedia","reservation_created_date":"2021-02-07 12:35:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"265.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3174267","reservation_id":"104751","confirmation_number":"SJ12683537895","room_stay_from":"2021-02-18","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.30,202.30,202.30,174.30,174.30","nightly_discount":"0,0,0,0,0","subtotal":"927.50","grand_total":"1043.44","paid_amount":"1043.44","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1727606096","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111104","customer_id":"111104","source_of_creation":"Expedia","reservation_created_date":"2021-01-05 01:56:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"0","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192531","reservation_id":"106990","confirmation_number":"SJ12684637228","room_stay_from":"2021-02-15","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.04,159.04,159.04,159.04,159.04,159.04,159.04,150.64","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1263.92","grand_total":"1421.91","paid_amount":"1421.91","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1735623211","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113427","customer_id":"113427","source_of_creation":"Expedia","reservation_created_date":"2021-02-05 22:15:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"159.04","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3201160","reservation_id":"105087","confirmation_number":"SJ12688982589","room_stay_from":"2021-02-19","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"244.30,244.30,174.30,174.30","nightly_discount":"0,0,0,0","subtotal":"837.20","grand_total":"941.85","paid_amount":"941.85","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1728752820","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111461","customer_id":"111461","source_of_creation":"Expedia","reservation_created_date":"2021-01-09 20:36:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3180456","reservation_id":"105515","confirmation_number":"SJ12650920347","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"223.44,223.44,223.44,223.44","nightly_discount":"0,0,0,0","subtotal":"893.76","grand_total":"1005.48","paid_amount":"1005.48","room_type_id":"320","product_id":"1714","siteminder_id":"EXP-1730698443","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111930","customer_id":"111930","source_of_creation":"Expedia","reservation_created_date":"2021-01-17 18:41:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1291,1711","currentDayPrice":"223.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181138","reservation_id":"105583","confirmation_number":"SJ12657879374","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.30,195.30,195.30,195.30","nightly_discount":"0,0,0,0","subtotal":"781.20","grand_total":"878.85","paid_amount":"878.85","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1731006446","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112004","customer_id":"112004","source_of_creation":"Expedia","reservation_created_date":"2021-01-18 23:11:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3191344","reservation_id":"106859","confirmation_number":"SJ12631859348","room_stay_from":"2021-02-20","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.24,215.04,215.04,215.04,215.04","nightly_discount":"0,0,0,0,0","subtotal":"1086.40","grand_total":"1222.20","paid_amount":"1222.20","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1735109301","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113289","customer_id":"113289","source_of_creation":"Expedia","reservation_created_date":"2021-02-04 01:35:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"215.04","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192502","reservation_id":"105584","confirmation_number":"SJ12613428247","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.30,174.30,174.30,174.30","nightly_discount":"0,0,0,0","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1731007797","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112005","customer_id":"112005","source_of_creation":"Expedia","reservation_created_date":"2021-01-18 23:16:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"174.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192728","reservation_id":"104790","confirmation_number":"SJ12621564410","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"128.44,128.44,128.44,128.44","nightly_discount":"0,0,0,0","subtotal":"513.76","grand_total":"577.98","paid_amount":"577.98","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1727743016","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111137","customer_id":"111137","source_of_creation":"Expedia","reservation_created_date":"2021-01-05 18:01:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"128.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3176699","reservation_id":"104843","confirmation_number":"SJ12684726620","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.44,139.44,139.44,139.44,139.44","nightly_discount":"0,0,0,0,0","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1727876153","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111193","customer_id":"111193","source_of_creation":"Expedia","reservation_created_date":"2021-01-06 03:56:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"139.44","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181206","reservation_id":"105308","confirmation_number":"SJ12644139433","room_stay_from":"2021-02-20","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.24,156.24,156.24,156.24,156.24,156.24","nightly_discount":"0,0,0,0,0,0","subtotal":"993.44","grand_total":"1117.62","paid_amount":"1117.62","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1729820159","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111696","customer_id":"111696","source_of_creation":"Expedia","reservation_created_date":"2021-01-14 03:16:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"156.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3183966","reservation_id":"106038","confirmation_number":"SJ12656697395","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.24,170.24,170.24,170.24,170.24,170.24,192.64","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1270.08","grand_total":"1428.84","paid_amount":"1428.84","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1732504814","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112465","customer_id":"112465","source_of_creation":"Expedia","reservation_created_date":"2021-01-25 02:27:07","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"170.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190748","reservation_id":"106769","confirmation_number":"SJ12635013549","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.24,201.04,201.04,201.04,201.04,201.04,184.24","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1401.68","grand_total":"1576.89","paid_amount":"1576.89","room_type_id":"413","product_id":"1262","siteminder_id":"EXP-1734776504","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113191","customer_id":"113191","source_of_creation":"Expedia","reservation_created_date":"2021-02-02 21:56:31","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"201.04","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3200911","reservation_id":"105363","confirmation_number":"SJ12669033208","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.44,139.44,139.44,139.44,139.44,161.84","nightly_discount":"0,0,0,0,0,0","subtotal":"859.04","grand_total":"966.42","paid_amount":"966.42","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1730104359","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111754","customer_id":"111754","source_of_creation":"Expedia","reservation_created_date":"2021-01-15 04:56:29","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3201226","reservation_id":"105309","confirmation_number":"SJ12614372867","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.30,195.30,195.30,195.30,195.30,223.30,223.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1423.10","grand_total":"1600.99","paid_amount":"1600.99","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1729820610","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111697","customer_id":"111697","source_of_creation":"Expedia","reservation_created_date":"2021-01-14 03:16:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3174677","reservation_id":"104119","confirmation_number":"SJ12640591791","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.44,167.44,167.44,167.44,167.44,184.24,184.24,167.44,171.92,171.92,171.92,171.92,188.72,188.72","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"2438.24","grand_total":"2743.02","paid_amount":"2743.02","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1724692080","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110451","customer_id":"110451","source_of_creation":"Expedia","reservation_created_date":"2020-12-22 19:01:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"167.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3201392","reservation_id":"107603","confirmation_number":"SJ12693714909","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"343.65,347.82","nightly_discount":"0.00,0.00","subtotal":"691.47","grand_total":"801.32","paid_amount":"801.32","room_type_id":"319","product_id":"1313","siteminder_id":"ABB-HMFHFBYAQB","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"695.64","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114058","customer_id":"114058","source_of_creation":"Airbnb","reservation_created_date":"2021-02-14 17:06:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"20.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"347.82","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":"3200405","reservation_id":"102989","confirmation_number":"SJ12620479354","room_stay_from":"2021-02-18","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"329.77,339.79,339.79,339.79,339.79","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1688.93","grand_total":"2193.80","paid_amount":"2193.80","room_type_id":"320","product_id":"1329","siteminder_id":"ABB-HMTTNZCHEK","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1698.95","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109126","customer_id":"109126","source_of_creation":"Airbnb","reservation_created_date":"2020-11-22 19:54:05","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"261.38","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"339.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3201664","reservation_id":"105259","confirmation_number":"SJ12676286740","room_stay_from":"2021-02-20","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"259.08,259.08,254.42","nightly_discount":"0.00,0.00,0.00","subtotal":"772.58","grand_total":"895.31","paid_amount":"895.31","room_type_id":"413","product_id":"1273","siteminder_id":"ABB-HM2E2TB9Y4","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"777.24","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111643","customer_id":"111643","source_of_creation":"Airbnb","reservation_created_date":"2021-01-13 05:54:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"22.86","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"259.08","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3202058","reservation_id":"106209","confirmation_number":"SJ12642723123","room_stay_from":"2021-02-21","room_stay_to":"2021-02-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"242.40,246.84,246.84","nightly_discount":"0.00,0.00,0.00","subtotal":"736.08","grand_total":"853.01","paid_amount":"853.01","room_type_id":"319","product_id":"1287","siteminder_id":"ABB-HMQ42P2A3Q","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"740.52","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112618","customer_id":"112618","source_of_creation":"Airbnb","reservation_created_date":"2021-01-27 00:15:26","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"21.78","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"242.40","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":"3202066","reservation_id":"108159","confirmation_number":"SJ12618421378","room_stay_from":"2021-03-09","room_stay_to":"2021-03-12","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"274.38,274.38,274.38","nightly_discount":"0,0,0","subtotal":"823.14","grand_total":"953.13","paid_amount":"0.00","room_type_id":"413","product_id":"1266","siteminder_id":"ABB-HMDDCMFB8C","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"823.14","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114626","customer_id":"114626","source_of_creation":"Airbnb","reservation_created_date":"2021-02-21 02:24:26","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"24.21","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3190719","reservation_id":"106716","confirmation_number":"SJ12637987977","room_stay_from":"2021-02-21","room_stay_to":"2021-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"139.00","nightly_discount":"0","subtotal":"139.00","grand_total":"156.38","paid_amount":"156.38","room_type_id":"319","product_id":"1319","siteminder_id":"HWR-303189473","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113139","customer_id":"113139","source_of_creation":"Hotwire","reservation_created_date":"2021-02-02 03:28:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.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":"3200445","reservation_id":"106315","confirmation_number":"SJ12690285399","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,99.00","nightly_discount":"0,0","subtotal":"218.00","grand_total":"245.25","paid_amount":"245.25","room_type_id":"319","product_id":"1943","siteminder_id":"HWR-303122300","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":"112712","customer_id":"112712","source_of_creation":"Hotwire","reservation_created_date":"2021-01-28 02:09:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"99.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202053","reservation_id":"105607","confirmation_number":"SJ12658569454","room_stay_from":"2021-02-21","room_stay_to":"2021-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.38","paid_amount":"111.38","room_type_id":"413","product_id":"1271","siteminder_id":"HWR-303124168","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":"112028","customer_id":"112028","source_of_creation":"Hotwire","reservation_created_date":"2021-01-19 03:12:09","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":"","sub_hotel_id":"126","currentDayPrice":"99.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":"3202358","reservation_id":"106858","confirmation_number":"SJ12611298834","room_stay_from":"2021-02-21","room_stay_to":"2021-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"290.25","paid_amount":"290.25","room_type_id":"319","product_id":"1309","siteminder_id":"HWR-303209653","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113288","customer_id":"113288","source_of_creation":"Hotwire","reservation_created_date":"2021-02-04 01:27:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3190934","reservation_id":"106800","confirmation_number":"SJ12698761438","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"284.25,269.25,269.25,269.25,269.25,269.25,246.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1877.25","grand_total":"2111.90","paid_amount":"2111.90","room_type_id":"318","product_id":"1282","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113224","customer_id":"113224","source_of_creation":"FE","reservation_created_date":"2021-02-03 03:00:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"269.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3199954","reservation_id":"107465","confirmation_number":"SJ12620005683","room_stay_from":"2021-02-17","room_stay_to":"2021-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"204.28,204.28,204.28,204.28,204.28","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1021.40","grand_total":"1149.08","paid_amount":"1149.08","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113412","customer_id":"113412","source_of_creation":"PMS","reservation_created_date":"2021-02-12 19:26:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"204.28","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3199956","reservation_id":"106409","confirmation_number":"SJ12696843895","room_stay_from":"2021-02-17","room_stay_to":"2021-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"254.25,254.25,284.25,284.25,231.75","nightly_discount":"12.71,12.71,14.21,14.21,11.59","subtotal":"1308.75","grand_total":"1398.74","paid_amount":"1398.74","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112804","customer_id":"112804","source_of_creation":"PMS","reservation_created_date":"2021-01-29 14:26:09","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":"FLRES","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"231.75","currentDayDiscount":"11.59","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181958","reservation_id":"102496","confirmation_number":"SJ12671908496","room_stay_from":"2021-02-17","room_stay_to":"2021-02-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"199.20,199.20,231.20,231.20,199.20,199.20,199.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1458.40","grand_total":"1640.70","paid_amount":"1640.70","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108658","customer_id":"108658","source_of_creation":"PMS","reservation_created_date":"2020-11-10 18:04:18","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"199.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192067","reservation_id":"105215","confirmation_number":"SJ12667678030","room_stay_from":"2021-02-17","room_stay_to":"2021-02-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,269.25,284.25,284.25,209.25,209.25,209.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1564.50","grand_total":"1760.07","paid_amount":"1760.07","room_type_id":"319","product_id":"1915","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111606","customer_id":"111606","source_of_creation":"PMS","reservation_created_date":"2021-01-12 14:04:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"209.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181777","reservation_id":"105481","confirmation_number":"SJ12642034519","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.75,186.75,186.75,186.75,186.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"933.75","grand_total":"1050.47","paid_amount":"1050.47","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111896","customer_id":"111896","source_of_creation":"PMS","reservation_created_date":"2021-01-16 23:23:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"186.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3189341","reservation_id":"106562","confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101703","customer_id":"101703","source_of_creation":"PMS","reservation_created_date":"2021-01-31 18:54:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"0.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202264","reservation_id":"105998","confirmation_number":"SJ12684183158","room_stay_from":"2021-04-10","room_stay_to":"2021-04-11","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.65","nightly_discount":"11.43","subtotal":"228.65","grand_total":"244.37","paid_amount":"257.23","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112419","customer_id":"112419","source_of_creation":"PMS","reservation_created_date":"2021-01-24 19:03:26","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":"AAA","sub_hotel_id":"0","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3181204","reservation_id":"105602","confirmation_number":"SJ12680282851","room_stay_from":"2021-02-17","room_stay_to":"2021-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"570.00","grand_total":"570.00","paid_amount":"140.63","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-01-19 02:49:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3200997","reservation_id":"105427","confirmation_number":"SJ12621975795","room_stay_from":"2021-02-19","room_stay_to":"2021-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.00,178.00,178.00,178.00,178.00,178.00,178.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1246.00","grand_total":"1246.00","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-01-16 02:43:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"178.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3197141","reservation_id":"106999","confirmation_number":"SJ12640521255","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.00,178.00,178.00,178.00,178.00,178.00,178.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1246.00","grand_total":"1246.00","paid_amount":"0.00","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-02-05 23:59:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"178.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181214","reservation_id":"105605","confirmation_number":"SJ12628104872","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"798.00","grand_total":"798.00","paid_amount":"196.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-01-19 02:53:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3184754","reservation_id":"105039","confirmation_number":"SJ12625284745","room_confirmation_number":"SJ12621517718","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","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":"1777","service_quantity":"1","customer_traveller_id":"111413","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-01-26 14:03:01","reservation_modified_date_time":"2021-01-26 14:03:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111413","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190720","reservation_id":"106716","confirmation_number":"SJ12690073126","room_confirmation_number":"SJ12637987977","room_stay_from":"2021-02-21","room_stay_to":"2021-02-22","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"113139","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-02 22:44:34","reservation_modified_date_time":"2021-02-02 22:44:34","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113139","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192729","reservation_id":"104790","confirmation_number":"SJ12629250989","room_confirmation_number":"SJ12621564410","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"111137","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-05 23:54:12","reservation_modified_date_time":"2021-02-05 23:54:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111137","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3180563","reservation_id":"105520","confirmation_number":"SJ12670341968","room_confirmation_number":"SJ12619332741","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","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":"111932","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-17 19:58:13","reservation_modified_date_time":"2021-01-17 19:58:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111932","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181205","reservation_id":"105602","confirmation_number":"SJ12668287238","room_confirmation_number":"SJ12680282851","room_stay_from":"2021-02-17","room_stay_to":"2021-02-22","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":"112023","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-19 02:49:09","reservation_modified_date_time":"2021-01-19 02:49:09","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3184755","reservation_id":"105039","confirmation_number":"SJ12677402857","room_confirmation_number":"SJ12621517718","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","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":"111413","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-09 02:01:06","reservation_modified_date_time":"2021-01-26 14:03:02","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111413","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190721","reservation_id":"106716","confirmation_number":"SJ12684815211","room_confirmation_number":"SJ12637987977","room_stay_from":"2021-02-21","room_stay_to":"2021-02-22","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":"113139","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-02 03:28:06","reservation_modified_date_time":"2021-02-02 22:44:34","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113139","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190790","reservation_id":"105175","confirmation_number":"SJ12648120721","room_confirmation_number":"SJ12660950234","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","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":"111549","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-11 16:24:10","reservation_modified_date_time":"2021-02-02 22:58:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111549","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3194236","reservation_id":"107166","confirmation_number":"SJ12663523709","room_confirmation_number":"SJ12641925788","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","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":"113621","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-08 17:50:13","reservation_modified_date_time":"2021-02-08 17:50:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113621","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3197698","reservation_id":"105735","confirmation_number":"SJ12614231800","room_confirmation_number":"SJ12676758809","room_stay_from":"2021-02-18","room_stay_to":"2021-02-22","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":"112131","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-20 19:46:06","reservation_modified_date_time":"2021-02-13 23:34:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112131","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3199252","reservation_id":"107824","confirmation_number":"SJ12659311966","room_confirmation_number":"SJ12628428415","room_stay_from":"2021-02-19","room_stay_to":"2021-02-22","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":"114282","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-16 19:52:09","reservation_modified_date_time":"2021-02-16 19:52:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114282","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3199955","reservation_id":"107465","confirmation_number":"SJ12694652967","room_confirmation_number":"SJ12620005683","room_stay_from":"2021-02-17","room_stay_to":"2021-02-22","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":"113412","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 19:26:57","reservation_modified_date_time":"2021-02-17 21:02:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113412","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3199957","reservation_id":"106409","confirmation_number":"SJ12662332206","room_confirmation_number":"SJ12696843895","room_stay_from":"2021-02-17","room_stay_to":"2021-02-22","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":"112804","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 14:26:09","reservation_modified_date_time":"2021-02-17 21:02:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112804","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3200447","reservation_id":"106315","confirmation_number":"SJ12649296866","room_confirmation_number":"SJ12690285399","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","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":"112712","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 02:09:09","reservation_modified_date_time":"2021-02-18 17:43:33","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112712","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3200497","reservation_id":"107077","confirmation_number":"SJ12623919911","room_confirmation_number":"SJ12681766931","room_stay_from":"2021-02-18","room_stay_to":"2021-02-22","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":"113525","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-07 12:35:15","reservation_modified_date_time":"2021-02-18 18:06:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113525","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3201393","reservation_id":"107603","confirmation_number":"SJ12697341648","room_confirmation_number":"SJ12693714909","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114058","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 17:06:12","reservation_modified_date_time":"2021-02-20 16:11:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114058","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3201657","reservation_id":"105173","confirmation_number":"SJ12684416304","room_confirmation_number":"SJ12692916777","room_stay_from":"2021-02-20","room_stay_to":"2021-02-22","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":"111547","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-11 16:13:09","reservation_modified_date_time":"2021-02-20 21:05:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111547","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202054","reservation_id":"105607","confirmation_number":"SJ12696406554","room_confirmation_number":"SJ12658569454","room_stay_from":"2021-02-21","room_stay_to":"2021-02-22","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112028","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-19 03:12:09","reservation_modified_date_time":"2021-02-21 14:55:58","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112028","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3174266","reservation_id":"104751","confirmation_number":"SJ12621772800","room_confirmation_number":"SJ12683537895","room_stay_from":"2021-02-18","room_stay_to":"2021-02-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"111104","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 01:56:15","reservation_modified_date_time":"2021-01-05 02:44:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111104","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192532","reservation_id":"106990","confirmation_number":"SJ12622170524","room_confirmation_number":"SJ12684637228","room_stay_from":"2021-02-15","room_stay_to":"2021-02-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113427","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 22:15:10","reservation_modified_date_time":"2021-02-05 22:15:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113427","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3200408","reservation_id":"102989","confirmation_number":"SJ12679339356","room_confirmation_number":"SJ12620479354","room_stay_from":"2021-02-18","room_stay_to":"2021-02-23","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109126","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-22 19:54:05","reservation_modified_date_time":"2021-02-18 16:42:40","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109126","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3201159","reservation_id":"105087","confirmation_number":"SJ12646792526","room_confirmation_number":"SJ12688982589","room_stay_from":"2021-02-19","room_stay_to":"2021-02-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"114288","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-09 20:36:13","reservation_modified_date_time":"2021-02-19 22:05:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111461","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3201665","reservation_id":"105259","confirmation_number":"SJ12697648995","room_confirmation_number":"SJ12676286740","room_stay_from":"2021-02-20","room_stay_to":"2021-02-23","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111643","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-13 05:54:11","reservation_modified_date_time":"2021-02-20 21:29:44","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111643","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3202356","reservation_id":"108182","confirmation_number":"SJ12672356673","room_confirmation_number":"SJ12687587181","room_stay_from":"2021-02-21","room_stay_to":"2021-02-23","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"114647","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-21 17:40:20","reservation_modified_date_time":"2021-02-21 20:52:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114647","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202360","reservation_id":"106858","confirmation_number":"SJ12668657052","room_confirmation_number":"SJ12611298834","room_stay_from":"2021-02-21","room_stay_to":"2021-02-23","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"25.00,0.00","subtotal":"50.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"113288","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-04 01:27:06","reservation_modified_date_time":"2021-02-21 20:56:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113288","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"25.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181959","reservation_id":"102496","confirmation_number":"SJ12676684265","room_confirmation_number":"SJ12671908496","room_stay_from":"2021-02-17","room_stay_to":"2021-02-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"108658","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-10 18:04:18","reservation_modified_date_time":"2021-01-20 20:20:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108658","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192068","reservation_id":"105215","confirmation_number":"SJ12662043715","room_confirmation_number":"SJ12667678030","room_stay_from":"2021-02-17","room_stay_to":"2021-02-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"111606","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-12 14:04:32","reservation_modified_date_time":"2021-02-05 00:24:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111606","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202059","reservation_id":"106209","confirmation_number":"SJ12616692859","room_confirmation_number":"SJ12642723123","room_stay_from":"2021-02-21","room_stay_to":"2021-02-24","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112618","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 00:15:26","reservation_modified_date_time":"2021-02-21 15:11:31","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112618","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3180457","reservation_id":"105515","confirmation_number":"SJ12696203551","room_confirmation_number":"SJ12650920347","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"111930","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-17 18:41:08","reservation_modified_date_time":"2021-01-17 18:41:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111930","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181139","reservation_id":"105583","confirmation_number":"SJ12617101576","room_confirmation_number":"SJ12657879374","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"112004","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 23:11:08","reservation_modified_date_time":"2021-01-18 23:59:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112004","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3191345","reservation_id":"106859","confirmation_number":"SJ12615472133","room_confirmation_number":"SJ12631859348","room_stay_from":"2021-02-20","room_stay_to":"2021-02-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"113289","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-04 01:35:07","reservation_modified_date_time":"2021-02-04 01:35:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113289","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192503","reservation_id":"105584","confirmation_number":"SJ12617347483","room_confirmation_number":"SJ12613428247","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"112005","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 23:16:18","reservation_modified_date_time":"2021-02-05 21:43:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112005","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192730","reservation_id":"104790","confirmation_number":"SJ12629944003","room_confirmation_number":"SJ12621564410","room_stay_from":"2021-02-21","room_stay_to":"2021-02-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"111137","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 18:01:08","reservation_modified_date_time":"2021-02-05 23:54:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111137","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3176701","reservation_id":"104843","confirmation_number":"SJ12693309515","room_confirmation_number":"SJ12684726620","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"111193","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-06 03:56:12","reservation_modified_date_time":"2021-01-09 17:01:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111193","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181207","reservation_id":"105308","confirmation_number":"SJ12681754001","room_confirmation_number":"SJ12644139433","room_stay_from":"2021-02-20","room_stay_to":"2021-02-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"111696","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 03:16:11","reservation_modified_date_time":"2021-01-19 02:49:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111696","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181779","reservation_id":"105481","confirmation_number":"SJ12644308877","room_confirmation_number":"SJ12642034519","room_stay_from":"2021-02-21","room_stay_to":"2021-02-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"111896","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 23:23:32","reservation_modified_date_time":"2021-01-20 16:02:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111896","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3200998","reservation_id":"105427","confirmation_number":"SJ12660982518","room_confirmation_number":"SJ12621975795","room_stay_from":"2021-02-19","room_stay_to":"2021-02-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111831","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 02:43:22","reservation_modified_date_time":"2021-02-19 17:05:21","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3179465","reservation_id":"104587","confirmation_number":"SJ12610374391","room_confirmation_number":"SJ12686301450","room_stay_from":"2021-02-19","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114516","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-02 18:01:07","reservation_modified_date_time":"2021-01-15 21:59:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110936","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3183967","reservation_id":"106038","confirmation_number":"SJ12681308912","room_confirmation_number":"SJ12656697395","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"112465","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-25 02:27:07","reservation_modified_date_time":"2021-01-25 02:27:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3184972","reservation_id":"106179","confirmation_number":"SJ12692312293","room_confirmation_number":"SJ12615389852","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"112586","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 18:01:08","reservation_modified_date_time":"2021-01-26 18:01:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112586","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190747","reservation_id":"106769","confirmation_number":"SJ12644796727","room_confirmation_number":"SJ12635013549","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"113191","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-02 21:56:31","reservation_modified_date_time":"2021-02-02 22:45:49","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113191","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190935","reservation_id":"106800","confirmation_number":"SJ12617782738","room_confirmation_number":"SJ12698761438","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"113224","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-03 03:00:11","reservation_modified_date_time":"2021-02-03 03:00:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113224","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3197142","reservation_id":"106999","confirmation_number":"SJ12610375317","room_confirmation_number":"SJ12640521255","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113438","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 23:59:52","reservation_modified_date_time":"2021-02-13 04:17:21","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3200912","reservation_id":"105363","confirmation_number":"SJ12689363160","room_confirmation_number":"SJ12669033208","room_stay_from":"2021-02-21","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"111754","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-15 04:56:29","reservation_modified_date_time":"2021-02-19 14:24:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111754","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3200915","reservation_id":"106188","confirmation_number":"SJ12672572211","room_confirmation_number":"SJ12640825161","room_stay_from":"2021-02-20","room_stay_to":"2021-02-27","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"112595","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 19:37:08","reservation_modified_date_time":"2021-02-19 14:25:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112595","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3181215","reservation_id":"105605","confirmation_number":"SJ12644459719","room_confirmation_number":"SJ12628104872","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112026","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-19 02:53:46","reservation_modified_date_time":"2021-01-19 02:53:46","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3201230","reservation_id":"105309","confirmation_number":"SJ12665982658","room_confirmation_number":"SJ12614372867","room_stay_from":"2021-02-21","room_stay_to":"2021-02-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"111697","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 03:16:15","reservation_modified_date_time":"2021-02-20 00:23:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111697","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3174680","reservation_id":"104119","confirmation_number":"SJ12691944516","room_confirmation_number":"SJ12640591791","room_stay_from":"2021-02-21","room_stay_to":"2021-03-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"350.00","grand_total":"393.75","paid_amount":"393.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"110451","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-22 19:01:07","reservation_modified_date_time":"2021-01-05 20:56:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110451","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3189342","reservation_id":"106562","confirmation_number":"SJ12674501286","room_confirmation_number":"SJ12633620796","room_stay_from":"2021-02-12","room_stay_to":"2021-04-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 18:54:06","reservation_modified_date_time":"2021-02-01 18:35:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101703","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202067","reservation_id":"108159","confirmation_number":"SJ12681131277","room_confirmation_number":"SJ12618421378","room_stay_from":"2021-03-09","room_stay_to":"2021-03-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114626","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-21 02:24:26","reservation_modified_date_time":"2021-02-21 15:18:43","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114626","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","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":"3202265","reservation_id":"105998","confirmation_number":"SJ12674917429","room_confirmation_number":"SJ12684183158","room_stay_from":"2021-04-10","room_stay_to":"2021-04-11","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112419","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-24 19:03:26","reservation_modified_date_time":"2021-02-21 18:17:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112419","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3202034","reservation_id":"105039","confirmation_number":"SJ12651919413","room_confirmation_number":"SJ12621517718","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"30.00","paid_amount":"30.00","product_id":"1662","service_quantity":"3","product_name":"Extra Chair or Umbrella","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-21 14:11:15","reservation_modified_date_time":"2021-02-21 14:11:15","customer_id":"111413","parentCustTravId":"111413","customer_traveller_id":"111413","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-02-20","sub_hotel_id":"126","currentDayPrice":"27.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3202043","reservation_id":"107915","confirmation_number":"SJ12670414405","room_confirmation_number":"SJ12676371882","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1710","service_quantity":"1","product_name":"Late Departure Check-Out","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-21 14:32:54","reservation_modified_date_time":"2021-02-21 14:32:54","customer_id":"114377","parentCustTravId":"114377","customer_traveller_id":"114377","static_pos_type":"latecheckoutfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-02-20","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"106","tax_name":"Lodging Tax","tax_percentage":"12.50"}]},{"room_stay_id":"3202033","reservation_id":"108169","confirmation_number":"SJ12615145542","room_confirmation_number":"SJ12612869613","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"30.00","paid_amount":"30.00","product_id":"1654","service_quantity":"2","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-21 14:07:54","reservation_modified_date_time":"2021-02-21 14:07:54","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"27.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3202074","reservation_id":"108176","confirmation_number":"SJ12657134200","room_confirmation_number":"SJ12698628107","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"30.00","paid_amount":"30.00","product_id":"1654","service_quantity":"2","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2021-02-21 15:26:43","reservation_modified_date_time":"2021-02-21 15:26:43","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"27.90","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":[]}}