{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-05-12","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":15,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1226,1113,1084,1224,1140","block_room_bookings":[{"confirmation_number":"BV12279993939","room_stay_from":"2020-05-10","room_stay_to":"2020-05-13","bundle_room":"0"},{"confirmation_number":"PB12237310193","room_stay_from":"2020-05-10","room_stay_to":"2020-05-13","bundle_room":"0"},{"confirmation_number":"PB12223715671","room_stay_from":"2020-05-08","room_stay_to":"2020-05-13","bundle_room":"0"},{"confirmation_number":"BV12274028703","room_stay_from":"2020-05-07","room_stay_to":"2020-05-13","bundle_room":"0"},{"confirmation_number":"BV12290663717","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","bundle_room":"0"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3093094","reservation_id":"94659","confirmation_number":"BP12536723221","room_stay_from":"2020-05-10","room_stay_to":"2020-05-12","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.75,111.75","nightly_discount":"0.00,7.58","subtotal":"223.50","grand_total":"243.99","paid_amount":"243.99","room_type_id":"295","product_id":"1128","siteminder_id":"BDC-3935418550","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100859","customer_id":"100859","source_of_creation":"Booking.com","reservation_created_date":"2020-05-11 01:08:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"47.43","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"-1.45","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3092661","reservation_id":"94582","confirmation_number":"BP12543077539","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.44,124.44","nightly_discount":"0,0","subtotal":"248.88","grand_total":"281.23","paid_amount":"281.23","room_type_id":"300","product_id":"1135","siteminder_id":"EXP-1663325546","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":"92253","customer_id":"92253","source_of_creation":"Expedia","reservation_created_date":"2020-05-08 22:16:05","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 805","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.44","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":"3092770","reservation_id":"94636","confirmation_number":"BP12582834053","room_stay_from":"2020-05-10","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"154.54,154.54,154.54,154.54","nightly_discount":"0,0,0,0","subtotal":"618.16","grand_total":"698.52","paid_amount":"698.52","room_type_id":"296","product_id":"1131","siteminder_id":"EXP-1663504401","collect_which":"hotel_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":"100857","customer_id":"100857","source_of_creation":"Expedia","reservation_created_date":"2020-05-10 14:26:10","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"154.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"}]}],"exp_non_taxable":[{"room_stay_id":"3093198","reservation_id":"93450","confirmation_number":"BP12552535566","room_stay_from":"2020-03-17","room_stay_to":"2020-03-18","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.20","nightly_discount":"0","subtotal":"123.20","grand_total":"139.21","paid_amount":"0.00","room_type_id":"295","product_id":"1128","siteminder_id":"EXP-1658309514","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":"99680","customer_id":"99680","source_of_creation":"Expedia","reservation_created_date":"2020-03-17 14:02:05","service_canceled_date_time":"2020-05-12 20:15:24","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"canceled resv amount refunded","total_paid_amount":"0.00","deltaChange":"0.00","changedComment":"resv paid or refunded after cancel","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3093207","reservation_id":"94349","confirmation_number":"PB12313626819","room_stay_from":"2020-05-12","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.29,117.29,117.29,143.47,143.47,117.29,117.29","nightly_discount":"0,0,0,0,0,0,0","subtotal":"873.39","grand_total":"986.93","paid_amount":"986.93","room_type_id":"289","product_id":"1111","siteminder_id":"GAM-R1953915007","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":"83852","customer_id":"83852","source_of_creation":"Getaroom.com","reservation_created_date":"2020-05-02 18:11:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3092327","reservation_id":"94591","confirmation_number":"BP12588905868","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.03,96.03","nightly_discount":"0,0","subtotal":"192.06","grand_total":"250.59","paid_amount":"250.59","room_type_id":"298","product_id":"1133","siteminder_id":"ABB-HMKZ54EAZQ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"192.06","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100791","customer_id":"100825","source_of_creation":"Airbnb","reservation_created_date":"2020-05-09 02:57:07","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"26.85","commision_charges":"5.94","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.03","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3093164","reservation_id":"94703","confirmation_number":"BV12486051953","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"65.10,65.10,65.10","nightly_discount":"0,0,0","subtotal":"195.30","grand_total":"220.69","paid_amount":"220.69","room_type_id":"289","product_id":"1103","siteminder_id":"AGO-318504394","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":"100903","customer_id":"100903","source_of_creation":"Agoda","reservation_created_date":"2020-05-12 14:28:10","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":"65.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"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3090926","reservation_id":"94397","confirmation_number":"BV12435520053","room_stay_from":"2020-05-12","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"303","product_id":"1139","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":"100611","customer_id":"100611","source_of_creation":"FE","reservation_created_date":"2020-05-03 21:55:36","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092848","reservation_id":"94670","confirmation_number":"BP12592293949","room_stay_from":"2020-05-12","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","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":"100869","customer_id":"100869","source_of_creation":"FE","reservation_created_date":"2020-05-11 14:53:32","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093185","reservation_id":"94574","confirmation_number":"PB12385953446","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"129.00,129.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","room_type_id":"289","product_id":"1109","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100769","customer_id":"100769","source_of_creation":"FE","reservation_created_date":"2020-05-08 20:43:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093104","reservation_id":"94521","confirmation_number":"PB12388445878","room_stay_from":"2020-05-10","room_stay_to":"2020-05-11","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"169.00","nightly_discount":"0.00","subtotal":"169.00","grand_total":"190.97","paid_amount":"190.97","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100728","customer_id":"100728","source_of_creation":"FE","reservation_created_date":"2020-05-07 02:38:29","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"-30.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3092567","reservation_id":"94539","confirmation_number":"BV12425108168","room_stay_from":"2020-05-09","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0","subtotal":"396.00","grand_total":"447.48","paid_amount":"447.48","room_type_id":"305","product_id":"1222","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"PMS","reservation_created_date":"2020-05-07 19:01:41","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":"99.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":"3092870","reservation_id":"94672","confirmation_number":"BP12531105203","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100870","customer_id":"100870","source_of_creation":"PMS","reservation_created_date":"2020-05-11 16:21:08","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092888","reservation_id":"94564","confirmation_number":"PB12379935105","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,159.00","nightly_discount":"0.00,0.00","subtotal":"318.00","grand_total":"359.34","paid_amount":"359.34","room_type_id":"289","product_id":"1101","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100800","customer_id":"100800","source_of_creation":"PMS","reservation_created_date":"2020-05-08 16:02:47","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"159.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093085","reservation_id":"94668","confirmation_number":"PB12381885918","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00","nightly_discount":"0.00,0","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","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":"100751","customer_id":"100751","source_of_creation":"PMS","reservation_created_date":"2020-05-11 14:04:21","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"129.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":"3093182","reservation_id":"94720","confirmation_number":"PB12384976124","room_stay_from":"2020-05-12","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.00","nightly_discount":"0.00","subtotal":"189.00","grand_total":"213.57","paid_amount":"213.57","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100891","customer_id":"100891","source_of_creation":"PMS","reservation_created_date":"2020-05-12 19:14:42","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"189.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092842","reservation_id":"94487","confirmation_number":"PB12366660707","room_stay_from":"2020-05-11","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00,149.00","nightly_discount":"0.00,0.00,0.00","subtotal":"447.00","grand_total":"505.11","paid_amount":"505.11","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":"100696","customer_id":"100696","source_of_creation":"PMS","reservation_created_date":"2020-05-06 13:24:54","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":"","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":"3092955","reservation_id":"94682","confirmation_number":"PB12315984825","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"5","nightly_price":"109.00,109.00","nightly_discount":"0.00,0.00","subtotal":"218.00","grand_total":"246.34","paid_amount":"246.34","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":"100881","customer_id":"100881","source_of_creation":"PMS","reservation_created_date":"2020-05-11 20:14:51","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":"109.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093083","reservation_id":"94699","confirmation_number":"PB12383047268","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100899","customer_id":"100899","source_of_creation":"PMS","reservation_created_date":"2020-05-12 13:33:02","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":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093129","reservation_id":"94706","confirmation_number":"PB12385097930","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","room_type_id":"289","product_id":"1098","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100906","customer_id":"100906","source_of_creation":"PMS","reservation_created_date":"2020-05-12 14:43:00","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093157","reservation_id":"94667","confirmation_number":"PB12348520781","room_stay_from":"2020-05-11","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00","nightly_discount":"0.00,0,0","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","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":"100866","customer_id":"100866","source_of_creation":"PMS","reservation_created_date":"2020-05-11 13:55:09","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"129.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":"3093197","reservation_id":"94680","confirmation_number":"PB12315538810","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","room_type_id":"289","product_id":"1121","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100923","customer_id":"100923","source_of_creation":"PMS","reservation_created_date":"2020-05-11 20:00:06","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":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090148","reservation_id":"93881","confirmation_number":"PB12347631567","room_stay_from":"2020-04-30","room_stay_to":"2020-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,78.39","subtotal":"1485.00","grand_total":"1589.47","paid_amount":"1589.47","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":"100118","customer_id":"100118","source_of_creation":"PMS","reservation_created_date":"2020-04-16 19:41:23","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":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092000","reservation_id":"94501","confirmation_number":"PB12352115516","room_stay_from":"2020-05-08","room_stay_to":"2020-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"273.90,328.68,199.00,199.00,199.00,199.00,199.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1597.58","grand_total":"1805.26","paid_amount":"1805.26","room_type_id":"287","product_id":"1090","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100711","customer_id":"100711","source_of_creation":"PMS","reservation_created_date":"2020-05-06 17:59:27","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"199.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092894","reservation_id":"94675","confirmation_number":"PB12317422090","room_stay_from":"2020-05-11","room_stay_to":"2020-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.00,75.00,75.00,75.00","nightly_discount":"0.00,0.00,0.00,18.00","subtotal":"300.00","grand_total":"318.66","paid_amount":"318.66","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":"100635","customer_id":"100635","source_of_creation":"PMS","reservation_created_date":"2020-05-11 18:05:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093026","reservation_id":"94684","confirmation_number":"PB12381646071","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"139.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00","subtotal":"417.00","grand_total":"471.21","paid_amount":"505.11","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":"100883","customer_id":"100883","source_of_creation":"PMS","reservation_created_date":"2020-05-11 20:51:31","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093116","reservation_id":"94702","confirmation_number":"PB12390044706","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00","nightly_discount":"0.00,0.00,0","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100902","customer_id":"100902","source_of_creation":"PMS","reservation_created_date":"2020-05-12 14:24:47","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":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092688","reservation_id":"90395","confirmation_number":"BV12428203689","room_stay_from":"2020-05-10","room_stay_to":"2020-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"240.00,240.00,240.00,240.00,290.00,290.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,83.50","subtotal":"1540.00","grand_total":"1645.85","paid_amount":"1645.85","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":"96447","customer_id":"96447","source_of_creation":"PMS","reservation_created_date":"2020-01-22 23:05:06","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":"240.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093142","reservation_id":"94308","confirmation_number":"BV12443593313","room_stay_from":"2020-05-12","room_stay_to":"2020-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0","subtotal":"516.00","grand_total":"583.08","paid_amount":"583.08","room_type_id":"304","product_id":"1219","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100546","customer_id":"100546","source_of_creation":"PMS","reservation_created_date":"2020-05-01 15:55:56","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092518","reservation_id":"94021","confirmation_number":"PB12389643319","room_stay_from":"2020-05-09","room_stay_to":"2020-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,36.01","subtotal":"984.00","grand_total":"1071.23","paid_amount":"1071.23","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"44906","customer_id":"44906","source_of_creation":"PMS","reservation_created_date":"2020-04-20 20:00:38","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":"123.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092637","reservation_id":"94492","confirmation_number":"PB12333304661","room_stay_from":"2020-05-06","room_stay_to":"2020-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0,0,0,0,0,0,0","subtotal":"1089.00","grand_total":"1230.57","paid_amount":"1230.57","room_type_id":"291","product_id":"1118","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100702","customer_id":"100702","source_of_creation":"PMS","reservation_created_date":"2020-05-06 15:04:19","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":"99.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":"3092778","reservation_id":"94245","confirmation_number":"PB12367964191","room_stay_from":"2020-05-10","room_stay_to":"2020-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"199.00,199.00,199.00,199.00,199.00,199.00,249.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,67.40","subtotal":"1443.00","grand_total":"1554.43","paid_amount":"1554.43","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":"100487","customer_id":"100487","source_of_creation":"PMS","reservation_created_date":"2020-04-28 21:38:06","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":"199.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093037","reservation_id":"94685","confirmation_number":"BV12419598660","room_stay_from":"2020-05-12","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"304","product_id":"1218","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100579","customer_id":"100579","source_of_creation":"PMS","reservation_created_date":"2020-05-11 22:48:50","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3092996","reservation_id":"93659","confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,89.00,89.00,89.00,89.00,89.00,89.00,89.00,99.00,89.00,89.00,89.00,89.00,89.00,99.00,109.00,99.00,99.00,99.00,99.00,99.00,109.00,129.00,99.00,99.00,99.00,99.00,109.00,109.00,109.00,99.00,99.00,99.00,99.00,99.00,129.00,129.00,99.00,99.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,69.26,5.00,0.00,0.00,0.00,0.00,0.00,0.00,40.00,0.00,0.00,0.00,0.00,0.00,0.00,42.00,0.00,0.00,0.00,0.00,0.00,0.00,39.85,0.00,0.00,0.00,0.00,0.00,0.00,41.16,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"5098.00","grand_total":"5492.62","paid_amount":"4864.34","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76889","customer_id":"76889","source_of_creation":"PMS","reservation_created_date":"2020-03-30 17:57:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093162","reservation_id":"78193","confirmation_number":"BV12417521021","room_stay_from":"2021-06-01","room_stay_to":"2021-06-11","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1440.00","grand_total":"1627.20","paid_amount":"162.72","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":"66932","customer_id":"66932","source_of_creation":"PMS","reservation_created_date":"2019-06-07 15:05:41","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":"","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":"3092872","reservation_id":"94672","confirmation_number":"BP12249244321","room_confirmation_number":"BP12531105203","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","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":"100870","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-11 16:21:08","reservation_modified_date_time":"2020-05-11 16:21:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100870","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":"3092767","reservation_id":"94636","confirmation_number":"BP12262596252","room_confirmation_number":"BP12582834053","room_stay_from":"2020-05-10","room_stay_to":"2020-05-14","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":"100857","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-10 14:26:10","reservation_modified_date_time":"2020-05-10 22:00:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100857","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":"3092956","reservation_id":"94682","confirmation_number":"PB12269943779","room_confirmation_number":"PB12315984825","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","room_stay_status":"Active","nightly_price":"40,40","nightly_discount":"0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"100881","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-11 20:16:36","reservation_modified_date_time":"2020-05-11 20:16:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100881","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093187","reservation_id":"94574","confirmation_number":"PB12273235999","room_confirmation_number":"PB12385953446","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"100769","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-12 19:28:01","reservation_modified_date_time":"2020-05-12 19:28:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100769","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":"3093028","reservation_id":"94684","confirmation_number":"BP12248611505","room_confirmation_number":"PB12381646071","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0,0,0","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"100883","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-11 22:11:47","reservation_modified_date_time":"2020-05-11 22:11:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100883","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":"3092308","reservation_id":"94245","confirmation_number":"PB12236723153","room_confirmation_number":"PB12367964191","room_stay_from":"2020-05-10","room_stay_to":"2020-05-17","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"100487","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-09 00:47:26","reservation_modified_date_time":"2020-05-09 00:47:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100487","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":"3092508","reservation_id":"94021","confirmation_number":"PB12251940213","room_confirmation_number":"PB12389643319","room_stay_from":"2020-05-09","room_stay_to":"2020-05-17","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"44906","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-09 21:12:11","reservation_modified_date_time":"2020-05-09 21:12:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44906","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":"3090927","reservation_id":"94397","confirmation_number":"BV12237419330","room_confirmation_number":"BV12435520053","room_stay_from":"2020-05-12","room_stay_to":"2020-05-13","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":"100611","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-03 21:55:36","reservation_modified_date_time":"2020-05-03 21:55:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100611","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":"3092328","reservation_id":"94591","confirmation_number":"BP12251150542","room_confirmation_number":"BP12588905868","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","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":"100791","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-09 02:57:07","reservation_modified_date_time":"2020-05-09 02:57:07","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100825","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3092566","reservation_id":"94539","confirmation_number":"BV12273390365","room_confirmation_number":"BV12425108168","room_stay_from":"2020-05-09","room_stay_to":"2020-05-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"47798","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-07 19:01:41","reservation_modified_date_time":"2020-05-09 23:48:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","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":"3092658","reservation_id":"94582","confirmation_number":"BP12245300442","room_confirmation_number":"BP12543077539","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","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":"92253","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-08 22:16:05","reservation_modified_date_time":"2020-05-10 16:16:33","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92253","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":"3092849","reservation_id":"94670","confirmation_number":"BP12262201537","room_confirmation_number":"BP12592293949","room_stay_from":"2020-05-12","room_stay_to":"2020-05-13","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":"100869","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 14:53:32","reservation_modified_date_time":"2020-05-11 14:53:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100869","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":"3092873","reservation_id":"94672","confirmation_number":"BP12277319878","room_confirmation_number":"BP12531105203","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","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":"100870","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 16:21:08","reservation_modified_date_time":"2020-05-11 16:21:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100870","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":"3092887","reservation_id":"94564","confirmation_number":"PB12254837404","room_confirmation_number":"PB12379935105","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","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":"100800","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-08 16:02:47","reservation_modified_date_time":"2020-05-11 17:06:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100800","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":"3093086","reservation_id":"94668","confirmation_number":"PB12244102916","room_confirmation_number":"PB12381885918","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","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":"100751","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 14:04:21","reservation_modified_date_time":"2020-05-12 13:45:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100751","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":"3093183","reservation_id":"94720","confirmation_number":"PB12288401708","room_confirmation_number":"PB12384976124","room_stay_from":"2020-05-12","room_stay_to":"2020-05-13","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":"100891","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-12 19:14:42","reservation_modified_date_time":"2020-05-12 19:14:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100891","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":"3092768","reservation_id":"94636","confirmation_number":"BP12265638208","room_confirmation_number":"BP12582834053","room_stay_from":"2020-05-10","room_stay_to":"2020-05-14","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":"100857","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-10 14:26:10","reservation_modified_date_time":"2020-05-10 22:00:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100857","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":"3092843","reservation_id":"94487","confirmation_number":"PB12281329143","room_confirmation_number":"PB12366660707","room_stay_from":"2020-05-11","room_stay_to":"2020-05-14","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":"100696","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 13:24:55","reservation_modified_date_time":"2020-05-11 14:38:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100696","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":"3092957","reservation_id":"94682","confirmation_number":"PB12288337776","room_confirmation_number":"PB12315984825","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","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":"100881","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 20:14:51","reservation_modified_date_time":"2020-05-11 20:16:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100881","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":"3093084","reservation_id":"94699","confirmation_number":"PB12214937654","room_confirmation_number":"PB12383047268","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","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":"100899","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-12 13:33:02","reservation_modified_date_time":"2020-05-12 13:33:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100899","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":"3093130","reservation_id":"94706","confirmation_number":"PB12230207300","room_confirmation_number":"PB12385097930","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","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":"100906","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-12 14:43:00","reservation_modified_date_time":"2020-05-12 14:43:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100906","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":"3093158","reservation_id":"94667","confirmation_number":"PB12218131297","room_confirmation_number":"PB12348520781","room_stay_from":"2020-05-11","room_stay_to":"2020-05-14","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":"100866","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 13:55:09","reservation_modified_date_time":"2020-05-12 16:13:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100866","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":"3093188","reservation_id":"94574","confirmation_number":"PB12267714395","room_confirmation_number":"PB12385953446","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","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":"100769","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-08 20:43:10","reservation_modified_date_time":"2020-05-12 19:28:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100769","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":"3093196","reservation_id":"94680","confirmation_number":"PB12239262388","room_confirmation_number":"PB12315538810","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","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":"100923","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 20:00:06","reservation_modified_date_time":"2020-05-12 19:56:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100923","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":"3090149","reservation_id":"93881","confirmation_number":"PB12234805093","room_confirmation_number":"PB12347631567","room_stay_from":"2020-04-30","room_stay_to":"2020-05-15","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":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"100118","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-16 19:41:23","reservation_modified_date_time":"2020-05-01 00:57:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100118","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":"3091999","reservation_id":"94501","confirmation_number":"PB12215529811","room_confirmation_number":"PB12352115516","room_stay_from":"2020-05-08","room_stay_to":"2020-05-15","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":"100711","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 17:59:27","reservation_modified_date_time":"2020-05-08 00:57:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100711","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":"3092895","reservation_id":"94675","confirmation_number":"PB12256901979","room_confirmation_number":"PB12317422090","room_stay_from":"2020-05-11","room_stay_to":"2020-05-15","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":"100635","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 18:05:05","reservation_modified_date_time":"2020-05-11 18:05:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100635","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":"3093029","reservation_id":"94684","confirmation_number":"PB12214340447","room_confirmation_number":"PB12381646071","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","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":"100883","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 20:51:31","reservation_modified_date_time":"2020-05-11 22:11:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100883","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":"3093117","reservation_id":"94702","confirmation_number":"PB12292765086","room_confirmation_number":"PB12390044706","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","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":"100902","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-12 14:24:47","reservation_modified_date_time":"2020-05-12 14:29:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100902","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":"3093165","reservation_id":"94703","confirmation_number":"BV12259447915","room_confirmation_number":"BV12486051953","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","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":"100903","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-12 14:28:10","reservation_modified_date_time":"2020-05-12 16:40:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100903","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":"3092689","reservation_id":"90395","confirmation_number":"BV12293385163","room_confirmation_number":"BV12428203689","room_stay_from":"2020-05-10","room_stay_to":"2020-05-16","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":"96447","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-22 23:05:06","reservation_modified_date_time":"2020-05-10 19:17:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96447","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":"3093143","reservation_id":"94308","confirmation_number":"BV12245615790","room_confirmation_number":"BV12443593313","room_stay_from":"2020-05-12","room_stay_to":"2020-05-16","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":"100546","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-01 15:55:56","reservation_modified_date_time":"2020-05-12 14:58:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100546","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":"3092519","reservation_id":"94021","confirmation_number":"PB12240650276","room_confirmation_number":"PB12389643319","room_stay_from":"2020-05-09","room_stay_to":"2020-05-17","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":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"44906","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-20 20:00:38","reservation_modified_date_time":"2020-05-09 21:34:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44906","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":"3092639","reservation_id":"94492","confirmation_number":"PB12299252539","room_confirmation_number":"PB12333304661","room_stay_from":"2020-05-06","room_stay_to":"2020-05-17","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100702","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 15:04:19","reservation_modified_date_time":"2020-05-10 15:18:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100702","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":"3092779","reservation_id":"94245","confirmation_number":"PB12228429875","room_confirmation_number":"PB12367964191","room_stay_from":"2020-05-10","room_stay_to":"2020-05-17","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":"100487","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-28 21:38:06","reservation_modified_date_time":"2020-05-11 00:10:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100487","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":"3093208","reservation_id":"94349","confirmation_number":"PB12281730192","room_confirmation_number":"PB12313626819","room_stay_from":"2020-05-12","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"83852","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-02 18:11:06","reservation_modified_date_time":"2020-05-12 20:32:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83852","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":"3093038","reservation_id":"94685","confirmation_number":"BV12246605087","room_confirmation_number":"BV12419598660","room_stay_from":"2020-05-12","room_stay_to":"2020-05-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100579","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 22:48:50","reservation_modified_date_time":"2020-05-11 22:48:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100579","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":"3092997","reservation_id":"93659","confirmation_number":"PB12259744424","room_confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"624.00","grand_total":"705.12","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"76889","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-30 17:57:33","reservation_modified_date_time":"2020-05-11 20:29:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76889","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":"3093163","reservation_id":"78193","confirmation_number":"BV12248317693","room_confirmation_number":"BV12417521021","room_stay_from":"2021-06-01","room_stay_to":"2021-06-11","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"66932","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-07 15:05:41","reservation_modified_date_time":"2020-05-12 16:34:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66932","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":"3092871","reservation_id":"94672","confirmation_number":"BP12256167926","room_confirmation_number":"BP12531105203","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","room_stay_status":"Active","nightly_price":"45.00,45.00","nightly_discount":"0.00,0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-11 16:21:08","reservation_modified_date_time":"2020-05-11 16:21:08","customer_id":"100870","parentCustTravId":"100870","customer_traveller_id":"100870","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":"45.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3093030","reservation_id":"94684","confirmation_number":"BP12298146061","room_confirmation_number":"PB12381646071","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","room_stay_status":"Active","nightly_price":"45.00,45.00,45.00","nightly_discount":"0.00,0.00,0.00","subtotal":"135.00","grand_total":"152.55","paid_amount":"118.65","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-11 22:12:04","reservation_modified_date_time":"2020-05-11 22:12:04","customer_id":"100883","parentCustTravId":"100883","customer_traveller_id":"100883","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":"45.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3093177","reservation_id":"94670","confirmation_number":"BP12227666348","room_confirmation_number":"BP12592293949","room_stay_from":"2020-05-12","room_stay_to":"2020-05-13","room_stay_status":"Active","nightly_price":"45.00","nightly_discount":"0.00","subtotal":"45.00","grand_total":"50.85","paid_amount":"50.85","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-12 18:11:13","reservation_modified_date_time":"2020-05-12 18:11:13","customer_id":"100869","parentCustTravId":"100869","customer_traveller_id":"100869","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":"45.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3093189","reservation_id":"94703","confirmation_number":"PB12261531666","room_confirmation_number":"BV12486051953","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"40.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1212","service_quantity":"3","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-12 19:34:43","reservation_modified_date_time":"2020-05-12 19:34:43","customer_id":"100903","parentCustTravId":"100903","customer_traveller_id":"100903","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":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3093192","reservation_id":"94703","confirmation_number":"PB12217712506","room_confirmation_number":"BV12486051953","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"64.20","paid_amount":"64.20","product_id":"1191","service_quantity":"3","product_name":"Resort Fee Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-12 19:41:32","reservation_modified_date_time":"2020-05-12 19:41:32","customer_id":"100903","parentCustTravId":"100903","customer_traveller_id":"100903","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":"60.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3092850","reservation_id":"94546","confirmation_number":"PB12218182365","room_confirmation_number":"BV12472536788","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-11 15:01:48","reservation_modified_date_time":"2020-05-11 15:01:48","customer_id":"100749","parentCustTravId":"100749","customer_traveller_id":"100749","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-12 14:25:04","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-9.35,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3092862","reservation_id":"94638","confirmation_number":"PB12274039438","room_confirmation_number":"PB12315475098","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-11 15:33:01","reservation_modified_date_time":"2020-05-11 15:33:01","customer_id":"100838","parentCustTravId":"100838","customer_traveller_id":"100838","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-12 14:52:18","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-37.4,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3092939","reservation_id":"94678","confirmation_number":"PB12231817291","room_confirmation_number":"PB12375797365","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-11 19:44:02","reservation_modified_date_time":"2020-05-11 19:44:02","customer_id":"100876","parentCustTravId":"100876","customer_traveller_id":"100876","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-12 13:54:28","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-9.35,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3093004","reservation_id":"94676","confirmation_number":"PB12214068022","room_confirmation_number":"PB12312712789","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-11 20:52:50","reservation_modified_date_time":"2020-05-11 20:52:50","customer_id":"100875","parentCustTravId":"100875","customer_traveller_id":"100875","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-12 13:53:21","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3093156","reservation_id":"94682","confirmation_number":"PB12259446319","room_confirmation_number":"PB12315984825","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"40.00","grand_total":"80.00","paid_amount":"80.00","product_id":"1082","service_quantity":"2","product_name":"extra person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-12 16:13:24","reservation_modified_date_time":"2020-05-12 16:13:24","customer_id":"100881","parentCustTravId":"100881","customer_traveller_id":"100881","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":"80.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"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":8,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1113,1084","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12237310193","room_stay_from":"2020-05-10","room_stay_to":"2020-05-13","bundle_room":"0"},{"confirmation_number":"PB12223715671","room_stay_from":"2020-05-08","room_stay_to":"2020-05-13","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3093207","reservation_id":"94349","confirmation_number":"PB12313626819","room_stay_from":"2020-05-12","room_stay_to":"2020-05-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.29,117.29,117.29,143.47,143.47,117.29,117.29","nightly_discount":"0,0,0,0,0,0,0","subtotal":"873.39","grand_total":"986.93","paid_amount":"986.93","room_type_id":"289","product_id":"1111","siteminder_id":"GAM-R1953915007","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":"83852","customer_id":"83852","source_of_creation":"Getaroom.com","reservation_created_date":"2020-05-02 18:11:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.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"}]}],"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":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3093185","reservation_id":"94574","confirmation_number":"PB12385953446","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"129.00,129.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","room_type_id":"289","product_id":"1109","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100769","customer_id":"100769","source_of_creation":"FE","reservation_created_date":"2020-05-08 20:43:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093104","reservation_id":"94521","confirmation_number":"PB12388445878","room_stay_from":"2020-05-10","room_stay_to":"2020-05-11","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"169.00","nightly_discount":"0.00","subtotal":"169.00","grand_total":"190.97","paid_amount":"190.97","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100728","customer_id":"100728","source_of_creation":"FE","reservation_created_date":"2020-05-07 02:38:29","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"-30.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3092888","reservation_id":"94564","confirmation_number":"PB12379935105","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,159.00","nightly_discount":"0.00,0.00","subtotal":"318.00","grand_total":"359.34","paid_amount":"359.34","room_type_id":"289","product_id":"1101","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100800","customer_id":"100800","source_of_creation":"PMS","reservation_created_date":"2020-05-08 16:02:47","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"159.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093085","reservation_id":"94668","confirmation_number":"PB12381885918","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00","nightly_discount":"0.00,0","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","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":"100751","customer_id":"100751","source_of_creation":"PMS","reservation_created_date":"2020-05-11 14:04:21","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"129.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":"3093182","reservation_id":"94720","confirmation_number":"PB12384976124","room_stay_from":"2020-05-12","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.00","nightly_discount":"0.00","subtotal":"189.00","grand_total":"213.57","paid_amount":"213.57","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100891","customer_id":"100891","source_of_creation":"PMS","reservation_created_date":"2020-05-12 19:14:42","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"189.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092842","reservation_id":"94487","confirmation_number":"PB12366660707","room_stay_from":"2020-05-11","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,149.00,149.00","nightly_discount":"0.00,0.00,0.00","subtotal":"447.00","grand_total":"505.11","paid_amount":"505.11","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":"100696","customer_id":"100696","source_of_creation":"PMS","reservation_created_date":"2020-05-06 13:24:54","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":"","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":"3092955","reservation_id":"94682","confirmation_number":"PB12315984825","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"5","nightly_price":"109.00,109.00","nightly_discount":"0.00,0.00","subtotal":"218.00","grand_total":"246.34","paid_amount":"246.34","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":"100881","customer_id":"100881","source_of_creation":"PMS","reservation_created_date":"2020-05-11 20:14:51","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":"109.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093083","reservation_id":"94699","confirmation_number":"PB12383047268","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100899","customer_id":"100899","source_of_creation":"PMS","reservation_created_date":"2020-05-12 13:33:02","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":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093129","reservation_id":"94706","confirmation_number":"PB12385097930","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","room_type_id":"289","product_id":"1098","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100906","customer_id":"100906","source_of_creation":"PMS","reservation_created_date":"2020-05-12 14:43:00","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093157","reservation_id":"94667","confirmation_number":"PB12348520781","room_stay_from":"2020-05-11","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00","nightly_discount":"0.00,0,0","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","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":"100866","customer_id":"100866","source_of_creation":"PMS","reservation_created_date":"2020-05-11 13:55:09","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"129.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":"3093197","reservation_id":"94680","confirmation_number":"PB12315538810","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","room_type_id":"289","product_id":"1121","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100923","customer_id":"100923","source_of_creation":"PMS","reservation_created_date":"2020-05-11 20:00:06","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":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090148","reservation_id":"93881","confirmation_number":"PB12347631567","room_stay_from":"2020-04-30","room_stay_to":"2020-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,78.39","subtotal":"1485.00","grand_total":"1589.47","paid_amount":"1589.47","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":"100118","customer_id":"100118","source_of_creation":"PMS","reservation_created_date":"2020-04-16 19:41:23","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":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092000","reservation_id":"94501","confirmation_number":"PB12352115516","room_stay_from":"2020-05-08","room_stay_to":"2020-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"273.90,328.68,199.00,199.00,199.00,199.00,199.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1597.58","grand_total":"1805.26","paid_amount":"1805.26","room_type_id":"287","product_id":"1090","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100711","customer_id":"100711","source_of_creation":"PMS","reservation_created_date":"2020-05-06 17:59:27","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"199.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092894","reservation_id":"94675","confirmation_number":"PB12317422090","room_stay_from":"2020-05-11","room_stay_to":"2020-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.00,75.00,75.00,75.00","nightly_discount":"0.00,0.00,0.00,18.00","subtotal":"300.00","grand_total":"318.66","paid_amount":"318.66","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":"100635","customer_id":"100635","source_of_creation":"PMS","reservation_created_date":"2020-05-11 18:05:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093026","reservation_id":"94684","confirmation_number":"PB12381646071","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"139.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00","subtotal":"417.00","grand_total":"471.21","paid_amount":"505.11","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":"100883","customer_id":"100883","source_of_creation":"PMS","reservation_created_date":"2020-05-11 20:51:31","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093116","reservation_id":"94702","confirmation_number":"PB12390044706","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00","nightly_discount":"0.00,0.00,0","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100902","customer_id":"100902","source_of_creation":"PMS","reservation_created_date":"2020-05-12 14:24:47","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":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092518","reservation_id":"94021","confirmation_number":"PB12389643319","room_stay_from":"2020-05-09","room_stay_to":"2020-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,36.01","subtotal":"984.00","grand_total":"1071.23","paid_amount":"1071.23","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"44906","customer_id":"44906","source_of_creation":"PMS","reservation_created_date":"2020-04-20 20:00:38","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":"123.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092637","reservation_id":"94492","confirmation_number":"PB12333304661","room_stay_from":"2020-05-06","room_stay_to":"2020-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0,0,0,0,0,0,0","subtotal":"1089.00","grand_total":"1230.57","paid_amount":"1230.57","room_type_id":"291","product_id":"1118","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100702","customer_id":"100702","source_of_creation":"PMS","reservation_created_date":"2020-05-06 15:04:19","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":"99.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":"3092778","reservation_id":"94245","confirmation_number":"PB12367964191","room_stay_from":"2020-05-10","room_stay_to":"2020-05-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"199.00,199.00,199.00,199.00,199.00,199.00,249.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,67.40","subtotal":"1443.00","grand_total":"1554.43","paid_amount":"1554.43","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":"100487","customer_id":"100487","source_of_creation":"PMS","reservation_created_date":"2020-04-28 21:38:06","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":"199.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092996","reservation_id":"93659","confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,89.00,89.00,89.00,89.00,89.00,89.00,89.00,99.00,89.00,89.00,89.00,89.00,89.00,99.00,109.00,99.00,99.00,99.00,99.00,99.00,109.00,129.00,99.00,99.00,99.00,99.00,109.00,109.00,109.00,99.00,99.00,99.00,99.00,99.00,129.00,129.00,99.00,99.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,69.26,5.00,0.00,0.00,0.00,0.00,0.00,0.00,40.00,0.00,0.00,0.00,0.00,0.00,0.00,42.00,0.00,0.00,0.00,0.00,0.00,0.00,39.85,0.00,0.00,0.00,0.00,0.00,0.00,41.16,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"5098.00","grand_total":"5492.62","paid_amount":"4864.34","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76889","customer_id":"76889","source_of_creation":"PMS","reservation_created_date":"2020-03-30 17:57:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3092956","reservation_id":"94682","confirmation_number":"PB12269943779","room_confirmation_number":"PB12315984825","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","room_stay_status":"Active","nightly_price":"40,40","nightly_discount":"0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"100881","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-11 20:16:36","reservation_modified_date_time":"2020-05-11 20:16:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100881","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093187","reservation_id":"94574","confirmation_number":"PB12273235999","room_confirmation_number":"PB12385953446","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"100769","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-12 19:28:01","reservation_modified_date_time":"2020-05-12 19:28:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100769","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":"3093028","reservation_id":"94684","confirmation_number":"BP12248611505","room_confirmation_number":"PB12381646071","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0,0,0","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"100883","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-11 22:11:47","reservation_modified_date_time":"2020-05-11 22:11:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100883","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":"3092308","reservation_id":"94245","confirmation_number":"PB12236723153","room_confirmation_number":"PB12367964191","room_stay_from":"2020-05-10","room_stay_to":"2020-05-17","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"100487","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-05-09 00:47:26","reservation_modified_date_time":"2020-05-09 00:47:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100487","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":"3092508","reservation_id":"94021","confirmation_number":"PB12251940213","room_confirmation_number":"PB12389643319","room_stay_from":"2020-05-09","room_stay_to":"2020-05-17","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"44906","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-09 21:12:11","reservation_modified_date_time":"2020-05-09 21:12:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44906","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":"3092887","reservation_id":"94564","confirmation_number":"PB12254837404","room_confirmation_number":"PB12379935105","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","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":"100800","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-08 16:02:47","reservation_modified_date_time":"2020-05-11 17:06:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100800","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":"3093086","reservation_id":"94668","confirmation_number":"PB12244102916","room_confirmation_number":"PB12381885918","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","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":"100751","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 14:04:21","reservation_modified_date_time":"2020-05-12 13:45:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100751","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":"3093183","reservation_id":"94720","confirmation_number":"PB12288401708","room_confirmation_number":"PB12384976124","room_stay_from":"2020-05-12","room_stay_to":"2020-05-13","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":"100891","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-12 19:14:42","reservation_modified_date_time":"2020-05-12 19:14:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100891","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":"3092843","reservation_id":"94487","confirmation_number":"PB12281329143","room_confirmation_number":"PB12366660707","room_stay_from":"2020-05-11","room_stay_to":"2020-05-14","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":"100696","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 13:24:55","reservation_modified_date_time":"2020-05-11 14:38:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100696","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":"3092957","reservation_id":"94682","confirmation_number":"PB12288337776","room_confirmation_number":"PB12315984825","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","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":"100881","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 20:14:51","reservation_modified_date_time":"2020-05-11 20:16:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100881","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":"3093084","reservation_id":"94699","confirmation_number":"PB12214937654","room_confirmation_number":"PB12383047268","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","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":"100899","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-12 13:33:02","reservation_modified_date_time":"2020-05-12 13:33:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100899","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":"3093130","reservation_id":"94706","confirmation_number":"PB12230207300","room_confirmation_number":"PB12385097930","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","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":"100906","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-12 14:43:00","reservation_modified_date_time":"2020-05-12 14:43:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100906","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":"3093158","reservation_id":"94667","confirmation_number":"PB12218131297","room_confirmation_number":"PB12348520781","room_stay_from":"2020-05-11","room_stay_to":"2020-05-14","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":"100866","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 13:55:09","reservation_modified_date_time":"2020-05-12 16:13:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100866","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":"3093188","reservation_id":"94574","confirmation_number":"PB12267714395","room_confirmation_number":"PB12385953446","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","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":"100769","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-08 20:43:10","reservation_modified_date_time":"2020-05-12 19:28:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100769","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":"3093196","reservation_id":"94680","confirmation_number":"PB12239262388","room_confirmation_number":"PB12315538810","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","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":"100923","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 20:00:06","reservation_modified_date_time":"2020-05-12 19:56:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100923","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":"3090149","reservation_id":"93881","confirmation_number":"PB12234805093","room_confirmation_number":"PB12347631567","room_stay_from":"2020-04-30","room_stay_to":"2020-05-15","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":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"100118","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-16 19:41:23","reservation_modified_date_time":"2020-05-01 00:57:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100118","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":"3091999","reservation_id":"94501","confirmation_number":"PB12215529811","room_confirmation_number":"PB12352115516","room_stay_from":"2020-05-08","room_stay_to":"2020-05-15","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":"100711","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 17:59:27","reservation_modified_date_time":"2020-05-08 00:57:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100711","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":"3092895","reservation_id":"94675","confirmation_number":"PB12256901979","room_confirmation_number":"PB12317422090","room_stay_from":"2020-05-11","room_stay_to":"2020-05-15","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":"100635","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 18:05:05","reservation_modified_date_time":"2020-05-11 18:05:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100635","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":"3093029","reservation_id":"94684","confirmation_number":"PB12214340447","room_confirmation_number":"PB12381646071","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","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":"100883","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 20:51:31","reservation_modified_date_time":"2020-05-11 22:11:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100883","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":"3093117","reservation_id":"94702","confirmation_number":"PB12292765086","room_confirmation_number":"PB12390044706","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","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":"100902","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-12 14:24:47","reservation_modified_date_time":"2020-05-12 14:29:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100902","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":"3092519","reservation_id":"94021","confirmation_number":"PB12240650276","room_confirmation_number":"PB12389643319","room_stay_from":"2020-05-09","room_stay_to":"2020-05-17","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":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"44906","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-20 20:00:38","reservation_modified_date_time":"2020-05-09 21:34:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44906","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":"3092639","reservation_id":"94492","confirmation_number":"PB12299252539","room_confirmation_number":"PB12333304661","room_stay_from":"2020-05-06","room_stay_to":"2020-05-17","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100702","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-06 15:04:19","reservation_modified_date_time":"2020-05-10 15:18:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100702","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":"3092779","reservation_id":"94245","confirmation_number":"PB12228429875","room_confirmation_number":"PB12367964191","room_stay_from":"2020-05-10","room_stay_to":"2020-05-17","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":"100487","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-28 21:38:06","reservation_modified_date_time":"2020-05-11 00:10:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100487","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":"3093208","reservation_id":"94349","confirmation_number":"PB12281730192","room_confirmation_number":"PB12313626819","room_stay_from":"2020-05-12","room_stay_to":"2020-05-19","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"83852","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-02 18:11:06","reservation_modified_date_time":"2020-05-12 20:32:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"83852","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":"3092997","reservation_id":"93659","confirmation_number":"PB12259744424","room_confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"624.00","grand_total":"705.12","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"76889","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-30 17:57:33","reservation_modified_date_time":"2020-05-11 20:29:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76889","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":"3093030","reservation_id":"94684","confirmation_number":"BP12298146061","room_confirmation_number":"PB12381646071","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","room_stay_status":"Active","nightly_price":"45.00,45.00,45.00","nightly_discount":"0.00,0.00,0.00","subtotal":"135.00","grand_total":"152.55","paid_amount":"118.65","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-11 22:12:04","reservation_modified_date_time":"2020-05-11 22:12:04","customer_id":"100883","parentCustTravId":"100883","customer_traveller_id":"100883","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":"45.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3092862","reservation_id":"94638","confirmation_number":"PB12274039438","room_confirmation_number":"PB12315475098","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-11 15:33:01","reservation_modified_date_time":"2020-05-11 15:33:01","customer_id":"100838","parentCustTravId":"100838","customer_traveller_id":"100838","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-12 14:52:18","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-37.4,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3092939","reservation_id":"94678","confirmation_number":"PB12231817291","room_confirmation_number":"PB12375797365","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-11 19:44:02","reservation_modified_date_time":"2020-05-11 19:44:02","customer_id":"100876","parentCustTravId":"100876","customer_traveller_id":"100876","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-12 13:54:28","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-9.35,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3093004","reservation_id":"94676","confirmation_number":"PB12214068022","room_confirmation_number":"PB12312712789","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-11 20:52:50","reservation_modified_date_time":"2020-05-11 20:52:50","customer_id":"100875","parentCustTravId":"100875","customer_traveller_id":"100875","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-12 13:53:21","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3093156","reservation_id":"94682","confirmation_number":"PB12259446319","room_confirmation_number":"PB12315984825","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"40.00","grand_total":"80.00","paid_amount":"80.00","product_id":"1082","service_quantity":"2","product_name":"extra person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-12 16:13:24","reservation_modified_date_time":"2020-05-12 16:13:24","customer_id":"100881","parentCustTravId":"100881","customer_traveller_id":"100881","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":"80.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":4,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1226,1224,1140","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BV12279993939","room_stay_from":"2020-05-10","room_stay_to":"2020-05-13","bundle_room":"0"},{"confirmation_number":"BV12274028703","room_stay_from":"2020-05-07","room_stay_to":"2020-05-13","bundle_room":"0"},{"confirmation_number":"BV12290663717","room_stay_from":"2020-05-12","room_stay_to":"2020-05-14","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3093164","reservation_id":"94703","confirmation_number":"BV12486051953","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"65.10,65.10,65.10","nightly_discount":"0,0,0","subtotal":"195.30","grand_total":"220.69","paid_amount":"220.69","room_type_id":"289","product_id":"1103","siteminder_id":"AGO-318504394","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":"100903","customer_id":"100903","source_of_creation":"Agoda","reservation_created_date":"2020-05-12 14:28:10","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":"65.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"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3090926","reservation_id":"94397","confirmation_number":"BV12435520053","room_stay_from":"2020-05-12","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","room_type_id":"303","product_id":"1139","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":"100611","customer_id":"100611","source_of_creation":"FE","reservation_created_date":"2020-05-03 21:55:36","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3092567","reservation_id":"94539","confirmation_number":"BV12425108168","room_stay_from":"2020-05-09","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0","subtotal":"396.00","grand_total":"447.48","paid_amount":"447.48","room_type_id":"305","product_id":"1222","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"PMS","reservation_created_date":"2020-05-07 19:01:41","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":"99.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":"3092688","reservation_id":"90395","confirmation_number":"BV12428203689","room_stay_from":"2020-05-10","room_stay_to":"2020-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"240.00,240.00,240.00,240.00,290.00,290.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,83.50","subtotal":"1540.00","grand_total":"1645.85","paid_amount":"1645.85","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":"96447","customer_id":"96447","source_of_creation":"PMS","reservation_created_date":"2020-01-22 23:05:06","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":"240.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093142","reservation_id":"94308","confirmation_number":"BV12443593313","room_stay_from":"2020-05-12","room_stay_to":"2020-05-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0","subtotal":"516.00","grand_total":"583.08","paid_amount":"583.08","room_type_id":"304","product_id":"1219","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100546","customer_id":"100546","source_of_creation":"PMS","reservation_created_date":"2020-05-01 15:55:56","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3093037","reservation_id":"94685","confirmation_number":"BV12419598660","room_stay_from":"2020-05-12","room_stay_to":"2020-05-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"304","product_id":"1218","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100579","customer_id":"100579","source_of_creation":"PMS","reservation_created_date":"2020-05-11 22:48:50","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3093162","reservation_id":"78193","confirmation_number":"BV12417521021","room_stay_from":"2021-06-01","room_stay_to":"2021-06-11","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00,144.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1440.00","grand_total":"1627.20","paid_amount":"162.72","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":"66932","customer_id":"66932","source_of_creation":"PMS","reservation_created_date":"2019-06-07 15:05:41","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":"","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":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3090927","reservation_id":"94397","confirmation_number":"BV12237419330","room_confirmation_number":"BV12435520053","room_stay_from":"2020-05-12","room_stay_to":"2020-05-13","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":"100611","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-03 21:55:36","reservation_modified_date_time":"2020-05-03 21:55:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100611","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":"3092566","reservation_id":"94539","confirmation_number":"BV12273390365","room_confirmation_number":"BV12425108168","room_stay_from":"2020-05-09","room_stay_to":"2020-05-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"47798","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-07 19:01:41","reservation_modified_date_time":"2020-05-09 23:48:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","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":"3093165","reservation_id":"94703","confirmation_number":"BV12259447915","room_confirmation_number":"BV12486051953","room_stay_from":"2020-05-12","room_stay_to":"2020-05-15","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":"100903","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-12 14:28:10","reservation_modified_date_time":"2020-05-12 16:40:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100903","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":"3092689","reservation_id":"90395","confirmation_number":"BV12293385163","room_confirmation_number":"BV12428203689","room_stay_from":"2020-05-10","room_stay_to":"2020-05-16","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":"96447","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-22 23:05:06","reservation_modified_date_time":"2020-05-10 19:17:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96447","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":"3093143","reservation_id":"94308","confirmation_number":"BV12245615790","room_confirmation_number":"BV12443593313","room_stay_from":"2020-05-12","room_stay_to":"2020-05-16","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":"100546","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-01 15:55:56","reservation_modified_date_time":"2020-05-12 14:58:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100546","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":"3093038","reservation_id":"94685","confirmation_number":"BV12246605087","room_confirmation_number":"BV12419598660","room_stay_from":"2020-05-12","room_stay_to":"2020-05-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100579","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 22:48:50","reservation_modified_date_time":"2020-05-11 22:48:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100579","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":"3093163","reservation_id":"78193","confirmation_number":"BV12248317693","room_confirmation_number":"BV12417521021","room_stay_from":"2021-06-01","room_stay_to":"2021-06-11","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"66932","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-07 15:05:41","reservation_modified_date_time":"2020-05-12 16:34:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66932","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":"3093189","reservation_id":"94703","confirmation_number":"PB12261531666","room_confirmation_number":"BV12486051953","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"40.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1212","service_quantity":"3","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-12 19:34:43","reservation_modified_date_time":"2020-05-12 19:34:43","customer_id":"100903","parentCustTravId":"100903","customer_traveller_id":"100903","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":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3093192","reservation_id":"94703","confirmation_number":"PB12217712506","room_confirmation_number":"BV12486051953","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"64.20","paid_amount":"64.20","product_id":"1191","service_quantity":"3","product_name":"Resort Fee Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-12 19:41:32","reservation_modified_date_time":"2020-05-12 19:41:32","customer_id":"100903","parentCustTravId":"100903","customer_traveller_id":"100903","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":"60.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3092850","reservation_id":"94546","confirmation_number":"PB12218182365","room_confirmation_number":"BV12472536788","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-11 15:01:48","reservation_modified_date_time":"2020-05-11 15:01:48","customer_id":"100749","parentCustTravId":"100749","customer_traveller_id":"100749","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-05-12 14:25:04","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-9.35,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":3,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3093094","reservation_id":"94659","confirmation_number":"BP12536723221","room_stay_from":"2020-05-10","room_stay_to":"2020-05-12","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.75,111.75","nightly_discount":"0.00,7.58","subtotal":"223.50","grand_total":"243.99","paid_amount":"243.99","room_type_id":"295","product_id":"1128","siteminder_id":"BDC-3935418550","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100859","customer_id":"100859","source_of_creation":"Booking.com","reservation_created_date":"2020-05-11 01:08:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"47.43","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"-1.45","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3092661","reservation_id":"94582","confirmation_number":"BP12543077539","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.44,124.44","nightly_discount":"0,0","subtotal":"248.88","grand_total":"281.23","paid_amount":"281.23","room_type_id":"300","product_id":"1135","siteminder_id":"EXP-1663325546","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":"92253","customer_id":"92253","source_of_creation":"Expedia","reservation_created_date":"2020-05-08 22:16:05","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 805","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.44","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":"3092770","reservation_id":"94636","confirmation_number":"BP12582834053","room_stay_from":"2020-05-10","room_stay_to":"2020-05-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"154.54,154.54,154.54,154.54","nightly_discount":"0,0,0,0","subtotal":"618.16","grand_total":"698.52","paid_amount":"698.52","room_type_id":"296","product_id":"1131","siteminder_id":"EXP-1663504401","collect_which":"hotel_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":"100857","customer_id":"100857","source_of_creation":"Expedia","reservation_created_date":"2020-05-10 14:26:10","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"154.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"}]}],"exp_non_taxable":[{"room_stay_id":"3093198","reservation_id":"93450","confirmation_number":"BP12552535566","room_stay_from":"2020-03-17","room_stay_to":"2020-03-18","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.20","nightly_discount":"0","subtotal":"123.20","grand_total":"139.21","paid_amount":"0.00","room_type_id":"295","product_id":"1128","siteminder_id":"EXP-1658309514","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":"99680","customer_id":"99680","source_of_creation":"Expedia","reservation_created_date":"2020-03-17 14:02:05","service_canceled_date_time":"2020-05-12 20:15:24","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"canceled resv amount refunded","total_paid_amount":"0.00","deltaChange":"0.00","changedComment":"resv paid or refunded after cancel","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3092327","reservation_id":"94591","confirmation_number":"BP12588905868","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.03,96.03","nightly_discount":"0,0","subtotal":"192.06","grand_total":"250.59","paid_amount":"250.59","room_type_id":"298","product_id":"1133","siteminder_id":"ABB-HMKZ54EAZQ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"192.06","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100791","customer_id":"100825","source_of_creation":"Airbnb","reservation_created_date":"2020-05-09 02:57:07","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"26.85","commision_charges":"5.94","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.03","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3092848","reservation_id":"94670","confirmation_number":"BP12592293949","room_stay_from":"2020-05-12","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"111.87","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":"100869","customer_id":"100869","source_of_creation":"FE","reservation_created_date":"2020-05-11 14:53:32","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3092870","reservation_id":"94672","confirmation_number":"BP12531105203","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100870","customer_id":"100870","source_of_creation":"PMS","reservation_created_date":"2020-05-11 16:21:08","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3092872","reservation_id":"94672","confirmation_number":"BP12249244321","room_confirmation_number":"BP12531105203","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","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":"100870","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-11 16:21:08","reservation_modified_date_time":"2020-05-11 16:21:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100870","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":"3092767","reservation_id":"94636","confirmation_number":"BP12262596252","room_confirmation_number":"BP12582834053","room_stay_from":"2020-05-10","room_stay_to":"2020-05-14","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":"100857","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-05-10 14:26:10","reservation_modified_date_time":"2020-05-10 22:00:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100857","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3092328","reservation_id":"94591","confirmation_number":"BP12251150542","room_confirmation_number":"BP12588905868","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","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":"100791","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-09 02:57:07","reservation_modified_date_time":"2020-05-09 02:57:07","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100825","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3092658","reservation_id":"94582","confirmation_number":"BP12245300442","room_confirmation_number":"BP12543077539","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","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":"92253","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-08 22:16:05","reservation_modified_date_time":"2020-05-10 16:16:33","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92253","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":"3092849","reservation_id":"94670","confirmation_number":"BP12262201537","room_confirmation_number":"BP12592293949","room_stay_from":"2020-05-12","room_stay_to":"2020-05-13","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":"100869","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 14:53:32","reservation_modified_date_time":"2020-05-11 14:53:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100869","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":"3092873","reservation_id":"94672","confirmation_number":"BP12277319878","room_confirmation_number":"BP12531105203","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","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":"100870","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-05-11 16:21:08","reservation_modified_date_time":"2020-05-11 16:21:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100870","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":"3092768","reservation_id":"94636","confirmation_number":"BP12265638208","room_confirmation_number":"BP12582834053","room_stay_from":"2020-05-10","room_stay_to":"2020-05-14","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":"100857","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-05-10 14:26:10","reservation_modified_date_time":"2020-05-10 22:00:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100857","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3092871","reservation_id":"94672","confirmation_number":"BP12256167926","room_confirmation_number":"BP12531105203","room_stay_from":"2020-05-11","room_stay_to":"2020-05-13","room_stay_status":"Active","nightly_price":"45.00,45.00","nightly_discount":"0.00,0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-11 16:21:08","reservation_modified_date_time":"2020-05-11 16:21:08","customer_id":"100870","parentCustTravId":"100870","customer_traveller_id":"100870","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":"45.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3093177","reservation_id":"94670","confirmation_number":"BP12227666348","room_confirmation_number":"BP12592293949","room_stay_from":"2020-05-12","room_stay_to":"2020-05-13","room_stay_status":"Active","nightly_price":"45.00","nightly_discount":"0.00","subtotal":"45.00","grand_total":"50.85","paid_amount":"50.85","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-12 18:11:13","reservation_modified_date_time":"2020-05-12 18:11:13","customer_id":"100869","parentCustTravId":"100869","customer_traveller_id":"100869","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":"45.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":[]}}}