{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-11-10","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":10,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1139,1223,1225,1135,1098,1086","block_room_bookings":[{"confirmation_number":"BV12288522299","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","bundle_room":"0"},{"confirmation_number":"BV12295275097","room_stay_from":"2020-11-08","room_stay_to":"2020-11-11","bundle_room":"0"},{"confirmation_number":"BV12292157753","room_stay_from":"2020-11-08","room_stay_to":"2020-11-11","bundle_room":"0"},{"confirmation_number":"BP12259465450","room_stay_from":"2020-11-09","room_stay_to":"2020-11-11","bundle_room":"0"},{"confirmation_number":"PB12253194092","room_stay_from":"2020-11-10","room_stay_to":"2020-11-12","bundle_room":"0"},{"confirmation_number":"PB12274981984","room_stay_from":"2020-11-06","room_stay_to":"2020-11-13","bundle_room":"0"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3153906","reservation_id":"102509","confirmation_number":"PB12386892133","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"109.83","nightly_discount":"0","subtotal":"109.83","grand_total":"124.11","paid_amount":"124.11","room_type_id":"289","product_id":"1093","siteminder_id":"BDC-3542472372","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108673","customer_id":"108673","source_of_creation":"Booking.com","reservation_created_date":"2020-11-10 23:40:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"20.97","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"109.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153760","reservation_id":"102007","confirmation_number":"PB12343364748","room_stay_from":"2020-11-09","room_stay_to":"2020-11-14","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"178.10,178.10,178.10,178.10,210.21","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"922.61","grand_total":"1042.55","paid_amount":"1042.55","room_type_id":"288","product_id":"1091","siteminder_id":"BDC-2109245666","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":"108653","customer_id":"108653","source_of_creation":"Booking.com","reservation_created_date":"2020-10-27 22:30:08","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"153.39","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"178.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3152893","reservation_id":"100526","confirmation_number":"PB12328042110","room_stay_from":"2020-11-07","room_stay_to":"2020-11-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.20,128.46,128.46,128.46,128.46,128.46,154.22","nightly_discount":"0,0,0,0,0,0,0","subtotal":"936.72","grand_total":"1058.49","paid_amount":"1058.49","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1700110660","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":"108552","customer_id":"108552","source_of_creation":"Expedia","reservation_created_date":"2020-09-18 13:37:05","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":"128.46","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":[{"room_stay_id":"3153849","reservation_id":"102501","confirmation_number":"BP12560147212","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"61.96","nightly_discount":"0","subtotal":"61.96","grand_total":"70.02","paid_amount":"70.02","room_type_id":"295","product_id":"1128","siteminder_id":"GAM-R2205939102","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":"108665","customer_id":"108665","source_of_creation":"Getaroom.com","reservation_created_date":"2020-11-10 19:47: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":"61.96","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":"3153378","reservation_id":"102325","confirmation_number":"PB12370981700","room_stay_from":"2020-11-08","room_stay_to":"2020-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.99,84.99,84.99,84.99,84.99","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"424.95","grand_total":"480.20","paid_amount":"480.20","room_type_id":"291","product_id":"1117","siteminder_id":"GAM-R2199606915","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":"108487","customer_id":"108487","source_of_creation":"Getaroom.com","reservation_created_date":"2020-11-05 19:34:10","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3153465","reservation_id":"102457","confirmation_number":"BP12565008647","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.57","nightly_discount":"0","subtotal":"78.57","grand_total":"102.51","paid_amount":"102.51","room_type_id":"293","product_id":"1124","siteminder_id":"ABB-HMWSDWYFNM","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"78.57","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108667","customer_id":"108667","source_of_creation":"Airbnb","reservation_created_date":"2020-11-09 14:43:09","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"10.98","commision_charges":"2.43","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.57","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":"3153693","reservation_id":"102476","confirmation_number":"PB12350634701","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"108.64","nightly_discount":"0","subtotal":"108.64","grand_total":"141.75","paid_amount":"141.75","room_type_id":"285","product_id":"1083","siteminder_id":"ABB-HMTETE5F2E","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"108.64","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108637","customer_id":"108637","source_of_creation":"Airbnb","reservation_created_date":"2020-11-09 23:37:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"15.19","commision_charges":"3.36","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"108.64","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":"3153857","reservation_id":"102503","confirmation_number":"BV12440708620","room_stay_from":"2020-11-10","room_stay_to":"2020-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"80.51,80.51","nightly_discount":"0,0","subtotal":"161.02","grand_total":"210.09","paid_amount":"210.09","room_type_id":"303","product_id":"1140","siteminder_id":"ABB-HMFXCFC83P","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"161.02","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108669","customer_id":"108669","source_of_creation":"Airbnb","reservation_created_date":"2020-11-10 20:26:12","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"22.51","commision_charges":"4.98","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"80.51","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":[{"room_stay_id":"3153546","reservation_id":"102075","confirmation_number":"PB12396161443","room_stay_from":"2020-11-09","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.26,118.26","nightly_discount":"0,0","subtotal":"236.52","grand_total":"267.27","paid_amount":"267.27","room_type_id":"289","product_id":"1094","siteminder_id":"AGO-351943862","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":"108628","customer_id":"108628","source_of_creation":"Agoda","reservation_created_date":"2020-10-29 19:37:07","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":"118.26","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3142781","reservation_id":"99485","confirmation_number":"PB12348758366","room_stay_from":"2020-11-08","room_stay_to":"2020-11-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.00,201.00,201.00,221.00,221.00,221.00,221.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0,0","subtotal":"1487.00","grand_total":"1680.31","paid_amount":"1680.31","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108620","customer_id":"80391","source_of_creation":"FE","reservation_created_date":"2020-08-25 03:29:00","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":"201.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153428","reservation_id":"99623","confirmation_number":"PB12353280966","room_stay_from":"2020-11-08","room_stay_to":"2020-11-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,150.00,150.00,150.00,150.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0,0","subtotal":"990.00","grand_total":"1118.70","paid_amount":"1118.70","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"105619","customer_id":"105619","source_of_creation":"FE","reservation_created_date":"2020-08-27 23:34:46","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3151109","reservation_id":"101364","confirmation_number":"PB12312386470","room_stay_from":"2020-11-10","room_stay_to":"2020-11-14","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"520.00","grand_total":"587.60","paid_amount":"146.90","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107440","customer_id":"107440","source_of_creation":"FE","reservation_created_date":"2020-10-10 03:05:57","service_canceled_date_time":"2020-11-09 21:55:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"146.90","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3150708","reservation_id":"91584","confirmation_number":"PB12375439425","room_stay_from":"2020-10-31","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,120.00,120.00,120.00,140.00,140.00,120.00,120.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,62.04,0.00,75.60,75.60","subtotal":"1380.00","grand_total":"1318.44","paid_amount":"1318.44","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"42262","customer_id":"42262","source_of_creation":"PMS","reservation_created_date":"2020-02-08 17:30:36","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.00","currentDayDiscount":"75.60","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3150712","reservation_id":"91586","confirmation_number":"PB12384711874","room_stay_from":"2020-10-31","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,108.00,108.00,108.00,126.00,126.00,108.00,108.00,108.00,108.00,108.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,62.70,0.00,0.00","subtotal":"1242.00","grand_total":"1332.61","paid_amount":"1332.61","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":"91826","customer_id":"91826","source_of_creation":"PMS","reservation_created_date":"2020-02-08 17:37:57","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":"108.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153443","reservation_id":"102456","confirmation_number":"BP12580166232","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.08","nightly_discount":"0.00","subtotal":"69.08","grand_total":"78.06","paid_amount":"78.06","room_type_id":"299","product_id":"1134","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":"108605","customer_id":"108605","source_of_creation":"PMS","reservation_created_date":"2020-11-09 14:22:57","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.08","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153474","reservation_id":"102458","confirmation_number":"BV12433348565","room_stay_from":"2020-11-09","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.34,105.34","nightly_discount":"0.00,0.00","subtotal":"210.68","grand_total":"238.07","paid_amount":"238.07","room_type_id":"304","product_id":"1218","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107879","customer_id":"107879","source_of_creation":"PMS","reservation_created_date":"2020-11-09 14:48:45","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153731","reservation_id":"102293","confirmation_number":"BP12514287329","room_stay_from":"2020-11-05","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.87,147.00,124.95,86.36,101.60,93.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"639.78","grand_total":"722.95","paid_amount":"722.95","room_type_id":"294","product_id":"1126","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":"108426","customer_id":"108426","source_of_creation":"PMS","reservation_created_date":"2020-11-04 18:33:50","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 806","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":"93.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153889","reservation_id":"102506","confirmation_number":"PB12348825314","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.76","nightly_discount":"0.00","subtotal":"95.76","grand_total":"108.21","paid_amount":"108.21","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":"108670","customer_id":"108670","source_of_creation":"PMS","reservation_created_date":"2020-11-10 21:53:56","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":"95.76","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153720","reservation_id":"102485","confirmation_number":"PB12339193987","room_stay_from":"2020-11-09","room_stay_to":"2020-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,140.00,140.00","nightly_discount":"0.00,0,0","subtotal":"420.00","grand_total":"474.60","paid_amount":"474.60","room_type_id":"287","product_id":"1089","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108647","customer_id":"108647","source_of_creation":"PMS","reservation_created_date":"2020-11-10 01:08:15","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":"140.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":"3153899","reservation_id":"102440","confirmation_number":"BP12557861833","room_stay_from":"2020-11-10","room_stay_to":"2020-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"69.08,69.08","nightly_discount":"0.00,0","subtotal":"138.16","grand_total":"156.12","paid_amount":"156.12","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106193","customer_id":"106193","source_of_creation":"PMS","reservation_created_date":"2020-11-08 19:16:22","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","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":"69.08","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3151119","reservation_id":"101972","confirmation_number":"PB12315916994","room_stay_from":"2020-11-02","room_stay_to":"2020-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.00,90.00,90.00,90.00,140.00,140.00,120.00,120.00,120.00,120.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,0.00","subtotal":"1240.00","grand_total":"1401.20","paid_amount":"1401.20","room_type_id":"289","product_id":"1106","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":"69555","customer_id":"69555","source_of_creation":"PMS","reservation_created_date":"2020-10-26 22:15:27","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3152573","reservation_id":"102359","confirmation_number":"PB12358048208","room_stay_from":"2020-11-10","room_stay_to":"2020-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.60,173.60,173.60","nightly_discount":"0.00,0.00,0","subtotal":"520.80","grand_total":"588.51","paid_amount":"588.51","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108520","customer_id":"108520","source_of_creation":"PMS","reservation_created_date":"2020-11-06 17:39:53","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":"173.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153296","reservation_id":"102336","confirmation_number":"BP12563000759","room_stay_from":"2020-11-08","room_stay_to":"2020-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.58,83.00,75.00,88.92,88.92","nightly_discount":"0.00,16.00,0.00,0.00,0.00","subtotal":"411.42","grand_total":"446.83","paid_amount":"446.83","room_type_id":"289","product_id":"1101","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":"108498","customer_id":"108498","source_of_creation":"PMS","reservation_created_date":"2020-11-05 23:28:46","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153653","reservation_id":"102452","confirmation_number":"BP12570468396","room_stay_from":"2020-11-09","room_stay_to":"2020-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00,95.00","nightly_discount":"0.00,0.00,0.00,19.00","subtotal":"380.00","grand_total":"407.93","paid_amount":"407.93","room_type_id":"301","product_id":"1136","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":"105457","customer_id":"105457","source_of_creation":"PMS","reservation_created_date":"2020-11-09 00:30:21","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 807","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153578","reservation_id":"102395","confirmation_number":"PB12354881507","room_stay_from":"2020-11-09","room_stay_to":"2020-11-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00,165.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"581.00","grand_total":"656.53","paid_amount":"656.53","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108556","customer_id":"108556","source_of_creation":"PMS","reservation_created_date":"2020-11-07 16:37:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3142783","reservation_id":"97755","confirmation_number":"PB12353376520","room_stay_from":"2020-11-08","room_stay_to":"2020-11-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.00,201.00,201.00,221.00,221.00,221.00,221.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0,0","subtotal":"1487.00","grand_total":"1680.31","paid_amount":"1680.31","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":"108620","customer_id":"80391","source_of_creation":"PMS","reservation_created_date":"2020-07-14 14:55:40","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":"201.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"3124156","reservation_id":"87221","confirmation_number":"PB12325002453","room_stay_from":"2020-11-10","room_stay_to":"2020-11-16","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,150.00,150.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"820.00","grand_total":"926.60","paid_amount":"140.12","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24229","customer_id":"24229","source_of_creation":"PMS","reservation_created_date":"2019-11-16 19:21:26","service_canceled_date_time":"2020-11-04 15:04:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"140.12","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3153904","reservation_id":"102509","confirmation_number":"PB12258129570","room_confirmation_number":"PB12386892133","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"108673","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-11-10 23:40:11","reservation_modified_date_time":"2020-11-11 00:08:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108673","canceled_nights_data":"","posAmt_airbnb_taxpaid":"10.00","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153761","reservation_id":"102007","confirmation_number":"PB12274047610","room_confirmation_number":"PB12343364748","room_stay_from":"2020-11-09","room_stay_to":"2020-11-14","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0,0,0,0,0","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"108653","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-11-10 15:22:38","reservation_modified_date_time":"2020-11-10 15:22:38","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108653","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"Reservation created with partial past date","deltaChange":"10.00","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3150709","reservation_id":"91584","confirmation_number":"PB12213796471","room_confirmation_number":"PB12375439425","room_stay_from":"2020-10-31","room_stay_to":"2020-11-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"132.00","grand_total":"149.16","paid_amount":"149.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"42262","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-08 17:30:36","reservation_modified_date_time":"2020-10-31 18:21:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42262","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":"3150713","reservation_id":"91586","confirmation_number":"PB12276362117","room_confirmation_number":"PB12384711874","room_stay_from":"2020-10-31","room_stay_to":"2020-11-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"132.00","grand_total":"149.16","paid_amount":"149.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"91826","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-08 17:37:57","reservation_modified_date_time":"2020-10-31 18:27:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91826","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":"3153444","reservation_id":"102456","confirmation_number":"BP12298085379","room_confirmation_number":"BP12580166232","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"108605","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-09 14:22:57","reservation_modified_date_time":"2020-11-09 14:22:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108605","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":"3153466","reservation_id":"102457","confirmation_number":"BP12243802926","room_confirmation_number":"BP12565008647","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","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":"108667","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-11-09 14:43:09","reservation_modified_date_time":"2020-11-09 14:43:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108667","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":"3153475","reservation_id":"102458","confirmation_number":"BV12278272751","room_confirmation_number":"BV12433348565","room_stay_from":"2020-11-09","room_stay_to":"2020-11-11","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":"107879","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-09 14:48:45","reservation_modified_date_time":"2020-11-09 14:48:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107879","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":"3153545","reservation_id":"102075","confirmation_number":"PB12254461830","room_confirmation_number":"PB12396161443","room_stay_from":"2020-11-09","room_stay_to":"2020-11-11","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":"108628","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-10-29 19:37:07","reservation_modified_date_time":"2020-11-09 17:46:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108628","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":"3153694","reservation_id":"102476","confirmation_number":"PB12227551621","room_confirmation_number":"PB12350634701","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"108637","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-11-09 23:37:06","reservation_modified_date_time":"2020-11-09 23:37:06","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108637","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":"3153732","reservation_id":"102293","confirmation_number":"BP12273345728","room_confirmation_number":"BP12514287329","room_stay_from":"2020-11-05","room_stay_to":"2020-11-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"108426","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-04 18:33:50","reservation_modified_date_time":"2020-11-10 13:21:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108426","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153850","reservation_id":"102501","confirmation_number":"BP12229232449","room_confirmation_number":"BP12560147212","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","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":"108665","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-11-10 19:47:11","reservation_modified_date_time":"2020-11-10 19:47:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108665","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":"3153890","reservation_id":"102506","confirmation_number":"PB12294128907","room_confirmation_number":"PB12348825314","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"108670","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-10 21:53:57","reservation_modified_date_time":"2020-11-10 21:53:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108670","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":"3153905","reservation_id":"102509","confirmation_number":"PB12270260162","room_confirmation_number":"PB12386892133","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","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":"108673","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-11-10 23:40:11","reservation_modified_date_time":"2020-11-11 00:08:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108673","canceled_nights_data":"","posAmt_airbnb_taxpaid":"10.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":"3153721","reservation_id":"102485","confirmation_number":"PB12248931460","room_confirmation_number":"PB12339193987","room_stay_from":"2020-11-09","room_stay_to":"2020-11-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"108647","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-10 01:08:15","reservation_modified_date_time":"2020-11-10 02:27:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108647","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":"3153858","reservation_id":"102503","confirmation_number":"BV12299000167","room_confirmation_number":"BV12440708620","room_stay_from":"2020-11-10","room_stay_to":"2020-11-12","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":"108669","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-11-10 20:26:12","reservation_modified_date_time":"2020-11-10 20:30:35","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108669","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":"3153900","reservation_id":"102440","confirmation_number":"BP12228164674","room_confirmation_number":"BP12557861833","room_stay_from":"2020-11-10","room_stay_to":"2020-11-12","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":"106193","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-08 19:16:22","reservation_modified_date_time":"2020-11-10 23:36:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106193","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3151120","reservation_id":"101972","confirmation_number":"PB12222098067","room_confirmation_number":"PB12315916994","room_stay_from":"2020-11-02","room_stay_to":"2020-11-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"132.00","grand_total":"149.16","paid_amount":"149.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"69555","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-10-26 22:15:27","reservation_modified_date_time":"2020-11-02 02:38:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"69555","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":"3152574","reservation_id":"102359","confirmation_number":"PB12240346132","room_confirmation_number":"PB12358048208","room_stay_from":"2020-11-10","room_stay_to":"2020-11-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"108520","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-06 17:39:53","reservation_modified_date_time":"2020-11-06 17:48:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108520","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":"3153297","reservation_id":"102336","confirmation_number":"BP12222075776","room_confirmation_number":"BP12563000759","room_stay_from":"2020-11-08","room_stay_to":"2020-11-13","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":"108498","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-05 23:28:46","reservation_modified_date_time":"2020-11-08 20:41:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108498","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":"3153379","reservation_id":"102325","confirmation_number":"PB12245618078","room_confirmation_number":"PB12370981700","room_stay_from":"2020-11-08","room_stay_to":"2020-11-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"108487","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-11-05 19:34:10","reservation_modified_date_time":"2020-11-08 21:55:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108487","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":"3153654","reservation_id":"102452","confirmation_number":"BP12238940188","room_confirmation_number":"BP12570468396","room_stay_from":"2020-11-09","room_stay_to":"2020-11-13","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":"105457","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-09 00:30:21","reservation_modified_date_time":"2020-11-09 20:43:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105457","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":"3152892","reservation_id":"100526","confirmation_number":"PB12265796673","room_confirmation_number":"PB12328042110","room_stay_from":"2020-11-07","room_stay_to":"2020-11-14","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":"108552","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-18 13:37:05","reservation_modified_date_time":"2020-11-07 15:33:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108552","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":"3153579","reservation_id":"102395","confirmation_number":"PB12297163239","room_confirmation_number":"PB12354881507","room_stay_from":"2020-11-09","room_stay_to":"2020-11-14","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":"108556","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-07 16:37:07","reservation_modified_date_time":"2020-11-09 18:30:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108556","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":"3153762","reservation_id":"102007","confirmation_number":"PB12243593094","room_confirmation_number":"PB12343364748","room_stay_from":"2020-11-09","room_stay_to":"2020-11-14","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"108653","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-10-27 22:30:08","reservation_modified_date_time":"2020-11-10 15:22:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108653","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3142782","reservation_id":"99485","confirmation_number":"PB12273668475","room_confirmation_number":"PB12348758366","room_stay_from":"2020-11-08","room_stay_to":"2020-11-15","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":"108620","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-25 03:29:00","reservation_modified_date_time":"2020-10-06 20:30:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80391","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":"3142784","reservation_id":"97755","confirmation_number":"PB12218177169","room_confirmation_number":"PB12353376520","room_stay_from":"2020-11-08","room_stay_to":"2020-11-15","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":"108620","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-07-14 14:55:40","reservation_modified_date_time":"2020-10-06 20:30:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80391","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":"3153429","reservation_id":"99623","confirmation_number":"PB12241827434","room_confirmation_number":"PB12353280966","room_stay_from":"2020-11-08","room_stay_to":"2020-11-15","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":"105619","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-27 23:34:46","reservation_modified_date_time":"2020-11-09 01:53:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105619","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":"3150714","reservation_id":"91586","confirmation_number":"PB12230799358","room_confirmation_number":"PB12384711874","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-10-31 18:32:21","reservation_modified_date_time":"2020-10-31 18:32:21","customer_id":"91826","parentCustTravId":"91826","customer_traveller_id":"91826","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-11-11 00:15:02","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-10-31","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3150715","reservation_id":"91584","confirmation_number":"PB12281802677","room_confirmation_number":"PB12375439425","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-10-31 18:38:01","reservation_modified_date_time":"2020-10-31 18:38:01","customer_id":"42262","parentCustTravId":"42262","customer_traveller_id":"42262","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-11-10 23:59:17","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-10-31","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3151734","reservation_id":"101858","confirmation_number":"PB12265658516","room_confirmation_number":"PB12310163055","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-11-04 17:41:32","reservation_modified_date_time":"2020-11-04 17:41:32","customer_id":"87086","parentCustTravId":"87086","customer_traveller_id":"87086","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-11-10 13:19:52","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-11-04","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3153518","reservation_id":"102299","confirmation_number":"BV12247132640","room_confirmation_number":"BV12447272665","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-11-09 16:18:15","reservation_modified_date_time":"2020-11-09 16:18:15","customer_id":"108462","parentCustTravId":"108462","customer_traveller_id":"108462","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-11-10 17:49:45","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-11-08","deltaChange":-9.35,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120","departureCount":7,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1098,1086","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12253194092","room_stay_from":"2020-11-10","room_stay_to":"2020-11-12","bundle_room":"0"},{"confirmation_number":"PB12274981984","room_stay_from":"2020-11-06","room_stay_to":"2020-11-13","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3153906","reservation_id":"102509","confirmation_number":"PB12386892133","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"109.83","nightly_discount":"0","subtotal":"109.83","grand_total":"124.11","paid_amount":"124.11","room_type_id":"289","product_id":"1093","siteminder_id":"BDC-3542472372","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108673","customer_id":"108673","source_of_creation":"Booking.com","reservation_created_date":"2020-11-10 23:40:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"20.97","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"109.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153760","reservation_id":"102007","confirmation_number":"PB12343364748","room_stay_from":"2020-11-09","room_stay_to":"2020-11-14","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"178.10,178.10,178.10,178.10,210.21","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"922.61","grand_total":"1042.55","paid_amount":"1042.55","room_type_id":"288","product_id":"1091","siteminder_id":"BDC-2109245666","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":"108653","customer_id":"108653","source_of_creation":"Booking.com","reservation_created_date":"2020-10-27 22:30:08","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"153.39","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"178.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3152893","reservation_id":"100526","confirmation_number":"PB12328042110","room_stay_from":"2020-11-07","room_stay_to":"2020-11-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.20,128.46,128.46,128.46,128.46,128.46,154.22","nightly_discount":"0,0,0,0,0,0,0","subtotal":"936.72","grand_total":"1058.49","paid_amount":"1058.49","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1700110660","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":"108552","customer_id":"108552","source_of_creation":"Expedia","reservation_created_date":"2020-09-18 13:37:05","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":"128.46","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":[{"room_stay_id":"3153378","reservation_id":"102325","confirmation_number":"PB12370981700","room_stay_from":"2020-11-08","room_stay_to":"2020-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.99,84.99,84.99,84.99,84.99","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"424.95","grand_total":"480.20","paid_amount":"480.20","room_type_id":"291","product_id":"1117","siteminder_id":"GAM-R2199606915","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":"108487","customer_id":"108487","source_of_creation":"Getaroom.com","reservation_created_date":"2020-11-05 19:34:10","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3153693","reservation_id":"102476","confirmation_number":"PB12350634701","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"108.64","nightly_discount":"0","subtotal":"108.64","grand_total":"141.75","paid_amount":"141.75","room_type_id":"285","product_id":"1083","siteminder_id":"ABB-HMTETE5F2E","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"108.64","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108637","customer_id":"108637","source_of_creation":"Airbnb","reservation_created_date":"2020-11-09 23:37:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"15.19","commision_charges":"3.36","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"108.64","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":[{"room_stay_id":"3153546","reservation_id":"102075","confirmation_number":"PB12396161443","room_stay_from":"2020-11-09","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.26,118.26","nightly_discount":"0,0","subtotal":"236.52","grand_total":"267.27","paid_amount":"267.27","room_type_id":"289","product_id":"1094","siteminder_id":"AGO-351943862","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":"108628","customer_id":"108628","source_of_creation":"Agoda","reservation_created_date":"2020-10-29 19:37:07","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":"118.26","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3142781","reservation_id":"99485","confirmation_number":"PB12348758366","room_stay_from":"2020-11-08","room_stay_to":"2020-11-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.00,201.00,201.00,221.00,221.00,221.00,221.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0,0","subtotal":"1487.00","grand_total":"1680.31","paid_amount":"1680.31","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108620","customer_id":"80391","source_of_creation":"FE","reservation_created_date":"2020-08-25 03:29:00","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":"201.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153428","reservation_id":"99623","confirmation_number":"PB12353280966","room_stay_from":"2020-11-08","room_stay_to":"2020-11-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,150.00,150.00,150.00,150.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0,0","subtotal":"990.00","grand_total":"1118.70","paid_amount":"1118.70","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"105619","customer_id":"105619","source_of_creation":"FE","reservation_created_date":"2020-08-27 23:34:46","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3151109","reservation_id":"101364","confirmation_number":"PB12312386470","room_stay_from":"2020-11-10","room_stay_to":"2020-11-14","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"520.00","grand_total":"587.60","paid_amount":"146.90","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107440","customer_id":"107440","source_of_creation":"FE","reservation_created_date":"2020-10-10 03:05:57","service_canceled_date_time":"2020-11-09 21:55:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"146.90","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3150708","reservation_id":"91584","confirmation_number":"PB12375439425","room_stay_from":"2020-10-31","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,120.00,120.00,120.00,140.00,140.00,120.00,120.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,62.04,0.00,75.60,75.60","subtotal":"1380.00","grand_total":"1318.44","paid_amount":"1318.44","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"42262","customer_id":"42262","source_of_creation":"PMS","reservation_created_date":"2020-02-08 17:30:36","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.00","currentDayDiscount":"75.60","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3150712","reservation_id":"91586","confirmation_number":"PB12384711874","room_stay_from":"2020-10-31","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,108.00,108.00,108.00,126.00,126.00,108.00,108.00,108.00,108.00,108.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,62.70,0.00,0.00","subtotal":"1242.00","grand_total":"1332.61","paid_amount":"1332.61","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":"91826","customer_id":"91826","source_of_creation":"PMS","reservation_created_date":"2020-02-08 17:37:57","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":"108.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153889","reservation_id":"102506","confirmation_number":"PB12348825314","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.76","nightly_discount":"0.00","subtotal":"95.76","grand_total":"108.21","paid_amount":"108.21","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":"108670","customer_id":"108670","source_of_creation":"PMS","reservation_created_date":"2020-11-10 21:53:56","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":"95.76","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153720","reservation_id":"102485","confirmation_number":"PB12339193987","room_stay_from":"2020-11-09","room_stay_to":"2020-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,140.00,140.00","nightly_discount":"0.00,0,0","subtotal":"420.00","grand_total":"474.60","paid_amount":"474.60","room_type_id":"287","product_id":"1089","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108647","customer_id":"108647","source_of_creation":"PMS","reservation_created_date":"2020-11-10 01:08:15","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":"140.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":"3151119","reservation_id":"101972","confirmation_number":"PB12315916994","room_stay_from":"2020-11-02","room_stay_to":"2020-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.00,90.00,90.00,90.00,140.00,140.00,120.00,120.00,120.00,120.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,0.00","subtotal":"1240.00","grand_total":"1401.20","paid_amount":"1401.20","room_type_id":"289","product_id":"1106","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":"69555","customer_id":"69555","source_of_creation":"PMS","reservation_created_date":"2020-10-26 22:15:27","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3152573","reservation_id":"102359","confirmation_number":"PB12358048208","room_stay_from":"2020-11-10","room_stay_to":"2020-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.60,173.60,173.60","nightly_discount":"0.00,0.00,0","subtotal":"520.80","grand_total":"588.51","paid_amount":"588.51","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108520","customer_id":"108520","source_of_creation":"PMS","reservation_created_date":"2020-11-06 17:39:53","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":"173.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153578","reservation_id":"102395","confirmation_number":"PB12354881507","room_stay_from":"2020-11-09","room_stay_to":"2020-11-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00,165.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"581.00","grand_total":"656.53","paid_amount":"656.53","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108556","customer_id":"108556","source_of_creation":"PMS","reservation_created_date":"2020-11-07 16:37:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3142783","reservation_id":"97755","confirmation_number":"PB12353376520","room_stay_from":"2020-11-08","room_stay_to":"2020-11-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.00,201.00,201.00,221.00,221.00,221.00,221.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0,0","subtotal":"1487.00","grand_total":"1680.31","paid_amount":"1680.31","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":"108620","customer_id":"80391","source_of_creation":"PMS","reservation_created_date":"2020-07-14 14:55:40","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":"201.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"3124156","reservation_id":"87221","confirmation_number":"PB12325002453","room_stay_from":"2020-11-10","room_stay_to":"2020-11-16","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,150.00,150.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"820.00","grand_total":"926.60","paid_amount":"140.12","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24229","customer_id":"24229","source_of_creation":"PMS","reservation_created_date":"2019-11-16 19:21:26","service_canceled_date_time":"2020-11-04 15:04:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"140.12","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3153904","reservation_id":"102509","confirmation_number":"PB12258129570","room_confirmation_number":"PB12386892133","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"108673","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-11-10 23:40:11","reservation_modified_date_time":"2020-11-11 00:08:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108673","canceled_nights_data":"","posAmt_airbnb_taxpaid":"10.00","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153761","reservation_id":"102007","confirmation_number":"PB12274047610","room_confirmation_number":"PB12343364748","room_stay_from":"2020-11-09","room_stay_to":"2020-11-14","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0,0,0,0,0","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"108653","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-11-10 15:22:38","reservation_modified_date_time":"2020-11-10 15:22:38","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108653","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"Reservation created with partial past date","deltaChange":"10.00","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3150709","reservation_id":"91584","confirmation_number":"PB12213796471","room_confirmation_number":"PB12375439425","room_stay_from":"2020-10-31","room_stay_to":"2020-11-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"132.00","grand_total":"149.16","paid_amount":"149.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"42262","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-08 17:30:36","reservation_modified_date_time":"2020-10-31 18:21:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42262","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":"3150713","reservation_id":"91586","confirmation_number":"PB12276362117","room_confirmation_number":"PB12384711874","room_stay_from":"2020-10-31","room_stay_to":"2020-11-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"132.00","grand_total":"149.16","paid_amount":"149.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"91826","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-08 17:37:57","reservation_modified_date_time":"2020-10-31 18:27:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91826","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":"3153545","reservation_id":"102075","confirmation_number":"PB12254461830","room_confirmation_number":"PB12396161443","room_stay_from":"2020-11-09","room_stay_to":"2020-11-11","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":"108628","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-10-29 19:37:07","reservation_modified_date_time":"2020-11-09 17:46:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108628","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":"3153694","reservation_id":"102476","confirmation_number":"PB12227551621","room_confirmation_number":"PB12350634701","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"108637","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-11-09 23:37:06","reservation_modified_date_time":"2020-11-09 23:37:06","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108637","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":"3153890","reservation_id":"102506","confirmation_number":"PB12294128907","room_confirmation_number":"PB12348825314","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"108670","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-10 21:53:57","reservation_modified_date_time":"2020-11-10 21:53:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108670","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":"3153905","reservation_id":"102509","confirmation_number":"PB12270260162","room_confirmation_number":"PB12386892133","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","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":"108673","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-11-10 23:40:11","reservation_modified_date_time":"2020-11-11 00:08:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108673","canceled_nights_data":"","posAmt_airbnb_taxpaid":"10.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":"3153721","reservation_id":"102485","confirmation_number":"PB12248931460","room_confirmation_number":"PB12339193987","room_stay_from":"2020-11-09","room_stay_to":"2020-11-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"108647","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-10 01:08:15","reservation_modified_date_time":"2020-11-10 02:27:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108647","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":"3151120","reservation_id":"101972","confirmation_number":"PB12222098067","room_confirmation_number":"PB12315916994","room_stay_from":"2020-11-02","room_stay_to":"2020-11-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"132.00","grand_total":"149.16","paid_amount":"149.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"69555","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-10-26 22:15:27","reservation_modified_date_time":"2020-11-02 02:38:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"69555","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":"3152574","reservation_id":"102359","confirmation_number":"PB12240346132","room_confirmation_number":"PB12358048208","room_stay_from":"2020-11-10","room_stay_to":"2020-11-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"108520","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-06 17:39:53","reservation_modified_date_time":"2020-11-06 17:48:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108520","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":"3153379","reservation_id":"102325","confirmation_number":"PB12245618078","room_confirmation_number":"PB12370981700","room_stay_from":"2020-11-08","room_stay_to":"2020-11-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"108487","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-11-05 19:34:10","reservation_modified_date_time":"2020-11-08 21:55:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108487","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":"3152892","reservation_id":"100526","confirmation_number":"PB12265796673","room_confirmation_number":"PB12328042110","room_stay_from":"2020-11-07","room_stay_to":"2020-11-14","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":"108552","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-09-18 13:37:05","reservation_modified_date_time":"2020-11-07 15:33:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108552","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":"3153579","reservation_id":"102395","confirmation_number":"PB12297163239","room_confirmation_number":"PB12354881507","room_stay_from":"2020-11-09","room_stay_to":"2020-11-14","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":"108556","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-07 16:37:07","reservation_modified_date_time":"2020-11-09 18:30:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108556","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":"3153762","reservation_id":"102007","confirmation_number":"PB12243593094","room_confirmation_number":"PB12343364748","room_stay_from":"2020-11-09","room_stay_to":"2020-11-14","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"108653","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-10-27 22:30:08","reservation_modified_date_time":"2020-11-10 15:22:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108653","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3142782","reservation_id":"99485","confirmation_number":"PB12273668475","room_confirmation_number":"PB12348758366","room_stay_from":"2020-11-08","room_stay_to":"2020-11-15","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":"108620","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-25 03:29:00","reservation_modified_date_time":"2020-10-06 20:30:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80391","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":"3142784","reservation_id":"97755","confirmation_number":"PB12218177169","room_confirmation_number":"PB12353376520","room_stay_from":"2020-11-08","room_stay_to":"2020-11-15","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":"108620","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-07-14 14:55:40","reservation_modified_date_time":"2020-10-06 20:30:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"80391","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":"3153429","reservation_id":"99623","confirmation_number":"PB12241827434","room_confirmation_number":"PB12353280966","room_stay_from":"2020-11-08","room_stay_to":"2020-11-15","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":"105619","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-08-27 23:34:46","reservation_modified_date_time":"2020-11-09 01:53:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105619","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":"3150714","reservation_id":"91586","confirmation_number":"PB12230799358","room_confirmation_number":"PB12384711874","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-10-31 18:32:21","reservation_modified_date_time":"2020-10-31 18:32:21","customer_id":"91826","parentCustTravId":"91826","customer_traveller_id":"91826","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-11-11 00:15:02","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-10-31","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3150715","reservation_id":"91584","confirmation_number":"PB12281802677","room_confirmation_number":"PB12375439425","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-10-31 18:38:01","reservation_modified_date_time":"2020-10-31 18:38:01","customer_id":"42262","parentCustTravId":"42262","customer_traveller_id":"42262","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-11-10 23:59:17","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-10-31","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3151734","reservation_id":"101858","confirmation_number":"PB12265658516","room_confirmation_number":"PB12310163055","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-11-04 17:41:32","reservation_modified_date_time":"2020-11-04 17:41:32","customer_id":"87086","parentCustTravId":"87086","customer_traveller_id":"87086","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-11-10 13:19:52","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-11-04","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":1,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1139,1223,1225","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BV12288522299","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","bundle_room":"0"},{"confirmation_number":"BV12295275097","room_stay_from":"2020-11-08","room_stay_to":"2020-11-11","bundle_room":"0"},{"confirmation_number":"BV12292157753","room_stay_from":"2020-11-08","room_stay_to":"2020-11-11","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3153857","reservation_id":"102503","confirmation_number":"BV12440708620","room_stay_from":"2020-11-10","room_stay_to":"2020-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"80.51,80.51","nightly_discount":"0,0","subtotal":"161.02","grand_total":"210.09","paid_amount":"210.09","room_type_id":"303","product_id":"1140","siteminder_id":"ABB-HMFXCFC83P","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"161.02","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108669","customer_id":"108669","source_of_creation":"Airbnb","reservation_created_date":"2020-11-10 20:26:12","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"22.51","commision_charges":"4.98","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"80.51","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":"3153474","reservation_id":"102458","confirmation_number":"BV12433348565","room_stay_from":"2020-11-09","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.34,105.34","nightly_discount":"0.00,0.00","subtotal":"210.68","grand_total":"238.07","paid_amount":"238.07","room_type_id":"304","product_id":"1218","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107879","customer_id":"107879","source_of_creation":"PMS","reservation_created_date":"2020-11-09 14:48:45","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3153475","reservation_id":"102458","confirmation_number":"BV12278272751","room_confirmation_number":"BV12433348565","room_stay_from":"2020-11-09","room_stay_to":"2020-11-11","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":"107879","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-09 14:48:45","reservation_modified_date_time":"2020-11-09 14:48:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107879","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":"3153858","reservation_id":"102503","confirmation_number":"BV12299000167","room_confirmation_number":"BV12440708620","room_stay_from":"2020-11-10","room_stay_to":"2020-11-12","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":"108669","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-11-10 20:26:12","reservation_modified_date_time":"2020-11-10 20:30:35","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108669","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3153518","reservation_id":"102299","confirmation_number":"BV12247132640","room_confirmation_number":"BV12447272665","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-11-09 16:18:15","reservation_modified_date_time":"2020-11-09 16:18:15","customer_id":"108462","parentCustTravId":"108462","customer_traveller_id":"108462","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-11-10 17:49:45","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-11-08","deltaChange":-9.35,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":2,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1135","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BP12259465450","room_stay_from":"2020-11-09","room_stay_to":"2020-11-11","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3153849","reservation_id":"102501","confirmation_number":"BP12560147212","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"61.96","nightly_discount":"0","subtotal":"61.96","grand_total":"70.02","paid_amount":"70.02","room_type_id":"295","product_id":"1128","siteminder_id":"GAM-R2205939102","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":"108665","customer_id":"108665","source_of_creation":"Getaroom.com","reservation_created_date":"2020-11-10 19:47: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":"61.96","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3153465","reservation_id":"102457","confirmation_number":"BP12565008647","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.57","nightly_discount":"0","subtotal":"78.57","grand_total":"102.51","paid_amount":"102.51","room_type_id":"293","product_id":"1124","siteminder_id":"ABB-HMWSDWYFNM","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"78.57","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108667","customer_id":"108667","source_of_creation":"Airbnb","reservation_created_date":"2020-11-09 14:43:09","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"10.98","commision_charges":"2.43","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.57","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":"3153443","reservation_id":"102456","confirmation_number":"BP12580166232","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.08","nightly_discount":"0.00","subtotal":"69.08","grand_total":"78.06","paid_amount":"78.06","room_type_id":"299","product_id":"1134","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":"108605","customer_id":"108605","source_of_creation":"PMS","reservation_created_date":"2020-11-09 14:22:57","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.08","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153731","reservation_id":"102293","confirmation_number":"BP12514287329","room_stay_from":"2020-11-05","room_stay_to":"2020-11-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.87,147.00,124.95,86.36,101.60,93.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"639.78","grand_total":"722.95","paid_amount":"722.95","room_type_id":"294","product_id":"1126","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":"108426","customer_id":"108426","source_of_creation":"PMS","reservation_created_date":"2020-11-04 18:33:50","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 806","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":"93.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153899","reservation_id":"102440","confirmation_number":"BP12557861833","room_stay_from":"2020-11-10","room_stay_to":"2020-11-12","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"69.08,69.08","nightly_discount":"0.00,0","subtotal":"138.16","grand_total":"156.12","paid_amount":"156.12","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106193","customer_id":"106193","source_of_creation":"PMS","reservation_created_date":"2020-11-08 19:16:22","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","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":"69.08","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153296","reservation_id":"102336","confirmation_number":"BP12563000759","room_stay_from":"2020-11-08","room_stay_to":"2020-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.58,83.00,75.00,88.92,88.92","nightly_discount":"0.00,16.00,0.00,0.00,0.00","subtotal":"411.42","grand_total":"446.83","paid_amount":"446.83","room_type_id":"289","product_id":"1101","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":"108498","customer_id":"108498","source_of_creation":"PMS","reservation_created_date":"2020-11-05 23:28:46","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153653","reservation_id":"102452","confirmation_number":"BP12570468396","room_stay_from":"2020-11-09","room_stay_to":"2020-11-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00,95.00","nightly_discount":"0.00,0.00,0.00,19.00","subtotal":"380.00","grand_total":"407.93","paid_amount":"407.93","room_type_id":"301","product_id":"1136","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":"105457","customer_id":"105457","source_of_creation":"PMS","reservation_created_date":"2020-11-09 00:30:21","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 807","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3153444","reservation_id":"102456","confirmation_number":"BP12298085379","room_confirmation_number":"BP12580166232","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"108605","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-09 14:22:57","reservation_modified_date_time":"2020-11-09 14:22:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108605","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":"3153466","reservation_id":"102457","confirmation_number":"BP12243802926","room_confirmation_number":"BP12565008647","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","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":"108667","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-11-09 14:43:09","reservation_modified_date_time":"2020-11-09 14:43:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108667","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":"3153732","reservation_id":"102293","confirmation_number":"BP12273345728","room_confirmation_number":"BP12514287329","room_stay_from":"2020-11-05","room_stay_to":"2020-11-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"108426","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-04 18:33:50","reservation_modified_date_time":"2020-11-10 13:21:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108426","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153850","reservation_id":"102501","confirmation_number":"BP12229232449","room_confirmation_number":"BP12560147212","room_stay_from":"2020-11-10","room_stay_to":"2020-11-11","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":"108665","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-11-10 19:47:11","reservation_modified_date_time":"2020-11-10 19:47:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108665","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":"3153900","reservation_id":"102440","confirmation_number":"BP12228164674","room_confirmation_number":"BP12557861833","room_stay_from":"2020-11-10","room_stay_to":"2020-11-12","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":"106193","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-08 19:16:22","reservation_modified_date_time":"2020-11-10 23:36:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106193","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3153297","reservation_id":"102336","confirmation_number":"BP12222075776","room_confirmation_number":"BP12563000759","room_stay_from":"2020-11-08","room_stay_to":"2020-11-13","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":"108498","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-05 23:28:46","reservation_modified_date_time":"2020-11-08 20:41:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108498","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":"3153654","reservation_id":"102452","confirmation_number":"BP12238940188","room_confirmation_number":"BP12570468396","room_stay_from":"2020-11-09","room_stay_to":"2020-11-13","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":"105457","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-09 00:30:21","reservation_modified_date_time":"2020-11-09 20:43:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105457","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":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}