{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-12-30","total_rooms_exist":63,"departureCount":18,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"12","block_room_bookings":[],"bundle_block_count":"11","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3032663","reservation_id":"86280","confirmation_number":"SJ12682810692","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"417.6,417.6,255.6,255.6","nightly_discount":"0,0,0,0","subtotal":"1346.40","grand_total":"1514.70","paid_amount":"1514.70","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2238673054","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93083","customer_id":"93083","source_of_creation":"Booking.com","reservation_created_date":"2019-10-26 15:10:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"242.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"417.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":"3033273","reservation_id":"86381","confirmation_number":"SJ12699057635","room_stay_from":"2019-12-29","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20","nightly_discount":"0,0","subtotal":"662.40","grand_total":"745.20","paid_amount":"745.20","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-2314579960","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":"93143","customer_id":"93143","source_of_creation":"Booking.com","reservation_created_date":"2019-10-28 20:20:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"119.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"331.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":"3037858","reservation_id":"86006","confirmation_number":"SJ12617619570","room_stay_from":"2019-12-27","room_stay_to":"2020-01-02","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"414,414,414,414,414,302","nightly_discount":"0,0,0,0,0,0","subtotal":"2372.00","grand_total":"2668.50","paid_amount":"2668.50","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-3822968123","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"300.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92895","customer_id":"92895","source_of_creation":"Booking.com","reservation_created_date":"2019-10-20 20:53:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"476.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"414","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":"3039970","reservation_id":"87353","confirmation_number":"SJ12683288743","room_stay_from":"2019-12-29","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"355.59,355.59","nightly_discount":"0,0","subtotal":"711.18","grand_total":"800.08","paid_amount":"800.08","room_type_id":"319","product_id":"1302","siteminder_id":"BDC-2870990253","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":"93902","customer_id":"93902","source_of_creation":"Booking.com","reservation_created_date":"2019-11-20 15:48:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"256.02","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"355.59","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":"3042031","reservation_id":"87570","confirmation_number":"SJ12641550088","room_stay_from":"2019-12-27","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,331.20,331.20","nightly_discount":"0,0,0,0","subtotal":"1324.80","grand_total":"1490.40","paid_amount":"1490.40","room_type_id":"319","product_id":"1314","siteminder_id":"BDC-2260289872","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":"94079","customer_id":"94079","source_of_creation":"Booking.com","reservation_created_date":"2019-11-27 19:56:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"238.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"331.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":"3044082","reservation_id":"87293","confirmation_number":"SJ12661009186","room_stay_from":"2019-12-27","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,331.20,331.20,331.20,234.00,234.00,266.00","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"2390.00","grand_total":"2688.75","paid_amount":"2688.75","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-3182555039","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":"93850","customer_id":"93850","source_of_creation":"Booking.com","reservation_created_date":"2019-11-18 22:46:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"430.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"331.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":"3048280","reservation_id":"88424","confirmation_number":"SJ12654130603","room_stay_from":"2019-12-28","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"392.6,392.6,392.6","nightly_discount":"0,0,0","subtotal":"1177.80","grand_total":"1325.03","paid_amount":"1325.03","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-2766742006","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":"94649","customer_id":"94649","source_of_creation":"Booking.com","reservation_created_date":"2019-12-17 19:51:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"225.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"392.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":"3048859","reservation_id":"88486","confirmation_number":"SJ12664889463","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,234.00,234.00","nightly_discount":"0,0,0,0","subtotal":"1130.40","grand_total":"1271.70","paid_amount":"1271.70","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-3907414660","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":"94700","customer_id":"94700","source_of_creation":"Booking.com","reservation_created_date":"2019-12-20 12:09:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"203.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"331.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":"3049191","reservation_id":"88522","confirmation_number":"SJ12647612717","room_stay_from":"2019-12-27","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,331.20,331.20,331.20,234.00,234.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"2124.00","grand_total":"2389.50","paid_amount":"2389.50","room_type_id":"319","product_id":"1288","siteminder_id":"BDC-3164254978","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":"94725","customer_id":"94725","source_of_creation":"Booking.com","reservation_created_date":"2019-12-21 18:50:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"382.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"331.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":"3049510","reservation_id":"88556","confirmation_number":"SJ12660766970","room_stay_from":"2019-12-29","room_stay_to":"2020-01-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"335.34,335.34,335.34","nightly_discount":"0,0,0","subtotal":"1006.02","grand_total":"1131.77","paid_amount":"1131.77","room_type_id":"413","product_id":"1268","siteminder_id":"BDC-2411504934","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":"94754","customer_id":"94754","source_of_creation":"Booking.com","reservation_created_date":"2019-12-22 18:10:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"181.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"335.34","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":"3049808","reservation_id":"86294","confirmation_number":"SJ12656153696","room_stay_from":"2019-12-28","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,331.20,331.20,234.00,234.00","nightly_discount":"0,0,0,0,0,0","subtotal":"1792.80","grand_total":"2016.90","paid_amount":"2016.90","room_type_id":"319","product_id":"1304","siteminder_id":"BDC-3428744582","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":"93092","customer_id":"93092","source_of_creation":"Booking.com","reservation_created_date":"2019-10-26 20:17:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"322.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"331.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":"3050021","reservation_id":"88515","confirmation_number":"SJ12669077416","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"316.08","nightly_discount":"0","subtotal":"316.08","grand_total":"355.59","paid_amount":"355.59","room_type_id":"319","product_id":"1711","siteminder_id":"BDC-2957815151","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":"94719","customer_id":"94719","source_of_creation":"Booking.com","reservation_created_date":"2019-12-21 15:19:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"56.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"316.08","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":"3050424","reservation_id":"88701","confirmation_number":"SJ12681079510","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"371.2,371.2,371.2,302","nightly_discount":"0,0,0,0","subtotal":"1415.60","grand_total":"1592.55","paid_amount":"1592.55","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-2568870530","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94865","customer_id":"94865","source_of_creation":"Booking.com","reservation_created_date":"2019-12-25 21:40:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"259.31","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"371.2","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":"3050462","reservation_id":"83702","confirmation_number":"SJ12690188562","room_stay_from":"2019-12-29","room_stay_to":"2020-01-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"268.27,268.27,268.27","nightly_discount":"0,0,0","subtotal":"804.81","grand_total":"905.41","paid_amount":"905.41","room_type_id":"319","product_id":"1913","siteminder_id":"BDC-3569886107","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":"91080","customer_id":"91080","source_of_creation":"Booking.com","reservation_created_date":"2019-09-06 17:03:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"144.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"268.27","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":"3050873","reservation_id":"83700","confirmation_number":"SJ12666183502","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.54,189.54,189.54,189.54","nightly_discount":"0,0,0,0","subtotal":"758.16","grand_total":"852.93","paid_amount":"852.93","room_type_id":"319","product_id":"1308","siteminder_id":"BDC-2179952352","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":"91079","customer_id":"91079","source_of_creation":"Booking.com","reservation_created_date":"2019-09-06 16:46:21","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"715.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"189.54","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":"3050875","reservation_id":"83700","confirmation_number":"SJ12647071153","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.54,189.54,189.54,189.54","nightly_discount":"0,0,0,0","subtotal":"758.16","grand_total":"852.93","paid_amount":"852.93","room_type_id":"319","product_id":"1309","siteminder_id":"BDC-2179952352","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":"91079","customer_id":"91079","source_of_creation":"Booking.com","reservation_created_date":"2019-09-06 16:46:26","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"715.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"189.54","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":"3050879","reservation_id":"83700","confirmation_number":"SJ12641131545","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.54,189.54,189.54,189.54","nightly_discount":"0,0,0,0","subtotal":"758.16","grand_total":"852.93","paid_amount":"852.93","room_type_id":"319","product_id":"1310","siteminder_id":"BDC-2179952352","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":"91079","customer_id":"91079","source_of_creation":"Booking.com","reservation_created_date":"2019-09-06 16:46:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"715.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"189.54","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":"3050979","reservation_id":"88755","confirmation_number":"SJ12656597895","room_stay_from":"2019-12-28","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,331.20,331.20,277.00,266.00","nightly_discount":"0,0,0,0,0,0","subtotal":"1867.80","grand_total":"2101.28","paid_amount":"2101.28","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-3253543532","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":"94910","customer_id":"94910","source_of_creation":"Booking.com","reservation_created_date":"2019-12-27 04:17:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 332","ota_service_fee_amount":"0","commision_charges":"168.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"331.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":"3051117","reservation_id":"85204","confirmation_number":"SJ12621405812","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"335.34,335.34,335.34,224.37","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1230.39","grand_total":"1384.19","paid_amount":"1384.19","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-3829269727","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":"92398","customer_id":"92398","source_of_creation":"Booking.com","reservation_created_date":"2019-10-06 19:14:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"221.48","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"335.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3051440","reservation_id":"88849","confirmation_number":"SJ12694147671","room_stay_from":"2019-12-30","room_stay_to":"2020-01-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20","nightly_discount":"0,0","subtotal":"662.40","grand_total":"745.20","paid_amount":"745.20","room_type_id":"319","product_id":"1305","siteminder_id":"BDC-2121037510","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":"94981","customer_id":"94981","source_of_creation":"Booking.com","reservation_created_date":"2019-12-28 18:45:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"119.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"331.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":"3052132","reservation_id":"87875","confirmation_number":"SJ12624633050","room_stay_from":"2019-12-30","room_stay_to":"2020-01-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"414.00,414.00","nightly_discount":"0,0","subtotal":"828.00","grand_total":"931.50","paid_amount":"931.50","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-2899944720","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":"94308","customer_id":"94308","source_of_creation":"Booking.com","reservation_created_date":"2019-12-05 13:55:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"149.04","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"414.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":"3052140","reservation_id":"88399","confirmation_number":"SJ12699853122","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"335.34","nightly_discount":"0","subtotal":"335.34","grand_total":"377.26","paid_amount":"377.26","room_type_id":"412","product_id":"1297","siteminder_id":"BDC-2211713400","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":"94630","customer_id":"94630","source_of_creation":"Booking.com","reservation_created_date":"2019-12-16 21:42:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"60.36","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"335.34","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":"3052142","reservation_id":"88956","confirmation_number":"SJ12618905631","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20","nightly_discount":"0","subtotal":"331.20","grand_total":"372.60","paid_amount":"372.60","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-2784842388","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":"95039","customer_id":"95039","source_of_creation":"Booking.com","reservation_created_date":"2019-12-30 13:58:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"59.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"331.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":"3052181","reservation_id":"88287","confirmation_number":"SJ12686739329","room_stay_from":"2019-12-28","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,331.20","nightly_discount":"0,0,0","subtotal":"993.60","grand_total":"1117.80","paid_amount":"1117.80","room_type_id":"319","product_id":"1291","siteminder_id":"BDC-3660115354","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":"94568","customer_id":"94568","source_of_creation":"Booking.com","reservation_created_date":"2019-12-14 05:38:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"119.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"331.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":"3052461","reservation_id":"87353","confirmation_number":"SJ12661881943","room_stay_from":"2019-12-29","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"355.59,355.59","nightly_discount":"0.00,0.00","subtotal":"711.18","grand_total":"800.08","paid_amount":"856.33","room_type_id":"319","product_id":"1303","siteminder_id":"BDC-2870990253","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":"93902","customer_id":"93902","source_of_creation":"Booking.com","reservation_created_date":"2019-11-20 15:48:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"256.02","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"355.59","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3052468","reservation_id":"87853","confirmation_number":"SJ12647986964","room_stay_from":"2019-12-27","room_stay_to":"2020-01-01","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"439.00,439.00,439.00,439.00,439.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"2195.00","grand_total":"2469.38","paid_amount":"2469.38","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-3698109009","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":"94289","customer_id":"94289","source_of_creation":"Booking.com","reservation_created_date":"2019-12-04 21:04:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"131.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"439.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":"3052666","reservation_id":"88402","confirmation_number":"SJ12616371713","room_stay_from":"2019-12-28","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"414.00,414.00,414.00,414.00,259.00,259.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2174.00","grand_total":"2456.62","paid_amount":"2456.62","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-3690288488","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"300.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94632","customer_id":"94632","source_of_creation":"Booking.com","reservation_created_date":"2019-12-16 22:15:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"436.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"414.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":"3052814","reservation_id":"83700","confirmation_number":"SJ12681668432","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.54,189.54,189.54,189.54","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"758.16","grand_total":"852.93","paid_amount":"852.93","room_type_id":"319","product_id":"1307","siteminder_id":"BDC-2179952352","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":"91079","customer_id":"91079","source_of_creation":"Booking.com","reservation_created_date":"2019-09-06 16:46:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"715.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"189.54","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3053584","reservation_id":"85788","confirmation_number":"SJ12680896953","room_stay_from":"2019-12-28","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"331.20,331.20,331.20,331.20,234.00,234.00","nightly_discount":"0,0,0,0,0,0","subtotal":"1792.80","grand_total":"2016.90","paid_amount":"2016.90","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-2554870856","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":"92804","customer_id":"92804","source_of_creation":"Booking.com","reservation_created_date":"2019-10-17 13:44:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"322.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"331.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3023169","reservation_id":"82961","confirmation_number":"SJ12693833332","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"375.20,375.20,227.20,227.20","nightly_discount":"0,0,0,0","subtotal":"1204.80","grand_total":"1355.40","paid_amount":"1355.40","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1325872167","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":"90434","customer_id":"90434","source_of_creation":"Expedia","reservation_created_date":"2019-08-20 16:27:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"375.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":"3038316","reservation_id":"87143","confirmation_number":"SJ12638655748","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"371.20","nightly_discount":"0","subtotal":"371.20","grand_total":"417.60","paid_amount":"417.60","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1380504544","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":"93721","customer_id":"93721","source_of_creation":"Expedia","reservation_created_date":"2019-11-14 20:03:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"371.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":"3044079","reservation_id":"83796","confirmation_number":"SJ12673762652","room_stay_from":"2019-12-29","room_stay_to":"2020-01-01","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"351.20,351.20,351.20","nightly_discount":"0,0,0","subtotal":"1053.60","grand_total":"1185.30","paid_amount":"1185.30","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1338478210","collect_which":"channel_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":"91139","customer_id":"91139","source_of_creation":"Expedia","reservation_created_date":"2019-09-08 21:16:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"351.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":"3047860","reservation_id":"88310","confirmation_number":"SJ12636725355","room_stay_from":"2019-12-30","room_stay_to":"2020-01-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"318.44,318.44,187.20","nightly_discount":"0,0,0","subtotal":"824.08","grand_total":"927.09","paid_amount":"927.09","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1607716383","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":"94584","customer_id":"94584","source_of_creation":"Expedia","reservation_created_date":"2019-12-14 21:37:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"318.44","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":"3050419","reservation_id":"88565","confirmation_number":"SJ12684502773","room_stay_from":"2019-12-30","room_stay_to":"2020-01-01","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"371.20,371.20","nightly_discount":"0,0","subtotal":"742.40","grand_total":"835.20","paid_amount":"835.20","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1611264158","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":"94762","customer_id":"94762","source_of_creation":"Expedia","reservation_created_date":"2019-12-22 21:12:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"371.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":"3051114","reservation_id":"87607","confirmation_number":"SJ12692334197","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"363.20,363.20,363.20,241.60","nightly_discount":"0,0,0,0","subtotal":"1331.20","grand_total":"1497.60","paid_amount":"1497.60","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1386378562","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":"94106","customer_id":"94106","source_of_creation":"Expedia","reservation_created_date":"2019-11-28 21:27:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"363.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":"3051449","reservation_id":"88637","confirmation_number":"SJ12632321064","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"283.18","nightly_discount":"0","subtotal":"283.18","grand_total":"318.58","paid_amount":"318.58","room_type_id":"319","product_id":"1319","siteminder_id":"EXP-1611946480","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":"94824","customer_id":"94824","source_of_creation":"Expedia","reservation_created_date":"2019-12-24 12:37:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"283.18","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":"3052118","reservation_id":"88890","confirmation_number":"SJ12688764398","room_stay_from":"2019-12-30","room_stay_to":"2020-01-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"298.91,298.91","nightly_discount":"0,0","subtotal":"597.82","grand_total":"672.55","paid_amount":"672.55","room_type_id":"319","product_id":"1312","siteminder_id":"EXP-1614061873","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":"95000","customer_id":"95000","source_of_creation":"Expedia","reservation_created_date":"2019-12-29 03:42:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"298.91","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":"3052130","reservation_id":"88572","confirmation_number":"SJ12656139060","room_stay_from":"2019-12-30","room_stay_to":"2020-01-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"414.00,414.00","nightly_discount":"0,0","subtotal":"828.00","grand_total":"931.50","paid_amount":"931.50","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1611306940","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":"94769","customer_id":"94769","source_of_creation":"Expedia","reservation_created_date":"2019-12-22 23:17:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"414.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":"3052183","reservation_id":"88988","confirmation_number":"SJ12625317332","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"314.64","nightly_discount":"0","subtotal":"314.64","grand_total":"353.97","paid_amount":"353.97","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1614915675","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":"95070","customer_id":"95070","source_of_creation":"Expedia","reservation_created_date":"2019-12-30 22:47:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"314.64","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":"3053876","reservation_id":"88437","confirmation_number":"SJ12644793438","room_stay_from":"2019-12-27","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"363.20,363.20,355.20,355.20,355.20,207.20,207.20,465.60","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2672.00","grand_total":"3006.00","paid_amount":"3259.13","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1609223218","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":"94659","customer_id":"94659","source_of_creation":"Expedia","reservation_created_date":"2019-12-18 01:47:10","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","migrated_id":"","currentDayPrice":"355.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":"3054928","reservation_id":"88600","confirmation_number":"SJ12699319342","room_stay_from":"2019-12-28","room_stay_to":"2020-01-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"351.20,343.20,343.20,343.20,443.19","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1823.99","grand_total":"2051.99","paid_amount":"2051.99","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1610873955","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":"94792","customer_id":"94792","source_of_creation":"Expedia","reservation_created_date":"2019-12-23 15:17:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"343.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"}]}],"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":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3051750","reservation_id":"88917","confirmation_number":"SJ12679618611","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"429.00","nightly_discount":"0.00","subtotal":"429.00","grand_total":"482.63","paid_amount":"482.63","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95021","customer_id":"95021","source_of_creation":"PMS","reservation_created_date":"2019-12-29 19:35:20","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","migrated_id":"","currentDayPrice":"429.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":"3052179","reservation_id":"88975","confirmation_number":"SJ12674805059","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"351.20","nightly_discount":"0.00","subtotal":"351.20","grand_total":"395.10","paid_amount":"395.10","room_type_id":"318","product_id":"1281","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95059","customer_id":"95059","source_of_creation":"PMS","reservation_created_date":"2019-12-30 18:20:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"351.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":"3052211","reservation_id":"88917","confirmation_number":"SJ12680695531","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"429.00","nightly_discount":"0.00","subtotal":"429.00","grand_total":"482.63","paid_amount":"482.63","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"95021","customer_id":"95021","source_of_creation":"PMS","reservation_created_date":"2019-12-29 19:35:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"429.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3045890","reservation_id":"88120","confirmation_number":"SJ12650189523","room_stay_from":"2019-12-28","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"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":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-12-10 16:40:33","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3045896","reservation_id":"88123","confirmation_number":"SJ12684287534","room_stay_from":"2019-12-28","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"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":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-12-10 16:46:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3048812","reservation_id":"82955","confirmation_number":"SJ12650065124","room_stay_from":"2019-12-28","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1756","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":"82876","customer_id":"82876","source_of_creation":"PMS","reservation_created_date":"2019-08-20 12:58:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3053263","reservation_id":"88121","confirmation_number":"SJ12631884314","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"79719","customer_id":"79719","source_of_creation":"PMS","reservation_created_date":"2019-12-10 16:42:05","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[{"room_stay_id":"3074234","reservation_id":"70027","confirmation_number":"SJ12693501161","room_stay_from":"2019-12-27","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.12,211.11,211.11,211.11","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"844.45","grand_total":"950.00","paid_amount":"950.00","room_type_id":"319","product_id":"1301","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2019-02-22 03:42:33","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","migrated_id":"","currentDayPrice":"211.11","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[{"room_stay_id":"3063033","reservation_id":"87870","confirmation_number":"SJ12611544100","room_stay_from":"2019-12-26","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.00,184.00,184.00,184.00,184","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"920.00","grand_total":"920.00","paid_amount":"920.00","room_type_id":"413","product_id":"1272","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-12-05 05:04:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"184","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":"3052053","reservation_id":"88229","confirmation_number":"SJ12631190009","room_stay_from":"2019-12-25","room_stay_to":"2019-12-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.00,184.00,184.00,184.00,184.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"920.00","grand_total":"920.00","paid_amount":"920.00","room_type_id":"319","product_id":"1711","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-12-13 02:14:04","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","migrated_id":"","taxExmptApplied":-115,"changedComment":"Nightly price or discount changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3032664","reservation_id":"86280","confirmation_number":"SJ12641677526","room_confirmation_number":"SJ12682810692","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"93083","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2019-10-26 15:10:09","reservation_modified_date_time":"2019-10-26 15:10:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93083","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":"3037861","reservation_id":"86006","confirmation_number":"SJ12685546915","room_confirmation_number":"SJ12617619570","room_stay_from":"2019-12-27","room_stay_to":"2020-01-02","room_stay_status":"Active","nightly_price":"50,50,50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"300.00","grand_total":"337.50","paid_amount":"337.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"92895","product_attribute_values":"extra_person#&#25","reservation_created_date":"2019-11-13 18:12:21","reservation_modified_date_time":"2019-11-13 18:12:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92895","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":"3048281","reservation_id":"88424","confirmation_number":"SJ12685443151","room_confirmation_number":"SJ12654130603","room_stay_from":"2019-12-28","room_stay_to":"2019-12-31","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":"94649","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2019-12-17 19:51:08","reservation_modified_date_time":"2019-12-17 19:51:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94649","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":"3050425","reservation_id":"88701","confirmation_number":"SJ12690561016","room_confirmation_number":"SJ12681079510","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Active","nightly_price":"50,50,50,50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"94865","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2019-12-25 21:40:11","reservation_modified_date_time":"2019-12-25 21:40:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94865","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":"3052102","reservation_id":"88482","confirmation_number":"SJ12626471748","room_confirmation_number":"SJ12612316398","room_stay_from":"2019-12-28","room_stay_to":"2019-12-29","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"94697","product_attribute_values":"extra_person#&#25","reservation_created_date":"2019-12-30 18:58:43","reservation_modified_date_time":"2019-12-30 18:58:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94697","canceled_nights_data":"","changedComment":"Reservation created for complete past date","deltaChange":"25.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3051786","reservation_id":"87353","confirmation_number":"SJ12640507635","room_confirmation_number":"SJ12661881943","room_stay_from":"2019-12-29","room_stay_to":"2019-12-31","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":"93902","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2019-12-29 20:17:56","reservation_modified_date_time":"2019-12-31 21:44:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93902","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3023171","reservation_id":"82961","confirmation_number":"SJ12689879704","room_confirmation_number":"SJ12693833332","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","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":"90434","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-20 16:27:10","reservation_modified_date_time":"2019-08-20 16:27:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90434","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":"3032665","reservation_id":"86280","confirmation_number":"SJ12648689328","room_confirmation_number":"SJ12682810692","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","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":"93083","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-26 15:10:09","reservation_modified_date_time":"2019-10-26 15:10:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93083","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":"3033274","reservation_id":"86381","confirmation_number":"SJ12627052438","room_confirmation_number":"SJ12699057635","room_stay_from":"2019-12-29","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"93143","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-28 20:20:08","reservation_modified_date_time":"2019-10-28 20:20:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93143","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":"3037862","reservation_id":"86006","confirmation_number":"SJ12613242351","room_confirmation_number":"SJ12617619570","room_stay_from":"2019-12-27","room_stay_to":"2020-01-02","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":"92895","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-20 20:53:06","reservation_modified_date_time":"2019-10-20 20:53:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92895","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":"3038318","reservation_id":"87143","confirmation_number":"SJ12630333790","room_confirmation_number":"SJ12638655748","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"93721","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-14 20:03:06","reservation_modified_date_time":"2019-11-14 20:03:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93721","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":"3039971","reservation_id":"87353","confirmation_number":"SJ12613117477","room_confirmation_number":"SJ12683288743","room_stay_from":"2019-12-29","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"93902","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-20 15:48:15","reservation_modified_date_time":"2019-11-20 15:48:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93902","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":"3042032","reservation_id":"87570","confirmation_number":"SJ12663611157","room_confirmation_number":"SJ12641550088","room_stay_from":"2019-12-27","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"94079","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-27 19:56:09","reservation_modified_date_time":"2019-11-27 19:56:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94079","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":"3044081","reservation_id":"83796","confirmation_number":"SJ12622333441","room_confirmation_number":"SJ12673762652","room_stay_from":"2019-12-29","room_stay_to":"2020-01-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"91139","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-08 21:16:10","reservation_modified_date_time":"2019-09-08 21:16:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91139","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":"3044083","reservation_id":"87293","confirmation_number":"SJ12663327431","room_confirmation_number":"SJ12661009186","room_stay_from":"2019-12-27","room_stay_to":"2020-01-04","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":"93850","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-18 22:46:09","reservation_modified_date_time":"2019-11-18 22:46:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93850","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":"3045891","reservation_id":"88120","confirmation_number":"SJ12693557735","room_confirmation_number":"SJ12650189523","room_stay_from":"2019-12-28","room_stay_to":"2020-01-04","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":"94452","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-10 16:40:33","reservation_modified_date_time":"2019-12-10 16:40:33","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","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":"3045897","reservation_id":"88123","confirmation_number":"SJ12644793982","room_confirmation_number":"SJ12684287534","room_stay_from":"2019-12-28","room_stay_to":"2020-01-04","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":"94455","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-10 16:46:18","reservation_modified_date_time":"2019-12-10 16:46:18","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","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":"3047862","reservation_id":"88310","confirmation_number":"SJ12650027165","room_confirmation_number":"SJ12636725355","room_stay_from":"2019-12-30","room_stay_to":"2020-01-02","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":"94584","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-14 21:37:08","reservation_modified_date_time":"2019-12-14 21:37:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94584","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":"3048282","reservation_id":"88424","confirmation_number":"SJ12629760453","room_confirmation_number":"SJ12654130603","room_stay_from":"2019-12-28","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"94649","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-17 19:51:08","reservation_modified_date_time":"2019-12-17 19:51:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94649","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":"3048813","reservation_id":"82955","confirmation_number":"SJ12698240518","room_confirmation_number":"SJ12650065124","room_stay_from":"2019-12-28","room_stay_to":"2020-01-04","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":"90428","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-20 12:58:07","reservation_modified_date_time":"2019-08-20 12:58:07","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82876","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":"3048860","reservation_id":"88486","confirmation_number":"SJ12685512698","room_confirmation_number":"SJ12664889463","room_stay_from":"2019-12-30","room_stay_to":"2020-01-03","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":"94700","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-20 12:09:11","reservation_modified_date_time":"2019-12-20 12:09:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94700","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":"3049192","reservation_id":"88522","confirmation_number":"SJ12653532097","room_confirmation_number":"SJ12647612717","room_stay_from":"2019-12-27","room_stay_to":"2020-01-03","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"94725","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-21 18:50:12","reservation_modified_date_time":"2019-12-21 18:50:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94725","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":"3049511","reservation_id":"88556","confirmation_number":"SJ12653663664","room_confirmation_number":"SJ12660766970","room_stay_from":"2019-12-29","room_stay_to":"2020-01-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"94754","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-22 18:10:12","reservation_modified_date_time":"2019-12-22 18:10:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94754","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":"3049810","reservation_id":"86294","confirmation_number":"SJ12639755061","room_confirmation_number":"SJ12656153696","room_stay_from":"2019-12-28","room_stay_to":"2020-01-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":"93092","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-26 20:17:10","reservation_modified_date_time":"2019-10-26 20:17:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93092","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":"3050022","reservation_id":"88515","confirmation_number":"SJ12674556007","room_confirmation_number":"SJ12669077416","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"94719","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-21 15:19:07","reservation_modified_date_time":"2019-12-21 15:19:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94719","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":"3050422","reservation_id":"88565","confirmation_number":"SJ12676850233","room_confirmation_number":"SJ12684502773","room_stay_from":"2019-12-30","room_stay_to":"2020-01-01","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"94762","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-22 21:12:08","reservation_modified_date_time":"2019-12-22 21:12:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94762","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":"3050426","reservation_id":"88701","confirmation_number":"SJ12670016987","room_confirmation_number":"SJ12681079510","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"94865","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-25 21:40:11","reservation_modified_date_time":"2019-12-25 21:40:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94865","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":"3050463","reservation_id":"83702","confirmation_number":"SJ12634216413","room_confirmation_number":"SJ12690188562","room_stay_from":"2019-12-29","room_stay_to":"2020-01-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"91080","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-06 17:03:12","reservation_modified_date_time":"2019-09-06 17:03:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91080","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":"3050874","reservation_id":"83700","confirmation_number":"SJ12691779070","room_confirmation_number":"SJ12666183502","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"91079","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-06 16:46:21","reservation_modified_date_time":"2019-09-06 16:46:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91079","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":"3050878","reservation_id":"83700","confirmation_number":"SJ12668708451","room_confirmation_number":"SJ12647071153","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"91079","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-06 16:46:26","reservation_modified_date_time":"2019-09-06 16:46:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91079","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":"3050880","reservation_id":"83700","confirmation_number":"SJ12617225364","room_confirmation_number":"SJ12641131545","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"91079","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-06 16:46:12","reservation_modified_date_time":"2019-09-06 16:46:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91079","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":"3050980","reservation_id":"88755","confirmation_number":"SJ12623671972","room_confirmation_number":"SJ12656597895","room_stay_from":"2019-12-28","room_stay_to":"2020-01-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,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"94910","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-27 04:17:06","reservation_modified_date_time":"2019-12-27 04:17:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94910","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":"3051116","reservation_id":"87607","confirmation_number":"SJ12610870471","room_confirmation_number":"SJ12692334197","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"94106","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-28 21:27:08","reservation_modified_date_time":"2019-11-28 21:27:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94106","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":"3051118","reservation_id":"85204","confirmation_number":"SJ12687685626","room_confirmation_number":"SJ12621405812","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"92398","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-06 19:14:08","reservation_modified_date_time":"2019-10-10 19:18:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92398","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":"3051441","reservation_id":"88849","confirmation_number":"SJ12613799951","room_confirmation_number":"SJ12694147671","room_stay_from":"2019-12-30","room_stay_to":"2020-01-01","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"94981","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-28 18:45:07","reservation_modified_date_time":"2019-12-28 18:45:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94981","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":"3051450","reservation_id":"88637","confirmation_number":"SJ12691315758","room_confirmation_number":"SJ12632321064","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"94824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-24 12:37:06","reservation_modified_date_time":"2019-12-24 12:37:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94824","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":"3051751","reservation_id":"88917","confirmation_number":"SJ12625820010","room_confirmation_number":"SJ12679618611","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"95021","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-29 19:35:20","reservation_modified_date_time":"2019-12-29 19:35:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95021","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":"3052120","reservation_id":"88890","confirmation_number":"SJ12655505765","room_confirmation_number":"SJ12688764398","room_stay_from":"2019-12-30","room_stay_to":"2020-01-01","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"95000","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-29 03:42:09","reservation_modified_date_time":"2019-12-29 03:42:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95000","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":"3052131","reservation_id":"88572","confirmation_number":"SJ12619176558","room_confirmation_number":"SJ12656139060","room_stay_from":"2019-12-30","room_stay_to":"2020-01-01","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"94769","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-22 23:17:11","reservation_modified_date_time":"2019-12-22 23:17:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94769","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":"3052133","reservation_id":"87875","confirmation_number":"SJ12637584990","room_confirmation_number":"SJ12624633050","room_stay_from":"2019-12-30","room_stay_to":"2020-01-01","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"94308","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-05 13:55:08","reservation_modified_date_time":"2019-12-05 13:55:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94308","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":"3052141","reservation_id":"88399","confirmation_number":"SJ12696162922","room_confirmation_number":"SJ12699853122","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"94630","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-16 21:42:11","reservation_modified_date_time":"2019-12-16 21:42:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94630","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":"3052143","reservation_id":"88956","confirmation_number":"SJ12649644338","room_confirmation_number":"SJ12618905631","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"95039","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-30 13:58:11","reservation_modified_date_time":"2019-12-30 13:58:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95039","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":"3052180","reservation_id":"88975","confirmation_number":"SJ12660270239","room_confirmation_number":"SJ12674805059","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"95059","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-30 18:20:16","reservation_modified_date_time":"2019-12-30 18:20:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95059","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":"3052182","reservation_id":"88287","confirmation_number":"SJ12692195958","room_confirmation_number":"SJ12686739329","room_stay_from":"2019-12-28","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"94568","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-14 05:38:10","reservation_modified_date_time":"2019-12-14 05:38:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94568","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":"3052184","reservation_id":"88988","confirmation_number":"SJ12683568728","room_confirmation_number":"SJ12625317332","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"95070","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-30 22:47:08","reservation_modified_date_time":"2019-12-30 22:47:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95070","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":"3052212","reservation_id":"88917","confirmation_number":"SJ12635705573","room_confirmation_number":"SJ12680695531","room_stay_from":"2019-12-30","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"95021","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-29 19:35:20","reservation_modified_date_time":"2019-12-29 19:35:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95021","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":"3052463","reservation_id":"87353","confirmation_number":"SJ12691046643","room_confirmation_number":"SJ12661881943","room_stay_from":"2019-12-29","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"93902","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-20 15:48:09","reservation_modified_date_time":"2019-12-31 21:51:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93902","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":"3052469","reservation_id":"87853","confirmation_number":"SJ12620961974","room_confirmation_number":"SJ12647986964","room_stay_from":"2019-12-27","room_stay_to":"2020-01-01","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"25.00,25.00,25.00,0.00,0.00","subtotal":"125.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"94289","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-04 21:04:06","reservation_modified_date_time":"2019-12-31 21:55:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94289","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":"3052668","reservation_id":"88402","confirmation_number":"SJ12634696965","room_confirmation_number":"SJ12616371713","room_stay_from":"2019-12-28","room_stay_to":"2020-01-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":"94632","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-16 22:15:07","reservation_modified_date_time":"2020-01-01 19:03:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94632","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":"3052816","reservation_id":"83700","confirmation_number":"SJ12680685190","room_confirmation_number":"SJ12681668432","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"91079","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-06 16:46:17","reservation_modified_date_time":"2020-01-01 23:11:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91079","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":"3053264","reservation_id":"88121","confirmation_number":"SJ12697088734","room_confirmation_number":"SJ12631884314","room_stay_from":"2019-12-29","room_stay_to":"2020-01-02","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"94453","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-10 16:42:05","reservation_modified_date_time":"2019-12-10 16:42:05","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"79719","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":"3053585","reservation_id":"85788","confirmation_number":"SJ12644502837","room_confirmation_number":"SJ12680896953","room_stay_from":"2019-12-28","room_stay_to":"2020-01-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":"94947","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-17 13:44:09","reservation_modified_date_time":"2019-10-17 13:44:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92804","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":"3053878","reservation_id":"88437","confirmation_number":"SJ12626448934","room_confirmation_number":"SJ12644793438","room_stay_from":"2019-12-27","room_stay_to":"2020-01-04","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"94659","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-18 01:47:10","reservation_modified_date_time":"2020-01-04 12:37:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94659","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":"3054930","reservation_id":"88600","confirmation_number":"SJ12652718480","room_confirmation_number":"SJ12699319342","room_stay_from":"2019-12-28","room_stay_to":"2020-01-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":"94792","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-23 15:17:09","reservation_modified_date_time":"2020-01-06 23:43:34","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94792","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":"3063035","reservation_id":"87870","confirmation_number":"SJ12638569317","room_confirmation_number":"SJ12611544100","room_stay_from":"2019-12-26","room_stay_to":"2019-12-31","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":"94305","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-05 05:04:14","reservation_modified_date_time":"2020-01-29 12:50:37","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3074233","reservation_id":"70027","confirmation_number":"SJ12635809073","room_confirmation_number":"SJ12693501161","room_stay_from":"2019-12-27","room_stay_to":"2019-12-31","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"82193","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-02-22 03:42:33","reservation_modified_date_time":"2020-02-25 22:59:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3052100","reservation_id":"87869","confirmation_number":"SJ12678078748","room_confirmation_number":"SJ12646968853","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":"25.63","product_id":"1869","service_quantity":"1","product_name":"Daily Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-12-30 18:56:52","reservation_modified_date_time":"2019-12-30 18:56:52","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"94304","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","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"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}