{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-03-14","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1278,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":17,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1942,1943","block_room_bookings":[{"confirmation_number":"SJ12622180244","room_stay_from":"2020-03-03","room_stay_to":"2020-04-01","bundle_room":"0"},{"confirmation_number":"SJ12665142275","room_stay_from":"2020-01-14","room_stay_to":"2020-04-01","bundle_room":"0"}],"bundle_block_count":"1269,1270,1302,1303,1271,1272,1307,1308,1311,1312,1262,1263,1260,1261,1267,1268,1309,1310,1291,1711,1304,1305","bundle_block_bookings":[{"confirmation_number":"SJB12696332493","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","bundle_room":"1"},{"confirmation_number":"SJB12649957901","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","bundle_room":"0"},{"confirmation_number":"SJB12699901536","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","bundle_room":"0"},{"confirmation_number":"SJB12622649079","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","bundle_room":"1"},{"confirmation_number":"SJB12617650056","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","bundle_room":"1"},{"confirmation_number":"SJB12613470490","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","bundle_room":"1"},{"confirmation_number":"SJB12673858928","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","bundle_room":"1"},{"confirmation_number":"SJB12696602241","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","bundle_room":"1"},{"confirmation_number":"SJB12639498791","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","bundle_room":"1"},{"confirmation_number":"SJB12633211593","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","bundle_room":"1"},{"confirmation_number":"SJB12698794759","room_stay_from":"2020-03-10","room_stay_to":"2020-03-18","bundle_room":"1"},{"confirmation_number":"SJB12660653965","room_stay_from":"2020-03-13","room_stay_to":"2020-03-19","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3080742","reservation_id":"92681","confirmation_number":"SJ12691768640","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.00,280.00","nightly_discount":"0,0","subtotal":"560.00","grand_total":"630.00","paid_amount":"630.00","room_type_id":"319","product_id":"1305","siteminder_id":"BDC-3841515828","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":"98827","customer_id":"98827","source_of_creation":"Booking.com","reservation_created_date":"2020-02-27 19:42:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"109.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"280.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081228","reservation_id":"92929","confirmation_number":"SJ12655627263","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"195.5,195.5","nightly_discount":"0,0","subtotal":"391.00","grand_total":"439.88","paid_amount":"439.88","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-3179948825","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":"99510","customer_id":"99510","source_of_creation":"Booking.com","reservation_created_date":"2020-03-04 01:20:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"88.38","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"195.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":"3081297","reservation_id":"93289","confirmation_number":"SJ12698561996","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.00,280.00","nightly_discount":"0,0","subtotal":"560.00","grand_total":"630.00","paid_amount":"630.00","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-3914554169","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":"99517","customer_id":"99517","source_of_creation":"Booking.com","reservation_created_date":"2020-03-13 16:07:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"109.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"280.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081471","reservation_id":"93281","confirmation_number":"SJ12663285767","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.00","nightly_discount":"0","subtotal":"280.00","grand_total":"315.00","paid_amount":"315.00","room_type_id":"319","product_id":"1314","siteminder_id":"BDC-3176755860","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":"99492","customer_id":"99492","source_of_creation":"Booking.com","reservation_created_date":"2020-03-13 13:49:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"54.90","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"280.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081779","reservation_id":"93345","confirmation_number":"SJ12675825850","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.80","nightly_discount":"0","subtotal":"226.80","grand_total":"255.15","paid_amount":"255.15","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-2437993635","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":"99559","customer_id":"99559","source_of_creation":"Booking.com","reservation_created_date":"2020-03-14 19:06:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"45.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"226.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3065157","reservation_id":"91150","confirmation_number":"SJ12627484888","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"168.5,136.1","nightly_discount":"0,0","subtotal":"304.60","grand_total":"342.68","paid_amount":"342.68","room_type_id":"413","product_id":"1267","siteminder_id":"BDC-3918665084","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":"97276","customer_id":"97276","source_of_creation":"Booking.com","reservation_created_date":"2020-02-02 19:20:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"73.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"168.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":"3065589","reservation_id":"91202","confirmation_number":"SJ12621747667","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"168.5,136.1","nightly_discount":"0,0","subtotal":"304.60","grand_total":"342.68","paid_amount":"342.68","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-2469458089","collect_which":"channel_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":"97325","customer_id":"97325","source_of_creation":"Booking.com","reservation_created_date":"2020-02-03 08:35:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"36.98","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"168.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":"3081397","reservation_id":"93189","confirmation_number":"SJ12640649125","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"195,160","nightly_discount":"0,0","subtotal":"355.00","grand_total":"399.38","paid_amount":"399.38","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-3050372843","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":"99389","customer_id":"99389","source_of_creation":"Booking.com","reservation_created_date":"2020-03-10 16:33:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"45.45","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"195","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":"3069022","reservation_id":"90606","confirmation_number":"SJ12689555882","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"190,154,154","nightly_discount":"0,0,0","subtotal":"498.00","grand_total":"560.25","paid_amount":"560.25","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-3531068529","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96680","customer_id":"96680","source_of_creation":"Booking.com","reservation_created_date":"2020-01-26 05:10:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"118.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"190","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":"3069026","reservation_id":"90934","confirmation_number":"SJ12653596319","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"215.00,179.00,179.00","nightly_discount":"0,0,0","subtotal":"573.00","grand_total":"644.63","paid_amount":"644.63","room_type_id":"319","product_id":"1310","siteminder_id":"BDC-3569270005","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":"97030","customer_id":"97030","source_of_creation":"Booking.com","reservation_created_date":"2020-01-30 14:30:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"118.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"215.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081407","reservation_id":"93316","confirmation_number":"SJ12656730721","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.00,210.00,210.00,210.00,210.00,210.00,245.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1540.00","grand_total":"1732.50","paid_amount":"1732.50","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-2690176829","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":"99527","customer_id":"99527","source_of_creation":"Booking.com","reservation_created_date":"2020-03-14 00:01:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"77.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"245.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":"3063794","reservation_id":"90987","confirmation_number":"SJ12622526271","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.00,172.00","nightly_discount":"0,0","subtotal":"344.00","grand_total":"387.00","paid_amount":"387.00","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1632870595","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":"97082","customer_id":"97082","source_of_creation":"Expedia","reservation_created_date":"2020-01-31 02:58:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3073361","reservation_id":"92422","confirmation_number":"SJ12687282709","room_stay_from":"2020-03-12","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00,245.00,245.00","nightly_discount":"0,0,0","subtotal":"700.00","grand_total":"787.50","paid_amount":"787.50","room_type_id":"413","product_id":"1272","siteminder_id":"EXP-1647064495","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":"98598","customer_id":"98598","source_of_creation":"Expedia","reservation_created_date":"2020-02-23 16:08:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"245.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":"3078024","reservation_id":"92990","confirmation_number":"SJ12684610172","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"196.00,196.00","nightly_discount":"0,0","subtotal":"392.00","grand_total":"441.00","paid_amount":"441.00","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1653489620","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":"99154","customer_id":"99154","source_of_creation":"Expedia","reservation_created_date":"2020-03-05 17:29:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"196.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":"3081134","reservation_id":"92864","confirmation_number":"SJ12679787767","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.00","nightly_discount":"0","subtotal":"224.00","grand_total":"252.00","paid_amount":"252.00","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1651692891","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":"99016","customer_id":"99016","source_of_creation":"Expedia","reservation_created_date":"2020-03-02 15:45:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3081197","reservation_id":"93292","confirmation_number":"SJ12634854146","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.00,245.00","nightly_discount":"0,0","subtotal":"490.00","grand_total":"551.25","paid_amount":"551.25","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1657336207","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":"99502","customer_id":"99502","source_of_creation":"Expedia","reservation_created_date":"2020-03-13 16:17:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"245.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":"3081210","reservation_id":"93295","confirmation_number":"SJ12639720326","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.00","nightly_discount":"0","subtotal":"224.00","grand_total":"252.00","paid_amount":"252.00","room_type_id":"319","product_id":"1312","siteminder_id":"EXP-1657359273","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":"99506","customer_id":"99506","source_of_creation":"Expedia","reservation_created_date":"2020-03-13 17:27:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3081239","reservation_id":"90848","confirmation_number":"SJ12681258511","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.00,172.00","nightly_discount":"0,0","subtotal":"344.00","grand_total":"387.00","paid_amount":"387.00","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1631676182","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":"96940","customer_id":"96940","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 04:43:05","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081295","reservation_id":"90618","confirmation_number":"SJ12654850266","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,215.00","nightly_discount":"0,0","subtotal":"430.00","grand_total":"483.75","paid_amount":"483.75","room_type_id":"319","product_id":"1313","siteminder_id":"EXP-1630064466","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":"99517","customer_id":"99517","source_of_creation":"Expedia","reservation_created_date":"2020-01-26 16:18:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"215.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081300","reservation_id":"93009","confirmation_number":"SJ12647279248","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.00,280.00","nightly_discount":"0,0","subtotal":"549.00","grand_total":"617.63","paid_amount":"617.63","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1653905129","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":"99182","customer_id":"99182","source_of_creation":"Expedia","reservation_created_date":"2020-03-06 11:34:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"280.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081451","reservation_id":"90574","confirmation_number":"SJ12625889844","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.00","nightly_discount":"0","subtotal":"172.00","grand_total":"193.50","paid_amount":"193.50","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1629629688","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":"96638","customer_id":"96638","source_of_creation":"Expedia","reservation_created_date":"2020-01-25 18:28:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081454","reservation_id":"92603","confirmation_number":"SJ12635668588","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.00","nightly_discount":"0","subtotal":"245.00","grand_total":"275.63","paid_amount":"275.63","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1648970636","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":"98758","customer_id":"98758","source_of_creation":"Expedia","reservation_created_date":"2020-02-26 17:06:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"245.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":"3081461","reservation_id":"92611","confirmation_number":"SJ12629362601","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"252.00","nightly_discount":"0","subtotal":"252.00","grand_total":"283.50","paid_amount":"283.50","room_type_id":"413","product_id":"1261","siteminder_id":"EXP-1649036721","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":"98764","customer_id":"98764","source_of_creation":"Expedia","reservation_created_date":"2020-02-26 18:58:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"252.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":"3081499","reservation_id":"92973","confirmation_number":"SJ12647424138","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.00","nightly_discount":"0","subtotal":"280.00","grand_total":"315.00","paid_amount":"315.00","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1653203891","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":"99142","customer_id":"99142","source_of_creation":"Expedia","reservation_created_date":"2020-03-05 03:09:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"280.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081644","reservation_id":"93248","confirmation_number":"SJ12665555670","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"280.00","nightly_discount":"0","subtotal":"280.00","grand_total":"315.00","paid_amount":"315.00","room_type_id":"318","product_id":"1282","siteminder_id":"EXP-1656775087","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":"99454","customer_id":"99454","source_of_creation":"Expedia","reservation_created_date":"2020-03-12 02:00:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"280.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081883","reservation_id":"92863","confirmation_number":"SJ12686234790","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.00","nightly_discount":"0","subtotal":"224.00","grand_total":"252.00","paid_amount":"252.00","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1651687742","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":"99015","customer_id":"99015","source_of_creation":"Expedia","reservation_created_date":"2020-03-02 15:34:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3067944","reservation_id":"91660","confirmation_number":"SJ12626085803","room_stay_from":"2020-03-11","room_stay_to":"2020-03-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,187.20,187.20,169.20","nightly_discount":"0,0,0,0,0","subtotal":"882.00","grand_total":"992.25","paid_amount":"992.25","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1638470787","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":"97799","customer_id":"97799","source_of_creation":"Expedia","reservation_created_date":"2020-02-09 20:03:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3079029","reservation_id":"93063","confirmation_number":"SJ12640352560","room_stay_from":"2020-03-12","room_stay_to":"2020-03-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,201.60,201.60,183.60","nightly_discount":"0,0,0,0","subtotal":"770.40","grand_total":"866.70","paid_amount":"866.70","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1654531029","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":"99252","customer_id":"99252","source_of_creation":"Expedia","reservation_created_date":"2020-03-07 17:09:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"201.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081249","reservation_id":"92901","confirmation_number":"SJ12656261145","room_stay_from":"2020-03-13","room_stay_to":"2020-03-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.00,224.00,204.00","nightly_discount":"0,0,0","subtotal":"652.00","grand_total":"733.50","paid_amount":"733.50","room_type_id":"319","product_id":"1319","siteminder_id":"EXP-1652234938","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":"99060","customer_id":"99060","source_of_creation":"Expedia","reservation_created_date":"2020-03-03 13:54:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3081275","reservation_id":"91596","confirmation_number":"SJ12638055665","room_stay_from":"2020-03-13","room_stay_to":"2020-03-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"260.00,260.00,235.00","nightly_discount":"0,0,0","subtotal":"755.00","grand_total":"849.38","paid_amount":"849.38","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1637940374","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":"99516","customer_id":"99516","source_of_creation":"Expedia","reservation_created_date":"2020-02-08 19:23:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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"}]},{"room_stay_id":"3067095","reservation_id":"91486","confirmation_number":"SJ12611429751","room_stay_from":"2020-03-10","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,169.20,187.20,187.20,169.20,169.20,169.20","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1389.60","grand_total":"1563.30","paid_amount":"1563.30","room_type_id":"319","product_id":"1291","siteminder_id":"EXP-1637238795","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":"97615","customer_id":"97615","source_of_creation":"Expedia","reservation_created_date":"2020-02-07 14:38:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"277.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"187.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068686","reservation_id":"91102","confirmation_number":"SJ12670787957","room_stay_from":"2020-03-14","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"228.00,208.00,208.00,208.00","nightly_discount":"0,0,0,0","subtotal":"852.00","grand_total":"958.50","paid_amount":"958.50","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1633951119","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":"97227","customer_id":"97227","source_of_creation":"Expedia","reservation_created_date":"2020-02-02 02:23:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"228.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":"3073635","reservation_id":"92491","confirmation_number":"SJ12684487074","room_stay_from":"2020-03-14","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"187.6,169.6,169.6,169.6","nightly_discount":"0,0,0,0","subtotal":"696.40","grand_total":"783.45","paid_amount":"783.45","room_type_id":"319","product_id":"1308","siteminder_id":"EXP-1647754042","collect_which":"channel_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":"98652","customer_id":"98652","source_of_creation":"Expedia","reservation_created_date":"2020-02-24 18:38:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"187.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":"3077665","reservation_id":"92940","confirmation_number":"SJ12661649081","room_stay_from":"2020-03-11","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"215.20,204.00,224.00,224.00,204.00,204.00,215.20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1490.40","grand_total":"1676.70","paid_amount":"1676.70","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1652818230","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":"99105","customer_id":"99105","source_of_creation":"Expedia","reservation_created_date":"2020-03-04 14:19:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3079553","reservation_id":"91487","confirmation_number":"SJ12643636295","room_stay_from":"2020-03-10","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"169.20,169.20,169.20,187.20,187.20,169.20,169.20,169.20","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1389.60","grand_total":"1563.30","paid_amount":"1563.30","room_type_id":"319","product_id":"1711","siteminder_id":"EXP-1637238799","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":"97616","customer_id":"97616","source_of_creation":"Expedia","reservation_created_date":"2020-02-07 14:38:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"277.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"187.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3080015","reservation_id":"91860","confirmation_number":"SJ12679190526","room_stay_from":"2020-03-11","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,187.20,187.20,169.20,169.20,169.20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1220.40","grand_total":"1372.95","paid_amount":"1372.95","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1640338173","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":"98008","customer_id":"98008","source_of_creation":"Expedia","reservation_created_date":"2020-02-12 16:44:13","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3081652","reservation_id":"91168","confirmation_number":"SJ12676681644","room_stay_from":"2020-03-14","room_stay_to":"2020-03-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"256.50,256.50,256.50,256.50,256.50","nightly_discount":"0,0,0,0,0","subtotal":"1282.50","grand_total":"1442.82","paid_amount":"1442.82","room_type_id":"319","product_id":"1287","siteminder_id":"EXP-1634320847","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":"97291","customer_id":"97291","source_of_creation":"Expedia","reservation_created_date":"2020-02-02 21:28:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":"256.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"}]}],"exp_non_taxable":[{"room_stay_id":"3066592","reservation_id":"91439","confirmation_number":"SJ12646218999","room_stay_from":"2020-03-13","room_stay_to":"2020-03-14","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.00","nightly_discount":"0","subtotal":"172.00","grand_total":"193.50","paid_amount":"193.50","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1636761188","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":"97568","customer_id":"97568","source_of_creation":"Expedia","reservation_created_date":"2020-02-06 19:28:12","service_canceled_date_time":"2020-03-14 17:01:14","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3073188","reservation_id":"92415","confirmation_number":"SJ12640389912","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.60,183.60","nightly_discount":"0,0","subtotal":"385.20","grand_total":"433.35","paid_amount":"433.35","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1647028443","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":"98591","customer_id":"98591","source_of_creation":"Expedia","reservation_created_date":"2020-02-23 14:33:07","service_canceled_date_time":"2020-03-14 16:47:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"433.35","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3067200","reservation_id":"91550","confirmation_number":"SJ12643632487","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"420.00","nightly_discount":"0.00","subtotal":"420.00","grand_total":"472.50","paid_amount":"472.50","room_type_id":"320","product_id":"1328","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97685","customer_id":"97685","source_of_creation":"FE","reservation_created_date":"2020-02-08 03:31:23","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"420.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":"3075018","reservation_id":"92088","confirmation_number":"SJ12693733794","room_stay_from":"2020-03-11","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00,280.00,280.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1070.00","grand_total":"1203.75","paid_amount":"1203.75","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98263","customer_id":"98263","source_of_creation":"FE","reservation_created_date":"2020-02-17 14:33:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"280.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":"3067548","reservation_id":"91610","confirmation_number":"SJ12625555606","room_stay_from":"2020-03-13","room_stay_to":"2020-03-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"260.00,260.00,235.00,235.00,235.00,235.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1460.00","grand_total":"1642.50","paid_amount":"1642.50","room_type_id":"319","product_id":"1304","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97745","customer_id":"97745","source_of_creation":"FE","reservation_created_date":"2020-02-08 21:39:58","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"260.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081506","reservation_id":"93249","confirmation_number":"SJ12632202376","room_stay_from":"2020-03-14","room_stay_to":"2020-03-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"350.00,255.00,255.00,255.00,255.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1370.00","grand_total":"1541.25","paid_amount":"1541.25","room_type_id":"319","product_id":"1756","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":"99455","customer_id":"99455","source_of_creation":"FE","reservation_created_date":"2020-03-12 02:19:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"350.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":"3080044","reservation_id":"92217","confirmation_number":"SJ12655787785","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00","nightly_discount":"0.00,0.00","subtotal":"510.00","grand_total":"573.75","paid_amount":"573.75","room_type_id":"412","product_id":"1866","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98373","customer_id":"98373","source_of_creation":"PMS","reservation_created_date":"2020-02-19 22:12:26","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3080310","reservation_id":"90997","confirmation_number":"SJ12641032703","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,215.00","nightly_discount":"0.00,0.00","subtotal":"430.00","grand_total":"483.75","paid_amount":"483.75","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96952","customer_id":"96952","source_of_creation":"PMS","reservation_created_date":"2020-01-31 13:41:45","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"215.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081581","reservation_id":"93301","confirmation_number":"SJ12662395477","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.00,172.00","nightly_discount":"0.00,0.00","subtotal":"344.00","grand_total":"387.00","paid_amount":"387.00","room_type_id":"319","product_id":"1916","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":"99511","customer_id":"99511","source_of_creation":"PMS","reservation_created_date":"2020-03-13 18:58:48","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.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":"3079555","reservation_id":"91539","confirmation_number":"SJ12663567468","room_stay_from":"2020-03-12","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,187.20,187.20,169.20,169.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"882.00","grand_total":"992.25","paid_amount":"992.25","room_type_id":"319","product_id":"1293","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":"97673","customer_id":"97673","source_of_creation":"PMS","reservation_created_date":"2020-02-08 00:56:50","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"187.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3081829","reservation_id":"93347","confirmation_number":"SJ12660078453","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.00,210.00,210.00","nightly_discount":"24.50,21.00,21.00","subtotal":"665.00","grand_total":"673.32","paid_amount":"673.32","room_type_id":"413","product_id":"1262","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":"99565","customer_id":"99565","source_of_creation":"PMS","reservation_created_date":"2020-03-14 20:17:15","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"245.00","currentDayDiscount":"24.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3067565","reservation_id":"91612","confirmation_number":"SJ12689117206","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"260.00,235.00,235.00,235.00,235.00,235.00,260.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1695.00","grand_total":"1906.88","paid_amount":"1906.88","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":"97749","customer_id":"97749","source_of_creation":"PMS","reservation_created_date":"2020-02-08 21:57:42","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"260.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3074573","reservation_id":"90326","confirmation_number":"SJ12617869467","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","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":"2020-01-21 21:54:40","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":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":"3077547","reservation_id":"92926","confirmation_number":"SJ12670536820","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-03-03 23:10:47","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":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":"3080798","reservation_id":"93257","confirmation_number":"SJ12645290249","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Active","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":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2020-03-12 15:02:36","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":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":"3081531","reservation_id":"90995","confirmation_number":"SJ12627554229","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.71,160.71,160.71,160.71,160.72,160.72,160.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1125.00","grand_total":"1125.00","paid_amount":"0.00","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-01-31 12:43:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.71","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":"3080904","reservation_id":"91767","confirmation_number":"SJ12661787470","room_stay_from":"2020-03-12","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"430.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"430.00","grand_total":"483.75","paid_amount":"84.38","room_type_id":"319","product_id":"1286","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-02-11 02:30:27","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[{"room_stay_id":"3081036","reservation_id":"92636","confirmation_number":"SJ12698837469","room_stay_from":"2020-03-13","room_stay_to":"2020-03-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00","subtotal":"300.00","grand_total":"300.00","paid_amount":"84.38","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-02-27 03:43:56","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.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":"3081321","reservation_id":"92804","confirmation_number":"SJ12668172781","room_stay_from":"2020-03-13","room_stay_to":"2020-03-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00","subtotal":"300.00","grand_total":"300.00","paid_amount":"84.38","room_type_id":"319","product_id":"1311","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-03-01 03:29:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.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":"3081068","reservation_id":"92805","confirmation_number":"SJ12683040098","room_stay_from":"2020-03-13","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"495.00","grand_total":"495.00","paid_amount":"140.64","room_type_id":"319","product_id":"1307","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-03-01 03:31:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3081226","reservation_id":"92929","confirmation_number":"SJ12620993394","room_confirmation_number":"SJ12655627263","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"99510","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-03-04 01:20:09","reservation_modified_date_time":"2020-03-13 18:49:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99510","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":"3065158","reservation_id":"91150","confirmation_number":"SJ12618188793","room_confirmation_number":"SJ12627484888","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","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":"97276","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-02 19:20:08","reservation_modified_date_time":"2020-02-02 19:20:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97276","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":"3065590","reservation_id":"91202","confirmation_number":"SJ12650438576","room_confirmation_number":"SJ12621747667","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"97325","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-03 17:34:22","reservation_modified_date_time":"2020-02-03 17:34:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97325","canceled_nights_data":"","currentDayPrice":"25","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":"3081398","reservation_id":"93189","confirmation_number":"SJ12639731621","room_confirmation_number":"SJ12640649125","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"99389","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-14 00:20:19","reservation_modified_date_time":"2020-03-14 00:20:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99389","canceled_nights_data":"","currentDayPrice":"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":"3069024","reservation_id":"90606","confirmation_number":"SJ12685358180","room_confirmation_number":"SJ12689555882","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"96680","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-12 00:52:12","reservation_modified_date_time":"2020-02-12 00:52:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96680","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":"3073636","reservation_id":"92491","confirmation_number":"SJ12623338120","room_confirmation_number":"SJ12684487074","room_stay_from":"2020-03-14","room_stay_to":"2020-03-18","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":"98652","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-24 18:38:10","reservation_modified_date_time":"2020-02-24 18:38:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98652","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3063795","reservation_id":"90987","confirmation_number":"SJ12616916322","room_confirmation_number":"SJ12622526271","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"97082","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 02:58:09","reservation_modified_date_time":"2020-01-31 02:58:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97082","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":"3067201","reservation_id":"91550","confirmation_number":"SJ12649116167","room_confirmation_number":"SJ12643632487","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.12","paid_amount":"28.12","product_id":"1776","service_quantity":"1","customer_traveller_id":"97685","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 03:31:23","reservation_modified_date_time":"2020-02-08 03:31:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97685","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":"3073360","reservation_id":"92422","confirmation_number":"SJ12678886514","room_confirmation_number":"SJ12687282709","room_stay_from":"2020-03-12","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98598","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-23 16:08:06","reservation_modified_date_time":"2020-02-23 16:43:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98598","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":"3075019","reservation_id":"92088","confirmation_number":"SJ12690777687","room_confirmation_number":"SJ12693733794","room_stay_from":"2020-03-11","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"98263","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-17 14:33:32","reservation_modified_date_time":"2020-02-27 13:57:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98263","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":"3078023","reservation_id":"92990","confirmation_number":"SJ12637860424","room_confirmation_number":"SJ12684610172","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"99154","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-05 17:29:08","reservation_modified_date_time":"2020-03-05 17:29:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99154","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":"3080045","reservation_id":"92217","confirmation_number":"SJ12699478834","room_confirmation_number":"SJ12655787785","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"98373","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-19 22:12:26","reservation_modified_date_time":"2020-03-10 13:47:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98373","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":"3080311","reservation_id":"90997","confirmation_number":"SJ12632835991","room_confirmation_number":"SJ12641032703","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"96952","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 13:41:45","reservation_modified_date_time":"2020-03-10 20:50:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96952","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":"3080743","reservation_id":"92681","confirmation_number":"SJ12667948075","room_confirmation_number":"SJ12691768640","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"98827","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-27 19:42:09","reservation_modified_date_time":"2020-03-12 13:08:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98827","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":"3080906","reservation_id":"91767","confirmation_number":"SJ12662904785","room_confirmation_number":"SJ12661787470","room_stay_from":"2020-03-12","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"97913","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 02:30:27","reservation_modified_date_time":"2020-03-12 20:21:22","collect_which":"","tax_exempt_status":"0","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":"3081135","reservation_id":"92864","confirmation_number":"SJ12693005969","room_confirmation_number":"SJ12679787767","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"99016","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-02 15:45:06","reservation_modified_date_time":"2020-03-13 14:37:02","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99016","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":"3081196","reservation_id":"93292","confirmation_number":"SJ12623160309","room_confirmation_number":"SJ12634854146","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"99502","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-13 16:17:11","reservation_modified_date_time":"2020-03-13 16:26:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99502","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":"3081211","reservation_id":"93295","confirmation_number":"SJ12692367031","room_confirmation_number":"SJ12639720326","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"99506","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-13 17:27:06","reservation_modified_date_time":"2020-03-13 17:27:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99506","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":"3081227","reservation_id":"92929","confirmation_number":"SJ12695028822","room_confirmation_number":"SJ12655627263","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"99510","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-04 01:20:09","reservation_modified_date_time":"2020-03-13 18:49:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99510","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":"3081241","reservation_id":"90848","confirmation_number":"SJ12628842144","room_confirmation_number":"SJ12681258511","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"96940","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 04:43:05","reservation_modified_date_time":"2020-03-13 19:09:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96940","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":"3081294","reservation_id":"90618","confirmation_number":"SJ12690532682","room_confirmation_number":"SJ12654850266","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"99517","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-26 16:18:10","reservation_modified_date_time":"2020-03-13 21:08:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99517","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":"3081296","reservation_id":"93289","confirmation_number":"SJ12613189360","room_confirmation_number":"SJ12698561996","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"99518","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-13 16:07:09","reservation_modified_date_time":"2020-03-13 21:14:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99517","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":"3081301","reservation_id":"93009","confirmation_number":"SJ12619720315","room_confirmation_number":"SJ12647279248","room_stay_from":"2020-03-13","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"99182","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-06 11:34:11","reservation_modified_date_time":"2020-03-13 21:18:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99182","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":"3081453","reservation_id":"90574","confirmation_number":"SJ12629499186","room_confirmation_number":"SJ12625889844","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"96638","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 18:28:06","reservation_modified_date_time":"2020-03-14 02:00:46","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96638","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":"3081455","reservation_id":"92603","confirmation_number":"SJ12685240266","room_confirmation_number":"SJ12635668588","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"98758","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-26 17:06:09","reservation_modified_date_time":"2020-03-14 02:01:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98758","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":"3081462","reservation_id":"92611","confirmation_number":"SJ12668112130","room_confirmation_number":"SJ12629362601","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"98764","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-26 18:58:07","reservation_modified_date_time":"2020-03-14 02:03:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98764","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":"3081472","reservation_id":"93281","confirmation_number":"SJ12631854267","room_confirmation_number":"SJ12663285767","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"99492","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-13 13:49:09","reservation_modified_date_time":"2020-03-14 02:09:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99492","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":"3081500","reservation_id":"92973","confirmation_number":"SJ12662520311","room_confirmation_number":"SJ12647424138","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"99142","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-05 03:09:10","reservation_modified_date_time":"2020-03-14 11:06:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99142","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":"3081645","reservation_id":"93248","confirmation_number":"SJ12632410271","room_confirmation_number":"SJ12665555670","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"99454","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-12 02:00:06","reservation_modified_date_time":"2020-03-14 15:23:27","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99454","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":"3081780","reservation_id":"93345","confirmation_number":"SJ12692167135","room_confirmation_number":"SJ12675825850","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"99559","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-14 19:06:09","reservation_modified_date_time":"2020-03-14 19:06:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99559","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":"3081882","reservation_id":"92863","confirmation_number":"SJ12648824655","room_confirmation_number":"SJ12686234790","room_stay_from":"2020-03-14","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"99573","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-02 15:34:10","reservation_modified_date_time":"2020-03-14 23:02:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99015","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":"3065159","reservation_id":"91150","confirmation_number":"SJ12659873816","room_confirmation_number":"SJ12627484888","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"97276","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 19:20:08","reservation_modified_date_time":"2020-02-02 19:20:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97276","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":"3065591","reservation_id":"91202","confirmation_number":"SJ12688201953","room_confirmation_number":"SJ12621747667","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","room_stay_status":"Active","nightly_price":"28.12,28.12","nightly_discount":"0,0","subtotal":"56.24","grand_total":"63.27","paid_amount":"63.27","product_id":"1776","service_quantity":"1","customer_traveller_id":"97325","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-02-03 08:35:09","reservation_modified_date_time":"2020-02-03 17:34:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97325","canceled_nights_data":"","currentDayPrice":"28.12","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":"3067945","reservation_id":"91660","confirmation_number":"SJ12659500685","room_confirmation_number":"SJ12626085803","room_stay_from":"2020-03-11","room_stay_to":"2020-03-16","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":"97799","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 20:03:12","reservation_modified_date_time":"2020-02-09 20:03:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97799","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":"3079030","reservation_id":"93063","confirmation_number":"SJ12617376955","room_confirmation_number":"SJ12640352560","room_stay_from":"2020-03-12","room_stay_to":"2020-03-16","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":"99252","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-07 17:09:06","reservation_modified_date_time":"2020-03-07 17:09:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99252","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":"3081037","reservation_id":"92636","confirmation_number":"SJ12618051306","room_confirmation_number":"SJ12698837469","room_stay_from":"2020-03-13","room_stay_to":"2020-03-16","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98790","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-27 03:43:56","reservation_modified_date_time":"2020-03-13 11:19:07","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3081248","reservation_id":"92901","confirmation_number":"SJ12695450666","room_confirmation_number":"SJ12656261145","room_stay_from":"2020-03-13","room_stay_to":"2020-03-16","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"99060","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-03 13:54:10","reservation_modified_date_time":"2020-03-13 19:36:46","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99060","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":"3081274","reservation_id":"91596","confirmation_number":"SJ12622694611","room_confirmation_number":"SJ12638055665","room_stay_from":"2020-03-13","room_stay_to":"2020-03-16","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"99516","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 19:23:11","reservation_modified_date_time":"2020-03-13 20:28:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99516","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":"3081322","reservation_id":"92804","confirmation_number":"SJ12682578964","room_confirmation_number":"SJ12668172781","room_stay_from":"2020-03-13","room_stay_to":"2020-03-16","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98955","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-01 03:29:37","reservation_modified_date_time":"2020-03-13 21:37:30","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3081399","reservation_id":"93189","confirmation_number":"SJ12679973197","room_confirmation_number":"SJ12640649125","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"99389","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-10 16:33:10","reservation_modified_date_time":"2020-03-14 00:20:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99389","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":"3081582","reservation_id":"93301","confirmation_number":"SJ12676255145","room_confirmation_number":"SJ12662395477","room_stay_from":"2020-03-14","room_stay_to":"2020-03-16","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"99511","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-13 18:58:48","reservation_modified_date_time":"2020-03-14 13:04:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99511","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":"3069025","reservation_id":"90606","confirmation_number":"SJ12648646643","room_confirmation_number":"SJ12689555882","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"96680","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-26 05:10:07","reservation_modified_date_time":"2020-02-12 00:52:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96680","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":"3069030","reservation_id":"90934","confirmation_number":"SJ12665498437","room_confirmation_number":"SJ12653596319","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","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":"97030","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-01-30 14:30:09","reservation_modified_date_time":"2020-02-12 00:52:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97030","canceled_nights_data":"","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":"3079556","reservation_id":"91539","confirmation_number":"SJ12620696931","room_confirmation_number":"SJ12663567468","room_stay_from":"2020-03-12","room_stay_to":"2020-03-17","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"97673","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 00:56:50","reservation_modified_date_time":"2020-03-09 11:27:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97673","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":"3081830","reservation_id":"93347","confirmation_number":"SJ12636152046","room_confirmation_number":"SJ12660078453","room_stay_from":"2020-03-14","room_stay_to":"2020-03-17","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"99565","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-14 20:17:15","reservation_modified_date_time":"2020-03-14 20:17:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99565","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":"3067097","reservation_id":"91486","confirmation_number":"SJ12616999370","room_confirmation_number":"SJ12611429751","room_stay_from":"2020-03-10","room_stay_to":"2020-03-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"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":"97615","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-07 14:38:09","reservation_modified_date_time":"2020-02-07 23:38:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97615","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":"3068687","reservation_id":"91102","confirmation_number":"SJ12682616535","room_confirmation_number":"SJ12670787957","room_stay_from":"2020-03-14","room_stay_to":"2020-03-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"97227","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 02:23:09","reservation_modified_date_time":"2020-02-11 02:34:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97227","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":"3073637","reservation_id":"92491","confirmation_number":"SJ12694795782","room_confirmation_number":"SJ12684487074","room_stay_from":"2020-03-14","room_stay_to":"2020-03-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"98652","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-24 18:38:10","reservation_modified_date_time":"2020-02-24 18:38:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98652","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":"3077664","reservation_id":"92940","confirmation_number":"SJ12668825240","room_confirmation_number":"SJ12661649081","room_stay_from":"2020-03-11","room_stay_to":"2020-03-18","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,0,0,0,0","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"99105","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-04 14:19:08","reservation_modified_date_time":"2020-03-04 14:27:04","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99105","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":"3079554","reservation_id":"91487","confirmation_number":"SJ12635852465","room_confirmation_number":"SJ12643636295","room_stay_from":"2020-03-10","room_stay_to":"2020-03-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"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":"97616","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-07 14:38:12","reservation_modified_date_time":"2020-03-09 11:26:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97616","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":"3080016","reservation_id":"91860","confirmation_number":"SJ12622623975","room_confirmation_number":"SJ12679190526","room_stay_from":"2020-03-11","room_stay_to":"2020-03-18","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":"98008","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 16:44:13","reservation_modified_date_time":"2020-03-10 13:10:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98008","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":"3081070","reservation_id":"92805","confirmation_number":"SJ12647246979","room_confirmation_number":"SJ12683040098","room_stay_from":"2020-03-13","room_stay_to":"2020-03-18","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":"98955","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-01 03:31:08","reservation_modified_date_time":"2020-03-13 11:21:22","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3067549","reservation_id":"91610","confirmation_number":"SJ12635453264","room_confirmation_number":"SJ12625555606","room_stay_from":"2020-03-13","room_stay_to":"2020-03-19","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":"97745","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 21:39:58","reservation_modified_date_time":"2020-02-08 21:39:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97745","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":"3081507","reservation_id":"93249","confirmation_number":"SJ12682744202","room_confirmation_number":"SJ12632202376","room_stay_from":"2020-03-14","room_stay_to":"2020-03-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"99455","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-12 02:19:15","reservation_modified_date_time":"2020-03-14 11:07:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99455","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":"3081655","reservation_id":"91168","confirmation_number":"SJ12644397592","room_confirmation_number":"SJ12676681644","room_stay_from":"2020-03-14","room_stay_to":"2020-03-19","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":"97291","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 21:28:10","reservation_modified_date_time":"2020-03-14 15:34:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97291","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3067566","reservation_id":"91612","confirmation_number":"SJ12677964477","room_confirmation_number":"SJ12689117206","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","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":"97749","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 21:57:42","reservation_modified_date_time":"2020-02-08 22:21:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97749","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":"3074574","reservation_id":"90326","confirmation_number":"SJ12693267413","room_confirmation_number":"SJ12617869467","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","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":"96375","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-21 21:54:40","reservation_modified_date_time":"2020-02-26 14:08:08","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":"3077548","reservation_id":"92926","confirmation_number":"SJ12690628682","room_confirmation_number":"SJ12670536820","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","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":"99089","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-03 23:10:47","reservation_modified_date_time":"2020-03-03 23:10:47","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3080799","reservation_id":"93257","confirmation_number":"SJ12668992347","room_confirmation_number":"SJ12645290249","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","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":"99463","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-12 15:02:36","reservation_modified_date_time":"2020-03-12 15:02:36","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","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":"3081406","reservation_id":"93316","confirmation_number":"SJ12636037045","room_confirmation_number":"SJ12656730721","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","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":"99527","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-14 00:01:08","reservation_modified_date_time":"2020-03-14 00:22:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99527","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":"3066593","reservation_id":"91439","confirmation_number":"SJ12669058948","room_confirmation_number":"SJ12646218999","room_stay_from":"2020-03-13","room_stay_to":"2020-03-14","room_stay_status":"Canceled","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-06 19:28:12","reservation_modified_date_time":"2020-02-06 19:28:12","customer_id":"97568","parentCustTravId":"97568","customer_traveller_id":"97568","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-03-14 17:01:14","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[{"room_stay_id":"3081532","reservation_id":"90995","confirmation_number":"SJ12693986498","room_confirmation_number":"SJ12627554229","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","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":"97088","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 12:43:41","reservation_modified_date_time":"2020-03-14 12:01:23","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"77106","canceled_nights_data":"","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"}]}],"gift_shop_taxable":[{"room_stay_id":"3081692","reservation_id":"93337","confirmation_number":"SJ12663056857","room_confirmation_number":"SJ12636951597","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":"53.76","paid_amount":"53.76","product_id":null,"service_quantity":"2","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-14 16:32:20","reservation_modified_date_time":"2020-03-14 16:32:20","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":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3081693","reservation_id":"93337","confirmation_number":"SJ12686218026","room_confirmation_number":"SJ12636951597","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"40.00","grand_total":"43.00","paid_amount":"43.00","product_id":null,"service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-14 16:32:20","reservation_modified_date_time":"2020-03-14 16:32:20","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":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3081768","reservation_id":"93343","confirmation_number":"SJ12671394806","room_confirmation_number":"SJ12696566075","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-03-14 18:41:57","reservation_modified_date_time":"2020-03-14 18:41:57","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":"3081544","reservation_id":"93327","confirmation_number":"SJ12685241867","room_confirmation_number":"SJ12673733368","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":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-14 12:27:06","reservation_modified_date_time":"2020-03-14 12:27: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":"7.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3081888","reservation_id":"93356","confirmation_number":"SJ12618164984","room_confirmation_number":"SJ12663861722","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-03-15 00:14:23","reservation_modified_date_time":"2020-03-15 00:14:23","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}