{"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":26,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[{"room_stay_id":"3015556","reservation_id":"83477","confirmation_number":"PB12317957369","room_stay_from":"2019-08-31","room_stay_to":"2019-09-01","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.51","nightly_discount":"0","subtotal":"172.51","grand_total":"194.94","paid_amount":"194.94","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3996974196","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":"90788","customer_id":"90788","source_of_creation":"Booking.com","reservation_created_date":"2019-08-31 16:18:10","service_canceled_date_time":"2019-09-02 17:30:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"25.88","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3015127","reservation_id":"83424","confirmation_number":"PB12359730570","room_stay_from":"2019-08-31","room_stay_to":"2019-09-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.42,112.84,120.36,86.16","nightly_discount":"0,0,0,0","subtotal":"485.78","grand_total":"548.93","paid_amount":"548.93","room_type_id":"289","product_id":"1093","siteminder_id":"EXP-1332431604","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":"90758","customer_id":"90758","source_of_creation":"Expedia","reservation_created_date":"2019-08-30 09:16:08","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":"120.36","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":"3015460","reservation_id":"80652","confirmation_number":"PB12386020046","room_stay_from":"2019-08-30","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.46,129.80,110.02,117.36,84.01,84.01,84.01,92.45,92.45,84.01,84.01,84.01,84.01,84.01","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1352.62","grand_total":"1528.46","paid_amount":"1528.46","room_type_id":"289","product_id":"1112","siteminder_id":"EXP-1299080977","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":"88876","customer_id":"88876","source_of_creation":"Expedia","reservation_created_date":"2019-07-13 15:30:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.36","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"2995353","reservation_id":"80211","confirmation_number":"PB12397880901","room_stay_from":"2019-08-31","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.07,61.93,61.93","nightly_discount":"0,0,0","subtotal":"196.93","grand_total":"222.54","paid_amount":"222.54","room_type_id":"289","product_id":"1095","siteminder_id":"HTN-90477583-DYYRHG","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":"88583","customer_id":"88583","source_of_creation":"HotelTonight","reservation_created_date":"2019-07-05 12:45:07","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":"61.93","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[{"room_stay_id":"3012895","reservation_id":"82563","confirmation_number":"PB12316304348","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.44,89","nightly_discount":"0,0","subtotal":"172.44","grand_total":"194.86","paid_amount":"194.86","room_type_id":"289","product_id":"1094","siteminder_id":"ZOO-0155-1096-4194","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":"90161","customer_id":"90161","source_of_creation":"Travelzoo","reservation_created_date":"2019-08-13 01:56:08","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":"89","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3014634","reservation_id":"81446","confirmation_number":"PB12323065755","room_stay_from":"2019-08-31","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.31,83.44,89","nightly_discount":"0,0,0","subtotal":"302.75","grand_total":"342.11","paid_amount":"342.11","room_type_id":"289","product_id":"1102","siteminder_id":"ZOO-0359-4682-7491","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":"89403","customer_id":"89403","source_of_creation":"Travelzoo","reservation_created_date":"2019-07-26 00:27:12","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":"89","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3015554","reservation_id":"70099","confirmation_number":"PB12377598096","room_stay_from":"2019-08-31","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"208.00,158.00,158.00,111.00,111.00,111.00,131.00","nightly_discount":"0.00,42.76,0.00,0.00,0.00,0.00,0.00","subtotal":"988.00","grand_total":"1068.12","paid_amount":"1068.12","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82221","customer_id":"82221","source_of_creation":"FE","reservation_created_date":"2019-02-22 23:19:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"158.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3015822","reservation_id":"78799","confirmation_number":"PB12393584018","room_stay_from":"2019-09-01","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.80,212.80,160.80,160.80,160.80,176.80","nightly_discount":"0.00,47.54,0.00,0.00,0.00,0.00","subtotal":"1084.80","grand_total":"1172.11","paid_amount":"1172.11","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":"87746","customer_id":"87746","source_of_creation":"FE","reservation_created_date":"2019-06-16 18:16:07","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":"212.80","currentDayDiscount":"47.54","productIsTaxExempt":false,"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":"3010278","reservation_id":"80496","confirmation_number":"PB12326106292","room_stay_from":"2019-08-30","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.25,135.75,144.80,144.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"598.60","grand_total":"676.42","paid_amount":"676.42","room_type_id":"285","product_id":"1084","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":"72241","customer_id":"72241","source_of_creation":"PMS","reservation_created_date":"2019-07-10 20:58:46","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.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":"3015577","reservation_id":"81599","confirmation_number":"PB12351485814","room_stay_from":"2019-08-31","room_stay_to":"2019-09-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.25,135.75,144.80,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"765.80","grand_total":"865.36","paid_amount":"865.36","room_type_id":"287","product_id":"1090","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"70223","customer_id":"70223","source_of_creation":"PMS","reservation_created_date":"2019-07-28 13:59:39","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.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":"3015835","reservation_id":"83514","confirmation_number":"PB12393029087","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"110.60","nightly_discount":"0.00","subtotal":"110.60","grand_total":"124.98","paid_amount":"124.98","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90815","customer_id":"90815","source_of_creation":"PMS","reservation_created_date":"2019-09-01 17:06:04","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017623","reservation_id":"82580","confirmation_number":"PB12396833898","room_stay_from":"2019-09-02","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"66.27,66.27,66.29","nightly_discount":"0.00,0.00,0.00","subtotal":"198.83","grand_total":"224.68","paid_amount":"224.68","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":"29326","customer_id":"29326","source_of_creation":"PMS","reservation_created_date":"2019-08-13 17:10:10","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":"66.27","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017626","reservation_id":"82831","confirmation_number":"PB12371814076","room_stay_from":"2019-09-02","room_stay_to":"2019-09-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"66.28,66.28","nightly_discount":"0.00,0.00","subtotal":"132.56","grand_total":"149.79","paid_amount":"149.79","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":"90352","customer_id":"90352","source_of_creation":"PMS","reservation_created_date":"2019-08-17 20:54:20","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":"66.28","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022733","reservation_id":"83543","confirmation_number":"PB12355471960","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00","nightly_discount":"0.00","subtotal":"114.00","grand_total":"128.82","paid_amount":"128.82","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90840","customer_id":"90840","source_of_creation":"PMS","reservation_created_date":"2019-09-02 14:30:43","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":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3030631","reservation_id":"83383","confirmation_number":"PB12344976843","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.27","nightly_discount":"0.00","subtotal":"77.27","grand_total":"87.32","paid_amount":"87.32","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":"70306","customer_id":"70306","source_of_creation":"PMS","reservation_created_date":"2019-08-29 12:20:58","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.27","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2992434","reservation_id":"79706","confirmation_number":"PB12267016069","room_confirmation_number":"PB12333055103","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","room_stay_status":"Active","nightly_price":"30,30","nightly_discount":"0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"0.00","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-27 14:10:09","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"88225","parentCustTravId":"88225","customer_traveller_id":"88225","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","canceled_nights_data":"","product_attribute_values":"extra_person# .00","currentDayPrice":30,"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"}]},{"room_stay_id":"3015836","reservation_id":"83514","confirmation_number":"PB12214547095","room_confirmation_number":"PB12393029087","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"90815","product_attribute_values":"extra_person# ","reservation_created_date":"2019-09-01 17:10:54","reservation_modified_date_time":"2019-09-01 17:10:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90815","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2992435","reservation_id":"79706","confirmation_number":"PB12299657856","room_confirmation_number":"PB12333055103","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","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":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-27 14:10:09","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"88225","parentCustTravId":"88225","customer_traveller_id":"88225","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-09-04 17:54:08","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#","currentDayPrice":20,"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"}]},{"room_stay_id":"2995354","reservation_id":"80211","confirmation_number":"PB12290727466","room_confirmation_number":"PB12397880901","room_stay_from":"2019-08-31","room_stay_to":"2019-09-03","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":"88583","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-05 12:45:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88583","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":"3010279","reservation_id":"80496","confirmation_number":"PB12246941786","room_confirmation_number":"PB12326106292","room_stay_from":"2019-08-30","room_stay_to":"2019-09-03","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":"72241","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-10 20:58:46","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"72241","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":"3012896","reservation_id":"82563","confirmation_number":"PB12268364597","room_confirmation_number":"PB12316304348","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","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":"90161","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-13 01:56:08","reservation_modified_date_time":"2019-08-13 01:56:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90161","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":"3014635","reservation_id":"81446","confirmation_number":"PB12225689157","room_confirmation_number":"PB12323065755","room_stay_from":"2019-08-31","room_stay_to":"2019-09-03","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":"89403","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-26 00:27: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":"89403","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":"3015128","reservation_id":"83424","confirmation_number":"PB12248649226","room_confirmation_number":"PB12359730570","room_stay_from":"2019-08-31","room_stay_to":"2019-09-04","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":"90758","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-30 09:16:08","reservation_modified_date_time":"2019-08-30 09:16:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90758","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":"3015461","reservation_id":"80652","confirmation_number":"PB12218001797","room_confirmation_number":"PB12386020046","room_stay_from":"2019-08-30","room_stay_to":"2019-09-13","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,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,0.00,0.00,0.00,0.00","subtotal":"280.00","grand_total":"316.40","paid_amount":"316.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"88876","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-13 15:30:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88876","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":"3015555","reservation_id":"70099","confirmation_number":"PB12244127121","room_confirmation_number":"PB12377598096","room_stay_from":"2019-08-31","room_stay_to":"2019-09-07","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":"82221","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-02-22 23:19:06","reservation_modified_date_time":"2019-08-31 16:13:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82221","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":"3015578","reservation_id":"81599","confirmation_number":"PB12278431018","room_confirmation_number":"PB12351485814","room_stay_from":"2019-08-31","room_stay_to":"2019-09-06","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":"70223","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-28 13:59:39","reservation_modified_date_time":"2019-08-30 21:32:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70223","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":"3015823","reservation_id":"78799","confirmation_number":"PB12237776272","room_confirmation_number":"PB12393584018","room_stay_from":"2019-09-01","room_stay_to":"2019-09-07","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":"87746","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-16 18:16:07","reservation_modified_date_time":"2019-09-01 16:12:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87746","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":"3015837","reservation_id":"83514","confirmation_number":"PB12269388820","room_confirmation_number":"PB12393029087","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"90815","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-01 17:06:04","reservation_modified_date_time":"2019-09-01 17:06:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90815","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":"3017627","reservation_id":"82831","confirmation_number":"PB12218077735","room_confirmation_number":"PB12371814076","room_stay_from":"2019-09-02","room_stay_to":"2019-09-04","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":"90352","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-17 20:54:20","reservation_modified_date_time":"2019-09-08 20:38:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90352","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":"3022734","reservation_id":"83543","confirmation_number":"PB12284451427","room_confirmation_number":"PB12355471960","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","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":"90840","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-02 14:30:43","reservation_modified_date_time":"2019-09-26 15:11:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90840","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":"3030632","reservation_id":"83383","confirmation_number":"PB12237334905","room_confirmation_number":"PB12344976843","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","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":"70306","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-29 12:20:58","reservation_modified_date_time":"2019-10-20 18:00:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70306","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":"3015987","reservation_id":"79581","confirmation_number":"PB12266852292","room_confirmation_number":"PB12386682978","room_stay_from":"2019-09-05","room_stay_to":"2019-09-08","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":"45391","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-25 18:13:18","reservation_modified_date_time":"2019-09-02 17:14:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"45391","canceled_nights_data":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3015557","reservation_id":"83477","confirmation_number":"PB12278351575","room_confirmation_number":"PB12317957369","room_stay_from":"2019-08-31","room_stay_to":"2019-09-01","room_stay_status":"Canceled","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","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-31 16:18:10","reservation_modified_date_time":"2019-08-31 16:18:10","customer_id":"90788","parentCustTravId":"90788","customer_traveller_id":"90788","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-09-02 17:30:08","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#","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":"3015992","reservation_id":"82831","confirmation_number":"PB12243282543","room_confirmation_number":"PB12371814076","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"30.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1212","service_quantity":"2","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-02 18:52:18","reservation_modified_date_time":"2019-09-02 18:52:18","customer_id":"90352","parentCustTravId":"90352","customer_traveller_id":"90352","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"60.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3016003","reservation_id":"83554","confirmation_number":"PB12236354585","room_confirmation_number":"PB12388524255","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-02 21:02:33","reservation_modified_date_time":"2019-09-02 21:02:33","customer_id":"90850","parentCustTravId":"90850","customer_traveller_id":"90850","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3016057","reservation_id":"83559","confirmation_number":"PB12292102943","room_confirmation_number":"PB12362554987","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-03 00:28:36","reservation_modified_date_time":"2019-09-03 00:28:36","customer_id":"90098","parentCustTravId":"90098","customer_traveller_id":"39147","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3015970","reservation_id":"83546","confirmation_number":"PB12291641865","room_confirmation_number":"PB12346114452","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.20","grand_total":"17.96","paid_amount":"17.96","product_id":null,"service_quantity":"4","product_name":"Coffee Mug","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-02 15:22:58","reservation_modified_date_time":"2019-09-02 15:22:58","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"16.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3015628","reservation_id":"83477","confirmation_number":"PB12273736988","room_confirmation_number":"PB12317957369","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":"11.30","product_id":"1192","service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-31 18:57:26","reservation_modified_date_time":"2019-08-31 18:57:26","customer_id":"90788","parentCustTravId":"90788","customer_traveller_id":"90788","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-09-02 17:30:08","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"}]}],"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":7,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"exp_taxable":[{"room_stay_id":"3014616","reservation_id":"83348","confirmation_number":"BV12472147407","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.52,120.01","nightly_discount":"0,0","subtotal":"232.53","grand_total":"262.76","paid_amount":"262.76","room_type_id":"308","product_id":"1225","siteminder_id":"EXP-1331231565","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":"90713","customer_id":"90713","source_of_creation":"Expedia","reservation_created_date":"2019-08-28 17:09:05","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":"120.01","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":"3015869","reservation_id":"83494","confirmation_number":"BV12451121410","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.52,130.00","nightly_discount":"0.00,0.00","subtotal":"242.52","grand_total":"274.05","paid_amount":"274.05","room_type_id":"305","product_id":"1222","siteminder_id":"EXP-1333409376","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":"90800","customer_id":"90800","source_of_creation":"Expedia","reservation_created_date":"2019-08-31 21:36:05","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":"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"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3015929","reservation_id":"83524","confirmation_number":"BV12471443032","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.36,68.16","nightly_discount":"0.00,0.61,0.00","subtotal":"150.52","grand_total":"169.39","paid_amount":"169.39","room_type_id":"294","product_id":"1126","siteminder_id":"HTN-98464981-A7TMDP","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":"90824","customer_id":"90824","source_of_creation":"HotelTonight","reservation_created_date":"2019-09-01 23:56:08","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"68.16","currentDayDiscount":"0.61","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3016203","reservation_id":"83397","confirmation_number":"BV12441650528","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.87,133.20","nightly_discount":"0.00,0.00","subtotal":"258.07","grand_total":"291.61","paid_amount":"278.05","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":"89411","customer_id":"89411","source_of_creation":"PMS","reservation_created_date":"2019-08-29 16:51:36","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":"133.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":"3016376","reservation_id":"81602","confirmation_number":"BV12476888636","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.68","nightly_discount":"0.00","subtotal":"103.68","grand_total":"117.16","paid_amount":"130.72","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":"89478","customer_id":"89478","source_of_creation":"PMS","reservation_created_date":"2019-09-03 13:00:44","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":"103.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3014617","reservation_id":"83348","confirmation_number":"BV12268312316","room_confirmation_number":"BV12472147407","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","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":"90713","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-28 17:09:05","reservation_modified_date_time":"2019-08-28 17:09:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90713","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":"3015870","reservation_id":"83494","confirmation_number":"BV12296428524","room_confirmation_number":"BV12451121410","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","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":"90800","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-31 21:36:05","reservation_modified_date_time":"2019-09-01 21:17:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90800","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":"3015930","reservation_id":"83524","confirmation_number":"BV12280620338","room_confirmation_number":"BV12471443032","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","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":"90824","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-01 23:56:08","reservation_modified_date_time":"2019-09-02 02:11:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90824","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":"3016204","reservation_id":"83397","confirmation_number":"BV12211326741","room_confirmation_number":"BV12441650528","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","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":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"89411","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-29 16:51:36","reservation_modified_date_time":"2019-09-01 22:07:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89411","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":"3016377","reservation_id":"81602","confirmation_number":"BV12255178846","room_confirmation_number":"BV12476888636","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","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":"89478","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-03 13:00:44","reservation_modified_date_time":"2019-09-04 19:53:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89478","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3015871","reservation_id":"83348","confirmation_number":"BV12264851621","room_confirmation_number":"BV12472147407","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-01 21:43:09","reservation_modified_date_time":"2019-09-01 21:43:09","customer_id":"90713","parentCustTravId":"90713","customer_traveller_id":"90713","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":"3015877","reservation_id":"83397","confirmation_number":"BV12298013630","room_confirmation_number":"BV12441650528","room_stay_from":"2019-09-01","room_stay_to":"2019-09-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"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-29 16:51:36","reservation_modified_date_time":"2019-09-01 22:07:51","customer_id":"89411","parentCustTravId":"89411","customer_traveller_id":"89411","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":"3015918","reservation_id":"83524","confirmation_number":"BP12213953303","room_confirmation_number":"BV12471443032","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-02 01:39:06","reservation_modified_date_time":"2019-09-02 01:39:06","customer_id":"90824","parentCustTravId":"90824","customer_traveller_id":"90824","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":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":4,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"exp_non_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3015701","reservation_id":"83504","confirmation_number":"BP12535765318","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"131.62,119.34,105.12,105.12","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"461.20","grand_total":"521.15","paid_amount":"521.15","room_type_id":"296","product_id":"1131","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90805","customer_id":"90805","source_of_creation":"FE","reservation_created_date":"2019-09-01 12:39:43","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3015558","reservation_id":"83369","confirmation_number":"BP12513056132","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.31,131.62,140.40,105.12","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"588.45","grand_total":"664.95","paid_amount":"664.95","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":"66287","customer_id":"66287","source_of_creation":"PMS","reservation_created_date":"2019-08-28 23:52:59","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":"131.62","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3015703","reservation_id":"83504","confirmation_number":"BP12267829499","room_confirmation_number":"BP12535765318","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,10.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"90805","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-09-01 12:39:43","reservation_modified_date_time":"2019-09-01 12:39:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90805","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":"3015559","reservation_id":"83369","confirmation_number":"BP12294922093","room_confirmation_number":"BP12513056132","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","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":"66287","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-28 23:52:59","reservation_modified_date_time":"2019-08-28 23:52:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66287","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":"3015702","reservation_id":"83504","confirmation_number":"BP12251094011","room_confirmation_number":"BP12535765318","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","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":"90805","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-01 12:39:43","reservation_modified_date_time":"2019-09-01 12:39:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90805","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3016054","reservation_id":"83558","confirmation_number":"BP12219367977","room_confirmation_number":"BP12512528094","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-02 22:43:54","reservation_modified_date_time":"2019-09-02 22:43:54","customer_id":"90854","parentCustTravId":"90854","customer_traveller_id":"90854","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2019-09-02","total_rooms_exist":66,"departureCount":37,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"2","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[{"room_stay_id":"3015556","reservation_id":"83477","confirmation_number":"PB12317957369","room_stay_from":"2019-08-31","room_stay_to":"2019-09-01","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.51","nightly_discount":"0","subtotal":"172.51","grand_total":"194.94","paid_amount":"194.94","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3996974196","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":"90788","customer_id":"90788","source_of_creation":"Booking.com","reservation_created_date":"2019-08-31 16:18:10","service_canceled_date_time":"2019-09-02 17:30:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"25.88","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3014616","reservation_id":"83348","confirmation_number":"BV12472147407","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.52,120.01","nightly_discount":"0,0","subtotal":"232.53","grand_total":"262.76","paid_amount":"262.76","room_type_id":"308","product_id":"1225","siteminder_id":"EXP-1331231565","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":"90713","customer_id":"90713","source_of_creation":"Expedia","reservation_created_date":"2019-08-28 17:09:05","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":"120.01","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":"3015127","reservation_id":"83424","confirmation_number":"PB12359730570","room_stay_from":"2019-08-31","room_stay_to":"2019-09-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.42,112.84,120.36,86.16","nightly_discount":"0,0,0,0","subtotal":"485.78","grand_total":"548.93","paid_amount":"548.93","room_type_id":"289","product_id":"1093","siteminder_id":"EXP-1332431604","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":"90758","customer_id":"90758","source_of_creation":"Expedia","reservation_created_date":"2019-08-30 09:16:08","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":"120.36","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":"3015460","reservation_id":"80652","confirmation_number":"PB12386020046","room_stay_from":"2019-08-30","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.46,129.80,110.02,117.36,84.01,84.01,84.01,92.45,92.45,84.01,84.01,84.01,84.01,84.01","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1352.62","grand_total":"1528.46","paid_amount":"1528.46","room_type_id":"289","product_id":"1112","siteminder_id":"EXP-1299080977","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":"88876","customer_id":"88876","source_of_creation":"Expedia","reservation_created_date":"2019-07-13 15:30:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.36","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":"3015869","reservation_id":"83494","confirmation_number":"BV12451121410","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.52,130.00","nightly_discount":"0.00,0.00","subtotal":"242.52","grand_total":"274.05","paid_amount":"274.05","room_type_id":"305","product_id":"1222","siteminder_id":"EXP-1333409376","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":"90800","customer_id":"90800","source_of_creation":"Expedia","reservation_created_date":"2019-08-31 21:36:05","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":"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"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"2995353","reservation_id":"80211","confirmation_number":"PB12397880901","room_stay_from":"2019-08-31","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.07,61.93,61.93","nightly_discount":"0,0,0","subtotal":"196.93","grand_total":"222.54","paid_amount":"222.54","room_type_id":"289","product_id":"1095","siteminder_id":"HTN-90477583-DYYRHG","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":"88583","customer_id":"88583","source_of_creation":"HotelTonight","reservation_created_date":"2019-07-05 12:45:07","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":"61.93","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3015929","reservation_id":"83524","confirmation_number":"BV12471443032","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.36,68.16","nightly_discount":"0.00,0.61,0.00","subtotal":"150.52","grand_total":"169.39","paid_amount":"169.39","room_type_id":"294","product_id":"1126","siteminder_id":"HTN-98464981-A7TMDP","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":"90824","customer_id":"90824","source_of_creation":"HotelTonight","reservation_created_date":"2019-09-01 23:56:08","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"68.16","currentDayDiscount":"0.61","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[{"room_stay_id":"3012895","reservation_id":"82563","confirmation_number":"PB12316304348","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.44,89","nightly_discount":"0,0","subtotal":"172.44","grand_total":"194.86","paid_amount":"194.86","room_type_id":"289","product_id":"1094","siteminder_id":"ZOO-0155-1096-4194","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":"90161","customer_id":"90161","source_of_creation":"Travelzoo","reservation_created_date":"2019-08-13 01:56:08","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":"89","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3014634","reservation_id":"81446","confirmation_number":"PB12323065755","room_stay_from":"2019-08-31","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.31,83.44,89","nightly_discount":"0,0,0","subtotal":"302.75","grand_total":"342.11","paid_amount":"342.11","room_type_id":"289","product_id":"1102","siteminder_id":"ZOO-0359-4682-7491","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":"89403","customer_id":"89403","source_of_creation":"Travelzoo","reservation_created_date":"2019-07-26 00:27:12","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":"89","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3015554","reservation_id":"70099","confirmation_number":"PB12377598096","room_stay_from":"2019-08-31","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"208.00,158.00,158.00,111.00,111.00,111.00,131.00","nightly_discount":"0.00,42.76,0.00,0.00,0.00,0.00,0.00","subtotal":"988.00","grand_total":"1068.12","paid_amount":"1068.12","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82221","customer_id":"82221","source_of_creation":"FE","reservation_created_date":"2019-02-22 23:19:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"158.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3015701","reservation_id":"83504","confirmation_number":"BP12535765318","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"131.62,119.34,105.12,105.12","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"461.20","grand_total":"521.15","paid_amount":"521.15","room_type_id":"296","product_id":"1131","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90805","customer_id":"90805","source_of_creation":"FE","reservation_created_date":"2019-09-01 12:39:43","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3015822","reservation_id":"78799","confirmation_number":"PB12393584018","room_stay_from":"2019-09-01","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.80,212.80,160.80,160.80,160.80,176.80","nightly_discount":"0.00,47.54,0.00,0.00,0.00,0.00","subtotal":"1084.80","grand_total":"1172.11","paid_amount":"1172.11","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":"87746","customer_id":"87746","source_of_creation":"FE","reservation_created_date":"2019-06-16 18:16:07","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":"212.80","currentDayDiscount":"47.54","productIsTaxExempt":false,"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":"3010278","reservation_id":"80496","confirmation_number":"PB12326106292","room_stay_from":"2019-08-30","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.25,135.75,144.80,144.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"598.60","grand_total":"676.42","paid_amount":"676.42","room_type_id":"285","product_id":"1084","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":"72241","customer_id":"72241","source_of_creation":"PMS","reservation_created_date":"2019-07-10 20:58:46","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.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":"3015558","reservation_id":"83369","confirmation_number":"BP12513056132","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.31,131.62,140.40,105.12","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"588.45","grand_total":"664.95","paid_amount":"664.95","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":"66287","customer_id":"66287","source_of_creation":"PMS","reservation_created_date":"2019-08-28 23:52:59","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":"131.62","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3015577","reservation_id":"81599","confirmation_number":"PB12351485814","room_stay_from":"2019-08-31","room_stay_to":"2019-09-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.25,135.75,144.80,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"765.80","grand_total":"865.36","paid_amount":"865.36","room_type_id":"287","product_id":"1090","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"70223","customer_id":"70223","source_of_creation":"PMS","reservation_created_date":"2019-07-28 13:59:39","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.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":"3015835","reservation_id":"83514","confirmation_number":"PB12393029087","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"110.60","nightly_discount":"0.00","subtotal":"110.60","grand_total":"124.98","paid_amount":"124.98","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90815","customer_id":"90815","source_of_creation":"PMS","reservation_created_date":"2019-09-01 17:06:04","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016203","reservation_id":"83397","confirmation_number":"BV12441650528","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.87,133.20","nightly_discount":"0.00,0.00","subtotal":"258.07","grand_total":"291.61","paid_amount":"278.05","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":"89411","customer_id":"89411","source_of_creation":"PMS","reservation_created_date":"2019-08-29 16:51:36","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":"133.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":"3016376","reservation_id":"81602","confirmation_number":"BV12476888636","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.68","nightly_discount":"0.00","subtotal":"103.68","grand_total":"117.16","paid_amount":"130.72","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":"89478","customer_id":"89478","source_of_creation":"PMS","reservation_created_date":"2019-09-03 13:00:44","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":"103.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":"3017623","reservation_id":"82580","confirmation_number":"PB12396833898","room_stay_from":"2019-09-02","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"66.27,66.27,66.29","nightly_discount":"0.00,0.00,0.00","subtotal":"198.83","grand_total":"224.68","paid_amount":"224.68","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":"29326","customer_id":"29326","source_of_creation":"PMS","reservation_created_date":"2019-08-13 17:10:10","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":"66.27","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017626","reservation_id":"82831","confirmation_number":"PB12371814076","room_stay_from":"2019-09-02","room_stay_to":"2019-09-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"66.28,66.28","nightly_discount":"0.00,0.00","subtotal":"132.56","grand_total":"149.79","paid_amount":"149.79","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":"90352","customer_id":"90352","source_of_creation":"PMS","reservation_created_date":"2019-08-17 20:54:20","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":"66.28","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022733","reservation_id":"83543","confirmation_number":"PB12355471960","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00","nightly_discount":"0.00","subtotal":"114.00","grand_total":"128.82","paid_amount":"128.82","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90840","customer_id":"90840","source_of_creation":"PMS","reservation_created_date":"2019-09-02 14:30:43","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":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3030631","reservation_id":"83383","confirmation_number":"PB12344976843","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.27","nightly_discount":"0.00","subtotal":"77.27","grand_total":"87.32","paid_amount":"87.32","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":"70306","customer_id":"70306","source_of_creation":"PMS","reservation_created_date":"2019-08-29 12:20:58","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.27","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2992434","reservation_id":"79706","confirmation_number":"PB12267016069","room_confirmation_number":"PB12333055103","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","room_stay_status":"Active","nightly_price":"30,30","nightly_discount":"0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"0.00","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-27 14:10:09","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"88225","parentCustTravId":"88225","customer_traveller_id":"88225","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","canceled_nights_data":"","product_attribute_values":"extra_person# .00","currentDayPrice":30,"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"}]},{"room_stay_id":"3015703","reservation_id":"83504","confirmation_number":"BP12267829499","room_confirmation_number":"BP12535765318","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,10.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"90805","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-09-01 12:39:43","reservation_modified_date_time":"2019-09-01 12:39:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90805","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":"3015836","reservation_id":"83514","confirmation_number":"PB12214547095","room_confirmation_number":"PB12393029087","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"90815","product_attribute_values":"extra_person# ","reservation_created_date":"2019-09-01 17:10:54","reservation_modified_date_time":"2019-09-01 17:10:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90815","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2992435","reservation_id":"79706","confirmation_number":"PB12299657856","room_confirmation_number":"PB12333055103","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","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":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-27 14:10:09","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"88225","parentCustTravId":"88225","customer_traveller_id":"88225","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-09-04 17:54:08","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#","currentDayPrice":20,"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"}]},{"room_stay_id":"2995354","reservation_id":"80211","confirmation_number":"PB12290727466","room_confirmation_number":"PB12397880901","room_stay_from":"2019-08-31","room_stay_to":"2019-09-03","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":"88583","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-05 12:45:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88583","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":"3010279","reservation_id":"80496","confirmation_number":"PB12246941786","room_confirmation_number":"PB12326106292","room_stay_from":"2019-08-30","room_stay_to":"2019-09-03","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":"72241","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-10 20:58:46","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"72241","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":"3012896","reservation_id":"82563","confirmation_number":"PB12268364597","room_confirmation_number":"PB12316304348","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","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":"90161","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-13 01:56:08","reservation_modified_date_time":"2019-08-13 01:56:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90161","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":"3014617","reservation_id":"83348","confirmation_number":"BV12268312316","room_confirmation_number":"BV12472147407","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","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":"90713","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-28 17:09:05","reservation_modified_date_time":"2019-08-28 17:09:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90713","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":"3014635","reservation_id":"81446","confirmation_number":"PB12225689157","room_confirmation_number":"PB12323065755","room_stay_from":"2019-08-31","room_stay_to":"2019-09-03","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":"89403","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-26 00:27: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":"89403","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":"3015128","reservation_id":"83424","confirmation_number":"PB12248649226","room_confirmation_number":"PB12359730570","room_stay_from":"2019-08-31","room_stay_to":"2019-09-04","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":"90758","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-30 09:16:08","reservation_modified_date_time":"2019-08-30 09:16:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90758","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":"3015461","reservation_id":"80652","confirmation_number":"PB12218001797","room_confirmation_number":"PB12386020046","room_stay_from":"2019-08-30","room_stay_to":"2019-09-13","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,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,0.00,0.00,0.00,0.00","subtotal":"280.00","grand_total":"316.40","paid_amount":"316.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"88876","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-13 15:30:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88876","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":"3015555","reservation_id":"70099","confirmation_number":"PB12244127121","room_confirmation_number":"PB12377598096","room_stay_from":"2019-08-31","room_stay_to":"2019-09-07","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":"82221","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-02-22 23:19:06","reservation_modified_date_time":"2019-08-31 16:13:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82221","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":"3015559","reservation_id":"83369","confirmation_number":"BP12294922093","room_confirmation_number":"BP12513056132","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","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":"66287","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-28 23:52:59","reservation_modified_date_time":"2019-08-28 23:52:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66287","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":"3015578","reservation_id":"81599","confirmation_number":"PB12278431018","room_confirmation_number":"PB12351485814","room_stay_from":"2019-08-31","room_stay_to":"2019-09-06","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":"70223","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-28 13:59:39","reservation_modified_date_time":"2019-08-30 21:32:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70223","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":"3015702","reservation_id":"83504","confirmation_number":"BP12251094011","room_confirmation_number":"BP12535765318","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","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":"90805","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-01 12:39:43","reservation_modified_date_time":"2019-09-01 12:39:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90805","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":"3015823","reservation_id":"78799","confirmation_number":"PB12237776272","room_confirmation_number":"PB12393584018","room_stay_from":"2019-09-01","room_stay_to":"2019-09-07","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":"87746","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-16 18:16:07","reservation_modified_date_time":"2019-09-01 16:12:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87746","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":"3015837","reservation_id":"83514","confirmation_number":"PB12269388820","room_confirmation_number":"PB12393029087","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"90815","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-01 17:06:04","reservation_modified_date_time":"2019-09-01 17:06:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90815","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":"3015870","reservation_id":"83494","confirmation_number":"BV12296428524","room_confirmation_number":"BV12451121410","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","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":"90800","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-31 21:36:05","reservation_modified_date_time":"2019-09-01 21:17:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90800","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":"3015930","reservation_id":"83524","confirmation_number":"BV12280620338","room_confirmation_number":"BV12471443032","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","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":"90824","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-01 23:56:08","reservation_modified_date_time":"2019-09-02 02:11:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90824","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":"3016204","reservation_id":"83397","confirmation_number":"BV12211326741","room_confirmation_number":"BV12441650528","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","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":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"89411","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-29 16:51:36","reservation_modified_date_time":"2019-09-01 22:07:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89411","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":"3016377","reservation_id":"81602","confirmation_number":"BV12255178846","room_confirmation_number":"BV12476888636","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","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":"89478","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-03 13:00:44","reservation_modified_date_time":"2019-09-04 19:53:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89478","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":"3017627","reservation_id":"82831","confirmation_number":"PB12218077735","room_confirmation_number":"PB12371814076","room_stay_from":"2019-09-02","room_stay_to":"2019-09-04","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":"90352","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-17 20:54:20","reservation_modified_date_time":"2019-09-08 20:38:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90352","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":"3022734","reservation_id":"83543","confirmation_number":"PB12284451427","room_confirmation_number":"PB12355471960","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","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":"90840","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-02 14:30:43","reservation_modified_date_time":"2019-09-26 15:11:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90840","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":"3030632","reservation_id":"83383","confirmation_number":"PB12237334905","room_confirmation_number":"PB12344976843","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","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":"70306","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-29 12:20:58","reservation_modified_date_time":"2019-10-20 18:00:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70306","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":"3015987","reservation_id":"79581","confirmation_number":"PB12266852292","room_confirmation_number":"PB12386682978","room_stay_from":"2019-09-05","room_stay_to":"2019-09-08","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":"45391","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-25 18:13:18","reservation_modified_date_time":"2019-09-02 17:14:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"45391","canceled_nights_data":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3015557","reservation_id":"83477","confirmation_number":"PB12278351575","room_confirmation_number":"PB12317957369","room_stay_from":"2019-08-31","room_stay_to":"2019-09-01","room_stay_status":"Canceled","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","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-31 16:18:10","reservation_modified_date_time":"2019-08-31 16:18:10","customer_id":"90788","parentCustTravId":"90788","customer_traveller_id":"90788","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-09-02 17:30:08","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#","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":"3015871","reservation_id":"83348","confirmation_number":"BV12264851621","room_confirmation_number":"BV12472147407","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-01 21:43:09","reservation_modified_date_time":"2019-09-01 21:43:09","customer_id":"90713","parentCustTravId":"90713","customer_traveller_id":"90713","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":"3015877","reservation_id":"83397","confirmation_number":"BV12298013630","room_confirmation_number":"BV12441650528","room_stay_from":"2019-09-01","room_stay_to":"2019-09-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"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-29 16:51:36","reservation_modified_date_time":"2019-09-01 22:07:51","customer_id":"89411","parentCustTravId":"89411","customer_traveller_id":"89411","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":"3015918","reservation_id":"83524","confirmation_number":"BP12213953303","room_confirmation_number":"BV12471443032","room_stay_from":"2019-09-01","room_stay_to":"2019-09-03","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-02 01:39:06","reservation_modified_date_time":"2019-09-02 01:39:06","customer_id":"90824","parentCustTravId":"90824","customer_traveller_id":"90824","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":"3015992","reservation_id":"82831","confirmation_number":"PB12243282543","room_confirmation_number":"PB12371814076","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"30.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1212","service_quantity":"2","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-02 18:52:18","reservation_modified_date_time":"2019-09-02 18:52:18","customer_id":"90352","parentCustTravId":"90352","customer_traveller_id":"90352","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"60.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3016003","reservation_id":"83554","confirmation_number":"PB12236354585","room_confirmation_number":"PB12388524255","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-02 21:02:33","reservation_modified_date_time":"2019-09-02 21:02:33","customer_id":"90850","parentCustTravId":"90850","customer_traveller_id":"90850","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3016054","reservation_id":"83558","confirmation_number":"BP12219367977","room_confirmation_number":"BP12512528094","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-02 22:43:54","reservation_modified_date_time":"2019-09-02 22:43:54","customer_id":"90854","parentCustTravId":"90854","customer_traveller_id":"90854","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3016057","reservation_id":"83559","confirmation_number":"PB12292102943","room_confirmation_number":"PB12362554987","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-03 00:28:36","reservation_modified_date_time":"2019-09-03 00:28:36","customer_id":"90098","parentCustTravId":"90098","customer_traveller_id":"39147","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3015970","reservation_id":"83546","confirmation_number":"PB12291641865","room_confirmation_number":"PB12346114452","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.20","grand_total":"17.96","paid_amount":"17.96","product_id":null,"service_quantity":"4","product_name":"Coffee Mug","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-02 15:22:58","reservation_modified_date_time":"2019-09-02 15:22:58","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"16.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3015628","reservation_id":"83477","confirmation_number":"PB12273736988","room_confirmation_number":"PB12317957369","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":"11.30","product_id":"1192","service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-31 18:57:26","reservation_modified_date_time":"2019-08-31 18:57:26","customer_id":"90788","parentCustTravId":"90788","customer_traveller_id":"90788","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-09-02 17:30:08","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"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}