{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2019-10-17","total_rooms_exist":66,"departureCount":19,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"0","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2999691","reservation_id":"80882","confirmation_number":"PB12365064632","room_stay_from":"2019-10-17","room_stay_to":"2019-10-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.83,125.27,125.27,113.83","nightly_discount":"0,0,0,0","subtotal":"478.20","grand_total":"540.36","paid_amount":"540.36","room_type_id":"285","product_id":"1085","siteminder_id":"BDC-2496328660","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":"89046","customer_id":"89046","source_of_creation":"Booking.com","reservation_created_date":"2019-07-17 20:19:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"143.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.83","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":"3010957","reservation_id":"82736","confirmation_number":"PB12374986190","room_stay_from":"2019-10-09","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.83,113.83,125.27,125.27,113.83,113.83,113.83,113.83,113.83,125.27","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"1172.62","grand_total":"1325.06","paid_amount":"1325.06","room_type_id":"289","product_id":"1108","siteminder_id":"BDC-2219382914","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":"90283","customer_id":"90283","source_of_creation":"Booking.com","reservation_created_date":"2019-08-16 13:48:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"175.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.83","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":"3017684","reservation_id":"83508","confirmation_number":"PB12324751175","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"113.58,113.58,113.58,113.58,113.58","nightly_discount":"0,0,0,0,0","subtotal":"567.90","grand_total":"641.72","paid_amount":"641.72","room_type_id":"289","product_id":"1106","siteminder_id":"BDC-3689773294","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90809","customer_id":"90809","source_of_creation":"Booking.com","reservation_created_date":"2019-09-01 14:19:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"92.69","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3027265","reservation_id":"80882","confirmation_number":"PB12335134444","room_stay_from":"2019-10-17","room_stay_to":"2019-10-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.83,125.27,125.27,113.83","nightly_discount":"0,0,0,0","subtotal":"478.20","grand_total":"540.36","paid_amount":"540.36","room_type_id":"289","product_id":"1097","siteminder_id":"BDC-2496328660","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":"89046","customer_id":"89046","source_of_creation":"Booking.com","reservation_created_date":"2019-07-17 20:19:18","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"143.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.83","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":"3029574","reservation_id":"85806","confirmation_number":"PB12316424813","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.38","nightly_discount":"0","subtotal":"80.38","grand_total":"90.83","paid_amount":"90.83","room_type_id":"285","product_id":"1084","siteminder_id":"BDC-2417025514","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":"92812","customer_id":"92812","source_of_creation":"Booking.com","reservation_created_date":"2019-10-17 19:32:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"12.06","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"80.38","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029903","reservation_id":"81501","confirmation_number":"PB12341879694","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"102.58","nightly_discount":"0.00","subtotal":"102.58","grand_total":"115.91","paid_amount":"115.92","room_type_id":"285","product_id":"1083","siteminder_id":"BDC-2602766070","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":"89431","customer_id":"89431","source_of_creation":"Booking.com","reservation_created_date":"2019-07-26 20:52:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"15.37","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"102.58","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3031429","reservation_id":"81537","confirmation_number":"BV12465999909","room_stay_from":"2019-10-16","room_stay_to":"2019-10-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.48,138.48,165.31,165.31,138.48,138.48","nightly_discount":"0,0,0,0,0,0","subtotal":"884.54","grand_total":"999.53","paid_amount":"1156.01","room_type_id":"306","product_id":"1223","siteminder_id":"BDC-2226187915","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":"89442","customer_id":"89442","source_of_creation":"Booking.com","reservation_created_date":"2019-07-27 12:23:11","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"153.45","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.48","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":[{"room_stay_id":"3029533","reservation_id":"85798","confirmation_number":"PB12341017909","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"59.46","nightly_discount":"0","subtotal":"59.46","grand_total":"67.19","paid_amount":"67.19","room_type_id":"290","product_id":"1113","siteminder_id":"BDC-2653098850","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":"92809","customer_id":"92809","source_of_creation":"Booking.com","reservation_created_date":"2019-10-17 18:32:11","service_canceled_date_time":"2019-10-17 19:10:06","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"8.92","deltaChange":"67.19","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"2984507","reservation_id":"78017","confirmation_number":"BP12579983751","room_stay_from":"2019-10-09","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"66.68,66.68,75.34,75.34,66.68,66.68,66.68,66.68,66.68,75.34","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"692.78","grand_total":"782.84","paid_amount":"782.84","room_type_id":"295","product_id":"1129","siteminder_id":"EXP-1271579783","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":"34980","customer_id":"34980","source_of_creation":"Expedia","reservation_created_date":"2019-06-05 12:13:14","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":"66.68","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":"2987113","reservation_id":"78488","confirmation_number":"BV12457273097","room_stay_from":"2019-10-17","room_stay_to":"2019-10-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.82,103.48,103.48,94.82,94.82,94.82","nightly_discount":"0,0,0,0,0,0","subtotal":"586.24","grand_total":"662.45","paid_amount":"662.45","room_type_id":"308","product_id":"1225","siteminder_id":"EXP-1276000395","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":"87540","customer_id":"87540","source_of_creation":"Expedia","reservation_created_date":"2019-06-11 20:51:08","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":"94.82","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":"3017696","reservation_id":"81661","confirmation_number":"PB12384000879","room_stay_from":"2019-10-15","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.07,105.07,105.07,115.63","nightly_discount":"0,0,0,0","subtotal":"430.84","grand_total":"486.85","paid_amount":"486.85","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1310603079","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":"89534","customer_id":"89534","source_of_creation":"Expedia","reservation_created_date":"2019-07-29 17:12: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":"105.07","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021823","reservation_id":"80713","confirmation_number":"PB12357092937","room_stay_from":"2019-10-13","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"99.15,99.15,99.15,99.15,99.15,107.81","nightly_discount":"0,0,0,0,0,0","subtotal":"603.56","grand_total":"682.02","paid_amount":"682.02","room_type_id":"291","product_id":"1119","siteminder_id":"EXP-1299598639","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88910","customer_id":"88910","source_of_creation":"Expedia","reservation_created_date":"2019-07-14 13:06:06","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.15","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":"3024452","reservation_id":"84985","confirmation_number":"PB12399662215","room_stay_from":"2019-10-16","room_stay_to":"2019-10-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.11,105.11,113.55,113.55,105.11,105.11,105.11","nightly_discount":"0,0,0,0,0,0,0","subtotal":"752.65","grand_total":"850.50","paid_amount":"850.50","room_type_id":"288","product_id":"1092","siteminder_id":"EXP-1353598627","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":"92237","customer_id":"92237","source_of_creation":"Expedia","reservation_created_date":"2019-10-02 03:02:10","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.11","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3027204","reservation_id":"85460","confirmation_number":"PB12367458986","room_stay_from":"2019-10-14","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.16,86.16,86.16,86.16","nightly_discount":"0,0,0,0","subtotal":"344.64","grand_total":"389.44","paid_amount":"389.44","room_type_id":"289","product_id":"1107","siteminder_id":"EXP-1359598451","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":"92573","customer_id":"92573","source_of_creation":"Expedia","reservation_created_date":"2019-10-11 05:11: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":"86.16","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":"3030241","reservation_id":"82128","confirmation_number":"PB12311504002","room_stay_from":"2019-10-14","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.16,86.16,86.16,86.16,94.82","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"439.46","grand_total":"496.59","paid_amount":"496.59","room_type_id":"289","product_id":"1098","siteminder_id":"EXP-1316296292","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":"89882","customer_id":"89882","source_of_creation":"Expedia","reservation_created_date":"2019-08-06 16:47:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"86.16","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029369","reservation_id":"85785","confirmation_number":"PB12367217210","room_stay_from":"2019-10-16","room_stay_to":"2019-10-17","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"79.34","nightly_discount":"0","subtotal":"79.34","grand_total":"89.65","paid_amount":"0.00","room_type_id":"297","product_id":"1132","siteminder_id":"EXP-1362955219","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":"92801","customer_id":"92801","source_of_creation":"Expedia","reservation_created_date":"2019-10-17 06:38:09","service_canceled_date_time":"2019-10-17 20:22:31","canceled_nights_data":"","product_name":"BP Deluxe Two Bedroom Suite 2Q, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":-79.34,"changedComment":"reservation is canceled","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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"2964419","reservation_id":"74516","confirmation_number":"BV12425373944","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"137.07,137.07,137.07,137.07,137.07","nightly_discount":"0,0,0,0,0","subtotal":"685.35","grand_total":"774.44","paid_amount":"774.44","room_type_id":"303","product_id":"1139","siteminder_id":"GAM-R1456990908","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84920","customer_id":"84920","source_of_creation":"Getaroom.com","reservation_created_date":"2019-04-11 20:24:10","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.07","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3026539","reservation_id":"85341","confirmation_number":"BP12536792356","room_stay_from":"2019-10-14","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"50.41,50.41,50.41,50.41","nightly_discount":"0,0,0,0","subtotal":"201.64","grand_total":"227.85","paid_amount":"227.85","room_type_id":"298","product_id":"1133","siteminder_id":"GAM-R1697146450","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":"92498","customer_id":"92498","source_of_creation":"Getaroom.com","reservation_created_date":"2019-10-09 13:14:06","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":"50.41","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":"3028979","reservation_id":"85699","confirmation_number":"BV12453430438","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.57,82.57","nightly_discount":"0.00,0.00","subtotal":"165.14","grand_total":"186.61","paid_amount":"186.61","room_type_id":"304","product_id":"1218","siteminder_id":"GAM-R1706442885","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":"92732","customer_id":"92732","source_of_creation":"Getaroom.com","reservation_created_date":"2019-10-15 18:45:08","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"82.57","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":[{"room_stay_id":"3003637","reservation_id":"81542","confirmation_number":"BP12548368955","room_stay_from":"2019-10-15","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.1,71.1,71.1","nightly_discount":"0,0,0","subtotal":"213.30","grand_total":"241.03","paid_amount":"241.03","room_type_id":"295","product_id":"1128","siteminder_id":"ZOO-5739-1819-7362","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":"89444","customer_id":"89444","source_of_creation":"Travelzoo","reservation_created_date":"2019-07-27 14:50: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":"71.1","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"}]}],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3026082","reservation_id":"85272","confirmation_number":"PB12389998697","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.16,124.16","nightly_discount":"0,0","subtotal":"248.32","grand_total":"323.99","paid_amount":"323.99","room_type_id":"286","product_id":"1086","siteminder_id":"ABB-HMADA58KNJ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"248.32","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92445","customer_id":"92445","source_of_creation":"Airbnb","reservation_created_date":"2019-10-07 21:16:07","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"34.71","commision_charges":"7.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.16","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3009615","reservation_id":"82485","confirmation_number":"PB12336944945","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"112.00,128.00","nightly_discount":"0.00,0.00","subtotal":"240.00","grand_total":"271.20","paid_amount":"271.20","room_type_id":"289","product_id":"1100","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":"59477","customer_id":"59477","source_of_creation":"FE","reservation_created_date":"2019-08-11 21:03:37","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3014874","reservation_id":"80804","confirmation_number":"PB12361897289","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.80,160.80,160.80,160.80,160.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"804.00","grand_total":"908.52","paid_amount":"908.52","room_type_id":"287","product_id":"1087","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":"88982","customer_id":"88982","source_of_creation":"FE","reservation_created_date":"2019-07-16 10:30:53","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":"160.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":"3027318","reservation_id":"85479","confirmation_number":"BP12575481959","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"72.72,96.80","nightly_discount":"0.00,0.00","subtotal":"169.52","grand_total":"191.56","paid_amount":"191.56","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":"92586","customer_id":"92586","source_of_creation":"FE","reservation_created_date":"2019-10-11 18:54:39","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":"72.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029400","reservation_id":"82226","confirmation_number":"BV12425089204","room_stay_from":"2019-10-16","room_stay_to":"2019-10-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.68,91.20,91.20,67.68,67.68","nightly_discount":"0.00,0.00,0.00,0.00,20.23,0.00","subtotal":"385.44","grand_total":"412.68","paid_amount":"412.68","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":"89953","customer_id":"89953","source_of_creation":"FE","reservation_created_date":"2019-08-08 00:24:59","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":"91.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":"3029572","reservation_id":"85724","confirmation_number":"BP12552691995","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"61.81","nightly_discount":"0.00","subtotal":"61.81","grand_total":"69.85","paid_amount":"0.00","room_type_id":"290","product_id":"1113","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":"92749","customer_id":"92749","source_of_creation":"FE","reservation_created_date":"2019-10-16 15:57:54","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"61.81","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029918","reservation_id":"82888","confirmation_number":"PB12338318586","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00","nightly_discount":"0.00","subtotal":"104.00","grand_total":"117.52","paid_amount":"371.84","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":"26714","customer_id":"26714","source_of_creation":"FE","reservation_created_date":"2019-08-18 20:02:44","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":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2884317","reservation_id":"58415","confirmation_number":"PB12386949407","room_stay_from":"2019-10-17","room_stay_to":"2019-10-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.99,184.99,184.99,184.99,184.99,184.99,184.99","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1294.93","grand_total":"1463.28","paid_amount":"1463.28","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"73602","customer_id":"73602","source_of_creation":"PMS","reservation_created_date":"2018-10-18 17:39:19","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":"184.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2972028","reservation_id":"67964","confirmation_number":"PB12312532644","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,126.00,126.00,126.00,126.00,176.00,176.00,176.00,176.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1334.00","grand_total":"1507.42","paid_amount":"1507.42","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":"53778","customer_id":"53778","source_of_creation":"PMS","reservation_created_date":"2019-01-27 21:38:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3011916","reservation_id":"82884","confirmation_number":"PB12389274640","room_stay_from":"2019-10-16","room_stay_to":"2019-10-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,112.00,112.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"704.00","grand_total":"795.52","paid_amount":"795.52","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":"90378","customer_id":"90378","source_of_creation":"PMS","reservation_created_date":"2019-08-18 19:15:40","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":"96.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3014917","reservation_id":"83395","confirmation_number":"BP12516039474","room_stay_from":"2019-10-16","room_stay_to":"2019-10-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.12,105.12,105.12,132.80,132.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"580.96","grand_total":"656.49","paid_amount":"656.49","room_type_id":"301","product_id":"1136","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":"50585","customer_id":"50585","source_of_creation":"PMS","reservation_created_date":"2019-08-29 15:35:44","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017368","reservation_id":"83756","confirmation_number":"BP12566786808","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"105.12,105.12,105.12,105.12,105.12","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"525.60","grand_total":"593.93","paid_amount":"593.93","room_type_id":"296","product_id":"1130","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":"28631","customer_id":"28631","source_of_creation":"PMS","reservation_created_date":"2019-09-07 22:59:53","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020019","reservation_id":"84210","confirmation_number":"PB12335236649","room_stay_from":"2019-10-15","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00","subtotal":"312.00","grand_total":"352.56","paid_amount":"352.56","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23494","customer_id":"23494","source_of_creation":"PMS","reservation_created_date":"2019-09-16 18:31:24","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022596","reservation_id":"84698","confirmation_number":"BV12495035525","room_stay_from":"2019-10-14","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.96,102.96,102.96,102.96","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"411.84","grand_total":"465.38","paid_amount":"465.38","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":"62294","customer_id":"62294","source_of_creation":"PMS","reservation_created_date":"2019-09-25 22:09:36","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":"102.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3024094","reservation_id":"82419","confirmation_number":"PB12350143627","room_stay_from":"2019-10-17","room_stay_to":"2019-10-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,110.00,110.00,110.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"440.00","grand_total":"497.20","paid_amount":"497.20","room_type_id":"291","product_id":"1115","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":"90064","customer_id":"90064","source_of_creation":"PMS","reservation_created_date":"2019-08-10 19:06:34","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3026568","reservation_id":"85309","confirmation_number":"PB12394680342","room_stay_from":"2019-10-15","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00","subtotal":"297.00","grand_total":"335.61","paid_amount":"335.61","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":"42330","customer_id":"42330","source_of_creation":"PMS","reservation_created_date":"2019-10-08 18:42:53","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":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3026584","reservation_id":"81489","confirmation_number":"PB12350942121","room_stay_from":"2019-10-09","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,112.00,112.00,96.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,40.00,0.00","subtotal":"896.00","grand_total":"967.28","paid_amount":"967.28","room_type_id":"289","product_id":"1101","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":"23448","customer_id":"23448","source_of_creation":"PMS","reservation_created_date":"2019-07-26 19:02:16","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":"96.00","currentDayDiscount":"40.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3027324","reservation_id":"80408","confirmation_number":"PB12342949398","room_stay_from":"2019-10-11","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00,112.00,96.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,33.52,0.00,0.00,0.00,0.00,0.00","subtotal":"704.00","grand_total":"757.64","paid_amount":"757.64","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":"23875","customer_id":"23875","source_of_creation":"PMS","reservation_created_date":"2019-07-08 20:42:37","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":"96.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3027640","reservation_id":"58524","confirmation_number":"PB12364155478","room_stay_from":"2019-10-12","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00,130.00,130.00,130.00","nightly_discount":"0.00,43.65,0.00,0.00,0.00,0.00,0.00","subtotal":"910.00","grand_total":"978.97","paid_amount":"978.98","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":"44703","customer_id":"44703","source_of_creation":"PMS","reservation_created_date":"2018-10-19 22:19:23","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3027696","reservation_id":"83391","confirmation_number":"PB12333843543","room_stay_from":"2019-10-12","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"164.80,148.80,148.80,148.80,148.80,148.80,164.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,50.00,0.00","subtotal":"1073.60","grand_total":"1156.67","paid_amount":"1156.67","room_type_id":"287","product_id":"1089","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"54583","customer_id":"54583","source_of_creation":"PMS","reservation_created_date":"2019-08-29 14:56:21","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":"148.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":"3027928","reservation_id":"85579","confirmation_number":"BP12524568456","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"495.00","grand_total":"559.35","paid_amount":"559.35","room_type_id":"301","product_id":"1137","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":"66981","customer_id":"66981","source_of_creation":"PMS","reservation_created_date":"2019-10-13 14:55:44","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3027973","reservation_id":"58398","confirmation_number":"PB12382881918","room_stay_from":"2019-10-13","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,126.00,126.00,126.00,126.00,176.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,38.60,0.00","subtotal":"806.00","grand_total":"867.16","paid_amount":"867.16","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":"42365","customer_id":"42365","source_of_creation":"PMS","reservation_created_date":"2018-10-18 12:56:41","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028641","reservation_id":"85551","confirmation_number":"PB12372474260","room_stay_from":"2019-10-15","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.32,89.32,89.32","nightly_discount":"0.00,0.00,0.00","subtotal":"267.96","grand_total":"302.80","paid_amount":"302.80","room_type_id":"291","product_id":"1118","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92622","customer_id":"92622","source_of_creation":"PMS","reservation_created_date":"2019-10-15 15:39:05","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.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":"3028643","reservation_id":"85690","confirmation_number":"PB12371425646","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.20,95.20","nightly_discount":"0.00,0.00","subtotal":"190.40","grand_total":"215.15","paid_amount":"215.15","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":"92724","customer_id":"92724","source_of_creation":"PMS","reservation_created_date":"2019-10-15 15:46:56","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":"95.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":"3028986","reservation_id":"85722","confirmation_number":"PB12390130298","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00","nightly_discount":"0.00,0.00","subtotal":"190.00","grand_total":"214.70","paid_amount":"214.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":"92748","customer_id":"92748","source_of_creation":"PMS","reservation_created_date":"2019-10-16 15:44:13","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":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029068","reservation_id":"80650","confirmation_number":"PB12334313249","room_stay_from":"2019-10-16","room_stay_to":"2019-10-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,112.00,112.00,96.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,45.40,0.00","subtotal":"896.00","grand_total":"961.18","paid_amount":"961.18","room_type_id":"289","product_id":"1103","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":"25925","customer_id":"25925","source_of_creation":"PMS","reservation_created_date":"2019-07-13 15:12:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029406","reservation_id":"83437","confirmation_number":"BV12467840549","room_stay_from":"2019-10-16","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.68,67.68,91.20","nightly_discount":"0.00,0.00,13.49,0.00","subtotal":"226.56","grand_total":"240.76","paid_amount":"240.76","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":"90770","customer_id":"90770","source_of_creation":"PMS","reservation_created_date":"2019-08-30 14:58:21","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":"67.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029684","reservation_id":"67964","confirmation_number":"PB12322074787","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"126.00,126.00,126.00,126.00,126.00,176.00,176.00,176.00,176.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1334.00","grand_total":"1507.42","paid_amount":"1507.42","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":"53778","customer_id":"53778","source_of_creation":"PMS","reservation_created_date":"2019-01-27 21:38:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029718","reservation_id":"67964","confirmation_number":"PB12367288183","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"126.00,126.00,126.00,126.00,126.00,176.00,176.00,176.00,176.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1334.00","grand_total":"1507.42","paid_amount":"1507.42","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"53778","customer_id":"53778","source_of_creation":"PMS","reservation_created_date":"2019-01-27 21:38:22","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":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029889","reservation_id":"83401","confirmation_number":"BV12450321797","room_stay_from":"2019-10-15","room_stay_to":"2019-10-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.68,67.68,67.68,91.20,91.20,79.00","nightly_discount":"0.00,0.00,0.00,0.00,25.14,0.00","subtotal":"464.44","grand_total":"496.41","paid_amount":"496.41","room_type_id":"304","product_id":"1220","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90740","customer_id":"90740","source_of_creation":"PMS","reservation_created_date":"2019-08-29 18:58:12","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029980","reservation_id":"77762","confirmation_number":"PB12368165608","room_stay_from":"2019-10-15","room_stay_to":"2019-10-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.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,38.60","subtotal":"700.00","grand_total":"747.38","paid_amount":"747.38","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":"48250","customer_id":"48250","source_of_creation":"PMS","reservation_created_date":"2019-06-01 17:17:45","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":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3030396","reservation_id":"81776","confirmation_number":"BV12430506818","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.96,102.96","nightly_discount":"0.00,0.00","subtotal":"205.92","grand_total":"232.69","paid_amount":"232.69","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"40658","customer_id":"40658","source_of_creation":"PMS","reservation_created_date":"2019-07-31 20:28:08","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"102.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3030843","reservation_id":"82803","confirmation_number":"PB12310050125","room_stay_from":"2019-10-16","room_stay_to":"2019-10-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.43,87.43,89.54,89.54","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"353.94","grand_total":"399.96","paid_amount":"399.96","room_type_id":"291","product_id":"1114","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":"90328","customer_id":"90328","source_of_creation":"PMS","reservation_created_date":"2019-08-17 13:13:53","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"87.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3037957","reservation_id":"84248","confirmation_number":"BP12569924754","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.73,65.86","nightly_discount":"0.00,0.00","subtotal":"119.59","grand_total":"135.14","paid_amount":"135.14","room_type_id":"294","product_id":"1125","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91732","customer_id":"91732","source_of_creation":"PMS","reservation_created_date":"2019-09-17 14:58:52","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"53.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3037973","reservation_id":"85760","confirmation_number":"BP12578382711","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.73","nightly_discount":"0.00","subtotal":"53.73","grand_total":"60.71","paid_amount":"60.71","room_type_id":"289","product_id":"1099","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":"92716","customer_id":"92716","source_of_creation":"PMS","reservation_created_date":"2019-10-16 21:47:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"53.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3037981","reservation_id":"85732","confirmation_number":"BV12470859322","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.73,65.86","nightly_discount":"0.00,0.00","subtotal":"119.59","grand_total":"135.14","paid_amount":"135.14","room_type_id":"305","product_id":"1222","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":"92757","customer_id":"92757","source_of_creation":"PMS","reservation_created_date":"2019-10-16 19:01:47","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":"53.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029633","reservation_id":"85631","confirmation_number":"PB12330391438","room_stay_from":"2019-10-16","room_stay_to":"2019-10-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","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":"42330","customer_id":"42330","source_of_creation":"PMS","reservation_created_date":"2019-10-14 13:12:24","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":"","changedComment":"Nightly price or discount changed","deltaChange":"-13.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":"3029631","reservation_id":"85637","confirmation_number":"PB12337471421","room_stay_from":"2019-10-16","room_stay_to":"2019-10-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"290","product_id":"1113","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":"42330","customer_id":"42330","source_of_creation":"PMS","reservation_created_date":"2019-10-14 14:41:23","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"16.44","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"}]}],"pms_non_taxable":[{"room_stay_id":"3019925","reservation_id":"82811","confirmation_number":"PB12364219241","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00,128.00","nightly_discount":"0.00,0.00","subtotal":"240.00","grand_total":"271.20","paid_amount":"126.56","room_type_id":"288","product_id":"1091","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":"89358","customer_id":"89358","source_of_creation":"PMS","reservation_created_date":"2019-08-17 15:07:54","service_canceled_date_time":"2019-10-15 18:49:57","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"126.56","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2964420","reservation_id":"74516","confirmation_number":"BV12229489243","room_confirmation_number":"BV12425373944","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"20,20,20,20,20","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":"1780","service_quantity":"1","customer_traveller_id":"84920","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-04-11 20:24:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84920","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3009617","reservation_id":"82485","confirmation_number":"PB12228906782","room_confirmation_number":"PB12336944945","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"10.00,10.00","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":"59477","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-08-11 21:03:37","reservation_modified_date_time":"2019-08-11 21:03:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"59477","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017685","reservation_id":"83508","confirmation_number":"PB12238957106","room_confirmation_number":"PB12324751175","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"90809","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-09-08 23:11:24","reservation_modified_date_time":"2019-09-08 23:11:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90809","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":"3021824","reservation_id":"80713","confirmation_number":"PB12257299833","room_confirmation_number":"PB12357092937","room_stay_from":"2019-10-13","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","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":"1780","service_quantity":"1","customer_traveller_id":"88910","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-09-22 12:07:55","reservation_modified_date_time":"2019-09-22 12:07:55","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88910","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3027693","reservation_id":"83391","confirmation_number":"PB12247621698","room_confirmation_number":"PB12333843543","room_stay_from":"2019-10-12","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0,0","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"54583","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-10-12 19:50:35","reservation_modified_date_time":"2019-10-12 19:50:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"54583","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":"3029686","reservation_id":"67964","confirmation_number":"PB12230767215","room_confirmation_number":"PB12322074787","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20,20","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"53778","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-10-17 22:21:50","reservation_modified_date_time":"2019-10-17 22:21:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53778","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029719","reservation_id":"67964","confirmation_number":"PB12237353398","room_confirmation_number":"PB12367288183","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"10.00,30.00,30.00,30.00,30.00,30.00,30.00,30.00,30.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"282.50","paid_amount":"282.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"53778","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-10-17 22:29:07","reservation_modified_date_time":"2019-10-17 22:30:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53778","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2898913","reservation_id":"58415","confirmation_number":"PBR12288570859","room_confirmation_number":"PB12386949407","room_stay_from":"2019-10-17","room_stay_to":"2019-10-24","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":"73602","product_attribute_values":"resort_fee#&#flat_rate#&#12.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":"73602","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":"2964421","reservation_id":"74516","confirmation_number":"BV12210622948","room_confirmation_number":"BV12425373944","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","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":"84920","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-04-11 20:24:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84920","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":"2972029","reservation_id":"67964","confirmation_number":"PB12280900482","room_confirmation_number":"PB12312532644","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"53776","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-27 21:38:21","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53778","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":"2984508","reservation_id":"78017","confirmation_number":"BP12251751227","room_confirmation_number":"BP12579983751","room_stay_from":"2019-10-09","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"87209","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-05 12:13:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"34980","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":"2987114","reservation_id":"78488","confirmation_number":"BV12280727834","room_confirmation_number":"BV12457273097","room_stay_from":"2019-10-17","room_stay_to":"2019-10-23","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":"87540","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-11 20:51: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":"87540","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":"2999692","reservation_id":"80882","confirmation_number":"PB12225381027","room_confirmation_number":"PB12365064632","room_stay_from":"2019-10-17","room_stay_to":"2019-10-21","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":"89046","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-17 20:19: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":"89046","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":"3003638","reservation_id":"81542","confirmation_number":"BP12288067545","room_confirmation_number":"BP12548368955","room_stay_from":"2019-10-15","room_stay_to":"2019-10-18","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":"89444","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-27 14:50: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":"89444","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":"3009616","reservation_id":"82485","confirmation_number":"PB12214503009","room_confirmation_number":"PB12336944945","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","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":"59477","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-11 21:03:37","reservation_modified_date_time":"2019-08-11 21:03:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"59477","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":"3010958","reservation_id":"82736","confirmation_number":"PB12239879715","room_confirmation_number":"PB12374986190","room_stay_from":"2019-10-09","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"90283","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-16 13:48:07","reservation_modified_date_time":"2019-08-16 13:48:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90283","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":"3011917","reservation_id":"82884","confirmation_number":"PB12265656185","room_confirmation_number":"PB12389274640","room_stay_from":"2019-10-16","room_stay_to":"2019-10-23","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":"90378","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-18 19:15:40","reservation_modified_date_time":"2019-08-18 19:15:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90378","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":"3014875","reservation_id":"80804","confirmation_number":"PB12294584230","room_confirmation_number":"PB12361897289","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88982","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-16 10:30:53","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88982","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":"3014918","reservation_id":"83395","confirmation_number":"BP12235946890","room_confirmation_number":"BP12516039474","room_stay_from":"2019-10-16","room_stay_to":"2019-10-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"50585","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-29 15:35:44","reservation_modified_date_time":"2019-08-29 15:35:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"50585","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":"3017369","reservation_id":"83756","confirmation_number":"BP12279369600","room_confirmation_number":"BP12566786808","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"28631","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-07 22:59:53","reservation_modified_date_time":"2019-09-07 22:59:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28631","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":"3017686","reservation_id":"83508","confirmation_number":"PB12287064297","room_confirmation_number":"PB12324751175","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","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":"90809","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-01 14:19:10","reservation_modified_date_time":"2019-09-01 14:19:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90809","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":"3017697","reservation_id":"81661","confirmation_number":"PB12262769399","room_confirmation_number":"PB12384000879","room_stay_from":"2019-10-15","room_stay_to":"2019-10-19","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":"89534","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-29 17:12: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":"89534","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":"3020020","reservation_id":"84210","confirmation_number":"PB12268900714","room_confirmation_number":"PB12335236649","room_stay_from":"2019-10-15","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23494","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-16 18:31:24","reservation_modified_date_time":"2019-09-16 18:31:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23494","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":"3021825","reservation_id":"80713","confirmation_number":"PB12242254625","room_confirmation_number":"PB12357092937","room_stay_from":"2019-10-13","room_stay_to":"2019-10-19","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":"88910","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-14 13:06:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88910","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":"3022597","reservation_id":"84698","confirmation_number":"BV12231395070","room_confirmation_number":"BV12495035525","room_stay_from":"2019-10-14","room_stay_to":"2019-10-18","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":"62294","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-25 22:09:36","reservation_modified_date_time":"2019-09-25 22:09:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"62294","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":"3024095","reservation_id":"82419","confirmation_number":"PB12267468860","room_confirmation_number":"PB12350143627","room_stay_from":"2019-10-17","room_stay_to":"2019-10-21","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":"90064","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-10 19:06:34","reservation_modified_date_time":"2019-08-10 19:06:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90064","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":"3024453","reservation_id":"84985","confirmation_number":"PB12236961906","room_confirmation_number":"PB12399662215","room_stay_from":"2019-10-16","room_stay_to":"2019-10-23","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":"92237","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-02 03:02:10","reservation_modified_date_time":"2019-10-02 03:02:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92237","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":"3026083","reservation_id":"85272","confirmation_number":"PB12246144981","room_confirmation_number":"PB12389998697","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","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":"92445","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-07 21:16:07","reservation_modified_date_time":"2019-10-07 21:16:07","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92445","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3026540","reservation_id":"85341","confirmation_number":"BP12288464928","room_confirmation_number":"BP12536792356","room_stay_from":"2019-10-14","room_stay_to":"2019-10-18","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":"92498","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-09 13:14:06","reservation_modified_date_time":"2019-10-09 13:14:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92498","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":"3026569","reservation_id":"85309","confirmation_number":"PB12257000045","room_confirmation_number":"PB12394680342","room_stay_from":"2019-10-15","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"42330","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-08 18:42:53","reservation_modified_date_time":"2019-10-08 18:42:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42330","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":"3026585","reservation_id":"81489","confirmation_number":"PB12235046546","room_confirmation_number":"PB12350942121","room_stay_from":"2019-10-09","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23448","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-26 19:02:16","reservation_modified_date_time":"2019-10-09 18:12:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23448","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":"3027205","reservation_id":"85460","confirmation_number":"PB12260061649","room_confirmation_number":"PB12367458986","room_stay_from":"2019-10-14","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0,0","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"92573","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-11 05:11:09","reservation_modified_date_time":"2019-10-11 05:11:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92573","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":"3027266","reservation_id":"80882","confirmation_number":"PB12247533802","room_confirmation_number":"PB12335134444","room_stay_from":"2019-10-17","room_stay_to":"2019-10-21","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":"89046","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-17 20:19: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":"89046","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":"3027319","reservation_id":"85479","confirmation_number":"BP12244326570","room_confirmation_number":"BP12575481959","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","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":"92586","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-11 18:54:39","reservation_modified_date_time":"2019-10-11 18:54:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92586","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":"3027325","reservation_id":"80408","confirmation_number":"PB12210526346","room_confirmation_number":"PB12342949398","room_stay_from":"2019-10-11","room_stay_to":"2019-10-18","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":"23875","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-08 20:42:37","reservation_modified_date_time":"2019-10-11 18:55:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23875","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":"3027641","reservation_id":"58524","confirmation_number":"PBR12238551180","room_confirmation_number":"PB12364155478","room_stay_from":"2019-10-12","room_stay_to":"2019-10-19","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":"44703","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"2019-10-12 18:01:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44703","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":"3027697","reservation_id":"83391","confirmation_number":"PB12263631482","room_confirmation_number":"PB12333843543","room_stay_from":"2019-10-12","room_stay_to":"2019-10-19","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":"54583","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-29 14:56:21","reservation_modified_date_time":"2019-10-12 19:51:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"54583","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":"3027929","reservation_id":"85579","confirmation_number":"BP12214854702","room_confirmation_number":"BP12524568456","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"66981","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-13 14:55:44","reservation_modified_date_time":"2019-10-13 14:55:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66981","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":"3027974","reservation_id":"58398","confirmation_number":"PBR12210587940","room_confirmation_number":"PB12382881918","room_stay_from":"2019-10-13","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"42365","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"2019-10-13 18:48:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42365","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":"3028644","reservation_id":"85690","confirmation_number":"PB12271686350","room_confirmation_number":"PB12371425646","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","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":"92724","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-15 15:46:56","reservation_modified_date_time":"2019-10-15 15:46:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92724","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":"3028980","reservation_id":"85699","confirmation_number":"BV12287564982","room_confirmation_number":"BV12453430438","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"92732","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-15 18:45:08","reservation_modified_date_time":"2019-10-16 15:08:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92732","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":"3028987","reservation_id":"85722","confirmation_number":"PB12291540642","room_confirmation_number":"PB12390130298","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","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":"92748","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-16 15:44:13","reservation_modified_date_time":"2019-10-16 15:44:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92748","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":"3029069","reservation_id":"80650","confirmation_number":"PB12212144461","room_confirmation_number":"PB12334313249","room_stay_from":"2019-10-16","room_stay_to":"2019-10-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"25925","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-13 15:12:09","reservation_modified_date_time":"2019-10-16 17:07:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"25925","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":"3029401","reservation_id":"82226","confirmation_number":"BV12279904711","room_confirmation_number":"BV12425089204","room_stay_from":"2019-10-16","room_stay_to":"2019-10-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"89953","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-08 00:24:59","reservation_modified_date_time":"2019-10-17 13:27:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89953","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":"3029407","reservation_id":"83437","confirmation_number":"BV12227689556","room_confirmation_number":"BV12467840549","room_stay_from":"2019-10-16","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"90770","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-30 14:58:21","reservation_modified_date_time":"2019-10-17 13:40:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90770","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":"3029573","reservation_id":"85724","confirmation_number":"BP12263380869","room_confirmation_number":"BP12552691995","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"92749","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-16 15:57:54","reservation_modified_date_time":"2019-10-16 15:57:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92749","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":"3029575","reservation_id":"85806","confirmation_number":"PB12267262178","room_confirmation_number":"PB12316424813","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","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":"92812","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-17 19:32:11","reservation_modified_date_time":"2019-10-17 19:32:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92812","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":"3029687","reservation_id":"67964","confirmation_number":"PB12285097202","room_confirmation_number":"PB12322074787","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"81039","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-27 21:38:21","reservation_modified_date_time":"2019-10-17 22:21:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53778","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":"3029720","reservation_id":"67964","confirmation_number":"PB12222232856","room_confirmation_number":"PB12367288183","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"81039","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-27 21:38:22","reservation_modified_date_time":"2019-10-17 22:30:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53778","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":"3029891","reservation_id":"83401","confirmation_number":"BV12250494861","room_confirmation_number":"BV12450321797","room_stay_from":"2019-10-15","room_stay_to":"2019-10-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"90740","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-29 18:58:12","reservation_modified_date_time":"2019-10-18 12:39:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90740","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":"3029904","reservation_id":"81501","confirmation_number":"PB12291675755","room_confirmation_number":"PB12341879694","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","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":"89431","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-26 20:52:11","reservation_modified_date_time":"2019-10-18 14:09:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89431","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":"3029919","reservation_id":"82888","confirmation_number":"PB12298655119","room_confirmation_number":"PB12338318586","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"26714","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-18 20:02:44","reservation_modified_date_time":"2019-10-17 14:05:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26714","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","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":"3029981","reservation_id":"77762","confirmation_number":"PB12279072437","room_confirmation_number":"PB12368165608","room_stay_from":"2019-10-15","room_stay_to":"2019-10-29","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"168.00","grand_total":"189.84","paid_amount":"189.84","product_id":"1781","service_quantity":"1","customer_traveller_id":"48250","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-01 17:17:45","reservation_modified_date_time":"2019-10-15 18:10:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"48250","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":"3030242","reservation_id":"82128","confirmation_number":"PB12238142257","room_confirmation_number":"PB12311504002","room_stay_from":"2019-10-14","room_stay_to":"2019-10-19","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":"89882","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-06 16:47:09","reservation_modified_date_time":"2019-10-19 14:51:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89882","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":"3030397","reservation_id":"81776","confirmation_number":"BV12276815589","room_confirmation_number":"BV12430506818","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","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":"40658","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-31 20:28:08","reservation_modified_date_time":"2019-10-17 17:23:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"40658","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","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":"3031430","reservation_id":"81537","confirmation_number":"BV12235881801","room_confirmation_number":"BV12465999909","room_stay_from":"2019-10-16","room_stay_to":"2019-10-22","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":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"89442","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-27 12:23: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":"89442","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":"3037958","reservation_id":"84248","confirmation_number":"BP12291964950","room_confirmation_number":"BP12569924754","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"91732","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-17 14:58:52","reservation_modified_date_time":"2019-11-13 20:43:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91732","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":"3037974","reservation_id":"85760","confirmation_number":"BP12290721959","room_confirmation_number":"BP12578382711","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","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":"92716","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-16 21:47:09","reservation_modified_date_time":"2019-11-13 20:49:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92716","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":"3037982","reservation_id":"85732","confirmation_number":"BV12298761791","room_confirmation_number":"BV12470859322","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"92757","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-16 19:01:47","reservation_modified_date_time":"2019-11-13 20:53:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92757","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":"3029370","reservation_id":"85785","confirmation_number":"PB12255001472","room_confirmation_number":"PB12367217210","room_stay_from":"2019-10-16","room_stay_to":"2019-10-17","room_stay_status":"Canceled","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-17 06:38:09","reservation_modified_date_time":"2019-10-17 06:38:09","customer_id":"92801","parentCustTravId":"92801","customer_traveller_id":"92801","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-10-17 20:22:31","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#20","deltaChange":-20,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"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":"3015213","reservation_id":"83437","confirmation_number":"BV12228717186","room_confirmation_number":"BV12467840549","room_stay_from":"2019-10-16","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.75","paid_amount":"84.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-30 15:01:22","reservation_modified_date_time":"2019-08-30 15:01:22","customer_id":"90770","parentCustTravId":"90770","customer_traveller_id":"90770","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":"3026532","reservation_id":"78017","confirmation_number":"BP12213314079","room_confirmation_number":"BP12579983751","room_stay_from":"2019-10-09","room_stay_to":"2019-10-19","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"282.50","paid_amount":"282.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-09 12:20:20","reservation_modified_date_time":"2019-10-09 12:20:20","customer_id":"34980","parentCustTravId":"34980","customer_traveller_id":"87209","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":"3029890","reservation_id":"83401","confirmation_number":"BV12276253114","room_confirmation_number":"BV12450321797","room_stay_from":"2019-10-15","room_stay_to":"2019-10-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,50.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"169.50","paid_amount":"169.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-29 18:58:12","reservation_modified_date_time":"2019-10-18 12:39:59","customer_id":"90740","parentCustTravId":"90740","customer_traveller_id":"90740","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":"3024446","reservation_id":"84983","confirmation_number":"BV12283410192","room_confirmation_number":"BV12443362281","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"0.00","product_id":"1147","service_quantity":"1","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-02 02:29:56","reservation_modified_date_time":"2019-10-02 02:29:56","customer_id":"92236","parentCustTravId":"92236","customer_traveller_id":"92236","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-10-18 01:22:30","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-10,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3024447","reservation_id":"84983","confirmation_number":"BV12243501502","room_confirmation_number":"BV12443362281","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.25","paid_amount":"0.00","product_id":"1146","service_quantity":"1","product_name":"Boat Dockage","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-02 02:29:56","reservation_modified_date_time":"2019-10-02 02:29:56","customer_id":"92236","parentCustTravId":"92236","customer_traveller_id":"92236","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-10-18 01:22:30","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"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":15,"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":"2999691","reservation_id":"80882","confirmation_number":"PB12365064632","room_stay_from":"2019-10-17","room_stay_to":"2019-10-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.83,125.27,125.27,113.83","nightly_discount":"0,0,0,0","subtotal":"478.20","grand_total":"540.36","paid_amount":"540.36","room_type_id":"285","product_id":"1085","siteminder_id":"BDC-2496328660","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":"89046","customer_id":"89046","source_of_creation":"Booking.com","reservation_created_date":"2019-07-17 20:19:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"143.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.83","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":"3010957","reservation_id":"82736","confirmation_number":"PB12374986190","room_stay_from":"2019-10-09","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.83,113.83,125.27,125.27,113.83,113.83,113.83,113.83,113.83,125.27","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"1172.62","grand_total":"1325.06","paid_amount":"1325.06","room_type_id":"289","product_id":"1108","siteminder_id":"BDC-2219382914","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":"90283","customer_id":"90283","source_of_creation":"Booking.com","reservation_created_date":"2019-08-16 13:48:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"175.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.83","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":"3017684","reservation_id":"83508","confirmation_number":"PB12324751175","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"113.58,113.58,113.58,113.58,113.58","nightly_discount":"0,0,0,0,0","subtotal":"567.90","grand_total":"641.72","paid_amount":"641.72","room_type_id":"289","product_id":"1106","siteminder_id":"BDC-3689773294","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90809","customer_id":"90809","source_of_creation":"Booking.com","reservation_created_date":"2019-09-01 14:19:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"92.69","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3027265","reservation_id":"80882","confirmation_number":"PB12335134444","room_stay_from":"2019-10-17","room_stay_to":"2019-10-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.83,125.27,125.27,113.83","nightly_discount":"0,0,0,0","subtotal":"478.20","grand_total":"540.36","paid_amount":"540.36","room_type_id":"289","product_id":"1097","siteminder_id":"BDC-2496328660","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":"89046","customer_id":"89046","source_of_creation":"Booking.com","reservation_created_date":"2019-07-17 20:19:18","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"143.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.83","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":"3029574","reservation_id":"85806","confirmation_number":"PB12316424813","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.38","nightly_discount":"0","subtotal":"80.38","grand_total":"90.83","paid_amount":"90.83","room_type_id":"285","product_id":"1084","siteminder_id":"BDC-2417025514","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":"92812","customer_id":"92812","source_of_creation":"Booking.com","reservation_created_date":"2019-10-17 19:32:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"12.06","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"80.38","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029903","reservation_id":"81501","confirmation_number":"PB12341879694","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"102.58","nightly_discount":"0.00","subtotal":"102.58","grand_total":"115.91","paid_amount":"115.92","room_type_id":"285","product_id":"1083","siteminder_id":"BDC-2602766070","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":"89431","customer_id":"89431","source_of_creation":"Booking.com","reservation_created_date":"2019-07-26 20:52:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"15.37","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"102.58","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":[{"room_stay_id":"3029533","reservation_id":"85798","confirmation_number":"PB12341017909","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"59.46","nightly_discount":"0","subtotal":"59.46","grand_total":"67.19","paid_amount":"67.19","room_type_id":"290","product_id":"1113","siteminder_id":"BDC-2653098850","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":"92809","customer_id":"92809","source_of_creation":"Booking.com","reservation_created_date":"2019-10-17 18:32:11","service_canceled_date_time":"2019-10-17 19:10:06","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"8.92","deltaChange":"67.19","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3017696","reservation_id":"81661","confirmation_number":"PB12384000879","room_stay_from":"2019-10-15","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.07,105.07,105.07,115.63","nightly_discount":"0,0,0,0","subtotal":"430.84","grand_total":"486.85","paid_amount":"486.85","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1310603079","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":"89534","customer_id":"89534","source_of_creation":"Expedia","reservation_created_date":"2019-07-29 17:12: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":"105.07","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3021823","reservation_id":"80713","confirmation_number":"PB12357092937","room_stay_from":"2019-10-13","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"99.15,99.15,99.15,99.15,99.15,107.81","nightly_discount":"0,0,0,0,0,0","subtotal":"603.56","grand_total":"682.02","paid_amount":"682.02","room_type_id":"291","product_id":"1119","siteminder_id":"EXP-1299598639","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88910","customer_id":"88910","source_of_creation":"Expedia","reservation_created_date":"2019-07-14 13:06:06","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.15","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":"3024452","reservation_id":"84985","confirmation_number":"PB12399662215","room_stay_from":"2019-10-16","room_stay_to":"2019-10-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.11,105.11,113.55,113.55,105.11,105.11,105.11","nightly_discount":"0,0,0,0,0,0,0","subtotal":"752.65","grand_total":"850.50","paid_amount":"850.50","room_type_id":"288","product_id":"1092","siteminder_id":"EXP-1353598627","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":"92237","customer_id":"92237","source_of_creation":"Expedia","reservation_created_date":"2019-10-02 03:02:10","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.11","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3027204","reservation_id":"85460","confirmation_number":"PB12367458986","room_stay_from":"2019-10-14","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.16,86.16,86.16,86.16","nightly_discount":"0,0,0,0","subtotal":"344.64","grand_total":"389.44","paid_amount":"389.44","room_type_id":"289","product_id":"1107","siteminder_id":"EXP-1359598451","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":"92573","customer_id":"92573","source_of_creation":"Expedia","reservation_created_date":"2019-10-11 05:11: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":"86.16","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":"3030241","reservation_id":"82128","confirmation_number":"PB12311504002","room_stay_from":"2019-10-14","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.16,86.16,86.16,86.16,94.82","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"439.46","grand_total":"496.59","paid_amount":"496.59","room_type_id":"289","product_id":"1098","siteminder_id":"EXP-1316296292","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":"89882","customer_id":"89882","source_of_creation":"Expedia","reservation_created_date":"2019-08-06 16:47:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"86.16","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029369","reservation_id":"85785","confirmation_number":"PB12367217210","room_stay_from":"2019-10-16","room_stay_to":"2019-10-17","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"79.34","nightly_discount":"0","subtotal":"79.34","grand_total":"89.65","paid_amount":"0.00","room_type_id":"297","product_id":"1132","siteminder_id":"EXP-1362955219","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":"92801","customer_id":"92801","source_of_creation":"Expedia","reservation_created_date":"2019-10-17 06:38:09","service_canceled_date_time":"2019-10-17 20:22:31","canceled_nights_data":"","product_name":"BP Deluxe Two Bedroom Suite 2Q, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":-79.34,"changedComment":"reservation is canceled","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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3026082","reservation_id":"85272","confirmation_number":"PB12389998697","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.16,124.16","nightly_discount":"0,0","subtotal":"248.32","grand_total":"323.99","paid_amount":"323.99","room_type_id":"286","product_id":"1086","siteminder_id":"ABB-HMADA58KNJ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"248.32","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92445","customer_id":"92445","source_of_creation":"Airbnb","reservation_created_date":"2019-10-07 21:16:07","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"34.71","commision_charges":"7.68","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.16","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3009615","reservation_id":"82485","confirmation_number":"PB12336944945","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"112.00,128.00","nightly_discount":"0.00,0.00","subtotal":"240.00","grand_total":"271.20","paid_amount":"271.20","room_type_id":"289","product_id":"1100","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":"59477","customer_id":"59477","source_of_creation":"FE","reservation_created_date":"2019-08-11 21:03:37","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3014874","reservation_id":"80804","confirmation_number":"PB12361897289","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.80,160.80,160.80,160.80,160.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"804.00","grand_total":"908.52","paid_amount":"908.52","room_type_id":"287","product_id":"1087","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":"88982","customer_id":"88982","source_of_creation":"FE","reservation_created_date":"2019-07-16 10:30:53","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":"160.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":"3029918","reservation_id":"82888","confirmation_number":"PB12338318586","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00","nightly_discount":"0.00","subtotal":"104.00","grand_total":"117.52","paid_amount":"371.84","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":"26714","customer_id":"26714","source_of_creation":"FE","reservation_created_date":"2019-08-18 20:02:44","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":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2884317","reservation_id":"58415","confirmation_number":"PB12386949407","room_stay_from":"2019-10-17","room_stay_to":"2019-10-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.99,184.99,184.99,184.99,184.99,184.99,184.99","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1294.93","grand_total":"1463.28","paid_amount":"1463.28","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"73602","customer_id":"73602","source_of_creation":"PMS","reservation_created_date":"2018-10-18 17:39:19","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":"184.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2972028","reservation_id":"67964","confirmation_number":"PB12312532644","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,126.00,126.00,126.00,126.00,176.00,176.00,176.00,176.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1334.00","grand_total":"1507.42","paid_amount":"1507.42","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":"53778","customer_id":"53778","source_of_creation":"PMS","reservation_created_date":"2019-01-27 21:38:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3011916","reservation_id":"82884","confirmation_number":"PB12389274640","room_stay_from":"2019-10-16","room_stay_to":"2019-10-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,112.00,112.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"704.00","grand_total":"795.52","paid_amount":"795.52","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":"90378","customer_id":"90378","source_of_creation":"PMS","reservation_created_date":"2019-08-18 19:15:40","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":"96.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020019","reservation_id":"84210","confirmation_number":"PB12335236649","room_stay_from":"2019-10-15","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00","subtotal":"312.00","grand_total":"352.56","paid_amount":"352.56","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23494","customer_id":"23494","source_of_creation":"PMS","reservation_created_date":"2019-09-16 18:31:24","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3024094","reservation_id":"82419","confirmation_number":"PB12350143627","room_stay_from":"2019-10-17","room_stay_to":"2019-10-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,110.00,110.00,110.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"440.00","grand_total":"497.20","paid_amount":"497.20","room_type_id":"291","product_id":"1115","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":"90064","customer_id":"90064","source_of_creation":"PMS","reservation_created_date":"2019-08-10 19:06:34","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3026568","reservation_id":"85309","confirmation_number":"PB12394680342","room_stay_from":"2019-10-15","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00","subtotal":"297.00","grand_total":"335.61","paid_amount":"335.61","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":"42330","customer_id":"42330","source_of_creation":"PMS","reservation_created_date":"2019-10-08 18:42:53","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":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3026584","reservation_id":"81489","confirmation_number":"PB12350942121","room_stay_from":"2019-10-09","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,112.00,112.00,96.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,40.00,0.00","subtotal":"896.00","grand_total":"967.28","paid_amount":"967.28","room_type_id":"289","product_id":"1101","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":"23448","customer_id":"23448","source_of_creation":"PMS","reservation_created_date":"2019-07-26 19:02:16","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":"96.00","currentDayDiscount":"40.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3027324","reservation_id":"80408","confirmation_number":"PB12342949398","room_stay_from":"2019-10-11","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00,112.00,96.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,33.52,0.00,0.00,0.00,0.00,0.00","subtotal":"704.00","grand_total":"757.64","paid_amount":"757.64","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":"23875","customer_id":"23875","source_of_creation":"PMS","reservation_created_date":"2019-07-08 20:42:37","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":"96.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3027640","reservation_id":"58524","confirmation_number":"PB12364155478","room_stay_from":"2019-10-12","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00,130.00,130.00,130.00","nightly_discount":"0.00,43.65,0.00,0.00,0.00,0.00,0.00","subtotal":"910.00","grand_total":"978.97","paid_amount":"978.98","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":"44703","customer_id":"44703","source_of_creation":"PMS","reservation_created_date":"2018-10-19 22:19:23","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3027696","reservation_id":"83391","confirmation_number":"PB12333843543","room_stay_from":"2019-10-12","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"164.80,148.80,148.80,148.80,148.80,148.80,164.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,50.00,0.00","subtotal":"1073.60","grand_total":"1156.67","paid_amount":"1156.67","room_type_id":"287","product_id":"1089","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"54583","customer_id":"54583","source_of_creation":"PMS","reservation_created_date":"2019-08-29 14:56:21","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":"148.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":"3027973","reservation_id":"58398","confirmation_number":"PB12382881918","room_stay_from":"2019-10-13","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,126.00,126.00,126.00,126.00,176.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,38.60,0.00","subtotal":"806.00","grand_total":"867.16","paid_amount":"867.16","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":"42365","customer_id":"42365","source_of_creation":"PMS","reservation_created_date":"2018-10-18 12:56:41","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028641","reservation_id":"85551","confirmation_number":"PB12372474260","room_stay_from":"2019-10-15","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.32,89.32,89.32","nightly_discount":"0.00,0.00,0.00","subtotal":"267.96","grand_total":"302.80","paid_amount":"302.80","room_type_id":"291","product_id":"1118","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92622","customer_id":"92622","source_of_creation":"PMS","reservation_created_date":"2019-10-15 15:39:05","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.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":"3028643","reservation_id":"85690","confirmation_number":"PB12371425646","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.20,95.20","nightly_discount":"0.00,0.00","subtotal":"190.40","grand_total":"215.15","paid_amount":"215.15","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":"92724","customer_id":"92724","source_of_creation":"PMS","reservation_created_date":"2019-10-15 15:46:56","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":"95.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":"3028986","reservation_id":"85722","confirmation_number":"PB12390130298","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00","nightly_discount":"0.00,0.00","subtotal":"190.00","grand_total":"214.70","paid_amount":"214.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":"92748","customer_id":"92748","source_of_creation":"PMS","reservation_created_date":"2019-10-16 15:44:13","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":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029068","reservation_id":"80650","confirmation_number":"PB12334313249","room_stay_from":"2019-10-16","room_stay_to":"2019-10-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,112.00,112.00,96.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,45.40,0.00","subtotal":"896.00","grand_total":"961.18","paid_amount":"961.18","room_type_id":"289","product_id":"1103","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":"25925","customer_id":"25925","source_of_creation":"PMS","reservation_created_date":"2019-07-13 15:12:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029684","reservation_id":"67964","confirmation_number":"PB12322074787","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"126.00,126.00,126.00,126.00,126.00,176.00,176.00,176.00,176.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1334.00","grand_total":"1507.42","paid_amount":"1507.42","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":"53778","customer_id":"53778","source_of_creation":"PMS","reservation_created_date":"2019-01-27 21:38:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029718","reservation_id":"67964","confirmation_number":"PB12367288183","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"126.00,126.00,126.00,126.00,126.00,176.00,176.00,176.00,176.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1334.00","grand_total":"1507.42","paid_amount":"1507.42","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"53778","customer_id":"53778","source_of_creation":"PMS","reservation_created_date":"2019-01-27 21:38:22","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":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029980","reservation_id":"77762","confirmation_number":"PB12368165608","room_stay_from":"2019-10-15","room_stay_to":"2019-10-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.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,38.60","subtotal":"700.00","grand_total":"747.38","paid_amount":"747.38","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":"48250","customer_id":"48250","source_of_creation":"PMS","reservation_created_date":"2019-06-01 17:17:45","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":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3030843","reservation_id":"82803","confirmation_number":"PB12310050125","room_stay_from":"2019-10-16","room_stay_to":"2019-10-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.43,87.43,89.54,89.54","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"353.94","grand_total":"399.96","paid_amount":"399.96","room_type_id":"291","product_id":"1114","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":"90328","customer_id":"90328","source_of_creation":"PMS","reservation_created_date":"2019-08-17 13:13:53","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"87.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029633","reservation_id":"85631","confirmation_number":"PB12330391438","room_stay_from":"2019-10-16","room_stay_to":"2019-10-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","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":"42330","customer_id":"42330","source_of_creation":"PMS","reservation_created_date":"2019-10-14 13:12:24","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":"","changedComment":"Nightly price or discount changed","deltaChange":"-13.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":"3029631","reservation_id":"85637","confirmation_number":"PB12337471421","room_stay_from":"2019-10-16","room_stay_to":"2019-10-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"290","product_id":"1113","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":"42330","customer_id":"42330","source_of_creation":"PMS","reservation_created_date":"2019-10-14 14:41:23","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"16.44","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"}]}],"pms_non_taxable":[{"room_stay_id":"3019925","reservation_id":"82811","confirmation_number":"PB12364219241","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00,128.00","nightly_discount":"0.00,0.00","subtotal":"240.00","grand_total":"271.20","paid_amount":"126.56","room_type_id":"288","product_id":"1091","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":"89358","customer_id":"89358","source_of_creation":"PMS","reservation_created_date":"2019-08-17 15:07:54","service_canceled_date_time":"2019-10-15 18:49:57","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"126.56","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3009617","reservation_id":"82485","confirmation_number":"PB12228906782","room_confirmation_number":"PB12336944945","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"10.00,10.00","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":"59477","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-08-11 21:03:37","reservation_modified_date_time":"2019-08-11 21:03:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"59477","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017685","reservation_id":"83508","confirmation_number":"PB12238957106","room_confirmation_number":"PB12324751175","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"90809","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-09-08 23:11:24","reservation_modified_date_time":"2019-09-08 23:11:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90809","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":"3021824","reservation_id":"80713","confirmation_number":"PB12257299833","room_confirmation_number":"PB12357092937","room_stay_from":"2019-10-13","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","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":"1780","service_quantity":"1","customer_traveller_id":"88910","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-09-22 12:07:55","reservation_modified_date_time":"2019-09-22 12:07:55","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88910","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3027693","reservation_id":"83391","confirmation_number":"PB12247621698","room_confirmation_number":"PB12333843543","room_stay_from":"2019-10-12","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0,0","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"54583","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-10-12 19:50:35","reservation_modified_date_time":"2019-10-12 19:50:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"54583","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":"3029686","reservation_id":"67964","confirmation_number":"PB12230767215","room_confirmation_number":"PB12322074787","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20,20","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"53778","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-10-17 22:21:50","reservation_modified_date_time":"2019-10-17 22:21:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53778","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029719","reservation_id":"67964","confirmation_number":"PB12237353398","room_confirmation_number":"PB12367288183","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"10.00,30.00,30.00,30.00,30.00,30.00,30.00,30.00,30.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"282.50","paid_amount":"282.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"53778","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-10-17 22:29:07","reservation_modified_date_time":"2019-10-17 22:30:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53778","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2898913","reservation_id":"58415","confirmation_number":"PBR12288570859","room_confirmation_number":"PB12386949407","room_stay_from":"2019-10-17","room_stay_to":"2019-10-24","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":"73602","product_attribute_values":"resort_fee#&#flat_rate#&#12.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":"73602","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":"2972029","reservation_id":"67964","confirmation_number":"PB12280900482","room_confirmation_number":"PB12312532644","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"53776","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-27 21:38:21","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53778","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":"2999692","reservation_id":"80882","confirmation_number":"PB12225381027","room_confirmation_number":"PB12365064632","room_stay_from":"2019-10-17","room_stay_to":"2019-10-21","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":"89046","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-17 20:19: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":"89046","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":"3009616","reservation_id":"82485","confirmation_number":"PB12214503009","room_confirmation_number":"PB12336944945","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","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":"59477","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-11 21:03:37","reservation_modified_date_time":"2019-08-11 21:03:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"59477","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":"3010958","reservation_id":"82736","confirmation_number":"PB12239879715","room_confirmation_number":"PB12374986190","room_stay_from":"2019-10-09","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"90283","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-16 13:48:07","reservation_modified_date_time":"2019-08-16 13:48:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90283","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":"3011917","reservation_id":"82884","confirmation_number":"PB12265656185","room_confirmation_number":"PB12389274640","room_stay_from":"2019-10-16","room_stay_to":"2019-10-23","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":"90378","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-18 19:15:40","reservation_modified_date_time":"2019-08-18 19:15:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90378","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":"3014875","reservation_id":"80804","confirmation_number":"PB12294584230","room_confirmation_number":"PB12361897289","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88982","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-16 10:30:53","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88982","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":"3017686","reservation_id":"83508","confirmation_number":"PB12287064297","room_confirmation_number":"PB12324751175","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","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":"90809","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-01 14:19:10","reservation_modified_date_time":"2019-09-01 14:19:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90809","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":"3017697","reservation_id":"81661","confirmation_number":"PB12262769399","room_confirmation_number":"PB12384000879","room_stay_from":"2019-10-15","room_stay_to":"2019-10-19","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":"89534","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-29 17:12: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":"89534","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":"3020020","reservation_id":"84210","confirmation_number":"PB12268900714","room_confirmation_number":"PB12335236649","room_stay_from":"2019-10-15","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23494","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-16 18:31:24","reservation_modified_date_time":"2019-09-16 18:31:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23494","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":"3021825","reservation_id":"80713","confirmation_number":"PB12242254625","room_confirmation_number":"PB12357092937","room_stay_from":"2019-10-13","room_stay_to":"2019-10-19","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":"88910","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-14 13:06:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88910","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":"3024095","reservation_id":"82419","confirmation_number":"PB12267468860","room_confirmation_number":"PB12350143627","room_stay_from":"2019-10-17","room_stay_to":"2019-10-21","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":"90064","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-10 19:06:34","reservation_modified_date_time":"2019-08-10 19:06:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90064","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":"3024453","reservation_id":"84985","confirmation_number":"PB12236961906","room_confirmation_number":"PB12399662215","room_stay_from":"2019-10-16","room_stay_to":"2019-10-23","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":"92237","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-02 03:02:10","reservation_modified_date_time":"2019-10-02 03:02:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92237","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":"3026083","reservation_id":"85272","confirmation_number":"PB12246144981","room_confirmation_number":"PB12389998697","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","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":"92445","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-07 21:16:07","reservation_modified_date_time":"2019-10-07 21:16:07","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92445","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3026569","reservation_id":"85309","confirmation_number":"PB12257000045","room_confirmation_number":"PB12394680342","room_stay_from":"2019-10-15","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"42330","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-08 18:42:53","reservation_modified_date_time":"2019-10-08 18:42:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42330","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":"3026585","reservation_id":"81489","confirmation_number":"PB12235046546","room_confirmation_number":"PB12350942121","room_stay_from":"2019-10-09","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23448","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-26 19:02:16","reservation_modified_date_time":"2019-10-09 18:12:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23448","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":"3027205","reservation_id":"85460","confirmation_number":"PB12260061649","room_confirmation_number":"PB12367458986","room_stay_from":"2019-10-14","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0,0","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"92573","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-11 05:11:09","reservation_modified_date_time":"2019-10-11 05:11:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92573","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":"3027266","reservation_id":"80882","confirmation_number":"PB12247533802","room_confirmation_number":"PB12335134444","room_stay_from":"2019-10-17","room_stay_to":"2019-10-21","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":"89046","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-17 20:19: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":"89046","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":"3027325","reservation_id":"80408","confirmation_number":"PB12210526346","room_confirmation_number":"PB12342949398","room_stay_from":"2019-10-11","room_stay_to":"2019-10-18","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":"23875","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-08 20:42:37","reservation_modified_date_time":"2019-10-11 18:55:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23875","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":"3027641","reservation_id":"58524","confirmation_number":"PBR12238551180","room_confirmation_number":"PB12364155478","room_stay_from":"2019-10-12","room_stay_to":"2019-10-19","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":"44703","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"2019-10-12 18:01:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44703","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":"3027697","reservation_id":"83391","confirmation_number":"PB12263631482","room_confirmation_number":"PB12333843543","room_stay_from":"2019-10-12","room_stay_to":"2019-10-19","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":"54583","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-29 14:56:21","reservation_modified_date_time":"2019-10-12 19:51:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"54583","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":"3027974","reservation_id":"58398","confirmation_number":"PBR12210587940","room_confirmation_number":"PB12382881918","room_stay_from":"2019-10-13","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"42365","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"2019-10-13 18:48:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42365","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":"3028644","reservation_id":"85690","confirmation_number":"PB12271686350","room_confirmation_number":"PB12371425646","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","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":"92724","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-15 15:46:56","reservation_modified_date_time":"2019-10-15 15:46:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92724","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":"3028987","reservation_id":"85722","confirmation_number":"PB12291540642","room_confirmation_number":"PB12390130298","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","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":"92748","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-16 15:44:13","reservation_modified_date_time":"2019-10-16 15:44:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92748","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":"3029069","reservation_id":"80650","confirmation_number":"PB12212144461","room_confirmation_number":"PB12334313249","room_stay_from":"2019-10-16","room_stay_to":"2019-10-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"25925","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-13 15:12:09","reservation_modified_date_time":"2019-10-16 17:07:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"25925","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":"3029575","reservation_id":"85806","confirmation_number":"PB12267262178","room_confirmation_number":"PB12316424813","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","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":"92812","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-17 19:32:11","reservation_modified_date_time":"2019-10-17 19:32:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92812","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":"3029687","reservation_id":"67964","confirmation_number":"PB12285097202","room_confirmation_number":"PB12322074787","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"81039","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-27 21:38:21","reservation_modified_date_time":"2019-10-17 22:21:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53778","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":"3029720","reservation_id":"67964","confirmation_number":"PB12222232856","room_confirmation_number":"PB12367288183","room_stay_from":"2019-10-17","room_stay_to":"2019-10-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"81039","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-27 21:38:22","reservation_modified_date_time":"2019-10-17 22:30:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53778","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":"3029904","reservation_id":"81501","confirmation_number":"PB12291675755","room_confirmation_number":"PB12341879694","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","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":"89431","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-26 20:52:11","reservation_modified_date_time":"2019-10-18 14:09:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89431","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":"3029919","reservation_id":"82888","confirmation_number":"PB12298655119","room_confirmation_number":"PB12338318586","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"26714","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-18 20:02:44","reservation_modified_date_time":"2019-10-17 14:05:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26714","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","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":"3029981","reservation_id":"77762","confirmation_number":"PB12279072437","room_confirmation_number":"PB12368165608","room_stay_from":"2019-10-15","room_stay_to":"2019-10-29","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"168.00","grand_total":"189.84","paid_amount":"189.84","product_id":"1781","service_quantity":"1","customer_traveller_id":"48250","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-01 17:17:45","reservation_modified_date_time":"2019-10-15 18:10:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"48250","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":"3030242","reservation_id":"82128","confirmation_number":"PB12238142257","room_confirmation_number":"PB12311504002","room_stay_from":"2019-10-14","room_stay_to":"2019-10-19","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":"89882","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-06 16:47:09","reservation_modified_date_time":"2019-10-19 14:51:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89882","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":"3029370","reservation_id":"85785","confirmation_number":"PB12255001472","room_confirmation_number":"PB12367217210","room_stay_from":"2019-10-16","room_stay_to":"2019-10-17","room_stay_status":"Canceled","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-17 06:38:09","reservation_modified_date_time":"2019-10-17 06:38:09","customer_id":"92801","parentCustTravId":"92801","customer_traveller_id":"92801","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-10-17 20:22:31","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#20","deltaChange":-20,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"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":"3031429","reservation_id":"81537","confirmation_number":"BV12465999909","room_stay_from":"2019-10-16","room_stay_to":"2019-10-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.48,138.48,165.31,165.31,138.48,138.48","nightly_discount":"0,0,0,0,0,0","subtotal":"884.54","grand_total":"999.53","paid_amount":"1156.01","room_type_id":"306","product_id":"1223","siteminder_id":"BDC-2226187915","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":"89442","customer_id":"89442","source_of_creation":"Booking.com","reservation_created_date":"2019-07-27 12:23:11","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"153.45","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.48","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_taxable":[{"room_stay_id":"2987113","reservation_id":"78488","confirmation_number":"BV12457273097","room_stay_from":"2019-10-17","room_stay_to":"2019-10-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.82,103.48,103.48,94.82,94.82,94.82","nightly_discount":"0,0,0,0,0,0","subtotal":"586.24","grand_total":"662.45","paid_amount":"662.45","room_type_id":"308","product_id":"1225","siteminder_id":"EXP-1276000395","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":"87540","customer_id":"87540","source_of_creation":"Expedia","reservation_created_date":"2019-06-11 20:51:08","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":"94.82","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"2964419","reservation_id":"74516","confirmation_number":"BV12425373944","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"137.07,137.07,137.07,137.07,137.07","nightly_discount":"0,0,0,0,0","subtotal":"685.35","grand_total":"774.44","paid_amount":"774.44","room_type_id":"303","product_id":"1139","siteminder_id":"GAM-R1456990908","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84920","customer_id":"84920","source_of_creation":"Getaroom.com","reservation_created_date":"2019-04-11 20:24:10","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.07","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028979","reservation_id":"85699","confirmation_number":"BV12453430438","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.57,82.57","nightly_discount":"0.00,0.00","subtotal":"165.14","grand_total":"186.61","paid_amount":"186.61","room_type_id":"304","product_id":"1218","siteminder_id":"GAM-R1706442885","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":"92732","customer_id":"92732","source_of_creation":"Getaroom.com","reservation_created_date":"2019-10-15 18:45:08","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"82.57","currentDayDiscount":"0.00","productIsTaxExempt":false,"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_non_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3029400","reservation_id":"82226","confirmation_number":"BV12425089204","room_stay_from":"2019-10-16","room_stay_to":"2019-10-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.68,91.20,91.20,67.68,67.68","nightly_discount":"0.00,0.00,0.00,0.00,20.23,0.00","subtotal":"385.44","grand_total":"412.68","paid_amount":"412.68","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":"89953","customer_id":"89953","source_of_creation":"FE","reservation_created_date":"2019-08-08 00:24:59","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":"91.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3022596","reservation_id":"84698","confirmation_number":"BV12495035525","room_stay_from":"2019-10-14","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.96,102.96,102.96,102.96","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"411.84","grand_total":"465.38","paid_amount":"465.38","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":"62294","customer_id":"62294","source_of_creation":"PMS","reservation_created_date":"2019-09-25 22:09:36","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":"102.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029406","reservation_id":"83437","confirmation_number":"BV12467840549","room_stay_from":"2019-10-16","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.68,67.68,91.20","nightly_discount":"0.00,0.00,13.49,0.00","subtotal":"226.56","grand_total":"240.76","paid_amount":"240.76","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":"90770","customer_id":"90770","source_of_creation":"PMS","reservation_created_date":"2019-08-30 14:58:21","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":"67.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029889","reservation_id":"83401","confirmation_number":"BV12450321797","room_stay_from":"2019-10-15","room_stay_to":"2019-10-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.68,67.68,67.68,91.20,91.20,79.00","nightly_discount":"0.00,0.00,0.00,0.00,25.14,0.00","subtotal":"464.44","grand_total":"496.41","paid_amount":"496.41","room_type_id":"304","product_id":"1220","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90740","customer_id":"90740","source_of_creation":"PMS","reservation_created_date":"2019-08-29 18:58:12","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3030396","reservation_id":"81776","confirmation_number":"BV12430506818","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.96,102.96","nightly_discount":"0.00,0.00","subtotal":"205.92","grand_total":"232.69","paid_amount":"232.69","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"40658","customer_id":"40658","source_of_creation":"PMS","reservation_created_date":"2019-07-31 20:28:08","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"102.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3037981","reservation_id":"85732","confirmation_number":"BV12470859322","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.73,65.86","nightly_discount":"0.00,0.00","subtotal":"119.59","grand_total":"135.14","paid_amount":"135.14","room_type_id":"305","product_id":"1222","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":"92757","customer_id":"92757","source_of_creation":"PMS","reservation_created_date":"2019-10-16 19:01:47","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":"53.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2964420","reservation_id":"74516","confirmation_number":"BV12229489243","room_confirmation_number":"BV12425373944","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"20,20,20,20,20","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":"1780","service_quantity":"1","customer_traveller_id":"84920","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-04-11 20:24:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84920","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2964421","reservation_id":"74516","confirmation_number":"BV12210622948","room_confirmation_number":"BV12425373944","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","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":"84920","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-04-11 20:24:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84920","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":"2987114","reservation_id":"78488","confirmation_number":"BV12280727834","room_confirmation_number":"BV12457273097","room_stay_from":"2019-10-17","room_stay_to":"2019-10-23","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":"87540","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-11 20:51: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":"87540","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":"3022597","reservation_id":"84698","confirmation_number":"BV12231395070","room_confirmation_number":"BV12495035525","room_stay_from":"2019-10-14","room_stay_to":"2019-10-18","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":"62294","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-25 22:09:36","reservation_modified_date_time":"2019-09-25 22:09:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"62294","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":"3028980","reservation_id":"85699","confirmation_number":"BV12287564982","room_confirmation_number":"BV12453430438","room_stay_from":"2019-10-16","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"92732","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-15 18:45:08","reservation_modified_date_time":"2019-10-16 15:08:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92732","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":"3029401","reservation_id":"82226","confirmation_number":"BV12279904711","room_confirmation_number":"BV12425089204","room_stay_from":"2019-10-16","room_stay_to":"2019-10-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"89953","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-08 00:24:59","reservation_modified_date_time":"2019-10-17 13:27:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89953","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":"3029407","reservation_id":"83437","confirmation_number":"BV12227689556","room_confirmation_number":"BV12467840549","room_stay_from":"2019-10-16","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"90770","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-30 14:58:21","reservation_modified_date_time":"2019-10-17 13:40:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90770","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":"3029891","reservation_id":"83401","confirmation_number":"BV12250494861","room_confirmation_number":"BV12450321797","room_stay_from":"2019-10-15","room_stay_to":"2019-10-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"90740","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-29 18:58:12","reservation_modified_date_time":"2019-10-18 12:39:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90740","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":"3030397","reservation_id":"81776","confirmation_number":"BV12276815589","room_confirmation_number":"BV12430506818","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","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":"40658","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-31 20:28:08","reservation_modified_date_time":"2019-10-17 17:23:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"40658","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","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":"3031430","reservation_id":"81537","confirmation_number":"BV12235881801","room_confirmation_number":"BV12465999909","room_stay_from":"2019-10-16","room_stay_to":"2019-10-22","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":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"89442","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-27 12:23: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":"89442","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":"3037982","reservation_id":"85732","confirmation_number":"BV12298761791","room_confirmation_number":"BV12470859322","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"92757","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-16 19:01:47","reservation_modified_date_time":"2019-11-13 20:53:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92757","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3015213","reservation_id":"83437","confirmation_number":"BV12228717186","room_confirmation_number":"BV12467840549","room_stay_from":"2019-10-16","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.75","paid_amount":"84.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-30 15:01:22","reservation_modified_date_time":"2019-08-30 15:01:22","customer_id":"90770","parentCustTravId":"90770","customer_traveller_id":"90770","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":"3029890","reservation_id":"83401","confirmation_number":"BV12276253114","room_confirmation_number":"BV12450321797","room_stay_from":"2019-10-15","room_stay_to":"2019-10-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,50.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"169.50","paid_amount":"169.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-29 18:58:12","reservation_modified_date_time":"2019-10-18 12:39:59","customer_id":"90740","parentCustTravId":"90740","customer_traveller_id":"90740","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":"3024446","reservation_id":"84983","confirmation_number":"BV12283410192","room_confirmation_number":"BV12443362281","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"0.00","product_id":"1147","service_quantity":"1","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-02 02:29:56","reservation_modified_date_time":"2019-10-02 02:29:56","customer_id":"92236","parentCustTravId":"92236","customer_traveller_id":"92236","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-10-18 01:22:30","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-10,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3024447","reservation_id":"84983","confirmation_number":"BV12243501502","room_confirmation_number":"BV12443362281","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.25","paid_amount":"0.00","product_id":"1146","service_quantity":"1","product_name":"Boat Dockage","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-02 02:29:56","reservation_modified_date_time":"2019-10-02 02:29:56","customer_id":"92236","parentCustTravId":"92236","customer_traveller_id":"92236","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-10-18 01:22:30","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-25,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":2,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"exp_taxable":[{"room_stay_id":"2984507","reservation_id":"78017","confirmation_number":"BP12579983751","room_stay_from":"2019-10-09","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"66.68,66.68,75.34,75.34,66.68,66.68,66.68,66.68,66.68,75.34","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"692.78","grand_total":"782.84","paid_amount":"782.84","room_type_id":"295","product_id":"1129","siteminder_id":"EXP-1271579783","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":"34980","customer_id":"34980","source_of_creation":"Expedia","reservation_created_date":"2019-06-05 12:13:14","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":"66.68","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3026539","reservation_id":"85341","confirmation_number":"BP12536792356","room_stay_from":"2019-10-14","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"50.41,50.41,50.41,50.41","nightly_discount":"0,0,0,0","subtotal":"201.64","grand_total":"227.85","paid_amount":"227.85","room_type_id":"298","product_id":"1133","siteminder_id":"GAM-R1697146450","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":"92498","customer_id":"92498","source_of_creation":"Getaroom.com","reservation_created_date":"2019-10-09 13:14:06","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":"50.41","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":[{"room_stay_id":"3003637","reservation_id":"81542","confirmation_number":"BP12548368955","room_stay_from":"2019-10-15","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.1,71.1,71.1","nightly_discount":"0,0,0","subtotal":"213.30","grand_total":"241.03","paid_amount":"241.03","room_type_id":"295","product_id":"1128","siteminder_id":"ZOO-5739-1819-7362","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":"89444","customer_id":"89444","source_of_creation":"Travelzoo","reservation_created_date":"2019-07-27 14:50: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":"71.1","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"}]}],"zoo_non_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3027318","reservation_id":"85479","confirmation_number":"BP12575481959","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"72.72,96.80","nightly_discount":"0.00,0.00","subtotal":"169.52","grand_total":"191.56","paid_amount":"191.56","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":"92586","customer_id":"92586","source_of_creation":"FE","reservation_created_date":"2019-10-11 18:54:39","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":"72.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029572","reservation_id":"85724","confirmation_number":"BP12552691995","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"61.81","nightly_discount":"0.00","subtotal":"61.81","grand_total":"69.85","paid_amount":"0.00","room_type_id":"290","product_id":"1113","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":"92749","customer_id":"92749","source_of_creation":"FE","reservation_created_date":"2019-10-16 15:57:54","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"61.81","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3014917","reservation_id":"83395","confirmation_number":"BP12516039474","room_stay_from":"2019-10-16","room_stay_to":"2019-10-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.12,105.12,105.12,132.80,132.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"580.96","grand_total":"656.49","paid_amount":"656.49","room_type_id":"301","product_id":"1136","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":"50585","customer_id":"50585","source_of_creation":"PMS","reservation_created_date":"2019-08-29 15:35:44","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017368","reservation_id":"83756","confirmation_number":"BP12566786808","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"105.12,105.12,105.12,105.12,105.12","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"525.60","grand_total":"593.93","paid_amount":"593.93","room_type_id":"296","product_id":"1130","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":"28631","customer_id":"28631","source_of_creation":"PMS","reservation_created_date":"2019-09-07 22:59:53","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3027928","reservation_id":"85579","confirmation_number":"BP12524568456","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"495.00","grand_total":"559.35","paid_amount":"559.35","room_type_id":"301","product_id":"1137","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":"66981","customer_id":"66981","source_of_creation":"PMS","reservation_created_date":"2019-10-13 14:55:44","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3037957","reservation_id":"84248","confirmation_number":"BP12569924754","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.73,65.86","nightly_discount":"0.00,0.00","subtotal":"119.59","grand_total":"135.14","paid_amount":"135.14","room_type_id":"294","product_id":"1125","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91732","customer_id":"91732","source_of_creation":"PMS","reservation_created_date":"2019-09-17 14:58:52","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"53.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3037973","reservation_id":"85760","confirmation_number":"BP12578382711","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.73","nightly_discount":"0.00","subtotal":"53.73","grand_total":"60.71","paid_amount":"60.71","room_type_id":"289","product_id":"1099","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":"92716","customer_id":"92716","source_of_creation":"PMS","reservation_created_date":"2019-10-16 21:47:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"53.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2984508","reservation_id":"78017","confirmation_number":"BP12251751227","room_confirmation_number":"BP12579983751","room_stay_from":"2019-10-09","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"87209","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-05 12:13:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"34980","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":"3003638","reservation_id":"81542","confirmation_number":"BP12288067545","room_confirmation_number":"BP12548368955","room_stay_from":"2019-10-15","room_stay_to":"2019-10-18","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":"89444","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-27 14:50: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":"89444","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":"3014918","reservation_id":"83395","confirmation_number":"BP12235946890","room_confirmation_number":"BP12516039474","room_stay_from":"2019-10-16","room_stay_to":"2019-10-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"50585","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-29 15:35:44","reservation_modified_date_time":"2019-08-29 15:35:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"50585","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":"3017369","reservation_id":"83756","confirmation_number":"BP12279369600","room_confirmation_number":"BP12566786808","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"28631","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-07 22:59:53","reservation_modified_date_time":"2019-09-07 22:59:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28631","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":"3026540","reservation_id":"85341","confirmation_number":"BP12288464928","room_confirmation_number":"BP12536792356","room_stay_from":"2019-10-14","room_stay_to":"2019-10-18","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":"92498","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-09 13:14:06","reservation_modified_date_time":"2019-10-09 13:14:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92498","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":"3027319","reservation_id":"85479","confirmation_number":"BP12244326570","room_confirmation_number":"BP12575481959","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","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":"92586","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-11 18:54:39","reservation_modified_date_time":"2019-10-11 18:54:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92586","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":"3027929","reservation_id":"85579","confirmation_number":"BP12214854702","room_confirmation_number":"BP12524568456","room_stay_from":"2019-10-13","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"66981","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-13 14:55:44","reservation_modified_date_time":"2019-10-13 14:55:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66981","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":"3029573","reservation_id":"85724","confirmation_number":"BP12263380869","room_confirmation_number":"BP12552691995","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"92749","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-16 15:57:54","reservation_modified_date_time":"2019-10-16 15:57:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92749","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":"3037958","reservation_id":"84248","confirmation_number":"BP12291964950","room_confirmation_number":"BP12569924754","room_stay_from":"2019-10-17","room_stay_to":"2019-10-19","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"91732","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-17 14:58:52","reservation_modified_date_time":"2019-11-13 20:43:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91732","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":"3037974","reservation_id":"85760","confirmation_number":"BP12290721959","room_confirmation_number":"BP12578382711","room_stay_from":"2019-10-17","room_stay_to":"2019-10-18","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":"92716","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-16 21:47:09","reservation_modified_date_time":"2019-11-13 20:49:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92716","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3026532","reservation_id":"78017","confirmation_number":"BP12213314079","room_confirmation_number":"BP12579983751","room_stay_from":"2019-10-09","room_stay_to":"2019-10-19","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"282.50","paid_amount":"282.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-09 12:20:20","reservation_modified_date_time":"2019-10-09 12:20:20","customer_id":"34980","parentCustTravId":"34980","customer_traveller_id":"87209","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"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}