{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-07-31","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":31,"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,1302,1303,1304,1305,1267,1268,1311,1312,1262,1263,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12655547477","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","bundle_room":"0"},{"confirmation_number":"SJB12658861740","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","bundle_room":"0"},{"confirmation_number":"SJB12664803865","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","bundle_room":"0"},{"confirmation_number":"SJB12669527704","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","bundle_room":"0"},{"confirmation_number":"SJB12620449785","room_stay_from":"2020-07-31","room_stay_to":"2020-08-01","bundle_room":"1"},{"confirmation_number":"SJB12693490839","room_stay_from":"2020-07-31","room_stay_to":"2020-08-01","bundle_room":"1"},{"confirmation_number":"SJB12679187448","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","bundle_room":"1"},{"confirmation_number":"SJB12632608652","room_stay_from":"2020-07-30","room_stay_to":"2020-08-02","bundle_room":"1"},{"confirmation_number":"SJB12656611283","room_stay_from":"2020-07-31","room_stay_to":"2020-08-02","bundle_room":"1"},{"confirmation_number":"SJB12667137547","room_stay_from":"2020-07-31","room_stay_to":"2020-08-05","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3120572","reservation_id":"92849","confirmation_number":"SJ12681495794","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"426.00,426.00,426.00,438.00,467.99","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"2183.99","grand_total":"2456.99","paid_amount":"2456.99","room_type_id":"320","product_id":"1320","siteminder_id":"BDC-2450614903","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":"99001","customer_id":"99001","source_of_creation":"Booking.com","reservation_created_date":"2020-03-02 02:38:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","ota_service_fee_amount":"0","commision_charges":"415.62","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"467.99","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":"3120914","reservation_id":"96753","confirmation_number":"SJ12662071440","room_stay_from":"2020-07-31","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"243.20,153.00","nightly_discount":"0.00,0.00","subtotal":"396.20","grand_total":"445.73","paid_amount":"445.73","room_type_id":"413","product_id":"1262","siteminder_id":"BDC-2625169346","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":"102871","customer_id":"102871","source_of_creation":"Booking.com","reservation_created_date":"2020-06-18 13:59:14","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"80.31","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"243.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":"3120918","reservation_id":"96753","confirmation_number":"SJ12667801643","room_stay_from":"2020-07-31","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"243.20,153.00","nightly_discount":"0,0","subtotal":"396.20","grand_total":"445.73","paid_amount":"445.73","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-2625169346","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":"102871","customer_id":"102871","source_of_creation":"Booking.com","reservation_created_date":"2020-06-18 13:59:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"160.63","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"243.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":"3122018","reservation_id":"93587","confirmation_number":"SJ12696472420","room_stay_from":"2020-07-25","room_stay_to":"2020-07-31","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"247.20,119.20,119.20,186.40,186.40,342.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1200.80","grand_total":"1350.90","paid_amount":"1379.03","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3169083708","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":"99816","customer_id":"99816","source_of_creation":"Booking.com","reservation_created_date":"2020-03-24 21:57:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"247.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"151.20","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":"3122061","reservation_id":"96104","confirmation_number":"SJ12621908645","room_stay_from":"2020-08-05","room_stay_to":"2020-08-09","room_stay_status":"Active","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":"183.38","room_type_id":"413","product_id":"1261","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 207","ota_service_fee_amount":"0","commision_charges":"67.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3122072","reservation_id":"96031","confirmation_number":"SJ12662652194","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"153.00,153.00,153.00","nightly_discount":"0,0,0","subtotal":"459.00","grand_total":"516.38","paid_amount":"172.13","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-3755639341","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":"102163","customer_id":"102163","source_of_creation":"Booking.com","reservation_created_date":"2020-06-07 03:55:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"64.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":[],"exp_taxable":[{"room_stay_id":"3119916","reservation_id":"95886","confirmation_number":"SJ12613318392","room_stay_from":"2020-07-30","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"163.20,188.16,91.52","nightly_discount":"0,0,0","subtotal":"442.88","grand_total":"498.24","paid_amount":"498.24","room_type_id":"319","product_id":"1311","siteminder_id":"EXP-1667883420","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":"102038","customer_id":"102038","source_of_creation":"Expedia","reservation_created_date":"2020-06-04 01:01:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"188.16","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":"3119925","reservation_id":"94440","confirmation_number":"SJ12651530268","room_stay_from":"2020-07-28","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"170.40,170.40,175.20,187.20,187.20","nightly_discount":"0,0,0,0,0","subtotal":"890.40","grand_total":"1001.70","paid_amount":"1001.70","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1662881840","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":"100657","customer_id":"100657","source_of_creation":"Expedia","reservation_created_date":"2020-05-05 11:57:06","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":"","currentDayPrice":"187.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":"3122087","reservation_id":"96523","confirmation_number":"SJ12671312898","room_stay_from":"2020-07-26","room_stay_to":"2020-07-31","room_stay_status":"Checked-Out","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"293.12,264.32,229.76,229.76,484.47","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1501.43","grand_total":"1689.11","paid_amount":"1689.11","room_type_id":"319","product_id":"1942","siteminder_id":"EXP-1670772078","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":"102629","customer_id":"102629","source_of_creation":"Expedia","reservation_created_date":"2020-06-15 02:29:09","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":"","changedComment":"To date changed","deltaChange":"254.71","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"}]}],"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":"3094799","reservation_id":"94959","confirmation_number":"SJ12673001401","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"450.00,406.00,406.00,406.00,418.00,448.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2534.00","grand_total":"2850.75","paid_amount":"2850.75","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":"101147","customer_id":"101147","source_of_creation":"FE","reservation_created_date":"2020-05-18 15:48:50","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":"448.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":"3095773","reservation_id":"95175","confirmation_number":"SJ12621544590","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.55,141.55,141.55,141.55,161.55","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"727.75","grand_total":"818.72","paid_amount":"818.72","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":"101357","customer_id":"101357","source_of_creation":"FE","reservation_created_date":"2020-05-21 04:51:04","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":"161.55","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":"3120869","reservation_id":"95034","confirmation_number":"SJ12625364498","room_stay_from":"2020-07-28","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.55,122.55,122.55,142.55","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"510.20","grand_total":"573.98","paid_amount":"573.98","room_type_id":"319","product_id":"1303","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":"101222","customer_id":"101222","source_of_creation":"FE","reservation_created_date":"2020-05-19 13:10:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"142.55","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":"3120898","reservation_id":"91985","confirmation_number":"SJ12651278650","room_stay_from":"2020-07-28","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"193.00,193.00,199.00,214.00,214.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1013.00","grand_total":"1139.63","paid_amount":"1139.63","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":"98138","customer_id":"98138","source_of_creation":"FE","reservation_created_date":"2020-02-14 21:26:06","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":"214.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":"3122064","reservation_id":"95553","confirmation_number":"SJ12663806196","room_stay_from":"2020-07-31","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.00,152.10","nightly_discount":"0.00,0.00","subtotal":"413.10","grand_total":"464.74","paid_amount":"464.74","room_type_id":"319","product_id":"1302","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":"101735","customer_id":"101735","source_of_creation":"FE","reservation_created_date":"2020-05-28 18:16:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"261.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":"3120881","reservation_id":"95429","confirmation_number":"SJ12646568195","room_stay_from":"2020-07-31","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"249.50,145.39,145.39,127.39","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"667.67","grand_total":"751.13","paid_amount":"751.13","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":"101618","customer_id":"101618","source_of_creation":"FE","reservation_created_date":"2020-05-26 17:25:25","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":"249.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":"3122009","reservation_id":"95404","confirmation_number":"SJ12646891479","room_stay_from":"2020-07-28","room_stay_to":"2020-07-31","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"218.61,218.61,468.10","nightly_discount":"0.00,0.00,0.00","subtotal":"905.32","grand_total":"1018.49","paid_amount":"1018.49","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":"101599","customer_id":"101599","source_of_creation":"FE","reservation_created_date":"2020-05-26 01:30:36","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":"","changedComment":"To date changed","deltaChange":"249.49","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":"3122340","reservation_id":"97519","confirmation_number":"SJ12612819897","room_stay_from":"2020-08-02","room_stay_to":"2020-08-08","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","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":"264.38","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102907","customer_id":"102907","source_of_creation":"FE","reservation_created_date":"2020-07-07 22:39:08","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":"","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":"3122342","reservation_id":"96787","confirmation_number":"SJ12675103220","room_stay_from":"2020-08-02","room_stay_to":"2020-08-15","room_stay_status":"Active","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":"127.44","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":"","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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3105741","reservation_id":"96540","confirmation_number":"SJ12648416794","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.72,125.72,125.72,125.71,125.71,125.71,125.71","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"990.00","paid_amount":"0.00","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":"84637","customer_id":"84637","source_of_creation":"PMS","reservation_created_date":"2020-06-15 15:05:07","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":"125.71","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":"3107233","reservation_id":"96781","confirmation_number":"SJ12695511614","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"318.02,276.54,276.54,276.54,315.62","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1463.26","grand_total":"1646.16","paid_amount":"1646.16","room_type_id":"412","product_id":"1921","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":"102893","customer_id":"102893","source_of_creation":"PMS","reservation_created_date":"2020-06-18 17:27:58","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"315.62","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":"3120736","reservation_id":"98038","confirmation_number":"SJ12699571263","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"142.80,191.25,191.25,191.25,290.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1006.55","grand_total":"1132.37","paid_amount":"1132.37","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":"104104","customer_id":"104104","source_of_creation":"PMS","reservation_created_date":"2020-07-22 14:03:18","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":"","currentDayPrice":"290.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":"3120815","reservation_id":"95305","confirmation_number":"SJ12647863510","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"159.32,159.32,184.02,184.02,185.32","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"872.00","grand_total":"981.00","paid_amount":"981.00","room_type_id":"413","product_id":"1266","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":"101491","customer_id":"101491","source_of_creation":"PMS","reservation_created_date":"2020-05-23 21:10:05","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":"185.32","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":"3120920","reservation_id":"97040","confirmation_number":"SJ12638294452","room_stay_from":"2020-07-28","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"213.75,213.75,213.75,278.75","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"920.00","grand_total":"1035.00","paid_amount":"1035.00","room_type_id":"319","product_id":"1304","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":"104118","customer_id":"104118","source_of_creation":"PMS","reservation_created_date":"2020-06-24 17:37:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"278.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":"3121150","reservation_id":"97923","confirmation_number":"SJ12691012852","room_stay_from":"2020-07-30","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"241.40,349.00","nightly_discount":"24.10,34.90","subtotal":"590.40","grand_total":"597.83","paid_amount":"597.83","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103159","customer_id":"103159","source_of_creation":"PMS","reservation_created_date":"2020-07-18 19:47:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"349.00","currentDayDiscount":"34.90","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3119927","reservation_id":"97689","confirmation_number":"SJ12668652431","room_stay_from":"2020-07-25","room_stay_to":"2020-08-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"221.60,133.96,133.96,180.20,180.20,180.20,277.00,277.00,144.16","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1728.28","grand_total":"1944.31","paid_amount":"1944.31","room_type_id":"413","product_id":"1264","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":"103760","customer_id":"103760","source_of_creation":"PMS","reservation_created_date":"2020-07-12 12:33:42","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":"","currentDayPrice":"277.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":"3120304","reservation_id":"97825","confirmation_number":"SJ12666215686","room_stay_from":"2020-07-30","room_stay_to":"2020-08-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.00,290.00,290.00,153.00","nightly_discount":"21.10,0.00,0.00,0.00","subtotal":"944.00","grand_total":"1038.27","paid_amount":"1038.27","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":"84865","customer_id":"84865","source_of_creation":"PMS","reservation_created_date":"2020-07-16 19:27:15","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":"290.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":"3121916","reservation_id":"98285","confirmation_number":"SJ12691641913","room_stay_from":"2020-07-31","room_stay_to":"2020-08-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"245.00,245.00,122.40","nightly_discount":"0.00,0.00,0.00","subtotal":"612.40","grand_total":"688.95","paid_amount":"688.95","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":"104325","customer_id":"104325","source_of_creation":"PMS","reservation_created_date":"2020-07-28 18:23:40","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":"245.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":"3121906","reservation_id":"97915","confirmation_number":"SJ12673220645","room_stay_from":"2020-08-04","room_stay_to":"2020-08-09","room_stay_status":"Active","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":"137.70","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103987","customer_id":"103987","source_of_creation":"PMS","reservation_created_date":"2020-07-18 18:33:56","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]}],"pms_non_taxable":[{"room_stay_id":"3121914","reservation_id":"97118","confirmation_number":"SJ12648875545","room_stay_from":"2020-07-25","room_stay_to":"2020-07-30","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","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","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":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-26 17:53:20","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":"","changedComment":"To date changed","deltaChange":"0.00","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"}]}],"negotiated_taxable":[{"room_stay_id":"3107838","reservation_id":"83912","confirmation_number":"SJ12695888446","room_stay_from":"2020-07-31","room_stay_to":"2020-08-07","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.83,76.83,76.83,76.83,76.83,76.83,76.83","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"537.81","grand_total":"605.04","paid_amount":"0.00","room_type_id":"319","product_id":"1287","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":"2019-09-11 12:32:37","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":"","currentDayPrice":"76.83","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":"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":[{"room_stay_id":"3105999","reservation_id":"96588","confirmation_number":"SJ12693034191","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","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":"2020-06-16 01:36:52","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":"","currentDayPrice":"77.86","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":"3106004","reservation_id":"96589","confirmation_number":"SJ12655511190","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"413","product_id":"1273","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-06-16 01:38:33","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","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":"3107011","reservation_id":"96590","confirmation_number":"SJ12696030417","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"413","product_id":"1267","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-06-16 01:39:59","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":"77.86","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":"3107020","reservation_id":"96591","confirmation_number":"SJ12644077479","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"196.88","room_type_id":"413","product_id":"1268","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-06-16 01:44:03","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.86","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":"3121789","reservation_id":"98385","confirmation_number":"SJ12624245050","room_stay_from":"2020-07-30","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.00","paid_amount":"140.63","room_type_id":"319","product_id":"1917","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-07-30 20:06:08","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":"","currentDayPrice":"78.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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3094800","reservation_id":"94959","confirmation_number":"SJ12649441442","room_confirmation_number":"SJ12673001401","room_stay_from":"2020-07-26","room_stay_to":"2020-08-01","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":"101147","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 15:48:50","reservation_modified_date_time":"2020-05-18 15:48:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101147","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":"3095774","reservation_id":"95175","confirmation_number":"SJ12667231092","room_confirmation_number":"SJ12621544590","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.62","paid_amount":"140.62","product_id":"1776","service_quantity":"1","customer_traveller_id":"101357","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-21 04:51:04","reservation_modified_date_time":"2020-05-21 04:51:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101357","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":"3105742","reservation_id":"96540","confirmation_number":"SJ12647498418","room_confirmation_number":"SJ12648416794","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102647","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 15:05:07","reservation_modified_date_time":"2020-06-15 15:05:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84637","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3106000","reservation_id":"96588","confirmation_number":"SJ12686722107","room_confirmation_number":"SJ12693034191","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"102702","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:36:52","reservation_modified_date_time":"2020-06-16 01:36:52","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3106005","reservation_id":"96589","confirmation_number":"SJ12684164813","room_confirmation_number":"SJ12655511190","room_stay_from":"2020-07-25","room_stay_to":"2020-08-01","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":"102703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:38:33","reservation_modified_date_time":"2020-06-16 01:38:33","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3107234","reservation_id":"96781","confirmation_number":"SJ12650398627","room_confirmation_number":"SJ12695511614","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"102893","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 17:27:58","reservation_modified_date_time":"2020-06-18 17:30:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102893","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":"3120575","reservation_id":"92849","confirmation_number":"SJ12694888233","room_confirmation_number":"SJ12681495794","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"99001","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-02 02:38:08","reservation_modified_date_time":"2020-07-27 12:11:56","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99001","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":"3120737","reservation_id":"98038","confirmation_number":"SJ12650729354","room_confirmation_number":"SJ12699571263","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"104104","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-22 14:03:18","reservation_modified_date_time":"2020-07-27 19:27:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104104","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":"3120816","reservation_id":"95305","confirmation_number":"SJ12695131965","room_confirmation_number":"SJ12647863510","room_stay_from":"2020-07-27","room_stay_to":"2020-08-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"101491","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-23 21:10:05","reservation_modified_date_time":"2020-07-27 22:46:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101491","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":"3120873","reservation_id":"95034","confirmation_number":"SJ12673728709","room_confirmation_number":"SJ12625364498","room_stay_from":"2020-07-28","room_stay_to":"2020-08-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"101222","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 13:10:28","reservation_modified_date_time":"2020-07-28 12:00:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101222","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":"3120922","reservation_id":"97040","confirmation_number":"SJ12646307665","room_confirmation_number":"SJ12638294452","room_stay_from":"2020-07-28","room_stay_to":"2020-08-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"104118","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-24 17:37:18","reservation_modified_date_time":"2020-07-28 12:08:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104118","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":"3121151","reservation_id":"97923","confirmation_number":"SJ12648318547","room_confirmation_number":"SJ12691012852","room_stay_from":"2020-07-30","room_stay_to":"2020-08-01","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":"103993","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-18 19:47:52","reservation_modified_date_time":"2020-07-28 20:01:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103159","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":"3107014","reservation_id":"96590","confirmation_number":"SJ12626622188","room_confirmation_number":"SJ12696030417","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102704","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:39:59","reservation_modified_date_time":"2020-06-18 12:41:46","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3107022","reservation_id":"96591","confirmation_number":"SJ12624927899","room_confirmation_number":"SJ12644077479","room_stay_from":"2020-07-26","room_stay_to":"2020-08-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102704","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:44:03","reservation_modified_date_time":"2020-06-18 12:45:58","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3119918","reservation_id":"95886","confirmation_number":"SJ12687071353","room_confirmation_number":"SJ12613318392","room_stay_from":"2020-07-30","room_stay_to":"2020-08-02","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":"102038","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-04 01:01:06","reservation_modified_date_time":"2020-07-25 17:31:34","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102038","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":"3119926","reservation_id":"94440","confirmation_number":"SJ12683036904","room_confirmation_number":"SJ12651530268","room_stay_from":"2020-07-28","room_stay_to":"2020-08-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"100657","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-05 11:57:06","reservation_modified_date_time":"2020-07-25 17:33:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100657","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":"3120899","reservation_id":"91985","confirmation_number":"SJ12683377335","room_confirmation_number":"SJ12651278650","room_stay_from":"2020-07-28","room_stay_to":"2020-08-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"98138","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-14 21:26:06","reservation_modified_date_time":"2020-07-28 12:04:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98138","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":"3120917","reservation_id":"96753","confirmation_number":"SJ12611260706","room_confirmation_number":"SJ12662071440","room_stay_from":"2020-07-31","room_stay_to":"2020-08-02","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":"102871","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 13:59:14","reservation_modified_date_time":"2020-07-28 12:07:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102871","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":"3120919","reservation_id":"96753","confirmation_number":"SJ12641418680","room_confirmation_number":"SJ12667801643","room_stay_from":"2020-07-31","room_stay_to":"2020-08-02","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":"102871","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 13:59:10","reservation_modified_date_time":"2020-07-28 12:07:44","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102871","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":"3122066","reservation_id":"95553","confirmation_number":"SJ12625091852","room_confirmation_number":"SJ12663806196","room_stay_from":"2020-07-31","room_stay_to":"2020-08-02","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":"101735","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-28 18:16:25","reservation_modified_date_time":"2020-07-31 16:57:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101735","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":"3119928","reservation_id":"97689","confirmation_number":"SJ12613152976","room_confirmation_number":"SJ12668652431","room_stay_from":"2020-07-25","room_stay_to":"2020-08-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"103760","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-12 12:33:42","reservation_modified_date_time":"2020-07-25 17:33:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103760","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":"3120305","reservation_id":"97825","confirmation_number":"SJ12611917303","room_confirmation_number":"SJ12666215686","room_stay_from":"2020-07-30","room_stay_to":"2020-08-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"84865","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-16 19:27:15","reservation_modified_date_time":"2020-07-26 16:28:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84865","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":"3121917","reservation_id":"98285","confirmation_number":"SJ12632814566","room_confirmation_number":"SJ12691641913","room_stay_from":"2020-07-31","room_stay_to":"2020-08-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"104325","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-28 18:23:40","reservation_modified_date_time":"2020-07-31 13:08:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104325","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":"3120883","reservation_id":"95429","confirmation_number":"SJ12615529036","room_confirmation_number":"SJ12646568195","room_stay_from":"2020-07-31","room_stay_to":"2020-08-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"101618","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 17:25:25","reservation_modified_date_time":"2020-07-28 12:02:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101618","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":"3121790","reservation_id":"98385","confirmation_number":"SJ12696178382","room_confirmation_number":"SJ12624245050","room_stay_from":"2020-07-30","room_stay_to":"2020-08-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102708","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-30 20:06:08","reservation_modified_date_time":"2020-07-30 20:06:08","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3107840","reservation_id":"83912","confirmation_number":"SJ12622661001","room_confirmation_number":"SJ12695888446","room_stay_from":"2020-07-31","room_stay_to":"2020-08-07","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"91476","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-11 12:32:37","reservation_modified_date_time":"2020-06-20 02:25:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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#&#25","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":"3121907","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103987","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-18 18:33:56","reservation_modified_date_time":"2020-07-31 12:44:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103987","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3121915","reservation_id":"97118","confirmation_number":"SJ12643657961","room_confirmation_number":"SJ12648875545","room_stay_from":"2020-07-25","room_stay_to":"2020-07-30","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":"103236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-26 17:53:20","reservation_modified_date_time":"2020-07-31 13:04:25","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.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"}]},{"room_stay_id":"3122010","reservation_id":"95404","confirmation_number":"SJ12650582676","room_confirmation_number":"SJ12646891479","room_stay_from":"2020-07-28","room_stay_to":"2020-07-31","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":"101599","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 01:30:36","reservation_modified_date_time":"2020-07-31 15:13:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101599","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.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"}]},{"room_stay_id":"3122019","reservation_id":"93587","confirmation_number":"SJ12637257008","room_confirmation_number":"SJ12696472420","room_stay_from":"2020-07-25","room_stay_to":"2020-07-31","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":"99816","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-24 21:57:09","reservation_modified_date_time":"2020-07-31 15:26:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99816","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.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"}]},{"room_stay_id":"3122063","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102227","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-08 16:34:09","reservation_modified_date_time":"2020-07-31 16:54:52","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102227","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3122074","reservation_id":"96031","confirmation_number":"SJ12627934716","room_confirmation_number":"SJ12662652194","room_stay_from":"2020-08-06","room_stay_to":"2020-08-09","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":"102163","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-07 03:55:09","reservation_modified_date_time":"2020-07-31 17:17:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102163","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3122088","reservation_id":"96523","confirmation_number":"SJ12620317592","room_confirmation_number":"SJ12671312898","room_stay_from":"2020-07-26","room_stay_to":"2020-07-31","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":"102629","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 02:29:09","reservation_modified_date_time":"2020-07-31 18:08:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102629","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.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"}]},{"room_stay_id":"3122341","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102907","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-07 22:39:08","reservation_modified_date_time":"2020-07-31 23:09:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102907","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"102907","product_attribute_values":"resort_fee#&#flat_rate#&#25","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","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3122008","reservation_id":"95404","confirmation_number":"SJ12677368617","room_confirmation_number":"SJ12646891479","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-31 15:13:22","reservation_modified_date_time":"2020-07-31 15:13:22","customer_id":"101599","parentCustTravId":"101599","customer_traveller_id":"101599","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3122020","reservation_id":"93587","confirmation_number":"SJ12643460773","room_confirmation_number":"SJ12696472420","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-31 15:26:15","reservation_modified_date_time":"2020-07-31 15:26:15","customer_id":"99816","parentCustTravId":"99816","customer_traveller_id":"99816","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3122086","reservation_id":"96523","confirmation_number":"SJ12647961599","room_confirmation_number":"SJ12671312898","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-31 18:08:26","reservation_modified_date_time":"2020-07-31 18:08:26","customer_id":"102629","parentCustTravId":"102629","customer_traveller_id":"102629","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3122116","reservation_id":"98425","confirmation_number":"SJ12646266043","room_confirmation_number":"SJ12629647851","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.99","grand_total":"16.08","paid_amount":"16.08","product_id":null,"service_quantity":"3","product_name":"Key Lime Soap","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-31 20:14:25","reservation_modified_date_time":"2020-07-31 20:14:25","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":"14.97","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3122441","reservation_id":"98459","confirmation_number":"SJ12664933182","room_confirmation_number":"SJ12636380265","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"2.50","paid_amount":"2.50","product_id":null,"service_quantity":"1","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-01 02:15:07","reservation_modified_date_time":"2020-08-01 02:15:07","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":"2.33","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":"3121919","reservation_id":"98406","confirmation_number":"SJ12648279481","room_confirmation_number":"SJ12678666380","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-31 13:10:18","reservation_modified_date_time":"2020-07-31 13:10:18","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3122440","reservation_id":"98459","confirmation_number":"SJ12684541865","room_confirmation_number":"SJ12636380265","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-01 02:15:07","reservation_modified_date_time":"2020-08-01 02:15:07","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"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":[]}}