{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2019-11-05","total_rooms_exist":66,"departureCount":8,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"1","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3007512","reservation_id":"82091","confirmation_number":"BV12472328627","room_stay_from":"2019-11-01","room_stay_to":"2019-11-17","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"113.58,113.58,91.9,91.9,91.9,91.9,91.9,113.58,113.58,91.9,91.9,91.9,91.9,91.9,113.58,113.58","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1600.48","grand_total":"1808.54","paid_amount":"1808.54","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-3067093686","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"160.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89847","customer_id":"89847","source_of_creation":"Booking.com","reservation_created_date":"2019-08-05 20:53:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"264.07","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.9","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034958","reservation_id":"86655","confirmation_number":"BP12593896102","room_stay_from":"2019-11-04","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"96.80,96.80,96.80","nightly_discount":"0,0,0","subtotal":"290.40","grand_total":"328.15","paid_amount":"328.15","room_type_id":"294","product_id":"1126","siteminder_id":"BDC-2806433104","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":"93337","customer_id":"93337","source_of_creation":"Booking.com","reservation_created_date":"2019-11-04 01:15:06","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"43.56","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035453","reservation_id":"85325","confirmation_number":"PB12390510045","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.27,113.83,113.83,113.83","nightly_discount":"0,0,0,0","subtotal":"466.76","grand_total":"527.44","paid_amount":"527.44","room_type_id":"289","product_id":"1104","siteminder_id":"BDC-2129342521","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92484","customer_id":"92484","source_of_creation":"Booking.com","reservation_created_date":"2019-10-08 23:56:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"70.01","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3032420","reservation_id":"86220","confirmation_number":"PB12343271685","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"84.01,84.01,84.01,84.01","nightly_discount":"0,0,0,0","subtotal":"336.04","grand_total":"379.72","paid_amount":"379.72","room_type_id":"289","product_id":"1094","siteminder_id":"EXP-1368498663","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":"93052","customer_id":"93052","source_of_creation":"Expedia","reservation_created_date":"2019-10-25 17:16:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.01","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035380","reservation_id":"82103","confirmation_number":"PB12361850225","room_stay_from":"2019-11-05","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"93.34,93.34","nightly_discount":"0.00,0.00","subtotal":"186.68","grand_total":"210.95","paid_amount":"210.95","room_type_id":"289","product_id":"1106","siteminder_id":"EXP-1315801232","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":"89855","customer_id":"89855","source_of_creation":"Expedia","reservation_created_date":"2019-08-05 23:57:09","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":"93.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":"3035748","reservation_id":"82102","confirmation_number":"BV12422682618","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.37","nightly_discount":"0.00","subtotal":"81.37","grand_total":"91.95","paid_amount":"91.95","room_type_id":"307","product_id":"1224","siteminder_id":"EXP-1315800023","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":"89857","customer_id":"89857","source_of_creation":"Expedia","reservation_created_date":"2019-08-05 23:57:08","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":"81.37","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2987881","reservation_id":"78663","confirmation_number":"PB12329320660","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"61.66","nightly_discount":"0","subtotal":"61.66","grand_total":"69.68","paid_amount":"69.68","room_type_id":"290","product_id":"1113","siteminder_id":"GAM-R1537098530","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":"87669","customer_id":"87669","source_of_creation":"Getaroom.com","reservation_created_date":"2019-06-14 04:43:05","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":"61.66","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":"3033973","reservation_id":"86514","confirmation_number":"BP12550755154","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"48.52,48.52,48.52,48.52","nightly_discount":"0,0,0,0","subtotal":"194.08","grand_total":"219.31","paid_amount":"219.31","room_type_id":"295","product_id":"1129","siteminder_id":"GAM-R1728953154","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":"93253","customer_id":"93253","source_of_creation":"Getaroom.com","reservation_created_date":"2019-11-01 00:49:09","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":"48.52","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3035097","reservation_id":"86675","confirmation_number":"BV12462634784","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.13","nightly_discount":"0","subtotal":"125.13","grand_total":"163.26","paid_amount":"163.26","room_type_id":"306","product_id":"1223","siteminder_id":"ABB-HMAQNFPP99","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"125.13","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93353","customer_id":"93353","source_of_creation":"Airbnb","reservation_created_date":"2019-11-04 17:44:08","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"17.49","commision_charges":"3.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"125.13","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3034264","reservation_id":"86544","confirmation_number":"BP12544410844","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.49,48.49,48.49,48.49","nightly_discount":"0,0,0,0","subtotal":"193.96","grand_total":"219.18","paid_amount":"219.18","room_type_id":"299","product_id":"1134","siteminder_id":"HWR-301199683","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":"93277","customer_id":"93277","source_of_creation":"Hotwire","reservation_created_date":"2019-11-01 20:23:05","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.49","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":"3035205","reservation_id":"86693","confirmation_number":"BP12574364070","room_stay_from":"2019-11-04","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"54.75,54.75","nightly_discount":"0,0","subtotal":"109.50","grand_total":"123.74","paid_amount":"123.74","room_type_id":"301","product_id":"1136","siteminder_id":"HWR-301232864","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":"93370","customer_id":"93370","source_of_creation":"Hotwire","reservation_created_date":"2019-11-05 04:25:11","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":"54.75","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":"3035385","reservation_id":"86709","confirmation_number":"BP12532816499","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.49","nightly_discount":"0","subtotal":"48.49","grand_total":"54.79","paid_amount":"54.79","room_type_id":"293","product_id":"1124","siteminder_id":"HWR-301238552","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":"93384","customer_id":"93384","source_of_creation":"Hotwire","reservation_created_date":"2019-11-05 18:09:11","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.49","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":"3033680","reservation_id":"86472","confirmation_number":"BP12562940261","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.68,71.68,71.68,71.68","nightly_discount":"0,0,0,0","subtotal":"286.72","grand_total":"323.99","paid_amount":"323.99","room_type_id":"301","product_id":"1137","siteminder_id":"AGO-288549402","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":"93220","customer_id":"93220","source_of_creation":"Agoda","reservation_created_date":"2019-10-30 23:45:36","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.68","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":"3034597","reservation_id":"86607","confirmation_number":"PB12392467983","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.26,83.26,83.26,83.26","nightly_discount":"0,0,0,0","subtotal":"333.04","grand_total":"376.33","paid_amount":"376.33","room_type_id":"291","product_id":"1115","siteminder_id":"AGO-289123042","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":"93307","customer_id":"93307","source_of_creation":"Agoda","reservation_created_date":"2019-11-02 22:59:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"83.26","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035183","reservation_id":"86685","confirmation_number":"PB12381410530","room_stay_from":"2019-11-04","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.14,73.14","nightly_discount":"0,0","subtotal":"146.28","grand_total":"165.30","paid_amount":"165.30","room_type_id":"285","product_id":"1084","siteminder_id":"AGO-289490410","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":"93363","customer_id":"93363","source_of_creation":"Agoda","reservation_created_date":"2019-11-04 22:48:11","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":"73.14","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3000885","reservation_id":"81098","confirmation_number":"PB12372965350","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"416.00","grand_total":"470.08","paid_amount":"470.08","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"73566","customer_id":"73566","source_of_creation":"FE","reservation_created_date":"2019-07-20 17:34:52","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3014089","reservation_id":"83247","confirmation_number":"BV12477870814","room_stay_from":"2019-11-03","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.96,102.96,102.96,102.96,102.96,130.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"645.20","grand_total":"729.07","paid_amount":"729.07","room_type_id":"305","product_id":"1222","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90636","customer_id":"90636","source_of_creation":"FE","reservation_created_date":"2019-08-26 17:51:04","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"102.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017920","reservation_id":"83854","confirmation_number":"BV12458745500","room_stay_from":"2019-11-04","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.68,67.68,67.68","nightly_discount":"0.00,0.00,0.00","subtotal":"203.04","grand_total":"229.43","paid_amount":"229.43","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":"91183","customer_id":"91183","source_of_creation":"FE","reservation_created_date":"2019-09-09 21:07:28","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034304","reservation_id":"86551","confirmation_number":"BP12534754244","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"64.30,64.30,64.30","nightly_discount":"0.00,0.00,0.00","subtotal":"192.90","grand_total":"217.97","paid_amount":"217.97","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"FE","reservation_created_date":"2019-11-01 22:30:58","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"64.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034501","reservation_id":"84549","confirmation_number":"PB12325384614","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.60,129.60,129.60,129.60","nightly_discount":"21.84,0.00,0.00,0.00","subtotal":"534.40","grand_total":"579.19","paid_amount":"579.19","room_type_id":"288","product_id":"1091","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84601","customer_id":"84601","source_of_creation":"FE","reservation_created_date":"2019-09-22 23:18:22","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035468","reservation_id":"86722","confirmation_number":"BP12528988627","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.87","nightly_discount":"0.00","subtotal":"73.87","grand_total":"83.47","paid_amount":"83.47","room_type_id":"295","product_id":"1128","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":"93395","customer_id":"93395","source_of_creation":"FE","reservation_created_date":"2019-11-05 22:30:56","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":"73.87","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035375","reservation_id":"84177","confirmation_number":"BV12458733513","room_stay_from":"2019-11-07","room_stay_to":"2019-11-10","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"105.00,139.20,139.20","nightly_discount":"0.00,0.00,0.00","subtotal":"383.40","grand_total":"433.24","paid_amount":"433.24","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":"91670","customer_id":"91670","source_of_creation":"FE","reservation_created_date":"2019-09-16 01:06:34","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":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3007979","reservation_id":"82189","confirmation_number":"PB12368226074","room_stay_from":"2019-10-29","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00,110.00,110.00,95.00,95.00,95.00,95.00,95.00,110.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1090.00","grand_total":"1231.70","paid_amount":"1231.70","room_type_id":"289","product_id":"1109","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89930","customer_id":"89930","source_of_creation":"PMS","reservation_created_date":"2019-08-07 18:22:47","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3033212","reservation_id":"84318","confirmation_number":"PB12392575211","room_stay_from":"2019-10-28","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,96.00,96.00,112.00,112.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,51.73,0.00","subtotal":"896.00","grand_total":"954.03","paid_amount":"954.03","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79718","customer_id":"79718","source_of_creation":"PMS","reservation_created_date":"2019-09-18 16:58:00","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.00","currentDayDiscount":"51.73","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034298","reservation_id":"84357","confirmation_number":"PB12372913252","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.80,100.80,86.40,86.40,86.40,86.40,86.40","nightly_discount":"27.34,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"633.60","grand_total":"685.08","paid_amount":"685.08","room_type_id":"289","product_id":"1111","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91826","customer_id":"91826","source_of_creation":"PMS","reservation_created_date":"2019-09-19 17:46:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"86.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034302","reservation_id":"84333","confirmation_number":"PB12340155718","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,20.22,0.00","subtotal":"384.00","grand_total":"411.07","paid_amount":"411.08","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"42262","customer_id":"42262","source_of_creation":"PMS","reservation_created_date":"2019-09-18 22:06:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3034332","reservation_id":"84629","confirmation_number":"PB12330616079","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.80,100.80,86.40,86.40,86.40,86.40,86.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"633.60","grand_total":"715.97","paid_amount":"715.97","room_type_id":"289","product_id":"1107","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"28906","customer_id":"28906","source_of_creation":"PMS","reservation_created_date":"2019-09-24 00:40:48","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"86.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034545","reservation_id":"59728","confirmation_number":"PB12384017809","room_stay_from":"2019-11-02","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.00,186.00,186.00,186.00,186.00,186.00,186.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,67.80,0.00","subtotal":"1302.00","grand_total":"1394.64","paid_amount":"1394.64","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23074","customer_id":"23074","source_of_creation":"PMS","reservation_created_date":"2018-11-06 17:38:58","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"186.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034711","reservation_id":"86625","confirmation_number":"PB12328053039","room_stay_from":"2019-11-04","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.00,93.00","nightly_discount":"0.00,0.00","subtotal":"186.00","grand_total":"210.18","paid_amount":"210.18","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":"93317","customer_id":"93317","source_of_creation":"PMS","reservation_created_date":"2019-11-03 14:32:43","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":"93.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034749","reservation_id":"60182","confirmation_number":"PB12322310478","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,56.12,0.00","subtotal":"1260.00","grand_total":"1360.38","paid_amount":"1360.38","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24409","customer_id":"24409","source_of_creation":"PMS","reservation_created_date":"2018-11-12 13:10:42","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034753","reservation_id":"60182","confirmation_number":"PB12333050365","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,56.12,0.00","subtotal":"1260.00","grand_total":"1360.38","paid_amount":"1360.38","room_type_id":"289","product_id":"1121","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24409","customer_id":"24409","source_of_creation":"PMS","reservation_created_date":"2018-11-12 13:10:42","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034769","reservation_id":"82379","confirmation_number":"PB12355235886","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00,104.00","nightly_discount":"23.80,0.00,0.00,0.00,0.00","subtotal":"520.00","grand_total":"560.70","paid_amount":"560.70","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90039","customer_id":"90039","source_of_creation":"PMS","reservation_created_date":"2019-08-10 02:24:58","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034932","reservation_id":"85426","confirmation_number":"PB12350544802","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,15.00,0.00","subtotal":"416.00","grand_total":"453.13","paid_amount":"453.13","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"53442","customer_id":"53442","source_of_creation":"PMS","reservation_created_date":"2019-10-10 21:26:17","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035188","reservation_id":"86641","confirmation_number":"BV12440606139","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.81,97.81,97.81","nightly_discount":"0.00,0.00,0.00","subtotal":"293.43","grand_total":"331.58","paid_amount":"331.58","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"28609","customer_id":"28609","source_of_creation":"PMS","reservation_created_date":"2019-11-03 19:37:42","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"97.81","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035398","reservation_id":"86679","confirmation_number":"PB12315745972","room_stay_from":"2019-11-04","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.40,106.40,106.40","nightly_discount":"0.00,11.84,11.84","subtotal":"319.20","grand_total":"333.94","paid_amount":"333.94","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93356","customer_id":"93356","source_of_creation":"PMS","reservation_created_date":"2019-11-04 19:03:50","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"106.40","currentDayDiscount":"11.84","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035424","reservation_id":"86712","confirmation_number":"BV12492063913","room_stay_from":"2019-11-05","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.32,84.32","nightly_discount":"0.00,9.63,0.00","subtotal":"168.64","grand_total":"179.68","paid_amount":"179.68","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":"93387","customer_id":"93387","source_of_creation":"PMS","reservation_created_date":"2019-11-05 19:35:34","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":"84.32","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035440","reservation_id":"86715","confirmation_number":"PB12361923511","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.68","nightly_discount":"0.00","subtotal":"90.68","grand_total":"102.47","paid_amount":"102.47","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"70532","customer_id":"70532","source_of_creation":"PMS","reservation_created_date":"2019-11-05 20:45:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.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":"3035506","reservation_id":"60846","confirmation_number":"PB12379701223","room_stay_from":"2019-11-05","room_stay_to":"2019-11-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,11.77,110.00","subtotal":"2530.00","grand_total":"2721.30","paid_amount":"2721.30","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":"34353","customer_id":"34353","source_of_creation":"PMS","reservation_created_date":"2018-11-21 14:57:31","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":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035787","reservation_id":"86708","confirmation_number":"PB12334623093","room_stay_from":"2019-11-05","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"106.40,106.40,106.40","nightly_discount":"0.00,0.00,0.00","subtotal":"319.20","grand_total":"360.69","paid_amount":"360.69","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":"93383","customer_id":"93383","source_of_creation":"PMS","reservation_created_date":"2019-11-05 17:31:32","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":"106.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3036701","reservation_id":"86056","confirmation_number":"BP12535044277","room_stay_from":"2019-11-04","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.86,99.86,99.86,99.86,132.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"532.24","grand_total":"601.43","paid_amount":"601.43","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":"92927","customer_id":"92927","source_of_creation":"PMS","reservation_created_date":"2019-10-21 19:41:54","canceled_nights_data":"","product_name":"BP Waterfront 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.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3037089","reservation_id":"85344","confirmation_number":"BV12420476697","room_stay_from":"2019-11-04","room_stay_to":"2019-11-10","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"594.00","grand_total":"671.22","paid_amount":"671.22","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":"38460","customer_id":"38460","source_of_creation":"PMS","reservation_created_date":"2019-10-09 14:20:02","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":"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":"3038029","reservation_id":"81546","confirmation_number":"PB12358891924","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.43,87.43,87.43,87.43,87.43","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"437.15","grand_total":"493.98","paid_amount":"493.98","room_type_id":"287","product_id":"1090","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89446","customer_id":"89446","source_of_creation":"PMS","reservation_created_date":"2019-11-02 21:42:25","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"87.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038111","reservation_id":"84835","confirmation_number":"PB12368624323","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.80,69.80,69.80,69.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"279.20","grand_total":"315.49","paid_amount":"315.49","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88639","customer_id":"88639","source_of_creation":"PMS","reservation_created_date":"2019-09-28 23:26:38","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038708","reservation_id":"59963","confirmation_number":"PB12369148316","room_stay_from":"2019-10-29","room_stay_to":"2019-11-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00","nightly_discount":"70.76,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1836.00","grand_total":"1994.72","paid_amount":"1890.92","room_type_id":"289","product_id":"1098","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"44768","customer_id":"44768","source_of_creation":"PMS","reservation_created_date":"2018-11-09 16:27:42","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"108.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3039958","reservation_id":"60458","confirmation_number":"PB12394331741","room_stay_from":"2019-11-04","room_stay_to":"2019-11-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.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,133.60,0.00","subtotal":"2826.00","grand_total":"3042.41","paid_amount":"3042.41","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":"23636","customer_id":"23636","source_of_creation":"PMS","reservation_created_date":"2018-11-16 14:56:54","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":"157.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3041260","reservation_id":"83371","confirmation_number":"BP12598404732","room_stay_from":"2019-11-05","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.73,53.73,53.75,65.85","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"227.06","grand_total":"256.57","paid_amount":"256.57","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":"90728","customer_id":"90728","source_of_creation":"PMS","reservation_created_date":"2019-08-29 00:11:20","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":"","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":"3044301","reservation_id":"61846","confirmation_number":"PB12391957014","room_stay_from":"2019-10-28","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00","nightly_discount":"79.80,79.80,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,83.00,83.00,83.00,83.00,83.00","subtotal":"3705.00","grand_total":"3537.35","paid_amount":"3537.35","room_type_id":"289","product_id":"1101","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23454","customer_id":"23454","source_of_creation":"PMS","reservation_created_date":"2018-11-30 00:04:47","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083019","reservation_id":"86706","confirmation_number":"BV12446866867","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.34","nightly_discount":"0.00","subtotal":"105.34","grand_total":"119.03","paid_amount":"119.03","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":"95379","customer_id":"95379","source_of_creation":"PMS","reservation_created_date":"2019-11-05 16:35:33","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3007513","reservation_id":"82091","confirmation_number":"BV12244575200","room_confirmation_number":"BV12472328627","room_stay_from":"2019-11-01","room_stay_to":"2019-11-17","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"89847","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-08-05 20:53:09","reservation_modified_date_time":"2019-08-05 20:53:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89847","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035382","reservation_id":"82103","confirmation_number":"PB12288098951","room_confirmation_number":"PB12361850225","room_stay_from":"2019-11-05","room_stay_to":"2019-11-07","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"89855","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-11-05 17:07:06","reservation_modified_date_time":"2019-11-05 18:06:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89855","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":"3035788","reservation_id":"86708","confirmation_number":"PB12231049800","room_confirmation_number":"PB12334623093","room_stay_from":"2019-11-05","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"93383","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-11-06 17:58:30","reservation_modified_date_time":"2019-11-06 17:58:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93383","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2987882","reservation_id":"78663","confirmation_number":"PB12244182977","room_confirmation_number":"PB12329320660","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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":"87669","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-14 04:43:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87669","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3000886","reservation_id":"81098","confirmation_number":"PB12283505400","room_confirmation_number":"PB12372965350","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"73566","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-20 17:34:52","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73566","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007514","reservation_id":"82091","confirmation_number":"BV12241348721","room_confirmation_number":"BV12472328627","room_stay_from":"2019-11-01","room_stay_to":"2019-11-17","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"320.00","grand_total":"361.60","paid_amount":"361.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"89847","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-05 20:53:09","reservation_modified_date_time":"2019-08-05 20:53:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89847","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007980","reservation_id":"82189","confirmation_number":"PB12237113864","room_confirmation_number":"PB12368226074","room_stay_from":"2019-10-29","room_stay_to":"2019-11-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,12.00","subtotal":"132.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"89930","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-07 18:22:47","reservation_modified_date_time":"2019-08-07 18:24:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89930","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3014090","reservation_id":"83247","confirmation_number":"BV12212345943","room_confirmation_number":"BV12477870814","room_stay_from":"2019-11-03","room_stay_to":"2019-11-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"90636","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-26 17:51:04","reservation_modified_date_time":"2019-08-26 17:51:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90636","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017921","reservation_id":"83854","confirmation_number":"BV12226378982","room_confirmation_number":"BV12458745500","room_stay_from":"2019-11-04","room_stay_to":"2019-11-07","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":"91183","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-09 21:07:28","reservation_modified_date_time":"2019-09-09 21:07:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91183","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":"3032421","reservation_id":"86220","confirmation_number":"PB12255182534","room_confirmation_number":"PB12343271685","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","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":"93052","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-25 17:16:10","reservation_modified_date_time":"2019-10-25 17:16:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93052","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3033213","reservation_id":"84318","confirmation_number":"PB12265162018","room_confirmation_number":"PB12392575211","room_stay_from":"2019-10-28","room_stay_to":"2019-11-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"79718","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-18 16:58:00","reservation_modified_date_time":"2019-10-28 18:07:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79718","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3033681","reservation_id":"86472","confirmation_number":"BP12247799984","room_confirmation_number":"BP12562940261","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","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":"93220","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-30 23:45:36","reservation_modified_date_time":"2019-10-30 23:45:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93220","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":"3033974","reservation_id":"86514","confirmation_number":"BP12298549506","room_confirmation_number":"BP12550755154","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","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":"93253","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-01 00:49:09","reservation_modified_date_time":"2019-11-01 00:49:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93253","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":"3034265","reservation_id":"86544","confirmation_number":"BP12267381566","room_confirmation_number":"BP12544410844","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","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":"93277","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-01 20:23:05","reservation_modified_date_time":"2019-11-01 20:23:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93277","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034299","reservation_id":"84357","confirmation_number":"PB12248771278","room_confirmation_number":"PB12372913252","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"91826","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 17:46:28","reservation_modified_date_time":"2019-11-01 22:01:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91826","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034303","reservation_id":"84333","confirmation_number":"PB12210916344","room_confirmation_number":"PB12340155718","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"42262","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-18 22:06:08","reservation_modified_date_time":"2019-11-01 22:13:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42262","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034305","reservation_id":"86551","confirmation_number":"BP12230612644","room_confirmation_number":"BP12534754244","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"47798","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-01 22:30:58","reservation_modified_date_time":"2019-11-01 22:30:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034333","reservation_id":"84629","confirmation_number":"PB12240305719","room_confirmation_number":"PB12330616079","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"28906","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-24 00:40:48","reservation_modified_date_time":"2019-11-01 23:16:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28906","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034502","reservation_id":"84549","confirmation_number":"PB12218701260","room_confirmation_number":"PB12325384614","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"84601","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-22 23:18:22","reservation_modified_date_time":"2019-11-02 18:32:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84601","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034546","reservation_id":"59728","confirmation_number":"PBR12212069506","room_confirmation_number":"PB12384017809","room_stay_from":"2019-11-02","room_stay_to":"2019-11-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"23074","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"2019-11-02 21:07:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23074","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034598","reservation_id":"86607","confirmation_number":"PB12268338262","room_confirmation_number":"PB12392467983","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","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":"93307","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-02 22:59:09","reservation_modified_date_time":"2019-11-02 22:59:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93307","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":"3034712","reservation_id":"86625","confirmation_number":"PB12214053018","room_confirmation_number":"PB12328053039","room_stay_from":"2019-11-04","room_stay_to":"2019-11-06","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":"93317","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-03 14:32:43","reservation_modified_date_time":"2019-11-03 14:32:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93317","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034750","reservation_id":"60182","confirmation_number":"PB12338198280","room_confirmation_number":"PB12322310478","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24409","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-12 13:10:42","reservation_modified_date_time":"2019-11-03 16:21:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24409","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034754","reservation_id":"60182","confirmation_number":"PB12396722311","room_confirmation_number":"PB12333050365","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24409","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-12 13:10:42","reservation_modified_date_time":"2019-11-03 16:21:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24409","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034770","reservation_id":"82379","confirmation_number":"PB12292144731","room_confirmation_number":"PB12355235886","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"90039","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-10 02:24:58","reservation_modified_date_time":"2019-11-03 16:54:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90039","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034933","reservation_id":"85426","confirmation_number":"PB12222555534","room_confirmation_number":"PB12350544802","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"53442","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-10 21:26:17","reservation_modified_date_time":"2019-11-03 22:43:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53442","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034959","reservation_id":"86655","confirmation_number":"BP12295020197","room_confirmation_number":"BP12593896102","room_stay_from":"2019-11-04","room_stay_to":"2019-11-07","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":"93337","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-04 01:15:06","reservation_modified_date_time":"2019-11-04 01:15:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93337","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":"3035098","reservation_id":"86675","confirmation_number":"BV12290707902","room_confirmation_number":"BV12462634784","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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":"93353","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-04 17:44:08","reservation_modified_date_time":"2019-11-04 17:44:08","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93353","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3035184","reservation_id":"86685","confirmation_number":"PB12249892290","room_confirmation_number":"PB12381410530","room_stay_from":"2019-11-04","room_stay_to":"2019-11-06","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":"93363","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-04 22:48:11","reservation_modified_date_time":"2019-11-04 22:48:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93363","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035189","reservation_id":"86641","confirmation_number":"BV12293985091","room_confirmation_number":"BV12440606139","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"28609","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-03 19:37:42","reservation_modified_date_time":"2019-11-03 19:37:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28609","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035206","reservation_id":"86693","confirmation_number":"BP12287635360","room_confirmation_number":"BP12574364070","room_stay_from":"2019-11-04","room_stay_to":"2019-11-06","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":"93370","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-05 04:25:11","reservation_modified_date_time":"2019-11-05 04:25:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93370","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":"3035381","reservation_id":"82103","confirmation_number":"PB12255297284","room_confirmation_number":"PB12361850225","room_stay_from":"2019-11-05","room_stay_to":"2019-11-07","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":"89855","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-05 23:57:09","reservation_modified_date_time":"2019-11-05 18:06:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89855","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":"3035386","reservation_id":"86709","confirmation_number":"BP12279278540","room_confirmation_number":"BP12532816499","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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":"93384","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-05 18:09:11","reservation_modified_date_time":"2019-11-05 18:09:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93384","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":"3035399","reservation_id":"86679","confirmation_number":"PB12226547153","room_confirmation_number":"PB12315745972","room_stay_from":"2019-11-04","room_stay_to":"2019-11-07","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":"93356","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-04 19:03:50","reservation_modified_date_time":"2019-11-04 19:03:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93356","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":"3035425","reservation_id":"86712","confirmation_number":"BV12224057844","room_confirmation_number":"BV12492063913","room_stay_from":"2019-11-05","room_stay_to":"2019-11-07","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":"93387","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-05 19:35:34","reservation_modified_date_time":"2019-11-05 19:41:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93387","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":"3035441","reservation_id":"86715","confirmation_number":"PB12234412908","room_confirmation_number":"PB12361923511","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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":"70532","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-05 20:45:12","reservation_modified_date_time":"2019-11-05 20:45:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70532","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035454","reservation_id":"85325","confirmation_number":"PB12264627481","room_confirmation_number":"PB12390510045","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"92484","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-08 23:56:07","reservation_modified_date_time":"2019-10-08 23:56:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92484","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035469","reservation_id":"86722","confirmation_number":"BP12253209375","room_confirmation_number":"BP12528988627","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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":"93395","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-05 22:30:56","reservation_modified_date_time":"2019-11-05 22:30:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93395","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":"3035507","reservation_id":"60846","confirmation_number":"PB12336082603","room_confirmation_number":"PB12379701223","room_stay_from":"2019-11-05","room_stay_to":"2019-11-28","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"34353","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-21 14:57:31","reservation_modified_date_time":"2019-11-06 02:17:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"34353","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":"3035749","reservation_id":"82102","confirmation_number":"BV12277920868","room_confirmation_number":"BV12422682618","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89857","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-05 23:57:08","reservation_modified_date_time":"2019-11-06 16:22:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89857","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":"3035789","reservation_id":"86708","confirmation_number":"PB12296808859","room_confirmation_number":"PB12334623093","room_stay_from":"2019-11-05","room_stay_to":"2019-11-08","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":"93383","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-05 17:31:32","reservation_modified_date_time":"2019-11-05 17:31:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93383","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":"3036702","reservation_id":"86056","confirmation_number":"BP12221831857","room_confirmation_number":"BP12535044277","room_stay_from":"2019-11-04","room_stay_to":"2019-11-09","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"92927","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-21 19:41:54","reservation_modified_date_time":"2019-11-09 16:03:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92927","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":"3037090","reservation_id":"85344","confirmation_number":"BV12229738076","room_confirmation_number":"BV12420476697","room_stay_from":"2019-11-04","room_stay_to":"2019-11-10","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":"38460","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-09 14:20:02","reservation_modified_date_time":"2019-11-10 23:07:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"38460","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":"3038030","reservation_id":"81546","confirmation_number":"PB12275099579","room_confirmation_number":"PB12358891924","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89446","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-02 21:42:25","reservation_modified_date_time":"2019-11-13 21:12:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89446","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038112","reservation_id":"84835","confirmation_number":"PB12242529699","room_confirmation_number":"PB12368624323","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"88639","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-28 23:26:38","reservation_modified_date_time":"2019-11-13 21:43:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88639","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038709","reservation_id":"59963","confirmation_number":"PBR12285185099","room_confirmation_number":"PB12369148316","room_stay_from":"2019-10-29","room_stay_to":"2019-11-15","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"44768","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"2019-11-15 01:33:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44768","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3039959","reservation_id":"60458","confirmation_number":"PB12339654416","room_confirmation_number":"PB12394331741","room_stay_from":"2019-11-04","room_stay_to":"2019-11-22","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":"23636","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-16 21:18:07","reservation_modified_date_time":"2019-11-20 15:00:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23636","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":"3041261","reservation_id":"83371","confirmation_number":"BP12237108034","room_confirmation_number":"BP12598404732","room_stay_from":"2019-11-05","room_stay_to":"2019-11-09","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"90728","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-29 00:11:20","reservation_modified_date_time":"2019-11-24 23:16:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90728","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3044302","reservation_id":"61846","confirmation_number":"PB12312856665","room_confirmation_number":"PB12391957014","room_stay_from":"2019-10-28","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23454","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-30 00:04:47","reservation_modified_date_time":"2019-12-05 15:30:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23454","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083018","reservation_id":"86706","confirmation_number":"BV12261622689","room_confirmation_number":"BV12446866867","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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":"95379","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-05 16:35:33","reservation_modified_date_time":"2020-03-17 15:12:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95379","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3034960","reservation_id":"86655","confirmation_number":"BP12297966014","room_confirmation_number":"BP12593896102","room_stay_from":"2019-11-04","room_stay_to":"2019-11-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.75","paid_amount":"84.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-11-04 01:21:20","reservation_modified_date_time":"2019-11-04 01:21:20","customer_id":"93337","parentCustTravId":"93337","customer_traveller_id":"93337","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":"3035456","reservation_id":"85325","confirmation_number":"PB12273449457","room_confirmation_number":"PB12390510045","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1141","service_quantity":"2","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2019-11-05 21:34:01","reservation_modified_date_time":"2019-11-05 21:34:01","customer_id":"92484","parentCustTravId":"92484","customer_traveller_id":"92484","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":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3035457","reservation_id":"86675","confirmation_number":"BV12293948976","room_confirmation_number":"BV12462634784","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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-11-05 21:51:11","reservation_modified_date_time":"2019-11-05 21:51:11","customer_id":"93353","parentCustTravId":"93353","customer_traveller_id":"93353","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":"3035458","reservation_id":"86675","confirmation_number":"BV12280674275","room_confirmation_number":"BV12462634784","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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-11-05 21:51:35","reservation_modified_date_time":"2019-11-05 21:51:35","customer_id":"93353","parentCustTravId":"93353","customer_traveller_id":"93353","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":"3034522","reservation_id":"86574","confirmation_number":"BP12238960117","room_confirmation_number":"BP12542559543","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":"22.60","paid_amount":"0.00","product_id":"1192","service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-11-02 19:39:15","reservation_modified_date_time":"2019-11-02 19:39:15","customer_id":"93288","parentCustTravId":"93288","customer_traveller_id":"93288","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-11-05 14:56:45","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-20,"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":[]},"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":3,"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":"3035453","reservation_id":"85325","confirmation_number":"PB12390510045","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.27,113.83,113.83,113.83","nightly_discount":"0,0,0,0","subtotal":"466.76","grand_total":"527.44","paid_amount":"527.44","room_type_id":"289","product_id":"1104","siteminder_id":"BDC-2129342521","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92484","customer_id":"92484","source_of_creation":"Booking.com","reservation_created_date":"2019-10-08 23:56:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"70.01","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3032420","reservation_id":"86220","confirmation_number":"PB12343271685","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"84.01,84.01,84.01,84.01","nightly_discount":"0,0,0,0","subtotal":"336.04","grand_total":"379.72","paid_amount":"379.72","room_type_id":"289","product_id":"1094","siteminder_id":"EXP-1368498663","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":"93052","customer_id":"93052","source_of_creation":"Expedia","reservation_created_date":"2019-10-25 17:16:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"84.01","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035380","reservation_id":"82103","confirmation_number":"PB12361850225","room_stay_from":"2019-11-05","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"93.34,93.34","nightly_discount":"0.00,0.00","subtotal":"186.68","grand_total":"210.95","paid_amount":"210.95","room_type_id":"289","product_id":"1106","siteminder_id":"EXP-1315801232","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":"89855","customer_id":"89855","source_of_creation":"Expedia","reservation_created_date":"2019-08-05 23:57:09","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":"93.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"2987881","reservation_id":"78663","confirmation_number":"PB12329320660","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"61.66","nightly_discount":"0","subtotal":"61.66","grand_total":"69.68","paid_amount":"69.68","room_type_id":"290","product_id":"1113","siteminder_id":"GAM-R1537098530","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":"87669","customer_id":"87669","source_of_creation":"Getaroom.com","reservation_created_date":"2019-06-14 04:43:05","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":"61.66","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_non_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3034597","reservation_id":"86607","confirmation_number":"PB12392467983","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.26,83.26,83.26,83.26","nightly_discount":"0,0,0,0","subtotal":"333.04","grand_total":"376.33","paid_amount":"376.33","room_type_id":"291","product_id":"1115","siteminder_id":"AGO-289123042","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":"93307","customer_id":"93307","source_of_creation":"Agoda","reservation_created_date":"2019-11-02 22:59:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"83.26","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035183","reservation_id":"86685","confirmation_number":"PB12381410530","room_stay_from":"2019-11-04","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.14,73.14","nightly_discount":"0,0","subtotal":"146.28","grand_total":"165.30","paid_amount":"165.30","room_type_id":"285","product_id":"1084","siteminder_id":"AGO-289490410","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":"93363","customer_id":"93363","source_of_creation":"Agoda","reservation_created_date":"2019-11-04 22:48:11","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":"73.14","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3000885","reservation_id":"81098","confirmation_number":"PB12372965350","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"416.00","grand_total":"470.08","paid_amount":"470.08","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"73566","customer_id":"73566","source_of_creation":"FE","reservation_created_date":"2019-07-20 17:34:52","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034501","reservation_id":"84549","confirmation_number":"PB12325384614","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.60,129.60,129.60,129.60","nightly_discount":"21.84,0.00,0.00,0.00","subtotal":"534.40","grand_total":"579.19","paid_amount":"579.19","room_type_id":"288","product_id":"1091","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84601","customer_id":"84601","source_of_creation":"FE","reservation_created_date":"2019-09-22 23:18:22","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3007979","reservation_id":"82189","confirmation_number":"PB12368226074","room_stay_from":"2019-10-29","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00,110.00,110.00,95.00,95.00,95.00,95.00,95.00,110.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1090.00","grand_total":"1231.70","paid_amount":"1231.70","room_type_id":"289","product_id":"1109","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89930","customer_id":"89930","source_of_creation":"PMS","reservation_created_date":"2019-08-07 18:22:47","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3033212","reservation_id":"84318","confirmation_number":"PB12392575211","room_stay_from":"2019-10-28","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.00,96.00,96.00,96.00,112.00,112.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,51.73,0.00","subtotal":"896.00","grand_total":"954.03","paid_amount":"954.03","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79718","customer_id":"79718","source_of_creation":"PMS","reservation_created_date":"2019-09-18 16:58:00","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.00","currentDayDiscount":"51.73","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034298","reservation_id":"84357","confirmation_number":"PB12372913252","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.80,100.80,86.40,86.40,86.40,86.40,86.40","nightly_discount":"27.34,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"633.60","grand_total":"685.08","paid_amount":"685.08","room_type_id":"289","product_id":"1111","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91826","customer_id":"91826","source_of_creation":"PMS","reservation_created_date":"2019-09-19 17:46:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"86.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034302","reservation_id":"84333","confirmation_number":"PB12340155718","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,96.00,96.00,96.00,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,20.22,0.00","subtotal":"384.00","grand_total":"411.07","paid_amount":"411.08","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"42262","customer_id":"42262","source_of_creation":"PMS","reservation_created_date":"2019-09-18 22:06:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3034332","reservation_id":"84629","confirmation_number":"PB12330616079","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.80,100.80,86.40,86.40,86.40,86.40,86.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"633.60","grand_total":"715.97","paid_amount":"715.97","room_type_id":"289","product_id":"1107","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"28906","customer_id":"28906","source_of_creation":"PMS","reservation_created_date":"2019-09-24 00:40:48","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"86.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034545","reservation_id":"59728","confirmation_number":"PB12384017809","room_stay_from":"2019-11-02","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.00,186.00,186.00,186.00,186.00,186.00,186.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,67.80,0.00","subtotal":"1302.00","grand_total":"1394.64","paid_amount":"1394.64","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23074","customer_id":"23074","source_of_creation":"PMS","reservation_created_date":"2018-11-06 17:38:58","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"186.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034711","reservation_id":"86625","confirmation_number":"PB12328053039","room_stay_from":"2019-11-04","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.00,93.00","nightly_discount":"0.00,0.00","subtotal":"186.00","grand_total":"210.18","paid_amount":"210.18","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":"93317","customer_id":"93317","source_of_creation":"PMS","reservation_created_date":"2019-11-03 14:32:43","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":"93.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034749","reservation_id":"60182","confirmation_number":"PB12322310478","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,56.12,0.00","subtotal":"1260.00","grand_total":"1360.38","paid_amount":"1360.38","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24409","customer_id":"24409","source_of_creation":"PMS","reservation_created_date":"2018-11-12 13:10:42","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034753","reservation_id":"60182","confirmation_number":"PB12333050365","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00,126.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,56.12,0.00","subtotal":"1260.00","grand_total":"1360.38","paid_amount":"1360.38","room_type_id":"289","product_id":"1121","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24409","customer_id":"24409","source_of_creation":"PMS","reservation_created_date":"2018-11-12 13:10:42","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034769","reservation_id":"82379","confirmation_number":"PB12355235886","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00,104.00","nightly_discount":"23.80,0.00,0.00,0.00,0.00","subtotal":"520.00","grand_total":"560.70","paid_amount":"560.70","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90039","customer_id":"90039","source_of_creation":"PMS","reservation_created_date":"2019-08-10 02:24:58","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034932","reservation_id":"85426","confirmation_number":"PB12350544802","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,15.00,0.00","subtotal":"416.00","grand_total":"453.13","paid_amount":"453.13","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"53442","customer_id":"53442","source_of_creation":"PMS","reservation_created_date":"2019-10-10 21:26:17","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035398","reservation_id":"86679","confirmation_number":"PB12315745972","room_stay_from":"2019-11-04","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.40,106.40,106.40","nightly_discount":"0.00,11.84,11.84","subtotal":"319.20","grand_total":"333.94","paid_amount":"333.94","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93356","customer_id":"93356","source_of_creation":"PMS","reservation_created_date":"2019-11-04 19:03:50","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"106.40","currentDayDiscount":"11.84","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035440","reservation_id":"86715","confirmation_number":"PB12361923511","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.68","nightly_discount":"0.00","subtotal":"90.68","grand_total":"102.47","paid_amount":"102.47","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"70532","customer_id":"70532","source_of_creation":"PMS","reservation_created_date":"2019-11-05 20:45:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.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":"3035506","reservation_id":"60846","confirmation_number":"PB12379701223","room_stay_from":"2019-11-05","room_stay_to":"2019-11-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,11.77,110.00","subtotal":"2530.00","grand_total":"2721.30","paid_amount":"2721.30","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":"34353","customer_id":"34353","source_of_creation":"PMS","reservation_created_date":"2018-11-21 14:57:31","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":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035787","reservation_id":"86708","confirmation_number":"PB12334623093","room_stay_from":"2019-11-05","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"106.40,106.40,106.40","nightly_discount":"0.00,0.00,0.00","subtotal":"319.20","grand_total":"360.69","paid_amount":"360.69","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":"93383","customer_id":"93383","source_of_creation":"PMS","reservation_created_date":"2019-11-05 17:31:32","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":"106.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038029","reservation_id":"81546","confirmation_number":"PB12358891924","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.43,87.43,87.43,87.43,87.43","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"437.15","grand_total":"493.98","paid_amount":"493.98","room_type_id":"287","product_id":"1090","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89446","customer_id":"89446","source_of_creation":"PMS","reservation_created_date":"2019-11-02 21:42:25","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"87.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038111","reservation_id":"84835","confirmation_number":"PB12368624323","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.80,69.80,69.80,69.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"279.20","grand_total":"315.49","paid_amount":"315.49","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88639","customer_id":"88639","source_of_creation":"PMS","reservation_created_date":"2019-09-28 23:26:38","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038708","reservation_id":"59963","confirmation_number":"PB12369148316","room_stay_from":"2019-10-29","room_stay_to":"2019-11-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00,108.00","nightly_discount":"70.76,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1836.00","grand_total":"1994.72","paid_amount":"1890.92","room_type_id":"289","product_id":"1098","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"44768","customer_id":"44768","source_of_creation":"PMS","reservation_created_date":"2018-11-09 16:27:42","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"108.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3039958","reservation_id":"60458","confirmation_number":"PB12394331741","room_stay_from":"2019-11-04","room_stay_to":"2019-11-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.00,157.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,133.60,0.00","subtotal":"2826.00","grand_total":"3042.41","paid_amount":"3042.41","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":"23636","customer_id":"23636","source_of_creation":"PMS","reservation_created_date":"2018-11-16 14:56:54","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":"157.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3044301","reservation_id":"61846","confirmation_number":"PB12391957014","room_stay_from":"2019-10-28","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00","nightly_discount":"79.80,79.80,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,83.00,83.00,83.00,83.00,83.00","subtotal":"3705.00","grand_total":"3537.35","paid_amount":"3537.35","room_type_id":"289","product_id":"1101","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23454","customer_id":"23454","source_of_creation":"PMS","reservation_created_date":"2018-11-30 00:04:47","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3035382","reservation_id":"82103","confirmation_number":"PB12288098951","room_confirmation_number":"PB12361850225","room_stay_from":"2019-11-05","room_stay_to":"2019-11-07","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"89855","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-11-05 17:07:06","reservation_modified_date_time":"2019-11-05 18:06:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89855","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":"3035788","reservation_id":"86708","confirmation_number":"PB12231049800","room_confirmation_number":"PB12334623093","room_stay_from":"2019-11-05","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"93383","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-11-06 17:58:30","reservation_modified_date_time":"2019-11-06 17:58:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93383","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2987882","reservation_id":"78663","confirmation_number":"PB12244182977","room_confirmation_number":"PB12329320660","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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":"87669","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-14 04:43:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87669","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3000886","reservation_id":"81098","confirmation_number":"PB12283505400","room_confirmation_number":"PB12372965350","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"73566","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-20 17:34:52","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73566","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3007980","reservation_id":"82189","confirmation_number":"PB12237113864","room_confirmation_number":"PB12368226074","room_stay_from":"2019-10-29","room_stay_to":"2019-11-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,12.00","subtotal":"132.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"89930","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-07 18:22:47","reservation_modified_date_time":"2019-08-07 18:24:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89930","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3032421","reservation_id":"86220","confirmation_number":"PB12255182534","room_confirmation_number":"PB12343271685","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","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":"93052","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-25 17:16:10","reservation_modified_date_time":"2019-10-25 17:16:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93052","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3033213","reservation_id":"84318","confirmation_number":"PB12265162018","room_confirmation_number":"PB12392575211","room_stay_from":"2019-10-28","room_stay_to":"2019-11-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"79718","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-18 16:58:00","reservation_modified_date_time":"2019-10-28 18:07:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79718","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034299","reservation_id":"84357","confirmation_number":"PB12248771278","room_confirmation_number":"PB12372913252","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"91826","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-19 17:46:28","reservation_modified_date_time":"2019-11-01 22:01:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91826","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034303","reservation_id":"84333","confirmation_number":"PB12210916344","room_confirmation_number":"PB12340155718","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"42262","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-18 22:06:08","reservation_modified_date_time":"2019-11-01 22:13:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42262","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034333","reservation_id":"84629","confirmation_number":"PB12240305719","room_confirmation_number":"PB12330616079","room_stay_from":"2019-11-01","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"28906","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-24 00:40:48","reservation_modified_date_time":"2019-11-01 23:16:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28906","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034502","reservation_id":"84549","confirmation_number":"PB12218701260","room_confirmation_number":"PB12325384614","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"84601","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-22 23:18:22","reservation_modified_date_time":"2019-11-02 18:32:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84601","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034546","reservation_id":"59728","confirmation_number":"PBR12212069506","room_confirmation_number":"PB12384017809","room_stay_from":"2019-11-02","room_stay_to":"2019-11-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"23074","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"2019-11-02 21:07:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23074","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034598","reservation_id":"86607","confirmation_number":"PB12268338262","room_confirmation_number":"PB12392467983","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","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":"93307","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-02 22:59:09","reservation_modified_date_time":"2019-11-02 22:59:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93307","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":"3034712","reservation_id":"86625","confirmation_number":"PB12214053018","room_confirmation_number":"PB12328053039","room_stay_from":"2019-11-04","room_stay_to":"2019-11-06","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":"93317","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-03 14:32:43","reservation_modified_date_time":"2019-11-03 14:32:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93317","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034750","reservation_id":"60182","confirmation_number":"PB12338198280","room_confirmation_number":"PB12322310478","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24409","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-12 13:10:42","reservation_modified_date_time":"2019-11-03 16:21:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24409","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034754","reservation_id":"60182","confirmation_number":"PB12396722311","room_confirmation_number":"PB12333050365","room_stay_from":"2019-11-03","room_stay_to":"2019-11-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24409","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-12 13:10:42","reservation_modified_date_time":"2019-11-03 16:21:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24409","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034770","reservation_id":"82379","confirmation_number":"PB12292144731","room_confirmation_number":"PB12355235886","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"90039","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-10 02:24:58","reservation_modified_date_time":"2019-11-03 16:54:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90039","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034933","reservation_id":"85426","confirmation_number":"PB12222555534","room_confirmation_number":"PB12350544802","room_stay_from":"2019-11-03","room_stay_to":"2019-11-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"53442","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-10 21:26:17","reservation_modified_date_time":"2019-11-03 22:43:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53442","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035184","reservation_id":"86685","confirmation_number":"PB12249892290","room_confirmation_number":"PB12381410530","room_stay_from":"2019-11-04","room_stay_to":"2019-11-06","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":"93363","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-04 22:48:11","reservation_modified_date_time":"2019-11-04 22:48:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93363","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":"3035381","reservation_id":"82103","confirmation_number":"PB12255297284","room_confirmation_number":"PB12361850225","room_stay_from":"2019-11-05","room_stay_to":"2019-11-07","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":"89855","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-05 23:57:09","reservation_modified_date_time":"2019-11-05 18:06:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89855","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":"3035399","reservation_id":"86679","confirmation_number":"PB12226547153","room_confirmation_number":"PB12315745972","room_stay_from":"2019-11-04","room_stay_to":"2019-11-07","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":"93356","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-04 19:03:50","reservation_modified_date_time":"2019-11-04 19:03:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93356","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":"3035441","reservation_id":"86715","confirmation_number":"PB12234412908","room_confirmation_number":"PB12361923511","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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":"70532","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-05 20:45:12","reservation_modified_date_time":"2019-11-05 20:45:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70532","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035454","reservation_id":"85325","confirmation_number":"PB12264627481","room_confirmation_number":"PB12390510045","room_stay_from":"2019-11-02","room_stay_to":"2019-11-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"92484","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-08 23:56:07","reservation_modified_date_time":"2019-10-08 23:56:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92484","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035507","reservation_id":"60846","confirmation_number":"PB12336082603","room_confirmation_number":"PB12379701223","room_stay_from":"2019-11-05","room_stay_to":"2019-11-28","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"34353","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-21 14:57:31","reservation_modified_date_time":"2019-11-06 02:17:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"34353","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":"3035789","reservation_id":"86708","confirmation_number":"PB12296808859","room_confirmation_number":"PB12334623093","room_stay_from":"2019-11-05","room_stay_to":"2019-11-08","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":"93383","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-05 17:31:32","reservation_modified_date_time":"2019-11-05 17:31:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93383","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":"3038030","reservation_id":"81546","confirmation_number":"PB12275099579","room_confirmation_number":"PB12358891924","room_stay_from":"2019-11-03","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89446","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-02 21:42:25","reservation_modified_date_time":"2019-11-13 21:12:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89446","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038112","reservation_id":"84835","confirmation_number":"PB12242529699","room_confirmation_number":"PB12368624323","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"88639","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-28 23:26:38","reservation_modified_date_time":"2019-11-13 21:43:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88639","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3038709","reservation_id":"59963","confirmation_number":"PBR12285185099","room_confirmation_number":"PB12369148316","room_stay_from":"2019-10-29","room_stay_to":"2019-11-15","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"44768","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"2019-11-15 01:33:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44768","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3039959","reservation_id":"60458","confirmation_number":"PB12339654416","room_confirmation_number":"PB12394331741","room_stay_from":"2019-11-04","room_stay_to":"2019-11-22","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":"23636","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-16 21:18:07","reservation_modified_date_time":"2019-11-20 15:00:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23636","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3044302","reservation_id":"61846","confirmation_number":"PB12312856665","room_confirmation_number":"PB12391957014","room_stay_from":"2019-10-28","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23454","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-30 00:04:47","reservation_modified_date_time":"2019-12-05 15:30:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23454","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3035456","reservation_id":"85325","confirmation_number":"PB12273449457","room_confirmation_number":"PB12390510045","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1141","service_quantity":"2","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2019-11-05 21:34:01","reservation_modified_date_time":"2019-11-05 21:34:01","customer_id":"92484","parentCustTravId":"92484","customer_traveller_id":"92484","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":"40.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":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":3,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3007512","reservation_id":"82091","confirmation_number":"BV12472328627","room_stay_from":"2019-11-01","room_stay_to":"2019-11-17","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"113.58,113.58,91.9,91.9,91.9,91.9,91.9,113.58,113.58,91.9,91.9,91.9,91.9,91.9,113.58,113.58","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1600.48","grand_total":"1808.54","paid_amount":"1808.54","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-3067093686","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"160.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89847","customer_id":"89847","source_of_creation":"Booking.com","reservation_created_date":"2019-08-05 20:53:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"264.07","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.9","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3035748","reservation_id":"82102","confirmation_number":"BV12422682618","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.37","nightly_discount":"0.00","subtotal":"81.37","grand_total":"91.95","paid_amount":"91.95","room_type_id":"307","product_id":"1224","siteminder_id":"EXP-1315800023","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":"89857","customer_id":"89857","source_of_creation":"Expedia","reservation_created_date":"2019-08-05 23:57:08","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":"81.37","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":[{"room_stay_id":"3035097","reservation_id":"86675","confirmation_number":"BV12462634784","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.13","nightly_discount":"0","subtotal":"125.13","grand_total":"163.26","paid_amount":"163.26","room_type_id":"306","product_id":"1223","siteminder_id":"ABB-HMAQNFPP99","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"125.13","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93353","customer_id":"93353","source_of_creation":"Airbnb","reservation_created_date":"2019-11-04 17:44:08","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"17.49","commision_charges":"3.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"125.13","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3014089","reservation_id":"83247","confirmation_number":"BV12477870814","room_stay_from":"2019-11-03","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.96,102.96,102.96,102.96,102.96,130.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"645.20","grand_total":"729.07","paid_amount":"729.07","room_type_id":"305","product_id":"1222","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90636","customer_id":"90636","source_of_creation":"FE","reservation_created_date":"2019-08-26 17:51:04","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"102.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017920","reservation_id":"83854","confirmation_number":"BV12458745500","room_stay_from":"2019-11-04","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.68,67.68,67.68","nightly_discount":"0.00,0.00,0.00","subtotal":"203.04","grand_total":"229.43","paid_amount":"229.43","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":"91183","customer_id":"91183","source_of_creation":"FE","reservation_created_date":"2019-09-09 21:07:28","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035375","reservation_id":"84177","confirmation_number":"BV12458733513","room_stay_from":"2019-11-07","room_stay_to":"2019-11-10","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"105.00,139.20,139.20","nightly_discount":"0.00,0.00,0.00","subtotal":"383.40","grand_total":"433.24","paid_amount":"433.24","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":"91670","customer_id":"91670","source_of_creation":"FE","reservation_created_date":"2019-09-16 01:06:34","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":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3035188","reservation_id":"86641","confirmation_number":"BV12440606139","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.81,97.81,97.81","nightly_discount":"0.00,0.00,0.00","subtotal":"293.43","grand_total":"331.58","paid_amount":"331.58","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"28609","customer_id":"28609","source_of_creation":"PMS","reservation_created_date":"2019-11-03 19:37:42","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"97.81","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035424","reservation_id":"86712","confirmation_number":"BV12492063913","room_stay_from":"2019-11-05","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.32,84.32","nightly_discount":"0.00,9.63,0.00","subtotal":"168.64","grand_total":"179.68","paid_amount":"179.68","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":"93387","customer_id":"93387","source_of_creation":"PMS","reservation_created_date":"2019-11-05 19:35:34","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":"84.32","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3037089","reservation_id":"85344","confirmation_number":"BV12420476697","room_stay_from":"2019-11-04","room_stay_to":"2019-11-10","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"594.00","grand_total":"671.22","paid_amount":"671.22","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":"38460","customer_id":"38460","source_of_creation":"PMS","reservation_created_date":"2019-10-09 14:20:02","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":"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":"3083019","reservation_id":"86706","confirmation_number":"BV12446866867","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.34","nightly_discount":"0.00","subtotal":"105.34","grand_total":"119.03","paid_amount":"119.03","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":"95379","customer_id":"95379","source_of_creation":"PMS","reservation_created_date":"2019-11-05 16:35:33","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3007513","reservation_id":"82091","confirmation_number":"BV12244575200","room_confirmation_number":"BV12472328627","room_stay_from":"2019-11-01","room_stay_to":"2019-11-17","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"89847","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-08-05 20:53:09","reservation_modified_date_time":"2019-08-05 20:53:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89847","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3007514","reservation_id":"82091","confirmation_number":"BV12241348721","room_confirmation_number":"BV12472328627","room_stay_from":"2019-11-01","room_stay_to":"2019-11-17","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"320.00","grand_total":"361.60","paid_amount":"361.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"89847","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-05 20:53:09","reservation_modified_date_time":"2019-08-05 20:53:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89847","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3014090","reservation_id":"83247","confirmation_number":"BV12212345943","room_confirmation_number":"BV12477870814","room_stay_from":"2019-11-03","room_stay_to":"2019-11-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"90636","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-26 17:51:04","reservation_modified_date_time":"2019-08-26 17:51:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90636","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017921","reservation_id":"83854","confirmation_number":"BV12226378982","room_confirmation_number":"BV12458745500","room_stay_from":"2019-11-04","room_stay_to":"2019-11-07","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":"91183","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-09 21:07:28","reservation_modified_date_time":"2019-09-09 21:07:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91183","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":"3035098","reservation_id":"86675","confirmation_number":"BV12290707902","room_confirmation_number":"BV12462634784","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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":"93353","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-04 17:44:08","reservation_modified_date_time":"2019-11-04 17:44:08","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93353","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3035189","reservation_id":"86641","confirmation_number":"BV12293985091","room_confirmation_number":"BV12440606139","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"28609","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-03 19:37:42","reservation_modified_date_time":"2019-11-03 19:37:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28609","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035425","reservation_id":"86712","confirmation_number":"BV12224057844","room_confirmation_number":"BV12492063913","room_stay_from":"2019-11-05","room_stay_to":"2019-11-07","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":"93387","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-05 19:35:34","reservation_modified_date_time":"2019-11-05 19:41:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93387","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":"3035749","reservation_id":"82102","confirmation_number":"BV12277920868","room_confirmation_number":"BV12422682618","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89857","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-05 23:57:08","reservation_modified_date_time":"2019-11-06 16:22:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89857","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":"3037090","reservation_id":"85344","confirmation_number":"BV12229738076","room_confirmation_number":"BV12420476697","room_stay_from":"2019-11-04","room_stay_to":"2019-11-10","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":"38460","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-09 14:20:02","reservation_modified_date_time":"2019-11-10 23:07:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"38460","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":"3083018","reservation_id":"86706","confirmation_number":"BV12261622689","room_confirmation_number":"BV12446866867","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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":"95379","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-05 16:35:33","reservation_modified_date_time":"2020-03-17 15:12:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95379","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3035457","reservation_id":"86675","confirmation_number":"BV12293948976","room_confirmation_number":"BV12462634784","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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-11-05 21:51:11","reservation_modified_date_time":"2019-11-05 21:51:11","customer_id":"93353","parentCustTravId":"93353","customer_traveller_id":"93353","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":"3035458","reservation_id":"86675","confirmation_number":"BV12280674275","room_confirmation_number":"BV12462634784","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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-11-05 21:51:35","reservation_modified_date_time":"2019-11-05 21:51:35","customer_id":"93353","parentCustTravId":"93353","customer_traveller_id":"93353","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":[]}},"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":"3034958","reservation_id":"86655","confirmation_number":"BP12593896102","room_stay_from":"2019-11-04","room_stay_to":"2019-11-07","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"96.80,96.80,96.80","nightly_discount":"0,0,0","subtotal":"290.40","grand_total":"328.15","paid_amount":"328.15","room_type_id":"294","product_id":"1126","siteminder_id":"BDC-2806433104","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":"93337","customer_id":"93337","source_of_creation":"Booking.com","reservation_created_date":"2019-11-04 01:15:06","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"43.56","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3033973","reservation_id":"86514","confirmation_number":"BP12550755154","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"48.52,48.52,48.52,48.52","nightly_discount":"0,0,0,0","subtotal":"194.08","grand_total":"219.31","paid_amount":"219.31","room_type_id":"295","product_id":"1129","siteminder_id":"GAM-R1728953154","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":"93253","customer_id":"93253","source_of_creation":"Getaroom.com","reservation_created_date":"2019-11-01 00:49:09","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":"48.52","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_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3034264","reservation_id":"86544","confirmation_number":"BP12544410844","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.49,48.49,48.49,48.49","nightly_discount":"0,0,0,0","subtotal":"193.96","grand_total":"219.18","paid_amount":"219.18","room_type_id":"299","product_id":"1134","siteminder_id":"HWR-301199683","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":"93277","customer_id":"93277","source_of_creation":"Hotwire","reservation_created_date":"2019-11-01 20:23:05","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.49","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":"3035205","reservation_id":"86693","confirmation_number":"BP12574364070","room_stay_from":"2019-11-04","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"54.75,54.75","nightly_discount":"0,0","subtotal":"109.50","grand_total":"123.74","paid_amount":"123.74","room_type_id":"301","product_id":"1136","siteminder_id":"HWR-301232864","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":"93370","customer_id":"93370","source_of_creation":"Hotwire","reservation_created_date":"2019-11-05 04:25:11","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":"54.75","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":"3035385","reservation_id":"86709","confirmation_number":"BP12532816499","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.49","nightly_discount":"0","subtotal":"48.49","grand_total":"54.79","paid_amount":"54.79","room_type_id":"293","product_id":"1124","siteminder_id":"HWR-301238552","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":"93384","customer_id":"93384","source_of_creation":"Hotwire","reservation_created_date":"2019-11-05 18:09:11","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.49","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":"3033680","reservation_id":"86472","confirmation_number":"BP12562940261","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.68,71.68,71.68,71.68","nightly_discount":"0,0,0,0","subtotal":"286.72","grand_total":"323.99","paid_amount":"323.99","room_type_id":"301","product_id":"1137","siteminder_id":"AGO-288549402","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":"93220","customer_id":"93220","source_of_creation":"Agoda","reservation_created_date":"2019-10-30 23:45:36","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.68","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3034304","reservation_id":"86551","confirmation_number":"BP12534754244","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"64.30,64.30,64.30","nightly_discount":"0.00,0.00,0.00","subtotal":"192.90","grand_total":"217.97","paid_amount":"217.97","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"FE","reservation_created_date":"2019-11-01 22:30:58","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"64.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3035468","reservation_id":"86722","confirmation_number":"BP12528988627","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.87","nightly_discount":"0.00","subtotal":"73.87","grand_total":"83.47","paid_amount":"83.47","room_type_id":"295","product_id":"1128","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":"93395","customer_id":"93395","source_of_creation":"FE","reservation_created_date":"2019-11-05 22:30:56","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":"73.87","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3036701","reservation_id":"86056","confirmation_number":"BP12535044277","room_stay_from":"2019-11-04","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.86,99.86,99.86,99.86,132.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"532.24","grand_total":"601.43","paid_amount":"601.43","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":"92927","customer_id":"92927","source_of_creation":"PMS","reservation_created_date":"2019-10-21 19:41:54","canceled_nights_data":"","product_name":"BP Waterfront 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.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3041260","reservation_id":"83371","confirmation_number":"BP12598404732","room_stay_from":"2019-11-05","room_stay_to":"2019-11-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.73,53.73,53.75,65.85","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"227.06","grand_total":"256.57","paid_amount":"256.57","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":"90728","customer_id":"90728","source_of_creation":"PMS","reservation_created_date":"2019-08-29 00:11:20","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":"","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_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3033681","reservation_id":"86472","confirmation_number":"BP12247799984","room_confirmation_number":"BP12562940261","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","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":"93220","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-30 23:45:36","reservation_modified_date_time":"2019-10-30 23:45:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93220","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":"3033974","reservation_id":"86514","confirmation_number":"BP12298549506","room_confirmation_number":"BP12550755154","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","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":"93253","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-01 00:49:09","reservation_modified_date_time":"2019-11-01 00:49:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93253","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":"3034265","reservation_id":"86544","confirmation_number":"BP12267381566","room_confirmation_number":"BP12544410844","room_stay_from":"2019-11-04","room_stay_to":"2019-11-08","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":"93277","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-01 20:23:05","reservation_modified_date_time":"2019-11-01 20:23:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93277","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":"3034305","reservation_id":"86551","confirmation_number":"BP12230612644","room_confirmation_number":"BP12534754244","room_stay_from":"2019-11-03","room_stay_to":"2019-11-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"47798","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-01 22:30:58","reservation_modified_date_time":"2019-11-01 22:30:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034959","reservation_id":"86655","confirmation_number":"BP12295020197","room_confirmation_number":"BP12593896102","room_stay_from":"2019-11-04","room_stay_to":"2019-11-07","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":"93337","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-04 01:15:06","reservation_modified_date_time":"2019-11-04 01:15:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93337","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":"3035206","reservation_id":"86693","confirmation_number":"BP12287635360","room_confirmation_number":"BP12574364070","room_stay_from":"2019-11-04","room_stay_to":"2019-11-06","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":"93370","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-05 04:25:11","reservation_modified_date_time":"2019-11-05 04:25:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93370","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":"3035386","reservation_id":"86709","confirmation_number":"BP12279278540","room_confirmation_number":"BP12532816499","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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":"93384","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-05 18:09:11","reservation_modified_date_time":"2019-11-05 18:09:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93384","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":"3035469","reservation_id":"86722","confirmation_number":"BP12253209375","room_confirmation_number":"BP12528988627","room_stay_from":"2019-11-05","room_stay_to":"2019-11-06","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":"93395","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-05 22:30:56","reservation_modified_date_time":"2019-11-05 22:30:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93395","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":"3036702","reservation_id":"86056","confirmation_number":"BP12221831857","room_confirmation_number":"BP12535044277","room_stay_from":"2019-11-04","room_stay_to":"2019-11-09","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"92927","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-21 19:41:54","reservation_modified_date_time":"2019-11-09 16:03:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92927","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":"3041261","reservation_id":"83371","confirmation_number":"BP12237108034","room_confirmation_number":"BP12598404732","room_stay_from":"2019-11-05","room_stay_to":"2019-11-09","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"90728","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-29 00:11:20","reservation_modified_date_time":"2019-11-24 23:16:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90728","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":"3034960","reservation_id":"86655","confirmation_number":"BP12297966014","room_confirmation_number":"BP12593896102","room_stay_from":"2019-11-04","room_stay_to":"2019-11-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.75","paid_amount":"84.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-11-04 01:21:20","reservation_modified_date_time":"2019-11-04 01:21:20","customer_id":"93337","parentCustTravId":"93337","customer_traveller_id":"93337","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":"3034522","reservation_id":"86574","confirmation_number":"BP12238960117","room_confirmation_number":"BP12542559543","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":"22.60","paid_amount":"0.00","product_id":"1192","service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-11-02 19:39:15","reservation_modified_date_time":"2019-11-02 19:39:15","customer_id":"93288","parentCustTravId":"93288","customer_traveller_id":"93288","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-11-05 14:56:45","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-20,"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":[]}}}