{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2019-01-05","total_rooms_exist":66,"departureCount":22,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"2","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2908769","reservation_id":"64669","confirmation_number":"BV12494305673","room_stay_from":"2019-01-03","room_stay_to":"2019-01-07","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"97.81,112.32,112.32,101.56","nightly_discount":"0,0,0,0","subtotal":"424.01","grand_total":"479.13","paid_amount":"479.13","room_type_id":"304","product_id":"1220","siteminder_id":"BDC-1293666967","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79095","customer_id":"79095","source_of_creation":"Booking.com","reservation_created_date":"2018-12-29 13:41:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"63.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"112.32","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":"2909046","reservation_id":"65095","confirmation_number":"PB12350573763","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"95.47,95.47,111.89,111.89","nightly_discount":"0,0,0,0","subtotal":"414.72","grand_total":"468.63","paid_amount":"468.63","room_type_id":"289","product_id":"1102","siteminder_id":"BDC-1002386324","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":"79255","customer_id":"79255","source_of_creation":"Booking.com","reservation_created_date":"2019-01-01 19:20:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"62.21","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.89","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":"2909349","reservation_id":"65033","confirmation_number":"BV12493382396","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.81,112.32,112.32","nightly_discount":"0.00,0.00,0.00","subtotal":"322.45","grand_total":"341.80","paid_amount":"364.37","room_type_id":"304","product_id":"1221","siteminder_id":"BDC-1026627407","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":"79224","customer_id":"79224","source_of_creation":"Booking.com","reservation_created_date":"2019-01-01 05:36:15","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"42.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"112.32","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910123","reservation_id":"65337","confirmation_number":"PB12378552559","room_stay_from":"2019-01-03","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.89,128.30,128.30,116.21,116.21,116.21","nightly_discount":"0,0,0,0,0,0","subtotal":"717.12","grand_total":"810.35","paid_amount":"810.35","room_type_id":"291","product_id":"1114","siteminder_id":"BDC-1134712172","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":"79374","customer_id":"79374","source_of_creation":"Booking.com","reservation_created_date":"2019-01-03 14:49:14","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"107.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"128.30","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":"2910223","reservation_id":"65367","confirmation_number":"PB12315935378","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.62","nightly_discount":"0","subtotal":"141.62","grand_total":"160.03","paid_amount":"160.03","room_type_id":"286","product_id":"1086","siteminder_id":"BDC-1911714142","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":"79393","customer_id":"79393","source_of_creation":"Booking.com","reservation_created_date":"2019-01-03 19:57:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"21.24","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"141.62","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":"2910790","reservation_id":"65469","confirmation_number":"BV12423331123","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.96","nightly_discount":"0","subtotal":"120.96","grand_total":"136.69","paid_amount":"136.69","room_type_id":"304","product_id":"1219","siteminder_id":"BDC-1124678678","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":"79443","customer_id":"79443","source_of_creation":"Booking.com","reservation_created_date":"2019-01-04 16:47:11","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"18.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.96","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":"2911346","reservation_id":"64796","confirmation_number":"PB12336608691","room_stay_from":"2019-01-05","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"107.14,95.04,95.04,95.04","nightly_discount":"0,0,0,0","subtotal":"392.26","grand_total":"443.26","paid_amount":"443.26","room_type_id":"292","product_id":"1120","siteminder_id":"BDC-1800087513","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79137","customer_id":"79137","source_of_creation":"Booking.com","reservation_created_date":"2018-12-30 04:06:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS 218","ota_service_fee_amount":"0","commision_charges":"58.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"107.14","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":"2911386","reservation_id":"64315","confirmation_number":"PB12377250827","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"95.47,95.47,111.89,111.89","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"414.72","grand_total":"468.63","paid_amount":"468.63","room_type_id":"289","product_id":"1100","siteminder_id":"BDC-1412738243","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"78970","customer_id":"78970","source_of_creation":"Booking.com","reservation_created_date":"2018-12-26 18:33:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"62.21","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.89","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911395","reservation_id":"64151","confirmation_number":"PB12330819377","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"111.38,130.54,130.54","nightly_discount":"0.00,0.00,0.00","subtotal":"372.46","grand_total":"420.88","paid_amount":"420.88","room_type_id":"289","product_id":"1098","siteminder_id":"BDC-1819309475","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":"78908","customer_id":"78908","source_of_creation":"Booking.com","reservation_created_date":"2018-12-24 19:21:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"55.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.54","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911402","reservation_id":"64804","confirmation_number":"PB12332336916","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"130.54,130.54","nightly_discount":"0.00,0.00","subtotal":"261.08","grand_total":"295.02","paid_amount":"295.02","room_type_id":"289","product_id":"1099","siteminder_id":"BDC-1717744506","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79143","customer_id":"79143","source_of_creation":"Booking.com","reservation_created_date":"2018-12-30 15:30:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"39.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.54","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911516","reservation_id":"64671","confirmation_number":"BV12440444588","room_stay_from":"2019-01-04","room_stay_to":"2019-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.87,109.87,98.28","nightly_discount":"0,0,0","subtotal":"318.02","grand_total":"359.36","paid_amount":"359.36","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-1253407742","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79098","customer_id":"79098","source_of_creation":"Booking.com","reservation_created_date":"2018-12-29 13:53:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"47.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"109.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":"2911933","reservation_id":"65621","confirmation_number":"BP12554628334","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.14","nightly_discount":"0","subtotal":"107.14","grand_total":"121.07","paid_amount":"121.07","room_type_id":"294","product_id":"1127","siteminder_id":"BDC-1358817948","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":"79513","customer_id":"79513","source_of_creation":"Booking.com","reservation_created_date":"2019-01-05 18:01:11","canceled_nights_data":"","product_name":"BP One Bedroom Suite 1Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"16.07","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"107.14","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":"2912040","reservation_id":"65673","confirmation_number":"PB12364297908","room_stay_from":"2019-01-05","room_stay_to":"2019-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.71,152.71","nightly_discount":"0,0","subtotal":"305.42","grand_total":"345.13","paid_amount":"345.13","room_type_id":"288","product_id":"1091","siteminder_id":"BDC-1098666556","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":"79535","customer_id":"79535","source_of_creation":"Booking.com","reservation_created_date":"2019-01-05 22:11:10","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"22.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"152.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":"2913421","reservation_id":"65260","confirmation_number":"PB12366420675","room_stay_from":"2019-01-05","room_stay_to":"2019-01-08","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"130.54,116.42,116.42","nightly_discount":"0.00,0.00,0.00","subtotal":"363.38","grand_total":"410.62","paid_amount":"410.62","room_type_id":"289","product_id":"1106","siteminder_id":"BDC-2066320214","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"90.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79350","customer_id":"79350","source_of_creation":"Booking.com","reservation_created_date":"2019-01-02 21:29:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"54.51","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.54","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2910602","reservation_id":"65454","confirmation_number":"BP12525432306","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"129.77","nightly_discount":"0","subtotal":"129.77","grand_total":"146.64","paid_amount":"146.64","room_type_id":"302","product_id":"1138","siteminder_id":"EXP-1173379097","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":"79431","customer_id":"79431","source_of_creation":"Expedia","reservation_created_date":"2019-01-04 13:00:13","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":"129.77","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":"2911072","reservation_id":"65530","confirmation_number":"PB12355191306","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"117.81,117.81","nightly_discount":"0,0","subtotal":"235.62","grand_total":"266.25","paid_amount":"266.26","room_type_id":"291","product_id":"1116","siteminder_id":"EXP-1173650356","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79467","customer_id":"79467","source_of_creation":"Expedia","reservation_created_date":"2019-01-04 21:35:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.81","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":"2911348","reservation_id":"64641","confirmation_number":"PB12392305224","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"107.04","nightly_discount":"0","subtotal":"107.04","grand_total":"120.95","paid_amount":"120.95","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1170166674","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79084","customer_id":"79084","source_of_creation":"Expedia","reservation_created_date":"2018-12-29 01:10:08","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":"107.04","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":"2911356","reservation_id":"63657","confirmation_number":"BV12460195323","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.63","nightly_discount":"0","subtotal":"108.63","grand_total":"122.75","paid_amount":"122.75","room_type_id":"304","product_id":"1218","siteminder_id":"EXP-1164815480","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":"78656","customer_id":"78656","source_of_creation":"Expedia","reservation_created_date":"2018-12-17 16:05:12","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":"108.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":"2911482","reservation_id":"62792","confirmation_number":"PB12342995915","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.19,104.38,104.38,122.33,122.33","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"569.61","grand_total":"643.66","paid_amount":"643.66","room_type_id":"289","product_id":"1097","siteminder_id":"EXP-1159510132","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":"78395","customer_id":"78395","source_of_creation":"Expedia","reservation_created_date":"2018-12-06 13:15:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"122.33","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911519","reservation_id":"64131","confirmation_number":"PB12376407487","room_stay_from":"2019-01-05","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.95,80.20,80.20,80.20","nightly_discount":"0,0,0,0","subtotal":"331.55","grand_total":"374.65","paid_amount":"374.65","room_type_id":"287","product_id":"1089","siteminder_id":"EXP-1168102296","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":"78902","customer_id":"78902","source_of_creation":"Expedia","reservation_created_date":"2018-12-24 17:40:08","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":"90.95","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":"2911581","reservation_id":"65623","confirmation_number":"PB12369335423","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.94","nightly_discount":"0","subtotal":"97.94","grand_total":"110.68","paid_amount":"110.68","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1174085256","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":"79514","customer_id":"79514","source_of_creation":"Expedia","reservation_created_date":"2019-01-05 18:05:11","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":"97.94","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":"2909792","reservation_id":"65255","confirmation_number":"PB12379564214","room_stay_from":"2019-01-05","room_stay_to":"2019-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"49.63,49.63","nightly_discount":"0,0","subtotal":"99.25","grand_total":"112.16","paid_amount":"112.16","room_type_id":"289","product_id":"1101","siteminder_id":"HTN-72480058-DX9FX6","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":"79346","customer_id":"79346","source_of_creation":"HotelTonight","reservation_created_date":"2019-01-02 21:12:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"49.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":"2910909","reservation_id":"65496","confirmation_number":"PB12348253518","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.04,60.04","nightly_discount":"0,0","subtotal":"120.07","grand_total":"135.67","paid_amount":"135.68","room_type_id":"289","product_id":"1107","siteminder_id":"HTN-72665382-CPQKXM","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":"79455","customer_id":"79455","source_of_creation":"HotelTonight","reservation_created_date":"2019-01-04 19:17: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":"60.04","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":"2911837","reservation_id":"64330","confirmation_number":"PB12324988363","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.86","nightly_discount":"0.00","subtotal":"62.86","grand_total":"71.03","paid_amount":"71.03","room_type_id":"285","product_id":"1084","siteminder_id":"HTN-71720995","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"78976","customer_id":"78976","source_of_creation":"HotelTonight","reservation_created_date":"2018-12-26 20:55:12","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":"62.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":"2911886","reservation_id":"65708","confirmation_number":"PB12345931062","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.45","nightly_discount":"0","subtotal":"64.45","grand_total":"72.83","paid_amount":"72.83","room_type_id":"289","product_id":"1108","siteminder_id":"HTN-72793407-H9ZVD3","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":"79545","customer_id":"79545","source_of_creation":"HotelTonight","reservation_created_date":"2019-01-06 02:08:12","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":"64.45","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[{"room_stay_id":"2911533","reservation_id":"65609","confirmation_number":"BV12470949613","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"82.94","nightly_discount":"0.00","subtotal":"82.94","grand_total":"93.73","paid_amount":"93.73","room_type_id":"305","product_id":"1222","siteminder_id":"PCL-33094193","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":"79507","customer_id":"79507","source_of_creation":"Priceline.com","reservation_created_date":"2019-01-05 15:58:09","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"82.94","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2910801","reservation_id":"65471","confirmation_number":"BP12539954275","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.40,75.40","nightly_discount":"0,0","subtotal":"150.80","grand_total":"170.41","paid_amount":"170.41","room_type_id":"295","product_id":"1128","siteminder_id":"GAM-R1338277951","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":"79444","customer_id":"79444","source_of_creation":"Getaroom.com","reservation_created_date":"2019-01-04 17:00:11","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":"75.40","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":"2911304","reservation_id":"65591","confirmation_number":"PB12337532019","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.47","nightly_discount":"0","subtotal":"126.47","grand_total":"142.91","paid_amount":"142.91","room_type_id":"287","product_id":"1087","siteminder_id":"GAM-R1339067807","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":"79492","customer_id":"79492","source_of_creation":"Getaroom.com","reservation_created_date":"2019-01-05 06:42:09","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":"126.47","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"2909100","reservation_id":"65109","confirmation_number":"BP12552568202","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.44","nightly_discount":"0","subtotal":"73.44","grand_total":"82.99","paid_amount":"82.99","room_type_id":"299","product_id":"1134","siteminder_id":"HWR-171239179","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":"79265","customer_id":"79265","source_of_creation":"Hotwire","reservation_created_date":"2019-01-01 20:16:08","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.44","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":"2911541","reservation_id":"65603","confirmation_number":"PB12326321199","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.03","nightly_discount":"0","subtotal":"80.03","grand_total":"90.43","paid_amount":"90.43","room_type_id":"289","product_id":"1123","siteminder_id":"HWR-171253165","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":"79502","customer_id":"79502","source_of_creation":"Hotwire","reservation_created_date":"2019-01-05 15:12:10","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":"80.03","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":"2910526","reservation_id":"65447","confirmation_number":"BV12467011292","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.80,124.80","nightly_discount":"0.00,0.00","subtotal":"249.60","grand_total":"282.05","paid_amount":"282.05","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":"79425","customer_id":"79425","source_of_creation":"FE","reservation_created_date":"2019-01-04 03:08:35","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2915595","reservation_id":"65419","confirmation_number":"PB12365308537","room_stay_from":"2019-01-04","room_stay_to":"2019-01-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.40,102.40,104.00,104.00,104.00,104.00,104.00,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1036.80","grand_total":"1171.59","paid_amount":"1171.59","room_type_id":"289","product_id":"1105","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":"65816","customer_id":"65816","source_of_creation":"FE","reservation_created_date":"2019-01-04 00:51:35","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":"102.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2876331","reservation_id":"58096","confirmation_number":"PB12315576038","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.00,134.00,134.00,134.00,134.00,134.00,184.00,184.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1222.00","grand_total":"1380.86","paid_amount":"1380.86","room_type_id":"289","product_id":"1110","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":"75908","customer_id":"75908","source_of_creation":"PMS","reservation_created_date":"2018-10-12 16:00:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"184.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2876334","reservation_id":"58098","confirmation_number":"PB12360697642","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"184.00,134.00,134.00,134.00,134.00,134.00,184.00,184.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1222.00","grand_total":"1380.86","paid_amount":"1380.86","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":"75908","customer_id":"75908","source_of_creation":"PMS","reservation_created_date":"2018-10-12 16:04:38","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":"184.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2876337","reservation_id":"58099","confirmation_number":"PB12313882951","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.00,134.00,134.00,134.00,134.00,134.00,184.00,184.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1222.00","grand_total":"1380.86","paid_amount":"1380.86","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":"75909","customer_id":"75909","source_of_creation":"PMS","reservation_created_date":"2018-10-12 16:07:57","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":"184.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2905141","reservation_id":"30738","confirmation_number":"PB938814659","room_stay_from":"2018-12-26","room_stay_to":"2019-01-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.00,134.00,134.00,134.00,134.00,134.00,134.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,46.90,0.00,0.00,0.00,0.00,0.00,0.00,38.50,0.00,0.00,0.00,0.00,0.00,0.00,0.00,44.00","subtotal":"2588.00","grand_total":"2778.22","paid_amount":"2778.22","room_type_id":"289","product_id":"1109","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"69127","customer_id":"69127","source_of_creation":"PMS","reservation_created_date":"2018-02-28 21:58:13","canceled_nights_data":"","product_name":"207 PB Deluxe Efficiency Suite","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":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2907921","reservation_id":"64844","confirmation_number":"PB12361017668","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"287","product_id":"1088","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":"26469","customer_id":"26469","source_of_creation":"PMS","reservation_created_date":"2018-12-30 20:20:48","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","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"}]},{"room_stay_id":"2909602","reservation_id":"65202","confirmation_number":"PB12374716681","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"112.00","nightly_discount":"0.00","subtotal":"112.00","grand_total":"126.56","paid_amount":"126.56","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":"47798","customer_id":"47798","source_of_creation":"PMS","reservation_created_date":"2019-01-02 17:34:20","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":"112.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":"2910866","reservation_id":"65484","confirmation_number":"BV12477319840","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00","nightly_discount":"0.00,0.00","subtotal":"228.00","grand_total":"257.64","paid_amount":"257.64","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":"50159","customer_id":"50159","source_of_creation":"PMS","reservation_created_date":"2019-01-04 18:19:24","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":"114.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":"2911362","reservation_id":"60558","confirmation_number":"BP12560117727","room_stay_from":"2019-01-05","room_stay_to":"2019-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,109.00","nightly_discount":"0.00,0.00","subtotal":"268.00","grand_total":"302.84","paid_amount":"302.84","room_type_id":"298","product_id":"1133","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":"29376","customer_id":"29376","source_of_creation":"PMS","reservation_created_date":"2018-11-17 15:02:24","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":"159.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":"2911448","reservation_id":"65464","confirmation_number":"PB12362056767","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00","nightly_discount":"7.58,0.00","subtotal":"112.00","grand_total":"118.00","paid_amount":"118.00","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":"52357","customer_id":"52357","source_of_creation":"PMS","reservation_created_date":"2019-01-04 16:23:03","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"112.00","currentDayDiscount":"7.58","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911492","reservation_id":"49336","confirmation_number":"PB12395178081","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.00,134.00,134.00,134.00,134.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"938.00","grand_total":"1059.94","paid_amount":"1059.94","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":"71320","customer_id":"71320","source_of_creation":"PMS","reservation_created_date":"2018-06-18 19:55:30","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.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":"2911494","reservation_id":"49336","confirmation_number":"PB12321287513","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.00,184.00,184.00,134.00,134.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1038.00","grand_total":"1172.94","paid_amount":"1172.94","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":"71320","customer_id":"71320","source_of_creation":"PMS","reservation_created_date":"2018-06-18 19:55:31","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"184.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":"2911498","reservation_id":"49336","confirmation_number":"PB12333738962","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.00,184.00,184.00,134.00,134.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1038.00","grand_total":"1172.94","paid_amount":"1172.94","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":"71320","customer_id":"71320","source_of_creation":"PMS","reservation_created_date":"2018-06-18 19:55:32","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"184.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":"2911510","reservation_id":"64676","confirmation_number":"BP12528088497","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.60,84.00,84.00,81.60,81.60,81.60,81.60","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"568.00","grand_total":"641.84","paid_amount":"641.84","room_type_id":"295","product_id":"1129","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":"79102","customer_id":"79102","source_of_creation":"PMS","reservation_created_date":"2018-12-29 15:08:33","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":"84.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":"2911565","reservation_id":"56578","confirmation_number":"BP12569141751","room_stay_from":"2019-01-05","room_stay_to":"2019-02-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,73.85,105.00","subtotal":"3675.00","grand_total":"3950.65","paid_amount":"3950.65","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":"26029","customer_id":"26029","source_of_creation":"PMS","reservation_created_date":"2018-09-18 15:03:54","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":"105.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":"2911577","reservation_id":"60896","confirmation_number":"BP12513723366","room_stay_from":"2019-01-05","room_stay_to":"2019-01-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"182.00,132.00,132.00,132.00,132.00,132.00,182.00,182.00,132.00,132.00,132.00,132.00,132.00,182.00,182.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,130.43,0.00","subtotal":"2230.00","grand_total":"2372.51","paid_amount":"2372.51","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":"33409","customer_id":"33409","source_of_creation":"PMS","reservation_created_date":"2018-11-21 23:40:22","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"182.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":"2911717","reservation_id":"65645","confirmation_number":"PB12325382823","room_stay_from":"2019-01-05","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"151.00,151.00,151.00,151.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"604.00","grand_total":"682.52","paid_amount":"682.52","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":"79520","customer_id":"79520","source_of_creation":"PMS","reservation_created_date":"2019-01-05 19:41:09","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"151.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":"2911738","reservation_id":"65665","confirmation_number":"BV12423138674","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00","nightly_discount":"0.00","subtotal":"130.00","grand_total":"146.90","paid_amount":"146.90","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":"79530","customer_id":"79530","source_of_creation":"PMS","reservation_created_date":"2019-01-05 21:06:53","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":"130.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":"2911927","reservation_id":"65722","confirmation_number":"PB12323879396","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.00","nightly_discount":"0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","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":"79467","customer_id":"79467","source_of_creation":"PMS","reservation_created_date":"2019-01-06 03:48:54","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":"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":"2912514","reservation_id":"65477","confirmation_number":"BV12488119491","room_stay_from":"2019-01-04","room_stay_to":"2019-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"312.00","grand_total":"352.56","paid_amount":"352.56","room_type_id":"307","product_id":"1224","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":"79447","customer_id":"79447","source_of_creation":"PMS","reservation_created_date":"2019-01-04 17:45:53","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":"78.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":"2914555","reservation_id":"65524","confirmation_number":"BP12527268259","room_stay_from":"2019-01-05","room_stay_to":"2019-01-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.49,75.49,75.49,75.49,75.49,75.49,75.49","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"528.43","grand_total":"597.13","paid_amount":"597.13","room_type_id":"293","product_id":"1124","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":"79466","customer_id":"79466","source_of_creation":"PMS","reservation_created_date":"2019-01-04 21:02:13","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.49","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2926683","reservation_id":"63996","confirmation_number":"BV12497687505","room_stay_from":"2019-01-03","room_stay_to":"2019-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65","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":"1630.65","grand_total":"1842.64","paid_amount":"1842.64","room_type_id":"303","product_id":"1140","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":"78851","customer_id":"78851","source_of_creation":"PMS","reservation_created_date":"2018-12-22 16:57:22","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":"77.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2934470","reservation_id":"30562","confirmation_number":"PB916443308","room_stay_from":"2019-01-03","room_stay_to":"2019-03-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43","nightly_discount":"87.11,87.11,87.11,87.11,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,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,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":"7146.09","grand_total":"7681.35","paid_amount":"7681.35","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":"23037","customer_id":"23037","source_of_creation":"PMS","reservation_created_date":"2018-02-17 23:01:53","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":"113.43","currentDayDiscount":"87.11","productIsTaxExempt":false,"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":"2911073","reservation_id":"65530","confirmation_number":"PB12251349026","room_confirmation_number":"PB12355191306","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"79467","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-01-04 21:35: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":"79467","canceled_nights_data":"","currentDayPrice":"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":"2911389","reservation_id":"64151","confirmation_number":"PB12230822704","room_confirmation_number":"PB12330819377","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"30,30,30","nightly_discount":"0.00,0.00,0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1780","service_quantity":"1","customer_traveller_id":"78908","product_attribute_values":"extra_person# ","reservation_created_date":"2019-01-05 14:04:18","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78908","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"60.00","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911398","reservation_id":"64804","confirmation_number":"PB12298803363","room_confirmation_number":"PB12332336916","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"79143","product_attribute_values":"extra_person# ","reservation_created_date":"2019-01-05 14:16:40","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79143","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"20.00","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":"2911535","reservation_id":"65609","confirmation_number":"BV12235212755","room_confirmation_number":"BV12470949613","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"79507","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-01-05 17:10:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79507","canceled_nights_data":"","currentDayPrice":"10","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":"2911340","reservation_id":"64832","confirmation_number":"PB12225300726","room_confirmation_number":"PB12369545502","room_stay_from":"2019-01-04","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"77323","product_attribute_values":"extra_person# ","reservation_created_date":"2019-01-05 12:20:49","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77323","canceled_nights_data":"","changedComment":"Reservation created for complete past date","deltaChange":"20.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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2898863","reservation_id":"58096","confirmation_number":"PBR12229201566","room_confirmation_number":"PB12315576038","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","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,0,0,0,0,0,0,0","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"75908","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":"75908","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2898864","reservation_id":"58098","confirmation_number":"PBR12268181066","room_confirmation_number":"PB12360697642","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","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,0,0,0,0,0,0,0","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"75908","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":"75908","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2898865","reservation_id":"58099","confirmation_number":"PBR12289079923","room_confirmation_number":"PB12313882951","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","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,0,0,0,0,0,0,0","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"75909","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":"75909","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2905625","reservation_id":"30738","confirmation_number":"PB12369587397","room_confirmation_number":"PB938814659","room_stay_from":"2018-12-26","room_stay_to":"2019-01-17","room_stay_status":"Active","nightly_price":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","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,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"69127","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-02-28 21:58:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"69127","canceled_nights_data":"","currentDayPrice":"0","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2907922","reservation_id":"64844","confirmation_number":"PB12249422606","room_confirmation_number":"PB12361017668","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","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":"26469","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-12-30 20:20:48","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26469","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":"2908770","reservation_id":"64669","confirmation_number":"BV12281041751","room_confirmation_number":"BV12494305673","room_stay_from":"2019-01-03","room_stay_to":"2019-01-07","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":"79095","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-29 13:41: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":"79095","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":"2909047","reservation_id":"65095","confirmation_number":"PB12244169648","room_confirmation_number":"PB12350573763","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","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":"79255","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-01 19:20:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79255","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":"2909101","reservation_id":"65109","confirmation_number":"BP12279952907","room_confirmation_number":"BP12552568202","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79265","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-01 20: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":"79265","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":"2909351","reservation_id":"65033","confirmation_number":"BV12232434950","room_confirmation_number":"BV12493382396","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","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":"79224","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-01 05:36:15","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79224","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":"2909603","reservation_id":"65202","confirmation_number":"PB12266743246","room_confirmation_number":"PB12374716681","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"47798","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-02 17:34:20","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","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":"2909793","reservation_id":"65255","confirmation_number":"PB12279649868","room_confirmation_number":"PB12379564214","room_stay_from":"2019-01-05","room_stay_to":"2019-01-07","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":"79346","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-02 21:12:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79346","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":"2910124","reservation_id":"65337","confirmation_number":"PB12299631203","room_confirmation_number":"PB12378552559","room_stay_from":"2019-01-03","room_stay_to":"2019-01-09","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":"79374","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-03 14:49: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":"79374","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":"2910224","reservation_id":"65367","confirmation_number":"PB12278355206","room_confirmation_number":"PB12315935378","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79393","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-03 19:57:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79393","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":"2910527","reservation_id":"65447","confirmation_number":"BV12217944438","room_confirmation_number":"BV12467011292","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","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":"79425","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-04 03:08:35","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79425","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":"2910603","reservation_id":"65454","confirmation_number":"BP12287960183","room_confirmation_number":"BP12525432306","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79431","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-04 13:00:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79431","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":"2910791","reservation_id":"65469","confirmation_number":"BV12264349348","room_confirmation_number":"BV12423331123","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79443","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-04 16:47: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":"79443","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":"2910802","reservation_id":"65471","confirmation_number":"BP12219242418","room_confirmation_number":"BP12539954275","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","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":"79444","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-04 17:00:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79444","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":"2910867","reservation_id":"65484","confirmation_number":"BV12216725397","room_confirmation_number":"BV12477319840","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","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":"50159","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-04 18:19:24","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"50159","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":"2910910","reservation_id":"65496","confirmation_number":"PB12215133929","room_confirmation_number":"PB12348253518","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","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.19","product_id":"1781","service_quantity":"1","customer_traveller_id":"79455","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-04 19:17: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":"79455","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":"2911074","reservation_id":"65530","confirmation_number":"PB12287282243","room_confirmation_number":"PB12355191306","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","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.19","product_id":"1781","service_quantity":"1","customer_traveller_id":"79467","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-04 21:35: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":"79467","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":"2911305","reservation_id":"65591","confirmation_number":"PB12255896927","room_confirmation_number":"PB12337532019","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79492","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-05 06:42: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":"79492","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":"2911347","reservation_id":"64796","confirmation_number":"PB12228994843","room_confirmation_number":"PB12336608691","room_stay_from":"2019-01-05","room_stay_to":"2019-01-09","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":"79137","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-30 04:06: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":"79137","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":"2911349","reservation_id":"64641","confirmation_number":"PB12298586046","room_confirmation_number":"PB12392305224","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79084","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-29 01:10: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":"79084","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":"2911357","reservation_id":"63657","confirmation_number":"PBR12236424379","room_confirmation_number":"BV12460195323","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"78656","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":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78656","canceled_nights_data":"","currentDayPrice":"20.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":"2911363","reservation_id":"60558","confirmation_number":"PBR12231659403","room_confirmation_number":"BP12560117727","room_stay_from":"2019-01-05","room_stay_to":"2019-01-07","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":"29376","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":"29376","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":"2911387","reservation_id":"64315","confirmation_number":"PB12294991886","room_confirmation_number":"PB12377250827","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","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":"78970","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-26 18:33: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":"78970","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":"2911396","reservation_id":"64151","confirmation_number":"PB12227649305","room_confirmation_number":"PB12330819377","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","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":"78908","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-24 19:21: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":"78908","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":"2911403","reservation_id":"64804","confirmation_number":"PB12297021648","room_confirmation_number":"PB12332336916","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","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":"79143","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-30 15:30:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79143","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":"2911449","reservation_id":"65464","confirmation_number":"PB12279333326","room_confirmation_number":"PB12362056767","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"52357","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-04 16:23:03","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"52357","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":"2911483","reservation_id":"62792","confirmation_number":"PBR12279524923","room_confirmation_number":"PB12342995915","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","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":"78395","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":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78395","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":"2911493","reservation_id":"49336","confirmation_number":"PBR12279492377","room_confirmation_number":"PB12395178081","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","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":"71320","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"2018-06-18 19:55:30","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71320","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":"2911495","reservation_id":"49336","confirmation_number":"PBR12278630843","room_confirmation_number":"PB12321287513","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","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":"71320","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"2018-06-18 19:55:30","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71320","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":"2911499","reservation_id":"49336","confirmation_number":"PBR12238759839","room_confirmation_number":"PB12333738962","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","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":"71320","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":"71320","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":"2911511","reservation_id":"64676","confirmation_number":"BP12288954208","room_confirmation_number":"BP12528088497","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"79102","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-12-29 15:08:33","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79102","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":"2911517","reservation_id":"64671","confirmation_number":"BV12267518541","room_confirmation_number":"BV12440444588","room_stay_from":"2019-01-04","room_stay_to":"2019-01-07","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":"79098","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-29 13:53: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":"79098","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":"2911520","reservation_id":"64131","confirmation_number":"PB12211311465","room_confirmation_number":"PB12376407487","room_stay_from":"2019-01-05","room_stay_to":"2019-01-09","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":"78902","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-24 17:40: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":"78902","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":"2911536","reservation_id":"65609","confirmation_number":"BV12220090027","room_confirmation_number":"BV12470949613","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79507","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-05 15:58: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":"79507","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":"2911542","reservation_id":"65603","confirmation_number":"PB12289774473","room_confirmation_number":"PB12326321199","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79502","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-05 15:12: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":"79502","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":"2911578","reservation_id":"60896","confirmation_number":"PBR12239928137","room_confirmation_number":"BP12513723366","room_stay_from":"2019-01-05","room_stay_to":"2019-01-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,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","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"33409","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":"33409","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":"2911582","reservation_id":"65623","confirmation_number":"PB12258755761","room_confirmation_number":"PB12369335423","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79514","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-05 18:05:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79514","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":"2911718","reservation_id":"65645","confirmation_number":"PB12291593279","room_confirmation_number":"PB12325382823","room_stay_from":"2019-01-05","room_stay_to":"2019-01-09","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":"79520","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-05 19:41:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79520","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":"2911739","reservation_id":"65665","confirmation_number":"BV12211338595","room_confirmation_number":"BV12423138674","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79530","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-05 21:06:53","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79530","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":"2911838","reservation_id":"64330","confirmation_number":"PB12251751000","room_confirmation_number":"PB12324988363","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"78976","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-26 20:55:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78976","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":"2911887","reservation_id":"65708","confirmation_number":"PB12272835187","room_confirmation_number":"PB12345931062","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79545","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-06 02:08:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79545","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":"2911928","reservation_id":"65722","confirmation_number":"PB12253805265","room_confirmation_number":"PB12323879396","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79467","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-06 03:48:54","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79467","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":"2911934","reservation_id":"65621","confirmation_number":"BP12218064784","room_confirmation_number":"BP12554628334","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79513","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-05 18:01: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":"79513","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":"2912041","reservation_id":"65673","confirmation_number":"PB12246613046","room_confirmation_number":"PB12364297908","room_stay_from":"2019-01-05","room_stay_to":"2019-01-07","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":"79535","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-05 22:11: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":"79535","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","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":"2912515","reservation_id":"65477","confirmation_number":"BV12227956162","room_confirmation_number":"BV12488119491","room_stay_from":"2019-01-04","room_stay_to":"2019-01-08","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":"79447","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-04 17:45:53","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79447","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":"2913422","reservation_id":"65260","confirmation_number":"PB12298112843","room_confirmation_number":"PB12366420675","room_stay_from":"2019-01-05","room_stay_to":"2019-01-08","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":"79350","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-02 21:29: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":"79350","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":"2914556","reservation_id":"65524","confirmation_number":"BP12257103644","room_confirmation_number":"BP12527268259","room_stay_from":"2019-01-05","room_stay_to":"2019-01-12","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":"79466","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-04 21:02:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79466","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":"2915596","reservation_id":"65419","confirmation_number":"PB12278953876","room_confirmation_number":"PB12365308537","room_stay_from":"2019-01-04","room_stay_to":"2019-01-14","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":"65816","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-04 00:51:35","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"65816","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":"2926684","reservation_id":"63996","confirmation_number":"BV12214529070","room_confirmation_number":"BV12497687505","room_stay_from":"2019-01-03","room_stay_to":"2019-01-24","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":"78851","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-12-22 16:57:22","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78851","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":"2928003","reservation_id":"56578","confirmation_number":"BP12542154861","room_confirmation_number":"BP12569141751","room_stay_from":"2019-01-05","room_stay_to":"2019-02-09","room_stay_status":"Active","nightly_price":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"26029","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-05 17:36:18","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26029","canceled_nights_data":"","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"}]},{"room_stay_id":"2934471","reservation_id":"30562","confirmation_number":"PB12332311942","room_confirmation_number":"PB916443308","room_stay_from":"2019-01-03","room_stay_to":"2019-03-07","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,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,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,0.00,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,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,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,0.00,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":"23037","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-02-17 23:01:53","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23037","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":"2911924","reservation_id":"65721","confirmation_number":"PB12278590331","room_confirmation_number":"PB12364594677","room_stay_from":"2019-03-29","room_stay_to":"2019-04-05","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":"79549","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-06 03:40: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":"79549","canceled_nights_data":"","changedComment":"From 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"}]},{"room_stay_id":"2914281","reservation_id":"65723","confirmation_number":"PB12238994750","room_confirmation_number":"PB12380242234","room_stay_from":"2019-03-29","room_stay_to":"2019-04-05","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":"79550","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-06 03:49: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":"79550","canceled_nights_data":"","changedComment":"both dates 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"}]},{"room_stay_id":"2951260","reservation_id":"65680","confirmation_number":"PB12247564609","room_confirmation_number":"PB12321605483","room_stay_from":"2019-03-10","room_stay_to":"2019-03-17","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":"180.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79538","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-05 22:51: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":"79538","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":"2911008","reservation_id":"65447","confirmation_number":"BV12238615670","room_confirmation_number":"BV12467011292","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-04 20:37:04","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"79425","parentCustTravId":"79425","customer_traveller_id":"79425","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2911481","reservation_id":"65596","confirmation_number":"BV12248129866","room_confirmation_number":"BV12446853742","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":"1192","service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-05 15:42:29","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"79496","parentCustTravId":"79496","customer_traveller_id":"79496","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":"2911518","reservation_id":"64131","confirmation_number":"PB12227653749","room_confirmation_number":"PB12376407487","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"339.00","paid_amount":"339.00","product_id":"1212","service_quantity":"4","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-05 16:31:10","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"78902","parentCustTravId":"78902","customer_traveller_id":"78902","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":"300.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2911572","reservation_id":"60896","confirmation_number":"BP12283892027","room_confirmation_number":"BP12513723366","room_stay_from":"2019-01-05","room_stay_to":"2019-01-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"375.00","grand_total":"423.75","paid_amount":"423.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-05 17:58:26","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"33409","parentCustTravId":"33409","customer_traveller_id":"33409","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2911682","reservation_id":"65652","confirmation_number":"PB12235440230","room_confirmation_number":"PB12348160089","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-01-05 20:14:35","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"}]},{"room_stay_id":"2911932","reservation_id":"65724","confirmation_number":"PB12268562440","room_confirmation_number":"PB12364424663","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":"1.99","paid_amount":"1.99","product_id":null,"service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-06 03:54:23","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"}]}],"gift_shop_non_taxable":[{"room_stay_id":"2911686","reservation_id":"65653","confirmation_number":"PB12299305622","room_confirmation_number":"PB12378544479","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.25","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"4","product_name":"Print\/Copy","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-05 20:16:02","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.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2911688","reservation_id":"65654","confirmation_number":"PB12213727729","room_confirmation_number":"PB12382443686","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.50","grand_total":"0.50","paid_amount":"0.50","product_id":null,"service_quantity":"1","product_name":"Laundry Soap","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-05 20:17:39","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":"0.50","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"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":13,"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":"2909046","reservation_id":"65095","confirmation_number":"PB12350573763","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"95.47,95.47,111.89,111.89","nightly_discount":"0,0,0,0","subtotal":"414.72","grand_total":"468.63","paid_amount":"468.63","room_type_id":"289","product_id":"1102","siteminder_id":"BDC-1002386324","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":"79255","customer_id":"79255","source_of_creation":"Booking.com","reservation_created_date":"2019-01-01 19:20:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"62.21","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.89","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":"2910123","reservation_id":"65337","confirmation_number":"PB12378552559","room_stay_from":"2019-01-03","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.89,128.30,128.30,116.21,116.21,116.21","nightly_discount":"0,0,0,0,0,0","subtotal":"717.12","grand_total":"810.35","paid_amount":"810.35","room_type_id":"291","product_id":"1114","siteminder_id":"BDC-1134712172","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":"79374","customer_id":"79374","source_of_creation":"Booking.com","reservation_created_date":"2019-01-03 14:49:14","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"107.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"128.30","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":"2910223","reservation_id":"65367","confirmation_number":"PB12315935378","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.62","nightly_discount":"0","subtotal":"141.62","grand_total":"160.03","paid_amount":"160.03","room_type_id":"286","product_id":"1086","siteminder_id":"BDC-1911714142","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":"79393","customer_id":"79393","source_of_creation":"Booking.com","reservation_created_date":"2019-01-03 19:57:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"21.24","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"141.62","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":"2911346","reservation_id":"64796","confirmation_number":"PB12336608691","room_stay_from":"2019-01-05","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"107.14,95.04,95.04,95.04","nightly_discount":"0,0,0,0","subtotal":"392.26","grand_total":"443.26","paid_amount":"443.26","room_type_id":"292","product_id":"1120","siteminder_id":"BDC-1800087513","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79137","customer_id":"79137","source_of_creation":"Booking.com","reservation_created_date":"2018-12-30 04:06:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS 218","ota_service_fee_amount":"0","commision_charges":"58.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"107.14","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":"2911386","reservation_id":"64315","confirmation_number":"PB12377250827","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"95.47,95.47,111.89,111.89","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"414.72","grand_total":"468.63","paid_amount":"468.63","room_type_id":"289","product_id":"1100","siteminder_id":"BDC-1412738243","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"78970","customer_id":"78970","source_of_creation":"Booking.com","reservation_created_date":"2018-12-26 18:33:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"62.21","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.89","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911395","reservation_id":"64151","confirmation_number":"PB12330819377","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"111.38,130.54,130.54","nightly_discount":"0.00,0.00,0.00","subtotal":"372.46","grand_total":"420.88","paid_amount":"420.88","room_type_id":"289","product_id":"1098","siteminder_id":"BDC-1819309475","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":"78908","customer_id":"78908","source_of_creation":"Booking.com","reservation_created_date":"2018-12-24 19:21:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"55.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.54","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911402","reservation_id":"64804","confirmation_number":"PB12332336916","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"130.54,130.54","nightly_discount":"0.00,0.00","subtotal":"261.08","grand_total":"295.02","paid_amount":"295.02","room_type_id":"289","product_id":"1099","siteminder_id":"BDC-1717744506","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79143","customer_id":"79143","source_of_creation":"Booking.com","reservation_created_date":"2018-12-30 15:30:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"39.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.54","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2912040","reservation_id":"65673","confirmation_number":"PB12364297908","room_stay_from":"2019-01-05","room_stay_to":"2019-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.71,152.71","nightly_discount":"0,0","subtotal":"305.42","grand_total":"345.13","paid_amount":"345.13","room_type_id":"288","product_id":"1091","siteminder_id":"BDC-1098666556","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":"79535","customer_id":"79535","source_of_creation":"Booking.com","reservation_created_date":"2019-01-05 22:11:10","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"22.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"152.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":"2913421","reservation_id":"65260","confirmation_number":"PB12366420675","room_stay_from":"2019-01-05","room_stay_to":"2019-01-08","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"130.54,116.42,116.42","nightly_discount":"0.00,0.00,0.00","subtotal":"363.38","grand_total":"410.62","paid_amount":"410.62","room_type_id":"289","product_id":"1106","siteminder_id":"BDC-2066320214","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"90.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79350","customer_id":"79350","source_of_creation":"Booking.com","reservation_created_date":"2019-01-02 21:29:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"54.51","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.54","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2911072","reservation_id":"65530","confirmation_number":"PB12355191306","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"117.81,117.81","nightly_discount":"0,0","subtotal":"235.62","grand_total":"266.25","paid_amount":"266.26","room_type_id":"291","product_id":"1116","siteminder_id":"EXP-1173650356","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79467","customer_id":"79467","source_of_creation":"Expedia","reservation_created_date":"2019-01-04 21:35:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.81","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":"2911348","reservation_id":"64641","confirmation_number":"PB12392305224","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"107.04","nightly_discount":"0","subtotal":"107.04","grand_total":"120.95","paid_amount":"120.95","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1170166674","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79084","customer_id":"79084","source_of_creation":"Expedia","reservation_created_date":"2018-12-29 01:10:08","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":"107.04","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":"2911482","reservation_id":"62792","confirmation_number":"PB12342995915","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.19,104.38,104.38,122.33,122.33","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"569.61","grand_total":"643.66","paid_amount":"643.66","room_type_id":"289","product_id":"1097","siteminder_id":"EXP-1159510132","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":"78395","customer_id":"78395","source_of_creation":"Expedia","reservation_created_date":"2018-12-06 13:15:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"122.33","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911519","reservation_id":"64131","confirmation_number":"PB12376407487","room_stay_from":"2019-01-05","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.95,80.20,80.20,80.20","nightly_discount":"0,0,0,0","subtotal":"331.55","grand_total":"374.65","paid_amount":"374.65","room_type_id":"287","product_id":"1089","siteminder_id":"EXP-1168102296","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":"78902","customer_id":"78902","source_of_creation":"Expedia","reservation_created_date":"2018-12-24 17:40:08","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":"90.95","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":"2911581","reservation_id":"65623","confirmation_number":"PB12369335423","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.94","nightly_discount":"0","subtotal":"97.94","grand_total":"110.68","paid_amount":"110.68","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1174085256","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":"79514","customer_id":"79514","source_of_creation":"Expedia","reservation_created_date":"2019-01-05 18:05:11","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":"97.94","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":"2909792","reservation_id":"65255","confirmation_number":"PB12379564214","room_stay_from":"2019-01-05","room_stay_to":"2019-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"49.63,49.63","nightly_discount":"0,0","subtotal":"99.25","grand_total":"112.16","paid_amount":"112.16","room_type_id":"289","product_id":"1101","siteminder_id":"HTN-72480058-DX9FX6","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":"79346","customer_id":"79346","source_of_creation":"HotelTonight","reservation_created_date":"2019-01-02 21:12:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"49.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":"2910909","reservation_id":"65496","confirmation_number":"PB12348253518","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.04,60.04","nightly_discount":"0,0","subtotal":"120.07","grand_total":"135.67","paid_amount":"135.68","room_type_id":"289","product_id":"1107","siteminder_id":"HTN-72665382-CPQKXM","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":"79455","customer_id":"79455","source_of_creation":"HotelTonight","reservation_created_date":"2019-01-04 19:17: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":"60.04","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":"2911837","reservation_id":"64330","confirmation_number":"PB12324988363","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.86","nightly_discount":"0.00","subtotal":"62.86","grand_total":"71.03","paid_amount":"71.03","room_type_id":"285","product_id":"1084","siteminder_id":"HTN-71720995","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"78976","customer_id":"78976","source_of_creation":"HotelTonight","reservation_created_date":"2018-12-26 20:55:12","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":"62.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":"2911886","reservation_id":"65708","confirmation_number":"PB12345931062","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.45","nightly_discount":"0","subtotal":"64.45","grand_total":"72.83","paid_amount":"72.83","room_type_id":"289","product_id":"1108","siteminder_id":"HTN-72793407-H9ZVD3","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":"79545","customer_id":"79545","source_of_creation":"HotelTonight","reservation_created_date":"2019-01-06 02:08:12","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":"64.45","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"2911304","reservation_id":"65591","confirmation_number":"PB12337532019","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.47","nightly_discount":"0","subtotal":"126.47","grand_total":"142.91","paid_amount":"142.91","room_type_id":"287","product_id":"1087","siteminder_id":"GAM-R1339067807","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":"79492","customer_id":"79492","source_of_creation":"Getaroom.com","reservation_created_date":"2019-01-05 06:42:09","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":"126.47","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"2911541","reservation_id":"65603","confirmation_number":"PB12326321199","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.03","nightly_discount":"0","subtotal":"80.03","grand_total":"90.43","paid_amount":"90.43","room_type_id":"289","product_id":"1123","siteminder_id":"HWR-171253165","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":"79502","customer_id":"79502","source_of_creation":"Hotwire","reservation_created_date":"2019-01-05 15:12:10","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":"80.03","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":"2915595","reservation_id":"65419","confirmation_number":"PB12365308537","room_stay_from":"2019-01-04","room_stay_to":"2019-01-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.40,102.40,104.00,104.00,104.00,104.00,104.00,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1036.80","grand_total":"1171.59","paid_amount":"1171.59","room_type_id":"289","product_id":"1105","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":"65816","customer_id":"65816","source_of_creation":"FE","reservation_created_date":"2019-01-04 00:51:35","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":"102.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2876331","reservation_id":"58096","confirmation_number":"PB12315576038","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.00,134.00,134.00,134.00,134.00,134.00,184.00,184.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1222.00","grand_total":"1380.86","paid_amount":"1380.86","room_type_id":"289","product_id":"1110","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":"75908","customer_id":"75908","source_of_creation":"PMS","reservation_created_date":"2018-10-12 16:00:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"184.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2876334","reservation_id":"58098","confirmation_number":"PB12360697642","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"184.00,134.00,134.00,134.00,134.00,134.00,184.00,184.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1222.00","grand_total":"1380.86","paid_amount":"1380.86","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":"75908","customer_id":"75908","source_of_creation":"PMS","reservation_created_date":"2018-10-12 16:04:38","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":"184.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2876337","reservation_id":"58099","confirmation_number":"PB12313882951","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.00,134.00,134.00,134.00,134.00,134.00,184.00,184.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1222.00","grand_total":"1380.86","paid_amount":"1380.86","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":"75909","customer_id":"75909","source_of_creation":"PMS","reservation_created_date":"2018-10-12 16:07:57","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":"184.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2907921","reservation_id":"64844","confirmation_number":"PB12361017668","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"287","product_id":"1088","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":"26469","customer_id":"26469","source_of_creation":"PMS","reservation_created_date":"2018-12-30 20:20:48","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","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"}]},{"room_stay_id":"2909602","reservation_id":"65202","confirmation_number":"PB12374716681","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"112.00","nightly_discount":"0.00","subtotal":"112.00","grand_total":"126.56","paid_amount":"126.56","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":"47798","customer_id":"47798","source_of_creation":"PMS","reservation_created_date":"2019-01-02 17:34:20","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":"112.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":"2911448","reservation_id":"65464","confirmation_number":"PB12362056767","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00","nightly_discount":"7.58,0.00","subtotal":"112.00","grand_total":"118.00","paid_amount":"118.00","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":"52357","customer_id":"52357","source_of_creation":"PMS","reservation_created_date":"2019-01-04 16:23:03","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"112.00","currentDayDiscount":"7.58","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911492","reservation_id":"49336","confirmation_number":"PB12395178081","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.00,134.00,134.00,134.00,134.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"938.00","grand_total":"1059.94","paid_amount":"1059.94","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":"71320","customer_id":"71320","source_of_creation":"PMS","reservation_created_date":"2018-06-18 19:55:30","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.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":"2911494","reservation_id":"49336","confirmation_number":"PB12321287513","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.00,184.00,184.00,134.00,134.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1038.00","grand_total":"1172.94","paid_amount":"1172.94","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":"71320","customer_id":"71320","source_of_creation":"PMS","reservation_created_date":"2018-06-18 19:55:31","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"184.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":"2911498","reservation_id":"49336","confirmation_number":"PB12333738962","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.00,184.00,184.00,134.00,134.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1038.00","grand_total":"1172.94","paid_amount":"1172.94","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":"71320","customer_id":"71320","source_of_creation":"PMS","reservation_created_date":"2018-06-18 19:55:32","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"184.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":"2911717","reservation_id":"65645","confirmation_number":"PB12325382823","room_stay_from":"2019-01-05","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"151.00,151.00,151.00,151.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"604.00","grand_total":"682.52","paid_amount":"682.52","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":"79520","customer_id":"79520","source_of_creation":"PMS","reservation_created_date":"2019-01-05 19:41:09","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"151.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":"2911927","reservation_id":"65722","confirmation_number":"PB12323879396","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.00","nightly_discount":"0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","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":"79467","customer_id":"79467","source_of_creation":"PMS","reservation_created_date":"2019-01-06 03:48:54","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":"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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2911073","reservation_id":"65530","confirmation_number":"PB12251349026","room_confirmation_number":"PB12355191306","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"79467","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-01-04 21:35: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":"79467","canceled_nights_data":"","currentDayPrice":"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":"2911389","reservation_id":"64151","confirmation_number":"PB12230822704","room_confirmation_number":"PB12330819377","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"30,30,30","nightly_discount":"0.00,0.00,0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1780","service_quantity":"1","customer_traveller_id":"78908","product_attribute_values":"extra_person# ","reservation_created_date":"2019-01-05 14:04:18","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78908","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"60.00","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911398","reservation_id":"64804","confirmation_number":"PB12298803363","room_confirmation_number":"PB12332336916","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"79143","product_attribute_values":"extra_person# ","reservation_created_date":"2019-01-05 14:16:40","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79143","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"20.00","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":"2911340","reservation_id":"64832","confirmation_number":"PB12225300726","room_confirmation_number":"PB12369545502","room_stay_from":"2019-01-04","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"77323","product_attribute_values":"extra_person# ","reservation_created_date":"2019-01-05 12:20:49","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77323","canceled_nights_data":"","changedComment":"Reservation created for complete past date","deltaChange":"20.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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2898863","reservation_id":"58096","confirmation_number":"PBR12229201566","room_confirmation_number":"PB12315576038","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","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,0,0,0,0,0,0,0","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"75908","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":"75908","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2898864","reservation_id":"58098","confirmation_number":"PBR12268181066","room_confirmation_number":"PB12360697642","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","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,0,0,0,0,0,0,0","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"75908","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":"75908","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2898865","reservation_id":"58099","confirmation_number":"PBR12289079923","room_confirmation_number":"PB12313882951","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","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,0,0,0,0,0,0,0","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"75909","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":"75909","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2907922","reservation_id":"64844","confirmation_number":"PB12249422606","room_confirmation_number":"PB12361017668","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","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":"26469","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-12-30 20:20:48","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26469","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":"2909047","reservation_id":"65095","confirmation_number":"PB12244169648","room_confirmation_number":"PB12350573763","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","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":"79255","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-01 19:20:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79255","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":"2909603","reservation_id":"65202","confirmation_number":"PB12266743246","room_confirmation_number":"PB12374716681","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"47798","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-02 17:34:20","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","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":"2909793","reservation_id":"65255","confirmation_number":"PB12279649868","room_confirmation_number":"PB12379564214","room_stay_from":"2019-01-05","room_stay_to":"2019-01-07","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":"79346","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-02 21:12:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79346","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":"2910124","reservation_id":"65337","confirmation_number":"PB12299631203","room_confirmation_number":"PB12378552559","room_stay_from":"2019-01-03","room_stay_to":"2019-01-09","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":"79374","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-03 14:49: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":"79374","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":"2910224","reservation_id":"65367","confirmation_number":"PB12278355206","room_confirmation_number":"PB12315935378","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79393","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-03 19:57:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79393","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":"2910910","reservation_id":"65496","confirmation_number":"PB12215133929","room_confirmation_number":"PB12348253518","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","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.19","product_id":"1781","service_quantity":"1","customer_traveller_id":"79455","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-04 19:17: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":"79455","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":"2911074","reservation_id":"65530","confirmation_number":"PB12287282243","room_confirmation_number":"PB12355191306","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","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.19","product_id":"1781","service_quantity":"1","customer_traveller_id":"79467","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-04 21:35: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":"79467","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":"2911305","reservation_id":"65591","confirmation_number":"PB12255896927","room_confirmation_number":"PB12337532019","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79492","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-05 06:42: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":"79492","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":"2911347","reservation_id":"64796","confirmation_number":"PB12228994843","room_confirmation_number":"PB12336608691","room_stay_from":"2019-01-05","room_stay_to":"2019-01-09","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":"79137","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-30 04:06: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":"79137","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":"2911349","reservation_id":"64641","confirmation_number":"PB12298586046","room_confirmation_number":"PB12392305224","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79084","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-29 01:10: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":"79084","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":"2911387","reservation_id":"64315","confirmation_number":"PB12294991886","room_confirmation_number":"PB12377250827","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","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":"78970","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-26 18:33: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":"78970","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":"2911396","reservation_id":"64151","confirmation_number":"PB12227649305","room_confirmation_number":"PB12330819377","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","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":"78908","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-24 19:21: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":"78908","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":"2911403","reservation_id":"64804","confirmation_number":"PB12297021648","room_confirmation_number":"PB12332336916","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","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":"79143","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-30 15:30:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79143","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":"2911449","reservation_id":"65464","confirmation_number":"PB12279333326","room_confirmation_number":"PB12362056767","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"52357","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-04 16:23:03","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"52357","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":"2911483","reservation_id":"62792","confirmation_number":"PBR12279524923","room_confirmation_number":"PB12342995915","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","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":"78395","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":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78395","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":"2911493","reservation_id":"49336","confirmation_number":"PBR12279492377","room_confirmation_number":"PB12395178081","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","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":"71320","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"2018-06-18 19:55:30","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71320","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":"2911495","reservation_id":"49336","confirmation_number":"PBR12278630843","room_confirmation_number":"PB12321287513","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","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":"71320","product_attribute_values":"resort_fee#&#flat_rate# .00","reservation_created_date":"2018-06-18 19:55:30","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71320","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":"2911499","reservation_id":"49336","confirmation_number":"PBR12238759839","room_confirmation_number":"PB12333738962","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","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":"71320","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":"71320","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":"2911520","reservation_id":"64131","confirmation_number":"PB12211311465","room_confirmation_number":"PB12376407487","room_stay_from":"2019-01-05","room_stay_to":"2019-01-09","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":"78902","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-24 17:40: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":"78902","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":"2911542","reservation_id":"65603","confirmation_number":"PB12289774473","room_confirmation_number":"PB12326321199","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79502","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-05 15:12: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":"79502","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":"2911582","reservation_id":"65623","confirmation_number":"PB12258755761","room_confirmation_number":"PB12369335423","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79514","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-05 18:05:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79514","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":"2911718","reservation_id":"65645","confirmation_number":"PB12291593279","room_confirmation_number":"PB12325382823","room_stay_from":"2019-01-05","room_stay_to":"2019-01-09","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":"79520","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-05 19:41:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79520","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":"2911838","reservation_id":"64330","confirmation_number":"PB12251751000","room_confirmation_number":"PB12324988363","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"78976","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-26 20:55:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78976","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":"2911887","reservation_id":"65708","confirmation_number":"PB12272835187","room_confirmation_number":"PB12345931062","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79545","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-06 02:08:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79545","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":"2911928","reservation_id":"65722","confirmation_number":"PB12253805265","room_confirmation_number":"PB12323879396","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79467","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-06 03:48:54","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79467","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":"2912041","reservation_id":"65673","confirmation_number":"PB12246613046","room_confirmation_number":"PB12364297908","room_stay_from":"2019-01-05","room_stay_to":"2019-01-07","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":"79535","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-05 22:11: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":"79535","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","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":"2913422","reservation_id":"65260","confirmation_number":"PB12298112843","room_confirmation_number":"PB12366420675","room_stay_from":"2019-01-05","room_stay_to":"2019-01-08","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":"79350","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-02 21:29: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":"79350","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":"2915596","reservation_id":"65419","confirmation_number":"PB12278953876","room_confirmation_number":"PB12365308537","room_stay_from":"2019-01-04","room_stay_to":"2019-01-14","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":"65816","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-04 00:51:35","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"65816","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":"2911924","reservation_id":"65721","confirmation_number":"PB12278590331","room_confirmation_number":"PB12364594677","room_stay_from":"2019-03-29","room_stay_to":"2019-04-05","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":"79549","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-06 03:40: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":"79549","canceled_nights_data":"","changedComment":"From 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"}]},{"room_stay_id":"2914281","reservation_id":"65723","confirmation_number":"PB12238994750","room_confirmation_number":"PB12380242234","room_stay_from":"2019-03-29","room_stay_to":"2019-04-05","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":"79550","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-06 03:49: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":"79550","canceled_nights_data":"","changedComment":"both dates 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"}]},{"room_stay_id":"2951260","reservation_id":"65680","confirmation_number":"PB12247564609","room_confirmation_number":"PB12321605483","room_stay_from":"2019-03-10","room_stay_to":"2019-03-17","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":"180.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79538","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-05 22:51: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":"79538","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":"2911518","reservation_id":"64131","confirmation_number":"PB12227653749","room_confirmation_number":"PB12376407487","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"339.00","paid_amount":"339.00","product_id":"1212","service_quantity":"4","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-05 16:31:10","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"78902","parentCustTravId":"78902","customer_traveller_id":"78902","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":"300.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2911682","reservation_id":"65652","confirmation_number":"PB12235440230","room_confirmation_number":"PB12348160089","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-01-05 20:14:35","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"}]},{"room_stay_id":"2911932","reservation_id":"65724","confirmation_number":"PB12268562440","room_confirmation_number":"PB12364424663","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":"1.99","paid_amount":"1.99","product_id":null,"service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-06 03:54:23","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"}]}],"gift_shop_non_taxable":[{"room_stay_id":"2911686","reservation_id":"65653","confirmation_number":"PB12299305622","room_confirmation_number":"PB12378544479","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.25","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"4","product_name":"Print\/Copy","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-05 20:16:02","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.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"2911688","reservation_id":"65654","confirmation_number":"PB12213727729","room_confirmation_number":"PB12382443686","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.50","grand_total":"0.50","paid_amount":"0.50","product_id":null,"service_quantity":"1","product_name":"Laundry Soap","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-05 20:17:39","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":"0.50","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"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":2,"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":"2908769","reservation_id":"64669","confirmation_number":"BV12494305673","room_stay_from":"2019-01-03","room_stay_to":"2019-01-07","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"97.81,112.32,112.32,101.56","nightly_discount":"0,0,0,0","subtotal":"424.01","grand_total":"479.13","paid_amount":"479.13","room_type_id":"304","product_id":"1220","siteminder_id":"BDC-1293666967","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79095","customer_id":"79095","source_of_creation":"Booking.com","reservation_created_date":"2018-12-29 13:41:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"63.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"112.32","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":"2909349","reservation_id":"65033","confirmation_number":"BV12493382396","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.81,112.32,112.32","nightly_discount":"0.00,0.00,0.00","subtotal":"322.45","grand_total":"341.80","paid_amount":"364.37","room_type_id":"304","product_id":"1221","siteminder_id":"BDC-1026627407","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":"79224","customer_id":"79224","source_of_creation":"Booking.com","reservation_created_date":"2019-01-01 05:36:15","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"42.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"112.32","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910790","reservation_id":"65469","confirmation_number":"BV12423331123","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.96","nightly_discount":"0","subtotal":"120.96","grand_total":"136.69","paid_amount":"136.69","room_type_id":"304","product_id":"1219","siteminder_id":"BDC-1124678678","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":"79443","customer_id":"79443","source_of_creation":"Booking.com","reservation_created_date":"2019-01-04 16:47:11","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"18.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.96","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":"2911516","reservation_id":"64671","confirmation_number":"BV12440444588","room_stay_from":"2019-01-04","room_stay_to":"2019-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.87,109.87,98.28","nightly_discount":"0,0,0","subtotal":"318.02","grand_total":"359.36","paid_amount":"359.36","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-1253407742","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79098","customer_id":"79098","source_of_creation":"Booking.com","reservation_created_date":"2018-12-29 13:53:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"47.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"109.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2911356","reservation_id":"63657","confirmation_number":"BV12460195323","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.63","nightly_discount":"0","subtotal":"108.63","grand_total":"122.75","paid_amount":"122.75","room_type_id":"304","product_id":"1218","siteminder_id":"EXP-1164815480","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":"78656","customer_id":"78656","source_of_creation":"Expedia","reservation_created_date":"2018-12-17 16:05:12","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":"108.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"}]}],"exp_non_taxable":[],"htn_non_taxable":[],"pcl_taxable":[{"room_stay_id":"2911533","reservation_id":"65609","confirmation_number":"BV12470949613","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"82.94","nightly_discount":"0.00","subtotal":"82.94","grand_total":"93.73","paid_amount":"93.73","room_type_id":"305","product_id":"1222","siteminder_id":"PCL-33094193","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":"79507","customer_id":"79507","source_of_creation":"Priceline.com","reservation_created_date":"2019-01-05 15:58:09","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"82.94","currentDayDiscount":"0.00","productIsTaxExempt":false,"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_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":"2910526","reservation_id":"65447","confirmation_number":"BV12467011292","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.80,124.80","nightly_discount":"0.00,0.00","subtotal":"249.60","grand_total":"282.05","paid_amount":"282.05","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":"79425","customer_id":"79425","source_of_creation":"FE","reservation_created_date":"2019-01-04 03:08:35","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2910866","reservation_id":"65484","confirmation_number":"BV12477319840","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00","nightly_discount":"0.00,0.00","subtotal":"228.00","grand_total":"257.64","paid_amount":"257.64","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":"50159","customer_id":"50159","source_of_creation":"PMS","reservation_created_date":"2019-01-04 18:19:24","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":"114.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":"2911738","reservation_id":"65665","confirmation_number":"BV12423138674","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00","nightly_discount":"0.00","subtotal":"130.00","grand_total":"146.90","paid_amount":"146.90","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":"79530","customer_id":"79530","source_of_creation":"PMS","reservation_created_date":"2019-01-05 21:06:53","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":"130.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":"2912514","reservation_id":"65477","confirmation_number":"BV12488119491","room_stay_from":"2019-01-04","room_stay_to":"2019-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"312.00","grand_total":"352.56","paid_amount":"352.56","room_type_id":"307","product_id":"1224","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":"79447","customer_id":"79447","source_of_creation":"PMS","reservation_created_date":"2019-01-04 17:45:53","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":"78.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":"2926683","reservation_id":"63996","confirmation_number":"BV12497687505","room_stay_from":"2019-01-03","room_stay_to":"2019-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65","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":"1630.65","grand_total":"1842.64","paid_amount":"1842.64","room_type_id":"303","product_id":"1140","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":"78851","customer_id":"78851","source_of_creation":"PMS","reservation_created_date":"2018-12-22 16:57:22","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":"77.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2911535","reservation_id":"65609","confirmation_number":"BV12235212755","room_confirmation_number":"BV12470949613","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"79507","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-01-05 17:10:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79507","canceled_nights_data":"","currentDayPrice":"10","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":"2908770","reservation_id":"64669","confirmation_number":"BV12281041751","room_confirmation_number":"BV12494305673","room_stay_from":"2019-01-03","room_stay_to":"2019-01-07","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":"79095","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-29 13:41: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":"79095","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":"2909351","reservation_id":"65033","confirmation_number":"BV12232434950","room_confirmation_number":"BV12493382396","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","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":"79224","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-01 05:36:15","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79224","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":"2910527","reservation_id":"65447","confirmation_number":"BV12217944438","room_confirmation_number":"BV12467011292","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","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":"79425","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-04 03:08:35","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79425","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":"2910791","reservation_id":"65469","confirmation_number":"BV12264349348","room_confirmation_number":"BV12423331123","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79443","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-04 16:47: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":"79443","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":"2910867","reservation_id":"65484","confirmation_number":"BV12216725397","room_confirmation_number":"BV12477319840","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","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":"50159","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-04 18:19:24","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"50159","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":"2911357","reservation_id":"63657","confirmation_number":"PBR12236424379","room_confirmation_number":"BV12460195323","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"78656","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":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78656","canceled_nights_data":"","currentDayPrice":"20.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":"2911517","reservation_id":"64671","confirmation_number":"BV12267518541","room_confirmation_number":"BV12440444588","room_stay_from":"2019-01-04","room_stay_to":"2019-01-07","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":"79098","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2018-12-29 13:53: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":"79098","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":"2911536","reservation_id":"65609","confirmation_number":"BV12220090027","room_confirmation_number":"BV12470949613","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79507","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-05 15:58: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":"79507","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":"2911739","reservation_id":"65665","confirmation_number":"BV12211338595","room_confirmation_number":"BV12423138674","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79530","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-05 21:06:53","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79530","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":"2912515","reservation_id":"65477","confirmation_number":"BV12227956162","room_confirmation_number":"BV12488119491","room_stay_from":"2019-01-04","room_stay_to":"2019-01-08","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":"79447","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-04 17:45:53","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79447","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":"2926684","reservation_id":"63996","confirmation_number":"BV12214529070","room_confirmation_number":"BV12497687505","room_stay_from":"2019-01-03","room_stay_to":"2019-01-24","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":"78851","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-12-22 16:57:22","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78851","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"2911008","reservation_id":"65447","confirmation_number":"BV12238615670","room_confirmation_number":"BV12467011292","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-04 20:37:04","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"79425","parentCustTravId":"79425","customer_traveller_id":"79425","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2911481","reservation_id":"65596","confirmation_number":"BV12248129866","room_confirmation_number":"BV12446853742","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":"1192","service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-05 15:42:29","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"79496","parentCustTravId":"79496","customer_traveller_id":"79496","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"}]}],"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":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":"2911933","reservation_id":"65621","confirmation_number":"BP12554628334","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.14","nightly_discount":"0","subtotal":"107.14","grand_total":"121.07","paid_amount":"121.07","room_type_id":"294","product_id":"1127","siteminder_id":"BDC-1358817948","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":"79513","customer_id":"79513","source_of_creation":"Booking.com","reservation_created_date":"2019-01-05 18:01:11","canceled_nights_data":"","product_name":"BP One Bedroom Suite 1Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"16.07","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"107.14","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":"2910602","reservation_id":"65454","confirmation_number":"BP12525432306","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"129.77","nightly_discount":"0","subtotal":"129.77","grand_total":"146.64","paid_amount":"146.64","room_type_id":"302","product_id":"1138","siteminder_id":"EXP-1173379097","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":"79431","customer_id":"79431","source_of_creation":"Expedia","reservation_created_date":"2019-01-04 13:00:13","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":"129.77","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_non_taxable":[],"gam_taxable":[{"room_stay_id":"2910801","reservation_id":"65471","confirmation_number":"BP12539954275","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.40,75.40","nightly_discount":"0,0","subtotal":"150.80","grand_total":"170.41","paid_amount":"170.41","room_type_id":"295","product_id":"1128","siteminder_id":"GAM-R1338277951","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":"79444","customer_id":"79444","source_of_creation":"Getaroom.com","reservation_created_date":"2019-01-04 17:00:11","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":"75.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"2909100","reservation_id":"65109","confirmation_number":"BP12552568202","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.44","nightly_discount":"0","subtotal":"73.44","grand_total":"82.99","paid_amount":"82.99","room_type_id":"299","product_id":"1134","siteminder_id":"HWR-171239179","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":"79265","customer_id":"79265","source_of_creation":"Hotwire","reservation_created_date":"2019-01-01 20:16:08","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.44","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":"2911362","reservation_id":"60558","confirmation_number":"BP12560117727","room_stay_from":"2019-01-05","room_stay_to":"2019-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,109.00","nightly_discount":"0.00,0.00","subtotal":"268.00","grand_total":"302.84","paid_amount":"302.84","room_type_id":"298","product_id":"1133","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":"29376","customer_id":"29376","source_of_creation":"PMS","reservation_created_date":"2018-11-17 15:02:24","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":"159.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":"2911510","reservation_id":"64676","confirmation_number":"BP12528088497","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.60,84.00,84.00,81.60,81.60,81.60,81.60","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"568.00","grand_total":"641.84","paid_amount":"641.84","room_type_id":"295","product_id":"1129","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":"79102","customer_id":"79102","source_of_creation":"PMS","reservation_created_date":"2018-12-29 15:08:33","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":"84.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":"2911565","reservation_id":"56578","confirmation_number":"BP12569141751","room_stay_from":"2019-01-05","room_stay_to":"2019-02-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,73.85,105.00","subtotal":"3675.00","grand_total":"3950.65","paid_amount":"3950.65","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":"26029","customer_id":"26029","source_of_creation":"PMS","reservation_created_date":"2018-09-18 15:03:54","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":"105.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":"2911577","reservation_id":"60896","confirmation_number":"BP12513723366","room_stay_from":"2019-01-05","room_stay_to":"2019-01-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"182.00,132.00,132.00,132.00,132.00,132.00,182.00,182.00,132.00,132.00,132.00,132.00,132.00,182.00,182.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,130.43,0.00","subtotal":"2230.00","grand_total":"2372.51","paid_amount":"2372.51","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":"33409","customer_id":"33409","source_of_creation":"PMS","reservation_created_date":"2018-11-21 23:40:22","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"182.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":"2914555","reservation_id":"65524","confirmation_number":"BP12527268259","room_stay_from":"2019-01-05","room_stay_to":"2019-01-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.49,75.49,75.49,75.49,75.49,75.49,75.49","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"528.43","grand_total":"597.13","paid_amount":"597.13","room_type_id":"293","product_id":"1124","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":"79466","customer_id":"79466","source_of_creation":"PMS","reservation_created_date":"2019-01-04 21:02:13","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.49","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2909101","reservation_id":"65109","confirmation_number":"BP12279952907","room_confirmation_number":"BP12552568202","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79265","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-01 20: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":"79265","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":"2910603","reservation_id":"65454","confirmation_number":"BP12287960183","room_confirmation_number":"BP12525432306","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79431","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-04 13:00:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79431","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":"2910802","reservation_id":"65471","confirmation_number":"BP12219242418","room_confirmation_number":"BP12539954275","room_stay_from":"2019-01-04","room_stay_to":"2019-01-06","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":"79444","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-04 17:00:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79444","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":"2911363","reservation_id":"60558","confirmation_number":"PBR12231659403","room_confirmation_number":"BP12560117727","room_stay_from":"2019-01-05","room_stay_to":"2019-01-07","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":"29376","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":"29376","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":"2911511","reservation_id":"64676","confirmation_number":"BP12288954208","room_confirmation_number":"BP12528088497","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"79102","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-12-29 15:08:33","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79102","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":"2911578","reservation_id":"60896","confirmation_number":"PBR12239928137","room_confirmation_number":"BP12513723366","room_stay_from":"2019-01-05","room_stay_to":"2019-01-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,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","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"33409","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":"33409","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":"2911934","reservation_id":"65621","confirmation_number":"BP12218064784","room_confirmation_number":"BP12554628334","room_stay_from":"2019-01-05","room_stay_to":"2019-01-06","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":"79513","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-01-05 18:01: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":"79513","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":"2914556","reservation_id":"65524","confirmation_number":"BP12257103644","room_confirmation_number":"BP12527268259","room_stay_from":"2019-01-05","room_stay_to":"2019-01-12","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":"79466","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-04 21:02:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79466","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":"2928003","reservation_id":"56578","confirmation_number":"BP12542154861","room_confirmation_number":"BP12569141751","room_stay_from":"2019-01-05","room_stay_to":"2019-02-09","room_stay_status":"Active","nightly_price":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"26029","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-05 17:36:18","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26029","canceled_nights_data":"","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":"2911572","reservation_id":"60896","confirmation_number":"BP12283892027","room_confirmation_number":"BP12513723366","room_stay_from":"2019-01-05","room_stay_to":"2019-01-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"375.00","grand_total":"423.75","paid_amount":"423.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-05 17:58:26","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"33409","parentCustTravId":"33409","customer_traveller_id":"33409","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}