{"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1123","departureCount":3,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3016469","reservation_id":"83608","confirmation_number":"PB12347522715","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.15","nightly_discount":"0.00","subtotal":"137.15","grand_total":"154.98","paid_amount":"154.98","room_type_id":"287","product_id":"1087","siteminder_id":"BDC-3179761706","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":"91013","customer_id":"91013","source_of_creation":"Booking.com","reservation_created_date":"2019-09-04 16:50:09","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"23.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2992433","reservation_id":"79706","confirmation_number":"PB12333055103","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","room_stay_status":"Canceled","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"178.29,178.29","nightly_discount":"0,0","subtotal":"356.58","grand_total":"402.93","paid_amount":"0.00","room_type_id":"289","product_id":"1102","siteminder_id":"BDC-2446252130","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88225","customer_id":"88225","source_of_creation":"Booking.com","reservation_created_date":"2019-06-27 14:10:09","service_canceled_date_time":"2019-09-04 17:54:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"68.49","deltaChange":-356.58,"changedComment":"reservation is canceled","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":[],"exp_taxable":[{"room_stay_id":"2992143","reservation_id":"79642","confirmation_number":"PB12395688806","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"73.34,73.34,82.72","nightly_discount":"0,0,0","subtotal":"229.40","grand_total":"259.22","paid_amount":"259.22","room_type_id":"289","product_id":"1093","siteminder_id":"EXP-1286605565","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88183","customer_id":"88183","source_of_creation":"Expedia","reservation_created_date":"2019-06-26 17:59:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.34","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"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":"3015841","reservation_id":"81395","confirmation_number":"PB12374366453","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"88.01,88.01,102.72","nightly_discount":"0,0,0","subtotal":"278.74","grand_total":"314.97","paid_amount":"314.97","room_type_id":"289","product_id":"1095","siteminder_id":"EXP-1307608759","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":"89367","customer_id":"89367","source_of_creation":"Expedia","reservation_created_date":"2019-07-25 04:39:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"61.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"88.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":"3016224","reservation_id":"83590","confirmation_number":"PB12393947141","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"92.61","nightly_discount":"0","subtotal":"92.61","grand_total":"104.65","paid_amount":"104.65","room_type_id":"289","product_id":"1094","siteminder_id":"EXP-1335471050","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":"90939","customer_id":"90939","source_of_creation":"Expedia","reservation_created_date":"2019-09-04 02:41:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"92.61","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3016000","reservation_id":"83553","confirmation_number":"PB12354060539","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"56.90","nightly_discount":"0","subtotal":"56.90","grand_total":"64.29","paid_amount":"64.29","room_type_id":"290","product_id":"1113","siteminder_id":"GAM-R1643005524","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":"90849","customer_id":"90849","source_of_creation":"Getaroom.com","reservation_created_date":"2019-09-02 20:49: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":"56.90","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_non_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3015554","reservation_id":"70099","confirmation_number":"PB12377598096","room_stay_from":"2019-08-31","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"208.00,158.00,158.00,111.00,111.00,111.00,131.00","nightly_discount":"0.00,42.76,0.00,0.00,0.00,0.00,0.00","subtotal":"988.00","grand_total":"1068.12","paid_amount":"1068.12","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":"82221","customer_id":"82221","source_of_creation":"FE","reservation_created_date":"2019-02-22 23:19:06","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":"111.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3015822","reservation_id":"78799","confirmation_number":"PB12393584018","room_stay_from":"2019-09-01","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.80,212.80,160.80,160.80,160.80,176.80","nightly_discount":"0.00,47.54,0.00,0.00,0.00,0.00","subtotal":"1084.80","grand_total":"1172.11","paid_amount":"1172.11","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":"87746","customer_id":"87746","source_of_creation":"FE","reservation_created_date":"2019-06-16 18:16:07","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":"3016308","reservation_id":"82992","confirmation_number":"PB12370368831","room_stay_from":"2019-10-07","room_stay_to":"2019-10-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"536.00","grand_total":"605.68","paid_amount":"605.68","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":"65891","customer_id":"65891","source_of_creation":"FE","reservation_created_date":"2019-08-21 11:22:41","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":"","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"}]}],"fe_non_taxable":[{"room_stay_id":"3003661","reservation_id":"81543","confirmation_number":"PB12317593327","room_stay_from":"2019-09-04","room_stay_to":"2019-09-06","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.80,128.80","nightly_discount":"0.00,0.00","subtotal":"257.60","grand_total":"291.09","paid_amount":"145.55","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":"89445","customer_id":"89445","source_of_creation":"FE","reservation_created_date":"2019-07-27 15:30:35","service_canceled_date_time":"2019-08-29 19:08:11","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"145.55","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3015577","reservation_id":"81599","confirmation_number":"PB12351485814","room_stay_from":"2019-08-31","room_stay_to":"2019-09-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.25,135.75,144.80,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"765.80","grand_total":"865.36","paid_amount":"865.36","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":"70223","customer_id":"70223","source_of_creation":"PMS","reservation_created_date":"2019-07-28 13:59:39","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":"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":"3016265","reservation_id":"83600","confirmation_number":"PB12348247842","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,120.00","nightly_discount":"0.00,0.00,0.00","subtotal":"308.00","grand_total":"348.04","paid_amount":"348.04","room_type_id":"289","product_id":"1105","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90946","customer_id":"90946","source_of_creation":"PMS","reservation_created_date":"2019-09-04 13:47:19","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3016384","reservation_id":"83619","confirmation_number":"PB12371532306","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.00","nightly_discount":"0.00","subtotal":"102.00","grand_total":"115.26","paid_amount":"115.26","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":"91022","customer_id":"91022","source_of_creation":"PMS","reservation_created_date":"2019-09-04 21:48:54","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"102.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017623","reservation_id":"82580","confirmation_number":"PB12396833898","room_stay_from":"2019-09-02","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"66.27,66.27,66.29","nightly_discount":"0.00,0.00,0.00","subtotal":"198.83","grand_total":"224.68","paid_amount":"224.68","room_type_id":"289","product_id":"1101","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"29326","customer_id":"29326","source_of_creation":"PMS","reservation_created_date":"2019-08-13 17:10:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"66.29","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3030664","reservation_id":"83439","confirmation_number":"PB12389315719","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.04","nightly_discount":"0.00","subtotal":"62.04","grand_total":"70.10","paid_amount":"70.10","room_type_id":"294","product_id":"1125","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"75498","customer_id":"75498","source_of_creation":"PMS","reservation_created_date":"2019-08-30 15:36:32","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.04","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2992144","reservation_id":"79642","confirmation_number":"PB12222266529","room_confirmation_number":"PB12395688806","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"88183","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-26 17:59: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":"88183","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":"3016225","reservation_id":"83590","confirmation_number":"PB12257651266","room_confirmation_number":"PB12393947141","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"90939","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-04 02:41:06","reservation_modified_date_time":"2019-09-04 02:41:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90939","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":"2992434","reservation_id":"79706","confirmation_number":"PB12267016069","room_confirmation_number":"PB12333055103","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","room_stay_status":"Canceled","nightly_price":"30,30","nightly_discount":"0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"0.00","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-27 14:10:09","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"88225","parentCustTravId":"88225","customer_traveller_id":"88225","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-09-04 17:54:08","canceled_nights_data":"","product_attribute_values":"extra_person#&#10.00","deltaChange":-60,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2992145","reservation_id":"79642","confirmation_number":"PB12248712050","room_confirmation_number":"PB12395688806","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88183","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-26 17:59: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":"88183","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":"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#&#20","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":"3015555","reservation_id":"70099","confirmation_number":"PB12244127121","room_confirmation_number":"PB12377598096","room_stay_from":"2019-08-31","room_stay_to":"2019-09-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"82221","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-22 23:19:06","reservation_modified_date_time":"2019-08-31 16:13:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82221","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":"3015578","reservation_id":"81599","confirmation_number":"PB12278431018","room_confirmation_number":"PB12351485814","room_stay_from":"2019-08-31","room_stay_to":"2019-09-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"70223","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-28 13:59:39","reservation_modified_date_time":"2019-08-30 21:32:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70223","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":"3015823","reservation_id":"78799","confirmation_number":"PB12237776272","room_confirmation_number":"PB12393584018","room_stay_from":"2019-09-01","room_stay_to":"2019-09-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"87746","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-16 18:16:07","reservation_modified_date_time":"2019-09-01 16:12:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87746","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":"3015842","reservation_id":"81395","confirmation_number":"PB12253567780","room_confirmation_number":"PB12374366453","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"89367","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-25 04:39:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89367","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":"3016001","reservation_id":"83553","confirmation_number":"PB12296695411","room_confirmation_number":"PB12354060539","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","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":"90849","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-02 20:49:08","reservation_modified_date_time":"2019-09-02 20:49:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90849","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":"3016226","reservation_id":"83590","confirmation_number":"PB12299615472","room_confirmation_number":"PB12393947141","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","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":"90939","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-04 02:41:06","reservation_modified_date_time":"2019-09-04 02:41:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90939","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":"3016266","reservation_id":"83600","confirmation_number":"PB12210178582","room_confirmation_number":"PB12348247842","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"90946","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-04 13:47:19","reservation_modified_date_time":"2019-09-04 13:47:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90946","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":"3016385","reservation_id":"83619","confirmation_number":"PB12270706907","room_confirmation_number":"PB12371532306","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","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":"91022","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-04 21:48:54","reservation_modified_date_time":"2019-09-04 21:48:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91022","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":"3016470","reservation_id":"83608","confirmation_number":"PB12212243818","room_confirmation_number":"PB12347522715","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","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":"91013","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-04 16:50:09","reservation_modified_date_time":"2019-09-05 13:23:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91013","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":"2992435","reservation_id":"79706","confirmation_number":"PB12299657856","room_confirmation_number":"PB12333055103","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","room_stay_status":"Canceled","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-27 14:10:09","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"88225","parentCustTravId":"88225","customer_traveller_id":"88225","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-09-04 17:54:08","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#20","deltaChange":-40,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":1,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_non_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3016310","reservation_id":"83606","confirmation_number":"BV12478026964","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.08","nightly_discount":"0","subtotal":"62.08","grand_total":"81.00","paid_amount":"81.00","room_type_id":"303","product_id":"1140","siteminder_id":"ABB-HMAR4Z59JE","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"62.08","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91004","customer_id":"91004","source_of_creation":"Airbnb","reservation_created_date":"2019-09-04 16:21:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"8.68","commision_charges":"1.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.08","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3016391","reservation_id":"81361","confirmation_number":"BV12467801605","room_stay_from":"2019-09-04","room_stay_to":"2019-09-08","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"75.20,75.20,91.20,91.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"332.80","grand_total":"376.07","paid_amount":"376.07","room_type_id":"289","product_id":"1109","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89354","customer_id":"89354","source_of_creation":"FE","reservation_created_date":"2019-07-24 21:33:16","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":"75.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":"3014785","reservation_id":"83331","confirmation_number":"BV12473860313","room_stay_from":"2019-08-28","room_stay_to":"2019-08-29","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.31","nightly_discount":"0.00","subtotal":"71.31","grand_total":"80.58","paid_amount":"0.00","room_type_id":"305","product_id":"1222","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"77895","customer_id":"77895","source_of_creation":"FE","reservation_created_date":"2019-08-28 07:02:57","service_canceled_date_time":"2019-09-04 13:01:42","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":-71.31,"changedComment":"reservation is canceled","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_taxable":[{"room_stay_id":"3016374","reservation_id":"81602","confirmation_number":"BV12422416409","room_stay_from":"2019-09-03","room_stay_to":"2019-09-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.48,60.48,60.48,83.20,83.20,60.48","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"408.32","grand_total":"461.40","paid_amount":"461.40","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":"89478","customer_id":"89478","source_of_creation":"PMS","reservation_created_date":"2019-09-03 13:00:44","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":"60.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3016392","reservation_id":"81361","confirmation_number":"BV12257102802","room_confirmation_number":"BV12467801605","room_stay_from":"2019-09-04","room_stay_to":"2019-09-08","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"89354","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-09-04 22:41:11","reservation_modified_date_time":"2019-09-04 22:41:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89354","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":"3016311","reservation_id":"83606","confirmation_number":"BV12297574863","room_confirmation_number":"BV12478026964","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","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":"91004","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-04 16:21:09","reservation_modified_date_time":"2019-09-04 16:21:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91004","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":"3016375","reservation_id":"81602","confirmation_number":"BV12297149480","room_confirmation_number":"BV12422416409","room_stay_from":"2019-09-03","room_stay_to":"2019-09-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"89478","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-03 13:00:44","reservation_modified_date_time":"2019-09-04 19:51:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89478","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"12.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016393","reservation_id":"81361","confirmation_number":"BV12294640065","room_confirmation_number":"BV12467801605","room_stay_from":"2019-09-04","room_stay_to":"2019-09-08","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":"89354","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-24 21:33:16","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89354","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":"3016377","reservation_id":"81602","confirmation_number":"BV12255178846","room_confirmation_number":"BV12476888636","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89478","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-03 13:00:44","reservation_modified_date_time":"2019-09-04 19:53:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89478","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"12.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":"3014786","reservation_id":"83331","confirmation_number":"BV12287642524","room_confirmation_number":"BV12473860313","room_stay_from":"2019-08-28","room_stay_to":"2019-08-29","room_stay_status":"Canceled","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-28 07:02:57","reservation_modified_date_time":"2019-08-28 07:02:57","customer_id":"77895","parentCustTravId":"77895","customer_traveller_id":"77895","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-09-04 13:01:42","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#12","deltaChange":-12,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3016328","reservation_id":"83609","confirmation_number":"BV12218905048","room_confirmation_number":"BV12482463341","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":"84.75","paid_amount":"84.75","product_id":"1146","service_quantity":"3","product_name":"Boat Dockage","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-04 16:57:35","reservation_modified_date_time":"2019-09-04 16:57:35","customer_id":"84963","parentCustTravId":"84963","customer_traveller_id":"84963","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":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3016329","reservation_id":"83609","confirmation_number":"BV12226268561","room_confirmation_number":"BV12482463341","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":"33.90","paid_amount":"33.90","product_id":"1147","service_quantity":"3","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-04 16:57:35","reservation_modified_date_time":"2019-09-04 16:57:35","customer_id":"84963","parentCustTravId":"84963","customer_traveller_id":"84963","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":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3016397","reservation_id":"81361","confirmation_number":"PB12232595203","room_confirmation_number":"BV12467801605","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":"113.00","paid_amount":"113.00","product_id":"1212","service_quantity":"4","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-04 22:42:24","reservation_modified_date_time":"2019-09-04 22:42:24","customer_id":"89354","parentCustTravId":"89354","customer_traveller_id":"89354","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":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":3,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3015426","reservation_id":"83215","confirmation_number":"BP12520137653","room_stay_from":"2019-09-03","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"105.30,95.47","nightly_discount":"0.00,0.00","subtotal":"200.77","grand_total":"226.87","paid_amount":"226.87","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-2832017506","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":"90609","customer_id":"90609","source_of_creation":"Booking.com","reservation_created_date":"2019-08-25 20:55:10","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"24.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.47","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3016406","reservation_id":"83596","confirmation_number":"BP12552977157","room_stay_from":"2019-09-04","room_stay_to":"2019-09-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.23,89.23","nightly_discount":"0.00,0.00","subtotal":"178.46","grand_total":"201.66","paid_amount":"201.66","room_type_id":"300","product_id":"1135","siteminder_id":"EXP-1335687085","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":"90943","customer_id":"90943","source_of_creation":"Expedia","reservation_created_date":"2019-09-04 12:17:10","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":"89.23","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3016402","reservation_id":"83624","confirmation_number":"BP12539862616","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"39.49","nightly_discount":"0","subtotal":"39.49","grand_total":"44.62","paid_amount":"44.62","room_type_id":"299","product_id":"1134","siteminder_id":"HWR-300842674","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":"91024","customer_id":"91024","source_of_creation":"Hotwire","reservation_created_date":"2019-09-04 23:03:12","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"39.49","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3015701","reservation_id":"83504","confirmation_number":"BP12535765318","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"131.62,119.34,105.12,105.12","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"461.20","grand_total":"521.15","paid_amount":"521.15","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":"90805","customer_id":"90805","source_of_creation":"FE","reservation_created_date":"2019-09-01 12:39:43","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"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_taxable":[{"room_stay_id":"3015558","reservation_id":"83369","confirmation_number":"BP12513056132","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.31,131.62,140.40,105.12","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"588.45","grand_total":"664.95","paid_amount":"664.95","room_type_id":"296","product_id":"1130","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"66287","customer_id":"66287","source_of_creation":"PMS","reservation_created_date":"2019-08-28 23:52:59","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016090","reservation_id":"83563","confirmation_number":"BP12513484758","room_stay_from":"2019-09-03","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.00,62.00","nightly_discount":"0.00,7.39,0.00","subtotal":"124.00","grand_total":"131.77","paid_amount":"131.77","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":"90858","customer_id":"90858","source_of_creation":"PMS","reservation_created_date":"2019-09-03 12:56:58","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.00","currentDayDiscount":"7.39","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016737","reservation_id":"83621","confirmation_number":"BP12526755610","room_stay_from":"2019-09-04","room_stay_to":"2019-09-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.00,60.00,60.00,60.00,60.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"300.00","grand_total":"339.00","paid_amount":"339.00","room_type_id":"295","product_id":"1128","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"67440","customer_id":"67440","source_of_creation":"PMS","reservation_created_date":"2019-09-04 22:41:22","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"60.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016894","reservation_id":"83612","confirmation_number":"BP12522388969","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.76,67.76,63.15","nightly_discount":"3.98,8.08,0.00","subtotal":"198.67","grand_total":"210.87","paid_amount":"210.87","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91015","customer_id":"91015","source_of_creation":"PMS","reservation_created_date":"2019-09-04 17:29:46","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":"67.76","currentDayDiscount":"3.98","productIsTaxExempt":false,"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":"3015427","reservation_id":"83215","confirmation_number":"BP12230599053","room_confirmation_number":"BP12520137653","room_stay_from":"2019-09-03","room_stay_to":"2019-09-05","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"90609","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-08-30 21:46:12","reservation_modified_date_time":"2019-08-30 21:46:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90609","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":"3015703","reservation_id":"83504","confirmation_number":"BP12267829499","room_confirmation_number":"BP12535765318","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,10.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"90805","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-01 12:39:43","reservation_modified_date_time":"2019-09-01 12:39:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90805","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3015428","reservation_id":"83215","confirmation_number":"BP12294527503","room_confirmation_number":"BP12520137653","room_stay_from":"2019-09-03","room_stay_to":"2019-09-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"90609","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-25 20:55:10","reservation_modified_date_time":"2019-08-30 21:44:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90609","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":"3015559","reservation_id":"83369","confirmation_number":"BP12294922093","room_confirmation_number":"BP12513056132","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","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":"66287","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-28 23:52:59","reservation_modified_date_time":"2019-08-28 23:52:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66287","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":"3015702","reservation_id":"83504","confirmation_number":"BP12251094011","room_confirmation_number":"BP12535765318","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","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":"90805","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-01 12:39:43","reservation_modified_date_time":"2019-09-01 12:39:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90805","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":"3016091","reservation_id":"83563","confirmation_number":"BP12266426287","room_confirmation_number":"BP12513484758","room_stay_from":"2019-09-03","room_stay_to":"2019-09-05","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"90858","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-03 12:56:58","reservation_modified_date_time":"2019-09-03 13:03:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90858","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":"3016403","reservation_id":"83624","confirmation_number":"BP12248842194","room_confirmation_number":"BP12539862616","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","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":"91024","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-04 23:03:12","reservation_modified_date_time":"2019-09-04 23:03:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91024","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":"3016408","reservation_id":"83596","confirmation_number":"BP12239212043","room_confirmation_number":"BP12552977157","room_stay_from":"2019-09-04","room_stay_to":"2019-09-06","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"90943","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-04 12:17:10","reservation_modified_date_time":"2019-09-04 23:49:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90943","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":"3016738","reservation_id":"83621","confirmation_number":"BP12232615213","room_confirmation_number":"BP12526755610","room_stay_from":"2019-09-04","room_stay_to":"2019-09-09","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":"67440","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-04 22:41:22","reservation_modified_date_time":"2019-09-04 22:41:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"67440","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":"3016895","reservation_id":"83612","confirmation_number":"BP12288473440","room_confirmation_number":"BP12522388969","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"90593","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-04 17:29:46","reservation_modified_date_time":"2019-09-06 19:07:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91015","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3016256","reservation_id":"83592","confirmation_number":"BP12286620648","room_confirmation_number":"BP12586941863","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":"28.25","paid_amount":"0.00","product_id":"1146","service_quantity":"1","product_name":"Boat Dockage","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-04 12:37:15","reservation_modified_date_time":"2019-09-04 12:37:15","customer_id":"90941","parentCustTravId":"90941","customer_traveller_id":"90941","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","canceled_nights_data":"","product_attribute_values":null,"currentDayPrice":25,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3016395","reservation_id":"83621","confirmation_number":"BP12236061370","room_confirmation_number":"BP12526755610","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-04 22:41:22","reservation_modified_date_time":"2019-09-04 22:41:22","customer_id":"67440","parentCustTravId":"67440","customer_traveller_id":"67440","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2019-09-04","total_rooms_exist":66,"departureCount":7,"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":"3015426","reservation_id":"83215","confirmation_number":"BP12520137653","room_stay_from":"2019-09-03","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"105.30,95.47","nightly_discount":"0.00,0.00","subtotal":"200.77","grand_total":"226.87","paid_amount":"226.87","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-2832017506","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":"90609","customer_id":"90609","source_of_creation":"Booking.com","reservation_created_date":"2019-08-25 20:55:10","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"24.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.47","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016469","reservation_id":"83608","confirmation_number":"PB12347522715","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.15","nightly_discount":"0.00","subtotal":"137.15","grand_total":"154.98","paid_amount":"154.98","room_type_id":"287","product_id":"1087","siteminder_id":"BDC-3179761706","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":"91013","customer_id":"91013","source_of_creation":"Booking.com","reservation_created_date":"2019-09-04 16:50:09","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"23.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2992433","reservation_id":"79706","confirmation_number":"PB12333055103","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","room_stay_status":"Canceled","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"178.29,178.29","nightly_discount":"0,0","subtotal":"356.58","grand_total":"402.93","paid_amount":"0.00","room_type_id":"289","product_id":"1102","siteminder_id":"BDC-2446252130","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88225","customer_id":"88225","source_of_creation":"Booking.com","reservation_created_date":"2019-06-27 14:10:09","service_canceled_date_time":"2019-09-04 17:54:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"68.49","deltaChange":-356.58,"changedComment":"reservation is canceled","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":[],"exp_taxable":[{"room_stay_id":"2992143","reservation_id":"79642","confirmation_number":"PB12395688806","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"73.34,73.34,82.72","nightly_discount":"0,0,0","subtotal":"229.40","grand_total":"259.22","paid_amount":"259.22","room_type_id":"289","product_id":"1093","siteminder_id":"EXP-1286605565","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88183","customer_id":"88183","source_of_creation":"Expedia","reservation_created_date":"2019-06-26 17:59:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.34","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"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":"3015841","reservation_id":"81395","confirmation_number":"PB12374366453","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"88.01,88.01,102.72","nightly_discount":"0,0,0","subtotal":"278.74","grand_total":"314.97","paid_amount":"314.97","room_type_id":"289","product_id":"1095","siteminder_id":"EXP-1307608759","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":"89367","customer_id":"89367","source_of_creation":"Expedia","reservation_created_date":"2019-07-25 04:39:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"61.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"88.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":"3016224","reservation_id":"83590","confirmation_number":"PB12393947141","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"92.61","nightly_discount":"0","subtotal":"92.61","grand_total":"104.65","paid_amount":"104.65","room_type_id":"289","product_id":"1094","siteminder_id":"EXP-1335471050","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":"90939","customer_id":"90939","source_of_creation":"Expedia","reservation_created_date":"2019-09-04 02:41:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"92.61","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016406","reservation_id":"83596","confirmation_number":"BP12552977157","room_stay_from":"2019-09-04","room_stay_to":"2019-09-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.23,89.23","nightly_discount":"0.00,0.00","subtotal":"178.46","grand_total":"201.66","paid_amount":"201.66","room_type_id":"300","product_id":"1135","siteminder_id":"EXP-1335687085","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":"90943","customer_id":"90943","source_of_creation":"Expedia","reservation_created_date":"2019-09-04 12:17:10","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":"89.23","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3016000","reservation_id":"83553","confirmation_number":"PB12354060539","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"56.90","nightly_discount":"0","subtotal":"56.90","grand_total":"64.29","paid_amount":"64.29","room_type_id":"290","product_id":"1113","siteminder_id":"GAM-R1643005524","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":"90849","customer_id":"90849","source_of_creation":"Getaroom.com","reservation_created_date":"2019-09-02 20:49: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":"56.90","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3016310","reservation_id":"83606","confirmation_number":"BV12478026964","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.08","nightly_discount":"0","subtotal":"62.08","grand_total":"81.00","paid_amount":"81.00","room_type_id":"303","product_id":"1140","siteminder_id":"ABB-HMAR4Z59JE","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"62.08","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91004","customer_id":"91004","source_of_creation":"Airbnb","reservation_created_date":"2019-09-04 16:21:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"8.68","commision_charges":"1.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.08","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3016402","reservation_id":"83624","confirmation_number":"BP12539862616","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"39.49","nightly_discount":"0","subtotal":"39.49","grand_total":"44.62","paid_amount":"44.62","room_type_id":"299","product_id":"1134","siteminder_id":"HWR-300842674","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":"91024","customer_id":"91024","source_of_creation":"Hotwire","reservation_created_date":"2019-09-04 23:03:12","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"39.49","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3015554","reservation_id":"70099","confirmation_number":"PB12377598096","room_stay_from":"2019-08-31","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"208.00,158.00,158.00,111.00,111.00,111.00,131.00","nightly_discount":"0.00,42.76,0.00,0.00,0.00,0.00,0.00","subtotal":"988.00","grand_total":"1068.12","paid_amount":"1068.12","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":"82221","customer_id":"82221","source_of_creation":"FE","reservation_created_date":"2019-02-22 23:19:06","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":"111.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3015701","reservation_id":"83504","confirmation_number":"BP12535765318","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"131.62,119.34,105.12,105.12","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"461.20","grand_total":"521.15","paid_amount":"521.15","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":"90805","customer_id":"90805","source_of_creation":"FE","reservation_created_date":"2019-09-01 12:39:43","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3015822","reservation_id":"78799","confirmation_number":"PB12393584018","room_stay_from":"2019-09-01","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.80,212.80,160.80,160.80,160.80,176.80","nightly_discount":"0.00,47.54,0.00,0.00,0.00,0.00","subtotal":"1084.80","grand_total":"1172.11","paid_amount":"1172.11","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":"87746","customer_id":"87746","source_of_creation":"FE","reservation_created_date":"2019-06-16 18:16:07","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":"3016391","reservation_id":"81361","confirmation_number":"BV12467801605","room_stay_from":"2019-09-04","room_stay_to":"2019-09-08","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"75.20,75.20,91.20,91.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"332.80","grand_total":"376.07","paid_amount":"376.07","room_type_id":"289","product_id":"1109","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89354","customer_id":"89354","source_of_creation":"FE","reservation_created_date":"2019-07-24 21:33:16","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":"75.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":"3016308","reservation_id":"82992","confirmation_number":"PB12370368831","room_stay_from":"2019-10-07","room_stay_to":"2019-10-12","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.00,104.00,104.00,104.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"536.00","grand_total":"605.68","paid_amount":"605.68","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":"65891","customer_id":"65891","source_of_creation":"FE","reservation_created_date":"2019-08-21 11:22:41","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":"","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":"3014785","reservation_id":"83331","confirmation_number":"BV12473860313","room_stay_from":"2019-08-28","room_stay_to":"2019-08-29","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.31","nightly_discount":"0.00","subtotal":"71.31","grand_total":"80.58","paid_amount":"0.00","room_type_id":"305","product_id":"1222","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"77895","customer_id":"77895","source_of_creation":"FE","reservation_created_date":"2019-08-28 07:02:57","service_canceled_date_time":"2019-09-04 13:01:42","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":-71.31,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[{"room_stay_id":"3003661","reservation_id":"81543","confirmation_number":"PB12317593327","room_stay_from":"2019-09-04","room_stay_to":"2019-09-06","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.80,128.80","nightly_discount":"0.00,0.00","subtotal":"257.60","grand_total":"291.09","paid_amount":"145.55","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":"89445","customer_id":"89445","source_of_creation":"FE","reservation_created_date":"2019-07-27 15:30:35","service_canceled_date_time":"2019-08-29 19:08:11","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"145.55","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3015558","reservation_id":"83369","confirmation_number":"BP12513056132","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.31,131.62,140.40,105.12","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"588.45","grand_total":"664.95","paid_amount":"664.95","room_type_id":"296","product_id":"1130","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"66287","customer_id":"66287","source_of_creation":"PMS","reservation_created_date":"2019-08-28 23:52:59","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3015577","reservation_id":"81599","confirmation_number":"PB12351485814","room_stay_from":"2019-08-31","room_stay_to":"2019-09-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.25,135.75,144.80,104.00,104.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"765.80","grand_total":"865.36","paid_amount":"865.36","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":"70223","customer_id":"70223","source_of_creation":"PMS","reservation_created_date":"2019-07-28 13:59:39","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":"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":"3016090","reservation_id":"83563","confirmation_number":"BP12513484758","room_stay_from":"2019-09-03","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.00,62.00","nightly_discount":"0.00,7.39,0.00","subtotal":"124.00","grand_total":"131.77","paid_amount":"131.77","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":"90858","customer_id":"90858","source_of_creation":"PMS","reservation_created_date":"2019-09-03 12:56:58","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.00","currentDayDiscount":"7.39","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016265","reservation_id":"83600","confirmation_number":"PB12348247842","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,120.00","nightly_discount":"0.00,0.00,0.00","subtotal":"308.00","grand_total":"348.04","paid_amount":"348.04","room_type_id":"289","product_id":"1105","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90946","customer_id":"90946","source_of_creation":"PMS","reservation_created_date":"2019-09-04 13:47:19","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3016374","reservation_id":"81602","confirmation_number":"BV12422416409","room_stay_from":"2019-09-03","room_stay_to":"2019-09-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.48,60.48,60.48,83.20,83.20,60.48","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"408.32","grand_total":"461.40","paid_amount":"461.40","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":"89478","customer_id":"89478","source_of_creation":"PMS","reservation_created_date":"2019-09-03 13:00:44","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":"60.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016384","reservation_id":"83619","confirmation_number":"PB12371532306","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.00","nightly_discount":"0.00","subtotal":"102.00","grand_total":"115.26","paid_amount":"115.26","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":"91022","customer_id":"91022","source_of_creation":"PMS","reservation_created_date":"2019-09-04 21:48:54","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"102.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016737","reservation_id":"83621","confirmation_number":"BP12526755610","room_stay_from":"2019-09-04","room_stay_to":"2019-09-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.00,60.00,60.00,60.00,60.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"300.00","grand_total":"339.00","paid_amount":"339.00","room_type_id":"295","product_id":"1128","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"67440","customer_id":"67440","source_of_creation":"PMS","reservation_created_date":"2019-09-04 22:41:22","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"60.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016894","reservation_id":"83612","confirmation_number":"BP12522388969","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.76,67.76,63.15","nightly_discount":"3.98,8.08,0.00","subtotal":"198.67","grand_total":"210.87","paid_amount":"210.87","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91015","customer_id":"91015","source_of_creation":"PMS","reservation_created_date":"2019-09-04 17:29:46","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":"67.76","currentDayDiscount":"3.98","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3017623","reservation_id":"82580","confirmation_number":"PB12396833898","room_stay_from":"2019-09-02","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"66.27,66.27,66.29","nightly_discount":"0.00,0.00,0.00","subtotal":"198.83","grand_total":"224.68","paid_amount":"224.68","room_type_id":"289","product_id":"1101","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"29326","customer_id":"29326","source_of_creation":"PMS","reservation_created_date":"2019-08-13 17:10:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"66.29","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3030664","reservation_id":"83439","confirmation_number":"PB12389315719","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.04","nightly_discount":"0.00","subtotal":"62.04","grand_total":"70.10","paid_amount":"70.10","room_type_id":"294","product_id":"1125","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"75498","customer_id":"75498","source_of_creation":"PMS","reservation_created_date":"2019-08-30 15:36:32","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.04","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2992144","reservation_id":"79642","confirmation_number":"PB12222266529","room_confirmation_number":"PB12395688806","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"88183","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-06-26 17:59: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":"88183","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":"3015427","reservation_id":"83215","confirmation_number":"BP12230599053","room_confirmation_number":"BP12520137653","room_stay_from":"2019-09-03","room_stay_to":"2019-09-05","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"90609","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-08-30 21:46:12","reservation_modified_date_time":"2019-08-30 21:46:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90609","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":"3015703","reservation_id":"83504","confirmation_number":"BP12267829499","room_confirmation_number":"BP12535765318","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,10.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"90805","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-01 12:39:43","reservation_modified_date_time":"2019-09-01 12:39:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90805","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016225","reservation_id":"83590","confirmation_number":"PB12257651266","room_confirmation_number":"PB12393947141","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"90939","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-09-04 02:41:06","reservation_modified_date_time":"2019-09-04 02:41:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90939","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":"3016392","reservation_id":"81361","confirmation_number":"BV12257102802","room_confirmation_number":"BV12467801605","room_stay_from":"2019-09-04","room_stay_to":"2019-09-08","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"89354","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-09-04 22:41:11","reservation_modified_date_time":"2019-09-04 22:41:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89354","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":"2992434","reservation_id":"79706","confirmation_number":"PB12267016069","room_confirmation_number":"PB12333055103","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","room_stay_status":"Canceled","nightly_price":"30,30","nightly_discount":"0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"0.00","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-27 14:10:09","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"88225","parentCustTravId":"88225","customer_traveller_id":"88225","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-09-04 17:54:08","canceled_nights_data":"","product_attribute_values":"extra_person#&#10.00","deltaChange":-60,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2992145","reservation_id":"79642","confirmation_number":"PB12248712050","room_confirmation_number":"PB12395688806","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"88183","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-26 17:59: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":"88183","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":"3015428","reservation_id":"83215","confirmation_number":"BP12294527503","room_confirmation_number":"BP12520137653","room_stay_from":"2019-09-03","room_stay_to":"2019-09-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"90609","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-25 20:55:10","reservation_modified_date_time":"2019-08-30 21:44:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90609","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":"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#&#20","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":"3015555","reservation_id":"70099","confirmation_number":"PB12244127121","room_confirmation_number":"PB12377598096","room_stay_from":"2019-08-31","room_stay_to":"2019-09-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"82221","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-22 23:19:06","reservation_modified_date_time":"2019-08-31 16:13:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"82221","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":"3015559","reservation_id":"83369","confirmation_number":"BP12294922093","room_confirmation_number":"BP12513056132","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","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":"66287","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-28 23:52:59","reservation_modified_date_time":"2019-08-28 23:52:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66287","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":"3015578","reservation_id":"81599","confirmation_number":"PB12278431018","room_confirmation_number":"PB12351485814","room_stay_from":"2019-08-31","room_stay_to":"2019-09-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"70223","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-28 13:59:39","reservation_modified_date_time":"2019-08-30 21:32:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70223","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":"3015702","reservation_id":"83504","confirmation_number":"BP12251094011","room_confirmation_number":"BP12535765318","room_stay_from":"2019-09-01","room_stay_to":"2019-09-05","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":"90805","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-01 12:39:43","reservation_modified_date_time":"2019-09-01 12:39:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90805","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":"3015823","reservation_id":"78799","confirmation_number":"PB12237776272","room_confirmation_number":"PB12393584018","room_stay_from":"2019-09-01","room_stay_to":"2019-09-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"87746","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-16 18:16:07","reservation_modified_date_time":"2019-09-01 16:12:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87746","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":"3015842","reservation_id":"81395","confirmation_number":"PB12253567780","room_confirmation_number":"PB12374366453","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"89367","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-25 04:39:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89367","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":"3016001","reservation_id":"83553","confirmation_number":"PB12296695411","room_confirmation_number":"PB12354060539","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","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":"90849","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-02 20:49:08","reservation_modified_date_time":"2019-09-02 20:49:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90849","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":"3016091","reservation_id":"83563","confirmation_number":"BP12266426287","room_confirmation_number":"BP12513484758","room_stay_from":"2019-09-03","room_stay_to":"2019-09-05","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"90858","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-03 12:56:58","reservation_modified_date_time":"2019-09-03 13:03:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90858","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":"3016226","reservation_id":"83590","confirmation_number":"PB12299615472","room_confirmation_number":"PB12393947141","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","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":"90939","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-04 02:41:06","reservation_modified_date_time":"2019-09-04 02:41:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90939","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":"3016266","reservation_id":"83600","confirmation_number":"PB12210178582","room_confirmation_number":"PB12348247842","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"90946","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-04 13:47:19","reservation_modified_date_time":"2019-09-04 13:47:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90946","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":"3016311","reservation_id":"83606","confirmation_number":"BV12297574863","room_confirmation_number":"BV12478026964","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","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":"91004","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-04 16:21:09","reservation_modified_date_time":"2019-09-04 16:21:09","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91004","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":"3016375","reservation_id":"81602","confirmation_number":"BV12297149480","room_confirmation_number":"BV12422416409","room_stay_from":"2019-09-03","room_stay_to":"2019-09-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"89478","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-03 13:00:44","reservation_modified_date_time":"2019-09-04 19:51:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89478","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"12.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3016385","reservation_id":"83619","confirmation_number":"PB12270706907","room_confirmation_number":"PB12371532306","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","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":"91022","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-04 21:48:54","reservation_modified_date_time":"2019-09-04 21:48:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91022","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":"3016393","reservation_id":"81361","confirmation_number":"BV12294640065","room_confirmation_number":"BV12467801605","room_stay_from":"2019-09-04","room_stay_to":"2019-09-08","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":"89354","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-07-24 21:33:16","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89354","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":"3016403","reservation_id":"83624","confirmation_number":"BP12248842194","room_confirmation_number":"BP12539862616","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","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":"91024","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-04 23:03:12","reservation_modified_date_time":"2019-09-04 23:03:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91024","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":"3016408","reservation_id":"83596","confirmation_number":"BP12239212043","room_confirmation_number":"BP12552977157","room_stay_from":"2019-09-04","room_stay_to":"2019-09-06","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"90943","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-04 12:17:10","reservation_modified_date_time":"2019-09-04 23:49:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90943","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":"3016470","reservation_id":"83608","confirmation_number":"PB12212243818","room_confirmation_number":"PB12347522715","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","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":"91013","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-04 16:50:09","reservation_modified_date_time":"2019-09-05 13:23:39","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91013","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":"3016738","reservation_id":"83621","confirmation_number":"BP12232615213","room_confirmation_number":"BP12526755610","room_stay_from":"2019-09-04","room_stay_to":"2019-09-09","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":"67440","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-04 22:41:22","reservation_modified_date_time":"2019-09-04 22:41:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"67440","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":"3016895","reservation_id":"83612","confirmation_number":"BP12288473440","room_confirmation_number":"BP12522388969","room_stay_from":"2019-09-04","room_stay_to":"2019-09-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"90593","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-04 17:29:46","reservation_modified_date_time":"2019-09-06 19:07:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91015","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":"3016377","reservation_id":"81602","confirmation_number":"BV12255178846","room_confirmation_number":"BV12476888636","room_stay_from":"2019-09-02","room_stay_to":"2019-09-03","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89478","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-03 13:00:44","reservation_modified_date_time":"2019-09-04 19:53:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89478","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"12.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":"2992435","reservation_id":"79706","confirmation_number":"PB12299657856","room_confirmation_number":"PB12333055103","room_stay_from":"2019-08-02","room_stay_to":"2019-08-04","room_stay_status":"Canceled","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-06-27 14:10:09","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"88225","parentCustTravId":"88225","customer_traveller_id":"88225","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-09-04 17:54:08","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#20","deltaChange":-40,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3014786","reservation_id":"83331","confirmation_number":"BV12287642524","room_confirmation_number":"BV12473860313","room_stay_from":"2019-08-28","room_stay_to":"2019-08-29","room_stay_status":"Canceled","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-28 07:02:57","reservation_modified_date_time":"2019-08-28 07:02:57","customer_id":"77895","parentCustTravId":"77895","customer_traveller_id":"77895","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-09-04 13:01:42","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#12","deltaChange":-12,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3016328","reservation_id":"83609","confirmation_number":"BV12218905048","room_confirmation_number":"BV12482463341","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":"84.75","paid_amount":"84.75","product_id":"1146","service_quantity":"3","product_name":"Boat Dockage","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-04 16:57:35","reservation_modified_date_time":"2019-09-04 16:57:35","customer_id":"84963","parentCustTravId":"84963","customer_traveller_id":"84963","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":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3016329","reservation_id":"83609","confirmation_number":"BV12226268561","room_confirmation_number":"BV12482463341","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":"33.90","paid_amount":"33.90","product_id":"1147","service_quantity":"3","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-04 16:57:35","reservation_modified_date_time":"2019-09-04 16:57:35","customer_id":"84963","parentCustTravId":"84963","customer_traveller_id":"84963","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":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3016395","reservation_id":"83621","confirmation_number":"BP12236061370","room_confirmation_number":"BP12526755610","room_stay_from":"2019-09-04","room_stay_to":"2019-09-05","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-04 22:41:22","reservation_modified_date_time":"2019-09-04 22:41:22","customer_id":"67440","parentCustTravId":"67440","customer_traveller_id":"67440","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":"3016397","reservation_id":"81361","confirmation_number":"PB12232595203","room_confirmation_number":"BV12467801605","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":"113.00","paid_amount":"113.00","product_id":"1212","service_quantity":"4","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-04 22:42:24","reservation_modified_date_time":"2019-09-04 22:42:24","customer_id":"89354","parentCustTravId":"89354","customer_traveller_id":"89354","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":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3016256","reservation_id":"83592","confirmation_number":"BP12286620648","room_confirmation_number":"BP12586941863","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":"28.25","paid_amount":"0.00","product_id":"1146","service_quantity":"1","product_name":"Boat Dockage","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-04 12:37:15","reservation_modified_date_time":"2019-09-04 12:37:15","customer_id":"90941","parentCustTravId":"90941","customer_traveller_id":"90941","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","canceled_nights_data":"","product_attribute_values":null,"currentDayPrice":25,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}