{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-08-05","total_rooms_exist":"1281,1282,1289,1274,1275,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":1,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1307","block_room_bookings":[{"confirmation_number":"SJ12676533150","room_stay_from":"2020-07-31","room_stay_to":"2020-08-15","bundle_room":"0"}],"bundle_block_count":"1269,1270,1260,1261,1267,1268,1309,1310,1304,1305,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12630789337","room_stay_from":"2020-08-03","room_stay_to":"2020-08-06","bundle_room":"0"},{"confirmation_number":"SJB12643243079","room_stay_from":"2020-08-03","room_stay_to":"2020-08-06","bundle_room":"0"},{"confirmation_number":"SJB12660177242","room_stay_from":"2020-08-05","room_stay_to":"2020-08-06","bundle_room":"1"},{"confirmation_number":"SJB12692569463","room_stay_from":"2020-08-03","room_stay_to":"2020-08-07","bundle_room":"1"},{"confirmation_number":"SJB12675379331","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","bundle_room":"0"},{"confirmation_number":"SJB12692328099","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","bundle_room":"0"},{"confirmation_number":"SJB12656450728","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","bundle_room":"0"},{"confirmation_number":"SJB12684822863","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","bundle_room":"0"},{"confirmation_number":"SJB12664178015","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3123886","reservation_id":"96162","confirmation_number":"SJ12646161852","room_stay_from":"2020-08-05","room_stay_to":"2020-08-06","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"103","nightly_discount":"0","subtotal":"103.00","grand_total":"115.88","paid_amount":"115.88","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-3516994715","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104643","customer_id":"102289","source_of_creation":"Booking.com","reservation_created_date":"2020-06-09 15:44:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"27.54","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103","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":"3122818","reservation_id":"95382","confirmation_number":"SJ12650481444","room_stay_from":"2020-08-03","room_stay_to":"2020-08-09","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.00,123.00,123.00,123.00,143.00,143.00","nightly_discount":"0,0,0,0,0,0","subtotal":"778.00","grand_total":"875.25","paid_amount":"0.00","room_type_id":"413","product_id":"1268","siteminder_id":"BDC-2359762740","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":"101573","customer_id":"101573","source_of_creation":"Booking.com","reservation_created_date":"2020-05-25 16:53:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"167.04","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"123.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3123893","reservation_id":"96104","confirmation_number":"SJ12621908645","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.00,163.00,163.00,163.00","nightly_discount":"0,0,0,0","subtotal":"652.00","grand_total":"733.50","paid_amount":"733.50","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3362490097","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":"102227","customer_id":"102227","source_of_creation":"Booking.com","reservation_created_date":"2020-06-08 16:34:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"67.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"163.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3106490","reservation_id":"96690","confirmation_number":"SJ12617488454","room_stay_from":"2020-08-03","room_stay_to":"2020-08-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"85.76,85.76,85.76,85.76","nightly_discount":"0,0,0,0","subtotal":"343.04","grand_total":"385.92","paid_amount":"385.92","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1671399307","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":"102807","customer_id":"102807","source_of_creation":"Expedia","reservation_created_date":"2020-06-17 04:19:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.76","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":"3119625","reservation_id":"96466","confirmation_number":"SJ12613473386","room_stay_from":"2020-08-02","room_stay_to":"2020-08-07","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"102.2,102.2,102.2,102.2,102.2","nightly_discount":"0,0,0,0,0","subtotal":"511.00","grand_total":"574.88","paid_amount":"574.88","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1670501717","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":"102577","customer_id":"102577","source_of_creation":"Expedia","reservation_created_date":"2020-06-14 00:51:08","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":"","currentDayPrice":"102.2","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3095227","reservation_id":"95064","confirmation_number":"SJ12610097089","room_stay_from":"2020-08-03","room_stay_to":"2020-08-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.48,116.48,116.48,116.48,129.28","nightly_discount":"0,0,0,0,0","subtotal":"595.20","grand_total":"669.60","paid_amount":"669.60","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1664872652","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":"101248","customer_id":"101248","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 20:22:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"116.48","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3115659","reservation_id":"97736","confirmation_number":"SJ12689309101","room_stay_from":"2020-08-03","room_stay_to":"2020-08-06","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"305.32,349.52,349.52","nightly_discount":"0.00,0.00,0.00","subtotal":"1004.36","grand_total":"1129.91","paid_amount":"0.00","room_type_id":"320","product_id":"1323","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":"103805","customer_id":"103805","source_of_creation":"FE","reservation_created_date":"2020-07-13 20:25:12","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"349.52","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3122371","reservation_id":"97321","confirmation_number":"SJ12636451373","room_stay_from":"2020-08-05","room_stay_to":"2020-08-08","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"197.20,197.20,290.00","nightly_discount":"0.00,0.00,0.00","subtotal":"684.40","grand_total":"769.95","paid_amount":"221.85","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":"103405","customer_id":"103405","source_of_creation":"FE","reservation_created_date":"2020-07-02 22:14:08","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":"","currentDayPrice":"197.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3123058","reservation_id":"97519","confirmation_number":"SJ12612819897","room_stay_from":"2020-08-02","room_stay_to":"2020-08-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"235.00,115.60,115.60,159.80,159.80,159.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"945.60","grand_total":"1063.80","paid_amount":"1063.80","room_type_id":"412","product_id":"1866","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102907","customer_id":"102907","source_of_creation":"FE","reservation_created_date":"2020-07-07 22:39:08","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":"","currentDayPrice":"159.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3118873","reservation_id":"96682","confirmation_number":"SJ12622883041","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.29,122.29,164.29,164.29","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"573.16","grand_total":"644.81","paid_amount":"644.81","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":"102798","customer_id":"102798","source_of_creation":"FE","reservation_created_date":"2020-06-17 01:17:49","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":"","currentDayPrice":"122.29","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3122383","reservation_id":"98302","confirmation_number":"SJ12681986093","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"197.20,197.20,290.00,290.00","nightly_discount":"19.70,19.70,29.00,29.00","subtotal":"974.40","grand_total":"986.63","paid_amount":"986.63","room_type_id":"412","product_id":"1315","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":"104343","customer_id":"104343","source_of_creation":"FE","reservation_created_date":"2020-07-29 01:09:49","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"197.20","currentDayDiscount":"19.70","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3122406","reservation_id":"98301","confirmation_number":"SJ12676034400","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"218.28,218.28,321.00,321.00","nightly_discount":"21.82,21.82,32.10,32.10","subtotal":"1078.56","grand_total":"1092.06","paid_amount":"1092.06","room_type_id":"412","product_id":"1316","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":"75813","customer_id":"75813","source_of_creation":"FE","reservation_created_date":"2020-07-29 00:33:29","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":"","currentDayPrice":"218.28","currentDayDiscount":"21.82","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3122342","reservation_id":"96787","confirmation_number":"SJ12675103220","room_stay_from":"2020-08-02","room_stay_to":"2020-08-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.28,113.28,113.28,113.28,113.28,113.28,133.34,133.34,133.34,121.22,113.28,113.28,113.28","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","subtotal":"1540.76","grand_total":"1733.36","paid_amount":"1733.36","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102907","customer_id":"102907","source_of_creation":"FE","reservation_created_date":"2020-06-18 19:48:21","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":"","currentDayPrice":"113.28","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3123823","reservation_id":"98627","confirmation_number":"SJ12630767011","room_stay_from":"2020-08-05","room_stay_to":"2020-08-08","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"172.20,172.20,290.00","nightly_discount":"0.00,0.00,0.00","subtotal":"634.40","grand_total":"713.70","paid_amount":"713.70","room_type_id":"319","product_id":"1319","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":"104636","customer_id":"104636","source_of_creation":"PMS","reservation_created_date":"2020-08-05 21:01:21","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103604","reservation_id":"96212","confirmation_number":"SJ12646842827","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.29,122.29,149.35,149.35","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"543.28","grand_total":"611.19","paid_amount":"611.19","room_type_id":"319","product_id":"1274","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":"102334","customer_id":"102334","source_of_creation":"PMS","reservation_created_date":"2020-06-10 12:40:04","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"122.29","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3106643","reservation_id":"96713","confirmation_number":"SJ12687422248","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"286.58,286.58,286.58,286.58","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1146.32","grand_total":"1289.61","paid_amount":"1289.61","room_type_id":"320","product_id":"1910","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102827","customer_id":"102827","source_of_creation":"PMS","reservation_created_date":"2020-06-17 16:49:54","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"286.58","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3120941","reservation_id":"98102","confirmation_number":"SJ12617737440","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"349.52,349.52,514.00,514.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1727.04","grand_total":"1942.92","paid_amount":"1942.92","room_type_id":"320","product_id":"1329","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104168","customer_id":"104168","source_of_creation":"PMS","reservation_created_date":"2020-07-23 18:56:20","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"349.52","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3123254","reservation_id":"97915","confirmation_number":"SJ12673220645","room_stay_from":"2020-08-04","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.60,141.60,141.60,245.00,245.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"914.80","grand_total":"1029.15","paid_amount":"1029.15","room_type_id":"319","product_id":"1942","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":"103987","customer_id":"103987","source_of_creation":"PMS","reservation_created_date":"2020-07-18 18:33:56","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"141.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3123857","reservation_id":"98044","confirmation_number":"SJ12669786862","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.40,166.60,166.60,166.60","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"622.20","grand_total":"699.98","paid_amount":"699.98","room_type_id":"319","product_id":"1943","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104109","customer_id":"104109","source_of_creation":"PMS","reservation_created_date":"2020-07-22 15:06:54","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"122.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3122211","reservation_id":"96895","confirmation_number":"SJ12654328430","room_stay_from":"2020-08-03","room_stay_to":"2020-08-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"130.27,130.27,130.27,130.27,153.34,153.34,153.34","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"981.10","grand_total":"1103.74","paid_amount":"1103.74","room_type_id":"319","product_id":"1308","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":"103017","customer_id":"103017","source_of_creation":"PMS","reservation_created_date":"2020-06-21 13:48:21","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":"","currentDayPrice":"130.27","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3115080","reservation_id":"95815","confirmation_number":"SJ12638681997","room_stay_from":"2020-07-31","room_stay_to":"2020-08-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1756","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":"2020-06-02 18:17:24","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":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3123888","reservation_id":"96162","confirmation_number":"SJ12672646378","room_confirmation_number":"SJ12646161852","room_stay_from":"2020-08-05","room_stay_to":"2020-08-06","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"104643","product_attribute_values":"extra_person#","reservation_created_date":"2020-08-06 01:55:20","reservation_modified_date_time":"2020-08-06 01:55:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102289","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","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":"3119626","reservation_id":"96466","confirmation_number":"SJ12622837688","room_confirmation_number":"SJ12613473386","room_stay_from":"2020-08-02","room_stay_to":"2020-08-07","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":"1777","service_quantity":"1","customer_traveller_id":"102577","product_attribute_values":"extra_person#","reservation_created_date":"2020-07-24 19:51:25","reservation_modified_date_time":"2020-07-24 19:51:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102577","canceled_nights_data":"","posAmt_airbnb_taxpaid":"125.00","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":"3123866","reservation_id":"98390","confirmation_number":"SJ12648762886","room_confirmation_number":"SJ12633062975","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"104414","product_attribute_values":"extra_person#","reservation_created_date":"2020-08-06 00:29:26","reservation_modified_date_time":"2020-08-06 00:29:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104414","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","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":"3115660","reservation_id":"97736","confirmation_number":"SJ12649764952","room_confirmation_number":"SJ12689309101","room_stay_from":"2020-08-03","room_stay_to":"2020-08-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103805","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-07-13 20:25:12","reservation_modified_date_time":"2020-07-13 20:25:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103805","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123889","reservation_id":"96162","confirmation_number":"SJ12671183722","room_confirmation_number":"SJ12646161852","room_stay_from":"2020-08-05","room_stay_to":"2020-08-06","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":"104643","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-09 15:44:11","reservation_modified_date_time":"2020-08-06 01:55:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102289","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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":"3106491","reservation_id":"96690","confirmation_number":"SJ12693917613","room_confirmation_number":"SJ12617488454","room_stay_from":"2020-08-03","room_stay_to":"2020-08-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"102807","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-17 04:19:10","reservation_modified_date_time":"2020-06-17 04:19:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102807","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3115081","reservation_id":"95815","confirmation_number":"SJ12654142157","room_confirmation_number":"SJ12638681997","room_stay_from":"2020-07-31","room_stay_to":"2020-08-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"101971","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-02 18:17:24","reservation_modified_date_time":"2020-07-11 21:38:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3119627","reservation_id":"96466","confirmation_number":"SJ12666823217","room_confirmation_number":"SJ12613473386","room_stay_from":"2020-08-02","room_stay_to":"2020-08-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"102577","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-14 00:51:08","reservation_modified_date_time":"2020-07-24 19:51:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102577","canceled_nights_data":"","posAmt_airbnb_taxpaid":"125.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":"3095228","reservation_id":"95064","confirmation_number":"SJ12668537449","room_confirmation_number":"SJ12610097089","room_stay_from":"2020-08-03","room_stay_to":"2020-08-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"101248","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-19 20:22:09","reservation_modified_date_time":"2020-05-19 20:22:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101248","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122372","reservation_id":"97321","confirmation_number":"SJ12621991815","room_confirmation_number":"SJ12636451373","room_stay_from":"2020-08-05","room_stay_to":"2020-08-08","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":"103405","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-07-02 22:14:08","reservation_modified_date_time":"2020-08-01 00:19:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103405","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123060","reservation_id":"97519","confirmation_number":"SJ12680320343","room_confirmation_number":"SJ12612819897","room_stay_from":"2020-08-02","room_stay_to":"2020-08-08","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":"102907","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-07-07 22:39:08","reservation_modified_date_time":"2020-08-03 01:05:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102907","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123824","reservation_id":"98627","confirmation_number":"SJ12622765509","room_confirmation_number":"SJ12630767011","room_stay_from":"2020-08-05","room_stay_to":"2020-08-08","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":"104636","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-05 21:01:21","reservation_modified_date_time":"2020-08-05 21:01:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104636","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3103605","reservation_id":"96212","confirmation_number":"SJ12641402250","room_confirmation_number":"SJ12646842827","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"102334","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-10 12:40:04","reservation_modified_date_time":"2020-06-10 12:40:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102334","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3106644","reservation_id":"96713","confirmation_number":"SJ12664900531","room_confirmation_number":"SJ12687422248","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"102827","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-17 16:49:54","reservation_modified_date_time":"2020-06-17 16:49:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102827","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3118874","reservation_id":"96682","confirmation_number":"SJ12626044277","room_confirmation_number":"SJ12622883041","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"102798","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-17 01:17:49","reservation_modified_date_time":"2020-07-22 18:46:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102798","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3120944","reservation_id":"98102","confirmation_number":"SJ12648224084","room_confirmation_number":"SJ12617737440","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"104168","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-07-23 18:56:20","reservation_modified_date_time":"2020-07-28 13:06:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104168","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122384","reservation_id":"98302","confirmation_number":"SJ12696717874","room_confirmation_number":"SJ12681986093","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"104343","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-07-29 01:09:49","reservation_modified_date_time":"2020-08-01 00:27:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104343","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122407","reservation_id":"98301","confirmation_number":"SJ12619550442","room_confirmation_number":"SJ12676034400","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"75813","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-07-29 00:33:29","reservation_modified_date_time":"2020-08-01 00:53:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75813","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122820","reservation_id":"95382","confirmation_number":"SJ12615023273","room_confirmation_number":"SJ12650481444","room_stay_from":"2020-08-03","room_stay_to":"2020-08-09","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"101573","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-25 16:53:07","reservation_modified_date_time":"2020-08-02 15:42:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101573","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123255","reservation_id":"97915","confirmation_number":"SJ12632743307","room_confirmation_number":"SJ12673220645","room_stay_from":"2020-08-04","room_stay_to":"2020-08-09","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":"103987","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-07-18 18:33:56","reservation_modified_date_time":"2020-08-03 20:38:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103987","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123858","reservation_id":"98044","confirmation_number":"SJ12615981853","room_confirmation_number":"SJ12669786862","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"104109","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-07-22 15:06:54","reservation_modified_date_time":"2020-08-06 00:22:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104109","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123895","reservation_id":"96104","confirmation_number":"SJ12631904807","room_confirmation_number":"SJ12621908645","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","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":"102227","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-08 16:34:09","reservation_modified_date_time":"2020-08-06 01:55:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102227","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122212","reservation_id":"96895","confirmation_number":"SJ12682877626","room_confirmation_number":"SJ12654328430","room_stay_from":"2020-08-03","room_stay_to":"2020-08-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"103017","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-21 13:48:21","reservation_modified_date_time":"2020-07-31 22:09:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103017","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122343","reservation_id":"96787","confirmation_number":"SJ12640729762","room_confirmation_number":"SJ12675103220","room_stay_from":"2020-08-02","room_stay_to":"2020-08-15","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","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","subtotal":"325.00","grand_total":"365.63","paid_amount":"365.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"102907","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-18 19:48:21","reservation_modified_date_time":"2020-07-31 23:09:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102907","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3123844","reservation_id":"98633","confirmation_number":"SJ12627803168","room_confirmation_number":"SJ12651009498","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"45.00","paid_amount":"45.00","product_id":null,"service_quantity":"3","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-05 23:03:53","reservation_modified_date_time":"2020-08-05 23:03:53","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,"currentDayPrice":"41.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[{"room_stay_id":"3123881","reservation_id":"96690","confirmation_number":"SJ12676181014","room_confirmation_number":"SJ12617488454","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"0.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-06 01:38:11","reservation_modified_date_time":"2020-08-06 01:38:11","customer_id":"102807","parentCustTravId":"102807","customer_traveller_id":"102807","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}