{"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":13,"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":"3004637","reservation_id":"81676","confirmation_number":"PB12319886901","room_stay_from":"2019-09-07","room_stay_to":"2019-09-11","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":"1105","siteminder_id":"BDC-3510654197","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":"89550","customer_id":"89550","source_of_creation":"Booking.com","reservation_created_date":"2019-07-29 20:09:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","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"}]},{"room_stay_id":"3017842","reservation_id":"82481","confirmation_number":"PB12347825794","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.58","nightly_discount":"0","subtotal":"122.58","grand_total":"138.51","paid_amount":"138.52","room_type_id":"289","product_id":"1093","siteminder_id":"BDC-3271466208","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":"90092","customer_id":"90092","source_of_creation":"Booking.com","reservation_created_date":"2019-08-11 19:38:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"38.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"122.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017844","reservation_id":"82481","confirmation_number":"PB12396776997","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"123.08","nightly_discount":"0","subtotal":"123.08","grand_total":"139.08","paid_amount":"139.08","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3271466208","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90092","customer_id":"90092","source_of_creation":"Booking.com","reservation_created_date":"2019-08-11 19:38:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"38.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"123.08","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":"3017783","reservation_id":"80743","confirmation_number":"PB12310834930","room_stay_from":"2019-10-04","room_stay_to":"2019-10-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.90,134.90","nightly_discount":"0,0","subtotal":"269.80","grand_total":"304.88","paid_amount":"304.88","room_type_id":"289","product_id":"1111","siteminder_id":"BDC-3874252880","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":"88932","customer_id":"88932","source_of_creation":"Booking.com","reservation_created_date":"2019-07-14 21:23:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"40.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates 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"}]}],"bdc_non_taxable":[{"room_stay_id":"3016841","reservation_id":"78802","confirmation_number":"PB12313122335","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"187.94,187.94,176.5,176.5","nightly_discount":"0,0,0,0","subtotal":"728.88","grand_total":"823.63","paid_amount":"76.77","room_type_id":"313","product_id":"1228","siteminder_id":"BDC-3675528886","collect_which":"hotel_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":"87753","customer_id":"87753","source_of_creation":"Booking.com","reservation_created_date":"2019-06-16 19:08:07","service_canceled_date_time":"2019-09-06 18:01:05","canceled_nights_data":"","product_name":"PB Walk","ota_service_fee_amount":"0","commision_charges":"127.33","deltaChange":"212.37","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3004382","reservation_id":"81630","confirmation_number":"PB12351229846","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.14,62.14,62.14,62.14,62.14","nightly_discount":"0,0,0,0,0","subtotal":"310.70","grand_total":"351.09","paid_amount":"351.09","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1310060936","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":"89503","customer_id":"89503","source_of_creation":"Expedia","reservation_created_date":"2019-07-28 22:14:08","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.14","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3015460","reservation_id":"80652","confirmation_number":"PB12386020046","room_stay_from":"2019-08-30","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.46,129.80,110.02,117.36,84.01,84.01,84.01,92.45,92.45,84.01,84.01,84.01,84.01,84.01","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1352.62","grand_total":"1528.46","paid_amount":"1528.46","room_type_id":"289","product_id":"1112","siteminder_id":"EXP-1299080977","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":"88876","customer_id":"88876","source_of_creation":"Expedia","reservation_created_date":"2019-07-13 15:30:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3016183","reservation_id":"78429","confirmation_number":"PB12354310216","room_stay_from":"2019-09-07","room_stay_to":"2019-09-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.82,86.16,86.16,86.16,86.16,86.16,94.82,94.82,86.16,86.16","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"887.58","grand_total":"1002.96","paid_amount":"1002.96","room_type_id":"289","product_id":"1098","siteminder_id":"EXP-1275163924","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":"87498","customer_id":"87498","source_of_creation":"Expedia","reservation_created_date":"2019-06-10 19:24:08","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":"86.16","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017933","reservation_id":"83783","confirmation_number":"PB12371701361","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"84.01,84.01","nightly_discount":"0,0","subtotal":"168.02","grand_total":"189.86","paid_amount":"189.86","room_type_id":"287","product_id":"1088","siteminder_id":"EXP-1338323811","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91130","customer_id":"91130","source_of_creation":"Expedia","reservation_created_date":"2019-09-08 16:12:09","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":"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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3017184","reservation_id":"82382","confirmation_number":"PB12334056599","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.40,77.40,77.40,77.40,77.40","nightly_discount":"0,0,0,0,0","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","room_type_id":"289","product_id":"1096","siteminder_id":"GAM-R1610327247","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":"90041","customer_id":"90041","source_of_creation":"Getaroom.com","reservation_created_date":"2019-08-10 02:53:10","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":"77.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[{"room_stay_id":"3009297","reservation_id":"82422","confirmation_number":"PB12367545368","room_stay_from":"2019-09-08","room_stay_to":"2019-09-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89,89,89,89,89,129","nightly_discount":"0,0,0,0,0,0","subtotal":"574.00","grand_total":"648.62","paid_amount":"648.62","room_type_id":"289","product_id":"1109","siteminder_id":"ZOO-3314-7150-7964","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":"90066","customer_id":"90066","source_of_creation":"Travelzoo","reservation_created_date":"2019-08-10 19:51:10","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":"89","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"}]}],"zoo_non_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2980379","reservation_id":"77227","confirmation_number":"PB12382509662","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,119.20,119.20,119.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"476.80","grand_total":"538.79","paid_amount":"538.79","room_type_id":"286","product_id":"1086","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"86661","customer_id":"86661","source_of_creation":"FE","reservation_created_date":"2019-05-24 01:08:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3002083","reservation_id":"81242","confirmation_number":"PB12386675250","room_stay_from":"2019-09-06","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"120.00,120.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"448.00","grand_total":"506.24","paid_amount":"506.24","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":"89261","customer_id":"89261","source_of_creation":"FE","reservation_created_date":"2019-07-23 01:25:29","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":"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":"3009560","reservation_id":"82478","confirmation_number":"PB12344278899","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.80,160.80,160.80","nightly_discount":"0.00,0.00,0.00","subtotal":"498.40","grand_total":"563.19","paid_amount":"563.19","room_type_id":"287","product_id":"1089","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90088","customer_id":"90088","source_of_creation":"FE","reservation_created_date":"2019-08-11 17:10:10","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3012771","reservation_id":"83037","confirmation_number":"PB12389778672","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.80,160.80,160.80,160.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"643.20","grand_total":"726.81","paid_amount":"726.81","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":"90490","customer_id":"90490","source_of_creation":"FE","reservation_created_date":"2019-08-22 02:55:10","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":"160.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016998","reservation_id":"83688","confirmation_number":"PB12337477871","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.00,106.00,106.00,106.00,106.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"530.00","grand_total":"598.90","paid_amount":"598.90","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":"91067","customer_id":"91067","source_of_creation":"FE","reservation_created_date":"2019-09-06 01:45:38","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":"106.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017177","reservation_id":"77079","confirmation_number":"PB12399667658","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"145.60,129.60,129.60","nightly_discount":"0.00,0.00,15.46,0.00","subtotal":"404.80","grand_total":"439.95","paid_amount":"439.95","room_type_id":"288","product_id":"1092","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84601","customer_id":"84601","source_of_creation":"FE","reservation_created_date":"2019-05-22 01:57:07","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.60","currentDayDiscount":"15.46","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017179","reservation_id":"77079","confirmation_number":"PB12350360974","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"145.60,129.60,129.60","nightly_discount":"0.00,0.00,15.46,0.00","subtotal":"404.80","grand_total":"439.95","paid_amount":"439.95","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-05-22 01:57:07","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":"15.46","productIsTaxExempt":false,"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":"3000086","reservation_id":"80970","confirmation_number":"PB12341456450","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","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":"0.00,0.00,0.00,0.00,0.00","subtotal":"520.00","grand_total":"587.60","paid_amount":"587.60","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"58435","customer_id":"58435","source_of_creation":"PMS","reservation_created_date":"2019-07-18 21:38:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3017480","reservation_id":"56590","confirmation_number":"PB12327585879","room_stay_from":"2019-09-08","room_stay_to":"2019-09-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.00,69.00,69.00,69.00,69.00,69.00,69.00,69.00,69.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,27.60,0.00,0.00","subtotal":"621.00","grand_total":"670.54","paid_amount":"670.54","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"75193","customer_id":"75193","source_of_creation":"PMS","reservation_created_date":"2018-09-18 18:41:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017490","reservation_id":"56610","confirmation_number":"PB12399904510","room_stay_from":"2019-09-08","room_stay_to":"2019-09-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.00,69.00,69.00,69.00,69.00,69.00,69.00,69.00,69.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,31.00,0.00","subtotal":"621.00","grand_total":"666.70","paid_amount":"666.70","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":"32420","customer_id":"32420","source_of_creation":"PMS","reservation_created_date":"2018-09-18 20:53:32","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017492","reservation_id":"56596","confirmation_number":"PB12342052474","room_stay_from":"2019-09-08","room_stay_to":"2019-09-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.00,69.00,69.00,69.00,69.00,69.00,69.00,69.00,69.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,31.00,0.00","subtotal":"621.00","grand_total":"666.70","paid_amount":"666.70","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":"27863","customer_id":"27863","source_of_creation":"PMS","reservation_created_date":"2018-09-18 19:06:49","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":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017771","reservation_id":"83820","confirmation_number":"PB12341180878","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00","nightly_discount":"6.20","subtotal":"112.00","grand_total":"119.56","paid_amount":"119.56","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":"91129","customer_id":"91129","source_of_creation":"PMS","reservation_created_date":"2019-09-09 14:29:14","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":"112.00","currentDayDiscount":"6.20","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017825","reservation_id":"81336","confirmation_number":"PB12344025568","room_stay_from":"2019-09-09","room_stay_to":"2019-09-19","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,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,4.85,40.00,0.00,0.00,0.00","subtotal":"992.00","grand_total":"1070.28","paid_amount":"1070.28","room_type_id":"289","product_id":"1106","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"44312","customer_id":"44312","source_of_creation":"PMS","reservation_created_date":"2019-07-24 16:20:14","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":"","changedComment":"To date changed","deltaChange":"0.00","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":"3017942","reservation_id":"83857","confirmation_number":"PB12385591557","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00","nightly_discount":"6.69,0.00","subtotal":"100.00","grand_total":"105.44","paid_amount":"105.44","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91348","customer_id":"91348","source_of_creation":"PMS","reservation_created_date":"2019-09-09 23:14:14","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":"100.00","currentDayDiscount":"6.69","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017954","reservation_id":"83859","confirmation_number":"PB12377867875","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00","nightly_discount":"0.00","subtotal":"89.00","grand_total":"100.57","paid_amount":"100.57","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":"59271","customer_id":"59271","source_of_creation":"PMS","reservation_created_date":"2019-09-10 00:38:50","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":"89.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3018023","reservation_id":"83785","confirmation_number":"PB12382148568","room_stay_from":"2019-09-08","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00","nightly_discount":"0.00,0.00","subtotal":"208.00","grand_total":"235.04","paid_amount":"207.92","room_type_id":"289","product_id":"1103","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91132","customer_id":"91132","source_of_creation":"PMS","reservation_created_date":"2019-09-08 16:43:47","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3018046","reservation_id":"83570","confirmation_number":"PB12310918997","room_stay_from":"2019-09-07","room_stay_to":"2019-09-11","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"150.00,100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"450.00","grand_total":"508.50","paid_amount":"508.50","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":"90862","customer_id":"90862","source_of_creation":"PMS","reservation_created_date":"2019-09-03 15:13:37","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":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3018259","reservation_id":"56573","confirmation_number":"PB12352948646","room_stay_from":"2019-09-08","room_stay_to":"2019-09-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.00,69.00,69.00","nightly_discount":"0.00,0.00,0.00","subtotal":"207.00","grand_total":"233.91","paid_amount":"233.91","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":"27794","customer_id":"27794","source_of_creation":"PMS","reservation_created_date":"2018-09-18 13:41:35","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":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020740","reservation_id":"81292","confirmation_number":"PB12334530932","room_stay_from":"2019-09-09","room_stay_to":"2019-09-20","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,96.00,96.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":"1088.00","grand_total":"1229.44","paid_amount":"1229.44","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":"89302","customer_id":"89302","source_of_creation":"PMS","reservation_created_date":"2019-07-23 20:36:04","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":"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":"3022754","reservation_id":"83559","confirmation_number":"PB12362554987","room_stay_from":"2019-09-08","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00","nightly_discount":"0.00,0.00","subtotal":"228.00","grand_total":"257.64","paid_amount":"257.64","room_type_id":"291","product_id":"1117","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90098","customer_id":"90098","source_of_creation":"PMS","reservation_created_date":"2019-09-03 00:28:36","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3026133","reservation_id":"83611","confirmation_number":"PB12348454570","room_stay_from":"2019-09-08","room_stay_to":"2019-09-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"94.00,94.00,94.00","nightly_discount":"0.00,0.00,0.00","subtotal":"282.00","grand_total":"318.66","paid_amount":"318.66","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":"91017","customer_id":"91017","source_of_creation":"PMS","reservation_created_date":"2019-09-04 17:24:20","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":"94.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028867","reservation_id":"83393","confirmation_number":"PB12358154595","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"456.00","grand_total":"515.28","paid_amount":"515.28","room_type_id":"291","product_id":"1115","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"72986","customer_id":"72986","source_of_creation":"PMS","reservation_created_date":"2019-08-29 15:18:18","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":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017917","reservation_id":"67964","confirmation_number":"PB12317218224","room_stay_from":"2019-10-20","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,164.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"734.00","grand_total":"829.42","paid_amount":"829.42","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"53778","customer_id":"53778","source_of_creation":"PMS","reservation_created_date":"2019-01-27 21:38:21","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":"","changedComment":"To 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"}]},{"room_stay_id":"3017501","reservation_id":"83782","confirmation_number":"PB12329030702","room_stay_from":"2019-09-08","room_stay_to":"2019-09-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00","nightly_discount":"5.92,0.00","subtotal":"112.00","grand_total":"119.87","paid_amount":"119.87","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":"91129","customer_id":"91129","source_of_creation":"PMS","reservation_created_date":"2019-09-08 15:46:59","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"-5.92","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3002085","reservation_id":"81242","confirmation_number":"PB12242499981","room_confirmation_number":"PB12386675250","room_stay_from":"2019-09-06","room_stay_to":"2019-09-10","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":"1780","service_quantity":"1","customer_traveller_id":"89261","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-07-23 01:25:29","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89261","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":"3016461","reservation_id":"77079","confirmation_number":"PB12228879154","room_confirmation_number":"PB12350360974","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0,0,0","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"84601","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-09-05 12:53:44","reservation_modified_date_time":"2019-09-05 12:53:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84601","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016465","reservation_id":"77079","confirmation_number":"PB12222972399","room_confirmation_number":"PB12399667658","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0,0,0","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"84601","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-09-05 12:53:50","reservation_modified_date_time":"2019-09-05 12:53:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84601","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017845","reservation_id":"82481","confirmation_number":"PB12265023907","room_confirmation_number":"PB12396776997","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"90092","product_attribute_values":"extra_person# ","reservation_created_date":"2019-09-09 17:49:48","reservation_modified_date_time":"2019-09-09 17:49:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90092","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":"3017934","reservation_id":"83783","confirmation_number":"PB12233219017","room_confirmation_number":"PB12371701361","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"91130","product_attribute_values":"extra_person# ","reservation_created_date":"2019-09-09 22:02:58","reservation_modified_date_time":"2019-09-09 22:02:58","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91130","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":"3018047","reservation_id":"83570","confirmation_number":"PB12238140308","room_confirmation_number":"PB12310918997","room_stay_from":"2019-09-07","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0.00,0.00,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"90862","product_attribute_values":"extra_person# ","reservation_created_date":"2019-09-10 15:51:46","reservation_modified_date_time":"2019-09-10 15:51:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90862","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":"2980380","reservation_id":"77227","confirmation_number":"PB12283771789","room_confirmation_number":"PB12382509662","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"86661","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-05-24 01:08:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86661","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":"3000087","reservation_id":"80970","confirmation_number":"PB12223589048","room_confirmation_number":"PB12341456450","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"58435","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-18 21:38:28","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58435","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":"3002084","reservation_id":"81242","confirmation_number":"PB12262788119","room_confirmation_number":"PB12386675250","room_stay_from":"2019-09-06","room_stay_to":"2019-09-10","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":"89261","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-23 01:25:29","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89261","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":"3004383","reservation_id":"81630","confirmation_number":"PB12252276440","room_confirmation_number":"PB12351229846","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89503","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-28 22:14:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89503","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":"3004638","reservation_id":"81676","confirmation_number":"PB12226587641","room_confirmation_number":"PB12319886901","room_stay_from":"2019-09-07","room_stay_to":"2019-09-11","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":"89550","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-29 20:09:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89550","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":"3009298","reservation_id":"82422","confirmation_number":"PB12271353147","room_confirmation_number":"PB12367545368","room_stay_from":"2019-09-08","room_stay_to":"2019-09-14","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"90066","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-10 19:51:10","reservation_modified_date_time":"2019-08-10 19:51:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90066","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":"3009561","reservation_id":"82478","confirmation_number":"PB12283150790","room_confirmation_number":"PB12344278899","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","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":"90088","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-11 17:10:10","reservation_modified_date_time":"2019-08-11 17:10:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90088","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":"3012772","reservation_id":"83037","confirmation_number":"PB12269102463","room_confirmation_number":"PB12389778672","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"90490","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-22 02:55:10","reservation_modified_date_time":"2019-08-22 02:55:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90490","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":"3015461","reservation_id":"80652","confirmation_number":"PB12218001797","room_confirmation_number":"PB12386020046","room_stay_from":"2019-08-30","room_stay_to":"2019-09-13","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"280.00","grand_total":"316.40","paid_amount":"316.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"88876","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-13 15:30: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":"88876","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":"3016184","reservation_id":"78429","confirmation_number":"PB12294782073","room_confirmation_number":"PB12354310216","room_stay_from":"2019-09-07","room_stay_to":"2019-09-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"87498","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-10 19:24:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87498","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":"3016999","reservation_id":"83688","confirmation_number":"PB12296173928","room_confirmation_number":"PB12337477871","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"91067","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-06 01:45:38","reservation_modified_date_time":"2019-09-06 23:30:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91067","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":"3017178","reservation_id":"77079","confirmation_number":"PB12262509987","room_confirmation_number":"PB12399667658","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","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":"84601","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-05-22 01:57:07","reservation_modified_date_time":"2019-09-07 16:45:58","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":"3017180","reservation_id":"77079","confirmation_number":"PB12242106760","room_confirmation_number":"PB12350360974","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","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":"84601","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-05-22 01:57:07","reservation_modified_date_time":"2019-09-07 16:48:48","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":"3017185","reservation_id":"82382","confirmation_number":"PB12213353049","room_confirmation_number":"PB12334056599","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"90041","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-10 02:53:10","reservation_modified_date_time":"2019-08-10 02:53:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90041","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":"3017481","reservation_id":"56590","confirmation_number":"PB12314824300","room_confirmation_number":"PB12327585879","room_stay_from":"2019-09-08","room_stay_to":"2019-09-17","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"75193","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-09-18 18:41:20","reservation_modified_date_time":"2019-09-08 15:12:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75193","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":"3017491","reservation_id":"56610","confirmation_number":"PB12385143046","room_confirmation_number":"PB12399904510","room_stay_from":"2019-09-08","room_stay_to":"2019-09-17","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"32420","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-09-18 20:54:46","reservation_modified_date_time":"2019-09-08 15:48:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"32420","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":"3017493","reservation_id":"56596","confirmation_number":"PB12339389297","room_confirmation_number":"PB12342052474","room_stay_from":"2019-09-08","room_stay_to":"2019-09-17","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"27863","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-09-18 19:06:49","reservation_modified_date_time":"2019-09-08 15:54:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"27863","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":"3017772","reservation_id":"83820","confirmation_number":"PB12225814204","room_confirmation_number":"PB12341180878","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","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":"91129","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-09 14:29:14","reservation_modified_date_time":"2019-09-09 14:29:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91129","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":"3017826","reservation_id":"81336","confirmation_number":"PB12230942864","room_confirmation_number":"PB12344025568","room_stay_from":"2019-09-09","room_stay_to":"2019-09-19","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":"44312","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-24 16:20:14","reservation_modified_date_time":"2019-09-09 17:05:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44312","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017843","reservation_id":"82481","confirmation_number":"PB12244948571","room_confirmation_number":"PB12347825794","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.59","product_id":"1781","service_quantity":"1","customer_traveller_id":"90092","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-11 19:38:14","reservation_modified_date_time":"2019-08-11 19:38:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90092","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":"3017846","reservation_id":"82481","confirmation_number":"PB12248636189","room_confirmation_number":"PB12396776997","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","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":"90092","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-11 19:38:09","reservation_modified_date_time":"2019-08-11 19:38:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90092","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":"3017935","reservation_id":"83783","confirmation_number":"PB12281772633","room_confirmation_number":"PB12371701361","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91130","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-08 16:12:09","reservation_modified_date_time":"2019-09-08 16:12:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91130","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":"3017943","reservation_id":"83857","confirmation_number":"PB12247074098","room_confirmation_number":"PB12385591557","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","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":"91348","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-09 23:14:14","reservation_modified_date_time":"2019-09-09 23:14:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91348","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":"3017955","reservation_id":"83859","confirmation_number":"PB12238516943","room_confirmation_number":"PB12377867875","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","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":"59271","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-10 00:38:50","reservation_modified_date_time":"2019-09-10 00:52:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"59271","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":"3018024","reservation_id":"83785","confirmation_number":"PB12270244397","room_confirmation_number":"PB12382148568","room_stay_from":"2019-09-08","room_stay_to":"2019-09-10","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":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"91132","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-08 16:43:47","reservation_modified_date_time":"2019-09-08 16:43:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91132","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":"3018048","reservation_id":"83570","confirmation_number":"PB12257931143","room_confirmation_number":"PB12310918997","room_stay_from":"2019-09-07","room_stay_to":"2019-09-11","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":"90862","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-03 15:13:37","reservation_modified_date_time":"2019-09-03 15:13:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90862","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":"3018260","reservation_id":"56573","confirmation_number":"PB12314412011","room_confirmation_number":"PB12352948646","room_stay_from":"2019-09-08","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"27794","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-09-18 13:41:43","reservation_modified_date_time":"2019-09-08 14:40:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"27794","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":"3020741","reservation_id":"81292","confirmation_number":"PB12244842838","room_confirmation_number":"PB12334530932","room_stay_from":"2019-09-09","room_stay_to":"2019-09-20","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,12.00,12.00,12.00,12.00","subtotal":"132.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"89302","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-23 20:36:04","reservation_modified_date_time":"2019-09-18 20:03:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89302","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":"3022755","reservation_id":"83559","confirmation_number":"PB12290611066","room_confirmation_number":"PB12362554987","room_stay_from":"2019-09-08","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"39147","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-03 00:28:36","reservation_modified_date_time":"2019-09-26 15:18:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90098","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":"3026134","reservation_id":"83611","confirmation_number":"PB12259860827","room_confirmation_number":"PB12348454570","room_stay_from":"2019-09-08","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"91017","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-04 17:24:20","reservation_modified_date_time":"2019-10-07 22:05:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91017","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":"3016691","reservation_id":"83688","confirmation_number":"PB12215869320","room_confirmation_number":"PB12337477871","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"141.25","paid_amount":"141.25","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-06 02:10:05","reservation_modified_date_time":"2019-09-06 02:10:05","customer_id":"91067","parentCustTravId":"91067","customer_traveller_id":"91067","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":"3017797","reservation_id":"83826","confirmation_number":"PB12287215366","room_confirmation_number":"PB12375131772","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.26","grand_total":"3.49","paid_amount":"3.49","product_id":null,"service_quantity":"1","product_name":"Toothpaste","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-09 15:28:50","reservation_modified_date_time":"2019-09-09 15:28:50","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":4,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3017678","reservation_id":"83799","confirmation_number":"BV12410482886","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"71.78,71.78","nightly_discount":"0,0","subtotal":"143.56","grand_total":"187.31","paid_amount":"187.31","room_type_id":"303","product_id":"1140","siteminder_id":"ABB-HMARZ4E9AX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"143.56","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91141","customer_id":"91141","source_of_creation":"Airbnb","reservation_created_date":"2019-09-08 23:04:10","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"20.07","commision_charges":"4.44","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.78","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3017526","reservation_id":"82744","confirmation_number":"BV12443515569","room_stay_from":"2019-09-08","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.88,110.88","nightly_discount":"0.00,8.35,0.00","subtotal":"221.76","grand_total":"241.15","paid_amount":"241.15","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":"70531","customer_id":"70531","source_of_creation":"FE","reservation_created_date":"2019-08-16 16:56:58","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.88","currentDayDiscount":"8.35","productIsTaxExempt":false,"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":"3017977","reservation_id":"83864","confirmation_number":"BV12487745896","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"309","product_id":"1226","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74692","customer_id":"74692","source_of_creation":"PMS","reservation_created_date":"2019-09-10 02:50:06","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3017527","reservation_id":"82744","confirmation_number":"BV12290594150","room_confirmation_number":"BV12443515569","room_stay_from":"2019-09-08","room_stay_to":"2019-09-10","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":"70531","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-16 16:56:58","reservation_modified_date_time":"2019-09-08 18:04:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70531","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":"3017679","reservation_id":"83799","confirmation_number":"BV12286464524","room_confirmation_number":"BV12410482886","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91141","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-08 23:04:10","reservation_modified_date_time":"2019-09-08 23:04:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91141","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":"3017978","reservation_id":"83864","confirmation_number":"BV12237024909","room_confirmation_number":"BV12487745896","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","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":"74692","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-10 02:50:06","reservation_modified_date_time":"2019-09-10 02:50:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74692","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":"3017515","reservation_id":"82744","confirmation_number":"BV12287531250","room_confirmation_number":"BV12443515569","room_stay_from":"2019-09-08","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-08 17:50:15","reservation_modified_date_time":"2019-09-08 17:50:15","customer_id":"70531","parentCustTravId":"70531","customer_traveller_id":"70531","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":"3017780","reservation_id":"83798","confirmation_number":"BV12258245657","room_confirmation_number":"BV12458726042","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.27","grand_total":"3.50","paid_amount":"3.50","product_id":"1198","service_quantity":"1","product_name":"SunBlock / Tanning Oil","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-09 14:50:51","reservation_modified_date_time":"2019-09-09 14:50:51","customer_id":"91140","parentCustTravId":"91140","customer_traveller_id":"91140","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"3.27","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3017898","reservation_id":"83799","confirmation_number":"BV12239688762","room_confirmation_number":"BV12410482886","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1192","service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-09 19:42:49","reservation_modified_date_time":"2019-09-09 19:42:49","customer_id":"91141","parentCustTravId":"91141","customer_traveller_id":"91141","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3017899","reservation_id":"83799","confirmation_number":"BV12229741583","room_confirmation_number":"BV12410482886","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"26.75","paid_amount":"26.75","product_id":"1191","service_quantity":"1","product_name":"Resort Fee Car","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-09 19:42:49","reservation_modified_date_time":"2019-09-09 19:42:49","customer_id":"91141","parentCustTravId":"91141","customer_traveller_id":"91141","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":5,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3017781","reservation_id":"83823","confirmation_number":"BP12557510179","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"61.58","nightly_discount":"0","subtotal":"61.58","grand_total":"69.58","paid_amount":"0.00","room_type_id":"293","product_id":"1124","siteminder_id":"BDC-2978619780","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":"91157","customer_id":"91157","source_of_creation":"Booking.com","reservation_created_date":"2019-09-09 15:02:08","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"9.24","currentDayPrice":61.58,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017937","reservation_id":"83856","confirmation_number":"BP12562568922","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"64.86","nightly_discount":"0","subtotal":"64.86","grand_total":"73.29","paid_amount":"73.29","room_type_id":"295","product_id":"1128","siteminder_id":"BDC-3986484584","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91235","customer_id":"91235","source_of_creation":"Booking.com","reservation_created_date":"2019-09-09 22:16:09","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"11.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"64.86","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_taxable":[{"room_stay_id":"3016734","reservation_id":"77998","confirmation_number":"BP12576675372","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"90.49,80.39,80.39","nightly_discount":"0,0,0","subtotal":"251.27","grand_total":"283.94","paid_amount":"283.94","room_type_id":"295","product_id":"1129","siteminder_id":"EXP-1271278057","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87191","customer_id":"87191","source_of_creation":"Expedia","reservation_created_date":"2019-06-05 00:28:08","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":"80.39","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":"3017900","reservation_id":"83812","confirmation_number":"BP12593492948","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"58.35","nightly_discount":"0","subtotal":"58.35","grand_total":"65.93","paid_amount":"65.93","room_type_id":"304","product_id":"1220","siteminder_id":"EXP-1338882810","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":"91151","customer_id":"91151","source_of_creation":"Expedia","reservation_created_date":"2019-09-09 13:37:07","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"58.35","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3017952","reservation_id":"83855","confirmation_number":"BP12582874974","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.86,48.86","nightly_discount":"0,0","subtotal":"97.72","grand_total":"110.42","paid_amount":"110.42","room_type_id":"294","product_id":"1127","siteminder_id":"GAM-R1653570314","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":"91477","customer_id":"91477","source_of_creation":"Getaroom.com","reservation_created_date":"2019-09-09 21:37:10","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.86","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_non_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3017238","reservation_id":"82928","confirmation_number":"BP12543312139","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"107.56,107.56","nightly_discount":"0,0","subtotal":"215.12","grand_total":"243.09","paid_amount":"0.00","room_type_id":"315","product_id":"1230","siteminder_id":"GCS-0000400007-f81","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":"90409","customer_id":"90409","source_of_creation":"GuestCentric Channels","reservation_created_date":"2019-08-19 18:32:10","canceled_nights_data":"","product_name":"BP Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"107.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3017196","reservation_id":"64930","confirmation_number":"BP12593347752","room_stay_from":"2019-09-07","room_stay_to":"2019-09-14","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"110.00,110.00,110.00,110.00,110.00,110.00,110.00","nightly_discount":"0.00,39.82,0.00,0.00,0.00,0.00,0.00","subtotal":"770.00","grand_total":"825.10","paid_amount":"825.10","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":"33782","customer_id":"33782","source_of_creation":"PMS","reservation_created_date":"2018-12-31 15:58:38","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3017204","reservation_id":"66228","confirmation_number":"BP12599487345","room_stay_from":"2019-09-07","room_stay_to":"2019-09-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.00,105.00,105.00,105.00,105.00,105.00,105.00","nightly_discount":"0.00,31.77,0.00,0.00,0.00,0.00,0.00","subtotal":"735.00","grand_total":"794.65","paid_amount":"794.65","room_type_id":"300","product_id":"1135","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"26029","customer_id":"26029","source_of_creation":"PMS","reservation_created_date":"2019-01-10 20:04:58","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017211","reservation_id":"70079","confirmation_number":"BP12527746922","room_stay_from":"2019-09-07","room_stay_to":"2019-09-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,114.00,114.00,94.00,94.00","nightly_discount":"0.00,39.79,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"886.00","grand_total":"956.21","paid_amount":"956.22","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":"82217","customer_id":"82217","source_of_creation":"PMS","reservation_created_date":"2019-02-22 21:28:36","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":"94.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3030662","reservation_id":"83213","confirmation_number":"BP12562383005","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.44,76.44,76.44,76.45","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"305.77","grand_total":"345.52","paid_amount":"345.52","room_type_id":"301","product_id":"1136","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"70654","customer_id":"70654","source_of_creation":"PMS","reservation_created_date":"2019-08-25 19:37:38","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":"76.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2938954","reservation_id":"64930","confirmation_number":"BP12296008748","room_confirmation_number":"BP12593347752","room_stay_from":"2019-09-07","room_stay_to":"2019-09-14","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"33782","product_attribute_values":"extra_person# ","reservation_created_date":"2019-02-22 21:43:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"33782","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016735","reservation_id":"77998","confirmation_number":"BP12285176145","room_confirmation_number":"BP12576675372","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"87191","product_attribute_values":"extra_person# ","reservation_created_date":"2019-09-06 13:35:28","reservation_modified_date_time":"2019-09-06 13:35:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87191","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":"3017239","reservation_id":"82928","confirmation_number":"BP12252758818","room_confirmation_number":"BP12543312139","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"90409","product_attribute_values":"extra_person# ","reservation_created_date":"2019-09-07 20:43:18","reservation_modified_date_time":"2019-09-07 20:43:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90409","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017938","reservation_id":"83856","confirmation_number":"BP12234334325","room_confirmation_number":"BP12562568922","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"91235","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-09-09 22:16:09","reservation_modified_date_time":"2019-09-09 22:16:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91235","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":"3017782","reservation_id":"83823","confirmation_number":"BP12293864862","room_confirmation_number":"BP12557510179","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-09 15:02:08","reservation_modified_date_time":"2019-09-09 15:02:08","customer_id":"91157","parentCustTravId":"91157","customer_traveller_id":"91157","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#","currentDayPrice":20,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016736","reservation_id":"77998","confirmation_number":"BP12218145517","room_confirmation_number":"BP12576675372","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","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":"87191","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-05 00:28:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87191","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":"3017197","reservation_id":"64930","confirmation_number":"BP12278469451","room_confirmation_number":"BP12593347752","room_stay_from":"2019-09-07","room_stay_to":"2019-09-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"33782","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-12-31 15:58:38","reservation_modified_date_time":"2019-09-07 18:35:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"33782","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":"3017205","reservation_id":"66228","confirmation_number":"BP12251257074","room_confirmation_number":"BP12599487345","room_stay_from":"2019-09-07","room_stay_to":"2019-09-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"26029","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-10 20:04:58","reservation_modified_date_time":"2019-09-07 18:42:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26029","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":"3017212","reservation_id":"70079","confirmation_number":"BP12246751754","room_confirmation_number":"BP12527746922","room_stay_from":"2019-09-07","room_stay_to":"2019-09-16","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"82217","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-02-22 21:28:36","reservation_modified_date_time":"2019-09-07 19:07:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82217","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":"3017240","reservation_id":"82928","confirmation_number":"BP12244897706","room_confirmation_number":"BP12543312139","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"90409","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-19 18:32:10","reservation_modified_date_time":"2019-08-19 18:32:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90409","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":"3017901","reservation_id":"83812","confirmation_number":"BP12251259815","room_confirmation_number":"BP12593492948","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","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":"91151","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-09 13:37:07","reservation_modified_date_time":"2019-09-09 13:37:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91151","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":"3017939","reservation_id":"83856","confirmation_number":"BP12244936112","room_confirmation_number":"BP12562568922","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","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":"91235","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-09 22:16:09","reservation_modified_date_time":"2019-09-09 22:16:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91235","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":"3017953","reservation_id":"83855","confirmation_number":"BP12248541963","room_confirmation_number":"BP12582874974","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91477","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-09 21:37:10","reservation_modified_date_time":"2019-09-09 21:37:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91477","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":"3030663","reservation_id":"83213","confirmation_number":"BP12269726009","room_confirmation_number":"BP12562383005","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","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":"70654","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-25 19:37:38","reservation_modified_date_time":"2019-10-20 18:18:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70654","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":"3017801","reservation_id":"83213","confirmation_number":"BP12271811130","room_confirmation_number":"BP12562383005","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":"1192","service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-09 16:09:10","reservation_modified_date_time":"2019-09-09 16:09:10","customer_id":"70654","parentCustTravId":"70654","customer_traveller_id":"70654","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2019-09-09","total_rooms_exist":66,"departureCount":22,"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":"3017781","reservation_id":"83823","confirmation_number":"BP12557510179","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"61.58","nightly_discount":"0","subtotal":"61.58","grand_total":"69.58","paid_amount":"0.00","room_type_id":"293","product_id":"1124","siteminder_id":"BDC-2978619780","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":"91157","customer_id":"91157","source_of_creation":"Booking.com","reservation_created_date":"2019-09-09 15:02:08","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"9.24","currentDayPrice":61.58,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3004637","reservation_id":"81676","confirmation_number":"PB12319886901","room_stay_from":"2019-09-07","room_stay_to":"2019-09-11","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":"1105","siteminder_id":"BDC-3510654197","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":"89550","customer_id":"89550","source_of_creation":"Booking.com","reservation_created_date":"2019-07-29 20:09:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","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"}]},{"room_stay_id":"3017842","reservation_id":"82481","confirmation_number":"PB12347825794","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.58","nightly_discount":"0","subtotal":"122.58","grand_total":"138.51","paid_amount":"138.52","room_type_id":"289","product_id":"1093","siteminder_id":"BDC-3271466208","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":"90092","customer_id":"90092","source_of_creation":"Booking.com","reservation_created_date":"2019-08-11 19:38:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"38.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"122.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017844","reservation_id":"82481","confirmation_number":"PB12396776997","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"123.08","nightly_discount":"0","subtotal":"123.08","grand_total":"139.08","paid_amount":"139.08","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3271466208","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90092","customer_id":"90092","source_of_creation":"Booking.com","reservation_created_date":"2019-08-11 19:38:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"38.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"123.08","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":"3017937","reservation_id":"83856","confirmation_number":"BP12562568922","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"64.86","nightly_discount":"0","subtotal":"64.86","grand_total":"73.29","paid_amount":"73.29","room_type_id":"295","product_id":"1128","siteminder_id":"BDC-3986484584","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91235","customer_id":"91235","source_of_creation":"Booking.com","reservation_created_date":"2019-09-09 22:16:09","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"11.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"64.86","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":"3017783","reservation_id":"80743","confirmation_number":"PB12310834930","room_stay_from":"2019-10-04","room_stay_to":"2019-10-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.90,134.90","nightly_discount":"0,0","subtotal":"269.80","grand_total":"304.88","paid_amount":"304.88","room_type_id":"289","product_id":"1111","siteminder_id":"BDC-3874252880","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":"88932","customer_id":"88932","source_of_creation":"Booking.com","reservation_created_date":"2019-07-14 21:23:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"40.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates 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"}]}],"bdc_non_taxable":[{"room_stay_id":"3016841","reservation_id":"78802","confirmation_number":"PB12313122335","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"187.94,187.94,176.5,176.5","nightly_discount":"0,0,0,0","subtotal":"728.88","grand_total":"823.63","paid_amount":"76.77","room_type_id":"313","product_id":"1228","siteminder_id":"BDC-3675528886","collect_which":"hotel_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":"87753","customer_id":"87753","source_of_creation":"Booking.com","reservation_created_date":"2019-06-16 19:08:07","service_canceled_date_time":"2019-09-06 18:01:05","canceled_nights_data":"","product_name":"PB Walk","ota_service_fee_amount":"0","commision_charges":"127.33","deltaChange":"212.37","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3004382","reservation_id":"81630","confirmation_number":"PB12351229846","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.14,62.14,62.14,62.14,62.14","nightly_discount":"0,0,0,0,0","subtotal":"310.70","grand_total":"351.09","paid_amount":"351.09","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1310060936","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":"89503","customer_id":"89503","source_of_creation":"Expedia","reservation_created_date":"2019-07-28 22:14:08","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.14","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3015460","reservation_id":"80652","confirmation_number":"PB12386020046","room_stay_from":"2019-08-30","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.46,129.80,110.02,117.36,84.01,84.01,84.01,92.45,92.45,84.01,84.01,84.01,84.01,84.01","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1352.62","grand_total":"1528.46","paid_amount":"1528.46","room_type_id":"289","product_id":"1112","siteminder_id":"EXP-1299080977","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":"88876","customer_id":"88876","source_of_creation":"Expedia","reservation_created_date":"2019-07-13 15:30:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3016183","reservation_id":"78429","confirmation_number":"PB12354310216","room_stay_from":"2019-09-07","room_stay_to":"2019-09-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.82,86.16,86.16,86.16,86.16,86.16,94.82,94.82,86.16,86.16","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"887.58","grand_total":"1002.96","paid_amount":"1002.96","room_type_id":"289","product_id":"1098","siteminder_id":"EXP-1275163924","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":"87498","customer_id":"87498","source_of_creation":"Expedia","reservation_created_date":"2019-06-10 19:24:08","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":"86.16","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016734","reservation_id":"77998","confirmation_number":"BP12576675372","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"90.49,80.39,80.39","nightly_discount":"0,0,0","subtotal":"251.27","grand_total":"283.94","paid_amount":"283.94","room_type_id":"295","product_id":"1129","siteminder_id":"EXP-1271278057","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"87191","customer_id":"87191","source_of_creation":"Expedia","reservation_created_date":"2019-06-05 00:28:08","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":"80.39","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":"3017900","reservation_id":"83812","confirmation_number":"BP12593492948","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"58.35","nightly_discount":"0","subtotal":"58.35","grand_total":"65.93","paid_amount":"65.93","room_type_id":"304","product_id":"1220","siteminder_id":"EXP-1338882810","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":"91151","customer_id":"91151","source_of_creation":"Expedia","reservation_created_date":"2019-09-09 13:37:07","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"58.35","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":"3017933","reservation_id":"83783","confirmation_number":"PB12371701361","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"84.01,84.01","nightly_discount":"0,0","subtotal":"168.02","grand_total":"189.86","paid_amount":"189.86","room_type_id":"287","product_id":"1088","siteminder_id":"EXP-1338323811","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91130","customer_id":"91130","source_of_creation":"Expedia","reservation_created_date":"2019-09-08 16:12:09","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":"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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3017184","reservation_id":"82382","confirmation_number":"PB12334056599","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.40,77.40,77.40,77.40,77.40","nightly_discount":"0,0,0,0,0","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","room_type_id":"289","product_id":"1096","siteminder_id":"GAM-R1610327247","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":"90041","customer_id":"90041","source_of_creation":"Getaroom.com","reservation_created_date":"2019-08-10 02:53:10","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":"77.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017952","reservation_id":"83855","confirmation_number":"BP12582874974","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.86,48.86","nightly_discount":"0,0","subtotal":"97.72","grand_total":"110.42","paid_amount":"110.42","room_type_id":"294","product_id":"1127","siteminder_id":"GAM-R1653570314","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":"91477","customer_id":"91477","source_of_creation":"Getaroom.com","reservation_created_date":"2019-09-09 21:37:10","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.86","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":[{"room_stay_id":"3009297","reservation_id":"82422","confirmation_number":"PB12367545368","room_stay_from":"2019-09-08","room_stay_to":"2019-09-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89,89,89,89,89,129","nightly_discount":"0,0,0,0,0,0","subtotal":"574.00","grand_total":"648.62","paid_amount":"648.62","room_type_id":"289","product_id":"1109","siteminder_id":"ZOO-3314-7150-7964","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":"90066","customer_id":"90066","source_of_creation":"Travelzoo","reservation_created_date":"2019-08-10 19:51:10","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":"89","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"}]}],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3017678","reservation_id":"83799","confirmation_number":"BV12410482886","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"71.78,71.78","nightly_discount":"0,0","subtotal":"143.56","grand_total":"187.31","paid_amount":"187.31","room_type_id":"303","product_id":"1140","siteminder_id":"ABB-HMARZ4E9AX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"143.56","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91141","customer_id":"91141","source_of_creation":"Airbnb","reservation_created_date":"2019-09-08 23:04:10","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"20.07","commision_charges":"4.44","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.78","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3017238","reservation_id":"82928","confirmation_number":"BP12543312139","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"107.56,107.56","nightly_discount":"0,0","subtotal":"215.12","grand_total":"243.09","paid_amount":"0.00","room_type_id":"315","product_id":"1230","siteminder_id":"GCS-0000400007-f81","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":"90409","customer_id":"90409","source_of_creation":"GuestCentric Channels","reservation_created_date":"2019-08-19 18:32:10","canceled_nights_data":"","product_name":"BP Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"107.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"2980379","reservation_id":"77227","confirmation_number":"PB12382509662","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.20,119.20,119.20,119.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"476.80","grand_total":"538.79","paid_amount":"538.79","room_type_id":"286","product_id":"1086","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"86661","customer_id":"86661","source_of_creation":"FE","reservation_created_date":"2019-05-24 01:08:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3002083","reservation_id":"81242","confirmation_number":"PB12386675250","room_stay_from":"2019-09-06","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"120.00,120.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"448.00","grand_total":"506.24","paid_amount":"506.24","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":"89261","customer_id":"89261","source_of_creation":"FE","reservation_created_date":"2019-07-23 01:25:29","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":"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":"3009560","reservation_id":"82478","confirmation_number":"PB12344278899","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.80,160.80,160.80","nightly_discount":"0.00,0.00,0.00","subtotal":"498.40","grand_total":"563.19","paid_amount":"563.19","room_type_id":"287","product_id":"1089","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90088","customer_id":"90088","source_of_creation":"FE","reservation_created_date":"2019-08-11 17:10:10","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3012771","reservation_id":"83037","confirmation_number":"PB12389778672","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.80,160.80,160.80,160.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"643.20","grand_total":"726.81","paid_amount":"726.81","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":"90490","customer_id":"90490","source_of_creation":"FE","reservation_created_date":"2019-08-22 02:55:10","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":"160.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016998","reservation_id":"83688","confirmation_number":"PB12337477871","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.00,106.00,106.00,106.00,106.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"530.00","grand_total":"598.90","paid_amount":"598.90","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":"91067","customer_id":"91067","source_of_creation":"FE","reservation_created_date":"2019-09-06 01:45:38","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":"106.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017177","reservation_id":"77079","confirmation_number":"PB12399667658","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"145.60,129.60,129.60","nightly_discount":"0.00,0.00,15.46,0.00","subtotal":"404.80","grand_total":"439.95","paid_amount":"439.95","room_type_id":"288","product_id":"1092","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84601","customer_id":"84601","source_of_creation":"FE","reservation_created_date":"2019-05-22 01:57:07","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.60","currentDayDiscount":"15.46","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017179","reservation_id":"77079","confirmation_number":"PB12350360974","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"145.60,129.60,129.60","nightly_discount":"0.00,0.00,15.46,0.00","subtotal":"404.80","grand_total":"439.95","paid_amount":"439.95","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-05-22 01:57:07","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":"15.46","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017526","reservation_id":"82744","confirmation_number":"BV12443515569","room_stay_from":"2019-09-08","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.88,110.88","nightly_discount":"0.00,8.35,0.00","subtotal":"221.76","grand_total":"241.15","paid_amount":"241.15","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":"70531","customer_id":"70531","source_of_creation":"FE","reservation_created_date":"2019-08-16 16:56:58","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.88","currentDayDiscount":"8.35","productIsTaxExempt":false,"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":"3000086","reservation_id":"80970","confirmation_number":"PB12341456450","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","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":"0.00,0.00,0.00,0.00,0.00","subtotal":"520.00","grand_total":"587.60","paid_amount":"587.60","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"58435","customer_id":"58435","source_of_creation":"PMS","reservation_created_date":"2019-07-18 21:38:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3017196","reservation_id":"64930","confirmation_number":"BP12593347752","room_stay_from":"2019-09-07","room_stay_to":"2019-09-14","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"110.00,110.00,110.00,110.00,110.00,110.00,110.00","nightly_discount":"0.00,39.82,0.00,0.00,0.00,0.00,0.00","subtotal":"770.00","grand_total":"825.10","paid_amount":"825.10","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":"33782","customer_id":"33782","source_of_creation":"PMS","reservation_created_date":"2018-12-31 15:58:38","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3017204","reservation_id":"66228","confirmation_number":"BP12599487345","room_stay_from":"2019-09-07","room_stay_to":"2019-09-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.00,105.00,105.00,105.00,105.00,105.00,105.00","nightly_discount":"0.00,31.77,0.00,0.00,0.00,0.00,0.00","subtotal":"735.00","grand_total":"794.65","paid_amount":"794.65","room_type_id":"300","product_id":"1135","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"26029","customer_id":"26029","source_of_creation":"PMS","reservation_created_date":"2019-01-10 20:04:58","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017211","reservation_id":"70079","confirmation_number":"BP12527746922","room_stay_from":"2019-09-07","room_stay_to":"2019-09-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,114.00,114.00,94.00,94.00","nightly_discount":"0.00,39.79,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"886.00","grand_total":"956.21","paid_amount":"956.22","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":"82217","customer_id":"82217","source_of_creation":"PMS","reservation_created_date":"2019-02-22 21:28:36","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":"94.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017480","reservation_id":"56590","confirmation_number":"PB12327585879","room_stay_from":"2019-09-08","room_stay_to":"2019-09-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.00,69.00,69.00,69.00,69.00,69.00,69.00,69.00,69.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,27.60,0.00,0.00","subtotal":"621.00","grand_total":"670.54","paid_amount":"670.54","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"75193","customer_id":"75193","source_of_creation":"PMS","reservation_created_date":"2018-09-18 18:41:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017490","reservation_id":"56610","confirmation_number":"PB12399904510","room_stay_from":"2019-09-08","room_stay_to":"2019-09-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.00,69.00,69.00,69.00,69.00,69.00,69.00,69.00,69.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,31.00,0.00","subtotal":"621.00","grand_total":"666.70","paid_amount":"666.70","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":"32420","customer_id":"32420","source_of_creation":"PMS","reservation_created_date":"2018-09-18 20:53:32","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017492","reservation_id":"56596","confirmation_number":"PB12342052474","room_stay_from":"2019-09-08","room_stay_to":"2019-09-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.00,69.00,69.00,69.00,69.00,69.00,69.00,69.00,69.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,31.00,0.00","subtotal":"621.00","grand_total":"666.70","paid_amount":"666.70","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":"27863","customer_id":"27863","source_of_creation":"PMS","reservation_created_date":"2018-09-18 19:06:49","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":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017771","reservation_id":"83820","confirmation_number":"PB12341180878","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00","nightly_discount":"6.20","subtotal":"112.00","grand_total":"119.56","paid_amount":"119.56","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":"91129","customer_id":"91129","source_of_creation":"PMS","reservation_created_date":"2019-09-09 14:29:14","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":"112.00","currentDayDiscount":"6.20","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017825","reservation_id":"81336","confirmation_number":"PB12344025568","room_stay_from":"2019-09-09","room_stay_to":"2019-09-19","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,96.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,4.85,40.00,0.00,0.00,0.00","subtotal":"992.00","grand_total":"1070.28","paid_amount":"1070.28","room_type_id":"289","product_id":"1106","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"44312","customer_id":"44312","source_of_creation":"PMS","reservation_created_date":"2019-07-24 16:20:14","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":"","changedComment":"To date changed","deltaChange":"0.00","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":"3017942","reservation_id":"83857","confirmation_number":"PB12385591557","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00","nightly_discount":"6.69,0.00","subtotal":"100.00","grand_total":"105.44","paid_amount":"105.44","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91348","customer_id":"91348","source_of_creation":"PMS","reservation_created_date":"2019-09-09 23:14:14","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":"100.00","currentDayDiscount":"6.69","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017954","reservation_id":"83859","confirmation_number":"PB12377867875","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00","nightly_discount":"0.00","subtotal":"89.00","grand_total":"100.57","paid_amount":"100.57","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":"59271","customer_id":"59271","source_of_creation":"PMS","reservation_created_date":"2019-09-10 00:38:50","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":"89.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017977","reservation_id":"83864","confirmation_number":"BV12487745896","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"309","product_id":"1226","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74692","customer_id":"74692","source_of_creation":"PMS","reservation_created_date":"2019-09-10 02:50:06","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3018023","reservation_id":"83785","confirmation_number":"PB12382148568","room_stay_from":"2019-09-08","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00","nightly_discount":"0.00,0.00","subtotal":"208.00","grand_total":"235.04","paid_amount":"207.92","room_type_id":"289","product_id":"1103","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91132","customer_id":"91132","source_of_creation":"PMS","reservation_created_date":"2019-09-08 16:43:47","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3018046","reservation_id":"83570","confirmation_number":"PB12310918997","room_stay_from":"2019-09-07","room_stay_to":"2019-09-11","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"150.00,100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"450.00","grand_total":"508.50","paid_amount":"508.50","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":"90862","customer_id":"90862","source_of_creation":"PMS","reservation_created_date":"2019-09-03 15:13:37","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":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3018259","reservation_id":"56573","confirmation_number":"PB12352948646","room_stay_from":"2019-09-08","room_stay_to":"2019-09-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.00,69.00,69.00","nightly_discount":"0.00,0.00,0.00","subtotal":"207.00","grand_total":"233.91","paid_amount":"233.91","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":"27794","customer_id":"27794","source_of_creation":"PMS","reservation_created_date":"2018-09-18 13:41:35","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":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3020740","reservation_id":"81292","confirmation_number":"PB12334530932","room_stay_from":"2019-09-09","room_stay_to":"2019-09-20","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,96.00,96.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":"1088.00","grand_total":"1229.44","paid_amount":"1229.44","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":"89302","customer_id":"89302","source_of_creation":"PMS","reservation_created_date":"2019-07-23 20:36:04","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":"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":"3022754","reservation_id":"83559","confirmation_number":"PB12362554987","room_stay_from":"2019-09-08","room_stay_to":"2019-09-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00","nightly_discount":"0.00,0.00","subtotal":"228.00","grand_total":"257.64","paid_amount":"257.64","room_type_id":"291","product_id":"1117","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90098","customer_id":"90098","source_of_creation":"PMS","reservation_created_date":"2019-09-03 00:28:36","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3026133","reservation_id":"83611","confirmation_number":"PB12348454570","room_stay_from":"2019-09-08","room_stay_to":"2019-09-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"94.00,94.00,94.00","nightly_discount":"0.00,0.00,0.00","subtotal":"282.00","grand_total":"318.66","paid_amount":"318.66","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":"91017","customer_id":"91017","source_of_creation":"PMS","reservation_created_date":"2019-09-04 17:24:20","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":"94.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3028867","reservation_id":"83393","confirmation_number":"PB12358154595","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"456.00","grand_total":"515.28","paid_amount":"515.28","room_type_id":"291","product_id":"1115","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"72986","customer_id":"72986","source_of_creation":"PMS","reservation_created_date":"2019-08-29 15:18:18","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":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3030662","reservation_id":"83213","confirmation_number":"BP12562383005","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.44,76.44,76.44,76.45","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"305.77","grand_total":"345.52","paid_amount":"345.52","room_type_id":"301","product_id":"1136","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"70654","customer_id":"70654","source_of_creation":"PMS","reservation_created_date":"2019-08-25 19:37:38","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":"76.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017917","reservation_id":"67964","confirmation_number":"PB12317218224","room_stay_from":"2019-10-20","room_stay_to":"2019-10-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,164.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"734.00","grand_total":"829.42","paid_amount":"829.42","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"53778","customer_id":"53778","source_of_creation":"PMS","reservation_created_date":"2019-01-27 21:38:21","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":"","changedComment":"To 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"}]},{"room_stay_id":"3017501","reservation_id":"83782","confirmation_number":"PB12329030702","room_stay_from":"2019-09-08","room_stay_to":"2019-09-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00","nightly_discount":"5.92,0.00","subtotal":"112.00","grand_total":"119.87","paid_amount":"119.87","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":"91129","customer_id":"91129","source_of_creation":"PMS","reservation_created_date":"2019-09-08 15:46:59","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"-5.92","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2938954","reservation_id":"64930","confirmation_number":"BP12296008748","room_confirmation_number":"BP12593347752","room_stay_from":"2019-09-07","room_stay_to":"2019-09-14","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"33782","product_attribute_values":"extra_person# ","reservation_created_date":"2019-02-22 21:43:05","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"33782","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3002085","reservation_id":"81242","confirmation_number":"PB12242499981","room_confirmation_number":"PB12386675250","room_stay_from":"2019-09-06","room_stay_to":"2019-09-10","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":"1780","service_quantity":"1","customer_traveller_id":"89261","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-07-23 01:25:29","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89261","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":"3016461","reservation_id":"77079","confirmation_number":"PB12228879154","room_confirmation_number":"PB12350360974","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0,0,0","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"84601","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-09-05 12:53:44","reservation_modified_date_time":"2019-09-05 12:53:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84601","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016465","reservation_id":"77079","confirmation_number":"PB12222972399","room_confirmation_number":"PB12399667658","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0,0,0","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"84601","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-09-05 12:53:50","reservation_modified_date_time":"2019-09-05 12:53:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84601","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016735","reservation_id":"77998","confirmation_number":"BP12285176145","room_confirmation_number":"BP12576675372","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"87191","product_attribute_values":"extra_person# ","reservation_created_date":"2019-09-06 13:35:28","reservation_modified_date_time":"2019-09-06 13:35:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87191","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":"3017239","reservation_id":"82928","confirmation_number":"BP12252758818","room_confirmation_number":"BP12543312139","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"90409","product_attribute_values":"extra_person# ","reservation_created_date":"2019-09-07 20:43:18","reservation_modified_date_time":"2019-09-07 20:43:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90409","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017845","reservation_id":"82481","confirmation_number":"PB12265023907","room_confirmation_number":"PB12396776997","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"90092","product_attribute_values":"extra_person# ","reservation_created_date":"2019-09-09 17:49:48","reservation_modified_date_time":"2019-09-09 17:49:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90092","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":"3017934","reservation_id":"83783","confirmation_number":"PB12233219017","room_confirmation_number":"PB12371701361","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"91130","product_attribute_values":"extra_person# ","reservation_created_date":"2019-09-09 22:02:58","reservation_modified_date_time":"2019-09-09 22:02:58","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91130","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":"3017938","reservation_id":"83856","confirmation_number":"BP12234334325","room_confirmation_number":"BP12562568922","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"91235","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-09-09 22:16:09","reservation_modified_date_time":"2019-09-09 22:16:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91235","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":"3018047","reservation_id":"83570","confirmation_number":"PB12238140308","room_confirmation_number":"PB12310918997","room_stay_from":"2019-09-07","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0.00,0.00,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"90862","product_attribute_values":"extra_person# ","reservation_created_date":"2019-09-10 15:51:46","reservation_modified_date_time":"2019-09-10 15:51:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90862","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":"3017782","reservation_id":"83823","confirmation_number":"BP12293864862","room_confirmation_number":"BP12557510179","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-09 15:02:08","reservation_modified_date_time":"2019-09-09 15:02:08","customer_id":"91157","parentCustTravId":"91157","customer_traveller_id":"91157","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#","currentDayPrice":20,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2980380","reservation_id":"77227","confirmation_number":"PB12283771789","room_confirmation_number":"PB12382509662","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"86661","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-05-24 01:08:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"86661","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":"3000087","reservation_id":"80970","confirmation_number":"PB12223589048","room_confirmation_number":"PB12341456450","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"58435","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-18 21:38:28","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58435","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":"3002084","reservation_id":"81242","confirmation_number":"PB12262788119","room_confirmation_number":"PB12386675250","room_stay_from":"2019-09-06","room_stay_to":"2019-09-10","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":"89261","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-23 01:25:29","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89261","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":"3004383","reservation_id":"81630","confirmation_number":"PB12252276440","room_confirmation_number":"PB12351229846","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89503","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-28 22:14:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89503","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":"3004638","reservation_id":"81676","confirmation_number":"PB12226587641","room_confirmation_number":"PB12319886901","room_stay_from":"2019-09-07","room_stay_to":"2019-09-11","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":"89550","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-29 20:09:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89550","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":"3009298","reservation_id":"82422","confirmation_number":"PB12271353147","room_confirmation_number":"PB12367545368","room_stay_from":"2019-09-08","room_stay_to":"2019-09-14","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"90066","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-10 19:51:10","reservation_modified_date_time":"2019-08-10 19:51:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90066","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":"3009561","reservation_id":"82478","confirmation_number":"PB12283150790","room_confirmation_number":"PB12344278899","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","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":"90088","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-11 17:10:10","reservation_modified_date_time":"2019-08-11 17:10:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90088","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":"3012772","reservation_id":"83037","confirmation_number":"PB12269102463","room_confirmation_number":"PB12389778672","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"90490","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-22 02:55:10","reservation_modified_date_time":"2019-08-22 02:55:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90490","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":"3015461","reservation_id":"80652","confirmation_number":"PB12218001797","room_confirmation_number":"PB12386020046","room_stay_from":"2019-08-30","room_stay_to":"2019-09-13","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"280.00","grand_total":"316.40","paid_amount":"316.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"88876","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-07-13 15:30: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":"88876","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":"3016184","reservation_id":"78429","confirmation_number":"PB12294782073","room_confirmation_number":"PB12354310216","room_stay_from":"2019-09-07","room_stay_to":"2019-09-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"87498","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-10 19:24:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87498","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":"3016736","reservation_id":"77998","confirmation_number":"BP12218145517","room_confirmation_number":"BP12576675372","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","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":"87191","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-06-05 00:28:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87191","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":"3016999","reservation_id":"83688","confirmation_number":"PB12296173928","room_confirmation_number":"PB12337477871","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"91067","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-06 01:45:38","reservation_modified_date_time":"2019-09-06 23:30:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91067","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":"3017178","reservation_id":"77079","confirmation_number":"PB12262509987","room_confirmation_number":"PB12399667658","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","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":"84601","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-05-22 01:57:07","reservation_modified_date_time":"2019-09-07 16:45:58","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":"3017180","reservation_id":"77079","confirmation_number":"PB12242106760","room_confirmation_number":"PB12350360974","room_stay_from":"2019-09-07","room_stay_to":"2019-09-10","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":"84601","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-05-22 01:57:07","reservation_modified_date_time":"2019-09-07 16:48:48","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":"3017185","reservation_id":"82382","confirmation_number":"PB12213353049","room_confirmation_number":"PB12334056599","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"90041","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-10 02:53:10","reservation_modified_date_time":"2019-08-10 02:53:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90041","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":"3017197","reservation_id":"64930","confirmation_number":"BP12278469451","room_confirmation_number":"BP12593347752","room_stay_from":"2019-09-07","room_stay_to":"2019-09-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"33782","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-12-31 15:58:38","reservation_modified_date_time":"2019-09-07 18:35:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"33782","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":"3017205","reservation_id":"66228","confirmation_number":"BP12251257074","room_confirmation_number":"BP12599487345","room_stay_from":"2019-09-07","room_stay_to":"2019-09-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"26029","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-10 20:04:58","reservation_modified_date_time":"2019-09-07 18:42:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26029","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":"3017212","reservation_id":"70079","confirmation_number":"BP12246751754","room_confirmation_number":"BP12527746922","room_stay_from":"2019-09-07","room_stay_to":"2019-09-16","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"82217","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-02-22 21:28:36","reservation_modified_date_time":"2019-09-07 19:07:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82217","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":"3017240","reservation_id":"82928","confirmation_number":"BP12244897706","room_confirmation_number":"BP12543312139","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"90409","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-19 18:32:10","reservation_modified_date_time":"2019-08-19 18:32:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90409","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":"3017481","reservation_id":"56590","confirmation_number":"PB12314824300","room_confirmation_number":"PB12327585879","room_stay_from":"2019-09-08","room_stay_to":"2019-09-17","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"75193","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-09-18 18:41:20","reservation_modified_date_time":"2019-09-08 15:12:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75193","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":"3017491","reservation_id":"56610","confirmation_number":"PB12385143046","room_confirmation_number":"PB12399904510","room_stay_from":"2019-09-08","room_stay_to":"2019-09-17","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"32420","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-09-18 20:54:46","reservation_modified_date_time":"2019-09-08 15:48:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"32420","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":"3017493","reservation_id":"56596","confirmation_number":"PB12339389297","room_confirmation_number":"PB12342052474","room_stay_from":"2019-09-08","room_stay_to":"2019-09-17","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"27863","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-09-18 19:06:49","reservation_modified_date_time":"2019-09-08 15:54:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"27863","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":"3017527","reservation_id":"82744","confirmation_number":"BV12290594150","room_confirmation_number":"BV12443515569","room_stay_from":"2019-09-08","room_stay_to":"2019-09-10","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":"70531","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-16 16:56:58","reservation_modified_date_time":"2019-09-08 18:04:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70531","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":"3017679","reservation_id":"83799","confirmation_number":"BV12286464524","room_confirmation_number":"BV12410482886","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91141","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-08 23:04:10","reservation_modified_date_time":"2019-09-08 23:04:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91141","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":"3017772","reservation_id":"83820","confirmation_number":"PB12225814204","room_confirmation_number":"PB12341180878","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","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":"91129","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-09 14:29:14","reservation_modified_date_time":"2019-09-09 14:29:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91129","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":"3017826","reservation_id":"81336","confirmation_number":"PB12230942864","room_confirmation_number":"PB12344025568","room_stay_from":"2019-09-09","room_stay_to":"2019-09-19","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":"44312","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-24 16:20:14","reservation_modified_date_time":"2019-09-09 17:05:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44312","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017843","reservation_id":"82481","confirmation_number":"PB12244948571","room_confirmation_number":"PB12347825794","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.59","product_id":"1781","service_quantity":"1","customer_traveller_id":"90092","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-11 19:38:14","reservation_modified_date_time":"2019-08-11 19:38:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90092","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":"3017846","reservation_id":"82481","confirmation_number":"PB12248636189","room_confirmation_number":"PB12396776997","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","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":"90092","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-08-11 19:38:09","reservation_modified_date_time":"2019-08-11 19:38:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90092","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":"3017901","reservation_id":"83812","confirmation_number":"BP12251259815","room_confirmation_number":"BP12593492948","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","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":"91151","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-09 13:37:07","reservation_modified_date_time":"2019-09-09 13:37:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91151","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":"3017935","reservation_id":"83783","confirmation_number":"PB12281772633","room_confirmation_number":"PB12371701361","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91130","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-08 16:12:09","reservation_modified_date_time":"2019-09-08 16:12:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91130","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":"3017939","reservation_id":"83856","confirmation_number":"BP12244936112","room_confirmation_number":"BP12562568922","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","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":"91235","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-09 22:16:09","reservation_modified_date_time":"2019-09-09 22:16:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91235","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":"3017943","reservation_id":"83857","confirmation_number":"PB12247074098","room_confirmation_number":"PB12385591557","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","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":"91348","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-09 23:14:14","reservation_modified_date_time":"2019-09-09 23:14:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91348","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":"3017953","reservation_id":"83855","confirmation_number":"BP12248541963","room_confirmation_number":"BP12582874974","room_stay_from":"2019-09-09","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"91477","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-09 21:37:10","reservation_modified_date_time":"2019-09-09 21:37:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91477","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":"3017955","reservation_id":"83859","confirmation_number":"PB12238516943","room_confirmation_number":"PB12377867875","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","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":"59271","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-10 00:38:50","reservation_modified_date_time":"2019-09-10 00:52:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"59271","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":"3017978","reservation_id":"83864","confirmation_number":"BV12237024909","room_confirmation_number":"BV12487745896","room_stay_from":"2019-09-09","room_stay_to":"2019-09-10","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":"74692","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-10 02:50:06","reservation_modified_date_time":"2019-09-10 02:50:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74692","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":"3018024","reservation_id":"83785","confirmation_number":"PB12270244397","room_confirmation_number":"PB12382148568","room_stay_from":"2019-09-08","room_stay_to":"2019-09-10","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":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"91132","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-08 16:43:47","reservation_modified_date_time":"2019-09-08 16:43:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91132","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":"3018048","reservation_id":"83570","confirmation_number":"PB12257931143","room_confirmation_number":"PB12310918997","room_stay_from":"2019-09-07","room_stay_to":"2019-09-11","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":"90862","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-03 15:13:37","reservation_modified_date_time":"2019-09-03 15:13:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90862","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":"3018260","reservation_id":"56573","confirmation_number":"PB12314412011","room_confirmation_number":"PB12352948646","room_stay_from":"2019-09-08","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"27794","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2018-09-18 13:41:43","reservation_modified_date_time":"2019-09-08 14:40:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"27794","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":"3020741","reservation_id":"81292","confirmation_number":"PB12244842838","room_confirmation_number":"PB12334530932","room_stay_from":"2019-09-09","room_stay_to":"2019-09-20","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,12.00,12.00,12.00,12.00","subtotal":"132.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"89302","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-07-23 20:36:04","reservation_modified_date_time":"2019-09-18 20:03:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89302","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":"3022755","reservation_id":"83559","confirmation_number":"PB12290611066","room_confirmation_number":"PB12362554987","room_stay_from":"2019-09-08","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"39147","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-03 00:28:36","reservation_modified_date_time":"2019-09-26 15:18:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90098","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":"3026134","reservation_id":"83611","confirmation_number":"PB12259860827","room_confirmation_number":"PB12348454570","room_stay_from":"2019-09-08","room_stay_to":"2019-09-11","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"91017","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-09-04 17:24:20","reservation_modified_date_time":"2019-10-07 22:05:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91017","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":"3030663","reservation_id":"83213","confirmation_number":"BP12269726009","room_confirmation_number":"BP12562383005","room_stay_from":"2019-09-09","room_stay_to":"2019-09-13","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":"70654","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-25 19:37:38","reservation_modified_date_time":"2019-10-20 18:18:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70654","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":"3016691","reservation_id":"83688","confirmation_number":"PB12215869320","room_confirmation_number":"PB12337477871","room_stay_from":"2019-09-08","room_stay_to":"2019-09-13","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"141.25","paid_amount":"141.25","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-06 02:10:05","reservation_modified_date_time":"2019-09-06 02:10:05","customer_id":"91067","parentCustTravId":"91067","customer_traveller_id":"91067","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":"3017515","reservation_id":"82744","confirmation_number":"BV12287531250","room_confirmation_number":"BV12443515569","room_stay_from":"2019-09-08","room_stay_to":"2019-09-10","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-08 17:50:15","reservation_modified_date_time":"2019-09-08 17:50:15","customer_id":"70531","parentCustTravId":"70531","customer_traveller_id":"70531","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":"3017780","reservation_id":"83798","confirmation_number":"BV12258245657","room_confirmation_number":"BV12458726042","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.27","grand_total":"3.50","paid_amount":"3.50","product_id":"1198","service_quantity":"1","product_name":"SunBlock / Tanning Oil","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-09 14:50:51","reservation_modified_date_time":"2019-09-09 14:50:51","customer_id":"91140","parentCustTravId":"91140","customer_traveller_id":"91140","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"3.27","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3017801","reservation_id":"83213","confirmation_number":"BP12271811130","room_confirmation_number":"BP12562383005","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":"1192","service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-09 16:09:10","reservation_modified_date_time":"2019-09-09 16:09:10","customer_id":"70654","parentCustTravId":"70654","customer_traveller_id":"70654","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3017898","reservation_id":"83799","confirmation_number":"BV12239688762","room_confirmation_number":"BV12410482886","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1192","service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-09 19:42:49","reservation_modified_date_time":"2019-09-09 19:42:49","customer_id":"91141","parentCustTravId":"91141","customer_traveller_id":"91141","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3017899","reservation_id":"83799","confirmation_number":"BV12229741583","room_confirmation_number":"BV12410482886","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"26.75","paid_amount":"26.75","product_id":"1191","service_quantity":"1","product_name":"Resort Fee Car","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-09 19:42:49","reservation_modified_date_time":"2019-09-09 19:42:49","customer_id":"91141","parentCustTravId":"91141","customer_traveller_id":"91141","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3017797","reservation_id":"83826","confirmation_number":"PB12287215366","room_confirmation_number":"PB12375131772","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.26","grand_total":"3.49","paid_amount":"3.49","product_id":null,"service_quantity":"1","product_name":"Toothpaste","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-09 15:28:50","reservation_modified_date_time":"2019-09-09 15:28:50","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}