{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-03-03","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":14,"holdBlockRooms":{"hold_room_count":"1277","hold_room_bookings":[{"confirmation_number":"SJ12697964990","room_stay_from":"2020-03-03","room_stay_to":"2020-03-07","bundle_room":"0"}],"block_room_count":"1942,1262,1313,1943","block_room_bookings":[{"confirmation_number":"SJ12622180244","room_stay_from":"2020-02-29","room_stay_to":"2020-03-09","bundle_room":"0"},{"confirmation_number":"SJ12632788009","room_stay_from":"2019-12-20","room_stay_to":"2020-03-13","bundle_room":"0"},{"confirmation_number":"SJ12660283277","room_stay_from":"2020-03-02","room_stay_to":"2020-03-13","bundle_room":"0"},{"confirmation_number":"SJ12665142275","room_stay_from":"2020-01-14","room_stay_to":"2020-03-27","bundle_room":"0"}],"bundle_block_count":"1271,1272,1269,1270,1291,1711,1262,1263,1304,1305,1307,1308,1267,1268,1302,1303,1311,1312,1260,1261","bundle_block_bookings":[{"confirmation_number":"SJB12678913002","room_stay_from":"2020-03-03","room_stay_to":"2020-03-04","bundle_room":"1"},{"confirmation_number":"SJB12693335262","room_stay_from":"2020-03-03","room_stay_to":"2020-03-04","bundle_room":"1"},{"confirmation_number":"SJB12634114205","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","bundle_room":"1"},{"confirmation_number":"SJB12653140696","room_stay_from":"2020-03-03","room_stay_to":"2020-03-04","bundle_room":"1"},{"confirmation_number":"SJB12611931336","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","bundle_room":"1"},{"confirmation_number":"SJB12675570011","room_stay_from":"2020-03-03","room_stay_to":"2020-03-04","bundle_room":"1"},{"confirmation_number":"SJB12636937157","room_stay_from":"2020-03-03","room_stay_to":"2020-03-05","bundle_room":"1"},{"confirmation_number":"SJB12613359463","room_stay_from":"2020-03-03","room_stay_to":"2020-03-05","bundle_room":"1"},{"confirmation_number":"SJB12686997721","room_stay_from":"2020-03-03","room_stay_to":"2020-03-05","bundle_room":"1"},{"confirmation_number":"SJB12671735907","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3061594","reservation_id":"90561","confirmation_number":"SJ12661997615","room_stay_from":"2020-03-03","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00","nightly_discount":"0","subtotal":"179.00","grand_total":"201.38","paid_amount":"201.38","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-3690935723","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":"96625","customer_id":"96625","source_of_creation":"Booking.com","reservation_created_date":"2020-01-25 16:29:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"37.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3077054","reservation_id":"91277","confirmation_number":"SJ12612758794","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.50,211.50","nightly_discount":"0,0","subtotal":"423.00","grand_total":"475.88","paid_amount":"475.88","room_type_id":"319","product_id":"1711","siteminder_id":"BDC-2704195438","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":"97400","customer_id":"97400","source_of_creation":"Booking.com","reservation_created_date":"2020-02-04 12:07:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"86.26","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"211.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3077191","reservation_id":"91556","confirmation_number":"SJ12679527244","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"179.00,179.00","nightly_discount":"0,0","subtotal":"358.00","grand_total":"402.75","paid_amount":"402.75","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-2349305187","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":"99029","customer_id":"99029","source_of_creation":"Booking.com","reservation_created_date":"2020-02-08 07:09:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"74.56","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3077534","reservation_id":"92873","confirmation_number":"SJ12624416164","room_stay_from":"2020-03-03","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00","nightly_discount":"0","subtotal":"210.00","grand_total":"236.25","paid_amount":"236.25","room_type_id":"413","product_id":"1268","siteminder_id":"BDC-3648699943","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":"99026","customer_id":"99026","source_of_creation":"Booking.com","reservation_created_date":"2020-03-02 19:58:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"42.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"210.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":"3077544","reservation_id":"92890","confirmation_number":"SJ12619682558","room_stay_from":"2020-03-03","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00","nightly_discount":"0","subtotal":"255.00","grand_total":"286.88","paid_amount":"286.88","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-2259007573","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":"99087","customer_id":"99087","source_of_creation":"Booking.com","reservation_created_date":"2020-03-03 00:52:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"50.40","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"255.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":"3077234","reservation_id":"92227","confirmation_number":"SJ12614689025","room_stay_from":"2020-03-02","room_stay_to":"2020-03-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00,255.00","nightly_discount":"0,0,0","subtotal":"765.00","grand_total":"860.63","paid_amount":"860.63","room_type_id":"319","product_id":"1303","siteminder_id":"BDC-3709279133","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":"99036","customer_id":"99036","source_of_creation":"Booking.com","reservation_created_date":"2020-02-20 00:18:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"152.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"255.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":"3067681","reservation_id":"90655","confirmation_number":"SJ12655152005","room_stay_from":"2020-03-03","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,179.00","nightly_discount":"0,0,0","subtotal":"537.00","grand_total":"604.13","paid_amount":"604.13","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-3163101587","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":"96739","customer_id":"96739","source_of_creation":"Booking.com","reservation_created_date":"2020-01-26 21:33:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"111.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3077542","reservation_id":"90552","confirmation_number":"SJ12657257104","room_stay_from":"2020-03-03","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129,129,129","nightly_discount":"0,0,0","subtotal":"387.00","grand_total":"435.38","paid_amount":"435.38","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-2493406546","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99086","customer_id":"99086","source_of_creation":"Booking.com","reservation_created_date":"2020-01-25 14:15:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"111.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3061759","reservation_id":"90598","confirmation_number":"SJ12621336475","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00","nightly_discount":"0,0","subtotal":"358.00","grand_total":"402.75","paid_amount":"402.75","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1629787678","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":"96670","customer_id":"96670","source_of_creation":"Expedia","reservation_created_date":"2020-01-26 00:23:10","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":"179.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3062385","reservation_id":"90701","confirmation_number":"SJ12630573612","room_stay_from":"2020-03-03","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20","nightly_discount":"0","subtotal":"143.20","grand_total":"161.10","paid_amount":"161.10","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1630723568","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":"96783","customer_id":"96783","source_of_creation":"Expedia","reservation_created_date":"2020-01-27 18:28:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"28.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3062774","reservation_id":"90798","confirmation_number":"SJ12694518161","room_stay_from":"2020-03-01","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20,143.20","nightly_discount":"0,0,0","subtotal":"429.60","grand_total":"483.30","paid_amount":"483.30","room_type_id":"413","product_id":"1272","siteminder_id":"EXP-1631400107","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":"96883","customer_id":"96883","source_of_creation":"Expedia","reservation_created_date":"2020-01-28 19:28:10","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":"143.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3066508","reservation_id":"91419","confirmation_number":"SJ12677373124","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.50,211.50","nightly_discount":"0,0","subtotal":"423.00","grand_total":"475.88","paid_amount":"475.88","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1636679635","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":"97547","customer_id":"97547","source_of_creation":"Expedia","reservation_created_date":"2020-02-06 17:03:15","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":"211.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068194","reservation_id":"91706","confirmation_number":"SJ12619311018","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20","nightly_discount":"0,0","subtotal":"338.40","grand_total":"380.70","paid_amount":"380.70","room_type_id":"319","product_id":"1291","siteminder_id":"EXP-1638814523","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":"97845","customer_id":"97845","source_of_creation":"Expedia","reservation_created_date":"2020-02-10 10:03:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"169.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3073322","reservation_id":"92418","confirmation_number":"SJ12615042752","room_stay_from":"2020-02-28","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.60,201.60,183.60,183.60,183.60","nightly_discount":"0,0,0,0,0","subtotal":"954.00","grand_total":"1073.25","paid_amount":"1073.25","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1647034004","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":"98593","customer_id":"98593","source_of_creation":"Expedia","reservation_created_date":"2020-02-23 14:53:06","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":"183.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074835","reservation_id":"92265","confirmation_number":"SJ12688738184","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,183.60","nightly_discount":"0,0","subtotal":"367.20","grand_total":"413.10","paid_amount":"413.10","room_type_id":"319","product_id":"1305","siteminder_id":"EXP-1645418641","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":"98446","customer_id":"98446","source_of_creation":"Expedia","reservation_created_date":"2020-02-20 17:48:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"183.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076110","reservation_id":"92752","confirmation_number":"SJ12663054518","room_stay_from":"2020-02-29","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.60,183.60,183.60,183.60","nightly_discount":"0,0,0,0","subtotal":"752.40","grand_total":"846.45","paid_amount":"846.45","room_type_id":"319","product_id":"1307","siteminder_id":"EXP-1650665381","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":"98899","customer_id":"98899","source_of_creation":"Expedia","reservation_created_date":"2020-02-29 14:34:11","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":"183.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3077135","reservation_id":"90681","confirmation_number":"SJ12674703095","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20","nightly_discount":"0,0","subtotal":"286.40","grand_total":"322.20","paid_amount":"322.20","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1630575098","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":"96764","customer_id":"96764","source_of_creation":"Expedia","reservation_created_date":"2020-01-27 14:00:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3062131","reservation_id":"90674","confirmation_number":"SJ12687711728","room_stay_from":"2020-03-03","room_stay_to":"2020-03-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20","nightly_discount":"0,0","subtotal":"286.40","grand_total":"322.20","paid_amount":"322.20","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1630451325","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":"96757","customer_id":"96757","source_of_creation":"Expedia","reservation_created_date":"2020-01-27 07:53:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3065592","reservation_id":"91108","confirmation_number":"SJ12639247573","room_stay_from":"2020-03-03","room_stay_to":"2020-03-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.50,211.50","nightly_discount":"0,0","subtotal":"423.00","grand_total":"475.88","paid_amount":"475.88","room_type_id":"319","product_id":"1302","siteminder_id":"EXP-1634007425","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":"97235","customer_id":"97235","source_of_creation":"Expedia","reservation_created_date":"2020-02-02 05:18:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"211.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3076551","reservation_id":"91070","confirmation_number":"SJ12655555333","room_stay_from":"2020-02-29","room_stay_to":"2020-03-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"234.00,211.50,211.50,211.50,211.50","nightly_discount":"0,0,0,0,0","subtotal":"1080.00","grand_total":"1215.00","paid_amount":"1215.00","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1633766207","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":"97183","customer_id":"97183","source_of_creation":"Expedia","reservation_created_date":"2020-02-01 18:53:10","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":"211.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3077197","reservation_id":"90515","confirmation_number":"SJ12689853860","room_stay_from":"2020-03-02","room_stay_to":"2020-03-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20,143.20","nightly_discount":"0,0,0","subtotal":"429.60","grand_total":"483.30","paid_amount":"483.30","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1629095118","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":"96570","customer_id":"96570","source_of_creation":"Expedia","reservation_created_date":"2020-01-24 18:33:08","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":"143.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3077005","reservation_id":"92848","confirmation_number":"SJ12693928580","room_stay_from":"2020-03-02","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"204.00,204.00,204.00,204.00","nightly_discount":"0,0,0,0","subtotal":"816.00","grand_total":"918.00","paid_amount":"918.00","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1651437482","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":"99000","customer_id":"99000","source_of_creation":"Expedia","reservation_created_date":"2020-03-02 02:19:12","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":"204.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3055197","reservation_id":"86752","confirmation_number":"SJ12617303084","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"272.80,230.40,230.40,230.40,230.40,230.40,272.80","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1697.60","grand_total":"1909.80","paid_amount":"1909.80","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1375501820","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":"93421","customer_id":"93421","source_of_creation":"Expedia","reservation_created_date":"2019-11-06 16:30:10","canceled_nights_data":"","product_name":"Deluxe 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":"230.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3064014","reservation_id":"91023","confirmation_number":"SJ12689263523","room_stay_from":"2020-03-03","room_stay_to":"2020-03-08","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","nightly_discount":"0,0,0,0,0","subtotal":"882.00","grand_total":"992.25","paid_amount":"992.25","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1633421734","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":"97130","customer_id":"97130","source_of_creation":"Expedia","reservation_created_date":"2020-02-01 01:03: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","migrated_id":"","currentDayPrice":"169.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3070460","reservation_id":"92060","confirmation_number":"SJ12678483548","room_stay_from":"2020-03-02","room_stay_to":"2020-03-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.37,169.37,169.37","nightly_discount":"0,0,0","subtotal":"508.11","grand_total":"571.63","paid_amount":"571.63","room_type_id":"319","product_id":"1293","siteminder_id":"HTN-119600662-XNTVGZ","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":"98229","customer_id":"98229","source_of_creation":"HotelTonight","reservation_created_date":"2020-02-16 19:34:08","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":"169.37","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3062376","reservation_id":"90700","confirmation_number":"SJ12621052693","room_stay_from":"2020-03-03","room_stay_to":"2020-03-04","room_stay_status":"Checked-In","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":"1269","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":"96782","customer_id":"96782","source_of_creation":"FE","reservation_created_date":"2020-01-27 18:25:44","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":"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":"3077340","reservation_id":"92195","confirmation_number":"SJ12655913785","room_stay_from":"2020-03-03","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00,255.00","nightly_discount":"0.00,0.00,0.00","subtotal":"765.00","grand_total":"860.63","paid_amount":"860.63","room_type_id":"319","product_id":"1314","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98382","customer_id":"98382","source_of_creation":"FE","reservation_created_date":"2020-02-19 15:21:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3077100","reservation_id":"90827","confirmation_number":"SJ12697439638","room_stay_from":"2020-03-01","room_stay_to":"2020-03-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,179.00,179.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"716.00","grand_total":"805.50","paid_amount":"777.37","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":"96915","customer_id":"96915","source_of_creation":"PMS","reservation_created_date":"2020-01-28 23:36:26","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":"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":"3077425","reservation_id":"92910","confirmation_number":"SJ12658611877","room_stay_from":"2020-03-03","room_stay_to":"2020-03-05","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":"319","product_id":"1312","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99066","customer_id":"99066","source_of_creation":"PMS","reservation_created_date":"2020-03-03 16:46:26","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":"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":"3077517","reservation_id":"92590","confirmation_number":"SJ12659490433","room_stay_from":"2020-02-22","room_stay_to":"2020-03-13","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,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,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"413","product_id":"1261","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":"74162","customer_id":"74162","source_of_creation":"PMS","reservation_created_date":"2020-02-26 13:36:23","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3077573","reservation_id":"90408","confirmation_number":"SJ12696514497","room_stay_from":"2020-02-26","room_stay_to":"2020-03-03","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,215.00,215.00,179.00,178.99","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1145.99","grand_total":"1289.24","paid_amount":"1289.24","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":"96459","customer_id":"96459","source_of_creation":"PMS","reservation_created_date":"2020-01-23 02:02:11","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":"","changedComment":"Nightly price or discount changed","deltaChange":"-0.01","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":"3063607","reservation_id":"90536","confirmation_number":"SJ12678284131","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","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":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-01-25 01:27:28","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":"160.72","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":"3060583","reservation_id":"90092","confirmation_number":"SJ12692020381","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","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-16 20:24: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":"3068639","reservation_id":"91759","confirmation_number":"SJ12612193407","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"412","product_id":"1316","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-02-11 01:00:18","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":"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":"3068643","reservation_id":"91761","confirmation_number":"SJ12683533919","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-02-11 01:04:41","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"}]}],"negotiated_taxable":[{"room_stay_id":"3074364","reservation_id":"86398","confirmation_number":"SJ12650609805","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"893.34","grand_total":"1005.01","paid_amount":"196.88","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-10-29 02:20:04","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":"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":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3077540","reservation_id":"90552","confirmation_number":"SJ12698606943","room_confirmation_number":"SJ12657257104","room_stay_from":"2020-03-03","room_stay_to":"2020-03-06","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"99086","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-01-25 14:15:09","reservation_modified_date_time":"2020-03-03 22:38:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99086","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":"3061595","reservation_id":"90561","confirmation_number":"SJ12641396392","room_confirmation_number":"SJ12661997615","room_stay_from":"2020-03-03","room_stay_to":"2020-03-04","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":"96625","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 16:29:09","reservation_modified_date_time":"2020-01-25 16:29:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96625","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":"3061760","reservation_id":"90598","confirmation_number":"SJ12691286763","room_confirmation_number":"SJ12621336475","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","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":"96670","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-26 00:23:10","reservation_modified_date_time":"2020-01-26 00:23:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96670","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":"3062377","reservation_id":"90700","confirmation_number":"SJ12612590038","room_confirmation_number":"SJ12621052693","room_stay_from":"2020-03-03","room_stay_to":"2020-03-04","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":"96782","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-27 18:25:44","reservation_modified_date_time":"2020-01-27 18:25:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96782","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":"3062387","reservation_id":"90701","confirmation_number":"SJ12637243654","room_confirmation_number":"SJ12630573612","room_stay_from":"2020-03-03","room_stay_to":"2020-03-04","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":"96783","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-27 18:28:09","reservation_modified_date_time":"2020-01-27 18:28:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96783","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":"3062775","reservation_id":"90798","confirmation_number":"SJ12699435082","room_confirmation_number":"SJ12694518161","room_stay_from":"2020-03-01","room_stay_to":"2020-03-04","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":"96883","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 19:28:10","reservation_modified_date_time":"2020-01-28 19:28:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96883","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":"3066509","reservation_id":"91419","confirmation_number":"SJ12657123032","room_confirmation_number":"SJ12677373124","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","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":"97547","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 17:03:15","reservation_modified_date_time":"2020-02-06 17:03:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97547","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":"3068195","reservation_id":"91706","confirmation_number":"SJ12645567253","room_confirmation_number":"SJ12619311018","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","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":"97845","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-10 10:03:05","reservation_modified_date_time":"2020-02-10 10:03:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97845","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":"3073323","reservation_id":"92418","confirmation_number":"SJ12643420486","room_confirmation_number":"SJ12615042752","room_stay_from":"2020-02-28","room_stay_to":"2020-03-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":"98593","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-23 14:53:06","reservation_modified_date_time":"2020-02-23 14:53:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98593","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":"3074837","reservation_id":"92265","confirmation_number":"SJ12653332573","room_confirmation_number":"SJ12688738184","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","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":"98446","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-20 17:48:07","reservation_modified_date_time":"2020-02-26 21:39:03","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98446","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":"3076112","reservation_id":"92752","confirmation_number":"SJ12681944020","room_confirmation_number":"SJ12663054518","room_stay_from":"2020-02-29","room_stay_to":"2020-03-04","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":"98899","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-29 14:34:11","reservation_modified_date_time":"2020-02-29 15:14:42","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98899","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":"3077055","reservation_id":"91277","confirmation_number":"SJ12677353921","room_confirmation_number":"SJ12612758794","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","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":"97400","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-04 12:07:09","reservation_modified_date_time":"2020-03-02 12:05:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97400","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":"3077137","reservation_id":"90681","confirmation_number":"SJ12646612716","room_confirmation_number":"SJ12674703095","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","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":"96764","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-27 14:00:05","reservation_modified_date_time":"2020-03-02 18:13:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96764","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":"3077190","reservation_id":"91556","confirmation_number":"SJ12688213983","room_confirmation_number":"SJ12679527244","room_stay_from":"2020-03-02","room_stay_to":"2020-03-04","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":"99029","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 07:09:11","reservation_modified_date_time":"2020-03-02 20:41:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99029","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":"3077533","reservation_id":"92873","confirmation_number":"SJ12671697346","room_confirmation_number":"SJ12624416164","room_stay_from":"2020-03-03","room_stay_to":"2020-03-04","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":"99026","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-02 19:58:10","reservation_modified_date_time":"2020-03-03 22:05:16","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99026","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":"3077543","reservation_id":"92890","confirmation_number":"SJ12626009676","room_confirmation_number":"SJ12619682558","room_stay_from":"2020-03-03","room_stay_to":"2020-03-04","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":"99087","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-03 00:52:07","reservation_modified_date_time":"2020-03-03 22:39:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99087","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":"3062132","reservation_id":"90674","confirmation_number":"SJ12613672028","room_confirmation_number":"SJ12687711728","room_stay_from":"2020-03-03","room_stay_to":"2020-03-05","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":"96757","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-27 07:53:10","reservation_modified_date_time":"2020-01-27 07:53:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96757","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":"3065594","reservation_id":"91108","confirmation_number":"SJ12670172917","room_confirmation_number":"SJ12639247573","room_stay_from":"2020-03-03","room_stay_to":"2020-03-05","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":"97235","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 05:18:11","reservation_modified_date_time":"2020-02-03 17:36:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97235","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":"3070461","reservation_id":"92060","confirmation_number":"SJ12647202179","room_confirmation_number":"SJ12678483548","room_stay_from":"2020-03-02","room_stay_to":"2020-03-05","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":"98229","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-16 19:34:08","reservation_modified_date_time":"2020-02-16 19:34:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98229","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":"3076553","reservation_id":"91070","confirmation_number":"SJ12682490106","room_confirmation_number":"SJ12655555333","room_stay_from":"2020-02-29","room_stay_to":"2020-03-05","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":"97183","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 18:53:10","reservation_modified_date_time":"2020-03-01 01:00:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97183","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":"3077101","reservation_id":"90827","confirmation_number":"SJ12658880324","room_confirmation_number":"SJ12697439638","room_stay_from":"2020-03-01","room_stay_to":"2020-03-05","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":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"96915","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 23:36:26","reservation_modified_date_time":"2020-03-02 16:10:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96915","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":"3077198","reservation_id":"90515","confirmation_number":"SJ12663269646","room_confirmation_number":"SJ12689853860","room_stay_from":"2020-03-02","room_stay_to":"2020-03-05","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":"96570","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-24 18:33:08","reservation_modified_date_time":"2020-03-02 21:06:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96570","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":"3077233","reservation_id":"92227","confirmation_number":"SJ12643735154","room_confirmation_number":"SJ12614689025","room_stay_from":"2020-03-02","room_stay_to":"2020-03-05","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":"99036","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-20 00:18:10","reservation_modified_date_time":"2020-03-02 22:22:27","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99036","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":"3077426","reservation_id":"92910","confirmation_number":"SJ12624900923","room_confirmation_number":"SJ12658611877","room_stay_from":"2020-03-03","room_stay_to":"2020-03-05","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":"99066","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-03 16:46:26","reservation_modified_date_time":"2020-03-03 16:46:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99066","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":"3063608","reservation_id":"90536","confirmation_number":"SJ12691035339","room_confirmation_number":"SJ12678284131","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","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":"96598","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 01:27:28","reservation_modified_date_time":"2020-01-30 17:52:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3067682","reservation_id":"90655","confirmation_number":"SJ12677902218","room_confirmation_number":"SJ12655152005","room_stay_from":"2020-03-03","room_stay_to":"2020-03-06","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":"96739","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-26 21:33:12","reservation_modified_date_time":"2020-02-09 12:10:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96739","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":"3074363","reservation_id":"86398","confirmation_number":"SJ12663775501","room_confirmation_number":"SJ12650609805","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"95414","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-29 02:20:04","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":"3077006","reservation_id":"92848","confirmation_number":"SJ12699511033","room_confirmation_number":"SJ12693928580","room_stay_from":"2020-03-02","room_stay_to":"2020-03-06","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":"99000","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-02 02:19:12","reservation_modified_date_time":"2020-03-02 02:19:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99000","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":"3077341","reservation_id":"92195","confirmation_number":"SJ12649677517","room_confirmation_number":"SJ12655913785","room_stay_from":"2020-03-03","room_stay_to":"2020-03-06","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":"98382","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-19 15:21:10","reservation_modified_date_time":"2020-03-03 12:40:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98382","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":"3077541","reservation_id":"90552","confirmation_number":"SJ12635717314","room_confirmation_number":"SJ12657257104","room_stay_from":"2020-03-03","room_stay_to":"2020-03-06","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":"99086","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 14:15:09","reservation_modified_date_time":"2020-03-03 22:38:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99086","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":"3055199","reservation_id":"86752","confirmation_number":"SJ12661253646","room_confirmation_number":"SJ12617303084","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","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":"93421","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-06 16:30:10","reservation_modified_date_time":"2019-11-06 16:30:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93421","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":"3060584","reservation_id":"90092","confirmation_number":"SJ12690545263","room_confirmation_number":"SJ12692020381","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","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":"96124","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-16 20:24:40","reservation_modified_date_time":"2020-01-16 20:24:40","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":"3068640","reservation_id":"91759","confirmation_number":"SJ12618322882","room_confirmation_number":"SJ12612193407","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"96904","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 01:00:18","reservation_modified_date_time":"2020-02-11 01:00:18","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":"3068644","reservation_id":"91761","confirmation_number":"SJ12647559783","room_confirmation_number":"SJ12683533919","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","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":"97903","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 01:04:41","reservation_modified_date_time":"2020-02-11 01:04:41","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":"3064015","reservation_id":"91023","confirmation_number":"SJ12613691427","room_confirmation_number":"SJ12689263523","room_stay_from":"2020-03-03","room_stay_to":"2020-03-08","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":"97130","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 01:03:07","reservation_modified_date_time":"2020-02-01 01:03:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97130","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":"3077518","reservation_id":"92590","confirmation_number":"SJ12696987483","room_confirmation_number":"SJ12659490433","room_stay_from":"2020-02-22","room_stay_to":"2020-03-13","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,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,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"74162","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-26 13:36:23","reservation_modified_date_time":"2020-03-03 20:57:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74162","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3077550","reservation_id":"90870","confirmation_number":"SJ12668384588","room_confirmation_number":"SJ12646152730","room_stay_from":"2020-02-15","room_stay_to":"2020-02-16","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"96958","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 16:29:09","reservation_modified_date_time":"2020-03-03 23:27:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96958","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"-25.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3077395","reservation_id":"92904","confirmation_number":"SJ12632121588","room_confirmation_number":"SJ12651293822","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"7.99","grand_total":"8.59","paid_amount":"8.59","product_id":null,"service_quantity":"1","product_name":"Key Lime Soap","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-03 15:36:30","reservation_modified_date_time":"2020-03-03 15:36:30","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":"7.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}