{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-04-03","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":"1293","hold_room_bookings":[{"confirmation_number":"SJ12648924386","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","bundle_room":"0","product_id":"1293"}],"block_room_count":"1275","block_room_bookings":[{"confirmation_number":"SJ12618960500","room_stay_from":"2021-03-30","room_stay_to":"2021-04-11","bundle_room":"0","product_id":"1275"}],"bundle_block_count":"1262,1263,1267,1268,1269,1270,1309,1310,1291,1711,1260,1261,1307,1308,1311,1312,1271,1272,1304,1305,1302,1303","bundle_block_bookings":[{"confirmation_number":"SJB12660310405","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12690182039","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12622265793","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12677290402","room_stay_from":"2021-04-01","room_stay_to":"2021-04-05","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12628659965","room_stay_from":"2021-04-01","room_stay_to":"2021-04-05","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12612424430","room_stay_from":"2021-03-29","room_stay_to":"2021-04-05","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12673142349","room_stay_from":"2021-03-29","room_stay_to":"2021-04-05","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12610283712","room_stay_from":"2021-04-01","room_stay_to":"2021-04-06","bundle_room":"0","product_id":"1260"},{"confirmation_number":"SJB12659558402","room_stay_from":"2021-04-01","room_stay_to":"2021-04-06","bundle_room":"0","product_id":"1261"},{"confirmation_number":"SJB12613942983","room_stay_from":"2021-04-02","room_stay_to":"2021-04-07","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12672794861","room_stay_from":"2021-04-02","room_stay_to":"2021-04-07","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12615917105","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12616059818","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12658500387","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12639194377","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12640322029","room_stay_from":"2021-04-02","room_stay_to":"2021-04-09","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12695644949","room_stay_from":"2021-04-02","room_stay_to":"2021-04-09","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12689462322","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12670530520","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","bundle_room":"0","product_id":"1303"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3202920","reservation_id":"107433","confirmation_number":"SJ12695963627","room_stay_from":"2021-03-31","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"271.15,271.15,330.55,305.15","nightly_discount":"0,0,0,0","subtotal":"1178.00","grand_total":"1325.25","paid_amount":"1325.25","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-2999273003","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113888","customer_id":"113888","source_of_creation":"Booking.com","reservation_created_date":"2021-02-12 15:46:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"305.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":"3221452","reservation_id":"111126","confirmation_number":"SJ12631402733","room_stay_from":"2021-04-02","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"295.37,295.37","nightly_discount":"0,0","subtotal":"590.74","grand_total":"664.59","paid_amount":"664.59","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-2750520914","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":"118505","customer_id":"117656","source_of_creation":"Booking.com","reservation_created_date":"2021-03-23 21:17:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"115.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"295.37","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3222554","reservation_id":"111312","confirmation_number":"SJ12666250431","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"364.65","nightly_discount":"0","subtotal":"364.65","grand_total":"410.23","paid_amount":"410.23","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-2282814676","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":"117847","customer_id":"117847","source_of_creation":"Booking.com","reservation_created_date":"2021-03-26 02:30:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"70.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"364.65","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3227289","reservation_id":"111706","confirmation_number":"SJ12681762110","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"295.37","nightly_discount":"0","subtotal":"295.37","grand_total":"332.29","paid_amount":"332.29","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-2961413091","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":"118266","customer_id":"118266","source_of_creation":"Booking.com","reservation_created_date":"2021-03-30 19:57:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"57.67","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"295.37","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3187209","reservation_id":"106124","confirmation_number":"SJ12671153111","room_stay_from":"2021-03-30","room_stay_to":"2021-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"219.80,219.80,233.80,261.80,261.80,233.80,233.80","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1664.60","grand_total":"1872.68","paid_amount":"1872.68","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3316278270","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":"112541","customer_id":"112541","source_of_creation":"Booking.com","reservation_created_date":"2021-01-26 01:34:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"331.13","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"261.80","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":"3198472","reservation_id":"107652","confirmation_number":"SJ12615056158","room_stay_from":"2021-04-03","room_stay_to":"2021-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"279.25,249.25,249.25","nightly_discount":"0,0,0","subtotal":"777.75","grand_total":"874.97","paid_amount":"874.97","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-2566880511","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114111","customer_id":"114111","source_of_creation":"Booking.com","reservation_created_date":"2021-02-15 02:55:29","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"348.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"279.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202935","reservation_id":"107652","confirmation_number":"SJ12694345132","room_stay_from":"2021-04-03","room_stay_to":"2021-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"256.75,226.75,226.75","nightly_discount":"0,0,0","subtotal":"710.25","grand_total":"799.03","paid_amount":"799.03","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-2566880511","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":"114111","customer_id":"114111","source_of_creation":"Booking.com","reservation_created_date":"2021-02-15 02:55:24","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":"126","group_rooms":null,"currentDayPrice":"256.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3223593","reservation_id":"107327","confirmation_number":"SJ12677941040","room_stay_from":"2021-03-29","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.80,261.80,261.80,261.80,289.80,289.80,261.80,261.80,240.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2391.20","grand_total":"2690.10","paid_amount":"2690.10","room_type_id":"319","product_id":"1277","siteminder_id":"BDC-3657384126","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":"113785","customer_id":"113785","source_of_creation":"Booking.com","reservation_created_date":"2021-02-11 02:54:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"470.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"289.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3192081","reservation_id":"106937","confirmation_number":"SJ12660023131","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"345.80,317.80,317.80,282.80,282.80","nightly_discount":"0,0,0,0,0","subtotal":"1547.00","grand_total":"1740.38","paid_amount":"1740.38","room_type_id":"320","product_id":"1332","siteminder_id":"BDC-3341394800","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":"113372","customer_id":"113372","source_of_creation":"Booking.com","reservation_created_date":"2021-02-05 01:26:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"300.96","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1311,1312","currentDayPrice":"345.80","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":"3214599","reservation_id":"110154","confirmation_number":"SJ12696259719","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"370.57,336.82,336.82,336.82,323.32","nightly_discount":"0,0,0,0,0","subtotal":"1704.35","grand_total":"1917.40","paid_amount":"1917.40","room_type_id":"320","product_id":"1324","siteminder_id":"BDC-3994456644","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":"116661","customer_id":"116661","source_of_creation":"Booking.com","reservation_created_date":"2021-03-12 19:17:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"329.28","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1271,1272","currentDayPrice":"370.57","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":"3191788","reservation_id":"106746","confirmation_number":"SJ12655644327","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"279.30,279.30,251.30,251.30,216.30,216.30,216.30,244.30","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1954.40","grand_total":"2198.70","paid_amount":"2198.70","room_type_id":"319","product_id":"1314","siteminder_id":"BDC-3665180401","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":"113167","customer_id":"113167","source_of_creation":"Booking.com","reservation_created_date":"2021-02-02 18:16:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"387.79","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"279.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":"3227121","reservation_id":"111850","confirmation_number":"SJ12649168968","room_stay_from":"2021-06-20","room_stay_to":"2021-06-23","room_stay_status":"Active","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"303.00,303.00,333.00","nightly_discount":"0,0,0","subtotal":"939.00","grand_total":"1056.38","paid_amount":"340.88","room_type_id":"320","product_id":"1320","siteminder_id":"BDC-2974734730","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":"118411","customer_id":"118411","source_of_creation":"Booking.com","reservation_created_date":"2021-04-01 22:09:14","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3203019","reservation_id":"107089","confirmation_number":"SJ12655252916","room_stay_from":"2021-03-31","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"223.44,223.44,245.84,245.84","nightly_discount":"0,0,0,0","subtotal":"938.56","grand_total":"1055.88","paid_amount":"1055.88","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1736039763","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":"113540","customer_id":"113540","source_of_creation":"Expedia","reservation_created_date":"2021-02-07 16:55: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":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"245.84","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":"3215227","reservation_id":"109630","confirmation_number":"SJ12659147003","room_stay_from":"2021-04-01","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"284.25,321.75,321.75","nightly_discount":"0,0,0","subtotal":"927.75","grand_total":"1043.72","paid_amount":"1043.72","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1744729463","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":"116105","customer_id":"116105","source_of_creation":"Expedia","reservation_created_date":"2021-03-06 23:47:30","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":"321.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219721","reservation_id":"109077","confirmation_number":"SJ12612831687","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"288.32","nightly_discount":"0","subtotal":"288.32","grand_total":"324.36","paid_amount":"324.36","room_type_id":"413","product_id":"1270","siteminder_id":"EXP-1743345367","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":"115549","customer_id":"115549","source_of_creation":"Expedia","reservation_created_date":"2021-03-03 02:43:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"288.32","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3221010","reservation_id":"111086","confirmation_number":"SJ12675613306","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"271.32","nightly_discount":"0","subtotal":"271.32","grand_total":"305.24","paid_amount":"305.24","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1751137298","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":"117625","customer_id":"117625","source_of_creation":"Expedia","reservation_created_date":"2021-03-23 16:02:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"271.32","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3221832","reservation_id":"111195","confirmation_number":"SJ12682983215","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"339.15","nightly_discount":"0","subtotal":"339.15","grand_total":"381.55","paid_amount":"381.55","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1751592161","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":"117726","customer_id":"117726","source_of_creation":"Expedia","reservation_created_date":"2021-03-24 18:22:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"339.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":"3224537","reservation_id":"111595","confirmation_number":"SJ12698557020","room_stay_from":"2021-04-02","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"360.9,360.9","nightly_discount":"0,0","subtotal":"721.80","grand_total":"812.03","paid_amount":"812.03","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1753479535","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118155","customer_id":"118155","source_of_creation":"Expedia","reservation_created_date":"2021-03-29 16:37:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"360.9","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":"3226584","reservation_id":"109079","confirmation_number":"SJ12696893124","room_stay_from":"2021-04-02","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"291.72,291.72","nightly_discount":"0,0","subtotal":"583.44","grand_total":"656.37","paid_amount":"656.37","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1743345825","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":"115550","customer_id":"115550","source_of_creation":"Expedia","reservation_created_date":"2021-03-03 02:43:11","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":"291.72","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3227391","reservation_id":"111149","confirmation_number":"SJ12673101537","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"325.72","nightly_discount":"0","subtotal":"325.72","grand_total":"366.44","paid_amount":"366.44","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1751356802","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":"117681","customer_id":"117681","source_of_creation":"Expedia","reservation_created_date":"2021-03-24 01:59:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"325.72","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3187283","reservation_id":"104670","confirmation_number":"SJ12665294892","room_stay_from":"2021-03-29","room_stay_to":"2021-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"5","nightly_price":"257.04,257.04,257.04,268.24,290.64,290.64,268.24","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1888.88","grand_total":"2124.99","paid_amount":"2124.99","room_type_id":"320","product_id":"1714","siteminder_id":"EXP-1727317192","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":"111023","customer_id":"111023","source_of_creation":"Expedia","reservation_created_date":"2021-01-03 22:36:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1291,1711","currentDayPrice":"290.64","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3188444","reservation_id":"106540","confirmation_number":"SJ12651938501","room_stay_from":"2021-04-03","room_stay_to":"2021-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.36,213.76","nightly_discount":"0,0","subtotal":"453.12","grand_total":"509.76","paid_amount":"509.76","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1734151449","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":"112959","customer_id":"112959","source_of_creation":"Expedia","reservation_created_date":"2021-01-31 15:01:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"239.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":"3190609","reservation_id":"104860","confirmation_number":"SJ12665286647","room_stay_from":"2021-03-29","room_stay_to":"2021-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,181.30,195.30,223.30,223.30,195.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1381.10","grand_total":"1553.74","paid_amount":"1553.74","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1727955399","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":"111215","customer_id":"111215","source_of_creation":"Expedia","reservation_created_date":"2021-01-06 15:31:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"223.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":"3212257","reservation_id":"105337","confirmation_number":"SJ12615829821","room_stay_from":"2021-04-02","room_stay_to":"2021-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.25,239.25,209.25","nightly_discount":"0,0,0","subtotal":"687.75","grand_total":"773.72","paid_amount":"773.72","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1729967920","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":"111723","customer_id":"111723","source_of_creation":"Expedia","reservation_created_date":"2021-01-14 19:31:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"239.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3200814","reservation_id":"107957","confirmation_number":"SJ12632080324","room_stay_from":"2021-04-03","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.30,223.30,223.30,223.30","nightly_discount":"0,0,0,0","subtotal":"921.20","grand_total":"1036.35","paid_amount":"1036.35","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1739284112","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":"114423","customer_id":"114423","source_of_creation":"Expedia","reservation_created_date":"2021-02-18 12:52:24","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"251.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":"3189237","reservation_id":"104357","confirmation_number":"SJ12667088765","room_stay_from":"2021-04-03","room_stay_to":"2021-04-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.80,233.80,233.80,198.80,198.80,198.80","nightly_discount":"0,0,0,0,0,0","subtotal":"1325.80","grand_total":"1491.53","paid_amount":"1491.53","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1725953977","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":"110707","customer_id":"110707","source_of_creation":"Expedia","reservation_created_date":"2020-12-29 01:46:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"261.80","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":"3188742","reservation_id":"105296","confirmation_number":"SJ12640166141","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"328.30,328.30,300.30,300.30,265.30,265.30,265.30,293.30","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"2346.40","grand_total":"2639.70","paid_amount":"2639.70","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1729770005","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":"111683","customer_id":"111683","source_of_creation":"Expedia","reservation_created_date":"2021-01-13 23:56:08","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":"328.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":"3192155","reservation_id":"106954","confirmation_number":"SJ12654770899","room_stay_from":"2021-04-03","room_stay_to":"2021-04-10","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.80,233.80,233.80,198.80,198.80,198.80,226.80","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1552.60","grand_total":"1746.68","paid_amount":"1746.68","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1735458935","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":"113388","customer_id":"113388","source_of_creation":"Expedia","reservation_created_date":"2021-02-05 07:00:10","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"261.80","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":"3226926","reservation_id":"107501","confirmation_number":"SJ12656885295","room_stay_from":"2021-04-03","room_stay_to":"2021-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"307.37,311.10","nightly_discount":"0.00,0.00","subtotal":"618.47","grand_total":"716.72","paid_amount":"716.72","room_type_id":"319","product_id":"1943","siteminder_id":"ABB-HMTKQZXXKD","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"622.20","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113960","customer_id":"113960","source_of_creation":"Airbnb","reservation_created_date":"2021-02-13 05:49:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"18.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"307.37","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":"3226930","reservation_id":"110468","confirmation_number":"SJ12669764845","room_stay_from":"2021-04-03","room_stay_to":"2021-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"360.64,371.27","nightly_discount":"0.00,0.00","subtotal":"731.91","grand_total":"856.77","paid_amount":"856.77","room_type_id":"319","product_id":"1301","siteminder_id":"ABB-HMS5QKMQ54","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"742.54","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116982","customer_id":"116982","source_of_creation":"Airbnb","reservation_created_date":"2021-03-17 00:58:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"23.31","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"360.64","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"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3209733","reservation_id":"109521","confirmation_number":"SJ12644996637","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"339.15","nightly_discount":"0.00","subtotal":"339.15","grand_total":"381.55","paid_amount":"381.55","room_type_id":"413","product_id":"1267","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":"115993","customer_id":"115993","source_of_creation":"FE","reservation_created_date":"2021-03-05 20:09:17","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"339.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3227076","reservation_id":"111986","confirmation_number":"SJ12685425678","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"385.90","nightly_discount":"0.00","subtotal":"385.90","grand_total":"434.14","paid_amount":"434.14","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118552","customer_id":"118552","source_of_creation":"FE","reservation_created_date":"2021-04-03 16:27:00","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"385.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3184677","reservation_id":"106140","confirmation_number":"SJ12685003286","room_stay_from":"2021-04-01","room_stay_to":"2021-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"321.75,351.75,351.75,321.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1347.00","grand_total":"1515.38","paid_amount":"1515.38","room_type_id":"320","product_id":"1910","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112552","customer_id":"112552","source_of_creation":"FE","reservation_created_date":"2021-01-26 03:30:51","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1309,1310","currentDayPrice":"351.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":"3223567","reservation_id":"109141","confirmation_number":"SJ12688802323","room_stay_from":"2021-04-02","room_stay_to":"2021-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"299.25,299.25,261.75","nightly_discount":"14.96,14.96,13.09","subtotal":"860.25","grand_total":"919.39","paid_amount":"919.39","room_type_id":"412","product_id":"1866","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":"115615","customer_id":"115615","source_of_creation":"FE","reservation_created_date":"2021-03-03 17:19:18","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":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"299.25","currentDayDiscount":"14.96","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3224263","reservation_id":"105560","confirmation_number":"SJ12671824100","room_stay_from":"2021-04-03","room_stay_to":"2021-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"296.65,262.65","nightly_discount":"0.00,0.00","subtotal":"559.30","grand_total":"629.22","paid_amount":"629.22","room_type_id":"318","product_id":"1289","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":"111981","customer_id":"111981","source_of_creation":"FE","reservation_created_date":"2021-01-18 17:20:19","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":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"296.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3190655","reservation_id":"104722","confirmation_number":"SJ12627281713","room_stay_from":"2021-04-01","room_stay_to":"2021-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"3","nightly_price":"321.75,351.75,351.75,321.75,321.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1668.75","grand_total":"1877.35","paid_amount":"1877.35","room_type_id":"320","product_id":"1320","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":"111075","customer_id":"111075","source_of_creation":"FE","reservation_created_date":"2021-01-04 20:51:00","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1260,1261","currentDayPrice":"351.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":"3190619","reservation_id":"105736","confirmation_number":"SJ12698787249","room_stay_from":"2021-04-02","room_stay_to":"2021-04-09","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"351.75,351.75,321.75,321.75,284.25,284.25,284.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2199.75","grand_total":"2474.72","paid_amount":"2474.72","room_type_id":"320","product_id":"1329","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":"112130","customer_id":"112130","source_of_creation":"FE","reservation_created_date":"2021-01-20 19:49:58","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1304,1305","currentDayPrice":"351.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3188167","reservation_id":"106521","confirmation_number":"SJ12648128637","room_stay_from":"2021-04-02","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"351.75,351.75,321.75,321.75,284.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1631.25","grand_total":"1835.15","paid_amount":"1835.15","room_type_id":"320","product_id":"1330","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":"112931","customer_id":"112931","source_of_creation":"PMS","reservation_created_date":"2021-01-30 22:57:13","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":"0","group_rooms":"1307,1308","currentDayPrice":"351.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":"3188169","reservation_id":"106435","confirmation_number":"SJ12684423456","room_stay_from":"2021-04-02","room_stay_to":"2021-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.25,239.25,209.25,209.25,171.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1068.75","grand_total":"1202.35","paid_amount":"1202.35","room_type_id":"319","product_id":"1306","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":"112933","customer_id":"112933","source_of_creation":"PMS","reservation_created_date":"2021-01-29 19:15:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"239.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":"3186729","reservation_id":"105522","confirmation_number":"SJ12657642008","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.25,239.25,209.25,209.25,171.75,171.75,171.75,201.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1614.00","grand_total":"1815.75","paid_amount":"1815.75","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":"111934","customer_id":"111934","source_of_creation":"PMS","reservation_created_date":"2021-01-17 20:41:56","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":"239.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"}]}],"pms_non_taxable":[{"room_stay_id":"3203017","reservation_id":"103584","confirmation_number":"SJ12638392410","room_stay_from":"2021-04-03","room_stay_to":"2021-04-09","room_stay_status":"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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"318","product_id":"1282","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"118564","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2020-12-07 22:41:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"0.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"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3202995","reservation_id":"106304","confirmation_number":"SJ12689272167","room_stay_from":"2021-03-28","room_stay_to":"2021-04-04","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,0,0,0,0,0","subtotal":"798.00","grand_total":"798.00","paid_amount":"196.88","room_type_id":"319","product_id":"1942","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-28 00:04:05","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":"114.00","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3203100","reservation_id":"108323","confirmation_number":"SJ12692487295","room_stay_from":"2021-04-01","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.33,113.33,113.33","nightly_discount":"0.00,0.00,0.00","subtotal":"339.99","grand_total":"339.99","paid_amount":"84.38","room_type_id":"413","product_id":"1263","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-02-22 23:57:16","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.33","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3211134","reservation_id":"108315","confirmation_number":"SJ12685522264","room_stay_from":"2021-03-28","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.57,165.57,165.57,165.57,165.57,165.57,165.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1159.00","grand_total":"1159.00","paid_amount":"0.00","room_type_id":"413","product_id":"1265","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-22 22:35:04","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"165.58","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":"3211145","reservation_id":"105425","confirmation_number":"SJ12681303827","room_stay_from":"2021-03-28","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.57,165.57,165.57,165.57,165.57,165.57,165.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1159.00","grand_total":"1159.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:38:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"165.58","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":"3215237","reservation_id":"110233","confirmation_number":"SJ12680157431","room_stay_from":"2021-04-01","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.33,113.33,113.33","nightly_discount":"0.00,0,0","subtotal":"339.99","grand_total":"339.99","paid_amount":"84.38","room_type_id":"413","product_id":"1266","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-03-13 22:27:23","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":"0","group_rooms":null,"currentDayPrice":"113.33","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219723","reservation_id":"110845","confirmation_number":"SJ12638482605","room_stay_from":"2021-04-01","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.33,113.33,113.33","nightly_discount":"0.00,0.00,0.00","subtotal":"339.99","grand_total":"339.99","paid_amount":"84.38","room_type_id":"413","product_id":"1262","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-03-20 22:40:13","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":"0","group_rooms":null,"currentDayPrice":"113.33","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3211128","reservation_id":"106969","confirmation_number":"SJ12631038519","room_stay_from":"2021-04-02","room_stay_to":"2021-04-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.57,165.57,165.57,165.57,165.57,165.57,165.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1159.00","grand_total":"1159.00","paid_amount":"0.00","room_type_id":"319","product_id":"1756","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 18:04:31","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":"165.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3224538","reservation_id":"111595","confirmation_number":"SJ12647149308","room_confirmation_number":"SJ12698557020","room_stay_from":"2021-04-02","room_stay_to":"2021-04-04","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":"118155","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-03-29 16:37:08","reservation_modified_date_time":"2021-03-29 16:37:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118155","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":"3198473","reservation_id":"107652","confirmation_number":"SJ12630687033","room_confirmation_number":"SJ12615056158","room_stay_from":"2021-04-03","room_stay_to":"2021-04-06","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"114111","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-15 18:35:14","reservation_modified_date_time":"2021-02-15 18:35:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114111","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202937","reservation_id":"107652","confirmation_number":"SJ12682111443","room_confirmation_number":"SJ12694345132","room_stay_from":"2021-04-03","room_stay_to":"2021-04-06","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"114111","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-22 20:19:07","reservation_modified_date_time":"2021-02-22 20:19:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114111","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3202923","reservation_id":"107433","confirmation_number":"SJ12687381988","room_confirmation_number":"SJ12695963627","room_stay_from":"2021-03-31","room_stay_to":"2021-04-04","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"113888","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 15:46:18","reservation_modified_date_time":"2021-02-22 20:17:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113888","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3202996","reservation_id":"106304","confirmation_number":"SJ12676351691","room_confirmation_number":"SJ12689272167","room_stay_from":"2021-03-28","room_stay_to":"2021-04-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112699","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 00:04:05","reservation_modified_date_time":"2021-02-22 20:46:07","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":"3203020","reservation_id":"107089","confirmation_number":"SJ12637365868","room_confirmation_number":"SJ12655252916","room_stay_from":"2021-03-31","room_stay_to":"2021-04-04","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":"113540","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-07 16:55:07","reservation_modified_date_time":"2021-02-22 21:21:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113540","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":"3203101","reservation_id":"108323","confirmation_number":"SJ12633394783","room_confirmation_number":"SJ12692487295","room_stay_from":"2021-04-01","room_stay_to":"2021-04-04","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":"114778","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 23:57:16","reservation_modified_date_time":"2021-02-22 23:57:16","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3209734","reservation_id":"109521","confirmation_number":"SJ12666274005","room_confirmation_number":"SJ12644996637","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.12","paid_amount":"28.12","product_id":"1776","service_quantity":"1","customer_traveller_id":"115993","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-05 20:09:17","reservation_modified_date_time":"2021-03-05 20:09:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115993","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":"3211133","reservation_id":"108315","confirmation_number":"SJ12645855193","room_confirmation_number":"SJ12685522264","room_stay_from":"2021-03-28","room_stay_to":"2021-04-04","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":"114770","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 22:35:04","reservation_modified_date_time":"2021-03-07 15:18:15","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":"3211144","reservation_id":"105425","confirmation_number":"SJ12612282847","room_confirmation_number":"SJ12681303827","room_stay_from":"2021-03-28","room_stay_to":"2021-04-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111828","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 02:38:57","reservation_modified_date_time":"2021-03-07 15:18:15","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":"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":"3215228","reservation_id":"109630","confirmation_number":"SJ12653683674","room_confirmation_number":"SJ12659147003","room_stay_from":"2021-04-01","room_stay_to":"2021-04-04","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":"116105","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-06 23:47:30","reservation_modified_date_time":"2021-03-13 22:25:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116105","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":"3215238","reservation_id":"110233","confirmation_number":"SJ12631297509","room_confirmation_number":"SJ12680157431","room_stay_from":"2021-04-01","room_stay_to":"2021-04-04","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":"114778","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-13 22:27:23","reservation_modified_date_time":"2021-03-13 22:28:22","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219722","reservation_id":"109077","confirmation_number":"SJ12685679974","room_confirmation_number":"SJ12612831687","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","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":"115549","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 02:43:07","reservation_modified_date_time":"2021-03-20 22:46:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115549","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":"3219724","reservation_id":"110845","confirmation_number":"SJ12650960193","room_confirmation_number":"SJ12638482605","room_stay_from":"2021-04-01","room_stay_to":"2021-04-04","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":"114778","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-20 22:40:13","reservation_modified_date_time":"2021-03-20 22:46:25","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":"3221011","reservation_id":"111086","confirmation_number":"SJ12642584184","room_confirmation_number":"SJ12675613306","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","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":"117625","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-23 16:02:06","reservation_modified_date_time":"2021-03-23 16:02:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117625","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":"3221453","reservation_id":"111126","confirmation_number":"SJ12640786481","room_confirmation_number":"SJ12631402733","room_stay_from":"2021-04-02","room_stay_to":"2021-04-04","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"118505","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-23 21:17:09","reservation_modified_date_time":"2021-03-24 02:04:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117656","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":"3221833","reservation_id":"111195","confirmation_number":"SJ12684254151","room_confirmation_number":"SJ12682983215","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","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":"117726","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 18:22:08","reservation_modified_date_time":"2021-03-24 18:22:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117726","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":"3222555","reservation_id":"111312","confirmation_number":"SJ12634639023","room_confirmation_number":"SJ12666250431","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","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":"117847","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-26 02:30:12","reservation_modified_date_time":"2021-03-26 02:30:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117847","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":"3224539","reservation_id":"111595","confirmation_number":"SJ12663902682","room_confirmation_number":"SJ12698557020","room_stay_from":"2021-04-02","room_stay_to":"2021-04-04","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":"118155","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-29 16:37:08","reservation_modified_date_time":"2021-03-29 16:37:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118155","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":"3226585","reservation_id":"109079","confirmation_number":"SJ12677085111","room_confirmation_number":"SJ12696893124","room_stay_from":"2021-04-02","room_stay_to":"2021-04-04","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":"115550","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 02:43:11","reservation_modified_date_time":"2021-04-02 20:05:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115550","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":"3227077","reservation_id":"111986","confirmation_number":"SJ12651419302","room_confirmation_number":"SJ12685425678","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.12","paid_amount":"28.12","product_id":"1776","service_quantity":"1","customer_traveller_id":"118552","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 16:27:00","reservation_modified_date_time":"2021-04-03 16:27:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118552","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":"3227290","reservation_id":"111706","confirmation_number":"SJ12676713776","room_confirmation_number":"SJ12681762110","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","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":"118266","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-30 19:57:08","reservation_modified_date_time":"2021-04-03 20:03:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118266","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":"3227392","reservation_id":"111149","confirmation_number":"SJ12669763226","room_confirmation_number":"SJ12673101537","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","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":"117681","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 01:59:10","reservation_modified_date_time":"2021-04-03 21:05:20","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117681","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":"3184678","reservation_id":"106140","confirmation_number":"SJ12620429961","room_confirmation_number":"SJ12685003286","room_stay_from":"2021-04-01","room_stay_to":"2021-04-05","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":"112552","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 03:30:51","reservation_modified_date_time":"2021-01-26 03:30:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112552","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":"3187286","reservation_id":"104670","confirmation_number":"SJ12676888242","room_confirmation_number":"SJ12665294892","room_stay_from":"2021-03-29","room_stay_to":"2021-04-05","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":"111023","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-03 22:36:10","reservation_modified_date_time":"2021-01-29 19:11:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111023","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":"3188445","reservation_id":"106540","confirmation_number":"SJ12636950915","room_confirmation_number":"SJ12651938501","room_stay_from":"2021-04-03","room_stay_to":"2021-04-05","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"112959","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 15:01:07","reservation_modified_date_time":"2021-01-31 15:01:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112959","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":"3190610","reservation_id":"104860","confirmation_number":"SJ12657703375","room_confirmation_number":"SJ12665286647","room_stay_from":"2021-03-29","room_stay_to":"2021-04-05","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":"111215","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-06 15:31:09","reservation_modified_date_time":"2021-02-02 22:12:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111215","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":"3212258","reservation_id":"105337","confirmation_number":"SJ12685446006","room_confirmation_number":"SJ12615829821","room_stay_from":"2021-04-02","room_stay_to":"2021-04-05","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":"111723","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 19:31:10","reservation_modified_date_time":"2021-03-09 00:18:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111723","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":"3223568","reservation_id":"109141","confirmation_number":"SJ12632433672","room_confirmation_number":"SJ12688802323","room_stay_from":"2021-04-02","room_stay_to":"2021-04-05","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":"115615","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 17:19:18","reservation_modified_date_time":"2021-03-27 20:20:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115615","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":"3224264","reservation_id":"105560","confirmation_number":"SJ12681225776","room_confirmation_number":"SJ12671824100","room_stay_from":"2021-04-03","room_stay_to":"2021-04-05","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"111981","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-18 17:20:19","reservation_modified_date_time":"2021-03-28 20:46:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111981","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":"3226927","reservation_id":"107501","confirmation_number":"SJ12672694897","room_confirmation_number":"SJ12656885295","room_stay_from":"2021-04-03","room_stay_to":"2021-04-05","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":"113960","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-13 05:49:10","reservation_modified_date_time":"2021-04-03 12:11:17","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113960","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":"3226931","reservation_id":"110468","confirmation_number":"SJ12669812208","room_confirmation_number":"SJ12669764845","room_stay_from":"2021-04-03","room_stay_to":"2021-04-05","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"116982","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 00:58:10","reservation_modified_date_time":"2021-04-03 12:12:41","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116982","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","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":"3187211","reservation_id":"106124","confirmation_number":"SJ12664475305","room_confirmation_number":"SJ12671153111","room_stay_from":"2021-03-30","room_stay_to":"2021-04-06","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":"112541","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-26 01:34:07","reservation_modified_date_time":"2021-01-29 19:02:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112541","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":"3190658","reservation_id":"104722","confirmation_number":"SJ12625779531","room_confirmation_number":"SJ12627281713","room_stay_from":"2021-04-01","room_stay_to":"2021-04-06","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":"111075","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-04 20:51:00","reservation_modified_date_time":"2021-02-02 22:20:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111075","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":"3198474","reservation_id":"107652","confirmation_number":"SJ12650229017","room_confirmation_number":"SJ12615056158","room_stay_from":"2021-04-03","room_stay_to":"2021-04-06","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":"114111","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-15 02:55:29","reservation_modified_date_time":"2021-02-15 18:35:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114111","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202938","reservation_id":"107652","confirmation_number":"SJ12642914244","room_confirmation_number":"SJ12694345132","room_stay_from":"2021-04-03","room_stay_to":"2021-04-06","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":"114111","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-15 02:55:24","reservation_modified_date_time":"2021-02-22 20:19:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114111","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"3188166","reservation_id":"106521","confirmation_number":"SJ12687145113","room_confirmation_number":"SJ12648128637","room_stay_from":"2021-04-02","room_stay_to":"2021-04-07","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":"112931","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-30 22:57:13","reservation_modified_date_time":"2021-01-30 22:58:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112931","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":"3188168","reservation_id":"106435","confirmation_number":"SJ12623898262","room_confirmation_number":"SJ12684423456","room_stay_from":"2021-04-02","room_stay_to":"2021-04-07","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":"112933","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 19:15:32","reservation_modified_date_time":"2021-01-30 23:00:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112933","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":"3200815","reservation_id":"107957","confirmation_number":"SJ12682986397","room_confirmation_number":"SJ12632080324","room_stay_from":"2021-04-03","room_stay_to":"2021-04-07","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":"114423","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-18 12:52:24","reservation_modified_date_time":"2021-02-19 02:33:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114423","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":"3223594","reservation_id":"107327","confirmation_number":"SJ12697442895","room_confirmation_number":"SJ12677941040","room_stay_from":"2021-03-29","room_stay_to":"2021-04-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"113785","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-11 02:54:11","reservation_modified_date_time":"2021-03-27 20:24:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113785","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":"3192082","reservation_id":"106937","confirmation_number":"SJ12668722382","room_confirmation_number":"SJ12660023131","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","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":"113372","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 01:26:08","reservation_modified_date_time":"2021-02-05 01:26:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113372","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":"3214600","reservation_id":"110154","confirmation_number":"SJ12673289553","room_confirmation_number":"SJ12696259719","room_stay_from":"2021-04-03","room_stay_to":"2021-04-08","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":"116661","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-12 19:17:08","reservation_modified_date_time":"2021-03-12 19:17:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116661","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":"3189238","reservation_id":"104357","confirmation_number":"SJ12660626167","room_confirmation_number":"SJ12667088765","room_stay_from":"2021-04-03","room_stay_to":"2021-04-09","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":"110707","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-29 01:46:10","reservation_modified_date_time":"2021-02-01 17:48:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110707","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":"3190622","reservation_id":"105736","confirmation_number":"SJ12625542052","room_confirmation_number":"SJ12698787249","room_stay_from":"2021-04-02","room_stay_to":"2021-04-09","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":"112130","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-20 19:49:58","reservation_modified_date_time":"2021-02-02 22:15:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112130","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":"3203018","reservation_id":"103584","confirmation_number":"SJ12681911103","room_confirmation_number":"SJ12638392410","room_stay_from":"2021-04-03","room_stay_to":"2021-04-09","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103072","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-07 22:41:38","reservation_modified_date_time":"2021-02-22 21:21:13","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3211127","reservation_id":"106969","confirmation_number":"SJ12678619010","room_confirmation_number":"SJ12631038519","room_stay_from":"2021-04-02","room_stay_to":"2021-04-09","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":"113402","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 18:04:31","reservation_modified_date_time":"2021-03-07 15:18:15","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":"3186730","reservation_id":"105522","confirmation_number":"SJ12613505401","room_confirmation_number":"SJ12657642008","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","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":"111934","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-17 20:41:56","reservation_modified_date_time":"2021-01-29 02:55:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111934","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":"3188745","reservation_id":"105296","confirmation_number":"SJ12614024808","room_confirmation_number":"SJ12640166141","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","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":"111683","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-13 23:56:08","reservation_modified_date_time":"2021-01-31 20:39:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111683","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":"3191789","reservation_id":"106746","confirmation_number":"SJ12623293913","room_confirmation_number":"SJ12655644327","room_stay_from":"2021-04-02","room_stay_to":"2021-04-10","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":"113167","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-02 18:16:10","reservation_modified_date_time":"2021-02-04 20:25:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113167","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":"3192156","reservation_id":"106954","confirmation_number":"SJ12687922139","room_confirmation_number":"SJ12654770899","room_stay_from":"2021-04-03","room_stay_to":"2021-04-10","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":"113388","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-05 07:00:10","reservation_modified_date_time":"2021-02-05 07:00:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113388","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":"3227120","reservation_id":"111850","confirmation_number":"SJ12613137630","room_confirmation_number":"SJ12649168968","room_stay_from":"2021-06-20","room_stay_to":"2021-06-23","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":"118411","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-01 22:09:14","reservation_modified_date_time":"2021-04-03 17:28:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118411","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3227209","reservation_id":"111991","confirmation_number":"SJ12655606885","room_confirmation_number":"SJ12661736792","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"7.50","paid_amount":"7.50","product_id":"1660","service_quantity":"3","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-03 18:25:06","reservation_modified_date_time":"2021-04-03 18:25:06","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"6.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3227429","reservation_id":"112014","confirmation_number":"SJ12612184846","room_confirmation_number":"SJ12638180504","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":"15.00","paid_amount":"15.00","product_id":"1654","service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-03 21:39:24","reservation_modified_date_time":"2021-04-03 21:39:24","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":"13.95","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":[]}}