{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2019-04-09","total_rooms_exist":66,"departureCount":23,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"1","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2914141","reservation_id":"66091","confirmation_number":"PB12345115197","room_stay_from":"2019-04-09","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.35,174.35","nightly_discount":"0,0","subtotal":"348.70","grand_total":"394.03","paid_amount":"394.03","room_type_id":"292","product_id":"1120","siteminder_id":"BDC-1339278969","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":"79732","customer_id":"79732","source_of_creation":"Booking.com","reservation_created_date":"2019-01-09 19:03:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS 218","ota_service_fee_amount":"0","commision_charges":"52.31","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"174.35","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2956227","reservation_id":"73162","confirmation_number":"BP12565403738","room_stay_from":"2019-04-05","room_stay_to":"2019-04-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.43,139.43,123.58,123.58,123.58","nightly_discount":"0,0,0,0,0","subtotal":"649.60","grand_total":"734.05","paid_amount":"734.05","room_type_id":"296","product_id":"1130","siteminder_id":"BDC-2696994434","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":"84079","customer_id":"84079","source_of_creation":"Booking.com","reservation_created_date":"2019-03-25 22:59:09","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"97.44","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"123.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2958730","reservation_id":"73530","confirmation_number":"BP12593715790","room_stay_from":"2019-04-09","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.22,147.22","nightly_discount":"0,0","subtotal":"294.44","grand_total":"332.72","paid_amount":"332.72","room_type_id":"293","product_id":"1124","siteminder_id":"BDC-3254100762","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":"84316","customer_id":"84316","source_of_creation":"Booking.com","reservation_created_date":"2019-03-29 16:11:06","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"44.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"147.22","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962760","reservation_id":"72450","confirmation_number":"PB12373326937","room_stay_from":"2019-04-06","room_stay_to":"2019-04-16","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"149.97,132.02,132.02,132.02,132.02,132.02,149.97,149.97,132.02,132.02","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"1374.05","grand_total":"1552.67","paid_amount":"1552.67","room_type_id":"289","product_id":"1101","siteminder_id":"BDC-1172112422","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"180.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"83577","customer_id":"83577","source_of_creation":"Booking.com","reservation_created_date":"2019-03-19 00:11:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"118.06","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"132.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963083","reservation_id":"73031","confirmation_number":"PB12391748061","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"132.52,132.52,132.52,132.52,132.52,150.47","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"813.07","grand_total":"918.76","paid_amount":"918.76","room_type_id":"289","product_id":"1110","siteminder_id":"BDC-3215836463","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":"83973","customer_id":"83973","source_of_creation":"Booking.com","reservation_created_date":"2019-03-24 13:13:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"40.65","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"132.52","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963471","reservation_id":"74301","confirmation_number":"PB12315214807","room_stay_from":"2019-04-09","room_stay_to":"2019-04-10","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"142.71","nightly_discount":"0","subtotal":"142.71","grand_total":"161.26","paid_amount":"161.26","room_type_id":"289","product_id":"1095","siteminder_id":"BDC-3690660097","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":"84767","customer_id":"84767","source_of_creation":"Booking.com","reservation_created_date":"2019-04-08 18:01:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"21.41","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"142.71","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2962798","reservation_id":"73073","confirmation_number":"PB12375437661","room_stay_from":"2019-04-07","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"234.26,234.26,234.26,234.26,234.26","nightly_discount":"0,0,0,0,0","subtotal":"1171.30","grand_total":"1323.57","paid_amount":"1323.57","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1223889786","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":"84007","customer_id":"84007","source_of_creation":"Expedia","reservation_created_date":"2019-03-25 00:06:06","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"234.26","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963132","reservation_id":"73794","confirmation_number":"BV12459686632","room_stay_from":"2019-04-09","room_stay_to":"2019-04-10","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"110.45","nightly_discount":"0","subtotal":"110.45","grand_total":"124.81","paid_amount":"124.81","room_type_id":"303","product_id":"1139","siteminder_id":"EXP-1228923521","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":"84446","customer_id":"84446","source_of_creation":"Expedia","reservation_created_date":"2019-04-01 14:51:07","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.45","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963797","reservation_id":"71214","confirmation_number":"PB12346035616","room_stay_from":"2019-04-09","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.31,154.31","nightly_discount":"0,0","subtotal":"308.62","grand_total":"348.74","paid_amount":"348.74","room_type_id":"289","product_id":"1112","siteminder_id":"EXP-1212291851","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":"82844","customer_id":"82844","source_of_creation":"Expedia","reservation_created_date":"2019-03-07 20:29:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"154.31","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"2948529","reservation_id":"71832","confirmation_number":"BV12416829006","room_stay_from":"2019-04-06","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"118.35,101.78,101.78,101.78,101.78,101.78,118.35","nightly_discount":"0,0,0,0,0,0,0","subtotal":"745.60","grand_total":"842.53","paid_amount":"842.53","room_type_id":"303","product_id":"1140","siteminder_id":"GAM-R1417425738","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":"83175","customer_id":"83175","source_of_creation":"Getaroom.com","reservation_created_date":"2019-03-13 14:55:08","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"101.78","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962660","reservation_id":"66172","confirmation_number":"PB12348063482","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.38,113.38,113.38,113.38,113.38,137.24","nightly_discount":"0,0,0,0,0,0","subtotal":"704.14","grand_total":"795.68","paid_amount":"795.68","room_type_id":"289","product_id":"1096","siteminder_id":"GAM-R1343807019","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":"79773","customer_id":"79773","source_of_creation":"Getaroom.com","reservation_created_date":"2019-01-10 02:12:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.38","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963228","reservation_id":"73082","confirmation_number":"PB12365478900","room_stay_from":"2019-04-08","room_stay_to":"2019-04-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.02,117.02","nightly_discount":"0,0","subtotal":"234.04","grand_total":"264.46","paid_amount":"264.46","room_type_id":"289","product_id":"1100","siteminder_id":"GAM-R1432883038","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":"84012","customer_id":"84012","source_of_creation":"Getaroom.com","reservation_created_date":"2019-03-25 01:13:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"2963819","reservation_id":"74395","confirmation_number":"BP12557451627","room_stay_from":"2019-04-09","room_stay_to":"2019-04-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.93","nightly_discount":"0","subtotal":"69.93","grand_total":"79.03","paid_amount":"79.03","room_type_id":"299","product_id":"1134","siteminder_id":"HWR-300140052","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":"84841","customer_id":"84841","source_of_creation":"Hotwire","reservation_created_date":"2019-04-09 22:55:07","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.93","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2915405","reservation_id":"66402","confirmation_number":"BV12453615206","room_stay_from":"2019-03-22","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.40,242.00,192.00,192.00,192.00,192.00,192.00,242.00,242.00,134.40,134.40,134.40,134.40,134.40,169.40,169.40,134.40,134.40,134.40,134.40,134.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"3538.20","grand_total":"3998.16","paid_amount":"3998.16","room_type_id":"304","product_id":"1220","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":"68361","customer_id":"68361","source_of_creation":"FE","reservation_created_date":"2019-01-11 23:00:36","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962806","reservation_id":"67595","confirmation_number":"PB12381195519","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.25,185.25,185.25,185.25,185.25,222.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1149.00","grand_total":"1298.37","paid_amount":"1298.37","room_type_id":"291","product_id":"1119","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":"80786","customer_id":"80786","source_of_creation":"FE","reservation_created_date":"2019-01-23 07:45:37","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"185.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"96539","reservation_id":"31068","confirmation_number":"PB986616591","room_stay_from":"2019-04-02","room_stay_to":"2019-04-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00,139.00","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1946.00","grand_total":"2198.98","paid_amount":"2198.98","room_type_id":"289","product_id":"1097","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":"56067","customer_id":"56067","source_of_creation":"PMS","reservation_created_date":"2018-04-08 15:12:02","canceled_nights_data":"","product_name":"109 PB Deluxe Efficiency Suite","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"133659","reservation_id":"51782","confirmation_number":"PB12386044088","room_stay_from":"2019-04-08","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.00,212.00,212.00","nightly_discount":"0.00,0.00,0.00","subtotal":"636.00","grand_total":"718.68","paid_amount":"718.68","room_type_id":"285","product_id":"1085","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":"72641","customer_id":"72641","source_of_creation":"PMS","reservation_created_date":"2018-07-22 16:02:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"212.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2884452","reservation_id":"60025","confirmation_number":"BP12539543456","room_stay_from":"2019-04-08","room_stay_to":"2019-04-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.00,235.00,235.00,235.00,235.00,235.00,235.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1645.00","grand_total":"1858.85","paid_amount":"1858.85","room_type_id":"300","product_id":"1135","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":"76711","customer_id":"76711","source_of_creation":"PMS","reservation_created_date":"2018-11-10 03:09:25","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"235.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2936092","reservation_id":"69549","confirmation_number":"PB12316915740","room_stay_from":"2019-04-08","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"270.00,270.00,270.00","nightly_discount":"0.00,0.00,0.00","subtotal":"810.00","grand_total":"915.30","paid_amount":"915.30","room_type_id":"288","product_id":"1092","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":"61085","customer_id":"61085","source_of_creation":"PMS","reservation_created_date":"2019-02-15 23:49:58","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"270.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2943663","reservation_id":"65222","confirmation_number":"PB12337750752","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00,225.00,225.00,225.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"900.00","grand_total":"1017.00","paid_amount":"1017.00","room_type_id":"289","product_id":"1121","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":"56077","customer_id":"56077","source_of_creation":"PMS","reservation_created_date":"2019-01-02 19:16:31","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"225.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2943667","reservation_id":"65222","confirmation_number":"PB12396517669","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00,225.00,225.00,225.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"900.00","grand_total":"1017.00","paid_amount":"1017.00","room_type_id":"289","product_id":"1123","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":"56077","customer_id":"56077","source_of_creation":"PMS","reservation_created_date":"2019-01-02 19:16:31","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"225.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2945524","reservation_id":"71252","confirmation_number":"BV12442927009","room_stay_from":"2019-04-09","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"156.00,156.00,156.00,193.50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"661.50","grand_total":"747.50","paid_amount":"747.50","room_type_id":"309","product_id":"1226","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":"64769","customer_id":"64769","source_of_creation":"PMS","reservation_created_date":"2019-03-08 00:47:41","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"156.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2952052","reservation_id":"72418","confirmation_number":"PB12368638338","room_stay_from":"2019-04-03","room_stay_to":"2019-04-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.91,143.91,143.91,143.91,143.91,143.91,143.91","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1007.37","grand_total":"1138.33","paid_amount":"1138.33","room_type_id":"289","product_id":"1109","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":"83556","customer_id":"83556","source_of_creation":"PMS","reservation_created_date":"2019-03-18 20:10:59","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2952949","reservation_id":"72451","confirmation_number":"BP12592139058","room_stay_from":"2019-04-08","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.00,90.00,90.00,90.00,90.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"450.00","grand_total":"508.50","paid_amount":"508.50","room_type_id":"302","product_id":"1138","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":"44475","customer_id":"44475","source_of_creation":"PMS","reservation_created_date":"2019-03-19 00:18:46","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2953223","reservation_id":"72643","confirmation_number":"BV12471362638","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"131.82,131.82,131.82,131.82","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"527.28","grand_total":"595.83","paid_amount":"595.83","room_type_id":"304","product_id":"1221","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":"83719","customer_id":"83719","source_of_creation":"PMS","reservation_created_date":"2019-03-21 01:16:00","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131.82","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2960606","reservation_id":"72643","confirmation_number":"BV12419746418","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"131.82,131.82,131.82,131.82","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"527.28","grand_total":"595.83","paid_amount":"595.83","room_type_id":"304","product_id":"1219","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":"83719","customer_id":"83719","source_of_creation":"PMS","reservation_created_date":"2019-03-21 01:16:00","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131.82","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961151","reservation_id":"30339","confirmation_number":"BV912427184","room_stay_from":"2019-04-02","room_stay_to":"2019-04-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00","nightly_discount":"124.12,124.12,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2002.00","grand_total":"1981.75","paid_amount":"1981.75","room_type_id":"308","product_id":"1225","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":"23671","customer_id":"23671","source_of_creation":"PMS","reservation_created_date":"2018-04-22 15:54:08","canceled_nights_data":"","product_name":"717 BV Bayfront With Balcony Suite","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"154.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961289","reservation_id":"51781","confirmation_number":"PB12358090891","room_stay_from":"2019-04-03","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"219.00,219.00,269.00,269.00,219.00,219.00,219.00,219.00,219.00,269.00","nightly_discount":"0.00,112.05,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2340.00","grand_total":"2517.59","paid_amount":"2517.59","room_type_id":"286","product_id":"1086","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":"25071","customer_id":"25071","source_of_creation":"PMS","reservation_created_date":"2018-07-22 15:58:29","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"219.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961320","reservation_id":"63677","confirmation_number":"PB12316568063","room_stay_from":"2019-04-02","room_stay_to":"2019-04-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,125.00,125.00,110.00,110.00,110.00,110.00","nightly_discount":"0.00,93.60,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1790.00","grand_total":"1916.93","paid_amount":"1916.93","room_type_id":"289","product_id":"1094","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":"77858","customer_id":"77858","source_of_creation":"PMS","reservation_created_date":"2018-12-17 22:40:00","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961727","reservation_id":"53672","confirmation_number":"PB12393235179","room_stay_from":"2019-04-05","room_stay_to":"2019-04-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"307.00,307.00,257.00,257.00,257.00,257.00,257.00,307.00,307.00,257.00,257.00,257.00,257.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,191.77,0.00","subtotal":"3541.00","grand_total":"3784.63","paid_amount":"3784.63","room_type_id":"287","product_id":"1089","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":"45153","customer_id":"45153","source_of_creation":"PMS","reservation_created_date":"2018-08-14 21:55:57","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"257.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962766","reservation_id":"57940","confirmation_number":"PB12397429376","room_stay_from":"2019-04-09","room_stay_to":"2019-04-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.00,212.00,212.00,212.00,212.00,212.00,212.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,74.00","subtotal":"1484.00","grand_total":"1593.30","paid_amount":"1593.30","room_type_id":"289","product_id":"1108","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":"69477","customer_id":"69477","source_of_creation":"PMS","reservation_created_date":"2018-10-09 18:03:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"212.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962832","reservation_id":"73470","confirmation_number":"BP12520999761","room_stay_from":"2019-04-07","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"133.72,133.72,133.72,133.72,133.72","nightly_discount":"36.56,0.00,0.00,0.00,0.00","subtotal":"668.60","grand_total":"714.20","paid_amount":"714.20","room_type_id":"294","product_id":"1125","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":"60569","customer_id":"60569","source_of_creation":"PMS","reservation_created_date":"2019-03-28 21:06:01","canceled_nights_data":"","product_name":"BP One Bedroom Suite 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"133.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963115","reservation_id":"64632","confirmation_number":"BP12565144420","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"192.00,192.00,192.00,192.00,192.00,242.00","nightly_discount":"0.00,0.00,0.00,0.00,55.19,72.00","subtotal":"1202.00","grand_total":"1214.54","paid_amount":"1214.54","room_type_id":"294","product_id":"1126","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":"56184","customer_id":"56184","source_of_creation":"PMS","reservation_created_date":"2019-04-07 13:20:33","canceled_nights_data":"","product_name":"BP One Bedroom Suite 1Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"192.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963199","reservation_id":"30614","confirmation_number":"PB921938591","room_stay_from":"2019-04-07","room_stay_to":"2019-04-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"214.00,214.00,214.00,214.00,214.00,214.00,214.00,214.00,214.00,214.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2140.00","grand_total":"2418.20","paid_amount":"2418.20","room_type_id":"287","product_id":"1088","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":"27233","customer_id":"27233","source_of_creation":"PMS","reservation_created_date":"2018-04-18 18:16:08","canceled_nights_data":"","product_name":"117 PB Gulf Front with Balcony Suite","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"214.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963220","reservation_id":"31079","confirmation_number":"PB988311941","room_stay_from":"2019-04-07","room_stay_to":"2019-04-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"162.10,162.10,162.10,162.10,162.10,162.10,162.10,162.10,162.10,162.10","nightly_discount":"0.00,78.94,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1621.00","grand_total":"1742.52","paid_amount":"1742.52","room_type_id":"289","product_id":"1093","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":"44880","customer_id":"44880","source_of_creation":"PMS","reservation_created_date":"2018-04-18 00:22:28","canceled_nights_data":"","product_name":"105 PB Deluxe Efficiency Suite","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"162.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963921","reservation_id":"73971","confirmation_number":"PB12355569712","room_stay_from":"2019-04-09","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"180.28,180.28,180.28,216.19","nightly_discount":"0.00,31.24,0.00,0.00","subtotal":"757.03","grand_total":"820.15","paid_amount":"820.15","room_type_id":"291","product_id":"1117","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":"84571","customer_id":"84571","source_of_creation":"PMS","reservation_created_date":"2019-04-03 20:02:06","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"180.28","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963971","reservation_id":"30607","confirmation_number":"PB921244401","room_stay_from":"2019-04-01","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.00,209.00,209.00,209.00,209.00,209.00,209.00,209.00,209.00,209.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,89.74,11.05,0.00","subtotal":"2090.00","grand_total":"2247.80","paid_amount":"2247.80","room_type_id":"289","product_id":"1102","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":"50174","customer_id":"50174","source_of_creation":"PMS","reservation_created_date":"2018-06-05 15:43:59","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"209.00","currentDayDiscount":"89.74","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2936091","reservation_id":"69549","confirmation_number":"PB12256827167","room_confirmation_number":"PB12316915740","room_stay_from":"2019-04-08","room_stay_to":"2019-04-11","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":"1780","service_quantity":"1","customer_traveller_id":"61085","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-02-15 23:49:58","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"61085","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962761","reservation_id":"72450","confirmation_number":"PB12225330318","room_confirmation_number":"PB12373326937","room_stay_from":"2019-04-06","room_stay_to":"2019-04-16","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"83577","product_attribute_values":"extra_person# ","reservation_created_date":"2019-04-06 16:52:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83577","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2898752","reservation_id":"51782","confirmation_number":"PBR12212616036","room_confirmation_number":"PB12386044088","room_stay_from":"2019-04-08","room_stay_to":"2019-04-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0,0,0","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"72641","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"72641","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2898915","reservation_id":"60025","confirmation_number":"PBR12230788942","room_confirmation_number":"BP12539543456","room_stay_from":"2019-04-08","room_stay_to":"2019-04-15","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"76711","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76711","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2905702","reservation_id":"31068","confirmation_number":"PB12394915082","room_confirmation_number":"PB986616591","room_stay_from":"2019-04-02","room_stay_to":"2019-04-16","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"168.00","grand_total":"189.84","paid_amount":"189.84","product_id":"1781","service_quantity":"1","customer_traveller_id":"56067","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-04-08 15:12:02","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56067","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2914142","reservation_id":"66091","confirmation_number":"PB12254802036","room_confirmation_number":"PB12345115197","room_stay_from":"2019-04-09","room_stay_to":"2019-04-11","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"79732","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-09 19:03:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79732","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2915406","reservation_id":"66402","confirmation_number":"BV12250631760","room_confirmation_number":"BV12453615206","room_stay_from":"2019-03-22","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"252.00","grand_total":"284.76","paid_amount":"284.76","product_id":"1781","service_quantity":"1","customer_traveller_id":"68361","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-11 23:00:36","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"68361","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2936093","reservation_id":"69549","confirmation_number":"PB12277380957","room_confirmation_number":"PB12316915740","room_stay_from":"2019-04-08","room_stay_to":"2019-04-11","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":"1781","service_quantity":"1","customer_traveller_id":"61085","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-02-15 23:49:58","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"61085","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2943664","reservation_id":"65222","confirmation_number":"PB12234725938","room_confirmation_number":"PB12337750752","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"56077","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-02 19:16:31","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56077","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2943668","reservation_id":"65222","confirmation_number":"PB12252817831","room_confirmation_number":"PB12396517669","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"56077","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-02 19:16:31","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56077","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2945525","reservation_id":"71252","confirmation_number":"BV12292414486","room_confirmation_number":"BV12442927009","room_stay_from":"2019-04-09","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"64769","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-08 00:47:41","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"64769","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2948530","reservation_id":"71832","confirmation_number":"BV12215193137","room_confirmation_number":"BV12416829006","room_stay_from":"2019-04-06","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"83175","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-13 14:55:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83175","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2952053","reservation_id":"72418","confirmation_number":"PB12264837501","room_confirmation_number":"PB12368638338","room_stay_from":"2019-04-03","room_stay_to":"2019-04-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"83556","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-18 20:10:59","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83556","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2952950","reservation_id":"72451","confirmation_number":"BP12242840809","room_confirmation_number":"BP12592139058","room_stay_from":"2019-04-08","room_stay_to":"2019-04-13","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":"1781","service_quantity":"1","customer_traveller_id":"44475","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-19 00:18:46","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44475","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2953224","reservation_id":"72643","confirmation_number":"BV12281260059","room_confirmation_number":"BV12471362638","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","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":"1781","service_quantity":"1","customer_traveller_id":"83719","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-21 01:16:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83719","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2956228","reservation_id":"73162","confirmation_number":"BP12234086409","room_confirmation_number":"BP12565403738","room_stay_from":"2019-04-05","room_stay_to":"2019-04-10","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"84079","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-25 22:59:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84079","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2958731","reservation_id":"73530","confirmation_number":"BP12278154359","room_confirmation_number":"BP12593715790","room_stay_from":"2019-04-09","room_stay_to":"2019-04-11","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"84316","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-29 16:11:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84316","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2960607","reservation_id":"72643","confirmation_number":"BV12215895310","room_confirmation_number":"BV12419746418","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","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":"1781","service_quantity":"1","customer_traveller_id":"83719","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-21 01:16:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83719","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961152","reservation_id":"30339","confirmation_number":"BV12466270014","room_confirmation_number":"BV912427184","room_stay_from":"2019-04-02","room_stay_to":"2019-04-15","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"156.00","grand_total":"176.28","paid_amount":"176.28","product_id":"1781","service_quantity":"1","customer_traveller_id":"23671","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-04-22 15:54:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23671","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961290","reservation_id":"51781","confirmation_number":"PBR12279195172","room_confirmation_number":"PB12358090891","room_stay_from":"2019-04-03","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"25071","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"25071","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961321","reservation_id":"63677","confirmation_number":"PBR12241826867","room_confirmation_number":"PB12316568063","room_stay_from":"2019-04-02","room_stay_to":"2019-04-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"192.00","grand_total":"216.96","paid_amount":"216.96","product_id":"1781","service_quantity":"1","customer_traveller_id":"77858","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77858","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961728","reservation_id":"53672","confirmation_number":"PBR12239351295","room_confirmation_number":"PB12393235179","room_stay_from":"2019-04-05","room_stay_to":"2019-04-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"156.00","grand_total":"176.28","paid_amount":"176.28","product_id":"1781","service_quantity":"1","customer_traveller_id":"45153","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"45153","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962661","reservation_id":"66172","confirmation_number":"PB12283137855","room_confirmation_number":"PB12348063482","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"79773","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-10 02:12:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79773","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962762","reservation_id":"72450","confirmation_number":"PB12288857446","room_confirmation_number":"PB12373326937","room_stay_from":"2019-04-06","room_stay_to":"2019-04-16","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"83577","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-19 00:11:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83577","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962767","reservation_id":"57940","confirmation_number":"PBR12231360295","room_confirmation_number":"PB12397429376","room_stay_from":"2019-04-09","room_stay_to":"2019-04-16","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"69477","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"69477","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962799","reservation_id":"73073","confirmation_number":"PB12295719596","room_confirmation_number":"PB12375437661","room_stay_from":"2019-04-07","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"84007","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-25 00:06:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84007","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962807","reservation_id":"67595","confirmation_number":"PB12239572151","room_confirmation_number":"PB12381195519","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"80786","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-23 07:45:37","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80786","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962833","reservation_id":"73470","confirmation_number":"BP12283075446","room_confirmation_number":"BP12520999761","room_stay_from":"2019-04-07","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"60569","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-28 21:06:01","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"60569","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963084","reservation_id":"73031","confirmation_number":"PB12216233764","room_confirmation_number":"PB12391748061","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"83973","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-24 13:13:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83973","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963116","reservation_id":"64632","confirmation_number":"BP12277395501","room_confirmation_number":"BP12565144420","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"47.46","product_id":"1781","service_quantity":"1","customer_traveller_id":"56184","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-07 13:20:33","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56184","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963133","reservation_id":"73794","confirmation_number":"BV12272581252","room_confirmation_number":"BV12459686632","room_stay_from":"2019-04-09","room_stay_to":"2019-04-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"84446","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-01 14:51:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84446","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963200","reservation_id":"30614","confirmation_number":"PB12383458113","room_confirmation_number":"PB921938591","room_stay_from":"2019-04-07","room_stay_to":"2019-04-17","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"27233","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-04-18 18:16:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"27233","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963221","reservation_id":"31079","confirmation_number":"PB12376571628","room_confirmation_number":"PB988311941","room_stay_from":"2019-04-07","room_stay_to":"2019-04-17","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"44880","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-04-18 00:22:28","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44880","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963229","reservation_id":"73082","confirmation_number":"PB12219289003","room_confirmation_number":"PB12365478900","room_stay_from":"2019-04-08","room_stay_to":"2019-04-10","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"84012","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-25 01:13:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84012","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963472","reservation_id":"74301","confirmation_number":"PB12279492721","room_confirmation_number":"PB12315214807","room_stay_from":"2019-04-09","room_stay_to":"2019-04-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"84767","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-08 18:01:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84767","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963798","reservation_id":"71214","confirmation_number":"PB12270831896","room_confirmation_number":"PB12346035616","room_stay_from":"2019-04-09","room_stay_to":"2019-04-11","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"82844","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-07 20:29:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82844","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963820","reservation_id":"74395","confirmation_number":"BP12282821895","room_confirmation_number":"BP12557451627","room_stay_from":"2019-04-09","room_stay_to":"2019-04-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"84841","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-09 22:55:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84841","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963922","reservation_id":"73971","confirmation_number":"PB12297204146","room_confirmation_number":"PB12355569712","room_stay_from":"2019-04-09","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"84571","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-03 20:02:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84571","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963972","reservation_id":"30607","confirmation_number":"PB12363928340","room_confirmation_number":"PB921244401","room_stay_from":"2019-04-01","room_stay_to":"2019-04-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"50174","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-06-05 15:43:59","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"50174","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1123","departureCount":12,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2914141","reservation_id":"66091","confirmation_number":"PB12345115197","room_stay_from":"2019-04-09","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"174.35,174.35","nightly_discount":"0,0","subtotal":"348.70","grand_total":"394.03","paid_amount":"394.03","room_type_id":"292","product_id":"1120","siteminder_id":"BDC-1339278969","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":"79732","customer_id":"79732","source_of_creation":"Booking.com","reservation_created_date":"2019-01-09 19:03:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS 218","ota_service_fee_amount":"0","commision_charges":"52.31","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"174.35","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962760","reservation_id":"72450","confirmation_number":"PB12373326937","room_stay_from":"2019-04-06","room_stay_to":"2019-04-16","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"149.97,132.02,132.02,132.02,132.02,132.02,149.97,149.97,132.02,132.02","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"1374.05","grand_total":"1552.67","paid_amount":"1552.67","room_type_id":"289","product_id":"1101","siteminder_id":"BDC-1172112422","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"180.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"83577","customer_id":"83577","source_of_creation":"Booking.com","reservation_created_date":"2019-03-19 00:11:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"118.06","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"132.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963083","reservation_id":"73031","confirmation_number":"PB12391748061","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"132.52,132.52,132.52,132.52,132.52,150.47","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"813.07","grand_total":"918.76","paid_amount":"918.76","room_type_id":"289","product_id":"1110","siteminder_id":"BDC-3215836463","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":"83973","customer_id":"83973","source_of_creation":"Booking.com","reservation_created_date":"2019-03-24 13:13:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"40.65","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"132.52","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963471","reservation_id":"74301","confirmation_number":"PB12315214807","room_stay_from":"2019-04-09","room_stay_to":"2019-04-10","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"142.71","nightly_discount":"0","subtotal":"142.71","grand_total":"161.26","paid_amount":"161.26","room_type_id":"289","product_id":"1095","siteminder_id":"BDC-3690660097","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":"84767","customer_id":"84767","source_of_creation":"Booking.com","reservation_created_date":"2019-04-08 18:01:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"21.41","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"142.71","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2962798","reservation_id":"73073","confirmation_number":"PB12375437661","room_stay_from":"2019-04-07","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"234.26,234.26,234.26,234.26,234.26","nightly_discount":"0,0,0,0,0","subtotal":"1171.30","grand_total":"1323.57","paid_amount":"1323.57","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1223889786","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":"84007","customer_id":"84007","source_of_creation":"Expedia","reservation_created_date":"2019-03-25 00:06:06","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"234.26","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963797","reservation_id":"71214","confirmation_number":"PB12346035616","room_stay_from":"2019-04-09","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.31,154.31","nightly_discount":"0,0","subtotal":"308.62","grand_total":"348.74","paid_amount":"348.74","room_type_id":"289","product_id":"1112","siteminder_id":"EXP-1212291851","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":"82844","customer_id":"82844","source_of_creation":"Expedia","reservation_created_date":"2019-03-07 20:29:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"154.31","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"2962660","reservation_id":"66172","confirmation_number":"PB12348063482","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.38,113.38,113.38,113.38,113.38,137.24","nightly_discount":"0,0,0,0,0,0","subtotal":"704.14","grand_total":"795.68","paid_amount":"795.68","room_type_id":"289","product_id":"1096","siteminder_id":"GAM-R1343807019","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":"79773","customer_id":"79773","source_of_creation":"Getaroom.com","reservation_created_date":"2019-01-10 02:12:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.38","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963228","reservation_id":"73082","confirmation_number":"PB12365478900","room_stay_from":"2019-04-08","room_stay_to":"2019-04-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.02,117.02","nightly_discount":"0,0","subtotal":"234.04","grand_total":"264.46","paid_amount":"264.46","room_type_id":"289","product_id":"1100","siteminder_id":"GAM-R1432883038","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":"84012","customer_id":"84012","source_of_creation":"Getaroom.com","reservation_created_date":"2019-03-25 01:13:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2962806","reservation_id":"67595","confirmation_number":"PB12381195519","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.25,185.25,185.25,185.25,185.25,222.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1149.00","grand_total":"1298.37","paid_amount":"1298.37","room_type_id":"291","product_id":"1119","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":"80786","customer_id":"80786","source_of_creation":"FE","reservation_created_date":"2019-01-23 07:45:37","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"185.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"133659","reservation_id":"51782","confirmation_number":"PB12386044088","room_stay_from":"2019-04-08","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.00,212.00,212.00","nightly_discount":"0.00,0.00,0.00","subtotal":"636.00","grand_total":"718.68","paid_amount":"718.68","room_type_id":"285","product_id":"1085","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":"72641","customer_id":"72641","source_of_creation":"PMS","reservation_created_date":"2018-07-22 16:02:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"212.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2936092","reservation_id":"69549","confirmation_number":"PB12316915740","room_stay_from":"2019-04-08","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"270.00,270.00,270.00","nightly_discount":"0.00,0.00,0.00","subtotal":"810.00","grand_total":"915.30","paid_amount":"915.30","room_type_id":"288","product_id":"1092","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":"61085","customer_id":"61085","source_of_creation":"PMS","reservation_created_date":"2019-02-15 23:49:58","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"270.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2943663","reservation_id":"65222","confirmation_number":"PB12337750752","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00,225.00,225.00,225.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"900.00","grand_total":"1017.00","paid_amount":"1017.00","room_type_id":"289","product_id":"1121","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":"56077","customer_id":"56077","source_of_creation":"PMS","reservation_created_date":"2019-01-02 19:16:31","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"225.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2943667","reservation_id":"65222","confirmation_number":"PB12396517669","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00,225.00,225.00,225.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"900.00","grand_total":"1017.00","paid_amount":"1017.00","room_type_id":"289","product_id":"1123","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":"56077","customer_id":"56077","source_of_creation":"PMS","reservation_created_date":"2019-01-02 19:16:31","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"225.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2952052","reservation_id":"72418","confirmation_number":"PB12368638338","room_stay_from":"2019-04-03","room_stay_to":"2019-04-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.91,143.91,143.91,143.91,143.91,143.91,143.91","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1007.37","grand_total":"1138.33","paid_amount":"1138.33","room_type_id":"289","product_id":"1109","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":"83556","customer_id":"83556","source_of_creation":"PMS","reservation_created_date":"2019-03-18 20:10:59","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961289","reservation_id":"51781","confirmation_number":"PB12358090891","room_stay_from":"2019-04-03","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"219.00,219.00,269.00,269.00,219.00,219.00,219.00,219.00,219.00,269.00","nightly_discount":"0.00,112.05,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2340.00","grand_total":"2517.59","paid_amount":"2517.59","room_type_id":"286","product_id":"1086","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":"25071","customer_id":"25071","source_of_creation":"PMS","reservation_created_date":"2018-07-22 15:58:29","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"219.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961320","reservation_id":"63677","confirmation_number":"PB12316568063","room_stay_from":"2019-04-02","room_stay_to":"2019-04-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,125.00,125.00,110.00,110.00,110.00,110.00","nightly_discount":"0.00,93.60,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1790.00","grand_total":"1916.93","paid_amount":"1916.93","room_type_id":"289","product_id":"1094","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":"77858","customer_id":"77858","source_of_creation":"PMS","reservation_created_date":"2018-12-17 22:40:00","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961727","reservation_id":"53672","confirmation_number":"PB12393235179","room_stay_from":"2019-04-05","room_stay_to":"2019-04-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"307.00,307.00,257.00,257.00,257.00,257.00,257.00,307.00,307.00,257.00,257.00,257.00,257.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,191.77,0.00","subtotal":"3541.00","grand_total":"3784.63","paid_amount":"3784.63","room_type_id":"287","product_id":"1089","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":"45153","customer_id":"45153","source_of_creation":"PMS","reservation_created_date":"2018-08-14 21:55:57","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"257.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962766","reservation_id":"57940","confirmation_number":"PB12397429376","room_stay_from":"2019-04-09","room_stay_to":"2019-04-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.00,212.00,212.00,212.00,212.00,212.00,212.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,74.00","subtotal":"1484.00","grand_total":"1593.30","paid_amount":"1593.30","room_type_id":"289","product_id":"1108","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":"69477","customer_id":"69477","source_of_creation":"PMS","reservation_created_date":"2018-10-09 18:03:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"212.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963921","reservation_id":"73971","confirmation_number":"PB12355569712","room_stay_from":"2019-04-09","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"180.28,180.28,180.28,216.19","nightly_discount":"0.00,31.24,0.00,0.00","subtotal":"757.03","grand_total":"820.15","paid_amount":"820.15","room_type_id":"291","product_id":"1117","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":"84571","customer_id":"84571","source_of_creation":"PMS","reservation_created_date":"2019-04-03 20:02:06","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"180.28","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2936091","reservation_id":"69549","confirmation_number":"PB12256827167","room_confirmation_number":"PB12316915740","room_stay_from":"2019-04-08","room_stay_to":"2019-04-11","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":"1780","service_quantity":"1","customer_traveller_id":"61085","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-02-15 23:49:58","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"61085","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962761","reservation_id":"72450","confirmation_number":"PB12225330318","room_confirmation_number":"PB12373326937","room_stay_from":"2019-04-06","room_stay_to":"2019-04-16","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"83577","product_attribute_values":"extra_person# ","reservation_created_date":"2019-04-06 16:52:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83577","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2898752","reservation_id":"51782","confirmation_number":"PBR12212616036","room_confirmation_number":"PB12386044088","room_stay_from":"2019-04-08","room_stay_to":"2019-04-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0,0,0","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"72641","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"72641","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2914142","reservation_id":"66091","confirmation_number":"PB12254802036","room_confirmation_number":"PB12345115197","room_stay_from":"2019-04-09","room_stay_to":"2019-04-11","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"79732","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-09 19:03:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79732","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2936093","reservation_id":"69549","confirmation_number":"PB12277380957","room_confirmation_number":"PB12316915740","room_stay_from":"2019-04-08","room_stay_to":"2019-04-11","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":"1781","service_quantity":"1","customer_traveller_id":"61085","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-02-15 23:49:58","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"61085","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2943664","reservation_id":"65222","confirmation_number":"PB12234725938","room_confirmation_number":"PB12337750752","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"56077","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-02 19:16:31","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56077","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2943668","reservation_id":"65222","confirmation_number":"PB12252817831","room_confirmation_number":"PB12396517669","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"56077","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-02 19:16:31","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56077","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2952053","reservation_id":"72418","confirmation_number":"PB12264837501","room_confirmation_number":"PB12368638338","room_stay_from":"2019-04-03","room_stay_to":"2019-04-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"83556","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-18 20:10:59","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83556","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961290","reservation_id":"51781","confirmation_number":"PBR12279195172","room_confirmation_number":"PB12358090891","room_stay_from":"2019-04-03","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"25071","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"25071","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961321","reservation_id":"63677","confirmation_number":"PBR12241826867","room_confirmation_number":"PB12316568063","room_stay_from":"2019-04-02","room_stay_to":"2019-04-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"192.00","grand_total":"216.96","paid_amount":"216.96","product_id":"1781","service_quantity":"1","customer_traveller_id":"77858","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77858","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2961728","reservation_id":"53672","confirmation_number":"PBR12239351295","room_confirmation_number":"PB12393235179","room_stay_from":"2019-04-05","room_stay_to":"2019-04-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"156.00","grand_total":"176.28","paid_amount":"176.28","product_id":"1781","service_quantity":"1","customer_traveller_id":"45153","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"45153","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962661","reservation_id":"66172","confirmation_number":"PB12283137855","room_confirmation_number":"PB12348063482","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"79773","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-10 02:12:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79773","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962762","reservation_id":"72450","confirmation_number":"PB12288857446","room_confirmation_number":"PB12373326937","room_stay_from":"2019-04-06","room_stay_to":"2019-04-16","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"83577","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-19 00:11:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83577","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962767","reservation_id":"57940","confirmation_number":"PBR12231360295","room_confirmation_number":"PB12397429376","room_stay_from":"2019-04-09","room_stay_to":"2019-04-16","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"69477","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"69477","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962799","reservation_id":"73073","confirmation_number":"PB12295719596","room_confirmation_number":"PB12375437661","room_stay_from":"2019-04-07","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"84007","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-25 00:06:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84007","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962807","reservation_id":"67595","confirmation_number":"PB12239572151","room_confirmation_number":"PB12381195519","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"80786","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-23 07:45:37","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80786","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963084","reservation_id":"73031","confirmation_number":"PB12216233764","room_confirmation_number":"PB12391748061","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"83973","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-24 13:13:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83973","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963229","reservation_id":"73082","confirmation_number":"PB12219289003","room_confirmation_number":"PB12365478900","room_stay_from":"2019-04-08","room_stay_to":"2019-04-10","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"84012","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-25 01:13:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84012","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963472","reservation_id":"74301","confirmation_number":"PB12279492721","room_confirmation_number":"PB12315214807","room_stay_from":"2019-04-09","room_stay_to":"2019-04-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"84767","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-08 18:01:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84767","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963798","reservation_id":"71214","confirmation_number":"PB12270831896","room_confirmation_number":"PB12346035616","room_stay_from":"2019-04-09","room_stay_to":"2019-04-11","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"82844","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-07 20:29:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82844","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963922","reservation_id":"73971","confirmation_number":"PB12297204146","room_confirmation_number":"PB12355569712","room_stay_from":"2019-04-09","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"84571","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-03 20:02:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84571","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":5,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2963132","reservation_id":"73794","confirmation_number":"BV12459686632","room_stay_from":"2019-04-09","room_stay_to":"2019-04-10","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"110.45","nightly_discount":"0","subtotal":"110.45","grand_total":"124.81","paid_amount":"124.81","room_type_id":"303","product_id":"1139","siteminder_id":"EXP-1228923521","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":"84446","customer_id":"84446","source_of_creation":"Expedia","reservation_created_date":"2019-04-01 14:51:07","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.45","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"2948529","reservation_id":"71832","confirmation_number":"BV12416829006","room_stay_from":"2019-04-06","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"118.35,101.78,101.78,101.78,101.78,101.78,118.35","nightly_discount":"0,0,0,0,0,0,0","subtotal":"745.60","grand_total":"842.53","paid_amount":"842.53","room_type_id":"303","product_id":"1140","siteminder_id":"GAM-R1417425738","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":"83175","customer_id":"83175","source_of_creation":"Getaroom.com","reservation_created_date":"2019-03-13 14:55:08","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"101.78","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2915405","reservation_id":"66402","confirmation_number":"BV12453615206","room_stay_from":"2019-03-22","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.40,242.00,192.00,192.00,192.00,192.00,192.00,242.00,242.00,134.40,134.40,134.40,134.40,134.40,169.40,169.40,134.40,134.40,134.40,134.40,134.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"3538.20","grand_total":"3998.16","paid_amount":"3998.16","room_type_id":"304","product_id":"1220","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":"68361","customer_id":"68361","source_of_creation":"FE","reservation_created_date":"2019-01-11 23:00:36","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2945524","reservation_id":"71252","confirmation_number":"BV12442927009","room_stay_from":"2019-04-09","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"156.00,156.00,156.00,193.50","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"661.50","grand_total":"747.50","paid_amount":"747.50","room_type_id":"309","product_id":"1226","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":"64769","customer_id":"64769","source_of_creation":"PMS","reservation_created_date":"2019-03-08 00:47:41","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"156.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2953223","reservation_id":"72643","confirmation_number":"BV12471362638","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"131.82,131.82,131.82,131.82","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"527.28","grand_total":"595.83","paid_amount":"595.83","room_type_id":"304","product_id":"1221","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":"83719","customer_id":"83719","source_of_creation":"PMS","reservation_created_date":"2019-03-21 01:16:00","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131.82","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2960606","reservation_id":"72643","confirmation_number":"BV12419746418","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"131.82,131.82,131.82,131.82","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"527.28","grand_total":"595.83","paid_amount":"595.83","room_type_id":"304","product_id":"1219","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":"83719","customer_id":"83719","source_of_creation":"PMS","reservation_created_date":"2019-03-21 01:16:00","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131.82","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2915406","reservation_id":"66402","confirmation_number":"BV12250631760","room_confirmation_number":"BV12453615206","room_stay_from":"2019-03-22","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"252.00","grand_total":"284.76","paid_amount":"284.76","product_id":"1781","service_quantity":"1","customer_traveller_id":"68361","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-11 23:00:36","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"68361","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2945525","reservation_id":"71252","confirmation_number":"BV12292414486","room_confirmation_number":"BV12442927009","room_stay_from":"2019-04-09","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"64769","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-08 00:47:41","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"64769","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2948530","reservation_id":"71832","confirmation_number":"BV12215193137","room_confirmation_number":"BV12416829006","room_stay_from":"2019-04-06","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"83175","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-13 14:55:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83175","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2953224","reservation_id":"72643","confirmation_number":"BV12281260059","room_confirmation_number":"BV12471362638","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","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":"1781","service_quantity":"1","customer_traveller_id":"83719","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-21 01:16:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83719","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2960607","reservation_id":"72643","confirmation_number":"BV12215895310","room_confirmation_number":"BV12419746418","room_stay_from":"2019-04-08","room_stay_to":"2019-04-12","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":"1781","service_quantity":"1","customer_traveller_id":"83719","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-21 01:16:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83719","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963133","reservation_id":"73794","confirmation_number":"BV12272581252","room_confirmation_number":"BV12459686632","room_stay_from":"2019-04-09","room_stay_to":"2019-04-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"84446","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-01 14:51:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84446","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":6,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2956227","reservation_id":"73162","confirmation_number":"BP12565403738","room_stay_from":"2019-04-05","room_stay_to":"2019-04-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.43,139.43,123.58,123.58,123.58","nightly_discount":"0,0,0,0,0","subtotal":"649.60","grand_total":"734.05","paid_amount":"734.05","room_type_id":"296","product_id":"1130","siteminder_id":"BDC-2696994434","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":"84079","customer_id":"84079","source_of_creation":"Booking.com","reservation_created_date":"2019-03-25 22:59:09","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"97.44","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"123.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2958730","reservation_id":"73530","confirmation_number":"BP12593715790","room_stay_from":"2019-04-09","room_stay_to":"2019-04-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.22,147.22","nightly_discount":"0,0","subtotal":"294.44","grand_total":"332.72","paid_amount":"332.72","room_type_id":"293","product_id":"1124","siteminder_id":"BDC-3254100762","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":"84316","customer_id":"84316","source_of_creation":"Booking.com","reservation_created_date":"2019-03-29 16:11:06","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"44.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"147.22","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"2963819","reservation_id":"74395","confirmation_number":"BP12557451627","room_stay_from":"2019-04-09","room_stay_to":"2019-04-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.93","nightly_discount":"0","subtotal":"69.93","grand_total":"79.03","paid_amount":"79.03","room_type_id":"299","product_id":"1134","siteminder_id":"HWR-300140052","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":"84841","customer_id":"84841","source_of_creation":"Hotwire","reservation_created_date":"2019-04-09 22:55:07","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.93","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2884452","reservation_id":"60025","confirmation_number":"BP12539543456","room_stay_from":"2019-04-08","room_stay_to":"2019-04-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.00,235.00,235.00,235.00,235.00,235.00,235.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1645.00","grand_total":"1858.85","paid_amount":"1858.85","room_type_id":"300","product_id":"1135","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":"76711","customer_id":"76711","source_of_creation":"PMS","reservation_created_date":"2018-11-10 03:09:25","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"235.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2952949","reservation_id":"72451","confirmation_number":"BP12592139058","room_stay_from":"2019-04-08","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.00,90.00,90.00,90.00,90.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"450.00","grand_total":"508.50","paid_amount":"508.50","room_type_id":"302","product_id":"1138","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":"44475","customer_id":"44475","source_of_creation":"PMS","reservation_created_date":"2019-03-19 00:18:46","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962832","reservation_id":"73470","confirmation_number":"BP12520999761","room_stay_from":"2019-04-07","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"133.72,133.72,133.72,133.72,133.72","nightly_discount":"36.56,0.00,0.00,0.00,0.00","subtotal":"668.60","grand_total":"714.20","paid_amount":"714.20","room_type_id":"294","product_id":"1125","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":"60569","customer_id":"60569","source_of_creation":"PMS","reservation_created_date":"2019-03-28 21:06:01","canceled_nights_data":"","product_name":"BP One Bedroom Suite 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"133.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963115","reservation_id":"64632","confirmation_number":"BP12565144420","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"192.00,192.00,192.00,192.00,192.00,242.00","nightly_discount":"0.00,0.00,0.00,0.00,55.19,72.00","subtotal":"1202.00","grand_total":"1214.54","paid_amount":"1214.54","room_type_id":"294","product_id":"1126","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":"56184","customer_id":"56184","source_of_creation":"PMS","reservation_created_date":"2019-04-07 13:20:33","canceled_nights_data":"","product_name":"BP One Bedroom Suite 1Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"192.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2898915","reservation_id":"60025","confirmation_number":"PBR12230788942","room_confirmation_number":"BP12539543456","room_stay_from":"2019-04-08","room_stay_to":"2019-04-15","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"76711","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76711","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2952950","reservation_id":"72451","confirmation_number":"BP12242840809","room_confirmation_number":"BP12592139058","room_stay_from":"2019-04-08","room_stay_to":"2019-04-13","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":"1781","service_quantity":"1","customer_traveller_id":"44475","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-19 00:18:46","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44475","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2956228","reservation_id":"73162","confirmation_number":"BP12234086409","room_confirmation_number":"BP12565403738","room_stay_from":"2019-04-05","room_stay_to":"2019-04-10","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"84079","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-25 22:59:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84079","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2958731","reservation_id":"73530","confirmation_number":"BP12278154359","room_confirmation_number":"BP12593715790","room_stay_from":"2019-04-09","room_stay_to":"2019-04-11","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"84316","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-29 16:11:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84316","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2962833","reservation_id":"73470","confirmation_number":"BP12283075446","room_confirmation_number":"BP12520999761","room_stay_from":"2019-04-07","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"60569","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-28 21:06:01","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"60569","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963116","reservation_id":"64632","confirmation_number":"BP12277395501","room_confirmation_number":"BP12565144420","room_stay_from":"2019-04-07","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"47.46","product_id":"1781","service_quantity":"1","customer_traveller_id":"56184","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-07 13:20:33","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56184","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2963820","reservation_id":"74395","confirmation_number":"BP12282821895","room_confirmation_number":"BP12557451627","room_stay_from":"2019-04-09","room_stay_to":"2019-04-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"84841","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-09 22:55:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84841","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}