{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-03-09","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":12,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1942,1262,1943","block_room_bookings":[{"confirmation_number":"SJ12622180244","room_stay_from":"2020-02-29","room_stay_to":"2020-03-13","bundle_room":"0"},{"confirmation_number":"SJ12657124384","room_stay_from":"2020-03-07","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":"1304,1305,1262,1263,1302,1303,1267,1268,1271,1272,1269,1270,1260,1261,1311,1312,1307,1308,1309,1310","bundle_block_bookings":[{"confirmation_number":"SJB12693669123","room_stay_from":"2020-03-08","room_stay_to":"2020-03-10","bundle_room":"1"},{"confirmation_number":"SJB12635721451","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","bundle_room":"1"},{"confirmation_number":"SJB12628502692","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","bundle_room":"1"},{"confirmation_number":"SJB12680213090","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","bundle_room":"1"},{"confirmation_number":"SJB12637902905","room_stay_from":"2020-03-08","room_stay_to":"2020-03-11","bundle_room":"1"},{"confirmation_number":"SJB12691027852","room_stay_from":"2020-03-09","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":"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"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3069764","reservation_id":"91953","confirmation_number":"SJ12696092474","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.50","nightly_discount":"0","subtotal":"211.50","grand_total":"237.94","paid_amount":"237.94","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-3826861318","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":"98098","customer_id":"98098","source_of_creation":"Booking.com","reservation_created_date":"2020-02-14 01:04:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"43.13","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":"3061846","reservation_id":"90612","confirmation_number":"SJ12615444259","room_stay_from":"2020-03-09","room_stay_to":"2020-03-11","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":"413","product_id":"1264","siteminder_id":"BDC-2849187419","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":"96688","customer_id":"96688","source_of_creation":"Booking.com","reservation_created_date":"2020-01-26 14:58:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","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":"3077502","reservation_id":"92920","confirmation_number":"SJ12634226520","room_stay_from":"2020-03-09","room_stay_to":"2020-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"267.30,267.30","nightly_discount":"0,0","subtotal":"534.60","grand_total":"601.43","paid_amount":"601.43","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-2259038170","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":"99079","customer_id":"99079","source_of_creation":"Booking.com","reservation_created_date":"2020-03-03 20:09:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"105.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"267.30","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":"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":"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":"3079548","reservation_id":"92426","confirmation_number":"SJ12681234262","room_stay_from":"2020-03-24","room_stay_to":"2020-03-26","room_stay_status":"Active","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"185,185","nightly_discount":"0,0","subtotal":"370.00","grand_total":"416.25","paid_amount":"208.13","room_type_id":"413","product_id":"1272","siteminder_id":"BDC-3312881399","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98601","customer_id":"98601","source_of_creation":"Booking.com","reservation_created_date":"2020-02-23 17:21:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"42.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3062584","reservation_id":"90749","confirmation_number":"SJ12668668517","room_stay_from":"2020-03-08","room_stay_to":"2020-03-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00","nightly_discount":"0,0","subtotal":"358.00","grand_total":"402.75","paid_amount":"402.75","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1631004354","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":"96830","customer_id":"96830","source_of_creation":"Expedia","reservation_created_date":"2020-01-28 03:13:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3064654","reservation_id":"90917","confirmation_number":"SJ12666074084","room_stay_from":"2020-03-07","room_stay_to":"2020-03-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,179.00,179.00","nightly_discount":"0,0,0","subtotal":"573.00","grand_total":"644.63","paid_amount":"644.63","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1632213432","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":"97012","customer_id":"99259","source_of_creation":"Expedia","reservation_created_date":"2020-01-30 01:33:11","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":"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":"3064771","reservation_id":"91117","confirmation_number":"SJ12656377285","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20","nightly_discount":"0","subtotal":"143.20","grand_total":"161.10","paid_amount":"161.10","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1634050720","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":"97244","customer_id":"97244","source_of_creation":"Expedia","reservation_created_date":"2020-02-02 12:13:05","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":"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":"3068645","reservation_id":"91762","confirmation_number":"SJ12653349893","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20","nightly_discount":"0","subtotal":"143.20","grand_total":"161.10","paid_amount":"161.10","room_type_id":"413","product_id":"1270","siteminder_id":"EXP-1639289002","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":"97905","customer_id":"97905","source_of_creation":"Expedia","reservation_created_date":"2020-02-11 01:09: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":"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":"3079867","reservation_id":"90565","confirmation_number":"SJ12627979451","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20","nightly_discount":"0","subtotal":"143.20","grand_total":"161.10","paid_amount":"161.10","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1629595880","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":"96628","customer_id":"96628","source_of_creation":"Expedia","reservation_created_date":"2020-01-25 17:13:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3079924","reservation_id":"93169","confirmation_number":"SJ12634116516","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"175.20","nightly_discount":"0","subtotal":"175.20","grand_total":"197.10","paid_amount":"197.10","room_type_id":"319","product_id":"1303","siteminder_id":"EXP-1655727309","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":"99365","customer_id":"99365","source_of_creation":"Expedia","reservation_created_date":"2020-03-09 23:09:09","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":"175.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":"3075022","reservation_id":"91412","confirmation_number":"SJ12650865305","room_stay_from":"2020-03-08","room_stay_to":"2020-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.00,188.00,188.00","nightly_discount":"0,0,0","subtotal":"564.00","grand_total":"634.50","paid_amount":"634.50","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1636624997","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":"97539","customer_id":"97539","source_of_creation":"Expedia","reservation_created_date":"2020-02-06 15:30:09","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":"188.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3079375","reservation_id":"91052","confirmation_number":"SJ12674498282","room_stay_from":"2020-03-08","room_stay_to":"2020-03-11","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":"1271","siteminder_id":"EXP-1633688588","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":"99309","customer_id":"99309","source_of_creation":"Expedia","reservation_created_date":"2020-02-01 16:03:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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":"3079661","reservation_id":"91726","confirmation_number":"SJ12656027787","room_stay_from":"2020-03-08","room_stay_to":"2020-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,169.20","nightly_discount":"0,0,0","subtotal":"507.60","grand_total":"571.05","paid_amount":"571.05","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1638990390","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":"97867","customer_id":"97867","source_of_creation":"Expedia","reservation_created_date":"2020-02-10 16:46:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"169.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"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":"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":"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"}]}],"exp_non_taxable":[{"room_stay_id":"3079656","reservation_id":"91106","confirmation_number":"SJ12635543299","room_stay_from":"2020-03-10","room_stay_to":"2020-03-12","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.50,211.50","nightly_discount":"0,0","subtotal":"423.00","grand_total":"475.88","paid_amount":"237.94","room_type_id":"319","product_id":"1756","siteminder_id":"EXP-1633985359","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":"97232","customer_id":"97232","source_of_creation":"Expedia","reservation_created_date":"2020-02-02 04:03:10","service_canceled_date_time":"2020-03-09 20:49:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"237.94","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"htn_taxable":[{"room_stay_id":"3079394","reservation_id":"93113","confirmation_number":"SJ12641956432","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.98","nightly_discount":"0.00","subtotal":"154.98","grand_total":"174.35","paid_amount":"174.35","room_type_id":"319","product_id":"1276","siteminder_id":"HTN-122449398-CLWCT4","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":"99308","customer_id":"99308","source_of_creation":"HotelTonight","reservation_created_date":"2020-03-08 18:30:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"154.98","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3079624","reservation_id":"93135","confirmation_number":"SJ12613049651","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.98","nightly_discount":"0","subtotal":"154.98","grand_total":"174.35","paid_amount":"174.35","room_type_id":"319","product_id":"1277","siteminder_id":"HTN-122543873-QPKXRE","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":"99333","customer_id":"99333","source_of_creation":"HotelTonight","reservation_created_date":"2020-03-09 14:44: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":"154.98","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3079318","reservation_id":"93107","confirmation_number":"SJ12669084499","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00","nightly_discount":"0.00","subtotal":"210.00","grand_total":"236.25","paid_amount":"236.25","room_type_id":"413","product_id":"1267","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":"99303","customer_id":"99303","source_of_creation":"FE","reservation_created_date":"2020-03-08 16:41:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"210.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":"3079919","reservation_id":"91156","confirmation_number":"SJ12625396552","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","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":"319","product_id":"1293","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97280","customer_id":"97280","source_of_creation":"FE","reservation_created_date":"2020-02-02 19:54:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"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":"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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3079761","reservation_id":"93134","confirmation_number":"SJ12640776488","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","room_stay_status":"Checked-In","room_stay_guest_count":"4","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":"319","product_id":"1302","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98631","customer_id":"98631","source_of_creation":"PMS","reservation_created_date":"2020-03-09 14:13:33","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3079832","reservation_id":"93153","confirmation_number":"SJ12668852569","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00","nightly_discount":"0.00","subtotal":"210.00","grand_total":"236.25","paid_amount":"236.25","room_type_id":"413","product_id":"1261","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99350","customer_id":"99350","source_of_creation":"PMS","reservation_created_date":"2020-03-09 19:02:36","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"210.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":"3079549","reservation_id":"92190","confirmation_number":"SJ12648853807","room_stay_from":"2020-03-09","room_stay_to":"2020-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00","nightly_discount":"0.00,0.00","subtotal":"510.00","grand_total":"573.75","paid_amount":"573.75","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98373","customer_id":"98373","source_of_creation":"PMS","reservation_created_date":"2020-02-19 14:20:02","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":"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"}]}],"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.71","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"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.71","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[{"room_stay_id":"3079255","reservation_id":"90750","confirmation_number":"SJ12640549084","room_stay_from":"2020-03-08","room_stay_to":"2020-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"430.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"430.00","grand_total":"483.75","paid_amount":"84.38","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2020-01-28 03:41:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3079763","reservation_id":"93134","confirmation_number":"SJ12677385061","room_confirmation_number":"SJ12640776488","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","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":"98631","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-09 17:19:37","reservation_modified_date_time":"2020-03-09 17:19:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98631","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":"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":"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.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3079546","reservation_id":"92426","confirmation_number":"SJ12646363922","room_confirmation_number":"SJ12681234262","room_stay_from":"2020-03-24","room_stay_to":"2020-03-26","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"98601","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-09 10:24:12","reservation_modified_date_time":"2020-03-09 10:24:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98601","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3079183","reservation_id":"91299","confirmation_number":"SJ12654136840","room_confirmation_number":"SJ12621713568","room_stay_from":"2020-03-07","room_stay_to":"2020-03-09","room_stay_status":"Canceled","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1777","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-04 22:28:56","reservation_modified_date_time":"2020-03-07 22:56:53","customer_id":"99277","parentCustTravId":"99277","customer_traveller_id":"99277","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-03-09 13:40:48","canceled_nights_data":"","product_attribute_values":"extra_person#&#25","deltaChange":-50,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3062585","reservation_id":"90749","confirmation_number":"SJ12654222904","room_confirmation_number":"SJ12668668517","room_stay_from":"2020-03-08","room_stay_to":"2020-03-10","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":"96830","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 03:13:11","reservation_modified_date_time":"2020-01-28 03:13:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96830","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":"3064655","reservation_id":"90917","confirmation_number":"SJ12637120326","room_confirmation_number":"SJ12666074084","room_stay_from":"2020-03-07","room_stay_to":"2020-03-10","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":"97012","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 01:33:11","reservation_modified_date_time":"2020-02-01 22:47:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99259","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":"3064772","reservation_id":"91117","confirmation_number":"SJ12672364252","room_confirmation_number":"SJ12656377285","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","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":"97244","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 12:13:05","reservation_modified_date_time":"2020-02-02 12:13:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97244","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":"3068646","reservation_id":"91762","confirmation_number":"SJ12641765160","room_confirmation_number":"SJ12653349893","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","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":"97905","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 01:09:08","reservation_modified_date_time":"2020-02-11 01:09:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97905","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":"3069765","reservation_id":"91953","confirmation_number":"SJ12676742524","room_confirmation_number":"SJ12696092474","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","room_stay_status":"Active","nightly_price":"28.12","nightly_discount":"0.00","subtotal":"28.12","grand_total":"31.63","paid_amount":"31.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"98098","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-02-14 01:04:08","reservation_modified_date_time":"2020-02-14 01:04:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98098","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":"3079319","reservation_id":"93107","confirmation_number":"SJ12638532352","room_confirmation_number":"SJ12669084499","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.12","paid_amount":"28.12","product_id":"1776","service_quantity":"1","customer_traveller_id":"99303","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-08 16:41:11","reservation_modified_date_time":"2020-03-08 16:41:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99303","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":"3079395","reservation_id":"93113","confirmation_number":"SJ12652566711","room_confirmation_number":"SJ12641956432","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","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":"99308","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-08 18:30:08","reservation_modified_date_time":"2020-03-08 19:21:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99308","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":"3079625","reservation_id":"93135","confirmation_number":"SJ12620904001","room_confirmation_number":"SJ12613049651","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","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":"99333","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-09 14:44:09","reservation_modified_date_time":"2020-03-09 14:44:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99333","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":"3079764","reservation_id":"93134","confirmation_number":"SJ12679716553","room_confirmation_number":"SJ12640776488","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","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":"98631","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-09 14:13:33","reservation_modified_date_time":"2020-03-09 17:19:37","collect_which":"","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":"3079833","reservation_id":"93153","confirmation_number":"SJ12641139248","room_confirmation_number":"SJ12668852569","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","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":"99350","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-09 19:02:36","reservation_modified_date_time":"2020-03-09 19:02:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99350","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":"3079868","reservation_id":"90565","confirmation_number":"SJ12659691863","room_confirmation_number":"SJ12627979451","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","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":"96628","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 17:13:11","reservation_modified_date_time":"2020-03-09 20:16:32","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96628","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":"3079921","reservation_id":"91156","confirmation_number":"SJ12671553723","room_confirmation_number":"SJ12625396552","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.12","product_id":"1776","service_quantity":"1","customer_traveller_id":"97280","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 19:54:52","reservation_modified_date_time":"2020-03-09 23:11:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97280","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":"3079925","reservation_id":"93169","confirmation_number":"SJ12681810220","room_confirmation_number":"SJ12634116516","room_stay_from":"2020-03-09","room_stay_to":"2020-03-10","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":"99365","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-09 23:09:09","reservation_modified_date_time":"2020-03-09 23:15:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99365","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":"3061847","reservation_id":"90612","confirmation_number":"SJ12683092523","room_confirmation_number":"SJ12615444259","room_stay_from":"2020-03-09","room_stay_to":"2020-03-11","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":"96688","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-01-26 14:58:07","reservation_modified_date_time":"2020-01-26 14:58:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96688","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":"3075023","reservation_id":"91412","confirmation_number":"SJ12687107575","room_confirmation_number":"SJ12650865305","room_stay_from":"2020-03-08","room_stay_to":"2020-03-11","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":"97539","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 15:30:09","reservation_modified_date_time":"2020-02-27 13:58:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97539","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":"3077503","reservation_id":"92920","confirmation_number":"SJ12672046730","room_confirmation_number":"SJ12634226520","room_stay_from":"2020-03-09","room_stay_to":"2020-03-11","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":"99079","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-03 20:09:11","reservation_modified_date_time":"2020-03-03 20:09:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99079","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":"3079256","reservation_id":"90750","confirmation_number":"SJ12626731884","room_confirmation_number":"SJ12640549084","room_stay_from":"2020-03-08","room_stay_to":"2020-03-11","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"96831","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 03:41:32","reservation_modified_date_time":"2020-03-08 12:18:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3079374","reservation_id":"91052","confirmation_number":"SJ12652673104","room_confirmation_number":"SJ12674498282","room_stay_from":"2020-03-08","room_stay_to":"2020-03-11","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":"99309","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 16:03:11","reservation_modified_date_time":"2020-03-08 18:47:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99309","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":"3079550","reservation_id":"92190","confirmation_number":"SJ12617101267","room_confirmation_number":"SJ12648853807","room_stay_from":"2020-03-09","room_stay_to":"2020-03-11","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"98373","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-19 14:20:02","reservation_modified_date_time":"2020-03-09 11:25:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98373","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3079663","reservation_id":"91726","confirmation_number":"SJ12636013650","room_confirmation_number":"SJ12656027787","room_stay_from":"2020-03-08","room_stay_to":"2020-03-11","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":"97867","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-10 16:46:09","reservation_modified_date_time":"2020-03-09 15:06:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97867","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"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":"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":"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.00","productIsTaxExempt":false,"taxes":[{"tax_id":"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":"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":"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":"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":"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":"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":"3079547","reservation_id":"92426","confirmation_number":"SJ12666268499","room_confirmation_number":"SJ12681234262","room_stay_from":"2020-03-24","room_stay_to":"2020-03-26","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"98601","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-23 17:21:09","reservation_modified_date_time":"2020-03-09 10:24:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98601","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3079856","reservation_id":"93158","confirmation_number":"SJ12628915113","room_confirmation_number":"SJ12676802603","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"2.50","paid_amount":"2.50","product_id":null,"service_quantity":"1","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-09 20:04:56","reservation_modified_date_time":"2020-03-09 20:04:56","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.33","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3079971","reservation_id":"93175","confirmation_number":"SJ12615691431","room_confirmation_number":"SJ12676716229","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"40.00","grand_total":"43.00","paid_amount":"43.00","product_id":null,"service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-10 02:46:31","reservation_modified_date_time":"2020-03-10 02:46:31","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}