{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-03-11","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":16,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1942,1943","block_room_bookings":[{"confirmation_number":"SJ12622180244","room_stay_from":"2020-02-29","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":"1269,1270,1262,1263,1271,1272,1260,1261,1311,1312,1267,1268,1302,1303,1304,1305,1307,1308,1309,1310,1291,1711","bundle_block_bookings":[{"confirmation_number":"SJB12691027852","room_stay_from":"2020-03-09","room_stay_to":"2020-03-12","bundle_room":"1"},{"confirmation_number":"SJB12694131585","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","bundle_room":"1"},{"confirmation_number":"SJB12698238327","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","bundle_room":"1"},{"confirmation_number":"SJB12641390329","room_stay_from":"2020-03-09","room_stay_to":"2020-03-12","bundle_room":"1"},{"confirmation_number":"SJB12644472257","room_stay_from":"2020-03-05","room_stay_to":"2020-03-12","bundle_room":"1"},{"confirmation_number":"SJB12637767675","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","bundle_room":"1"},{"confirmation_number":"SJB12681133603","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","bundle_room":"1"},{"confirmation_number":"SJB12623258397","room_stay_from":"2020-03-10","room_stay_to":"2020-03-13","bundle_room":"1"},{"confirmation_number":"SJB12674167413","room_stay_from":"2020-03-08","room_stay_to":"2020-03-13","bundle_room":"1"},{"confirmation_number":"SJB12617714889","room_stay_from":"2020-03-07","room_stay_to":"2020-03-13","bundle_room":"1"},{"confirmation_number":"SJB12698794759","room_stay_from":"2020-03-10","room_stay_to":"2020-03-18","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3065280","reservation_id":"91114","confirmation_number":"SJ12698903853","room_stay_from":"2020-03-09","room_stay_to":"2020-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"111.1,111.1,111.1","nightly_discount":"0,0,0","subtotal":"333.30","grand_total":"374.97","paid_amount":"374.97","room_type_id":"413","product_id":"1269","siteminder_id":"BDC-3545660977","collect_which":"channel_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":"97241","customer_id":"97241","source_of_creation":"Booking.com","reservation_created_date":"2020-02-02 11:42:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"102.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.1","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068844","reservation_id":"91783","confirmation_number":"SJ12669745120","room_stay_from":"2020-03-09","room_stay_to":"2020-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"136.1,136.1,136.1","nightly_discount":"0,0,0","subtotal":"408.30","grand_total":"459.34","paid_amount":"459.34","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-3769100109","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97929","customer_id":"97929","source_of_creation":"Booking.com","reservation_created_date":"2020-02-11 14:57:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"102.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136.1","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3077660","reservation_id":"90353","confirmation_number":"SJ12616569267","room_stay_from":"2020-03-10","room_stay_to":"2020-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.10,161.10","nightly_discount":"0,0","subtotal":"322.20","grand_total":"362.48","paid_amount":"362.48","room_type_id":"319","product_id":"1309","siteminder_id":"BDC-2828323568","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":"96399","customer_id":"96399","source_of_creation":"Booking.com","reservation_created_date":"2020-01-22 16:34:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"68.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"161.10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3079385","reservation_id":"93112","confirmation_number":"SJ12680313702","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"160","nightly_discount":"0","subtotal":"160.00","grand_total":"180.00","paid_amount":"180.00","room_type_id":"413","product_id":"1267","siteminder_id":"BDC-2670062505","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":"99307","customer_id":"99307","source_of_creation":"Booking.com","reservation_created_date":"2020-03-08 18:05:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"84.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160","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":"3079476","reservation_id":"91594","confirmation_number":"SJ12622898774","room_stay_from":"2020-03-08","room_stay_to":"2020-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129,129,129,129","nightly_discount":"0,0,0,0","subtotal":"516.00","grand_total":"580.50","paid_amount":"580.50","room_type_id":"319","product_id":"1305","siteminder_id":"BDC-2349355706","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":"99318","customer_id":"99318","source_of_creation":"Booking.com","reservation_created_date":"2020-02-08 19:13:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"149.12","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"}]},{"room_stay_id":"3079477","reservation_id":"93121","confirmation_number":"SJ12684632168","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"229.50","nightly_discount":"0","subtotal":"229.50","grand_total":"258.19","paid_amount":"258.19","room_type_id":"319","product_id":"1276","siteminder_id":"BDC-3950645441","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":"99319","customer_id":"99319","source_of_creation":"Booking.com","reservation_created_date":"2020-03-08 23:44:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"45.81","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"229.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":"3080084","reservation_id":"93125","confirmation_number":"SJ12620588331","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","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":"264.38","room_type_id":"319","product_id":"1756","siteminder_id":"BDC-3193055836","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":"99324","customer_id":"99324","source_of_creation":"Booking.com","reservation_created_date":"2020-03-09 00:53:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","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":"3080252","reservation_id":"92684","confirmation_number":"SJ12627162811","room_stay_from":"2020-03-10","room_stay_to":"2020-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00","nightly_discount":"0,0","subtotal":"510.00","grand_total":"573.75","paid_amount":"573.75","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2841517799","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":"99404","customer_id":"99404","source_of_creation":"Booking.com","reservation_created_date":"2020-02-27 20:33:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"100.80","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":"3080483","reservation_id":"92998","confirmation_number":"SJ12612721616","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"139","nightly_discount":"0","subtotal":"139.00","grand_total":"156.38","paid_amount":"156.38","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-2346319123","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":"99168","customer_id":"99168","source_of_creation":"Booking.com","reservation_created_date":"2020-03-05 22:23:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"38.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139","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":"3080650","reservation_id":"93112","confirmation_number":"SJ12694547892","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"160","nightly_discount":"0","subtotal":"160.00","grand_total":"180.00","paid_amount":"180.00","room_type_id":"413","product_id":"1268","siteminder_id":"BDC-2670062505","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":"99307","customer_id":"99307","source_of_creation":"Booking.com","reservation_created_date":"2020-03-08 18:05:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"84.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160","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":"3075765","reservation_id":"92465","confirmation_number":"SJ12698770200","room_stay_from":"2020-03-10","room_stay_to":"2020-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"297.00,297.00,297.00","nightly_discount":"0,0,0","subtotal":"891.00","grand_total":"1002.38","paid_amount":"1002.38","room_type_id":"319","product_id":"1302","siteminder_id":"BDC-3629044258","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":"98631","customer_id":"98631","source_of_creation":"Booking.com","reservation_created_date":"2020-02-24 01:46:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"173.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"297.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3072247","reservation_id":"92298","confirmation_number":"SJ12643918455","room_stay_from":"2020-03-11","room_stay_to":"2020-03-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00,280.00","nightly_discount":"0,0,0","subtotal":"790.00","grand_total":"888.75","paid_amount":"888.75","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-2253211369","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":"98481","customer_id":"98481","source_of_creation":"Booking.com","reservation_created_date":"2020-02-21 15:23:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"155.70","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":"3080578","reservation_id":"90935","confirmation_number":"SJ12674648229","room_stay_from":"2020-03-26","room_stay_to":"2020-03-29","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,215.00,215.00","nightly_discount":"0,0,0","subtotal":"609.00","grand_total":"685.13","paid_amount":"145.13","room_type_id":"413","product_id":"1271","siteminder_id":"BDC-3018444228","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":"97031","customer_id":"97031","source_of_creation":"Booking.com","reservation_created_date":"2020-01-30 14:42:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"123.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates 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":"3080490","reservation_id":"92623","confirmation_number":"SJ12690384005","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.89,136.89","nightly_discount":"0,0","subtotal":"273.78","grand_total":"308.00","paid_amount":"255.15","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-3541088906","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":"98778","customer_id":"98778","source_of_creation":"Booking.com","reservation_created_date":"2020-02-26 22:45:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"58.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates 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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3069267","reservation_id":"91871","confirmation_number":"SJ12621718072","room_stay_from":"2020-03-09","room_stay_to":"2020-03-12","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":"1260","siteminder_id":"EXP-1640434941","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":"98017","customer_id":"98017","source_of_creation":"Expedia","reservation_created_date":"2020-02-12 19:23:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3079141","reservation_id":"91722","confirmation_number":"SJ12646341870","room_stay_from":"2020-03-07","room_stay_to":"2020-03-12","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":"318","product_id":"1282","siteminder_id":"EXP-1638963367","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":"97861","customer_id":"97861","source_of_creation":"Expedia","reservation_created_date":"2020-02-10 15:59:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3079154","reservation_id":"92080","confirmation_number":"SJ12684702523","room_stay_from":"2020-03-09","room_stay_to":"2020-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"168.00,168.00,168.00","nightly_discount":"0,0,0","subtotal":"504.00","grand_total":"567.00","paid_amount":"567.00","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1643096869","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":"98256","customer_id":"98256","source_of_creation":"Expedia","reservation_created_date":"2020-02-17 04:04:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"168.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":"3080412","reservation_id":"93212","confirmation_number":"SJ12692101685","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.00","nightly_discount":"0","subtotal":"168.00","grand_total":"189.00","paid_amount":"189.00","room_type_id":"413","product_id":"1272","siteminder_id":"EXP-1656239511","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":"99419","customer_id":"99419","source_of_creation":"Expedia","reservation_created_date":"2020-03-10 23:30: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":"168.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":"3080443","reservation_id":"93156","confirmation_number":"SJ12639529908","room_stay_from":"2020-03-10","room_stay_to":"2020-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.00,189.00","nightly_discount":"0.00,0.00","subtotal":"357.00","grand_total":"401.63","paid_amount":"401.63","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1655629670","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":"99354","customer_id":"99354","source_of_creation":"Expedia","reservation_created_date":"2020-03-09 19:44:08","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":"189.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":"3064650","reservation_id":"90985","confirmation_number":"SJ12642768191","room_stay_from":"2020-03-09","room_stay_to":"2020-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20,143.20,143.20","nightly_discount":"0,0,0,0","subtotal":"572.80","grand_total":"644.40","paid_amount":"644.40","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1632849328","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":"97080","customer_id":"97080","source_of_creation":"Expedia","reservation_created_date":"2020-01-31 02:13:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3068693","reservation_id":"91613","confirmation_number":"SJ12673339256","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","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":"319","product_id":"1303","siteminder_id":"EXP-1638016367","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":"97750","customer_id":"97750","source_of_creation":"Expedia","reservation_created_date":"2020-02-08 22:08:10","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","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":"3068699","reservation_id":"90967","confirmation_number":"SJ12663191837","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"204.00,204.00","nightly_discount":"0,0","subtotal":"408.00","grand_total":"459.00","paid_amount":"459.00","room_type_id":"319","product_id":"1287","siteminder_id":"EXP-1632698406","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":"97061","customer_id":"97061","source_of_creation":"Expedia","reservation_created_date":"2020-01-30 20:53:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3069053","reservation_id":"91828","confirmation_number":"SJ12649786604","room_stay_from":"2020-03-09","room_stay_to":"2020-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20,143.20,143.20","nightly_discount":"0,0,0,0","subtotal":"572.80","grand_total":"644.40","paid_amount":"644.40","room_type_id":"413","product_id":"1273","siteminder_id":"EXP-1639973935","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":"97979","customer_id":"97979","source_of_creation":"Expedia","reservation_created_date":"2020-02-12 01:43:08","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":"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":"3072468","reservation_id":"92338","confirmation_number":"SJ12660607340","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.00,168.00","nightly_discount":"0,0","subtotal":"336.00","grand_total":"378.00","paid_amount":"378.00","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1646288108","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":"98521","customer_id":"98521","source_of_creation":"Expedia","reservation_created_date":"2020-02-22 00:28:11","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","migrated_id":"","currentDayPrice":"168.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":"3076599","reservation_id":"91552","confirmation_number":"SJ12633336898","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","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":"1264","siteminder_id":"EXP-1637645245","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":"97687","customer_id":"97687","source_of_creation":"Expedia","reservation_created_date":"2020-02-08 03:48:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3077513","reservation_id":"91768","confirmation_number":"SJ12637621036","room_stay_from":"2020-03-09","room_stay_to":"2020-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20,143.20,143.20","nightly_discount":"0,0,0,0","subtotal":"572.80","grand_total":"644.40","paid_amount":"644.40","room_type_id":"319","product_id":"1308","siteminder_id":"EXP-1639346720","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":"97914","customer_id":"97914","source_of_creation":"Expedia","reservation_created_date":"2020-02-11 02:54:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3079063","reservation_id":"92612","confirmation_number":"SJ12671412672","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"168.00,168.00","nightly_discount":"0,0","subtotal":"336.00","grand_total":"378.00","paid_amount":"378.00","room_type_id":"319","product_id":"1319","siteminder_id":"EXP-1649038468","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":"98765","customer_id":"98765","source_of_creation":"Expedia","reservation_created_date":"2020-02-26 19:03:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"168.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":"3079293","reservation_id":"92885","confirmation_number":"SJ12621634969","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00,210.00","nightly_discount":"0,0","subtotal":"420.00","grand_total":"472.50","paid_amount":"472.50","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1651945035","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":"99297","customer_id":"99297","source_of_creation":"Expedia","reservation_created_date":"2020-03-02 23:24:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3080295","reservation_id":"92158","confirmation_number":"SJ12627601394","room_stay_from":"2020-03-10","room_stay_to":"2020-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"204.00,204.00,204.00","nightly_discount":"0,0,0","subtotal":"612.00","grand_total":"688.50","paid_amount":"688.50","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1644222679","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":"99408","customer_id":"99408","source_of_creation":"Expedia","reservation_created_date":"2020-02-18 21:14:13","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3080402","reservation_id":"93211","confirmation_number":"SJ12659589273","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.00,168.00","nightly_discount":"0,0","subtotal":"336.00","grand_total":"378.00","paid_amount":"378.00","room_type_id":"413","product_id":"1262","siteminder_id":"EXP-1656238840","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":"99418","customer_id":"99418","source_of_creation":"Expedia","reservation_created_date":"2020-03-10 23:24:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"168.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":"3064652","reservation_id":"90796","confirmation_number":"SJ12661991029","room_stay_from":"2020-03-10","room_stay_to":"2020-03-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20,143.20,172.00","nightly_discount":"0,0,0,0","subtotal":"601.60","grand_total":"676.80","paid_amount":"676.80","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1631378112","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":"96879","customer_id":"96879","source_of_creation":"Expedia","reservation_created_date":"2020-01-28 18:48:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3076608","reservation_id":"92806","confirmation_number":"SJ12685779682","room_stay_from":"2020-03-11","room_stay_to":"2020-03-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.00,168.00,196.00","nightly_discount":"0,0,0","subtotal":"532.00","grand_total":"598.50","paid_amount":"598.50","room_type_id":"413","product_id":"1270","siteminder_id":"EXP-1651021242","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":"98957","customer_id":"98957","source_of_creation":"Expedia","reservation_created_date":"2020-03-01 05:19:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"168.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3067944","reservation_id":"91660","confirmation_number":"SJ12626085803","room_stay_from":"2020-03-11","room_stay_to":"2020-03-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,187.20,187.20,169.20","nightly_discount":"0,0,0,0,0","subtotal":"882.00","grand_total":"992.25","paid_amount":"992.25","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1638470787","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97799","customer_id":"97799","source_of_creation":"Expedia","reservation_created_date":"2020-02-09 20:03:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3067095","reservation_id":"91486","confirmation_number":"SJ12611429751","room_stay_from":"2020-03-10","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,169.20,187.20,187.20,169.20,169.20,169.20","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1389.60","grand_total":"1563.30","paid_amount":"1563.30","room_type_id":"319","product_id":"1291","siteminder_id":"EXP-1637238795","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97615","customer_id":"97615","source_of_creation":"Expedia","reservation_created_date":"2020-02-07 14:38:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"277.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3077665","reservation_id":"92940","confirmation_number":"SJ12661649081","room_stay_from":"2020-03-11","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"215.20,204.00,224.00,224.00,204.00,204.00,215.20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1490.40","grand_total":"1676.70","paid_amount":"1676.70","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1652818230","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99105","customer_id":"99105","source_of_creation":"Expedia","reservation_created_date":"2020-03-04 14:19:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"215.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":"3079553","reservation_id":"91487","confirmation_number":"SJ12643636295","room_stay_from":"2020-03-10","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"169.20,169.20,169.20,187.20,187.20,169.20,169.20,169.20","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1389.60","grand_total":"1563.30","paid_amount":"1563.30","room_type_id":"319","product_id":"1711","siteminder_id":"EXP-1637238799","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97616","customer_id":"97616","source_of_creation":"Expedia","reservation_created_date":"2020-02-07 14:38:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"277.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3080015","reservation_id":"91860","confirmation_number":"SJ12679190526","room_stay_from":"2020-03-11","room_stay_to":"2020-03-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,187.20,187.20,169.20,169.20,169.20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1220.40","grand_total":"1372.95","paid_amount":"1372.95","room_type_id":"411","product_id":"1296","siteminder_id":"EXP-1640338173","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98008","customer_id":"98008","source_of_creation":"Expedia","reservation_created_date":"2020-02-12 16:44:13","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3079987","reservation_id":"93177","confirmation_number":"SJ12636909706","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.48,169.37","nightly_discount":"0,0","subtotal":"308.85","grand_total":"347.45","paid_amount":"347.45","room_type_id":"319","product_id":"1277","siteminder_id":"HTN-122640258-RV7WZV","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":"99373","customer_id":"99373","source_of_creation":"HotelTonight","reservation_created_date":"2020-03-10 03:26:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.48","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":"3080104","reservation_id":"93185","confirmation_number":"SJ12658440906","room_stay_from":"2020-03-10","room_stay_to":"2020-03-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.37,139.48,169.37,162.73","nightly_discount":"0,0,0,0","subtotal":"640.95","grand_total":"721.07","paid_amount":"721.07","room_type_id":"319","product_id":"1314","siteminder_id":"HTN-122675099-7WGGFK","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":"99385","customer_id":"99385","source_of_creation":"HotelTonight","reservation_created_date":"2020-03-10 14:57:08","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":"139.48","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":"3080698","reservation_id":"93243","confirmation_number":"SJ12638991507","room_stay_from":"2020-03-11","room_stay_to":"2020-03-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.48,169.37,162.73","nightly_discount":"0.00,0.00,0.00","subtotal":"471.58","grand_total":"530.53","paid_amount":"530.53","room_type_id":"412","product_id":"1315","siteminder_id":"HTN-122878067-F3WMNQ","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":"99449","customer_id":"99449","source_of_creation":"HotelTonight","reservation_created_date":"2020-03-11 23:23:08","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":"139.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3078596","reservation_id":"92707","confirmation_number":"SJ12662042316","room_stay_from":"2020-03-05","room_stay_to":"2020-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,280.00,280.00,255.00,255.00,255.00,255.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1835.00","grand_total":"2064.38","paid_amount":"2064.38","room_type_id":"319","product_id":"1311","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98852","customer_id":"98852","source_of_creation":"FE","reservation_created_date":"2020-02-28 04:13:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3068696","reservation_id":"89937","confirmation_number":"SJ12669588844","room_stay_from":"2020-03-10","room_stay_to":"2020-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"287.83,287.83,287.83","nightly_discount":"0.00,0.00,0.00","subtotal":"863.49","grand_total":"971.42","paid_amount":"971.42","room_type_id":"319","product_id":"1913","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":"95957","customer_id":"95957","source_of_creation":"FE","reservation_created_date":"2020-01-14 04:38:45","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":"287.83","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068712","reservation_id":"90259","confirmation_number":"SJ12638828272","room_stay_from":"2020-03-08","room_stay_to":"2020-03-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"287.83,287.83,287.83,287.83,287.83","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1439.15","grand_total":"1619.05","paid_amount":"1619.05","room_type_id":"319","product_id":"1307","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96308","customer_id":"96308","source_of_creation":"FE","reservation_created_date":"2020-01-20 17:49:39","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":"287.83","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3075018","reservation_id":"92088","confirmation_number":"SJ12693733794","room_stay_from":"2020-03-11","room_stay_to":"2020-03-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00,280.00,280.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1070.00","grand_total":"1203.75","paid_amount":"1203.75","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98263","customer_id":"98263","source_of_creation":"FE","reservation_created_date":"2020-02-17 14:33:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3080710","reservation_id":"93250","confirmation_number":"SJ12649710165","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","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":"318","product_id":"1281","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99456","customer_id":"99456","source_of_creation":"PMS","reservation_created_date":"2020-03-12 02:40:02","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":"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":"3068704","reservation_id":"90356","confirmation_number":"SJ12691408531","room_stay_from":"2020-03-10","room_stay_to":"2020-03-13","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.00,0.00,0.00","subtotal":"537.00","grand_total":"604.13","paid_amount":"604.13","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":"96401","customer_id":"96401","source_of_creation":"PMS","reservation_created_date":"2020-01-22 17:07:39","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3080460","reservation_id":"93218","confirmation_number":"SJ12657963842","room_stay_from":"2020-03-10","room_stay_to":"2020-03-11","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00","nightly_discount":"0.00","subtotal":"255.00","grand_total":"286.88","paid_amount":"286.88","room_type_id":"318","product_id":"1289","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99424","customer_id":"99424","source_of_creation":"PMS","reservation_created_date":"2020-03-11 04:19:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Reservation created for complete past date","deltaChange":"255.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":"3071852","reservation_id":"92243","confirmation_number":"SJ12627545003","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","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":"1294","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-02-20 13:30:47","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3074576","reservation_id":"92036","confirmation_number":"SJ12658054867","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","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":"1310","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-02-16 14:11:03","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","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":"3074579","reservation_id":"90736","confirmation_number":"SJ12615618060","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","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-28 01:28:50","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":"3079164","reservation_id":"92339","confirmation_number":"SJ12616286397","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","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-22 01:44:46","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":"3079206","reservation_id":"92242","confirmation_number":"SJ12663358357","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","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":"1312","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-02-20 13:21:56","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":"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"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3065283","reservation_id":"91114","confirmation_number":"SJ12650269290","room_confirmation_number":"SJ12698903853","room_stay_from":"2020-03-09","room_stay_to":"2020-03-12","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":"97241","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-02 21:55:41","reservation_modified_date_time":"2020-02-02 21:55:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97241","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068845","reservation_id":"91783","confirmation_number":"SJ12625269519","room_confirmation_number":"SJ12669745120","room_stay_from":"2020-03-09","room_stay_to":"2020-03-12","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"97929","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-11 14:57:10","reservation_modified_date_time":"2020-02-11 14:57:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97929","canceled_nights_data":"","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3079387","reservation_id":"93112","confirmation_number":"SJ12668902163","room_confirmation_number":"SJ12680313702","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"99307","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-08 19:06:48","reservation_modified_date_time":"2020-03-08 19:06:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99307","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3079474","reservation_id":"91594","confirmation_number":"SJ12650767264","room_confirmation_number":"SJ12622898774","room_stay_from":"2020-03-08","room_stay_to":"2020-03-12","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"99318","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-11 02:47:45","reservation_modified_date_time":"2020-03-08 23:32:33","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99318","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3080484","reservation_id":"92998","confirmation_number":"SJ12692394714","room_confirmation_number":"SJ12612721616","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"99168","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-11 10:58:00","reservation_modified_date_time":"2020-03-11 10:58:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99168","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3080648","reservation_id":"93112","confirmation_number":"SJ12672280338","room_confirmation_number":"SJ12694547892","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"99307","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-11 10:57:24","reservation_modified_date_time":"2020-03-11 22:02:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99307","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":"3065284","reservation_id":"91114","confirmation_number":"SJ12679228487","room_confirmation_number":"SJ12698903853","room_stay_from":"2020-03-09","room_stay_to":"2020-03-12","room_stay_status":"Active","nightly_price":"28.12,28.12,28.12","nightly_discount":"0.00,0.00,0.00","subtotal":"84.36","grand_total":"94.90","paid_amount":"94.90","product_id":"1776","service_quantity":"1","customer_traveller_id":"97241","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-02-02 11:42:10","reservation_modified_date_time":"2020-02-02 21:55:42","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97241","canceled_nights_data":"","currentDayPrice":"28.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068846","reservation_id":"91783","confirmation_number":"SJ12634153564","room_confirmation_number":"SJ12669745120","room_stay_from":"2020-03-09","room_stay_to":"2020-03-12","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":"97929","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 14:57:10","reservation_modified_date_time":"2020-02-11 14:57:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97929","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":"3069268","reservation_id":"91871","confirmation_number":"SJ12618526451","room_confirmation_number":"SJ12621718072","room_stay_from":"2020-03-09","room_stay_to":"2020-03-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98017","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 19:23:07","reservation_modified_date_time":"2020-02-12 19:30:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98017","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3077661","reservation_id":"90353","confirmation_number":"SJ12682843269","room_confirmation_number":"SJ12616569267","room_stay_from":"2020-03-10","room_stay_to":"2020-03-12","room_stay_status":"Active","nightly_price":"28.12,28.12","nightly_discount":"0.00,0.00","subtotal":"56.24","grand_total":"63.27","paid_amount":"63.27","product_id":"1776","service_quantity":"1","customer_traveller_id":"96399","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-01-22 16:34:10","reservation_modified_date_time":"2020-03-04 14:26:33","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96399","canceled_nights_data":"","currentDayPrice":"28.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3078598","reservation_id":"92707","confirmation_number":"SJ12630565147","room_confirmation_number":"SJ12662042316","room_stay_from":"2020-03-05","room_stay_to":"2020-03-12","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":"98852","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-28 04:13:14","reservation_modified_date_time":"2020-03-06 17:12:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98852","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":"3079142","reservation_id":"91722","confirmation_number":"SJ12617501862","room_confirmation_number":"SJ12646341870","room_stay_from":"2020-03-07","room_stay_to":"2020-03-12","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":"97861","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-10 15:59:09","reservation_modified_date_time":"2020-03-07 21:26:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97861","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":"3079155","reservation_id":"92080","confirmation_number":"SJ12664936954","room_confirmation_number":"SJ12684702523","room_stay_from":"2020-03-09","room_stay_to":"2020-03-12","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":"98256","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-17 04:04:10","reservation_modified_date_time":"2020-03-07 21:43:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98256","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":"3079388","reservation_id":"93112","confirmation_number":"SJ12642727791","room_confirmation_number":"SJ12680313702","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","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":"99307","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-08 18:05:13","reservation_modified_date_time":"2020-03-08 19:06:49","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99307","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":"3079475","reservation_id":"91594","confirmation_number":"SJ12638414466","room_confirmation_number":"SJ12622898774","room_stay_from":"2020-03-08","room_stay_to":"2020-03-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"99318","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 19:13:09","reservation_modified_date_time":"2020-03-08 23:32:33","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99318","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3079478","reservation_id":"93121","confirmation_number":"SJ12661665873","room_confirmation_number":"SJ12684632168","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","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":"99319","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-08 23:44:07","reservation_modified_date_time":"2020-03-08 23:44:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99319","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":"3080085","reservation_id":"93125","confirmation_number":"SJ12666355004","room_confirmation_number":"SJ12620588331","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","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":"99324","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-09 00:53:06","reservation_modified_date_time":"2020-03-10 14:35:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99324","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":"3080251","reservation_id":"92684","confirmation_number":"SJ12636051153","room_confirmation_number":"SJ12627162811","room_stay_from":"2020-03-10","room_stay_to":"2020-03-12","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":"99404","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-27 20:33:10","reservation_modified_date_time":"2020-03-10 20:12:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99404","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":"3080413","reservation_id":"93212","confirmation_number":"SJ12615154939","room_confirmation_number":"SJ12692101685","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","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":"99419","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-10 23:30:10","reservation_modified_date_time":"2020-03-10 23:30:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99419","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":"3080444","reservation_id":"93156","confirmation_number":"SJ12689939364","room_confirmation_number":"SJ12639529908","room_stay_from":"2020-03-10","room_stay_to":"2020-03-12","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":"99354","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-09 19:44:08","reservation_modified_date_time":"2020-03-11 00:52:03","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99354","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":"3080485","reservation_id":"92998","confirmation_number":"SJ12690503748","room_confirmation_number":"SJ12612721616","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","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":"99168","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-05 22:23:11","reservation_modified_date_time":"2020-03-11 10:58:01","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99168","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":"3080649","reservation_id":"93112","confirmation_number":"SJ12645531104","room_confirmation_number":"SJ12694547892","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","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":"99445","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-08 18:05:09","reservation_modified_date_time":"2020-03-11 22:02:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99307","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":"3080711","reservation_id":"93250","confirmation_number":"SJ12658852059","room_confirmation_number":"SJ12649710165","room_stay_from":"2020-03-11","room_stay_to":"2020-03-12","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":"99457","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-12 02:40:02","reservation_modified_date_time":"2020-03-12 03:05:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99456","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":"3064651","reservation_id":"90985","confirmation_number":"SJ12659876042","room_confirmation_number":"SJ12642768191","room_stay_from":"2020-03-09","room_stay_to":"2020-03-13","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":"97080","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 02:13:09","reservation_modified_date_time":"2020-02-01 22:45:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97080","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":"3068695","reservation_id":"91613","confirmation_number":"SJ12616786412","room_confirmation_number":"SJ12673339256","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"97750","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 22:08:10","reservation_modified_date_time":"2020-02-11 02:40:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97750","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3068698","reservation_id":"89937","confirmation_number":"SJ12663495479","room_confirmation_number":"SJ12669588844","room_stay_from":"2020-03-10","room_stay_to":"2020-03-13","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":"95957","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-14 04:38:45","reservation_modified_date_time":"2020-02-11 02:40:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95957","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":"3068700","reservation_id":"90967","confirmation_number":"SJ12631861224","room_confirmation_number":"SJ12663191837","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","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":"97061","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 20:53:09","reservation_modified_date_time":"2020-02-11 02:41:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97061","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":"3068707","reservation_id":"90356","confirmation_number":"SJ12646082236","room_confirmation_number":"SJ12691408531","room_stay_from":"2020-03-10","room_stay_to":"2020-03-13","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":"96401","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-22 17:07:39","reservation_modified_date_time":"2020-02-11 02:42:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96401","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":"3068716","reservation_id":"90259","confirmation_number":"SJ12699908828","room_confirmation_number":"SJ12638828272","room_stay_from":"2020-03-08","room_stay_to":"2020-03-13","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":"96309","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-20 17:49:39","reservation_modified_date_time":"2020-02-11 02:44:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96308","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":"3069054","reservation_id":"91828","confirmation_number":"SJ12617383324","room_confirmation_number":"SJ12649786604","room_stay_from":"2020-03-09","room_stay_to":"2020-03-13","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":"97979","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 01:43:08","reservation_modified_date_time":"2020-02-12 01:43:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97979","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":"3072469","reservation_id":"92338","confirmation_number":"SJ12624094541","room_confirmation_number":"SJ12660607340","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","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":"98521","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-22 00:28:11","reservation_modified_date_time":"2020-02-22 00:28:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98521","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":"3075767","reservation_id":"92465","confirmation_number":"SJ12617853532","room_confirmation_number":"SJ12698770200","room_stay_from":"2020-03-10","room_stay_to":"2020-03-13","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":"98631","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-24 01:46:10","reservation_modified_date_time":"2020-02-28 18:45:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98631","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":"3076600","reservation_id":"91552","confirmation_number":"SJ12661372222","room_confirmation_number":"SJ12633336898","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","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":"97687","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 03:48:09","reservation_modified_date_time":"2020-03-01 12:06:39","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97687","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":"3077516","reservation_id":"91768","confirmation_number":"SJ12695998795","room_confirmation_number":"SJ12637621036","room_stay_from":"2020-03-09","room_stay_to":"2020-03-13","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":"97914","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 02:54:10","reservation_modified_date_time":"2020-03-03 20:54:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97914","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":"3079064","reservation_id":"92612","confirmation_number":"SJ12616792571","room_confirmation_number":"SJ12671412672","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","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":"98765","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-26 19:03:08","reservation_modified_date_time":"2020-03-07 17:45:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98765","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":"3079292","reservation_id":"92885","confirmation_number":"SJ12668365958","room_confirmation_number":"SJ12621634969","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","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":"99297","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-02 23:24:10","reservation_modified_date_time":"2020-03-08 15:19:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99297","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":"3079988","reservation_id":"93177","confirmation_number":"SJ12687657331","room_confirmation_number":"SJ12636909706","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","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":"99373","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-10 03:26:09","reservation_modified_date_time":"2020-03-10 03:26:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99373","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":"3080294","reservation_id":"92158","confirmation_number":"SJ12632631433","room_confirmation_number":"SJ12627601394","room_stay_from":"2020-03-10","room_stay_to":"2020-03-13","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":"99408","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-18 21:14:13","reservation_modified_date_time":"2020-03-10 20:33:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99408","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":"3080403","reservation_id":"93211","confirmation_number":"SJ12674506519","room_confirmation_number":"SJ12659589273","room_stay_from":"2020-03-11","room_stay_to":"2020-03-13","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":"99418","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-10 23:24:08","reservation_modified_date_time":"2020-03-10 23:24:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99418","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":"3064653","reservation_id":"90796","confirmation_number":"SJ12629057148","room_confirmation_number":"SJ12661991029","room_stay_from":"2020-03-10","room_stay_to":"2020-03-14","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":"96879","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 18:48:10","reservation_modified_date_time":"2020-02-01 22:46:04","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96879","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":"3071853","reservation_id":"92243","confirmation_number":"SJ12636744948","room_confirmation_number":"SJ12627545003","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","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":"98428","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-20 13:30:47","reservation_modified_date_time":"2020-02-20 13:30:47","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":"3072248","reservation_id":"92298","confirmation_number":"SJ12643173214","room_confirmation_number":"SJ12643918455","room_stay_from":"2020-03-11","room_stay_to":"2020-03-14","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":"98481","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-21 15:23:11","reservation_modified_date_time":"2020-02-21 15:23:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98481","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":"3074578","reservation_id":"92036","confirmation_number":"SJ12640323709","room_confirmation_number":"SJ12658054867","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","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":"98206","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-16 14:11:03","reservation_modified_date_time":"2020-02-26 14:09:17","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":"3074580","reservation_id":"90736","confirmation_number":"SJ12613075067","room_confirmation_number":"SJ12615618060","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","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":"96817","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 01:28:50","reservation_modified_date_time":"2020-02-26 14:09:38","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":"3076607","reservation_id":"92806","confirmation_number":"SJ12632661943","room_confirmation_number":"SJ12685779682","room_stay_from":"2020-03-11","room_stay_to":"2020-03-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98957","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-01 05:19:08","reservation_modified_date_time":"2020-03-01 12:06:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98957","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":"3079165","reservation_id":"92339","confirmation_number":"SJ12681528805","room_confirmation_number":"SJ12616286397","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","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":"98522","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-22 01:44:46","reservation_modified_date_time":"2020-03-07 21:46:11","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":"3079208","reservation_id":"92242","confirmation_number":"SJ12685662171","room_confirmation_number":"SJ12663358357","room_stay_from":"2020-03-07","room_stay_to":"2020-03-14","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":"98427","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-20 13:21:56","reservation_modified_date_time":"2020-03-08 00:30:35","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":"3080105","reservation_id":"93185","confirmation_number":"SJ12676753350","room_confirmation_number":"SJ12658440906","room_stay_from":"2020-03-10","room_stay_to":"2020-03-14","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":"99385","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-10 14:57:08","reservation_modified_date_time":"2020-03-10 14:57:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99385","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":"3080699","reservation_id":"93243","confirmation_number":"SJ12654774156","room_confirmation_number":"SJ12638991507","room_stay_from":"2020-03-11","room_stay_to":"2020-03-14","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":"99449","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-11 23:23:08","reservation_modified_date_time":"2020-03-12 01:20:29","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99449","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":"3075019","reservation_id":"92088","confirmation_number":"SJ12690777687","room_confirmation_number":"SJ12693733794","room_stay_from":"2020-03-11","room_stay_to":"2020-03-15","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"98263","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-17 14:33:32","reservation_modified_date_time":"2020-02-27 13:57:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98263","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3067945","reservation_id":"91660","confirmation_number":"SJ12659500685","room_confirmation_number":"SJ12626085803","room_stay_from":"2020-03-11","room_stay_to":"2020-03-16","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"97799","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 20:03:12","reservation_modified_date_time":"2020-02-09 20:03:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97799","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3067097","reservation_id":"91486","confirmation_number":"SJ12616999370","room_confirmation_number":"SJ12611429751","room_stay_from":"2020-03-10","room_stay_to":"2020-03-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"97615","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-07 14:38:09","reservation_modified_date_time":"2020-02-07 23:38:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97615","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3077664","reservation_id":"92940","confirmation_number":"SJ12668825240","room_confirmation_number":"SJ12661649081","room_stay_from":"2020-03-11","room_stay_to":"2020-03-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0,0,0,0,0","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"99105","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-04 14:19:08","reservation_modified_date_time":"2020-03-04 14:27:04","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99105","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3079554","reservation_id":"91487","confirmation_number":"SJ12635852465","room_confirmation_number":"SJ12643636295","room_stay_from":"2020-03-10","room_stay_to":"2020-03-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"97616","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-07 14:38:12","reservation_modified_date_time":"2020-03-09 11:26:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97616","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3080016","reservation_id":"91860","confirmation_number":"SJ12622623975","room_confirmation_number":"SJ12679190526","room_stay_from":"2020-03-11","room_stay_to":"2020-03-18","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"98008","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 16:44:13","reservation_modified_date_time":"2020-03-10 13:10:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98008","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3080461","reservation_id":"93218","confirmation_number":"SJ12657496979","room_confirmation_number":"SJ12657963842","room_stay_from":"2020-03-10","room_stay_to":"2020-03-11","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":"99424","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-11 04:19:14","reservation_modified_date_time":"2020-03-11 04:19:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99424","canceled_nights_data":"","changedComment":"Reservation created for complete past date","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"}]},{"room_stay_id":"3080491","reservation_id":"92623","confirmation_number":"SJ12619233729","room_confirmation_number":"SJ12690384005","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98778","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-26 22:45:07","reservation_modified_date_time":"2020-03-11 12:53:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98778","canceled_nights_data":"","changedComment":"both dates 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":"3080581","reservation_id":"90935","confirmation_number":"SJ12673387957","room_confirmation_number":"SJ12674648229","room_stay_from":"2020-03-26","room_stay_to":"2020-03-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"97031","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 14:42:11","reservation_modified_date_time":"2020-03-11 17:56:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97031","canceled_nights_data":"","changedComment":"both dates 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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3080587","reservation_id":"93233","confirmation_number":"SJ12636208510","room_confirmation_number":"SJ12617144204","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"29.99","grand_total":"32.24","paid_amount":"32.24","product_id":null,"service_quantity":"1","product_name":"Beach Buggy package","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-11 18:43:33","reservation_modified_date_time":"2020-03-11 18:43:33","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":"29.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3080588","reservation_id":"93233","confirmation_number":"SJ12619863054","room_confirmation_number":"SJ12617144204","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.86","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"2","product_name":"Koozie","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-11 18:43:33","reservation_modified_date_time":"2020-03-11 18:43:33","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":"3.72","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":"3080629","reservation_id":"93239","confirmation_number":"SJ12685718755","room_confirmation_number":"SJ12679978790","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-11 19:56:35","reservation_modified_date_time":"2020-03-11 19:56:35","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3080709","reservation_id":"93251","confirmation_number":"SJ12657533627","room_confirmation_number":"SJ12652631731","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-12 02:50:31","reservation_modified_date_time":"2020-03-12 02:50:31","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}