{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-06-21","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":25,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1305,1307,1943","block_room_bookings":[{"confirmation_number":"SJ12612307368","room_stay_from":"2020-06-15","room_stay_to":"2020-07-01","bundle_room":"0"},{"confirmation_number":"SJ12664166752","room_stay_from":"2020-06-07","room_stay_to":"2020-07-04","bundle_room":"0"},{"confirmation_number":"SJ12637930546","room_stay_from":"2020-06-04","room_stay_to":"2020-07-10","bundle_room":"0"}],"bundle_block_count":"1271,1272,1311,1312,1304,1305,1269,1270,1262,1263,1260,1261,1267,1268,1307,1308,1309,1310,1291,1711,1302,1303","bundle_block_bookings":[{"confirmation_number":"SJB12615842286","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","bundle_room":"1"},{"confirmation_number":"SJB12668683309","room_stay_from":"2020-06-18","room_stay_to":"2020-06-22","bundle_room":"1"},{"confirmation_number":"SJB12663826592","room_stay_from":"2020-06-20","room_stay_to":"2020-06-22","bundle_room":"1"},{"confirmation_number":"SJB12698728869","room_stay_from":"2020-06-21","room_stay_to":"2020-06-22","bundle_room":"1"},{"confirmation_number":"SJB12658783342","room_stay_from":"2020-06-21","room_stay_to":"2020-06-22","bundle_room":"1"},{"confirmation_number":"SJB12691200533","room_stay_from":"2020-06-21","room_stay_to":"2020-06-22","bundle_room":"1"},{"confirmation_number":"SJB12656391722","room_stay_from":"2020-06-21","room_stay_to":"2020-06-24","bundle_room":"1"},{"confirmation_number":"SJB12639614415","room_stay_from":"2020-06-21","room_stay_to":"2020-06-26","bundle_room":"1"},{"confirmation_number":"SJB12684398109","room_stay_from":"2020-06-21","room_stay_to":"2020-06-26","bundle_room":"1"},{"confirmation_number":"SJB12640781917","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","bundle_room":"1"},{"confirmation_number":"SJB12670942263","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3101105","reservation_id":"95777","confirmation_number":"SJ12641027053","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.60,209.60,164.80","nightly_discount":"0,0,0","subtotal":"584.00","grand_total":"657.00","paid_amount":"657.00","room_type_id":"413","product_id":"1272","siteminder_id":"BDC-2740030028","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":"101946","customer_id":"101946","source_of_creation":"Booking.com","reservation_created_date":"2020-06-01 23:12:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"118.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"164.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103124","reservation_id":"96100","confirmation_number":"SJ12684080337","room_stay_from":"2020-06-20","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"217.60,181.60","nightly_discount":"0,0","subtotal":"399.20","grand_total":"449.10","paid_amount":"449.10","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-2830053933","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":"102223","customer_id":"102223","source_of_creation":"Booking.com","reservation_created_date":"2020-06-08 15:39:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"80.86","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"181.60","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":"3108362","reservation_id":"96490","confirmation_number":"SJ12629136237","room_stay_from":"2020-06-21","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"260.80","nightly_discount":"0","subtotal":"260.80","grand_total":"293.40","paid_amount":"293.40","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-3040979195","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":"102598","customer_id":"102598","source_of_creation":"Booking.com","reservation_created_date":"2020-06-14 17:12:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"88.63","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"260.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3108339","reservation_id":"96379","confirmation_number":"SJ12683550350","room_stay_from":"2020-06-21","room_stay_to":"2020-06-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"311.20,272.00,251.20","nightly_discount":"0.00,0.00,0.00","subtotal":"834.40","grand_total":"938.70","paid_amount":"938.70","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-2289438337","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102487","customer_id":"102487","source_of_creation":"Booking.com","reservation_created_date":"2020-06-12 20:29:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"163.69","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"311.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3097898","reservation_id":"95440","confirmation_number":"SJ12677845272","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.68,167.68,131.84","nightly_discount":"0,0,0","subtotal":"467.20","grand_total":"525.60","paid_amount":"525.60","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1666167095","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":"101626","customer_id":"102958","source_of_creation":"Expedia","reservation_created_date":"2020-05-26 22:22:05","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131.84","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3104260","reservation_id":"96285","confirmation_number":"SJ12625749709","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.80,228.80,181.60","nightly_discount":"0,0,0","subtotal":"639.20","grand_total":"719.10","paid_amount":"719.10","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1669853171","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":"102408","customer_id":"102408","source_of_creation":"Expedia","reservation_created_date":"2020-06-11 17:47:11","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":"181.60","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":"3106915","reservation_id":"96746","confirmation_number":"SJ12616203810","room_stay_from":"2020-06-20","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"208.64,181.76","nightly_discount":"0,0","subtotal":"390.40","grand_total":"439.20","paid_amount":"439.20","room_type_id":"413","product_id":"1270","siteminder_id":"EXP-1671638954","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":"102865","customer_id":"102865","source_of_creation":"Expedia","reservation_created_date":"2020-06-18 00:53:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"181.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":"3106963","reservation_id":"96127","confirmation_number":"SJ12665026335","room_stay_from":"2020-06-18","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"177.92,238.72,238.72,216.96","nightly_discount":"0,0,0,0","subtotal":"872.32","grand_total":"981.36","paid_amount":"981.36","room_type_id":"413","product_id":"1262","siteminder_id":"EXP-1669058323","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":"102254","customer_id":"102254","source_of_creation":"Expedia","reservation_created_date":"2020-06-08 21:37:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"216.96","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":"3106986","reservation_id":"96205","confirmation_number":"SJ12666669790","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.36,175.36,138.24","nightly_discount":"0,0,0","subtotal":"488.96","grand_total":"550.08","paid_amount":"550.08","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1669398131","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":"102327","customer_id":"102327","source_of_creation":"Expedia","reservation_created_date":"2020-06-10 01:36:06","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":"138.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107331","reservation_id":"96126","confirmation_number":"SJ12657704300","room_stay_from":"2020-06-18","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"177.92,238.72,238.72,216.96","nightly_discount":"0,0,0,0","subtotal":"872.32","grand_total":"981.36","paid_amount":"981.36","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1669058322","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":"102252","customer_id":"102252","source_of_creation":"Expedia","reservation_created_date":"2020-06-08 21:36:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"216.96","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":"3107992","reservation_id":"96574","confirmation_number":"SJ12696057869","room_stay_from":"2020-06-20","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"330.40,339.20","nightly_discount":"0,0","subtotal":"669.60","grand_total":"753.30","paid_amount":"753.30","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1671026373","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":"102687","customer_id":"102687","source_of_creation":"Expedia","reservation_created_date":"2020-06-15 23:24:10","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":"339.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":"3095239","reservation_id":"95067","confirmation_number":"SJ12645741926","room_stay_from":"2020-06-21","room_stay_to":"2020-06-23","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.72,78.72","nightly_discount":"0,0","subtotal":"157.44","grand_total":"177.12","paid_amount":"177.12","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1664874272","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":"101250","customer_id":"101250","source_of_creation":"Expedia","reservation_created_date":"2020-05-19 20:32:12","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":"78.72","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3106312","reservation_id":"95849","confirmation_number":"SJ12691165163","room_stay_from":"2020-06-17","room_stay_to":"2020-06-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.40,150.40,209.60,209.60,164.80,164.80","nightly_discount":"0,0,0,0,0,0","subtotal":"1049.60","grand_total":"1180.80","paid_amount":"1180.80","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1667742274","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":"102006","customer_id":"102006","source_of_creation":"Expedia","reservation_created_date":"2020-06-03 13:26:10","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":"164.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3101966","reservation_id":"95994","confirmation_number":"SJ12654465938","room_stay_from":"2020-06-21","room_stay_to":"2020-06-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.84,131.84,120.32","nightly_discount":"0,0,0","subtotal":"384.00","grand_total":"432.00","paid_amount":"432.00","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1668491987","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":"102128","customer_id":"102800","source_of_creation":"Expedia","reservation_created_date":"2020-06-06 15:11:11","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":"131.84","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3103177","reservation_id":"95993","confirmation_number":"SJ12677844021","room_stay_from":"2020-06-21","room_stay_to":"2020-06-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.84,131.84,120.32","nightly_discount":"0,0,0","subtotal":"384.00","grand_total":"432.00","paid_amount":"432.00","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1668491986","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":"102127","customer_id":"103036","source_of_creation":"Expedia","reservation_created_date":"2020-06-06 15:11:07","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":"131.84","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3107408","reservation_id":"94983","confirmation_number":"SJ12686725295","room_stay_from":"2020-06-21","room_stay_to":"2020-06-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.20,103.20,103.20,103.20","nightly_discount":"0,0,0,0","subtotal":"412.80","grand_total":"464.40","paid_amount":"464.40","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1664694924","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":"101176","customer_id":"101176","source_of_creation":"Expedia","reservation_created_date":"2020-05-18 20:26:10","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":"103.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"}]}],"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":"3104232","reservation_id":"95798","confirmation_number":"SJ12656625316","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.94,255.94,232.66","nightly_discount":"0.00,0.00,0.00","subtotal":"744.54","grand_total":"837.61","paid_amount":"837.61","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":"98138","customer_id":"98138","source_of_creation":"FE","reservation_created_date":"2020-06-02 14:18:23","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":"232.66","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":"3108055","reservation_id":"96885","confirmation_number":"SJ12633023307","room_stay_from":"2020-06-20","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"307.73,258.61","nightly_discount":"0.00,0.00","subtotal":"566.34","grand_total":"637.14","paid_amount":"637.14","room_type_id":"319","product_id":"1306","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103010","customer_id":"103010","source_of_creation":"FE","reservation_created_date":"2020-06-20 21:48:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"258.61","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":"3095067","reservation_id":"95032","confirmation_number":"SJ12663544214","room_stay_from":"2020-06-20","room_stay_to":"2020-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.20,103.20,103.20,103.20,103.20,103.20,103.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"722.40","grand_total":"812.70","paid_amount":"812.70","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":"101221","customer_id":"101221","source_of_creation":"FE","reservation_created_date":"2020-05-19 12:57:54","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":"","currentDayPrice":"103.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":"3099725","reservation_id":"94939","confirmation_number":"SJ12682977632","room_stay_from":"2020-06-21","room_stay_to":"2020-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,119.20,119.20,119.20,119.20,119.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"715.20","grand_total":"804.60","paid_amount":"804.60","room_type_id":"319","product_id":"1913","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":"85255","customer_id":"85255","source_of_creation":"FE","reservation_created_date":"2020-05-18 03:47:56","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":"119.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"}]}],"fe_non_taxable":[{"room_stay_id":"3066426","reservation_id":"91399","confirmation_number":"SJ12659921592","room_stay_from":"2020-06-21","room_stay_to":"2020-06-23","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"201.38","room_type_id":"413","product_id":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97528","customer_id":"97528","source_of_creation":"FE","reservation_created_date":"2020-02-06 02:36:25","service_canceled_date_time":"2020-06-11 02:03:46","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"201.38","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3095727","reservation_id":"90968","confirmation_number":"SJ12649617401","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"188.52,188.52,162.07","nightly_discount":"0.00,0.00,0.00","subtotal":"539.11","grand_total":"606.50","paid_amount":"606.50","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":"97060","customer_id":"97060","source_of_creation":"PMS","reservation_created_date":"2020-01-30 20:53:17","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":"162.07","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":"3102744","reservation_id":"96079","confirmation_number":"SJ12695708529","room_stay_from":"2020-06-18","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.00,183.00,183.00,183.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"732.00","grand_total":"823.50","paid_amount":"823.50","room_type_id":"319","product_id":"1312","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":"102204","customer_id":"102204","source_of_creation":"PMS","reservation_created_date":"2020-06-08 00:21:21","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"183.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":"3102747","reservation_id":"96076","confirmation_number":"SJ12619526025","room_stay_from":"2020-06-18","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"183.00,183.00,183.00,183.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"732.00","grand_total":"823.50","paid_amount":"823.50","room_type_id":"319","product_id":"1311","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":"102201","customer_id":"102201","source_of_creation":"PMS","reservation_created_date":"2020-06-07 23:52:26","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":"183.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":"3107584","reservation_id":"96214","confirmation_number":"SJ12688373079","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.05,152.43,152.43","nightly_discount":"0.00,0.00,0","subtotal":"480.91","grand_total":"541.03","paid_amount":"541.03","room_type_id":"319","product_id":"1286","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102336","customer_id":"102336","source_of_creation":"PMS","reservation_created_date":"2020-06-10 13:10:51","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":"152.43","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":"3107588","reservation_id":"96213","confirmation_number":"SJ12678997460","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"176.05,152.43,152.43","nightly_discount":"0.00,0.00,0","subtotal":"480.91","grand_total":"541.03","paid_amount":"541.03","room_type_id":"319","product_id":"1287","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":"102335","customer_id":"102335","source_of_creation":"PMS","reservation_created_date":"2020-06-10 12:58:44","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":"152.43","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":"3107960","reservation_id":"96872","confirmation_number":"SJ12667182229","room_stay_from":"2020-06-20","room_stay_to":"2020-06-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00,225.00","nightly_discount":"0.00,0.00","subtotal":"450.00","grand_total":"506.25","paid_amount":"506.25","room_type_id":"411","product_id":"1296","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":"102995","customer_id":"102995","source_of_creation":"PMS","reservation_created_date":"2020-06-20 17:00:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"225.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":"3108482","reservation_id":"96929","confirmation_number":"SJ12688032336","room_stay_from":"2020-06-21","room_stay_to":"2020-06-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.00","nightly_discount":"0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","room_type_id":"318","product_id":"1281","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":"103049","customer_id":"103049","source_of_creation":"PMS","reservation_created_date":"2020-06-22 04:22:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"175.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":"3107447","reservation_id":"96240","confirmation_number":"SJ12675192031","room_stay_from":"2020-06-20","room_stay_to":"2020-06-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.94,232.66,203.86","nightly_discount":"0.00,0.00,0.00","subtotal":"692.46","grand_total":"779.01","paid_amount":"779.01","room_type_id":"413","product_id":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102363","customer_id":"102363","source_of_creation":"PMS","reservation_created_date":"2020-06-10 19:10:29","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"232.66","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":"3106993","reservation_id":"96437","confirmation_number":"SJ12670763368","room_stay_from":"2020-06-21","room_stay_to":"2020-06-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"232.66,203.86,185.33,185.33,185.33,251.51","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1244.02","grand_total":"1399.52","paid_amount":"1399.52","room_type_id":"319","product_id":"1288","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":"84466","customer_id":"84466","source_of_creation":"PMS","reservation_created_date":"2020-06-13 18:13:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"232.66","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":[{"room_stay_id":"3105749","reservation_id":"96543","confirmation_number":"SJ12616896695","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.58,103.57,103.57,103.57,103.57,103.57,103.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"725.00","grand_total":"725.00","paid_amount":"0.00","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":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-06-15 15:30:39","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":"103.58","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":"3107426","reservation_id":"96542","confirmation_number":"SJ12694445048","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.58,103.57,103.57,103.57,103.57,103.57,103.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"725.00","grand_total":"725.00","paid_amount":"0.00","room_type_id":"319","product_id":"1309","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-15 15:25:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103.58","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"}]}],"negotiated_taxable":[{"room_stay_id":"3103208","reservation_id":"80082","confirmation_number":"SJ12616059345","room_stay_from":"2020-06-20","room_stay_to":"2020-06-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.44,84.44,84.44,84.44,84.44","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"422.20","grand_total":"474.98","paid_amount":"0.00","room_type_id":"319","product_id":"1942","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-07-03 02:11:44","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":"84.44","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":"3106981","reservation_id":"96592","confirmation_number":"SJ12629340591","room_stay_from":"2020-06-18","room_stay_to":"2020-06-23","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":"412","product_id":"1294","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:51:26","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]},{"room_stay_id":"3106991","reservation_id":"96314","confirmation_number":"SJ12611867661","room_stay_from":"2020-06-18","room_stay_to":"2020-06-23","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":"1302","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-12 01:58:49","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":"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"}]},{"room_stay_id":"3104198","reservation_id":"96312","confirmation_number":"SJ12642458919","room_stay_from":"2020-06-19","room_stay_to":"2020-06-26","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":"1308","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-12 01:54:43","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":"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":"3108283","reservation_id":"96315","confirmation_number":"SJ12684993363","room_stay_from":"2020-06-21","room_stay_to":"2020-06-26","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":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-12 02:00:40","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]},{"room_stay_id":"3104196","reservation_id":"96311","confirmation_number":"SJ12640191172","room_stay_from":"2020-06-20","room_stay_to":"2020-06-27","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":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-06-12 01:52:25","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":"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":"3097664","reservation_id":"95422","confirmation_number":"SJ12681033452","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","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":"1711","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-26 16:19:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3097667","reservation_id":"95423","confirmation_number":"SJ12669328888","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","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":"1291","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-26 16:20:36","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3095728","reservation_id":"90968","confirmation_number":"SJ12665571871","room_confirmation_number":"SJ12649617401","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","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":"97060","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 20:53:17","reservation_modified_date_time":"2020-05-20 23:28:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97060","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":"3097900","reservation_id":"95440","confirmation_number":"SJ12669336144","room_confirmation_number":"SJ12677845272","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","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":"101626","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 22:22:05","reservation_modified_date_time":"2020-05-27 14:03:55","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102958","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":"3101106","reservation_id":"95777","confirmation_number":"SJ12671256787","room_confirmation_number":"SJ12641027053","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","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":"101946","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-01 23:12:08","reservation_modified_date_time":"2020-06-04 16:22:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101946","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":"3102746","reservation_id":"96079","confirmation_number":"SJ12672180940","room_confirmation_number":"SJ12695708529","room_stay_from":"2020-06-18","room_stay_to":"2020-06-22","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":"102204","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-08 00:21:21","reservation_modified_date_time":"2020-06-08 00:22:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102204","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":"3102748","reservation_id":"96076","confirmation_number":"SJ12630037961","room_confirmation_number":"SJ12619526025","room_stay_from":"2020-06-18","room_stay_to":"2020-06-22","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":"102201","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-07 23:52:26","reservation_modified_date_time":"2020-06-08 00:23:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102201","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":"3103125","reservation_id":"96100","confirmation_number":"SJ12664540291","room_confirmation_number":"SJ12684080337","room_stay_from":"2020-06-20","room_stay_to":"2020-06-22","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":"102223","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-08 15:39:08","reservation_modified_date_time":"2020-06-09 00:11:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102223","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":"3104234","reservation_id":"95798","confirmation_number":"SJ12662898105","room_confirmation_number":"SJ12656625316","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","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":"98138","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-02 14:18:23","reservation_modified_date_time":"2020-06-12 02:19:06","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":"3104259","reservation_id":"96285","confirmation_number":"SJ12625963470","room_confirmation_number":"SJ12625749709","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"102408","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-11 17:47:11","reservation_modified_date_time":"2020-06-12 02:57:47","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102408","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.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":"3106916","reservation_id":"96746","confirmation_number":"SJ12654279540","room_confirmation_number":"SJ12616203810","room_stay_from":"2020-06-20","room_stay_to":"2020-06-22","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":"102865","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-18 00:53:09","reservation_modified_date_time":"2020-06-18 00:53:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102865","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":"3106964","reservation_id":"96127","confirmation_number":"SJ12686585477","room_confirmation_number":"SJ12665026335","room_stay_from":"2020-06-18","room_stay_to":"2020-06-22","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":"102254","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-08 21:37:10","reservation_modified_date_time":"2020-06-18 11:12:42","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102254","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":"3106987","reservation_id":"96205","confirmation_number":"SJ12649315641","room_confirmation_number":"SJ12666669790","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"102327","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-10 01:36:06","reservation_modified_date_time":"2020-06-18 11:28:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102327","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.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":"3107330","reservation_id":"96126","confirmation_number":"SJ12629518783","room_confirmation_number":"SJ12657704300","room_stay_from":"2020-06-18","room_stay_to":"2020-06-22","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":"102255","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-08 21:36:10","reservation_modified_date_time":"2020-06-18 21:13:32","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102252","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":"3107586","reservation_id":"96214","confirmation_number":"SJ12688471317","room_confirmation_number":"SJ12688373079","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","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":"102336","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-10 13:10:51","reservation_modified_date_time":"2020-06-19 17:49:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102336","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":"3107590","reservation_id":"96213","confirmation_number":"SJ12665568296","room_confirmation_number":"SJ12678997460","room_stay_from":"2020-06-19","room_stay_to":"2020-06-22","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":"102335","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-10 12:58:44","reservation_modified_date_time":"2020-06-19 17:49:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102335","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":"3107961","reservation_id":"96872","confirmation_number":"SJ12650683388","room_confirmation_number":"SJ12667182229","room_stay_from":"2020-06-20","room_stay_to":"2020-06-22","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":"102995","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-20 17:00:12","reservation_modified_date_time":"2020-06-20 17:00:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102995","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":"3107991","reservation_id":"96574","confirmation_number":"SJ12683870702","room_confirmation_number":"SJ12696057869","room_stay_from":"2020-06-20","room_stay_to":"2020-06-22","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":"102687","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 23:24:10","reservation_modified_date_time":"2020-06-20 18:32:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102687","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":"3108056","reservation_id":"96885","confirmation_number":"SJ12620293349","room_confirmation_number":"SJ12633023307","room_stay_from":"2020-06-20","room_stay_to":"2020-06-22","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":"103010","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-20 21:48:07","reservation_modified_date_time":"2020-06-20 21:48:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103010","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":"3108363","reservation_id":"96490","confirmation_number":"SJ12696113532","room_confirmation_number":"SJ12629136237","room_stay_from":"2020-06-21","room_stay_to":"2020-06-22","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":"102598","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-14 17:12:10","reservation_modified_date_time":"2020-06-21 20:11:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102598","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"From date changed","deltaChange":"-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":"3108483","reservation_id":"96929","confirmation_number":"SJ12636441819","room_confirmation_number":"SJ12688032336","room_stay_from":"2020-06-21","room_stay_to":"2020-06-22","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103050","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-22 04:22:22","reservation_modified_date_time":"2020-06-22 04:22:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103049","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":"3095240","reservation_id":"95067","confirmation_number":"SJ12681200392","room_confirmation_number":"SJ12645741926","room_stay_from":"2020-06-21","room_stay_to":"2020-06-23","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":"101250","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 20:32:12","reservation_modified_date_time":"2020-05-19 20:32:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101250","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":"3106315","reservation_id":"95849","confirmation_number":"SJ12644722107","room_confirmation_number":"SJ12691165163","room_stay_from":"2020-06-17","room_stay_to":"2020-06-23","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,0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"102006","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-03 13:26:10","reservation_modified_date_time":"2020-06-16 21:39:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102006","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25.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":"3106982","reservation_id":"96592","confirmation_number":"SJ12642990693","room_confirmation_number":"SJ12629340591","room_stay_from":"2020-06-18","room_stay_to":"2020-06-23","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":"101654","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-16 01:51:26","reservation_modified_date_time":"2020-06-18 11:25:55","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":"3106992","reservation_id":"96314","confirmation_number":"SJ12674367285","room_confirmation_number":"SJ12611867661","room_stay_from":"2020-06-18","room_stay_to":"2020-06-23","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":"102438","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 01:58:49","reservation_modified_date_time":"2020-06-18 11:29:31","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":"3107449","reservation_id":"96240","confirmation_number":"SJ12689364284","room_confirmation_number":"SJ12675192031","room_stay_from":"2020-06-20","room_stay_to":"2020-06-23","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":"102363","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-10 19:10:29","reservation_modified_date_time":"2020-06-19 03:20:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102363","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":"3101967","reservation_id":"95994","confirmation_number":"SJ12648241434","room_confirmation_number":"SJ12654465938","room_stay_from":"2020-06-21","room_stay_to":"2020-06-24","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":"102128","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-06 15:11:11","reservation_modified_date_time":"2020-06-06 15:11:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102800","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":"3103178","reservation_id":"95993","confirmation_number":"SJ12675240941","room_confirmation_number":"SJ12677844021","room_stay_from":"2020-06-21","room_stay_to":"2020-06-24","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":"102127","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-06 15:11:07","reservation_modified_date_time":"2020-06-09 02:15:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103036","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":"3108341","reservation_id":"96379","confirmation_number":"SJ12698209285","room_confirmation_number":"SJ12683550350","room_stay_from":"2020-06-21","room_stay_to":"2020-06-24","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":"102487","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 20:29:09","reservation_modified_date_time":"2020-06-21 18:50:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102487","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.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":"3103209","reservation_id":"80082","confirmation_number":"SJ12639531344","room_confirmation_number":"SJ12616059345","room_stay_from":"2020-06-20","room_stay_to":"2020-06-25","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":"88505","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-03 02:11:44","reservation_modified_date_time":"2020-06-09 12:42:32","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":"3107409","reservation_id":"94983","confirmation_number":"SJ12672998203","room_confirmation_number":"SJ12686725295","room_stay_from":"2020-06-21","room_stay_to":"2020-06-25","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":"101176","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 20:26:10","reservation_modified_date_time":"2020-06-19 03:01:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101176","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":"3104199","reservation_id":"96312","confirmation_number":"SJ12671714455","room_confirmation_number":"SJ12642458919","room_stay_from":"2020-06-19","room_stay_to":"2020-06-26","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":"102436","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 01:54:43","reservation_modified_date_time":"2020-06-12 01:54:43","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":"3108284","reservation_id":"96315","confirmation_number":"SJ12638626722","room_confirmation_number":"SJ12684993363","room_stay_from":"2020-06-21","room_stay_to":"2020-06-26","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":"102439","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 02:00:40","reservation_modified_date_time":"2020-06-21 16:40:42","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":"3095068","reservation_id":"95032","confirmation_number":"SJ12632742266","room_confirmation_number":"SJ12663544214","room_stay_from":"2020-06-20","room_stay_to":"2020-06-27","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":"101221","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-19 12:57:54","reservation_modified_date_time":"2020-05-19 12:57:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101221","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":"3099726","reservation_id":"94939","confirmation_number":"SJ12657345565","room_confirmation_number":"SJ12682977632","room_stay_from":"2020-06-21","room_stay_to":"2020-06-27","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":"85255","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-18 03:47:56","reservation_modified_date_time":"2020-06-01 14:42:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"85255","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":"3104197","reservation_id":"96311","confirmation_number":"SJ12664606097","room_confirmation_number":"SJ12640191172","room_stay_from":"2020-06-20","room_stay_to":"2020-06-27","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":"102435","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-12 01:52:25","reservation_modified_date_time":"2020-06-12 01:52:25","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":"3106994","reservation_id":"96437","confirmation_number":"SJ12687275233","room_confirmation_number":"SJ12670763368","room_stay_from":"2020-06-21","room_stay_to":"2020-06-27","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":"84466","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-13 18:13:10","reservation_modified_date_time":"2020-06-18 11:30:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84466","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":"3097665","reservation_id":"95422","confirmation_number":"SJ12691430516","room_confirmation_number":"SJ12681033452","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","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":"101613","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 16:19:27","reservation_modified_date_time":"2020-05-26 16:19:27","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":"3097668","reservation_id":"95423","confirmation_number":"SJ12620136082","room_confirmation_number":"SJ12669328888","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","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":"101613","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-26 16:20:36","reservation_modified_date_time":"2020-05-26 16:20:36","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":"3105750","reservation_id":"96543","confirmation_number":"SJ12656129645","room_confirmation_number":"SJ12616896695","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","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":"102651","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 15:30:39","reservation_modified_date_time":"2020-06-15 15:30:39","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","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":"3107428","reservation_id":"96542","confirmation_number":"SJ12643915172","room_confirmation_number":"SJ12694445048","room_stay_from":"2020-06-21","room_stay_to":"2020-06-28","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":"102649","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-15 15:25:17","reservation_modified_date_time":"2020-06-19 03:09:26","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3108325","reservation_id":"96885","confirmation_number":"SJ12644063521","room_confirmation_number":"SJ12633023307","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"27.91","grand_total":"30.00","paid_amount":"30.00","product_id":"1659","service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-21 18:16:40","reservation_modified_date_time":"2020-06-21 18:16:40","customer_id":"103010","parentCustTravId":"103010","customer_traveller_id":"103010","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":"27.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3108342","reservation_id":"96315","confirmation_number":"SJ12681429570","room_confirmation_number":"SJ12684993363","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"40.00","paid_amount":"0.00","product_id":"2073","service_quantity":"4","product_name":"Face Mask","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-21 18:55:52","reservation_modified_date_time":"2020-06-21 18:55:52","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"102439","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"37.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3108229","reservation_id":"96898","confirmation_number":"SJ12697326648","room_confirmation_number":"SJ12634612731","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"15.00","paid_amount":"15.00","product_id":null,"service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-21 14:29:11","reservation_modified_date_time":"2020-06-21 14:29:11","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":"13.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3108230","reservation_id":"96898","confirmation_number":"SJ12686763922","room_confirmation_number":"SJ12634612731","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"27.91","grand_total":"30.00","paid_amount":"30.00","product_id":null,"service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-21 14:29:11","reservation_modified_date_time":"2020-06-21 14:29:11","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":"27.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3108232","reservation_id":"96899","confirmation_number":"SJ12623114125","room_confirmation_number":"SJ12629880108","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"13.95","grand_total":"15.00","paid_amount":"15.00","product_id":null,"service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-21 14:49:48","reservation_modified_date_time":"2020-06-21 14:49:48","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":"13.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3108234","reservation_id":"96900","confirmation_number":"SJ12697866501","room_confirmation_number":"SJ12653743619","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-06-21 14:50:28","reservation_modified_date_time":"2020-06-21 14:50:28","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"}]},{"room_stay_id":"3108382","reservation_id":"96915","confirmation_number":"SJ12662765682","room_confirmation_number":"SJ12620342032","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"1","product_name":"Face Mask","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-21 21:02:06","reservation_modified_date_time":"2020-06-21 21:02:06","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":"9.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3106774","reservation_id":"96734","confirmation_number":"SJ12614547296","room_confirmation_number":"SJ12690642765","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"27.91","grand_total":"60.00","paid_amount":"0.00","product_id":"1659","service_quantity":"2","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-06-17 20:54:55","reservation_modified_date_time":"2020-06-17 20:54:55","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","service_canceled_date_time":"2020-06-21 12:50:58","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-55.82,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[{"room_stay_id":"3108383","reservation_id":"96915","confirmation_number":"SJ12650090703","room_confirmation_number":"SJ12620342032","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-06-21 21:02:06","reservation_modified_date_time":"2020-06-21 21:02:06","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":"3108448","reservation_id":"96922","confirmation_number":"SJ12645537709","room_confirmation_number":"SJ12664516781","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-06-22 00:05:03","reservation_modified_date_time":"2020-06-22 00:05:03","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":[]}}