{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-02-26","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,1918,1920,1942,1943,1296,1294,1297,1315,1316,1866,1919,1921,1922,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1923","departureCount":18,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1296,1262,1943,1918,1919,1920,1922,1923","block_room_bookings":[{"confirmation_number":"SJ12678494307","room_stay_from":"2020-02-26","room_stay_to":"2020-03-01","bundle_room":"0"},{"confirmation_number":"SJ12632788009","room_stay_from":"2019-12-20","room_stay_to":"2020-03-13","bundle_room":"0"},{"confirmation_number":"SJ12665142275","room_stay_from":"2020-01-14","room_stay_to":"2020-03-17","bundle_room":"0"},{"confirmation_number":"SJ12632903645","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12638549225","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12665324838","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12657221101","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12693730510","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"}],"bundle_block_count":"1271,1272,1267,1268,1260,1261,1311,1312,1262,1263,1304,1305,1309,1310,1307,1308,1269,1270,1302,1303,1291,1711","bundle_block_bookings":[{"confirmation_number":"SJB12674041028","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","bundle_room":"1"},{"confirmation_number":"SJB12644959897","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","bundle_room":"1"},{"confirmation_number":"SJB12685370791","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","bundle_room":"1"},{"confirmation_number":"SJB12639503887","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","bundle_room":"1"},{"confirmation_number":"SJB12660009195","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","bundle_room":"1"},{"confirmation_number":"SJB12662961437","room_stay_from":"2020-02-20","room_stay_to":"2020-02-27","bundle_room":"1"},{"confirmation_number":"SJB12642242009","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","bundle_room":"1"},{"confirmation_number":"SJB12688215679","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","bundle_room":"0"},{"confirmation_number":"SJB12626684999","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","bundle_room":"0"},{"confirmation_number":"SJB12611112708","room_stay_from":"2020-02-25","room_stay_to":"2020-02-28","bundle_room":"1"},{"confirmation_number":"SJB12650071652","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","bundle_room":"1"},{"confirmation_number":"SJB12655215942","room_stay_from":"2020-02-24","room_stay_to":"2020-02-29","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3061341","reservation_id":"90514","confirmation_number":"SJ12666477886","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"179.00","nightly_discount":"0","subtotal":"179.00","grand_total":"201.38","paid_amount":"201.38","room_type_id":"413","product_id":"1268","siteminder_id":"BDC-2288172236","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":"96569","customer_id":"96569","source_of_creation":"Booking.com","reservation_created_date":"2020-01-24 18:25:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"37.28","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"179.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3065633","reservation_id":"91149","confirmation_number":"SJ12645232951","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.50,211.50","nightly_discount":"0,0","subtotal":"423.00","grand_total":"475.88","paid_amount":"475.88","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-2148256809","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":"97275","customer_id":"97275","source_of_creation":"Booking.com","reservation_created_date":"2020-02-02 19:00:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"86.26","resv_is_no_show":"0","is_bundle":"0","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":"3067292","reservation_id":"91224","confirmation_number":"SJ12633880275","room_stay_from":"2020-02-24","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,179.00","nightly_discount":"0,0,0","subtotal":"537.00","grand_total":"604.13","paid_amount":"604.13","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-3520586922","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":"97346","customer_id":"97346","source_of_creation":"Booking.com","reservation_created_date":"2020-02-03 18:08:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"55.92","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"179.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3070819","reservation_id":"92108","confirmation_number":"SJ12689241912","room_stay_from":"2020-02-23","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00,255.00,255.00","nightly_discount":"0,0,0,0","subtotal":"1020.00","grand_total":"1147.50","paid_amount":"1147.50","room_type_id":"319","product_id":"1314","siteminder_id":"BDC-3591642960","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":"98284","customer_id":"98284","source_of_creation":"Booking.com","reservation_created_date":"2020-02-17 19:14:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"203.84","resv_is_no_show":"0","is_bundle":"0","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":"3072427","reservation_id":"92334","confirmation_number":"SJ12657021782","room_stay_from":"2020-02-24","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"227,227,227","nightly_discount":"0,0,0","subtotal":"681.00","grand_total":"766.13","paid_amount":"766.13","room_type_id":"319","product_id":"1756","siteminder_id":"BDC-2618524840","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":"98513","customer_id":"98513","source_of_creation":"Booking.com","reservation_created_date":"2020-02-21 23:03:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"149.58","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"227","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":"3074602","reservation_id":"91448","confirmation_number":"SJ12612480678","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.00","nightly_discount":"0","subtotal":"235.00","grand_total":"264.38","paid_amount":"264.38","room_type_id":"319","product_id":"1310","siteminder_id":"BDC-3208027691","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":"97577","customer_id":"97577","source_of_creation":"Booking.com","reservation_created_date":"2020-02-06 21:05:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"94.72","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"235.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":"3074621","reservation_id":"91448","confirmation_number":"SJ12630132220","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.00","nightly_discount":"0","subtotal":"235.00","grand_total":"264.38","paid_amount":"264.38","room_type_id":"319","product_id":"1309","siteminder_id":"BDC-3208027691","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":"97577","customer_id":"97577","source_of_creation":"Booking.com","reservation_created_date":"2020-02-06 21:05:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"94.72","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"235.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":"3074898","reservation_id":"90376","confirmation_number":"SJ12621345346","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"111.10","nightly_discount":"0.00","subtotal":"111.10","grand_total":"124.99","paid_amount":"124.99","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-2389885203","collect_which":"channel_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":"96424","customer_id":"96424","source_of_creation":"Booking.com","reservation_created_date":"2020-01-22 19:44:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"34.06","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"111.10","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":"3065564","reservation_id":"91212","confirmation_number":"SJ12629637160","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","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":"1273","siteminder_id":"BDC-2979620101","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":"97334","customer_id":"97334","source_of_creation":"Booking.com","reservation_created_date":"2020-02-03 16:17:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"68.12","resv_is_no_show":"0","is_bundle":"0","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":"3068894","reservation_id":"91794","confirmation_number":"SJ12659632352","room_stay_from":"2020-02-25","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"190.35,190.35,190.35","nightly_discount":"0,0,0","subtotal":"571.05","grand_total":"642.43","paid_amount":"642.43","room_type_id":"319","product_id":"1302","siteminder_id":"BDC-3895846080","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":"97938","customer_id":"97938","source_of_creation":"Booking.com","reservation_created_date":"2020-02-11 16:52:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"117.97","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"190.35","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":"3072582","reservation_id":"85934","confirmation_number":"SJ12658903556","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"250.29,250.29","nightly_discount":"0,0","subtotal":"500.58","grand_total":"563.15","paid_amount":"563.15","room_type_id":"319","product_id":"1303","siteminder_id":"BDC-3411189684","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":"92858","customer_id":"92858","source_of_creation":"Booking.com","reservation_created_date":"2019-10-19 16:20:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"90.10","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"250.29","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":"3074776","reservation_id":"90477","confirmation_number":"SJ12646338321","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129,129","nightly_discount":"0,0","subtotal":"258.00","grand_total":"290.25","paid_amount":"290.25","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-2493421636","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96534","customer_id":"96534","source_of_creation":"Booking.com","reservation_created_date":"2020-01-24 03:32:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"74.56","resv_is_no_show":"0","is_bundle":"0","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":"3074845","reservation_id":"91640","confirmation_number":"SJ12611624414","room_stay_from":"2020-02-26","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.50,211.50,269.10","nightly_discount":"0,0,0","subtotal":"692.10","grand_total":"778.62","paid_amount":"778.62","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-2708793755","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":"97777","customer_id":"97777","source_of_creation":"Booking.com","reservation_created_date":"2020-02-09 15:41:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"139.76","resv_is_no_show":"0","is_bundle":"0","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":"3074860","reservation_id":"91110","confirmation_number":"SJ12622685488","room_stay_from":"2020-02-26","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.50,211.50,234.00,234.00","nightly_discount":"0,0,0,0","subtotal":"891.00","grand_total":"1002.38","paid_amount":"1002.38","room_type_id":"319","product_id":"1293","siteminder_id":"BDC-2561526155","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":"97237","customer_id":"97237","source_of_creation":"Booking.com","reservation_created_date":"2020-02-02 07:59:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"180.63","resv_is_no_show":"0","is_bundle":"0","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3061675","reservation_id":"90582","confirmation_number":"SJ12683049186","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","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":"1272","siteminder_id":"EXP-1629671343","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":"96648","customer_id":"96648","source_of_creation":"Expedia","reservation_created_date":"2020-01-25 19:53:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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":"3069369","reservation_id":"91776","confirmation_number":"SJ12659275314","room_stay_from":"2020-02-20","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"237.60,280.00,280.00,237.60,237.60,237.60,237.60","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1748.00","grand_total":"1966.50","paid_amount":"1966.50","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1639312904","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":"97921","customer_id":"97921","source_of_creation":"Expedia","reservation_created_date":"2020-02-11 06:22:09","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","currentDayPrice":"237.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3071600","reservation_id":"91868","confirmation_number":"SJ12694225769","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.50,211.50","nightly_discount":"0,0","subtotal":"423.00","grand_total":"475.88","paid_amount":"475.88","room_type_id":"319","product_id":"1311","siteminder_id":"EXP-1640410454","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":"98013","customer_id":"98013","source_of_creation":"Expedia","reservation_created_date":"2020-02-12 18:43:08","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","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":"3072700","reservation_id":"92279","confirmation_number":"SJ12652168564","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"176.6,176.6","nightly_discount":"0,0","subtotal":"353.20","grand_total":"397.35","paid_amount":"397.35","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1645632312","collect_which":"channel_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":"98459","customer_id":"98459","source_of_creation":"Expedia","reservation_created_date":"2020-02-21 00:08:10","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","currentDayPrice":"176.6","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3072705","reservation_id":"91280","confirmation_number":"SJ12695883665","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"178,178","nightly_discount":"0,0","subtotal":"356.00","grand_total":"400.50","paid_amount":"400.50","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1635273051","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97403","customer_id":"97403","source_of_creation":"Expedia","reservation_created_date":"2020-02-04 13:24:07","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","currentDayPrice":"178","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":"3073683","reservation_id":"92497","confirmation_number":"SJ12651551429","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"204.00","nightly_discount":"0","subtotal":"204.00","grand_total":"229.50","paid_amount":"229.50","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1647813724","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":"98659","customer_id":"98659","source_of_creation":"Expedia","reservation_created_date":"2020-02-24 20:19:10","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","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":"3074683","reservation_id":"92549","confirmation_number":"SJ12649592513","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,183.60","nightly_discount":"0.00,0.00","subtotal":"367.20","grand_total":"413.10","paid_amount":"413.10","room_type_id":"319","product_id":"1711","siteminder_id":"EXP-1648401995","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":"98711","customer_id":"98711","source_of_creation":"Expedia","reservation_created_date":"2020-02-25 18:48:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"183.60","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":"3074820","reservation_id":"91852","confirmation_number":"SJ12682347974","room_stay_from":"2020-02-22","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.20,188.00,188.00,188.00,188.00","nightly_discount":"0,0,0,0,0","subtotal":"991.20","grand_total":"1115.10","paid_amount":"1115.11","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1640290741","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":"98003","customer_id":"98003","source_of_creation":"Expedia","reservation_created_date":"2020-02-12 15:23:06","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","changedComment":"To date changed","deltaChange":"0.00","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":"3074862","reservation_id":"91415","confirmation_number":"SJ12651171767","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","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":"1288","siteminder_id":"EXP-1636641546","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":"97541","customer_id":"97541","source_of_creation":"Expedia","reservation_created_date":"2020-02-06 15:58: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","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":"3063727","reservation_id":"90533","confirmation_number":"SJ12690044372","room_stay_from":"2020-02-25","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20,143.20","nightly_discount":"0,0,0","subtotal":"429.60","grand_total":"483.30","paid_amount":"483.30","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1629291287","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":"96595","customer_id":"96595","source_of_creation":"Expedia","reservation_created_date":"2020-01-25 00:58:06","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","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":"3067294","reservation_id":"91537","confirmation_number":"SJ12623040384","room_stay_from":"2020-02-24","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,179.00,179.00","nightly_discount":"0,0,0,0","subtotal":"716.00","grand_total":"805.50","paid_amount":"805.50","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1637568216","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":"97671","customer_id":"97671","source_of_creation":"Expedia","reservation_created_date":"2020-02-08 00:48:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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":"3069044","reservation_id":"91825","confirmation_number":"SJ12627606962","room_stay_from":"2020-02-24","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.00,188.00,188.00,188.00","nightly_discount":"0,0,0,0","subtotal":"752.00","grand_total":"846.00","paid_amount":"846.00","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1639950765","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":"97974","customer_id":"97974","source_of_creation":"Expedia","reservation_created_date":"2020-02-12 00:58:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"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":"3073153","reservation_id":"92326","confirmation_number":"SJ12687956027","room_stay_from":"2020-02-24","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,183.60,183.60,183.60","nightly_discount":"0,0,0,0","subtotal":"734.40","grand_total":"826.20","paid_amount":"826.20","room_type_id":"319","product_id":"1319","siteminder_id":"EXP-1646158326","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":"98499","customer_id":"98499","source_of_creation":"Expedia","reservation_created_date":"2020-02-21 20:18:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"183.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3073173","reservation_id":"91436","confirmation_number":"SJ12692430464","room_stay_from":"2020-02-22","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.28,169.20,169.20,169.20,169.20,169.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1061.28","grand_total":"1193.94","paid_amount":"1193.94","room_type_id":"319","product_id":"1313","siteminder_id":"EXP-1636756309","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":"98565","customer_id":"98565","source_of_creation":"Expedia","reservation_created_date":"2020-02-06 19:23:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"169.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3073661","reservation_id":"92356","confirmation_number":"SJ12662872804","room_stay_from":"2020-02-24","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,183.60,183.60,183.60","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"734.40","grand_total":"826.20","paid_amount":"826.20","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1646575609","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":"98536","customer_id":"98536","source_of_creation":"Expedia","reservation_created_date":"2020-02-22 16:08:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"183.60","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":"3073838","reservation_id":"92361","confirmation_number":"SJ12613626347","room_stay_from":"2020-02-24","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"227,227,227,227","nightly_discount":"0,0,0,0","subtotal":"908.00","grand_total":"1021.50","paid_amount":"1021.50","room_type_id":"319","product_id":"1301","siteminder_id":"EXP-1646607602","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98688","customer_id":"98688","source_of_creation":"Expedia","reservation_created_date":"2020-02-22 17:18:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"227","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":"3073934","reservation_id":"91174","confirmation_number":"SJ12666820195","room_stay_from":"2020-02-20","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"187.20,187.20,169.20,169.20,169.20,169.20,169.20,169.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1389.60","grand_total":"1563.30","paid_amount":"1563.30","room_type_id":"319","product_id":"1305","siteminder_id":"EXP-1634352386","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":"97299","customer_id":"97299","source_of_creation":"Expedia","reservation_created_date":"2020-02-02 22:33:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"169.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074774","reservation_id":"91209","confirmation_number":"SJ12685673935","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","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-1634713922","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":"97332","customer_id":"97332","source_of_creation":"Expedia","reservation_created_date":"2020-02-03 15:57:12","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","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":"3074789","reservation_id":"92592","confirmation_number":"SJ12638256065","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,183.60","nightly_discount":"0,0","subtotal":"367.20","grand_total":"413.10","paid_amount":"413.10","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1648877085","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":"98750","customer_id":"98750","source_of_creation":"Expedia","reservation_created_date":"2020-02-26 14:18:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"183.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074793","reservation_id":"91810","confirmation_number":"SJ12652444805","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.50,211.50","nightly_discount":"0,0","subtotal":"423.00","grand_total":"475.88","paid_amount":"475.88","room_type_id":"319","product_id":"1312","siteminder_id":"EXP-1639810386","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":"97955","customer_id":"97955","source_of_creation":"Expedia","reservation_created_date":"2020-02-11 20:49:10","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","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":"3074806","reservation_id":"91890","confirmation_number":"SJ12669687783","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20","nightly_discount":"0,0","subtotal":"338.40","grand_total":"380.70","paid_amount":"380.70","room_type_id":"319","product_id":"1942","siteminder_id":"EXP-1640566498","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":"98036","customer_id":"98036","source_of_creation":"Expedia","reservation_created_date":"2020-02-12 23:18:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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":"3067663","reservation_id":"91631","confirmation_number":"SJ12643298100","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"234.00,234.00,234.00,291.60","nightly_discount":"0,0,0,0","subtotal":"993.60","grand_total":"1117.80","paid_amount":"1117.80","room_type_id":"319","product_id":"1287","siteminder_id":"EXP-1638151316","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":"97768","customer_id":"97768","source_of_creation":"Expedia","reservation_created_date":"2020-02-09 04:03:08","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","currentDayPrice":"234.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":"3071104","reservation_id":"89022","confirmation_number":"SJ12673020053","room_stay_from":"2020-02-23","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.40,230.40,230.40,230.40,230.40,272.80","nightly_discount":"0,0,0,0,0,0","subtotal":"1424.80","grand_total":"1602.90","paid_amount":"1602.90","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1615324196","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":"95099","customer_id":"95099","source_of_creation":"Expedia","reservation_created_date":"2019-12-31 19:42:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"230.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3071964","reservation_id":"92267","confirmation_number":"SJ12614637836","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"204.00,204.00,204.00,224.00","nightly_discount":"0,0,0,0","subtotal":"836.00","grand_total":"940.50","paid_amount":"940.50","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1645469216","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":"98447","customer_id":"98447","source_of_creation":"Expedia","reservation_created_date":"2020-02-20 19:08:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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":"3073813","reservation_id":"91986","confirmation_number":"SJ12654742970","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,183.60,183.60,201.60","nightly_discount":"0,0,0,0","subtotal":"752.40","grand_total":"846.45","paid_amount":"846.45","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1641811532","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":"98139","customer_id":"98139","source_of_creation":"Expedia","reservation_created_date":"2020-02-14 21:39:06","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","currentDayPrice":"183.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074827","reservation_id":"92355","confirmation_number":"SJ12638273038","room_stay_from":"2020-02-26","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"183.60,183.60,201.60","nightly_discount":"0,0,0","subtotal":"568.80","grand_total":"639.90","paid_amount":"639.90","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1646550347","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":"98535","customer_id":"98535","source_of_creation":"Expedia","reservation_created_date":"2020-02-22 15:13:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"183.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3073159","reservation_id":"91774","confirmation_number":"SJ12617520566","room_stay_from":"2020-02-26","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,215.28,215.28,169.20","nightly_discount":"0,0,0,0,0","subtotal":"938.16","grand_total":"1055.43","paid_amount":"1055.43","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1639387006","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":"97919","customer_id":"97919","source_of_creation":"Expedia","reservation_created_date":"2020-02-11 04:19:09","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","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":"3074513","reservation_id":"92332","confirmation_number":"SJ12645674596","room_stay_from":"2020-02-24","room_stay_to":"2020-02-26","room_stay_status":"Checked-Out","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"183.60,440.00","nightly_discount":"0.00,0.00","subtotal":"623.60","grand_total":"701.55","paid_amount":"729.68","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1646236555","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":"98510","customer_id":"98660","source_of_creation":"Expedia","reservation_created_date":"2020-02-21 22:43:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","changedComment":"To date changed","deltaChange":"220.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":"3074520","reservation_id":"92333","confirmation_number":"SJ12684432491","room_stay_from":"2020-02-24","room_stay_to":"2020-02-26","room_stay_status":"Checked-Out","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"183.60,440.00","nightly_discount":"0.00,0.00","subtotal":"623.60","grand_total":"701.55","paid_amount":"729.68","room_type_id":"319","product_id":"1310","siteminder_id":"EXP-1646236556","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":"98511","customer_id":"98661","source_of_creation":"Expedia","reservation_created_date":"2020-02-21 22:43:08","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","changedComment":"To date changed","deltaChange":"220.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3060758","reservation_id":"90394","confirmation_number":"SJ12691617540","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00","nightly_discount":"0.00","subtotal":"179.00","grand_total":"201.38","paid_amount":"201.38","room_type_id":"413","product_id":"1263","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96446","customer_id":"96446","source_of_creation":"FE","reservation_created_date":"2020-01-22 23:02:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"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":"3061624","reservation_id":"90568","confirmation_number":"SJ12614484962","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00","nightly_discount":"0.00,0.00","subtotal":"358.00","grand_total":"402.75","paid_amount":"402.75","room_type_id":"413","product_id":"1271","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":"96631","customer_id":"96631","source_of_creation":"FE","reservation_created_date":"2020-01-25 17:48:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"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":"3065326","reservation_id":"90504","confirmation_number":"SJ12666616447","room_stay_from":"2020-02-25","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,179.00,215.00,215.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"967.00","grand_total":"1087.88","paid_amount":"1087.88","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"96559","customer_id":"96559","source_of_creation":"FE","reservation_created_date":"2020-01-24 16:34:20","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","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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3063729","reservation_id":"90970","confirmation_number":"SJ12668315206","room_stay_from":"2020-02-25","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,159.00,159.00","nightly_discount":"0.00,0.00,0.00","subtotal":"477.00","grand_total":"536.63","paid_amount":"536.63","room_type_id":"413","product_id":"1269","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97063","customer_id":"97063","source_of_creation":"PMS","reservation_created_date":"2020-01-30 21:22:43","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"159.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3066503","reservation_id":"91418","confirmation_number":"SJ12680820205","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"420.00,420.00","nightly_discount":"0.00,0.00","subtotal":"840.00","grand_total":"945.00","paid_amount":"945.00","room_type_id":"320","product_id":"1330","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":"97546","customer_id":"97546","source_of_creation":"PMS","reservation_created_date":"2020-02-06 16:57:33","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","currentDayPrice":"420.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3067280","reservation_id":"91513","confirmation_number":"SJ12679558493","room_stay_from":"2020-02-24","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.00,235.00,235.00,235.00,299.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1239.00","grand_total":"1393.88","paid_amount":"1393.88","room_type_id":"319","product_id":"1291","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":"97706","customer_id":"97706","source_of_creation":"PMS","reservation_created_date":"2020-02-07 20:25:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"235.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":"3074073","reservation_id":"92526","confirmation_number":"SJ12614448266","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"229.50,229.50,229.50,252.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"940.50","grand_total":"1058.07","paid_amount":"1058.07","room_type_id":"318","product_id":"1282","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98721","customer_id":"98721","source_of_creation":"PMS","reservation_created_date":"2020-02-25 01:34:47","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"229.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":"3074838","reservation_id":"90408","confirmation_number":"SJ12696514497","room_stay_from":"2020-02-26","room_stay_to":"2020-03-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,215.00,215.00,179.00,179.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1146.00","grand_total":"1289.25","paid_amount":"1289.25","room_type_id":"319","product_id":"1304","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96459","customer_id":"96459","source_of_creation":"PMS","reservation_created_date":"2020-01-23 02:02:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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":"3074593","reservation_id":"92590","confirmation_number":"SJ12659490433","room_stay_from":"2020-02-22","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"413","product_id":"1261","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74162","customer_id":"74162","source_of_creation":"PMS","reservation_created_date":"2020-02-26 13:36:23","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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":"3074557","reservation_id":"90977","confirmation_number":"SJ12641733360","room_stay_from":"2020-03-25","room_stay_to":"2020-03-27","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00","nightly_discount":"0.00,0.00","subtotal":"358.00","grand_total":"402.75","paid_amount":"201.38","room_type_id":"413","product_id":"1273","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97070","customer_id":"97070","source_of_creation":"PMS","reservation_created_date":"2020-01-30 22:27:54","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","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3061453","reservation_id":"90534","confirmation_number":"SJ12647452977","room_stay_from":"2020-02-21","room_stay_to":"2020-02-28","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":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-01-25 01:17:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"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":"3065767","reservation_id":"91252","confirmation_number":"SJ12634124984","room_stay_from":"2020-02-22","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-02-03 22:47:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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":"3065772","reservation_id":"91254","confirmation_number":"SJ12685477866","room_stay_from":"2020-02-22","room_stay_to":"2020-02-29","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":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-02-03 22:49:34","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3072565","reservation_id":"85093","confirmation_number":"SJ12676066667","room_stay_from":"2020-02-22","room_stay_to":"2020-02-29","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":"2019-10-04 03:14:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3072428","reservation_id":"92334","confirmation_number":"SJ12692172736","room_confirmation_number":"SJ12657021782","room_stay_from":"2020-02-24","room_stay_to":"2020-02-27","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":"98513","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-21 23:03:06","reservation_modified_date_time":"2020-02-21 23:03:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98513","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":"3072701","reservation_id":"92279","confirmation_number":"SJ12630061697","room_confirmation_number":"SJ12652168564","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"98459","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-22 14:48:41","reservation_modified_date_time":"2020-02-22 14:48:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98459","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":"3072706","reservation_id":"91280","confirmation_number":"SJ12645016191","room_confirmation_number":"SJ12695883665","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"97403","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-22 14:50:12","reservation_modified_date_time":"2020-02-22 14:50:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97403","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":"3074899","reservation_id":"90376","confirmation_number":"SJ12633843669","room_confirmation_number":"SJ12621345346","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","room_stay_status":"Active","nightly_price":"49.99","nightly_discount":"0.00","subtotal":"49.99","grand_total":"56.24","paid_amount":"56.24","product_id":"1777","service_quantity":"1","customer_traveller_id":"96424","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-25 20:09:05","reservation_modified_date_time":"2020-02-27 01:39:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96424","canceled_nights_data":"","currentDayPrice":"49.99","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":"3073836","reservation_id":"92361","confirmation_number":"SJ12680223579","room_confirmation_number":"SJ12613626347","room_stay_from":"2020-02-24","room_stay_to":"2020-02-28","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"98688","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-02-22 17:18:08","reservation_modified_date_time":"2020-02-24 23:58:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98688","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":"3074777","reservation_id":"90477","confirmation_number":"SJ12638227468","room_confirmation_number":"SJ12646338321","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"96534","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-26 20:23:54","reservation_modified_date_time":"2020-02-26 20:23:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96534","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":"3060759","reservation_id":"90394","confirmation_number":"SJ12617913072","room_confirmation_number":"SJ12691617540","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","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":"96446","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-22 23:02:10","reservation_modified_date_time":"2020-01-22 23:02:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96446","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":"3061342","reservation_id":"90514","confirmation_number":"SJ12616078165","room_confirmation_number":"SJ12666477886","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","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":"96569","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-24 18:25:11","reservation_modified_date_time":"2020-01-24 18:25:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96569","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":"3061625","reservation_id":"90568","confirmation_number":"SJ12681718936","room_confirmation_number":"SJ12614484962","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","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":"96631","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 17:48:06","reservation_modified_date_time":"2020-01-25 17:48:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96631","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":"3061676","reservation_id":"90582","confirmation_number":"SJ12626729159","room_confirmation_number":"SJ12683049186","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","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":"96648","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 19:53:06","reservation_modified_date_time":"2020-01-25 19:53:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96648","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":"3065634","reservation_id":"91149","confirmation_number":"SJ12630051137","room_confirmation_number":"SJ12645232951","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","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":"97275","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 19:00:08","reservation_modified_date_time":"2020-02-03 18:10:16","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97275","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":"3067293","reservation_id":"91224","confirmation_number":"SJ12616153795","room_confirmation_number":"SJ12633880275","room_stay_from":"2020-02-24","room_stay_to":"2020-02-27","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":"97346","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 18:08:07","reservation_modified_date_time":"2020-02-08 16:11:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97346","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":"3069370","reservation_id":"91776","confirmation_number":"SJ12650442816","room_confirmation_number":"SJ12659275314","room_stay_from":"2020-02-20","room_stay_to":"2020-02-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"97921","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 06:22:09","reservation_modified_date_time":"2020-02-12 23:28:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97921","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":"3070820","reservation_id":"92108","confirmation_number":"SJ12621445537","room_confirmation_number":"SJ12689241912","room_stay_from":"2020-02-23","room_stay_to":"2020-02-27","room_stay_status":"Active","nightly_price":"28.12,28.12,28.12,28.12","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"112.48","grand_total":"126.54","paid_amount":"126.54","product_id":"1776","service_quantity":"1","customer_traveller_id":"98284","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-02-17 19:14:06","reservation_modified_date_time":"2020-02-17 20:59:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98284","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":"3071602","reservation_id":"91868","confirmation_number":"SJ12687121067","room_confirmation_number":"SJ12694225769","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","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":"98013","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 18:43:08","reservation_modified_date_time":"2020-02-19 21:29:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98013","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":"3072429","reservation_id":"92334","confirmation_number":"SJ12695758816","room_confirmation_number":"SJ12657021782","room_stay_from":"2020-02-24","room_stay_to":"2020-02-27","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":"98513","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-21 23:03:06","reservation_modified_date_time":"2020-02-21 23:03:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98513","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":"3072702","reservation_id":"92279","confirmation_number":"SJ12653918656","room_confirmation_number":"SJ12652168564","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","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":"98459","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-21 00:08:10","reservation_modified_date_time":"2020-02-22 14:48:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98459","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":"3072707","reservation_id":"91280","confirmation_number":"SJ12682641996","room_confirmation_number":"SJ12695883665","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","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":"97403","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-04 13:24:07","reservation_modified_date_time":"2020-02-22 14:50:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97403","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":"3073684","reservation_id":"92497","confirmation_number":"SJ12627684052","room_confirmation_number":"SJ12651551429","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","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":"98659","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-24 20:19:10","reservation_modified_date_time":"2020-02-24 20:19:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98659","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":"3074603","reservation_id":"91448","confirmation_number":"SJ12688448171","room_confirmation_number":"SJ12612480678","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","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":"97577","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 21:05:10","reservation_modified_date_time":"2020-02-26 14:26:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97577","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":"3074622","reservation_id":"91448","confirmation_number":"SJ12627916439","room_confirmation_number":"SJ12630132220","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","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":"97577","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 21:05:15","reservation_modified_date_time":"2020-02-26 14:29:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97577","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":"3074684","reservation_id":"92549","confirmation_number":"SJ12691125838","room_confirmation_number":"SJ12649592513","room_stay_from":"2020-02-25","room_stay_to":"2020-02-27","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":"98711","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-25 18:48:09","reservation_modified_date_time":"2020-02-26 17:12:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98711","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":"3074821","reservation_id":"91852","confirmation_number":"SJ12691605659","room_confirmation_number":"SJ12682347974","room_stay_from":"2020-02-22","room_stay_to":"2020-02-27","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":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"98003","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 15:23:06","reservation_modified_date_time":"2020-02-26 21:31:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98003","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":"3074863","reservation_id":"91415","confirmation_number":"SJ12695161251","room_confirmation_number":"SJ12651171767","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","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":"97541","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 15:58:08","reservation_modified_date_time":"2020-02-26 22:14:39","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97541","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":"3074900","reservation_id":"90376","confirmation_number":"SJ12676737463","room_confirmation_number":"SJ12621345346","room_stay_from":"2020-02-26","room_stay_to":"2020-02-27","room_stay_status":"Active","nightly_price":"28.12","nightly_discount":"0.00","subtotal":"28.12","grand_total":"31.64","paid_amount":"31.64","product_id":"1776","service_quantity":"1","customer_traveller_id":"96424","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-01-22 19:44:09","reservation_modified_date_time":"2020-02-27 01:39:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96424","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":"3061454","reservation_id":"90534","confirmation_number":"SJ12681681896","room_confirmation_number":"SJ12647452977","room_stay_from":"2020-02-21","room_stay_to":"2020-02-28","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":"96596","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 01:17:24","reservation_modified_date_time":"2020-01-25 01:17:24","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":"3063728","reservation_id":"90533","confirmation_number":"SJ12682753390","room_confirmation_number":"SJ12690044372","room_stay_from":"2020-02-25","room_stay_to":"2020-02-28","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":"96595","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 00:58:06","reservation_modified_date_time":"2020-01-30 21:18:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96595","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":"3063730","reservation_id":"90970","confirmation_number":"SJ12649972723","room_confirmation_number":"SJ12668315206","room_stay_from":"2020-02-25","room_stay_to":"2020-02-28","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":"97063","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 21:22:43","reservation_modified_date_time":"2020-01-30 21:22:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97063","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":"3065565","reservation_id":"91212","confirmation_number":"SJ12669129703","room_confirmation_number":"SJ12629637160","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","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":"97334","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 16:17:11","reservation_modified_date_time":"2020-02-03 16:17:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97334","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":"3066504","reservation_id":"91418","confirmation_number":"SJ12658146851","room_confirmation_number":"SJ12680820205","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","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":"97546","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 16:57:33","reservation_modified_date_time":"2020-02-06 16:57:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97546","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":"3067295","reservation_id":"91537","confirmation_number":"SJ12681445724","room_confirmation_number":"SJ12623040384","room_stay_from":"2020-02-24","room_stay_to":"2020-02-28","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":"97671","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 00:48:10","reservation_modified_date_time":"2020-02-08 16:11:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97671","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":"3068895","reservation_id":"91794","confirmation_number":"SJ12659371145","room_confirmation_number":"SJ12659632352","room_stay_from":"2020-02-25","room_stay_to":"2020-02-28","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":"97938","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 16:52:09","reservation_modified_date_time":"2020-02-11 16:52:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97938","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":"3069045","reservation_id":"91825","confirmation_number":"SJ12658078886","room_confirmation_number":"SJ12627606962","room_stay_from":"2020-02-24","room_stay_to":"2020-02-28","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":"97974","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 00:58:10","reservation_modified_date_time":"2020-02-12 00:58:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97974","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":"3072584","reservation_id":"85934","confirmation_number":"SJ12654762552","room_confirmation_number":"SJ12658903556","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","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":"92858","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-19 16:20:11","reservation_modified_date_time":"2020-02-22 12:35:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92858","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":"3073154","reservation_id":"92326","confirmation_number":"SJ12623021534","room_confirmation_number":"SJ12687956027","room_stay_from":"2020-02-24","room_stay_to":"2020-02-28","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":"98499","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-21 20:18:07","reservation_modified_date_time":"2020-02-23 13:24:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98499","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":"3073174","reservation_id":"91436","confirmation_number":"SJ12613825610","room_confirmation_number":"SJ12692430464","room_stay_from":"2020-02-22","room_stay_to":"2020-02-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"98565","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 19:23:07","reservation_modified_date_time":"2020-02-23 13:48:20","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98565","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":"3073662","reservation_id":"92356","confirmation_number":"SJ12646994969","room_confirmation_number":"SJ12662872804","room_stay_from":"2020-02-24","room_stay_to":"2020-02-28","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":"98536","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-22 16:08:09","reservation_modified_date_time":"2020-02-24 19:30:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98536","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":"3073837","reservation_id":"92361","confirmation_number":"SJ12678318120","room_confirmation_number":"SJ12613626347","room_stay_from":"2020-02-24","room_stay_to":"2020-02-28","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":"98688","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-22 17:18:08","reservation_modified_date_time":"2020-02-24 23:58:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98688","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":"3073936","reservation_id":"91174","confirmation_number":"SJ12689542591","room_confirmation_number":"SJ12666820195","room_stay_from":"2020-02-20","room_stay_to":"2020-02-28","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":"97299","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 22:33:06","reservation_modified_date_time":"2020-02-25 13:04:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97299","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":"3074775","reservation_id":"91209","confirmation_number":"SJ12625587912","room_confirmation_number":"SJ12685673935","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","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":"97332","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 15:57:12","reservation_modified_date_time":"2020-02-26 20:23:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97332","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":"3074778","reservation_id":"90477","confirmation_number":"SJ12668089074","room_confirmation_number":"SJ12646338321","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","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":"96534","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-24 03:32:08","reservation_modified_date_time":"2020-02-26 20:23:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96534","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":"3074790","reservation_id":"92592","confirmation_number":"SJ12688747446","room_confirmation_number":"SJ12638256065","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","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":"98750","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-26 14:18:09","reservation_modified_date_time":"2020-02-26 20:45:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98750","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":"3074795","reservation_id":"91810","confirmation_number":"SJ12629891300","room_confirmation_number":"SJ12652444805","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","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":"97955","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 20:49:10","reservation_modified_date_time":"2020-02-26 20:49:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97955","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":"3074807","reservation_id":"91890","confirmation_number":"SJ12641406723","room_confirmation_number":"SJ12669687783","room_stay_from":"2020-02-26","room_stay_to":"2020-02-28","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":"98036","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-12 23:18:10","reservation_modified_date_time":"2020-02-26 21:16:33","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98036","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":"3065768","reservation_id":"91252","confirmation_number":"SJ12630668745","room_confirmation_number":"SJ12634124984","room_stay_from":"2020-02-22","room_stay_to":"2020-02-29","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":"97377","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 22:47:41","reservation_modified_date_time":"2020-02-03 22:47:41","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3065773","reservation_id":"91254","confirmation_number":"SJ12658795644","room_confirmation_number":"SJ12685477866","room_stay_from":"2020-02-22","room_stay_to":"2020-02-29","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":"97378","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 22:49:34","reservation_modified_date_time":"2020-02-03 22:49:34","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":"3067279","reservation_id":"91513","confirmation_number":"SJ12685929720","room_confirmation_number":"SJ12679558493","room_stay_from":"2020-02-24","room_stay_to":"2020-02-29","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":"97706","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-07 20:25:32","reservation_modified_date_time":"2020-02-08 15:52:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97706","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":"3067664","reservation_id":"91631","confirmation_number":"SJ12640230789","room_confirmation_number":"SJ12643298100","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","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":"97768","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 04:03:08","reservation_modified_date_time":"2020-02-09 04:03:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97768","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":"3071107","reservation_id":"89022","confirmation_number":"SJ12690601709","room_confirmation_number":"SJ12673020053","room_stay_from":"2020-02-23","room_stay_to":"2020-02-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"95099","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-31 19:42:09","reservation_modified_date_time":"2020-02-18 18:21:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95099","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":"3071965","reservation_id":"92267","confirmation_number":"SJ12695320090","room_confirmation_number":"SJ12614637836","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","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":"98447","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-20 19:08:07","reservation_modified_date_time":"2020-02-20 19:08:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98447","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":"3072566","reservation_id":"85093","confirmation_number":"SJ12647530071","room_confirmation_number":"SJ12676066667","room_stay_from":"2020-02-22","room_stay_to":"2020-02-29","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":"92326","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-04 03:14:53","reservation_modified_date_time":"2020-02-22 08:08:20","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":"3073816","reservation_id":"91986","confirmation_number":"SJ12671684546","room_confirmation_number":"SJ12654742970","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","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":"98139","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-14 21:39:06","reservation_modified_date_time":"2020-02-24 23:32:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98139","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":"3074072","reservation_id":"92526","confirmation_number":"SJ12669569200","room_confirmation_number":"SJ12614448266","room_stay_from":"2020-02-25","room_stay_to":"2020-02-29","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":"98721","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-25 01:34:47","reservation_modified_date_time":"2020-02-25 21:57:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98721","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":"3074828","reservation_id":"92355","confirmation_number":"SJ12660192428","room_confirmation_number":"SJ12638273038","room_stay_from":"2020-02-26","room_stay_to":"2020-02-29","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":"98535","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-22 15:13:06","reservation_modified_date_time":"2020-02-26 21:36:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98535","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":"3074846","reservation_id":"91640","confirmation_number":"SJ12650434578","room_confirmation_number":"SJ12611624414","room_stay_from":"2020-02-26","room_stay_to":"2020-02-29","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":"97777","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 15:41:11","reservation_modified_date_time":"2020-02-26 21:49:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97777","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":"3065327","reservation_id":"90504","confirmation_number":"SJ12611143624","room_confirmation_number":"SJ12666616447","room_stay_from":"2020-02-25","room_stay_to":"2020-03-01","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":"96559","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-24 16:34:20","reservation_modified_date_time":"2020-02-02 22:40:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96559","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":"3074861","reservation_id":"91110","confirmation_number":"SJ12691320822","room_confirmation_number":"SJ12622685488","room_stay_from":"2020-02-26","room_stay_to":"2020-03-01","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":"97237","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-02 07:59:10","reservation_modified_date_time":"2020-02-26 22:13:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97237","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":"3073160","reservation_id":"91774","confirmation_number":"SJ12634953237","room_confirmation_number":"SJ12617520566","room_stay_from":"2020-02-26","room_stay_to":"2020-03-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"97919","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 04:19:09","reservation_modified_date_time":"2020-02-23 13:30:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97919","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":"3074840","reservation_id":"90408","confirmation_number":"SJ12623104211","room_confirmation_number":"SJ12696514497","room_stay_from":"2020-02-26","room_stay_to":"2020-03-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"96459","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-23 02:02:11","reservation_modified_date_time":"2020-02-26 21:40:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96459","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":"3074594","reservation_id":"92590","confirmation_number":"SJ12696987483","room_confirmation_number":"SJ12659490433","room_stay_from":"2020-02-22","room_stay_to":"2020-03-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"74162","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-26 13:36:23","reservation_modified_date_time":"2020-02-26 14:14:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74162","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":"3074515","reservation_id":"92332","confirmation_number":"SJ12629471625","room_confirmation_number":"SJ12645674596","room_stay_from":"2020-02-24","room_stay_to":"2020-02-26","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":"98510","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-21 22:43:05","reservation_modified_date_time":"2020-02-26 13:01:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98660","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":"3074522","reservation_id":"92333","confirmation_number":"SJ12630138790","room_confirmation_number":"SJ12684432491","room_stay_from":"2020-02-24","room_stay_to":"2020-02-26","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":"98511","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-21 22:43:08","reservation_modified_date_time":"2020-02-26 13:03:18","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98661","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":"3074558","reservation_id":"90977","confirmation_number":"SJ12637354439","room_confirmation_number":"SJ12641733360","room_stay_from":"2020-03-25","room_stay_to":"2020-03-27","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":"97070","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 22:27:54","reservation_modified_date_time":"2020-02-26 13:51:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97070","canceled_nights_data":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3074516","reservation_id":"92332","confirmation_number":"SJ12647398852","room_confirmation_number":"SJ12645674596","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-26 13:02:33","reservation_modified_date_time":"2020-02-26 13:02:33","customer_id":"98660","parentCustTravId":"98510","customer_traveller_id":"98510","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":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074523","reservation_id":"92333","confirmation_number":"SJ12658700850","room_confirmation_number":"SJ12684432491","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-26 13:03:35","reservation_modified_date_time":"2020-02-26 13:03:35","customer_id":"98661","parentCustTravId":"98511","customer_traveller_id":"98511","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":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074822","reservation_id":"91852","confirmation_number":"SJ12640180359","room_confirmation_number":"SJ12682347974","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-26 21:31:40","reservation_modified_date_time":"2020-02-26 21:31:40","customer_id":"98003","parentCustTravId":"98003","customer_traveller_id":"98003","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":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074905","reservation_id":"91825","confirmation_number":"SJ12693107596","room_confirmation_number":"SJ12627606962","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"26.88","paid_amount":"26.88","product_id":"1654","service_quantity":"1","product_name":"Short Sleeve Pocket Tee","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-27 01:51:45","reservation_modified_date_time":"2020-02-27 01:51:45","customer_id":"97974","parentCustTravId":"97974","customer_traveller_id":"97974","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":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3074906","reservation_id":"91825","confirmation_number":"SJ12635300654","room_confirmation_number":"SJ12627606962","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":"1659","service_quantity":"1","product_name":"UV Shirts with\/without Hoodie","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-27 01:51:45","reservation_modified_date_time":"2020-02-27 01:51:45","customer_id":"97974","parentCustTravId":"97974","customer_traveller_id":"97974","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3074893","reservation_id":"92628","confirmation_number":"SJ12660561168","room_confirmation_number":"SJ12655033906","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"32.89","grand_total":"35.50","paid_amount":"35.50","product_id":null,"service_quantity":"1","product_name":"Bar Tab - Hayward","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-27 00:53:31","reservation_modified_date_time":"2020-02-27 00:53: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":"32.89","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3074902","reservation_id":"92630","confirmation_number":"SJ12669553094","room_confirmation_number":"SJ12611875471","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"62.99","grand_total":"68.00","paid_amount":"68.00","product_id":null,"service_quantity":"1","product_name":"Bar Tab","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-27 01:44:06","reservation_modified_date_time":"2020-02-27 01:44:06","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":"62.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"105","tax_name":"Bar Tax","tax_percentage":"7.95"}]},{"room_stay_id":"3074953","reservation_id":"92644","confirmation_number":"SJ12646587485","room_confirmation_number":"SJ12651910812","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"5.00","paid_amount":"5.00","product_id":null,"service_quantity":"2","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-27 04:04:34","reservation_modified_date_time":"2020-02-27 04:04:34","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.66","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3074693","reservation_id":"92549","confirmation_number":"SJ12675544348","room_confirmation_number":"SJ12649592513","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"8.00","grand_total":"8.00","paid_amount":"8.00","product_id":"2006","service_quantity":"1","product_name":"Miscellaneous- Bar and Restaurant","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-26 17:25:05","reservation_modified_date_time":"2020-02-26 17:25:05","customer_id":"98711","parentCustTravId":"98711","customer_traveller_id":"98711","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":"8.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3074723","reservation_id":"92610","confirmation_number":"SJ12643526591","room_confirmation_number":"SJ12671060513","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"1","product_name":"Custom product","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-26 18:39:45","reservation_modified_date_time":"2020-02-26 18:39:45","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":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3074763","reservation_id":"92614","confirmation_number":"SJ12611239634","room_confirmation_number":"SJ12688346493","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"68.00","grand_total":"68.00","paid_amount":"68.00","product_id":null,"service_quantity":"1","product_name":"blue bar","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-26 19:52:55","reservation_modified_date_time":"2020-02-26 19:52:55","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":"68.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}