{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-09-30","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":1,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1127","block_room_bookings":[{"confirmation_number":"BP12232481298","room_stay_from":"2020-09-29","room_stay_to":"2020-10-01","bundle_room":"0"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3140805","reservation_id":"100180","confirmation_number":"PB12351189672","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.28,117.28","nightly_discount":"0,0","subtotal":"234.56","grand_total":"265.05","paid_amount":"265.05","room_type_id":"285","product_id":"1083","siteminder_id":"BDC-2940541602","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":"107038","customer_id":"107038","source_of_creation":"Booking.com","reservation_created_date":"2020-09-09 20:03:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"41.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.28","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":"3140925","reservation_id":"100531","confirmation_number":"BP12552219344","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"72.38,72.38","nightly_discount":"0,0","subtotal":"144.76","grand_total":"163.58","paid_amount":"163.58","room_type_id":"299","product_id":"1134","siteminder_id":"BDC-2566048724","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":"107067","customer_id":"107067","source_of_creation":"Booking.com","reservation_created_date":"2020-09-18 14:37:11","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"33.26","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"72.38","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":"3139352","reservation_id":"93983","confirmation_number":"PB12371702445","room_stay_from":"2020-09-24","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"221.00,234.00,234.00,221.00,221.00,221.00,221.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1573.00","grand_total":"1777.49","paid_amount":"1777.49","room_type_id":"287","product_id":"1089","siteminder_id":"EXP-1661346921","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":"106815","customer_id":"106815","source_of_creation":"Expedia","reservation_created_date":"2020-04-19 18:51: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":"221.00","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":"3140860","reservation_id":"101004","confirmation_number":"PB12348086261","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"75.63","nightly_discount":"0","subtotal":"75.63","grand_total":"85.46","paid_amount":"85.46","room_type_id":"292","product_id":"1120","siteminder_id":"EXP-1703743888","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":"107050","customer_id":"107050","source_of_creation":"Expedia","reservation_created_date":"2020-09-30 20:02:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.63","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":"3140919","reservation_id":"101014","confirmation_number":"BP12554127966","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"57.58","nightly_discount":"0","subtotal":"57.58","grand_total":"65.06","paid_amount":"65.06","room_type_id":"295","product_id":"1129","siteminder_id":"EXP-1703799038","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":"107065","customer_id":"107065","source_of_creation":"Expedia","reservation_created_date":"2020-09-30 23:27:10","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":"57.58","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":"3140580","reservation_id":"100737","confirmation_number":"PB12367802940","room_stay_from":"2020-09-29","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.05,161.05,161.05","nightly_discount":"0,0,0","subtotal":"483.15","grand_total":"545.96","paid_amount":"545.96","room_type_id":"287","product_id":"1087","siteminder_id":"EXP-1701613318","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":"106982","customer_id":"106982","source_of_creation":"Expedia","reservation_created_date":"2020-09-23 17:42:05","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":"161.05","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":"3140902","reservation_id":"101000","confirmation_number":"PB12313319706","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"66.76,66.76","nightly_discount":"0,0","subtotal":"133.52","grand_total":"150.88","paid_amount":"150.88","room_type_id":"304","product_id":"1219","siteminder_id":"EXP-1703714058","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":"107058","customer_id":"107058","source_of_creation":"Expedia","reservation_created_date":"2020-09-30 18:12:11","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":"66.76","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":"3138773","reservation_id":"100689","confirmation_number":"PB12335334409","room_stay_from":"2020-09-27","room_stay_to":"2020-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"93.37,93.37,93.37,93.37,93.37,126.17","nightly_discount":"0,0,0,0,0,0","subtotal":"593.02","grand_total":"670.11","paid_amount":"670.11","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1701066375","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":"106712","customer_id":"106712","source_of_creation":"Expedia","reservation_created_date":"2020-09-21 22:02:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"93.37","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":"3139796","reservation_id":"100057","confirmation_number":"PB12392149622","room_stay_from":"2020-09-26","room_stay_to":"2020-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"252.00,202.30,202.30,202.30,202.30,202.30,252.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1515.50","grand_total":"1712.52","paid_amount":"1712.52","room_type_id":"287","product_id":"1088","siteminder_id":"EXP-1696464962","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":"106899","customer_id":"106899","source_of_creation":"Expedia","reservation_created_date":"2020-09-06 15:31:11","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":"202.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"}]},{"room_stay_id":"3140842","reservation_id":"100816","confirmation_number":"PB12390442844","room_stay_from":"2020-09-30","room_stay_to":"2020-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.79,123.79,167.30","nightly_discount":"0,0,0","subtotal":"414.88","grand_total":"468.81","paid_amount":"468.81","room_type_id":"289","product_id":"1094","siteminder_id":"EXP-1702302158","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":"107048","customer_id":"107048","source_of_creation":"Expedia","reservation_created_date":"2020-09-25 20:47:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"123.79","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3140616","reservation_id":"100977","confirmation_number":"BV12492560353","room_stay_from":"2020-09-29","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"56.72,56.72","nightly_discount":"0,0","subtotal":"113.44","grand_total":"128.19","paid_amount":"128.19","room_type_id":"307","product_id":"1224","siteminder_id":"HTN-139802294-CCT9LZ","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":"107016","customer_id":"107016","source_of_creation":"HotelTonight","reservation_created_date":"2020-09-29 19:51:07","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"56.72","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":"3140438","reservation_id":"100951","confirmation_number":"BV12453892953","room_stay_from":"2020-09-28","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"63.03,63.03,63.03,63.03","nightly_discount":"0.00,0.00,0.00,11.00","subtotal":"252.12","grand_total":"272.47","paid_amount":"272.47","room_type_id":"306","product_id":"1223","siteminder_id":"HTN-139724522-4PLDCP","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":"106989","customer_id":"106989","source_of_creation":"HotelTonight","reservation_created_date":"2020-09-29 00:00:09","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":"63.03","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3140917","reservation_id":"101005","confirmation_number":"BV12471557964","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"51.05,51.05","nightly_discount":"0,0","subtotal":"102.10","grand_total":"115.38","paid_amount":"115.38","room_type_id":"303","product_id":"1139","siteminder_id":"HTN-139893247-RGGXJJ","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":"107064","customer_id":"107064","source_of_creation":"HotelTonight","reservation_created_date":"2020-09-30 20:06:06","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":"51.05","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":[{"room_stay_id":"3136532","reservation_id":"100317","confirmation_number":"PB12387801846","room_stay_from":"2020-09-28","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.89,103.89,103.89","nightly_discount":"0,0,0","subtotal":"311.67","grand_total":"406.66","paid_amount":"406.66","room_type_id":"285","product_id":"1085","siteminder_id":"ABB-HM8J8YD9R8","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"311.67","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106967","customer_id":"106967","source_of_creation":"Airbnb","reservation_created_date":"2020-09-12 19:34:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"43.57","commision_charges":"9.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103.89","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]},{"room_stay_id":"3140602","reservation_id":"100459","confirmation_number":"BV12489714638","room_stay_from":"2020-09-29","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.83,76.83","nightly_discount":"0,0","subtotal":"153.66","grand_total":"200.48","paid_amount":"200.48","room_type_id":"289","product_id":"1101","siteminder_id":"ABB-HM8YC9PXSJ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"153.66","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107012","customer_id":"107012","source_of_creation":"Airbnb","reservation_created_date":"2020-09-16 21:12:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"21.48","commision_charges":"4.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"76.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]},{"room_stay_id":"3140702","reservation_id":"100992","confirmation_number":"BP12593887254","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"74.69","nightly_discount":"0","subtotal":"74.69","grand_total":"97.45","paid_amount":"97.45","room_type_id":"298","product_id":"1133","siteminder_id":"ABB-HMQ25SBRDQ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"74.69","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107047","customer_id":"107047","source_of_creation":"Airbnb","reservation_created_date":"2020-09-30 12:06:07","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"10.44","commision_charges":"2.31","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"74.69","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]},{"room_stay_id":"3140830","reservation_id":"100083","confirmation_number":"BP12553703463","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"89.33,89.33","nightly_discount":"0.00,0.00","subtotal":"178.66","grand_total":"239.20","paid_amount":"239.20","room_type_id":"293","product_id":"1124","siteminder_id":"ABB-HM5XHDDET4","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"178.66","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107042","customer_id":"107042","source_of_creation":"Airbnb","reservation_created_date":"2020-09-07 01:57:05","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"27.77","commision_charges":"6.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.33","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3140913","reservation_id":"101009","confirmation_number":"BP12571904008","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"63.83","nightly_discount":"0.00","subtotal":"63.83","grand_total":"72.13","paid_amount":"72.13","room_type_id":"295","product_id":"1128","siteminder_id":"AGO-346063814","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":"107063","customer_id":"107063","source_of_creation":"Agoda","reservation_created_date":"2020-09-30 20:57:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"63.83","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3140057","reservation_id":"100893","confirmation_number":"PB12380373351","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"113.05,113.05","nightly_discount":"0.00,0.00","subtotal":"226.10","grand_total":"255.50","paid_amount":"255.50","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":"106935","customer_id":"106935","source_of_creation":"FE","reservation_created_date":"2020-09-27 17:56:00","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":"113.05","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3125925","reservation_id":"98948","confirmation_number":"PB12386665028","room_stay_from":"2020-09-30","room_stay_to":"2020-10-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,150.00,150.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"560.00","grand_total":"632.80","paid_amount":"632.80","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104934","customer_id":"104934","source_of_creation":"FE","reservation_created_date":"2020-08-12 21:27:36","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":"130.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[{"room_stay_id":"3096965","reservation_id":"87998","confirmation_number":"PB12392540005","room_stay_from":"2020-09-30","room_stay_to":"2020-10-05","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"246.34","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":"94372","customer_id":"94372","source_of_creation":"FE","reservation_created_date":"2019-12-07 19:11:48","service_canceled_date_time":"2020-07-21 15:50:51","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"246.34","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"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":"104.00","currentDayDiscount":"50.07","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3139381","reservation_id":"95987","confirmation_number":"PB12384805857","room_stay_from":"2020-09-24","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.00,158.00,158.00,138.00,138.00,138.00,138.00","nightly_discount":"0.00,47.58,0.00,0.00,0.00,0.00,0.00","subtotal":"1006.00","grand_total":"1083.02","paid_amount":"1083.02","room_type_id":"289","product_id":"1121","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":"102123","customer_id":"102123","source_of_creation":"PMS","reservation_created_date":"2020-06-06 13:57:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3136731","reservation_id":"100345","confirmation_number":"PB12385154128","room_stay_from":"2020-09-25","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,140.00,96.90,96.90,96.90,96.90,96.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"764.50","grand_total":"863.89","paid_amount":"863.89","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":"106387","customer_id":"106387","source_of_creation":"PMS","reservation_created_date":"2020-09-13 18:07:21","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":"96.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3138394","reservation_id":"84128","confirmation_number":"PB12396525990","room_stay_from":"2020-09-20","room_stay_to":"2020-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"79.00,79.00,79.00,79.00,79.00,79.00,79.00,79.00,79.00,79.00,79.00,79.00,79.00","nightly_discount":"0.00,53.02,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1027.00","grand_total":"1100.60","paid_amount":"1100.60","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"75193","customer_id":"75193","source_of_creation":"PMS","reservation_created_date":"2019-09-15 14:10:05","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":"79.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3140350","reservation_id":"100935","confirmation_number":"PB12312033198","room_stay_from":"2020-09-28","room_stay_to":"2020-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"162.31,162.31,162.31,162.31,221.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"870.24","grand_total":"983.37","paid_amount":"983.37","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":"106971","customer_id":"106971","source_of_creation":"PMS","reservation_created_date":"2020-09-28 21:13:25","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":"162.31","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3140370","reservation_id":"100936","confirmation_number":"PB12312156125","room_stay_from":"2020-09-28","room_stay_to":"2020-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.97,104.97,104.97,104.97,150.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"569.88","grand_total":"643.96","paid_amount":"643.96","room_type_id":"289","product_id":"1105","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106713","customer_id":"106713","source_of_creation":"PMS","reservation_created_date":"2020-09-28 21:19:16","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.97","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3136987","reservation_id":"100378","confirmation_number":"PB12340905275","room_stay_from":"2020-09-25","room_stay_to":"2020-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,147.00,96.90,96.90,96.90,96.90,96.90,140.00,140.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1171.50","grand_total":"1323.80","paid_amount":"1323.80","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":"89847","customer_id":"89847","source_of_creation":"PMS","reservation_created_date":"2020-09-14 17:42:37","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":"96.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3140799","reservation_id":"99460","confirmation_number":"BP12565779366","room_stay_from":"2020-10-10","room_stay_to":"2020-10-17","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.50,121.50,121.50,121.50,121.50,121.50,155.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"840.00","grand_total":"949.20","paid_amount":"0.00","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":"90253","customer_id":"90253","source_of_creation":"PMS","reservation_created_date":"2020-08-24 17:09:54","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":"","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":"3140880","reservation_id":"100718","confirmation_number":"BP12528707679","room_stay_from":"2020-12-24","room_stay_to":"2021-01-03","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,149.00,149.00,129.00,129.00,129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"1330.00","grand_total":"1502.90","paid_amount":"145.77","room_type_id":"301","product_id":"1137","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":"48130","customer_id":"48130","source_of_creation":"PMS","reservation_created_date":"2020-09-22 21:56:21","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 824","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":"3140059","reservation_id":"100893","confirmation_number":"PB12230868810","room_confirmation_number":"PB12380373351","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Active","nightly_price":"10.00,10.00","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"106935","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-09-27 17:56:00","reservation_modified_date_time":"2020-09-27 17:56:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106935","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3140831","reservation_id":"100083","confirmation_number":"BP12257301636","room_confirmation_number":"BP12553703463","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"20.00","paid_amount":"20.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"107042","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-09-30 20:00:03","reservation_modified_date_time":"2020-09-30 20:00:03","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107042","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3136533","reservation_id":"100317","confirmation_number":"PB12242619076","room_confirmation_number":"PB12387801846","room_stay_from":"2020-09-28","room_stay_to":"2020-10-01","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"106967","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-12 19:34:10","reservation_modified_date_time":"2020-09-12 19:34:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106967","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.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":"3139351","reservation_id":"93983","confirmation_number":"PB12231759164","room_confirmation_number":"PB12371702445","room_stay_from":"2020-09-24","room_stay_to":"2020-10-01","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","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"106815","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-19 18:51:10","reservation_modified_date_time":"2020-09-24 17:39:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106815","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"20.00","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":"3139382","reservation_id":"95987","confirmation_number":"PB12257644661","room_confirmation_number":"PB12384805857","room_stay_from":"2020-09-24","room_stay_to":"2020-10-01","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":"102123","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-06-06 13:57:08","reservation_modified_date_time":"2020-09-24 20:14:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102123","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":"3140603","reservation_id":"100459","confirmation_number":"BV12270159510","room_confirmation_number":"BV12489714638","room_stay_from":"2020-09-29","room_stay_to":"2020-10-01","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":"107012","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-16 21:12:10","reservation_modified_date_time":"2020-09-29 19:52:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107012","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3140615","reservation_id":"100977","confirmation_number":"BV12273726761","room_confirmation_number":"BV12492560353","room_stay_from":"2020-09-29","room_stay_to":"2020-10-01","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":"107016","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-29 19:51:07","reservation_modified_date_time":"2020-09-29 20:50:39","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107016","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":"3140703","reservation_id":"100992","confirmation_number":"BP12291612578","room_confirmation_number":"BP12593887254","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","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":"107047","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-30 12:06:07","reservation_modified_date_time":"2020-09-30 12:06:07","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107047","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3140859","reservation_id":"101004","confirmation_number":"PB12280650254","room_confirmation_number":"PB12348086261","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","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":"107050","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-30 20:02:11","reservation_modified_date_time":"2020-09-30 20:45:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107050","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":"3140912","reservation_id":"101009","confirmation_number":"BP12245399379","room_confirmation_number":"BP12571904008","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","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":"107063","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-30 20:57:11","reservation_modified_date_time":"2020-10-01 00:11:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107063","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":"3140918","reservation_id":"101014","confirmation_number":"BP12283311163","room_confirmation_number":"BP12554127966","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","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":"107065","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-30 23:27:10","reservation_modified_date_time":"2020-10-01 00:35:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107065","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":"3136732","reservation_id":"100345","confirmation_number":"PB12247374305","room_confirmation_number":"PB12385154128","room_stay_from":"2020-09-25","room_stay_to":"2020-10-02","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":"106387","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-13 18:07:21","reservation_modified_date_time":"2020-09-13 18:07:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106387","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":"3140058","reservation_id":"100893","confirmation_number":"PB12252484114","room_confirmation_number":"PB12380373351","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","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":"106935","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-27 17:56:00","reservation_modified_date_time":"2020-09-27 17:56:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106935","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":"3140439","reservation_id":"100951","confirmation_number":"BV12287715091","room_confirmation_number":"BV12453892953","room_stay_from":"2020-09-28","room_stay_to":"2020-10-02","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":"106989","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-29 00:00:09","reservation_modified_date_time":"2020-09-29 01:38:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106989","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":"3140579","reservation_id":"100737","confirmation_number":"PB12212644308","room_confirmation_number":"PB12367802940","room_stay_from":"2020-09-29","room_stay_to":"2020-10-02","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"106982","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-23 17:42:05","reservation_modified_date_time":"2020-09-29 18:35:29","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106982","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":"3140804","reservation_id":"100180","confirmation_number":"PB12246176163","room_confirmation_number":"PB12351189672","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","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":"107038","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-09 20:03:10","reservation_modified_date_time":"2020-09-30 17:48:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107038","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":"3140832","reservation_id":"100083","confirmation_number":"BP12297696095","room_confirmation_number":"BP12553703463","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","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":"107042","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-07 01:57:05","reservation_modified_date_time":"2020-09-30 20:00:05","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107042","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3140900","reservation_id":"101000","confirmation_number":"PB12285426634","room_confirmation_number":"PB12313319706","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","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":"107058","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-30 18:12:11","reservation_modified_date_time":"2020-09-30 23:00:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107058","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":"3140916","reservation_id":"101005","confirmation_number":"BV12252321946","room_confirmation_number":"BV12471557964","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","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":"107064","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-30 20:06:06","reservation_modified_date_time":"2020-10-01 00:32:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107064","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":"3140924","reservation_id":"100531","confirmation_number":"BP12254669353","room_confirmation_number":"BP12552219344","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","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":"107067","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-18 14:37:11","reservation_modified_date_time":"2020-10-01 02:30:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107067","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":"3138395","reservation_id":"84128","confirmation_number":"PB12260679978","room_confirmation_number":"PB12396525990","room_stay_from":"2020-09-20","room_stay_to":"2020-10-03","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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"75193","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-15 14:10:05","reservation_modified_date_time":"2020-09-20 16:13:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75193","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":"3138774","reservation_id":"100689","confirmation_number":"PB12212152796","room_confirmation_number":"PB12335334409","room_stay_from":"2020-09-27","room_stay_to":"2020-10-03","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":"106712","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-21 22:02:08","reservation_modified_date_time":"2020-09-21 22:02:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106712","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":"3139795","reservation_id":"100057","confirmation_number":"PB12299894367","room_confirmation_number":"PB12392149622","room_stay_from":"2020-09-26","room_stay_to":"2020-10-03","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":"106899","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-06 15:31:11","reservation_modified_date_time":"2020-09-26 18:23:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106899","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":"3140351","reservation_id":"100935","confirmation_number":"PB12222734779","room_confirmation_number":"PB12312033198","room_stay_from":"2020-09-28","room_stay_to":"2020-10-03","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":"106971","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-28 21:13:25","reservation_modified_date_time":"2020-09-28 21:13:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106971","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":"3140371","reservation_id":"100936","confirmation_number":"PB12261319842","room_confirmation_number":"PB12312156125","room_stay_from":"2020-09-28","room_stay_to":"2020-10-03","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":"106713","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-28 21:19:16","reservation_modified_date_time":"2020-09-28 22:07:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106713","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":"3140841","reservation_id":"100816","confirmation_number":"PB12253355357","room_confirmation_number":"PB12390442844","room_stay_from":"2020-09-30","room_stay_to":"2020-10-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"107048","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-25 20:47:08","reservation_modified_date_time":"2020-09-30 20:35:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107048","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":"3125926","reservation_id":"98948","confirmation_number":"PB12267898890","room_confirmation_number":"PB12386665028","room_stay_from":"2020-09-30","room_stay_to":"2020-10-04","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":"104934","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-12 21:27:36","reservation_modified_date_time":"2020-08-12 21:27:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104934","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":"3136988","reservation_id":"100378","confirmation_number":"PB12259962716","room_confirmation_number":"PB12340905275","room_stay_from":"2020-09-25","room_stay_to":"2020-10-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"89847","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-14 17:42:37","reservation_modified_date_time":"2020-09-14 17:42:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89847","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":"3140800","reservation_id":"99460","confirmation_number":"BP12253632399","room_confirmation_number":"BP12565779366","room_stay_from":"2020-10-10","room_stay_to":"2020-10-17","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"90253","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-24 17:09:54","reservation_modified_date_time":"2020-09-30 17:17:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90253","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":"3140881","reservation_id":"100718","confirmation_number":"BP12249739812","room_confirmation_number":"BP12528707679","room_stay_from":"2020-12-24","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"48130","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-22 21:56:21","reservation_modified_date_time":"2020-09-30 21:52:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"48130","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":"3140812","reservation_id":"101001","confirmation_number":"PB12281427858","room_confirmation_number":"PB12315291146","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-30 18:25:15","reservation_modified_date_time":"2020-09-30 18:25:15","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":"3140933","reservation_id":"101020","confirmation_number":"PB12270428453","room_confirmation_number":"PB12339644049","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.00","grand_total":"2.14","paid_amount":"2.14","product_id":"1175","service_quantity":"2","product_name":"Miscellaneous","parentTypeOfRes":"reservation","reservation_created_date":"2020-10-01 02:57:32","reservation_modified_date_time":"2020-10-01 02:57:32","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":"2.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120","departureCount":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":"3140805","reservation_id":"100180","confirmation_number":"PB12351189672","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.28,117.28","nightly_discount":"0,0","subtotal":"234.56","grand_total":"265.05","paid_amount":"265.05","room_type_id":"285","product_id":"1083","siteminder_id":"BDC-2940541602","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":"107038","customer_id":"107038","source_of_creation":"Booking.com","reservation_created_date":"2020-09-09 20:03:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"41.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.28","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":"3139352","reservation_id":"93983","confirmation_number":"PB12371702445","room_stay_from":"2020-09-24","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"221.00,234.00,234.00,221.00,221.00,221.00,221.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1573.00","grand_total":"1777.49","paid_amount":"1777.49","room_type_id":"287","product_id":"1089","siteminder_id":"EXP-1661346921","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":"106815","customer_id":"106815","source_of_creation":"Expedia","reservation_created_date":"2020-04-19 18:51: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":"221.00","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":"3140860","reservation_id":"101004","confirmation_number":"PB12348086261","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"75.63","nightly_discount":"0","subtotal":"75.63","grand_total":"85.46","paid_amount":"85.46","room_type_id":"292","product_id":"1120","siteminder_id":"EXP-1703743888","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":"107050","customer_id":"107050","source_of_creation":"Expedia","reservation_created_date":"2020-09-30 20:02:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.63","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":"3140580","reservation_id":"100737","confirmation_number":"PB12367802940","room_stay_from":"2020-09-29","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.05,161.05,161.05","nightly_discount":"0,0,0","subtotal":"483.15","grand_total":"545.96","paid_amount":"545.96","room_type_id":"287","product_id":"1087","siteminder_id":"EXP-1701613318","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":"106982","customer_id":"106982","source_of_creation":"Expedia","reservation_created_date":"2020-09-23 17:42:05","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":"161.05","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":"3140902","reservation_id":"101000","confirmation_number":"PB12313319706","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"66.76,66.76","nightly_discount":"0,0","subtotal":"133.52","grand_total":"150.88","paid_amount":"150.88","room_type_id":"304","product_id":"1219","siteminder_id":"EXP-1703714058","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":"107058","customer_id":"107058","source_of_creation":"Expedia","reservation_created_date":"2020-09-30 18:12:11","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":"66.76","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":"3138773","reservation_id":"100689","confirmation_number":"PB12335334409","room_stay_from":"2020-09-27","room_stay_to":"2020-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"93.37,93.37,93.37,93.37,93.37,126.17","nightly_discount":"0,0,0,0,0,0","subtotal":"593.02","grand_total":"670.11","paid_amount":"670.11","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1701066375","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":"106712","customer_id":"106712","source_of_creation":"Expedia","reservation_created_date":"2020-09-21 22:02:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"93.37","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":"3139796","reservation_id":"100057","confirmation_number":"PB12392149622","room_stay_from":"2020-09-26","room_stay_to":"2020-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"252.00,202.30,202.30,202.30,202.30,202.30,252.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1515.50","grand_total":"1712.52","paid_amount":"1712.52","room_type_id":"287","product_id":"1088","siteminder_id":"EXP-1696464962","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":"106899","customer_id":"106899","source_of_creation":"Expedia","reservation_created_date":"2020-09-06 15:31:11","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":"202.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"}]},{"room_stay_id":"3140842","reservation_id":"100816","confirmation_number":"PB12390442844","room_stay_from":"2020-09-30","room_stay_to":"2020-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.79,123.79,167.30","nightly_discount":"0,0,0","subtotal":"414.88","grand_total":"468.81","paid_amount":"468.81","room_type_id":"289","product_id":"1094","siteminder_id":"EXP-1702302158","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":"107048","customer_id":"107048","source_of_creation":"Expedia","reservation_created_date":"2020-09-25 20:47:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"123.79","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":[{"room_stay_id":"3136532","reservation_id":"100317","confirmation_number":"PB12387801846","room_stay_from":"2020-09-28","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.89,103.89,103.89","nightly_discount":"0,0,0","subtotal":"311.67","grand_total":"406.66","paid_amount":"406.66","room_type_id":"285","product_id":"1085","siteminder_id":"ABB-HM8J8YD9R8","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"311.67","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106967","customer_id":"106967","source_of_creation":"Airbnb","reservation_created_date":"2020-09-12 19:34:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"43.57","commision_charges":"9.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103.89","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3140057","reservation_id":"100893","confirmation_number":"PB12380373351","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"113.05,113.05","nightly_discount":"0.00,0.00","subtotal":"226.10","grand_total":"255.50","paid_amount":"255.50","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":"106935","customer_id":"106935","source_of_creation":"FE","reservation_created_date":"2020-09-27 17:56:00","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":"113.05","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3125925","reservation_id":"98948","confirmation_number":"PB12386665028","room_stay_from":"2020-09-30","room_stay_to":"2020-10-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,150.00,150.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"560.00","grand_total":"632.80","paid_amount":"632.80","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104934","customer_id":"104934","source_of_creation":"FE","reservation_created_date":"2020-08-12 21:27:36","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":"130.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[{"room_stay_id":"3096965","reservation_id":"87998","confirmation_number":"PB12392540005","room_stay_from":"2020-09-30","room_stay_to":"2020-10-05","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"246.34","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":"94372","customer_id":"94372","source_of_creation":"FE","reservation_created_date":"2019-12-07 19:11:48","service_canceled_date_time":"2020-07-21 15:50:51","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"246.34","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3139381","reservation_id":"95987","confirmation_number":"PB12384805857","room_stay_from":"2020-09-24","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.00,158.00,158.00,138.00,138.00,138.00,138.00","nightly_discount":"0.00,47.58,0.00,0.00,0.00,0.00,0.00","subtotal":"1006.00","grand_total":"1083.02","paid_amount":"1083.02","room_type_id":"289","product_id":"1121","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":"102123","customer_id":"102123","source_of_creation":"PMS","reservation_created_date":"2020-06-06 13:57:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3136731","reservation_id":"100345","confirmation_number":"PB12385154128","room_stay_from":"2020-09-25","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,140.00,96.90,96.90,96.90,96.90,96.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"764.50","grand_total":"863.89","paid_amount":"863.89","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":"106387","customer_id":"106387","source_of_creation":"PMS","reservation_created_date":"2020-09-13 18:07:21","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":"96.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3138394","reservation_id":"84128","confirmation_number":"PB12396525990","room_stay_from":"2020-09-20","room_stay_to":"2020-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"79.00,79.00,79.00,79.00,79.00,79.00,79.00,79.00,79.00,79.00,79.00,79.00,79.00","nightly_discount":"0.00,53.02,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1027.00","grand_total":"1100.60","paid_amount":"1100.60","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"75193","customer_id":"75193","source_of_creation":"PMS","reservation_created_date":"2019-09-15 14:10:05","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":"79.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3140350","reservation_id":"100935","confirmation_number":"PB12312033198","room_stay_from":"2020-09-28","room_stay_to":"2020-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"162.31,162.31,162.31,162.31,221.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"870.24","grand_total":"983.37","paid_amount":"983.37","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":"106971","customer_id":"106971","source_of_creation":"PMS","reservation_created_date":"2020-09-28 21:13:25","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":"162.31","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3140370","reservation_id":"100936","confirmation_number":"PB12312156125","room_stay_from":"2020-09-28","room_stay_to":"2020-10-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.97,104.97,104.97,104.97,150.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"569.88","grand_total":"643.96","paid_amount":"643.96","room_type_id":"289","product_id":"1105","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106713","customer_id":"106713","source_of_creation":"PMS","reservation_created_date":"2020-09-28 21:19:16","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.97","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3136987","reservation_id":"100378","confirmation_number":"PB12340905275","room_stay_from":"2020-09-25","room_stay_to":"2020-10-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,147.00,96.90,96.90,96.90,96.90,96.90,140.00,140.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1171.50","grand_total":"1323.80","paid_amount":"1323.80","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":"89847","customer_id":"89847","source_of_creation":"PMS","reservation_created_date":"2020-09-14 17:42:37","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":"96.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3140059","reservation_id":"100893","confirmation_number":"PB12230868810","room_confirmation_number":"PB12380373351","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Active","nightly_price":"10.00,10.00","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"106935","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-09-27 17:56:00","reservation_modified_date_time":"2020-09-27 17:56:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106935","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3136533","reservation_id":"100317","confirmation_number":"PB12242619076","room_confirmation_number":"PB12387801846","room_stay_from":"2020-09-28","room_stay_to":"2020-10-01","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"106967","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-12 19:34:10","reservation_modified_date_time":"2020-09-12 19:34:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106967","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3139351","reservation_id":"93983","confirmation_number":"PB12231759164","room_confirmation_number":"PB12371702445","room_stay_from":"2020-09-24","room_stay_to":"2020-10-01","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","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"106815","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-19 18:51:10","reservation_modified_date_time":"2020-09-24 17:39:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106815","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"20.00","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":"3139382","reservation_id":"95987","confirmation_number":"PB12257644661","room_confirmation_number":"PB12384805857","room_stay_from":"2020-09-24","room_stay_to":"2020-10-01","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":"102123","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-06-06 13:57:08","reservation_modified_date_time":"2020-09-24 20:14:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102123","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":"3140859","reservation_id":"101004","confirmation_number":"PB12280650254","room_confirmation_number":"PB12348086261","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","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":"107050","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-30 20:02:11","reservation_modified_date_time":"2020-09-30 20:45:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107050","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":"3136732","reservation_id":"100345","confirmation_number":"PB12247374305","room_confirmation_number":"PB12385154128","room_stay_from":"2020-09-25","room_stay_to":"2020-10-02","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":"106387","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-13 18:07:21","reservation_modified_date_time":"2020-09-13 18:07:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106387","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":"3140058","reservation_id":"100893","confirmation_number":"PB12252484114","room_confirmation_number":"PB12380373351","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","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":"106935","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-27 17:56:00","reservation_modified_date_time":"2020-09-27 17:56:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106935","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":"3140579","reservation_id":"100737","confirmation_number":"PB12212644308","room_confirmation_number":"PB12367802940","room_stay_from":"2020-09-29","room_stay_to":"2020-10-02","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"106982","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-23 17:42:05","reservation_modified_date_time":"2020-09-29 18:35:29","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106982","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":"3140804","reservation_id":"100180","confirmation_number":"PB12246176163","room_confirmation_number":"PB12351189672","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","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":"107038","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-09 20:03:10","reservation_modified_date_time":"2020-09-30 17:48:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107038","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":"3140900","reservation_id":"101000","confirmation_number":"PB12285426634","room_confirmation_number":"PB12313319706","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","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":"107058","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-30 18:12:11","reservation_modified_date_time":"2020-09-30 23:00:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107058","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":"3138395","reservation_id":"84128","confirmation_number":"PB12260679978","room_confirmation_number":"PB12396525990","room_stay_from":"2020-09-20","room_stay_to":"2020-10-03","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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"75193","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-15 14:10:05","reservation_modified_date_time":"2020-09-20 16:13:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75193","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":"3138774","reservation_id":"100689","confirmation_number":"PB12212152796","room_confirmation_number":"PB12335334409","room_stay_from":"2020-09-27","room_stay_to":"2020-10-03","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":"106712","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-21 22:02:08","reservation_modified_date_time":"2020-09-21 22:02:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106712","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":"3139795","reservation_id":"100057","confirmation_number":"PB12299894367","room_confirmation_number":"PB12392149622","room_stay_from":"2020-09-26","room_stay_to":"2020-10-03","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":"106899","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-06 15:31:11","reservation_modified_date_time":"2020-09-26 18:23:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106899","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":"3140351","reservation_id":"100935","confirmation_number":"PB12222734779","room_confirmation_number":"PB12312033198","room_stay_from":"2020-09-28","room_stay_to":"2020-10-03","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":"106971","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-28 21:13:25","reservation_modified_date_time":"2020-09-28 21:13:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106971","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":"3140371","reservation_id":"100936","confirmation_number":"PB12261319842","room_confirmation_number":"PB12312156125","room_stay_from":"2020-09-28","room_stay_to":"2020-10-03","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":"106713","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-28 21:19:16","reservation_modified_date_time":"2020-09-28 22:07:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106713","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":"3140841","reservation_id":"100816","confirmation_number":"PB12253355357","room_confirmation_number":"PB12390442844","room_stay_from":"2020-09-30","room_stay_to":"2020-10-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"107048","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-25 20:47:08","reservation_modified_date_time":"2020-09-30 20:35:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107048","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":"3125926","reservation_id":"98948","confirmation_number":"PB12267898890","room_confirmation_number":"PB12386665028","room_stay_from":"2020-09-30","room_stay_to":"2020-10-04","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":"104934","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-12 21:27:36","reservation_modified_date_time":"2020-08-12 21:27:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104934","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":"3136988","reservation_id":"100378","confirmation_number":"PB12259962716","room_confirmation_number":"PB12340905275","room_stay_from":"2020-09-25","room_stay_to":"2020-10-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"89847","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-14 17:42:37","reservation_modified_date_time":"2020-09-14 17:42:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89847","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3140812","reservation_id":"101001","confirmation_number":"PB12281427858","room_confirmation_number":"PB12315291146","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-30 18:25:15","reservation_modified_date_time":"2020-09-30 18:25:15","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":"3140933","reservation_id":"101020","confirmation_number":"PB12270428453","room_confirmation_number":"PB12339644049","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.00","grand_total":"2.14","paid_amount":"2.14","product_id":"1175","service_quantity":"2","product_name":"Miscellaneous","parentTypeOfRes":"reservation","reservation_created_date":"2020-10-01 02:57:32","reservation_modified_date_time":"2020-10-01 02:57:32","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":"2.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":0,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3140616","reservation_id":"100977","confirmation_number":"BV12492560353","room_stay_from":"2020-09-29","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"56.72,56.72","nightly_discount":"0,0","subtotal":"113.44","grand_total":"128.19","paid_amount":"128.19","room_type_id":"307","product_id":"1224","siteminder_id":"HTN-139802294-CCT9LZ","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":"107016","customer_id":"107016","source_of_creation":"HotelTonight","reservation_created_date":"2020-09-29 19:51:07","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"56.72","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":"3140438","reservation_id":"100951","confirmation_number":"BV12453892953","room_stay_from":"2020-09-28","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"63.03,63.03,63.03,63.03","nightly_discount":"0.00,0.00,0.00,11.00","subtotal":"252.12","grand_total":"272.47","paid_amount":"272.47","room_type_id":"306","product_id":"1223","siteminder_id":"HTN-139724522-4PLDCP","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":"106989","customer_id":"106989","source_of_creation":"HotelTonight","reservation_created_date":"2020-09-29 00:00:09","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":"63.03","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3140917","reservation_id":"101005","confirmation_number":"BV12471557964","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"51.05,51.05","nightly_discount":"0,0","subtotal":"102.10","grand_total":"115.38","paid_amount":"115.38","room_type_id":"303","product_id":"1139","siteminder_id":"HTN-139893247-RGGXJJ","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":"107064","customer_id":"107064","source_of_creation":"HotelTonight","reservation_created_date":"2020-09-30 20:06:06","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":"51.05","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":[{"room_stay_id":"3140602","reservation_id":"100459","confirmation_number":"BV12489714638","room_stay_from":"2020-09-29","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.83,76.83","nightly_discount":"0,0","subtotal":"153.66","grand_total":"200.48","paid_amount":"200.48","room_type_id":"289","product_id":"1101","siteminder_id":"ABB-HM8YC9PXSJ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"153.66","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107012","customer_id":"107012","source_of_creation":"Airbnb","reservation_created_date":"2020-09-16 21:12:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"21.48","commision_charges":"4.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"76.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"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":"104.00","currentDayDiscount":"50.07","productIsTaxExempt":false,"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":"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":"3140603","reservation_id":"100459","confirmation_number":"BV12270159510","room_confirmation_number":"BV12489714638","room_stay_from":"2020-09-29","room_stay_to":"2020-10-01","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":"107012","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-16 21:12:10","reservation_modified_date_time":"2020-09-29 19:52:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107012","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3140615","reservation_id":"100977","confirmation_number":"BV12273726761","room_confirmation_number":"BV12492560353","room_stay_from":"2020-09-29","room_stay_to":"2020-10-01","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":"107016","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-29 19:51:07","reservation_modified_date_time":"2020-09-29 20:50:39","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107016","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":"3140439","reservation_id":"100951","confirmation_number":"BV12287715091","room_confirmation_number":"BV12453892953","room_stay_from":"2020-09-28","room_stay_to":"2020-10-02","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":"106989","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-29 00:00:09","reservation_modified_date_time":"2020-09-29 01:38:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106989","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":"3140916","reservation_id":"101005","confirmation_number":"BV12252321946","room_confirmation_number":"BV12471557964","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","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":"107064","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-30 20:06:06","reservation_modified_date_time":"2020-10-01 00:32:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107064","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":0,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1127","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BP12232481298","room_stay_from":"2020-09-29","room_stay_to":"2020-10-01","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3140925","reservation_id":"100531","confirmation_number":"BP12552219344","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"72.38,72.38","nightly_discount":"0,0","subtotal":"144.76","grand_total":"163.58","paid_amount":"163.58","room_type_id":"299","product_id":"1134","siteminder_id":"BDC-2566048724","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":"107067","customer_id":"107067","source_of_creation":"Booking.com","reservation_created_date":"2020-09-18 14:37:11","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"33.26","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"72.38","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":"3140919","reservation_id":"101014","confirmation_number":"BP12554127966","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"57.58","nightly_discount":"0","subtotal":"57.58","grand_total":"65.06","paid_amount":"65.06","room_type_id":"295","product_id":"1129","siteminder_id":"EXP-1703799038","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":"107065","customer_id":"107065","source_of_creation":"Expedia","reservation_created_date":"2020-09-30 23:27:10","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":"57.58","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":[{"room_stay_id":"3140702","reservation_id":"100992","confirmation_number":"BP12593887254","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"74.69","nightly_discount":"0","subtotal":"74.69","grand_total":"97.45","paid_amount":"97.45","room_type_id":"298","product_id":"1133","siteminder_id":"ABB-HMQ25SBRDQ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"74.69","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107047","customer_id":"107047","source_of_creation":"Airbnb","reservation_created_date":"2020-09-30 12:06:07","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"10.44","commision_charges":"2.31","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"74.69","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]},{"room_stay_id":"3140830","reservation_id":"100083","confirmation_number":"BP12553703463","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"89.33,89.33","nightly_discount":"0.00,0.00","subtotal":"178.66","grand_total":"239.20","paid_amount":"239.20","room_type_id":"293","product_id":"1124","siteminder_id":"ABB-HM5XHDDET4","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"178.66","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107042","customer_id":"107042","source_of_creation":"Airbnb","reservation_created_date":"2020-09-07 01:57:05","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"27.77","commision_charges":"6.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.33","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3140913","reservation_id":"101009","confirmation_number":"BP12571904008","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"63.83","nightly_discount":"0.00","subtotal":"63.83","grand_total":"72.13","paid_amount":"72.13","room_type_id":"295","product_id":"1128","siteminder_id":"AGO-346063814","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":"107063","customer_id":"107063","source_of_creation":"Agoda","reservation_created_date":"2020-09-30 20:57:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"63.83","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3140799","reservation_id":"99460","confirmation_number":"BP12565779366","room_stay_from":"2020-10-10","room_stay_to":"2020-10-17","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.50,121.50,121.50,121.50,121.50,121.50,155.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"840.00","grand_total":"949.20","paid_amount":"0.00","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":"90253","customer_id":"90253","source_of_creation":"PMS","reservation_created_date":"2020-08-24 17:09:54","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":"","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":"3140880","reservation_id":"100718","confirmation_number":"BP12528707679","room_stay_from":"2020-12-24","room_stay_to":"2021-01-03","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,149.00,149.00,129.00,129.00,129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"1330.00","grand_total":"1502.90","paid_amount":"145.77","room_type_id":"301","product_id":"1137","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":"48130","customer_id":"48130","source_of_creation":"PMS","reservation_created_date":"2020-09-22 21:56:21","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 824","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":"3140831","reservation_id":"100083","confirmation_number":"BP12257301636","room_confirmation_number":"BP12553703463","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"20.00","paid_amount":"20.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"107042","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-09-30 20:00:03","reservation_modified_date_time":"2020-09-30 20:00:03","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107042","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3140703","reservation_id":"100992","confirmation_number":"BP12291612578","room_confirmation_number":"BP12593887254","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","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":"107047","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-30 12:06:07","reservation_modified_date_time":"2020-09-30 12:06:07","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107047","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3140912","reservation_id":"101009","confirmation_number":"BP12245399379","room_confirmation_number":"BP12571904008","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","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":"107063","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-30 20:57:11","reservation_modified_date_time":"2020-10-01 00:11:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107063","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":"3140918","reservation_id":"101014","confirmation_number":"BP12283311163","room_confirmation_number":"BP12554127966","room_stay_from":"2020-09-30","room_stay_to":"2020-10-01","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":"107065","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-30 23:27:10","reservation_modified_date_time":"2020-10-01 00:35:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107065","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":"3140832","reservation_id":"100083","confirmation_number":"BP12297696095","room_confirmation_number":"BP12553703463","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","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":"107042","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-07 01:57:05","reservation_modified_date_time":"2020-09-30 20:00:05","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107042","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","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3140924","reservation_id":"100531","confirmation_number":"BP12254669353","room_confirmation_number":"BP12552219344","room_stay_from":"2020-09-30","room_stay_to":"2020-10-02","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":"107067","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-18 14:37:11","reservation_modified_date_time":"2020-10-01 02:30:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107067","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":"3140800","reservation_id":"99460","confirmation_number":"BP12253632399","room_confirmation_number":"BP12565779366","room_stay_from":"2020-10-10","room_stay_to":"2020-10-17","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"90253","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-24 17:09:54","reservation_modified_date_time":"2020-09-30 17:17:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90253","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":"3140881","reservation_id":"100718","confirmation_number":"BP12249739812","room_confirmation_number":"BP12528707679","room_stay_from":"2020-12-24","room_stay_to":"2021-01-03","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"48130","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-22 21:56:21","reservation_modified_date_time":"2020-09-30 21:52:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"48130","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":[]}}}