{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-02-14","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":"1271,1272,1262,1263,1291,1711,1311,1312,1267,1268,1269,1270,1307,1308,1304,1305,1260,1261,1309,1310,1302,1303","bundle_block_bookings":[{"confirmation_number":"SJB12674281995","room_stay_from":"2020-02-13","room_stay_to":"2020-02-15","bundle_room":"1"},{"confirmation_number":"SJB12641300481","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","bundle_room":"1"},{"confirmation_number":"SJB12630177968","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","bundle_room":"1"},{"confirmation_number":"SJB12622603811","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","bundle_room":"1"},{"confirmation_number":"SJB12660627433","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","bundle_room":"1"},{"confirmation_number":"SJB12691664877","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","bundle_room":"1"},{"confirmation_number":"SJB12699075092","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","bundle_room":"1"},{"confirmation_number":"SJB12667025258","room_stay_from":"2020-02-14","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":"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"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3060778","reservation_id":"90402","confirmation_number":"SJ12650045376","room_stay_from":"2020-02-13","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,215.00","nightly_discount":"0,0","subtotal":"394.00","grand_total":"443.25","paid_amount":"443.25","room_type_id":"413","product_id":"1272","siteminder_id":"BDC-3930597303","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":"96452","customer_id":"96452","source_of_creation":"Booking.com","reservation_created_date":"2020-01-23 00:05:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"81.04","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":"3063089","reservation_id":"90860","confirmation_number":"SJ12645255688","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"165","nightly_discount":"0","subtotal":"165.00","grand_total":"185.63","paid_amount":"185.63","room_type_id":"413","product_id":"1267","siteminder_id":"BDC-3804964238","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":"96949","customer_id":"96949","source_of_creation":"Booking.com","reservation_created_date":"2020-01-29 15:02:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"43.76","currentDayPrice":"165","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":"3064408","reservation_id":"91066","confirmation_number":"SJ12657248127","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"234.00","nightly_discount":"0","subtotal":"234.00","grand_total":"263.25","paid_amount":"263.25","room_type_id":"319","product_id":"1291","siteminder_id":"BDC-2403301568","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":"97177","customer_id":"97177","source_of_creation":"Booking.com","reservation_created_date":"2020-02-01 18:12:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"47.18","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":"3065740","reservation_id":"91247","confirmation_number":"SJ12621412843","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.60","nightly_discount":"0","subtotal":"210.60","grand_total":"236.93","paid_amount":"236.93","room_type_id":"319","product_id":"1312","siteminder_id":"BDC-2814974478","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":"97370","customer_id":"97370","source_of_creation":"Booking.com","reservation_created_date":"2020-02-03 21:39:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"42.97","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":"3067142","reservation_id":"91535","confirmation_number":"SJ12628390394","room_stay_from":"2020-02-07","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"165,165,129,129,129,129,129,210","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1185.00","grand_total":"1333.13","paid_amount":"1333.13","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-2237870405","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"400.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97669","customer_id":"97669","source_of_creation":"Booking.com","reservation_created_date":"2020-02-08 00:25:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"325.79","currentDayPrice":"210","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":"3069131","reservation_id":"91001","confirmation_number":"SJ12696058140","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"193.50","nightly_discount":"0","subtotal":"193.50","grand_total":"217.69","paid_amount":"217.69","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-2659008037","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":"97093","customer_id":"97093","source_of_creation":"Booking.com","reservation_created_date":"2020-01-31 15:32:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"39.89","currentDayPrice":"193.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3069794","reservation_id":"91065","confirmation_number":"SJ12673881058","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"251.10","nightly_discount":"0","subtotal":"251.10","grand_total":"282.49","paid_amount":"282.49","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-3545680083","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":"97176","customer_id":"97176","source_of_creation":"Booking.com","reservation_created_date":"2020-02-01 17:59:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"50.26","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":"3069798","reservation_id":"91911","confirmation_number":"SJ12672689296","room_stay_from":"2020-02-13","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.00,259.00","nightly_discount":"0.00,0.00","subtotal":"494.00","grand_total":"555.75","paid_amount":"555.75","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3886880304","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":"98056","customer_id":"98056","source_of_creation":"Booking.com","reservation_created_date":"2020-02-13 13:36:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"43.13","changedComment":"To date changed","deltaChange":"23.50","currentDayPrice":"259.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":"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":"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":"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":"3069710","reservation_id":"90580","confirmation_number":"SJ12648945065","room_stay_from":"2020-02-14","room_stay_to":"2020-02-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"321.57,321.57,278.64,278.64","nightly_discount":"0,0,0,0","subtotal":"1200.42","grand_total":"1350.47","paid_amount":"1350.47","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","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3062598","reservation_id":"90752","confirmation_number":"SJ12630875325","room_stay_from":"2020-02-13","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"138.2,167","nightly_discount":"0,0","subtotal":"305.20","grand_total":"343.35","paid_amount":"343.35","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1631022906","collect_which":"channel_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":"96833","customer_id":"96833","source_of_creation":"Expedia","reservation_created_date":"2020-01-28 03:53:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"167","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":"3065444","reservation_id":"91200","confirmation_number":"SJ12637340028","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"187.20","nightly_discount":"0","subtotal":"187.20","grand_total":"210.60","paid_amount":"210.60","room_type_id":"319","product_id":"1308","siteminder_id":"EXP-1634517949","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":"97323","customer_id":"97323","source_of_creation":"Expedia","reservation_created_date":"2020-02-03 06:33:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","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":"3066363","reservation_id":"91382","confirmation_number":"SJ12650793810","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.28","nightly_discount":"0","subtotal":"215.28","grand_total":"242.19","paid_amount":"242.19","room_type_id":"319","product_id":"1711","siteminder_id":"EXP-1636203943","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":"97508","customer_id":"97508","source_of_creation":"Expedia","reservation_created_date":"2020-02-05 21:58:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"215.28","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":"3066418","reservation_id":"91395","confirmation_number":"SJ12625342532","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"215.28","nightly_discount":"0","subtotal":"215.28","grand_total":"242.19","paid_amount":"242.19","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1636312172","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":"97522","customer_id":"97522","source_of_creation":"Expedia","reservation_created_date":"2020-02-06 01:28:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"215.28","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":"3067086","reservation_id":"91512","confirmation_number":"SJ12690372591","room_stay_from":"2020-02-08","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"256.00,237.60,237.60,237.60,237.60,237.60,280.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1724.00","grand_total":"1939.50","paid_amount":"1939.50","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1637430717","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":"97642","customer_id":"97642","source_of_creation":"Expedia","reservation_created_date":"2020-02-07 20:23:05","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"280.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":"3067610","reservation_id":"90393","confirmation_number":"SJ12682710659","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"319","product_id":"1287","siteminder_id":"EXP-1627953235","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":"96445","customer_id":"96445","source_of_creation":"Expedia","reservation_created_date":"2020-01-22 22:48:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","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":"3068613","reservation_id":"90392","confirmation_number":"SJ12645447536","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"1264","siteminder_id":"EXP-1627953232","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":"96444","customer_id":"96444","source_of_creation":"Expedia","reservation_created_date":"2020-01-22 22:48:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","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":"3068854","reservation_id":"91392","confirmation_number":"SJ12614648652","room_stay_from":"2020-02-11","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.50,211.50,211.50,269.10","nightly_discount":"0,0,0,0","subtotal":"903.60","grand_total":"1016.55","paid_amount":"1016.55","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1636300591","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":"97520","customer_id":"97520","source_of_creation":"Expedia","reservation_created_date":"2020-02-06 01:08:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"269.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":"3068994","reservation_id":"91269","confirmation_number":"SJ12635676916","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"187.20","nightly_discount":"0","subtotal":"187.20","grand_total":"210.60","paid_amount":"210.60","room_type_id":"319","product_id":"1756","siteminder_id":"EXP-1635080839","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":"97392","customer_id":"97392","source_of_creation":"Expedia","reservation_created_date":"2020-02-04 03:23:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","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":"3069602","reservation_id":"91193","confirmation_number":"SJ12629206060","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"187.20","nightly_discount":"0","subtotal":"187.20","grand_total":"210.60","paid_amount":"210.60","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1634456958","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":"97316","customer_id":"97316","source_of_creation":"Expedia","reservation_created_date":"2020-02-03 03:18:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","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":"3069920","reservation_id":"91979","confirmation_number":"SJ12679602660","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.60","nightly_discount":"0","subtotal":"201.60","grand_total":"226.80","paid_amount":"226.80","room_type_id":"319","product_id":"1314","siteminder_id":"EXP-1641751659","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":"98129","customer_id":"98129","source_of_creation":"Expedia","reservation_created_date":"2020-02-14 19:54:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"201.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":"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":"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":"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":"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":"3062956","reservation_id":"87019","confirmation_number":"SJ12617211658","room_stay_from":"2020-02-08","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"330.63,277.13,277.13,277.13,277.13,277.13,330.63","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2046.91","grand_total":"2302.78","paid_amount":"2302.78","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93613","customer_id":"93613","source_of_creation":"FE","reservation_created_date":"2019-11-11 22:39:14","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"330.63","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":"3068861","reservation_id":"91787","confirmation_number":"SJ12640235013","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"413","product_id":"1268","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":"97933","customer_id":"97933","source_of_creation":"FE","reservation_created_date":"2020-02-11 15:29:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","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":"682.66","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3069982","reservation_id":"91414","confirmation_number":"SJ12685586608","room_stay_from":"2020-02-10","room_stay_to":"2020-02-12","room_stay_status":"Checked-Out","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"235.00,470.00","nightly_discount":"0.00,0.00","subtotal":"705.00","grand_total":"793.13","paid_amount":"821.26","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":"97540","customer_id":"97540","source_of_creation":"FE","reservation_created_date":"2020-02-06 15:48:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","changedComment":"Nightly price or discount changed","deltaChange":"235.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3069605","reservation_id":"91933","confirmation_number":"SJ12686517750","room_stay_from":"2020-02-13","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"220.00,220.00","nightly_discount":"0.00,0.00","subtotal":"440.00","grand_total":"495.00","paid_amount":"495.00","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","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":"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":"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":"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":"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":"3060059","reservation_id":"90278","confirmation_number":"SJ12627079288","room_stay_from":"2020-02-08","room_stay_to":"2020-02-15","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-20 21:02:47","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":"3060572","reservation_id":"86065","confirmation_number":"SJ12618297120","room_stay_from":"2020-02-08","room_stay_to":"2020-02-15","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-10-22 00:32:53","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":"3067546","reservation_id":"86158","confirmation_number":"SJ12696580062","room_stay_from":"2020-02-08","room_stay_to":"2020-02-15","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":"1276","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":"82876","customer_id":"82876","source_of_creation":"PMS","reservation_created_date":"2019-10-24 13:09:59","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","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":"3067623","reservation_id":"90277","confirmation_number":"SJ12611367413","room_stay_from":"2020-02-08","room_stay_to":"2020-02-15","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":"1318","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-20 21:00:01","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","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":"3063625","reservation_id":"90498","confirmation_number":"SJ12643925763","room_stay_from":"2020-02-09","room_stay_to":"2020-02-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.85,172.85,172.86,172.86,172.86,172.86,172.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1210.00","grand_total":"1210.00","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","currentDayPrice":"172.86","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[{"room_stay_id":"3068434","reservation_id":"77863","confirmation_number":"SJ12618311969","room_stay_from":"2020-02-10","room_stay_to":"2020-02-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.00,128.00,128.00,128.00,128.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"640.00","grand_total":"640.00","paid_amount":"140.63","room_type_id":"318","product_id":"1281","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2019-06-03 00:39:34","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"128.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3062599","reservation_id":"90752","confirmation_number":"SJ12669086503","room_confirmation_number":"SJ12630875325","room_stay_from":"2020-02-13","room_stay_to":"2020-02-15","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"96833","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-01-28 03:53:07","reservation_modified_date_time":"2020-01-28 03:53:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96833","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":"3063090","reservation_id":"90860","confirmation_number":"SJ12636651878","room_confirmation_number":"SJ12645255688","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"96949","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-01-29 15:02:12","reservation_modified_date_time":"2020-01-29 15:02:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96949","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":"3067143","reservation_id":"91535","confirmation_number":"SJ12639398942","room_confirmation_number":"SJ12628390394","room_stay_from":"2020-02-07","room_stay_to":"2020-02-15","room_stay_status":"Active","nightly_price":"50,50,50,50,50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"400.00","grand_total":"450.00","paid_amount":"450.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"97669","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-08 00:25:10","reservation_modified_date_time":"2020-02-08 00:25:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97669","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":"3060060","reservation_id":"90278","confirmation_number":"SJ12642396633","room_confirmation_number":"SJ12627079288","room_stay_from":"2020-02-08","room_stay_to":"2020-02-15","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":"96330","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-20 21:02:47","reservation_modified_date_time":"2020-01-20 21:02:47","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":"3060573","reservation_id":"86065","confirmation_number":"SJ12673789441","room_confirmation_number":"SJ12618297120","room_stay_from":"2020-02-08","room_stay_to":"2020-02-15","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":"92934","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-22 00:32:53","reservation_modified_date_time":"2019-10-22 00:32:53","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":"3060779","reservation_id":"90402","confirmation_number":"SJ12628313592","room_confirmation_number":"SJ12650045376","room_stay_from":"2020-02-13","room_stay_to":"2020-02-15","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":"96452","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-23 00:05:09","reservation_modified_date_time":"2020-01-23 00:05:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96452","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":"3062600","reservation_id":"90752","confirmation_number":"SJ12645295132","room_confirmation_number":"SJ12630875325","room_stay_from":"2020-02-13","room_stay_to":"2020-02-15","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":"96833","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 03:53:07","reservation_modified_date_time":"2020-01-28 03:53:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96833","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":"3062957","reservation_id":"87019","confirmation_number":"SJ12660170405","room_confirmation_number":"SJ12617211658","room_stay_from":"2020-02-08","room_stay_to":"2020-02-15","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"93613","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-11 22:39:14","reservation_modified_date_time":"2020-01-29 01:31:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93613","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":"3063091","reservation_id":"90860","confirmation_number":"SJ12649069637","room_confirmation_number":"SJ12645255688","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"96949","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 15:02:12","reservation_modified_date_time":"2020-01-29 15:02:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96949","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":"3064409","reservation_id":"91066","confirmation_number":"SJ12696964362","room_confirmation_number":"SJ12657248127","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"97177","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 18:12:09","reservation_modified_date_time":"2020-02-01 18:12:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97177","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":"3065445","reservation_id":"91200","confirmation_number":"SJ12671257872","room_confirmation_number":"SJ12637340028","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"97323","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 06:33:05","reservation_modified_date_time":"2020-02-03 06:33:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97323","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":"3065741","reservation_id":"91247","confirmation_number":"SJ12699688160","room_confirmation_number":"SJ12621412843","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"97370","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 21:39:11","reservation_modified_date_time":"2020-02-03 21:39:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97370","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":"3066364","reservation_id":"91382","confirmation_number":"SJ12683015885","room_confirmation_number":"SJ12650793810","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"97508","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-05 21:58:09","reservation_modified_date_time":"2020-02-05 21:58:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97508","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":"3066419","reservation_id":"91395","confirmation_number":"SJ12669097670","room_confirmation_number":"SJ12625342532","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"97522","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 01:28:08","reservation_modified_date_time":"2020-02-06 01:28:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97522","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":"3067087","reservation_id":"91512","confirmation_number":"SJ12684264322","room_confirmation_number":"SJ12690372591","room_stay_from":"2020-02-08","room_stay_to":"2020-02-15","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"97642","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-07 20:23:05","reservation_modified_date_time":"2020-02-07 23:13:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97642","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":"3067144","reservation_id":"91535","confirmation_number":"SJ12677615602","room_confirmation_number":"SJ12628390394","room_stay_from":"2020-02-07","room_stay_to":"2020-02-15","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":"97669","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 00:25:10","reservation_modified_date_time":"2020-02-08 00:25:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97669","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":"3067547","reservation_id":"86158","confirmation_number":"SJ12628300577","room_confirmation_number":"SJ12696580062","room_stay_from":"2020-02-08","room_stay_to":"2020-02-15","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":"93013","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-24 13:09:59","reservation_modified_date_time":"2020-02-08 21:30:27","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82876","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":"3067611","reservation_id":"90393","confirmation_number":"SJ12645837360","room_confirmation_number":"SJ12682710659","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"96445","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-22 22:48:15","reservation_modified_date_time":"2020-02-08 23:59:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96445","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":"3067624","reservation_id":"90277","confirmation_number":"SJ12686273393","room_confirmation_number":"SJ12611367413","room_stay_from":"2020-02-08","room_stay_to":"2020-02-15","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":"96329","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-20 21:00:01","reservation_modified_date_time":"2020-02-09 00:37:57","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":"3068435","reservation_id":"77863","confirmation_number":"SJ12678016000","room_confirmation_number":"SJ12618311969","room_stay_from":"2020-02-10","room_stay_to":"2020-02-15","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"87074","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-06-03 00:39:34","reservation_modified_date_time":"2020-02-10 18:26:58","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74459","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":"3068614","reservation_id":"90392","confirmation_number":"SJ12672747363","room_confirmation_number":"SJ12645447536","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"96444","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-22 22:48:10","reservation_modified_date_time":"2020-02-10 23:14:47","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96444","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":"3068855","reservation_id":"91392","confirmation_number":"SJ12648144053","room_confirmation_number":"SJ12614648652","room_stay_from":"2020-02-11","room_stay_to":"2020-02-15","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":"97520","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 01:08:08","reservation_modified_date_time":"2020-02-11 15:21:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97520","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":"3068862","reservation_id":"91787","confirmation_number":"SJ12648336386","room_confirmation_number":"SJ12640235013","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.12","paid_amount":"28.12","product_id":"1776","service_quantity":"1","customer_traveller_id":"97933","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 15:29:11","reservation_modified_date_time":"2020-02-11 15:29:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97933","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":"3068995","reservation_id":"91269","confirmation_number":"SJ12669976323","room_confirmation_number":"SJ12635676916","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"97392","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-04 03:23:05","reservation_modified_date_time":"2020-02-11 22:16:45","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97392","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":"3069133","reservation_id":"91001","confirmation_number":"SJ12634489567","room_confirmation_number":"SJ12696058140","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"97093","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 15:32:11","reservation_modified_date_time":"2020-02-12 15:00:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97093","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":"3069604","reservation_id":"91193","confirmation_number":"SJ12631722349","room_confirmation_number":"SJ12629206060","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"97316","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 03:18:09","reservation_modified_date_time":"2020-02-13 18:22:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97316","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":"3069606","reservation_id":"91933","confirmation_number":"SJ12656004770","room_confirmation_number":"SJ12686517750","room_stay_from":"2020-02-13","room_stay_to":"2020-02-15","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":"98075","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-13 18:19:07","reservation_modified_date_time":"2020-02-13 18:23:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98075","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":"3069795","reservation_id":"91065","confirmation_number":"SJ12669030576","room_confirmation_number":"SJ12673881058","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"97176","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 17:59:11","reservation_modified_date_time":"2020-02-14 12:52:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97176","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":"3069799","reservation_id":"91911","confirmation_number":"SJ12682742647","room_confirmation_number":"SJ12672689296","room_stay_from":"2020-02-13","room_stay_to":"2020-02-15","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":"98056","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-13 13:36:10","reservation_modified_date_time":"2020-02-14 12:55:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98056","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":"3069921","reservation_id":"91979","confirmation_number":"SJ12663649980","room_confirmation_number":"SJ12679602660","room_stay_from":"2020-02-14","room_stay_to":"2020-02-15","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":"98129","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-14 19:54:09","reservation_modified_date_time":"2020-02-14 19:54:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98129","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":"3063626","reservation_id":"90498","confirmation_number":"SJ12699168050","room_confirmation_number":"SJ12643925763","room_stay_from":"2020-02-09","room_stay_to":"2020-02-16","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":"96554","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-24 15:54:46","reservation_modified_date_time":"2020-01-30 17:57:10","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","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":"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":"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":"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":"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":"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":"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":"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":"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":"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":"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":"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":"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":"3069711","reservation_id":"90580","confirmation_number":"SJ12658885578","room_confirmation_number":"SJ12648945065","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":"96647","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 19:18:11","reservation_modified_date_time":"2020-02-13 23:26:41","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96647","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":"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":"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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3069985","reservation_id":"91414","confirmation_number":"SJ12630396669","room_confirmation_number":"SJ12685586608","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-15 00:31:23","reservation_modified_date_time":"2020-02-15 00:31:23","customer_id":"97540","parentCustTravId":"97540","customer_traveller_id":"97540","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":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3069976","reservation_id":"91989","confirmation_number":"SJ12632483235","room_confirmation_number":"SJ12648117788","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"26.88","paid_amount":"26.88","product_id":null,"service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-14 23:36:32","reservation_modified_date_time":"2020-02-14 23:36:32","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":"25.00","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":[]}}