{"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":11,"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":"2984300","reservation_id":"77957","confirmation_number":"PB12362189565","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.83,113.83,113.83,113.83,113.83,125.27","nightly_discount":"0,0,0,0,0,0","subtotal":"694.42","grand_total":"784.70","paid_amount":"784.70","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3438081794","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":"56218","customer_id":"56218","source_of_creation":"Booking.com","reservation_created_date":"2019-06-04 17:28:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"244.33","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"}]},{"room_stay_id":"2993600","reservation_id":"79905","confirmation_number":"PB12382405007","room_stay_from":"2019-10-03","room_stay_to":"2019-10-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.99,142.43,142.43,130.99,130.99,130.99,130.99,130.99","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1070.80","grand_total":"1210.01","paid_amount":"1210.01","room_type_id":"291","product_id":"1115","siteminder_id":"BDC-3547999162","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":"88352","customer_id":"88352","source_of_creation":"Booking.com","reservation_created_date":"2019-06-30 00:04:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"184.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.99","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":"3013960","reservation_id":"77957","confirmation_number":"PB12317249701","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.83,113.83,113.83,113.83,113.83,125.27","nightly_discount":"0,0,0,0,0,0","subtotal":"694.42","grand_total":"784.70","paid_amount":"784.70","room_type_id":"289","product_id":"1123","siteminder_id":"BDC-3438081794","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":"56218","customer_id":"56218","source_of_creation":"Booking.com","reservation_created_date":"2019-06-04 17:28:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"244.33","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":"2989180","reservation_id":"78854","confirmation_number":"PB12374611273","room_stay_from":"2019-09-30","room_stay_to":"2019-10-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.47,131.47,131.47,131.47,142.03,142.03,131.47","nightly_discount":"0,0,0,0,0,0,0","subtotal":"941.41","grand_total":"1063.79","paid_amount":"1063.79","room_type_id":"288","product_id":"1091","siteminder_id":"EXP-1280031905","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":"91693","customer_id":"91693","source_of_creation":"Expedia","reservation_created_date":"2019-06-17 18:30:09","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":"131.47","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":"3011142","reservation_id":"82757","confirmation_number":"PB12355541562","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.99,142.43","nightly_discount":"0,0","subtotal":"273.42","grand_total":"308.97","paid_amount":"308.97","room_type_id":"286","product_id":"1086","siteminder_id":"EXP-1323383792","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":"90303","customer_id":"90303","source_of_creation":"Expedia","reservation_created_date":"2019-08-16 19:27:10","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.99","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":"3016730","reservation_id":"83692","confirmation_number":"PB12381383998","room_stay_from":"2019-10-03","room_stay_to":"2019-10-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.16,94.82,94.82,86.16","nightly_discount":"0,0,0,0","subtotal":"361.96","grand_total":"409.02","paid_amount":"409.02","room_type_id":"289","product_id":"1106","siteminder_id":"EXP-1337126118","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":"91072","customer_id":"91072","source_of_creation":"Expedia","reservation_created_date":"2019-09-06 13:07:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3024078","reservation_id":"84914","confirmation_number":"PB12359814916","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.34,93.34","nightly_discount":"0,0","subtotal":"186.68","grand_total":"210.95","paid_amount":"210.95","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1352673531","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":"92180","customer_id":"92180","source_of_creation":"Expedia","reservation_created_date":"2019-09-30 19:11:09","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":"93.34","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":"3025058","reservation_id":"81876","confirmation_number":"PB12376721892","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"66.92,74.19,74.19","nightly_discount":"0.00,0.00,0.00","subtotal":"215.30","grand_total":"243.29","paid_amount":"243.29","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1313502292","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":"89707","customer_id":"89707","source_of_creation":"Expedia","reservation_created_date":"2019-08-02 13:24:08","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":"66.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3024948","reservation_id":"83013","confirmation_number":"PB12326079649","room_stay_from":"2019-10-03","room_stay_to":"2019-10-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.40,85.18,85.18,77.40","nightly_discount":"0,0,0,0","subtotal":"325.16","grand_total":"367.43","paid_amount":"367.43","room_type_id":"289","product_id":"1112","siteminder_id":"GAM-R1626536237","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":"90478","customer_id":"90478","source_of_creation":"Getaroom.com","reservation_created_date":"2019-08-21 21:43:09","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":"77.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3025048","reservation_id":"84457","confirmation_number":"PB12386755271","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"75.91","nightly_discount":"0.00","subtotal":"75.91","grand_total":"85.77","paid_amount":"85.77","room_type_id":"289","product_id":"1097","siteminder_id":"AGO-281569078","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":"91872","customer_id":"91872","source_of_creation":"Agoda","reservation_created_date":"2019-09-21 03:21:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2986398","reservation_id":"78327","confirmation_number":"PB12344348648","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"128.80,144.80","nightly_discount":"0.00,0.00","subtotal":"273.60","grand_total":"309.17","paid_amount":"309.17","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":"87413","customer_id":"87413","source_of_creation":"FE","reservation_created_date":"2019-06-09 16:15:19","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":"128.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":"2999911","reservation_id":"80932","confirmation_number":"PB12348057448","room_stay_from":"2019-09-30","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"119.20,119.20,119.20,119.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"476.80","grand_total":"538.79","paid_amount":"538.79","room_type_id":"291","product_id":"1116","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":"89070","customer_id":"89070","source_of_creation":"FE","reservation_created_date":"2019-07-18 13:27:48","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","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":"3014374","reservation_id":"83290","confirmation_number":"PB12327917706","room_stay_from":"2019-10-02","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.80,160.80,176.80","nightly_discount":"0.00,0.00,0.00","subtotal":"498.40","grand_total":"563.19","paid_amount":"563.19","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90669","customer_id":"90669","source_of_creation":"FE","reservation_created_date":"2019-08-27 16:26:38","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.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":"3015537","reservation_id":"83474","confirmation_number":"PB12398369570","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.00,120.00,120.00,120.00,120.00,120.00,136.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"872.00","grand_total":"985.36","paid_amount":"985.36","room_type_id":"288","product_id":"1092","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":"90785","customer_id":"90785","source_of_creation":"FE","reservation_created_date":"2019-08-31 15:13:44","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","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":"3024073","reservation_id":"78331","confirmation_number":"PB12380732772","room_stay_from":"2019-09-30","room_stay_to":"2019-10-07","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"704.00","grand_total":"795.52","paid_amount":"795.52","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"40155","customer_id":"40155","source_of_creation":"FE","reservation_created_date":"2019-06-09 17:26:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2954691","reservation_id":"72849","confirmation_number":"PB12397680645","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.00,180.00","nightly_discount":"0.00,0.00","subtotal":"340.00","grand_total":"384.20","paid_amount":"384.20","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":"83891","customer_id":"83891","source_of_creation":"PMS","reservation_created_date":"2019-03-22 18:02:24","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":"160.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008823","reservation_id":"81801","confirmation_number":"PB12350809927","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,120.00","nightly_discount":"0.00,0.00,0.00","subtotal":"328.00","grand_total":"370.64","paid_amount":"370.64","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"44752","customer_id":"44752","source_of_creation":"PMS","reservation_created_date":"2019-08-01 01:46:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3014389","reservation_id":"83292","confirmation_number":"PB12383739686","room_stay_from":"2019-10-03","room_stay_to":"2019-10-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.80,176.80,176.80,160.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"675.20","grand_total":"762.97","paid_amount":"762.97","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":"90671","customer_id":"90671","source_of_creation":"PMS","reservation_created_date":"2019-08-27 17:10:27","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":"160.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":"3022533","reservation_id":"82971","confirmation_number":"PB12324768557","room_stay_from":"2019-09-25","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,112.00,112.00,96.00,96.00,96.00,96.00,96.00,112.00","nightly_discount":"0.00,51.47,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1008.00","grand_total":"1080.88","paid_amount":"1080.88","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":"56624","customer_id":"56624","source_of_creation":"PMS","reservation_created_date":"2019-08-20 19:41:46","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":"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":"3023180","reservation_id":"83646","confirmation_number":"PB12374364977","room_stay_from":"2019-09-27","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"112.00,112.00,96.00,96.00,96.00,96.00,96.00,112.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,39.76,0.00","subtotal":"816.00","grand_total":"877.15","paid_amount":"877.16","room_type_id":"289","product_id":"1105","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"61509","customer_id":"61509","source_of_creation":"PMS","reservation_created_date":"2019-09-05 14:59:24","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3023622","reservation_id":"84366","confirmation_number":"PB12389904472","room_stay_from":"2019-09-30","room_stay_to":"2019-10-04","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":"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":"70463","customer_id":"70463","source_of_creation":"PMS","reservation_created_date":"2019-09-19 18:52:04","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":"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":"3023655","reservation_id":"84544","confirmation_number":"PB12361559219","room_stay_from":"2019-10-01","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,119.20,119.20","nightly_discount":"0.00,0.00,0.00","subtotal":"357.60","grand_total":"404.09","paid_amount":"404.09","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":"73231","customer_id":"73231","source_of_creation":"PMS","reservation_created_date":"2019-09-22 21:12:17","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":"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":"3024165","reservation_id":"84924","confirmation_number":"PB12340153801","room_stay_from":"2019-09-30","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,119.20,119.20,119.20","nightly_discount":"26.24,0.00,0.00,0.00","subtotal":"476.80","grand_total":"509.13","paid_amount":"509.13","room_type_id":"291","product_id":"1117","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90393","customer_id":"90393","source_of_creation":"PMS","reservation_created_date":"2019-09-30 20:22:54","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3024564","reservation_id":"81900","confirmation_number":"PB12360296116","room_stay_from":"2019-10-02","room_stay_to":"2019-10-07","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,0.00","subtotal":"552.00","grand_total":"623.76","paid_amount":"623.76","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":"89726","customer_id":"89726","source_of_creation":"PMS","reservation_created_date":"2019-08-02 19:05:10","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":"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":"3024579","reservation_id":"81801","confirmation_number":"PB12357066886","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,120.00","nightly_discount":"0.00,0.00,0.00","subtotal":"328.00","grand_total":"370.64","paid_amount":"370.64","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":"44752","customer_id":"44752","source_of_creation":"PMS","reservation_created_date":"2019-08-01 01:46:20","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":"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":"3024869","reservation_id":"80196","confirmation_number":"PB12332838153","room_stay_from":"2019-09-23","room_stay_to":"2019-10-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"148.80,148.80,148.80,148.80,164.80,164.80,148.80,148.80,148.80,148.80,148.80,164.80,164.80,148.80,89.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","subtotal":"2236.20","grand_total":"2526.90","paid_amount":"2526.90","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":"48600","customer_id":"48600","source_of_creation":"PMS","reservation_created_date":"2019-07-04 22:48:30","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"148.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":"3025013","reservation_id":"85079","confirmation_number":"PB12322270207","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.60","nightly_discount":"0.00","subtotal":"89.60","grand_total":"101.25","paid_amount":"101.25","room_type_id":"289","product_id":"1110","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":"22954","customer_id":"22954","source_of_creation":"PMS","reservation_created_date":"2019-10-03 22:43:49","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":"89.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028632","reservation_id":"84903","confirmation_number":"PB12389781041","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"289","product_id":"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":"92171","customer_id":"92171","source_of_creation":"PMS","reservation_created_date":"2019-09-30 16:05:59","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":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028740","reservation_id":"81873","confirmation_number":"PB12354855806","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"94.00,94.00,99.00,99.00,99.00,111.96","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"596.96","grand_total":"674.57","paid_amount":"674.57","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":"89705","customer_id":"89705","source_of_creation":"PMS","reservation_created_date":"2019-08-02 12:40:55","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":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2986400","reservation_id":"78327","confirmation_number":"PB12280842498","room_confirmation_number":"PB12344348648","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"87413","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-09 16:15:19","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87413","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":"2999913","reservation_id":"80932","confirmation_number":"PB12282605444","room_confirmation_number":"PB12348057448","room_stay_from":"2019-09-30","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,10.00","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":"89070","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-18 13:27:48","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89070","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":"3016516","reservation_id":"83646","confirmation_number":"PB12220596174","room_confirmation_number":"PB12374364977","room_stay_from":"2019-09-27","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"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","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"61509","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-05 14:59:24","reservation_modified_date_time":"2019-09-05 14:59:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"61509","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":"3017807","reservation_id":"81873","confirmation_number":"PB12272760901","room_confirmation_number":"PB12354855806","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"89705","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-09 16:26:48","reservation_modified_date_time":"2019-09-09 16:26:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89705","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":"3025050","reservation_id":"84457","confirmation_number":"PB12281326125","room_confirmation_number":"PB12386755271","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"91872","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-10-04 00:47:17","reservation_modified_date_time":"2019-10-04 00:47:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91872","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2954692","reservation_id":"72849","confirmation_number":"PB12286957381","room_confirmation_number":"PB12397680645","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"83891","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-03-22 18:02:24","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83891","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":"2984301","reservation_id":"77957","confirmation_number":"PB12264348413","room_confirmation_number":"PB12362189565","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"87150","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-04 17:28:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56218","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":"2986399","reservation_id":"78327","confirmation_number":"PB12220444995","room_confirmation_number":"PB12344348648","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"87413","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-09 16:15:19","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87413","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":"2989181","reservation_id":"78854","confirmation_number":"PB12250670060","room_confirmation_number":"PB12374611273","room_stay_from":"2019-09-30","room_stay_to":"2019-10-07","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91693","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-17 18:30:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91693","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":"2993601","reservation_id":"79905","confirmation_number":"PB12293871706","room_confirmation_number":"PB12382405007","room_stay_from":"2019-10-03","room_stay_to":"2019-10-11","room_stay_status":"Active","nightly_price":"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","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88352","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-30 00:04:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88352","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":"2999912","reservation_id":"80932","confirmation_number":"PB12288126033","room_confirmation_number":"PB12348057448","room_stay_from":"2019-09-30","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"89070","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-18 13:27:48","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89070","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":"3008824","reservation_id":"81801","confirmation_number":"PB12229744828","room_confirmation_number":"PB12350809927","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"44752","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-01 01:46:20","reservation_modified_date_time":"2019-08-01 01:46:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44752","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":"3011143","reservation_id":"82757","confirmation_number":"PB12255570007","room_confirmation_number":"PB12355541562","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"90303","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-16 19:27:10","reservation_modified_date_time":"2019-08-16 19:27:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90303","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":"3013961","reservation_id":"77957","confirmation_number":"PB12221603096","room_confirmation_number":"PB12317249701","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"56218","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-04 17:28:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56218","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":"3014375","reservation_id":"83290","confirmation_number":"PB12222337733","room_confirmation_number":"PB12327917706","room_stay_from":"2019-10-02","room_stay_to":"2019-10-05","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":"90669","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-27 16:26:38","reservation_modified_date_time":"2019-08-27 16:26:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90669","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":"3014390","reservation_id":"83292","confirmation_number":"PB12275341824","room_confirmation_number":"PB12383739686","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"90671","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-27 17:10:27","reservation_modified_date_time":"2019-08-27 17:10:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90671","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":"3015538","reservation_id":"83474","confirmation_number":"PB12259515279","room_confirmation_number":"PB12398369570","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","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":"90785","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-31 15:13:44","reservation_modified_date_time":"2019-08-31 15:13:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90785","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":"3016731","reservation_id":"83692","confirmation_number":"PB12286651667","room_confirmation_number":"PB12381383998","room_stay_from":"2019-10-03","room_stay_to":"2019-10-07","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":"91072","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-06 13:07:08","reservation_modified_date_time":"2019-09-06 13:07:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91072","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":"3022534","reservation_id":"82971","confirmation_number":"PB12275739458","room_confirmation_number":"PB12324768557","room_stay_from":"2019-09-25","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"56624","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-20 19:41:46","reservation_modified_date_time":"2019-09-25 19:48:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56624","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":"3023181","reservation_id":"83646","confirmation_number":"PB12237844524","room_confirmation_number":"PB12374364977","room_stay_from":"2019-09-27","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"61509","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-05 14:59:24","reservation_modified_date_time":"2019-09-27 15:49:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"61509","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":"3023623","reservation_id":"84366","confirmation_number":"PB12229111663","room_confirmation_number":"PB12389904472","room_stay_from":"2019-09-30","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"70463","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 18:52:04","reservation_modified_date_time":"2019-09-19 18:52:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70463","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":"3023656","reservation_id":"84544","confirmation_number":"PB12249161208","room_confirmation_number":"PB12361559219","room_stay_from":"2019-10-01","room_stay_to":"2019-10-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":"73231","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-22 21:12:17","reservation_modified_date_time":"2019-09-22 21:12:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73231","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":"3024074","reservation_id":"78331","confirmation_number":"PB12238334126","room_confirmation_number":"PB12380732772","room_stay_from":"2019-09-30","room_stay_to":"2019-10-07","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":"40155","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-09 17:26:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"40155","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":"3024079","reservation_id":"84914","confirmation_number":"PB12262575908","room_confirmation_number":"PB12359814916","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"92180","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-30 19:11:09","reservation_modified_date_time":"2019-09-30 19:11:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92180","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":"3024166","reservation_id":"84924","confirmation_number":"PB12253861168","room_confirmation_number":"PB12340153801","room_stay_from":"2019-09-30","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"90393","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-30 20:22:54","reservation_modified_date_time":"2019-09-30 20:22:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90393","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":"3024565","reservation_id":"81900","confirmation_number":"PB12216924629","room_confirmation_number":"PB12360296116","room_stay_from":"2019-10-02","room_stay_to":"2019-10-07","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":"89726","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-02 19:05:10","reservation_modified_date_time":"2019-08-02 19:05:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89726","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":"3024580","reservation_id":"81801","confirmation_number":"PB12256232230","room_confirmation_number":"PB12357066886","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"44752","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-01 01:46:20","reservation_modified_date_time":"2019-08-01 01:46:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44752","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":"3024870","reservation_id":"80196","confirmation_number":"PB12223524481","room_confirmation_number":"PB12332838153","room_stay_from":"2019-09-23","room_stay_to":"2019-10-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","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","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"48600","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-04 22:48:30","reservation_modified_date_time":"2019-10-03 13:25:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"48600","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":"3024949","reservation_id":"83013","confirmation_number":"PB12224612740","room_confirmation_number":"PB12326079649","room_stay_from":"2019-10-03","room_stay_to":"2019-10-07","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":"90478","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-21 21:43:09","reservation_modified_date_time":"2019-08-21 21:43:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90478","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":"3025014","reservation_id":"85079","confirmation_number":"PB12221817590","room_confirmation_number":"PB12322270207","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"92315","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-03 22:43:49","reservation_modified_date_time":"2019-10-03 22:43:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"22954","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":"3025051","reservation_id":"84457","confirmation_number":"PB12217122071","room_confirmation_number":"PB12386755271","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"91872","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-21 03:21:09","reservation_modified_date_time":"2019-10-04 00:47:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91872","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":"3025059","reservation_id":"81876","confirmation_number":"PB12228515037","room_confirmation_number":"PB12376721892","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"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":"89707","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-02 13:24:08","reservation_modified_date_time":"2019-10-04 02:23:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89707","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":"3028633","reservation_id":"84903","confirmation_number":"PB12253651846","room_confirmation_number":"PB12389781041","room_stay_from":"2019-10-02","room_stay_to":"2019-10-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":"92171","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-30 16:05:59","reservation_modified_date_time":"2019-10-15 15:10:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92171","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":"3028741","reservation_id":"81873","confirmation_number":"PB12289573230","room_confirmation_number":"PB12354855806","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89705","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-02 12:40:55","reservation_modified_date_time":"2019-10-15 17:29:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89705","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":"3024878","reservation_id":"85000","confirmation_number":"PB12215624014","room_confirmation_number":"PB12387836611","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1150","service_quantity":"1","product_name":"Clean-Up Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 13:51:48","reservation_modified_date_time":"2019-10-03 13:51:48","customer_id":"92250","parentCustTravId":"92250","customer_traveller_id":"92250","static_pos_type":"cleaningfee","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":"200.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3024879","reservation_id":"83920","confirmation_number":"PB12212715890","room_confirmation_number":"PB12375358693","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":"8.98","paid_amount":"8.98","product_id":"1151","service_quantity":"2","product_name":"Coffee Mug","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 13:55:08","reservation_modified_date_time":"2019-10-03 13:55:08","customer_id":"91482","parentCustTravId":"91482","customer_traveller_id":"91482","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":"8.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3024950","reservation_id":"83013","confirmation_number":"PB12278775724","room_confirmation_number":"PB12326079649","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 16:37:47","reservation_modified_date_time":"2019-10-03 16:37:47","customer_id":"90478","parentCustTravId":"90478","customer_traveller_id":"90478","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":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3024951","reservation_id":"83692","confirmation_number":"PB12261554837","room_confirmation_number":"PB12381383998","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"10.00","paid_amount":"10.00","product_id":"1175","service_quantity":"1","product_name":"Miscellaneous","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 16:37:49","reservation_modified_date_time":"2019-10-03 16:37:49","customer_id":"91072","parentCustTravId":"91072","customer_traveller_id":"91072","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"9.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3025060","reservation_id":"81876","confirmation_number":"PB12246351013","room_confirmation_number":"PB12376721892","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"41.40","grand_total":"46.78","paid_amount":"46.78","product_id":"1082","service_quantity":"1","product_name":"Resort Fee from \"Despegar\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-04 02:25:39","reservation_modified_date_time":"2019-10-04 02:25:39","customer_id":"89707","parentCustTravId":"89707","customer_traveller_id":"89707","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":"41.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3024974","reservation_id":"85064","confirmation_number":"PB12228570002","room_confirmation_number":"PB12384720611","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 18:58:12","reservation_modified_date_time":"2019-10-03 18:58:12","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":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":1,"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":[{"room_stay_id":"3024637","reservation_id":"85012","confirmation_number":"BV12463171354","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.57,100.11","nightly_discount":"0,0","subtotal":"182.68","grand_total":"206.43","paid_amount":"206.43","room_type_id":"305","product_id":"1222","siteminder_id":"GAM-R1687419254","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":"92264","customer_id":"92264","source_of_creation":"Getaroom.com","reservation_created_date":"2019-10-02 21:13:07","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":"82.57","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3015125","reservation_id":"83423","confirmation_number":"BV12461307974","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.68,67.68,67.68,67.68,67.68,91.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"429.60","grand_total":"485.45","paid_amount":"485.45","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":"90757","customer_id":"90757","source_of_creation":"FE","reservation_created_date":"2019-08-30 08:26:39","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":"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":"3022721","reservation_id":"84722","confirmation_number":"BV12445156976","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.88,139.20","nightly_discount":"0.00,0.00","subtotal":"250.08","grand_total":"282.59","paid_amount":"282.59","room_type_id":"304","product_id":"1219","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92035","customer_id":"92035","source_of_creation":"FE","reservation_created_date":"2019-09-26 14:40:08","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":"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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3007483","reservation_id":"82088","confirmation_number":"BV12436088098","room_stay_from":"2019-10-02","room_stay_to":"2019-10-09","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"60.48,60.48,83.20,83.20,60.48,60.48,60.48","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"468.80","grand_total":"529.75","paid_amount":"529.75","room_type_id":"303","product_id":"1139","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"43955","customer_id":"43955","source_of_creation":"PMS","reservation_created_date":"2019-08-05 20:08:14","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"60.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017776","reservation_id":"83821","confirmation_number":"BV12469374057","room_stay_from":"2019-10-02","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.96,102.96,130.40","nightly_discount":"0.00,0.00,0.00","subtotal":"336.32","grand_total":"380.04","paid_amount":"380.04","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":"84913","customer_id":"84913","source_of_creation":"PMS","reservation_created_date":"2019-09-09 14:41:04","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":"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":"3022990","reservation_id":"58149","confirmation_number":"BV12477278913","room_stay_from":"2019-09-26","room_stay_to":"2019-10-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.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,73.95,0.00","subtotal":"1566.00","grand_total":"1686.01","paid_amount":"1686.01","room_type_id":"303","product_id":"1140","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"40114","customer_id":"40114","source_of_creation":"PMS","reservation_created_date":"2018-10-13 16:25:35","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":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3024843","reservation_id":"85002","confirmation_number":"BV12431144276","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.08,0.00","nightly_discount":"0.00,0.00","subtotal":"136.08","grand_total":"153.77","paid_amount":"153.77","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92253","customer_id":"92253","source_of_creation":"PMS","reservation_created_date":"2019-10-02 17:56:01","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3025089","reservation_id":"85097","confirmation_number":"BV12460965629","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"88.70","nightly_discount":"0.00","subtotal":"88.70","grand_total":"100.23","paid_amount":"100.23","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":"92330","customer_id":"92330","source_of_creation":"PMS","reservation_created_date":"2019-10-04 03:31:48","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":"88.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3025163","reservation_id":"85003","confirmation_number":"BV12434309030","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.88,0.00","nightly_discount":"0.00,0.00","subtotal":"110.88","grand_total":"125.29","paid_amount":"125.29","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":"92254","customer_id":"92254","source_of_creation":"PMS","reservation_created_date":"2019-10-02 18:00:55","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":"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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3007484","reservation_id":"82088","confirmation_number":"BV12255181394","room_confirmation_number":"BV12436088098","room_stay_from":"2019-10-02","room_stay_to":"2019-10-09","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"43955","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-05 20:08:14","reservation_modified_date_time":"2019-08-05 20:08:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"43955","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":"3015126","reservation_id":"83423","confirmation_number":"BV12282071941","room_confirmation_number":"BV12461307974","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","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":"90757","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-30 08:26:39","reservation_modified_date_time":"2019-08-30 08:26:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90757","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":"3017777","reservation_id":"83821","confirmation_number":"BV12243015379","room_confirmation_number":"BV12469374057","room_stay_from":"2019-10-02","room_stay_to":"2019-10-05","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":"84913","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-09 14:41:04","reservation_modified_date_time":"2019-09-09 14:41:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84913","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":"3022722","reservation_id":"84722","confirmation_number":"BV12221074309","room_confirmation_number":"BV12445156976","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"92035","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-26 14:40:08","reservation_modified_date_time":"2019-09-26 14:40:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92035","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":"3022991","reservation_id":"58149","confirmation_number":"BV12440557868","room_confirmation_number":"BV12477278913","room_stay_from":"2019-09-26","room_stay_to":"2019-10-14","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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"40114","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-10-13 16:34:33","reservation_modified_date_time":"2019-09-27 01:31:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"40114","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":"3024638","reservation_id":"85012","confirmation_number":"BV12280169135","room_confirmation_number":"BV12463171354","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"92264","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-02 21:13:07","reservation_modified_date_time":"2019-10-02 21:13:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92264","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":"3024844","reservation_id":"85002","confirmation_number":"BV12278005393","room_confirmation_number":"BV12431144276","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,12.00","subtotal":"24.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"92253","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-02 17:56:01","reservation_modified_date_time":"2019-10-03 12:27:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92253","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"12.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3025090","reservation_id":"85097","confirmation_number":"BV12235973256","room_confirmation_number":"BV12460965629","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"92330","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-04 03:31:48","reservation_modified_date_time":"2019-10-04 03:31:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92330","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":"3025164","reservation_id":"85003","confirmation_number":"BV12220606665","room_confirmation_number":"BV12434309030","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,12.00","subtotal":"24.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"92254","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-02 18:00:55","reservation_modified_date_time":"2019-10-04 16:19:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92254","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"12.00","productIsTaxExempt":false,"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":"3022723","reservation_id":"84722","confirmation_number":"BV12219196549","room_confirmation_number":"BV12445156976","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-26 14:40:08","reservation_modified_date_time":"2019-09-26 14:40:08","customer_id":"92035","parentCustTravId":"92035","customer_traveller_id":"92035","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3024901","reservation_id":"85003","confirmation_number":"BV12284427338","room_confirmation_number":"BV12434309030","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1142","service_quantity":"1","product_name":"1/2 Day till 6pm","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 14:37:01","reservation_modified_date_time":"2019-10-03 14:37:01","customer_id":"92254","parentCustTravId":"92254","customer_traveller_id":"92254","static_pos_type":"latecheckoutfee","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":"70.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3024560","reservation_id":"85004","confirmation_number":"BV12283436315","room_confirmation_number":"BV12412904230","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"0.00","product_id":"1147","service_quantity":"1","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-02 18:20:00","reservation_modified_date_time":"2019-10-02 18:20:00","customer_id":"92255","parentCustTravId":"92255","customer_traveller_id":"92255","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-10-03 14:57:11","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-10,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":2,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3024927","reservation_id":"85053","confirmation_number":"BP12543723408","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"49.27","nightly_discount":"0","subtotal":"49.27","grand_total":"55.68","paid_amount":"55.68","room_type_id":"293","product_id":"1124","siteminder_id":"BDC-3515982470","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":"92299","customer_id":"92299","source_of_creation":"Booking.com","reservation_created_date":"2019-10-03 16:04:09","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"7.39","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"49.27","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":"3013157","reservation_id":"83104","confirmation_number":"BP12581002347","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"57.98,73.37,73.37","nightly_discount":"0,0,0","subtotal":"204.72","grand_total":"231.33","paid_amount":"231.33","room_type_id":"298","product_id":"1133","siteminder_id":"EXP-1328120505","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":"90537","customer_id":"90537","source_of_creation":"Expedia","reservation_created_date":"2019-08-23 19:07:09","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":"57.98","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3024408","reservation_id":"84973","confirmation_number":"BP12519071615","room_stay_from":"2019-10-01","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"51.87,51.87,51.87","nightly_discount":"0,0,0","subtotal":"155.61","grand_total":"175.84","paid_amount":"175.84","room_type_id":"295","product_id":"1128","siteminder_id":"HWR-301065755","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":"92225","customer_id":"92225","source_of_creation":"Hotwire","reservation_created_date":"2019-10-01 21:29:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"51.87","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3023852","reservation_id":"61102","confirmation_number":"BP12539190075","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.00,102.00,102.00,102.00,102.00,102.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"612.00","grand_total":"691.56","paid_amount":"691.56","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"56019","customer_id":"56019","source_of_creation":"FE","reservation_created_date":"2018-11-24 14:31:53","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"102.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3022213","reservation_id":"81031","confirmation_number":"BP12541933890","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.60,93.60,93.60,93.60,109.60,109.60,93.60,93.60,93.60,93.60,93.60,109.60,109.60,93.60,93.60,93.60,93.60,93.60,93.60,93.60,93.60","nightly_discount":"86.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","subtotal":"2029.60","grand_total":"2195.37","paid_amount":"2195.37","room_type_id":"294","product_id":"1127","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":"89141","customer_id":"89141","source_of_creation":"PMS","reservation_created_date":"2019-07-19 19:58:46","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"93.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022219","reservation_id":"57926","confirmation_number":"BP12530019332","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"99.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"2079.00","grand_total":"2237.40","paid_amount":"2237.40","room_type_id":"296","product_id":"1131","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":"58813","customer_id":"58813","source_of_creation":"PMS","reservation_created_date":"2018-10-09 15:24:13","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3024904","reservation_id":"85021","confirmation_number":"BP12582567543","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.34,78.34","nightly_discount":"0.00,0.00","subtotal":"156.68","grand_total":"177.05","paid_amount":"177.05","room_type_id":"294","product_id":"1125","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92272","customer_id":"92272","source_of_creation":"PMS","reservation_created_date":"2019-10-02 23:04:49","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"78.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3024936","reservation_id":"85055","confirmation_number":"BP12571827913","room_stay_from":"2019-10-03","room_stay_to":"2019-10-10","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"115.78,176.80,176.80,115.78,115.78,115.78,115.78","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"932.50","grand_total":"1053.73","paid_amount":"1053.73","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":"92039","customer_id":"92039","source_of_creation":"PMS","reservation_created_date":"2019-10-03 16:19:52","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":"115.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3024999","reservation_id":"85075","confirmation_number":"BP12524160551","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.43","nightly_discount":"0.00","subtotal":"90.43","grand_total":"102.19","paid_amount":"102.19","room_type_id":"300","product_id":"1135","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92313","customer_id":"92313","source_of_creation":"PMS","reservation_created_date":"2019-10-03 20:56:23","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.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":"3025408","reservation_id":"84600","confirmation_number":"BP12586541405","room_stay_from":"2019-09-29","room_stay_to":"2019-10-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.00,64.00,64.00,64.00,64.00,64.00,64.00,64.00,64.00,64.00,64.00,64.00,64.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,34.60,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"832.00","grand_total":"901.06","paid_amount":"901.06","room_type_id":"294","product_id":"1126","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91477","customer_id":"91477","source_of_creation":"PMS","reservation_created_date":"2019-09-23 14:12:57","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"64.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3030715","reservation_id":"83898","confirmation_number":"BP12532294945","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.73,65.86","nightly_discount":"0.00,0.00","subtotal":"119.59","grand_total":"135.14","paid_amount":"135.14","room_type_id":"301","product_id":"1136","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89374","customer_id":"89374","source_of_creation":"PMS","reservation_created_date":"2019-09-10 22:58:50","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"53.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3024938","reservation_id":"85055","confirmation_number":"BP12226732211","room_confirmation_number":"BP12571827913","room_stay_from":"2019-10-03","room_stay_to":"2019-10-10","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"92039","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-10-03 16:19:52","reservation_modified_date_time":"2019-10-03 16:19:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92039","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3013158","reservation_id":"83104","confirmation_number":"BP12251588808","room_confirmation_number":"BP12581002347","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","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":"90537","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-23 19:07:09","reservation_modified_date_time":"2019-08-23 19:07:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90537","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":"3022214","reservation_id":"81031","confirmation_number":"BP12246988669","room_confirmation_number":"BP12541933890","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89141","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-19 19:58:46","reservation_modified_date_time":"2019-09-23 22:48:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89141","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":"3022220","reservation_id":"57926","confirmation_number":"BP12547187980","room_confirmation_number":"BP12530019332","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"58813","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-10-09 15:24:13","reservation_modified_date_time":"2019-09-23 23:00:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58813","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":"3023853","reservation_id":"61102","confirmation_number":"PBR12226036418","room_confirmation_number":"BP12539190075","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"56019","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56019","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3024409","reservation_id":"84973","confirmation_number":"BP12288122788","room_confirmation_number":"BP12519071615","room_stay_from":"2019-10-01","room_stay_to":"2019-10-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":"92225","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-01 21:29:11","reservation_modified_date_time":"2019-10-01 21:29:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92225","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":"3024905","reservation_id":"85021","confirmation_number":"BP12279996702","room_confirmation_number":"BP12582567543","room_stay_from":"2019-10-02","room_stay_to":"2019-10-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":"92272","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-02 23:04:49","reservation_modified_date_time":"2019-10-02 23:04:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92272","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":"3024928","reservation_id":"85053","confirmation_number":"BP12290425848","room_confirmation_number":"BP12543723408","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"92299","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-03 16:04:09","reservation_modified_date_time":"2019-10-03 16:04:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92299","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":"3024937","reservation_id":"85055","confirmation_number":"BP12293684687","room_confirmation_number":"BP12571827913","room_stay_from":"2019-10-03","room_stay_to":"2019-10-10","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":"92039","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-03 16:19:52","reservation_modified_date_time":"2019-10-03 16:19:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92039","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":"3025001","reservation_id":"85075","confirmation_number":"BP12278224274","room_confirmation_number":"BP12524160551","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"92313","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-03 20:56:23","reservation_modified_date_time":"2019-10-03 20:56:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92313","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":"3025409","reservation_id":"84600","confirmation_number":"BP12243522395","room_confirmation_number":"BP12586541405","room_stay_from":"2019-09-29","room_stay_to":"2019-10-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"156.00","grand_total":"176.28","paid_amount":"176.28","product_id":"1781","service_quantity":"1","customer_traveller_id":"91477","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-23 14:12:57","reservation_modified_date_time":"2019-10-01 17:25:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91477","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":"3030716","reservation_id":"83898","confirmation_number":"BP12229884190","room_confirmation_number":"BP12532294945","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89374","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-10 22:58:50","reservation_modified_date_time":"2019-10-20 18:40:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89374","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":"3025038","reservation_id":"85075","confirmation_number":"BP12224118418","room_confirmation_number":"BP12524160551","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"50.00","grand_total":"50.00","paid_amount":"0.00","product_id":"1082","service_quantity":"1","product_name":"Pet deposit for 1 pet at bp105","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 23:50:22","reservation_modified_date_time":"2019-10-03 23:50:22","customer_id":"92313","parentCustTravId":"92313","customer_traveller_id":"92313","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","canceled_nights_data":"","product_attribute_values":null,"currentDayPrice":50,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3024909","reservation_id":"85021","confirmation_number":"BP12229465879","room_confirmation_number":"BP12582567543","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 14:46:56","reservation_modified_date_time":"2019-10-03 14:46:56","customer_id":"92272","parentCustTravId":"92272","customer_traveller_id":"92272","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3025000","reservation_id":"85075","confirmation_number":"BP12282400292","room_confirmation_number":"BP12524160551","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 20:56:23","reservation_modified_date_time":"2019-10-03 20:56:23","customer_id":"92313","parentCustTravId":"92313","customer_traveller_id":"92313","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","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":[]}},"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2019-10-03","total_rooms_exist":66,"departureCount":14,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"4","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2984300","reservation_id":"77957","confirmation_number":"PB12362189565","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.83,113.83,113.83,113.83,113.83,125.27","nightly_discount":"0,0,0,0,0,0","subtotal":"694.42","grand_total":"784.70","paid_amount":"784.70","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3438081794","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":"56218","customer_id":"56218","source_of_creation":"Booking.com","reservation_created_date":"2019-06-04 17:28:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"244.33","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"}]},{"room_stay_id":"2993600","reservation_id":"79905","confirmation_number":"PB12382405007","room_stay_from":"2019-10-03","room_stay_to":"2019-10-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.99,142.43,142.43,130.99,130.99,130.99,130.99,130.99","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1070.80","grand_total":"1210.01","paid_amount":"1210.01","room_type_id":"291","product_id":"1115","siteminder_id":"BDC-3547999162","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":"88352","customer_id":"88352","source_of_creation":"Booking.com","reservation_created_date":"2019-06-30 00:04:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"184.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.99","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":"3013960","reservation_id":"77957","confirmation_number":"PB12317249701","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.83,113.83,113.83,113.83,113.83,125.27","nightly_discount":"0,0,0,0,0,0","subtotal":"694.42","grand_total":"784.70","paid_amount":"784.70","room_type_id":"289","product_id":"1123","siteminder_id":"BDC-3438081794","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":"56218","customer_id":"56218","source_of_creation":"Booking.com","reservation_created_date":"2019-06-04 17:28:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"244.33","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"}]},{"room_stay_id":"3024927","reservation_id":"85053","confirmation_number":"BP12543723408","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"49.27","nightly_discount":"0","subtotal":"49.27","grand_total":"55.68","paid_amount":"55.68","room_type_id":"293","product_id":"1124","siteminder_id":"BDC-3515982470","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":"92299","customer_id":"92299","source_of_creation":"Booking.com","reservation_created_date":"2019-10-03 16:04:09","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"7.39","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"49.27","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":"2989180","reservation_id":"78854","confirmation_number":"PB12374611273","room_stay_from":"2019-09-30","room_stay_to":"2019-10-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.47,131.47,131.47,131.47,142.03,142.03,131.47","nightly_discount":"0,0,0,0,0,0,0","subtotal":"941.41","grand_total":"1063.79","paid_amount":"1063.79","room_type_id":"288","product_id":"1091","siteminder_id":"EXP-1280031905","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":"91693","customer_id":"91693","source_of_creation":"Expedia","reservation_created_date":"2019-06-17 18:30:09","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":"131.47","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":"3011142","reservation_id":"82757","confirmation_number":"PB12355541562","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.99,142.43","nightly_discount":"0,0","subtotal":"273.42","grand_total":"308.97","paid_amount":"308.97","room_type_id":"286","product_id":"1086","siteminder_id":"EXP-1323383792","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":"90303","customer_id":"90303","source_of_creation":"Expedia","reservation_created_date":"2019-08-16 19:27:10","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.99","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":"3013157","reservation_id":"83104","confirmation_number":"BP12581002347","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"57.98,73.37,73.37","nightly_discount":"0,0,0","subtotal":"204.72","grand_total":"231.33","paid_amount":"231.33","room_type_id":"298","product_id":"1133","siteminder_id":"EXP-1328120505","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":"90537","customer_id":"90537","source_of_creation":"Expedia","reservation_created_date":"2019-08-23 19:07:09","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":"57.98","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":"3016730","reservation_id":"83692","confirmation_number":"PB12381383998","room_stay_from":"2019-10-03","room_stay_to":"2019-10-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.16,94.82,94.82,86.16","nightly_discount":"0,0,0,0","subtotal":"361.96","grand_total":"409.02","paid_amount":"409.02","room_type_id":"289","product_id":"1106","siteminder_id":"EXP-1337126118","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":"91072","customer_id":"91072","source_of_creation":"Expedia","reservation_created_date":"2019-09-06 13:07:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3024078","reservation_id":"84914","confirmation_number":"PB12359814916","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.34,93.34","nightly_discount":"0,0","subtotal":"186.68","grand_total":"210.95","paid_amount":"210.95","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1352673531","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":"92180","customer_id":"92180","source_of_creation":"Expedia","reservation_created_date":"2019-09-30 19:11:09","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":"93.34","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":"3025058","reservation_id":"81876","confirmation_number":"PB12376721892","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"66.92,74.19,74.19","nightly_discount":"0.00,0.00,0.00","subtotal":"215.30","grand_total":"243.29","paid_amount":"243.29","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1313502292","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":"89707","customer_id":"89707","source_of_creation":"Expedia","reservation_created_date":"2019-08-02 13:24:08","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":"66.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3024637","reservation_id":"85012","confirmation_number":"BV12463171354","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.57,100.11","nightly_discount":"0,0","subtotal":"182.68","grand_total":"206.43","paid_amount":"206.43","room_type_id":"305","product_id":"1222","siteminder_id":"GAM-R1687419254","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":"92264","customer_id":"92264","source_of_creation":"Getaroom.com","reservation_created_date":"2019-10-02 21:13:07","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":"82.57","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":"3024948","reservation_id":"83013","confirmation_number":"PB12326079649","room_stay_from":"2019-10-03","room_stay_to":"2019-10-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.40,85.18,85.18,77.40","nightly_discount":"0,0,0,0","subtotal":"325.16","grand_total":"367.43","paid_amount":"367.43","room_type_id":"289","product_id":"1112","siteminder_id":"GAM-R1626536237","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":"90478","customer_id":"90478","source_of_creation":"Getaroom.com","reservation_created_date":"2019-08-21 21:43:09","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":"77.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3024408","reservation_id":"84973","confirmation_number":"BP12519071615","room_stay_from":"2019-10-01","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"51.87,51.87,51.87","nightly_discount":"0,0,0","subtotal":"155.61","grand_total":"175.84","paid_amount":"175.84","room_type_id":"295","product_id":"1128","siteminder_id":"HWR-301065755","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":"92225","customer_id":"92225","source_of_creation":"Hotwire","reservation_created_date":"2019-10-01 21:29:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"51.87","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3025048","reservation_id":"84457","confirmation_number":"PB12386755271","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"75.91","nightly_discount":"0.00","subtotal":"75.91","grand_total":"85.77","paid_amount":"85.77","room_type_id":"289","product_id":"1097","siteminder_id":"AGO-281569078","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":"91872","customer_id":"91872","source_of_creation":"Agoda","reservation_created_date":"2019-09-21 03:21:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2986398","reservation_id":"78327","confirmation_number":"PB12344348648","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"128.80,144.80","nightly_discount":"0.00,0.00","subtotal":"273.60","grand_total":"309.17","paid_amount":"309.17","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":"87413","customer_id":"87413","source_of_creation":"FE","reservation_created_date":"2019-06-09 16:15:19","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":"128.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":"2999911","reservation_id":"80932","confirmation_number":"PB12348057448","room_stay_from":"2019-09-30","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"119.20,119.20,119.20,119.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"476.80","grand_total":"538.79","paid_amount":"538.79","room_type_id":"291","product_id":"1116","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":"89070","customer_id":"89070","source_of_creation":"FE","reservation_created_date":"2019-07-18 13:27:48","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","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":"3014374","reservation_id":"83290","confirmation_number":"PB12327917706","room_stay_from":"2019-10-02","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.80,160.80,176.80","nightly_discount":"0.00,0.00,0.00","subtotal":"498.40","grand_total":"563.19","paid_amount":"563.19","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90669","customer_id":"90669","source_of_creation":"FE","reservation_created_date":"2019-08-27 16:26:38","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.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":"3015125","reservation_id":"83423","confirmation_number":"BV12461307974","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.68,67.68,67.68,67.68,67.68,91.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"429.60","grand_total":"485.45","paid_amount":"485.45","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":"90757","customer_id":"90757","source_of_creation":"FE","reservation_created_date":"2019-08-30 08:26:39","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":"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":"3015537","reservation_id":"83474","confirmation_number":"PB12398369570","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.00,120.00,120.00,120.00,120.00,120.00,136.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"872.00","grand_total":"985.36","paid_amount":"985.36","room_type_id":"288","product_id":"1092","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":"90785","customer_id":"90785","source_of_creation":"FE","reservation_created_date":"2019-08-31 15:13:44","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","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":"3022721","reservation_id":"84722","confirmation_number":"BV12445156976","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.88,139.20","nightly_discount":"0.00,0.00","subtotal":"250.08","grand_total":"282.59","paid_amount":"282.59","room_type_id":"304","product_id":"1219","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92035","customer_id":"92035","source_of_creation":"FE","reservation_created_date":"2019-09-26 14:40:08","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":"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":"3023852","reservation_id":"61102","confirmation_number":"BP12539190075","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.00,102.00,102.00,102.00,102.00,102.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"612.00","grand_total":"691.56","paid_amount":"691.56","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"56019","customer_id":"56019","source_of_creation":"FE","reservation_created_date":"2018-11-24 14:31:53","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"102.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3024073","reservation_id":"78331","confirmation_number":"PB12380732772","room_stay_from":"2019-09-30","room_stay_to":"2019-10-07","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"704.00","grand_total":"795.52","paid_amount":"795.52","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"40155","customer_id":"40155","source_of_creation":"FE","reservation_created_date":"2019-06-09 17:26:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2954691","reservation_id":"72849","confirmation_number":"PB12397680645","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.00,180.00","nightly_discount":"0.00,0.00","subtotal":"340.00","grand_total":"384.20","paid_amount":"384.20","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":"83891","customer_id":"83891","source_of_creation":"PMS","reservation_created_date":"2019-03-22 18:02:24","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":"160.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007483","reservation_id":"82088","confirmation_number":"BV12436088098","room_stay_from":"2019-10-02","room_stay_to":"2019-10-09","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"60.48,60.48,83.20,83.20,60.48,60.48,60.48","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"468.80","grand_total":"529.75","paid_amount":"529.75","room_type_id":"303","product_id":"1139","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"43955","customer_id":"43955","source_of_creation":"PMS","reservation_created_date":"2019-08-05 20:08:14","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"60.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008823","reservation_id":"81801","confirmation_number":"PB12350809927","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,120.00","nightly_discount":"0.00,0.00,0.00","subtotal":"328.00","grand_total":"370.64","paid_amount":"370.64","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"44752","customer_id":"44752","source_of_creation":"PMS","reservation_created_date":"2019-08-01 01:46:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3014389","reservation_id":"83292","confirmation_number":"PB12383739686","room_stay_from":"2019-10-03","room_stay_to":"2019-10-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.80,176.80,176.80,160.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"675.20","grand_total":"762.97","paid_amount":"762.97","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":"90671","customer_id":"90671","source_of_creation":"PMS","reservation_created_date":"2019-08-27 17:10:27","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":"160.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":"3017776","reservation_id":"83821","confirmation_number":"BV12469374057","room_stay_from":"2019-10-02","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.96,102.96,130.40","nightly_discount":"0.00,0.00,0.00","subtotal":"336.32","grand_total":"380.04","paid_amount":"380.04","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":"84913","customer_id":"84913","source_of_creation":"PMS","reservation_created_date":"2019-09-09 14:41:04","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":"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":"3022213","reservation_id":"81031","confirmation_number":"BP12541933890","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.60,93.60,93.60,93.60,109.60,109.60,93.60,93.60,93.60,93.60,93.60,109.60,109.60,93.60,93.60,93.60,93.60,93.60,93.60,93.60,93.60","nightly_discount":"86.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","subtotal":"2029.60","grand_total":"2195.37","paid_amount":"2195.37","room_type_id":"294","product_id":"1127","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":"89141","customer_id":"89141","source_of_creation":"PMS","reservation_created_date":"2019-07-19 19:58:46","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"93.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022219","reservation_id":"57926","confirmation_number":"BP12530019332","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"99.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"2079.00","grand_total":"2237.40","paid_amount":"2237.40","room_type_id":"296","product_id":"1131","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":"58813","customer_id":"58813","source_of_creation":"PMS","reservation_created_date":"2018-10-09 15:24:13","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3022533","reservation_id":"82971","confirmation_number":"PB12324768557","room_stay_from":"2019-09-25","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,112.00,112.00,96.00,96.00,96.00,96.00,96.00,112.00","nightly_discount":"0.00,51.47,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1008.00","grand_total":"1080.88","paid_amount":"1080.88","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":"56624","customer_id":"56624","source_of_creation":"PMS","reservation_created_date":"2019-08-20 19:41:46","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":"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":"3022990","reservation_id":"58149","confirmation_number":"BV12477278913","room_stay_from":"2019-09-26","room_stay_to":"2019-10-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.00,87.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,73.95,0.00","subtotal":"1566.00","grand_total":"1686.01","paid_amount":"1686.01","room_type_id":"303","product_id":"1140","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"40114","customer_id":"40114","source_of_creation":"PMS","reservation_created_date":"2018-10-13 16:25:35","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":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3023180","reservation_id":"83646","confirmation_number":"PB12374364977","room_stay_from":"2019-09-27","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"112.00,112.00,96.00,96.00,96.00,96.00,96.00,112.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,39.76,0.00","subtotal":"816.00","grand_total":"877.15","paid_amount":"877.16","room_type_id":"289","product_id":"1105","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"61509","customer_id":"61509","source_of_creation":"PMS","reservation_created_date":"2019-09-05 14:59:24","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3023622","reservation_id":"84366","confirmation_number":"PB12389904472","room_stay_from":"2019-09-30","room_stay_to":"2019-10-04","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":"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":"70463","customer_id":"70463","source_of_creation":"PMS","reservation_created_date":"2019-09-19 18:52:04","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":"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":"3023655","reservation_id":"84544","confirmation_number":"PB12361559219","room_stay_from":"2019-10-01","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,119.20,119.20","nightly_discount":"0.00,0.00,0.00","subtotal":"357.60","grand_total":"404.09","paid_amount":"404.09","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":"73231","customer_id":"73231","source_of_creation":"PMS","reservation_created_date":"2019-09-22 21:12:17","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":"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":"3024165","reservation_id":"84924","confirmation_number":"PB12340153801","room_stay_from":"2019-09-30","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,119.20,119.20,119.20","nightly_discount":"26.24,0.00,0.00,0.00","subtotal":"476.80","grand_total":"509.13","paid_amount":"509.13","room_type_id":"291","product_id":"1117","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90393","customer_id":"90393","source_of_creation":"PMS","reservation_created_date":"2019-09-30 20:22:54","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3024564","reservation_id":"81900","confirmation_number":"PB12360296116","room_stay_from":"2019-10-02","room_stay_to":"2019-10-07","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,0.00","subtotal":"552.00","grand_total":"623.76","paid_amount":"623.76","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":"89726","customer_id":"89726","source_of_creation":"PMS","reservation_created_date":"2019-08-02 19:05:10","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":"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":"3024579","reservation_id":"81801","confirmation_number":"PB12357066886","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,120.00","nightly_discount":"0.00,0.00,0.00","subtotal":"328.00","grand_total":"370.64","paid_amount":"370.64","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":"44752","customer_id":"44752","source_of_creation":"PMS","reservation_created_date":"2019-08-01 01:46:20","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":"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":"3024843","reservation_id":"85002","confirmation_number":"BV12431144276","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.08,0.00","nightly_discount":"0.00,0.00","subtotal":"136.08","grand_total":"153.77","paid_amount":"153.77","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92253","customer_id":"92253","source_of_creation":"PMS","reservation_created_date":"2019-10-02 17:56:01","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3024869","reservation_id":"80196","confirmation_number":"PB12332838153","room_stay_from":"2019-09-23","room_stay_to":"2019-10-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"148.80,148.80,148.80,148.80,164.80,164.80,148.80,148.80,148.80,148.80,148.80,164.80,164.80,148.80,89.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","subtotal":"2236.20","grand_total":"2526.90","paid_amount":"2526.90","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":"48600","customer_id":"48600","source_of_creation":"PMS","reservation_created_date":"2019-07-04 22:48:30","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"148.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":"3024904","reservation_id":"85021","confirmation_number":"BP12582567543","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.34,78.34","nightly_discount":"0.00,0.00","subtotal":"156.68","grand_total":"177.05","paid_amount":"177.05","room_type_id":"294","product_id":"1125","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92272","customer_id":"92272","source_of_creation":"PMS","reservation_created_date":"2019-10-02 23:04:49","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"78.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3024936","reservation_id":"85055","confirmation_number":"BP12571827913","room_stay_from":"2019-10-03","room_stay_to":"2019-10-10","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"115.78,176.80,176.80,115.78,115.78,115.78,115.78","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"932.50","grand_total":"1053.73","paid_amount":"1053.73","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":"92039","customer_id":"92039","source_of_creation":"PMS","reservation_created_date":"2019-10-03 16:19:52","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":"115.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3024999","reservation_id":"85075","confirmation_number":"BP12524160551","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.43","nightly_discount":"0.00","subtotal":"90.43","grand_total":"102.19","paid_amount":"102.19","room_type_id":"300","product_id":"1135","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92313","customer_id":"92313","source_of_creation":"PMS","reservation_created_date":"2019-10-03 20:56:23","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.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":"3025013","reservation_id":"85079","confirmation_number":"PB12322270207","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.60","nightly_discount":"0.00","subtotal":"89.60","grand_total":"101.25","paid_amount":"101.25","room_type_id":"289","product_id":"1110","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":"22954","customer_id":"22954","source_of_creation":"PMS","reservation_created_date":"2019-10-03 22:43:49","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":"89.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3025089","reservation_id":"85097","confirmation_number":"BV12460965629","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"88.70","nightly_discount":"0.00","subtotal":"88.70","grand_total":"100.23","paid_amount":"100.23","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":"92330","customer_id":"92330","source_of_creation":"PMS","reservation_created_date":"2019-10-04 03:31:48","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":"88.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3025163","reservation_id":"85003","confirmation_number":"BV12434309030","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.88,0.00","nightly_discount":"0.00,0.00","subtotal":"110.88","grand_total":"125.29","paid_amount":"125.29","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":"92254","customer_id":"92254","source_of_creation":"PMS","reservation_created_date":"2019-10-02 18:00:55","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":"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":"3025408","reservation_id":"84600","confirmation_number":"BP12586541405","room_stay_from":"2019-09-29","room_stay_to":"2019-10-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.00,64.00,64.00,64.00,64.00,64.00,64.00,64.00,64.00,64.00,64.00,64.00,64.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,34.60,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"832.00","grand_total":"901.06","paid_amount":"901.06","room_type_id":"294","product_id":"1126","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91477","customer_id":"91477","source_of_creation":"PMS","reservation_created_date":"2019-09-23 14:12:57","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"64.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028632","reservation_id":"84903","confirmation_number":"PB12389781041","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"289","product_id":"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":"92171","customer_id":"92171","source_of_creation":"PMS","reservation_created_date":"2019-09-30 16:05:59","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":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028740","reservation_id":"81873","confirmation_number":"PB12354855806","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"94.00,94.00,99.00,99.00,99.00,111.96","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"596.96","grand_total":"674.57","paid_amount":"674.57","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":"89705","customer_id":"89705","source_of_creation":"PMS","reservation_created_date":"2019-08-02 12:40:55","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":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3030715","reservation_id":"83898","confirmation_number":"BP12532294945","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.73,65.86","nightly_discount":"0.00,0.00","subtotal":"119.59","grand_total":"135.14","paid_amount":"135.14","room_type_id":"301","product_id":"1136","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89374","customer_id":"89374","source_of_creation":"PMS","reservation_created_date":"2019-09-10 22:58:50","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"53.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3024040","reservation_id":"30877","confirmation_number":"PB956638105","room_stay_from":"2019-09-30","room_stay_to":"2019-10-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.00,75.00,75.00","nightly_discount":"0.00,0.00,7.30,0.00","subtotal":"225.00","grand_total":"246.00","paid_amount":"246.00","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":"25372","customer_id":"25372","source_of_creation":"PMS","reservation_created_date":"2016-09-21 19:48:12","canceled_nights_data":"","product_name":"114 PB Deluxe Efficiency Suite","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"-7.30","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2986400","reservation_id":"78327","confirmation_number":"PB12280842498","room_confirmation_number":"PB12344348648","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"87413","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-09 16:15:19","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87413","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":"2999913","reservation_id":"80932","confirmation_number":"PB12282605444","room_confirmation_number":"PB12348057448","room_stay_from":"2019-09-30","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,10.00","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":"89070","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-07-18 13:27:48","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89070","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":"3016516","reservation_id":"83646","confirmation_number":"PB12220596174","room_confirmation_number":"PB12374364977","room_stay_from":"2019-09-27","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"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","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"61509","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-05 14:59:24","reservation_modified_date_time":"2019-09-05 14:59:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"61509","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":"3017807","reservation_id":"81873","confirmation_number":"PB12272760901","room_confirmation_number":"PB12354855806","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"89705","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-09 16:26:48","reservation_modified_date_time":"2019-09-09 16:26:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89705","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":"3024938","reservation_id":"85055","confirmation_number":"BP12226732211","room_confirmation_number":"BP12571827913","room_stay_from":"2019-10-03","room_stay_to":"2019-10-10","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"92039","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-10-03 16:19:52","reservation_modified_date_time":"2019-10-03 16:19:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92039","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":"3025050","reservation_id":"84457","confirmation_number":"PB12281326125","room_confirmation_number":"PB12386755271","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"91872","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-10-04 00:47:17","reservation_modified_date_time":"2019-10-04 00:47:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91872","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2954692","reservation_id":"72849","confirmation_number":"PB12286957381","room_confirmation_number":"PB12397680645","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"83891","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-03-22 18:02:24","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83891","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":"2984301","reservation_id":"77957","confirmation_number":"PB12264348413","room_confirmation_number":"PB12362189565","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"87150","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-04 17:28:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56218","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":"2986399","reservation_id":"78327","confirmation_number":"PB12220444995","room_confirmation_number":"PB12344348648","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"87413","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-09 16:15:19","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87413","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":"2989181","reservation_id":"78854","confirmation_number":"PB12250670060","room_confirmation_number":"PB12374611273","room_stay_from":"2019-09-30","room_stay_to":"2019-10-07","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91693","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-17 18:30:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91693","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":"2993601","reservation_id":"79905","confirmation_number":"PB12293871706","room_confirmation_number":"PB12382405007","room_stay_from":"2019-10-03","room_stay_to":"2019-10-11","room_stay_status":"Active","nightly_price":"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","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88352","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-30 00:04:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88352","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":"2999912","reservation_id":"80932","confirmation_number":"PB12288126033","room_confirmation_number":"PB12348057448","room_stay_from":"2019-09-30","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"89070","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-18 13:27:48","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89070","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":"3007484","reservation_id":"82088","confirmation_number":"BV12255181394","room_confirmation_number":"BV12436088098","room_stay_from":"2019-10-02","room_stay_to":"2019-10-09","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"43955","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-05 20:08:14","reservation_modified_date_time":"2019-08-05 20:08:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"43955","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":"3008824","reservation_id":"81801","confirmation_number":"PB12229744828","room_confirmation_number":"PB12350809927","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"44752","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-01 01:46:20","reservation_modified_date_time":"2019-08-01 01:46:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44752","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":"3011143","reservation_id":"82757","confirmation_number":"PB12255570007","room_confirmation_number":"PB12355541562","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"90303","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-16 19:27:10","reservation_modified_date_time":"2019-08-16 19:27:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90303","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":"3013158","reservation_id":"83104","confirmation_number":"BP12251588808","room_confirmation_number":"BP12581002347","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","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":"90537","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-23 19:07:09","reservation_modified_date_time":"2019-08-23 19:07:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90537","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":"3013961","reservation_id":"77957","confirmation_number":"PB12221603096","room_confirmation_number":"PB12317249701","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"56218","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-04 17:28:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56218","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":"3014375","reservation_id":"83290","confirmation_number":"PB12222337733","room_confirmation_number":"PB12327917706","room_stay_from":"2019-10-02","room_stay_to":"2019-10-05","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":"90669","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-27 16:26:38","reservation_modified_date_time":"2019-08-27 16:26:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90669","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":"3014390","reservation_id":"83292","confirmation_number":"PB12275341824","room_confirmation_number":"PB12383739686","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"90671","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-27 17:10:27","reservation_modified_date_time":"2019-08-27 17:10:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90671","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":"3015126","reservation_id":"83423","confirmation_number":"BV12282071941","room_confirmation_number":"BV12461307974","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","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":"90757","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-30 08:26:39","reservation_modified_date_time":"2019-08-30 08:26:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90757","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":"3015538","reservation_id":"83474","confirmation_number":"PB12259515279","room_confirmation_number":"PB12398369570","room_stay_from":"2019-09-28","room_stay_to":"2019-10-05","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":"90785","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-31 15:13:44","reservation_modified_date_time":"2019-08-31 15:13:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90785","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":"3016731","reservation_id":"83692","confirmation_number":"PB12286651667","room_confirmation_number":"PB12381383998","room_stay_from":"2019-10-03","room_stay_to":"2019-10-07","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":"91072","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-06 13:07:08","reservation_modified_date_time":"2019-09-06 13:07:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91072","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":"3017777","reservation_id":"83821","confirmation_number":"BV12243015379","room_confirmation_number":"BV12469374057","room_stay_from":"2019-10-02","room_stay_to":"2019-10-05","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":"84913","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-09 14:41:04","reservation_modified_date_time":"2019-09-09 14:41:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84913","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":"3022214","reservation_id":"81031","confirmation_number":"BP12246988669","room_confirmation_number":"BP12541933890","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89141","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-19 19:58:46","reservation_modified_date_time":"2019-09-23 22:48:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89141","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":"3022220","reservation_id":"57926","confirmation_number":"BP12547187980","room_confirmation_number":"BP12530019332","room_stay_from":"2019-09-23","room_stay_to":"2019-10-14","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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"58813","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-10-09 15:24:13","reservation_modified_date_time":"2019-09-23 23:00:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58813","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":"3022534","reservation_id":"82971","confirmation_number":"PB12275739458","room_confirmation_number":"PB12324768557","room_stay_from":"2019-09-25","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"56624","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-20 19:41:46","reservation_modified_date_time":"2019-09-25 19:48:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56624","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":"3022722","reservation_id":"84722","confirmation_number":"BV12221074309","room_confirmation_number":"BV12445156976","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"92035","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-26 14:40:08","reservation_modified_date_time":"2019-09-26 14:40:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92035","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":"3022991","reservation_id":"58149","confirmation_number":"BV12440557868","room_confirmation_number":"BV12477278913","room_stay_from":"2019-09-26","room_stay_to":"2019-10-14","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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"40114","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-10-13 16:34:33","reservation_modified_date_time":"2019-09-27 01:31:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"40114","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":"3023181","reservation_id":"83646","confirmation_number":"PB12237844524","room_confirmation_number":"PB12374364977","room_stay_from":"2019-09-27","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"61509","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-05 14:59:24","reservation_modified_date_time":"2019-09-27 15:49:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"61509","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":"3023623","reservation_id":"84366","confirmation_number":"PB12229111663","room_confirmation_number":"PB12389904472","room_stay_from":"2019-09-30","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"70463","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 18:52:04","reservation_modified_date_time":"2019-09-19 18:52:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70463","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":"3023656","reservation_id":"84544","confirmation_number":"PB12249161208","room_confirmation_number":"PB12361559219","room_stay_from":"2019-10-01","room_stay_to":"2019-10-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":"73231","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-22 21:12:17","reservation_modified_date_time":"2019-09-22 21:12:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73231","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":"3023853","reservation_id":"61102","confirmation_number":"PBR12226036418","room_confirmation_number":"BP12539190075","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"56019","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56019","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3024074","reservation_id":"78331","confirmation_number":"PB12238334126","room_confirmation_number":"PB12380732772","room_stay_from":"2019-09-30","room_stay_to":"2019-10-07","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":"40155","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-09 17:26:06","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"40155","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":"3024079","reservation_id":"84914","confirmation_number":"PB12262575908","room_confirmation_number":"PB12359814916","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"92180","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-30 19:11:09","reservation_modified_date_time":"2019-09-30 19:11:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92180","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":"3024166","reservation_id":"84924","confirmation_number":"PB12253861168","room_confirmation_number":"PB12340153801","room_stay_from":"2019-09-30","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"90393","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-30 20:22:54","reservation_modified_date_time":"2019-09-30 20:22:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90393","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":"3024409","reservation_id":"84973","confirmation_number":"BP12288122788","room_confirmation_number":"BP12519071615","room_stay_from":"2019-10-01","room_stay_to":"2019-10-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":"92225","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-01 21:29:11","reservation_modified_date_time":"2019-10-01 21:29:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92225","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":"3024565","reservation_id":"81900","confirmation_number":"PB12216924629","room_confirmation_number":"PB12360296116","room_stay_from":"2019-10-02","room_stay_to":"2019-10-07","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":"89726","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-02 19:05:10","reservation_modified_date_time":"2019-08-02 19:05:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89726","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":"3024580","reservation_id":"81801","confirmation_number":"PB12256232230","room_confirmation_number":"PB12357066886","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"44752","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-01 01:46:20","reservation_modified_date_time":"2019-08-01 01:46:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44752","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":"3024638","reservation_id":"85012","confirmation_number":"BV12280169135","room_confirmation_number":"BV12463171354","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"92264","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-02 21:13:07","reservation_modified_date_time":"2019-10-02 21:13:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92264","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":"3024844","reservation_id":"85002","confirmation_number":"BV12278005393","room_confirmation_number":"BV12431144276","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,12.00","subtotal":"24.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"92253","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-02 17:56:01","reservation_modified_date_time":"2019-10-03 12:27:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92253","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"12.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3024870","reservation_id":"80196","confirmation_number":"PB12223524481","room_confirmation_number":"PB12332838153","room_stay_from":"2019-09-23","room_stay_to":"2019-10-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","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","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"48600","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-04 22:48:30","reservation_modified_date_time":"2019-10-03 13:25:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"48600","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":"3024905","reservation_id":"85021","confirmation_number":"BP12279996702","room_confirmation_number":"BP12582567543","room_stay_from":"2019-10-02","room_stay_to":"2019-10-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":"92272","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-02 23:04:49","reservation_modified_date_time":"2019-10-02 23:04:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92272","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":"3024928","reservation_id":"85053","confirmation_number":"BP12290425848","room_confirmation_number":"BP12543723408","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"92299","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-03 16:04:09","reservation_modified_date_time":"2019-10-03 16:04:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92299","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":"3024937","reservation_id":"85055","confirmation_number":"BP12293684687","room_confirmation_number":"BP12571827913","room_stay_from":"2019-10-03","room_stay_to":"2019-10-10","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":"92039","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-03 16:19:52","reservation_modified_date_time":"2019-10-03 16:19:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92039","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":"3024949","reservation_id":"83013","confirmation_number":"PB12224612740","room_confirmation_number":"PB12326079649","room_stay_from":"2019-10-03","room_stay_to":"2019-10-07","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":"90478","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-21 21:43:09","reservation_modified_date_time":"2019-08-21 21:43:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90478","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":"3025001","reservation_id":"85075","confirmation_number":"BP12278224274","room_confirmation_number":"BP12524160551","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"92313","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-03 20:56:23","reservation_modified_date_time":"2019-10-03 20:56:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92313","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":"3025014","reservation_id":"85079","confirmation_number":"PB12221817590","room_confirmation_number":"PB12322270207","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"92315","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-03 22:43:49","reservation_modified_date_time":"2019-10-03 22:43:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"22954","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":"3025051","reservation_id":"84457","confirmation_number":"PB12217122071","room_confirmation_number":"PB12386755271","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"91872","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-21 03:21:09","reservation_modified_date_time":"2019-10-04 00:47:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91872","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":"3025059","reservation_id":"81876","confirmation_number":"PB12228515037","room_confirmation_number":"PB12376721892","room_stay_from":"2019-10-03","room_stay_to":"2019-10-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"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":"89707","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-02 13:24:08","reservation_modified_date_time":"2019-10-04 02:23:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89707","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":"3025090","reservation_id":"85097","confirmation_number":"BV12235973256","room_confirmation_number":"BV12460965629","room_stay_from":"2019-10-03","room_stay_to":"2019-10-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":"92330","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-04 03:31:48","reservation_modified_date_time":"2019-10-04 03:31:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92330","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":"3025164","reservation_id":"85003","confirmation_number":"BV12220606665","room_confirmation_number":"BV12434309030","room_stay_from":"2019-10-02","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,12.00","subtotal":"24.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"92254","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-02 18:00:55","reservation_modified_date_time":"2019-10-04 16:19:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92254","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"12.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3025409","reservation_id":"84600","confirmation_number":"BP12243522395","room_confirmation_number":"BP12586541405","room_stay_from":"2019-09-29","room_stay_to":"2019-10-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"156.00","grand_total":"176.28","paid_amount":"176.28","product_id":"1781","service_quantity":"1","customer_traveller_id":"91477","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-23 14:12:57","reservation_modified_date_time":"2019-10-01 17:25:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91477","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":"3028633","reservation_id":"84903","confirmation_number":"PB12253651846","room_confirmation_number":"PB12389781041","room_stay_from":"2019-10-02","room_stay_to":"2019-10-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":"92171","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-30 16:05:59","reservation_modified_date_time":"2019-10-15 15:10:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92171","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":"3028741","reservation_id":"81873","confirmation_number":"PB12289573230","room_confirmation_number":"PB12354855806","room_stay_from":"2019-09-29","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89705","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-02 12:40:55","reservation_modified_date_time":"2019-10-15 17:29:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89705","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":"3030716","reservation_id":"83898","confirmation_number":"BP12229884190","room_confirmation_number":"BP12532294945","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89374","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-10 22:58:50","reservation_modified_date_time":"2019-10-20 18:40:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89374","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":"3022723","reservation_id":"84722","confirmation_number":"BV12219196549","room_confirmation_number":"BV12445156976","room_stay_from":"2019-10-03","room_stay_to":"2019-10-05","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-26 14:40:08","reservation_modified_date_time":"2019-09-26 14:40:08","customer_id":"92035","parentCustTravId":"92035","customer_traveller_id":"92035","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3024878","reservation_id":"85000","confirmation_number":"PB12215624014","room_confirmation_number":"PB12387836611","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1150","service_quantity":"1","product_name":"Clean-Up Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 13:51:48","reservation_modified_date_time":"2019-10-03 13:51:48","customer_id":"92250","parentCustTravId":"92250","customer_traveller_id":"92250","static_pos_type":"cleaningfee","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":"200.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3024879","reservation_id":"83920","confirmation_number":"PB12212715890","room_confirmation_number":"PB12375358693","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":"8.98","paid_amount":"8.98","product_id":"1151","service_quantity":"2","product_name":"Coffee Mug","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 13:55:08","reservation_modified_date_time":"2019-10-03 13:55:08","customer_id":"91482","parentCustTravId":"91482","customer_traveller_id":"91482","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":"8.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3024901","reservation_id":"85003","confirmation_number":"BV12284427338","room_confirmation_number":"BV12434309030","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1142","service_quantity":"1","product_name":"1/2 Day till 6pm","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 14:37:01","reservation_modified_date_time":"2019-10-03 14:37:01","customer_id":"92254","parentCustTravId":"92254","customer_traveller_id":"92254","static_pos_type":"latecheckoutfee","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":"70.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3024909","reservation_id":"85021","confirmation_number":"BP12229465879","room_confirmation_number":"BP12582567543","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 14:46:56","reservation_modified_date_time":"2019-10-03 14:46:56","customer_id":"92272","parentCustTravId":"92272","customer_traveller_id":"92272","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3024950","reservation_id":"83013","confirmation_number":"PB12278775724","room_confirmation_number":"PB12326079649","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 16:37:47","reservation_modified_date_time":"2019-10-03 16:37:47","customer_id":"90478","parentCustTravId":"90478","customer_traveller_id":"90478","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":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3024951","reservation_id":"83692","confirmation_number":"PB12261554837","room_confirmation_number":"PB12381383998","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"10.00","paid_amount":"10.00","product_id":"1175","service_quantity":"1","product_name":"Miscellaneous","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 16:37:49","reservation_modified_date_time":"2019-10-03 16:37:49","customer_id":"91072","parentCustTravId":"91072","customer_traveller_id":"91072","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"9.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3025000","reservation_id":"85075","confirmation_number":"BP12282400292","room_confirmation_number":"BP12524160551","room_stay_from":"2019-10-03","room_stay_to":"2019-10-04","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 20:56:23","reservation_modified_date_time":"2019-10-03 20:56:23","customer_id":"92313","parentCustTravId":"92313","customer_traveller_id":"92313","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3025060","reservation_id":"81876","confirmation_number":"PB12246351013","room_confirmation_number":"PB12376721892","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"41.40","grand_total":"46.78","paid_amount":"46.78","product_id":"1082","service_quantity":"1","product_name":"Resort Fee from \"Despegar\"","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-04 02:25:39","reservation_modified_date_time":"2019-10-04 02:25:39","customer_id":"89707","parentCustTravId":"89707","customer_traveller_id":"89707","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":"41.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3024974","reservation_id":"85064","confirmation_number":"PB12228570002","room_confirmation_number":"PB12384720611","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 18:58:12","reservation_modified_date_time":"2019-10-03 18:58:12","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":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3024560","reservation_id":"85004","confirmation_number":"BV12283436315","room_confirmation_number":"BV12412904230","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"0.00","product_id":"1147","service_quantity":"1","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-02 18:20:00","reservation_modified_date_time":"2019-10-02 18:20:00","customer_id":"92255","parentCustTravId":"92255","customer_traveller_id":"92255","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-10-03 14:57:11","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-10,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3025038","reservation_id":"85075","confirmation_number":"BP12224118418","room_confirmation_number":"BP12524160551","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"50.00","grand_total":"50.00","paid_amount":"0.00","product_id":"1082","service_quantity":"1","product_name":"Pet deposit for 1 pet at bp105","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-03 23:50:22","reservation_modified_date_time":"2019-10-03 23:50:22","customer_id":"92313","parentCustTravId":"92313","customer_traveller_id":"92313","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","canceled_nights_data":"","product_attribute_values":null,"currentDayPrice":50,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}