{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-03-29","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":14,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3084956","reservation_id":"93603","confirmation_number":"PB12327387835","room_stay_from":"2020-03-26","room_stay_to":"2020-03-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.52,91.02,91.02,92.53","nightly_discount":"0,0,0,0","subtotal":"367.09","grand_total":"414.82","paid_amount":"414.82","room_type_id":"286","product_id":"1086","siteminder_id":"EXP-1659424321","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":"99833","customer_id":"99833","source_of_creation":"Expedia","reservation_created_date":"2020-03-26 15:02:11","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"92.53","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":"3085265","reservation_id":"93626","confirmation_number":"BV12450664378","room_stay_from":"2020-03-28","room_stay_to":"2020-03-29","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.33","nightly_discount":"0.00","subtotal":"73.33","grand_total":"82.86","paid_amount":"82.86","room_type_id":"291","product_id":"1117","siteminder_id":"EXP-1659546314","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":"99852","customer_id":"99852","source_of_creation":"Expedia","reservation_created_date":"2020-03-27 20:25:06","service_canceled_date_time":"2020-03-29 15:52:32","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","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":[{"room_stay_id":"3082071","reservation_id":"76103","confirmation_number":"PB12347611431","room_stay_from":"2020-03-29","room_stay_to":"2020-04-02","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"291.54","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85805","customer_id":"85805","source_of_creation":"FE","reservation_created_date":"2019-05-09 18:21:17","service_canceled_date_time":"2020-03-18 12:51:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3084974","reservation_id":"93532","confirmation_number":"PB12362048535","room_stay_from":"2020-03-20","room_stay_to":"2020-03-30","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"170.00,170.00,170.00,145.00,145.00,145.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1341.00","grand_total":"1515.33","paid_amount":"1515.33","room_type_id":"285","product_id":"1085","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":"99766","customer_id":"99766","source_of_creation":"PMS","reservation_created_date":"2020-03-19 21:58:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3085182","reservation_id":"93640","confirmation_number":"PB12317907892","room_stay_from":"2020-03-29","room_stay_to":"2020-03-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99872","customer_id":"99872","source_of_creation":"PMS","reservation_created_date":"2020-03-28 17:38:01","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":"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":"3085205","reservation_id":"93621","confirmation_number":"PB12367257503","room_stay_from":"2020-03-28","room_stay_to":"2020-03-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.00,106.00","nightly_discount":"0.00,0.00","subtotal":"212.00","grand_total":"239.56","paid_amount":"239.56","room_type_id":"289","product_id":"1096","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":"99846","customer_id":"99846","source_of_creation":"PMS","reservation_created_date":"2020-03-27 18:24:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"106.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3085252","reservation_id":"93631","confirmation_number":"PB12341414573","room_stay_from":"2020-03-27","room_stay_to":"2020-03-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.00,82.00,82.00","nightly_discount":"0.00,0.00,0.00","subtotal":"246.00","grand_total":"277.98","paid_amount":"277.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":"99860","customer_id":"99860","source_of_creation":"PMS","reservation_created_date":"2020-03-27 22:07:37","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"82.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084843","reservation_id":"82255","confirmation_number":"PB12310264585","room_stay_from":"2020-03-25","room_stay_to":"2020-03-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"150.00,150.00,150.00,150.00,150.00,150.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,37.41","subtotal":"900.00","grand_total":"974.73","paid_amount":"979.59","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":"45771","customer_id":"45771","source_of_creation":"PMS","reservation_created_date":"2019-08-08 17:00:33","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":"3085076","reservation_id":"93614","confirmation_number":"PB12339876249","room_stay_from":"2020-03-27","room_stay_to":"2020-03-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00","nightly_discount":"17.57,0.00,0.00,0.00","subtotal":"396.00","grand_total":"427.63","paid_amount":"427.63","room_type_id":"289","product_id":"1098","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":"88564","customer_id":"88564","source_of_creation":"PMS","reservation_created_date":"2020-03-27 14:34:25","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3085277","reservation_id":"93607","confirmation_number":"PB12360243059","room_stay_from":"2020-03-27","room_stay_to":"2020-03-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"396.00","grand_total":"447.48","paid_amount":"447.48","room_type_id":"291","product_id":"1114","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99832","customer_id":"99832","source_of_creation":"PMS","reservation_created_date":"2020-03-26 16:43:22","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","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":"3085279","reservation_id":"93637","confirmation_number":"PB12394572506","room_stay_from":"2020-03-29","room_stay_to":"2020-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"891.00","grand_total":"1006.83","paid_amount":"671.22","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":"99869","customer_id":"99869","source_of_creation":"PMS","reservation_created_date":"2020-03-28 15:45:22","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":"","changedComment":"To date changed","deltaChange":"0.00","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":"3085262","reservation_id":"80161","confirmation_number":"PB12359313933","room_stay_from":"2020-09-15","room_stay_to":"2020-09-20","room_stay_status":"Active","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"169.00,169.00,169.00,169.00,169.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"845.00","grand_total":"954.85","paid_amount":"200.00","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81518","customer_id":"81518","source_of_creation":"PMS","reservation_created_date":"2019-07-04 15:46:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3085232","reservation_id":"84536","confirmation_number":"BP12594124115","room_stay_from":"2020-09-15","room_stay_to":"2020-09-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.00,117.00,117.00,117.00,117.00,117.00,117.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"819.00","grand_total":"925.47","paid_amount":"132.21","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"40114","customer_id":"40114","source_of_creation":"PMS","reservation_created_date":"2019-09-22 15:56:42","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3085230","reservation_id":"85293","confirmation_number":"BV12412059286","room_stay_from":"2020-09-15","room_stay_to":"2020-10-01","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.00,104.00,104.00,84.00,84.00,84.00,84.00,84.00,104.00,104.00,84.00,84.00,84.00,84.00,84.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1444.00","grand_total":"1631.72","paid_amount":"100.00","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":"40114","customer_id":"40114","source_of_creation":"PMS","reservation_created_date":"2019-10-08 13:40:32","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":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3084831","reservation_id":"82255","confirmation_number":"PB12241791303","room_confirmation_number":"PB12310264585","room_stay_from":"2020-03-25","room_stay_to":"2020-03-31","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"45771","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-25 16:02:14","reservation_modified_date_time":"2020-03-25 16:02:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"45771","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":"3084955","reservation_id":"93603","confirmation_number":"PB12295658443","room_confirmation_number":"PB12327387835","room_stay_from":"2020-03-26","room_stay_to":"2020-03-30","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":"99833","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-26 15:02:11","reservation_modified_date_time":"2020-03-26 17:33:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99833","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":"3084975","reservation_id":"93532","confirmation_number":"PB12235989805","room_confirmation_number":"PB12362048535","room_stay_from":"2020-03-20","room_stay_to":"2020-03-30","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"99766","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 21:58:10","reservation_modified_date_time":"2020-03-26 19:10:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99766","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":"3085184","reservation_id":"93640","confirmation_number":"PB12210536597","room_confirmation_number":"PB12317907892","room_stay_from":"2020-03-29","room_stay_to":"2020-03-30","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":"99872","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-28 17:38:01","reservation_modified_date_time":"2020-03-28 17:56:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99872","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":"3085206","reservation_id":"93621","confirmation_number":"PB12269263743","room_confirmation_number":"PB12367257503","room_stay_from":"2020-03-28","room_stay_to":"2020-03-30","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":"99846","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-27 18:24:10","reservation_modified_date_time":"2020-03-28 20:59:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99846","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":"3085253","reservation_id":"93631","confirmation_number":"PB12271721735","room_confirmation_number":"PB12341414573","room_stay_from":"2020-03-27","room_stay_to":"2020-03-30","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":"99860","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-27 22:07:37","reservation_modified_date_time":"2020-03-29 14:43:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99860","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3045946","reservation_id":"88064","confirmation_number":"BV12223447717","room_confirmation_number":"BV12428689124","room_stay_from":"2020-03-16","room_stay_to":"2020-03-31","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"94413","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-08 21:42:57","reservation_modified_date_time":"2019-12-08 21:42:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94413","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":"3084844","reservation_id":"82255","confirmation_number":"PB12272153401","room_confirmation_number":"PB12310264585","room_stay_from":"2020-03-25","room_stay_to":"2020-03-31","room_stay_status":"Active","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"45771","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-08 17:00:33","reservation_modified_date_time":"2020-03-25 16:41:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"45771","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":"3085077","reservation_id":"93614","confirmation_number":"PB12282888539","room_confirmation_number":"PB12339876249","room_stay_from":"2020-03-27","room_stay_to":"2020-03-31","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":"88564","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-27 14:34:25","reservation_modified_date_time":"2020-03-27 20:56:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88564","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":"3085278","reservation_id":"93607","confirmation_number":"PB12277378441","room_confirmation_number":"PB12360243059","room_stay_from":"2020-03-27","room_stay_to":"2020-03-31","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":"99832","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-26 16:43:22","reservation_modified_date_time":"2020-03-29 19:41:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99832","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3085280","reservation_id":"93637","confirmation_number":"PB12243625342","room_confirmation_number":"PB12394572506","room_stay_from":"2020-03-29","room_stay_to":"2020-04-07","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":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"99869","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-28 15:45:22","reservation_modified_date_time":"2020-03-29 19:51:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99869","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3085264","reservation_id":"80161","confirmation_number":"PB12247198211","room_confirmation_number":"PB12359313933","room_stay_from":"2020-09-15","room_stay_to":"2020-09-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"81518","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-04 15:46:28","reservation_modified_date_time":"2020-03-29 15:42:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81518","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3085233","reservation_id":"84536","confirmation_number":"BP12224374781","room_confirmation_number":"BP12594124115","room_stay_from":"2020-09-15","room_stay_to":"2020-09-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"40114","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-22 15:56:42","reservation_modified_date_time":"2020-03-29 13:34:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"40114","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3085231","reservation_id":"85293","confirmation_number":"BV12252690227","room_confirmation_number":"BV12412059286","room_stay_from":"2020-09-15","room_stay_to":"2020-10-01","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"40114","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-08 13:40:32","reservation_modified_date_time":"2020-03-29 13:24:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"40114","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3085234","reservation_id":"93613","confirmation_number":"PB12218865057","room_confirmation_number":"PB12359720112","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":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-29 14:04:17","reservation_modified_date_time":"2020-03-29 14:04:17","customer_id":"99838","parentCustTravId":"99838","customer_traveller_id":"99838","static_pos_type":"latecheckoutfee","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":"3085251","reservation_id":"93646","confirmation_number":"PB12246245168","room_confirmation_number":"PB12329795608","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":"3.00","paid_amount":"3.00","product_id":"1213","service_quantity":"3","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-29 14:38:38","reservation_modified_date_time":"2020-03-29 14:38:38","customer_id":"99879","parentCustTravId":"99879","customer_traveller_id":"99879","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":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3085271","reservation_id":"93621","confirmation_number":"PB12219285189","room_confirmation_number":"PB12367257503","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":"13.56","paid_amount":"13.56","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-29 17:12:51","reservation_modified_date_time":"2020-03-29 17:12:51","customer_id":"99846","parentCustTravId":"99846","customer_traveller_id":"99846","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":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3085273","reservation_id":"93654","confirmation_number":"PB12271885486","room_confirmation_number":"PB12352066801","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":"11.30","paid_amount":"11.30","product_id":null,"service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-29 17:32:48","reservation_modified_date_time":"2020-03-29 17:32:48","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":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3085275","reservation_id":"93655","confirmation_number":"PB12295232584","room_confirmation_number":"PB12346046231","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":"13.56","paid_amount":"13.56","product_id":null,"service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-29 18:35:41","reservation_modified_date_time":"2020-03-29 18:35:41","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":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3085276","reservation_id":"93655","confirmation_number":"PB12293364583","room_confirmation_number":"PB12346046231","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":"26.75","paid_amount":"26.75","product_id":null,"service_quantity":"1","product_name":"Resort Fee Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-29 18:35:41","reservation_modified_date_time":"2020-03-29 18:35:41","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":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3085250","reservation_id":"93653","confirmation_number":"PB12211406010","room_confirmation_number":"PB12358938218","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":"20.00","paid_amount":"20.00","product_id":null,"service_quantity":"1","product_name":"Parking","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-29 14:34:34","reservation_modified_date_time":"2020-03-29 14:34:34","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120","departureCount":14,"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":"3084956","reservation_id":"93603","confirmation_number":"PB12327387835","room_stay_from":"2020-03-26","room_stay_to":"2020-03-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.52,91.02,91.02,92.53","nightly_discount":"0,0,0,0","subtotal":"367.09","grand_total":"414.82","paid_amount":"414.82","room_type_id":"286","product_id":"1086","siteminder_id":"EXP-1659424321","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":"99833","customer_id":"99833","source_of_creation":"Expedia","reservation_created_date":"2020-03-26 15:02:11","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"92.53","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_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":[{"room_stay_id":"3082071","reservation_id":"76103","confirmation_number":"PB12347611431","room_stay_from":"2020-03-29","room_stay_to":"2020-04-02","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"291.54","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"85805","customer_id":"85805","source_of_creation":"FE","reservation_created_date":"2019-05-09 18:21:17","service_canceled_date_time":"2020-03-18 12:51:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3084974","reservation_id":"93532","confirmation_number":"PB12362048535","room_stay_from":"2020-03-20","room_stay_to":"2020-03-30","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"170.00,170.00,170.00,145.00,145.00,145.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1341.00","grand_total":"1515.33","paid_amount":"1515.33","room_type_id":"285","product_id":"1085","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":"99766","customer_id":"99766","source_of_creation":"PMS","reservation_created_date":"2020-03-19 21:58:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3085182","reservation_id":"93640","confirmation_number":"PB12317907892","room_stay_from":"2020-03-29","room_stay_to":"2020-03-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99872","customer_id":"99872","source_of_creation":"PMS","reservation_created_date":"2020-03-28 17:38:01","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":"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":"3085205","reservation_id":"93621","confirmation_number":"PB12367257503","room_stay_from":"2020-03-28","room_stay_to":"2020-03-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.00,106.00","nightly_discount":"0.00,0.00","subtotal":"212.00","grand_total":"239.56","paid_amount":"239.56","room_type_id":"289","product_id":"1096","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":"99846","customer_id":"99846","source_of_creation":"PMS","reservation_created_date":"2020-03-27 18:24:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"106.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3085252","reservation_id":"93631","confirmation_number":"PB12341414573","room_stay_from":"2020-03-27","room_stay_to":"2020-03-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.00,82.00,82.00","nightly_discount":"0.00,0.00,0.00","subtotal":"246.00","grand_total":"277.98","paid_amount":"277.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":"99860","customer_id":"99860","source_of_creation":"PMS","reservation_created_date":"2020-03-27 22:07:37","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"82.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084843","reservation_id":"82255","confirmation_number":"PB12310264585","room_stay_from":"2020-03-25","room_stay_to":"2020-03-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"150.00,150.00,150.00,150.00,150.00,150.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,37.41","subtotal":"900.00","grand_total":"974.73","paid_amount":"979.59","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":"45771","customer_id":"45771","source_of_creation":"PMS","reservation_created_date":"2019-08-08 17:00:33","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":"3085076","reservation_id":"93614","confirmation_number":"PB12339876249","room_stay_from":"2020-03-27","room_stay_to":"2020-03-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00","nightly_discount":"17.57,0.00,0.00,0.00","subtotal":"396.00","grand_total":"427.63","paid_amount":"427.63","room_type_id":"289","product_id":"1098","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":"88564","customer_id":"88564","source_of_creation":"PMS","reservation_created_date":"2020-03-27 14:34:25","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3085277","reservation_id":"93607","confirmation_number":"PB12360243059","room_stay_from":"2020-03-27","room_stay_to":"2020-03-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"396.00","grand_total":"447.48","paid_amount":"447.48","room_type_id":"291","product_id":"1114","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99832","customer_id":"99832","source_of_creation":"PMS","reservation_created_date":"2020-03-26 16:43:22","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","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":"3085279","reservation_id":"93637","confirmation_number":"PB12394572506","room_stay_from":"2020-03-29","room_stay_to":"2020-04-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"891.00","grand_total":"1006.83","paid_amount":"671.22","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":"99869","customer_id":"99869","source_of_creation":"PMS","reservation_created_date":"2020-03-28 15:45:22","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":"","changedComment":"To date changed","deltaChange":"0.00","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":"3085262","reservation_id":"80161","confirmation_number":"PB12359313933","room_stay_from":"2020-09-15","room_stay_to":"2020-09-20","room_stay_status":"Active","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"169.00,169.00,169.00,169.00,169.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"845.00","grand_total":"954.85","paid_amount":"200.00","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81518","customer_id":"81518","source_of_creation":"PMS","reservation_created_date":"2019-07-04 15:46:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3084831","reservation_id":"82255","confirmation_number":"PB12241791303","room_confirmation_number":"PB12310264585","room_stay_from":"2020-03-25","room_stay_to":"2020-03-31","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"45771","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-25 16:02:14","reservation_modified_date_time":"2020-03-25 16:02:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"45771","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":"3084955","reservation_id":"93603","confirmation_number":"PB12295658443","room_confirmation_number":"PB12327387835","room_stay_from":"2020-03-26","room_stay_to":"2020-03-30","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":"99833","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-26 15:02:11","reservation_modified_date_time":"2020-03-26 17:33:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99833","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":"3084975","reservation_id":"93532","confirmation_number":"PB12235989805","room_confirmation_number":"PB12362048535","room_stay_from":"2020-03-20","room_stay_to":"2020-03-30","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"99766","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 21:58:10","reservation_modified_date_time":"2020-03-26 19:10:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99766","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":"3085184","reservation_id":"93640","confirmation_number":"PB12210536597","room_confirmation_number":"PB12317907892","room_stay_from":"2020-03-29","room_stay_to":"2020-03-30","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":"99872","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-28 17:38:01","reservation_modified_date_time":"2020-03-28 17:56:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99872","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":"3085206","reservation_id":"93621","confirmation_number":"PB12269263743","room_confirmation_number":"PB12367257503","room_stay_from":"2020-03-28","room_stay_to":"2020-03-30","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":"99846","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-27 18:24:10","reservation_modified_date_time":"2020-03-28 20:59:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99846","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":"3085253","reservation_id":"93631","confirmation_number":"PB12271721735","room_confirmation_number":"PB12341414573","room_stay_from":"2020-03-27","room_stay_to":"2020-03-30","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":"99860","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-27 22:07:37","reservation_modified_date_time":"2020-03-29 14:43:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99860","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084844","reservation_id":"82255","confirmation_number":"PB12272153401","room_confirmation_number":"PB12310264585","room_stay_from":"2020-03-25","room_stay_to":"2020-03-31","room_stay_status":"Active","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"45771","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-08 17:00:33","reservation_modified_date_time":"2020-03-25 16:41:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"45771","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":"3085077","reservation_id":"93614","confirmation_number":"PB12282888539","room_confirmation_number":"PB12339876249","room_stay_from":"2020-03-27","room_stay_to":"2020-03-31","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":"88564","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-27 14:34:25","reservation_modified_date_time":"2020-03-27 20:56:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88564","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":"3085278","reservation_id":"93607","confirmation_number":"PB12277378441","room_confirmation_number":"PB12360243059","room_stay_from":"2020-03-27","room_stay_to":"2020-03-31","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":"99832","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-26 16:43:22","reservation_modified_date_time":"2020-03-29 19:41:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99832","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3085280","reservation_id":"93637","confirmation_number":"PB12243625342","room_confirmation_number":"PB12394572506","room_stay_from":"2020-03-29","room_stay_to":"2020-04-07","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":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"99869","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-28 15:45:22","reservation_modified_date_time":"2020-03-29 19:51:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99869","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3085264","reservation_id":"80161","confirmation_number":"PB12247198211","room_confirmation_number":"PB12359313933","room_stay_from":"2020-09-15","room_stay_to":"2020-09-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"81518","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-04 15:46:28","reservation_modified_date_time":"2020-03-29 15:42:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81518","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3085234","reservation_id":"93613","confirmation_number":"PB12218865057","room_confirmation_number":"PB12359720112","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":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-29 14:04:17","reservation_modified_date_time":"2020-03-29 14:04:17","customer_id":"99838","parentCustTravId":"99838","customer_traveller_id":"99838","static_pos_type":"latecheckoutfee","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":"3085251","reservation_id":"93646","confirmation_number":"PB12246245168","room_confirmation_number":"PB12329795608","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":"3.00","paid_amount":"3.00","product_id":"1213","service_quantity":"3","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-29 14:38:38","reservation_modified_date_time":"2020-03-29 14:38:38","customer_id":"99879","parentCustTravId":"99879","customer_traveller_id":"99879","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":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3085271","reservation_id":"93621","confirmation_number":"PB12219285189","room_confirmation_number":"PB12367257503","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":"13.56","paid_amount":"13.56","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-29 17:12:51","reservation_modified_date_time":"2020-03-29 17:12:51","customer_id":"99846","parentCustTravId":"99846","customer_traveller_id":"99846","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":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3085273","reservation_id":"93654","confirmation_number":"PB12271885486","room_confirmation_number":"PB12352066801","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":"11.30","paid_amount":"11.30","product_id":null,"service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-29 17:32:48","reservation_modified_date_time":"2020-03-29 17:32:48","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":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3085275","reservation_id":"93655","confirmation_number":"PB12295232584","room_confirmation_number":"PB12346046231","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":"13.56","paid_amount":"13.56","product_id":null,"service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-29 18:35:41","reservation_modified_date_time":"2020-03-29 18:35:41","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":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3085276","reservation_id":"93655","confirmation_number":"PB12293364583","room_confirmation_number":"PB12346046231","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":"26.75","paid_amount":"26.75","product_id":null,"service_quantity":"1","product_name":"Resort Fee Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-29 18:35:41","reservation_modified_date_time":"2020-03-29 18:35:41","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":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3085250","reservation_id":"93653","confirmation_number":"PB12211406010","room_confirmation_number":"PB12358938218","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":"20.00","paid_amount":"20.00","product_id":null,"service_quantity":"1","product_name":"Parking","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-29 14:34:34","reservation_modified_date_time":"2020-03-29 14:34:34","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":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_non_taxable":[{"room_stay_id":"3085265","reservation_id":"93626","confirmation_number":"BV12450664378","room_stay_from":"2020-03-28","room_stay_to":"2020-03-29","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.33","nightly_discount":"0.00","subtotal":"73.33","grand_total":"82.86","paid_amount":"82.86","room_type_id":"291","product_id":"1117","siteminder_id":"EXP-1659546314","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":"99852","customer_id":"99852","source_of_creation":"Expedia","reservation_created_date":"2020-03-27 20:25:06","service_canceled_date_time":"2020-03-29 15:52:32","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","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":[],"pms_taxable":[{"room_stay_id":"3085230","reservation_id":"85293","confirmation_number":"BV12412059286","room_stay_from":"2020-09-15","room_stay_to":"2020-10-01","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.00,104.00,104.00,84.00,84.00,84.00,84.00,84.00,104.00,104.00,84.00,84.00,84.00,84.00,84.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1444.00","grand_total":"1631.72","paid_amount":"100.00","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":"40114","customer_id":"40114","source_of_creation":"PMS","reservation_created_date":"2019-10-08 13:40:32","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":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3045946","reservation_id":"88064","confirmation_number":"BV12223447717","room_confirmation_number":"BV12428689124","room_stay_from":"2020-03-16","room_stay_to":"2020-03-31","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"94413","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-08 21:42:57","reservation_modified_date_time":"2019-12-08 21:42:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94413","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":"3085231","reservation_id":"85293","confirmation_number":"BV12252690227","room_confirmation_number":"BV12412059286","room_stay_from":"2020-09-15","room_stay_to":"2020-10-01","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"40114","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-08 13:40:32","reservation_modified_date_time":"2020-03-29 13:24:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"40114","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_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":[],"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":[],"pms_taxable":[{"room_stay_id":"3085232","reservation_id":"84536","confirmation_number":"BP12594124115","room_stay_from":"2020-09-15","room_stay_to":"2020-09-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.00,117.00,117.00,117.00,117.00,117.00,117.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"819.00","grand_total":"925.47","paid_amount":"132.21","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"40114","customer_id":"40114","source_of_creation":"PMS","reservation_created_date":"2019-09-22 15:56:42","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3085233","reservation_id":"84536","confirmation_number":"BP12224374781","room_confirmation_number":"BP12594124115","room_stay_from":"2020-09-15","room_stay_to":"2020-09-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"40114","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-22 15:56:42","reservation_modified_date_time":"2020-03-29 13:34:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"40114","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}