{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-04-15","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,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":8,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1103,1113","block_room_bookings":[{"confirmation_number":"PB12227317317","room_stay_from":"2020-04-07","room_stay_to":"2020-04-16","bundle_room":"0"},{"confirmation_number":"PB12296786602","room_stay_from":"2020-04-15","room_stay_to":"2020-05-03","bundle_room":"0"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3087144","reservation_id":"93850","confirmation_number":"PB12350614190","room_stay_from":"2020-04-15","room_stay_to":"2020-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"92.61","nightly_discount":"0","subtotal":"92.61","grand_total":"104.65","paid_amount":"149.85","room_type_id":"289","product_id":"1111","siteminder_id":"EXP-1661007494","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100087","customer_id":"100087","source_of_creation":"Expedia","reservation_created_date":"2020-04-15 19:06:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"92.61","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087147","reservation_id":"93849","confirmation_number":"PB12319912165","room_stay_from":"2020-04-15","room_stay_to":"2020-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"104.91,104.91","nightly_discount":"0,0","subtotal":"209.82","grand_total":"237.10","paid_amount":"327.50","room_type_id":"291","product_id":"1118","siteminder_id":"EXP-1661006464","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100088","customer_id":"100088","source_of_creation":"Expedia","reservation_created_date":"2020-04-15 18:51:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.91","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":"3087180","reservation_id":"93863","confirmation_number":"BP12593352220","room_stay_from":"2020-04-15","room_stay_to":"2020-04-20","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.83,74.83,83.69,83.69,74.83","nightly_discount":"0,0,0,0,0","subtotal":"391.87","grand_total":"442.81","paid_amount":"442.81","room_type_id":"289","product_id":"1106","siteminder_id":"EXP-1661027209","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":"100097","customer_id":"100097","source_of_creation":"Expedia","reservation_created_date":"2020-04-15 23:16:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"74.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[{"room_stay_id":"3087173","reservation_id":"93861","confirmation_number":"BP12519286286","room_stay_from":"2020-04-15","room_stay_to":"2020-04-19","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.83,74.83,83.69,83.69","nightly_discount":"0,0,0,0","subtotal":"317.04","grand_total":"358.25","paid_amount":"358.25","room_type_id":"298","product_id":"1133","siteminder_id":"EXP-1661025622","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":"100095","customer_id":"100095","source_of_creation":"Expedia","reservation_created_date":"2020-04-15 22:56:11","service_canceled_date_time":"2020-04-15 23:41:08","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"358.25","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_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":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3086358","reservation_id":"93721","confirmation_number":"PB12335986231","room_stay_from":"2020-04-07","room_stay_to":"2020-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00","nightly_discount":"57.14,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1035.00","grand_total":"1104.98","paid_amount":"1104.98","room_type_id":"289","product_id":"1105","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76004","customer_id":"76004","source_of_creation":"PMS","reservation_created_date":"2020-04-07 19:57:59","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"115.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087016","reservation_id":"93837","confirmation_number":"PB12334505510","room_stay_from":"2020-04-15","room_stay_to":"2020-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"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":"89875","customer_id":"89875","source_of_creation":"PMS","reservation_created_date":"2020-04-15 14:39:28","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":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087086","reservation_id":"93841","confirmation_number":"PB12336034554","room_stay_from":"2020-04-15","room_stay_to":"2020-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"5.69","subtotal":"99.00","grand_total":"105.44","paid_amount":"105.44","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":"100074","customer_id":"100074","source_of_creation":"PMS","reservation_created_date":"2020-04-15 16:57:21","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":"99.00","currentDayDiscount":"5.69","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086976","reservation_id":"93822","confirmation_number":"PB12389924895","room_stay_from":"2020-04-15","room_stay_to":"2020-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.70,146.70","nightly_discount":"0.00,0.00","subtotal":"293.40","grand_total":"331.54","paid_amount":"331.54","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":"100057","customer_id":"100057","source_of_creation":"PMS","reservation_created_date":"2020-04-14 21:13:23","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":"146.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086658","reservation_id":"93752","confirmation_number":"PB12393073558","room_stay_from":"2020-04-10","room_stay_to":"2020-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1200.00","grand_total":"1356.00","paid_amount":"1356.00","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":"99977","customer_id":"99977","source_of_creation":"PMS","reservation_created_date":"2020-04-10 19:48:57","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":"150.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087151","reservation_id":"93855","confirmation_number":"PB12330300313","room_stay_from":"2020-04-15","room_stay_to":"2020-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.00,169.00,169.00","nightly_discount":"0.00,0.00,30.00","subtotal":"507.00","grand_total":"539.01","paid_amount":"539.01","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":"100090","customer_id":"100090","source_of_creation":"PMS","reservation_created_date":"2020-04-15 21:56:16","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":"169.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087115","reservation_id":"93659","confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,89.00,89.00,89.00,89.00,89.00,89.00,89.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,69.26,5.00,0.00,0.00,0.00,0.00,0.00,0.00,40.00","subtotal":"1939.00","grand_total":"2061.95","paid_amount":"2061.95","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76889","customer_id":"76889","source_of_creation":"PMS","reservation_created_date":"2020-03-30 17:57:33","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":"94.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087096","reservation_id":"92667","confirmation_number":"PB12345466822","room_stay_from":"2020-10-11","room_stay_to":"2020-10-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"520.00","grand_total":"587.60","paid_amount":"146.90","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98817","customer_id":"98817","source_of_creation":"PMS","reservation_created_date":"2020-02-27 17:23:04","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]}],"pms_non_taxable":[{"room_stay_id":"3037458","reservation_id":"87018","confirmation_number":"BV12460920562","room_stay_from":"2020-04-15","room_stay_to":"2020-04-21","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"145.77","room_type_id":"307","product_id":"1224","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"80365","customer_id":"80365","source_of_creation":"PMS","reservation_created_date":"2019-11-11 22:21:09","service_canceled_date_time":"2020-04-04 01:49:00","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"145.77","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3087142","reservation_id":"93850","confirmation_number":"PB12250933090","room_confirmation_number":"PB12350614190","room_stay_from":"2020-04-15","room_stay_to":"2020-04-16","room_stay_status":"Active","nightly_price":"40","nightly_discount":"0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100087","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-15 21:25:36","reservation_modified_date_time":"2020-04-15 21:26:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100087","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087145","reservation_id":"93849","confirmation_number":"PB12217032105","room_confirmation_number":"PB12319912165","room_stay_from":"2020-04-15","room_stay_to":"2020-04-17","room_stay_status":"Active","nightly_price":"40,40","nightly_discount":"0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"73.45","product_id":"1780","service_quantity":"1","customer_traveller_id":"100088","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-15 21:25:26","reservation_modified_date_time":"2020-04-15 21:29:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100088","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086659","reservation_id":"93752","confirmation_number":"PB12231904228","room_confirmation_number":"PB12393073558","room_stay_from":"2020-04-10","room_stay_to":"2020-04-18","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0,0,0,0,0","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"99977","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-12 15:32:09","reservation_modified_date_time":"2020-04-12 15:32:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99977","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3086359","reservation_id":"93721","confirmation_number":"PB12260060467","room_confirmation_number":"PB12335986231","room_stay_from":"2020-04-07","room_stay_to":"2020-04-16","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"76004","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-07 19:57:59","reservation_modified_date_time":"2020-04-07 20:04:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76004","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":"3087017","reservation_id":"93837","confirmation_number":"PB12221369969","room_confirmation_number":"PB12334505510","room_stay_from":"2020-04-15","room_stay_to":"2020-04-16","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":"89875","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-15 14:39:28","reservation_modified_date_time":"2020-04-15 14:39:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89875","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":"3087087","reservation_id":"93841","confirmation_number":"PB12270529559","room_confirmation_number":"PB12336034554","room_stay_from":"2020-04-15","room_stay_to":"2020-04-16","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":"100074","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-15 16:57:21","reservation_modified_date_time":"2020-04-15 17:31:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100074","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":"3087143","reservation_id":"93850","confirmation_number":"PB12232388110","room_confirmation_number":"PB12350614190","room_stay_from":"2020-04-15","room_stay_to":"2020-04-16","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100087","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-15 19:06:08","reservation_modified_date_time":"2020-04-15 21:26:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100087","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":"3086977","reservation_id":"93822","confirmation_number":"PB12264777816","room_confirmation_number":"PB12389924895","room_stay_from":"2020-04-15","room_stay_to":"2020-04-17","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"100057","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-14 21:13:23","reservation_modified_date_time":"2020-04-14 21:13:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100057","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":"3087146","reservation_id":"93849","confirmation_number":"PB12283450687","room_confirmation_number":"PB12319912165","room_stay_from":"2020-04-15","room_stay_to":"2020-04-17","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","customer_traveller_id":"100088","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-15 18:51:08","reservation_modified_date_time":"2020-04-15 21:29:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100088","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":"3086660","reservation_id":"93752","confirmation_number":"PB12268418938","room_confirmation_number":"PB12393073558","room_stay_from":"2020-04-10","room_stay_to":"2020-04-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"99977","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-10 19:48:57","reservation_modified_date_time":"2020-04-12 15:32:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99977","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":"3087152","reservation_id":"93855","confirmation_number":"PB12243759929","room_confirmation_number":"PB12330300313","room_stay_from":"2020-04-15","room_stay_to":"2020-04-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"100090","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-15 21:56:16","reservation_modified_date_time":"2020-04-15 21:56:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100090","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":"3087181","reservation_id":"93863","confirmation_number":"BP12266647678","room_confirmation_number":"BP12593352220","room_stay_from":"2020-04-15","room_stay_to":"2020-04-20","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100097","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-15 23:16:09","reservation_modified_date_time":"2020-04-15 23:27:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100097","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":"3087116","reservation_id":"93659","confirmation_number":"PB12259744424","room_confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-04-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"252.00","grand_total":"284.76","paid_amount":"284.76","product_id":"1781","service_quantity":"1","customer_traveller_id":"76889","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-30 17:57:33","reservation_modified_date_time":"2020-04-15 18:51:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76889","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":"3087097","reservation_id":"92667","confirmation_number":"PB12288618973","room_confirmation_number":"PB12345466822","room_stay_from":"2020-10-11","room_stay_to":"2020-10-15","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"98817","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-27 17:23:04","reservation_modified_date_time":"2020-04-15 18:35:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98817","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3060763","reservation_id":"90395","confirmation_number":"BV12231909159","room_confirmation_number":"BV12428203689","room_stay_from":"2020-04-13","room_stay_to":"2020-04-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"169.50","paid_amount":"0.00","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-22 23:05:06","reservation_modified_date_time":"2020-01-22 23:05:06","customer_id":"96447","parentCustTravId":"96447","customer_traveller_id":"96447","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":"3087079","reservation_id":"93828","confirmation_number":"PB12229924300","room_confirmation_number":"PB12333049554","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"84.75","paid_amount":"0.00","product_id":"1146","service_quantity":"3","product_name":"Boat Dockage","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-15 13:34:37","reservation_modified_date_time":"2020-04-15 17:22:15","customer_id":"100075","parentCustTravId":"100075","customer_traveller_id":"100075","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":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3087080","reservation_id":"93828","confirmation_number":"PB12286878741","room_confirmation_number":"PB12333049554","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"33.90","paid_amount":"0.00","product_id":"1147","service_quantity":"3","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-15 13:34:37","reservation_modified_date_time":"2020-04-15 17:22:15","customer_id":"100075","parentCustTravId":"100075","customer_traveller_id":"100075","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":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3087124","reservation_id":"93852","confirmation_number":"PB12291129387","room_confirmation_number":"PB12369515147","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1147","service_quantity":"2","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-15 20:26:16","reservation_modified_date_time":"2020-04-15 20:26:16","customer_id":"100084","parentCustTravId":"100084","customer_traveller_id":"100084","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3087125","reservation_id":"93852","confirmation_number":"PB12252832524","room_confirmation_number":"PB12369515147","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.50","paid_amount":"0.00","product_id":"1146","service_quantity":"2","product_name":"Boat Dockage","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-15 20:26:16","reservation_modified_date_time":"2020-04-15 20:26:16","customer_id":"100084","parentCustTravId":"100084","customer_traveller_id":"100084","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":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3087148","reservation_id":"93849","confirmation_number":"PB12233075927","room_confirmation_number":"PB12319912165","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.25","paid_amount":"0.00","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-15 21:36:30","reservation_modified_date_time":"2020-04-15 21:36:30","customer_id":"100088","parentCustTravId":"100088","customer_traveller_id":"100088","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":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3086988","reservation_id":"93827","confirmation_number":"PB12230286186","room_confirmation_number":"PB12377051829","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"12.00","grand_total":"27.12","paid_amount":"27.12","product_id":null,"service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-15 13:07:43","reservation_modified_date_time":"2020-04-15 13:07:43","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":"24.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3087078","reservation_id":"93843","confirmation_number":"PB12289134622","room_confirmation_number":"PB12321034210","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-15 17:18:56","reservation_modified_date_time":"2020-04-15 17:18:56","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120","departureCount":8,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1103,1113","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12227317317","room_stay_from":"2020-04-07","room_stay_to":"2020-04-16","bundle_room":"0"},{"confirmation_number":"PB12296786602","room_stay_from":"2020-04-15","room_stay_to":"2020-05-03","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3087144","reservation_id":"93850","confirmation_number":"PB12350614190","room_stay_from":"2020-04-15","room_stay_to":"2020-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"92.61","nightly_discount":"0","subtotal":"92.61","grand_total":"104.65","paid_amount":"149.85","room_type_id":"289","product_id":"1111","siteminder_id":"EXP-1661007494","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100087","customer_id":"100087","source_of_creation":"Expedia","reservation_created_date":"2020-04-15 19:06:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"92.61","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087147","reservation_id":"93849","confirmation_number":"PB12319912165","room_stay_from":"2020-04-15","room_stay_to":"2020-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"104.91,104.91","nightly_discount":"0,0","subtotal":"209.82","grand_total":"237.10","paid_amount":"327.50","room_type_id":"291","product_id":"1118","siteminder_id":"EXP-1661006464","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100088","customer_id":"100088","source_of_creation":"Expedia","reservation_created_date":"2020-04-15 18:51:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.91","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_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":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3086358","reservation_id":"93721","confirmation_number":"PB12335986231","room_stay_from":"2020-04-07","room_stay_to":"2020-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00","nightly_discount":"57.14,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1035.00","grand_total":"1104.98","paid_amount":"1104.98","room_type_id":"289","product_id":"1105","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76004","customer_id":"76004","source_of_creation":"PMS","reservation_created_date":"2020-04-07 19:57:59","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"115.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087016","reservation_id":"93837","confirmation_number":"PB12334505510","room_stay_from":"2020-04-15","room_stay_to":"2020-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"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":"89875","customer_id":"89875","source_of_creation":"PMS","reservation_created_date":"2020-04-15 14:39:28","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":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087086","reservation_id":"93841","confirmation_number":"PB12336034554","room_stay_from":"2020-04-15","room_stay_to":"2020-04-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"5.69","subtotal":"99.00","grand_total":"105.44","paid_amount":"105.44","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":"100074","customer_id":"100074","source_of_creation":"PMS","reservation_created_date":"2020-04-15 16:57:21","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":"99.00","currentDayDiscount":"5.69","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086976","reservation_id":"93822","confirmation_number":"PB12389924895","room_stay_from":"2020-04-15","room_stay_to":"2020-04-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.70,146.70","nightly_discount":"0.00,0.00","subtotal":"293.40","grand_total":"331.54","paid_amount":"331.54","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":"100057","customer_id":"100057","source_of_creation":"PMS","reservation_created_date":"2020-04-14 21:13:23","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":"146.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086658","reservation_id":"93752","confirmation_number":"PB12393073558","room_stay_from":"2020-04-10","room_stay_to":"2020-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1200.00","grand_total":"1356.00","paid_amount":"1356.00","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":"99977","customer_id":"99977","source_of_creation":"PMS","reservation_created_date":"2020-04-10 19:48:57","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":"150.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087151","reservation_id":"93855","confirmation_number":"PB12330300313","room_stay_from":"2020-04-15","room_stay_to":"2020-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.00,169.00,169.00","nightly_discount":"0.00,0.00,30.00","subtotal":"507.00","grand_total":"539.01","paid_amount":"539.01","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":"100090","customer_id":"100090","source_of_creation":"PMS","reservation_created_date":"2020-04-15 21:56:16","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":"169.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087115","reservation_id":"93659","confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,89.00,89.00,89.00,89.00,89.00,89.00,89.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,69.26,5.00,0.00,0.00,0.00,0.00,0.00,0.00,40.00","subtotal":"1939.00","grand_total":"2061.95","paid_amount":"2061.95","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76889","customer_id":"76889","source_of_creation":"PMS","reservation_created_date":"2020-03-30 17:57:33","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":"94.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087096","reservation_id":"92667","confirmation_number":"PB12345466822","room_stay_from":"2020-10-11","room_stay_to":"2020-10-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"520.00","grand_total":"587.60","paid_amount":"146.90","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98817","customer_id":"98817","source_of_creation":"PMS","reservation_created_date":"2020-02-27 17:23:04","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3087142","reservation_id":"93850","confirmation_number":"PB12250933090","room_confirmation_number":"PB12350614190","room_stay_from":"2020-04-15","room_stay_to":"2020-04-16","room_stay_status":"Active","nightly_price":"40","nightly_discount":"0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100087","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-15 21:25:36","reservation_modified_date_time":"2020-04-15 21:26:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100087","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087145","reservation_id":"93849","confirmation_number":"PB12217032105","room_confirmation_number":"PB12319912165","room_stay_from":"2020-04-15","room_stay_to":"2020-04-17","room_stay_status":"Active","nightly_price":"40,40","nightly_discount":"0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"73.45","product_id":"1780","service_quantity":"1","customer_traveller_id":"100088","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-15 21:25:26","reservation_modified_date_time":"2020-04-15 21:29:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100088","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086659","reservation_id":"93752","confirmation_number":"PB12231904228","room_confirmation_number":"PB12393073558","room_stay_from":"2020-04-10","room_stay_to":"2020-04-18","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0,0,0,0,0","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"99977","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-12 15:32:09","reservation_modified_date_time":"2020-04-12 15:32:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99977","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3086359","reservation_id":"93721","confirmation_number":"PB12260060467","room_confirmation_number":"PB12335986231","room_stay_from":"2020-04-07","room_stay_to":"2020-04-16","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"76004","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-07 19:57:59","reservation_modified_date_time":"2020-04-07 20:04:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76004","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":"3087017","reservation_id":"93837","confirmation_number":"PB12221369969","room_confirmation_number":"PB12334505510","room_stay_from":"2020-04-15","room_stay_to":"2020-04-16","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":"89875","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-15 14:39:28","reservation_modified_date_time":"2020-04-15 14:39:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89875","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":"3087087","reservation_id":"93841","confirmation_number":"PB12270529559","room_confirmation_number":"PB12336034554","room_stay_from":"2020-04-15","room_stay_to":"2020-04-16","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":"100074","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-15 16:57:21","reservation_modified_date_time":"2020-04-15 17:31:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100074","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":"3087143","reservation_id":"93850","confirmation_number":"PB12232388110","room_confirmation_number":"PB12350614190","room_stay_from":"2020-04-15","room_stay_to":"2020-04-16","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100087","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-15 19:06:08","reservation_modified_date_time":"2020-04-15 21:26:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100087","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":"3086977","reservation_id":"93822","confirmation_number":"PB12264777816","room_confirmation_number":"PB12389924895","room_stay_from":"2020-04-15","room_stay_to":"2020-04-17","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"100057","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-14 21:13:23","reservation_modified_date_time":"2020-04-14 21:13:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100057","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":"3087146","reservation_id":"93849","confirmation_number":"PB12283450687","room_confirmation_number":"PB12319912165","room_stay_from":"2020-04-15","room_stay_to":"2020-04-17","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","customer_traveller_id":"100088","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-15 18:51:08","reservation_modified_date_time":"2020-04-15 21:29:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100088","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":"3086660","reservation_id":"93752","confirmation_number":"PB12268418938","room_confirmation_number":"PB12393073558","room_stay_from":"2020-04-10","room_stay_to":"2020-04-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"99977","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-10 19:48:57","reservation_modified_date_time":"2020-04-12 15:32:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99977","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":"3087152","reservation_id":"93855","confirmation_number":"PB12243759929","room_confirmation_number":"PB12330300313","room_stay_from":"2020-04-15","room_stay_to":"2020-04-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"100090","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-15 21:56:16","reservation_modified_date_time":"2020-04-15 21:56:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100090","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":"3087116","reservation_id":"93659","confirmation_number":"PB12259744424","room_confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-04-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"252.00","grand_total":"284.76","paid_amount":"284.76","product_id":"1781","service_quantity":"1","customer_traveller_id":"76889","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-30 17:57:33","reservation_modified_date_time":"2020-04-15 18:51:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76889","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":"3087097","reservation_id":"92667","confirmation_number":"PB12288618973","room_confirmation_number":"PB12345466822","room_stay_from":"2020-10-11","room_stay_to":"2020-10-15","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"98817","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-27 17:23:04","reservation_modified_date_time":"2020-04-15 18:35:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98817","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3087079","reservation_id":"93828","confirmation_number":"PB12229924300","room_confirmation_number":"PB12333049554","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"84.75","paid_amount":"0.00","product_id":"1146","service_quantity":"3","product_name":"Boat Dockage","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-15 13:34:37","reservation_modified_date_time":"2020-04-15 17:22:15","customer_id":"100075","parentCustTravId":"100075","customer_traveller_id":"100075","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":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3087080","reservation_id":"93828","confirmation_number":"PB12286878741","room_confirmation_number":"PB12333049554","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"33.90","paid_amount":"0.00","product_id":"1147","service_quantity":"3","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-15 13:34:37","reservation_modified_date_time":"2020-04-15 17:22:15","customer_id":"100075","parentCustTravId":"100075","customer_traveller_id":"100075","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":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3087124","reservation_id":"93852","confirmation_number":"PB12291129387","room_confirmation_number":"PB12369515147","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1147","service_quantity":"2","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-15 20:26:16","reservation_modified_date_time":"2020-04-15 20:26:16","customer_id":"100084","parentCustTravId":"100084","customer_traveller_id":"100084","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3087125","reservation_id":"93852","confirmation_number":"PB12252832524","room_confirmation_number":"PB12369515147","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.50","paid_amount":"0.00","product_id":"1146","service_quantity":"2","product_name":"Boat Dockage","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-15 20:26:16","reservation_modified_date_time":"2020-04-15 20:26:16","customer_id":"100084","parentCustTravId":"100084","customer_traveller_id":"100084","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":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3087148","reservation_id":"93849","confirmation_number":"PB12233075927","room_confirmation_number":"PB12319912165","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.25","paid_amount":"0.00","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-15 21:36:30","reservation_modified_date_time":"2020-04-15 21:36:30","customer_id":"100088","parentCustTravId":"100088","customer_traveller_id":"100088","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":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3086988","reservation_id":"93827","confirmation_number":"PB12230286186","room_confirmation_number":"PB12377051829","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"12.00","grand_total":"27.12","paid_amount":"27.12","product_id":null,"service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-15 13:07:43","reservation_modified_date_time":"2020-04-15 13:07:43","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":"24.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3087078","reservation_id":"93843","confirmation_number":"PB12289134622","room_confirmation_number":"PB12321034210","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-15 17:18:56","reservation_modified_date_time":"2020-04-15 17:18:56","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":0,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_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":[],"fe_non_taxable":[],"pms_taxable":[],"pms_non_taxable":[{"room_stay_id":"3037458","reservation_id":"87018","confirmation_number":"BV12460920562","room_stay_from":"2020-04-15","room_stay_to":"2020-04-21","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"145.77","room_type_id":"307","product_id":"1224","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"80365","customer_id":"80365","source_of_creation":"PMS","reservation_created_date":"2019-11-11 22:21:09","service_canceled_date_time":"2020-04-04 01:49:00","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"145.77","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3060763","reservation_id":"90395","confirmation_number":"BV12231909159","room_confirmation_number":"BV12428203689","room_stay_from":"2020-04-13","room_stay_to":"2020-04-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"169.50","paid_amount":"0.00","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-22 23:05:06","reservation_modified_date_time":"2020-01-22 23:05:06","customer_id":"96447","parentCustTravId":"96447","customer_traveller_id":"96447","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":0,"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":[],"exp_taxable":[{"room_stay_id":"3087180","reservation_id":"93863","confirmation_number":"BP12593352220","room_stay_from":"2020-04-15","room_stay_to":"2020-04-20","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.83,74.83,83.69,83.69,74.83","nightly_discount":"0,0,0,0,0","subtotal":"391.87","grand_total":"442.81","paid_amount":"442.81","room_type_id":"289","product_id":"1106","siteminder_id":"EXP-1661027209","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":"100097","customer_id":"100097","source_of_creation":"Expedia","reservation_created_date":"2020-04-15 23:16:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"74.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[{"room_stay_id":"3087173","reservation_id":"93861","confirmation_number":"BP12519286286","room_stay_from":"2020-04-15","room_stay_to":"2020-04-19","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.83,74.83,83.69,83.69","nightly_discount":"0,0,0,0","subtotal":"317.04","grand_total":"358.25","paid_amount":"358.25","room_type_id":"298","product_id":"1133","siteminder_id":"EXP-1661025622","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":"100095","customer_id":"100095","source_of_creation":"Expedia","reservation_created_date":"2020-04-15 22:56:11","service_canceled_date_time":"2020-04-15 23:41:08","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"358.25","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_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":[],"fe_non_taxable":[],"pms_taxable":[],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3087181","reservation_id":"93863","confirmation_number":"BP12266647678","room_confirmation_number":"BP12593352220","room_stay_from":"2020-04-15","room_stay_to":"2020-04-20","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100097","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-15 23:16:09","reservation_modified_date_time":"2020-04-15 23:27:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100097","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}