{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-09-15","total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":3,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1098,1123,1096","block_room_bookings":[{"confirmation_number":"PB12249081550","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","bundle_room":"0"},{"confirmation_number":"PB12239774114","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","bundle_room":"0"},{"confirmation_number":"PB12243464711","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","bundle_room":"0"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3136698","reservation_id":"99830","confirmation_number":"PB12354334478","room_stay_from":"2020-09-09","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.28,117.28,150.57,150.57,117.28,117.28,117.28","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"887.54","grand_total":"1002.92","paid_amount":"1002.92","room_type_id":"289","product_id":"1097","siteminder_id":"BDC-2555371487","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":"106190","customer_id":"106190","source_of_creation":"Booking.com","reservation_created_date":"2020-09-01 21:32:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"154.13","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.28","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3133829","reservation_id":"99955","confirmation_number":"BP12557110663","room_stay_from":"2020-09-15","room_stay_to":"2020-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.64,76.64","nightly_discount":"0,0","subtotal":"153.28","grand_total":"173.21","paid_amount":"173.21","room_type_id":"298","product_id":"1133","siteminder_id":"BDC-3783489262","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":"105957","customer_id":"105957","source_of_creation":"Booking.com","reservation_created_date":"2020-09-04 01:14:10","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"34.79","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"76.64","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":"3137042","reservation_id":"100369","confirmation_number":"PB12328340770","room_stay_from":"2020-09-14","room_stay_to":"2020-09-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.64,143.64,143.64,143.64,188.37,188.37","nightly_discount":"0,0,0,0,0,0","subtotal":"951.30","grand_total":"1074.97","paid_amount":"1074.97","room_type_id":"289","product_id":"1121","siteminder_id":"BDC-3027406408","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":"106422","customer_id":"106422","source_of_creation":"Booking.com","reservation_created_date":"2020-09-14 14:27:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"160.69","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.64","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":"3137150","reservation_id":"100118","confirmation_number":"PB12340275322","room_stay_from":"2020-09-26","room_stay_to":"2020-09-27","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.36","nightly_discount":"0","subtotal":"171.36","grand_total":"193.64","paid_amount":"193.64","room_type_id":"291","product_id":"1114","siteminder_id":"BDC-3132257658","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":"106139","customer_id":"106139","source_of_creation":"Booking.com","reservation_created_date":"2020-09-08 00:10:07","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"28.70","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3137176","reservation_id":"100006","confirmation_number":"PB12372083261","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"130.25","nightly_discount":"0","subtotal":"130.25","grand_total":"147.19","paid_amount":"147.19","room_type_id":"291","product_id":"1118","siteminder_id":"EXP-1696154610","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106444","customer_id":"106444","source_of_creation":"Expedia","reservation_created_date":"2020-09-05 13:11:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.25","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":"3137314","reservation_id":"100428","confirmation_number":"PB12373182359","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"88.70","nightly_discount":"0","subtotal":"88.70","grand_total":"100.23","paid_amount":"100.23","room_type_id":"289","product_id":"1095","siteminder_id":"EXP-1699319665","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":"106458","customer_id":"106458","source_of_creation":"Expedia","reservation_created_date":"2020-09-15 23:21:12","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":"88.70","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":"3137044","reservation_id":"100176","confirmation_number":"PB12319248880","room_stay_from":"2020-09-14","room_stay_to":"2020-09-18","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"109.19,101.67,109.19,109.19","nightly_discount":"0,0,0,0","subtotal":"429.24","grand_total":"485.04","paid_amount":"485.04","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1697436745","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":"106423","customer_id":"106423","source_of_creation":"Expedia","reservation_created_date":"2020-09-09 18:46:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"101.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"}]}],"exp_non_taxable":[{"room_stay_id":"3137205","reservation_id":"93866","confirmation_number":"BP12544036081","room_stay_from":"2020-09-11","room_stay_to":"2020-09-16","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"79.26,79.26,70.40,70.40,70.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"369.72","grand_total":"417.78","paid_amount":"417.78","room_type_id":"315","product_id":"1230","siteminder_id":"EXP-1661046935","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":"100102","customer_id":"100102","source_of_creation":"Expedia","reservation_created_date":"2020-04-16 03:41:07","service_canceled_date_time":"2020-09-15 19:00:53","canceled_nights_data":"","product_name":"BP Walk","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"","total_paid_amount":"417.78","deltaChange":"79.55","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[{"room_stay_id":"3137083","reservation_id":"100362","confirmation_number":"BV12425321856","room_stay_from":"2020-09-14","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.89,53.89","nightly_discount":"0,0","subtotal":"107.78","grand_total":"121.79","paid_amount":"121.79","room_type_id":"285","product_id":"1084","siteminder_id":"HTN-138294682-HZM6WA","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":"106428","customer_id":"106428","source_of_creation":"HotelTonight","reservation_created_date":"2020-09-14 07:02:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"53.89","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"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":[{"room_stay_id":"3131841","reservation_id":"93677","confirmation_number":"PB12362306518","room_stay_from":"2020-09-12","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"223.30,205.30,205.30,205.30,205.30,205.30,223.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1473.10","grand_total":"1664.61","paid_amount":"1664.61","room_type_id":"287","product_id":"1089","siteminder_id":"GCC-0004600044-064","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"70.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99904","customer_id":"99904","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-04-01 16:37:10","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"205.30","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"}]}],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3137161","reservation_id":"100401","confirmation_number":"PB12382755348","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"95.49","nightly_discount":"0","subtotal":"95.49","grand_total":"107.90","paid_amount":"107.90","room_type_id":"289","product_id":"1094","siteminder_id":"AGO-342717114","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106442","customer_id":"106442","source_of_creation":"Agoda","reservation_created_date":"2020-09-15 15:07:10","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":"95.49","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":"3136730","reservation_id":"99214","confirmation_number":"BV12434320906","room_stay_from":"2020-09-13","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.06,122.06,122.06,122.06,122.06,132.14","nightly_discount":"0,0,0,0,0,0","subtotal":"742.44","grand_total":"838.96","paid_amount":"838.96","room_type_id":"305","product_id":"1222","siteminder_id":"AGO-336933654","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":"106388","customer_id":"106388","source_of_creation":"Agoda","reservation_created_date":"2020-08-18 19:55:08","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"122.06","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"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3136378","reservation_id":"100300","confirmation_number":"PB12316144405","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00","nightly_discount":"0.00","subtotal":"119.00","grand_total":"134.47","paid_amount":"134.47","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":"106331","customer_id":"106331","source_of_creation":"FE","reservation_created_date":"2020-09-12 13:26:40","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":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3127509","reservation_id":"99153","confirmation_number":"PB12327869329","room_stay_from":"2020-09-13","room_stay_to":"2020-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00,149.00,149.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"596.00","grand_total":"673.48","paid_amount":"673.48","room_type_id":"286","product_id":"1086","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":"62914","customer_id":"62914","source_of_creation":"FE","reservation_created_date":"2020-08-17 00:51:07","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135569","reservation_id":"100182","confirmation_number":"BP12521107635","room_stay_from":"2020-09-14","room_stay_to":"2020-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"124.10,124.10,124.10","nightly_discount":"0.00,0.00,0.00","subtotal":"372.30","grand_total":"420.70","paid_amount":"420.70","room_type_id":"302","product_id":"1138","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":"106204","customer_id":"106204","source_of_creation":"FE","reservation_created_date":"2020-09-09 20:44:40","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137309","reservation_id":"100301","confirmation_number":"BP12524574314","room_stay_from":"2020-09-15","room_stay_to":"2020-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"85.85,85.85","nightly_discount":"0.00,0.00","subtotal":"171.70","grand_total":"194.02","paid_amount":"194.02","room_type_id":"294","product_id":"1125","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"FE","reservation_created_date":"2020-09-12 13:29:15","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 803","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3132458","reservation_id":"99771","confirmation_number":"PB12371974226","room_stay_from":"2020-09-13","room_stay_to":"2020-09-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.50,110.50,110.50,110.50,110.50","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"552.50","grand_total":"624.33","paid_amount":"624.33","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92748","customer_id":"92748","source_of_creation":"FE","reservation_created_date":"2020-08-31 02:02:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3100527","reservation_id":"95846","confirmation_number":"BV12449936219","room_stay_from":"2020-09-11","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,84.00,84.00,84.00,84.00,84.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"732.00","grand_total":"827.16","paid_amount":"827.16","room_type_id":"303","product_id":"1139","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":"102003","customer_id":"102003","source_of_creation":"FE","reservation_created_date":"2020-06-03 11:24:53","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3137188","reservation_id":"100405","confirmation_number":"PB12384370472","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.40","nightly_discount":"0.00","subtotal":"107.40","grand_total":"121.36","paid_amount":"121.36","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":"100147","customer_id":"100147","source_of_creation":"PMS","reservation_created_date":"2020-09-15 17:37:18","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"107.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":"3126914","reservation_id":"84470","confirmation_number":"PB12391110580","room_stay_from":"2020-09-14","room_stay_to":"2020-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00,149.00","nightly_discount":"0.00,0.00,0.00","subtotal":"447.00","grand_total":"505.11","paid_amount":"505.11","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":"62692","customer_id":"62692","source_of_creation":"PMS","reservation_created_date":"2019-09-21 13:31:34","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":"149.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137311","reservation_id":"99920","confirmation_number":"PB12362919222","room_stay_from":"2020-09-15","room_stay_to":"2020-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"98.00,98.00","nightly_discount":"0.00,0.00","subtotal":"196.00","grand_total":"221.48","paid_amount":"221.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":"105920","customer_id":"105920","source_of_creation":"PMS","reservation_created_date":"2020-09-03 15:09:20","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":"98.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135151","reservation_id":"100103","confirmation_number":"PB12341391734","room_stay_from":"2020-09-15","room_stay_to":"2020-09-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"170.85,170.85,170.85","nightly_discount":"0.00,0.00,0.00","subtotal":"512.55","grand_total":"579.18","paid_amount":"579.18","room_type_id":"287","product_id":"1090","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106123","customer_id":"106123","source_of_creation":"PMS","reservation_created_date":"2020-09-07 16:44:09","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":"170.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3136504","reservation_id":"93706","confirmation_number":"PB12353867011","room_stay_from":"2020-09-12","room_stay_to":"2020-09-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"221.00,201.00,201.00,201.00,201.00,201.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,55.85","subtotal":"1226.00","grand_total":"1322.27","paid_amount":"1322.27","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":"51452","customer_id":"51452","source_of_creation":"PMS","reservation_created_date":"2020-04-05 17:41:49","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":"201.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3130498","reservation_id":"99545","confirmation_number":"BV12427751184","room_stay_from":"2020-09-12","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.00,137.70,137.70,137.70,137.70,137.70,137.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"962.50","grand_total":"1087.63","paid_amount":"1087.63","room_type_id":"306","product_id":"1223","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":"35292","customer_id":"35292","source_of_creation":"PMS","reservation_created_date":"2020-08-26 13:16:39","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3132762","reservation_id":"99787","confirmation_number":"PB12343689347","room_stay_from":"2020-09-12","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,102.00,102.00,102.00,102.00,102.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"790.00","grand_total":"892.70","paid_amount":"892.70","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":"105797","customer_id":"105797","source_of_creation":"PMS","reservation_created_date":"2020-08-31 17:02:10","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":"102.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3133614","reservation_id":"99915","confirmation_number":"PB12374663251","room_stay_from":"2020-09-14","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.65,126.65,126.65,126.65,169.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"675.60","grand_total":"763.43","paid_amount":"763.43","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":"48776","customer_id":"48776","source_of_creation":"PMS","reservation_created_date":"2020-09-03 13:05:09","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":"126.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137154","reservation_id":"93716","confirmation_number":"BP12512849390","room_stay_from":"2020-09-15","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"100.00,100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00,17.40","subtotal":"400.00","grand_total":"432.34","paid_amount":"432.34","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"40114","customer_id":"40114","source_of_creation":"PMS","reservation_created_date":"2020-04-07 14:25:13","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137177","reservation_id":"98969","confirmation_number":"BV12452891699","room_stay_from":"2020-09-15","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.00,143.00,163.00,163.00","nightly_discount":"0.00,0.00,0.00,25.85","subtotal":"612.00","grand_total":"662.35","paid_amount":"662.35","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76358","customer_id":"76358","source_of_creation":"PMS","reservation_created_date":"2020-08-13 13:01:46","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137202","reservation_id":"94488","confirmation_number":"PB12317311697","room_stay_from":"2020-09-11","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,140.00,102.00,102.00,102.00,102.00,102.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"930.00","grand_total":"1050.90","paid_amount":"1050.90","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":"58691","customer_id":"58691","source_of_creation":"PMS","reservation_created_date":"2020-05-06 13:26:46","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":"102.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3136558","reservation_id":"96977","confirmation_number":"BP12583097812","room_stay_from":"2020-09-12","room_stay_to":"2020-09-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.00,135.00,135.00,135.00,135.00,135.00,155.00,155.00","nightly_discount":"0.00,50.40,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1140.00","grand_total":"1231.25","paid_amount":"1231.25","room_type_id":"296","product_id":"1130","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"36083","customer_id":"36083","source_of_creation":"PMS","reservation_created_date":"2020-06-23 12:52:04","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 804","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"135.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3136269","reservation_id":"99792","confirmation_number":"BV12429363981","room_stay_from":"2020-09-12","room_stay_to":"2020-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"152.00,112.20,112.20,112.20,112.20,112.20,152.00,152.00,112.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1129.20","grand_total":"1275.99","paid_amount":"1275.99","room_type_id":"308","product_id":"1225","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":"105802","customer_id":"105802","source_of_creation":"PMS","reservation_created_date":"2020-08-31 19:15:40","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"112.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":"3136713","reservation_id":"90974","confirmation_number":"PB12393692969","room_stay_from":"2020-09-14","room_stay_to":"2020-09-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.00,166.00,166.00,166.00,206.00,206.00,166.00,166.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1408.00","grand_total":"1591.04","paid_amount":"1591.04","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":"97066","customer_id":"97066","source_of_creation":"PMS","reservation_created_date":"2020-01-30 21:56:31","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"166.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3136838","reservation_id":"90946","confirmation_number":"BV12452870424","room_stay_from":"2020-09-13","room_stay_to":"2020-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.00,128.00,128.00,128.00,128.00,152.00,152.00,128.00,128.00,128.00,128.00,128.00,152.00,152.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,97.00","subtotal":"1888.00","grand_total":"2023.83","paid_amount":"2023.83","room_type_id":"304","product_id":"1219","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":"23128","customer_id":"23128","source_of_creation":"PMS","reservation_created_date":"2020-01-30 17:19:00","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"128.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3136840","reservation_id":"90946","confirmation_number":"BV12471809932","room_stay_from":"2020-09-13","room_stay_to":"2020-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.00,128.00,128.00,128.00,128.00,152.00,152.00,128.00,128.00,128.00,128.00,128.00,152.00,152.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,97.00","subtotal":"1888.00","grand_total":"2023.83","paid_amount":"2023.83","room_type_id":"304","product_id":"1218","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":"23128","customer_id":"23128","source_of_creation":"PMS","reservation_created_date":"2020-01-30 17:19:00","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"128.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137156","reservation_id":"85293","confirmation_number":"BV12412059286","room_stay_from":"2020-09-15","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.00,104.00,104.00,84.00,84.00,84.00,84.00,84.00,104.00,104.00,84.00,84.00,84.00,84.00,84.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,50.07","subtotal":"1444.00","grand_total":"1575.15","paid_amount":"1575.15","room_type_id":"303","product_id":"1140","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"40114","customer_id":"40114","source_of_creation":"PMS","reservation_created_date":"2019-10-08 13:40:32","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137127","reservation_id":"95335","confirmation_number":"PB12397005569","room_stay_from":"2020-11-12","room_stay_to":"2020-11-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,165.00,165.00","nightly_discount":"0.00,0.00,0.00","subtotal":"460.00","grand_total":"519.80","paid_amount":"146.90","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101524","customer_id":"101524","source_of_creation":"PMS","reservation_created_date":"2020-05-24 15:38:04","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137192","reservation_id":"92660","confirmation_number":"BP12518161313","room_stay_from":"2021-02-22","room_stay_to":"2021-02-27","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.20,199.20,199.20,199.20,199.20","nightly_discount":"0.00,0.00,0.00,0,0","subtotal":"996.00","grand_total":"1125.48","paid_amount":"193.91","room_type_id":"308","product_id":"1225","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":"68651","customer_id":"68651","source_of_creation":"PMS","reservation_created_date":"2020-02-27 16:12:12","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137207","reservation_id":"100110","confirmation_number":"BV12493466021","room_stay_from":"2020-09-24","room_stay_to":"2020-09-27","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"121.55,163.00,163.00","nightly_discount":"0.00,0.00,0.00","subtotal":"447.55","grand_total":"505.73","paid_amount":"137.35","room_type_id":"304","product_id":"1220","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106130","customer_id":"106130","source_of_creation":"PMS","reservation_created_date":"2020-09-07 18:20:46","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3137159","reservation_id":"100401","confirmation_number":"PB12228273066","room_confirmation_number":"PB12382755348","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"106442","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-09-15 15:07:10","reservation_modified_date_time":"2020-09-15 16:56:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106442","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","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":"3137172","reservation_id":"100006","confirmation_number":"PB12296453712","room_confirmation_number":"PB12372083261","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"106444","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-09-06 13:24:39","reservation_modified_date_time":"2020-09-15 17:11:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106444","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","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":"3135571","reservation_id":"100182","confirmation_number":"BP12228512238","room_confirmation_number":"BP12521107635","room_stay_from":"2020-09-14","room_stay_to":"2020-09-17","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"106204","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-09-09 20:44:40","reservation_modified_date_time":"2020-09-09 20:44:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106204","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3131842","reservation_id":"93677","confirmation_number":"PB12298692494","room_confirmation_number":"PB12362306518","room_stay_from":"2020-09-12","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"99904","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-08-29 13:07:10","reservation_modified_date_time":"2020-08-29 13:07:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99904","canceled_nights_data":"","posAmt_airbnb_taxpaid":"70.00","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3136379","reservation_id":"100300","confirmation_number":"PB12234434500","room_confirmation_number":"PB12316144405","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"106331","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-12 13:26:40","reservation_modified_date_time":"2020-09-12 13:26:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106331","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3136699","reservation_id":"99830","confirmation_number":"PB12239199340","room_confirmation_number":"PB12354334478","room_stay_from":"2020-09-09","room_stay_to":"2020-09-16","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"106190","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-01 21:32:08","reservation_modified_date_time":"2020-09-13 16:52:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106190","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3137081","reservation_id":"100362","confirmation_number":"BV12224180650","room_confirmation_number":"BV12425321856","room_stay_from":"2020-09-14","room_stay_to":"2020-09-16","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":"106428","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-14 07:02:11","reservation_modified_date_time":"2020-09-14 22:51:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106428","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3137160","reservation_id":"100401","confirmation_number":"PB12276946568","room_confirmation_number":"PB12382755348","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","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":"106442","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-15 15:07:10","reservation_modified_date_time":"2020-09-15 16:56:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106442","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","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":"3137173","reservation_id":"100006","confirmation_number":"PB12224442986","room_confirmation_number":"PB12372083261","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","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":"106444","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-05 13:11:08","reservation_modified_date_time":"2020-09-15 17:11:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106444","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","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":"3137187","reservation_id":"100405","confirmation_number":"PB12226807310","room_confirmation_number":"PB12384370472","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"100147","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-15 17:37:18","reservation_modified_date_time":"2020-09-15 17:39:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100147","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137313","reservation_id":"100428","confirmation_number":"PB12248773999","room_confirmation_number":"PB12373182359","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","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":"106458","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-15 23:21:12","reservation_modified_date_time":"2020-09-16 01:06:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106458","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3126915","reservation_id":"84470","confirmation_number":"PB12285254863","room_confirmation_number":"PB12391110580","room_stay_from":"2020-09-14","room_stay_to":"2020-09-17","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":"62692","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-21 13:31:34","reservation_modified_date_time":"2020-08-15 15:23:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"62692","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3127510","reservation_id":"99153","confirmation_number":"PB12235269484","room_confirmation_number":"PB12327869329","room_stay_from":"2020-09-13","room_stay_to":"2020-09-17","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":"62914","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-17 00:51:07","reservation_modified_date_time":"2020-08-17 00:51:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"62914","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3133828","reservation_id":"99955","confirmation_number":"BP12268269163","room_confirmation_number":"BP12557110663","room_stay_from":"2020-09-15","room_stay_to":"2020-09-17","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"105957","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-04 01:14:10","reservation_modified_date_time":"2020-09-04 01:18:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105957","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3135570","reservation_id":"100182","confirmation_number":"BP12254372218","room_confirmation_number":"BP12521107635","room_stay_from":"2020-09-14","room_stay_to":"2020-09-17","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":"106204","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-09 20:44:40","reservation_modified_date_time":"2020-09-09 20:44:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106204","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137310","reservation_id":"100301","confirmation_number":"BP12212885222","room_confirmation_number":"BP12524574314","room_stay_from":"2020-09-15","room_stay_to":"2020-09-17","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"47798","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-12 13:29:15","reservation_modified_date_time":"2020-09-16 00:12:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137312","reservation_id":"99920","confirmation_number":"PB12236310777","room_confirmation_number":"PB12362919222","room_stay_from":"2020-09-15","room_stay_to":"2020-09-17","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"105920","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-03 15:09:20","reservation_modified_date_time":"2020-09-16 00:44:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105920","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3132459","reservation_id":"99771","confirmation_number":"PB12229798690","room_confirmation_number":"PB12371974226","room_stay_from":"2020-09-13","room_stay_to":"2020-09-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"92748","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-31 02:02:21","reservation_modified_date_time":"2020-08-31 02:02:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92748","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3135152","reservation_id":"100103","confirmation_number":"PB12215308343","room_confirmation_number":"PB12341391734","room_stay_from":"2020-09-15","room_stay_to":"2020-09-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"106123","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-07 16:44:09","reservation_modified_date_time":"2020-09-07 16:44:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106123","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3136505","reservation_id":"93706","confirmation_number":"PB12267001651","room_confirmation_number":"PB12353867011","room_stay_from":"2020-09-12","room_stay_to":"2020-09-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"51452","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-05 17:41:49","reservation_modified_date_time":"2020-09-12 17:48:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"51452","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137043","reservation_id":"100176","confirmation_number":"PB12235973539","room_confirmation_number":"PB12319248880","room_stay_from":"2020-09-14","room_stay_to":"2020-09-18","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"106423","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-09 18:46:10","reservation_modified_date_time":"2020-09-14 21:35:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106423","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3100528","reservation_id":"95846","confirmation_number":"BV12255362831","room_confirmation_number":"BV12449936219","room_stay_from":"2020-09-11","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"102003","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-06-03 11:24:53","reservation_modified_date_time":"2020-06-03 11:24:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102003","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3130499","reservation_id":"99545","confirmation_number":"BV12228472387","room_confirmation_number":"BV12427751184","room_stay_from":"2020-09-12","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"35292","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-26 13:16:39","reservation_modified_date_time":"2020-08-26 13:16:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"35292","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3131843","reservation_id":"93677","confirmation_number":"PB12259618645","room_confirmation_number":"PB12362306518","room_stay_from":"2020-09-12","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"99904","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-01 16:37:10","reservation_modified_date_time":"2020-08-29 13:07:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99904","canceled_nights_data":"","posAmt_airbnb_taxpaid":"70.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":"3132763","reservation_id":"99787","confirmation_number":"PB12249937156","room_confirmation_number":"PB12343689347","room_stay_from":"2020-09-12","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"105797","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-31 17:02:10","reservation_modified_date_time":"2020-08-31 17:04:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105797","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3133615","reservation_id":"99915","confirmation_number":"PB12211111045","room_confirmation_number":"PB12374663251","room_stay_from":"2020-09-14","room_stay_to":"2020-09-19","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":"48776","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-03 13:05:09","reservation_modified_date_time":"2020-09-03 13:05:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"48776","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3136729","reservation_id":"99214","confirmation_number":"BV12212661097","room_confirmation_number":"BV12434320906","room_stay_from":"2020-09-13","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"106388","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-08-18 19:55:08","reservation_modified_date_time":"2020-09-13 18:06:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106388","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3137155","reservation_id":"93716","confirmation_number":"BP12270286970","room_confirmation_number":"BP12512849390","room_stay_from":"2020-09-15","room_stay_to":"2020-09-19","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":"40114","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-07 14:25:13","reservation_modified_date_time":"2020-09-15 16:43:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"40114","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137178","reservation_id":"98969","confirmation_number":"BV12237928744","room_confirmation_number":"BV12452891699","room_stay_from":"2020-09-15","room_stay_to":"2020-09-19","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":"76358","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-13 13:01:46","reservation_modified_date_time":"2020-09-15 17:31:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76358","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137204","reservation_id":"94488","confirmation_number":"PB12221277457","room_confirmation_number":"PB12317311697","room_stay_from":"2020-09-11","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"58691","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 13:26:46","reservation_modified_date_time":"2020-09-15 18:45:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58691","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3136559","reservation_id":"96977","confirmation_number":"BP12278262789","room_confirmation_number":"BP12583097812","room_stay_from":"2020-09-12","room_stay_to":"2020-09-20","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"36083","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-06-23 12:52:04","reservation_modified_date_time":"2020-09-12 20:20:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36083","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137040","reservation_id":"100369","confirmation_number":"PB12279786617","room_confirmation_number":"PB12328340770","room_stay_from":"2020-09-14","room_stay_to":"2020-09-20","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"106422","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-14 14:27:09","reservation_modified_date_time":"2020-09-14 21:34:01","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106422","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3136271","reservation_id":"99792","confirmation_number":"BV12246824033","room_confirmation_number":"BV12429363981","room_stay_from":"2020-09-12","room_stay_to":"2020-09-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"105802","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-31 19:15:40","reservation_modified_date_time":"2020-09-11 23:30:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105802","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3136714","reservation_id":"90974","confirmation_number":"PB12224531042","room_confirmation_number":"PB12393692969","room_stay_from":"2020-09-14","room_stay_to":"2020-09-22","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"97066","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-30 21:56:31","reservation_modified_date_time":"2020-09-13 16:56:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97066","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3136839","reservation_id":"90946","confirmation_number":"BV12214405126","room_confirmation_number":"BV12452870424","room_stay_from":"2020-09-13","room_stay_to":"2020-09-27","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"168.00","grand_total":"189.84","paid_amount":"189.84","product_id":"1781","service_quantity":"1","customer_traveller_id":"23128","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-30 17:19:00","reservation_modified_date_time":"2020-09-13 21:07:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23128","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3136841","reservation_id":"90946","confirmation_number":"BV12249599028","room_confirmation_number":"BV12471809932","room_stay_from":"2020-09-13","room_stay_to":"2020-09-27","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"168.00","grand_total":"189.84","paid_amount":"189.84","product_id":"1781","service_quantity":"1","customer_traveller_id":"23128","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-30 17:19:00","reservation_modified_date_time":"2020-09-13 21:07:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23128","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137157","reservation_id":"85293","confirmation_number":"BV12252690227","room_confirmation_number":"BV12412059286","room_stay_from":"2020-09-15","room_stay_to":"2020-10-01","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"40114","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-08 13:40:32","reservation_modified_date_time":"2020-09-15 16:51:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"40114","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3137128","reservation_id":"95335","confirmation_number":"PB12257012200","room_confirmation_number":"PB12397005569","room_stay_from":"2020-11-12","room_stay_to":"2020-11-15","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"101524","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-24 15:38:04","reservation_modified_date_time":"2020-09-15 13:56:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101524","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137151","reservation_id":"100118","confirmation_number":"PB12215817032","room_confirmation_number":"PB12340275322","room_stay_from":"2020-09-26","room_stay_to":"2020-09-27","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"106139","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-08 00:10:07","reservation_modified_date_time":"2020-09-15 16:43:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106139","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137193","reservation_id":"92660","confirmation_number":"BP12284401856","room_confirmation_number":"BP12518161313","room_stay_from":"2021-02-22","room_stay_to":"2021-02-27","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"68651","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-27 16:12:12","reservation_modified_date_time":"2020-09-15 17:50:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"68651","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137208","reservation_id":"100110","confirmation_number":"BV12246763124","room_confirmation_number":"BV12493466021","room_stay_from":"2020-09-24","room_stay_to":"2020-09-27","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"106130","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-07 18:20:46","reservation_modified_date_time":"2020-09-15 19:07:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106130","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3137256","reservation_id":"100413","confirmation_number":"PB12243014761","room_confirmation_number":"PB12386130200","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":"1213","service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-09-15 20:56:28","reservation_modified_date_time":"2020-09-15 20:56:28","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3135574","reservation_id":"99830","confirmation_number":"PB12297652441","room_confirmation_number":"PB12354334478","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-09-09 20:56:18","reservation_modified_date_time":"2020-09-09 20:56:18","customer_id":"106190","parentCustTravId":"106190","customer_traveller_id":"106190","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-09-15 15:29:40","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-09-09","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120","departureCount":2,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1098,1123,1096","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12249081550","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","bundle_room":"0"},{"confirmation_number":"PB12239774114","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","bundle_room":"0"},{"confirmation_number":"PB12243464711","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3136698","reservation_id":"99830","confirmation_number":"PB12354334478","room_stay_from":"2020-09-09","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.28,117.28,150.57,150.57,117.28,117.28,117.28","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"887.54","grand_total":"1002.92","paid_amount":"1002.92","room_type_id":"289","product_id":"1097","siteminder_id":"BDC-2555371487","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":"106190","customer_id":"106190","source_of_creation":"Booking.com","reservation_created_date":"2020-09-01 21:32:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"154.13","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.28","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137042","reservation_id":"100369","confirmation_number":"PB12328340770","room_stay_from":"2020-09-14","room_stay_to":"2020-09-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.64,143.64,143.64,143.64,188.37,188.37","nightly_discount":"0,0,0,0,0,0","subtotal":"951.30","grand_total":"1074.97","paid_amount":"1074.97","room_type_id":"289","product_id":"1121","siteminder_id":"BDC-3027406408","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":"106422","customer_id":"106422","source_of_creation":"Booking.com","reservation_created_date":"2020-09-14 14:27:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"160.69","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.64","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":"3137150","reservation_id":"100118","confirmation_number":"PB12340275322","room_stay_from":"2020-09-26","room_stay_to":"2020-09-27","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.36","nightly_discount":"0","subtotal":"171.36","grand_total":"193.64","paid_amount":"193.64","room_type_id":"291","product_id":"1114","siteminder_id":"BDC-3132257658","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":"106139","customer_id":"106139","source_of_creation":"Booking.com","reservation_created_date":"2020-09-08 00:10:07","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"28.70","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3137176","reservation_id":"100006","confirmation_number":"PB12372083261","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"130.25","nightly_discount":"0","subtotal":"130.25","grand_total":"147.19","paid_amount":"147.19","room_type_id":"291","product_id":"1118","siteminder_id":"EXP-1696154610","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106444","customer_id":"106444","source_of_creation":"Expedia","reservation_created_date":"2020-09-05 13:11:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.25","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":"3137314","reservation_id":"100428","confirmation_number":"PB12373182359","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"88.70","nightly_discount":"0","subtotal":"88.70","grand_total":"100.23","paid_amount":"100.23","room_type_id":"289","product_id":"1095","siteminder_id":"EXP-1699319665","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":"106458","customer_id":"106458","source_of_creation":"Expedia","reservation_created_date":"2020-09-15 23:21:12","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":"88.70","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":"3137044","reservation_id":"100176","confirmation_number":"PB12319248880","room_stay_from":"2020-09-14","room_stay_to":"2020-09-18","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"109.19,101.67,109.19,109.19","nightly_discount":"0,0,0,0","subtotal":"429.24","grand_total":"485.04","paid_amount":"485.04","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1697436745","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":"106423","customer_id":"106423","source_of_creation":"Expedia","reservation_created_date":"2020-09-09 18:46:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"101.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"}]}],"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":[{"room_stay_id":"3131841","reservation_id":"93677","confirmation_number":"PB12362306518","room_stay_from":"2020-09-12","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"223.30,205.30,205.30,205.30,205.30,205.30,223.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1473.10","grand_total":"1664.61","paid_amount":"1664.61","room_type_id":"287","product_id":"1089","siteminder_id":"GCC-0004600044-064","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"70.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99904","customer_id":"99904","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-04-01 16:37:10","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"205.30","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"}]}],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3137161","reservation_id":"100401","confirmation_number":"PB12382755348","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"95.49","nightly_discount":"0","subtotal":"95.49","grand_total":"107.90","paid_amount":"107.90","room_type_id":"289","product_id":"1094","siteminder_id":"AGO-342717114","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106442","customer_id":"106442","source_of_creation":"Agoda","reservation_created_date":"2020-09-15 15:07:10","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":"95.49","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"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3136378","reservation_id":"100300","confirmation_number":"PB12316144405","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00","nightly_discount":"0.00","subtotal":"119.00","grand_total":"134.47","paid_amount":"134.47","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":"106331","customer_id":"106331","source_of_creation":"FE","reservation_created_date":"2020-09-12 13:26:40","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":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3127509","reservation_id":"99153","confirmation_number":"PB12327869329","room_stay_from":"2020-09-13","room_stay_to":"2020-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00,149.00,149.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"596.00","grand_total":"673.48","paid_amount":"673.48","room_type_id":"286","product_id":"1086","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":"62914","customer_id":"62914","source_of_creation":"FE","reservation_created_date":"2020-08-17 00:51:07","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3132458","reservation_id":"99771","confirmation_number":"PB12371974226","room_stay_from":"2020-09-13","room_stay_to":"2020-09-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.50,110.50,110.50,110.50,110.50","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"552.50","grand_total":"624.33","paid_amount":"624.33","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92748","customer_id":"92748","source_of_creation":"FE","reservation_created_date":"2020-08-31 02:02:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3137188","reservation_id":"100405","confirmation_number":"PB12384370472","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.40","nightly_discount":"0.00","subtotal":"107.40","grand_total":"121.36","paid_amount":"121.36","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":"100147","customer_id":"100147","source_of_creation":"PMS","reservation_created_date":"2020-09-15 17:37:18","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"107.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":"3126914","reservation_id":"84470","confirmation_number":"PB12391110580","room_stay_from":"2020-09-14","room_stay_to":"2020-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00,149.00","nightly_discount":"0.00,0.00,0.00","subtotal":"447.00","grand_total":"505.11","paid_amount":"505.11","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":"62692","customer_id":"62692","source_of_creation":"PMS","reservation_created_date":"2019-09-21 13:31:34","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":"149.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137311","reservation_id":"99920","confirmation_number":"PB12362919222","room_stay_from":"2020-09-15","room_stay_to":"2020-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"98.00,98.00","nightly_discount":"0.00,0.00","subtotal":"196.00","grand_total":"221.48","paid_amount":"221.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":"105920","customer_id":"105920","source_of_creation":"PMS","reservation_created_date":"2020-09-03 15:09:20","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":"98.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135151","reservation_id":"100103","confirmation_number":"PB12341391734","room_stay_from":"2020-09-15","room_stay_to":"2020-09-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"170.85,170.85,170.85","nightly_discount":"0.00,0.00,0.00","subtotal":"512.55","grand_total":"579.18","paid_amount":"579.18","room_type_id":"287","product_id":"1090","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106123","customer_id":"106123","source_of_creation":"PMS","reservation_created_date":"2020-09-07 16:44:09","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":"170.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3136504","reservation_id":"93706","confirmation_number":"PB12353867011","room_stay_from":"2020-09-12","room_stay_to":"2020-09-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"221.00,201.00,201.00,201.00,201.00,201.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,55.85","subtotal":"1226.00","grand_total":"1322.27","paid_amount":"1322.27","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":"51452","customer_id":"51452","source_of_creation":"PMS","reservation_created_date":"2020-04-05 17:41:49","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":"201.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3132762","reservation_id":"99787","confirmation_number":"PB12343689347","room_stay_from":"2020-09-12","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,102.00,102.00,102.00,102.00,102.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"790.00","grand_total":"892.70","paid_amount":"892.70","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":"105797","customer_id":"105797","source_of_creation":"PMS","reservation_created_date":"2020-08-31 17:02:10","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":"102.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3133614","reservation_id":"99915","confirmation_number":"PB12374663251","room_stay_from":"2020-09-14","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.65,126.65,126.65,126.65,169.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"675.60","grand_total":"763.43","paid_amount":"763.43","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":"48776","customer_id":"48776","source_of_creation":"PMS","reservation_created_date":"2020-09-03 13:05:09","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":"126.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137202","reservation_id":"94488","confirmation_number":"PB12317311697","room_stay_from":"2020-09-11","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,140.00,102.00,102.00,102.00,102.00,102.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"930.00","grand_total":"1050.90","paid_amount":"1050.90","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":"58691","customer_id":"58691","source_of_creation":"PMS","reservation_created_date":"2020-05-06 13:26:46","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":"102.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3136713","reservation_id":"90974","confirmation_number":"PB12393692969","room_stay_from":"2020-09-14","room_stay_to":"2020-09-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.00,166.00,166.00,166.00,206.00,206.00,166.00,166.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1408.00","grand_total":"1591.04","paid_amount":"1591.04","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":"97066","customer_id":"97066","source_of_creation":"PMS","reservation_created_date":"2020-01-30 21:56:31","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"166.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137127","reservation_id":"95335","confirmation_number":"PB12397005569","room_stay_from":"2020-11-12","room_stay_to":"2020-11-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,165.00,165.00","nightly_discount":"0.00,0.00,0.00","subtotal":"460.00","grand_total":"519.80","paid_amount":"146.90","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101524","customer_id":"101524","source_of_creation":"PMS","reservation_created_date":"2020-05-24 15:38:04","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"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":"3137159","reservation_id":"100401","confirmation_number":"PB12228273066","room_confirmation_number":"PB12382755348","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"106442","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-09-15 15:07:10","reservation_modified_date_time":"2020-09-15 16:56:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106442","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","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":"3137172","reservation_id":"100006","confirmation_number":"PB12296453712","room_confirmation_number":"PB12372083261","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"106444","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-09-06 13:24:39","reservation_modified_date_time":"2020-09-15 17:11:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106444","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","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":"3131842","reservation_id":"93677","confirmation_number":"PB12298692494","room_confirmation_number":"PB12362306518","room_stay_from":"2020-09-12","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"99904","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-08-29 13:07:10","reservation_modified_date_time":"2020-08-29 13:07:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99904","canceled_nights_data":"","posAmt_airbnb_taxpaid":"70.00","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3136379","reservation_id":"100300","confirmation_number":"PB12234434500","room_confirmation_number":"PB12316144405","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"106331","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-12 13:26:40","reservation_modified_date_time":"2020-09-12 13:26:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106331","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3136699","reservation_id":"99830","confirmation_number":"PB12239199340","room_confirmation_number":"PB12354334478","room_stay_from":"2020-09-09","room_stay_to":"2020-09-16","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"106190","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-01 21:32:08","reservation_modified_date_time":"2020-09-13 16:52:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106190","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3137160","reservation_id":"100401","confirmation_number":"PB12276946568","room_confirmation_number":"PB12382755348","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","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":"106442","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-15 15:07:10","reservation_modified_date_time":"2020-09-15 16:56:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106442","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","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":"3137173","reservation_id":"100006","confirmation_number":"PB12224442986","room_confirmation_number":"PB12372083261","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","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":"106444","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-05 13:11:08","reservation_modified_date_time":"2020-09-15 17:11:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106444","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","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":"3137187","reservation_id":"100405","confirmation_number":"PB12226807310","room_confirmation_number":"PB12384370472","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"100147","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-15 17:37:18","reservation_modified_date_time":"2020-09-15 17:39:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100147","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137313","reservation_id":"100428","confirmation_number":"PB12248773999","room_confirmation_number":"PB12373182359","room_stay_from":"2020-09-15","room_stay_to":"2020-09-16","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":"106458","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-15 23:21:12","reservation_modified_date_time":"2020-09-16 01:06:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106458","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3126915","reservation_id":"84470","confirmation_number":"PB12285254863","room_confirmation_number":"PB12391110580","room_stay_from":"2020-09-14","room_stay_to":"2020-09-17","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":"62692","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-21 13:31:34","reservation_modified_date_time":"2020-08-15 15:23:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"62692","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3127510","reservation_id":"99153","confirmation_number":"PB12235269484","room_confirmation_number":"PB12327869329","room_stay_from":"2020-09-13","room_stay_to":"2020-09-17","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":"62914","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-17 00:51:07","reservation_modified_date_time":"2020-08-17 00:51:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"62914","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137312","reservation_id":"99920","confirmation_number":"PB12236310777","room_confirmation_number":"PB12362919222","room_stay_from":"2020-09-15","room_stay_to":"2020-09-17","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"105920","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-03 15:09:20","reservation_modified_date_time":"2020-09-16 00:44:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105920","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3132459","reservation_id":"99771","confirmation_number":"PB12229798690","room_confirmation_number":"PB12371974226","room_stay_from":"2020-09-13","room_stay_to":"2020-09-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"92748","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-31 02:02:21","reservation_modified_date_time":"2020-08-31 02:02:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92748","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3135152","reservation_id":"100103","confirmation_number":"PB12215308343","room_confirmation_number":"PB12341391734","room_stay_from":"2020-09-15","room_stay_to":"2020-09-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"106123","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-07 16:44:09","reservation_modified_date_time":"2020-09-07 16:44:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106123","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3136505","reservation_id":"93706","confirmation_number":"PB12267001651","room_confirmation_number":"PB12353867011","room_stay_from":"2020-09-12","room_stay_to":"2020-09-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"51452","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-05 17:41:49","reservation_modified_date_time":"2020-09-12 17:48:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"51452","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137043","reservation_id":"100176","confirmation_number":"PB12235973539","room_confirmation_number":"PB12319248880","room_stay_from":"2020-09-14","room_stay_to":"2020-09-18","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"106423","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-09 18:46:10","reservation_modified_date_time":"2020-09-14 21:35:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106423","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3131843","reservation_id":"93677","confirmation_number":"PB12259618645","room_confirmation_number":"PB12362306518","room_stay_from":"2020-09-12","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"99904","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-01 16:37:10","reservation_modified_date_time":"2020-08-29 13:07:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99904","canceled_nights_data":"","posAmt_airbnb_taxpaid":"70.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":"3132763","reservation_id":"99787","confirmation_number":"PB12249937156","room_confirmation_number":"PB12343689347","room_stay_from":"2020-09-12","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"105797","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-31 17:02:10","reservation_modified_date_time":"2020-08-31 17:04:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105797","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3133615","reservation_id":"99915","confirmation_number":"PB12211111045","room_confirmation_number":"PB12374663251","room_stay_from":"2020-09-14","room_stay_to":"2020-09-19","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":"48776","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-03 13:05:09","reservation_modified_date_time":"2020-09-03 13:05:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"48776","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137204","reservation_id":"94488","confirmation_number":"PB12221277457","room_confirmation_number":"PB12317311697","room_stay_from":"2020-09-11","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"58691","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 13:26:46","reservation_modified_date_time":"2020-09-15 18:45:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58691","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137040","reservation_id":"100369","confirmation_number":"PB12279786617","room_confirmation_number":"PB12328340770","room_stay_from":"2020-09-14","room_stay_to":"2020-09-20","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"106422","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-14 14:27:09","reservation_modified_date_time":"2020-09-14 21:34:01","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106422","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3136714","reservation_id":"90974","confirmation_number":"PB12224531042","room_confirmation_number":"PB12393692969","room_stay_from":"2020-09-14","room_stay_to":"2020-09-22","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"97066","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-30 21:56:31","reservation_modified_date_time":"2020-09-13 16:56:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97066","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137128","reservation_id":"95335","confirmation_number":"PB12257012200","room_confirmation_number":"PB12397005569","room_stay_from":"2020-11-12","room_stay_to":"2020-11-15","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"101524","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-24 15:38:04","reservation_modified_date_time":"2020-09-15 13:56:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101524","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137151","reservation_id":"100118","confirmation_number":"PB12215817032","room_confirmation_number":"PB12340275322","room_stay_from":"2020-09-26","room_stay_to":"2020-09-27","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"106139","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-08 00:10:07","reservation_modified_date_time":"2020-09-15 16:43:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106139","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3137256","reservation_id":"100413","confirmation_number":"PB12243014761","room_confirmation_number":"PB12386130200","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":"1213","service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-09-15 20:56:28","reservation_modified_date_time":"2020-09-15 20:56:28","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3135574","reservation_id":"99830","confirmation_number":"PB12297652441","room_confirmation_number":"PB12354334478","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-09-09 20:56:18","reservation_modified_date_time":"2020-09-09 20:56:18","customer_id":"106190","parentCustTravId":"106190","customer_traveller_id":"106190","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-09-15 15:29:40","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-09-09","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":0,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3137083","reservation_id":"100362","confirmation_number":"BV12425321856","room_stay_from":"2020-09-14","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.89,53.89","nightly_discount":"0,0","subtotal":"107.78","grand_total":"121.79","paid_amount":"121.79","room_type_id":"285","product_id":"1084","siteminder_id":"HTN-138294682-HZM6WA","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":"106428","customer_id":"106428","source_of_creation":"HotelTonight","reservation_created_date":"2020-09-14 07:02:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"53.89","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"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":[{"room_stay_id":"3136730","reservation_id":"99214","confirmation_number":"BV12434320906","room_stay_from":"2020-09-13","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.06,122.06,122.06,122.06,122.06,132.14","nightly_discount":"0,0,0,0,0,0","subtotal":"742.44","grand_total":"838.96","paid_amount":"838.96","room_type_id":"305","product_id":"1222","siteminder_id":"AGO-336933654","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":"106388","customer_id":"106388","source_of_creation":"Agoda","reservation_created_date":"2020-08-18 19:55:08","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"122.06","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"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3100527","reservation_id":"95846","confirmation_number":"BV12449936219","room_stay_from":"2020-09-11","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,84.00,84.00,84.00,84.00,84.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"732.00","grand_total":"827.16","paid_amount":"827.16","room_type_id":"303","product_id":"1139","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":"102003","customer_id":"102003","source_of_creation":"FE","reservation_created_date":"2020-06-03 11:24:53","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3130498","reservation_id":"99545","confirmation_number":"BV12427751184","room_stay_from":"2020-09-12","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.00,137.70,137.70,137.70,137.70,137.70,137.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"962.50","grand_total":"1087.63","paid_amount":"1087.63","room_type_id":"306","product_id":"1223","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":"35292","customer_id":"35292","source_of_creation":"PMS","reservation_created_date":"2020-08-26 13:16:39","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137177","reservation_id":"98969","confirmation_number":"BV12452891699","room_stay_from":"2020-09-15","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.00,143.00,163.00,163.00","nightly_discount":"0.00,0.00,0.00,25.85","subtotal":"612.00","grand_total":"662.35","paid_amount":"662.35","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76358","customer_id":"76358","source_of_creation":"PMS","reservation_created_date":"2020-08-13 13:01:46","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3136269","reservation_id":"99792","confirmation_number":"BV12429363981","room_stay_from":"2020-09-12","room_stay_to":"2020-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"152.00,112.20,112.20,112.20,112.20,112.20,152.00,152.00,112.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1129.20","grand_total":"1275.99","paid_amount":"1275.99","room_type_id":"308","product_id":"1225","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":"105802","customer_id":"105802","source_of_creation":"PMS","reservation_created_date":"2020-08-31 19:15:40","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"112.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":"3136838","reservation_id":"90946","confirmation_number":"BV12452870424","room_stay_from":"2020-09-13","room_stay_to":"2020-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.00,128.00,128.00,128.00,128.00,152.00,152.00,128.00,128.00,128.00,128.00,128.00,152.00,152.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,97.00","subtotal":"1888.00","grand_total":"2023.83","paid_amount":"2023.83","room_type_id":"304","product_id":"1219","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":"23128","customer_id":"23128","source_of_creation":"PMS","reservation_created_date":"2020-01-30 17:19:00","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"128.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3136840","reservation_id":"90946","confirmation_number":"BV12471809932","room_stay_from":"2020-09-13","room_stay_to":"2020-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.00,128.00,128.00,128.00,128.00,152.00,152.00,128.00,128.00,128.00,128.00,128.00,152.00,152.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,97.00","subtotal":"1888.00","grand_total":"2023.83","paid_amount":"2023.83","room_type_id":"304","product_id":"1218","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":"23128","customer_id":"23128","source_of_creation":"PMS","reservation_created_date":"2020-01-30 17:19:00","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"128.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137156","reservation_id":"85293","confirmation_number":"BV12412059286","room_stay_from":"2020-09-15","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.00,104.00,104.00,84.00,84.00,84.00,84.00,84.00,104.00,104.00,84.00,84.00,84.00,84.00,84.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,50.07","subtotal":"1444.00","grand_total":"1575.15","paid_amount":"1575.15","room_type_id":"303","product_id":"1140","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"40114","customer_id":"40114","source_of_creation":"PMS","reservation_created_date":"2019-10-08 13:40:32","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137207","reservation_id":"100110","confirmation_number":"BV12493466021","room_stay_from":"2020-09-24","room_stay_to":"2020-09-27","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"121.55,163.00,163.00","nightly_discount":"0.00,0.00,0.00","subtotal":"447.55","grand_total":"505.73","paid_amount":"137.35","room_type_id":"304","product_id":"1220","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106130","customer_id":"106130","source_of_creation":"PMS","reservation_created_date":"2020-09-07 18:20:46","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3137081","reservation_id":"100362","confirmation_number":"BV12224180650","room_confirmation_number":"BV12425321856","room_stay_from":"2020-09-14","room_stay_to":"2020-09-16","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":"106428","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-14 07:02:11","reservation_modified_date_time":"2020-09-14 22:51:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106428","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3100528","reservation_id":"95846","confirmation_number":"BV12255362831","room_confirmation_number":"BV12449936219","room_stay_from":"2020-09-11","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"102003","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-06-03 11:24:53","reservation_modified_date_time":"2020-06-03 11:24:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102003","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3130499","reservation_id":"99545","confirmation_number":"BV12228472387","room_confirmation_number":"BV12427751184","room_stay_from":"2020-09-12","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"35292","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-26 13:16:39","reservation_modified_date_time":"2020-08-26 13:16:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"35292","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3136729","reservation_id":"99214","confirmation_number":"BV12212661097","room_confirmation_number":"BV12434320906","room_stay_from":"2020-09-13","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"106388","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-08-18 19:55:08","reservation_modified_date_time":"2020-09-13 18:06:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106388","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3137178","reservation_id":"98969","confirmation_number":"BV12237928744","room_confirmation_number":"BV12452891699","room_stay_from":"2020-09-15","room_stay_to":"2020-09-19","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":"76358","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-13 13:01:46","reservation_modified_date_time":"2020-09-15 17:31:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76358","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3136271","reservation_id":"99792","confirmation_number":"BV12246824033","room_confirmation_number":"BV12429363981","room_stay_from":"2020-09-12","room_stay_to":"2020-09-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"105802","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-31 19:15:40","reservation_modified_date_time":"2020-09-11 23:30:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105802","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3136839","reservation_id":"90946","confirmation_number":"BV12214405126","room_confirmation_number":"BV12452870424","room_stay_from":"2020-09-13","room_stay_to":"2020-09-27","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"168.00","grand_total":"189.84","paid_amount":"189.84","product_id":"1781","service_quantity":"1","customer_traveller_id":"23128","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-30 17:19:00","reservation_modified_date_time":"2020-09-13 21:07:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23128","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3136841","reservation_id":"90946","confirmation_number":"BV12249599028","room_confirmation_number":"BV12471809932","room_stay_from":"2020-09-13","room_stay_to":"2020-09-27","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"168.00","grand_total":"189.84","paid_amount":"189.84","product_id":"1781","service_quantity":"1","customer_traveller_id":"23128","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-30 17:19:00","reservation_modified_date_time":"2020-09-13 21:07:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23128","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137157","reservation_id":"85293","confirmation_number":"BV12252690227","room_confirmation_number":"BV12412059286","room_stay_from":"2020-09-15","room_stay_to":"2020-10-01","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"40114","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-08 13:40:32","reservation_modified_date_time":"2020-09-15 16:51:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"40114","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3137208","reservation_id":"100110","confirmation_number":"BV12246763124","room_confirmation_number":"BV12493466021","room_stay_from":"2020-09-24","room_stay_to":"2020-09-27","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"106130","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-07 18:20:46","reservation_modified_date_time":"2020-09-15 19:07:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106130","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"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":1,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3133829","reservation_id":"99955","confirmation_number":"BP12557110663","room_stay_from":"2020-09-15","room_stay_to":"2020-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.64,76.64","nightly_discount":"0,0","subtotal":"153.28","grand_total":"173.21","paid_amount":"173.21","room_type_id":"298","product_id":"1133","siteminder_id":"BDC-3783489262","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":"105957","customer_id":"105957","source_of_creation":"Booking.com","reservation_created_date":"2020-09-04 01:14:10","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"34.79","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"76.64","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":[],"exp_non_taxable":[{"room_stay_id":"3137205","reservation_id":"93866","confirmation_number":"BP12544036081","room_stay_from":"2020-09-11","room_stay_to":"2020-09-16","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"79.26,79.26,70.40,70.40,70.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"369.72","grand_total":"417.78","paid_amount":"417.78","room_type_id":"315","product_id":"1230","siteminder_id":"EXP-1661046935","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":"100102","customer_id":"100102","source_of_creation":"Expedia","reservation_created_date":"2020-04-16 03:41:07","service_canceled_date_time":"2020-09-15 19:00:53","canceled_nights_data":"","product_name":"BP Walk","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"","total_paid_amount":"417.78","deltaChange":"79.55","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3135569","reservation_id":"100182","confirmation_number":"BP12521107635","room_stay_from":"2020-09-14","room_stay_to":"2020-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"124.10,124.10,124.10","nightly_discount":"0.00,0.00,0.00","subtotal":"372.30","grand_total":"420.70","paid_amount":"420.70","room_type_id":"302","product_id":"1138","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":"106204","customer_id":"106204","source_of_creation":"FE","reservation_created_date":"2020-09-09 20:44:40","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137309","reservation_id":"100301","confirmation_number":"BP12524574314","room_stay_from":"2020-09-15","room_stay_to":"2020-09-17","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"85.85,85.85","nightly_discount":"0.00,0.00","subtotal":"171.70","grand_total":"194.02","paid_amount":"194.02","room_type_id":"294","product_id":"1125","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"FE","reservation_created_date":"2020-09-12 13:29:15","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 803","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3137154","reservation_id":"93716","confirmation_number":"BP12512849390","room_stay_from":"2020-09-15","room_stay_to":"2020-09-19","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"100.00,100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00,17.40","subtotal":"400.00","grand_total":"432.34","paid_amount":"432.34","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"40114","customer_id":"40114","source_of_creation":"PMS","reservation_created_date":"2020-04-07 14:25:13","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3136558","reservation_id":"96977","confirmation_number":"BP12583097812","room_stay_from":"2020-09-12","room_stay_to":"2020-09-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.00,135.00,135.00,135.00,135.00,135.00,155.00,155.00","nightly_discount":"0.00,50.40,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1140.00","grand_total":"1231.25","paid_amount":"1231.25","room_type_id":"296","product_id":"1130","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"36083","customer_id":"36083","source_of_creation":"PMS","reservation_created_date":"2020-06-23 12:52:04","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 804","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"135.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3137192","reservation_id":"92660","confirmation_number":"BP12518161313","room_stay_from":"2021-02-22","room_stay_to":"2021-02-27","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.20,199.20,199.20,199.20,199.20","nightly_discount":"0.00,0.00,0.00,0,0","subtotal":"996.00","grand_total":"1125.48","paid_amount":"193.91","room_type_id":"308","product_id":"1225","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":"68651","customer_id":"68651","source_of_creation":"PMS","reservation_created_date":"2020-02-27 16:12:12","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3135571","reservation_id":"100182","confirmation_number":"BP12228512238","room_confirmation_number":"BP12521107635","room_stay_from":"2020-09-14","room_stay_to":"2020-09-17","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"106204","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-09-09 20:44:40","reservation_modified_date_time":"2020-09-09 20:44:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106204","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3133828","reservation_id":"99955","confirmation_number":"BP12268269163","room_confirmation_number":"BP12557110663","room_stay_from":"2020-09-15","room_stay_to":"2020-09-17","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"105957","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-04 01:14:10","reservation_modified_date_time":"2020-09-04 01:18:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105957","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3135570","reservation_id":"100182","confirmation_number":"BP12254372218","room_confirmation_number":"BP12521107635","room_stay_from":"2020-09-14","room_stay_to":"2020-09-17","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":"106204","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-09 20:44:40","reservation_modified_date_time":"2020-09-09 20:44:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106204","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137310","reservation_id":"100301","confirmation_number":"BP12212885222","room_confirmation_number":"BP12524574314","room_stay_from":"2020-09-15","room_stay_to":"2020-09-17","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"47798","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-12 13:29:15","reservation_modified_date_time":"2020-09-16 00:12:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137155","reservation_id":"93716","confirmation_number":"BP12270286970","room_confirmation_number":"BP12512849390","room_stay_from":"2020-09-15","room_stay_to":"2020-09-19","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":"40114","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-07 14:25:13","reservation_modified_date_time":"2020-09-15 16:43:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"40114","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3136559","reservation_id":"96977","confirmation_number":"BP12278262789","room_confirmation_number":"BP12583097812","room_stay_from":"2020-09-12","room_stay_to":"2020-09-20","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"36083","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-06-23 12:52:04","reservation_modified_date_time":"2020-09-12 20:20:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36083","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3137193","reservation_id":"92660","confirmation_number":"BP12284401856","room_confirmation_number":"BP12518161313","room_stay_from":"2021-02-22","room_stay_to":"2021-02-27","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"68651","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-27 16:12:12","reservation_modified_date_time":"2020-09-15 17:50:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"68651","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}