{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-02-15","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1278,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,1918,1920,1942,1943,1296,1294,1297,1315,1316,1866,1919,1921,1922,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1923","holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1261,1262,1313,1943,1918,1919,1920,1922,1923","block_room_bookings":[{"confirmation_number":"SJ12629964770","room_stay_from":"2020-01-29","room_stay_to":"2020-02-23","bundle_room":"0"},{"confirmation_number":"SJ12632788009","room_stay_from":"2019-12-20","room_stay_to":"2020-02-24","bundle_room":"0"},{"confirmation_number":"SJ12673593636","room_stay_from":"2019-11-09","room_stay_to":"2020-02-26","bundle_room":"0"},{"confirmation_number":"SJ12665142275","room_stay_from":"2020-01-14","room_stay_to":"2020-03-01","bundle_room":"0"},{"confirmation_number":"SJ12632903645","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12638549225","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12665324838","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12657221101","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12693730510","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"}],"bundle_block_count":"1304,1305,1267,1268,1260,1261,1269,1270,1271,1272,1307,1308,1262,1263,1311,1312,1309,1310,1302,1303,1291,1711","bundle_block_bookings":[{"confirmation_number":"SJB12667025258","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","bundle_room":"1"},{"confirmation_number":"SJB12650234103","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","bundle_room":"1"},{"confirmation_number":"SJB12669553616","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","bundle_room":"1"},{"confirmation_number":"SJB12662021701","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","bundle_room":"1"},{"confirmation_number":"SJB12634708481","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","bundle_room":"1"},{"confirmation_number":"SJB12680791682","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","bundle_room":"1"},{"confirmation_number":"SJB12651240533","room_stay_from":"2020-02-15","room_stay_to":"2020-02-17","bundle_room":"1"},{"confirmation_number":"SJB12687279943","room_stay_from":"2020-02-15","room_stay_to":"2020-02-17","bundle_room":"1"},{"confirmation_number":"SJB12622212968","room_stay_from":"2020-02-14","room_stay_to":"2020-02-17","bundle_room":"1"},{"confirmation_number":"SJB12659525285","room_stay_from":"2020-02-14","room_stay_to":"2020-02-18","bundle_room":"0"},{"confirmation_number":"SJB12699825733","room_stay_from":"2020-02-14","room_stay_to":"2020-02-18","bundle_room":"0"},{"confirmation_number":"SJB12632307179","room_stay_from":"2020-02-15","room_stay_to":"2020-02-19","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3064744","reservation_id":"91111","confirmation_number":"SJ12697352101","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.60,210.60","nightly_discount":"0,0","subtotal":"421.20","grand_total":"473.85","paid_amount":"473.85","room_type_id":"319","product_id":"1304","siteminder_id":"BDC-3608933003","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":"97238","customer_id":"97238","source_of_creation":"Booking.com","reservation_created_date":"2020-02-02 10:14:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"85.94","currentDayPrice":"210.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":"3067669","reservation_id":"91633","confirmation_number":"SJ12677104070","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"314.10","nightly_discount":"0","subtotal":"314.10","grand_total":"353.37","paid_amount":"353.37","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-3741189369","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":"97770","customer_id":"98183","source_of_creation":"Booking.com","reservation_created_date":"2020-02-09 05:21:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"61.60","currentDayPrice":"314.10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068426","reservation_id":"91297","confirmation_number":"SJ12655108685","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"265","nightly_discount":"0","subtotal":"265.00","grand_total":"298.13","paid_amount":"298.13","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-3086087113","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97420","customer_id":"97420","source_of_creation":"Booking.com","reservation_created_date":"2020-02-04 18:31:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"123.52","currentDayPrice":"265","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":"3068805","reservation_id":"90361","confirmation_number":"SJ12639951200","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"167.00","nightly_discount":"0.00","subtotal":"167.00","grand_total":"187.88","paid_amount":"187.88","room_type_id":"413","product_id":"1268","siteminder_id":"BDC-3930532391","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96407","customer_id":"97931","source_of_creation":"Booking.com","reservation_created_date":"2020-01-22 18:06:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"87.52","currentDayPrice":"167.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":"3069137","reservation_id":"89956","confirmation_number":"SJ12637671670","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"363.00,363.00","nightly_discount":"0,0","subtotal":"726.00","grand_total":"816.75","paid_amount":"816.75","room_type_id":"413","product_id":"1269","siteminder_id":"BDC-2298419279","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":"95980","customer_id":"95980","source_of_creation":"Booking.com","reservation_created_date":"2020-01-14 17:06:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"140.80","currentDayPrice":"363.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":"3069948","reservation_id":"89512","confirmation_number":"SJ12688155376","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"316.80,316.80","nightly_discount":"0,0","subtotal":"633.60","grand_total":"712.80","paid_amount":"712.80","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-3347067746","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":"98136","customer_id":"98136","source_of_creation":"Booking.com","reservation_created_date":"2020-01-07 17:10:07","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"124.17","currentDayPrice":"316.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":"3069997","reservation_id":"91127","confirmation_number":"SJ12698109720","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"251.10,251.10","nightly_discount":"0,0","subtotal":"502.20","grand_total":"564.98","paid_amount":"564.98","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-3141442588","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":"98152","customer_id":"98152","source_of_creation":"Booking.com","reservation_created_date":"2020-02-02 14:39:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"100.52","currentDayPrice":"251.10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3070014","reservation_id":"90580","confirmation_number":"SJ12648945065","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"321.57,321.57","nightly_discount":"0,0","subtotal":"643.14","grand_total":"723.54","paid_amount":"667.29","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-3068353283","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":"96647","customer_id":"96647","source_of_creation":"Booking.com","reservation_created_date":"2020-01-25 19:18:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"236.32","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"321.57","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":"3070074","reservation_id":"91297","confirmation_number":"SJ12670559080","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"315.00","nightly_discount":"0","subtotal":"315.00","grand_total":"354.38","paid_amount":"354.38","room_type_id":"413","product_id":"1271","siteminder_id":"BDC-3086087113","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":"97420","customer_id":"97420","source_of_creation":"Booking.com","reservation_created_date":"2020-02-04 18:31:19","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"123.52","currentDayPrice":"315.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":"3070167","reservation_id":"90387","confirmation_number":"SJ12636460104","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"143.5","nightly_discount":"0","subtotal":"143.50","grand_total":"161.44","paid_amount":"161.44","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3653295298","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98181","customer_id":"98181","source_of_creation":"Booking.com","reservation_created_date":"2020-01-22 22:03:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"39.89","currentDayPrice":"143.5","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":"3070175","reservation_id":"90593","confirmation_number":"SJ12619794137","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"310.23","nightly_discount":"0","subtotal":"310.23","grand_total":"349.01","paid_amount":"349.01","room_type_id":"319","product_id":"1308","siteminder_id":"BDC-3527804332","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":"96663","customer_id":"96663","source_of_creation":"Booking.com","reservation_created_date":"2020-01-25 23:06:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"60.90","currentDayPrice":"310.23","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":"3069121","reservation_id":"90669","confirmation_number":"SJ12647756176","room_stay_from":"2020-02-12","room_stay_to":"2020-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"319.00,319.00,372.00,372.00,319.00","nightly_discount":"0,0,0,0,0","subtotal":"1701.00","grand_total":"1913.63","paid_amount":"1913.63","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2807495496","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":"96752","customer_id":"96752","source_of_creation":"Booking.com","reservation_created_date":"2020-01-27 02:39:33","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"331.49","currentDayPrice":"372.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":"3057300","reservation_id":"89857","confirmation_number":"SJ12622066857","room_stay_from":"2020-02-15","room_stay_to":"2020-02-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"341.00,288.00,288.00,288.00","nightly_discount":"0,0,0,0","subtotal":"1205.00","grand_total":"1355.63","paid_amount":"1355.63","room_type_id":"319","product_id":"1711","siteminder_id":"BDC-2400750321","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":"95873","customer_id":"95873","source_of_creation":"Booking.com","reservation_created_date":"2020-01-13 02:50:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"474.29","currentDayPrice":"341.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":"3057303","reservation_id":"89857","confirmation_number":"SJ12651938574","room_stay_from":"2020-02-15","room_stay_to":"2020-02-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"341.00,288.00,288.00,288.00","nightly_discount":"0,0,0,0","subtotal":"1205.00","grand_total":"1355.63","paid_amount":"1355.63","room_type_id":"319","product_id":"1291","siteminder_id":"BDC-2400750321","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":"95873","customer_id":"95873","source_of_creation":"Booking.com","reservation_created_date":"2020-01-13 02:50:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"474.29","currentDayPrice":"341.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3062995","reservation_id":"90840","confirmation_number":"SJ12634844212","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00","nightly_discount":"0","subtotal":"215.00","grand_total":"241.88","paid_amount":"241.88","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1631632165","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":"96932","customer_id":"96932","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 03:03:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"215.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":"3063210","reservation_id":"90878","confirmation_number":"SJ12678959068","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.00","nightly_discount":"0","subtotal":"172.00","grand_total":"193.50","paid_amount":"193.50","room_type_id":"413","product_id":"1272","siteminder_id":"EXP-1631962528","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":"96966","customer_id":"96966","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 17:28:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"172.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":"3064118","reservation_id":"91043","confirmation_number":"SJ12638764105","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"187.20,187.20","nightly_discount":"0,0","subtotal":"374.40","grand_total":"421.20","paid_amount":"421.20","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1633633958","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":"97152","customer_id":"97152","source_of_creation":"Expedia","reservation_created_date":"2020-02-01 13:33:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"187.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3064289","reservation_id":"91055","confirmation_number":"SJ12629173519","room_stay_from":"2020-02-13","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,187.20,187.20","nightly_discount":"0,0,0","subtotal":"543.60","grand_total":"611.55","paid_amount":"611.55","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1633696775","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":"97165","customer_id":"97165","source_of_creation":"Expedia","reservation_created_date":"2020-02-01 16:23:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"187.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3064773","reservation_id":"91118","confirmation_number":"SJ12637267035","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"205.20,205.20","nightly_discount":"0,0","subtotal":"410.40","grand_total":"461.70","paid_amount":"461.70","room_type_id":"319","product_id":"1305","siteminder_id":"EXP-1634065273","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":"97245","customer_id":"97245","source_of_creation":"Expedia","reservation_created_date":"2020-02-02 12:28:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"205.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":"3065393","reservation_id":"91186","confirmation_number":"SJ12684432384","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"187.20,187.20","nightly_discount":"0,0","subtotal":"374.40","grand_total":"421.20","paid_amount":"421.20","room_type_id":"319","product_id":"1319","siteminder_id":"EXP-1634425101","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":"97310","customer_id":"97310","source_of_creation":"Expedia","reservation_created_date":"2020-02-03 01:53:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"187.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068611","reservation_id":"91227","confirmation_number":"SJ12653727658","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,215.00","nightly_discount":"0,0","subtotal":"430.00","grand_total":"483.75","paid_amount":"483.75","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1634796933","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":"97349","customer_id":"97349","source_of_creation":"Expedia","reservation_created_date":"2020-02-03 18:18:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"215.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":"3069705","reservation_id":"90385","confirmation_number":"SJ12647513374","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.00,172.00","nightly_discount":"0,0","subtotal":"344.00","grand_total":"387.00","paid_amount":"387.00","room_type_id":"318","product_id":"1282","siteminder_id":"EXP-1627911534","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":"96434","customer_id":"96434","source_of_creation":"Expedia","reservation_created_date":"2020-01-22 21:28:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"172.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":"3069708","reservation_id":"90411","confirmation_number":"SJ12688758636","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"267.84,267.84","nightly_discount":"0,0","subtotal":"535.68","grand_total":"602.64","paid_amount":"602.64","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1628077151","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":"96462","customer_id":"96462","source_of_creation":"Expedia","reservation_created_date":"2020-01-23 02:53:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"267.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":"3069929","reservation_id":"91981","confirmation_number":"SJ12622001323","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.00","nightly_discount":"0","subtotal":"224.00","grand_total":"252.00","paid_amount":"252.00","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1641752420","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":"98132","customer_id":"98132","source_of_creation":"Expedia","reservation_created_date":"2020-02-14 19:59:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"224.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":"3070076","reservation_id":"90870","confirmation_number":"SJ12646152730","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.00","nightly_discount":"0","subtotal":"172.00","grand_total":"193.50","paid_amount":"193.50","room_type_id":"319","product_id":"1276","siteminder_id":"EXP-1631926679","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":"96958","customer_id":"96958","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 16:29:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"172.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":"3070177","reservation_id":"91155","confirmation_number":"SJ12653071481","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"208.00","nightly_discount":"0","subtotal":"208.00","grand_total":"234.00","paid_amount":"234.00","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1634273978","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":"97281","customer_id":"97281","source_of_creation":"Expedia","reservation_created_date":"2020-02-02 19:53:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"208.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":"3055187","reservation_id":"89543","confirmation_number":"SJ12676130648","room_stay_from":"2020-02-14","room_stay_to":"2020-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"272.80,272.80,230.40","nightly_discount":"0,0,0","subtotal":"776.00","grand_total":"873.00","paid_amount":"873.00","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1619138668","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":"95524","customer_id":"95524","source_of_creation":"Expedia","reservation_created_date":"2020-01-08 02:18:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"272.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":"3064606","reservation_id":"91082","confirmation_number":"SJ12656247394","room_stay_from":"2020-02-15","room_stay_to":"2020-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"234.00,211.50","nightly_discount":"0,0","subtotal":"445.50","grand_total":"501.19","paid_amount":"501.19","room_type_id":"319","product_id":"1301","siteminder_id":"EXP-1633825757","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":"97200","customer_id":"97200","source_of_creation":"Expedia","reservation_created_date":"2020-02-01 21:08:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"234.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":"3065711","reservation_id":"91194","confirmation_number":"SJ12647804647","room_stay_from":"2020-02-15","room_stay_to":"2020-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"187.20,169.20","nightly_discount":"0,0","subtotal":"356.40","grand_total":"400.95","paid_amount":"400.95","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1634461523","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":"97317","customer_id":"97317","source_of_creation":"Expedia","reservation_created_date":"2020-02-03 03:33:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"187.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068858","reservation_id":"90375","confirmation_number":"SJ12646242593","room_stay_from":"2020-02-15","room_stay_to":"2020-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,179.00","nightly_discount":"0,0","subtotal":"394.00","grand_total":"443.25","paid_amount":"443.25","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1627850879","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":"96423","customer_id":"96423","source_of_creation":"Expedia","reservation_created_date":"2020-01-22 19:43:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"215.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":"3069881","reservation_id":"91109","confirmation_number":"SJ12648642975","room_stay_from":"2020-02-14","room_stay_to":"2020-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"187.20,187.20,169.20","nightly_discount":"0,0,0","subtotal":"543.60","grand_total":"611.55","paid_amount":"611.55","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1634015683","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":"97236","customer_id":"97236","source_of_creation":"Expedia","reservation_created_date":"2020-02-02 05:48:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"187.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3069964","reservation_id":"91229","confirmation_number":"SJ12687578831","room_stay_from":"2020-02-14","room_stay_to":"2020-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"234.00,234.00,211.50","nightly_discount":"0,0,0","subtotal":"679.50","grand_total":"764.44","paid_amount":"764.44","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1634801546","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":"98144","customer_id":"98144","source_of_creation":"Expedia","reservation_created_date":"2020-02-03 18:23:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"234.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":"3070169","reservation_id":"91122","confirmation_number":"SJ12662421145","room_stay_from":"2020-02-15","room_stay_to":"2020-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"234.00,211.50","nightly_discount":"0,0","subtotal":"445.50","grand_total":"501.19","paid_amount":"501.19","room_type_id":"319","product_id":"1756","siteminder_id":"EXP-1634114805","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":"98182","customer_id":"98182","source_of_creation":"Expedia","reservation_created_date":"2020-02-02 13:53:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"234.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":"3064444","reservation_id":"89477","confirmation_number":"SJ12637384157","room_stay_from":"2020-02-15","room_stay_to":"2020-02-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"272.80,230.40,230.40","nightly_discount":"0,0,0","subtotal":"733.60","grand_total":"825.30","paid_amount":"825.30","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1618442136","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":"95456","customer_id":"95456","source_of_creation":"Expedia","reservation_created_date":"2020-01-06 23:03:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"272.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":"3069546","reservation_id":"89589","confirmation_number":"SJ12656998305","room_stay_from":"2020-02-10","room_stay_to":"2020-02-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"207.36,207.36,207.36,207.36,245.52,245.52,207.36,207.36","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1735.20","grand_total":"1952.10","paid_amount":"1952.10","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1619586586","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":"95579","customer_id":"95579","source_of_creation":"Expedia","reservation_created_date":"2020-01-08 21:08:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"245.52","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3060696","reservation_id":"90377","confirmation_number":"SJ12612590068","room_stay_from":"2020-02-14","room_stay_to":"2020-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.00,172.00,143.20,143.20,143.20,143.20,143.20,172.00","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1232.00","grand_total":"1386.00","paid_amount":"1386.00","room_type_id":"413","product_id":"1273","siteminder_id":"EXP-1627858566","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":"96426","customer_id":"96426","source_of_creation":"Expedia","reservation_created_date":"2020-01-22 19:53:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"172.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":"3055189","reservation_id":"89207","confirmation_number":"SJ12682005213","room_stay_from":"2020-02-14","room_stay_to":"2020-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"272.80,272.80,230.40,230.40,230.40,230.40,230.40,272.80,272.80,230.40,230.40","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0","subtotal":"2704.00","grand_total":"3042.00","paid_amount":"3042.00","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1616437054","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":"95234","customer_id":"95234","source_of_creation":"Expedia","reservation_created_date":"2020-01-03 04:07:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"272.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"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":"3069139","reservation_id":"90972","confirmation_number":"SJ12611595897","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00","nightly_discount":"0.00","subtotal":"215.00","grand_total":"241.88","paid_amount":"241.88","room_type_id":"412","product_id":"1866","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97050","customer_id":"97050","source_of_creation":"FE","reservation_created_date":"2020-01-30 21:27:51","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"215.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":"3070048","reservation_id":"91128","confirmation_number":"SJ12669718801","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"260.00","nightly_discount":"0.00","subtotal":"260.00","grand_total":"292.50","paid_amount":"292.50","room_type_id":"319","product_id":"1275","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":"97254","customer_id":"97254","source_of_creation":"FE","reservation_created_date":"2020-02-02 14:52:49","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"260.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":"3065725","reservation_id":"91242","confirmation_number":"SJ12679755500","room_stay_from":"2020-02-15","room_stay_to":"2020-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"260.00,235.00","nightly_discount":"0.00,0.00","subtotal":"495.00","grand_total":"556.88","paid_amount":"556.88","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97364","customer_id":"97364","source_of_creation":"FE","reservation_created_date":"2020-02-03 20:50:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"260.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":"3062314","reservation_id":"89624","confirmation_number":"SJ12676672905","room_stay_from":"2020-02-14","room_stay_to":"2020-02-18","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"682.66,639.86,575.66,575.66","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"2473.84","grand_total":"2783.07","paid_amount":"2783.07","room_type_id":"320","product_id":"1328","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95614","customer_id":"95614","source_of_creation":"FE","reservation_created_date":"2020-01-09 11:14:49","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"639.86","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":"3068615","reservation_id":"89544","confirmation_number":"SJ12695926933","room_stay_from":"2020-02-15","room_stay_to":"2020-02-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"277.13,277.13,277.13,277.13,277.13,277.13","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1662.78","grand_total":"1870.63","paid_amount":"1558.85","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95525","customer_id":"95525","source_of_creation":"FE","reservation_created_date":"2020-01-08 02:31:16","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"277.13","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3064441","reservation_id":"91061","confirmation_number":"SJ12656401047","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","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":"0.00","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":"74500","customer_id":"74500","source_of_creation":"PMS","reservation_created_date":"2020-02-01 17:19:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"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":"3064694","reservation_id":"91099","confirmation_number":"SJ12698805851","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"260.00","nightly_discount":"0.00","subtotal":"260.00","grand_total":"292.50","paid_amount":"292.50","room_type_id":"319","product_id":"1917","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97228","customer_id":"97228","source_of_creation":"PMS","reservation_created_date":"2020-02-02 01:31:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"260.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":"3067860","reservation_id":"91060","confirmation_number":"SJ12616033049","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","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":"0.00","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74500","customer_id":"74500","source_of_creation":"PMS","reservation_created_date":"2020-02-01 17:16:05","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"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":"3070052","reservation_id":"91933","confirmation_number":"SJ12686517750","room_stay_from":"2020-02-13","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"220.00,220.00,220.00","nightly_discount":"0.00,0.00,0.00","subtotal":"660.00","grand_total":"742.50","paid_amount":"742.50","room_type_id":"319","product_id":"1307","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":"98075","customer_id":"98075","source_of_creation":"PMS","reservation_created_date":"2020-02-13 18:19:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"220.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":"3063775","reservation_id":"89437","confirmation_number":"SJ12662961260","room_stay_from":"2020-02-14","room_stay_to":"2020-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"298.53,298.53,298.53","nightly_discount":"0.00,0.00,0.00","subtotal":"895.59","grand_total":"1007.54","paid_amount":"1007.54","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95401","customer_id":"95401","source_of_creation":"PMS","reservation_created_date":"2020-01-06 00:41:54","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"298.53","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":"3064436","reservation_id":"91063","confirmation_number":"SJ12675809957","room_stay_from":"2020-02-15","room_stay_to":"2020-02-17","room_stay_status":"Checked-In","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":"0.00","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":"74500","customer_id":"74500","source_of_creation":"PMS","reservation_created_date":"2020-02-01 17:21:31","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"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":"3065153","reservation_id":"91148","confirmation_number":"SJ12639937546","room_stay_from":"2020-02-14","room_stay_to":"2020-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"260.00,260.00,235.00","nightly_discount":"0.00,0.00,0.00","subtotal":"755.00","grand_total":"849.38","paid_amount":"849.38","room_type_id":"319","product_id":"1915","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97274","customer_id":"97274","source_of_creation":"PMS","reservation_created_date":"2020-02-02 18:52:56","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"260.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":"3069884","reservation_id":"89437","confirmation_number":"SJ12697547250","room_stay_from":"2020-02-14","room_stay_to":"2020-02-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"298.53,298.53,298.53","nightly_discount":"0.00,0.00,0.00","subtotal":"895.59","grand_total":"1007.54","paid_amount":"1007.54","room_type_id":"319","product_id":"1310","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":"95401","customer_id":"95401","source_of_creation":"PMS","reservation_created_date":"2020-01-06 00:40:34","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"298.53","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":"3060585","reservation_id":"86723","confirmation_number":"SJ12614566986","room_stay_from":"2020-02-15","room_stay_to":"2020-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1278","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":"74797","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2019-11-05 22:45:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"0.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":"3062936","reservation_id":"90831","confirmation_number":"SJ12684937263","room_stay_from":"2020-02-15","room_stay_to":"2020-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1277","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":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-01-29 00:33:58","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"0.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":"3067843","reservation_id":"90820","confirmation_number":"SJ12631965344","room_stay_from":"2020-02-15","room_stay_to":"2020-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"412","product_id":"1316","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-01-28 22:46:21","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"0.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":"3070046","reservation_id":"90498","confirmation_number":"SJ12643925763","room_stay_from":"2020-02-09","room_stay_to":"2020-02-15","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.85,172.85,172.86,172.86,172.86,172.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1037.14","grand_total":"1037.14","paid_amount":"0.00","room_type_id":"319","product_id":"1275","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-01-24 15:54:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3068427","reservation_id":"91297","confirmation_number":"SJ12664302412","room_confirmation_number":"SJ12655108685","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"97420","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-10 18:25:12","reservation_modified_date_time":"2020-02-10 18:25:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97420","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068801","reservation_id":"90361","confirmation_number":"SJ12658464188","room_confirmation_number":"SJ12639951200","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"96407","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-11 12:55:04","reservation_modified_date_time":"2020-02-11 12:55:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97931","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3070050","reservation_id":"91128","confirmation_number":"SJ12638305850","room_confirmation_number":"SJ12669718801","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"97254","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-15 16:02:38","reservation_modified_date_time":"2020-02-15 16:02:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97254","canceled_nights_data":"","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3070165","reservation_id":"90387","confirmation_number":"SJ12648689188","room_confirmation_number":"SJ12636460104","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"98181","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-10 22:47:39","reservation_modified_date_time":"2020-02-15 22:08:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98181","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3062996","reservation_id":"90840","confirmation_number":"SJ12645786484","room_confirmation_number":"SJ12634844212","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","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":"96932","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 03:03:08","reservation_modified_date_time":"2020-01-29 03:03:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96932","canceled_nights_data":"","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":"3063211","reservation_id":"90878","confirmation_number":"SJ12633574910","room_confirmation_number":"SJ12678959068","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","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":"96966","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 17:28:07","reservation_modified_date_time":"2020-01-29 17:28:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96966","canceled_nights_data":"","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":"3064119","reservation_id":"91043","confirmation_number":"SJ12615831686","room_confirmation_number":"SJ12638764105","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","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":"97152","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 13:33:07","reservation_modified_date_time":"2020-02-01 13:33:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97152","canceled_nights_data":"","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":"3064290","reservation_id":"91055","confirmation_number":"SJ12644266353","room_confirmation_number":"SJ12629173519","room_stay_from":"2020-02-13","room_stay_to":"2020-02-16","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":"97165","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 16:23:06","reservation_modified_date_time":"2020-02-01 16:23:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97165","canceled_nights_data":"","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":"3064443","reservation_id":"91061","confirmation_number":"SJ12622366074","room_confirmation_number":"SJ12656401047","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"97173","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 17:19:37","reservation_modified_date_time":"2020-02-01 18:41:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74500","canceled_nights_data":"","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":"3064695","reservation_id":"91099","confirmation_number":"SJ12637332850","room_confirmation_number":"SJ12698805851","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","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":"97228","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 01:31:19","reservation_modified_date_time":"2020-02-02 01:31:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97228","canceled_nights_data":"","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":"3064745","reservation_id":"91111","confirmation_number":"SJ12664069325","room_confirmation_number":"SJ12697352101","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","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":"97238","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 10:14:06","reservation_modified_date_time":"2020-02-02 10:14:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97238","canceled_nights_data":"","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":"3064774","reservation_id":"91118","confirmation_number":"SJ12694737467","room_confirmation_number":"SJ12637267035","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","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":"97245","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 12:28:10","reservation_modified_date_time":"2020-02-02 12:28:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97245","canceled_nights_data":"","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":"3065394","reservation_id":"91186","confirmation_number":"SJ12666485698","room_confirmation_number":"SJ12684432384","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","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":"97310","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 01:53:09","reservation_modified_date_time":"2020-02-03 01:53:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97310","canceled_nights_data":"","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":"3067670","reservation_id":"91633","confirmation_number":"SJ12697970500","room_confirmation_number":"SJ12677104070","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","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":"97770","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 05:21:09","reservation_modified_date_time":"2020-02-09 05:21:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98183","canceled_nights_data":"","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":"3067861","reservation_id":"91060","confirmation_number":"SJ12650667050","room_confirmation_number":"SJ12616033049","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"97171","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 17:16:05","reservation_modified_date_time":"2020-02-09 17:40:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74500","canceled_nights_data":"","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":"3068428","reservation_id":"91297","confirmation_number":"SJ12614695496","room_confirmation_number":"SJ12655108685","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","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":"97420","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-04 18:31:13","reservation_modified_date_time":"2020-02-10 18:25:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97420","canceled_nights_data":"","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":"3068612","reservation_id":"91227","confirmation_number":"SJ12664086711","room_confirmation_number":"SJ12653727658","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","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":"97349","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 18:18:11","reservation_modified_date_time":"2020-02-10 23:14:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97349","canceled_nights_data":"","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":"3068806","reservation_id":"90361","confirmation_number":"SJ12694631161","room_confirmation_number":"SJ12639951200","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","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":"96407","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-22 18:06:12","reservation_modified_date_time":"2020-02-11 12:56:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97931","canceled_nights_data":"","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":"3069138","reservation_id":"89956","confirmation_number":"SJ12657835353","room_confirmation_number":"SJ12637671670","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","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":"95980","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-14 17:06:08","reservation_modified_date_time":"2020-02-12 15:01:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95980","canceled_nights_data":"","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":"3069140","reservation_id":"90972","confirmation_number":"SJ12653756810","room_confirmation_number":"SJ12611595897","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","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":"97050","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 21:27:51","reservation_modified_date_time":"2020-02-12 15:02:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97050","canceled_nights_data":"","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":"3069706","reservation_id":"90385","confirmation_number":"SJ12620410115","room_confirmation_number":"SJ12647513374","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","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":"96434","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-22 21:28:11","reservation_modified_date_time":"2020-02-13 23:17:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96434","canceled_nights_data":"","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":"3069707","reservation_id":"90411","confirmation_number":"SJ12617923682","room_confirmation_number":"SJ12688758636","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","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":"96462","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-23 02:53:08","reservation_modified_date_time":"2020-02-13 23:18:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96462","canceled_nights_data":"","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":"3069930","reservation_id":"91981","confirmation_number":"SJ12621286902","room_confirmation_number":"SJ12622001323","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","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":"98132","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-14 19:59:08","reservation_modified_date_time":"2020-02-14 19:59:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98132","canceled_nights_data":"","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":"3069947","reservation_id":"89512","confirmation_number":"SJ12678039610","room_confirmation_number":"SJ12688155376","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","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":"98136","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-07 17:10:07","reservation_modified_date_time":"2020-02-14 20:53:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98136","canceled_nights_data":"","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":"3069996","reservation_id":"91127","confirmation_number":"SJ12676522752","room_confirmation_number":"SJ12698109720","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","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":"98152","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 14:39:07","reservation_modified_date_time":"2020-02-15 02:44:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98152","canceled_nights_data":"","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":"3070015","reservation_id":"90580","confirmation_number":"SJ12658885578","room_confirmation_number":"SJ12648945065","room_stay_from":"2020-02-14","room_stay_to":"2020-02-16","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":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"96647","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 19:18:11","reservation_modified_date_time":"2020-02-15 14:04:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96647","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3070051","reservation_id":"91128","confirmation_number":"SJ12672650100","room_confirmation_number":"SJ12669718801","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","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":"97254","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 14:52:49","reservation_modified_date_time":"2020-02-15 16:02:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97254","canceled_nights_data":"","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":"3070053","reservation_id":"91933","confirmation_number":"SJ12656004770","room_confirmation_number":"SJ12686517750","room_stay_from":"2020-02-13","room_stay_to":"2020-02-16","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":"98075","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-13 18:19:07","reservation_modified_date_time":"2020-02-15 16:05:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98075","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3070075","reservation_id":"91297","confirmation_number":"SJ12653565949","room_confirmation_number":"SJ12670559080","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","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":"97420","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-04 18:31:19","reservation_modified_date_time":"2020-02-15 17:58:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97420","canceled_nights_data":"","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":"3070077","reservation_id":"90870","confirmation_number":"SJ12668384588","room_confirmation_number":"SJ12646152730","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","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":"96958","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 16:29:09","reservation_modified_date_time":"2020-02-15 18:00:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96958","canceled_nights_data":"","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":"3070166","reservation_id":"90387","confirmation_number":"SJ12624654362","room_confirmation_number":"SJ12636460104","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","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":"98181","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-22 22:03:14","reservation_modified_date_time":"2020-02-15 22:08:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98181","canceled_nights_data":"","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":"3070176","reservation_id":"90593","confirmation_number":"SJ12673525770","room_confirmation_number":"SJ12619794137","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","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":"96663","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 23:06:08","reservation_modified_date_time":"2020-02-15 22:32:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96663","canceled_nights_data":"","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":"3070178","reservation_id":"91155","confirmation_number":"SJ12693004268","room_confirmation_number":"SJ12653071481","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","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":"97281","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 19:53:08","reservation_modified_date_time":"2020-02-15 22:33:42","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97281","canceled_nights_data":"","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":"3055188","reservation_id":"89543","confirmation_number":"SJ12692273847","room_confirmation_number":"SJ12676130648","room_stay_from":"2020-02-14","room_stay_to":"2020-02-17","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":"95524","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-08 02:18:10","reservation_modified_date_time":"2020-01-08 02:18:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95524","canceled_nights_data":"","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":"3063776","reservation_id":"89437","confirmation_number":"SJ12669061018","room_confirmation_number":"SJ12662961260","room_stay_from":"2020-02-14","room_stay_to":"2020-02-17","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":"95401","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-06 00:41:55","reservation_modified_date_time":"2020-01-30 23:59:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95401","canceled_nights_data":"","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":"3064438","reservation_id":"91063","confirmation_number":"SJ12640118209","room_confirmation_number":"SJ12675809957","room_stay_from":"2020-02-15","room_stay_to":"2020-02-17","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"97174","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 17:21:31","reservation_modified_date_time":"2020-02-01 18:39:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74500","canceled_nights_data":"","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":"3064607","reservation_id":"91082","confirmation_number":"SJ12690362582","room_confirmation_number":"SJ12656247394","room_stay_from":"2020-02-15","room_stay_to":"2020-02-17","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":"97200","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 21:08:06","reservation_modified_date_time":"2020-02-01 21:08:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97200","canceled_nights_data":"","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":"3065154","reservation_id":"91148","confirmation_number":"SJ12648133968","room_confirmation_number":"SJ12639937546","room_stay_from":"2020-02-14","room_stay_to":"2020-02-17","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":"97274","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 18:52:56","reservation_modified_date_time":"2020-02-02 18:52:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97274","canceled_nights_data":"","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":"3065712","reservation_id":"91194","confirmation_number":"SJ12679478826","room_confirmation_number":"SJ12647804647","room_stay_from":"2020-02-15","room_stay_to":"2020-02-17","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":"97317","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 03:33:09","reservation_modified_date_time":"2020-02-03 20:31:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97317","canceled_nights_data":"","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":"3065726","reservation_id":"91242","confirmation_number":"SJ12672028927","room_confirmation_number":"SJ12679755500","room_stay_from":"2020-02-15","room_stay_to":"2020-02-17","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":"97364","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 20:50:18","reservation_modified_date_time":"2020-02-03 20:50:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97364","canceled_nights_data":"","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":"3068859","reservation_id":"90375","confirmation_number":"SJ12677564951","room_confirmation_number":"SJ12646242593","room_stay_from":"2020-02-15","room_stay_to":"2020-02-17","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":"96423","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-22 19:43:10","reservation_modified_date_time":"2020-02-11 15:24:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96423","canceled_nights_data":"","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":"3069122","reservation_id":"90669","confirmation_number":"SJ12684990241","room_confirmation_number":"SJ12647756176","room_stay_from":"2020-02-12","room_stay_to":"2020-02-17","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"96752","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-27 02:39:33","reservation_modified_date_time":"2020-02-12 14:31:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96752","canceled_nights_data":"","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":"3069883","reservation_id":"91109","confirmation_number":"SJ12683174148","room_confirmation_number":"SJ12648642975","room_stay_from":"2020-02-14","room_stay_to":"2020-02-17","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":"97236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 05:48:07","reservation_modified_date_time":"2020-02-14 17:13:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97236","canceled_nights_data":"","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":"3069885","reservation_id":"89437","confirmation_number":"SJ12626683557","room_confirmation_number":"SJ12697547250","room_stay_from":"2020-02-14","room_stay_to":"2020-02-17","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":"95401","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-06 00:40:34","reservation_modified_date_time":"2020-02-14 17:13:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95401","canceled_nights_data":"","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":"3069963","reservation_id":"91229","confirmation_number":"SJ12643745058","room_confirmation_number":"SJ12687578831","room_stay_from":"2020-02-14","room_stay_to":"2020-02-17","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":"98144","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 18:23:14","reservation_modified_date_time":"2020-02-14 22:52:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98144","canceled_nights_data":"","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":"3070168","reservation_id":"91122","confirmation_number":"SJ12673302521","room_confirmation_number":"SJ12662421145","room_stay_from":"2020-02-15","room_stay_to":"2020-02-17","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":"98182","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 13:53:09","reservation_modified_date_time":"2020-02-15 22:09:44","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98182","canceled_nights_data":"","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":"3062317","reservation_id":"89624","confirmation_number":"SJ12613274484","room_confirmation_number":"SJ12676672905","room_stay_from":"2020-02-14","room_stay_to":"2020-02-18","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":"95614","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-09 11:14:49","reservation_modified_date_time":"2020-01-09 11:14:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95614","canceled_nights_data":"","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":"3064445","reservation_id":"89477","confirmation_number":"SJ12652560302","room_confirmation_number":"SJ12637384157","room_stay_from":"2020-02-15","room_stay_to":"2020-02-18","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":"95456","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-06 23:03:07","reservation_modified_date_time":"2020-02-01 18:41:46","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95456","canceled_nights_data":"","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":"3069547","reservation_id":"89589","confirmation_number":"SJ12657225712","room_confirmation_number":"SJ12656998305","room_stay_from":"2020-02-10","room_stay_to":"2020-02-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"25.00,25.00,25.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"95579","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-08 21:08:10","reservation_modified_date_time":"2020-02-13 16:34:29","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95579","canceled_nights_data":"","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":"3057302","reservation_id":"89857","confirmation_number":"SJ12621773501","room_confirmation_number":"SJ12622066857","room_stay_from":"2020-02-15","room_stay_to":"2020-02-19","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":"95873","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-13 02:50:15","reservation_modified_date_time":"2020-01-13 02:50:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95873","canceled_nights_data":"","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":"3057304","reservation_id":"89857","confirmation_number":"SJ12619527498","room_confirmation_number":"SJ12651938574","room_stay_from":"2020-02-15","room_stay_to":"2020-02-19","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":"95873","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-13 02:50:10","reservation_modified_date_time":"2020-01-13 02:50:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95873","canceled_nights_data":"","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":"3068616","reservation_id":"89544","confirmation_number":"SJ12684837828","room_confirmation_number":"SJ12695926933","room_stay_from":"2020-02-15","room_stay_to":"2020-02-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"95525","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-08 02:31:16","reservation_modified_date_time":"2020-02-10 23:15:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95525","canceled_nights_data":"","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":"3060586","reservation_id":"86723","confirmation_number":"SJ12662273453","room_confirmation_number":"SJ12614566986","room_stay_from":"2020-02-15","room_stay_to":"2020-02-22","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":"93397","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-05 22:45:06","reservation_modified_date_time":"2019-11-05 22:45:06","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","canceled_nights_data":"","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":"3060697","reservation_id":"90377","confirmation_number":"SJ12619303277","room_confirmation_number":"SJ12612590068","room_stay_from":"2020-02-14","room_stay_to":"2020-02-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"96426","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-22 19:53:10","reservation_modified_date_time":"2020-01-22 19:53:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96426","canceled_nights_data":"","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":"3062937","reservation_id":"90831","confirmation_number":"SJ12620741089","room_confirmation_number":"SJ12684937263","room_stay_from":"2020-02-15","room_stay_to":"2020-02-22","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":"96922","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 00:33:58","reservation_modified_date_time":"2020-01-29 00:33:58","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","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":"3067844","reservation_id":"90820","confirmation_number":"SJ12636431548","room_confirmation_number":"SJ12631965344","room_stay_from":"2020-02-15","room_stay_to":"2020-02-22","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":"96904","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 22:46:21","reservation_modified_date_time":"2020-02-09 17:34:52","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","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":"3055190","reservation_id":"89207","confirmation_number":"SJ12674011392","room_confirmation_number":"SJ12682005213","room_stay_from":"2020-02-14","room_stay_to":"2020-02-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"275.00","grand_total":"309.38","paid_amount":"309.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"95234","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-03 04:07:10","reservation_modified_date_time":"2020-01-03 04:07:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95234","canceled_nights_data":"","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":"3070047","reservation_id":"90498","confirmation_number":"SJ12699168050","room_confirmation_number":"SJ12643925763","room_stay_from":"2020-02-09","room_stay_to":"2020-02-15","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"96554","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-24 15:54:46","reservation_modified_date_time":"2020-02-15 16:01:24","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3070064","reservation_id":"90402","confirmation_number":"SJ12675439968","room_confirmation_number":"SJ12650045376","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.99","grand_total":"7.99","paid_amount":"7.99","product_id":"1231","service_quantity":"1","product_name":"key lime","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-15 17:10:26","reservation_modified_date_time":"2020-02-15 17:10:26","customer_id":"96452","parentCustTravId":"96452","customer_traveller_id":"96452","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":"7.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"0","tax_name":null,"tax_percentage":"0.00"}]},{"room_stay_id":"3070065","reservation_id":"90402","confirmation_number":"SJ12617621580","room_confirmation_number":"SJ12650045376","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.95","grand_total":"22.52","paid_amount":"22.52","product_id":"1728","service_quantity":"1","product_name":"Salt Scrub of the Keys","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-15 17:10:26","reservation_modified_date_time":"2020-02-15 17:10:26","customer_id":"96452","parentCustTravId":"96452","customer_traveller_id":"96452","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":"20.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3070281","reservation_id":"90831","confirmation_number":"SJ12637184773","room_confirmation_number":"SJ12684937263","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"20.00","paid_amount":"20.00","product_id":"1231","service_quantity":"1","product_name":"Bar Tab","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-16 02:32:28","reservation_modified_date_time":"2020-02-16 02:32:28","customer_id":"81161","parentCustTravId":"81161","customer_traveller_id":"96922","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"0","tax_name":null,"tax_percentage":"0.00"}]},{"room_stay_id":"3070303","reservation_id":"90385","confirmation_number":"SJ12649994357","room_confirmation_number":"SJ12647513374","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.00","grand_total":"6.00","paid_amount":"6.00","product_id":"1231","service_quantity":"1","product_name":"Bar Tab","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-16 03:30:18","reservation_modified_date_time":"2020-02-16 03:30:18","customer_id":"96434","parentCustTravId":"96434","customer_traveller_id":"96434","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":"6.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"0","tax_name":null,"tax_percentage":"0.00"}]},{"room_stay_id":"3070097","reservation_id":"92010","confirmation_number":"SJ12634879890","room_confirmation_number":"SJ12651260624","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"2.50","paid_amount":"2.50","product_id":null,"service_quantity":"1","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-15 19:50:39","reservation_modified_date_time":"2020-02-15 19:50:39","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.33","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}