{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-04-02","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":20,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1275","block_room_bookings":[{"confirmation_number":"SJ12618960500","room_stay_from":"2021-03-30","room_stay_to":"2021-04-08","bundle_room":"0","product_id":"1275"}],"bundle_block_count":"1311,1312,1262,1263,1269,1270,1267,1268,1271,1272,1309,1310,1291,1711,1260,1261,1307,1308,1304,1305,1302,1303","bundle_block_bookings":[{"confirmation_number":"SJB12636918252","room_stay_from":"2021-03-27","room_stay_to":"2021-04-03","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12663057934","room_stay_from":"2021-03-27","room_stay_to":"2021-04-03","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12648076420","room_stay_from":"2021-04-01","room_stay_to":"2021-04-03","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12643833963","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12681222961","room_stay_from":"2021-03-27","room_stay_to":"2021-04-03","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12670579988","room_stay_from":"2021-03-27","room_stay_to":"2021-04-03","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12621984352","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","bundle_room":"1","product_id":"1324"},{"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":"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":"3186726","reservation_id":"106365","confirmation_number":"SJ12621922274","room_stay_from":"2021-03-27","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"164.89,142.21,142.21,142.21,142.21,153.55,176.23","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1063.51","grand_total":"1196.45","paid_amount":"1196.45","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-2764338251","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"350.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112761","customer_id":"112761","source_of_creation":"Booking.com","reservation_created_date":"2021-01-28 23:53:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"571.86","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"176.23","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":"3186731","reservation_id":"106365","confirmation_number":"SJ12678291478","room_stay_from":"2021-03-27","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"214.89,192.21,192.21,192.21,192.21,203.55,226.23","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1413.51","grand_total":"1590.20","paid_amount":"1590.20","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-2764338251","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":"112761","customer_id":"112761","source_of_creation":"Booking.com","reservation_created_date":"2021-01-28 23:53:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"571.86","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"226.23","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":"3189216","reservation_id":"106584","confirmation_number":"SJ12633075745","room_stay_from":"2021-03-30","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,195.30,223.30","nightly_discount":"0,0,0,0","subtotal":"781.20","grand_total":"878.85","paid_amount":"878.85","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-3577236264","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":"113006","customer_id":"113006","source_of_creation":"Booking.com","reservation_created_date":"2021-01-31 23:30:24","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"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":"3190753","reservation_id":"106770","confirmation_number":"SJ12661033224","room_stay_from":"2021-03-27","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"331.80,303.80,303.80,303.80,303.80,317.80,345.80","nightly_discount":"0,0,0,0,0,0,0","subtotal":"2210.60","grand_total":"2486.93","paid_amount":"2486.93","room_type_id":"320","product_id":"1332","siteminder_id":"BDC-3390126906","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":"113192","customer_id":"113192","source_of_creation":"Booking.com","reservation_created_date":"2021-02-02 21:56:49","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"752.99","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","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":"3190840","reservation_id":"106770","confirmation_number":"SJ12628385254","room_stay_from":"2021-03-27","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"247.80,219.80,219.80,219.80,219.80,233.80,261.80","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1622.60","grand_total":"1825.43","paid_amount":"1825.43","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-3390126906","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":"113192","customer_id":"113192","source_of_creation":"Booking.com","reservation_created_date":"2021-02-02 21:56:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"752.99","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":"3192216","reservation_id":"105438","confirmation_number":"SJ12665741767","room_stay_from":"2021-03-31","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.25,209.25,239.25","nightly_discount":"0,0,0","subtotal":"642.75","grand_total":"723.10","paid_amount":"723.10","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2822287358","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":"111845","customer_id":"111845","source_of_creation":"Booking.com","reservation_created_date":"2021-01-16 08:11:20","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"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":"3203014","reservation_id":"106908","confirmation_number":"SJ12675506537","room_stay_from":"2021-03-31","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"195.7,209.2,236.2","nightly_discount":"0,0,0","subtotal":"641.10","grand_total":"721.24","paid_amount":"721.24","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-3137689134","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":"113338","customer_id":"113338","source_of_creation":"Booking.com","reservation_created_date":"2021-02-04 19:06:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"155.90","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"236.2","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3211421","reservation_id":"105327","confirmation_number":"SJ12621334111","room_stay_from":"2021-03-31","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.82,188.32,215.32","nightly_discount":"0,0,0","subtotal":"578.46","grand_total":"650.76","paid_amount":"650.76","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-3858191208","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":"111715","customer_id":"111715","source_of_creation":"Booking.com","reservation_created_date":"2021-01-14 18:04:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"117.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"215.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":"3212555","reservation_id":"109859","confirmation_number":"SJ12619168911","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"312.58","nightly_discount":"0","subtotal":"312.58","grand_total":"351.65","paid_amount":"351.65","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3017696272","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":"116350","customer_id":"116350","source_of_creation":"Booking.com","reservation_created_date":"2021-03-09 16:38:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"60.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"312.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3224261","reservation_id":"111392","confirmation_number":"SJ12650992951","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"364.65","nightly_discount":"0","subtotal":"364.65","grand_total":"410.23","paid_amount":"410.23","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-2974414679","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":"117940","customer_id":"117940","source_of_creation":"Booking.com","reservation_created_date":"2021-03-27 00:10:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"70.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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":"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":"330.55","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":"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":"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":"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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3211419","reservation_id":"106533","confirmation_number":"SJ12635158319","room_stay_from":"2021-03-30","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,195.30,223.30","nightly_discount":"0,0,0,0","subtotal":"781.20","grand_total":"878.85","paid_amount":"878.85","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1734086885","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":"112950","customer_id":"112950","source_of_creation":"Expedia","reservation_created_date":"2021-01-31 03:46:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"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":"3221775","reservation_id":"109814","confirmation_number":"SJ12635971467","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"308.72","nightly_discount":"0","subtotal":"308.72","grand_total":"347.31","paid_amount":"347.31","room_type_id":"319","product_id":"1301","siteminder_id":"EXP-1745403373","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116298","customer_id":"116298","source_of_creation":"Expedia","reservation_created_date":"2021-03-08 23:27:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","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":"308.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":"3221851","reservation_id":"111199","confirmation_number":"SJ12654409947","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"305.32","nightly_discount":"0","subtotal":"305.32","grand_total":"343.49","paid_amount":"343.49","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1751608620","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":"117730","customer_id":"117730","source_of_creation":"Expedia","reservation_created_date":"2021-03-24 19:12: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":"305.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":"3223665","reservation_id":"111472","confirmation_number":"SJ12626558259","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","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":"1272","siteminder_id":"EXP-1752868643","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":"118030","customer_id":"118030","source_of_creation":"Expedia","reservation_created_date":"2021-03-27 22:47:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","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":"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":"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","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":"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":"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":"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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3221773","reservation_id":"106642","confirmation_number":"SJ12631752535","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"208.79","nightly_discount":"0","subtotal":"208.79","grand_total":"234.89","paid_amount":"234.89","room_type_id":"413","product_id":"1271","siteminder_id":"GAM-R2306551892","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":"113061","customer_id":"113061","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-01 20:17:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"208.79","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3223138","reservation_id":"106541","confirmation_number":"SJ12640342137","room_stay_from":"2021-03-27","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"391.10,391.10,391.10,391.10,391.10,391.10,374.67","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2721.27","grand_total":"3153.57","paid_amount":"3153.57","room_type_id":"320","product_id":"1322","siteminder_id":"ABB-HMFF9A432Q","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"2737.70","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112960","customer_id":"112960","source_of_creation":"Airbnb","reservation_created_date":"2021-01-31 15:01:16","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"80.50","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1267,1268","currentDayPrice":"374.67","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":"3226586","reservation_id":"111832","confirmation_number":"SJ12657429245","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"392.05","nightly_discount":"0.00","subtotal":"392.05","grand_total":"461.98","paid_amount":"461.98","room_type_id":"412","product_id":"1297","siteminder_id":"ABB-HMKMYNAY2N","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"394.72","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118394","customer_id":"118394","source_of_creation":"Airbnb","reservation_created_date":"2021-04-01 18:49:05","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"13.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"392.05","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"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":"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":"3224583","reservation_id":"111599","confirmation_number":"SJ12650917081","room_stay_from":"2021-04-01","room_stay_to":"2021-04-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"296.65,339.15","nightly_discount":"0.00,0.00","subtotal":"635.80","grand_total":"715.28","paid_amount":"715.28","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118158","customer_id":"118158","source_of_creation":"PMS","reservation_created_date":"2021-03-29 17:20:37","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3188167","reservation_id":"106521","confirmation_number":"SJ12648128637","room_stay_from":"2021-04-02","room_stay_to":"2021-04-07","room_stay_status":"Active","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":"395.72","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":"Active","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":"269.16","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":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3190470","reservation_id":"102020","confirmation_number":"SJ12650770441","room_stay_from":"2021-03-31","room_stay_to":"2021-04-03","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":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-10-28 01:28:29","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":"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":"3194841","reservation_id":"106292","confirmation_number":"SJ12636554170","room_stay_from":"2021-03-29","room_stay_to":"2021-04-03","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"570.00","grand_total":"570.00","paid_amount":"140.63","room_type_id":"319","product_id":"1943","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-01-27 23:26:02","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219725","reservation_id":"103554","confirmation_number":"SJ12658458915","room_stay_from":"2021-03-31","room_stay_to":"2021-04-03","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":"1270","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-12-06 23:33:58","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":"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":"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.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"3186727","reservation_id":"106365","confirmation_number":"SJ12636719187","room_confirmation_number":"SJ12621922274","room_stay_from":"2021-03-27","room_stay_to":"2021-04-03","room_stay_status":"Active","nightly_price":"50,50,50,50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"350.00","grand_total":"393.75","paid_amount":"393.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"112761","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-01-29 02:55:15","reservation_modified_date_time":"2021-01-29 02:55:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112761","canceled_nights_data":"","posAmt_airbnb_taxpaid":"350.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":"3203015","reservation_id":"106908","confirmation_number":"SJ12681198338","room_confirmation_number":"SJ12675506537","room_stay_from":"2021-03-31","room_stay_to":"2021-04-03","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":"113338","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-02-22 21:21:03","reservation_modified_date_time":"2021-02-22 21:21:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113338","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":"3221776","reservation_id":"109814","confirmation_number":"SJ12679921188","room_confirmation_number":"SJ12635971467","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"116298","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-03-24 16:37:28","reservation_modified_date_time":"2021-03-24 16:37:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116298","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"3226587","reservation_id":"111832","confirmation_number":"SJ12621543404","room_confirmation_number":"SJ12657429245","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"50.30","paid_amount":"50.30","product_id":"1777","service_quantity":"1","customer_traveller_id":"118394","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-02 20:05:07","reservation_modified_date_time":"2021-04-02 20:05:07","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118394","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","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":"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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3186728","reservation_id":"106365","confirmation_number":"SJ12622151539","room_confirmation_number":"SJ12621922274","room_stay_from":"2021-03-27","room_stay_to":"2021-04-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"112761","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 23:53:09","reservation_modified_date_time":"2021-01-29 02:55:16","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112761","canceled_nights_data":"","posAmt_airbnb_taxpaid":"350.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":"3186732","reservation_id":"106365","confirmation_number":"SJ12670269981","room_confirmation_number":"SJ12678291478","room_stay_from":"2021-03-27","room_stay_to":"2021-04-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"112761","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 23:53:14","reservation_modified_date_time":"2021-01-29 02:56:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112761","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":"3189217","reservation_id":"106584","confirmation_number":"SJ12655271655","room_confirmation_number":"SJ12633075745","room_stay_from":"2021-03-30","room_stay_to":"2021-04-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"113006","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 23:30:24","reservation_modified_date_time":"2021-02-01 17:12:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113006","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":"3190471","reservation_id":"102020","confirmation_number":"SJ12629107381","room_confirmation_number":"SJ12650770441","room_stay_from":"2021-03-31","room_stay_to":"2021-04-03","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":"108138","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-28 01:28:29","reservation_modified_date_time":"2021-02-02 19:01: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":"3190756","reservation_id":"106770","confirmation_number":"SJ12634149862","room_confirmation_number":"SJ12661033224","room_stay_from":"2021-03-27","room_stay_to":"2021-04-03","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"113192","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-02 21:56:49","reservation_modified_date_time":"2021-02-02 22:50:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113192","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":"3190841","reservation_id":"106770","confirmation_number":"SJ12679178103","room_confirmation_number":"SJ12628385254","room_stay_from":"2021-03-27","room_stay_to":"2021-04-03","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"113192","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-02 21:56:37","reservation_modified_date_time":"2021-02-02 23:48:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113192","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":"3192217","reservation_id":"105438","confirmation_number":"SJ12648925937","room_confirmation_number":"SJ12665741767","room_stay_from":"2021-03-31","room_stay_to":"2021-04-03","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":"111845","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-16 08:11:20","reservation_modified_date_time":"2021-02-05 14:09:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111845","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":"3194842","reservation_id":"106292","confirmation_number":"SJ12641391562","room_confirmation_number":"SJ12636554170","room_stay_from":"2021-03-29","room_stay_to":"2021-04-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112693","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-27 23:26:02","reservation_modified_date_time":"2021-02-09 18:05:18","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":"3203016","reservation_id":"106908","confirmation_number":"SJ12628547375","room_confirmation_number":"SJ12675506537","room_stay_from":"2021-03-31","room_stay_to":"2021-04-03","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":"113338","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-04 19:06:11","reservation_modified_date_time":"2021-02-22 21:21:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113338","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":"3211420","reservation_id":"106533","confirmation_number":"SJ12616320507","room_confirmation_number":"SJ12635158319","room_stay_from":"2021-03-30","room_stay_to":"2021-04-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"112950","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 03:46:17","reservation_modified_date_time":"2021-03-07 20:05:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112950","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":"3211422","reservation_id":"105327","confirmation_number":"SJ12664842407","room_confirmation_number":"SJ12621334111","room_stay_from":"2021-03-31","room_stay_to":"2021-04-03","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":"111715","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 18:04:12","reservation_modified_date_time":"2021-03-07 20:05:44","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111715","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":"3212556","reservation_id":"109859","confirmation_number":"SJ12627393634","room_confirmation_number":"SJ12619168911","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","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":"116350","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-09 16:38:09","reservation_modified_date_time":"2021-03-09 16:38:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116350","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":"3219726","reservation_id":"103554","confirmation_number":"SJ12678105460","room_confirmation_number":"SJ12658458915","room_stay_from":"2021-03-31","room_stay_to":"2021-04-03","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":"109790","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-06 23:33:58","reservation_modified_date_time":"2021-03-20 22:46:49","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":"3221774","reservation_id":"106642","confirmation_number":"SJ12684833255","room_confirmation_number":"SJ12631752535","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","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":"113061","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 20:17:06","reservation_modified_date_time":"2021-03-24 16:37:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113061","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":"3221777","reservation_id":"109814","confirmation_number":"SJ12692436006","room_confirmation_number":"SJ12635971467","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","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":"116298","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-08 23:27:08","reservation_modified_date_time":"2021-03-24 16:37:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116298","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"3221852","reservation_id":"111199","confirmation_number":"SJ12674246659","room_confirmation_number":"SJ12654409947","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","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":"117730","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 19:12:08","reservation_modified_date_time":"2021-03-24 19:12:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117730","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":"3223141","reservation_id":"106541","confirmation_number":"SJ12697311881","room_confirmation_number":"SJ12640342137","room_stay_from":"2021-03-27","room_stay_to":"2021-04-03","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":"112960","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-31 15:01:16","reservation_modified_date_time":"2021-03-27 12:03:47","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112960","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":"3223666","reservation_id":"111472","confirmation_number":"SJ12695869867","room_confirmation_number":"SJ12626558259","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","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":"118030","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-27 22:47:09","reservation_modified_date_time":"2021-03-27 22:47:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118030","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":"3224262","reservation_id":"111392","confirmation_number":"SJ12624271583","room_confirmation_number":"SJ12650992951","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","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":"117940","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-27 00:10:12","reservation_modified_date_time":"2021-03-28 20:46:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117940","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":"3224584","reservation_id":"111599","confirmation_number":"SJ12622904804","room_confirmation_number":"SJ12650917081","room_stay_from":"2021-04-01","room_stay_to":"2021-04-03","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":"118158","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-29 17:20:37","reservation_modified_date_time":"2021-03-29 17:20:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118158","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":"3226588","reservation_id":"111832","confirmation_number":"SJ12647287422","room_confirmation_number":"SJ12657429245","room_stay_from":"2021-04-02","room_stay_to":"2021-04-03","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"118394","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-01 18:49:05","reservation_modified_date_time":"2021-04-02 20:05:07","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118394","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"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":"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":"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":"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":"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":"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":"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":"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":"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":"0.00","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":"0.00","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":"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":"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":"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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3226415","reservation_id":"105438","confirmation_number":"SJ12660326940","room_confirmation_number":"SJ12665741767","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"20.00","paid_amount":"20.00","product_id":"1662","service_quantity":"2","product_name":"Extra Chair or Umbrella","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-02 14:19:48","reservation_modified_date_time":"2021-04-02 14:19:48","customer_id":"111845","parentCustTravId":"111845","customer_traveller_id":"111845","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-03-31","sub_hotel_id":"126","currentDayPrice":"18.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3226551","reservation_id":"111912","confirmation_number":"SJ12690631838","room_confirmation_number":"SJ12648284792","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-02 18:05:13","reservation_modified_date_time":"2021-04-02 18:05:13","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":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3226596","reservation_id":"111920","confirmation_number":"SJ12624497522","room_confirmation_number":"SJ12674592699","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.86","grand_total":"2.00","paid_amount":"2.00","product_id":"1667","service_quantity":"1","product_name":"Koozie","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-02 20:09:16","reservation_modified_date_time":"2021-04-02 20:09:16","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":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3226609","reservation_id":"111926","confirmation_number":"SJ12654412098","room_confirmation_number":"SJ12639867691","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":"45.00","paid_amount":"45.00","product_id":"1654","service_quantity":"3","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-02 20:47:59","reservation_modified_date_time":"2021-04-02 20:47:59","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":"41.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3226755","reservation_id":"111945","confirmation_number":"SJ12625602682","room_confirmation_number":"SJ12647882585","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"20.00","paid_amount":"20.00","product_id":"1231","service_quantity":"1","product_name":"Boat ramp","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-03 00:58:46","reservation_modified_date_time":"2021-04-03 00:58:46","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}