{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-02-19","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":"1313,1262,1261,1943,1918,1919,1920,1922,1923","block_room_bookings":[{"confirmation_number":"SJ12673593636","room_stay_from":"2019-11-09","room_stay_to":"2020-02-26","bundle_room":"0"},{"confirmation_number":"SJ12632788009","room_stay_from":"2019-12-20","room_stay_to":"2020-02-26","bundle_room":"0"},{"confirmation_number":"SJ12629964770","room_stay_from":"2020-01-29","room_stay_to":"2020-02-29","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":"1267,1268,1304,1305,1291,1711,1269,1270,1271,1272,1302,1303,1262,1263,1311,1312,1309,1310,1307,1308,1260,1261","bundle_block_bookings":[{"confirmation_number":"SJB12646356209","room_stay_from":"2020-02-18","room_stay_to":"2020-02-20","bundle_room":"1"},{"confirmation_number":"SJB12696280652","room_stay_from":"2020-02-18","room_stay_to":"2020-02-20","bundle_room":"1"},{"confirmation_number":"SJB12691063721","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","bundle_room":"1"},{"confirmation_number":"SJB12698765171","room_stay_from":"2020-02-18","room_stay_to":"2020-02-20","bundle_room":"1"},{"confirmation_number":"SJB12626511197","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","bundle_room":"1"},{"confirmation_number":"SJB12668915891","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","bundle_room":"1"},{"confirmation_number":"SJB12660953722","room_stay_from":"2020-02-19","room_stay_to":"2020-02-21","bundle_room":"1"},{"confirmation_number":"SJB12670984215","room_stay_from":"2020-02-19","room_stay_to":"2020-02-21","bundle_room":"1"},{"confirmation_number":"SJB12635481762","room_stay_from":"2020-02-19","room_stay_to":"2020-02-21","bundle_room":"1"},{"confirmation_number":"SJB12664645235","room_stay_from":"2020-02-19","room_stay_to":"2020-02-22","bundle_room":"1"},{"confirmation_number":"SJB12653119669","room_stay_from":"2020-02-02","room_stay_to":"2020-02-23","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3061125","reservation_id":"90457","confirmation_number":"SJ12632069723","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"111.1","nightly_discount":"0","subtotal":"111.10","grand_total":"124.99","paid_amount":"124.99","room_type_id":"413","product_id":"1267","siteminder_id":"BDC-3042340850","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":"96510","customer_id":"96510","source_of_creation":"Booking.com","reservation_created_date":"2020-01-23 20:51:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"34.06","currentDayPrice":"111.1","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":"3062318","reservation_id":"90491","confirmation_number":"SJ12672335749","room_stay_from":"2020-02-18","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"287.10,287.10","nightly_discount":"0,0","subtotal":"574.20","grand_total":"645.98","paid_amount":"645.98","room_type_id":"319","product_id":"1304","siteminder_id":"BDC-3373567170","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":"96548","customer_id":"96548","source_of_creation":"Booking.com","reservation_created_date":"2020-01-24 14:38:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"113.48","currentDayPrice":"287.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":"3062882","reservation_id":"90381","confirmation_number":"SJ12689471167","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129","nightly_discount":"0","subtotal":"129.00","grand_total":"145.13","paid_amount":"145.13","room_type_id":"413","product_id":"1271","siteminder_id":"BDC-3213843899","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":"96429","customer_id":"96429","source_of_creation":"Booking.com","reservation_created_date":"2020-01-22 20:39:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"37.28","currentDayPrice":"129","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":"3062885","reservation_id":"90801","confirmation_number":"SJ12646447645","room_stay_from":"2020-02-18","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00","nightly_discount":"0,0","subtotal":"358.00","grand_total":"402.75","paid_amount":"402.75","room_type_id":"413","product_id":"1269","siteminder_id":"BDC-3729416852","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":"96888","customer_id":"96888","source_of_creation":"Booking.com","reservation_created_date":"2020-01-28 20:03:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"74.56","currentDayPrice":"179.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":"3066815","reservation_id":"91358","confirmation_number":"SJ12692733016","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"206.5","nightly_discount":"0","subtotal":"206.50","grand_total":"232.32","paid_amount":"232.32","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-2704179096","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":"97485","customer_id":"97485","source_of_creation":"Booking.com","reservation_created_date":"2020-02-05 15:47:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"51.23","currentDayPrice":"206.5","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068580","reservation_id":"91750","confirmation_number":"SJ12667844915","room_stay_from":"2020-02-18","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"190.35,190.35","nightly_discount":"0,0","subtotal":"380.70","grand_total":"428.29","paid_amount":"428.29","room_type_id":"319","product_id":"1276","siteminder_id":"BDC-3395856040","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":"97892","customer_id":"97892","source_of_creation":"Booking.com","reservation_created_date":"2020-02-10 22:18:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"78.65","currentDayPrice":"190.35","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":"3071149","reservation_id":"91216","confirmation_number":"SJ12649394661","room_stay_from":"2020-02-18","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.50,211.50","nightly_discount":"0,0","subtotal":"423.00","grand_total":"475.88","paid_amount":"475.88","room_type_id":"319","product_id":"1305","siteminder_id":"BDC-3889897700","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":"98335","customer_id":"98335","source_of_creation":"Booking.com","reservation_created_date":"2020-02-03 17:30:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"86.26","currentDayPrice":"211.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":"3071547","reservation_id":"91152","confirmation_number":"SJ12622517863","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"185.6","nightly_discount":"0","subtotal":"185.60","grand_total":"208.80","paid_amount":"208.80","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-3918621946","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97278","customer_id":"97278","source_of_creation":"Booking.com","reservation_created_date":"2020-02-02 19:25:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"42.97","currentDayPrice":"185.6","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":"3062321","reservation_id":"90384","confirmation_number":"SJ12678883321","room_stay_from":"2020-02-16","room_stay_to":"2020-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,179.00,179.00,179.00","nightly_discount":"0,0,0,0,0","subtotal":"895.00","grand_total":"1006.88","paid_amount":"1006.88","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-2675516415","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":"96433","customer_id":"96433","source_of_creation":"Booking.com","reservation_created_date":"2020-01-22 21:03:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"93.20","currentDayPrice":"179.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":"3067074","reservation_id":"91528","confirmation_number":"SJ12680047639","room_stay_from":"2020-02-18","room_stay_to":"2020-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.00,235.00,235.00","nightly_discount":"0,0,0","subtotal":"705.00","grand_total":"793.13","paid_amount":"793.13","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-2553607367","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":"97660","customer_id":"97660","source_of_creation":"Booking.com","reservation_created_date":"2020-02-07 22:40:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"142.08","currentDayPrice":"235.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":"3071172","reservation_id":"89489","confirmation_number":"SJ12628853345","room_stay_from":"2020-02-18","room_stay_to":"2020-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"281.70,281.70,281.70","nightly_discount":"0,0,0","subtotal":"845.10","grand_total":"950.74","paid_amount":"950.74","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-3242162563","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":"98343","customer_id":"98343","source_of_creation":"Booking.com","reservation_created_date":"2020-01-07 02:38:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"167.30","currentDayPrice":"281.70","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":"3071524","reservation_id":"91676","confirmation_number":"SJ12659478806","room_stay_from":"2020-02-19","room_stay_to":"2020-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.00,235.00","nightly_discount":"0,0","subtotal":"470.00","grand_total":"528.75","paid_amount":"528.75","room_type_id":"413","product_id":"1272","siteminder_id":"BDC-3395896789","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":"97818","customer_id":"97818","source_of_creation":"Booking.com","reservation_created_date":"2020-02-09 22:46:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"94.72","currentDayPrice":"235.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":"3071558","reservation_id":"91845","confirmation_number":"SJ12644371136","room_stay_from":"2020-02-19","room_stay_to":"2020-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"190.35,190.35","nightly_discount":"0,0","subtotal":"380.70","grand_total":"428.29","paid_amount":"428.29","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-2456677502","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":"97996","customer_id":"97996","source_of_creation":"Booking.com","reservation_created_date":"2020-02-12 11:49:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"78.65","currentDayPrice":"190.35","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":"3071560","reservation_id":"91599","confirmation_number":"SJ12654300184","room_stay_from":"2020-02-19","room_stay_to":"2020-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.00,235.00","nightly_discount":"0,0","subtotal":"470.00","grand_total":"528.75","paid_amount":"528.75","room_type_id":"319","product_id":"1311","siteminder_id":"BDC-2495591859","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":"97733","customer_id":"97733","source_of_creation":"Booking.com","reservation_created_date":"2020-02-08 19:52:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"94.72","currentDayPrice":"235.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":"3060683","reservation_id":"90373","confirmation_number":"SJ12685896286","room_stay_from":"2020-02-18","room_stay_to":"2020-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129,129,129,165","nightly_discount":"0,0,0,0","subtotal":"552.00","grand_total":"621.00","paid_amount":"621.00","room_type_id":"413","product_id":"1268","siteminder_id":"BDC-3377808825","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96421","customer_id":"96421","source_of_creation":"Booking.com","reservation_created_date":"2020-01-22 19:25:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"155.61","currentDayPrice":"129","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":"3066716","reservation_id":"91460","confirmation_number":"SJ12699794213","room_stay_from":"2020-02-16","room_stay_to":"2020-02-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"297.00,297.00,297.00,297.00,297.00,350.00,350.00,297.00","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"2482.00","grand_total":"2792.25","paid_amount":"2792.25","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-3686831090","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":"97588","customer_id":"97588","source_of_creation":"Booking.com","reservation_created_date":"2020-02-06 23:01:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"487.25","currentDayPrice":"297.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":"3071321","reservation_id":"91290","confirmation_number":"SJ12654598105","room_stay_from":"2020-02-18","room_stay_to":"2020-02-24","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"185.6,185.6,185.6,237.44,237.44,185.6","nightly_discount":"0,0,0,0,0,0","subtotal":"1217.28","grand_total":"1369.44","paid_amount":"1369.44","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-2283629447","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98364","customer_id":"98364","source_of_creation":"Booking.com","reservation_created_date":"2020-02-04 17:24:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"276.48","currentDayPrice":"185.6","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":"3071624","reservation_id":"91274","confirmation_number":"SJ12689244150","room_stay_from":"2020-02-19","room_stay_to":"2020-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"260.00,260.00,285.00,285.00,260.00,260.00,260.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1870.00","grand_total":"2103.75","paid_amount":"2103.75","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-2590800078","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":"97397","customer_id":"97397","source_of_creation":"Booking.com","reservation_created_date":"2020-02-04 04:14:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"372.03","currentDayPrice":"260.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3067198","reservation_id":"91549","confirmation_number":"SJ12635101942","room_stay_from":"2020-02-17","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20,143.20","nightly_discount":"0,0,0","subtotal":"429.60","grand_total":"483.30","paid_amount":"483.30","room_type_id":"413","product_id":"1270","siteminder_id":"EXP-1637634703","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":"97684","customer_id":"97684","source_of_creation":"Expedia","reservation_created_date":"2020-02-08 03:18:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"143.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":"3069332","reservation_id":"91884","confirmation_number":"SJ12642220472","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"187.20","nightly_discount":"0","subtotal":"187.20","grand_total":"210.60","paid_amount":"210.60","room_type_id":"319","product_id":"1291","siteminder_id":"EXP-1640534483","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":"98029","customer_id":"98029","source_of_creation":"Expedia","reservation_created_date":"2020-02-12 22:18:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","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":"3070496","reservation_id":"92066","confirmation_number":"SJ12652313419","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"204.00","nightly_discount":"0","subtotal":"204.00","grand_total":"229.50","paid_amount":"229.50","room_type_id":"319","product_id":"1301","siteminder_id":"EXP-1642905464","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":"98236","customer_id":"98236","source_of_creation":"Expedia","reservation_created_date":"2020-02-16 21:29:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"204.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":"3071550","reservation_id":"92126","confirmation_number":"SJ12671033964","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"224.00","nightly_discount":"0","subtotal":"224.00","grand_total":"252.00","paid_amount":"252.00","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1643736260","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":"98311","customer_id":"98311","source_of_creation":"Expedia","reservation_created_date":"2020-02-18 02:44:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"224.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3071620","reservation_id":"92157","confirmation_number":"SJ12696929179","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"183.60","nightly_discount":"0","subtotal":"183.60","grand_total":"206.55","paid_amount":"206.55","room_type_id":"319","product_id":"1756","siteminder_id":"EXP-1644223186","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":"98339","customer_id":"98339","source_of_creation":"Expedia","reservation_created_date":"2020-02-18 21:14:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"183.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":"3071642","reservation_id":"92156","confirmation_number":"SJ12679143735","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60","nightly_discount":"0","subtotal":"183.60","grand_total":"206.55","paid_amount":"206.55","room_type_id":"319","product_id":"1310","siteminder_id":"EXP-1644216981","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":"98337","customer_id":"98337","source_of_creation":"Expedia","reservation_created_date":"2020-02-18 21:04:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"183.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":"3062582","reservation_id":"90748","confirmation_number":"SJ12685484595","room_stay_from":"2020-02-17","room_stay_to":"2020-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"221.76,221.76,221.76,221.76","nightly_discount":"0,0,0,0","subtotal":"887.04","grand_total":"997.92","paid_amount":"997.92","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1631004329","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":"96829","customer_id":"96829","source_of_creation":"Expedia","reservation_created_date":"2020-01-28 03:13:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"221.76","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3066378","reservation_id":"91386","confirmation_number":"SJ12629256568","room_stay_from":"2020-02-19","room_stay_to":"2020-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20","nightly_discount":"0,0","subtotal":"338.40","grand_total":"380.70","paid_amount":"380.70","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1636226950","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":"97512","customer_id":"97512","source_of_creation":"Expedia","reservation_created_date":"2020-02-05 23:08:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"169.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":"3068863","reservation_id":"89350","confirmation_number":"SJ12697314953","room_stay_from":"2020-02-18","room_stay_to":"2020-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.10,269.10,269.10","nightly_discount":"0,0,0","subtotal":"807.30","grand_total":"908.22","paid_amount":"908.22","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1617412415","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":"95336","customer_id":"95336","source_of_creation":"Expedia","reservation_created_date":"2020-01-04 23:22:11","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":"3071565","reservation_id":"90388","confirmation_number":"SJ12635079630","room_stay_from":"2020-02-19","room_stay_to":"2020-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"143.20,143.20","nightly_discount":"0,0","subtotal":"286.40","grand_total":"322.20","paid_amount":"322.20","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1627934383","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":"96439","customer_id":"96439","source_of_creation":"Expedia","reservation_created_date":"2020-01-22 22:08:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"143.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":"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":"143.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":"3067347","reservation_id":"91589","confirmation_number":"SJ12669625332","room_stay_from":"2020-02-18","room_stay_to":"2020-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,169.20,215.28","nightly_discount":"0,0,0,0","subtotal":"722.88","grand_total":"813.24","paid_amount":"813.24","room_type_id":"319","product_id":"1307","siteminder_id":"EXP-1637893744","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":"97723","customer_id":"97723","source_of_creation":"Expedia","reservation_created_date":"2020-02-08 17:48:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"169.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":"3071612","reservation_id":"91141","confirmation_number":"SJ12652068016","room_stay_from":"2020-02-19","room_stay_to":"2020-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"297.00,297.00,320.00","nightly_discount":"0,0,0","subtotal":"914.00","grand_total":"1028.25","paid_amount":"1028.25","room_type_id":"319","product_id":"1308","siteminder_id":"EXP-1634214207","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":"97267","customer_id":"97267","source_of_creation":"Expedia","reservation_created_date":"2020-02-02 17:48:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"297.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":"3064470","reservation_id":"86226","confirmation_number":"SJ12623152941","room_stay_from":"2020-02-19","room_stay_to":"2020-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.40,230.40,272.80,272.80","nightly_discount":"0,0,0,0","subtotal":"1006.40","grand_total":"1132.20","paid_amount":"1132.20","room_type_id":"319","product_id":"1287","siteminder_id":"EXP-1368516075","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":"93057","customer_id":"93057","source_of_creation":"Expedia","reservation_created_date":"2019-10-25 17:51:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"230.40","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":"3067068","reservation_id":"91526","confirmation_number":"SJ12663957357","room_stay_from":"2020-02-19","room_stay_to":"2020-02-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,215.28,215.28,169.20","nightly_discount":"0,0,0,0,0","subtotal":"938.16","grand_total":"1055.43","paid_amount":"1055.43","room_type_id":"319","product_id":"1312","siteminder_id":"EXP-1637501621","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":"97658","customer_id":"97658","source_of_creation":"Expedia","reservation_created_date":"2020-02-07 22:33:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"169.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":"3067849","reservation_id":"91479","confirmation_number":"SJ12648475345","room_stay_from":"2020-02-17","room_stay_to":"2020-02-24","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"188.00,188.00,188.00,188.00,239.20,239.20,188.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1418.40","grand_total":"1595.70","paid_amount":"1595.70","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1637060345","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":"97605","customer_id":"97605","source_of_creation":"Expedia","reservation_created_date":"2020-02-07 05:18:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"188.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":"230.40","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":"3055191","reservation_id":"81442","confirmation_number":"SJ12689674724","room_stay_from":"2020-02-19","room_stay_to":"2020-02-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.40,230.40,272.80,272.80,230.40,230.40","nightly_discount":"0,0,0,0,0,0","subtotal":"1467.20","grand_total":"1650.60","paid_amount":"1650.60","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1308189130","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":"89401","customer_id":"89401","source_of_creation":"Expedia","reservation_created_date":"2019-07-25 23:50:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"230.40","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":"3068320","reservation_id":"91720","confirmation_number":"SJ12672974380","room_stay_from":"2020-02-19","room_stay_to":"2020-02-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,215.28,215.28,169.20,169.20,169.20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1276.56","grand_total":"1436.13","paid_amount":"1436.13","room_type_id":"319","product_id":"1942","siteminder_id":"EXP-1638957185","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":"97859","customer_id":"97859","source_of_creation":"Expedia","reservation_created_date":"2020-02-10 15:49:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"169.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3066811","reservation_id":"91301","confirmation_number":"SJ12631101480","room_stay_from":"2020-02-18","room_stay_to":"2020-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"156.09,156.09,156.09","nightly_discount":"0,0,0","subtotal":"468.27","grand_total":"526.80","paid_amount":"526.80","room_type_id":"319","product_id":"1286","siteminder_id":"HTN-117871369-DKMWQW","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":"97425","customer_id":"97425","source_of_creation":"HotelTonight","reservation_created_date":"2020-02-04 19:15:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"156.09","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"}]}],"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":"3055166","reservation_id":"89539","confirmation_number":"SJ12619556709","room_stay_from":"2020-02-16","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"277.13,277.13,277.13,277.13","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1108.52","grand_total":"1247.09","paid_amount":"1247.09","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95520","customer_id":"95520","source_of_creation":"FE","reservation_created_date":"2020-01-08 00:56:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"277.13","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068615","reservation_id":"89544","confirmation_number":"SJ12695926933","room_stay_from":"2020-02-15","room_stay_to":"2020-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"277.13,277.13,277.13,277.13,277.13,277.13","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1662.78","grand_total":"1870.63","paid_amount":"1870.63","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95525","customer_id":"95525","source_of_creation":"FE","reservation_created_date":"2020-01-08 02:31:16","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"277.13","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3071580","reservation_id":"91253","confirmation_number":"SJ12628843193","room_stay_from":"2020-02-19","room_stay_to":"2020-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.00,235.00,260.00","nightly_discount":"0.00,0.00,0.00","subtotal":"730.00","grand_total":"821.25","paid_amount":"821.25","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":"97376","customer_id":"97376","source_of_creation":"FE","reservation_created_date":"2020-02-03 22:48:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"235.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3065379","reservation_id":"91182","confirmation_number":"SJ12660342137","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.10","nightly_discount":"0.00","subtotal":"125.10","grand_total":"140.74","paid_amount":"140.74","room_type_id":"319","product_id":"1711","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":"97307","customer_id":"97307","source_of_creation":"PMS","reservation_created_date":"2020-02-02 23:52:59","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"125.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3067078","reservation_id":"91530","confirmation_number":"SJ12650206995","room_stay_from":"2020-02-18","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"211.50,211.50","nightly_discount":"0.00,0.00","subtotal":"423.00","grand_total":"475.88","paid_amount":"475.88","room_type_id":"318","product_id":"1289","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":"97662","customer_id":"97662","source_of_creation":"PMS","reservation_created_date":"2020-02-07 23:01:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"211.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":"3071248","reservation_id":"92168","confirmation_number":"SJ12671311860","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"297.00","nightly_discount":"0.00","subtotal":"297.00","grand_total":"334.13","paid_amount":"334.13","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":"98352","customer_id":"98352","source_of_creation":"PMS","reservation_created_date":"2020-02-18 23:50:24","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"297.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":"3071353","reservation_id":"92185","confirmation_number":"SJ12641731036","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00","nightly_discount":"0.00","subtotal":"255.00","grand_total":"286.88","paid_amount":"286.88","room_type_id":"318","product_id":"1281","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98370","customer_id":"98370","source_of_creation":"PMS","reservation_created_date":"2020-02-19 13:01:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"255.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":"3066527","reservation_id":"91424","confirmation_number":"SJ12618339365","room_stay_from":"2020-02-18","room_stay_to":"2020-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"235.00,235.00,235.00","nightly_discount":"0.00,0.00,0.00","subtotal":"705.00","grand_total":"793.13","paid_amount":"793.13","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97553","customer_id":"97553","source_of_creation":"PMS","reservation_created_date":"2020-02-06 17:41:35","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"235.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":"3067862","reservation_id":"91237","confirmation_number":"SJ12699379800","room_stay_from":"2020-02-17","room_stay_to":"2020-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"234.00,234.00,234.00,234.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"936.00","grand_total":"1053.00","paid_amount":"1053.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":"97360","customer_id":"97360","source_of_creation":"PMS","reservation_created_date":"2020-02-03 20:21:35","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"234.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":"3069910","reservation_id":"91978","confirmation_number":"SJ12674678772","room_stay_from":"2020-02-16","room_stay_to":"2020-02-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,159.00,159.00,159.00,159.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"795.00","grand_total":"894.38","paid_amount":"0.00","room_type_id":"319","product_id":"1314","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":"98127","customer_id":"98127","source_of_creation":"PMS","reservation_created_date":"2020-02-14 19:45:51","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"159.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":"3071539","reservation_id":"91912","confirmation_number":"SJ12637915180","room_stay_from":"2020-02-19","room_stay_to":"2020-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.00,235.00,299.00","nightly_discount":"0.00,0.00,0.00","subtotal":"769.00","grand_total":"865.13","paid_amount":"865.13","room_type_id":"319","product_id":"1303","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98057","customer_id":"98057","source_of_creation":"PMS","reservation_created_date":"2020-02-13 14:04:43","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"235.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":"3071651","reservation_id":"91062","confirmation_number":"SJ12649941114","room_stay_from":"2020-02-19","room_stay_to":"2020-02-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.00,235.00,260.00,260.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"990.00","grand_total":"1113.75","paid_amount":"1113.75","room_type_id":"319","product_id":"1302","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97172","customer_id":"97172","source_of_creation":"PMS","reservation_created_date":"2020-02-01 17:20:01","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"235.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"}]}],"pms_non_taxable":[{"room_stay_id":"3060585","reservation_id":"86723","confirmation_number":"SJ12614566986","room_stay_from":"2020-02-15","room_stay_to":"2020-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1278","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"74797","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2019-11-05 22:45:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3062936","reservation_id":"90831","confirmation_number":"SJ12684937263","room_stay_from":"2020-02-15","room_stay_to":"2020-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-01-29 00:33:58","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3067843","reservation_id":"90820","confirmation_number":"SJ12631965344","room_stay_from":"2020-02-15","room_stay_to":"2020-02-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"412","product_id":"1316","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-01-28 22:46:21","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[{"room_stay_id":"3071779","reservation_id":"89248","confirmation_number":"SJ12689909766","room_stay_from":"2020-02-19","room_stay_to":"2020-02-24","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"128.00,0.00,128.00,128.00,128.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"512.00","grand_total":"512.00","paid_amount":"140.63","room_type_id":"319","product_id":"1319","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-01-03 19:37:45","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","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":"3061126","reservation_id":"90457","confirmation_number":"SJ12655020859","room_confirmation_number":"SJ12632069723","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","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":"96510","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-01-23 20:51:12","reservation_modified_date_time":"2020-01-23 20:51:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96510","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":"3062883","reservation_id":"90381","confirmation_number":"SJ12623095880","room_confirmation_number":"SJ12689471167","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","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":"96429","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-01-28 22:32:55","reservation_modified_date_time":"2020-01-28 22:32:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96429","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":"3066816","reservation_id":"91358","confirmation_number":"SJ12620763248","room_confirmation_number":"SJ12692733016","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","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":"97485","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-07 12:54:43","reservation_modified_date_time":"2020-02-07 12:54:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97485","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":"3067079","reservation_id":"91530","confirmation_number":"SJ12692013312","room_confirmation_number":"SJ12650206995","room_stay_from":"2020-02-18","room_stay_to":"2020-02-20","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":"97662","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-07 23:01:52","reservation_modified_date_time":"2020-02-07 23:01:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97662","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":"3071548","reservation_id":"91152","confirmation_number":"SJ12627265007","room_confirmation_number":"SJ12622517863","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"97278","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-19 20:48:42","reservation_modified_date_time":"2020-02-19 20:48:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97278","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":"3060684","reservation_id":"90373","confirmation_number":"SJ12648262610","room_confirmation_number":"SJ12685896286","room_stay_from":"2020-02-18","room_stay_to":"2020-02-22","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"96421","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-01-22 19:25:09","reservation_modified_date_time":"2020-01-22 19:25:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96421","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":"3071319","reservation_id":"91290","confirmation_number":"SJ12691976938","room_confirmation_number":"SJ12654598105","room_stay_from":"2020-02-18","room_stay_to":"2020-02-24","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"98364","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-13 23:27:19","reservation_modified_date_time":"2020-02-19 03:25:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98364","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3055167","reservation_id":"89539","confirmation_number":"SJ12687181682","room_confirmation_number":"SJ12619556709","room_stay_from":"2020-02-16","room_stay_to":"2020-02-20","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":"95520","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-08 00:56:27","reservation_modified_date_time":"2020-01-08 00:56:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95520","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":"3061127","reservation_id":"90457","confirmation_number":"SJ12627796943","room_confirmation_number":"SJ12632069723","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","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":"96510","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-23 20:51:12","reservation_modified_date_time":"2020-01-23 20:51:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96510","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":"3062320","reservation_id":"90491","confirmation_number":"SJ12611384338","room_confirmation_number":"SJ12672335749","room_stay_from":"2020-02-18","room_stay_to":"2020-02-20","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":"96548","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-24 14:38:08","reservation_modified_date_time":"2020-01-24 14:38:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96548","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":"3062884","reservation_id":"90381","confirmation_number":"SJ12629501406","room_confirmation_number":"SJ12689471167","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","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":"96429","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-22 20:39:11","reservation_modified_date_time":"2020-01-28 22:32:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96429","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":"3062886","reservation_id":"90801","confirmation_number":"SJ12680893220","room_confirmation_number":"SJ12646447645","room_stay_from":"2020-02-18","room_stay_to":"2020-02-20","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":"96888","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 20:03:11","reservation_modified_date_time":"2020-01-28 22:33:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96888","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":"3065380","reservation_id":"91182","confirmation_number":"SJ12615433168","room_confirmation_number":"SJ12660342137","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","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":"97307","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 23:53:00","reservation_modified_date_time":"2020-02-02 23:53:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97307","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":"3066817","reservation_id":"91358","confirmation_number":"SJ12674842588","room_confirmation_number":"SJ12692733016","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","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":"97485","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-05 15:47:12","reservation_modified_date_time":"2020-02-07 12:54:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97485","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":"3067080","reservation_id":"91530","confirmation_number":"SJ12679269890","room_confirmation_number":"SJ12650206995","room_stay_from":"2020-02-18","room_stay_to":"2020-02-20","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":"97662","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-07 23:01:52","reservation_modified_date_time":"2020-02-07 23:01:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97662","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":"3067199","reservation_id":"91549","confirmation_number":"SJ12694551825","room_confirmation_number":"SJ12635101942","room_stay_from":"2020-02-17","room_stay_to":"2020-02-20","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":"97684","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 03:18:10","reservation_modified_date_time":"2020-02-08 03:18:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97684","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":"3068581","reservation_id":"91750","confirmation_number":"SJ12672915979","room_confirmation_number":"SJ12667844915","room_stay_from":"2020-02-18","room_stay_to":"2020-02-20","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":"97892","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-10 22:18:11","reservation_modified_date_time":"2020-02-10 22:18:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97892","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":"3069333","reservation_id":"91884","confirmation_number":"SJ12656638538","room_confirmation_number":"SJ12642220472","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","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":"98029","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 22:18:07","reservation_modified_date_time":"2020-02-12 22:18:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98029","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":"3070497","reservation_id":"92066","confirmation_number":"SJ12620385444","room_confirmation_number":"SJ12652313419","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","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":"98236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-16 21:29:10","reservation_modified_date_time":"2020-02-16 21:29:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98236","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":"3071148","reservation_id":"91216","confirmation_number":"SJ12698216506","room_confirmation_number":"SJ12649394661","room_stay_from":"2020-02-18","room_stay_to":"2020-02-20","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":"98335","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 17:30:10","reservation_modified_date_time":"2020-02-18 21:01:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98335","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":"3071249","reservation_id":"92168","confirmation_number":"SJ12688243165","room_confirmation_number":"SJ12671311860","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","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":"98352","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-18 23:50:24","reservation_modified_date_time":"2020-02-18 23:50:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98352","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":"3071354","reservation_id":"92185","confirmation_number":"SJ12625079059","room_confirmation_number":"SJ12641731036","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","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":"98370","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-19 13:01:28","reservation_modified_date_time":"2020-02-19 13:01:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98370","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":"3071549","reservation_id":"91152","confirmation_number":"SJ12615698804","room_confirmation_number":"SJ12622517863","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","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":"97278","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 19:25:06","reservation_modified_date_time":"2020-02-19 20:48:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97278","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":"3071551","reservation_id":"92126","confirmation_number":"SJ12633004405","room_confirmation_number":"SJ12671033964","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","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":"98311","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-18 02:44:10","reservation_modified_date_time":"2020-02-19 20:49:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98311","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":"3071621","reservation_id":"92157","confirmation_number":"SJ12612923757","room_confirmation_number":"SJ12696929179","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","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":"98339","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-18 21:14:09","reservation_modified_date_time":"2020-02-19 21:34:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98339","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":"3071643","reservation_id":"92156","confirmation_number":"SJ12645977822","room_confirmation_number":"SJ12679143735","room_stay_from":"2020-02-19","room_stay_to":"2020-02-20","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":"98337","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-18 21:04:11","reservation_modified_date_time":"2020-02-19 21:43:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98337","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":"3062322","reservation_id":"90384","confirmation_number":"SJ12665944679","room_confirmation_number":"SJ12678883321","room_stay_from":"2020-02-16","room_stay_to":"2020-02-21","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,0","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"96433","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-22 21:03:11","reservation_modified_date_time":"2020-01-22 21:03:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96433","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":"3062583","reservation_id":"90748","confirmation_number":"SJ12650904386","room_confirmation_number":"SJ12685484595","room_stay_from":"2020-02-17","room_stay_to":"2020-02-21","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":"96829","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 03:13:06","reservation_modified_date_time":"2020-01-28 03:13:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96829","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":"3066379","reservation_id":"91386","confirmation_number":"SJ12680130423","room_confirmation_number":"SJ12629256568","room_stay_from":"2020-02-19","room_stay_to":"2020-02-21","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":"97512","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-05 23:08:11","reservation_modified_date_time":"2020-02-05 23:08:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97512","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":"3066528","reservation_id":"91424","confirmation_number":"SJ12676898697","room_confirmation_number":"SJ12618339365","room_stay_from":"2020-02-18","room_stay_to":"2020-02-21","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":"97553","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 17:41:35","reservation_modified_date_time":"2020-02-06 17:41:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97553","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":"3066812","reservation_id":"91301","confirmation_number":"SJ12635220010","room_confirmation_number":"SJ12631101480","room_stay_from":"2020-02-18","room_stay_to":"2020-02-21","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":"97425","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-04 19:15:06","reservation_modified_date_time":"2020-02-07 12:53:55","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97425","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":"3067075","reservation_id":"91528","confirmation_number":"SJ12628502507","room_confirmation_number":"SJ12680047639","room_stay_from":"2020-02-18","room_stay_to":"2020-02-21","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":"97660","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-07 22:40:12","reservation_modified_date_time":"2020-02-07 22:40:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97660","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":"3067863","reservation_id":"91237","confirmation_number":"SJ12688649522","room_confirmation_number":"SJ12699379800","room_stay_from":"2020-02-17","room_stay_to":"2020-02-21","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":"97360","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 20:21:35","reservation_modified_date_time":"2020-02-09 17:41:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97360","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068616","reservation_id":"89544","confirmation_number":"SJ12684837828","room_confirmation_number":"SJ12695926933","room_stay_from":"2020-02-15","room_stay_to":"2020-02-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"95525","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-08 02:31:16","reservation_modified_date_time":"2020-02-10 23:15:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95525","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068864","reservation_id":"89350","confirmation_number":"SJ12649441457","room_confirmation_number":"SJ12697314953","room_stay_from":"2020-02-18","room_stay_to":"2020-02-21","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":"95336","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-04 23:22:11","reservation_modified_date_time":"2020-02-11 15:29:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95336","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":"3069911","reservation_id":"91978","confirmation_number":"SJ12631226883","room_confirmation_number":"SJ12674678772","room_stay_from":"2020-02-16","room_stay_to":"2020-02-21","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":"98128","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-14 19:45:51","reservation_modified_date_time":"2020-02-14 19:45:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98127","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":"3071341","reservation_id":"89489","confirmation_number":"SJ12636616711","room_confirmation_number":"SJ12628853345","room_stay_from":"2020-02-18","room_stay_to":"2020-02-21","room_stay_status":"Active","nightly_price":"28.12,28.12,28.12","nightly_discount":"0.00,0.00,0.00","subtotal":"84.36","grand_total":"94.90","paid_amount":"94.90","product_id":"1776","service_quantity":"1","customer_traveller_id":"98343","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-01-07 02:38:06","reservation_modified_date_time":"2020-02-19 09:10:56","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98343","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"3.12","currentDayPrice":"28.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3071525","reservation_id":"91676","confirmation_number":"SJ12689261562","room_confirmation_number":"SJ12659478806","room_stay_from":"2020-02-19","room_stay_to":"2020-02-21","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":"97818","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 22:46:10","reservation_modified_date_time":"2020-02-19 20:30:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97818","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":"3071559","reservation_id":"91845","confirmation_number":"SJ12670205074","room_confirmation_number":"SJ12644371136","room_stay_from":"2020-02-19","room_stay_to":"2020-02-21","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":"97996","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 11:49:12","reservation_modified_date_time":"2020-02-19 21:00:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97996","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":"3071561","reservation_id":"91599","confirmation_number":"SJ12695784272","room_confirmation_number":"SJ12654300184","room_stay_from":"2020-02-19","room_stay_to":"2020-02-21","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":"97733","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 19:52:11","reservation_modified_date_time":"2020-02-19 21:08:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97733","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":"3071566","reservation_id":"90388","confirmation_number":"SJ12694564248","room_confirmation_number":"SJ12635079630","room_stay_from":"2020-02-19","room_stay_to":"2020-02-21","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":"96439","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-22 22:08:10","reservation_modified_date_time":"2020-02-19 21:10:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96439","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3060586","reservation_id":"86723","confirmation_number":"SJ12662273453","room_confirmation_number":"SJ12614566986","room_stay_from":"2020-02-15","room_stay_to":"2020-02-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"93397","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-05 22:45:06","reservation_modified_date_time":"2019-11-05 22:45:06","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3060685","reservation_id":"90373","confirmation_number":"SJ12620802238","room_confirmation_number":"SJ12685896286","room_stay_from":"2020-02-18","room_stay_to":"2020-02-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"96421","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-22 19:25:09","reservation_modified_date_time":"2020-01-22 19:25:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96421","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":"3062937","reservation_id":"90831","confirmation_number":"SJ12620741089","room_confirmation_number":"SJ12684937263","room_stay_from":"2020-02-15","room_stay_to":"2020-02-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"96922","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 00:33:58","reservation_modified_date_time":"2020-01-29 00:33:58","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3067348","reservation_id":"91589","confirmation_number":"SJ12673498605","room_confirmation_number":"SJ12669625332","room_stay_from":"2020-02-18","room_stay_to":"2020-02-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"97723","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 17:48:09","reservation_modified_date_time":"2020-02-08 17:48:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97723","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":"3067844","reservation_id":"90820","confirmation_number":"SJ12636431548","room_confirmation_number":"SJ12631965344","room_stay_from":"2020-02-15","room_stay_to":"2020-02-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"96904","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 22:46:21","reservation_modified_date_time":"2020-02-09 17:34:52","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3071540","reservation_id":"91912","confirmation_number":"SJ12623505754","room_confirmation_number":"SJ12637915180","room_stay_from":"2020-02-19","room_stay_to":"2020-02-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98057","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-13 14:04:43","reservation_modified_date_time":"2020-02-19 20:43:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98057","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":"3071581","reservation_id":"91253","confirmation_number":"SJ12626771568","room_confirmation_number":"SJ12628843193","room_stay_from":"2020-02-19","room_stay_to":"2020-02-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"97376","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 22:48:57","reservation_modified_date_time":"2020-02-19 21:24:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97376","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":"3071614","reservation_id":"91141","confirmation_number":"SJ12631075625","room_confirmation_number":"SJ12652068016","room_stay_from":"2020-02-19","room_stay_to":"2020-02-22","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"97267","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 17:48:07","reservation_modified_date_time":"2020-02-19 21:31:44","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97267","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":"3064475","reservation_id":"86226","confirmation_number":"SJ12616020055","room_confirmation_number":"SJ12623152941","room_stay_from":"2020-02-19","room_stay_to":"2020-02-23","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":"93057","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-25 17:51:08","reservation_modified_date_time":"2020-02-01 18:50:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93057","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":"3071652","reservation_id":"91062","confirmation_number":"SJ12616016557","room_confirmation_number":"SJ12649941114","room_stay_from":"2020-02-19","room_stay_to":"2020-02-23","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":"97172","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 17:20:01","reservation_modified_date_time":"2020-02-19 21:47:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97172","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":"3066717","reservation_id":"91460","confirmation_number":"SJ12656868277","room_confirmation_number":"SJ12699794213","room_stay_from":"2020-02-16","room_stay_to":"2020-02-24","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":"97588","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 23:01:09","reservation_modified_date_time":"2020-02-06 23:01:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97588","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":"3067069","reservation_id":"91526","confirmation_number":"SJ12697001929","room_confirmation_number":"SJ12663957357","room_stay_from":"2020-02-19","room_stay_to":"2020-02-24","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":"97658","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-07 22:33:08","reservation_modified_date_time":"2020-02-07 22:33:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97658","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":"3067852","reservation_id":"91479","confirmation_number":"SJ12653888786","room_confirmation_number":"SJ12648475345","room_stay_from":"2020-02-17","room_stay_to":"2020-02-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"97605","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-07 05:18:09","reservation_modified_date_time":"2020-02-09 17:38:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97605","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":"3071320","reservation_id":"91290","confirmation_number":"SJ12617144231","room_confirmation_number":"SJ12654598105","room_stay_from":"2020-02-18","room_stay_to":"2020-02-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"98364","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-04 17:24:12","reservation_modified_date_time":"2020-02-19 03:25:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98364","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":"3071780","reservation_id":"89248","confirmation_number":"SJ12665588801","room_confirmation_number":"SJ12689909766","room_stay_from":"2020-02-19","room_stay_to":"2020-02-24","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":"95271","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-03 19:37:45","reservation_modified_date_time":"2020-02-20 00:52:38","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":"3055190","reservation_id":"89207","confirmation_number":"SJ12674011392","room_confirmation_number":"SJ12682005213","room_stay_from":"2020-02-14","room_stay_to":"2020-02-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"275.00","grand_total":"309.38","paid_amount":"309.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"95234","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-03 04:07:10","reservation_modified_date_time":"2020-01-03 04:07:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95234","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3055192","reservation_id":"81442","confirmation_number":"SJ12670747118","room_confirmation_number":"SJ12689674724","room_stay_from":"2020-02-19","room_stay_to":"2020-02-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"89401","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-25 23:50:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89401","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":"3068321","reservation_id":"91720","confirmation_number":"SJ12657276447","room_confirmation_number":"SJ12672974380","room_stay_from":"2020-02-19","room_stay_to":"2020-02-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"97859","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-10 15:49:09","reservation_modified_date_time":"2020-02-10 15:49:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97859","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":"3071625","reservation_id":"91274","confirmation_number":"SJ12659422499","room_confirmation_number":"SJ12689244150","room_stay_from":"2020-02-19","room_stay_to":"2020-02-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"97397","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-04 04:14:12","reservation_modified_date_time":"2020-02-19 21:36:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97397","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":"3071340","reservation_id":"91359","confirmation_number":"SJ12698724966","room_confirmation_number":"SJ12688539616","room_stay_from":"2020-02-17","room_stay_to":"2020-02-19","room_stay_status":"Active","nightly_price":"28.12,28.12","nightly_discount":"0.00,0.00","subtotal":"56.24","grand_total":"63.27","paid_amount":"63.27","product_id":"1776","service_quantity":"1","customer_traveller_id":"98380","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-02-05 16:52:10","reservation_modified_date_time":"2020-02-19 08:56:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98380","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"6.24","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3071755","reservation_id":"91274","confirmation_number":"SJ12644744370","room_confirmation_number":"SJ12689244150","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.86","grand_total":"2.00","paid_amount":"2.00","product_id":"1667","service_quantity":"1","product_name":"Koozie","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-19 23:48:10","reservation_modified_date_time":"2020-02-19 23:48:10","customer_id":"97397","parentCustTravId":"97397","customer_traveller_id":"97397","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":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3071804","reservation_id":"91884","confirmation_number":"SJ12692523092","room_confirmation_number":"SJ12642220472","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"10.00","paid_amount":"10.00","product_id":"1231","service_quantity":"1","product_name":"Customer Tip for Matthew Boyle","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:17:04","reservation_modified_date_time":"2020-02-20 04:17:04","customer_id":"98029","parentCustTravId":"98029","customer_traveller_id":"98029","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":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3071813","reservation_id":"90831","confirmation_number":"SJ12656267023","room_confirmation_number":"SJ12684937263","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.00","grand_total":"7.00","paid_amount":"7.00","product_id":"1231","service_quantity":"1","product_name":"Customer Tip for Matthew Boyle","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:25:50","reservation_modified_date_time":"2020-02-20 04:25:50","customer_id":"81161","parentCustTravId":"81161","customer_traveller_id":"96922","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3071815","reservation_id":"91141","confirmation_number":"SJ12627810381","room_confirmation_number":"SJ12652068016","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"8.00","grand_total":"8.00","paid_amount":"8.00","product_id":"1231","service_quantity":"1","product_name":"Customer Tip for Matthew Boyle","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:27:27","reservation_modified_date_time":"2020-02-20 04:27:27","customer_id":"97267","parentCustTravId":"97267","customer_traveller_id":"97267","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":"8.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3071356","reservation_id":"92186","confirmation_number":"SJ12672215397","room_confirmation_number":"SJ12640713120","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-19 13:12:29","reservation_modified_date_time":"2020-02-19 13:12:29","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"}]},{"room_stay_id":"3071694","reservation_id":"92220","confirmation_number":"SJ12643763627","room_confirmation_number":"SJ12637105305","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"2.50","paid_amount":"2.50","product_id":null,"service_quantity":"1","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-19 22:50:04","reservation_modified_date_time":"2020-02-19 22:50:04","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.33","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[{"room_stay_id":"3071802","reservation_id":"89489","confirmation_number":"SJ12677621837","room_confirmation_number":"SJ12628853345","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":"1393","service_quantity":"1","product_name":"Islamorada Ale Draft","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:15:20","reservation_modified_date_time":"2020-02-20 04:15:20","customer_id":"98343","parentCustTravId":"98343","customer_traveller_id":"98343","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071803","reservation_id":"89489","confirmation_number":"SJ12612317881","room_confirmation_number":"SJ12628853345","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.41","grand_total":"16.00","paid_amount":"16.00","product_id":"1397","service_quantity":"2","product_name":"Jameson","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:15:20","reservation_modified_date_time":"2020-02-20 04:15:20","customer_id":"98343","parentCustTravId":"98343","customer_traveller_id":"98343","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"14.82","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071805","reservation_id":"91884","confirmation_number":"SJ12655521840","room_confirmation_number":"SJ12642220472","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"8.34","grand_total":"36.00","paid_amount":"36.00","product_id":"1399","service_quantity":"4","product_name":"Johnny Walker Black","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:17:04","reservation_modified_date_time":"2020-02-20 04:17:04","customer_id":"98029","parentCustTravId":"98029","customer_traveller_id":"98029","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"33.36","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071806","reservation_id":"91386","confirmation_number":"SJ12647959567","room_confirmation_number":"SJ12629256568","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.41","grand_total":"8.00","paid_amount":"8.00","product_id":"1377","service_quantity":"1","product_name":"Gran Marnier","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:20:33","reservation_modified_date_time":"2020-02-20 04:20:33","customer_id":"97512","parentCustTravId":"97512","customer_traveller_id":"97512","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.41","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071811","reservation_id":"91274","confirmation_number":"SJ12654306220","room_confirmation_number":"SJ12689244150","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.41","grand_total":"8.00","paid_amount":"8.00","product_id":"1335","service_quantity":"1","product_name":"1800 Silver","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:25:06","reservation_modified_date_time":"2020-02-20 04:25:06","customer_id":"97397","parentCustTravId":"97397","customer_traveller_id":"98406","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.41","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071812","reservation_id":"91274","confirmation_number":"SJ12677121924","room_confirmation_number":"SJ12689244150","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":"1339","service_quantity":"1","product_name":"Amaretto","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:25:06","reservation_modified_date_time":"2020-02-20 04:25:06","customer_id":"97397","parentCustTravId":"97397","customer_traveller_id":"98406","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071814","reservation_id":"90831","confirmation_number":"SJ12611559774","room_confirmation_number":"SJ12684937263","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"35.00","paid_amount":"35.00","product_id":"1339","service_quantity":"7","product_name":"Amaretto","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:25:50","reservation_modified_date_time":"2020-02-20 04:25:50","customer_id":"81161","parentCustTravId":"81161","customer_traveller_id":"96922","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"32.41","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071816","reservation_id":"91141","confirmation_number":"SJ12675861708","room_confirmation_number":"SJ12652068016","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"6.48","grand_total":"7.00","paid_amount":"7.00","product_id":"1345","service_quantity":"1","product_name":"Bailey's","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:27:27","reservation_modified_date_time":"2020-02-20 04:27:27","customer_id":"97267","parentCustTravId":"97267","customer_traveller_id":"97267","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"6.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071817","reservation_id":"91141","confirmation_number":"SJ12668448292","room_confirmation_number":"SJ12652068016","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":"1339","service_quantity":"1","product_name":"Amaretto","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:27:27","reservation_modified_date_time":"2020-02-20 04:27:27","customer_id":"97267","parentCustTravId":"97267","customer_traveller_id":"97267","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071818","reservation_id":"91141","confirmation_number":"SJ12694993618","room_confirmation_number":"SJ12652068016","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.85","grand_total":"2.00","paid_amount":"2.00","product_id":"1333","service_quantity":"1","product_name":"Floater","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:27:27","reservation_modified_date_time":"2020-02-20 04:27:27","customer_id":"97267","parentCustTravId":"97267","customer_traveller_id":"97267","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"1.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071819","reservation_id":"91141","confirmation_number":"SJ12638907107","room_confirmation_number":"SJ12652068016","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.94","grand_total":"28.00","paid_amount":"28.00","product_id":"1337","service_quantity":"1","product_name":"Amado Sur (Bottle)","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:27:27","reservation_modified_date_time":"2020-02-20 04:27:27","customer_id":"97267","parentCustTravId":"97267","customer_traveller_id":"97267","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"25.94","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071820","reservation_id":"91237","confirmation_number":"SJ12690593428","room_confirmation_number":"SJ12699379800","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"40.00","paid_amount":"40.00","product_id":"1339","service_quantity":"8","product_name":"Amaretto","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:27:59","reservation_modified_date_time":"2020-02-20 04:27:59","customer_id":"97360","parentCustTravId":"97360","customer_traveller_id":"97360","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"37.04","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071360","reservation_id":"92188","confirmation_number":"SJ12642736106","room_confirmation_number":"SJ12699097148","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-19 14:05:06","reservation_modified_date_time":"2020-02-19 14:05:06","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3071746","reservation_id":"92223","confirmation_number":"SJ12656616577","room_confirmation_number":"SJ12684295128","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.41","grand_total":"16.00","paid_amount":"16.00","product_id":null,"service_quantity":"2","product_name":"Gran Marnier","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-19 23:31:00","reservation_modified_date_time":"2020-02-19 23:31:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"14.82","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071747","reservation_id":"92223","confirmation_number":"SJ12687513991","room_confirmation_number":"SJ12684295128","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Domestic Draft Beer","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-19 23:31:00","reservation_modified_date_time":"2020-02-19 23:31:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071748","reservation_id":"92223","confirmation_number":"SJ12654488993","room_confirmation_number":"SJ12684295128","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.63","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"1","product_name":"Amaretto","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-19 23:31:00","reservation_modified_date_time":"2020-02-19 23:31:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071749","reservation_id":"92223","confirmation_number":"SJ12692494363","room_confirmation_number":"SJ12684295128","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.41","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"1","product_name":"1800 Silver","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-19 23:31:00","reservation_modified_date_time":"2020-02-19 23:31:00","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.41","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071799","reservation_id":"92236","confirmation_number":"SJ12686523512","room_confirmation_number":"SJ12630116911","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.78","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Domestic Draft Beer","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:11:33","reservation_modified_date_time":"2020-02-20 04:11:33","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"beer","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071800","reservation_id":"92236","confirmation_number":"SJ12668848276","room_confirmation_number":"SJ12630116911","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.41","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"1","product_name":"1800 Silver","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:11:33","reservation_modified_date_time":"2020-02-20 04:11:33","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.41","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3071801","reservation_id":"92236","confirmation_number":"SJ12662901179","room_confirmation_number":"SJ12630116911","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.94","grand_total":"28.00","paid_amount":"28.00","product_id":null,"service_quantity":"1","product_name":"Amado Sur (Bottle)","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-20 04:11:33","reservation_modified_date_time":"2020-02-20 04:11:33","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"liquor","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"25.94","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":true,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}