{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-04-28","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":19,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1307,1309,1310,1314,1318,1319,1271,1289,1315,1942","block_room_bookings":[{"confirmation_number":"SJ12673302279","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJ12638704592","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJ12684843284","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJ12619736819","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","bundle_room":"0","product_id":"1314"},{"confirmation_number":"SJ12645168488","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","bundle_room":"0","product_id":"1318"},{"confirmation_number":"SJ12643282679","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","bundle_room":"0","product_id":"1319"},{"confirmation_number":"SJ12673724495","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJ12645323420","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","bundle_room":"0","product_id":"1289"},{"confirmation_number":"SJ12615397218","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","bundle_room":"0","product_id":"1315"},{"confirmation_number":"SJ12610184938","room_stay_from":"2021-04-28","room_stay_to":"2021-05-02","bundle_room":"0","product_id":"1942"}],"bundle_block_count":"1267,1268,1302,1303,1269,1270,1311,1312,1271,1272,1309,1310,1291,1711,1307,1308,1262,1263,1260,1261,1304,1305","bundle_block_bookings":[{"confirmation_number":"SJB12632531273","room_stay_from":"2021-04-24","room_stay_to":"2021-04-29","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12622815533","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12629218277","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12638971007","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12621303825","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","bundle_room":"1","product_id":"1332"},{"confirmation_number":"SJB12639578597","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12626665290","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12641851691","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12660868902","room_stay_from":"2021-04-28","room_stay_to":"2021-04-30","bundle_room":"1","product_id":"1330"},{"confirmation_number":"SJB12647091166","room_stay_from":"2021-04-27","room_stay_to":"2021-04-30","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12649353866","room_stay_from":"2021-04-28","room_stay_to":"2021-05-01","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12696267591","room_stay_from":"2021-04-28","room_stay_to":"2021-05-03","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12699610411","room_stay_from":"2021-04-28","room_stay_to":"2021-05-03","bundle_room":"0","product_id":"1305"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3186984","reservation_id":"106408","confirmation_number":"SJ12622282653","room_stay_from":"2021-04-24","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.30,160.30,160.30,160.30,160.30","nightly_discount":"0,0,0,0,0","subtotal":"829.50","grand_total":"933.19","paid_amount":"933.19","room_type_id":"413","product_id":"1267","siteminder_id":"BDC-3167840611","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":"112805","customer_id":"112805","source_of_creation":"Booking.com","reservation_created_date":"2021-01-29 14:25:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"171.81","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.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":"3203103","reservation_id":"108281","confirmation_number":"SJ12636974410","room_stay_from":"2021-04-28","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.84,129.84,152.52,152.52,112.83","nightly_discount":"0,0,0,0,0","subtotal":"677.55","grand_total":"762.25","paid_amount":"762.25","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3004188921","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":"114740","customer_id":"114740","source_of_creation":"Booking.com","reservation_created_date":"2021-02-22 17:23:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"144.45","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"129.84","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3203653","reservation_id":"106362","confirmation_number":"SJ12657876825","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.17,163.17,188.37,188.37,163.17,163.17,163.17","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1192.59","grand_total":"1341.66","paid_amount":"1341.66","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-2673763646","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":"112757","customer_id":"112757","source_of_creation":"Booking.com","reservation_created_date":"2021-01-28 23:36:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"246.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"163.17","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":"3206543","reservation_id":"108625","confirmation_number":"SJ12656346023","room_stay_from":"2021-04-26","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.30,195.30,195.30,195.30,230.30,230.30,160.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1402.10","grand_total":"1577.37","paid_amount":"1577.37","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-2712943488","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":"115064","customer_id":"115064","source_of_creation":"Booking.com","reservation_created_date":"2021-02-26 04:07:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"283.85","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"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":"3225794","reservation_id":"111769","confirmation_number":"SJ12678021317","room_stay_from":"2021-04-28","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"254.88,254.88","nightly_discount":"0,0","subtotal":"509.76","grand_total":"573.48","paid_amount":"573.48","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-3627593634","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":"118327","customer_id":"118327","source_of_creation":"Booking.com","reservation_created_date":"2021-03-31 16:51:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"100.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"254.88","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":"3229813","reservation_id":"109832","confirmation_number":"SJ12639370317","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.85,146.85,146.85,146.85,146.85","nightly_discount":"0,0,0,0,0","subtotal":"734.25","grand_total":"826.03","paid_amount":"826.03","room_type_id":"319","product_id":"1291","siteminder_id":"BDC-3548480543","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":"116323","customer_id":"116323","source_of_creation":"Booking.com","reservation_created_date":"2021-03-09 04:45:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"154.66","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"146.85","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":"3231992","reservation_id":"109124","confirmation_number":"SJ12616237128","room_stay_from":"2021-04-28","room_stay_to":"2021-05-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,160.30,160.30,160.30","nightly_discount":"0,0,0,0","subtotal":"641.20","grand_total":"721.35","paid_amount":"721.35","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-3189146732","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":"115597","customer_id":"115597","source_of_creation":"Booking.com","reservation_created_date":"2021-03-03 15:02:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"168.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.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":"3239140","reservation_id":"113558","confirmation_number":"SJ12693394160","room_stay_from":"2021-04-26","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75,246.75","nightly_discount":"0,0,0,0","subtotal":"987.00","grand_total":"1110.38","paid_amount":"1110.38","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3583016466","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":"120159","customer_id":"120159","source_of_creation":"Booking.com","reservation_created_date":"2021-04-21 19:27:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"195.66","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3240130","reservation_id":"113680","confirmation_number":"SJ12616434168","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.74","nightly_discount":"0","subtotal":"228.74","grand_total":"257.34","paid_amount":"257.34","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-2744991003","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":"120288","customer_id":"120288","source_of_creation":"Booking.com","reservation_created_date":"2021-04-23 02:11:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"45.67","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"228.74","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":"3241271","reservation_id":"107325","confirmation_number":"SJ12622239414","room_stay_from":"2021-04-28","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"181.30,181.30,209.30,209.30,209.30","nightly_discount":"0,0,0,0,0","subtotal":"990.50","grand_total":"1114.32","paid_amount":"1114.32","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-3546181952","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":"113782","customer_id":"113782","source_of_creation":"Booking.com","reservation_created_date":"2021-02-11 01:37:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"191.97","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":"3241860","reservation_id":"111648","confirmation_number":"SJ12673975702","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,209.30,209.30,209.30,209.30","nightly_discount":"0,0,0,0,0","subtotal":"1046.50","grand_total":"1177.32","paid_amount":"1177.32","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-2349742095","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":"118206","customer_id":"118206","source_of_creation":"Booking.com","reservation_created_date":"2021-03-30 00:49:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"210.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"209.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":"3242370","reservation_id":"113957","confirmation_number":"SJ12621733068","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.51","nightly_discount":"0","subtotal":"255.51","grand_total":"287.45","paid_amount":"287.45","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2336426525","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":"120590","customer_id":"120590","source_of_creation":"Booking.com","reservation_created_date":"2021-04-26 22:39:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"50.49","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"255.51","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":"3242865","reservation_id":"114037","confirmation_number":"SJ12665779903","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"192.10","nightly_discount":"0","subtotal":"192.10","grand_total":"216.12","paid_amount":"216.12","room_type_id":"413","product_id":"1268","siteminder_id":"BDC-2956337425","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":"120671","customer_id":"120671","source_of_creation":"Booking.com","reservation_created_date":"2021-04-28 00:26:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"39.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"192.10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3242871","reservation_id":"114039","confirmation_number":"SJ12650990609","room_stay_from":"2021-04-28","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.88,200.88","nightly_discount":"0,0","subtotal":"401.76","grand_total":"451.98","paid_amount":"451.98","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-3467434015","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":"120673","customer_id":"120673","source_of_creation":"Booking.com","reservation_created_date":"2021-04-28 00:48:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"81.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"200.88","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":"3243559","reservation_id":"114126","confirmation_number":"SJ12674562689","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"192.10","nightly_discount":"0","subtotal":"192.10","grand_total":"216.12","paid_amount":"216.12","room_type_id":"413","product_id":"1272","siteminder_id":"BDC-3465873155","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":"120762","customer_id":"120762","source_of_creation":"Booking.com","reservation_created_date":"2021-04-29 01:22:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"39.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"192.10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3242968","reservation_id":"112367","confirmation_number":"SJ12698783291","room_stay_from":"2021-06-07","room_stay_to":"2021-06-10","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"222.07,201.82,222.07","nightly_discount":"0,0,0","subtotal":"645.96","grand_total":"726.71","paid_amount":"280.20","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2451021014","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":"118935","customer_id":"118935","source_of_creation":"Booking.com","reservation_created_date":"2021-04-07 17:31:48","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"129.78","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[{"room_stay_id":"3243067","reservation_id":"99741","confirmation_number":"SJ12687867502","room_stay_from":"2021-04-05","room_stay_to":"2021-04-06","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3320409792","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":"105755","customer_id":"105755","source_of_creation":"Booking.com","reservation_created_date":"2020-08-30 15:42:08","service_canceled_date_time":"2021-04-28 15:18:47","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"45.81","reservation_status_type":"canceled resv amount refunded","total_paid_amount":"0.00","sub_hotel_id":"126","deltaChange":"0.00","changedComment":"resv paid or refunded after cancel","currentDayPrice":0,"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"}]}],"exp_taxable":[{"room_stay_id":"3230533","reservation_id":"111873","confirmation_number":"SJ12697609684","room_stay_from":"2021-04-27","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"265.50,265.50,265.50","nightly_discount":"0,0,0","subtotal":"796.50","grand_total":"896.07","paid_amount":"896.07","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1754894500","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":"118438","customer_id":"118438","source_of_creation":"Expedia","reservation_created_date":"2021-04-02 02:12:07","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":"265.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3231564","reservation_id":"112555","confirmation_number":"SJ12636763405","room_stay_from":"2021-04-26","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.40,212.40,212.40,212.40","nightly_discount":"0,0,0,0","subtotal":"849.60","grand_total":"955.80","paid_amount":"955.80","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1757776355","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":"119133","customer_id":"119133","source_of_creation":"Expedia","reservation_created_date":"2021-04-09 21:39:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"212.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":"3240208","reservation_id":"113009","confirmation_number":"SJ12633973843","room_stay_from":"2021-04-28","room_stay_to":"2021-05-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.40,215.40,257.40","nightly_discount":"0,0,0","subtotal":"688.20","grand_total":"774.23","paid_amount":"774.23","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1759669913","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":"119593","customer_id":"119593","source_of_creation":"Expedia","reservation_created_date":"2021-04-14 23:18:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"215.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":"3242389","reservation_id":"113661","confirmation_number":"SJ12677564323","room_stay_from":"2021-04-27","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.40,179.40,179.40","nightly_discount":"0,0,0","subtotal":"538.20","grand_total":"605.48","paid_amount":"605.48","room_type_id":"319","product_id":"1312","siteminder_id":"EXP-1762666865","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":"120264","customer_id":"120264","source_of_creation":"Expedia","reservation_created_date":"2021-04-22 22:39:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","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":"179.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":"3242502","reservation_id":"110586","confirmation_number":"SJ12640207675","room_stay_from":"2021-04-27","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.40,161.40,161.40","nightly_discount":"0,0,0","subtotal":"484.20","grand_total":"544.73","paid_amount":"544.73","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1748887689","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":"117100","customer_id":"117100","source_of_creation":"Expedia","reservation_created_date":"2021-03-17 23:37:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"161.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":"3242796","reservation_id":"114023","confirmation_number":"SJ12676601817","room_stay_from":"2021-04-28","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.20,167.20","nightly_discount":"0,0","subtotal":"334.40","grand_total":"376.20","paid_amount":"376.20","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1764445601","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":"120657","customer_id":"120657","source_of_creation":"Expedia","reservation_created_date":"2021-04-27 21:45:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"167.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":"3243257","reservation_id":"96793","confirmation_number":"SJ12628295076","room_stay_from":"2021-04-28","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"178,178","nightly_discount":"0,0","subtotal":"356.00","grand_total":"400.50","paid_amount":"400.50","room_type_id":"319","product_id":"1308","siteminder_id":"EXP-1671874871","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102913","customer_id":"102913","source_of_creation":"Expedia","reservation_created_date":"2020-06-18 20:58:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"178","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":"3243515","reservation_id":"109340","confirmation_number":"SJ12693483785","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"191.30,191.30,191.30,191.30,191.30","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"956.50","grand_total":"1076.07","paid_amount":"1076.07","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1743861784","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"125.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115805","customer_id":"115805","source_of_creation":"Expedia","reservation_created_date":"2021-03-04 15:32:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"191.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3243520","reservation_id":"109473","confirmation_number":"SJ12699179345","room_stay_from":"2021-04-25","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"216.30,216.30,216.30,216.30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"865.20","grand_total":"973.35","paid_amount":"973.35","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1744192042","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":"115940","customer_id":"115940","source_of_creation":"Expedia","reservation_created_date":"2021-03-05 12:42:13","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"216.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3243528","reservation_id":"109578","confirmation_number":"SJ12675188151","room_stay_from":"2021-04-28","room_stay_to":"2021-05-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.75,171.75,276.75","nightly_discount":"0.00,0.00,0.00","subtotal":"620.25","grand_total":"697.78","paid_amount":"697.78","room_type_id":"319","product_id":"1277","siteminder_id":"EXP-1744588488","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":"116059","customer_id":"116059","source_of_creation":"Expedia","reservation_created_date":"2021-03-06 16:02:22","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","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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3241629","reservation_id":"112594","confirmation_number":"SJ12695813842","room_stay_from":"2021-04-25","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"294.56,302.42,302.42,302.42","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1201.82","grand_total":"1408.04","paid_amount":"1408.04","room_type_id":"319","product_id":"1943","siteminder_id":"ABB-HMAEN8DJMB","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"1209.68","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119174","customer_id":"119174","source_of_creation":"Airbnb","reservation_created_date":"2021-04-10 14:42:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"38.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"302.42","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":"3242070","reservation_id":"112585","confirmation_number":"SJ12628396272","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"301.92,301.92,296.49","nightly_discount":"0.00,0.00,0.00","subtotal":"900.33","grand_total":"1043.36","paid_amount":"1043.36","room_type_id":"319","product_id":"1311","siteminder_id":"ABB-HM83KCJEJX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"905.76","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119163","customer_id":"119163","source_of_creation":"Airbnb","reservation_created_date":"2021-04-10 12:38:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"26.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"296.49","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":"3242476","reservation_id":"111489","confirmation_number":"SJ12615590142","room_stay_from":"2021-04-27","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"301.92,298.30","nightly_discount":"0.00,0.00","subtotal":"600.22","grand_total":"695.57","paid_amount":"695.57","room_type_id":"319","product_id":"1306","siteminder_id":"ABB-HMZJHW3YXR","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"603.84","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118054","customer_id":"118054","source_of_creation":"Airbnb","reservation_created_date":"2021-03-28 02:54:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"17.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"298.30","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":"3243024","reservation_id":"110161","confirmation_number":"SJ12642208559","room_stay_from":"2021-04-28","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"413.92,413.92,413.92,413.92,401.50","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"2057.18","grand_total":"2384.00","paid_amount":"2384.00","room_type_id":"320","product_id":"1329","siteminder_id":"ABB-HMJNTJK9X5","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"2069.60","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116672","customer_id":"116672","source_of_creation":"Airbnb","reservation_created_date":"2021-03-12 21:57:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"60.87","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"413.92","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":"3230996","reservation_id":"112477","confirmation_number":"SJ12640020586","room_stay_from":"2021-04-25","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75,246.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"987.00","grand_total":"1110.38","paid_amount":"1110.38","room_type_id":"319","product_id":"1301","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":"119036","customer_id":"119036","source_of_creation":"FE","reservation_created_date":"2021-04-08 23:27:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"246.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":"3241265","reservation_id":"111377","confirmation_number":"SJ12635010341","room_stay_from":"2021-04-24","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"321.75,246.75,246.75,246.75,246.75,246.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1555.50","grand_total":"1749.94","paid_amount":"1749.94","room_type_id":"319","product_id":"1313","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":"117921","customer_id":"117921","source_of_creation":"FE","reservation_created_date":"2021-03-26 20:48:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","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":"246.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3195031","reservation_id":"107250","confirmation_number":"SJ12660712041","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"322.15,322.15,322.15","nightly_discount":"0.00,0.00,0.00","subtotal":"966.45","grand_total":"1087.25","paid_amount":"1087.25","room_type_id":"320","product_id":"1328","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":"113713","customer_id":"113713","source_of_creation":"PMS","reservation_created_date":"2021-02-09 22:32:52","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":"0","group_rooms":"1302,1303","currentDayPrice":"322.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3242377","reservation_id":"113940","confirmation_number":"SJ12674279879","room_stay_from":"2021-04-26","room_stay_to":"2021-04-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"262.65,262.65,262.65,262.65","nightly_discount":"0.00,0.00,0,0","subtotal":"1050.60","grand_total":"1181.93","paid_amount":"1181.93","room_type_id":"319","product_id":"1915","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119882","customer_id":"119882","source_of_creation":"PMS","reservation_created_date":"2021-04-26 20:00:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"262.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":"3242885","reservation_id":"114042","confirmation_number":"SJ12668068893","room_stay_from":"2021-04-27","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"262.65,262.65","nightly_discount":"0.00,0.00","subtotal":"525.30","grand_total":"590.97","paid_amount":"590.97","room_type_id":"319","product_id":"1286","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":"120677","customer_id":"120677","source_of_creation":"PMS","reservation_created_date":"2021-04-28 01:43:22","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":"0","group_rooms":null,"currentDayPrice":"262.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3243092","reservation_id":"114075","confirmation_number":"SJ12629821304","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"262.65","nightly_discount":"0.00","subtotal":"262.65","grand_total":"295.48","paid_amount":"295.48","room_type_id":"319","product_id":"1917","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":"120388","customer_id":"120388","source_of_creation":"PMS","reservation_created_date":"2021-04-28 16:06:01","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"262.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[{"room_stay_id":"3243072","reservation_id":"105915","confirmation_number":"SJ12675456963","room_stay_from":"2021-04-26","room_stay_to":"2021-04-28","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,139.00","nightly_discount":"0.00,0.00","subtotal":"278.00","grand_total":"312.75","paid_amount":"84.38","room_type_id":"413","product_id":"1271","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2021-01-23 03:41:59","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[{"room_stay_id":"3185832","reservation_id":"95536","confirmation_number":"SJ12645800076","room_stay_from":"2021-04-23","room_stay_to":"2021-05-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.14,87.14,87.14,87.14,87.14,87.14,87.14,86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"869.99","grand_total":"869.99","paid_amount":"281.25","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-28 14:11:36","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":"87.14","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":"3196163","reservation_id":"107397","confirmation_number":"SJ12676286863","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","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":"413","product_id":"1269","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-12 01:32:29","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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":"3196188","reservation_id":"107405","confirmation_number":"SJ12640279491","room_stay_from":"2021-04-28","room_stay_to":"2021-05-01","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":"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":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-12 02:48:16","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":"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":"3204806","reservation_id":"108591","confirmation_number":"SJ12653667920","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","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.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-26 01:25:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3215882","reservation_id":"108592","confirmation_number":"SJ12694732411","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","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.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-26 01:27:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"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":"3229909","reservation_id":"95534","confirmation_number":"SJ12616649969","room_stay_from":"2021-04-23","room_stay_to":"2021-05-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14,87.14","nightly_discount":"0.00,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1219.96","grand_total":"1219.96","paid_amount":"393.75","room_type_id":"412","product_id":"1866","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-28 14:06:38","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":"87.14","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":"3240871","reservation_id":"106660","confirmation_number":"SJ12621428969","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-01 22:10:59","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3242384","reservation_id":"107404","confirmation_number":"SJ12647584589","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"1711","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-12 02:29:33","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","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":"3242387","reservation_id":"106661","confirmation_number":"SJ12647750567","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"413","product_id":"1262","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-01 22:13:04","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3243103","reservation_id":"107777","confirmation_number":"SJ12668344605","room_stay_from":"2021-04-28","room_stay_to":"2021-05-01","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":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-16 10:59:04","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","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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3239135","reservation_id":"112594","confirmation_number":"SJ12671345290","room_confirmation_number":"SJ12695813842","room_stay_from":"2021-04-25","room_stay_to":"2021-04-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":"100.60","paid_amount":"100.60","product_id":"1777","service_quantity":"1","customer_traveller_id":"119174","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-21 20:31:51","reservation_modified_date_time":"2021-04-21 20:31:51","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119174","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","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":"3241867","reservation_id":"109340","confirmation_number":"SJ12652298870","room_confirmation_number":"SJ12693483785","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0,0","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1777","service_quantity":"1","customer_traveller_id":"115805","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-25 19:29:35","reservation_modified_date_time":"2021-04-25 19:29:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115805","canceled_nights_data":"","posAmt_airbnb_taxpaid":"125.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"}]},{"room_stay_id":"3243259","reservation_id":"96793","confirmation_number":"SJ12693105329","room_confirmation_number":"SJ12628295076","room_stay_from":"2021-04-28","room_stay_to":"2021-04-30","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"102913","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-28 19:55:10","reservation_modified_date_time":"2021-04-28 19:55:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102913","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3243059","reservation_id":"112110","confirmation_number":"SJ12624293511","room_confirmation_number":"SJ12629852659","room_stay_from":"2021-05-06","room_stay_to":"2021-05-09","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"118678","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-28 14:51:40","reservation_modified_date_time":"2021-04-28 14:51:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118678","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3186985","reservation_id":"106408","confirmation_number":"SJ12676184823","room_confirmation_number":"SJ12622282653","room_stay_from":"2021-04-24","room_stay_to":"2021-04-29","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":"112805","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-29 14:25:06","reservation_modified_date_time":"2021-01-29 14:25:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112805","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":"3195032","reservation_id":"107250","confirmation_number":"SJ12615377366","room_confirmation_number":"SJ12660712041","room_stay_from":"2021-04-26","room_stay_to":"2021-04-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":"113713","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-09 22:32:52","reservation_modified_date_time":"2021-02-09 22:32:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113713","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":"3196164","reservation_id":"107397","confirmation_number":"SJ12639808354","room_confirmation_number":"SJ12676286863","room_stay_from":"2021-04-26","room_stay_to":"2021-04-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113854","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 01:32:29","reservation_modified_date_time":"2021-02-12 01:32:29","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":"3230997","reservation_id":"112477","confirmation_number":"SJ12612977296","room_confirmation_number":"SJ12640020586","room_stay_from":"2021-04-25","room_stay_to":"2021-04-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":"119036","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-08 23:27:41","reservation_modified_date_time":"2021-04-08 23:27:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119036","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":"3240131","reservation_id":"113680","confirmation_number":"SJ12631107567","room_confirmation_number":"SJ12616434168","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","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":"120288","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-23 02:11:15","reservation_modified_date_time":"2021-04-23 02:11:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120288","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":"3241630","reservation_id":"112594","confirmation_number":"SJ12631670970","room_confirmation_number":"SJ12695813842","room_stay_from":"2021-04-25","room_stay_to":"2021-04-29","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119174","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 14:42:10","reservation_modified_date_time":"2021-04-25 12:27:04","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119174","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"3242072","reservation_id":"112585","confirmation_number":"SJ12645823436","room_confirmation_number":"SJ12628396272","room_stay_from":"2021-04-26","room_stay_to":"2021-04-29","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119163","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 12:38:08","reservation_modified_date_time":"2021-04-26 13:22:55","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119163","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":"3242371","reservation_id":"113957","confirmation_number":"SJ12622279839","room_confirmation_number":"SJ12621733068","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","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":"120590","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-26 22:39:09","reservation_modified_date_time":"2021-04-26 22:39:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120590","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":"3242477","reservation_id":"111489","confirmation_number":"SJ12650713479","room_confirmation_number":"SJ12615590142","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"118054","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-28 02:54:10","reservation_modified_date_time":"2021-04-27 11:45:52","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118054","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":"3242866","reservation_id":"114037","confirmation_number":"SJ12699396437","room_confirmation_number":"SJ12665779903","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","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":"120671","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-28 00:26:13","reservation_modified_date_time":"2021-04-28 00:26:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120671","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":"3242886","reservation_id":"114042","confirmation_number":"SJ12686222120","room_confirmation_number":"SJ12668068893","room_stay_from":"2021-04-27","room_stay_to":"2021-04-29","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":"120677","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-28 01:43:22","reservation_modified_date_time":"2021-04-28 01:43:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120677","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":"3243093","reservation_id":"114075","confirmation_number":"SJ12624924902","room_confirmation_number":"SJ12629821304","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","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":"120388","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-28 16:06:02","reservation_modified_date_time":"2021-04-28 16:06:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120388","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":"3243521","reservation_id":"109473","confirmation_number":"SJ12645666649","room_confirmation_number":"SJ12699179345","room_stay_from":"2021-04-25","room_stay_to":"2021-04-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":"115940","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-05 12:42:13","reservation_modified_date_time":"2021-04-28 22:56:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115940","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3243561","reservation_id":"114126","confirmation_number":"SJ12611231776","room_confirmation_number":"SJ12674562689","room_stay_from":"2021-04-28","room_stay_to":"2021-04-29","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":"120762","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-29 01:22:13","reservation_modified_date_time":"2021-04-29 01:34:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120762","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":"3203654","reservation_id":"106362","confirmation_number":"SJ12667638930","room_confirmation_number":"SJ12657876825","room_stay_from":"2021-04-23","room_stay_to":"2021-04-30","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":"112757","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-28 23:36:12","reservation_modified_date_time":"2021-02-24 15:20:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112757","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":"3204807","reservation_id":"108591","confirmation_number":"SJ12659138449","room_confirmation_number":"SJ12653667920","room_stay_from":"2021-04-23","room_stay_to":"2021-04-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115029","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 01:25:32","reservation_modified_date_time":"2021-02-26 01:25:32","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":"3215883","reservation_id":"108592","confirmation_number":"SJ12639140046","room_confirmation_number":"SJ12694732411","room_stay_from":"2021-04-23","room_stay_to":"2021-04-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115030","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 01:27:18","reservation_modified_date_time":"2021-03-15 01:48: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":"3225795","reservation_id":"111769","confirmation_number":"SJ12615364135","room_confirmation_number":"SJ12678021317","room_stay_from":"2021-04-28","room_stay_to":"2021-04-30","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":"118327","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-31 16:51:07","reservation_modified_date_time":"2021-04-01 12:31:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118327","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":"3229816","reservation_id":"109832","confirmation_number":"SJ12683788974","room_confirmation_number":"SJ12639370317","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","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":"116323","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-09 04:45:11","reservation_modified_date_time":"2021-04-07 17:27:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116323","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":"3230534","reservation_id":"111873","confirmation_number":"SJ12668329767","room_confirmation_number":"SJ12697609684","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"118438","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-02 02:12:07","reservation_modified_date_time":"2021-04-08 13:31:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118438","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":"3231565","reservation_id":"112555","confirmation_number":"SJ12653080678","room_confirmation_number":"SJ12636763405","room_stay_from":"2021-04-26","room_stay_to":"2021-04-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":"119133","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-09 21:39:10","reservation_modified_date_time":"2021-04-09 21:39:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119133","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":"3239141","reservation_id":"113558","confirmation_number":"SJ12627838522","room_confirmation_number":"SJ12693394160","room_stay_from":"2021-04-26","room_stay_to":"2021-04-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":"120159","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-21 19:27:08","reservation_modified_date_time":"2021-04-21 20:32:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120159","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":"3240872","reservation_id":"106660","confirmation_number":"SJ12674140097","room_confirmation_number":"SJ12621428969","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"113078","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 22:10:59","reservation_modified_date_time":"2021-04-24 15:42:49","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3241266","reservation_id":"111377","confirmation_number":"SJ12656905055","room_confirmation_number":"SJ12635010341","room_stay_from":"2021-04-24","room_stay_to":"2021-04-30","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":"117921","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-26 20:48:05","reservation_modified_date_time":"2021-04-24 19:27:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117921","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":"3241862","reservation_id":"111648","confirmation_number":"SJ12622373879","room_confirmation_number":"SJ12673975702","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","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":"118206","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-30 00:49:07","reservation_modified_date_time":"2021-04-25 19:29:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118206","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":"3242378","reservation_id":"113940","confirmation_number":"SJ12656528036","room_confirmation_number":"SJ12674279879","room_stay_from":"2021-04-26","room_stay_to":"2021-04-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":"119882","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-26 20:00:52","reservation_modified_date_time":"2021-04-26 23:00:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119882","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":"3242386","reservation_id":"107404","confirmation_number":"SJ12640827007","room_confirmation_number":"SJ12647584589","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"113860","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 02:29:33","reservation_modified_date_time":"2021-04-26 23:07:00","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":"3242388","reservation_id":"106661","confirmation_number":"SJ12635704579","room_confirmation_number":"SJ12647750567","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"113079","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-01 22:13:04","reservation_modified_date_time":"2021-04-26 23:07:33","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":"3242391","reservation_id":"113661","confirmation_number":"SJ12636411720","room_confirmation_number":"SJ12677564323","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"120264","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-22 22:39:09","reservation_modified_date_time":"2021-04-26 23:08:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120264","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":"3242503","reservation_id":"110586","confirmation_number":"SJ12650275426","room_confirmation_number":"SJ12640207675","room_stay_from":"2021-04-27","room_stay_to":"2021-04-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":"117100","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 23:37:07","reservation_modified_date_time":"2021-04-27 13:25:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117100","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":"3242797","reservation_id":"114023","confirmation_number":"SJ12686718861","room_confirmation_number":"SJ12676601817","room_stay_from":"2021-04-28","room_stay_to":"2021-04-30","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":"120657","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-27 21:45:09","reservation_modified_date_time":"2021-04-27 21:45:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120657","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":"3242872","reservation_id":"114039","confirmation_number":"SJ12658000410","room_confirmation_number":"SJ12650990609","room_stay_from":"2021-04-28","room_stay_to":"2021-04-30","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":"120673","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-28 00:48:08","reservation_modified_date_time":"2021-04-28 00:48:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120673","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":"3243260","reservation_id":"96793","confirmation_number":"SJ12611413361","room_confirmation_number":"SJ12628295076","room_stay_from":"2021-04-28","room_stay_to":"2021-04-30","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":"102913","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 20:58:09","reservation_modified_date_time":"2021-04-28 19:55:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102913","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3243517","reservation_id":"109340","confirmation_number":"SJ12638988346","room_confirmation_number":"SJ12693483785","room_stay_from":"2021-04-25","room_stay_to":"2021-04-30","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":"115805","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 15:32:11","reservation_modified_date_time":"2021-04-28 22:54:41","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115805","canceled_nights_data":"","posAmt_airbnb_taxpaid":"125.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":"3196189","reservation_id":"107405","confirmation_number":"SJ12623434806","room_confirmation_number":"SJ12640279491","room_stay_from":"2021-04-28","room_stay_to":"2021-05-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113861","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-12 02:48:16","reservation_modified_date_time":"2021-02-12 02:48:16","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3240209","reservation_id":"113009","confirmation_number":"SJ12627164402","room_confirmation_number":"SJ12633973843","room_stay_from":"2021-04-28","room_stay_to":"2021-05-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"119593","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-14 23:18:09","reservation_modified_date_time":"2021-04-23 13:12:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119593","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":"3243105","reservation_id":"107777","confirmation_number":"SJ12623686254","room_confirmation_number":"SJ12668344605","room_stay_from":"2021-04-28","room_stay_to":"2021-05-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120723","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-16 10:59:04","reservation_modified_date_time":"2021-04-28 16:09:36","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":"3243529","reservation_id":"109578","confirmation_number":"SJ12692646066","room_confirmation_number":"SJ12675188151","room_stay_from":"2021-04-28","room_stay_to":"2021-05-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"116059","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-06 16:02:22","reservation_modified_date_time":"2021-04-28 22:58:01","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116059","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":"3231993","reservation_id":"109124","confirmation_number":"SJ12699191686","room_confirmation_number":"SJ12616237128","room_stay_from":"2021-04-28","room_stay_to":"2021-05-02","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":"115597","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 15:02:10","reservation_modified_date_time":"2021-04-10 17:40:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115597","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":"3185833","reservation_id":"95536","confirmation_number":"SJ12671781895","room_confirmation_number":"SJ12645800076","room_stay_from":"2021-04-23","room_stay_to":"2021-05-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101721","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 14:11:36","reservation_modified_date_time":"2021-01-27 21:49:53","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":"3203104","reservation_id":"108281","confirmation_number":"SJ12626701386","room_confirmation_number":"SJ12636974410","room_stay_from":"2021-04-28","room_stay_to":"2021-05-03","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"114740","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 17:23:07","reservation_modified_date_time":"2021-02-23 00:03:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114740","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":"3206544","reservation_id":"108625","confirmation_number":"SJ12655239094","room_confirmation_number":"SJ12656346023","room_stay_from":"2021-04-26","room_stay_to":"2021-05-03","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"115064","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 04:07:10","reservation_modified_date_time":"2021-03-01 01:53:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115064","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":"3241272","reservation_id":"107325","confirmation_number":"SJ12665517166","room_confirmation_number":"SJ12622239414","room_stay_from":"2021-04-28","room_stay_to":"2021-05-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"113782","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-11 01:37:11","reservation_modified_date_time":"2021-04-24 19:29:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113782","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":"3243027","reservation_id":"110161","confirmation_number":"SJ12686759595","room_confirmation_number":"SJ12642208559","room_stay_from":"2021-04-28","room_stay_to":"2021-05-03","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116672","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-12 21:57:08","reservation_modified_date_time":"2021-04-28 14:09:03","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116672","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":"3229910","reservation_id":"95534","confirmation_number":"SJ12670678562","room_confirmation_number":"SJ12616649969","room_stay_from":"2021-04-23","room_stay_to":"2021-05-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"350.00","grand_total":"393.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111672","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 14:06:38","reservation_modified_date_time":"2021-04-07 18:29: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":"3242969","reservation_id":"112367","confirmation_number":"SJ12667184582","room_confirmation_number":"SJ12698783291","room_stay_from":"2021-06-07","room_stay_to":"2021-06-10","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"118935","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 17:31:48","reservation_modified_date_time":"2021-04-28 12:49:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118935","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3243074","reservation_id":"105915","confirmation_number":"SJ12655626972","room_confirmation_number":"SJ12675456963","room_stay_from":"2021-04-26","room_stay_to":"2021-04-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"112332","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-23 03:41:59","reservation_modified_date_time":"2021-04-28 15:28:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3243298","reservation_id":"114114","confirmation_number":"SJ12685114436","room_confirmation_number":"SJ12640974844","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"15.00","paid_amount":"15.00","product_id":"1654","service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-28 21:44:08","reservation_modified_date_time":"2021-04-28 21:44:08","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"13.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3243563","reservation_id":"114128","confirmation_number":"SJ12625415163","room_confirmation_number":"SJ12687267941","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"29.99","grand_total":"32.24","paid_amount":"32.24","product_id":"1664","service_quantity":"1","product_name":"Beach Buggy package","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-29 01:35:23","reservation_modified_date_time":"2021-04-29 01:35:23","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":"29.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3243148","reservation_id":"113656","confirmation_number":"SJ12638126617","room_confirmation_number":"SJ12633417059","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"75.00","paid_amount":"75.00","product_id":"1704","service_quantity":"1","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-28 17:25:30","reservation_modified_date_time":"2021-04-28 17:25:30","customer_id":"120256","parentCustTravId":"120256","customer_traveller_id":"120256","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-04-25","sub_hotel_id":"0","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}