{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2019-08-25","total_rooms_exist":44,"departureCount":7,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"11","block_room_bookings":[],"bundle_block_count":"4","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3013106","reservation_id":"83097","confirmation_number":"SJ12678301709","room_stay_from":"2019-08-23","room_stay_to":"2019-08-26","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"136.04,136.04,113.24","nightly_discount":"0,0,0","subtotal":"385.32","grand_total":"433.49","paid_amount":"433.49","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1327990036","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":"90532","customer_id":"90532","source_of_creation":"Expedia","reservation_created_date":"2019-08-23 15:27:09","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":"113.24","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":"3014034","reservation_id":"83096","confirmation_number":"SJ12683653248","room_stay_from":"2019-08-23","room_stay_to":"2019-08-26","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"298.68,298.68,291.08","nightly_discount":"0,0,0","subtotal":"888.44","grand_total":"999.49","paid_amount":"999.49","room_type_id":"320","product_id":"1332","siteminder_id":"EXP-1327980651","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":"90531","customer_id":"90531","source_of_creation":"Expedia","reservation_created_date":"2019-08-23 15:08:16","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"291.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3013936","reservation_id":"83223","confirmation_number":"SJ12678118412","room_stay_from":"2019-08-25","room_stay_to":"2019-08-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00","nightly_discount":"0.00,0.00","subtotal":"298.00","grand_total":"335.25","paid_amount":"335.25","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":"90616","customer_id":"90616","source_of_creation":"FE","reservation_created_date":"2019-08-25 23:48:04","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"}]},{"room_stay_id":"3014380","reservation_id":"78189","confirmation_number":"SJ12624182186","room_stay_from":"2019-08-25","room_stay_to":"2019-08-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.00,358.00","nightly_discount":"0.00,0.00","subtotal":"527.00","grand_total":"592.88","paid_amount":"621.01","room_type_id":"412","product_id":"1316","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87328","customer_id":"87328","source_of_creation":"FE","reservation_created_date":"2019-06-07 13:50:33","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":"169.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3013260","reservation_id":"83012","confirmation_number":"SJ12683486148","room_stay_from":"2019-08-23","room_stay_to":"2019-08-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00","subtotal":"297.00","grand_total":"334.13","paid_amount":"334.13","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"75914","customer_id":"75914","source_of_creation":"PMS","reservation_created_date":"2019-08-21 20:33:07","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":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3014830","reservation_id":"83157","confirmation_number":"SJ12662574701","room_stay_from":"2019-08-24","room_stay_to":"2019-08-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,149.00,149.00,149.00,149.00,109.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"884.00","grand_total":"994.50","paid_amount":"994.50","room_type_id":"413","product_id":"1265","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":"90572","customer_id":"90572","source_of_creation":"PMS","reservation_created_date":"2019-08-24 19:20:45","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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"}]},{"room_stay_id":"3014860","reservation_id":"80235","confirmation_number":"SJ12626399482","room_stay_from":"2019-08-23","room_stay_to":"2019-08-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.00,164.00,159.00,159.00,159.00,159.00,159.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1123.00","grand_total":"1263.38","paid_amount":"1263.38","room_type_id":"319","product_id":"1307","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88604","customer_id":"88604","source_of_creation":"PMS","reservation_created_date":"2019-07-05 19:58:03","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"159.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3014190","reservation_id":"82059","confirmation_number":"SJ12697249724","room_stay_from":"2019-08-24","room_stay_to":"2019-08-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00","nightly_discount":"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-05 13:04:21","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":"3015221","reservation_id":"83043","confirmation_number":"SJ12646653613","room_stay_from":"2019-08-24","room_stay_to":"2019-08-30","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","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","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-22 12:48:02","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":"3015504","reservation_id":"82210","confirmation_number":"SJ12629432218","room_stay_from":"2019-08-24","room_stay_to":"2019-08-30","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","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","room_type_id":"411","product_id":"1296","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":"74796","customer_id":"74796","source_of_creation":"PMS","reservation_created_date":"2019-08-07 21:33:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 332","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":[]}],"negotiated_taxable":[{"room_stay_id":"3014882","reservation_id":"72174","confirmation_number":"SJ12629477113","room_stay_from":"2019-08-23","room_stay_to":"2019-08-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"515.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":"515.00","grand_total":"579.38","paid_amount":"579.38","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-03-16 18:28:43","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":"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":"3015204","reservation_id":"72627","confirmation_number":"SJ12635962635","room_stay_from":"2019-08-23","room_stay_to":"2019-08-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"515.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":"515.00","grand_total":"579.38","paid_amount":"579.38","room_type_id":"412","product_id":"1315","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-03-21 00:31:55","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3015509","reservation_id":"72629","confirmation_number":"SJ12688614935","room_stay_from":"2019-08-25","room_stay_to":"2019-08-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"515.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"515.00","grand_total":"579.38","paid_amount":"579.38","room_type_id":"412","product_id":"1866","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-03-21 00:39:25","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":"515.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_non_taxable":[{"room_stay_id":"3013037","reservation_id":"71859","confirmation_number":"SJ12698294180","room_stay_from":"2019-08-23","room_stay_to":"2019-08-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.33,73.33,73.34","nightly_discount":"0.00,0.00,0.00","subtotal":"220.00","grand_total":"220.00","paid_amount":"220.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-13 19:00:26","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":"73.34","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":"3013041","reservation_id":"71858","confirmation_number":"SJ12677542423","room_stay_from":"2019-08-23","room_stay_to":"2019-08-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.33,73.33,73.34","nightly_discount":"0.00,0.00,0.00","subtotal":"220.00","grand_total":"220.00","paid_amount":"220.00","room_type_id":"319","product_id":"1288","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-13 18:58:30","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.34","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":"3014059","reservation_id":"72683","confirmation_number":"SJ12625007024","room_stay_from":"2019-08-23","room_stay_to":"2019-08-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.33,73.33,73.34","nightly_discount":"0.00,0.00,0.00","subtotal":"220.00","grand_total":"220.00","paid_amount":"220.00","room_type_id":"413","product_id":"1266","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-21 13:06:51","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":"73.34","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":"3013038","reservation_id":"71859","confirmation_number":"SJ12631325073","room_confirmation_number":"SJ12698294180","room_stay_from":"2019-08-23","room_stay_to":"2019-08-26","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":"83198","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-13 19:00:26","reservation_modified_date_time":"2019-08-23 05:09:45","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":"3013042","reservation_id":"71858","confirmation_number":"SJ12693766949","room_confirmation_number":"SJ12677542423","room_stay_from":"2019-08-23","room_stay_to":"2019-08-26","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":"83197","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-13 18:58:30","reservation_modified_date_time":"2019-08-23 05:10:05","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":"3013108","reservation_id":"83097","confirmation_number":"SJ12692373844","room_confirmation_number":"SJ12678301709","room_stay_from":"2019-08-23","room_stay_to":"2019-08-26","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":"90532","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-23 15:27:09","reservation_modified_date_time":"2019-08-23 15:27:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90532","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":"3013261","reservation_id":"83012","confirmation_number":"SJ12678683695","room_confirmation_number":"SJ12683486148","room_stay_from":"2019-08-23","room_stay_to":"2019-08-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"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":"75914","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-21 20:33:07","reservation_modified_date_time":"2019-08-23 17:02:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75914","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":"3013937","reservation_id":"83223","confirmation_number":"SJ12632986274","room_confirmation_number":"SJ12678118412","room_stay_from":"2019-08-25","room_stay_to":"2019-08-27","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"90616","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-25 23:48:04","reservation_modified_date_time":"2019-08-25 23:48:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90616","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":"3014039","reservation_id":"83096","confirmation_number":"SJ12634012481","room_confirmation_number":"SJ12683653248","room_stay_from":"2019-08-23","room_stay_to":"2019-08-26","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":"90531","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-23 15:08:16","reservation_modified_date_time":"2019-08-23 15:08:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90531","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":"3014060","reservation_id":"72683","confirmation_number":"SJ12619008632","room_confirmation_number":"SJ12625007024","room_stay_from":"2019-08-23","room_stay_to":"2019-08-26","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":"83771","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-21 13:06:51","reservation_modified_date_time":"2019-08-26 17:07:04","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":"3014191","reservation_id":"82059","confirmation_number":"SJ12654094671","room_confirmation_number":"SJ12697249724","room_stay_from":"2019-08-24","room_stay_to":"2019-08-27","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"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":"89825","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-05 13:04:21","reservation_modified_date_time":"2019-08-05 13:04:21","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":"3014381","reservation_id":"78189","confirmation_number":"SJ12642330587","room_confirmation_number":"SJ12624182186","room_stay_from":"2019-08-25","room_stay_to":"2019-08-27","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"87328","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-06-07 13:50:33","reservation_modified_date_time":"2019-08-27 16:45:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87328","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":"3014831","reservation_id":"83157","confirmation_number":"SJ12617676551","room_confirmation_number":"SJ12662574701","room_stay_from":"2019-08-24","room_stay_to":"2019-08-30","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":"90572","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-24 19:20:45","reservation_modified_date_time":"2019-08-29 13:40:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90572","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":"3014862","reservation_id":"80235","confirmation_number":"SJ12628466541","room_confirmation_number":"SJ12626399482","room_stay_from":"2019-08-23","room_stay_to":"2019-08-30","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":"88604","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-05 19:58:03","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88604","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":"3014884","reservation_id":"72174","confirmation_number":"SJ12624137796","room_confirmation_number":"SJ12629477113","room_stay_from":"2019-08-23","room_stay_to":"2019-08-29","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"132.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"83398","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-16 18:28:43","reservation_modified_date_time":"2019-08-23 05:09:20","collect_which":"","tax_exempt_status":"0","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":"3015205","reservation_id":"72627","confirmation_number":"SJ12668014791","room_confirmation_number":"SJ12635962635","room_stay_from":"2019-08-23","room_stay_to":"2019-08-30","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"25.00,25.00,25.00,25.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"84.38","paid_amount":"20.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"83722","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-21 00:31:55","reservation_modified_date_time":"2019-08-30 13:56:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"25.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3015222","reservation_id":"83043","confirmation_number":"SJ12623565678","room_confirmation_number":"SJ12646653613","room_stay_from":"2019-08-24","room_stay_to":"2019-08-30","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":"90496","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-22 12:48:02","reservation_modified_date_time":"2019-08-22 12:48:02","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":"3015505","reservation_id":"82210","confirmation_number":"SJ12627425569","room_confirmation_number":"SJ12629432218","room_stay_from":"2019-08-24","room_stay_to":"2019-08-30","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":"89946","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-08-07 21:33:53","reservation_modified_date_time":"2019-08-07 21:33:53","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74796","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":"3015510","reservation_id":"72629","confirmation_number":"SJ12658830437","room_confirmation_number":"SJ12688614935","room_stay_from":"2019-08-25","room_stay_to":"2019-08-30","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":"132.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"83723","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-03-21 00:39:25","reservation_modified_date_time":"2019-08-31 12:05:28","collect_which":"","tax_exempt_status":"0","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":"3013458","reservation_id":"83153","confirmation_number":"SJ12652679341","room_confirmation_number":"SJ12637744269","room_stay_from":"2019-08-24","room_stay_to":"2019-08-25","room_stay_status":"Canceled","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-24 18:38:09","reservation_modified_date_time":"2019-08-24 18:38:09","customer_id":"90568","parentCustTravId":"90568","customer_traveller_id":"90568","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-08-25 11:31:08","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3002824","reservation_id":"81399","confirmation_number":"SJ12634248083","room_confirmation_number":"SJ12615430420","room_stay_from":"2019-08-25","room_stay_to":"2019-08-26","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","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-07-25 13:29:51","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"84865","parentCustTravId":"84865","customer_traveller_id":"84865","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-08-26 12:24:54","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#25","currentDayPrice":"25.00","currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}