{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2019-04-11","total_rooms_exist":66,"departureCount":12,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"0","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2940020","reservation_id":"66121","confirmation_number":"PB12335023819","room_stay_from":"2019-04-10","room_stay_to":"2019-04-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"153.90,153.90,186.30,186.30,153.90,153.90","nightly_discount":"0,0,0,0,0,0","subtotal":"988.20","grand_total":"1116.66","paid_amount":"1116.66","room_type_id":"289","product_id":"1099","siteminder_id":"BDC-1431810053","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":"79743","customer_id":"79743","source_of_creation":"Booking.com","reservation_created_date":"2019-01-09 21:14:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"148.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"153.90","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":"2951589","reservation_id":"72327","confirmation_number":"BV12433734554","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.22,127.07,127.07,111.22,111.22","nightly_discount":"0,0,0,0,0","subtotal":"587.80","grand_total":"664.22","paid_amount":"664.22","room_type_id":"305","product_id":"1222","siteminder_id":"BDC-2049526796","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":"83473","customer_id":"83473","source_of_creation":"Booking.com","reservation_created_date":"2019-03-17 22:55:09","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"88.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.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":"2953978","reservation_id":"72664","confirmation_number":"PB12342838159","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.87","nightly_discount":"0","subtotal":"203.87","grand_total":"230.37","paid_amount":"230.37","room_type_id":"289","product_id":"1100","siteminder_id":"BDC-3817034184","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":"83754","customer_id":"83754","source_of_creation":"Booking.com","reservation_created_date":"2019-03-21 04:16:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"30.58","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"203.87","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":"2962718","reservation_id":"74174","confirmation_number":"BP12545129809","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.22","nightly_discount":"0","subtotal":"147.22","grand_total":"166.36","paid_amount":"166.36","room_type_id":"299","product_id":"1134","siteminder_id":"BDC-3157650881","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":"84693","customer_id":"84693","source_of_creation":"Booking.com","reservation_created_date":"2019-04-06 16:14:10","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"22.08","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":"2963927","reservation_id":"74418","confirmation_number":"PB12317108510","room_stay_from":"2019-04-10","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"121.30,142.71","nightly_discount":"0,0","subtotal":"264.01","grand_total":"298.33","paid_amount":"298.33","room_type_id":"289","product_id":"1098","siteminder_id":"BDC-3224589246","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":"84862","customer_id":"84862","source_of_creation":"Booking.com","reservation_created_date":"2019-04-10 14:44:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"39.60","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"}]},{"room_stay_id":"2964678","reservation_id":"71771","confirmation_number":"PB12331482533","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"151.52","nightly_discount":"0","subtotal":"151.52","grand_total":"171.22","paid_amount":"171.22","room_type_id":"291","product_id":"1116","siteminder_id":"BDC-1633126501","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"210.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"83137","customer_id":"83137","source_of_creation":"Booking.com","reservation_created_date":"2019-03-12 18:09:10","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"27.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"151.52","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":"2951891","reservation_id":"72390","confirmation_number":"BP12590564040","room_stay_from":"2019-04-11","room_stay_to":"2019-04-14","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"120.72,140.71,140.71","nightly_discount":"0,0,0","subtotal":"402.14","grand_total":"454.42","paid_amount":"454.42","room_type_id":"298","product_id":"1133","siteminder_id":"EXP-1219560331","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":"83533","customer_id":"83533","source_of_creation":"Expedia","reservation_created_date":"2019-03-18 15:01:09","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.72","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":"2952350","reservation_id":"72491","confirmation_number":"PB12332323180","room_stay_from":"2019-04-11","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.87,231.50","nightly_discount":"0,0","subtotal":"435.37","grand_total":"491.97","paid_amount":"491.97","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1220236008","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":"83603","customer_id":"83603","source_of_creation":"Expedia","reservation_created_date":"2019-03-19 13:16:08","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":"203.87","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":"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":"2964430","reservation_id":"74521","confirmation_number":"BP12571159462","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.06","nightly_discount":"0","subtotal":"75.06","grand_total":"84.81","paid_amount":"84.81","room_type_id":"301","product_id":"1136","siteminder_id":"EXP-1235989276","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":"84923","customer_id":"84923","source_of_creation":"Expedia","reservation_created_date":"2019-04-11 21:16:09","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.06","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":[{"room_stay_id":"2945948","reservation_id":"71332","confirmation_number":"PB12356275265","room_stay_from":"2019-04-10","room_stay_to":"2019-04-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"121.11,121.11,121.11,121.11","nightly_discount":"0,0,0,0","subtotal":"484.44","grand_total":"547.42","paid_amount":"547.42","room_type_id":"285","product_id":"1084","siteminder_id":"HTN-78419717-WKJPDH","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":"82915","customer_id":"82915","source_of_creation":"HotelTonight","reservation_created_date":"2019-03-08 18:12:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"121.11","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"}]}],"htn_non_taxable":[],"pcl_taxable":[{"room_stay_id":"2952306","reservation_id":"72487","confirmation_number":"BV12444559615","room_stay_from":"2019-04-10","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"65.85,65.85,76.58","nightly_discount":"0,0,0","subtotal":"208.28","grand_total":"235.36","paid_amount":"235.36","room_type_id":"307","product_id":"1224","siteminder_id":"PCL-33585463","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":"83600","customer_id":"83600","source_of_creation":"Priceline.com","reservation_created_date":"2019-03-19 12:07:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"65.85","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":"2953308","reservation_id":"72665","confirmation_number":"BP12567200870","room_stay_from":"2019-04-10","room_stay_to":"2019-04-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.07,122.07,141.57,141.57","nightly_discount":"0,0,0,0","subtotal":"527.28","grand_total":"595.83","paid_amount":"595.83","room_type_id":"295","product_id":"1129","siteminder_id":"PCL-33597373","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":"83755","customer_id":"83755","source_of_creation":"Priceline.com","reservation_created_date":"2019-03-21 04:24:07","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"122.07","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"}]}],"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":"2949151","reservation_id":"71939","confirmation_number":"PB12347139496","room_stay_from":"2019-04-11","room_stay_to":"2019-04-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.63,157.42,157.42,138.63","nightly_discount":"0,0,0,0","subtotal":"592.10","grand_total":"669.08","paid_amount":"669.08","room_type_id":"289","product_id":"1107","siteminder_id":"GAM-R1419074806","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":"83241","customer_id":"83241","source_of_creation":"Getaroom.com","reservation_created_date":"2019-03-14 17:05:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.63","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":"2963063","reservation_id":"71938","confirmation_number":"PB12341351612","room_stay_from":"2019-04-11","room_stay_to":"2019-04-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.63,157.42,157.42,138.63","nightly_discount":"0,0,0,0","subtotal":"592.10","grand_total":"669.08","paid_amount":"669.08","room_type_id":"289","product_id":"1105","siteminder_id":"GAM-R1419074752","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":"83240","customer_id":"83240","source_of_creation":"Getaroom.com","reservation_created_date":"2019-03-14 17:05:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.63","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":"2964381","reservation_id":"72815","confirmation_number":"PB12399657388","room_stay_from":"2019-04-11","room_stay_to":"2019-04-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.04,110.19,110.19","nightly_discount":"0.00,0.00,0.00","subtotal":"317.42","grand_total":"358.69","paid_amount":"358.69","room_type_id":"289","product_id":"1109","siteminder_id":"GAM-R1429220121","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":"83865","customer_id":"83865","source_of_creation":"Getaroom.com","reservation_created_date":"2019-03-22 02:34:04","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":"97.04","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":"2964931","reservation_id":"74466","confirmation_number":"BP12538019444","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"45.25","nightly_discount":"0.00","subtotal":"45.25","grand_total":"51.14","paid_amount":"51.14","room_type_id":"296","product_id":"1130","siteminder_id":"GAM-R1455953930","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":"84857","customer_id":"84857","source_of_creation":"Getaroom.com","reservation_created_date":"2019-04-11 00:27:10","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"45.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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"2964576","reservation_id":"74445","confirmation_number":"BP12554250223","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.61","nightly_discount":"0","subtotal":"73.61","grand_total":"83.18","paid_amount":"83.18","room_type_id":"304","product_id":"1218","siteminder_id":"HWR-171729859","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":"84881","customer_id":"84881","source_of_creation":"Hotwire","reservation_created_date":"2019-04-10 20:49:08","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.61","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":"2945875","reservation_id":"71324","confirmation_number":"BV12487597152","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.50,174.00,174.00,136.50,136.50","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"757.50","grand_total":"855.98","paid_amount":"855.98","room_type_id":"303","product_id":"1139","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":"82907","customer_id":"82907","source_of_creation":"FE","reservation_created_date":"2019-03-08 16:59:20","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":"136.50","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":"2952026","reservation_id":"72411","confirmation_number":"BV12412870646","room_stay_from":"2019-04-10","room_stay_to":"2019-04-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.69,140.69,172.38,172.38,140.69,140.69,140.69,140.69,140.69","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1329.59","grand_total":"1502.44","paid_amount":"1502.44","room_type_id":"306","product_id":"1223","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":"64584","customer_id":"64584","source_of_creation":"FE","reservation_created_date":"2019-03-18 18:17:05","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"140.69","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":"96294","reservation_id":"30895","confirmation_number":"PB959328149","room_stay_from":"2019-04-10","room_stay_to":"2019-04-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"139.00,139.00,139.00,139.00,139.00,139.00,139.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"973.00","grand_total":"1099.49","paid_amount":"1099.49","room_type_id":"289","product_id":"1095","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":"23880","customer_id":"23880","source_of_creation":"PMS","reservation_created_date":"2018-04-11 16:10:21","canceled_nights_data":"","product_name":"107 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":"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":"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":"2907459","reservation_id":"64732","confirmation_number":"PB12392415045","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"290.00,340.00,340.00,290.00,290.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1550.00","grand_total":"1751.50","paid_amount":"1751.50","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47357","customer_id":"47357","source_of_creation":"PMS","reservation_created_date":"2018-12-29 21:51:42","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"290.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":"2947746","reservation_id":"71697","confirmation_number":"PB12379837408","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.00,185.00,185.00,185.00,185.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"925.00","grand_total":"1045.25","paid_amount":"1045.25","room_type_id":"289","product_id":"1112","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":"43188","customer_id":"43188","source_of_creation":"PMS","reservation_created_date":"2019-03-11 21:30:52","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":"185.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":"2952405","reservation_id":"72317","confirmation_number":"PB12389640096","room_stay_from":"2019-04-10","room_stay_to":"2019-04-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.00,124.00,124.00,124.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"496.00","grand_total":"560.48","paid_amount":"560.48","room_type_id":"289","product_id":"1111","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":"83466","customer_id":"83466","source_of_creation":"PMS","reservation_created_date":"2019-03-17 21:57:42","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.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":"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":"2962283","reservation_id":"74102","confirmation_number":"BP12578607588","room_stay_from":"2019-04-10","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.11,126.11","nightly_discount":"0.00,0.00","subtotal":"252.22","grand_total":"285.01","paid_amount":"285.01","room_type_id":"295","product_id":"1128","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":"84651","customer_id":"84651","source_of_creation":"PMS","reservation_created_date":"2019-04-05 16:33:10","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.11","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":"2962793","reservation_id":"74182","confirmation_number":"BP12566778366","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.86","nightly_discount":"0.00","subtotal":"143.86","grand_total":"162.56","paid_amount":"162.56","room_type_id":"294","product_id":"1127","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":"55918","customer_id":"55918","source_of_creation":"PMS","reservation_created_date":"2019-04-06 18:55:04","canceled_nights_data":"","product_name":"BP One Bedroom Suite 1Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.86","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":"55.19","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":"2963243","reservation_id":"72822","confirmation_number":"PB12335918865","room_stay_from":"2019-04-11","room_stay_to":"2019-04-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.00,122.00,122.00","nightly_discount":"0.00,0.00,0.00","subtotal":"366.00","grand_total":"413.58","paid_amount":"413.58","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":"83870","customer_id":"83870","source_of_creation":"PMS","reservation_created_date":"2019-03-22 12:07:39","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":"122.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":"2963653","reservation_id":"74347","confirmation_number":"PB12328481027","room_stay_from":"2019-04-10","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.10,146.10","nightly_discount":"0.00,0.00","subtotal":"292.20","grand_total":"330.18","paid_amount":"330.18","room_type_id":"291","product_id":"1118","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":"84012","customer_id":"84012","source_of_creation":"PMS","reservation_created_date":"2019-04-09 12:42:32","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"146.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":"2964064","reservation_id":"30683","confirmation_number":"PB930533339","room_stay_from":"2019-04-10","room_stay_to":"2019-04-17","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","nightly_discount":"48.65,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"973.00","grand_total":"1044.51","paid_amount":"1044.51","room_type_id":"289","product_id":"1106","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":"23244","customer_id":"23244","source_of_creation":"PMS","reservation_created_date":"2017-04-17 13:54:00","canceled_nights_data":"","product_name":"121 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.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":"2964066","reservation_id":"30959","confirmation_number":"PB971420748","room_stay_from":"2019-04-10","room_stay_to":"2019-04-17","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","nightly_discount":"48.65,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"973.00","grand_total":"1044.51","paid_amount":"1044.51","room_type_id":"289","product_id":"1104","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":"23244","customer_id":"23244","source_of_creation":"PMS","reservation_created_date":"2017-04-17 13:43:24","canceled_nights_data":"","product_name":"119 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.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":"2964248","reservation_id":"31010","confirmation_number":"PB979386156","room_stay_from":"2019-04-10","room_stay_to":"2019-04-17","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,75.41","subtotal":"1645.00","grand_total":"1773.64","paid_amount":"1773.64","room_type_id":"287","product_id":"1090","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":"52438","customer_id":"52438","source_of_creation":"PMS","reservation_created_date":"2018-04-25 13:12:32","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 217","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":"2964340","reservation_id":"74507","confirmation_number":"PB12375559521","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.87","nightly_discount":"0.00","subtotal":"135.87","grand_total":"153.53","paid_amount":"153.53","room_type_id":"285","product_id":"1083","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":"84915","customer_id":"84915","source_of_creation":"PMS","reservation_created_date":"2019-04-11 18:54:37","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"135.87","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":"2964574","reservation_id":"74536","confirmation_number":"PB12355533550","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"85.00","nightly_discount":"0.00","subtotal":"85.00","grand_total":"96.05","paid_amount":"96.05","room_type_id":"292","product_id":"1120","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":"84934","customer_id":"84934","source_of_creation":"PMS","reservation_created_date":"2019-04-12 00:05:03","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.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":"2964844","reservation_id":"62489","confirmation_number":"PB12337918028","room_stay_from":"2019-04-11","room_stay_to":"2019-04-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.00,145.00,145.00,145.00,145.00,145.00,145.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1015.00","grand_total":"1146.95","paid_amount":"1146.95","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":"24872","customer_id":"24872","source_of_creation":"PMS","reservation_created_date":"2018-12-05 18:55:32","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":"145.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":"2967357","reservation_id":"30171","confirmation_number":"BP936956134","room_stay_from":"2019-04-11","room_stay_to":"2019-04-19","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"249.00,249.00,249.00,249.00,249.00,249.00,399.00,262.00","nightly_discount":"125.80,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2155.00","grand_total":"2292.99","paid_amount":"2292.99","room_type_id":"297","product_id":"1132","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":"47417","customer_id":"47417","source_of_creation":"PMS","reservation_created_date":"2018-04-04 20:06:43","canceled_nights_data":"","product_name":"216 BP Deluxe Two Bedroom Suite","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"249.00","currentDayDiscount":"125.80","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":"2967695","reservation_id":"30171","confirmation_number":"BP979084781","room_stay_from":"2019-04-11","room_stay_to":"2019-04-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,199.00,199.00,199.00,199.00,199.00,199.00,199.00,398.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,107.46","subtotal":"1791.00","grand_total":"1902.40","paid_amount":"1902.40","room_type_id":"296","product_id":"1131","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":"47417","customer_id":"47417","source_of_creation":"PMS","reservation_created_date":"2018-04-04 20:08:43","canceled_nights_data":"","product_name":"109 BP Deluxe One Bedroom Suite","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"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":"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"}]},{"room_stay_id":"2967341","reservation_id":"30171","confirmation_number":"BP12214751921","room_confirmation_number":"BP936956134","room_stay_from":"2019-04-11","room_stay_to":"2019-04-19","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"47417","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-04-19 18:02:30","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47417","canceled_nights_data":"","currentDayPrice":"20","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"}]}],"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":"2905662","reservation_id":"30895","confirmation_number":"PB12347869803","room_confirmation_number":"PB959328149","room_stay_from":"2019-04-10","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","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":"23880","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-04-11 16:10:21","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23880","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":"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":"2907460","reservation_id":"64732","confirmation_number":"PB12243558955","room_confirmation_number":"PB12392415045","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","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":"47357","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-12-29 21:51:42","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47357","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":"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":"2940021","reservation_id":"66121","confirmation_number":"PB12293175061","room_confirmation_number":"PB12335023819","room_stay_from":"2019-04-10","room_stay_to":"2019-04-16","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":"79743","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-09 21:14:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79743","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":"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":"2945876","reservation_id":"71324","confirmation_number":"BV12248635184","room_confirmation_number":"BV12487597152","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","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":"82907","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-08 16:59:20","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82907","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":"2945949","reservation_id":"71332","confirmation_number":"PB12265534756","room_confirmation_number":"PB12356275265","room_stay_from":"2019-04-10","room_stay_to":"2019-04-14","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"82915","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-08 18:12:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82915","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":"2947747","reservation_id":"71697","confirmation_number":"PB12241703987","room_confirmation_number":"PB12379837408","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","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":"43188","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-11 21:30:52","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"43188","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":"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":"2949152","reservation_id":"71939","confirmation_number":"PB12246589912","room_confirmation_number":"PB12347139496","room_stay_from":"2019-04-11","room_stay_to":"2019-04-15","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"83241","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-14 17:05: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":"83241","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":"2951590","reservation_id":"72327","confirmation_number":"BV12230561497","room_confirmation_number":"BV12433734554","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","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":"83473","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-17 22:55: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":"83473","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":"2951892","reservation_id":"72390","confirmation_number":"BP12274430093","room_confirmation_number":"BP12590564040","room_stay_from":"2019-04-11","room_stay_to":"2019-04-14","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"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":"83533","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-18 15:01: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":"83533","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":"2952027","reservation_id":"72411","confirmation_number":"BV12257829451","room_confirmation_number":"BV12412870646","room_stay_from":"2019-04-10","room_stay_to":"2019-04-19","room_stay_status":"Active","nightly_price":"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","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"64584","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-18 18:17:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"64584","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":"2952307","reservation_id":"72487","confirmation_number":"BV12220851043","room_confirmation_number":"BV12444559615","room_stay_from":"2019-04-10","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"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":"83600","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-19 12:07: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":"83600","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":"2952351","reservation_id":"72491","confirmation_number":"PB12217056332","room_confirmation_number":"PB12332323180","room_stay_from":"2019-04-11","room_stay_to":"2019-04-13","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":"83603","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-19 13:16:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83603","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":"2952406","reservation_id":"72317","confirmation_number":"PB12222546263","room_confirmation_number":"PB12389640096","room_stay_from":"2019-04-10","room_stay_to":"2019-04-14","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":"83466","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-17 21:57:42","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83466","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":"2953309","reservation_id":"72665","confirmation_number":"BP12212215565","room_confirmation_number":"BP12567200870","room_stay_from":"2019-04-10","room_stay_to":"2019-04-14","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"83755","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-21 04:24: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":"83755","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":"2953979","reservation_id":"72664","confirmation_number":"PB12236670312","room_confirmation_number":"PB12342838159","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","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":"83754","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-21 04:16: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":"83754","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":"2962284","reservation_id":"74102","confirmation_number":"BP12278580450","room_confirmation_number":"BP12578607588","room_stay_from":"2019-04-10","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"84651","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-05 16:33:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84651","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":"2962719","reservation_id":"74174","confirmation_number":"BP12225762135","room_confirmation_number":"BP12545129809","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","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":"84693","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-06 16:14: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":"84693","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":"2962794","reservation_id":"74182","confirmation_number":"BP12271487145","room_confirmation_number":"BP12566778366","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"55918","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-06 18:55:04","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"55918","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":"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":"2963064","reservation_id":"71938","confirmation_number":"PB12281072853","room_confirmation_number":"PB12341351612","room_stay_from":"2019-04-11","room_stay_to":"2019-04-15","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"83240","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-14 17:05: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":"83240","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":"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":"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":"2963244","reservation_id":"72822","confirmation_number":"PB12252685612","room_confirmation_number":"PB12335918865","room_stay_from":"2019-04-11","room_stay_to":"2019-04-14","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"83870","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-22 12:07:39","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83870","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":"2963654","reservation_id":"74347","confirmation_number":"PB12240448557","room_confirmation_number":"PB12328481027","room_stay_from":"2019-04-10","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"84012","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-09 12:42:32","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84012","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":"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":"2963928","reservation_id":"74418","confirmation_number":"PB12221488648","room_confirmation_number":"PB12317108510","room_stay_from":"2019-04-10","room_stay_to":"2019-04-12","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":"84862","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-10 14:44: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":"84862","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":"2964065","reservation_id":"30683","confirmation_number":"PB12314116433","room_confirmation_number":"PB930533339","room_stay_from":"2019-04-10","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23244","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2017-04-17 13:54:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23244","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":"2964067","reservation_id":"30959","confirmation_number":"PB12316290952","room_confirmation_number":"PB971420748","room_stay_from":"2019-04-10","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23244","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2017-04-17 13:43:24","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23244","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":"2964249","reservation_id":"31010","confirmation_number":"PB12326010092","room_confirmation_number":"PB979386156","room_stay_from":"2019-04-10","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"52438","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-04-25 13:12:32","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"52438","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":"2964341","reservation_id":"74507","confirmation_number":"PB12251402345","room_confirmation_number":"PB12375559521","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"84915","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-11 18:54:37","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84915","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":"2964382","reservation_id":"72815","confirmation_number":"PB12274203890","room_confirmation_number":"PB12399657388","room_stay_from":"2019-04-11","room_stay_to":"2019-04-14","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,3.36","subtotal":"60.00","grand_total":"64.00","paid_amount":"64.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"83865","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-22 02:34:04","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83865","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":"2964431","reservation_id":"74521","confirmation_number":"BP12251003768","room_confirmation_number":"BP12571159462","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","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":"84923","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-11 21:16: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":"84923","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":"2964575","reservation_id":"74536","confirmation_number":"PB12288583191","room_confirmation_number":"PB12355533550","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"84934","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-12 00:05:03","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84934","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":"2964577","reservation_id":"74445","confirmation_number":"BP12243247215","room_confirmation_number":"BP12554250223","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","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":"84881","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-10 20:49:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84881","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":"2964680","reservation_id":"71771","confirmation_number":"PB12290020825","room_confirmation_number":"PB12331482533","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","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":"83137","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-12 18:09: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":"83137","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":"2964845","reservation_id":"62489","confirmation_number":"PBR12294220121","room_confirmation_number":"PB12337918028","room_stay_from":"2019-04-11","room_stay_to":"2019-04-18","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24872","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":"24872","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":"2964932","reservation_id":"74466","confirmation_number":"BP12236368352","room_confirmation_number":"BP12538019444","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"84857","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-11 00:27:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84857","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":"2967358","reservation_id":"30171","confirmation_number":"BP12546267732","room_confirmation_number":"BP936956134","room_stay_from":"2019-04-11","room_stay_to":"2019-04-19","room_stay_status":"Active","nightly_price":"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","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"47417","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-04-04 20:06:43","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47417","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":"2967696","reservation_id":"30171","confirmation_number":"BP12532906937","room_confirmation_number":"BP979084781","room_stay_from":"2019-04-11","room_stay_to":"2019-04-20","room_stay_status":"Active","nightly_price":"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","subtotal":"108.00","grand_total":"122.04","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"47417","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-04-04 20:08:43","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47417","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":"2970039","reservation_id":"74527","confirmation_number":"PB12291847118","room_confirmation_number":"PB12340693308","room_stay_from":"2019-04-24","room_stay_to":"2019-04-26","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":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"84927","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-11 22:31: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":"84927","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"2964580","reservation_id":"74445","confirmation_number":"BV12274088699","room_confirmation_number":"BP12554250223","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-04-12 00:11:33","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"84881","parentCustTravId":"84881","customer_traveller_id":"84881","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2964271","reservation_id":"74488","confirmation_number":"PB12217963644","room_confirmation_number":"PB12351504303","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"4","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2019-04-11 14:31:54","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"2964286","reservation_id":"74493","confirmation_number":"PB12259084107","room_confirmation_number":"PB12371688660","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2019-04-11 15:41:29","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"2964302","reservation_id":"74496","confirmation_number":"PB12225301849","room_confirmation_number":"PB12368759663","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.20","grand_total":"4.49","paid_amount":"4.49","product_id":null,"service_quantity":"1","product_name":"Coffee Mug","parentTypeOfRes":"reservation","reservation_created_date":"2019-04-11 16:10:40","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"2964326","reservation_id":"74502","confirmation_number":"PB12232304453","room_confirmation_number":"PB12346866404","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"22.60","paid_amount":"22.60","product_id":null,"service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-04-11 18:08:41","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2964707","reservation_id":"74552","confirmation_number":"PB12237850470","room_confirmation_number":"PB12380160210","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.80","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Computer 15 Minutes","parentTypeOfRes":"reservation","reservation_created_date":"2019-04-12 03:37:30","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"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":7,"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":"2940020","reservation_id":"66121","confirmation_number":"PB12335023819","room_stay_from":"2019-04-10","room_stay_to":"2019-04-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"153.90,153.90,186.30,186.30,153.90,153.90","nightly_discount":"0,0,0,0,0,0","subtotal":"988.20","grand_total":"1116.66","paid_amount":"1116.66","room_type_id":"289","product_id":"1099","siteminder_id":"BDC-1431810053","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":"79743","customer_id":"79743","source_of_creation":"Booking.com","reservation_created_date":"2019-01-09 21:14:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"148.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"153.90","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":"2953978","reservation_id":"72664","confirmation_number":"PB12342838159","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.87","nightly_discount":"0","subtotal":"203.87","grand_total":"230.37","paid_amount":"230.37","room_type_id":"289","product_id":"1100","siteminder_id":"BDC-3817034184","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":"83754","customer_id":"83754","source_of_creation":"Booking.com","reservation_created_date":"2019-03-21 04:16:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"30.58","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"203.87","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":"2963927","reservation_id":"74418","confirmation_number":"PB12317108510","room_stay_from":"2019-04-10","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"121.30,142.71","nightly_discount":"0,0","subtotal":"264.01","grand_total":"298.33","paid_amount":"298.33","room_type_id":"289","product_id":"1098","siteminder_id":"BDC-3224589246","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":"84862","customer_id":"84862","source_of_creation":"Booking.com","reservation_created_date":"2019-04-10 14:44:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"39.60","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"}]},{"room_stay_id":"2964678","reservation_id":"71771","confirmation_number":"PB12331482533","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"151.52","nightly_discount":"0","subtotal":"151.52","grand_total":"171.22","paid_amount":"171.22","room_type_id":"291","product_id":"1116","siteminder_id":"BDC-1633126501","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"210.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"83137","customer_id":"83137","source_of_creation":"Booking.com","reservation_created_date":"2019-03-12 18:09:10","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"27.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"151.52","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":"2952350","reservation_id":"72491","confirmation_number":"PB12332323180","room_stay_from":"2019-04-11","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.87,231.50","nightly_discount":"0,0","subtotal":"435.37","grand_total":"491.97","paid_amount":"491.97","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1220236008","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":"83603","customer_id":"83603","source_of_creation":"Expedia","reservation_created_date":"2019-03-19 13:16:08","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":"203.87","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":"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"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"2945948","reservation_id":"71332","confirmation_number":"PB12356275265","room_stay_from":"2019-04-10","room_stay_to":"2019-04-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"121.11,121.11,121.11,121.11","nightly_discount":"0,0,0,0","subtotal":"484.44","grand_total":"547.42","paid_amount":"547.42","room_type_id":"285","product_id":"1084","siteminder_id":"HTN-78419717-WKJPDH","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":"82915","customer_id":"82915","source_of_creation":"HotelTonight","reservation_created_date":"2019-03-08 18:12:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"121.11","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"}]}],"htn_non_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"2949151","reservation_id":"71939","confirmation_number":"PB12347139496","room_stay_from":"2019-04-11","room_stay_to":"2019-04-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.63,157.42,157.42,138.63","nightly_discount":"0,0,0,0","subtotal":"592.10","grand_total":"669.08","paid_amount":"669.08","room_type_id":"289","product_id":"1107","siteminder_id":"GAM-R1419074806","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":"83241","customer_id":"83241","source_of_creation":"Getaroom.com","reservation_created_date":"2019-03-14 17:05:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.63","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":"2963063","reservation_id":"71938","confirmation_number":"PB12341351612","room_stay_from":"2019-04-11","room_stay_to":"2019-04-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.63,157.42,157.42,138.63","nightly_discount":"0,0,0,0","subtotal":"592.10","grand_total":"669.08","paid_amount":"669.08","room_type_id":"289","product_id":"1105","siteminder_id":"GAM-R1419074752","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":"83240","customer_id":"83240","source_of_creation":"Getaroom.com","reservation_created_date":"2019-03-14 17:05:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.63","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":"2964381","reservation_id":"72815","confirmation_number":"PB12399657388","room_stay_from":"2019-04-11","room_stay_to":"2019-04-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.04,110.19,110.19","nightly_discount":"0.00,0.00,0.00","subtotal":"317.42","grand_total":"358.69","paid_amount":"358.69","room_type_id":"289","product_id":"1109","siteminder_id":"GAM-R1429220121","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":"83865","customer_id":"83865","source_of_creation":"Getaroom.com","reservation_created_date":"2019-03-22 02:34:04","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":"97.04","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"}]}],"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":"2907459","reservation_id":"64732","confirmation_number":"PB12392415045","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"290.00,340.00,340.00,290.00,290.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1550.00","grand_total":"1751.50","paid_amount":"1751.50","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47357","customer_id":"47357","source_of_creation":"PMS","reservation_created_date":"2018-12-29 21:51:42","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"290.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":"2947746","reservation_id":"71697","confirmation_number":"PB12379837408","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.00,185.00,185.00,185.00,185.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"925.00","grand_total":"1045.25","paid_amount":"1045.25","room_type_id":"289","product_id":"1112","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":"43188","customer_id":"43188","source_of_creation":"PMS","reservation_created_date":"2019-03-11 21:30:52","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":"185.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":"2952405","reservation_id":"72317","confirmation_number":"PB12389640096","room_stay_from":"2019-04-10","room_stay_to":"2019-04-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.00,124.00,124.00,124.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"496.00","grand_total":"560.48","paid_amount":"560.48","room_type_id":"289","product_id":"1111","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":"83466","customer_id":"83466","source_of_creation":"PMS","reservation_created_date":"2019-03-17 21:57:42","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.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":"2963243","reservation_id":"72822","confirmation_number":"PB12335918865","room_stay_from":"2019-04-11","room_stay_to":"2019-04-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.00,122.00,122.00","nightly_discount":"0.00,0.00,0.00","subtotal":"366.00","grand_total":"413.58","paid_amount":"413.58","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":"83870","customer_id":"83870","source_of_creation":"PMS","reservation_created_date":"2019-03-22 12:07:39","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":"122.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":"2963653","reservation_id":"74347","confirmation_number":"PB12328481027","room_stay_from":"2019-04-10","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.10,146.10","nightly_discount":"0.00,0.00","subtotal":"292.20","grand_total":"330.18","paid_amount":"330.18","room_type_id":"291","product_id":"1118","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":"84012","customer_id":"84012","source_of_creation":"PMS","reservation_created_date":"2019-04-09 12:42:32","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"146.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":"2964340","reservation_id":"74507","confirmation_number":"PB12375559521","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.87","nightly_discount":"0.00","subtotal":"135.87","grand_total":"153.53","paid_amount":"153.53","room_type_id":"285","product_id":"1083","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":"84915","customer_id":"84915","source_of_creation":"PMS","reservation_created_date":"2019-04-11 18:54:37","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"135.87","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":"2964574","reservation_id":"74536","confirmation_number":"PB12355533550","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"85.00","nightly_discount":"0.00","subtotal":"85.00","grand_total":"96.05","paid_amount":"96.05","room_type_id":"292","product_id":"1120","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":"84934","customer_id":"84934","source_of_creation":"PMS","reservation_created_date":"2019-04-12 00:05:03","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.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":"2964844","reservation_id":"62489","confirmation_number":"PB12337918028","room_stay_from":"2019-04-11","room_stay_to":"2019-04-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.00,145.00,145.00,145.00,145.00,145.00,145.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1015.00","grand_total":"1146.95","paid_amount":"1146.95","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":"24872","customer_id":"24872","source_of_creation":"PMS","reservation_created_date":"2018-12-05 18:55:32","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":"145.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_taxable":[{"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":"2907460","reservation_id":"64732","confirmation_number":"PB12243558955","room_confirmation_number":"PB12392415045","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","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":"47357","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-12-29 21:51:42","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47357","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":"2940021","reservation_id":"66121","confirmation_number":"PB12293175061","room_confirmation_number":"PB12335023819","room_stay_from":"2019-04-10","room_stay_to":"2019-04-16","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":"79743","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-09 21:14:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79743","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":"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":"2945949","reservation_id":"71332","confirmation_number":"PB12265534756","room_confirmation_number":"PB12356275265","room_stay_from":"2019-04-10","room_stay_to":"2019-04-14","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"82915","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-08 18:12:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82915","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":"2947747","reservation_id":"71697","confirmation_number":"PB12241703987","room_confirmation_number":"PB12379837408","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","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":"43188","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-11 21:30:52","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"43188","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":"2949152","reservation_id":"71939","confirmation_number":"PB12246589912","room_confirmation_number":"PB12347139496","room_stay_from":"2019-04-11","room_stay_to":"2019-04-15","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"83241","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-14 17:05: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":"83241","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":"2952351","reservation_id":"72491","confirmation_number":"PB12217056332","room_confirmation_number":"PB12332323180","room_stay_from":"2019-04-11","room_stay_to":"2019-04-13","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":"83603","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-19 13:16:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83603","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":"2952406","reservation_id":"72317","confirmation_number":"PB12222546263","room_confirmation_number":"PB12389640096","room_stay_from":"2019-04-10","room_stay_to":"2019-04-14","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":"83466","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-17 21:57:42","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83466","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":"2953979","reservation_id":"72664","confirmation_number":"PB12236670312","room_confirmation_number":"PB12342838159","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","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":"83754","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-21 04:16: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":"83754","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":"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":"2963064","reservation_id":"71938","confirmation_number":"PB12281072853","room_confirmation_number":"PB12341351612","room_stay_from":"2019-04-11","room_stay_to":"2019-04-15","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"83240","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-14 17:05: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":"83240","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":"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":"2963244","reservation_id":"72822","confirmation_number":"PB12252685612","room_confirmation_number":"PB12335918865","room_stay_from":"2019-04-11","room_stay_to":"2019-04-14","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"83870","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-22 12:07:39","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83870","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":"2963654","reservation_id":"74347","confirmation_number":"PB12240448557","room_confirmation_number":"PB12328481027","room_stay_from":"2019-04-10","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"84012","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-09 12:42:32","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84012","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":"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":"2963928","reservation_id":"74418","confirmation_number":"PB12221488648","room_confirmation_number":"PB12317108510","room_stay_from":"2019-04-10","room_stay_to":"2019-04-12","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":"84862","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-10 14:44: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":"84862","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":"2964341","reservation_id":"74507","confirmation_number":"PB12251402345","room_confirmation_number":"PB12375559521","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"84915","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-11 18:54:37","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84915","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":"2964382","reservation_id":"72815","confirmation_number":"PB12274203890","room_confirmation_number":"PB12399657388","room_stay_from":"2019-04-11","room_stay_to":"2019-04-14","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,3.36","subtotal":"60.00","grand_total":"64.00","paid_amount":"64.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"83865","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-22 02:34:04","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83865","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":"2964575","reservation_id":"74536","confirmation_number":"PB12288583191","room_confirmation_number":"PB12355533550","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"84934","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-12 00:05:03","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84934","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":"2964680","reservation_id":"71771","confirmation_number":"PB12290020825","room_confirmation_number":"PB12331482533","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","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":"83137","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-12 18:09: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":"83137","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":"2964845","reservation_id":"62489","confirmation_number":"PBR12294220121","room_confirmation_number":"PB12337918028","room_stay_from":"2019-04-11","room_stay_to":"2019-04-18","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24872","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":"24872","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":"2970039","reservation_id":"74527","confirmation_number":"PB12291847118","room_confirmation_number":"PB12340693308","room_stay_from":"2019-04-24","room_stay_to":"2019-04-26","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":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"84927","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-11 22:31: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":"84927","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"2964271","reservation_id":"74488","confirmation_number":"PB12217963644","room_confirmation_number":"PB12351504303","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"4","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2019-04-11 14:31:54","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"2964286","reservation_id":"74493","confirmation_number":"PB12259084107","room_confirmation_number":"PB12371688660","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2019-04-11 15:41:29","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"2964302","reservation_id":"74496","confirmation_number":"PB12225301849","room_confirmation_number":"PB12368759663","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.20","grand_total":"4.49","paid_amount":"4.49","product_id":null,"service_quantity":"1","product_name":"Coffee Mug","parentTypeOfRes":"reservation","reservation_created_date":"2019-04-11 16:10:40","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"2964326","reservation_id":"74502","confirmation_number":"PB12232304453","room_confirmation_number":"PB12346866404","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"22.60","paid_amount":"22.60","product_id":null,"service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-04-11 18:08:41","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2964707","reservation_id":"74552","confirmation_number":"PB12237850470","room_confirmation_number":"PB12380160210","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.80","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"1","product_name":"Computer 15 Minutes","parentTypeOfRes":"reservation","reservation_created_date":"2019-04-12 03:37:30","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"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":0,"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":"2951589","reservation_id":"72327","confirmation_number":"BV12433734554","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.22,127.07,127.07,111.22,111.22","nightly_discount":"0,0,0,0,0","subtotal":"587.80","grand_total":"664.22","paid_amount":"664.22","room_type_id":"305","product_id":"1222","siteminder_id":"BDC-2049526796","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":"83473","customer_id":"83473","source_of_creation":"Booking.com","reservation_created_date":"2019-03-17 22:55:09","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"88.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.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_non_taxable":[],"pcl_taxable":[{"room_stay_id":"2952306","reservation_id":"72487","confirmation_number":"BV12444559615","room_stay_from":"2019-04-10","room_stay_to":"2019-04-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"65.85,65.85,76.58","nightly_discount":"0,0,0","subtotal":"208.28","grand_total":"235.36","paid_amount":"235.36","room_type_id":"307","product_id":"1224","siteminder_id":"PCL-33585463","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":"83600","customer_id":"83600","source_of_creation":"Priceline.com","reservation_created_date":"2019-03-19 12:07:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"65.85","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"}]}],"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"}]},{"room_stay_id":"2945875","reservation_id":"71324","confirmation_number":"BV12487597152","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.50,174.00,174.00,136.50,136.50","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"757.50","grand_total":"855.98","paid_amount":"855.98","room_type_id":"303","product_id":"1139","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":"82907","customer_id":"82907","source_of_creation":"FE","reservation_created_date":"2019-03-08 16:59:20","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":"136.50","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":"2952026","reservation_id":"72411","confirmation_number":"BV12412870646","room_stay_from":"2019-04-10","room_stay_to":"2019-04-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.69,140.69,172.38,172.38,140.69,140.69,140.69,140.69,140.69","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1329.59","grand_total":"1502.44","paid_amount":"1502.44","room_type_id":"306","product_id":"1223","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":"64584","customer_id":"64584","source_of_creation":"FE","reservation_created_date":"2019-03-18 18:17:05","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"140.69","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":"2945876","reservation_id":"71324","confirmation_number":"BV12248635184","room_confirmation_number":"BV12487597152","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","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":"82907","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-08 16:59:20","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82907","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":"2951590","reservation_id":"72327","confirmation_number":"BV12230561497","room_confirmation_number":"BV12433734554","room_stay_from":"2019-04-11","room_stay_to":"2019-04-16","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":"83473","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-17 22:55: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":"83473","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":"2952027","reservation_id":"72411","confirmation_number":"BV12257829451","room_confirmation_number":"BV12412870646","room_stay_from":"2019-04-10","room_stay_to":"2019-04-19","room_stay_status":"Active","nightly_price":"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","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"64584","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-03-18 18:17:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"64584","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":"2952307","reservation_id":"72487","confirmation_number":"BV12220851043","room_confirmation_number":"BV12444559615","room_stay_from":"2019-04-10","room_stay_to":"2019-04-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"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":"83600","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-19 12:07: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":"83600","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"}]}],"resort_fee_non_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":5,"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":"2962718","reservation_id":"74174","confirmation_number":"BP12545129809","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.22","nightly_discount":"0","subtotal":"147.22","grand_total":"166.36","paid_amount":"166.36","room_type_id":"299","product_id":"1134","siteminder_id":"BDC-3157650881","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":"84693","customer_id":"84693","source_of_creation":"Booking.com","reservation_created_date":"2019-04-06 16:14:10","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"22.08","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_taxable":[{"room_stay_id":"2951891","reservation_id":"72390","confirmation_number":"BP12590564040","room_stay_from":"2019-04-11","room_stay_to":"2019-04-14","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"120.72,140.71,140.71","nightly_discount":"0,0,0","subtotal":"402.14","grand_total":"454.42","paid_amount":"454.42","room_type_id":"298","product_id":"1133","siteminder_id":"EXP-1219560331","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":"83533","customer_id":"83533","source_of_creation":"Expedia","reservation_created_date":"2019-03-18 15:01:09","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.72","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":"2964430","reservation_id":"74521","confirmation_number":"BP12571159462","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.06","nightly_discount":"0","subtotal":"75.06","grand_total":"84.81","paid_amount":"84.81","room_type_id":"301","product_id":"1136","siteminder_id":"EXP-1235989276","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":"84923","customer_id":"84923","source_of_creation":"Expedia","reservation_created_date":"2019-04-11 21:16:09","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.06","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_non_taxable":[],"pcl_taxable":[{"room_stay_id":"2953308","reservation_id":"72665","confirmation_number":"BP12567200870","room_stay_from":"2019-04-10","room_stay_to":"2019-04-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.07,122.07,141.57,141.57","nightly_discount":"0,0,0,0","subtotal":"527.28","grand_total":"595.83","paid_amount":"595.83","room_type_id":"295","product_id":"1129","siteminder_id":"PCL-33597373","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":"83755","customer_id":"83755","source_of_creation":"Priceline.com","reservation_created_date":"2019-03-21 04:24:07","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"122.07","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"}]}],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"2964931","reservation_id":"74466","confirmation_number":"BP12538019444","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"45.25","nightly_discount":"0.00","subtotal":"45.25","grand_total":"51.14","paid_amount":"51.14","room_type_id":"296","product_id":"1130","siteminder_id":"GAM-R1455953930","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":"84857","customer_id":"84857","source_of_creation":"Getaroom.com","reservation_created_date":"2019-04-11 00:27:10","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"45.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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"2964576","reservation_id":"74445","confirmation_number":"BP12554250223","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.61","nightly_discount":"0","subtotal":"73.61","grand_total":"83.18","paid_amount":"83.18","room_type_id":"304","product_id":"1218","siteminder_id":"HWR-171729859","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":"84881","customer_id":"84881","source_of_creation":"Hotwire","reservation_created_date":"2019-04-10 20:49:08","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.61","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":"2962283","reservation_id":"74102","confirmation_number":"BP12578607588","room_stay_from":"2019-04-10","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.11,126.11","nightly_discount":"0.00,0.00","subtotal":"252.22","grand_total":"285.01","paid_amount":"285.01","room_type_id":"295","product_id":"1128","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":"84651","customer_id":"84651","source_of_creation":"PMS","reservation_created_date":"2019-04-05 16:33:10","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.11","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":"2962793","reservation_id":"74182","confirmation_number":"BP12566778366","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.86","nightly_discount":"0.00","subtotal":"143.86","grand_total":"162.56","paid_amount":"162.56","room_type_id":"294","product_id":"1127","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":"55918","customer_id":"55918","source_of_creation":"PMS","reservation_created_date":"2019-04-06 18:55:04","canceled_nights_data":"","product_name":"BP One Bedroom Suite 1Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.86","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":"55.19","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":"2951892","reservation_id":"72390","confirmation_number":"BP12274430093","room_confirmation_number":"BP12590564040","room_stay_from":"2019-04-11","room_stay_to":"2019-04-14","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"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":"83533","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-18 15:01: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":"83533","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":"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":"2953309","reservation_id":"72665","confirmation_number":"BP12212215565","room_confirmation_number":"BP12567200870","room_stay_from":"2019-04-10","room_stay_to":"2019-04-14","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"83755","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-03-21 04:24: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":"83755","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":"2962284","reservation_id":"74102","confirmation_number":"BP12278580450","room_confirmation_number":"BP12578607588","room_stay_from":"2019-04-10","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"84651","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-05 16:33:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84651","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":"2962719","reservation_id":"74174","confirmation_number":"BP12225762135","room_confirmation_number":"BP12545129809","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","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":"84693","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-06 16:14: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":"84693","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":"2962794","reservation_id":"74182","confirmation_number":"BP12271487145","room_confirmation_number":"BP12566778366","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"55918","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-04-06 18:55:04","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"55918","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":"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":"2964431","reservation_id":"74521","confirmation_number":"BP12251003768","room_confirmation_number":"BP12571159462","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","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":"84923","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-11 21:16: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":"84923","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":"2964577","reservation_id":"74445","confirmation_number":"BP12243247215","room_confirmation_number":"BP12554250223","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","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":"84881","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-10 20:49:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84881","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":"2964932","reservation_id":"74466","confirmation_number":"BP12236368352","room_confirmation_number":"BP12538019444","room_stay_from":"2019-04-11","room_stay_to":"2019-04-12","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"84857","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-11 00:27:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84857","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"2964580","reservation_id":"74445","confirmation_number":"BV12274088699","room_confirmation_number":"BP12554250223","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-04-12 00:11:33","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"84881","parentCustTravId":"84881","customer_traveller_id":"84881","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}