{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-04-23","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":15,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1086,1114,1113","block_room_bookings":[{"confirmation_number":"PB12287585983","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","bundle_room":"0"},{"confirmation_number":"PB12276484936","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","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":[{"room_stay_id":"3088559","reservation_id":"94042","confirmation_number":"PB12370238121","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.67,131.67","nightly_discount":"0,0","subtotal":"263.34","grand_total":"297.57","paid_amount":"297.57","room_type_id":"291","product_id":"1116","siteminder_id":"BDC-3580995562","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100321","customer_id":"100321","source_of_creation":"Booking.com","reservation_created_date":"2020-04-21 16:46:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"45.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131.67","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3088623","reservation_id":"94097","confirmation_number":"PB12382439051","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.40","nightly_discount":"0","subtotal":"111.40","grand_total":"125.88","paid_amount":"125.88","room_type_id":"287","product_id":"1090","siteminder_id":"EXP-1661683702","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":"100348","customer_id":"100348","source_of_creation":"Expedia","reservation_created_date":"2020-04-23 14:31:10","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":"111.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"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":[{"room_stay_id":"3088449","reservation_id":"93996","confirmation_number":"PB12389107116","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"291","product_id":"1117","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100236","customer_id":"100236","source_of_creation":"FE","reservation_created_date":"2020-04-19 22:21:19","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088577","reservation_id":"94100","confirmation_number":"PB12346955465","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100341","customer_id":"100341","source_of_creation":"FE","reservation_created_date":"2020-04-23 15:48:17","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088611","reservation_id":"94002","confirmation_number":"PB12340342028","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"289","product_id":"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":"100242","customer_id":"100242","source_of_creation":"FE","reservation_created_date":"2020-04-20 02:51:44","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3087480","reservation_id":"93926","confirmation_number":"PB12386187956","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"289","product_id":"1111","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100166","customer_id":"100166","source_of_creation":"PMS","reservation_created_date":"2020-04-17 22:41:50","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":"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":"3087652","reservation_id":"93948","confirmation_number":"PB12335838251","room_stay_from":"2020-04-21","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100189","customer_id":"100189","source_of_creation":"PMS","reservation_created_date":"2020-04-18 20:32:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087864","reservation_id":"93880","confirmation_number":"PB12360713618","room_stay_from":"2020-04-19","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"99.00,99.00,99.00,99.00,99.00","nightly_discount":"32.99,0.00,0.00,0.00,0.00","subtotal":"495.00","grand_total":"522.07","paid_amount":"522.07","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100117","customer_id":"100117","source_of_creation":"PMS","reservation_created_date":"2020-04-16 19:27:46","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088218","reservation_id":"93845","confirmation_number":"PB12378213181","room_stay_from":"2020-04-19","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.35,136.35,136.35,136.35,136.35","nightly_discount":"15.78,0.00,0.00,0.00,17.93","subtotal":"681.75","grand_total":"732.28","paid_amount":"732.28","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100077","customer_id":"100077","source_of_creation":"PMS","reservation_created_date":"2020-04-15 17:52:14","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136.35","currentDayDiscount":"17.93","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3088220","reservation_id":"93847","confirmation_number":"PB12381057626","room_stay_from":"2020-04-20","room_stay_to":"2020-04-24","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":"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":"100079","customer_id":"100079","source_of_creation":"PMS","reservation_created_date":"2020-04-15 17:58:53","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":"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":"3088330","reservation_id":"94061","confirmation_number":"PB12367928114","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","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":"100306","customer_id":"100306","source_of_creation":"PMS","reservation_created_date":"2020-04-21 23:27:00","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":"3088335","reservation_id":"93819","confirmation_number":"PB12358548841","room_stay_from":"2020-04-20","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"1","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":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"65363","customer_id":"65363","source_of_creation":"PMS","reservation_created_date":"2020-04-14 20:23:37","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088431","reservation_id":"94050","confirmation_number":"PB12366697035","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100293","customer_id":"100293","source_of_creation":"PMS","reservation_created_date":"2020-04-21 18:09:24","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088433","reservation_id":"94068","confirmation_number":"PB12392845211","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93599","customer_id":"93599","source_of_creation":"PMS","reservation_created_date":"2020-04-22 13:30:55","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088506","reservation_id":"94020","confirmation_number":"PB12365751689","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"99.00,99.00","nightly_discount":"5.95,5.95","subtotal":"198.00","grand_total":"210.30","paid_amount":"210.30","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":"100265","customer_id":"100265","source_of_creation":"PMS","reservation_created_date":"2020-04-20 19:59:29","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":"5.95","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3088573","reservation_id":"94078","confirmation_number":"PB12318092889","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","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":"100322","customer_id":"100322","source_of_creation":"PMS","reservation_created_date":"2020-04-22 19:14:56","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":"","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":"3088646","reservation_id":"94037","confirmation_number":"PB12350320556","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","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":"1108","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":"100282","customer_id":"100282","source_of_creation":"PMS","reservation_created_date":"2020-04-21 14:56:50","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"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":"89.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087656","reservation_id":"93950","confirmation_number":"PB12396966163","room_stay_from":"2020-04-23","room_stay_to":"2020-04-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"111.87","room_type_id":"289","product_id":"1110","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100190","customer_id":"100190","source_of_creation":"PMS","reservation_created_date":"2020-04-18 20:41:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088640","reservation_id":"94038","confirmation_number":"PB12360038159","room_stay_from":"2020-04-23","room_stay_to":"2020-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","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":"100283","customer_id":"100283","source_of_creation":"PMS","reservation_created_date":"2020-04-21 16:03:58","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":"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":"3088650","reservation_id":"94111","confirmation_number":"PB12318514239","room_stay_from":"2020-04-23","room_stay_to":"2020-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","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":"100353","customer_id":"100353","source_of_creation":"PMS","reservation_created_date":"2020-04-23 21:45:49","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088570","reservation_id":"93953","confirmation_number":"PB12392210242","room_stay_from":"2020-05-09","room_stay_to":"2020-05-10","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","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":"1107","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":"100340","customer_id":"100340","source_of_creation":"PMS","reservation_created_date":"2020-04-18 21:02:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3087262","reservation_id":"93880","confirmation_number":"PB12214337425","room_confirmation_number":"PB12360713618","room_stay_from":"2020-04-19","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"40,40,40,40,40","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"100117","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-04-16 19:27:46","reservation_modified_date_time":"2020-04-16 19:27:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100117","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":"3088331","reservation_id":"94061","confirmation_number":"PB12281410573","room_confirmation_number":"PB12367928114","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"100306","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-04-21 23:27:00","reservation_modified_date_time":"2020-04-21 23:27:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100306","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3088507","reservation_id":"94020","confirmation_number":"PB12226356898","room_confirmation_number":"PB12365751689","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100265","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-22 20:35:35","reservation_modified_date_time":"2020-04-22 20:35:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100265","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3088579","reservation_id":"94100","confirmation_number":"PB12211041007","room_confirmation_number":"PB12346955465","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"30.00","nightly_discount":"0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"100341","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-04-23 15:48:17","reservation_modified_date_time":"2020-04-23 15:48:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100341","canceled_nights_data":"","currentDayPrice":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3088612","reservation_id":"94002","confirmation_number":"PB12297362346","room_confirmation_number":"PB12340342028","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1780","service_quantity":"1","customer_traveller_id":"100242","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-04-23 18:59:31","reservation_modified_date_time":"2020-04-23 18:59:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100242","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3088648","reservation_id":"94037","confirmation_number":"PB12241400176","room_confirmation_number":"PB12350320556","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100282","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-04-23 21:37:46","reservation_modified_date_time":"2020-04-23 21:37:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100282","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3088641","reservation_id":"94038","confirmation_number":"PB12235022470","room_confirmation_number":"PB12360038159","room_stay_from":"2020-04-23","room_stay_to":"2020-04-25","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100283","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-23 20:57:24","reservation_modified_date_time":"2020-04-23 20:57:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100283","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3087481","reservation_id":"93926","confirmation_number":"PB12246776616","room_confirmation_number":"PB12386187956","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","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":"100166","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-17 22:41:50","reservation_modified_date_time":"2020-04-17 22:41:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100166","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":"3087653","reservation_id":"93948","confirmation_number":"PB12242258789","room_confirmation_number":"PB12335838251","room_stay_from":"2020-04-21","room_stay_to":"2020-04-24","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":"100189","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-18 20:32:12","reservation_modified_date_time":"2020-04-18 20:32:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100189","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":"3087865","reservation_id":"93880","confirmation_number":"PB12249837412","room_confirmation_number":"PB12360713618","room_stay_from":"2020-04-19","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"100117","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-16 19:27:46","reservation_modified_date_time":"2020-04-19 19:50:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100117","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":"3088219","reservation_id":"93845","confirmation_number":"PB12230516919","room_confirmation_number":"PB12378213181","room_stay_from":"2020-04-19","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"100077","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-15 17:52:14","reservation_modified_date_time":"2020-04-21 16:32:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100077","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":"3088221","reservation_id":"93847","confirmation_number":"PB12257808266","room_confirmation_number":"PB12381057626","room_stay_from":"2020-04-20","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100079","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-15 17:58:53","reservation_modified_date_time":"2020-04-21 16:34:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100079","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":"3088332","reservation_id":"94061","confirmation_number":"PB12254421536","room_confirmation_number":"PB12367928114","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","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":"100306","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-21 23:27:00","reservation_modified_date_time":"2020-04-21 23:27:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100306","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":"3088336","reservation_id":"93819","confirmation_number":"PB12242166701","room_confirmation_number":"PB12358548841","room_stay_from":"2020-04-20","room_stay_to":"2020-04-24","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":"65363","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-14 20:23:37","reservation_modified_date_time":"2020-04-21 23:49:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"65363","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":"3088432","reservation_id":"94050","confirmation_number":"PB12263511483","room_confirmation_number":"PB12366697035","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","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":"100293","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-21 18:09:25","reservation_modified_date_time":"2020-04-22 17:43:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100293","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":"3088434","reservation_id":"94068","confirmation_number":"PB12290537558","room_confirmation_number":"PB12392845211","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","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":"93599","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-22 13:30:55","reservation_modified_date_time":"2020-04-22 17:43:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93599","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":"3088450","reservation_id":"93996","confirmation_number":"PB12286223628","room_confirmation_number":"PB12389107116","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","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":"100236","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-19 22:21:19","reservation_modified_date_time":"2020-04-22 18:30:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100236","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":"3088508","reservation_id":"94020","confirmation_number":"PB12265209096","room_confirmation_number":"PB12365751689","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","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":"100265","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-20 19:59:29","reservation_modified_date_time":"2020-04-22 20:35:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100265","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":"3088558","reservation_id":"94042","confirmation_number":"PB12290240617","room_confirmation_number":"PB12370238121","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"100321","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-21 16:46:08","reservation_modified_date_time":"2020-04-23 15:22:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100321","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":"3088574","reservation_id":"94078","confirmation_number":"PB12246460339","room_confirmation_number":"PB12318092889","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","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":"100322","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-22 19:14:56","reservation_modified_date_time":"2020-04-23 15:44:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100322","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":"3088578","reservation_id":"94100","confirmation_number":"PB12211877067","room_confirmation_number":"PB12346955465","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","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":"100341","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-23 15:48:17","reservation_modified_date_time":"2020-04-23 15:48:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100341","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":"3088613","reservation_id":"94002","confirmation_number":"PB12267620617","room_confirmation_number":"PB12340342028","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","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":"100242","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-20 02:51:44","reservation_modified_date_time":"2020-04-23 18:59:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100242","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":"3088624","reservation_id":"94097","confirmation_number":"PB12248537510","room_confirmation_number":"PB12382439051","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"100348","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-23 14:31:10","reservation_modified_date_time":"2020-04-23 19:59:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100348","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":"3088649","reservation_id":"94037","confirmation_number":"PB12253672179","room_confirmation_number":"PB12350320556","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","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":"100282","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-21 14:56:50","reservation_modified_date_time":"2020-04-23 21:37:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100282","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":"3087657","reservation_id":"93950","confirmation_number":"PB12270926328","room_confirmation_number":"PB12396966163","room_stay_from":"2020-04-23","room_stay_to":"2020-04-25","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100190","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-18 20:41:12","reservation_modified_date_time":"2020-04-18 20:41:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100190","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":"3088642","reservation_id":"94038","confirmation_number":"PB12288859367","room_confirmation_number":"PB12360038159","room_stay_from":"2020-04-23","room_stay_to":"2020-04-25","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":"100283","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-21 16:03:58","reservation_modified_date_time":"2020-04-23 20:57:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100283","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":"3088651","reservation_id":"94111","confirmation_number":"PB12262661468","room_confirmation_number":"PB12318514239","room_stay_from":"2020-04-23","room_stay_to":"2020-04-25","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":"100353","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-23 21:45:49","reservation_modified_date_time":"2020-04-23 21:45:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100353","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":"3088569","reservation_id":"93953","confirmation_number":"PB12220249953","room_confirmation_number":"PB12392210242","room_stay_from":"2020-05-09","room_stay_to":"2020-05-10","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100340","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-18 21:02:20","reservation_modified_date_time":"2020-04-23 15:33:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100340","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":"3088597","reservation_id":"94100","confirmation_number":"PB12277543101","room_confirmation_number":"PB12346955465","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"22.12","grand_total":"25.00","paid_amount":"25.00","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-23 17:44:57","reservation_modified_date_time":"2020-04-23 17:44:57","customer_id":"100341","parentCustTravId":"100341","customer_traveller_id":"100341","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":"22.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3088598","reservation_id":"94100","confirmation_number":"PB12238035119","room_confirmation_number":"PB12346955465","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.67","grand_total":"5.00","paid_amount":"5.00","product_id":"1175","service_quantity":"1","product_name":"Miscellaneous","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-23 18:06:39","reservation_modified_date_time":"2020-04-23 18:06:39","customer_id":"100341","parentCustTravId":"100341","customer_traveller_id":"100341","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":"4.67","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3088587","reservation_id":"94104","confirmation_number":"PB12232370742","room_confirmation_number":"PB12349746563","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-04-23 16:44:36","reservation_modified_date_time":"2020-04-23 16:44:36","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"}]},{"room_stay_id":"3088626","reservation_id":"94108","confirmation_number":"PB12249668632","room_confirmation_number":"PB12387131945","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.74","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"Koolies","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-23 20:20:29","reservation_modified_date_time":"2020-04-23 20:20:29","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":"3.74","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3088627","reservation_id":"94108","confirmation_number":"PB12226374763","room_confirmation_number":"PB12387131945","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":null,"service_quantity":"1","product_name":"Hat\/Visor - 1 Hat\/Visor","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-23 20:20:29","reservation_modified_date_time":"2020-04-23 20:20:29","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":"11.21","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":"3088557","reservation_id":"94083","confirmation_number":"PB12229854209","room_confirmation_number":"PB12311345365","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"200.00","grand_total":"200.00","paid_amount":"200.00","product_id":"1196","service_quantity":"1","product_name":"Smoking Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-23 14:56:45","reservation_modified_date_time":"2020-04-23 14:56:45","customer_id":"100327","parentCustTravId":"100327","customer_traveller_id":"100327","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":"200.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3088585","reservation_id":"94103","confirmation_number":"PB12264059053","room_confirmation_number":"PB12354484332","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":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-23 16:30:22","reservation_modified_date_time":"2020-04-23 16:30:22","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":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":15,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1086,1114,1113","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12287585983","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","bundle_room":"0"},{"confirmation_number":"PB12276484936","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","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":[{"room_stay_id":"3088559","reservation_id":"94042","confirmation_number":"PB12370238121","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.67,131.67","nightly_discount":"0,0","subtotal":"263.34","grand_total":"297.57","paid_amount":"297.57","room_type_id":"291","product_id":"1116","siteminder_id":"BDC-3580995562","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100321","customer_id":"100321","source_of_creation":"Booking.com","reservation_created_date":"2020-04-21 16:46:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"45.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131.67","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3088623","reservation_id":"94097","confirmation_number":"PB12382439051","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.40","nightly_discount":"0","subtotal":"111.40","grand_total":"125.88","paid_amount":"125.88","room_type_id":"287","product_id":"1090","siteminder_id":"EXP-1661683702","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":"100348","customer_id":"100348","source_of_creation":"Expedia","reservation_created_date":"2020-04-23 14:31:10","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":"111.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"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":[{"room_stay_id":"3088449","reservation_id":"93996","confirmation_number":"PB12389107116","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"291","product_id":"1117","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100236","customer_id":"100236","source_of_creation":"FE","reservation_created_date":"2020-04-19 22:21:19","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088577","reservation_id":"94100","confirmation_number":"PB12346955465","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100341","customer_id":"100341","source_of_creation":"FE","reservation_created_date":"2020-04-23 15:48:17","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088611","reservation_id":"94002","confirmation_number":"PB12340342028","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"289","product_id":"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":"100242","customer_id":"100242","source_of_creation":"FE","reservation_created_date":"2020-04-20 02:51:44","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3087480","reservation_id":"93926","confirmation_number":"PB12386187956","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"289","product_id":"1111","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100166","customer_id":"100166","source_of_creation":"PMS","reservation_created_date":"2020-04-17 22:41:50","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":"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":"3087652","reservation_id":"93948","confirmation_number":"PB12335838251","room_stay_from":"2020-04-21","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100189","customer_id":"100189","source_of_creation":"PMS","reservation_created_date":"2020-04-18 20:32:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087864","reservation_id":"93880","confirmation_number":"PB12360713618","room_stay_from":"2020-04-19","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"99.00,99.00,99.00,99.00,99.00","nightly_discount":"32.99,0.00,0.00,0.00,0.00","subtotal":"495.00","grand_total":"522.07","paid_amount":"522.07","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100117","customer_id":"100117","source_of_creation":"PMS","reservation_created_date":"2020-04-16 19:27:46","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088218","reservation_id":"93845","confirmation_number":"PB12378213181","room_stay_from":"2020-04-19","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.35,136.35,136.35,136.35,136.35","nightly_discount":"15.78,0.00,0.00,0.00,17.93","subtotal":"681.75","grand_total":"732.28","paid_amount":"732.28","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100077","customer_id":"100077","source_of_creation":"PMS","reservation_created_date":"2020-04-15 17:52:14","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136.35","currentDayDiscount":"17.93","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3088220","reservation_id":"93847","confirmation_number":"PB12381057626","room_stay_from":"2020-04-20","room_stay_to":"2020-04-24","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":"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":"100079","customer_id":"100079","source_of_creation":"PMS","reservation_created_date":"2020-04-15 17:58:53","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":"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":"3088330","reservation_id":"94061","confirmation_number":"PB12367928114","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","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":"100306","customer_id":"100306","source_of_creation":"PMS","reservation_created_date":"2020-04-21 23:27:00","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":"3088335","reservation_id":"93819","confirmation_number":"PB12358548841","room_stay_from":"2020-04-20","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"1","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":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"65363","customer_id":"65363","source_of_creation":"PMS","reservation_created_date":"2020-04-14 20:23:37","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088431","reservation_id":"94050","confirmation_number":"PB12366697035","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100293","customer_id":"100293","source_of_creation":"PMS","reservation_created_date":"2020-04-21 18:09:24","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088433","reservation_id":"94068","confirmation_number":"PB12392845211","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93599","customer_id":"93599","source_of_creation":"PMS","reservation_created_date":"2020-04-22 13:30:55","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088506","reservation_id":"94020","confirmation_number":"PB12365751689","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"99.00,99.00","nightly_discount":"5.95,5.95","subtotal":"198.00","grand_total":"210.30","paid_amount":"210.30","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":"100265","customer_id":"100265","source_of_creation":"PMS","reservation_created_date":"2020-04-20 19:59:29","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":"5.95","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3088573","reservation_id":"94078","confirmation_number":"PB12318092889","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","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":"100322","customer_id":"100322","source_of_creation":"PMS","reservation_created_date":"2020-04-22 19:14:56","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":"","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":"3088646","reservation_id":"94037","confirmation_number":"PB12350320556","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","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":"1108","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":"100282","customer_id":"100282","source_of_creation":"PMS","reservation_created_date":"2020-04-21 14:56:50","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"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":"89.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3087656","reservation_id":"93950","confirmation_number":"PB12396966163","room_stay_from":"2020-04-23","room_stay_to":"2020-04-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"111.87","room_type_id":"289","product_id":"1110","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100190","customer_id":"100190","source_of_creation":"PMS","reservation_created_date":"2020-04-18 20:41:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088640","reservation_id":"94038","confirmation_number":"PB12360038159","room_stay_from":"2020-04-23","room_stay_to":"2020-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","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":"100283","customer_id":"100283","source_of_creation":"PMS","reservation_created_date":"2020-04-21 16:03:58","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":"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":"3088650","reservation_id":"94111","confirmation_number":"PB12318514239","room_stay_from":"2020-04-23","room_stay_to":"2020-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","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":"100353","customer_id":"100353","source_of_creation":"PMS","reservation_created_date":"2020-04-23 21:45:49","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3088570","reservation_id":"93953","confirmation_number":"PB12392210242","room_stay_from":"2020-05-09","room_stay_to":"2020-05-10","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","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":"1107","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":"100340","customer_id":"100340","source_of_creation":"PMS","reservation_created_date":"2020-04-18 21:02:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3087262","reservation_id":"93880","confirmation_number":"PB12214337425","room_confirmation_number":"PB12360713618","room_stay_from":"2020-04-19","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"40,40,40,40,40","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"100117","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-04-16 19:27:46","reservation_modified_date_time":"2020-04-16 19:27:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100117","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":"3088331","reservation_id":"94061","confirmation_number":"PB12281410573","room_confirmation_number":"PB12367928114","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"100306","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-04-21 23:27:00","reservation_modified_date_time":"2020-04-21 23:27:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100306","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3088507","reservation_id":"94020","confirmation_number":"PB12226356898","room_confirmation_number":"PB12365751689","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100265","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-22 20:35:35","reservation_modified_date_time":"2020-04-22 20:35:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100265","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3088579","reservation_id":"94100","confirmation_number":"PB12211041007","room_confirmation_number":"PB12346955465","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"30.00","nightly_discount":"0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"100341","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-04-23 15:48:17","reservation_modified_date_time":"2020-04-23 15:48:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100341","canceled_nights_data":"","currentDayPrice":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3088612","reservation_id":"94002","confirmation_number":"PB12297362346","room_confirmation_number":"PB12340342028","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1780","service_quantity":"1","customer_traveller_id":"100242","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-04-23 18:59:31","reservation_modified_date_time":"2020-04-23 18:59:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100242","canceled_nights_data":"","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3088648","reservation_id":"94037","confirmation_number":"PB12241400176","room_confirmation_number":"PB12350320556","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100282","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-04-23 21:37:46","reservation_modified_date_time":"2020-04-23 21:37:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100282","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3088641","reservation_id":"94038","confirmation_number":"PB12235022470","room_confirmation_number":"PB12360038159","room_stay_from":"2020-04-23","room_stay_to":"2020-04-25","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100283","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-23 20:57:24","reservation_modified_date_time":"2020-04-23 20:57:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100283","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3087481","reservation_id":"93926","confirmation_number":"PB12246776616","room_confirmation_number":"PB12386187956","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","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":"100166","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-17 22:41:50","reservation_modified_date_time":"2020-04-17 22:41:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100166","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":"3087653","reservation_id":"93948","confirmation_number":"PB12242258789","room_confirmation_number":"PB12335838251","room_stay_from":"2020-04-21","room_stay_to":"2020-04-24","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":"100189","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-18 20:32:12","reservation_modified_date_time":"2020-04-18 20:32:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100189","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":"3087865","reservation_id":"93880","confirmation_number":"PB12249837412","room_confirmation_number":"PB12360713618","room_stay_from":"2020-04-19","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"100117","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-16 19:27:46","reservation_modified_date_time":"2020-04-19 19:50:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100117","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":"3088219","reservation_id":"93845","confirmation_number":"PB12230516919","room_confirmation_number":"PB12378213181","room_stay_from":"2020-04-19","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"100077","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-15 17:52:14","reservation_modified_date_time":"2020-04-21 16:32:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100077","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":"3088221","reservation_id":"93847","confirmation_number":"PB12257808266","room_confirmation_number":"PB12381057626","room_stay_from":"2020-04-20","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100079","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-15 17:58:53","reservation_modified_date_time":"2020-04-21 16:34:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100079","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":"3088332","reservation_id":"94061","confirmation_number":"PB12254421536","room_confirmation_number":"PB12367928114","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","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":"100306","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-21 23:27:00","reservation_modified_date_time":"2020-04-21 23:27:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100306","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":"3088336","reservation_id":"93819","confirmation_number":"PB12242166701","room_confirmation_number":"PB12358548841","room_stay_from":"2020-04-20","room_stay_to":"2020-04-24","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":"65363","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-14 20:23:37","reservation_modified_date_time":"2020-04-21 23:49:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"65363","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":"3088432","reservation_id":"94050","confirmation_number":"PB12263511483","room_confirmation_number":"PB12366697035","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","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":"100293","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-21 18:09:25","reservation_modified_date_time":"2020-04-22 17:43:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100293","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":"3088434","reservation_id":"94068","confirmation_number":"PB12290537558","room_confirmation_number":"PB12392845211","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","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":"93599","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-22 13:30:55","reservation_modified_date_time":"2020-04-22 17:43:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93599","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":"3088450","reservation_id":"93996","confirmation_number":"PB12286223628","room_confirmation_number":"PB12389107116","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","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":"100236","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-19 22:21:19","reservation_modified_date_time":"2020-04-22 18:30:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100236","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":"3088508","reservation_id":"94020","confirmation_number":"PB12265209096","room_confirmation_number":"PB12365751689","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","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":"100265","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-20 19:59:29","reservation_modified_date_time":"2020-04-22 20:35:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100265","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":"3088558","reservation_id":"94042","confirmation_number":"PB12290240617","room_confirmation_number":"PB12370238121","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"100321","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-21 16:46:08","reservation_modified_date_time":"2020-04-23 15:22:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100321","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":"3088574","reservation_id":"94078","confirmation_number":"PB12246460339","room_confirmation_number":"PB12318092889","room_stay_from":"2020-04-22","room_stay_to":"2020-04-24","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":"100322","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-22 19:14:56","reservation_modified_date_time":"2020-04-23 15:44:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100322","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":"3088578","reservation_id":"94100","confirmation_number":"PB12211877067","room_confirmation_number":"PB12346955465","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","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":"100341","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-23 15:48:17","reservation_modified_date_time":"2020-04-23 15:48:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100341","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":"3088613","reservation_id":"94002","confirmation_number":"PB12267620617","room_confirmation_number":"PB12340342028","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","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":"100242","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-20 02:51:44","reservation_modified_date_time":"2020-04-23 18:59:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100242","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":"3088624","reservation_id":"94097","confirmation_number":"PB12248537510","room_confirmation_number":"PB12382439051","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"100348","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-23 14:31:10","reservation_modified_date_time":"2020-04-23 19:59:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100348","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":"3088649","reservation_id":"94037","confirmation_number":"PB12253672179","room_confirmation_number":"PB12350320556","room_stay_from":"2020-04-23","room_stay_to":"2020-04-24","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":"100282","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-21 14:56:50","reservation_modified_date_time":"2020-04-23 21:37:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100282","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":"3087657","reservation_id":"93950","confirmation_number":"PB12270926328","room_confirmation_number":"PB12396966163","room_stay_from":"2020-04-23","room_stay_to":"2020-04-25","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100190","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-18 20:41:12","reservation_modified_date_time":"2020-04-18 20:41:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100190","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":"3088642","reservation_id":"94038","confirmation_number":"PB12288859367","room_confirmation_number":"PB12360038159","room_stay_from":"2020-04-23","room_stay_to":"2020-04-25","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":"100283","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-21 16:03:58","reservation_modified_date_time":"2020-04-23 20:57:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100283","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":"3088651","reservation_id":"94111","confirmation_number":"PB12262661468","room_confirmation_number":"PB12318514239","room_stay_from":"2020-04-23","room_stay_to":"2020-04-25","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":"100353","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-23 21:45:49","reservation_modified_date_time":"2020-04-23 21:45:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100353","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":"3088569","reservation_id":"93953","confirmation_number":"PB12220249953","room_confirmation_number":"PB12392210242","room_stay_from":"2020-05-09","room_stay_to":"2020-05-10","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100340","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-18 21:02:20","reservation_modified_date_time":"2020-04-23 15:33:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100340","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":"3088597","reservation_id":"94100","confirmation_number":"PB12277543101","room_confirmation_number":"PB12346955465","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"22.12","grand_total":"25.00","paid_amount":"25.00","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-23 17:44:57","reservation_modified_date_time":"2020-04-23 17:44:57","customer_id":"100341","parentCustTravId":"100341","customer_traveller_id":"100341","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":"22.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3088598","reservation_id":"94100","confirmation_number":"PB12238035119","room_confirmation_number":"PB12346955465","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.67","grand_total":"5.00","paid_amount":"5.00","product_id":"1175","service_quantity":"1","product_name":"Miscellaneous","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-23 18:06:39","reservation_modified_date_time":"2020-04-23 18:06:39","customer_id":"100341","parentCustTravId":"100341","customer_traveller_id":"100341","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":"4.67","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3088587","reservation_id":"94104","confirmation_number":"PB12232370742","room_confirmation_number":"PB12349746563","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-04-23 16:44:36","reservation_modified_date_time":"2020-04-23 16:44:36","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"}]},{"room_stay_id":"3088626","reservation_id":"94108","confirmation_number":"PB12249668632","room_confirmation_number":"PB12387131945","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.74","grand_total":"4.00","paid_amount":"4.00","product_id":null,"service_quantity":"1","product_name":"Koolies","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-23 20:20:29","reservation_modified_date_time":"2020-04-23 20:20:29","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":"3.74","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3088627","reservation_id":"94108","confirmation_number":"PB12226374763","room_confirmation_number":"PB12387131945","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":null,"service_quantity":"1","product_name":"Hat\/Visor - 1 Hat\/Visor","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-23 20:20:29","reservation_modified_date_time":"2020-04-23 20:20:29","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":"11.21","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":"3088557","reservation_id":"94083","confirmation_number":"PB12229854209","room_confirmation_number":"PB12311345365","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"200.00","grand_total":"200.00","paid_amount":"200.00","product_id":"1196","service_quantity":"1","product_name":"Smoking Fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-23 14:56:45","reservation_modified_date_time":"2020-04-23 14:56:45","customer_id":"100327","parentCustTravId":"100327","customer_traveller_id":"100327","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":"200.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3088585","reservation_id":"94103","confirmation_number":"PB12264059053","room_confirmation_number":"PB12354484332","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":"10.00","paid_amount":"10.00","product_id":null,"service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-23 16:30:22","reservation_modified_date_time":"2020-04-23 16:30:22","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":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_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":[],"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":[],"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":[],"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":[],"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":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}