{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-03-21","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,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":22,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3084224","reservation_id":"93524","confirmation_number":"BV12489417304","room_stay_from":"2020-03-21","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.01","nightly_discount":"0","subtotal":"136.01","grand_total":"153.69","paid_amount":"153.69","room_type_id":"307","product_id":"1224","siteminder_id":"EXP-1658667608","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":"99769","customer_id":"99769","source_of_creation":"Expedia","reservation_created_date":"2020-03-19 17:27:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"24.48","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136.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":"3083862","reservation_id":"93515","confirmation_number":"PB12313334247","room_stay_from":"2020-03-19","room_stay_to":"2020-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"157.1,156.99,172.22,172.36","nightly_discount":"0,0,0,0","subtotal":"658.67","grand_total":"744.30","paid_amount":"744.30","room_type_id":"291","product_id":"1118","siteminder_id":"EXP-1658599330","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99764","customer_id":"99764","source_of_creation":"Expedia","reservation_created_date":"2020-03-19 04:17:10","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.22","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":"3084391","reservation_id":"93472","confirmation_number":"BP12597836583","room_stay_from":"2020-03-21","room_stay_to":"2020-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.70,117.68","nightly_discount":"0,0","subtotal":"238.38","grand_total":"269.37","paid_amount":"269.37","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1658371668","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":"46127","customer_id":"46127","source_of_creation":"Expedia","reservation_created_date":"2020-03-17 21:07:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.70","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":"3084148","reservation_id":"93426","confirmation_number":"PB12312603459","room_stay_from":"2020-03-21","room_stay_to":"2020-03-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.52,204.58,204.58,204.58,204.58,204.58,255.52","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1533.94","grand_total":"1733.36","paid_amount":"1733.36","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1658177023","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":"99787","customer_id":"99787","source_of_creation":"Expedia","reservation_created_date":"2020-03-16 20:17:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"255.52","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[{"room_stay_id":"3054610","reservation_id":"84467","confirmation_number":"PB12348570182","room_stay_from":"2020-03-21","room_stay_to":"2020-03-28","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"3","nightly_price":"318.10,285.60,285.60,285.60,285.60,285.60,318.10","nightly_discount":"0,0,0,0,0,0,0","subtotal":"2064.20","grand_total":"2332.54","paid_amount":"382.05","room_type_id":"291","product_id":"1119","siteminder_id":"EXP-1346804934","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"140.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91879","customer_id":"91879","source_of_creation":"Expedia","reservation_created_date":"2019-09-21 10:37:11","service_canceled_date_time":"2020-03-19 22:37:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"382.05","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3073800","reservation_id":"85049","confirmation_number":"PB12385673688","room_stay_from":"2020-03-21","room_stay_to":"2020-03-28","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"429,379,379,379,379,379,429","nightly_discount":"0,0,0,0,0,0,0","subtotal":"2753.00","grand_total":"3110.89","paid_amount":"484.77","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1354620700","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"140.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92294","customer_id":"92294","source_of_creation":"Expedia","reservation_created_date":"2019-10-03 15:07:08","service_canceled_date_time":"2020-03-16 20:22:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"484.77","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3084247","reservation_id":"89702","confirmation_number":"BV12421793215","room_stay_from":"2020-03-16","room_stay_to":"2020-03-22","room_stay_status":"Checked-Out","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"152.67,152.67,152.67,152.67,191.73,210.85","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1013.26","grand_total":"1144.99","paid_amount":"1144.99","room_type_id":"305","product_id":"1222","siteminder_id":"AGO-302022914","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":"99789","customer_id":"99789","source_of_creation":"Agoda","reservation_created_date":"2020-01-10 16:22:10","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"210.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084304","reservation_id":"93555","confirmation_number":"BP12592361149","room_stay_from":"2020-03-21","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.86","nightly_discount":"0","subtotal":"106.86","grand_total":"120.75","paid_amount":"120.75","room_type_id":"286","product_id":"1086","siteminder_id":"AGO-314453170","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":"99791","customer_id":"99791","source_of_creation":"Agoda","reservation_created_date":"2020-03-21 15:28:10","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"106.86","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084385","reservation_id":"89600","confirmation_number":"PB12365625847","room_stay_from":"2020-03-20","room_stay_to":"2020-03-26","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"206.46,227.11,181.83,181.83,181.83,181.83","nightly_discount":"0,0,0,0,0,0","subtotal":"1160.89","grand_total":"1311.80","paid_amount":"1311.80","room_type_id":"313","product_id":"1228","siteminder_id":"AGO-301708510","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":"95591","customer_id":"95591","source_of_creation":"Agoda","reservation_created_date":"2020-01-09 00:03:09","canceled_nights_data":"","product_name":"PB Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"227.11","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":"3084424","reservation_id":"92275","confirmation_number":"BP12522165322","room_stay_from":"2020-03-21","room_stay_to":"2020-03-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"206.83,162.25,162.25,162.25,162.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"855.83","grand_total":"967.09","paid_amount":"967.09","room_type_id":"289","product_id":"1094","siteminder_id":"AGO-309663590","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"62637","customer_id":"62637","source_of_creation":"Agoda","reservation_created_date":"2020-02-20 23:21:07","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":"206.83","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3083563","reservation_id":"87559","confirmation_number":"BV12477210371","room_stay_from":"2020-03-18","room_stay_to":"2020-03-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.00,168.00,218.00,218.00,168.00,168.00,168.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1276.00","grand_total":"1441.88","paid_amount":"1441.88","room_type_id":"301","product_id":"1136","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"75923","customer_id":"75923","source_of_creation":"FE","reservation_created_date":"2019-11-27 14:34:46","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"218.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3081719","reservation_id":"93341","confirmation_number":"PB12342489993","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","room_stay_status":"Checked-Out","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"182.96,231.20,231.20,231.20,231.20,310.32,354.45","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1772.53","grand_total":"2002.96","paid_amount":"2002.96","room_type_id":"289","product_id":"1107","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99547","customer_id":"99547","source_of_creation":"PMS","reservation_created_date":"2020-03-14 17:27:26","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"354.45","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083377","reservation_id":"89745","confirmation_number":"PB12323986580","room_stay_from":"2020-03-18","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"232.00,232.00,232.00,232.00","nightly_discount":"0.00,36.50,0.00,0.00","subtotal":"928.00","grand_total":"1007.40","paid_amount":"1007.40","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95762","customer_id":"95762","source_of_creation":"PMS","reservation_created_date":"2020-01-11 14:05:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"232.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083773","reservation_id":"93520","confirmation_number":"BV12435075660","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.14,232.89","nightly_discount":"0.00,23.79","subtotal":"444.03","grand_total":"474.87","paid_amount":"474.88","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99752","customer_id":"99752","source_of_creation":"PMS","reservation_created_date":"2020-03-19 15:57:44","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"232.89","currentDayDiscount":"23.79","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083787","reservation_id":"93522","confirmation_number":"BP12542810668","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,110.00","nightly_discount":"0.00,0.00","subtotal":"220.00","grand_total":"248.60","paid_amount":"248.60","room_type_id":"299","product_id":"1134","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99702","customer_id":"99702","source_of_creation":"PMS","reservation_created_date":"2020-03-19 16:29:07","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":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084006","reservation_id":"71038","confirmation_number":"PB12342857321","room_stay_from":"2020-02-22","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00","nightly_discount":"100.00,100.00,53.06,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"4321.00","grand_total":"4596.78","paid_amount":"4596.78","room_type_id":"289","product_id":"1110","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23140","customer_id":"23140","source_of_creation":"PMS","reservation_created_date":"2019-03-05 23:08:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084046","reservation_id":"92777","confirmation_number":"PB12373303248","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"292.96,323.06","nightly_discount":"0.00,0.00","subtotal":"616.02","grand_total":"696.10","paid_amount":"696.10","room_type_id":"289","product_id":"1103","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"83070","customer_id":"83070","source_of_creation":"PMS","reservation_created_date":"2020-02-29 18:53:16","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"323.06","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084280","reservation_id":"93511","confirmation_number":"PB12382242941","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"195.55,135.00","nightly_discount":"2.18,2.18","subtotal":"330.55","grand_total":"368.59","paid_amount":"368.59","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99744","customer_id":"99744","source_of_creation":"PMS","reservation_created_date":"2020-03-19 02:31:24","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"135.00","currentDayDiscount":"2.18","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083868","reservation_id":"93532","confirmation_number":"PB12362048535","room_stay_from":"2020-03-20","room_stay_to":"2020-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"170.00,170.00,170.00","nightly_discount":"0.00,0.00,0.00","subtotal":"510.00","grand_total":"576.30","paid_amount":"576.30","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99766","customer_id":"99766","source_of_creation":"PMS","reservation_created_date":"2020-03-19 21:58:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"170.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084095","reservation_id":"93551","confirmation_number":"BV12457091300","room_stay_from":"2020-03-20","room_stay_to":"2020-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00,150.00,150.00","nightly_discount":"0.00,0.00,0.00","subtotal":"450.00","grand_total":"508.50","paid_amount":"508.50","room_type_id":"304","product_id":"1220","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99783","customer_id":"99783","source_of_creation":"PMS","reservation_created_date":"2020-03-20 22:00:22","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"150.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084415","reservation_id":"93465","confirmation_number":"PB12327041832","room_stay_from":"2020-03-19","room_stay_to":"2020-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"275.00,325.00,325.00,178.00","nightly_discount":"51.09,0.00,0.00,0.00","subtotal":"1103.00","grand_total":"1188.65","paid_amount":"1188.65","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":"58370","customer_id":"58370","source_of_creation":"PMS","reservation_created_date":"2020-03-17 19:00:29","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":"325.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3051723","reservation_id":"88910","confirmation_number":"BP12563514738","room_stay_from":"2020-03-18","room_stay_to":"2020-03-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"213.00,213.00,289.30,318.23,234.30,234.30,234.30","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1736.43","grand_total":"1962.17","paid_amount":"1962.17","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":"94997","customer_id":"94997","source_of_creation":"PMS","reservation_created_date":"2019-12-29 18:49:51","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":"318.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"}]},{"room_stay_id":"3084136","reservation_id":"93544","confirmation_number":"PB12375062057","room_stay_from":"2020-03-20","room_stay_to":"2020-03-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"229.00,229.00,229.00,229.00,229.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1145.00","grand_total":"1293.85","paid_amount":"1293.85","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99778","customer_id":"99778","source_of_creation":"PMS","reservation_created_date":"2020-03-20 17:01:40","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"229.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084219","reservation_id":"74642","confirmation_number":"PB12374030255","room_stay_from":"2021-04-06","room_stay_to":"2021-04-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2464.00","grand_total":"2784.32","paid_amount":"162.72","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"56067","customer_id":"56067","source_of_creation":"PMS","reservation_created_date":"2019-04-13 17:08:04","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3081721","reservation_id":"93341","confirmation_number":"PB12264940997","room_confirmation_number":"PB12342489993","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"99547","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-14 17:27:26","reservation_modified_date_time":"2020-03-14 17:27:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99547","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":"3084244","reservation_id":"89702","confirmation_number":"BV12232644077","room_confirmation_number":"BV12421793215","room_stay_from":"2020-03-16","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"99789","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-16 18:29:59","reservation_modified_date_time":"2020-03-21 14:48:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99789","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":"3084274","reservation_id":"93511","confirmation_number":"PB12250710441","room_confirmation_number":"PB12382242941","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"30,30","nightly_discount":"0.00,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"99744","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-21 15:37:38","reservation_modified_date_time":"2020-03-21 15:37:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99744","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"30.00","currentDayPrice":"30","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":"3083860","reservation_id":"93515","confirmation_number":"PB12288352729","room_confirmation_number":"PB12313334247","room_stay_from":"2020-03-19","room_stay_to":"2020-03-23","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"99764","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-19 20:54:47","reservation_modified_date_time":"2020-03-19 21:07:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99764","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":"3084416","reservation_id":"93465","confirmation_number":"PB12296614359","room_confirmation_number":"PB12327041832","room_stay_from":"2020-03-19","room_stay_to":"2020-03-23","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,0.00","nightly_discount":"0.00,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":"58370","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-17 19:00:29","reservation_modified_date_time":"2020-03-21 19:37:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58370","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":"3084137","reservation_id":"93544","confirmation_number":"PB12250105971","room_confirmation_number":"PB12375062057","room_stay_from":"2020-03-20","room_stay_to":"2020-03-25","room_stay_status":"Active","nightly_price":"30,30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"169.50","paid_amount":"169.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"99778","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-21 03:14:30","reservation_modified_date_time":"2020-03-21 03:14:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99778","canceled_nights_data":"","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3081720","reservation_id":"93341","confirmation_number":"PB12260405979","room_confirmation_number":"PB12342489993","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","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":"99547","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-14 17:27:26","reservation_modified_date_time":"2020-03-14 17:27:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99547","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":"3083378","reservation_id":"89745","confirmation_number":"PB12267278395","room_confirmation_number":"PB12323986580","room_stay_from":"2020-03-18","room_stay_to":"2020-03-22","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.23","product_id":"1781","service_quantity":"1","customer_traveller_id":"95762","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-11 14:05:10","reservation_modified_date_time":"2020-03-18 14:58:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95762","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":"3083774","reservation_id":"93520","confirmation_number":"BV12271962727","room_confirmation_number":"BV12435075660","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","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":"99752","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 15:57:44","reservation_modified_date_time":"2020-03-19 16:02:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99752","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":"3083788","reservation_id":"93522","confirmation_number":"BP12239293205","room_confirmation_number":"BP12542810668","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","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":"99702","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 16:29:08","reservation_modified_date_time":"2020-03-19 16:29:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99702","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":"3084007","reservation_id":"71038","confirmation_number":"PB12212649017","room_confirmation_number":"PB12342857321","room_stay_from":"2020-02-22","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23140","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-03-05 23:08:06","reservation_modified_date_time":"2020-03-20 14:49:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23140","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":"3084047","reservation_id":"92777","confirmation_number":"PB12236320592","room_confirmation_number":"PB12373303248","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","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":"83070","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-29 18:53:16","reservation_modified_date_time":"2020-03-20 16:48:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83070","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":"3084223","reservation_id":"93524","confirmation_number":"BV12267898519","room_confirmation_number":"BV12489417304","room_stay_from":"2020-03-21","room_stay_to":"2020-03-22","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":"99769","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-19 17:27:09","reservation_modified_date_time":"2020-03-21 14:16:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99769","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":"3084245","reservation_id":"89702","confirmation_number":"BV12252429810","room_confirmation_number":"BV12421793215","room_stay_from":"2020-03-16","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"99789","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-10 16:22:10","reservation_modified_date_time":"2020-03-21 14:48:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99789","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":"3084281","reservation_id":"93511","confirmation_number":"PB12267913779","room_confirmation_number":"PB12382242941","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","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":"99744","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 02:31:24","reservation_modified_date_time":"2020-03-21 15:41:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99744","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.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":"3084303","reservation_id":"93555","confirmation_number":"BP12248554420","room_confirmation_number":"BP12592361149","room_stay_from":"2020-03-21","room_stay_to":"2020-03-22","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":"99791","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-21 15:28:10","reservation_modified_date_time":"2020-03-21 16:36:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99791","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":"3083861","reservation_id":"93515","confirmation_number":"PB12255641758","room_confirmation_number":"PB12313334247","room_stay_from":"2020-03-19","room_stay_to":"2020-03-23","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"99764","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-19 04:17:10","reservation_modified_date_time":"2020-03-19 21:07:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99764","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":"3083869","reservation_id":"93532","confirmation_number":"PB12235989805","room_confirmation_number":"PB12362048535","room_stay_from":"2020-03-20","room_stay_to":"2020-03-23","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":"99766","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 21:58:10","reservation_modified_date_time":"2020-03-19 21:58:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99766","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":"3084096","reservation_id":"93551","confirmation_number":"BV12291170417","room_confirmation_number":"BV12457091300","room_stay_from":"2020-03-20","room_stay_to":"2020-03-23","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":"99783","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-20 22:00:22","reservation_modified_date_time":"2020-03-20 22:00:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99783","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":"3084390","reservation_id":"93472","confirmation_number":"BP12274061794","room_confirmation_number":"BP12597836583","room_stay_from":"2020-03-21","room_stay_to":"2020-03-23","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":"46127","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-17 21:07:06","reservation_modified_date_time":"2020-03-21 17:33:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"46127","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":"3084417","reservation_id":"93465","confirmation_number":"PB12251502504","room_confirmation_number":"PB12327041832","room_stay_from":"2020-03-19","room_stay_to":"2020-03-23","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":"58370","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-17 19:00:29","reservation_modified_date_time":"2020-03-21 19:37:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58370","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":"3051724","reservation_id":"88910","confirmation_number":"BP12238591793","room_confirmation_number":"BP12563514738","room_stay_from":"2020-03-18","room_stay_to":"2020-03-25","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":"94997","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-29 18:49:51","reservation_modified_date_time":"2019-12-29 18:49:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94997","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":"3083565","reservation_id":"87559","confirmation_number":"BV12233803065","room_confirmation_number":"BV12477210371","room_stay_from":"2020-03-18","room_stay_to":"2020-03-25","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":"75923","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-27 14:34:46","reservation_modified_date_time":"2020-03-18 20:13:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75923","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":"3084138","reservation_id":"93544","confirmation_number":"PB12258254979","room_confirmation_number":"PB12375062057","room_stay_from":"2020-03-20","room_stay_to":"2020-03-25","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":"99778","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-20 17:01:40","reservation_modified_date_time":"2020-03-21 03:14:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99778","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":"3084386","reservation_id":"89600","confirmation_number":"PB12280771137","room_confirmation_number":"PB12365625847","room_stay_from":"2020-03-20","room_stay_to":"2020-03-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0,0,0,0,0,0","subtotal":"120.00","grand_total":"135.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"95591","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-09 00:03:09","reservation_modified_date_time":"2020-03-21 17:17:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95591","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084423","reservation_id":"92275","confirmation_number":"BP12244352838","room_confirmation_number":"BP12522165322","room_stay_from":"2020-03-21","room_stay_to":"2020-03-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"62637","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-02-20 23:21:07","reservation_modified_date_time":"2020-03-21 20:03:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"62637","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":"3084147","reservation_id":"93426","confirmation_number":"PB12279893781","room_confirmation_number":"PB12312603459","room_stay_from":"2020-03-21","room_stay_to":"2020-03-28","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"99787","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-16 20:17:08","reservation_modified_date_time":"2020-03-21 13:23:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99787","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":"3045946","reservation_id":"88064","confirmation_number":"BV12223447717","room_confirmation_number":"BV12428689124","room_stay_from":"2020-03-16","room_stay_to":"2020-03-31","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"94413","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-08 21:42:57","reservation_modified_date_time":"2019-12-08 21:42:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94413","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":"3084210","reservation_id":"93389","confirmation_number":"BV12285120691","room_confirmation_number":"BV12474003071","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"47098","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-15 20:38:01","reservation_modified_date_time":"2020-03-21 14:11:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47098","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"-48.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":"3084220","reservation_id":"74642","confirmation_number":"PB12284489315","room_confirmation_number":"PB12374030255","room_stay_from":"2021-04-06","room_stay_to":"2021-04-22","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"192.00","grand_total":"216.96","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"56067","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-13 17:08:04","reservation_modified_date_time":"2020-03-21 14:14:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56067","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3084305","reservation_id":"93555","confirmation_number":"PB12219134491","room_confirmation_number":"BP12592361149","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":"28.25","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-21 16:37:21","reservation_modified_date_time":"2020-03-21 16:37:21","customer_id":"99791","parentCustTravId":"99791","customer_traveller_id":"99791","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3084384","reservation_id":"93511","confirmation_number":"PB12273487813","room_confirmation_number":"PB12382242941","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"4.00","paid_amount":"4.00","product_id":"1213","service_quantity":"4","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-21 17:11:03","reservation_modified_date_time":"2020-03-21 17:11:03","customer_id":"99744","parentCustTravId":"99744","customer_traveller_id":"99744","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3084460","reservation_id":"93560","confirmation_number":"PB12230156825","room_confirmation_number":"PB12367686945","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"3","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-21 21:50:37","reservation_modified_date_time":"2020-03-21 21:50:37","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3084475","reservation_id":"93565","confirmation_number":"PB12296362926","room_confirmation_number":"PB12380523198","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-22 00:49:03","reservation_modified_date_time":"2020-03-22 00:49:03","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"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,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120","departureCount":14,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3083862","reservation_id":"93515","confirmation_number":"PB12313334247","room_stay_from":"2020-03-19","room_stay_to":"2020-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"157.1,156.99,172.22,172.36","nightly_discount":"0,0,0,0","subtotal":"658.67","grand_total":"744.30","paid_amount":"744.30","room_type_id":"291","product_id":"1118","siteminder_id":"EXP-1658599330","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99764","customer_id":"99764","source_of_creation":"Expedia","reservation_created_date":"2020-03-19 04:17:10","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.22","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":"3084148","reservation_id":"93426","confirmation_number":"PB12312603459","room_stay_from":"2020-03-21","room_stay_to":"2020-03-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.52,204.58,204.58,204.58,204.58,204.58,255.52","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1533.94","grand_total":"1733.36","paid_amount":"1733.36","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1658177023","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":"99787","customer_id":"99787","source_of_creation":"Expedia","reservation_created_date":"2020-03-16 20:17:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"255.52","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[{"room_stay_id":"3054610","reservation_id":"84467","confirmation_number":"PB12348570182","room_stay_from":"2020-03-21","room_stay_to":"2020-03-28","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"3","nightly_price":"318.10,285.60,285.60,285.60,285.60,285.60,318.10","nightly_discount":"0,0,0,0,0,0,0","subtotal":"2064.20","grand_total":"2332.54","paid_amount":"382.05","room_type_id":"291","product_id":"1119","siteminder_id":"EXP-1346804934","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"140.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"91879","customer_id":"91879","source_of_creation":"Expedia","reservation_created_date":"2019-09-21 10:37:11","service_canceled_date_time":"2020-03-19 22:37:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"382.05","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3073800","reservation_id":"85049","confirmation_number":"PB12385673688","room_stay_from":"2020-03-21","room_stay_to":"2020-03-28","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"429,379,379,379,379,379,429","nightly_discount":"0,0,0,0,0,0,0","subtotal":"2753.00","grand_total":"3110.89","paid_amount":"484.77","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1354620700","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"140.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92294","customer_id":"92294","source_of_creation":"Expedia","reservation_created_date":"2019-10-03 15:07:08","service_canceled_date_time":"2020-03-16 20:22:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"484.77","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3084385","reservation_id":"89600","confirmation_number":"PB12365625847","room_stay_from":"2020-03-20","room_stay_to":"2020-03-26","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"206.46,227.11,181.83,181.83,181.83,181.83","nightly_discount":"0,0,0,0,0,0","subtotal":"1160.89","grand_total":"1311.80","paid_amount":"1311.80","room_type_id":"313","product_id":"1228","siteminder_id":"AGO-301708510","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":"95591","customer_id":"95591","source_of_creation":"Agoda","reservation_created_date":"2020-01-09 00:03:09","canceled_nights_data":"","product_name":"PB Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"227.11","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3081719","reservation_id":"93341","confirmation_number":"PB12342489993","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","room_stay_status":"Checked-Out","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"182.96,231.20,231.20,231.20,231.20,310.32,354.45","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1772.53","grand_total":"2002.96","paid_amount":"2002.96","room_type_id":"289","product_id":"1107","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99547","customer_id":"99547","source_of_creation":"PMS","reservation_created_date":"2020-03-14 17:27:26","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"354.45","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083377","reservation_id":"89745","confirmation_number":"PB12323986580","room_stay_from":"2020-03-18","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"232.00,232.00,232.00,232.00","nightly_discount":"0.00,36.50,0.00,0.00","subtotal":"928.00","grand_total":"1007.40","paid_amount":"1007.40","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95762","customer_id":"95762","source_of_creation":"PMS","reservation_created_date":"2020-01-11 14:05:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"232.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084006","reservation_id":"71038","confirmation_number":"PB12342857321","room_stay_from":"2020-02-22","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00,149.00","nightly_discount":"100.00,100.00,53.06,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"4321.00","grand_total":"4596.78","paid_amount":"4596.78","room_type_id":"289","product_id":"1110","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23140","customer_id":"23140","source_of_creation":"PMS","reservation_created_date":"2019-03-05 23:08:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084046","reservation_id":"92777","confirmation_number":"PB12373303248","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"292.96,323.06","nightly_discount":"0.00,0.00","subtotal":"616.02","grand_total":"696.10","paid_amount":"696.10","room_type_id":"289","product_id":"1103","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"83070","customer_id":"83070","source_of_creation":"PMS","reservation_created_date":"2020-02-29 18:53:16","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"323.06","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084280","reservation_id":"93511","confirmation_number":"PB12382242941","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"195.55,135.00","nightly_discount":"2.18,2.18","subtotal":"330.55","grand_total":"368.59","paid_amount":"368.59","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99744","customer_id":"99744","source_of_creation":"PMS","reservation_created_date":"2020-03-19 02:31:24","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"135.00","currentDayDiscount":"2.18","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083868","reservation_id":"93532","confirmation_number":"PB12362048535","room_stay_from":"2020-03-20","room_stay_to":"2020-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"170.00,170.00,170.00","nightly_discount":"0.00,0.00,0.00","subtotal":"510.00","grand_total":"576.30","paid_amount":"576.30","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99766","customer_id":"99766","source_of_creation":"PMS","reservation_created_date":"2020-03-19 21:58:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"170.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084415","reservation_id":"93465","confirmation_number":"PB12327041832","room_stay_from":"2020-03-19","room_stay_to":"2020-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"275.00,325.00,325.00,178.00","nightly_discount":"51.09,0.00,0.00,0.00","subtotal":"1103.00","grand_total":"1188.65","paid_amount":"1188.65","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":"58370","customer_id":"58370","source_of_creation":"PMS","reservation_created_date":"2020-03-17 19:00:29","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":"325.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084136","reservation_id":"93544","confirmation_number":"PB12375062057","room_stay_from":"2020-03-20","room_stay_to":"2020-03-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"229.00,229.00,229.00,229.00,229.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1145.00","grand_total":"1293.85","paid_amount":"1293.85","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99778","customer_id":"99778","source_of_creation":"PMS","reservation_created_date":"2020-03-20 17:01:40","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"229.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084219","reservation_id":"74642","confirmation_number":"PB12374030255","room_stay_from":"2021-04-06","room_stay_to":"2021-04-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00,154.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2464.00","grand_total":"2784.32","paid_amount":"162.72","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"56067","customer_id":"56067","source_of_creation":"PMS","reservation_created_date":"2019-04-13 17:08:04","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3081721","reservation_id":"93341","confirmation_number":"PB12264940997","room_confirmation_number":"PB12342489993","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"99547","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-14 17:27:26","reservation_modified_date_time":"2020-03-14 17:27:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99547","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":"3084274","reservation_id":"93511","confirmation_number":"PB12250710441","room_confirmation_number":"PB12382242941","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"30,30","nightly_discount":"0.00,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"99744","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-21 15:37:38","reservation_modified_date_time":"2020-03-21 15:37:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99744","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"30.00","currentDayPrice":"30","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":"3083860","reservation_id":"93515","confirmation_number":"PB12288352729","room_confirmation_number":"PB12313334247","room_stay_from":"2020-03-19","room_stay_to":"2020-03-23","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"99764","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-19 20:54:47","reservation_modified_date_time":"2020-03-19 21:07:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99764","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":"3084416","reservation_id":"93465","confirmation_number":"PB12296614359","room_confirmation_number":"PB12327041832","room_stay_from":"2020-03-19","room_stay_to":"2020-03-23","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,0.00","nightly_discount":"0.00,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":"58370","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-17 19:00:29","reservation_modified_date_time":"2020-03-21 19:37:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58370","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":"3084137","reservation_id":"93544","confirmation_number":"PB12250105971","room_confirmation_number":"PB12375062057","room_stay_from":"2020-03-20","room_stay_to":"2020-03-25","room_stay_status":"Active","nightly_price":"30,30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"169.50","paid_amount":"169.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"99778","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-21 03:14:30","reservation_modified_date_time":"2020-03-21 03:14:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99778","canceled_nights_data":"","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3081720","reservation_id":"93341","confirmation_number":"PB12260405979","room_confirmation_number":"PB12342489993","room_stay_from":"2020-03-15","room_stay_to":"2020-03-22","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":"99547","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-14 17:27:26","reservation_modified_date_time":"2020-03-14 17:27:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99547","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":"3083378","reservation_id":"89745","confirmation_number":"PB12267278395","room_confirmation_number":"PB12323986580","room_stay_from":"2020-03-18","room_stay_to":"2020-03-22","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.23","product_id":"1781","service_quantity":"1","customer_traveller_id":"95762","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-11 14:05:10","reservation_modified_date_time":"2020-03-18 14:58:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95762","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":"3084007","reservation_id":"71038","confirmation_number":"PB12212649017","room_confirmation_number":"PB12342857321","room_stay_from":"2020-02-22","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23140","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-03-05 23:08:06","reservation_modified_date_time":"2020-03-20 14:49:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23140","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":"3084047","reservation_id":"92777","confirmation_number":"PB12236320592","room_confirmation_number":"PB12373303248","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","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":"83070","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-29 18:53:16","reservation_modified_date_time":"2020-03-20 16:48:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83070","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":"3084281","reservation_id":"93511","confirmation_number":"PB12267913779","room_confirmation_number":"PB12382242941","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","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":"99744","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 02:31:24","reservation_modified_date_time":"2020-03-21 15:41:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99744","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.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":"3083861","reservation_id":"93515","confirmation_number":"PB12255641758","room_confirmation_number":"PB12313334247","room_stay_from":"2020-03-19","room_stay_to":"2020-03-23","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"99764","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-19 04:17:10","reservation_modified_date_time":"2020-03-19 21:07:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99764","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":"3083869","reservation_id":"93532","confirmation_number":"PB12235989805","room_confirmation_number":"PB12362048535","room_stay_from":"2020-03-20","room_stay_to":"2020-03-23","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":"99766","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 21:58:10","reservation_modified_date_time":"2020-03-19 21:58:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99766","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":"3084417","reservation_id":"93465","confirmation_number":"PB12251502504","room_confirmation_number":"PB12327041832","room_stay_from":"2020-03-19","room_stay_to":"2020-03-23","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":"58370","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-17 19:00:29","reservation_modified_date_time":"2020-03-21 19:37:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58370","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":"3084138","reservation_id":"93544","confirmation_number":"PB12258254979","room_confirmation_number":"PB12375062057","room_stay_from":"2020-03-20","room_stay_to":"2020-03-25","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":"99778","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-20 17:01:40","reservation_modified_date_time":"2020-03-21 03:14:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99778","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":"3084386","reservation_id":"89600","confirmation_number":"PB12280771137","room_confirmation_number":"PB12365625847","room_stay_from":"2020-03-20","room_stay_to":"2020-03-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0,0,0,0,0,0","subtotal":"120.00","grand_total":"135.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"95591","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-09 00:03:09","reservation_modified_date_time":"2020-03-21 17:17:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95591","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084147","reservation_id":"93426","confirmation_number":"PB12279893781","room_confirmation_number":"PB12312603459","room_stay_from":"2020-03-21","room_stay_to":"2020-03-28","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"99787","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-16 20:17:08","reservation_modified_date_time":"2020-03-21 13:23:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99787","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":"3084220","reservation_id":"74642","confirmation_number":"PB12284489315","room_confirmation_number":"PB12374030255","room_stay_from":"2021-04-06","room_stay_to":"2021-04-22","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"192.00","grand_total":"216.96","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"56067","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-13 17:08:04","reservation_modified_date_time":"2020-03-21 14:14:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56067","canceled_nights_data":"","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3084384","reservation_id":"93511","confirmation_number":"PB12273487813","room_confirmation_number":"PB12382242941","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"4.00","paid_amount":"4.00","product_id":"1213","service_quantity":"4","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-21 17:11:03","reservation_modified_date_time":"2020-03-21 17:11:03","customer_id":"99744","parentCustTravId":"99744","customer_traveller_id":"99744","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3084460","reservation_id":"93560","confirmation_number":"PB12230156825","room_confirmation_number":"PB12367686945","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"3","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-21 21:50:37","reservation_modified_date_time":"2020-03-21 21:50:37","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3084475","reservation_id":"93565","confirmation_number":"PB12296362926","room_confirmation_number":"PB12380523198","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"1.00","product_id":null,"service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-22 00:49:03","reservation_modified_date_time":"2020-03-22 00:49:03","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":3,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3084224","reservation_id":"93524","confirmation_number":"BV12489417304","room_stay_from":"2020-03-21","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"136.01","nightly_discount":"0","subtotal":"136.01","grand_total":"153.69","paid_amount":"153.69","room_type_id":"307","product_id":"1224","siteminder_id":"EXP-1658667608","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":"99769","customer_id":"99769","source_of_creation":"Expedia","reservation_created_date":"2020-03-19 17:27:09","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"24.48","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"136.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"}]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3084247","reservation_id":"89702","confirmation_number":"BV12421793215","room_stay_from":"2020-03-16","room_stay_to":"2020-03-22","room_stay_status":"Checked-Out","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"152.67,152.67,152.67,152.67,191.73,210.85","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1013.26","grand_total":"1144.99","paid_amount":"1144.99","room_type_id":"305","product_id":"1222","siteminder_id":"AGO-302022914","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":"99789","customer_id":"99789","source_of_creation":"Agoda","reservation_created_date":"2020-01-10 16:22:10","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"210.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3083563","reservation_id":"87559","confirmation_number":"BV12477210371","room_stay_from":"2020-03-18","room_stay_to":"2020-03-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.00,168.00,218.00,218.00,168.00,168.00,168.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1276.00","grand_total":"1441.88","paid_amount":"1441.88","room_type_id":"301","product_id":"1136","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"75923","customer_id":"75923","source_of_creation":"FE","reservation_created_date":"2019-11-27 14:34:46","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"218.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3083773","reservation_id":"93520","confirmation_number":"BV12435075660","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"211.14,232.89","nightly_discount":"0.00,23.79","subtotal":"444.03","grand_total":"474.87","paid_amount":"474.88","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99752","customer_id":"99752","source_of_creation":"PMS","reservation_created_date":"2020-03-19 15:57:44","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"232.89","currentDayDiscount":"23.79","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084095","reservation_id":"93551","confirmation_number":"BV12457091300","room_stay_from":"2020-03-20","room_stay_to":"2020-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00,150.00,150.00","nightly_discount":"0.00,0.00,0.00","subtotal":"450.00","grand_total":"508.50","paid_amount":"508.50","room_type_id":"304","product_id":"1220","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99783","customer_id":"99783","source_of_creation":"PMS","reservation_created_date":"2020-03-20 22:00:22","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"150.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3084244","reservation_id":"89702","confirmation_number":"BV12232644077","room_confirmation_number":"BV12421793215","room_stay_from":"2020-03-16","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"99789","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-16 18:29:59","reservation_modified_date_time":"2020-03-21 14:48:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99789","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3083774","reservation_id":"93520","confirmation_number":"BV12271962727","room_confirmation_number":"BV12435075660","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","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":"99752","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 15:57:44","reservation_modified_date_time":"2020-03-19 16:02:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99752","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":"3084223","reservation_id":"93524","confirmation_number":"BV12267898519","room_confirmation_number":"BV12489417304","room_stay_from":"2020-03-21","room_stay_to":"2020-03-22","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":"99769","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-19 17:27:09","reservation_modified_date_time":"2020-03-21 14:16:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99769","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":"3084245","reservation_id":"89702","confirmation_number":"BV12252429810","room_confirmation_number":"BV12421793215","room_stay_from":"2020-03-16","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"99789","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-10 16:22:10","reservation_modified_date_time":"2020-03-21 14:48:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99789","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":"3084096","reservation_id":"93551","confirmation_number":"BV12291170417","room_confirmation_number":"BV12457091300","room_stay_from":"2020-03-20","room_stay_to":"2020-03-23","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":"99783","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-20 22:00:22","reservation_modified_date_time":"2020-03-20 22:00:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99783","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":"3083565","reservation_id":"87559","confirmation_number":"BV12233803065","room_confirmation_number":"BV12477210371","room_stay_from":"2020-03-18","room_stay_to":"2020-03-25","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":"75923","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-27 14:34:46","reservation_modified_date_time":"2020-03-18 20:13:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75923","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":"3045946","reservation_id":"88064","confirmation_number":"BV12223447717","room_confirmation_number":"BV12428689124","room_stay_from":"2020-03-16","room_stay_to":"2020-03-31","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"94413","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-08 21:42:57","reservation_modified_date_time":"2019-12-08 21:42:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94413","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":"3084210","reservation_id":"93389","confirmation_number":"BV12285120691","room_confirmation_number":"BV12474003071","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"47098","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-15 20:38:01","reservation_modified_date_time":"2020-03-21 14:11:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47098","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"-48.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"}]}],"resort_fee_non_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":5,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3084391","reservation_id":"93472","confirmation_number":"BP12597836583","room_stay_from":"2020-03-21","room_stay_to":"2020-03-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.70,117.68","nightly_discount":"0,0","subtotal":"238.38","grand_total":"269.37","paid_amount":"269.37","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1658371668","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":"46127","customer_id":"46127","source_of_creation":"Expedia","reservation_created_date":"2020-03-17 21:07:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.70","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"}]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3084304","reservation_id":"93555","confirmation_number":"BP12592361149","room_stay_from":"2020-03-21","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.86","nightly_discount":"0","subtotal":"106.86","grand_total":"120.75","paid_amount":"120.75","room_type_id":"286","product_id":"1086","siteminder_id":"AGO-314453170","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":"99791","customer_id":"99791","source_of_creation":"Agoda","reservation_created_date":"2020-03-21 15:28:10","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"106.86","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084424","reservation_id":"92275","confirmation_number":"BP12522165322","room_stay_from":"2020-03-21","room_stay_to":"2020-03-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"206.83,162.25,162.25,162.25,162.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"855.83","grand_total":"967.09","paid_amount":"967.09","room_type_id":"289","product_id":"1094","siteminder_id":"AGO-309663590","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"62637","customer_id":"62637","source_of_creation":"Agoda","reservation_created_date":"2020-02-20 23:21:07","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":"206.83","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3083787","reservation_id":"93522","confirmation_number":"BP12542810668","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,110.00","nightly_discount":"0.00,0.00","subtotal":"220.00","grand_total":"248.60","paid_amount":"248.60","room_type_id":"299","product_id":"1134","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99702","customer_id":"99702","source_of_creation":"PMS","reservation_created_date":"2020-03-19 16:29:07","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":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3051723","reservation_id":"88910","confirmation_number":"BP12563514738","room_stay_from":"2020-03-18","room_stay_to":"2020-03-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"213.00,213.00,289.30,318.23,234.30,234.30,234.30","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1736.43","grand_total":"1962.17","paid_amount":"1962.17","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":"94997","customer_id":"94997","source_of_creation":"PMS","reservation_created_date":"2019-12-29 18:49:51","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":"318.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3083788","reservation_id":"93522","confirmation_number":"BP12239293205","room_confirmation_number":"BP12542810668","room_stay_from":"2020-03-20","room_stay_to":"2020-03-22","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":"99702","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 16:29:08","reservation_modified_date_time":"2020-03-19 16:29:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99702","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":"3084303","reservation_id":"93555","confirmation_number":"BP12248554420","room_confirmation_number":"BP12592361149","room_stay_from":"2020-03-21","room_stay_to":"2020-03-22","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":"99791","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-21 15:28:10","reservation_modified_date_time":"2020-03-21 16:36:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99791","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":"3084390","reservation_id":"93472","confirmation_number":"BP12274061794","room_confirmation_number":"BP12597836583","room_stay_from":"2020-03-21","room_stay_to":"2020-03-23","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":"46127","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-17 21:07:06","reservation_modified_date_time":"2020-03-21 17:33:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"46127","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":"3051724","reservation_id":"88910","confirmation_number":"BP12238591793","room_confirmation_number":"BP12563514738","room_stay_from":"2020-03-18","room_stay_to":"2020-03-25","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":"94997","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-29 18:49:51","reservation_modified_date_time":"2019-12-29 18:49:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94997","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":"3084423","reservation_id":"92275","confirmation_number":"BP12244352838","room_confirmation_number":"BP12522165322","room_stay_from":"2020-03-21","room_stay_to":"2020-03-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"62637","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-02-20 23:21:07","reservation_modified_date_time":"2020-03-21 20:03:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"62637","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3084305","reservation_id":"93555","confirmation_number":"PB12219134491","room_confirmation_number":"BP12592361149","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":"28.25","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-21 16:37:21","reservation_modified_date_time":"2020-03-21 16:37:21","customer_id":"99791","parentCustTravId":"99791","customer_traveller_id":"99791","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}