{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-05-18","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":28,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1108,1091,1113,1106,1103","block_room_bookings":[{"confirmation_number":"PB12276061450","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","bundle_room":"0"},{"confirmation_number":"PB12257228645","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","bundle_room":"0"},{"confirmation_number":"PB12298565194","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","bundle_room":"0"},{"confirmation_number":"PB12258619196","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","bundle_room":"0"},{"confirmation_number":"PB12260697091","room_stay_from":"2020-05-18","room_stay_to":"2020-05-20","bundle_room":"0"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3094851","reservation_id":"94924","confirmation_number":"PB12319593837","room_stay_from":"2020-05-18","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"125.37,125.37","nightly_discount":"0,0","subtotal":"250.74","grand_total":"283.33","paid_amount":"283.33","room_type_id":"285","product_id":"1085","siteminder_id":"BDC-2551073653","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":"101118","customer_id":"101118","source_of_creation":"Booking.com","reservation_created_date":"2020-05-17 23:56:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"43.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"125.37","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3094467","reservation_id":"94636","confirmation_number":"BP12582834053","room_stay_from":"2020-05-10","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"154.54,154.54,154.54,154.54,154.54,154.54,154.54,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1279.78","grand_total":"1446.15","paid_amount":"1558.02","room_type_id":"296","product_id":"1131","siteminder_id":"EXP-1663504401","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100857","customer_id":"100857","source_of_creation":"Expedia","reservation_created_date":"2020-05-10 14:26:10","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094894","reservation_id":"94177","confirmation_number":"BP12566714922","room_stay_from":"2020-05-18","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"100.61,100.61,100.61,100.61","nightly_discount":"0,0,0,0","subtotal":"402.44","grand_total":"454.76","paid_amount":"454.76","room_type_id":"302","product_id":"1138","siteminder_id":"EXP-1661980243","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101169","customer_id":"101169","source_of_creation":"Expedia","reservation_created_date":"2020-04-26 22:21:08","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.61","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":"3093207","reservation_id":"94349","confirmation_number":"PB12313626819","room_stay_from":"2020-05-12","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.29,117.29,117.29,143.47,143.47,117.29,117.29","nightly_discount":"0,0,0,0,0,0,0","subtotal":"873.39","grand_total":"986.93","paid_amount":"986.93","room_type_id":"289","product_id":"1111","siteminder_id":"GAM-R1953915007","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":"83852","customer_id":"83852","source_of_creation":"Getaroom.com","reservation_created_date":"2020-05-02 18:11:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.29","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":"3093820","reservation_id":"94592","confirmation_number":"BP12570529801","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"155.37","nightly_discount":"0","subtotal":"155.37","grand_total":"211.86","paid_amount":"211.86","room_type_id":"301","product_id":"1137","siteminder_id":"ABB-HM28B3BWAA","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"155.37","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101192","customer_id":"101192","source_of_creation":"Airbnb","reservation_created_date":"2020-05-09 04:02:04","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 824","ota_service_fee_amount":"25.91","commision_charges":"5.73","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"155.37","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":"3094687","reservation_id":"94812","confirmation_number":"BV12479067750","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.03","nightly_discount":"0.00","subtotal":"96.03","grand_total":"125.29","paid_amount":"125.29","room_type_id":"307","product_id":"1224","siteminder_id":"ABB-HMPP5TNTH4","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"96.03","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101173","customer_id":"101173","source_of_creation":"Airbnb","reservation_created_date":"2020-05-14 22:06:08","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"13.42","commision_charges":"2.97","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.03","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3094899","reservation_id":"94980","confirmation_number":"PB12333496940","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"80.10","nightly_discount":"0","subtotal":"80.10","grand_total":"90.52","paid_amount":"90.52","room_type_id":"292","product_id":"1120","siteminder_id":"HWR-302149359","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":"101172","customer_id":"101187","source_of_creation":"Hotwire","reservation_created_date":"2020-05-18 19:47:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"80.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"}]}],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3094887","reservation_id":"94822","confirmation_number":"PB12327844318","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"144.54,144.54","nightly_discount":"0.00,18.00","subtotal":"289.08","grand_total":"306.32","paid_amount":"306.32","room_type_id":"289","product_id":"1112","siteminder_id":"GCC-0008100080-064","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":"59773","customer_id":"59773","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-05-15 03:00:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.54","currentDayDiscount":"18.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094255","reservation_id":"94874","confirmation_number":"PB12394895741","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"142.55,142.55,142.55,142.55,142.55,209.05","nightly_discount":"0,0,0,0,0,0","subtotal":"921.80","grand_total":"1041.64","paid_amount":"1041.64","room_type_id":"289","product_id":"1109","siteminder_id":"GCC-0008300082-064","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101066","customer_id":"101066","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-05-16 18:20:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"142.55","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3092786","reservation_id":"94661","confirmation_number":"BV12420796461","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"139.52,70.53,70.53,70.53","nightly_discount":"0,0,0,0","subtotal":"351.11","grand_total":"396.76","paid_amount":"396.76","room_type_id":"303","product_id":"1140","siteminder_id":"AGO-318367766","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100860","customer_id":"101069","source_of_creation":"Agoda","reservation_created_date":"2020-05-11 01:57:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"70.53","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094369","reservation_id":"85521","confirmation_number":"PB12345584060","room_stay_from":"2020-05-15","room_stay_to":"2020-05-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.90,147.90,126.23,126.23,126.23,126.23","nightly_discount":"0,0,0,0,0,0","subtotal":"800.72","grand_total":"904.81","paid_amount":"904.81","room_type_id":"313","product_id":"1228","siteminder_id":"AGO-252881199","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":"92602","customer_id":"92602","source_of_creation":"Agoda","reservation_created_date":"2019-10-12 10:57:06","canceled_nights_data":"","product_name":"PB Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.23","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":"3094658","reservation_id":"94774","confirmation_number":"PB12385180723","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"106.56,106.56,106.56,106.56,106.56,205.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"738.38","grand_total":"834.37","paid_amount":"834.37","room_type_id":"289","product_id":"1098","siteminder_id":"AGO-318681282","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101111","customer_id":"101111","source_of_creation":"Agoda","reservation_created_date":"2020-05-14 01:28:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"106.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3094446","reservation_id":"94692","confirmation_number":"PB12392376188","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129.00,129.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100892","customer_id":"100892","source_of_creation":"FE","reservation_created_date":"2020-05-12 03:11:12","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":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094889","reservation_id":"94824","confirmation_number":"PB12313296116","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"144.54,144.54","nightly_discount":"0.00,0.00","subtotal":"289.08","grand_total":"326.66","paid_amount":"326.66","room_type_id":"289","product_id":"1107","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101025","customer_id":"101025","source_of_creation":"FE","reservation_created_date":"2020-05-15 03:25:50","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.54","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094921","reservation_id":"94330","confirmation_number":"BV12436776795","room_stay_from":"2020-05-18","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"99.00,99.00,99.00","nightly_discount":"0.00,0.00,15.23","subtotal":"297.00","grand_total":"318.40","paid_amount":"318.40","room_type_id":"303","product_id":"1139","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100389","customer_id":"100389","source_of_creation":"FE","reservation_created_date":"2020-05-02 14:55:31","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3093286","reservation_id":"94442","confirmation_number":"PB12357868640","room_stay_from":"2020-05-13","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,159.00,159.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"834.00","grand_total":"942.42","paid_amount":"942.42","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100156","customer_id":"100156","source_of_creation":"PMS","reservation_created_date":"2020-05-05 14:09:21","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":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094045","reservation_id":"94849","confirmation_number":"PB12386197731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101043","customer_id":"101043","source_of_creation":"PMS","reservation_created_date":"2020-05-15 19:22:54","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094146","reservation_id":"94819","confirmation_number":"BV12468763941","room_stay_from":"2020-05-16","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00","subtotal":"297.00","grand_total":"335.61","paid_amount":"335.61","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101020","customer_id":"101020","source_of_creation":"PMS","reservation_created_date":"2020-05-15 00:47:37","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094311","reservation_id":"94830","confirmation_number":"BP12543138865","room_stay_from":"2020-05-16","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","room_type_id":"300","product_id":"1135","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"PMS","reservation_created_date":"2020-05-15 13:09:21","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 805","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094358","reservation_id":"94849","confirmation_number":"PB12342380376","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101043","customer_id":"101043","source_of_creation":"PMS","reservation_created_date":"2020-05-15 19:23:51","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094360","reservation_id":"94837","confirmation_number":"PB12384161608","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"129.00,129.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101033","customer_id":"101033","source_of_creation":"PMS","reservation_created_date":"2020-05-15 15:07:47","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094393","reservation_id":"94894","confirmation_number":"PB12319811571","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"149.00,149.00","nightly_discount":"0.00,0.00","subtotal":"298.00","grand_total":"336.74","paid_amount":"336.74","room_type_id":"291","product_id":"1115","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":"101084","customer_id":"101084","source_of_creation":"PMS","reservation_created_date":"2020-05-17 14:33:24","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094738","reservation_id":"94947","confirmation_number":"PB12329221019","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00","nightly_discount":"0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","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":"101138","customer_id":"101138","source_of_creation":"PMS","reservation_created_date":"2020-05-18 12:28:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3094745","reservation_id":"94949","confirmation_number":"BV12456860745","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.91","nightly_discount":"0.00","subtotal":"92.91","grand_total":"104.98","paid_amount":"104.98","room_type_id":"308","product_id":"1225","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99857","customer_id":"99857","source_of_creation":"PMS","reservation_created_date":"2020-05-18 13:44:49","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"92.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094766","reservation_id":"94951","confirmation_number":"BP12534539709","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"293","product_id":"1124","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":"101058","customer_id":"101058","source_of_creation":"PMS","reservation_created_date":"2020-05-18 14:32:10","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094388","reservation_id":"94492","confirmation_number":"PB12333304661","room_stay_from":"2020-05-06","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0,0,0,0,0,0,0,0,0,0","subtotal":"1386.00","grand_total":"1566.18","paid_amount":"1566.18","room_type_id":"291","product_id":"1118","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":"100702","customer_id":"100702","source_of_creation":"PMS","reservation_created_date":"2020-05-06 15:04:19","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.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":"3093037","reservation_id":"94685","confirmation_number":"BV12419598660","room_stay_from":"2020-05-12","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","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":"100579","customer_id":"100579","source_of_creation":"PMS","reservation_created_date":"2020-05-11 22:48:50","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":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094335","reservation_id":"94834","confirmation_number":"PB12344310731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0","subtotal":"516.00","grand_total":"583.08","paid_amount":"583.08","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101022","customer_id":"101022","source_of_creation":"PMS","reservation_created_date":"2020-05-15 14:47:17","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092596","reservation_id":"94505","confirmation_number":"PB12321433020","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"159.00,129.00,129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"804.00","grand_total":"908.52","paid_amount":"908.52","room_type_id":"289","product_id":"1105","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81868","customer_id":"81868","source_of_creation":"PMS","reservation_created_date":"2020-05-06 20:42:31","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094295","reservation_id":"94505","confirmation_number":"PB12376730984","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,129.00,129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,35.58","subtotal":"804.00","grand_total":"868.32","paid_amount":"868.32","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":"81868","customer_id":"81868","source_of_creation":"PMS","reservation_created_date":"2020-05-06 20:42:31","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":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093765","reservation_id":"94749","confirmation_number":"BV12490814010","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1296.00","grand_total":"1385.16","paid_amount":"1385.16","room_type_id":"305","product_id":"1222","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":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-13 18:00:14","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093770","reservation_id":"94749","confirmation_number":"BP12575897730","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1296.00","grand_total":"1385.16","paid_amount":"1385.16","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-13 18:08:25","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093775","reservation_id":"94749","confirmation_number":"BP12584896215","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1296.00","grand_total":"1385.16","paid_amount":"1385.16","room_type_id":"294","product_id":"1125","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-13 18:11:37","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 803","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093959","reservation_id":"94749","confirmation_number":"BP12554397887","room_stay_from":"2020-05-15","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1152.00","grand_total":"1222.44","paid_amount":"1222.44","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":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-15 15:43:52","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":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094704","reservation_id":"94932","confirmation_number":"PB12313880138","room_stay_from":"2020-05-18","room_stay_to":"2020-05-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,129.00,199.00,199.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"914.00","grand_total":"1032.82","paid_amount":"1032.82","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":"101124","customer_id":"101124","source_of_creation":"PMS","reservation_created_date":"2020-05-18 01:51:42","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":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092996","reservation_id":"93659","confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,89.00,89.00,89.00,89.00,89.00,89.00,89.00,99.00,89.00,89.00,89.00,89.00,89.00,99.00,109.00,99.00,99.00,99.00,99.00,99.00,109.00,129.00,99.00,99.00,99.00,99.00,109.00,109.00,109.00,99.00,99.00,99.00,99.00,99.00,129.00,129.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,69.26,5.00,0.00,0.00,0.00,0.00,0.00,0.00,40.00,0.00,0.00,0.00,0.00,0.00,0.00,42.00,0.00,0.00,0.00,0.00,0.00,0.00,39.85,0.00,0.00,0.00,0.00,0.00,0.00,41.16,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"5098.00","grand_total":"5492.62","paid_amount":"5492.62","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76889","customer_id":"76889","source_of_creation":"PMS","reservation_created_date":"2020-03-30 17:57:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"3094754","reservation_id":"94808","confirmation_number":"PB12391119814","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Canceled","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129.00","nightly_discount":"0.00","subtotal":"129.00","grand_total":"145.77","paid_amount":"145.77","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":"101010","customer_id":"101010","source_of_creation":"PMS","reservation_created_date":"2020-05-14 21:00:35","service_canceled_date_time":"2020-05-18 14:16:36","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"145.77","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":"3093821","reservation_id":"94592","confirmation_number":"BP12266106994","room_confirmation_number":"BP12570529801","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"30","nightly_discount":"0.00","subtotal":"30.00","grand_total":"30.00","paid_amount":"30.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"101192","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-15 14:55:59","reservation_modified_date_time":"2020-05-15 14:55:59","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101192","canceled_nights_data":"","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]},{"room_stay_id":"3094361","reservation_id":"94837","confirmation_number":"PB12295655083","room_confirmation_number":"PB12384161608","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"101033","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-17 12:59:36","reservation_modified_date_time":"2020-05-17 12:59:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101033","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094395","reservation_id":"94894","confirmation_number":"PB12229330249","room_confirmation_number":"PB12319811571","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","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":"1780","service_quantity":"1","customer_traveller_id":"101084","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-17 14:33:24","reservation_modified_date_time":"2020-05-17 14:33:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101084","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094448","reservation_id":"94692","confirmation_number":"PB12289025294","room_confirmation_number":"PB12392376188","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"100892","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-17 16:51:08","reservation_modified_date_time":"2020-05-17 16:51:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100892","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094468","reservation_id":"94636","confirmation_number":"BP12262596252","room_confirmation_number":"BP12582834053","room_stay_from":"2020-05-10","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0,0,0,0,0","subtotal":"180.00","grand_total":"203.40","paid_amount":"48.85","product_id":"1780","service_quantity":"1","customer_traveller_id":"100857","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-17 17:41:18","reservation_modified_date_time":"2020-05-17 17:41:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100857","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094527","reservation_id":"94822","confirmation_number":"PB12221600367","room_confirmation_number":"PB12327844318","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"59773","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-17 19:09:48","reservation_modified_date_time":"2020-05-17 19:16:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"59773","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094537","reservation_id":"94824","confirmation_number":"PB12242378685","room_confirmation_number":"PB12313296116","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"101025","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-17 19:10:12","reservation_modified_date_time":"2020-05-17 19:17:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101025","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094768","reservation_id":"94951","confirmation_number":"BP12295717268","room_confirmation_number":"BP12534539709","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","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":"1780","service_quantity":"1","customer_traveller_id":"101058","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-18 14:32:10","reservation_modified_date_time":"2020-05-18 14:32:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101058","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092787","reservation_id":"94661","confirmation_number":"BV12245087623","room_confirmation_number":"BV12420796461","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"100860","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-11 01:57:09","reservation_modified_date_time":"2020-05-11 01:57:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101069","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094685","reservation_id":"94330","confirmation_number":"BV12263553621","room_confirmation_number":"BV12436776795","room_stay_from":"2020-05-18","room_stay_to":"2020-05-21","room_stay_status":"Active","nightly_price":"40,40,40","nightly_discount":"0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100389","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-18 00:30:06","reservation_modified_date_time":"2020-05-18 00:30:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100389","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092597","reservation_id":"94505","confirmation_number":"PB12215674144","room_confirmation_number":"PB12321433020","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"81868","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-10 14:05:00","reservation_modified_date_time":"2020-05-10 14:05:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81868","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094891","reservation_id":"94177","confirmation_number":"BP12294908038","room_confirmation_number":"BP12566714922","room_stay_from":"2020-05-18","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"101169","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-18 17:54:51","reservation_modified_date_time":"2020-05-18 19:09:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101169","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093351","reservation_id":"94749","confirmation_number":"BV12289705702","room_confirmation_number":"BV12490814010","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-13 18:00:14","reservation_modified_date_time":"2020-05-13 18:00:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093358","reservation_id":"94749","confirmation_number":"BP12248443950","room_confirmation_number":"BP12584896215","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-13 18:11:37","reservation_modified_date_time":"2020-05-13 18:11:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094256","reservation_id":"94874","confirmation_number":"PB12233320938","room_confirmation_number":"PB12394895741","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"101066","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-16 18:20:11","reservation_modified_date_time":"2020-05-16 18:20:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101066","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094656","reservation_id":"94774","confirmation_number":"PB12283914742","room_confirmation_number":"PB12385180723","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"30.00,30.00,30.00,30.00,30.00,30.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"101111","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-17 22:24:35","reservation_modified_date_time":"2020-05-17 22:47:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101111","canceled_nights_data":"","currentDayPrice":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094659","reservation_id":"94912","confirmation_number":"PB12232496351","room_confirmation_number":"PB12329902124","room_stay_from":"2020-05-17","room_stay_to":"2020-05-18","room_stay_status":"Canceled","nightly_price":"30","nightly_discount":"0","subtotal":"30.00","grand_total":"33.90","paid_amount":"0.00","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-17 22:13:34","reservation_modified_date_time":"2020-05-17 22:49:07","customer_id":"101115","parentCustTravId":"101115","customer_traveller_id":"101115","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-18 14:08:56","canceled_nights_data":"","product_attribute_values":"extra_person#&#10.00","deltaChange":-30,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"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":"3093208","reservation_id":"94349","confirmation_number":"PB12281730192","room_confirmation_number":"PB12313626819","room_stay_from":"2020-05-12","room_stay_to":"2020-05-19","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":"83852","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-02 18:11:06","reservation_modified_date_time":"2020-05-12 20:32:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83852","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093287","reservation_id":"94442","confirmation_number":"PB12271944397","room_confirmation_number":"PB12357868640","room_stay_from":"2020-05-13","room_stay_to":"2020-05-19","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":"100156","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-05 14:09:21","reservation_modified_date_time":"2020-05-13 13:48:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100156","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093822","reservation_id":"94592","confirmation_number":"BP12268359896","room_confirmation_number":"BP12570529801","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","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":"101192","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-09 04:02:04","reservation_modified_date_time":"2020-05-15 14:56:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101192","canceled_nights_data":"","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":"3094046","reservation_id":"94849","confirmation_number":"PB12238272550","room_confirmation_number":"PB12386197731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","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":"101043","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 19:22:54","reservation_modified_date_time":"2020-05-15 19:22:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101043","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094148","reservation_id":"94819","confirmation_number":"BV12277324632","room_confirmation_number":"BV12468763941","room_stay_from":"2020-05-16","room_stay_to":"2020-05-19","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":"101020","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 00:47:37","reservation_modified_date_time":"2020-05-16 03:00:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101020","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094310","reservation_id":"94830","confirmation_number":"BP12243780545","room_confirmation_number":"BP12543138865","room_stay_from":"2020-05-16","room_stay_to":"2020-05-19","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":"47798","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 13:09:21","reservation_modified_date_time":"2020-05-16 22:59:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094359","reservation_id":"94849","confirmation_number":"PB12224464779","room_confirmation_number":"PB12342380376","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","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":"101043","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 19:23:51","reservation_modified_date_time":"2020-05-17 12:58:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101043","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094362","reservation_id":"94837","confirmation_number":"PB12235658845","room_confirmation_number":"PB12384161608","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","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":"101033","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 15:07:47","reservation_modified_date_time":"2020-05-17 12:59:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101033","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094394","reservation_id":"94894","confirmation_number":"PB12290477181","room_confirmation_number":"PB12319811571","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","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":"101084","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-17 14:33:24","reservation_modified_date_time":"2020-05-17 14:33:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101084","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094449","reservation_id":"94692","confirmation_number":"PB12230261350","room_confirmation_number":"PB12392376188","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","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":"100892","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-12 03:11:12","reservation_modified_date_time":"2020-05-17 16:51:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100892","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094469","reservation_id":"94636","confirmation_number":"BP12265638208","room_confirmation_number":"BP12582834053","room_stay_from":"2020-05-10","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"20.00,20.00,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,8.00,8.00","subtotal":"180.00","grand_total":"185.32","paid_amount":"198.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100857","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-10 14:26:10","reservation_modified_date_time":"2020-05-17 17:41:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100857","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"8.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094689","reservation_id":"94812","confirmation_number":"BV12236300152","room_confirmation_number":"BV12479067750","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","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":"101173","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-14 22:06:08","reservation_modified_date_time":"2020-05-18 00:32:29","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101173","canceled_nights_data":"","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":"3094739","reservation_id":"94947","confirmation_number":"PB12293973580","room_confirmation_number":"PB12329221019","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","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":"101138","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 12:28:28","reservation_modified_date_time":"2020-05-18 12:28:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101138","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094746","reservation_id":"94949","confirmation_number":"BV12259467680","room_confirmation_number":"BV12456860745","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","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":"99857","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 13:44:49","reservation_modified_date_time":"2020-05-18 13:44:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99857","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094767","reservation_id":"94951","confirmation_number":"BP12260408051","room_confirmation_number":"BP12534539709","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","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":"101058","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 14:32:10","reservation_modified_date_time":"2020-05-18 14:32:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101058","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094888","reservation_id":"94822","confirmation_number":"PB12278985739","room_confirmation_number":"PB12327844318","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"59773","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-15 03:00:11","reservation_modified_date_time":"2020-05-18 19:04:38","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"59773","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"-12.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094890","reservation_id":"94824","confirmation_number":"PB12251120778","room_confirmation_number":"PB12313296116","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"101025","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 03:25:50","reservation_modified_date_time":"2020-05-18 19:06:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101025","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"-12.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094900","reservation_id":"94980","confirmation_number":"PB12254134537","room_confirmation_number":"PB12333496940","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","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":"101172","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-18 19:47:10","reservation_modified_date_time":"2020-05-18 19:47:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101187","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092788","reservation_id":"94661","confirmation_number":"BV12238775538","room_confirmation_number":"BV12420796461","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"100860","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-11 01:57:09","reservation_modified_date_time":"2020-05-11 01:57:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101069","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094390","reservation_id":"94492","confirmation_number":"PB12299252539","room_confirmation_number":"PB12333304661","room_stay_from":"2020-05-06","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100702","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 15:04:19","reservation_modified_date_time":"2020-05-17 14:20:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100702","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094852","reservation_id":"94924","confirmation_number":"PB12271585569","room_confirmation_number":"PB12319593837","room_stay_from":"2020-05-18","room_stay_to":"2020-05-20","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":"101118","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-17 23:56:11","reservation_modified_date_time":"2020-05-18 17:33:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101118","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093038","reservation_id":"94685","confirmation_number":"BV12246605087","room_confirmation_number":"BV12419598660","room_stay_from":"2020-05-12","room_stay_to":"2020-05-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100579","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 22:48:50","reservation_modified_date_time":"2020-05-11 22:48:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100579","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094336","reservation_id":"94834","confirmation_number":"PB12217617283","room_confirmation_number":"PB12344310731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-21","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":"101022","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 14:47:17","reservation_modified_date_time":"2020-05-17 00:00:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101022","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094370","reservation_id":"85521","confirmation_number":"PB12220890970","room_confirmation_number":"PB12345584060","room_stay_from":"2020-05-15","room_stay_to":"2020-05-21","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"92602","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-12 10:57:06","reservation_modified_date_time":"2020-05-17 13:21:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92602","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094922","reservation_id":"94330","confirmation_number":"BV12242097370","room_confirmation_number":"BV12436776795","room_stay_from":"2020-05-18","room_stay_to":"2020-05-21","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":"100389","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-02 14:55:31","reservation_modified_date_time":"2020-05-18 21:27:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100389","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092598","reservation_id":"94505","confirmation_number":"PB12288787795","room_confirmation_number":"PB12321433020","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","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":"81868","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 20:42:31","reservation_modified_date_time":"2020-05-10 14:05:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81868","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094296","reservation_id":"94505","confirmation_number":"PB12290064171","room_confirmation_number":"PB12376730984","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","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":"81868","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 20:42:31","reservation_modified_date_time":"2020-05-16 20:49:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81868","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094892","reservation_id":"94177","confirmation_number":"BP12277980546","room_confirmation_number":"BP12566714922","room_stay_from":"2020-05-18","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"101169","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-26 22:21:08","reservation_modified_date_time":"2020-05-18 19:09:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101169","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093766","reservation_id":"94749","confirmation_number":"BV12216115873","room_confirmation_number":"BV12490814010","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-13 18:00:14","reservation_modified_date_time":"2020-05-15 13:24:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093771","reservation_id":"94749","confirmation_number":"BP12268274978","room_confirmation_number":"BP12575897730","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-13 18:08:25","reservation_modified_date_time":"2020-05-15 13:26:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093776","reservation_id":"94749","confirmation_number":"BP12250430234","room_confirmation_number":"BP12584896215","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-13 18:11:37","reservation_modified_date_time":"2020-05-15 13:34:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093960","reservation_id":"94749","confirmation_number":"BP12290393180","room_confirmation_number":"BP12554397887","room_stay_from":"2020-05-15","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 15:43:52","reservation_modified_date_time":"2020-05-15 15:44:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094257","reservation_id":"94874","confirmation_number":"PB12237490259","room_confirmation_number":"PB12394895741","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","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":"101066","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-16 18:20:11","reservation_modified_date_time":"2020-05-16 18:20:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101066","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094657","reservation_id":"94774","confirmation_number":"PB12290577030","room_confirmation_number":"PB12385180723","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"101111","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-14 01:28:09","reservation_modified_date_time":"2020-05-17 22:47:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101111","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094705","reservation_id":"94932","confirmation_number":"PB12264018112","room_confirmation_number":"PB12313880138","room_stay_from":"2020-05-18","room_stay_to":"2020-05-24","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":"101124","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 01:51:42","reservation_modified_date_time":"2020-05-18 01:51:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101124","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092997","reservation_id":"93659","confirmation_number":"PB12259744424","room_confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"624.00","grand_total":"705.12","paid_amount":"705.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"76889","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-30 17:57:33","reservation_modified_date_time":"2020-05-11 20:29:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76889","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3094756","reservation_id":"93106","confirmation_number":"BP12220219925","room_confirmation_number":"BP12556512427","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1165","service_quantity":"1","product_name":"Hat\/Visor - 1 Hat\/Visor","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-18 14:04:31","reservation_modified_date_time":"2020-05-18 14:04:31","customer_id":"100968","parentCustTravId":"100968","customer_traveller_id":"100968","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3094757","reservation_id":"93106","confirmation_number":"BP12236611535","room_confirmation_number":"BP12556512427","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.20","grand_total":"4.49","paid_amount":"4.49","product_id":"1151","service_quantity":"1","product_name":"Coffee Mug","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-18 14:04:31","reservation_modified_date_time":"2020-05-18 14:04:31","customer_id":"100968","parentCustTravId":"100968","customer_traveller_id":"100968","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"4.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3094811","reservation_id":"94774","confirmation_number":"PB12280399177","room_confirmation_number":"PB12385180723","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-18 16:11:59","reservation_modified_date_time":"2020-05-18 16:11:59","customer_id":"101111","parentCustTravId":"101111","customer_traveller_id":"101111","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"37.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3094893","reservation_id":"94177","confirmation_number":"BP12250769914","room_confirmation_number":"BP12566714922","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"15.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1212","service_quantity":"4","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-18 18:00:24","reservation_modified_date_time":"2020-05-18 19:09:31","customer_id":"101169","parentCustTravId":"101169","customer_traveller_id":"101169","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"60.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3094918","reservation_id":"94661","confirmation_number":"BV12251174786","room_confirmation_number":"BV12420796461","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"10.00","paid_amount":"10.00","product_id":"1158","service_quantity":"1","product_name":"Fishing Pole","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-18 21:13:38","reservation_modified_date_time":"2020-05-18 21:13:38","customer_id":"101069","parentCustTravId":"100860","customer_traveller_id":"100860","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"9.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3094961","reservation_id":"94592","confirmation_number":"BP12254810344","room_confirmation_number":"BP12570529801","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"100.00","paid_amount":"0.00","product_id":"2010","service_quantity":"10","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-18 22:57:57","reservation_modified_date_time":"2020-05-18 22:57:57","customer_id":"101192","parentCustTravId":"101192","customer_traveller_id":"101192","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"93.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3093587","reservation_id":"94803","confirmation_number":"BP12256649581","room_confirmation_number":"BP12541491748","room_stay_from":"2020-05-16","room_stay_to":"2020-05-17","room_stay_status":"Canceled","nightly_price":"45.00","nightly_discount":"0.00","subtotal":"45.00","grand_total":"50.85","paid_amount":"0.00","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-14 19:18:45","reservation_modified_date_time":"2020-05-14 19:18:45","customer_id":"63604","parentCustTravId":"63604","customer_traveller_id":"63604","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-18 20:50:29","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-45,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3094193","reservation_id":"94674","confirmation_number":"PB12280845054","room_confirmation_number":"PB12376796511","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":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-16 15:37:06","reservation_modified_date_time":"2020-05-16 15:37:06","customer_id":"100873","parentCustTravId":"100873","customer_traveller_id":"100873","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-05-18 14:47:28","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-37.4,"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":"3094227","reservation_id":"94763","confirmation_number":"PB12286533931","room_confirmation_number":"PB12364882712","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":"80.04","paid_amount":"0.00","product_id":"2010","service_quantity":"8","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-15 19:33:35","reservation_modified_date_time":"2020-05-16 17:13:04","customer_id":"100966","parentCustTravId":"100966","customer_traveller_id":"100966","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-05-18 13:52:24","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-74.8,"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":17,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1108,1091,1113,1106,1103","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12276061450","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","bundle_room":"0"},{"confirmation_number":"PB12257228645","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","bundle_room":"0"},{"confirmation_number":"PB12298565194","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","bundle_room":"0"},{"confirmation_number":"PB12258619196","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","bundle_room":"0"},{"confirmation_number":"PB12260697091","room_stay_from":"2020-05-18","room_stay_to":"2020-05-20","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3094851","reservation_id":"94924","confirmation_number":"PB12319593837","room_stay_from":"2020-05-18","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"125.37,125.37","nightly_discount":"0,0","subtotal":"250.74","grand_total":"283.33","paid_amount":"283.33","room_type_id":"285","product_id":"1085","siteminder_id":"BDC-2551073653","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":"101118","customer_id":"101118","source_of_creation":"Booking.com","reservation_created_date":"2020-05-17 23:56:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"43.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"125.37","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3093207","reservation_id":"94349","confirmation_number":"PB12313626819","room_stay_from":"2020-05-12","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.29,117.29,117.29,143.47,143.47,117.29,117.29","nightly_discount":"0,0,0,0,0,0,0","subtotal":"873.39","grand_total":"986.93","paid_amount":"986.93","room_type_id":"289","product_id":"1111","siteminder_id":"GAM-R1953915007","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":"83852","customer_id":"83852","source_of_creation":"Getaroom.com","reservation_created_date":"2020-05-02 18:11:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.29","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":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3094899","reservation_id":"94980","confirmation_number":"PB12333496940","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"80.10","nightly_discount":"0","subtotal":"80.10","grand_total":"90.52","paid_amount":"90.52","room_type_id":"292","product_id":"1120","siteminder_id":"HWR-302149359","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":"101172","customer_id":"101187","source_of_creation":"Hotwire","reservation_created_date":"2020-05-18 19:47:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"80.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"}]}],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3094887","reservation_id":"94822","confirmation_number":"PB12327844318","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"144.54,144.54","nightly_discount":"0.00,18.00","subtotal":"289.08","grand_total":"306.32","paid_amount":"306.32","room_type_id":"289","product_id":"1112","siteminder_id":"GCC-0008100080-064","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":"59773","customer_id":"59773","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-05-15 03:00:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.54","currentDayDiscount":"18.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094255","reservation_id":"94874","confirmation_number":"PB12394895741","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"142.55,142.55,142.55,142.55,142.55,209.05","nightly_discount":"0,0,0,0,0,0","subtotal":"921.80","grand_total":"1041.64","paid_amount":"1041.64","room_type_id":"289","product_id":"1109","siteminder_id":"GCC-0008300082-064","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101066","customer_id":"101066","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-05-16 18:20:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"142.55","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3094369","reservation_id":"85521","confirmation_number":"PB12345584060","room_stay_from":"2020-05-15","room_stay_to":"2020-05-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.90,147.90,126.23,126.23,126.23,126.23","nightly_discount":"0,0,0,0,0,0","subtotal":"800.72","grand_total":"904.81","paid_amount":"904.81","room_type_id":"313","product_id":"1228","siteminder_id":"AGO-252881199","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":"92602","customer_id":"92602","source_of_creation":"Agoda","reservation_created_date":"2019-10-12 10:57:06","canceled_nights_data":"","product_name":"PB Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.23","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":"3094658","reservation_id":"94774","confirmation_number":"PB12385180723","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"106.56,106.56,106.56,106.56,106.56,205.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"738.38","grand_total":"834.37","paid_amount":"834.37","room_type_id":"289","product_id":"1098","siteminder_id":"AGO-318681282","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101111","customer_id":"101111","source_of_creation":"Agoda","reservation_created_date":"2020-05-14 01:28:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"106.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3094446","reservation_id":"94692","confirmation_number":"PB12392376188","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129.00,129.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100892","customer_id":"100892","source_of_creation":"FE","reservation_created_date":"2020-05-12 03:11:12","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":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094889","reservation_id":"94824","confirmation_number":"PB12313296116","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"144.54,144.54","nightly_discount":"0.00,0.00","subtotal":"289.08","grand_total":"326.66","paid_amount":"326.66","room_type_id":"289","product_id":"1107","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101025","customer_id":"101025","source_of_creation":"FE","reservation_created_date":"2020-05-15 03:25:50","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.54","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3093286","reservation_id":"94442","confirmation_number":"PB12357868640","room_stay_from":"2020-05-13","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,159.00,159.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"834.00","grand_total":"942.42","paid_amount":"942.42","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100156","customer_id":"100156","source_of_creation":"PMS","reservation_created_date":"2020-05-05 14:09:21","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":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094045","reservation_id":"94849","confirmation_number":"PB12386197731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101043","customer_id":"101043","source_of_creation":"PMS","reservation_created_date":"2020-05-15 19:22:54","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094358","reservation_id":"94849","confirmation_number":"PB12342380376","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101043","customer_id":"101043","source_of_creation":"PMS","reservation_created_date":"2020-05-15 19:23:51","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094360","reservation_id":"94837","confirmation_number":"PB12384161608","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"129.00,129.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101033","customer_id":"101033","source_of_creation":"PMS","reservation_created_date":"2020-05-15 15:07:47","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094393","reservation_id":"94894","confirmation_number":"PB12319811571","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"149.00,149.00","nightly_discount":"0.00,0.00","subtotal":"298.00","grand_total":"336.74","paid_amount":"336.74","room_type_id":"291","product_id":"1115","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":"101084","customer_id":"101084","source_of_creation":"PMS","reservation_created_date":"2020-05-17 14:33:24","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094738","reservation_id":"94947","confirmation_number":"PB12329221019","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00","nightly_discount":"0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","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":"101138","customer_id":"101138","source_of_creation":"PMS","reservation_created_date":"2020-05-18 12:28:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3094388","reservation_id":"94492","confirmation_number":"PB12333304661","room_stay_from":"2020-05-06","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0,0,0,0,0,0,0,0,0,0","subtotal":"1386.00","grand_total":"1566.18","paid_amount":"1566.18","room_type_id":"291","product_id":"1118","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":"100702","customer_id":"100702","source_of_creation":"PMS","reservation_created_date":"2020-05-06 15:04:19","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.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":"3094335","reservation_id":"94834","confirmation_number":"PB12344310731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0","subtotal":"516.00","grand_total":"583.08","paid_amount":"583.08","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101022","customer_id":"101022","source_of_creation":"PMS","reservation_created_date":"2020-05-15 14:47:17","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092596","reservation_id":"94505","confirmation_number":"PB12321433020","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"159.00,129.00,129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"804.00","grand_total":"908.52","paid_amount":"908.52","room_type_id":"289","product_id":"1105","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"81868","customer_id":"81868","source_of_creation":"PMS","reservation_created_date":"2020-05-06 20:42:31","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094295","reservation_id":"94505","confirmation_number":"PB12376730984","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,129.00,129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,35.58","subtotal":"804.00","grand_total":"868.32","paid_amount":"868.32","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":"81868","customer_id":"81868","source_of_creation":"PMS","reservation_created_date":"2020-05-06 20:42:31","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":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094704","reservation_id":"94932","confirmation_number":"PB12313880138","room_stay_from":"2020-05-18","room_stay_to":"2020-05-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,129.00,199.00,199.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"914.00","grand_total":"1032.82","paid_amount":"1032.82","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":"101124","customer_id":"101124","source_of_creation":"PMS","reservation_created_date":"2020-05-18 01:51:42","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":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092996","reservation_id":"93659","confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,89.00,89.00,89.00,89.00,89.00,89.00,89.00,99.00,89.00,89.00,89.00,89.00,89.00,99.00,109.00,99.00,99.00,99.00,99.00,99.00,109.00,129.00,99.00,99.00,99.00,99.00,109.00,109.00,109.00,99.00,99.00,99.00,99.00,99.00,129.00,129.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,69.26,5.00,0.00,0.00,0.00,0.00,0.00,0.00,40.00,0.00,0.00,0.00,0.00,0.00,0.00,42.00,0.00,0.00,0.00,0.00,0.00,0.00,39.85,0.00,0.00,0.00,0.00,0.00,0.00,41.16,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"5098.00","grand_total":"5492.62","paid_amount":"5492.62","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76889","customer_id":"76889","source_of_creation":"PMS","reservation_created_date":"2020-03-30 17:57:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"3094754","reservation_id":"94808","confirmation_number":"PB12391119814","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Canceled","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129.00","nightly_discount":"0.00","subtotal":"129.00","grand_total":"145.77","paid_amount":"145.77","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":"101010","customer_id":"101010","source_of_creation":"PMS","reservation_created_date":"2020-05-14 21:00:35","service_canceled_date_time":"2020-05-18 14:16:36","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"145.77","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":"3094361","reservation_id":"94837","confirmation_number":"PB12295655083","room_confirmation_number":"PB12384161608","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"101033","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-17 12:59:36","reservation_modified_date_time":"2020-05-17 12:59:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101033","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094395","reservation_id":"94894","confirmation_number":"PB12229330249","room_confirmation_number":"PB12319811571","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","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":"1780","service_quantity":"1","customer_traveller_id":"101084","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-17 14:33:24","reservation_modified_date_time":"2020-05-17 14:33:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101084","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094448","reservation_id":"94692","confirmation_number":"PB12289025294","room_confirmation_number":"PB12392376188","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"100892","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-17 16:51:08","reservation_modified_date_time":"2020-05-17 16:51:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100892","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094527","reservation_id":"94822","confirmation_number":"PB12221600367","room_confirmation_number":"PB12327844318","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"59773","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-17 19:09:48","reservation_modified_date_time":"2020-05-17 19:16:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"59773","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094537","reservation_id":"94824","confirmation_number":"PB12242378685","room_confirmation_number":"PB12313296116","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"101025","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-17 19:10:12","reservation_modified_date_time":"2020-05-17 19:17:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101025","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092597","reservation_id":"94505","confirmation_number":"PB12215674144","room_confirmation_number":"PB12321433020","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"81868","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-10 14:05:00","reservation_modified_date_time":"2020-05-10 14:05:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81868","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094256","reservation_id":"94874","confirmation_number":"PB12233320938","room_confirmation_number":"PB12394895741","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"101066","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-16 18:20:11","reservation_modified_date_time":"2020-05-16 18:20:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101066","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094656","reservation_id":"94774","confirmation_number":"PB12283914742","room_confirmation_number":"PB12385180723","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"30.00,30.00,30.00,30.00,30.00,30.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"101111","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-17 22:24:35","reservation_modified_date_time":"2020-05-17 22:47:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101111","canceled_nights_data":"","currentDayPrice":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094659","reservation_id":"94912","confirmation_number":"PB12232496351","room_confirmation_number":"PB12329902124","room_stay_from":"2020-05-17","room_stay_to":"2020-05-18","room_stay_status":"Canceled","nightly_price":"30","nightly_discount":"0","subtotal":"30.00","grand_total":"33.90","paid_amount":"0.00","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-17 22:13:34","reservation_modified_date_time":"2020-05-17 22:49:07","customer_id":"101115","parentCustTravId":"101115","customer_traveller_id":"101115","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-18 14:08:56","canceled_nights_data":"","product_attribute_values":"extra_person#&#10.00","deltaChange":-30,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"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":"3093208","reservation_id":"94349","confirmation_number":"PB12281730192","room_confirmation_number":"PB12313626819","room_stay_from":"2020-05-12","room_stay_to":"2020-05-19","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":"83852","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-02 18:11:06","reservation_modified_date_time":"2020-05-12 20:32:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83852","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093287","reservation_id":"94442","confirmation_number":"PB12271944397","room_confirmation_number":"PB12357868640","room_stay_from":"2020-05-13","room_stay_to":"2020-05-19","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":"100156","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-05 14:09:21","reservation_modified_date_time":"2020-05-13 13:48:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100156","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094046","reservation_id":"94849","confirmation_number":"PB12238272550","room_confirmation_number":"PB12386197731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","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":"101043","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 19:22:54","reservation_modified_date_time":"2020-05-15 19:22:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101043","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094359","reservation_id":"94849","confirmation_number":"PB12224464779","room_confirmation_number":"PB12342380376","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","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":"101043","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 19:23:51","reservation_modified_date_time":"2020-05-17 12:58:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101043","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094362","reservation_id":"94837","confirmation_number":"PB12235658845","room_confirmation_number":"PB12384161608","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","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":"101033","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 15:07:47","reservation_modified_date_time":"2020-05-17 12:59:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101033","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094394","reservation_id":"94894","confirmation_number":"PB12290477181","room_confirmation_number":"PB12319811571","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","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":"101084","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-17 14:33:24","reservation_modified_date_time":"2020-05-17 14:33:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101084","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094449","reservation_id":"94692","confirmation_number":"PB12230261350","room_confirmation_number":"PB12392376188","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","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":"100892","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-12 03:11:12","reservation_modified_date_time":"2020-05-17 16:51:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100892","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094739","reservation_id":"94947","confirmation_number":"PB12293973580","room_confirmation_number":"PB12329221019","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","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":"101138","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 12:28:28","reservation_modified_date_time":"2020-05-18 12:28:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101138","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094888","reservation_id":"94822","confirmation_number":"PB12278985739","room_confirmation_number":"PB12327844318","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"59773","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-15 03:00:11","reservation_modified_date_time":"2020-05-18 19:04:38","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"59773","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"-12.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094890","reservation_id":"94824","confirmation_number":"PB12251120778","room_confirmation_number":"PB12313296116","room_stay_from":"2020-05-17","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"101025","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 03:25:50","reservation_modified_date_time":"2020-05-18 19:06:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101025","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"-12.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094900","reservation_id":"94980","confirmation_number":"PB12254134537","room_confirmation_number":"PB12333496940","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","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":"101172","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-18 19:47:10","reservation_modified_date_time":"2020-05-18 19:47:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101187","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094390","reservation_id":"94492","confirmation_number":"PB12299252539","room_confirmation_number":"PB12333304661","room_stay_from":"2020-05-06","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100702","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 15:04:19","reservation_modified_date_time":"2020-05-17 14:20:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100702","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094852","reservation_id":"94924","confirmation_number":"PB12271585569","room_confirmation_number":"PB12319593837","room_stay_from":"2020-05-18","room_stay_to":"2020-05-20","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":"101118","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-17 23:56:11","reservation_modified_date_time":"2020-05-18 17:33:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101118","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094336","reservation_id":"94834","confirmation_number":"PB12217617283","room_confirmation_number":"PB12344310731","room_stay_from":"2020-05-17","room_stay_to":"2020-05-21","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":"101022","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 14:47:17","reservation_modified_date_time":"2020-05-17 00:00:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101022","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094370","reservation_id":"85521","confirmation_number":"PB12220890970","room_confirmation_number":"PB12345584060","room_stay_from":"2020-05-15","room_stay_to":"2020-05-21","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"92602","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-12 10:57:06","reservation_modified_date_time":"2020-05-17 13:21:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92602","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092598","reservation_id":"94505","confirmation_number":"PB12288787795","room_confirmation_number":"PB12321433020","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","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":"81868","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 20:42:31","reservation_modified_date_time":"2020-05-10 14:05:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81868","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094296","reservation_id":"94505","confirmation_number":"PB12290064171","room_confirmation_number":"PB12376730984","room_stay_from":"2020-05-16","room_stay_to":"2020-05-22","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":"81868","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 20:42:31","reservation_modified_date_time":"2020-05-16 20:49:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"81868","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094257","reservation_id":"94874","confirmation_number":"PB12237490259","room_confirmation_number":"PB12394895741","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","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":"101066","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-16 18:20:11","reservation_modified_date_time":"2020-05-16 18:20:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101066","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094657","reservation_id":"94774","confirmation_number":"PB12290577030","room_confirmation_number":"PB12385180723","room_stay_from":"2020-05-17","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"101111","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-14 01:28:09","reservation_modified_date_time":"2020-05-17 22:47:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101111","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094705","reservation_id":"94932","confirmation_number":"PB12264018112","room_confirmation_number":"PB12313880138","room_stay_from":"2020-05-18","room_stay_to":"2020-05-24","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":"101124","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 01:51:42","reservation_modified_date_time":"2020-05-18 01:51:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101124","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092997","reservation_id":"93659","confirmation_number":"PB12259744424","room_confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"624.00","grand_total":"705.12","paid_amount":"705.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"76889","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-30 17:57:33","reservation_modified_date_time":"2020-05-11 20:29:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76889","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3094811","reservation_id":"94774","confirmation_number":"PB12280399177","room_confirmation_number":"PB12385180723","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-18 16:11:59","reservation_modified_date_time":"2020-05-18 16:11:59","customer_id":"101111","parentCustTravId":"101111","customer_traveller_id":"101111","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"37.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3094193","reservation_id":"94674","confirmation_number":"PB12280845054","room_confirmation_number":"PB12376796511","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":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-16 15:37:06","reservation_modified_date_time":"2020-05-16 15:37:06","customer_id":"100873","parentCustTravId":"100873","customer_traveller_id":"100873","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-05-18 14:47:28","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-37.4,"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":"3094227","reservation_id":"94763","confirmation_number":"PB12286533931","room_confirmation_number":"PB12364882712","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":"80.04","paid_amount":"0.00","product_id":"2010","service_quantity":"8","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-15 19:33:35","reservation_modified_date_time":"2020-05-16 17:13:04","customer_id":"100966","parentCustTravId":"100966","customer_traveller_id":"100966","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-05-18 13:52:24","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-74.8,"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":6,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3094687","reservation_id":"94812","confirmation_number":"BV12479067750","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.03","nightly_discount":"0.00","subtotal":"96.03","grand_total":"125.29","paid_amount":"125.29","room_type_id":"307","product_id":"1224","siteminder_id":"ABB-HMPP5TNTH4","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"96.03","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101173","customer_id":"101173","source_of_creation":"Airbnb","reservation_created_date":"2020-05-14 22:06:08","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"13.42","commision_charges":"2.97","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.03","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3092786","reservation_id":"94661","confirmation_number":"BV12420796461","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"139.52,70.53,70.53,70.53","nightly_discount":"0,0,0,0","subtotal":"351.11","grand_total":"396.76","paid_amount":"396.76","room_type_id":"303","product_id":"1140","siteminder_id":"AGO-318367766","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100860","customer_id":"101069","source_of_creation":"Agoda","reservation_created_date":"2020-05-11 01:57:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"70.53","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3094921","reservation_id":"94330","confirmation_number":"BV12436776795","room_stay_from":"2020-05-18","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"99.00,99.00,99.00","nightly_discount":"0.00,0.00,15.23","subtotal":"297.00","grand_total":"318.40","paid_amount":"318.40","room_type_id":"303","product_id":"1139","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100389","customer_id":"100389","source_of_creation":"FE","reservation_created_date":"2020-05-02 14:55:31","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3094146","reservation_id":"94819","confirmation_number":"BV12468763941","room_stay_from":"2020-05-16","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00","subtotal":"297.00","grand_total":"335.61","paid_amount":"335.61","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101020","customer_id":"101020","source_of_creation":"PMS","reservation_created_date":"2020-05-15 00:47:37","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094745","reservation_id":"94949","confirmation_number":"BV12456860745","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.91","nightly_discount":"0.00","subtotal":"92.91","grand_total":"104.98","paid_amount":"104.98","room_type_id":"308","product_id":"1225","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99857","customer_id":"99857","source_of_creation":"PMS","reservation_created_date":"2020-05-18 13:44:49","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"92.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093037","reservation_id":"94685","confirmation_number":"BV12419598660","room_stay_from":"2020-05-12","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","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":"100579","customer_id":"100579","source_of_creation":"PMS","reservation_created_date":"2020-05-11 22:48:50","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":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093765","reservation_id":"94749","confirmation_number":"BV12490814010","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1296.00","grand_total":"1385.16","paid_amount":"1385.16","room_type_id":"305","product_id":"1222","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":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-13 18:00:14","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3092787","reservation_id":"94661","confirmation_number":"BV12245087623","room_confirmation_number":"BV12420796461","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"100860","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-11 01:57:09","reservation_modified_date_time":"2020-05-11 01:57:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101069","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094685","reservation_id":"94330","confirmation_number":"BV12263553621","room_confirmation_number":"BV12436776795","room_stay_from":"2020-05-18","room_stay_to":"2020-05-21","room_stay_status":"Active","nightly_price":"40,40,40","nightly_discount":"0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100389","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-18 00:30:06","reservation_modified_date_time":"2020-05-18 00:30:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100389","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093351","reservation_id":"94749","confirmation_number":"BV12289705702","room_confirmation_number":"BV12490814010","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-13 18:00:14","reservation_modified_date_time":"2020-05-13 18:00:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3094148","reservation_id":"94819","confirmation_number":"BV12277324632","room_confirmation_number":"BV12468763941","room_stay_from":"2020-05-16","room_stay_to":"2020-05-19","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":"101020","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 00:47:37","reservation_modified_date_time":"2020-05-16 03:00:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101020","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094689","reservation_id":"94812","confirmation_number":"BV12236300152","room_confirmation_number":"BV12479067750","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","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":"101173","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-14 22:06:08","reservation_modified_date_time":"2020-05-18 00:32:29","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101173","canceled_nights_data":"","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":"3094746","reservation_id":"94949","confirmation_number":"BV12259467680","room_confirmation_number":"BV12456860745","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","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":"99857","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 13:44:49","reservation_modified_date_time":"2020-05-18 13:44:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99857","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092788","reservation_id":"94661","confirmation_number":"BV12238775538","room_confirmation_number":"BV12420796461","room_stay_from":"2020-05-16","room_stay_to":"2020-05-20","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"100860","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-11 01:57:09","reservation_modified_date_time":"2020-05-11 01:57:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101069","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093038","reservation_id":"94685","confirmation_number":"BV12246605087","room_confirmation_number":"BV12419598660","room_stay_from":"2020-05-12","room_stay_to":"2020-05-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100579","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 22:48:50","reservation_modified_date_time":"2020-05-11 22:48:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100579","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094922","reservation_id":"94330","confirmation_number":"BV12242097370","room_confirmation_number":"BV12436776795","room_stay_from":"2020-05-18","room_stay_to":"2020-05-21","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":"100389","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-02 14:55:31","reservation_modified_date_time":"2020-05-18 21:27:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100389","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093766","reservation_id":"94749","confirmation_number":"BV12216115873","room_confirmation_number":"BV12490814010","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-13 18:00:14","reservation_modified_date_time":"2020-05-15 13:24:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3094918","reservation_id":"94661","confirmation_number":"BV12251174786","room_confirmation_number":"BV12420796461","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"10.00","paid_amount":"10.00","product_id":"1158","service_quantity":"1","product_name":"Fishing Pole","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-18 21:13:38","reservation_modified_date_time":"2020-05-18 21:13:38","customer_id":"101069","parentCustTravId":"100860","customer_traveller_id":"100860","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"9.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":5,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3094467","reservation_id":"94636","confirmation_number":"BP12582834053","room_stay_from":"2020-05-10","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"154.54,154.54,154.54,154.54,154.54,154.54,154.54,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1279.78","grand_total":"1446.15","paid_amount":"1558.02","room_type_id":"296","product_id":"1131","siteminder_id":"EXP-1663504401","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100857","customer_id":"100857","source_of_creation":"Expedia","reservation_created_date":"2020-05-10 14:26:10","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094894","reservation_id":"94177","confirmation_number":"BP12566714922","room_stay_from":"2020-05-18","room_stay_to":"2020-05-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"100.61,100.61,100.61,100.61","nightly_discount":"0,0,0,0","subtotal":"402.44","grand_total":"454.76","paid_amount":"454.76","room_type_id":"302","product_id":"1138","siteminder_id":"EXP-1661980243","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101169","customer_id":"101169","source_of_creation":"Expedia","reservation_created_date":"2020-04-26 22:21:08","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.61","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3093820","reservation_id":"94592","confirmation_number":"BP12570529801","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"155.37","nightly_discount":"0","subtotal":"155.37","grand_total":"211.86","paid_amount":"211.86","room_type_id":"301","product_id":"1137","siteminder_id":"ABB-HM28B3BWAA","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"155.37","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"101192","customer_id":"101192","source_of_creation":"Airbnb","reservation_created_date":"2020-05-09 04:02:04","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 824","ota_service_fee_amount":"25.91","commision_charges":"5.73","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"155.37","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":"3094311","reservation_id":"94830","confirmation_number":"BP12543138865","room_stay_from":"2020-05-16","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","room_type_id":"300","product_id":"1135","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"PMS","reservation_created_date":"2020-05-15 13:09:21","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 805","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094766","reservation_id":"94951","confirmation_number":"BP12534539709","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"293","product_id":"1124","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":"101058","customer_id":"101058","source_of_creation":"PMS","reservation_created_date":"2020-05-18 14:32:10","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093770","reservation_id":"94749","confirmation_number":"BP12575897730","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1296.00","grand_total":"1385.16","paid_amount":"1385.16","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-13 18:08:25","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093775","reservation_id":"94749","confirmation_number":"BP12584896215","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1296.00","grand_total":"1385.16","paid_amount":"1385.16","room_type_id":"294","product_id":"1125","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-13 18:11:37","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 803","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093959","reservation_id":"94749","confirmation_number":"BP12554397887","room_stay_from":"2020-05-15","room_stay_to":"2020-05-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.20","subtotal":"1152.00","grand_total":"1222.44","paid_amount":"1222.44","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":"100951","customer_id":"100951","source_of_creation":"PMS","reservation_created_date":"2020-05-15 15:43:52","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":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3093821","reservation_id":"94592","confirmation_number":"BP12266106994","room_confirmation_number":"BP12570529801","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"30","nightly_discount":"0.00","subtotal":"30.00","grand_total":"30.00","paid_amount":"30.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"101192","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-15 14:55:59","reservation_modified_date_time":"2020-05-15 14:55:59","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101192","canceled_nights_data":"","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]},{"room_stay_id":"3094468","reservation_id":"94636","confirmation_number":"BP12262596252","room_confirmation_number":"BP12582834053","room_stay_from":"2020-05-10","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0,0,0,0,0","subtotal":"180.00","grand_total":"203.40","paid_amount":"48.85","product_id":"1780","service_quantity":"1","customer_traveller_id":"100857","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-17 17:41:18","reservation_modified_date_time":"2020-05-17 17:41:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100857","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094768","reservation_id":"94951","confirmation_number":"BP12295717268","room_confirmation_number":"BP12534539709","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","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":"1780","service_quantity":"1","customer_traveller_id":"101058","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-18 14:32:10","reservation_modified_date_time":"2020-05-18 14:32:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101058","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094891","reservation_id":"94177","confirmation_number":"BP12294908038","room_confirmation_number":"BP12566714922","room_stay_from":"2020-05-18","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"101169","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-18 17:54:51","reservation_modified_date_time":"2020-05-18 19:09:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101169","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093358","reservation_id":"94749","confirmation_number":"BP12248443950","room_confirmation_number":"BP12584896215","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-13 18:11:37","reservation_modified_date_time":"2020-05-13 18:11:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3093822","reservation_id":"94592","confirmation_number":"BP12268359896","room_confirmation_number":"BP12570529801","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","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":"101192","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-09 04:02:04","reservation_modified_date_time":"2020-05-15 14:56:00","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101192","canceled_nights_data":"","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":"3094310","reservation_id":"94830","confirmation_number":"BP12243780545","room_confirmation_number":"BP12543138865","room_stay_from":"2020-05-16","room_stay_to":"2020-05-19","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":"47798","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 13:09:21","reservation_modified_date_time":"2020-05-16 22:59:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094469","reservation_id":"94636","confirmation_number":"BP12265638208","room_confirmation_number":"BP12582834053","room_stay_from":"2020-05-10","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"20.00,20.00,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,8.00,8.00","subtotal":"180.00","grand_total":"185.32","paid_amount":"198.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100857","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-10 14:26:10","reservation_modified_date_time":"2020-05-17 17:41:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100857","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"8.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094767","reservation_id":"94951","confirmation_number":"BP12260408051","room_confirmation_number":"BP12534539709","room_stay_from":"2020-05-18","room_stay_to":"2020-05-19","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":"101058","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-18 14:32:10","reservation_modified_date_time":"2020-05-18 14:32:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101058","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3094892","reservation_id":"94177","confirmation_number":"BP12277980546","room_confirmation_number":"BP12566714922","room_stay_from":"2020-05-18","room_stay_to":"2020-05-22","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"101169","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-26 22:21:08","reservation_modified_date_time":"2020-05-18 19:09:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101169","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093771","reservation_id":"94749","confirmation_number":"BP12268274978","room_confirmation_number":"BP12575897730","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-13 18:08:25","reservation_modified_date_time":"2020-05-15 13:26:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093776","reservation_id":"94749","confirmation_number":"BP12250430234","room_confirmation_number":"BP12584896215","room_stay_from":"2020-05-14","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-13 18:11:37","reservation_modified_date_time":"2020-05-15 13:34:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093960","reservation_id":"94749","confirmation_number":"BP12290393180","room_confirmation_number":"BP12554397887","room_stay_from":"2020-05-15","room_stay_to":"2020-05-23","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"100951","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-15 15:43:52","reservation_modified_date_time":"2020-05-15 15:44:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100951","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3094756","reservation_id":"93106","confirmation_number":"BP12220219925","room_confirmation_number":"BP12556512427","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1165","service_quantity":"1","product_name":"Hat\/Visor - 1 Hat\/Visor","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-18 14:04:31","reservation_modified_date_time":"2020-05-18 14:04:31","customer_id":"100968","parentCustTravId":"100968","customer_traveller_id":"100968","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3094757","reservation_id":"93106","confirmation_number":"BP12236611535","room_confirmation_number":"BP12556512427","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.20","grand_total":"4.49","paid_amount":"4.49","product_id":"1151","service_quantity":"1","product_name":"Coffee Mug","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-18 14:04:31","reservation_modified_date_time":"2020-05-18 14:04:31","customer_id":"100968","parentCustTravId":"100968","customer_traveller_id":"100968","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"4.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3094893","reservation_id":"94177","confirmation_number":"BP12250769914","room_confirmation_number":"BP12566714922","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"15.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1212","service_quantity":"4","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-18 18:00:24","reservation_modified_date_time":"2020-05-18 19:09:31","customer_id":"101169","parentCustTravId":"101169","customer_traveller_id":"101169","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"60.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3094961","reservation_id":"94592","confirmation_number":"BP12254810344","room_confirmation_number":"BP12570529801","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"100.00","paid_amount":"0.00","product_id":"2010","service_quantity":"10","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-18 22:57:57","reservation_modified_date_time":"2020-05-18 22:57:57","customer_id":"101192","parentCustTravId":"101192","customer_traveller_id":"101192","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"93.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3093587","reservation_id":"94803","confirmation_number":"BP12256649581","room_confirmation_number":"BP12541491748","room_stay_from":"2020-05-16","room_stay_to":"2020-05-17","room_stay_status":"Canceled","nightly_price":"45.00","nightly_discount":"0.00","subtotal":"45.00","grand_total":"50.85","paid_amount":"0.00","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-14 19:18:45","reservation_modified_date_time":"2020-05-14 19:18:45","customer_id":"63604","parentCustTravId":"63604","customer_traveller_id":"63604","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-18 20:50:29","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-45,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}