{"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,1113,1114,1115,1116,1117,1118,1119,1120,1121,1123","departureCount":16,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3035085","reservation_id":"81674","confirmation_number":"PB12330227029","room_stay_from":"2019-11-03","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.58","nightly_discount":"0","subtotal":"122.58","grand_total":"138.51","paid_amount":"138.52","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3196961433","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":"89549","customer_id":"89549","source_of_creation":"Booking.com","reservation_created_date":"2019-07-29 19:34:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"18.39","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"122.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035453","reservation_id":"85325","confirmation_number":"PB12390510045","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.27,113.83,113.83,113.83","nightly_discount":"0,0,0,0","subtotal":"466.76","grand_total":"527.44","paid_amount":"527.44","room_type_id":"289","product_id":"1104","siteminder_id":"BDC-2129342521","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":"92484","customer_id":"92484","source_of_creation":"Booking.com","reservation_created_date":"2019-10-08 23:56:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"70.01","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2994977","reservation_id":"80124","confirmation_number":"PB12334951050","room_stay_from":"2019-10-30","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.14,62.14,68.89,68.89,62.14","nightly_discount":"0,0,0,0,0","subtotal":"324.20","grand_total":"366.34","paid_amount":"366.34","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1291935132","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":"88539","customer_id":"88539","source_of_creation":"Expedia","reservation_created_date":"2019-07-03 22:14:09","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.14","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":"2995840","reservation_id":"80323","confirmation_number":"PB12334096993","room_stay_from":"2019-11-01","room_stay_to":"2019-11-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"154.32,154.32,144.93,144.93","nightly_discount":"0,0,0,0","subtotal":"598.50","grand_total":"676.31","paid_amount":"676.31","room_type_id":"287","product_id":"1089","siteminder_id":"EXP-1294052218","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88643","customer_id":"88643","source_of_creation":"Expedia","reservation_created_date":"2019-07-06 23:04:08","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.93","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":"3010644","reservation_id":"82680","confirmation_number":"PB12370338217","room_stay_from":"2019-10-30","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"86.16,86.16,94.82,94.82,86.16","nightly_discount":"0,0,0,0,0","subtotal":"448.12","grand_total":"506.38","paid_amount":"506.38","room_type_id":"289","product_id":"1095","siteminder_id":"EXP-1322482082","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":"90712","customer_id":"90712","source_of_creation":"Expedia","reservation_created_date":"2019-08-15 14:32:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"86.16","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":"3022428","reservation_id":"84672","confirmation_number":"PB12373349068","room_stay_from":"2019-10-31","room_stay_to":"2019-11-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.01,92.45,92.45,84.01,84.01","nightly_discount":"0,0,0,0,0","subtotal":"436.93","grand_total":"493.74","paid_amount":"493.74","room_type_id":"289","product_id":"1103","siteminder_id":"EXP-1349320343","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":"22954","customer_id":"22954","source_of_creation":"Expedia","reservation_created_date":"2019-09-25 11:27:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.01","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":"3033940","reservation_id":"86044","confirmation_number":"PB12311283691","room_stay_from":"2019-10-31","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"84.01,92.45,110.94,84.01","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"371.41","grand_total":"419.69","paid_amount":"419.69","room_type_id":"289","product_id":"1110","siteminder_id":"EXP-1365886391","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":"92916","customer_id":"92916","source_of_creation":"Expedia","reservation_created_date":"2019-10-21 16:41:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.01","currentDayDiscount":"0.00","productIsTaxExempt":false,"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_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3000885","reservation_id":"81098","confirmation_number":"PB12372965350","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"416.00","grand_total":"470.08","paid_amount":"470.08","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"73566","customer_id":"73566","source_of_creation":"FE","reservation_created_date":"2019-07-20 17:34:52","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3010055","reservation_id":"82558","confirmation_number":"PB12344483140","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"135.20,135.20,119.20","nightly_discount":"0.00,0.00,0.00","subtotal":"389.60","grand_total":"440.25","paid_amount":"440.25","room_type_id":"291","product_id":"1114","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":"90155","customer_id":"90155","source_of_creation":"FE","reservation_created_date":"2019-08-13 00:49:14","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.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":"3034501","reservation_id":"84549","confirmation_number":"PB12325384614","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.60,129.60,129.60,129.60","nightly_discount":"21.84,0.00,0.00,0.00","subtotal":"534.40","grand_total":"579.19","paid_amount":"579.19","room_type_id":"288","product_id":"1091","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":"84601","customer_id":"84601","source_of_creation":"FE","reservation_created_date":"2019-09-22 23:18:22","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3007979","reservation_id":"82189","confirmation_number":"PB12368226074","room_stay_from":"2019-10-29","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00,110.00,110.00,95.00,95.00,95.00,95.00,95.00,110.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1090.00","grand_total":"1231.70","paid_amount":"1231.70","room_type_id":"289","product_id":"1109","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":"89930","customer_id":"89930","source_of_creation":"PMS","reservation_created_date":"2019-08-07 18:22:47","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":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3033212","reservation_id":"84318","confirmation_number":"PB12392575211","room_stay_from":"2019-10-28","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,96.00,96.00,112.00,112.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,51.73,0.00","subtotal":"896.00","grand_total":"954.03","paid_amount":"954.03","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":"79718","customer_id":"79718","source_of_creation":"PMS","reservation_created_date":"2019-09-18 16:58:00","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3033674","reservation_id":"84275","confirmation_number":"PB12357335231","room_stay_from":"2019-10-30","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,120.00,120.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,25.40,0.00","subtotal":"552.00","grand_total":"595.06","paid_amount":"595.06","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"26314","customer_id":"26314","source_of_creation":"PMS","reservation_created_date":"2019-09-17 22:41:49","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":"104.00","currentDayDiscount":"25.40","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034298","reservation_id":"84357","confirmation_number":"PB12372913252","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.80,100.80,86.40,86.40,86.40,86.40,86.40","nightly_discount":"27.34,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"633.60","grand_total":"685.08","paid_amount":"685.08","room_type_id":"289","product_id":"1111","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91826","customer_id":"91826","source_of_creation":"PMS","reservation_created_date":"2019-09-19 17:46:28","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":"86.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":"3034302","reservation_id":"84333","confirmation_number":"PB12340155718","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,20.22,0.00","subtotal":"384.00","grand_total":"411.07","paid_amount":"411.08","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"42262","customer_id":"42262","source_of_creation":"PMS","reservation_created_date":"2019-09-18 22:06:08","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":"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":"3034332","reservation_id":"84629","confirmation_number":"PB12330616079","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.80,100.80,86.40,86.40,86.40,86.40,86.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"633.60","grand_total":"715.97","paid_amount":"715.97","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":"28906","customer_id":"28906","source_of_creation":"PMS","reservation_created_date":"2019-09-24 00:40:48","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":"86.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":"3034545","reservation_id":"59728","confirmation_number":"PB12384017809","room_stay_from":"2019-11-02","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.00,186.00,186.00,186.00,186.00,186.00,186.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,67.80,0.00","subtotal":"1302.00","grand_total":"1394.64","paid_amount":"1394.64","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23074","customer_id":"23074","source_of_creation":"PMS","reservation_created_date":"2018-11-06 17:38:58","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"186.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034749","reservation_id":"60182","confirmation_number":"PB12322310478","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,56.12,0.00","subtotal":"1260.00","grand_total":"1360.38","paid_amount":"1360.38","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24409","customer_id":"24409","source_of_creation":"PMS","reservation_created_date":"2018-11-12 13:10:42","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034753","reservation_id":"60182","confirmation_number":"PB12333050365","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,56.12,0.00","subtotal":"1260.00","grand_total":"1360.38","paid_amount":"1360.38","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":"24409","customer_id":"24409","source_of_creation":"PMS","reservation_created_date":"2018-11-12 13:10: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":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034769","reservation_id":"82379","confirmation_number":"PB12355235886","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00,104.00","nightly_discount":"23.80,0.00,0.00,0.00,0.00","subtotal":"520.00","grand_total":"560.70","paid_amount":"560.70","room_type_id":"285","product_id":"1085","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":"90039","customer_id":"90039","source_of_creation":"PMS","reservation_created_date":"2019-08-10 02:24:58","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.00","currentDayDiscount":"23.80","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034827","reservation_id":"86639","confirmation_number":"PB12312621813","room_stay_from":"2019-11-02","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00","nightly_discount":"0.00,0.00","subtotal":"178.00","grand_total":"201.14","paid_amount":"201.14","room_type_id":"314","product_id":"1229","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":"88088","customer_id":"88088","source_of_creation":"PMS","reservation_created_date":"2019-11-03 18:48:30","canceled_nights_data":"","product_name":"BV Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Reservation created with partial past date","deltaChange":"89.00","currentDayPrice":"89.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034932","reservation_id":"85426","confirmation_number":"PB12350544802","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,15.00,0.00","subtotal":"416.00","grand_total":"453.13","paid_amount":"453.13","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":"53442","customer_id":"53442","source_of_creation":"PMS","reservation_created_date":"2019-10-10 21:26:17","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":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034967","reservation_id":"86657","confirmation_number":"PB12382468811","room_stay_from":"2019-11-03","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.40","nightly_discount":"6.01,0.00","subtotal":"106.40","grand_total":"113.44","paid_amount":"113.44","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":"93338","customer_id":"93338","source_of_creation":"PMS","reservation_created_date":"2019-11-04 02:15:00","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":"106.40","currentDayDiscount":"6.01","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038010","reservation_id":"83347","confirmation_number":"PB12367683978","room_stay_from":"2019-10-30","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.80,69.80,78.95,78.95,69.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"367.30","grand_total":"415.05","paid_amount":"415.05","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":"90712","customer_id":"90712","source_of_creation":"PMS","reservation_created_date":"2019-08-28 17:08:33","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":"69.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038029","reservation_id":"81546","confirmation_number":"PB12358891924","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.43,87.43,87.43,87.43,87.43","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"437.15","grand_total":"493.98","paid_amount":"493.98","room_type_id":"287","product_id":"1090","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89446","customer_id":"89446","source_of_creation":"PMS","reservation_created_date":"2019-11-02 21:42:25","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"87.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038040","reservation_id":"82397","confirmation_number":"PB12325954756","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.54,89.54,87.43","nightly_discount":"0.00,0.00,0.00","subtotal":"266.51","grand_total":"301.16","paid_amount":"301.16","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":"90051","customer_id":"90051","source_of_creation":"PMS","reservation_created_date":"2019-08-10 13:56:04","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":"87.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038043","reservation_id":"82397","confirmation_number":"PB12366362898","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.54,89.54,87.43","nightly_discount":"0.00,0.00,0.00","subtotal":"266.51","grand_total":"301.16","paid_amount":"301.16","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90051","customer_id":"90051","source_of_creation":"PMS","reservation_created_date":"2019-08-10 13:56:04","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"87.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038085","reservation_id":"82881","confirmation_number":"PB12382085050","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.95,78.95,120.00","nightly_discount":"0.00,0.00,0.00","subtotal":"277.90","grand_total":"314.02","paid_amount":"314.02","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":"88027","customer_id":"88027","source_of_creation":"PMS","reservation_created_date":"2019-08-18 18:12:30","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":"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":"3038708","reservation_id":"59963","confirmation_number":"PB12369148316","room_stay_from":"2019-10-29","room_stay_to":"2019-11-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00","nightly_discount":"70.76,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":"1836.00","grand_total":"1994.72","paid_amount":"1890.92","room_type_id":"289","product_id":"1098","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"44768","customer_id":"44768","source_of_creation":"PMS","reservation_created_date":"2018-11-09 16:27:42","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":"108.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3044301","reservation_id":"61846","confirmation_number":"PB12391957014","room_stay_from":"2019-10-28","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00","nightly_discount":"79.80,79.80,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,83.00,83.00,83.00,83.00,83.00","subtotal":"3705.00","grand_total":"3537.35","paid_amount":"3537.35","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":"23454","customer_id":"23454","source_of_creation":"PMS","reservation_created_date":"2018-11-30 00:04:47","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2995841","reservation_id":"80323","confirmation_number":"PB12273052825","room_confirmation_number":"PB12334096993","room_stay_from":"2019-11-01","room_stay_to":"2019-11-05","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"88643","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-06 23:04:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88643","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3010057","reservation_id":"82558","confirmation_number":"PB12290577803","room_confirmation_number":"PB12344483140","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"90155","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-08-13 00:49:14","reservation_modified_date_time":"2019-08-13 00:49:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90155","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3033942","reservation_id":"86044","confirmation_number":"PB12238416681","room_confirmation_number":"PB12311283691","room_stay_from":"2019-10-31","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0,0,0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"92916","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-10-31 21:30:15","reservation_modified_date_time":"2019-10-31 21:30:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92916","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2994978","reservation_id":"80124","confirmation_number":"PB12281680682","room_confirmation_number":"PB12334951050","room_stay_from":"2019-10-30","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88539","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-03 22:14:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88539","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":"2995842","reservation_id":"80323","confirmation_number":"PB12265323676","room_confirmation_number":"PB12334096993","room_stay_from":"2019-11-01","room_stay_to":"2019-11-05","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":"88643","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-06 23:04:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88643","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":"3000886","reservation_id":"81098","confirmation_number":"PB12283505400","room_confirmation_number":"PB12372965350","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","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":"73566","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-20 17:34:52","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73566","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":"3007980","reservation_id":"82189","confirmation_number":"PB12237113864","room_confirmation_number":"PB12368226074","room_stay_from":"2019-10-29","room_stay_to":"2019-11-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,12.00","subtotal":"132.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"89930","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-07 18:22:47","reservation_modified_date_time":"2019-08-07 18:24:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89930","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":"3010056","reservation_id":"82558","confirmation_number":"PB12235263455","room_confirmation_number":"PB12344483140","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","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":"90155","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-13 00:49:14","reservation_modified_date_time":"2019-08-13 00:49:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90155","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":"3010645","reservation_id":"82680","confirmation_number":"PB12251724692","room_confirmation_number":"PB12370338217","room_stay_from":"2019-10-30","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"90249","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-15 14:32:11","reservation_modified_date_time":"2019-08-15 14:32:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90712","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":"3022429","reservation_id":"84672","confirmation_number":"PB12234253468","room_confirmation_number":"PB12373349068","room_stay_from":"2019-10-31","room_stay_to":"2019-11-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"22954","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-25 11:27:08","reservation_modified_date_time":"2019-09-25 11:27:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"22954","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":"3033213","reservation_id":"84318","confirmation_number":"PB12265162018","room_confirmation_number":"PB12392575211","room_stay_from":"2019-10-28","room_stay_to":"2019-11-06","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":"79718","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-18 16:58:00","reservation_modified_date_time":"2019-10-28 18:07:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79718","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":"3033675","reservation_id":"84275","confirmation_number":"PB12227377956","room_confirmation_number":"PB12357335231","room_stay_from":"2019-10-30","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"26314","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-17 22:41:49","reservation_modified_date_time":"2019-10-30 22:18:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26314","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":"3033943","reservation_id":"86044","confirmation_number":"PB12277548227","room_confirmation_number":"PB12311283691","room_stay_from":"2019-10-31","room_stay_to":"2019-11-04","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":"92916","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-21 16:41:08","reservation_modified_date_time":"2019-10-31 21:30:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92916","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":"3034299","reservation_id":"84357","confirmation_number":"PB12248771278","room_confirmation_number":"PB12372913252","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"91826","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 17:46:28","reservation_modified_date_time":"2019-11-01 22:01:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91826","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":"3034303","reservation_id":"84333","confirmation_number":"PB12210916344","room_confirmation_number":"PB12340155718","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"42262","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-18 22:06:08","reservation_modified_date_time":"2019-11-01 22:13:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42262","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":"3034333","reservation_id":"84629","confirmation_number":"PB12240305719","room_confirmation_number":"PB12330616079","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"28906","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-24 00:40:48","reservation_modified_date_time":"2019-11-01 23:16:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28906","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":"3034502","reservation_id":"84549","confirmation_number":"PB12218701260","room_confirmation_number":"PB12325384614","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","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":"84601","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-22 23:18:22","reservation_modified_date_time":"2019-11-02 18:32:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84601","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":"3034546","reservation_id":"59728","confirmation_number":"PBR12212069506","room_confirmation_number":"PB12384017809","room_stay_from":"2019-11-02","room_stay_to":"2019-11-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"23074","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"2019-11-02 21:07:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23074","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":"3034750","reservation_id":"60182","confirmation_number":"PB12338198280","room_confirmation_number":"PB12322310478","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","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","nightly_discount":"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":"24409","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-12 13:10:42","reservation_modified_date_time":"2019-11-03 16:21:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24409","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":"3034754","reservation_id":"60182","confirmation_number":"PB12396722311","room_confirmation_number":"PB12333050365","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","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","nightly_discount":"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":"24409","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-12 13:10:42","reservation_modified_date_time":"2019-11-03 16:21:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24409","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":"3034770","reservation_id":"82379","confirmation_number":"PB12292144731","room_confirmation_number":"PB12355235886","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"90039","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-10 02:24:58","reservation_modified_date_time":"2019-11-03 16:54:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90039","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":"3034828","reservation_id":"86639","confirmation_number":"PB12264097898","room_confirmation_number":"PB12312621813","room_stay_from":"2019-11-02","room_stay_to":"2019-11-04","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":"88088","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-03 18:48:30","reservation_modified_date_time":"2019-11-03 18:48:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88088","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"12.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034933","reservation_id":"85426","confirmation_number":"PB12222555534","room_confirmation_number":"PB12350544802","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","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":"53442","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-10 21:26:17","reservation_modified_date_time":"2019-11-03 22:43:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53442","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":"3034968","reservation_id":"86657","confirmation_number":"PB12224076194","room_confirmation_number":"PB12382468811","room_stay_from":"2019-11-03","room_stay_to":"2019-11-04","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":"93338","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-04 02:15:00","reservation_modified_date_time":"2019-11-04 02:20:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93338","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":"3035086","reservation_id":"81674","confirmation_number":"PB12259650183","room_confirmation_number":"PB12330227029","room_stay_from":"2019-11-03","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.59","product_id":"1781","service_quantity":"1","customer_traveller_id":"89549","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-29 19:34:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89549","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":"3035454","reservation_id":"85325","confirmation_number":"PB12264627481","room_confirmation_number":"PB12390510045","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","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":"92484","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-08 23:56:07","reservation_modified_date_time":"2019-10-08 23:56:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92484","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":"3038030","reservation_id":"81546","confirmation_number":"PB12275099579","room_confirmation_number":"PB12358891924","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89446","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-02 21:42:25","reservation_modified_date_time":"2019-11-13 21:12:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89446","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":"3038709","reservation_id":"59963","confirmation_number":"PBR12285185099","room_confirmation_number":"PB12369148316","room_stay_from":"2019-10-29","room_stay_to":"2019-11-15","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"44768","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"2019-11-15 01:33:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44768","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":"3044302","reservation_id":"61846","confirmation_number":"PB12312856665","room_confirmation_number":"PB12391957014","room_stay_from":"2019-10-28","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23454","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-30 00:04:47","reservation_modified_date_time":"2019-12-05 15:30:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23454","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3034757","reservation_id":"86631","confirmation_number":"PB12233430536","room_confirmation_number":"PB12398134830","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":null,"service_quantity":"1","product_name":"Coffee Mug","parentTypeOfRes":"reservation","reservation_created_date":"2019-11-03 16:31:54","reservation_modified_date_time":"2019-11-03 16:31:54","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3034846","reservation_id":"86634","confirmation_number":"PB12245880075","room_confirmation_number":"PB12342837833","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1082","service_quantity":"1","product_name":"resort fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-11-03 19:58:10","reservation_modified_date_time":"2019-11-03 19:58:10","customer_id":"93325","parentCustTravId":"93325","customer_traveller_id":"93325","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"","canceled_nights_data":"","product_attribute_values":null,"deltaChange":0,"changedComment":"","currentDayPrice":20,"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":[]}},"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":[{"room_stay_id":"3007512","reservation_id":"82091","confirmation_number":"BV12472328627","room_stay_from":"2019-11-01","room_stay_to":"2019-11-17","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"113.58,113.58,91.9,91.9,91.9,91.9,91.9,113.58,113.58,91.9,91.9,91.9,91.9,91.9,113.58,113.58","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1600.48","grand_total":"1808.54","paid_amount":"1808.54","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-3067093686","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"160.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89847","customer_id":"89847","source_of_creation":"Booking.com","reservation_created_date":"2019-08-05 20:53:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"264.07","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.9","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_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3034873","reservation_id":"86624","confirmation_number":"BV12426374422","room_stay_from":"2019-11-03","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"51.90","nightly_discount":"3.69,0.00","subtotal":"51.90","grand_total":"54.47","paid_amount":"54.47","room_type_id":"304","product_id":"1219","siteminder_id":"AGO-289214274","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":"93318","customer_id":"93318","source_of_creation":"Agoda","reservation_created_date":"2019-11-03 14:28:09","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"51.90","currentDayDiscount":"3.69","productIsTaxExempt":false,"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":"3008725","reservation_id":"82305","confirmation_number":"BV12457113878","room_stay_from":"2019-10-31","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.68,91.20,91.20,67.68","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"317.76","grand_total":"359.07","paid_amount":"359.07","room_type_id":"303","product_id":"1140","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90001","customer_id":"90001","source_of_creation":"FE","reservation_created_date":"2019-08-09 13:26:14","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":"67.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3014089","reservation_id":"83247","confirmation_number":"BV12477870814","room_stay_from":"2019-11-03","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.96,102.96,102.96,102.96,102.96,130.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"645.20","grand_total":"729.07","paid_amount":"729.07","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":"90636","customer_id":"90636","source_of_creation":"FE","reservation_created_date":"2019-08-26 17:51:04","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":"102.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034483","reservation_id":"85983","confirmation_number":"BV12494571215","room_stay_from":"2019-11-02","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"119.04,74.88","nightly_discount":"0.00,0.00","subtotal":"193.92","grand_total":"219.13","paid_amount":"219.13","room_type_id":"307","product_id":"1224","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":"92880","customer_id":"92880","source_of_creation":"FE","reservation_created_date":"2019-10-20 03:24:33","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"74.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2991969","reservation_id":"79569","confirmation_number":"BV12466346865","room_stay_from":"2019-10-31","room_stay_to":"2019-11-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.00,105.00,105.00,105.00,105.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"525.00","grand_total":"593.25","paid_amount":"593.25","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":"36678","customer_id":"36678","source_of_creation":"PMS","reservation_created_date":"2019-06-25 15:57:11","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":"105.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3033361","reservation_id":"86404","confirmation_number":"BV12497305441","room_stay_from":"2019-11-03","room_stay_to":"2019-11-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.88,110.88","nightly_discount":"0.00,0.00","subtotal":"221.76","grand_total":"250.59","paid_amount":"250.59","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":"33218","customer_id":"33218","source_of_creation":"PMS","reservation_created_date":"2019-10-29 12:36:16","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":"110.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035188","reservation_id":"86641","confirmation_number":"BV12440606139","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.81,97.81,97.81","nightly_discount":"0.00,0.00,0.00","subtotal":"293.43","grand_total":"331.58","paid_amount":"331.58","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":"28609","customer_id":"28609","source_of_creation":"PMS","reservation_created_date":"2019-11-03 19:37:42","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":"97.81","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3007513","reservation_id":"82091","confirmation_number":"BV12244575200","room_confirmation_number":"BV12472328627","room_stay_from":"2019-11-01","room_stay_to":"2019-11-17","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"89847","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-08-05 20:53:09","reservation_modified_date_time":"2019-08-05 20:53:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89847","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034485","reservation_id":"85983","confirmation_number":"BV12267822167","room_confirmation_number":"BV12494571215","room_stay_from":"2019-11-02","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"92880","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-11-02 17:52:18","reservation_modified_date_time":"2019-11-02 17:52:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92880","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2991970","reservation_id":"79569","confirmation_number":"BV12290974003","room_confirmation_number":"BV12466346865","room_stay_from":"2019-10-31","room_stay_to":"2019-11-05","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"36678","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-25 15:57:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36678","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":"3007514","reservation_id":"82091","confirmation_number":"BV12241348721","room_confirmation_number":"BV12472328627","room_stay_from":"2019-11-01","room_stay_to":"2019-11-17","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"320.00","grand_total":"361.60","paid_amount":"361.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"89847","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-05 20:53:09","reservation_modified_date_time":"2019-08-05 20:53:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89847","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":"3008726","reservation_id":"82305","confirmation_number":"BV12290066379","room_confirmation_number":"BV12457113878","room_stay_from":"2019-10-31","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"90001","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-09 13:26:14","reservation_modified_date_time":"2019-08-09 13:26:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90001","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":"3014090","reservation_id":"83247","confirmation_number":"BV12212345943","room_confirmation_number":"BV12477870814","room_stay_from":"2019-11-03","room_stay_to":"2019-11-09","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":"90636","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-26 17:51:04","reservation_modified_date_time":"2019-08-26 17:51:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90636","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":"3033362","reservation_id":"86404","confirmation_number":"BV12280688024","room_confirmation_number":"BV12497305441","room_stay_from":"2019-11-03","room_stay_to":"2019-11-05","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":"33218","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-29 12:36:16","reservation_modified_date_time":"2019-10-29 12:36:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"33218","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":"3034486","reservation_id":"85983","confirmation_number":"BV12297826885","room_confirmation_number":"BV12494571215","room_stay_from":"2019-11-02","room_stay_to":"2019-11-04","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":"92880","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-20 03:24:33","reservation_modified_date_time":"2019-11-02 17:52:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92880","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":"3034874","reservation_id":"86624","confirmation_number":"BV12240106049","room_confirmation_number":"BV12426374422","room_stay_from":"2019-11-03","room_stay_to":"2019-11-04","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":"93318","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-03 14:28:09","reservation_modified_date_time":"2019-11-03 21:27:20","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93318","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":"3035189","reservation_id":"86641","confirmation_number":"BV12293985091","room_confirmation_number":"BV12440606139","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","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":"28609","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-03 19:37:42","reservation_modified_date_time":"2019-11-03 19:37:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28609","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":"3034720","reservation_id":"86624","confirmation_number":"BV12222912372","room_confirmation_number":"BV12426374422","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"39.03","grand_total":"44.10","paid_amount":"44.10","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-11-03 14:51:42","reservation_modified_date_time":"2019-11-03 14:51:42","customer_id":"93318","parentCustTravId":"93318","customer_traveller_id":"93318","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":"39.03","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":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":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":11,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_non_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":"3016254","reservation_id":"83598","confirmation_number":"BP12524399259","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.86,90.86,90.86","nightly_discount":"0,0,0","subtotal":"272.58","grand_total":"355.64","paid_amount":"355.64","room_type_id":"295","product_id":"1128","siteminder_id":"ABB-HMAKJH8A8W","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"272.58","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90945","customer_id":"90945","source_of_creation":"Airbnb","reservation_created_date":"2019-09-04 12:35:10","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"38.1","commision_charges":"8.43","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.86","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":"3018334","reservation_id":"83941","confirmation_number":"BP12517023794","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"85.36,85.36,85.36","nightly_discount":"0,0,0","subtotal":"256.08","grand_total":"334.12","paid_amount":"334.12","room_type_id":"293","product_id":"1124","siteminder_id":"ABB-HMAJDKE3NB","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"256.08","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91502","customer_id":"91502","source_of_creation":"Airbnb","reservation_created_date":"2019-09-11 21:02:07","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"35.8","commision_charges":"7.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.36","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_non_taxable":[],"fe_taxable":[{"room_stay_id":"3034304","reservation_id":"86551","confirmation_number":"BP12534754244","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"64.30,64.30,64.30","nightly_discount":"0.00,0.00,0.00","subtotal":"192.90","grand_total":"217.97","paid_amount":"217.97","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"FE","reservation_created_date":"2019-11-01 22:30:58","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"64.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3020988","reservation_id":"84368","confirmation_number":"BP12586917022","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"190.40,190.40,156.96","nightly_discount":"0.00,0.00,0.00","subtotal":"537.76","grand_total":"607.67","paid_amount":"607.67","room_type_id":"297","product_id":"1132","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":"91833","customer_id":"91833","source_of_creation":"PMS","reservation_created_date":"2019-09-19 19:18:47","canceled_nights_data":"","product_name":"BP Deluxe Two Bedroom Suite 2Q, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"156.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034618","reservation_id":"86614","confirmation_number":"BP12586211045","room_stay_from":"2019-11-02","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.92,169.92","nightly_discount":"0.00,0.00","subtotal":"339.84","grand_total":"384.02","paid_amount":"384.02","room_type_id":"301","product_id":"1137","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"70616","customer_id":"70616","source_of_creation":"PMS","reservation_created_date":"2019-11-03 01:49:48","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"169.92","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3020989","reservation_id":"84368","confirmation_number":"BP12251548853","room_confirmation_number":"BP12586917022","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"91833","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-19 19:18:47","reservation_modified_date_time":"2019-09-19 19:18:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91833","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3016255","reservation_id":"83598","confirmation_number":"BP12240724192","room_confirmation_number":"BP12524399259","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"90945","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-04 12:35:10","reservation_modified_date_time":"2019-09-04 12:35:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90945","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":"3018335","reservation_id":"83941","confirmation_number":"BP12250243840","room_confirmation_number":"BP12517023794","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"91502","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-11 21:02:07","reservation_modified_date_time":"2019-09-11 21:02:07","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91502","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":"3020990","reservation_id":"84368","confirmation_number":"BP12287031896","room_confirmation_number":"BP12586917022","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","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":"91833","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 19:18:47","reservation_modified_date_time":"2019-09-19 19:18:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91833","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":"3034305","reservation_id":"86551","confirmation_number":"BP12230612644","room_confirmation_number":"BP12534754244","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","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":"2019-11-01 22:30:58","reservation_modified_date_time":"2019-11-01 22:30:58","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":"3034619","reservation_id":"86614","confirmation_number":"BP12227306718","room_confirmation_number":"BP12586211045","room_stay_from":"2019-11-02","room_stay_to":"2019-11-04","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":"70616","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-03 01:49:48","reservation_modified_date_time":"2019-11-03 01:49:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70616","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_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2019-11-03","total_rooms_exist":66,"departureCount":33,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"1","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3007512","reservation_id":"82091","confirmation_number":"BV12472328627","room_stay_from":"2019-11-01","room_stay_to":"2019-11-17","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"113.58,113.58,91.9,91.9,91.9,91.9,91.9,113.58,113.58,91.9,91.9,91.9,91.9,91.9,113.58,113.58","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1600.48","grand_total":"1808.54","paid_amount":"1808.54","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-3067093686","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"160.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89847","customer_id":"89847","source_of_creation":"Booking.com","reservation_created_date":"2019-08-05 20:53:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"264.07","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.9","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":"3035085","reservation_id":"81674","confirmation_number":"PB12330227029","room_stay_from":"2019-11-03","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.58","nightly_discount":"0","subtotal":"122.58","grand_total":"138.51","paid_amount":"138.52","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3196961433","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":"89549","customer_id":"89549","source_of_creation":"Booking.com","reservation_created_date":"2019-07-29 19:34:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"18.39","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"122.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035453","reservation_id":"85325","confirmation_number":"PB12390510045","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.27,113.83,113.83,113.83","nightly_discount":"0,0,0,0","subtotal":"466.76","grand_total":"527.44","paid_amount":"527.44","room_type_id":"289","product_id":"1104","siteminder_id":"BDC-2129342521","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":"92484","customer_id":"92484","source_of_creation":"Booking.com","reservation_created_date":"2019-10-08 23:56:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"70.01","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2994977","reservation_id":"80124","confirmation_number":"PB12334951050","room_stay_from":"2019-10-30","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.14,62.14,68.89,68.89,62.14","nightly_discount":"0,0,0,0,0","subtotal":"324.20","grand_total":"366.34","paid_amount":"366.34","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1291935132","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":"88539","customer_id":"88539","source_of_creation":"Expedia","reservation_created_date":"2019-07-03 22:14:09","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.14","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":"2995840","reservation_id":"80323","confirmation_number":"PB12334096993","room_stay_from":"2019-11-01","room_stay_to":"2019-11-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"154.32,154.32,144.93,144.93","nightly_discount":"0,0,0,0","subtotal":"598.50","grand_total":"676.31","paid_amount":"676.31","room_type_id":"287","product_id":"1089","siteminder_id":"EXP-1294052218","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88643","customer_id":"88643","source_of_creation":"Expedia","reservation_created_date":"2019-07-06 23:04:08","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.93","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":"3010644","reservation_id":"82680","confirmation_number":"PB12370338217","room_stay_from":"2019-10-30","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"86.16,86.16,94.82,94.82,86.16","nightly_discount":"0,0,0,0,0","subtotal":"448.12","grand_total":"506.38","paid_amount":"506.38","room_type_id":"289","product_id":"1095","siteminder_id":"EXP-1322482082","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":"90712","customer_id":"90712","source_of_creation":"Expedia","reservation_created_date":"2019-08-15 14:32:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"86.16","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":"3022428","reservation_id":"84672","confirmation_number":"PB12373349068","room_stay_from":"2019-10-31","room_stay_to":"2019-11-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.01,92.45,92.45,84.01,84.01","nightly_discount":"0,0,0,0,0","subtotal":"436.93","grand_total":"493.74","paid_amount":"493.74","room_type_id":"289","product_id":"1103","siteminder_id":"EXP-1349320343","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":"22954","customer_id":"22954","source_of_creation":"Expedia","reservation_created_date":"2019-09-25 11:27:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.01","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":"3033940","reservation_id":"86044","confirmation_number":"PB12311283691","room_stay_from":"2019-10-31","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"84.01,92.45,110.94,84.01","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"371.41","grand_total":"419.69","paid_amount":"419.69","room_type_id":"289","product_id":"1110","siteminder_id":"EXP-1365886391","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":"92916","customer_id":"92916","source_of_creation":"Expedia","reservation_created_date":"2019-10-21 16:41:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.01","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3016254","reservation_id":"83598","confirmation_number":"BP12524399259","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.86,90.86,90.86","nightly_discount":"0,0,0","subtotal":"272.58","grand_total":"355.64","paid_amount":"355.64","room_type_id":"295","product_id":"1128","siteminder_id":"ABB-HMAKJH8A8W","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"272.58","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90945","customer_id":"90945","source_of_creation":"Airbnb","reservation_created_date":"2019-09-04 12:35:10","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"38.1","commision_charges":"8.43","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.86","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":"3018334","reservation_id":"83941","confirmation_number":"BP12517023794","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"85.36,85.36,85.36","nightly_discount":"0,0,0","subtotal":"256.08","grand_total":"334.12","paid_amount":"334.12","room_type_id":"293","product_id":"1124","siteminder_id":"ABB-HMAJDKE3NB","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"256.08","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91502","customer_id":"91502","source_of_creation":"Airbnb","reservation_created_date":"2019-09-11 21:02:07","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"35.8","commision_charges":"7.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.36","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3034873","reservation_id":"86624","confirmation_number":"BV12426374422","room_stay_from":"2019-11-03","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"51.90","nightly_discount":"3.69,0.00","subtotal":"51.90","grand_total":"54.47","paid_amount":"54.47","room_type_id":"304","product_id":"1219","siteminder_id":"AGO-289214274","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":"93318","customer_id":"93318","source_of_creation":"Agoda","reservation_created_date":"2019-11-03 14:28:09","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"51.90","currentDayDiscount":"3.69","productIsTaxExempt":false,"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":"3000885","reservation_id":"81098","confirmation_number":"PB12372965350","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"416.00","grand_total":"470.08","paid_amount":"470.08","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"73566","customer_id":"73566","source_of_creation":"FE","reservation_created_date":"2019-07-20 17:34:52","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008725","reservation_id":"82305","confirmation_number":"BV12457113878","room_stay_from":"2019-10-31","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.68,91.20,91.20,67.68","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"317.76","grand_total":"359.07","paid_amount":"359.07","room_type_id":"303","product_id":"1140","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90001","customer_id":"90001","source_of_creation":"FE","reservation_created_date":"2019-08-09 13:26:14","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":"67.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3010055","reservation_id":"82558","confirmation_number":"PB12344483140","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"135.20,135.20,119.20","nightly_discount":"0.00,0.00,0.00","subtotal":"389.60","grand_total":"440.25","paid_amount":"440.25","room_type_id":"291","product_id":"1114","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":"90155","customer_id":"90155","source_of_creation":"FE","reservation_created_date":"2019-08-13 00:49:14","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.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":"3014089","reservation_id":"83247","confirmation_number":"BV12477870814","room_stay_from":"2019-11-03","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.96,102.96,102.96,102.96,102.96,130.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"645.20","grand_total":"729.07","paid_amount":"729.07","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":"90636","customer_id":"90636","source_of_creation":"FE","reservation_created_date":"2019-08-26 17:51:04","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":"102.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034304","reservation_id":"86551","confirmation_number":"BP12534754244","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"64.30,64.30,64.30","nightly_discount":"0.00,0.00,0.00","subtotal":"192.90","grand_total":"217.97","paid_amount":"217.97","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"FE","reservation_created_date":"2019-11-01 22:30:58","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"64.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034483","reservation_id":"85983","confirmation_number":"BV12494571215","room_stay_from":"2019-11-02","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"119.04,74.88","nightly_discount":"0.00,0.00","subtotal":"193.92","grand_total":"219.13","paid_amount":"219.13","room_type_id":"307","product_id":"1224","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":"92880","customer_id":"92880","source_of_creation":"FE","reservation_created_date":"2019-10-20 03:24:33","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"74.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034501","reservation_id":"84549","confirmation_number":"PB12325384614","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.60,129.60,129.60,129.60","nightly_discount":"21.84,0.00,0.00,0.00","subtotal":"534.40","grand_total":"579.19","paid_amount":"579.19","room_type_id":"288","product_id":"1091","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":"84601","customer_id":"84601","source_of_creation":"FE","reservation_created_date":"2019-09-22 23:18:22","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2991969","reservation_id":"79569","confirmation_number":"BV12466346865","room_stay_from":"2019-10-31","room_stay_to":"2019-11-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.00,105.00,105.00,105.00,105.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"525.00","grand_total":"593.25","paid_amount":"593.25","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":"36678","customer_id":"36678","source_of_creation":"PMS","reservation_created_date":"2019-06-25 15:57:11","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":"105.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007979","reservation_id":"82189","confirmation_number":"PB12368226074","room_stay_from":"2019-10-29","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00,110.00,110.00,95.00,95.00,95.00,95.00,95.00,110.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1090.00","grand_total":"1231.70","paid_amount":"1231.70","room_type_id":"289","product_id":"1109","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":"89930","customer_id":"89930","source_of_creation":"PMS","reservation_created_date":"2019-08-07 18:22:47","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":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020988","reservation_id":"84368","confirmation_number":"BP12586917022","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"190.40,190.40,156.96","nightly_discount":"0.00,0.00,0.00","subtotal":"537.76","grand_total":"607.67","paid_amount":"607.67","room_type_id":"297","product_id":"1132","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":"91833","customer_id":"91833","source_of_creation":"PMS","reservation_created_date":"2019-09-19 19:18:47","canceled_nights_data":"","product_name":"BP Deluxe Two Bedroom Suite 2Q, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"156.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3033212","reservation_id":"84318","confirmation_number":"PB12392575211","room_stay_from":"2019-10-28","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,96.00,96.00,112.00,112.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,51.73,0.00","subtotal":"896.00","grand_total":"954.03","paid_amount":"954.03","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":"79718","customer_id":"79718","source_of_creation":"PMS","reservation_created_date":"2019-09-18 16:58:00","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3033361","reservation_id":"86404","confirmation_number":"BV12497305441","room_stay_from":"2019-11-03","room_stay_to":"2019-11-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.88,110.88","nightly_discount":"0.00,0.00","subtotal":"221.76","grand_total":"250.59","paid_amount":"250.59","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":"33218","customer_id":"33218","source_of_creation":"PMS","reservation_created_date":"2019-10-29 12:36:16","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":"110.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3033674","reservation_id":"84275","confirmation_number":"PB12357335231","room_stay_from":"2019-10-30","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,120.00,120.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,25.40,0.00","subtotal":"552.00","grand_total":"595.06","paid_amount":"595.06","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"26314","customer_id":"26314","source_of_creation":"PMS","reservation_created_date":"2019-09-17 22:41:49","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":"104.00","currentDayDiscount":"25.40","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034298","reservation_id":"84357","confirmation_number":"PB12372913252","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.80,100.80,86.40,86.40,86.40,86.40,86.40","nightly_discount":"27.34,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"633.60","grand_total":"685.08","paid_amount":"685.08","room_type_id":"289","product_id":"1111","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91826","customer_id":"91826","source_of_creation":"PMS","reservation_created_date":"2019-09-19 17:46:28","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":"86.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":"3034302","reservation_id":"84333","confirmation_number":"PB12340155718","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,20.22,0.00","subtotal":"384.00","grand_total":"411.07","paid_amount":"411.08","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"42262","customer_id":"42262","source_of_creation":"PMS","reservation_created_date":"2019-09-18 22:06:08","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":"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":"3034332","reservation_id":"84629","confirmation_number":"PB12330616079","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.80,100.80,86.40,86.40,86.40,86.40,86.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"633.60","grand_total":"715.97","paid_amount":"715.97","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":"28906","customer_id":"28906","source_of_creation":"PMS","reservation_created_date":"2019-09-24 00:40:48","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":"86.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":"3034545","reservation_id":"59728","confirmation_number":"PB12384017809","room_stay_from":"2019-11-02","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.00,186.00,186.00,186.00,186.00,186.00,186.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,67.80,0.00","subtotal":"1302.00","grand_total":"1394.64","paid_amount":"1394.64","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23074","customer_id":"23074","source_of_creation":"PMS","reservation_created_date":"2018-11-06 17:38:58","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"186.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034618","reservation_id":"86614","confirmation_number":"BP12586211045","room_stay_from":"2019-11-02","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.92,169.92","nightly_discount":"0.00,0.00","subtotal":"339.84","grand_total":"384.02","paid_amount":"384.02","room_type_id":"301","product_id":"1137","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"70616","customer_id":"70616","source_of_creation":"PMS","reservation_created_date":"2019-11-03 01:49:48","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"169.92","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034749","reservation_id":"60182","confirmation_number":"PB12322310478","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,56.12,0.00","subtotal":"1260.00","grand_total":"1360.38","paid_amount":"1360.38","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24409","customer_id":"24409","source_of_creation":"PMS","reservation_created_date":"2018-11-12 13:10:42","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034753","reservation_id":"60182","confirmation_number":"PB12333050365","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,56.12,0.00","subtotal":"1260.00","grand_total":"1360.38","paid_amount":"1360.38","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":"24409","customer_id":"24409","source_of_creation":"PMS","reservation_created_date":"2018-11-12 13:10: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":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034769","reservation_id":"82379","confirmation_number":"PB12355235886","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00,104.00","nightly_discount":"23.80,0.00,0.00,0.00,0.00","subtotal":"520.00","grand_total":"560.70","paid_amount":"560.70","room_type_id":"285","product_id":"1085","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":"90039","customer_id":"90039","source_of_creation":"PMS","reservation_created_date":"2019-08-10 02:24:58","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.00","currentDayDiscount":"23.80","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034827","reservation_id":"86639","confirmation_number":"PB12312621813","room_stay_from":"2019-11-02","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00","nightly_discount":"0.00,0.00","subtotal":"178.00","grand_total":"201.14","paid_amount":"201.14","room_type_id":"314","product_id":"1229","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":"88088","customer_id":"88088","source_of_creation":"PMS","reservation_created_date":"2019-11-03 18:48:30","canceled_nights_data":"","product_name":"BV Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Reservation created with partial past date","deltaChange":"89.00","currentDayPrice":"89.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034932","reservation_id":"85426","confirmation_number":"PB12350544802","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,15.00,0.00","subtotal":"416.00","grand_total":"453.13","paid_amount":"453.13","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":"53442","customer_id":"53442","source_of_creation":"PMS","reservation_created_date":"2019-10-10 21:26:17","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":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034967","reservation_id":"86657","confirmation_number":"PB12382468811","room_stay_from":"2019-11-03","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.40","nightly_discount":"6.01,0.00","subtotal":"106.40","grand_total":"113.44","paid_amount":"113.44","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":"93338","customer_id":"93338","source_of_creation":"PMS","reservation_created_date":"2019-11-04 02:15:00","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":"106.40","currentDayDiscount":"6.01","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035188","reservation_id":"86641","confirmation_number":"BV12440606139","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.81,97.81,97.81","nightly_discount":"0.00,0.00,0.00","subtotal":"293.43","grand_total":"331.58","paid_amount":"331.58","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":"28609","customer_id":"28609","source_of_creation":"PMS","reservation_created_date":"2019-11-03 19:37:42","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":"97.81","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038010","reservation_id":"83347","confirmation_number":"PB12367683978","room_stay_from":"2019-10-30","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.80,69.80,78.95,78.95,69.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"367.30","grand_total":"415.05","paid_amount":"415.05","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":"90712","customer_id":"90712","source_of_creation":"PMS","reservation_created_date":"2019-08-28 17:08:33","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":"69.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038029","reservation_id":"81546","confirmation_number":"PB12358891924","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.43,87.43,87.43,87.43,87.43","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"437.15","grand_total":"493.98","paid_amount":"493.98","room_type_id":"287","product_id":"1090","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89446","customer_id":"89446","source_of_creation":"PMS","reservation_created_date":"2019-11-02 21:42:25","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"87.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038040","reservation_id":"82397","confirmation_number":"PB12325954756","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.54,89.54,87.43","nightly_discount":"0.00,0.00,0.00","subtotal":"266.51","grand_total":"301.16","paid_amount":"301.16","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":"90051","customer_id":"90051","source_of_creation":"PMS","reservation_created_date":"2019-08-10 13:56:04","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":"87.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038043","reservation_id":"82397","confirmation_number":"PB12366362898","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.54,89.54,87.43","nightly_discount":"0.00,0.00,0.00","subtotal":"266.51","grand_total":"301.16","paid_amount":"301.16","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90051","customer_id":"90051","source_of_creation":"PMS","reservation_created_date":"2019-08-10 13:56:04","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"87.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038085","reservation_id":"82881","confirmation_number":"PB12382085050","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.95,78.95,120.00","nightly_discount":"0.00,0.00,0.00","subtotal":"277.90","grand_total":"314.02","paid_amount":"314.02","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":"88027","customer_id":"88027","source_of_creation":"PMS","reservation_created_date":"2019-08-18 18:12:30","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":"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":"3038708","reservation_id":"59963","confirmation_number":"PB12369148316","room_stay_from":"2019-10-29","room_stay_to":"2019-11-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00","nightly_discount":"70.76,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":"1836.00","grand_total":"1994.72","paid_amount":"1890.92","room_type_id":"289","product_id":"1098","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"44768","customer_id":"44768","source_of_creation":"PMS","reservation_created_date":"2018-11-09 16:27:42","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":"108.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3044301","reservation_id":"61846","confirmation_number":"PB12391957014","room_stay_from":"2019-10-28","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00","nightly_discount":"79.80,79.80,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,83.00,83.00,83.00,83.00,83.00","subtotal":"3705.00","grand_total":"3537.35","paid_amount":"3537.35","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":"23454","customer_id":"23454","source_of_creation":"PMS","reservation_created_date":"2018-11-30 00:04:47","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2995841","reservation_id":"80323","confirmation_number":"PB12273052825","room_confirmation_number":"PB12334096993","room_stay_from":"2019-11-01","room_stay_to":"2019-11-05","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"88643","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-06 23:04:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88643","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007513","reservation_id":"82091","confirmation_number":"BV12244575200","room_confirmation_number":"BV12472328627","room_stay_from":"2019-11-01","room_stay_to":"2019-11-17","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"89847","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-08-05 20:53:09","reservation_modified_date_time":"2019-08-05 20:53:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89847","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3010057","reservation_id":"82558","confirmation_number":"PB12290577803","room_confirmation_number":"PB12344483140","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"90155","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-08-13 00:49:14","reservation_modified_date_time":"2019-08-13 00:49:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90155","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020989","reservation_id":"84368","confirmation_number":"BP12251548853","room_confirmation_number":"BP12586917022","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"91833","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-19 19:18:47","reservation_modified_date_time":"2019-09-19 19:18:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91833","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":"3033942","reservation_id":"86044","confirmation_number":"PB12238416681","room_confirmation_number":"PB12311283691","room_stay_from":"2019-10-31","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0,0,0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"92916","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-10-31 21:30:15","reservation_modified_date_time":"2019-10-31 21:30:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92916","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":"3034485","reservation_id":"85983","confirmation_number":"BV12267822167","room_confirmation_number":"BV12494571215","room_stay_from":"2019-11-02","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"92880","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-11-02 17:52:18","reservation_modified_date_time":"2019-11-02 17:52:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92880","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2991970","reservation_id":"79569","confirmation_number":"BV12290974003","room_confirmation_number":"BV12466346865","room_stay_from":"2019-10-31","room_stay_to":"2019-11-05","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"36678","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-25 15:57:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36678","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":"2994978","reservation_id":"80124","confirmation_number":"PB12281680682","room_confirmation_number":"PB12334951050","room_stay_from":"2019-10-30","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"88539","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-03 22:14:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88539","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":"2995842","reservation_id":"80323","confirmation_number":"PB12265323676","room_confirmation_number":"PB12334096993","room_stay_from":"2019-11-01","room_stay_to":"2019-11-05","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":"88643","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-06 23:04:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88643","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":"3000886","reservation_id":"81098","confirmation_number":"PB12283505400","room_confirmation_number":"PB12372965350","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","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":"73566","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-20 17:34:52","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73566","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":"3007514","reservation_id":"82091","confirmation_number":"BV12241348721","room_confirmation_number":"BV12472328627","room_stay_from":"2019-11-01","room_stay_to":"2019-11-17","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"320.00","grand_total":"361.60","paid_amount":"361.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"89847","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-05 20:53:09","reservation_modified_date_time":"2019-08-05 20:53:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89847","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":"3007980","reservation_id":"82189","confirmation_number":"PB12237113864","room_confirmation_number":"PB12368226074","room_stay_from":"2019-10-29","room_stay_to":"2019-11-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,12.00","subtotal":"132.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"89930","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-07 18:22:47","reservation_modified_date_time":"2019-08-07 18:24:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89930","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":"3008726","reservation_id":"82305","confirmation_number":"BV12290066379","room_confirmation_number":"BV12457113878","room_stay_from":"2019-10-31","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"90001","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-09 13:26:14","reservation_modified_date_time":"2019-08-09 13:26:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90001","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":"3010056","reservation_id":"82558","confirmation_number":"PB12235263455","room_confirmation_number":"PB12344483140","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","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":"90155","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-13 00:49:14","reservation_modified_date_time":"2019-08-13 00:49:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90155","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":"3010645","reservation_id":"82680","confirmation_number":"PB12251724692","room_confirmation_number":"PB12370338217","room_stay_from":"2019-10-30","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"90249","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-15 14:32:11","reservation_modified_date_time":"2019-08-15 14:32:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90712","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":"3014090","reservation_id":"83247","confirmation_number":"BV12212345943","room_confirmation_number":"BV12477870814","room_stay_from":"2019-11-03","room_stay_to":"2019-11-09","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":"90636","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-26 17:51:04","reservation_modified_date_time":"2019-08-26 17:51:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90636","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":"3016255","reservation_id":"83598","confirmation_number":"BP12240724192","room_confirmation_number":"BP12524399259","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"90945","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-04 12:35:10","reservation_modified_date_time":"2019-09-04 12:35:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90945","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":"3018335","reservation_id":"83941","confirmation_number":"BP12250243840","room_confirmation_number":"BP12517023794","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"91502","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-11 21:02:07","reservation_modified_date_time":"2019-09-11 21:02:07","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91502","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":"3020990","reservation_id":"84368","confirmation_number":"BP12287031896","room_confirmation_number":"BP12586917022","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","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":"91833","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 19:18:47","reservation_modified_date_time":"2019-09-19 19:18:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91833","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":"3022429","reservation_id":"84672","confirmation_number":"PB12234253468","room_confirmation_number":"PB12373349068","room_stay_from":"2019-10-31","room_stay_to":"2019-11-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"22954","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-25 11:27:08","reservation_modified_date_time":"2019-09-25 11:27:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"22954","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":"3033213","reservation_id":"84318","confirmation_number":"PB12265162018","room_confirmation_number":"PB12392575211","room_stay_from":"2019-10-28","room_stay_to":"2019-11-06","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":"79718","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-18 16:58:00","reservation_modified_date_time":"2019-10-28 18:07:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79718","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":"3033362","reservation_id":"86404","confirmation_number":"BV12280688024","room_confirmation_number":"BV12497305441","room_stay_from":"2019-11-03","room_stay_to":"2019-11-05","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":"33218","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-29 12:36:16","reservation_modified_date_time":"2019-10-29 12:36:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"33218","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":"3033675","reservation_id":"84275","confirmation_number":"PB12227377956","room_confirmation_number":"PB12357335231","room_stay_from":"2019-10-30","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"26314","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-17 22:41:49","reservation_modified_date_time":"2019-10-30 22:18:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26314","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":"3033943","reservation_id":"86044","confirmation_number":"PB12277548227","room_confirmation_number":"PB12311283691","room_stay_from":"2019-10-31","room_stay_to":"2019-11-04","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":"92916","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-21 16:41:08","reservation_modified_date_time":"2019-10-31 21:30:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92916","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":"3034299","reservation_id":"84357","confirmation_number":"PB12248771278","room_confirmation_number":"PB12372913252","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"91826","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 17:46:28","reservation_modified_date_time":"2019-11-01 22:01:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91826","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":"3034303","reservation_id":"84333","confirmation_number":"PB12210916344","room_confirmation_number":"PB12340155718","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"42262","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-18 22:06:08","reservation_modified_date_time":"2019-11-01 22:13:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42262","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":"3034305","reservation_id":"86551","confirmation_number":"BP12230612644","room_confirmation_number":"BP12534754244","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","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":"2019-11-01 22:30:58","reservation_modified_date_time":"2019-11-01 22:30:58","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":"3034333","reservation_id":"84629","confirmation_number":"PB12240305719","room_confirmation_number":"PB12330616079","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"28906","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-24 00:40:48","reservation_modified_date_time":"2019-11-01 23:16:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28906","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":"3034486","reservation_id":"85983","confirmation_number":"BV12297826885","room_confirmation_number":"BV12494571215","room_stay_from":"2019-11-02","room_stay_to":"2019-11-04","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":"92880","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-20 03:24:33","reservation_modified_date_time":"2019-11-02 17:52:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92880","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":"3034502","reservation_id":"84549","confirmation_number":"PB12218701260","room_confirmation_number":"PB12325384614","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","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":"84601","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-22 23:18:22","reservation_modified_date_time":"2019-11-02 18:32:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84601","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":"3034546","reservation_id":"59728","confirmation_number":"PBR12212069506","room_confirmation_number":"PB12384017809","room_stay_from":"2019-11-02","room_stay_to":"2019-11-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"23074","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"2019-11-02 21:07:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23074","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":"3034619","reservation_id":"86614","confirmation_number":"BP12227306718","room_confirmation_number":"BP12586211045","room_stay_from":"2019-11-02","room_stay_to":"2019-11-04","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":"70616","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-03 01:49:48","reservation_modified_date_time":"2019-11-03 01:49:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70616","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":"3034750","reservation_id":"60182","confirmation_number":"PB12338198280","room_confirmation_number":"PB12322310478","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","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","nightly_discount":"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":"24409","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-12 13:10:42","reservation_modified_date_time":"2019-11-03 16:21:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24409","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":"3034754","reservation_id":"60182","confirmation_number":"PB12396722311","room_confirmation_number":"PB12333050365","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","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","nightly_discount":"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":"24409","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-12 13:10:42","reservation_modified_date_time":"2019-11-03 16:21:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24409","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":"3034770","reservation_id":"82379","confirmation_number":"PB12292144731","room_confirmation_number":"PB12355235886","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"90039","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-10 02:24:58","reservation_modified_date_time":"2019-11-03 16:54:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90039","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":"3034828","reservation_id":"86639","confirmation_number":"PB12264097898","room_confirmation_number":"PB12312621813","room_stay_from":"2019-11-02","room_stay_to":"2019-11-04","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":"88088","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-03 18:48:30","reservation_modified_date_time":"2019-11-03 18:48:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88088","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"12.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034874","reservation_id":"86624","confirmation_number":"BV12240106049","room_confirmation_number":"BV12426374422","room_stay_from":"2019-11-03","room_stay_to":"2019-11-04","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":"93318","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-03 14:28:09","reservation_modified_date_time":"2019-11-03 21:27:20","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93318","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":"3034933","reservation_id":"85426","confirmation_number":"PB12222555534","room_confirmation_number":"PB12350544802","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","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":"53442","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-10 21:26:17","reservation_modified_date_time":"2019-11-03 22:43:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53442","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":"3034968","reservation_id":"86657","confirmation_number":"PB12224076194","room_confirmation_number":"PB12382468811","room_stay_from":"2019-11-03","room_stay_to":"2019-11-04","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":"93338","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-04 02:15:00","reservation_modified_date_time":"2019-11-04 02:20:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93338","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":"3035086","reservation_id":"81674","confirmation_number":"PB12259650183","room_confirmation_number":"PB12330227029","room_stay_from":"2019-11-03","room_stay_to":"2019-11-04","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.59","product_id":"1781","service_quantity":"1","customer_traveller_id":"89549","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-29 19:34:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89549","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":"3035189","reservation_id":"86641","confirmation_number":"BV12293985091","room_confirmation_number":"BV12440606139","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","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":"28609","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-03 19:37:42","reservation_modified_date_time":"2019-11-03 19:37:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28609","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":"3035454","reservation_id":"85325","confirmation_number":"PB12264627481","room_confirmation_number":"PB12390510045","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","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":"92484","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-08 23:56:07","reservation_modified_date_time":"2019-10-08 23:56:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92484","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":"3038030","reservation_id":"81546","confirmation_number":"PB12275099579","room_confirmation_number":"PB12358891924","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89446","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-02 21:42:25","reservation_modified_date_time":"2019-11-13 21:12:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89446","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":"3038709","reservation_id":"59963","confirmation_number":"PBR12285185099","room_confirmation_number":"PB12369148316","room_stay_from":"2019-10-29","room_stay_to":"2019-11-15","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"44768","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"2019-11-15 01:33:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44768","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":"3044302","reservation_id":"61846","confirmation_number":"PB12312856665","room_confirmation_number":"PB12391957014","room_stay_from":"2019-10-28","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23454","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-30 00:04:47","reservation_modified_date_time":"2019-12-05 15:30:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23454","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3034720","reservation_id":"86624","confirmation_number":"BV12222912372","room_confirmation_number":"BV12426374422","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"39.03","grand_total":"44.10","paid_amount":"44.10","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-11-03 14:51:42","reservation_modified_date_time":"2019-11-03 14:51:42","customer_id":"93318","parentCustTravId":"93318","customer_traveller_id":"93318","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":"39.03","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3034757","reservation_id":"86631","confirmation_number":"PB12233430536","room_confirmation_number":"PB12398134830","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":null,"service_quantity":"1","product_name":"Coffee Mug","parentTypeOfRes":"reservation","reservation_created_date":"2019-11-03 16:31:54","reservation_modified_date_time":"2019-11-03 16:31:54","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"4.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3034846","reservation_id":"86634","confirmation_number":"PB12245880075","room_confirmation_number":"PB12342837833","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1082","service_quantity":"1","product_name":"resort fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-11-03 19:58:10","reservation_modified_date_time":"2019-11-03 19:58:10","customer_id":"93325","parentCustTravId":"93325","customer_traveller_id":"93325","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"","canceled_nights_data":"","product_attribute_values":null,"deltaChange":0,"changedComment":"","currentDayPrice":20,"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":[]}}