{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-01-30","total_rooms_exist":"1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1281,1282,1286,1287,1288,1289,1291,1293,1294,1296,1297,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1318,1319,1711,1756,1866,1913,1915,1916,1917,1918,1919,1920,1921,1922,1923,1942,1943","departureCount":11,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1923,1313,1920,1943,1922,1921,1919,1918,1262,1261,1270","block_room_bookings":[{"confirmation_number":"SJ12693730510","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12673593636","room_stay_from":"2019-11-09","room_stay_to":"2019-11-20","bundle_room":"0"},{"confirmation_number":"SJ12665324838","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12665142275","room_stay_from":"2020-01-03","room_stay_to":"2020-01-06","bundle_room":"0"},{"confirmation_number":"SJ12657221101","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12648030950","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12638549225","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12632903645","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12632788009","room_stay_from":"2019-12-20","room_stay_to":"2020-01-06","bundle_room":"0"},{"confirmation_number":"SJ12629964770","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","bundle_room":"0"},{"confirmation_number":"SJ12613532835","room_stay_from":"2019-12-18","room_stay_to":"2021-01-01","bundle_room":"0"}],"bundle_block_count":"1291,1711,1271,1272,1267,1268,1304,1305,1302,1303,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12694178845","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","bundle_room":"1"},{"confirmation_number":"SJB12691850611","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","bundle_room":"1"},{"confirmation_number":"SJB12683518723","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","bundle_room":"1"},{"confirmation_number":"SJB12672966430","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","bundle_room":"1"},{"confirmation_number":"SJB12667709307","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","bundle_room":"1"},{"confirmation_number":"SJB12652449820","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3063567","reservation_id":"90866","confirmation_number":"SJ12637727233","room_stay_from":"2020-01-29","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.15,169.15","nightly_discount":"0,0","subtotal":"338.30","grand_total":"380.59","paid_amount":"380.59","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-3372706184","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":"96954","customer_id":"96954","source_of_creation":"Booking.com","reservation_created_date":"2020-01-29 15:53:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"41.43","resv_is_no_show":"0","is_bundle":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"169.15","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":"3063699","reservation_id":"90959","confirmation_number":"SJ12683343093","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.15","nightly_discount":"0","subtotal":"169.15","grand_total":"190.30","paid_amount":"190.30","room_type_id":"413","product_id":"1267","siteminder_id":"BDC-3569229568","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":"97053","customer_id":"97053","source_of_creation":"Booking.com","reservation_created_date":"2020-01-30 20:00:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"41.43","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"169.15","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":"3063348","reservation_id":"90774","confirmation_number":"SJ12661604329","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.15,169.15,169.15","nightly_discount":"0,0,0","subtotal":"507.45","grand_total":"570.88","paid_amount":"570.88","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3029115604","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":"96979","customer_id":"96979","source_of_creation":"Booking.com","reservation_created_date":"2020-01-28 14:09:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"82.85","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"169.15","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":"3063560","reservation_id":"90686","confirmation_number":"SJ12697218628","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"165.4,165.4","nightly_discount":"0,0","subtotal":"330.80","grand_total":"372.15","paid_amount":"372.15","room_type_id":"319","product_id":"1305","siteminder_id":"BDC-2374024264","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":"96768","customer_id":"96768","source_of_creation":"Booking.com","reservation_created_date":"2020-01-27 16:32:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"91.78","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"165.4","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":"3060168","reservation_id":"90303","confirmation_number":"SJ12667776648","room_stay_from":"2020-01-29","room_stay_to":"2020-02-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.15,203.15,252.45,252.45","nightly_discount":"0,0,0,0","subtotal":"911.20","grand_total":"1025.10","paid_amount":"1025.10","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-2853182247","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":"96353","customer_id":"96353","source_of_creation":"Booking.com","reservation_created_date":"2020-01-21 03:23:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"206.46","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"203.15","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":"3061957","reservation_id":"90468","confirmation_number":"SJ12668473405","room_stay_from":"2020-01-30","room_stay_to":"2020-02-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"179.00,320.00,215.00,179.00,179.00","nightly_discount":"0,0,0,0,0","subtotal":"1072.00","grand_total":"1206.00","paid_amount":"1206.00","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-3713841258","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":"96524","customer_id":"96524","source_of_creation":"Booking.com","reservation_created_date":"2020-01-23 23:13:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"235.20","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"179.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3061856","reservation_id":"90547","confirmation_number":"SJ12636578198","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"169.15","nightly_discount":"0","subtotal":"169.15","grand_total":"190.30","paid_amount":"190.30","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1629421316","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":"96610","customer_id":"96610","source_of_creation":"Expedia","reservation_created_date":"2020-01-25 07:18:20","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","currentDayPrice":"169.15","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":"3061858","reservation_id":"90545","confirmation_number":"SJ12662217398","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"169.15","nightly_discount":"0","subtotal":"169.15","grand_total":"190.30","paid_amount":"190.30","room_type_id":"319","product_id":"1307","siteminder_id":"EXP-1629421314","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":"96608","customer_id":"96608","source_of_creation":"Expedia","reservation_created_date":"2020-01-25 07:18:09","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","currentDayPrice":"169.15","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":"3061861","reservation_id":"90546","confirmation_number":"SJ12677740816","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"169.15","nightly_discount":"0","subtotal":"169.15","grand_total":"190.30","paid_amount":"190.30","room_type_id":"319","product_id":"1308","siteminder_id":"EXP-1629421312","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":"96609","customer_id":"96609","source_of_creation":"Expedia","reservation_created_date":"2020-01-25 07:18:15","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","currentDayPrice":"169.15","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":"3063416","reservation_id":"90905","confirmation_number":"SJ12669985443","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.32","nightly_discount":"0","subtotal":"135.32","grand_total":"152.24","paid_amount":"152.24","room_type_id":"319","product_id":"1304","siteminder_id":"EXP-1632139059","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":"96999","customer_id":"96999","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 22:53:10","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","currentDayPrice":"135.32","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":"3063427","reservation_id":"90889","confirmation_number":"SJ12688383260","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.32","nightly_discount":"0","subtotal":"135.32","grand_total":"152.24","paid_amount":"152.24","room_type_id":"319","product_id":"1711","siteminder_id":"EXP-1632021682","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":"96978","customer_id":"96978","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 19:18:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"135.32","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":"3062371","reservation_id":"80565","confirmation_number":"SJ12617069471","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.80,187.20,187.20,187.20,187.20,187.20,212.80","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1361.60","grand_total":"1531.80","paid_amount":"1531.80","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1297954421","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":"88824","customer_id":"88824","source_of_creation":"Expedia","reservation_created_date":"2019-07-12 00:15:07","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","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":"3063411","reservation_id":"90902","confirmation_number":"SJ12672099943","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"135.32,135.32,135.32","nightly_discount":"0,0,0","subtotal":"405.96","grand_total":"456.71","paid_amount":"456.71","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1632127276","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":"96996","customer_id":"96996","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 22:28:11","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","currentDayPrice":"135.32","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":"3063419","reservation_id":"90843","confirmation_number":"SJ12668230148","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.32,135.32","nightly_discount":"0,0","subtotal":"270.64","grand_total":"304.47","paid_amount":"304.47","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1631657170","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":"96935","customer_id":"96935","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 03:58:10","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","currentDayPrice":"135.32","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":"3063545","reservation_id":"90942","confirmation_number":"SJ12650099315","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"135.32,135.32","nightly_discount":"0,0","subtotal":"270.64","grand_total":"304.47","paid_amount":"304.47","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1632572711","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":"97037","customer_id":"97037","source_of_creation":"Expedia","reservation_created_date":"2020-01-30 16:58:07","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","currentDayPrice":"135.32","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":"3063547","reservation_id":"90943","confirmation_number":"SJ12644566461","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"135.32,135.32","nightly_discount":"0,0","subtotal":"270.64","grand_total":"304.47","paid_amount":"304.47","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1632572714","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":"97038","customer_id":"97038","source_of_creation":"Expedia","reservation_created_date":"2020-01-30 16:58:11","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","currentDayPrice":"135.32","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":"3065226","reservation_id":"87928","confirmation_number":"SJ12637915131","room_stay_from":"2020-01-23","room_stay_to":"2020-02-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"187.20,212.80,212.80,187.20,187.20,187.20,187.20,187.20,212.80,443.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2204.80","grand_total":"2480.40","paid_amount":"2508.53","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1388688970","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":"94340","customer_id":"94340","source_of_creation":"Expedia","reservation_created_date":"2019-12-06 16:08:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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":"3063221","reservation_id":"90882","confirmation_number":"SJ12648632989","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.32","nightly_discount":"0","subtotal":"135.32","grand_total":"152.24","paid_amount":"0.00","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1631970884","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":"96970","customer_id":"96970","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 17:43:12","service_canceled_date_time":"2020-01-30 18:05:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":-135.32,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063224","reservation_id":"90883","confirmation_number":"SJ12611443364","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.32","nightly_discount":"0","subtotal":"135.32","grand_total":"152.24","paid_amount":"0.00","room_type_id":"319","product_id":"1287","siteminder_id":"EXP-1631970883","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":"96971","customer_id":"96971","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 17:43:17","service_canceled_date_time":"2020-01-30 18:06:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":-135.32,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3062644","reservation_id":"88410","confirmation_number":"SJ12623750966","room_stay_from":"2020-01-28","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.00,209.00,209.00","nightly_discount":"0.00,0.00,0.00","subtotal":"627.00","grand_total":"705.38","paid_amount":"705.38","room_type_id":"319","product_id":"1303","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94640","customer_id":"94640","source_of_creation":"FE","reservation_created_date":"2019-12-17 05:18:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"209.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3063046","reservation_id":"90716","confirmation_number":"SJ12640422694","room_stay_from":"2020-01-27","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.00,169.00,169.00,169.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"676.00","grand_total":"760.50","paid_amount":"760.50","room_type_id":"319","product_id":"1319","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96799","customer_id":"96799","source_of_creation":"PMS","reservation_created_date":"2020-01-27 22:20:38","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","currentDayPrice":"169.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063443","reservation_id":"90912","confirmation_number":"SJ12636874365","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00","nightly_discount":"0.00","subtotal":"179.00","grand_total":"201.38","paid_amount":"201.38","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97007","customer_id":"97007","source_of_creation":"PMS","reservation_created_date":"2020-01-29 23:57:33","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","currentDayPrice":"179.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063462","reservation_id":"90920","confirmation_number":"SJ12627208415","room_stay_from":"2020-01-29","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,159.00","nightly_discount":"0.00,0.00","subtotal":"318.00","grand_total":"357.75","paid_amount":"357.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":"97015","customer_id":"97015","source_of_creation":"PMS","reservation_created_date":"2020-01-30 02:18:29","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","currentDayPrice":"159.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063162","reservation_id":"90833","confirmation_number":"SJ12629140123","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,159.00,159.00","nightly_discount":"0.00,0.00,0.00","subtotal":"477.00","grand_total":"536.63","paid_amount":"536.63","room_type_id":"413","product_id":"1263","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":"96926","customer_id":"96926","source_of_creation":"PMS","reservation_created_date":"2020-01-29 01:11:25","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"159.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063843","reservation_id":"90976","confirmation_number":"SJ12659222139","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00","nightly_discount":"0.00,0.00","subtotal":"358.00","grand_total":"402.75","paid_amount":"402.75","room_type_id":"413","product_id":"1266","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":"97069","customer_id":"97069","source_of_creation":"PMS","reservation_created_date":"2020-01-30 22:11:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"179.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063848","reservation_id":"90802","confirmation_number":"SJ12682586359","room_stay_from":"2020-01-28","room_stay_to":"2020-02-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.00,169.00,169.00,169.00,169.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"845.00","grand_total":"950.63","paid_amount":"950.63","room_type_id":"319","product_id":"1301","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":"96889","customer_id":"96889","source_of_creation":"PMS","reservation_created_date":"2020-01-28 20:04:30","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"169.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3056430","reservation_id":"89720","confirmation_number":"SJ12659215838","room_stay_from":"2020-01-28","room_stay_to":"2020-02-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"232.43,232.43,232.43,232.43,232.43,232.43,232.43","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1627.01","grand_total":"1830.39","paid_amount":"1830.39","room_type_id":"318","product_id":"1282","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":"95720","customer_id":"95720","source_of_creation":"PMS","reservation_created_date":"2020-01-10 20:36:29","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","currentDayPrice":"232.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3069600","reservation_id":"90463","confirmation_number":"SJ12667679631","room_stay_from":"2020-01-26","room_stay_to":"2020-02-14","room_stay_status":"Closed","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,0.00,0.00,0.00,0.00,0.00,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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"412","product_id":"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":"96519","customer_id":"96519","source_of_creation":"PMS","reservation_created_date":"2020-01-23 22:06:22","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","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063775","reservation_id":"89437","confirmation_number":"SJ12662961260","room_stay_from":"2020-02-14","room_stay_to":"2020-02-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"298.53,298.53,298.53","nightly_discount":"0.00,0.00,0.00","subtotal":"895.59","grand_total":"1007.54","paid_amount":"1007.54","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95401","customer_id":"95401","source_of_creation":"PMS","reservation_created_date":"2020-01-06 00:41:54","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3059591","reservation_id":"89922","confirmation_number":"SJ12694283457","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-01-14 00:16:51","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","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":"3060652","reservation_id":"89923","confirmation_number":"SJ12672570534","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","room_stay_status":"Closed","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-01-14 00:18:35","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","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":"3062142","reservation_id":"85092","confirmation_number":"SJ12630974145","room_stay_from":"2020-01-27","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1278","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"74797","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2019-10-04 03:11:16","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","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":"3063391","reservation_id":"89095","confirmation_number":"SJ12627002427","room_stay_from":"2020-01-30","room_stay_to":"2020-02-02","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"458.00,558.00,597.00","nightly_discount":"0.00,0.00,0.00","subtotal":"1613.00","grand_total":"1814.63","paid_amount":"650.25","room_type_id":"320","product_id":"1332","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":"95150","customer_id":"95150","source_of_creation":"PMS","reservation_created_date":"2020-01-01 23:53:03","service_canceled_date_time":"2020-01-30 13:18:24","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"650.25","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[{"room_stay_id":"3074346","reservation_id":"73996","confirmation_number":"SJ12664049931","room_stay_from":"2020-01-19","room_stay_to":"2020-02-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"127.62,127.62,127.62,127.62,127.62,127.62,127.62,127.62,127.62,127.62,127.62,127.62,127.62,127.62","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1786.68","grand_total":"2010.01","paid_amount":"2010.01","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2019-04-04 00:30:59","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","currentDayPrice":"127.62","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3063562","reservation_id":"90686","confirmation_number":"SJ12645895564","room_confirmation_number":"SJ12697218628","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","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":"96768","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-01-30 17:19:36","reservation_modified_date_time":"2020-01-30 17:19:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96768","canceled_nights_data":"","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3061857","reservation_id":"90547","confirmation_number":"SJ12660260815","room_confirmation_number":"SJ12636578198","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","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":"96610","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 07:18:20","reservation_modified_date_time":"2020-01-25 07:18:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96610","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":"3061860","reservation_id":"90545","confirmation_number":"SJ12649632538","room_confirmation_number":"SJ12662217398","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","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":"96608","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 07:18:09","reservation_modified_date_time":"2020-01-25 07:18:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96608","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":"3061862","reservation_id":"90546","confirmation_number":"SJ12649449148","room_confirmation_number":"SJ12677740816","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","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":"96609","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 07:18:15","reservation_modified_date_time":"2020-01-25 07:18:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96609","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":"3062646","reservation_id":"88410","confirmation_number":"SJ12690098147","room_confirmation_number":"SJ12623750966","room_stay_from":"2020-01-28","room_stay_to":"2020-01-31","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":"94640","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-17 05:18:37","reservation_modified_date_time":"2020-01-28 12:22:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94640","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":"3063047","reservation_id":"90716","confirmation_number":"SJ12641101247","room_confirmation_number":"SJ12640422694","room_stay_from":"2020-01-27","room_stay_to":"2020-01-31","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":"96799","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-27 22:20:38","reservation_modified_date_time":"2020-01-29 13:31:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96799","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":"3063418","reservation_id":"90905","confirmation_number":"SJ12699510166","room_confirmation_number":"SJ12669985443","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","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":"96999","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 22:53:10","reservation_modified_date_time":"2020-01-29 22:55:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96999","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":"3063429","reservation_id":"90889","confirmation_number":"SJ12621050556","room_confirmation_number":"SJ12688383260","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","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":"96978","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 19:18:11","reservation_modified_date_time":"2020-01-29 23:00:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96978","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":"3063444","reservation_id":"90912","confirmation_number":"SJ12665356487","room_confirmation_number":"SJ12636874365","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","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":"97007","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 23:57:33","reservation_modified_date_time":"2020-01-29 23:57:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97007","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":"3063463","reservation_id":"90920","confirmation_number":"SJ12642796824","room_confirmation_number":"SJ12627208415","room_stay_from":"2020-01-29","room_stay_to":"2020-01-31","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":"97015","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 02:18:29","reservation_modified_date_time":"2020-01-30 02:18:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97015","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":"3063568","reservation_id":"90866","confirmation_number":"SJ12638562173","room_confirmation_number":"SJ12637727233","room_stay_from":"2020-01-29","room_stay_to":"2020-01-31","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":"96954","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 15:53:10","reservation_modified_date_time":"2020-01-30 17:20:18","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96954","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063701","reservation_id":"90959","confirmation_number":"SJ12665033158","room_confirmation_number":"SJ12683343093","room_stay_from":"2020-01-30","room_stay_to":"2020-01-31","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":"97053","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 20:00:11","reservation_modified_date_time":"2020-01-30 20:04:41","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97053","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":"3059592","reservation_id":"89922","confirmation_number":"SJ12661584761","room_confirmation_number":"SJ12694283457","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","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":"95943","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-14 00:16:51","reservation_modified_date_time":"2020-01-14 00:16:51","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":"3060653","reservation_id":"89923","confirmation_number":"SJ12680772532","room_confirmation_number":"SJ12672570534","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","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":"95944","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-14 00:18:35","reservation_modified_date_time":"2020-01-14 00:18:35","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":"3062143","reservation_id":"85092","confirmation_number":"SJ12651740345","room_confirmation_number":"SJ12630974145","room_stay_from":"2020-01-27","room_stay_to":"2020-02-01","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"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":"92325","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-04 03:11:16","reservation_modified_date_time":"2020-01-25 14:47:48","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":"3062375","reservation_id":"80565","confirmation_number":"SJ12617949762","room_confirmation_number":"SJ12617069471","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","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":"88824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-12 00:15:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88824","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":"3063163","reservation_id":"90833","confirmation_number":"SJ12629317900","room_confirmation_number":"SJ12629140123","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","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":"96926","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 01:11:25","reservation_modified_date_time":"2020-01-29 16:55:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96926","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":"3063349","reservation_id":"90774","confirmation_number":"SJ12674433827","room_confirmation_number":"SJ12661604329","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","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":"96979","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 14:09:09","reservation_modified_date_time":"2020-01-29 19:18:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96979","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":"3063413","reservation_id":"90902","confirmation_number":"SJ12688056216","room_confirmation_number":"SJ12672099943","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","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":"96996","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 22:28:11","reservation_modified_date_time":"2020-01-29 22:40:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96996","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":"3063420","reservation_id":"90843","confirmation_number":"SJ12617859108","room_confirmation_number":"SJ12668230148","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","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":"96935","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 03:58:10","reservation_modified_date_time":"2020-01-29 22:55:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96935","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":"3063546","reservation_id":"90942","confirmation_number":"SJ12657557156","room_confirmation_number":"SJ12650099315","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","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":"97037","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 16:58:07","reservation_modified_date_time":"2020-01-30 16:58:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97037","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":"3063548","reservation_id":"90943","confirmation_number":"SJ12699276095","room_confirmation_number":"SJ12644566461","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","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":"97038","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 16:58:11","reservation_modified_date_time":"2020-01-30 16:58:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97038","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":"3063563","reservation_id":"90686","confirmation_number":"SJ12699084022","room_confirmation_number":"SJ12697218628","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","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":"96768","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-27 16:32:06","reservation_modified_date_time":"2020-01-30 17:19:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96768","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":"3063844","reservation_id":"90976","confirmation_number":"SJ12671689461","room_confirmation_number":"SJ12659222139","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","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":"97069","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 22:11:10","reservation_modified_date_time":"2020-01-31 14:18:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97069","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":"3060169","reservation_id":"90303","confirmation_number":"SJ12657289683","room_confirmation_number":"SJ12667776648","room_stay_from":"2020-01-29","room_stay_to":"2020-02-02","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":"96353","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-21 03:23:10","reservation_modified_date_time":"2020-01-21 03:23:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96353","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":"3063849","reservation_id":"90802","confirmation_number":"SJ12672268692","room_confirmation_number":"SJ12682586359","room_stay_from":"2020-01-28","room_stay_to":"2020-02-02","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":"96889","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 20:04:30","reservation_modified_date_time":"2020-01-31 14:35:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96889","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":"3065227","reservation_id":"87928","confirmation_number":"SJ12623788085","room_confirmation_number":"SJ12637915131","room_stay_from":"2020-01-23","room_stay_to":"2020-02-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"94340","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-06 16:08:11","reservation_modified_date_time":"2020-02-02 21:00:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94340","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":"3074345","reservation_id":"73996","confirmation_number":"SJ12661291774","room_confirmation_number":"SJ12664049931","room_stay_from":"2020-01-19","room_stay_to":"2020-02-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"350.00","grand_total":"393.75","paid_amount":"393.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"84586","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-04-04 00:30:59","reservation_modified_date_time":"2020-02-25 23:12:45","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":"3056431","reservation_id":"89720","confirmation_number":"SJ12620654096","room_confirmation_number":"SJ12659215838","room_stay_from":"2020-01-28","room_stay_to":"2020-02-04","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":"95720","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-10 20:36:29","reservation_modified_date_time":"2020-01-10 20:36:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95720","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":"3061960","reservation_id":"90468","confirmation_number":"SJ12697146209","room_confirmation_number":"SJ12668473405","room_stay_from":"2020-01-30","room_stay_to":"2020-02-04","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":"96524","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-23 23:13:10","reservation_modified_date_time":"2020-01-23 23:13:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96524","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":"3069601","reservation_id":"90463","confirmation_number":"SJ12631515357","room_confirmation_number":"SJ12667679631","room_stay_from":"2020-01-26","room_stay_to":"2020-02-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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,0.00,0.00,0.00,0.00,0.00,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":"96519","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-23 22:06:22","reservation_modified_date_time":"2020-02-13 18:21:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96519","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":"3063776","reservation_id":"89437","confirmation_number":"SJ12669061018","room_confirmation_number":"SJ12662961260","room_stay_from":"2020-02-14","room_stay_to":"2020-02-17","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"95401","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-06 00:41:55","reservation_modified_date_time":"2020-01-30 23:59:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95401","canceled_nights_data":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063222","reservation_id":"90882","confirmation_number":"SJ12693716082","room_confirmation_number":"SJ12648632989","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","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-01-29 17:43:12","reservation_modified_date_time":"2020-01-29 17:43:12","customer_id":"96970","parentCustTravId":"96970","customer_traveller_id":"96970","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-01-30 18:05:47","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"}]},{"room_stay_id":"3063225","reservation_id":"90883","confirmation_number":"SJ12654799508","room_confirmation_number":"SJ12611443364","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","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-01-29 17:43:17","reservation_modified_date_time":"2020-01-29 17:43:17","customer_id":"96971","parentCustTravId":"96971","customer_traveller_id":"96971","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-01-30 18:06:12","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":[],"gift_shop_taxable":[{"room_stay_id":"3063801","reservation_id":"90990","confirmation_number":"SJ12611077035","room_confirmation_number":"SJ12692591133","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":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"2","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-31 03:53:07","reservation_modified_date_time":"2020-01-31 03:53:07","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":"4.66","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":"3063696","reservation_id":"90958","confirmation_number":"SJ12614057810","room_confirmation_number":"SJ12698855069","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-01-30 19:39:28","reservation_modified_date_time":"2020-01-30 19:39:28","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":[]}}