{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-09-18","total_rooms_exist":44,"departureCount":0,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"9","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3020996","reservation_id":"84314","confirmation_number":"SJ12679399421","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"103.20,103.20,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"206.40","grand_total":"232.20","paid_amount":"232.20","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1344978007","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":"91788","customer_id":"91788","source_of_creation":"Expedia","reservation_created_date":"2019-09-18 16:22:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103.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":"3019758","reservation_id":"84020","confirmation_number":"SJ12640306700","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00,204.00","nightly_discount":"0.00,0.00,0.00","subtotal":"502.00","grand_total":"564.75","paid_amount":"564.75","room_type_id":"413","product_id":"1260","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":"91561","customer_id":"91561","source_of_creation":"PMS","reservation_created_date":"2019-09-13 14:47:55","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":"149.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":"3014218","reservation_id":"83261","confirmation_number":"SJ12669095423","room_stay_from":"2019-09-14","room_stay_to":"2019-09-21","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":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2019-08-26 22:26: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":"3015150","reservation_id":"83257","confirmation_number":"SJ12646473737","room_stay_from":"2019-09-14","room_stay_to":"2019-09-21","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":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2019-08-26 22:18:00","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":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":"3019087","reservation_id":"80407","confirmation_number":"SJ12634426269","room_stay_from":"2019-09-15","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"594.00","grand_total":"594.00","paid_amount":"594.00","room_type_id":"319","product_id":"1309","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":"88703","customer_id":"88703","source_of_creation":"PMS","reservation_created_date":"2019-07-08 20:35:34","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.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":"3019091","reservation_id":"80407","confirmation_number":"SJ12647252518","room_stay_from":"2019-09-15","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"594.00","grand_total":"594.00","paid_amount":"594.00","room_type_id":"319","product_id":"1310","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_traveller_id":"88703","customer_id":"88703","source_of_creation":"PMS","reservation_created_date":"2019-07-08 20:35:34","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.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":"3020875","reservation_id":"83259","confirmation_number":"SJ12633158528","room_stay_from":"2019-09-14","room_stay_to":"2019-09-19","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2019-08-26 22:23:06","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":"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":"3021253","reservation_id":"83839","confirmation_number":"SJ12644158004","room_stay_from":"2019-09-15","room_stay_to":"2019-09-20","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","nightly_discount":"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-09-09 18:28:04","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"}]}],"negotiated_taxable":[{"room_stay_id":"3020212","reservation_id":"80996","confirmation_number":"SJ12639164458","room_stay_from":"2019-09-17","room_stay_to":"2019-09-19","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.00,0.00","nightly_discount":"0.00,0.00","subtotal":"245.00","grand_total":"275.63","paid_amount":"0.00","room_type_id":"319","product_id":"1303","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-07-19 03:46:04","service_canceled_date_time":"2019-09-18 11:29:59","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","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"}]}],"negotiated_non_taxable":[{"room_stay_id":"3018722","reservation_id":"73859","confirmation_number":"SJ12610256076","room_stay_from":"2019-09-13","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.57,73.57,73.57,73.57,73.57,73.57,73.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"515.00","grand_total":"515.00","paid_amount":"515.00","room_type_id":"319","product_id":"1314","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-04-02 16:58:54","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.57","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":"3018727","reservation_id":"72177","confirmation_number":"SJ12686835829","room_stay_from":"2019-09-13","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.57,73.57,73.57,73.57,73.57,73.57,73.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"515.00","grand_total":"515.00","paid_amount":"515.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-03-16 18:34:56","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":"73.57","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":"3019389","reservation_id":"73405","confirmation_number":"SJ12686259596","room_stay_from":"2019-09-15","room_stay_to":"2019-09-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.57,73.57,73.57,73.57,73.57,73.57,73.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"515.00","grand_total":"515.00","paid_amount":"515.00","room_type_id":"413","product_id":"1268","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-03-28 15:28:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.57","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":"3019428","reservation_id":"73557","confirmation_number":"SJ12628088768","room_stay_from":"2019-09-15","room_stay_to":"2019-09-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.00,74.00,74.00,74.00,74","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"370.00","grand_total":"370.00","paid_amount":"370.00","room_type_id":"319","product_id":"1306","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-03-29 18:44:52","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"74.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":"3021513","reservation_id":"73871","confirmation_number":"SJ12636709117","room_stay_from":"2019-09-14","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.57,73.57,73.57,73.57,73.57,73.57,73.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"515.00","grand_total":"515.00","paid_amount":"515.00","room_type_id":"319","product_id":"1311","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-04-02 17:20:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.57","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":"3021515","reservation_id":"73871","confirmation_number":"SJ12660447788","room_stay_from":"2019-09-14","room_stay_to":"2019-09-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.57,73.57,73.57,73.57,73.57,73.57,73.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"515.00","grand_total":"515.00","paid_amount":"515.00","room_type_id":"319","product_id":"1312","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"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-04-02 17:20:28","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":"73.57","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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3014219","reservation_id":"83261","confirmation_number":"SJ12672715175","room_confirmation_number":"SJ12669095423","room_stay_from":"2019-09-14","room_stay_to":"2019-09-21","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":"90649","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-26 22:26:18","reservation_modified_date_time":"2019-08-26 22:26:18","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3015151","reservation_id":"83257","confirmation_number":"SJ12617859822","room_confirmation_number":"SJ12646473737","room_stay_from":"2019-09-14","room_stay_to":"2019-09-21","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":"90644","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-26 22:18:00","reservation_modified_date_time":"2019-08-26 22:18:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3018723","reservation_id":"73859","confirmation_number":"SJ12654852261","room_confirmation_number":"SJ12610256076","room_stay_from":"2019-09-13","room_stay_to":"2019-09-20","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":"84491","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-04-02 16:58:55","reservation_modified_date_time":"2019-09-13 04:49:59","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":"3018729","reservation_id":"72177","confirmation_number":"SJ12665335038","room_confirmation_number":"SJ12686835829","room_stay_from":"2019-09-13","room_stay_to":"2019-09-20","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":"83400","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-16 18:34:56","reservation_modified_date_time":"2019-09-13 04:50:30","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":"3019088","reservation_id":"80407","confirmation_number":"SJ12638319360","room_confirmation_number":"SJ12634426269","room_stay_from":"2019-09-15","room_stay_to":"2019-09-21","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"88704","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-08 20:35:34","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"88703","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":"3019390","reservation_id":"73405","confirmation_number":"SJ12634002405","room_confirmation_number":"SJ12686259596","room_stay_from":"2019-09-15","room_stay_to":"2019-09-22","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":"84238","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-28 15:28:38","reservation_modified_date_time":"2019-09-15 04:36:53","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":"3019429","reservation_id":"73557","confirmation_number":"SJ12689361680","room_confirmation_number":"SJ12628088768","room_stay_from":"2019-09-15","room_stay_to":"2019-09-20","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":"84341","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-29 18:44:52","reservation_modified_date_time":"2019-09-15 04:36:25","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":"3019761","reservation_id":"84020","confirmation_number":"SJ12646286509","room_confirmation_number":"SJ12640306700","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","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":"91561","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-13 14:47:55","reservation_modified_date_time":"2019-09-13 14:47:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91561","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":"3020876","reservation_id":"83259","confirmation_number":"SJ12695438312","room_confirmation_number":"SJ12633158528","room_stay_from":"2019-09-14","room_stay_to":"2019-09-19","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"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":"90648","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-26 22:23:06","reservation_modified_date_time":"2019-08-26 22:23:06","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3020997","reservation_id":"84314","confirmation_number":"SJ12634563122","room_confirmation_number":"SJ12679399421","room_stay_from":"2019-09-18","room_stay_to":"2019-09-21","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":"91788","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-18 16:22:07","reservation_modified_date_time":"2019-09-19 19:22:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91788","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":"3021254","reservation_id":"83839","confirmation_number":"SJ12620097118","room_confirmation_number":"SJ12644158004","room_stay_from":"2019-09-15","room_stay_to":"2019-09-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"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":"91171","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-09-09 18:28:04","reservation_modified_date_time":"2019-09-09 18:28:04","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":"3021514","reservation_id":"73871","confirmation_number":"SJ12631672581","room_confirmation_number":"SJ12636709117","room_stay_from":"2019-09-14","room_stay_to":"2019-09-21","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":"84503","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-04-02 17:20:28","reservation_modified_date_time":"2019-09-21 13:41:21","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":"3021517","reservation_id":"73871","confirmation_number":"SJ12650007235","room_confirmation_number":"SJ12660447788","room_stay_from":"2019-09-14","room_stay_to":"2019-09-21","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":"84503","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-04-02 17:20:28","reservation_modified_date_time":"2019-09-21 13:41:29","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"}]}],"resort_fee_non_taxable":[{"room_stay_id":"3019092","reservation_id":"80407","confirmation_number":"SJ12692155130","room_confirmation_number":"SJ12647252518","room_stay_from":"2019-09-15","room_stay_to":"2019-09-21","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"88703","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-08 20:35:34","reservation_modified_date_time":"2019-08-09 12:37:49","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"88703","canceled_nights_data":"","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"}]}],"gift_shop_taxable":[{"room_stay_id":"3020730","reservation_id":"84327","confirmation_number":"SJ12667962360","room_confirmation_number":"SJ12693762790","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.95","grand_total":"22.52","paid_amount":"22.52","product_id":null,"service_quantity":"1","product_name":"Salt Scrub of the Keys","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-18 20:01:26","reservation_modified_date_time":"2019-09-18 20:01:26","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"20.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[{"room_stay_id":"3020718","reservation_id":"84323","confirmation_number":"SJ12676074566","room_confirmation_number":"SJ12659502686","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-18 18:56:09","reservation_modified_date_time":"2019-09-18 18:56:09","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"drinks","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"bar_non_taxable":[],"restaurant_taxable":[{"room_stay_id":"3020719","reservation_id":"84323","confirmation_number":"SJ12634878941","room_confirmation_number":"SJ12659502686","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.79","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Ice Cream","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-18 18:56:09","reservation_modified_date_time":"2019-09-18 18:56:09","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"food","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3020731","reservation_id":"84327","confirmation_number":"SJ12610125423","room_confirmation_number":"SJ12693762790","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.79","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Ice Cream","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-18 20:01:26","reservation_modified_date_time":"2019-09-18 20:01:26","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":"food","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"restaurant_non_taxable":[]}}