{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-03-20","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":24,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1120","block_room_bookings":[{"confirmation_number":"PB12253381233","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","bundle_room":"0"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3081687","reservation_id":"92125","confirmation_number":"PB12370200336","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"183.85,183.85,183.85,183.85,229.06","nightly_discount":"0,0,0,0,0","subtotal":"964.46","grand_total":"1089.84","paid_amount":"1089.84","room_type_id":"289","product_id":"1109","siteminder_id":"EXP-1643723151","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98309","customer_id":"98309","source_of_creation":"Expedia","reservation_created_date":"2020-02-18 02:19:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"229.06","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":"3082572","reservation_id":"93350","confirmation_number":"PB12384731379","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"152.50,152.50,152.50,152.50,190.48","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"800.48","grand_total":"904.54","paid_amount":"904.54","room_type_id":"289","product_id":"1108","siteminder_id":"EXP-1657727321","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":"99647","customer_id":"99647","source_of_creation":"Expedia","reservation_created_date":"2020-03-14 21:17:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"190.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3082600","reservation_id":"91271","confirmation_number":"PB12371208090","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.40,231.40,231.40,231.40,286.54","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1212.14","grand_total":"1369.72","paid_amount":"1369.72","room_type_id":"289","product_id":"1101","siteminder_id":"EXP-1635088544","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99654","customer_id":"99654","source_of_creation":"Expedia","reservation_created_date":"2020-02-04 03:38:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"286.54","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3082603","reservation_id":"91270","confirmation_number":"PB12351295827","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"226.4,226.4,226.4,226.4,281.54","nightly_discount":"0,0,0,0,0","subtotal":"1187.14","grand_total":"1341.47","paid_amount":"1341.47","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1635088550","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99654","customer_id":"99654","source_of_creation":"Expedia","reservation_created_date":"2020-02-04 03:38:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"281.54","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":"3083393","reservation_id":"93474","confirmation_number":"PB12324484315","room_stay_from":"2020-03-18","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"157.7,157.7,157.59","nightly_discount":"0,0,0","subtotal":"472.99","grand_total":"534.48","paid_amount":"534.48","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1658374113","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":"99712","customer_id":"99712","source_of_creation":"Expedia","reservation_created_date":"2020-03-18 14:59:50","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":"157.59","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":"3084010","reservation_id":"93513","confirmation_number":"PB12383280315","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"188.59,185.61","nightly_discount":"0,0","subtotal":"374.20","grand_total":"422.84","paid_amount":"422.84","room_type_id":"291","product_id":"1117","siteminder_id":"EXP-1658589103","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99775","customer_id":"99775","source_of_creation":"Expedia","reservation_created_date":"2020-03-19 02:47:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"185.61","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084013","reservation_id":"93340","confirmation_number":"PB12364995864","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"124.31,154.80,154.80,154.80,154.80,414.60","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1158.11","grand_total":"1308.67","paid_amount":"1308.67","room_type_id":"289","product_id":"1123","siteminder_id":"EXP-1657656328","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99595","customer_id":"99595","source_of_creation":"Expedia","reservation_created_date":"2020-03-14 16:52:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"414.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"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":"156.99","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3083809","reservation_id":"93421","confirmation_number":"BP12595710730","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.25,117.95","nightly_discount":"0,0","subtotal":"193.20","grand_total":"218.31","paid_amount":"218.31","room_type_id":"294","product_id":"1125","siteminder_id":"HTN-123410929-GDXZZT","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":"99757","customer_id":"99757","source_of_creation":"HotelTonight","reservation_created_date":"2020-03-16 19:25:07","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.95","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":"3083839","reservation_id":"93514","confirmation_number":"BP12553741483","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"50.93,65.29","nightly_discount":"0,0","subtotal":"116.22","grand_total":"131.33","paid_amount":"131.33","room_type_id":"293","product_id":"1124","siteminder_id":"HTN-123614811-K32HKG","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":"99761","customer_id":"99761","source_of_creation":"HotelTonight","reservation_created_date":"2020-03-19 03:04:09","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"65.29","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_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":"3082412","reservation_id":"90979","confirmation_number":"PB12310463020","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"173.29,173.29,173.29,173.29,173.29,216.45","nightly_discount":"0,0,0,0,0,0","subtotal":"1082.90","grand_total":"1223.67","paid_amount":"1223.67","room_type_id":"289","product_id":"1097","siteminder_id":"AGO-305863270","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99633","customer_id":"99633","source_of_creation":"Agoda","reservation_created_date":"2020-01-30 22:39:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"216.45","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":"3082494","reservation_id":"89702","confirmation_number":"BV12421793215","room_stay_from":"2020-03-16","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","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":"95690","customer_id":"95690","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":"191.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055549","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":"289","product_id":"1121","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 Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"206.46","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":"3083960","reservation_id":"90233","confirmation_number":"BP12532747165","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","room_stay_status":"Checked-Out","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"169.58,169.58,169.58,169.58","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"678.32","grand_total":"766.50","paid_amount":"461.04","room_type_id":"300","product_id":"1135","siteminder_id":"AGO-303927442","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99441","customer_id":"99441","source_of_creation":"Agoda","reservation_created_date":"2020-01-20 01:46:05","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3070207","reservation_id":"88568","confirmation_number":"PB12382392143","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"218.00,218.00,218.00,218.00,218.00,268.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1358.00","grand_total":"1534.54","paid_amount":"1534.54","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94765","customer_id":"94765","source_of_creation":"FE","reservation_created_date":"2019-12-22 22:12:21","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":"268.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"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":"3071680","reservation_id":"89125","confirmation_number":"PB12349331795","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"276.10,201.00,201.00,201.00,201.00,201.00,276.10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1557.20","grand_total":"1759.63","paid_amount":"1759.63","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"83180","customer_id":"83180","source_of_creation":"PMS","reservation_created_date":"2020-01-02 16:28:25","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"276.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3077787","reservation_id":"92959","confirmation_number":"PB12328953095","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"261.60,261.60,261.60,261.60,261.60,353.76","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1661.76","grand_total":"1877.79","paid_amount":"1877.79","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99127","customer_id":"99127","source_of_creation":"PMS","reservation_created_date":"2020-03-04 21:49:58","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"353.76","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3082146","reservation_id":"86038","confirmation_number":"BV12446222370","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.00,200.00,200.00,200.00,210.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1010.00","grand_total":"1141.30","paid_amount":"1209.10","room_type_id":"308","product_id":"1225","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"56114","customer_id":"56114","source_of_creation":"PMS","reservation_created_date":"2020-03-15 15:51:34","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"210.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3082466","reservation_id":"93411","confirmation_number":"BP12533216487","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"520.00","grand_total":"587.60","paid_amount":"587.60","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"PMS","reservation_created_date":"2020-03-16 17:09:37","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3082916","reservation_id":"72135","confirmation_number":"PB12372797681","room_stay_from":"2020-03-07","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.00,188.00,188.00,188.00,188.00,188.00,188.00,188.00,188.00,188.00,188.00,188.00,188.00,188.00","nightly_discount":"0.00,94.35,94.36,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2632.00","grand_total":"2760.92","paid_amount":"2760.92","room_type_id":"288","product_id":"1091","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23139","customer_id":"23139","source_of_creation":"PMS","reservation_created_date":"2019-03-16 13:45:31","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"188.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083220","reservation_id":"93389","confirmation_number":"BV12474003071","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"156.40,156.40,273.80,273.80","nightly_discount":"0.00,0.00,0.00,44.00","subtotal":"860.40","grand_total":"922.53","paid_amount":"922.54","room_type_id":"309","product_id":"1226","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47098","customer_id":"47098","source_of_creation":"PMS","reservation_created_date":"2020-03-15 20:38:01","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"273.80","currentDayDiscount":"44.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083804","reservation_id":"93528","confirmation_number":"BP12553189153","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.00","nightly_discount":"0.00","subtotal":"117.00","grand_total":"132.21","paid_amount":"132.21","room_type_id":"302","product_id":"1138","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99713","customer_id":"99713","source_of_creation":"PMS","reservation_created_date":"2020-03-19 18:50:45","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083879","reservation_id":"93534","confirmation_number":"BV12466725307","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"132.00","nightly_discount":"0.00","subtotal":"132.00","grand_total":"149.16","paid_amount":"149.16","room_type_id":"307","product_id":"1224","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99769","customer_id":"99769","source_of_creation":"PMS","reservation_created_date":"2020-03-19 23:54:10","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"132.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083967","reservation_id":"73524","confirmation_number":"PB12397631284","room_stay_from":"2020-03-07","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.00,168.00,168.00,168.00,168.00,168.00,168.00,168.00,168.00,168.00,168.00,168.00,168.00,168.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2352.00","grand_total":"2657.76","paid_amount":"2657.76","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"56065","customer_id":"56065","source_of_creation":"PMS","reservation_created_date":"2019-03-29 14:14:41","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"168.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083975","reservation_id":"93448","confirmation_number":"BP12563007337","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"174.80,174.80,174.80,174.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"699.20","grand_total":"790.09","paid_amount":"790.09","room_type_id":"296","product_id":"1130","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99678","customer_id":"99678","source_of_creation":"PMS","reservation_created_date":"2020-03-17 03:08:16","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"174.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084060","reservation_id":"93511","confirmation_number":"PB12382242941","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"195.55","nightly_discount":"2.18","subtotal":"195.55","grand_total":"218.51","paid_amount":"218.51","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":"","currentDayPrice":"195.55","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":"3084062","reservation_id":"81950","confirmation_number":"PB12346472470","room_stay_from":"2020-03-13","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.00,281.00,231.00,231.00,231.00,231.00,231.00,231.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1897.00","grand_total":"2143.61","paid_amount":"2263.88","room_type_id":"291","product_id":"1116","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"66766","customer_id":"66766","source_of_creation":"PMS","reservation_created_date":"2019-08-03 17:21:53","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"231.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"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-In","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":"310.32","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"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":"211.14","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083775","reservation_id":"93465","confirmation_number":"PB12327041832","room_stay_from":"2020-03-19","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"275.00,325.00,325.00","nightly_discount":"51.09,0.00,0.00","subtotal":"925.00","grand_total":"987.51","paid_amount":"987.52","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":"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":"","changedComment":"To date changed","deltaChange":"0.00","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":"292.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"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":"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":"289.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084136","reservation_id":"93544","confirmation_number":"PB12375062057","room_stay_from":"2020-03-20","room_stay_to":"2020-03-25","room_stay_status":"Active","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":"258.77","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":"3084108","reservation_id":"73281","confirmation_number":"PB12388580408","room_stay_from":"2020-04-23","room_stay_to":"2020-05-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"180.00,180.00,180.00,180.00,180.00,180.00,180.00,180.00,180.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1620.00","grand_total":"1830.60","paid_amount":"203.40","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":"44906","customer_id":"44906","source_of_creation":"PMS","reservation_created_date":"2019-03-27 15:14:47","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":"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"}]},{"room_stay_id":"3084123","reservation_id":"85897","confirmation_number":"PB12343682080","room_stay_from":"2020-10-09","room_stay_to":"2020-10-16","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00,150.00,130.00,130.00,130.00,130.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"950.00","grand_total":"1073.50","paid_amount":"146.90","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":"42365","customer_id":"42365","source_of_creation":"PMS","reservation_created_date":"2019-10-18 21:05:32","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":"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"}]},{"room_stay_id":"3084130","reservation_id":"93317","confirmation_number":"PB12352765997","room_stay_from":"2020-04-24","room_stay_to":"2020-05-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"213.00,213.00,213.00,213.00,213.00,213.00,213.00,213.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1704.00","grand_total":"1925.52","paid_amount":"341.26","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99528","customer_id":"99528","source_of_creation":"PMS","reservation_created_date":"2020-03-14 00:15:39","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3070208","reservation_id":"88568","confirmation_number":"PB12271233031","room_confirmation_number":"PB12382392143","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0,0,0,0,0,0","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"0","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-02-15 22:54:16","reservation_modified_date_time":"2020-02-15 22:54:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94765","canceled_nights_data":"","currentDayPrice":"20","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":"3071682","reservation_id":"89125","confirmation_number":"PB12268417097","room_confirmation_number":"PB12349331795","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"30,30,30,30,30,30,30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"210.00","grand_total":"237.30","paid_amount":"237.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"0","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-02-19 22:08:51","reservation_modified_date_time":"2020-02-19 22:08:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83180","canceled_nights_data":"","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":"3081688","reservation_id":"92125","confirmation_number":"PB12211871556","room_confirmation_number":"PB12370200336","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"98309","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-14 16:27:19","reservation_modified_date_time":"2020-03-14 16:27:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98309","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3082410","reservation_id":"90979","confirmation_number":"PB12269983170","room_confirmation_number":"PB12310463020","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","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":"0","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-02-15 22:56:11","reservation_modified_date_time":"2020-03-16 14:24:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99633","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":"3082574","reservation_id":"93350","confirmation_number":"PB12212703440","room_confirmation_number":"PB12384731379","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"30,30,30,30,30","nightly_discount":"0,0,0,0,0","subtotal":"150.00","grand_total":"169.50","paid_amount":"169.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"99647","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-16 19:58:59","reservation_modified_date_time":"2020-03-16 19:58:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99647","canceled_nights_data":"","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":"3082601","reservation_id":"91270","confirmation_number":"PB12218983006","room_confirmation_number":"PB12351295827","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"99654","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-02-15 22:54:00","reservation_modified_date_time":"2020-03-16 20:18:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99654","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083161","reservation_id":"93389","confirmation_number":"BV12255945876","room_confirmation_number":"BV12474003071","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0.00,0.00,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"47098","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-17 19:17:15","reservation_modified_date_time":"2020-03-17 19:17:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47098","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":"3083391","reservation_id":"93474","confirmation_number":"PB12297589694","room_confirmation_number":"PB12324484315","room_stay_from":"2020-03-18","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"99712","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-18 14:59:50","reservation_modified_date_time":"2020-03-18 15:03:58","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99712","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":"3083625","reservation_id":"93511","confirmation_number":"PB12250710441","room_confirmation_number":"PB12382242941","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"30","nightly_discount":"0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"99744","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-19 02:31:24","reservation_modified_date_time":"2020-03-19 02:31:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99744","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"}]},{"room_stay_id":"3083976","reservation_id":"93448","confirmation_number":"BP12233445392","room_confirmation_number":"BP12563007337","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"99678","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-20 13:42:03","reservation_modified_date_time":"2020-03-20 13:42:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99678","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"60.00","currentDayPrice":"20","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":"3084008","reservation_id":"93513","confirmation_number":"PB12230356828","room_confirmation_number":"PB12383280315","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"99775","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-19 02:47:09","reservation_modified_date_time":"2020-03-20 14:58:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99775","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":"3084015","reservation_id":"93340","confirmation_number":"PB12256916851","room_confirmation_number":"PB12364995864","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,10.00,10.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"99595","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-19 15:43:36","reservation_modified_date_time":"2020-03-20 15:00:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99595","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":"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":"3082496","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":"95690","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-16 18:29:59","reservation_modified_date_time":"2020-03-16 18:29:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95690","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":"3083150","reservation_id":"93465","confirmation_number":"PB12296614359","room_confirmation_number":"PB12327041832","room_stay_from":"2020-03-19","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"58370","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-17 19:00:29","reservation_modified_date_time":"2020-03-17 19:00:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58370","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":"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":"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":"0.00","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"}]},{"room_stay_id":"3055550","reservation_id":"89600","confirmation_number":"PB12215989074","room_confirmation_number":"PB12365625847","room_stay_from":"2020-03-20","room_stay_to":"2020-03-26","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0,0,0,0,0,0","subtotal":"120.00","grand_total":"135.60","paid_amount":"0.01","product_id":"1780","service_quantity":"1","customer_traveller_id":"95591","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-01-09 00:37:32","reservation_modified_date_time":"2020-01-09 00:37:32","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95591","canceled_nights_data":"","currentDayPrice":"20","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":"3083961","reservation_id":"90233","confirmation_number":"BP12278249115","room_confirmation_number":"BP12532747165","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","room_stay_status":"Active","nightly_price":"40,40,40,40","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"99441","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-20 12:40:43","reservation_modified_date_time":"2020-03-20 12:40:43","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99441","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"80.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":"3083193","reservation_id":"93422","confirmation_number":"BP12221317828","room_confirmation_number":"BP12573834553","room_stay_from":"2020-03-16","room_stay_to":"2020-03-17","room_stay_status":"Canceled","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-16 19:34:08","reservation_modified_date_time":"2020-03-17 20:19:54","customer_id":"99655","parentCustTravId":"99655","customer_traveller_id":"99655","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-03-20 19:10:44","canceled_nights_data":"","product_attribute_values":"extra_person#&#10.00","deltaChange":-20,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3070209","reservation_id":"88568","confirmation_number":"PB12291582279","room_confirmation_number":"PB12382392143","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"94765","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-22 22:12:21","reservation_modified_date_time":"2020-02-15 22:54:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94765","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":"3071683","reservation_id":"89125","confirmation_number":"PB12221328766","room_confirmation_number":"PB12349331795","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","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":"83180","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-02 16:28:25","reservation_modified_date_time":"2020-02-19 22:08:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83180","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":"3077788","reservation_id":"92959","confirmation_number":"PB12262757000","room_confirmation_number":"PB12328953095","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"99127","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-04 21:49:58","reservation_modified_date_time":"2020-03-04 21:49:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99127","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":"3081689","reservation_id":"92125","confirmation_number":"PB12242393558","room_confirmation_number":"PB12370200336","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","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":"98309","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-02-18 02:19:08","reservation_modified_date_time":"2020-03-14 16:27:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98309","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":"3082147","reservation_id":"86038","confirmation_number":"BV12225077945","room_confirmation_number":"BV12446222370","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"56114","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-15 15:51:34","reservation_modified_date_time":"2020-03-15 16:02:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56114","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":"3082411","reservation_id":"90979","confirmation_number":"PB12230919989","room_confirmation_number":"PB12310463020","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","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":"99633","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-30 22:39:08","reservation_modified_date_time":"2020-03-16 14:24:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99633","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":"3082467","reservation_id":"93411","confirmation_number":"BP12224820335","room_confirmation_number":"BP12533216487","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","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":"47798","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-16 17:09:37","reservation_modified_date_time":"2020-03-16 17:09:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3082575","reservation_id":"93350","confirmation_number":"PB12260265894","room_confirmation_number":"PB12384731379","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","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":"99647","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-14 21:17:08","reservation_modified_date_time":"2020-03-16 19:59:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99647","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":"3082599","reservation_id":"91271","confirmation_number":"PB12265950973","room_confirmation_number":"PB12371208090","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","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":"99654","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-02-04 03:38:13","reservation_modified_date_time":"2020-03-16 20:17:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99654","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":"3082602","reservation_id":"91270","confirmation_number":"PB12299416458","room_confirmation_number":"PB12351295827","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","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":"97393","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-02-04 03:38:10","reservation_modified_date_time":"2020-03-16 20:18:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99654","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":"3082917","reservation_id":"72135","confirmation_number":"PB12238217450","room_confirmation_number":"PB12372797681","room_stay_from":"2020-03-07","room_stay_to":"2020-03-21","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23139","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-03-16 13:45:31","reservation_modified_date_time":"2020-03-17 13:33:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23139","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":"3083221","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":"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":"47098","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-15 20:38:01","reservation_modified_date_time":"2020-03-17 22:36:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47098","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":"3083392","reservation_id":"93474","confirmation_number":"PB12253437284","room_confirmation_number":"PB12324484315","room_stay_from":"2020-03-18","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"99712","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-18 14:59:50","reservation_modified_date_time":"2020-03-18 15:03:58","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99712","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":"3083805","reservation_id":"93528","confirmation_number":"BP12233538379","room_confirmation_number":"BP12553189153","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"99713","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 18:50:45","reservation_modified_date_time":"2020-03-19 18:50:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99713","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":"3083808","reservation_id":"93421","confirmation_number":"BP12248604147","room_confirmation_number":"BP12595710730","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","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":"99757","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-16 19:25:07","reservation_modified_date_time":"2020-03-19 18:54:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99757","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":"3083838","reservation_id":"93514","confirmation_number":"BP12228854879","room_confirmation_number":"BP12553741483","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","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":"99761","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-19 03:04:09","reservation_modified_date_time":"2020-03-19 20:40:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99761","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":"3083880","reservation_id":"93534","confirmation_number":"BV12286489514","room_confirmation_number":"BV12466725307","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"99769","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 23:54:10","reservation_modified_date_time":"2020-03-19 23:54:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99769","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":"3083968","reservation_id":"73524","confirmation_number":"PB12287739109","room_confirmation_number":"PB12397631284","room_stay_from":"2020-03-07","room_stay_to":"2020-03-21","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"56065","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-03-29 14:14:41","reservation_modified_date_time":"2020-03-20 12:59:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56065","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083977","reservation_id":"93448","confirmation_number":"BP12260709882","room_confirmation_number":"BP12563007337","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","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":"99678","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-17 03:08:16","reservation_modified_date_time":"2020-03-20 13:42:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99678","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":"3084009","reservation_id":"93513","confirmation_number":"PB12286875263","room_confirmation_number":"PB12383280315","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","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":"99775","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-19 02:47:09","reservation_modified_date_time":"2020-03-20 14:58:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99775","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":"3084014","reservation_id":"93340","confirmation_number":"PB12274143112","room_confirmation_number":"PB12364995864","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","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":"99595","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-14 16:52:09","reservation_modified_date_time":"2020-03-20 15:00:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99595","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":"3084061","reservation_id":"93511","confirmation_number":"PB12267913779","room_confirmation_number":"PB12382242941","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"99744","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 02:31:24","reservation_modified_date_time":"2020-03-20 17:19:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99744","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":"3084063","reservation_id":"81950","confirmation_number":"PB12211368915","room_confirmation_number":"PB12346472470","room_stay_from":"2020-03-13","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"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","subtotal":"96.00","grand_total":"108.48","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"66766","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-03 17:21:53","reservation_modified_date_time":"2020-03-20 17:26:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66766","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":"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":"3082497","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":"95690","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-10 16:22:10","reservation_modified_date_time":"2020-03-16 18:30:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95690","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":"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":"3083776","reservation_id":"93465","confirmation_number":"PB12251502504","room_confirmation_number":"PB12327041832","room_stay_from":"2020-03-19","room_stay_to":"2020-03-22","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":"58370","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-17 19:00:29","reservation_modified_date_time":"2020-03-19 16:13:53","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":"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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"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":"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":"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":"0.00","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":"3055551","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-01-09 00:03:09","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":"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":"3083962","reservation_id":"90233","confirmation_number":"BP12239749613","room_confirmation_number":"BP12532747165","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","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":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"99441","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-20 01:46:05","reservation_modified_date_time":"2020-03-20 12:40:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99441","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084110","reservation_id":"73281","confirmation_number":"PB12276823479","room_confirmation_number":"PB12388580408","room_stay_from":"2020-04-23","room_stay_to":"2020-05-02","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"44906","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-03-27 15:14:47","reservation_modified_date_time":"2020-03-21 00:13:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44906","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"}]},{"room_stay_id":"3084124","reservation_id":"85897","confirmation_number":"PB12241505058","room_confirmation_number":"PB12343682080","room_stay_from":"2020-10-09","room_stay_to":"2020-10-16","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"42365","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-18 21:05:32","reservation_modified_date_time":"2020-03-21 00:38:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42365","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"}]},{"room_stay_id":"3084132","reservation_id":"93317","confirmation_number":"PB12264360667","room_confirmation_number":"PB12352765997","room_stay_from":"2020-04-24","room_stay_to":"2020-05-02","room_stay_status":"Active","nightly_price":"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","subtotal":"96.00","grand_total":"108.48","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"99528","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-14 00:15:39","reservation_modified_date_time":"2020-03-21 01:45:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99528","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":"3082284","reservation_id":"93389","confirmation_number":"BV12224097591","room_confirmation_number":"BV12474003071","room_stay_from":"2020-03-18","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.75","paid_amount":"84.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-15 20:38:01","reservation_modified_date_time":"2020-03-15 20:38:01","customer_id":"47098","parentCustTravId":"47098","customer_traveller_id":"47098","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3083978","reservation_id":"93448","confirmation_number":"BP12270207559","room_confirmation_number":"BP12563007337","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-20 13:42:56","reservation_modified_date_time":"2020-03-20 13:42:56","customer_id":"99678","parentCustTravId":"99678","customer_traveller_id":"99678","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3084053","reservation_id":"93511","confirmation_number":"PB12295345138","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":"4.21","grand_total":"4.50","paid_amount":"4.50","product_id":"1144","service_quantity":"1","product_name":"Aloe Lotion\/ Gel","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-20 17:16:09","reservation_modified_date_time":"2020-03-20 17:16:09","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":"4.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3083971","reservation_id":"93537","confirmation_number":"PB12267266890","room_confirmation_number":"PB12345494568","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-20 13:33:18","reservation_modified_date_time":"2020-03-20 13:33:18","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"}]},{"room_stay_id":"3083988","reservation_id":"93538","confirmation_number":"PB12262982485","room_confirmation_number":"PB12338503046","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-20 13:55:42","reservation_modified_date_time":"2020-03-20 13:55:42","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3084081","reservation_id":"93548","confirmation_number":"PB12260699084","room_confirmation_number":"PB12350521433","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":null,"service_quantity":"4","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-20 18:48:52","reservation_modified_date_time":"2020-03-20 18:48:52","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","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":10,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1120","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12253381233","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3081687","reservation_id":"92125","confirmation_number":"PB12370200336","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"183.85,183.85,183.85,183.85,229.06","nightly_discount":"0,0,0,0,0","subtotal":"964.46","grand_total":"1089.84","paid_amount":"1089.84","room_type_id":"289","product_id":"1109","siteminder_id":"EXP-1643723151","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98309","customer_id":"98309","source_of_creation":"Expedia","reservation_created_date":"2020-02-18 02:19:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"229.06","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":"3082572","reservation_id":"93350","confirmation_number":"PB12384731379","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"152.50,152.50,152.50,152.50,190.48","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"800.48","grand_total":"904.54","paid_amount":"904.54","room_type_id":"289","product_id":"1108","siteminder_id":"EXP-1657727321","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":"99647","customer_id":"99647","source_of_creation":"Expedia","reservation_created_date":"2020-03-14 21:17:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"190.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3082600","reservation_id":"91271","confirmation_number":"PB12371208090","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.40,231.40,231.40,231.40,286.54","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1212.14","grand_total":"1369.72","paid_amount":"1369.72","room_type_id":"289","product_id":"1101","siteminder_id":"EXP-1635088544","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99654","customer_id":"99654","source_of_creation":"Expedia","reservation_created_date":"2020-02-04 03:38:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"286.54","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3082603","reservation_id":"91270","confirmation_number":"PB12351295827","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"226.4,226.4,226.4,226.4,281.54","nightly_discount":"0,0,0,0,0","subtotal":"1187.14","grand_total":"1341.47","paid_amount":"1341.47","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1635088550","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99654","customer_id":"99654","source_of_creation":"Expedia","reservation_created_date":"2020-02-04 03:38:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"281.54","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":"3083393","reservation_id":"93474","confirmation_number":"PB12324484315","room_stay_from":"2020-03-18","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"157.7,157.7,157.59","nightly_discount":"0,0,0","subtotal":"472.99","grand_total":"534.48","paid_amount":"534.48","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1658374113","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":"99712","customer_id":"99712","source_of_creation":"Expedia","reservation_created_date":"2020-03-18 14:59:50","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":"157.59","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":"3084010","reservation_id":"93513","confirmation_number":"PB12383280315","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"188.59,185.61","nightly_discount":"0,0","subtotal":"374.20","grand_total":"422.84","paid_amount":"422.84","room_type_id":"291","product_id":"1117","siteminder_id":"EXP-1658589103","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99775","customer_id":"99775","source_of_creation":"Expedia","reservation_created_date":"2020-03-19 02:47:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"185.61","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084013","reservation_id":"93340","confirmation_number":"PB12364995864","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"124.31,154.80,154.80,154.80,154.80,414.60","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1158.11","grand_total":"1308.67","paid_amount":"1308.67","room_type_id":"289","product_id":"1123","siteminder_id":"EXP-1657656328","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99595","customer_id":"99595","source_of_creation":"Expedia","reservation_created_date":"2020-03-14 16:52:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"414.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"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":"156.99","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_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":"3082412","reservation_id":"90979","confirmation_number":"PB12310463020","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"173.29,173.29,173.29,173.29,173.29,216.45","nightly_discount":"0,0,0,0,0,0","subtotal":"1082.90","grand_total":"1223.67","paid_amount":"1223.67","room_type_id":"289","product_id":"1097","siteminder_id":"AGO-305863270","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99633","customer_id":"99633","source_of_creation":"Agoda","reservation_created_date":"2020-01-30 22:39:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"216.45","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":"3055549","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":"289","product_id":"1121","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 Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"206.46","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3070207","reservation_id":"88568","confirmation_number":"PB12382392143","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"218.00,218.00,218.00,218.00,218.00,268.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1358.00","grand_total":"1534.54","paid_amount":"1534.54","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94765","customer_id":"94765","source_of_creation":"FE","reservation_created_date":"2019-12-22 22:12:21","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":"268.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3071680","reservation_id":"89125","confirmation_number":"PB12349331795","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"276.10,201.00,201.00,201.00,201.00,201.00,276.10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1557.20","grand_total":"1759.63","paid_amount":"1759.63","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"83180","customer_id":"83180","source_of_creation":"PMS","reservation_created_date":"2020-01-02 16:28:25","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"276.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3077787","reservation_id":"92959","confirmation_number":"PB12328953095","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"261.60,261.60,261.60,261.60,261.60,353.76","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1661.76","grand_total":"1877.79","paid_amount":"1877.79","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99127","customer_id":"99127","source_of_creation":"PMS","reservation_created_date":"2020-03-04 21:49:58","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"353.76","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3082916","reservation_id":"72135","confirmation_number":"PB12372797681","room_stay_from":"2020-03-07","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.00,188.00,188.00,188.00,188.00,188.00,188.00,188.00,188.00,188.00,188.00,188.00,188.00,188.00","nightly_discount":"0.00,94.35,94.36,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2632.00","grand_total":"2760.92","paid_amount":"2760.92","room_type_id":"288","product_id":"1091","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23139","customer_id":"23139","source_of_creation":"PMS","reservation_created_date":"2019-03-16 13:45:31","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"188.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083967","reservation_id":"73524","confirmation_number":"PB12397631284","room_stay_from":"2020-03-07","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.00,168.00,168.00,168.00,168.00,168.00,168.00,168.00,168.00,168.00,168.00,168.00,168.00,168.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2352.00","grand_total":"2657.76","paid_amount":"2657.76","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"56065","customer_id":"56065","source_of_creation":"PMS","reservation_created_date":"2019-03-29 14:14:41","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"168.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084060","reservation_id":"93511","confirmation_number":"PB12382242941","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"195.55","nightly_discount":"2.18","subtotal":"195.55","grand_total":"218.51","paid_amount":"218.51","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":"","currentDayPrice":"195.55","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":"3084062","reservation_id":"81950","confirmation_number":"PB12346472470","room_stay_from":"2020-03-13","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.00,281.00,231.00,231.00,231.00,231.00,231.00,231.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1897.00","grand_total":"2143.61","paid_amount":"2263.88","room_type_id":"291","product_id":"1116","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"66766","customer_id":"66766","source_of_creation":"PMS","reservation_created_date":"2019-08-03 17:21:53","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"231.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"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-In","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":"310.32","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"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":"3083775","reservation_id":"93465","confirmation_number":"PB12327041832","room_stay_from":"2020-03-19","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"275.00,325.00,325.00","nightly_discount":"51.09,0.00,0.00","subtotal":"925.00","grand_total":"987.51","paid_amount":"987.52","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":"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":"","changedComment":"To date changed","deltaChange":"0.00","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":"292.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"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":"3084136","reservation_id":"93544","confirmation_number":"PB12375062057","room_stay_from":"2020-03-20","room_stay_to":"2020-03-25","room_stay_status":"Active","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":"258.77","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":"3084108","reservation_id":"73281","confirmation_number":"PB12388580408","room_stay_from":"2020-04-23","room_stay_to":"2020-05-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"180.00,180.00,180.00,180.00,180.00,180.00,180.00,180.00,180.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1620.00","grand_total":"1830.60","paid_amount":"203.40","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":"44906","customer_id":"44906","source_of_creation":"PMS","reservation_created_date":"2019-03-27 15:14:47","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":"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"}]},{"room_stay_id":"3084123","reservation_id":"85897","confirmation_number":"PB12343682080","room_stay_from":"2020-10-09","room_stay_to":"2020-10-16","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00,150.00,130.00,130.00,130.00,130.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"950.00","grand_total":"1073.50","paid_amount":"146.90","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":"42365","customer_id":"42365","source_of_creation":"PMS","reservation_created_date":"2019-10-18 21:05:32","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":"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"}]},{"room_stay_id":"3084130","reservation_id":"93317","confirmation_number":"PB12352765997","room_stay_from":"2020-04-24","room_stay_to":"2020-05-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"213.00,213.00,213.00,213.00,213.00,213.00,213.00,213.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1704.00","grand_total":"1925.52","paid_amount":"341.26","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99528","customer_id":"99528","source_of_creation":"PMS","reservation_created_date":"2020-03-14 00:15:39","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3070208","reservation_id":"88568","confirmation_number":"PB12271233031","room_confirmation_number":"PB12382392143","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0,0,0,0,0,0","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"0","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-02-15 22:54:16","reservation_modified_date_time":"2020-02-15 22:54:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94765","canceled_nights_data":"","currentDayPrice":"20","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":"3071682","reservation_id":"89125","confirmation_number":"PB12268417097","room_confirmation_number":"PB12349331795","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"30,30,30,30,30,30,30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"210.00","grand_total":"237.30","paid_amount":"237.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"0","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-02-19 22:08:51","reservation_modified_date_time":"2020-02-19 22:08:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83180","canceled_nights_data":"","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":"3081688","reservation_id":"92125","confirmation_number":"PB12211871556","room_confirmation_number":"PB12370200336","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"98309","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-14 16:27:19","reservation_modified_date_time":"2020-03-14 16:27:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98309","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3082410","reservation_id":"90979","confirmation_number":"PB12269983170","room_confirmation_number":"PB12310463020","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","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":"0","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-02-15 22:56:11","reservation_modified_date_time":"2020-03-16 14:24:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99633","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":"3082574","reservation_id":"93350","confirmation_number":"PB12212703440","room_confirmation_number":"PB12384731379","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"30,30,30,30,30","nightly_discount":"0,0,0,0,0","subtotal":"150.00","grand_total":"169.50","paid_amount":"169.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"99647","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-16 19:58:59","reservation_modified_date_time":"2020-03-16 19:58:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99647","canceled_nights_data":"","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":"3082601","reservation_id":"91270","confirmation_number":"PB12218983006","room_confirmation_number":"PB12351295827","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"99654","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-02-15 22:54:00","reservation_modified_date_time":"2020-03-16 20:18:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99654","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083391","reservation_id":"93474","confirmation_number":"PB12297589694","room_confirmation_number":"PB12324484315","room_stay_from":"2020-03-18","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"99712","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-18 14:59:50","reservation_modified_date_time":"2020-03-18 15:03:58","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99712","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":"3083625","reservation_id":"93511","confirmation_number":"PB12250710441","room_confirmation_number":"PB12382242941","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"30","nightly_discount":"0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"99744","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-19 02:31:24","reservation_modified_date_time":"2020-03-19 02:31:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99744","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"}]},{"room_stay_id":"3084008","reservation_id":"93513","confirmation_number":"PB12230356828","room_confirmation_number":"PB12383280315","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"99775","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-19 02:47:09","reservation_modified_date_time":"2020-03-20 14:58:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99775","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":"3084015","reservation_id":"93340","confirmation_number":"PB12256916851","room_confirmation_number":"PB12364995864","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,10.00,10.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"99595","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-19 15:43:36","reservation_modified_date_time":"2020-03-20 15:00:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99595","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":"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":"3083150","reservation_id":"93465","confirmation_number":"PB12296614359","room_confirmation_number":"PB12327041832","room_stay_from":"2020-03-19","room_stay_to":"2020-03-22","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"58370","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-17 19:00:29","reservation_modified_date_time":"2020-03-17 19:00:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58370","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":"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":"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":"0.00","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"}]},{"room_stay_id":"3055550","reservation_id":"89600","confirmation_number":"PB12215989074","room_confirmation_number":"PB12365625847","room_stay_from":"2020-03-20","room_stay_to":"2020-03-26","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0,0,0,0,0,0","subtotal":"120.00","grand_total":"135.60","paid_amount":"0.01","product_id":"1780","service_quantity":"1","customer_traveller_id":"95591","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-01-09 00:37:32","reservation_modified_date_time":"2020-01-09 00:37:32","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95591","canceled_nights_data":"","currentDayPrice":"20","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":"3070209","reservation_id":"88568","confirmation_number":"PB12291582279","room_confirmation_number":"PB12382392143","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"94765","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-22 22:12:21","reservation_modified_date_time":"2020-02-15 22:54:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94765","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":"3071683","reservation_id":"89125","confirmation_number":"PB12221328766","room_confirmation_number":"PB12349331795","room_stay_from":"2020-03-14","room_stay_to":"2020-03-21","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":"83180","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-02 16:28:25","reservation_modified_date_time":"2020-02-19 22:08:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83180","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":"3077788","reservation_id":"92959","confirmation_number":"PB12262757000","room_confirmation_number":"PB12328953095","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"99127","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-04 21:49:58","reservation_modified_date_time":"2020-03-04 21:49:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99127","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":"3081689","reservation_id":"92125","confirmation_number":"PB12242393558","room_confirmation_number":"PB12370200336","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","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":"98309","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-02-18 02:19:08","reservation_modified_date_time":"2020-03-14 16:27:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98309","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":"3082411","reservation_id":"90979","confirmation_number":"PB12230919989","room_confirmation_number":"PB12310463020","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","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":"99633","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-30 22:39:08","reservation_modified_date_time":"2020-03-16 14:24:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99633","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":"3082575","reservation_id":"93350","confirmation_number":"PB12260265894","room_confirmation_number":"PB12384731379","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","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":"99647","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-14 21:17:08","reservation_modified_date_time":"2020-03-16 19:59:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99647","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":"3082599","reservation_id":"91271","confirmation_number":"PB12265950973","room_confirmation_number":"PB12371208090","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","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":"99654","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-02-04 03:38:13","reservation_modified_date_time":"2020-03-16 20:17:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99654","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":"3082602","reservation_id":"91270","confirmation_number":"PB12299416458","room_confirmation_number":"PB12351295827","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","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":"97393","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-02-04 03:38:10","reservation_modified_date_time":"2020-03-16 20:18:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99654","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":"3082917","reservation_id":"72135","confirmation_number":"PB12238217450","room_confirmation_number":"PB12372797681","room_stay_from":"2020-03-07","room_stay_to":"2020-03-21","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23139","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-03-16 13:45:31","reservation_modified_date_time":"2020-03-17 13:33:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23139","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":"3083392","reservation_id":"93474","confirmation_number":"PB12253437284","room_confirmation_number":"PB12324484315","room_stay_from":"2020-03-18","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"99712","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-18 14:59:50","reservation_modified_date_time":"2020-03-18 15:03:58","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99712","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":"3083968","reservation_id":"73524","confirmation_number":"PB12287739109","room_confirmation_number":"PB12397631284","room_stay_from":"2020-03-07","room_stay_to":"2020-03-21","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"56065","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-03-29 14:14:41","reservation_modified_date_time":"2020-03-20 12:59:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56065","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3084009","reservation_id":"93513","confirmation_number":"PB12286875263","room_confirmation_number":"PB12383280315","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","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":"99775","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-19 02:47:09","reservation_modified_date_time":"2020-03-20 14:58:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99775","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":"3084014","reservation_id":"93340","confirmation_number":"PB12274143112","room_confirmation_number":"PB12364995864","room_stay_from":"2020-03-15","room_stay_to":"2020-03-21","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":"99595","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-14 16:52:09","reservation_modified_date_time":"2020-03-20 15:00:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99595","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":"3084061","reservation_id":"93511","confirmation_number":"PB12267913779","room_confirmation_number":"PB12382242941","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"99744","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 02:31:24","reservation_modified_date_time":"2020-03-20 17:19:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99744","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":"3084063","reservation_id":"81950","confirmation_number":"PB12211368915","room_confirmation_number":"PB12346472470","room_stay_from":"2020-03-13","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"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","subtotal":"96.00","grand_total":"108.48","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"66766","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-03 17:21:53","reservation_modified_date_time":"2020-03-20 17:26:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66766","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":"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":"3083776","reservation_id":"93465","confirmation_number":"PB12251502504","room_confirmation_number":"PB12327041832","room_stay_from":"2020-03-19","room_stay_to":"2020-03-22","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":"58370","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-17 19:00:29","reservation_modified_date_time":"2020-03-19 16:13:53","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":"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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"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":"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":"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":"0.00","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":"3055551","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-01-09 00:03:09","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":"3084110","reservation_id":"73281","confirmation_number":"PB12276823479","room_confirmation_number":"PB12388580408","room_stay_from":"2020-04-23","room_stay_to":"2020-05-02","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"44906","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-03-27 15:14:47","reservation_modified_date_time":"2020-03-21 00:13:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44906","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"}]},{"room_stay_id":"3084124","reservation_id":"85897","confirmation_number":"PB12241505058","room_confirmation_number":"PB12343682080","room_stay_from":"2020-10-09","room_stay_to":"2020-10-16","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"42365","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-18 21:05:32","reservation_modified_date_time":"2020-03-21 00:38:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42365","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"}]},{"room_stay_id":"3084132","reservation_id":"93317","confirmation_number":"PB12264360667","room_confirmation_number":"PB12352765997","room_stay_from":"2020-04-24","room_stay_to":"2020-05-02","room_stay_status":"Active","nightly_price":"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","subtotal":"96.00","grand_total":"108.48","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"99528","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-14 00:15:39","reservation_modified_date_time":"2020-03-21 01:45:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99528","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":"3084053","reservation_id":"93511","confirmation_number":"PB12295345138","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":"4.21","grand_total":"4.50","paid_amount":"4.50","product_id":"1144","service_quantity":"1","product_name":"Aloe Lotion\/ Gel","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-20 17:16:09","reservation_modified_date_time":"2020-03-20 17:16:09","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":"4.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3083971","reservation_id":"93537","confirmation_number":"PB12267266890","room_confirmation_number":"PB12345494568","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-20 13:33:18","reservation_modified_date_time":"2020-03-20 13:33:18","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"}]},{"room_stay_id":"3083988","reservation_id":"93538","confirmation_number":"PB12262982485","room_confirmation_number":"PB12338503046","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-20 13:55:42","reservation_modified_date_time":"2020-03-20 13:55:42","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3084081","reservation_id":"93548","confirmation_number":"PB12260699084","room_confirmation_number":"PB12350521433","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":null,"service_quantity":"4","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-20 18:48:52","reservation_modified_date_time":"2020-03-20 18:48:52","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"3.72","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":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_non_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":"3082494","reservation_id":"89702","confirmation_number":"BV12421793215","room_stay_from":"2020-03-16","room_stay_to":"2020-03-22","room_stay_status":"Checked-In","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":"95690","customer_id":"95690","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":"191.73","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"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":"3082146","reservation_id":"86038","confirmation_number":"BV12446222370","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.00,200.00,200.00,200.00,210.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1010.00","grand_total":"1141.30","paid_amount":"1209.10","room_type_id":"308","product_id":"1225","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"56114","customer_id":"56114","source_of_creation":"PMS","reservation_created_date":"2020-03-15 15:51:34","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"210.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083220","reservation_id":"93389","confirmation_number":"BV12474003071","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"156.40,156.40,273.80,273.80","nightly_discount":"0.00,0.00,0.00,44.00","subtotal":"860.40","grand_total":"922.53","paid_amount":"922.54","room_type_id":"309","product_id":"1226","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47098","customer_id":"47098","source_of_creation":"PMS","reservation_created_date":"2020-03-15 20:38:01","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"273.80","currentDayDiscount":"44.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083879","reservation_id":"93534","confirmation_number":"BV12466725307","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"132.00","nightly_discount":"0.00","subtotal":"132.00","grand_total":"149.16","paid_amount":"149.16","room_type_id":"307","product_id":"1224","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99769","customer_id":"99769","source_of_creation":"PMS","reservation_created_date":"2020-03-19 23:54:10","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"132.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"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":"211.14","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"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":"3083161","reservation_id":"93389","confirmation_number":"BV12255945876","room_confirmation_number":"BV12474003071","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0.00,0.00,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"47098","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-17 19:17:15","reservation_modified_date_time":"2020-03-17 19:17:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47098","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":"3082496","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":"95690","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-03-16 18:29:59","reservation_modified_date_time":"2020-03-16 18:29:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95690","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":"3082147","reservation_id":"86038","confirmation_number":"BV12225077945","room_confirmation_number":"BV12446222370","room_stay_from":"2020-03-16","room_stay_to":"2020-03-21","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"56114","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-15 15:51:34","reservation_modified_date_time":"2020-03-15 16:02:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56114","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":"3083221","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":"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":"47098","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-15 20:38:01","reservation_modified_date_time":"2020-03-17 22:36:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47098","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":"3083880","reservation_id":"93534","confirmation_number":"BV12286489514","room_confirmation_number":"BV12466725307","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"99769","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 23:54:10","reservation_modified_date_time":"2020-03-19 23:54:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99769","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":"3082497","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":"95690","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-10 16:22:10","reservation_modified_date_time":"2020-03-16 18:30:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95690","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":"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":"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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3082284","reservation_id":"93389","confirmation_number":"BV12224097591","room_confirmation_number":"BV12474003071","room_stay_from":"2020-03-18","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.75","paid_amount":"84.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-15 20:38:01","reservation_modified_date_time":"2020-03-15 20:38:01","customer_id":"47098","parentCustTravId":"47098","customer_traveller_id":"47098","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":9,"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_non_taxable":[],"htn_taxable":[{"room_stay_id":"3083809","reservation_id":"93421","confirmation_number":"BP12595710730","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.25,117.95","nightly_discount":"0,0","subtotal":"193.20","grand_total":"218.31","paid_amount":"218.31","room_type_id":"294","product_id":"1125","siteminder_id":"HTN-123410929-GDXZZT","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":"99757","customer_id":"99757","source_of_creation":"HotelTonight","reservation_created_date":"2020-03-16 19:25:07","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.95","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":"3083839","reservation_id":"93514","confirmation_number":"BP12553741483","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"50.93,65.29","nightly_discount":"0,0","subtotal":"116.22","grand_total":"131.33","paid_amount":"131.33","room_type_id":"293","product_id":"1124","siteminder_id":"HTN-123614811-K32HKG","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":"99761","customer_id":"99761","source_of_creation":"HotelTonight","reservation_created_date":"2020-03-19 03:04:09","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"65.29","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_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":"3083960","reservation_id":"90233","confirmation_number":"BP12532747165","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","room_stay_status":"Checked-Out","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"169.58,169.58,169.58,169.58","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"678.32","grand_total":"766.50","paid_amount":"461.04","room_type_id":"300","product_id":"1135","siteminder_id":"AGO-303927442","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99441","customer_id":"99441","source_of_creation":"Agoda","reservation_created_date":"2020-01-20 01:46:05","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3082466","reservation_id":"93411","confirmation_number":"BP12533216487","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"520.00","grand_total":"587.60","paid_amount":"587.60","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"PMS","reservation_created_date":"2020-03-16 17:09:37","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083804","reservation_id":"93528","confirmation_number":"BP12553189153","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.00","nightly_discount":"0.00","subtotal":"117.00","grand_total":"132.21","paid_amount":"132.21","room_type_id":"302","product_id":"1138","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99713","customer_id":"99713","source_of_creation":"PMS","reservation_created_date":"2020-03-19 18:50:45","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083975","reservation_id":"93448","confirmation_number":"BP12563007337","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"174.80,174.80,174.80,174.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"699.20","grand_total":"790.09","paid_amount":"790.09","room_type_id":"296","product_id":"1130","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99678","customer_id":"99678","source_of_creation":"PMS","reservation_created_date":"2020-03-17 03:08:16","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"174.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"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":"289.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3083976","reservation_id":"93448","confirmation_number":"BP12233445392","room_confirmation_number":"BP12563007337","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"99678","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-20 13:42:03","reservation_modified_date_time":"2020-03-20 13:42:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99678","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"60.00","currentDayPrice":"20","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":"3083961","reservation_id":"90233","confirmation_number":"BP12278249115","room_confirmation_number":"BP12532747165","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","room_stay_status":"Active","nightly_price":"40,40,40,40","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"99441","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-03-20 12:40:43","reservation_modified_date_time":"2020-03-20 12:40:43","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99441","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"80.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":"3083193","reservation_id":"93422","confirmation_number":"BP12221317828","room_confirmation_number":"BP12573834553","room_stay_from":"2020-03-16","room_stay_to":"2020-03-17","room_stay_status":"Canceled","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-16 19:34:08","reservation_modified_date_time":"2020-03-17 20:19:54","customer_id":"99655","parentCustTravId":"99655","customer_traveller_id":"99655","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-03-20 19:10:44","canceled_nights_data":"","product_attribute_values":"extra_person#&#10.00","deltaChange":-20,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3082467","reservation_id":"93411","confirmation_number":"BP12224820335","room_confirmation_number":"BP12533216487","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","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":"47798","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-16 17:09:37","reservation_modified_date_time":"2020-03-16 17:09:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3083805","reservation_id":"93528","confirmation_number":"BP12233538379","room_confirmation_number":"BP12553189153","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"99713","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 18:50:45","reservation_modified_date_time":"2020-03-19 18:50:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99713","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":"3083808","reservation_id":"93421","confirmation_number":"BP12248604147","room_confirmation_number":"BP12595710730","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","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":"99757","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-16 19:25:07","reservation_modified_date_time":"2020-03-19 18:54:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99757","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":"3083838","reservation_id":"93514","confirmation_number":"BP12228854879","room_confirmation_number":"BP12553741483","room_stay_from":"2020-03-19","room_stay_to":"2020-03-21","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":"99761","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-19 03:04:09","reservation_modified_date_time":"2020-03-19 20:40:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99761","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":"3083977","reservation_id":"93448","confirmation_number":"BP12260709882","room_confirmation_number":"BP12563007337","room_stay_from":"2020-03-17","room_stay_to":"2020-03-21","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":"99678","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-17 03:08:16","reservation_modified_date_time":"2020-03-20 13:42:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99678","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":"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":"3083962","reservation_id":"90233","confirmation_number":"BP12239749613","room_confirmation_number":"BP12532747165","room_stay_from":"2020-03-16","room_stay_to":"2020-03-20","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":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"99441","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-20 01:46:05","reservation_modified_date_time":"2020-03-20 12:40:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99441","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3083978","reservation_id":"93448","confirmation_number":"BP12270207559","room_confirmation_number":"BP12563007337","room_stay_from":"2020-03-20","room_stay_to":"2020-03-21","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-03-20 13:42:56","reservation_modified_date_time":"2020-03-20 13:42:56","customer_id":"99678","parentCustTravId":"99678","customer_traveller_id":"99678","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}