{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-06-27","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":31,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1262,1915,1916,1301,1319","block_room_bookings":[{"confirmation_number":"SJ12670929127","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJ12620783443","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","bundle_room":"0","product_id":"1915"},{"confirmation_number":"SJ12618350461","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","bundle_room":"0","product_id":"1916"},{"confirmation_number":"SJ12621145273","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","bundle_room":"0","product_id":"1301"},{"confirmation_number":"SJ12690210371","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","bundle_room":"0","product_id":"1319"}],"bundle_block_count":"1309,1310,1271,1272,1269,1270,1291,1711,1262,1263,1267,1268,1304,1305,1307,1308,1260,1261,1302,1303,1311,1312","bundle_block_bookings":[{"confirmation_number":"SJB12667184967","room_stay_from":"2021-06-26","room_stay_to":"2021-06-28","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12644961812","room_stay_from":"2021-06-26","room_stay_to":"2021-06-28","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12627967593","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12698250393","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12629872162","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12621608535","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12616252389","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12667931013","room_stay_from":"2021-06-25","room_stay_to":"2021-06-29","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12629834820","room_stay_from":"2021-06-25","room_stay_to":"2021-06-29","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12681233715","room_stay_from":"2021-06-25","room_stay_to":"2021-06-29","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12697939145","room_stay_from":"2021-06-25","room_stay_to":"2021-06-29","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12622535293","room_stay_from":"2021-06-27","room_stay_to":"2021-06-30","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12689710844","room_stay_from":"2021-06-27","room_stay_to":"2021-06-30","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12686200546","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12622314205","room_stay_from":"2021-06-26","room_stay_to":"2021-07-01","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12651248539","room_stay_from":"2021-06-26","room_stay_to":"2021-07-01","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12643658267","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12694456161","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","bundle_room":"0","product_id":"1312"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3217509","reservation_id":"110509","confirmation_number":"SJ12631801725","room_stay_from":"2021-06-24","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"261.80,289.80,310.80,261.80","nightly_discount":"0,0,0,0","subtotal":"1124.20","grand_total":"1264.73","paid_amount":"1264.73","room_type_id":"320","product_id":"1910","siteminder_id":"BDC-2680617338","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":"117020","customer_id":"117020","source_of_creation":"Booking.com","reservation_created_date":"2021-03-17 14:27:15","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":"126","group_rooms":"1309,1310","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":"3271818","reservation_id":"114284","confirmation_number":"SJ12670254613","room_stay_from":"2021-06-25","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"218.09,242.39,157.34","nightly_discount":"0,0,0","subtotal":"617.82","grand_total":"695.05","paid_amount":"695.05","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-3940731912","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":"120941","customer_id":"120941","source_of_creation":"Booking.com","reservation_created_date":"2021-05-01 17:30:11","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":"157.34","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":"3274182","reservation_id":"118164","confirmation_number":"SJ12662807763","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"266.99","nightly_discount":"0","subtotal":"266.99","grand_total":"300.36","paid_amount":"300.36","room_type_id":"413","product_id":"1271","siteminder_id":"BDC-3171957948","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":"125169","customer_id":"125169","source_of_creation":"Booking.com","reservation_created_date":"2021-06-27 00:42:14","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"52.56","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"266.99","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":"3274314","reservation_id":"114996","confirmation_number":"SJ12637354999","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.65","nightly_discount":"0","subtotal":"194.65","grand_total":"218.98","paid_amount":"218.98","room_type_id":"413","product_id":"1269","siteminder_id":"BDC-3261344310","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":"121709","customer_id":"121709","source_of_creation":"Booking.com","reservation_created_date":"2021-05-11 16:24:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"39.54","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"194.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":"3229520","reservation_id":"105350","confirmation_number":"SJ12693715017","room_stay_from":"2021-06-25","room_stay_to":"2021-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"2","nightly_price":"282.3,240.3,240.3,240.3","nightly_discount":"0,0,0,0","subtotal":"1003.20","grand_total":"1128.60","paid_amount":"1128.60","room_type_id":"320","product_id":"1322","siteminder_id":"BDC-2822236998","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111735","customer_id":"111735","source_of_creation":"Booking.com","reservation_created_date":"2021-01-14 23:47:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"216.58","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1267,1268","currentDayPrice":"240.3","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":"3265065","reservation_id":"116590","confirmation_number":"SJ12652657187","room_stay_from":"2021-06-25","room_stay_to":"2021-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"304.92,304.92,223.02,223.02","nightly_discount":"0,0,0,0","subtotal":"1055.88","grand_total":"1187.86","paid_amount":"1187.86","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-2233721651","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":"123475","customer_id":"123475","source_of_creation":"Booking.com","reservation_created_date":"2021-06-05 15:49:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"208.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"223.02","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":"3260511","reservation_id":"116319","confirmation_number":"SJ12610918728","room_stay_from":"2021-06-27","room_stay_to":"2021-06-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.87,199.87,199.87","nightly_discount":"0,0,0","subtotal":"599.61","grand_total":"674.56","paid_amount":"674.56","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-3459621802","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":"123182","customer_id":"123182","source_of_creation":"Booking.com","reservation_created_date":"2021-06-01 15:43:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"121.44","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"199.87","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":"3265738","reservation_id":"116277","confirmation_number":"SJ12695480535","room_stay_from":"2021-06-27","room_stay_to":"2021-06-30","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"169.49,169.49,169.49","nightly_discount":"0.00,0.00,0.00","subtotal":"508.47","grand_total":"572.03","paid_amount":"572.03","room_type_id":"320","product_id":"1330","siteminder_id":"BDC-2760796969","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":"123136","customer_id":"123136","source_of_creation":"Booking.com","reservation_created_date":"2021-05-31 21:20:22","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"169.49","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":"3273648","reservation_id":"113302","confirmation_number":"SJ12625034441","room_stay_from":"2021-06-26","room_stay_to":"2021-06-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,194.25,194.25,194.25","nightly_discount":"0,0,0,0","subtotal":"882.00","grand_total":"992.25","paid_amount":"992.25","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-3464337418","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":"119886","customer_id":"119886","source_of_creation":"Booking.com","reservation_created_date":"2021-04-18 16:56:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"137.29","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"194.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":"3240302","reservation_id":"113701","confirmation_number":"SJ12685454450","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,181.30,181.30,181.30","nightly_discount":"0,0,0,0","subtotal":"725.20","grand_total":"815.85","paid_amount":"815.85","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-3562632381","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":"120311","customer_id":"120311","source_of_creation":"Booking.com","reservation_created_date":"2021-04-23 15:19:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"148.54","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"181.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":"3271506","reservation_id":"116723","confirmation_number":"SJ12649754495","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"265.30,265.30,265.30,286.30","nightly_discount":"0,0,0,0","subtotal":"1082.20","grand_total":"1217.48","paid_amount":"1217.48","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-2675041216","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":"123625","customer_id":"123625","source_of_creation":"Booking.com","reservation_created_date":"2021-06-07 14:58:31","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"265.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3273608","reservation_id":"112595","confirmation_number":"SJ12696601929","room_stay_from":"2021-06-25","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"275.80,275.80,198.80,198.80,198.80,198.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1346.80","grand_total":"1515.15","paid_amount":"1515.15","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-2398124566","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":"119175","customer_id":"119175","source_of_creation":"Booking.com","reservation_created_date":"2021-04-10 14:51:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"269.42","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"198.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":"3273668","reservation_id":"110793","confirmation_number":"SJ12616732724","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"195.30,195.30,195.30,195.30","nightly_discount":"0,0,0,0","subtotal":"781.20","grand_total":"878.85","paid_amount":"878.85","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-2881299124","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":"117303","customer_id":"117303","source_of_creation":"Booking.com","reservation_created_date":"2021-03-20 13:17:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"158.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"195.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3231742","reservation_id":"112574","confirmation_number":"SJ12675456502","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.27,144.27,144.27,144.27,144.27","nightly_discount":"0,0,0,0,0","subtotal":"721.35","grand_total":"811.52","paid_amount":"811.52","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2161126573","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":"119153","customer_id":"119153","source_of_creation":"Booking.com","reservation_created_date":"2021-04-10 02:14:24","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"144.27","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":"3240562","reservation_id":"113719","confirmation_number":"SJ12617869053","room_stay_from":"2021-06-26","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,181.30,181.30,181.30,181.30,195.30","nightly_discount":"0,0,0,0,0,0","subtotal":"1150.80","grand_total":"1294.65","paid_amount":"1294.65","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-3790806539","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":"120330","customer_id":"120330","source_of_creation":"Booking.com","reservation_created_date":"2021-04-23 18:43:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"181.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":"3249760","reservation_id":"114970","confirmation_number":"SJ12664749078","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.92,178.92,178.92,178.92,191.52","nightly_discount":"0,0,0,0,0","subtotal":"907.20","grand_total":"1020.60","paid_amount":"1020.60","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-2337402390","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":"121691","customer_id":"121691","source_of_creation":"Booking.com","reservation_created_date":"2021-05-11 01:14:09","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"185.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"178.92","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3246646","reservation_id":"114498","confirmation_number":"SJ12692683584","room_stay_from":"2021-06-26","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"359.20,247.20","nightly_discount":"0,0","subtotal":"606.40","grand_total":"682.20","paid_amount":"682.20","room_type_id":"319","product_id":"1756","siteminder_id":"EXP-1766981597","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":"121193","customer_id":"121193","source_of_creation":"Expedia","reservation_created_date":"2021-05-04 15:30:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"247.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3274028","reservation_id":"115902","confirmation_number":"SJ12630498084","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.72","nightly_discount":"0","subtotal":"189.72","grand_total":"213.44","paid_amount":"213.44","room_type_id":"319","product_id":"1277","siteminder_id":"EXP-1776103177","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":"122691","customer_id":"122691","source_of_creation":"Expedia","reservation_created_date":"2021-05-26 08:50:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"189.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":"3246376","reservation_id":"114464","confirmation_number":"SJ12637641953","room_stay_from":"2021-06-26","room_stay_to":"2021-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"318.00,213.00,213.00","nightly_discount":"0,0,0","subtotal":"744.00","grand_total":"837.00","paid_amount":"837.00","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1766761295","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":"121158","customer_id":"121158","source_of_creation":"Expedia","reservation_created_date":"2021-05-04 00:05:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"213.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3260245","reservation_id":"110568","confirmation_number":"SJ12663392833","room_stay_from":"2021-06-25","room_stay_to":"2021-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"307.30,328.30,328.30,328.30","nightly_discount":"0,0,0,0","subtotal":"1292.20","grand_total":"1453.73","paid_amount":"1453.73","room_type_id":"320","product_id":"1329","siteminder_id":"EXP-1748813274","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":"117080","customer_id":"117080","source_of_creation":"Expedia","reservation_created_date":"2021-03-17 20:32:10","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":"126","group_rooms":"1304,1305","currentDayPrice":"328.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3272463","reservation_id":"115577","confirmation_number":"SJ12691069015","room_stay_from":"2021-06-27","room_stay_to":"2021-06-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"197.40,197.40,197.40","nightly_discount":"0,0,0","subtotal":"592.20","grand_total":"666.23","paid_amount":"666.23","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1773669052","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":"122327","customer_id":"122327","source_of_creation":"Expedia","reservation_created_date":"2021-05-20 21:01:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"197.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3226319","reservation_id":"110854","confirmation_number":"SJ12664628580","room_stay_from":"2021-06-26","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"1","nightly_price":"237.64,215.24,215.24,215.24,215.24","nightly_discount":"0,0,0,0,0","subtotal":"1098.60","grand_total":"1235.93","paid_amount":"1235.93","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1750162176","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":"117376","customer_id":"117376","source_of_creation":"Expedia","reservation_created_date":"2021-03-21 00:37:18","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":"215.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3246200","reservation_id":"114423","confirmation_number":"SJ12689062824","room_stay_from":"2021-06-27","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.80,198.80,198.80,198.80,212.80,296.80","nightly_discount":"0,0,0,0,0,0","subtotal":"1304.80","grand_total":"1467.90","paid_amount":"1467.90","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1766568511","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":"121098","customer_id":"121098","source_of_creation":"Expedia","reservation_created_date":"2021-05-03 15:45:17","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"198.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3274222","reservation_id":"118172","confirmation_number":"SJ12615213132","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.42","nightly_discount":"0","subtotal":"228.42","grand_total":"256.97","paid_amount":"256.97","room_type_id":"413","product_id":"1272","siteminder_id":"GAM-R2619591657","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":"125178","customer_id":"125178","source_of_creation":"Getaroom.com","reservation_created_date":"2021-06-27 11:19:10","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","currentDayPrice":"228.42","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":"3262994","reservation_id":"111476","confirmation_number":"SJ12677242204","room_stay_from":"2021-06-27","room_stay_to":"2021-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"139.60,139.60,139.60,139.60,150.38,177.33,177.33","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1063.44","grand_total":"1196.37","paid_amount":"1196.37","room_type_id":"318","product_id":"1281","siteminder_id":"GAM-R2411890958","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":"118036","customer_id":"118036","source_of_creation":"Getaroom.com","reservation_created_date":"2021-03-28 00:09:08","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"139.60","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3274328","reservation_id":"117734","confirmation_number":"SJ12658775000","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"1","nightly_price":"481.27","nightly_discount":"0.00","subtotal":"481.27","grand_total":"565.38","paid_amount":"565.38","room_type_id":"320","product_id":"1714","siteminder_id":"ABB-HMEDSXYST4","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"484.48","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124712","customer_id":"124712","source_of_creation":"Airbnb","reservation_created_date":"2021-06-21 01:03:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"15.72","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"481.27","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":"3274241","reservation_id":"114944","confirmation_number":"SJ12680919922","room_stay_from":"2021-06-27","room_stay_to":"2021-07-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"3","nightly_price":"301.87,313.14,313.14,313.14,313.14,313.14","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1867.57","grand_total":"2164.26","paid_amount":"2164.26","room_type_id":"319","product_id":"1942","siteminder_id":"ABB-HMEJRRDNKW","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1878.84","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"121666","customer_id":"121666","source_of_creation":"Airbnb","reservation_created_date":"2021-05-10 20:59:02","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"55.26","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"301.87","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":"3273530","reservation_id":"112233","confirmation_number":"SJ12678435632","room_stay_from":"2021-06-25","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"276.75,276.75,194.25","nightly_discount":"0.00,0.00,0.00","subtotal":"747.75","grand_total":"841.22","paid_amount":"841.22","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":"118801","customer_id":"118801","source_of_creation":"FE","reservation_created_date":"2021-04-06 11:44:28","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"194.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":"3271969","reservation_id":"113297","confirmation_number":"SJ12675864167","room_stay_from":"2021-06-26","room_stay_to":"2021-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"299.25,194.25,194.25","nightly_discount":"0.00,0.00,0.00","subtotal":"687.75","grand_total":"773.72","paid_amount":"773.72","room_type_id":"413","product_id":"1265","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":"119859","customer_id":"119859","source_of_creation":"FE","reservation_created_date":"2021-04-18 15:52:53","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":"194.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":"3274088","reservation_id":"112210","confirmation_number":"SJ12619287066","room_stay_from":"2021-06-23","room_stay_to":"2021-06-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"265.50,295.50,295.50,213.00,213.00,213.00,213.00","nightly_discount":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","subtotal":"1708.50","grand_total":"1764.57","paid_amount":"1764.57","room_type_id":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118776","customer_id":"118776","source_of_creation":"FE","reservation_created_date":"2021-04-05 23:52:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"213.00","currentDayDiscount":"20.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":"3178717","reservation_id":"105306","confirmation_number":"SJ12646031307","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"134.25,134.25,134.25,134.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"537.00","grand_total":"604.13","paid_amount":"604.13","room_type_id":"413","product_id":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111692","customer_id":"111692","source_of_creation":"FE","reservation_created_date":"2021-01-14 02:13:51","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"134.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":"3232912","reservation_id":"112735","confirmation_number":"SJ12662416516","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"284.25,284.25,284.25,284.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1137.00","grand_total":"1279.13","paid_amount":"1279.13","room_type_id":"320","product_id":"1332","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119327","customer_id":"119327","source_of_creation":"FE","reservation_created_date":"2021-04-11 23:59:28","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1311,1312","currentDayPrice":"284.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3271031","reservation_id":"112261","confirmation_number":"SJ12691116073","room_stay_from":"2021-06-24","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,276.75,276.75,194.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"994.50","grand_total":"1118.82","paid_amount":"1118.82","room_type_id":"412","product_id":"1294","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":"118836","customer_id":"118836","source_of_creation":"PMS","reservation_created_date":"2021-04-06 18:45:26","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":"0","group_rooms":null,"currentDayPrice":"194.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":"3273532","reservation_id":"113000","confirmation_number":"SJ12650858902","room_stay_from":"2021-06-25","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"276.75,276.75,171.75","nightly_discount":"0.00,0.00,0.00","subtotal":"725.25","grand_total":"815.90","paid_amount":"815.90","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":"119582","customer_id":"119582","source_of_creation":"PMS","reservation_created_date":"2021-04-14 21:56:15","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":"171.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":"3274508","reservation_id":"118212","confirmation_number":"SJ12654369305","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"296.65","nightly_discount":"14.83","subtotal":"296.65","grand_total":"317.05","paid_amount":"317.05","room_type_id":"413","product_id":"1263","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":"116211","customer_id":"116211","source_of_creation":"PMS","reservation_created_date":"2021-06-27 22:33:18","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":"AAA","sub_hotel_id":"0","currentDayPrice":"296.65","currentDayDiscount":"14.83","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3271834","reservation_id":"106412","confirmation_number":"SJ12619027728","room_stay_from":"2021-06-25","room_stay_to":"2021-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"179.25,179.25,179.25,179.25","nightly_discount":"0.00,0,0,0","subtotal":"717.00","grand_total":"806.63","paid_amount":"806.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":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"112808","customer_id":"112808","source_of_creation":"PMS","reservation_created_date":"2021-01-29 14:40:53","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":"179.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":"3274322","reservation_id":"117938","confirmation_number":"SJ12670384667","room_stay_from":"2021-06-27","room_stay_to":"2021-06-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.00,279.00","nightly_discount":"27.90,27.90","subtotal":"558.00","grand_total":"564.98","paid_amount":"564.98","room_type_id":"413","product_id":"1270","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":"124930","customer_id":"124930","source_of_creation":"PMS","reservation_created_date":"2021-06-24 01:21:13","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":"special123","sub_hotel_id":"0","currentDayPrice":"279.00","currentDayDiscount":"27.90","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3271609","reservation_id":"117455","confirmation_number":"SJ12697762004","room_stay_from":"2021-06-26","room_stay_to":"2021-06-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,194.25,194.25,194.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"882.00","grand_total":"992.25","paid_amount":"992.25","room_type_id":"319","product_id":"1314","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":"119891","customer_id":"119891","source_of_creation":"PMS","reservation_created_date":"2021-06-16 23:26:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"194.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":"3260066","reservation_id":"116264","confirmation_number":"SJ12687282636","room_stay_from":"2021-06-27","room_stay_to":"2021-07-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.30,300.30,300.30,300.30,314.30,349.30,349.30","nightly_discount":"15.02,15.02,15.02,15.02,15.72,17.47,17.47","subtotal":"2214.10","grand_total":"2366.28","paid_amount":"2366.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":"123123","customer_id":"123123","source_of_creation":"PMS","reservation_created_date":"2021-05-31 18:55:16","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":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"300.30","currentDayDiscount":"15.02","productIsTaxExempt":false,"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":"3271375","reservation_id":"108377","confirmation_number":"SJ12627707689","room_stay_from":"2021-06-23","room_stay_to":"2021-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0,0,0,0","subtotal":"435.00","grand_total":"435.00","paid_amount":"215.63","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":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-23 02:41:17","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":"87.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":"3240546","reservation_id":"108356","confirmation_number":"SJ12646675049","room_stay_from":"2021-06-27","room_stay_to":"2021-06-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1274","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":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-23 02:02:22","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":"0","group_rooms":null,"currentDayPrice":"86.67","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":"3271500","reservation_id":"102628","confirmation_number":"SJ12677271328","room_stay_from":"2021-06-26","room_stay_to":"2021-07-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-11-13 22:15:03","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":"0","group_rooms":null,"currentDayPrice":"87.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":"3217780","reservation_id":"99180","confirmation_number":"SJ12696204199","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-08-17 19:33:02","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.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":"3271824","reservation_id":"110534","confirmation_number":"SJ12611391505","room_stay_from":"2021-06-25","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0,0,0","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1275","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":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 18:00:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.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":"3271838","reservation_id":"110535","confirmation_number":"SJ12655075815","room_stay_from":"2021-06-25","room_stay_to":"2021-07-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0,0,0,0,0,0","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1276","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":"122254","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 18:12:07","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":"87.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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3274331","reservation_id":"117734","confirmation_number":"SJ12657710008","room_confirmation_number":"SJ12658775000","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","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":"124712","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-06-27 17:33:21","reservation_modified_date_time":"2021-06-27 17:33:21","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124712","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":"3229523","reservation_id":"105350","confirmation_number":"SJ12668352069","room_confirmation_number":"SJ12693715017","room_stay_from":"2021-06-25","room_stay_to":"2021-06-29","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"111735","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-07 13:34:17","reservation_modified_date_time":"2021-04-07 13:34:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111735","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3226322","reservation_id":"110854","confirmation_number":"SJ12611787722","room_confirmation_number":"SJ12664628580","room_stay_from":"2021-06-26","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"0,0,0,0,0","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1777","service_quantity":"1","customer_traveller_id":"117376","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-02 02:38:42","reservation_modified_date_time":"2021-04-02 02:38:42","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117376","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3217508","reservation_id":"110509","confirmation_number":"SJ12620858322","room_confirmation_number":"SJ12631801725","room_stay_from":"2021-06-24","room_stay_to":"2021-06-28","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":"117095","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 14:27:15","reservation_modified_date_time":"2021-03-17 19:03:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117020","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":"3246647","reservation_id":"114498","confirmation_number":"SJ12648472819","room_confirmation_number":"SJ12692683584","room_stay_from":"2021-06-26","room_stay_to":"2021-06-28","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"121193","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-04 15:30:16","reservation_modified_date_time":"2021-05-04 15:30:16","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121193","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":"3271032","reservation_id":"112261","confirmation_number":"SJ12646370717","room_confirmation_number":"SJ12691116073","room_stay_from":"2021-06-24","room_stay_to":"2021-06-28","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":"118836","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-06 18:45:26","reservation_modified_date_time":"2021-06-20 20:46:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118836","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":"3271376","reservation_id":"108377","confirmation_number":"SJ12651517074","room_confirmation_number":"SJ12627707689","room_stay_from":"2021-06-23","room_stay_to":"2021-06-28","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":"114828","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 02:41:17","reservation_modified_date_time":"2021-06-21 14:29:09","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3271819","reservation_id":"114284","confirmation_number":"SJ12630974731","room_confirmation_number":"SJ12670254613","room_stay_from":"2021-06-25","room_stay_to":"2021-06-28","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"120941","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-01 17:30:11","reservation_modified_date_time":"2021-06-22 15:08:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120941","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":"3273531","reservation_id":"112233","confirmation_number":"SJ12648135352","room_confirmation_number":"SJ12678435632","room_stay_from":"2021-06-25","room_stay_to":"2021-06-28","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":"118801","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-06 11:44:28","reservation_modified_date_time":"2021-06-25 18:58:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118801","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":"3273533","reservation_id":"113000","confirmation_number":"SJ12653158040","room_confirmation_number":"SJ12650858902","room_stay_from":"2021-06-25","room_stay_to":"2021-06-28","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":"119582","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-14 21:56:15","reservation_modified_date_time":"2021-06-25 18:58:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119582","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":"3274029","reservation_id":"115902","confirmation_number":"SJ12691832912","room_confirmation_number":"SJ12630498084","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","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":"122691","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-26 08:50:10","reservation_modified_date_time":"2021-06-26 19:22:18","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122691","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":"3274183","reservation_id":"118164","confirmation_number":"SJ12634485657","room_confirmation_number":"SJ12662807763","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","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":"125169","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-27 00:42:14","reservation_modified_date_time":"2021-06-27 00:42:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125169","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":"3274223","reservation_id":"118172","confirmation_number":"SJ12622964251","room_confirmation_number":"SJ12615213132","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","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":"125178","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-27 11:19:10","reservation_modified_date_time":"2021-06-27 11:19:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125178","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":"3274316","reservation_id":"114996","confirmation_number":"SJ12662109910","room_confirmation_number":"SJ12637354999","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","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":"121709","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-11 16:24:09","reservation_modified_date_time":"2021-06-27 16:49:27","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121709","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":"3274332","reservation_id":"117734","confirmation_number":"SJ12698562036","room_confirmation_number":"SJ12658775000","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","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":"124712","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-21 01:03:08","reservation_modified_date_time":"2021-06-27 17:33:21","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124712","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":"3274509","reservation_id":"118212","confirmation_number":"SJ12653126773","room_confirmation_number":"SJ12654369305","room_stay_from":"2021-06-27","room_stay_to":"2021-06-28","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":"116211","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-27 22:33:18","reservation_modified_date_time":"2021-06-27 22:33:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116211","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":"3229524","reservation_id":"105350","confirmation_number":"SJ12614355907","room_confirmation_number":"SJ12693715017","room_stay_from":"2021-06-25","room_stay_to":"2021-06-29","room_stay_status":"Active","nightly_price":"25.00,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":"111735","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 23:47:09","reservation_modified_date_time":"2021-04-07 13:34:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111735","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3246377","reservation_id":"114464","confirmation_number":"SJ12678333406","room_confirmation_number":"SJ12637641953","room_stay_from":"2021-06-26","room_stay_to":"2021-06-29","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":"121158","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-04 00:05:08","reservation_modified_date_time":"2021-05-04 00:05:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121158","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":"3260248","reservation_id":"110568","confirmation_number":"SJ12637143129","room_confirmation_number":"SJ12663392833","room_stay_from":"2021-06-25","room_stay_to":"2021-06-29","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":"117080","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 20:32:10","reservation_modified_date_time":"2021-05-31 23:36:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117080","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":"3265066","reservation_id":"116590","confirmation_number":"SJ12674065626","room_confirmation_number":"SJ12652657187","room_stay_from":"2021-06-25","room_stay_to":"2021-06-29","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":"123475","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-05 15:49:08","reservation_modified_date_time":"2021-06-10 13:59:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123475","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":"3271835","reservation_id":"106412","confirmation_number":"SJ12626337122","room_confirmation_number":"SJ12619027728","room_stay_from":"2021-06-25","room_stay_to":"2021-06-29","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":"112808","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 14:40:53","reservation_modified_date_time":"2021-06-22 15:14:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112808","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":"3271972","reservation_id":"113297","confirmation_number":"SJ12665424852","room_confirmation_number":"SJ12675864167","room_stay_from":"2021-06-26","room_stay_to":"2021-06-29","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":"119859","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-18 15:52:53","reservation_modified_date_time":"2021-06-22 18:35:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119859","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":"3274323","reservation_id":"117938","confirmation_number":"SJ12620773792","room_confirmation_number":"SJ12670384667","room_stay_from":"2021-06-27","room_stay_to":"2021-06-29","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"124930","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-24 01:21:13","reservation_modified_date_time":"2021-06-27 16:49:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124930","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":"3240547","reservation_id":"108356","confirmation_number":"SJ12651290696","room_confirmation_number":"SJ12646675049","room_stay_from":"2021-06-27","room_stay_to":"2021-06-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114808","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 02:02:22","reservation_modified_date_time":"2021-04-23 19:30: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":"3260512","reservation_id":"116319","confirmation_number":"SJ12634648353","room_confirmation_number":"SJ12610918728","room_stay_from":"2021-06-27","room_stay_to":"2021-06-30","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"123182","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-01 15:43:08","reservation_modified_date_time":"2021-06-01 16:58:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123182","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":"3265741","reservation_id":"116277","confirmation_number":"SJ12621869667","room_confirmation_number":"SJ12695480535","room_stay_from":"2021-06-27","room_stay_to":"2021-06-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"123136","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-31 21:20:22","reservation_modified_date_time":"2021-06-11 18:56:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123136","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":"3271610","reservation_id":"117455","confirmation_number":"SJ12634755649","room_confirmation_number":"SJ12697762004","room_stay_from":"2021-06-26","room_stay_to":"2021-06-30","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":"119891","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-16 23:26:10","reservation_modified_date_time":"2021-06-21 22:32:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119891","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":"3272464","reservation_id":"115577","confirmation_number":"SJ12627297987","room_confirmation_number":"SJ12691069015","room_stay_from":"2021-06-27","room_stay_to":"2021-06-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"122327","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-20 21:01:09","reservation_modified_date_time":"2021-06-23 21:31:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122327","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":"3273649","reservation_id":"113302","confirmation_number":"SJ12625401697","room_confirmation_number":"SJ12625034441","room_stay_from":"2021-06-26","room_stay_to":"2021-06-30","room_stay_status":"Active","nightly_price":"25,25,25,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":"119886","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-18 16:56:13","reservation_modified_date_time":"2021-06-25 22:08:52","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119886","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":"3274089","reservation_id":"112210","confirmation_number":"SJ12662808743","room_confirmation_number":"SJ12619287066","room_stay_from":"2021-06-23","room_stay_to":"2021-06-30","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":"118776","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-05 23:52:28","reservation_modified_date_time":"2021-06-26 20:28:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118776","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":"3178718","reservation_id":"105306","confirmation_number":"SJ12676811150","room_confirmation_number":"SJ12646031307","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"111692","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-14 02:13:51","reservation_modified_date_time":"2021-01-14 02:13:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111692","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":"3226323","reservation_id":"110854","confirmation_number":"SJ12637011351","room_confirmation_number":"SJ12664628580","room_stay_from":"2021-06-26","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"117376","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-21 00:37:18","reservation_modified_date_time":"2021-04-02 02:38:42","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117376","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":"3232913","reservation_id":"112735","confirmation_number":"SJ12697499549","room_confirmation_number":"SJ12662416516","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"119327","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-11 23:59:28","reservation_modified_date_time":"2021-04-11 23:59:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119327","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":"3240303","reservation_id":"113701","confirmation_number":"SJ12637596500","room_confirmation_number":"SJ12685454450","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"120311","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-23 15:19:11","reservation_modified_date_time":"2021-04-23 15:19:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120311","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":"3271501","reservation_id":"102628","confirmation_number":"SJ12643614116","room_confirmation_number":"SJ12677271328","room_stay_from":"2021-06-26","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"108774","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-13 22:15:03","reservation_modified_date_time":"2021-06-21 18:39:55","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":"3271507","reservation_id":"116723","confirmation_number":"SJ12674559147","room_confirmation_number":"SJ12649754495","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"123625","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-07 14:58:31","reservation_modified_date_time":"2021-06-21 18:41:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123625","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":"3273609","reservation_id":"112595","confirmation_number":"SJ12698146074","room_confirmation_number":"SJ12696601929","room_stay_from":"2021-06-25","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"119175","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 14:51:08","reservation_modified_date_time":"2021-06-25 21:25:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119175","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":"3273669","reservation_id":"110793","confirmation_number":"SJ12688701975","room_confirmation_number":"SJ12616732724","room_stay_from":"2021-06-27","room_stay_to":"2021-07-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"117303","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-20 13:17:07","reservation_modified_date_time":"2021-06-25 22:22:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117303","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":"3217781","reservation_id":"99180","confirmation_number":"SJ12654750415","room_confirmation_number":"SJ12696204199","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"105159","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-17 19:33:02","reservation_modified_date_time":"2021-03-18 01:30:47","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":"3231744","reservation_id":"112574","confirmation_number":"SJ12612322535","room_confirmation_number":"SJ12675456502","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"119153","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 02:14:24","reservation_modified_date_time":"2021-04-10 13:50:27","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119153","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":"3240561","reservation_id":"113719","confirmation_number":"SJ12628381146","room_confirmation_number":"SJ12617869053","room_stay_from":"2021-06-26","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"120330","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-23 18:43:25","reservation_modified_date_time":"2021-04-23 19:31:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120330","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":"3249761","reservation_id":"114970","confirmation_number":"SJ12620960775","room_confirmation_number":"SJ12664749078","room_stay_from":"2021-06-27","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"121691","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-11 01:14:09","reservation_modified_date_time":"2021-05-11 01:14:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121691","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":"3271825","reservation_id":"110534","confirmation_number":"SJ12680818406","room_confirmation_number":"SJ12611391505","room_stay_from":"2021-06-25","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117047","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 18:00:57","reservation_modified_date_time":"2021-06-22 15:09:54","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":"3271839","reservation_id":"110535","confirmation_number":"SJ12657000227","room_confirmation_number":"SJ12655075815","room_stay_from":"2021-06-25","room_stay_to":"2021-07-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117047","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 18:12:07","reservation_modified_date_time":"2021-06-22 15:15:05","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":"3246199","reservation_id":"114423","confirmation_number":"SJ12688969029","room_confirmation_number":"SJ12689062824","room_stay_from":"2021-06-27","room_stay_to":"2021-07-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"121098","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-03 15:45:17","reservation_modified_date_time":"2021-05-03 15:45:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121098","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":"3274242","reservation_id":"114944","confirmation_number":"SJ12613396407","room_confirmation_number":"SJ12680919922","room_stay_from":"2021-06-27","room_stay_to":"2021-07-03","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"121666","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-10 20:59:02","reservation_modified_date_time":"2021-06-27 12:58:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121666","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":"3260067","reservation_id":"116264","confirmation_number":"SJ12621452758","room_confirmation_number":"SJ12687282636","room_stay_from":"2021-06-27","room_stay_to":"2021-07-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":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"123123","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-31 18:55:16","reservation_modified_date_time":"2021-05-31 18:55:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123123","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":"3262995","reservation_id":"111476","confirmation_number":"SJ12639912371","room_confirmation_number":"SJ12677242204","room_stay_from":"2021-06-27","room_stay_to":"2021-07-04","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":"118036","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-28 00:09:08","reservation_modified_date_time":"2021-06-06 00:08:18","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118036","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3274403","reservation_id":"118198","confirmation_number":"SJ12694435742","room_confirmation_number":"SJ12632735006","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-06-27 20:08:43","reservation_modified_date_time":"2021-06-27 20:08:43","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}