{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-08-03","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":19,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1108,1121,1097,1104,1116,1107","block_room_bookings":[{"confirmation_number":"PB12265599492","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","bundle_room":"0"},{"confirmation_number":"PB12252895085","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","bundle_room":"0"},{"confirmation_number":"PB12228866367","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","bundle_room":"0"},{"confirmation_number":"PB12278240267","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","bundle_room":"0"},{"confirmation_number":"PB12259401735","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","bundle_room":"0"},{"confirmation_number":"PB12286454261","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","bundle_room":"0"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3123182","reservation_id":"98467","confirmation_number":"PB12388486854","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"108.7,108.7","nightly_discount":"0,0","subtotal":"217.40","grand_total":"245.66","paid_amount":"245.66","room_type_id":"289","product_id":"1101","siteminder_id":"BDC-3072093442","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104562","customer_id":"104562","source_of_creation":"Booking.com","reservation_created_date":"2020-08-01 14:01:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"47.61","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"108.7","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":"3122851","reservation_id":"98268","confirmation_number":"PB12332616595","room_stay_from":"2020-08-02","room_stay_to":"2020-08-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"105.58,105.58,105.58,105.58","nightly_discount":"0,0,0,0","subtotal":"422.32","grand_total":"477.22","paid_amount":"477.22","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3025832292","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104527","customer_id":"104527","source_of_creation":"Booking.com","reservation_created_date":"2020-07-28 01:49:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"93.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3122618","reservation_id":"93878","confirmation_number":"BV12411113294","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.69,90.19,90.19,90.19","nightly_discount":"0,0,0,0","subtotal":"376.26","grand_total":"425.18","paid_amount":"425.18","room_type_id":"308","product_id":"1225","siteminder_id":"EXP-1661090537","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":"104504","customer_id":"104504","source_of_creation":"Expedia","reservation_created_date":"2020-04-16 18:11:08","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.19","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":"3123108","reservation_id":"98423","confirmation_number":"PB12389996089","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"129.84,129.84","nightly_discount":"0.00,0.00","subtotal":"259.68","grand_total":"293.44","paid_amount":"293.44","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1684894283","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":"104477","customer_id":"104477","source_of_creation":"Expedia","reservation_created_date":"2020-08-03 13:56:14","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.84","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123206","reservation_id":"98481","confirmation_number":"PB12387538847","room_stay_from":"2020-08-03","room_stay_to":"2020-08-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.00,122.27,131.00","nightly_discount":"0,0,0","subtotal":"384.27","grand_total":"434.23","paid_amount":"434.23","room_type_id":"291","product_id":"1115","siteminder_id":"EXP-1685228949","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":"104564","customer_id":"104564","source_of_creation":"Expedia","reservation_created_date":"2020-08-01 21:59:10","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131.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":"3123176","reservation_id":"98251","confirmation_number":"PB12397434508","room_stay_from":"2020-08-02","room_stay_to":"2020-08-07","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"211.33,211.33,211.33,211.33,211.33","nightly_discount":"0,0,0,0,0","subtotal":"1056.65","grand_total":"1194.02","paid_amount":"0.00","room_type_id":"313","product_id":"1228","siteminder_id":"EXP-1683578773","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104293","customer_id":"104293","source_of_creation":"Expedia","reservation_created_date":"2020-07-27 20:26:10","canceled_nights_data":"","product_name":"PB Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"211.33","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":"3123335","reservation_id":"98545","confirmation_number":"PB12378996351","room_stay_from":"2020-08-03","room_stay_to":"2020-08-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.16,105.16,105.16,105.16","nightly_discount":"0,0,0,0","subtotal":"420.64","grand_total":"475.32","paid_amount":"475.32","room_type_id":"285","product_id":"1084","siteminder_id":"EXP-1685752484","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":"104581","customer_id":"104581","source_of_creation":"Expedia","reservation_created_date":"2020-08-03 17:44:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.16","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123106","reservation_id":"98423","confirmation_number":"PB12325710057","room_stay_from":"2020-07-31","room_stay_to":"2020-08-03","room_stay_status":"Checked-Out","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"145.92,145.92,129.84","nightly_discount":"0.00,0.00,0.00","subtotal":"421.68","grand_total":"476.50","paid_amount":"476.50","room_type_id":"286","product_id":"1086","siteminder_id":"EXP-1684894283","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":"104477","customer_id":"104477","source_of_creation":"Expedia","reservation_created_date":"2020-07-31 19:44:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3123395","reservation_id":"98563","confirmation_number":"PB12394178184","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"111.19,111.19","nightly_discount":"0.00,0.00","subtotal":"222.38","grand_total":"251.29","paid_amount":"176.50","room_type_id":"289","product_id":"1110","siteminder_id":"HTN-134086867-L99Q9T","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":"104587","customer_id":"104587","source_of_creation":"HotelTonight","reservation_created_date":"2020-08-04 00:14:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.19","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3122487","reservation_id":"98231","confirmation_number":"BV12427157118","room_stay_from":"2020-08-01","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.66,172.66,172.66","nightly_discount":"0,0,0","subtotal":"517.98","grand_total":"675.83","paid_amount":"675.83","room_type_id":"304","product_id":"1220","siteminder_id":"ABB-HMEYAWAMJ2","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"517.98","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104458","customer_id":"104458","source_of_creation":"Airbnb","reservation_created_date":"2020-08-01 14:14:45","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"72.41","commision_charges":"16.02","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.66","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":"3122508","reservation_id":"98420","confirmation_number":"PB12350781144","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.48,99.48","nightly_discount":"0.00,0.00","subtotal":"198.96","grand_total":"224.83","paid_amount":"224.83","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":"47798","customer_id":"47798","source_of_creation":"FE","reservation_created_date":"2020-07-31 17:16:30","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":"99.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3122857","reservation_id":"98497","confirmation_number":"PB12392667542","room_stay_from":"2020-08-02","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"117.04,117.04,117.04","nightly_discount":"0.00,0.00,0.00","subtotal":"351.12","grand_total":"396.77","paid_amount":"396.77","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104528","customer_id":"104528","source_of_creation":"FE","reservation_created_date":"2020-08-02 17:12:53","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.04","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3122104","reservation_id":"98386","confirmation_number":"BV12441569338","room_stay_from":"2020-07-31","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.78,150.78,119.25,119.25","nightly_discount":"0.00,34.87,0.00,0.00","subtotal":"540.06","grand_total":"570.86","paid_amount":"570.86","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"35000","customer_id":"35000","source_of_creation":"PMS","reservation_created_date":"2020-07-30 20:13:08","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3122577","reservation_id":"95065","confirmation_number":"PB12391621256","room_stay_from":"2020-08-01","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"264.00,264.00,214.00","nightly_discount":"0.00,25.28,0.00","subtotal":"742.00","grand_total":"809.89","paid_amount":"809.89","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":"28048","customer_id":"28048","source_of_creation":"PMS","reservation_created_date":"2020-05-19 20:27:43","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":"214.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3122579","reservation_id":"95065","confirmation_number":"PB12315855323","room_stay_from":"2020-08-01","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"264.00,264.00,214.00","nightly_discount":"0.00,25.28,0.00","subtotal":"742.00","grand_total":"809.89","paid_amount":"809.89","room_type_id":"291","product_id":"1117","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"28048","customer_id":"28048","source_of_creation":"PMS","reservation_created_date":"2020-05-19 20:27:43","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"214.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3122716","reservation_id":"98240","confirmation_number":"PB12349766341","room_stay_from":"2020-08-02","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"161.19,161.19","nightly_discount":"0.00,0.00","subtotal":"322.38","grand_total":"364.29","paid_amount":"364.29","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":"100266","customer_id":"100266","source_of_creation":"PMS","reservation_created_date":"2020-07-27 17:10:11","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":"161.19","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123043","reservation_id":"98326","confirmation_number":"PB12380150293","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"123.20","nightly_discount":"0.00","subtotal":"123.20","grand_total":"139.21","paid_amount":"139.21","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":"71046","customer_id":"71046","source_of_creation":"PMS","reservation_created_date":"2020-07-29 17:47:35","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":"123.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":"3123067","reservation_id":"98080","confirmation_number":"BV12471090791","room_stay_from":"2020-07-28","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"127.20,127.20,101.76,139.00,139.00,103.00,103.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"840.16","grand_total":"949.38","paid_amount":"949.38","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":"101368","customer_id":"101368","source_of_creation":"PMS","reservation_created_date":"2020-07-23 14:36:12","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":"","currentDayPrice":"103.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123100","reservation_id":"98532","confirmation_number":"PB12393392548","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"207.07","nightly_discount":"0.00","subtotal":"207.07","grand_total":"233.98","paid_amount":"233.98","room_type_id":"287","product_id":"1088","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":"103622","customer_id":"103622","source_of_creation":"PMS","reservation_created_date":"2020-08-03 13:25:29","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"207.07","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3116325","reservation_id":"97805","confirmation_number":"PB12380632969","room_stay_from":"2020-08-02","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.00,137.00,137.00","nightly_discount":"0.00,0.00,0.00","subtotal":"411.00","grand_total":"464.43","paid_amount":"464.43","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103877","customer_id":"103877","source_of_creation":"PMS","reservation_created_date":"2020-07-16 00:41:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3116327","reservation_id":"97805","confirmation_number":"PB12317432321","room_stay_from":"2020-08-02","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.00,137.00,137.00","nightly_discount":"0.00,0.00,0.00","subtotal":"411.00","grand_total":"464.43","paid_amount":"464.43","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":"103877","customer_id":"103877","source_of_creation":"PMS","reservation_created_date":"2020-07-16 00:41:12","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":"137.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3117879","reservation_id":"97805","confirmation_number":"PB12392219284","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.00,137.00,137.00,137.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"548.00","grand_total":"619.24","paid_amount":"619.24","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":"103877","customer_id":"103877","source_of_creation":"PMS","reservation_created_date":"2020-07-16 00:41:12","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":"137.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3122573","reservation_id":"95065","confirmation_number":"PB12394877671","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"316.00,316.00,266.00,266.00","nightly_discount":"0.00,44.04,0.00,0.00","subtotal":"1164.00","grand_total":"1265.56","paid_amount":"1265.56","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":"28048","customer_id":"28048","source_of_creation":"PMS","reservation_created_date":"2020-05-19 20:27:43","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":"266.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123135","reservation_id":"98448","confirmation_number":"PB12316274501","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.93,117.04,111.00,111.00","nightly_discount":"7.41,0.00,0.00,0.00","subtotal":"511.97","grand_total":"570.15","paid_amount":"570.15","room_type_id":"289","product_id":"1111","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":"104466","customer_id":"104466","source_of_creation":"PMS","reservation_created_date":"2020-08-01 00:31:56","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"111.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123169","reservation_id":"98208","confirmation_number":"BP12515528150","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,5.50","subtotal":"198.00","grand_total":"217.53","paid_amount":"218.24","room_type_id":"300","product_id":"1135","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104262","customer_id":"104262","source_of_creation":"PMS","reservation_created_date":"2020-07-26 17:07:16","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":"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":"3123194","reservation_id":"98546","confirmation_number":"PB12342022185","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"196.72,196.72","nightly_discount":"0.00,0.00","subtotal":"393.44","grand_total":"444.59","paid_amount":"444.59","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":"46810","customer_id":"46810","source_of_creation":"PMS","reservation_created_date":"2020-08-03 18:38:40","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":"196.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123276","reservation_id":"98550","confirmation_number":"PB12320252262","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"111.19,111.19","nightly_discount":"0.00,14.31","subtotal":"222.38","grand_total":"235.11","paid_amount":"235.11","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":"104566","customer_id":"104566","source_of_creation":"PMS","reservation_created_date":"2020-08-03 20:34:51","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":"111.19","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095535","reservation_id":"88566","confirmation_number":"PB12385391898","room_stay_from":"2020-07-31","room_stay_to":"2020-08-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"316.00,266.00,266.00,266.00,266.00,266.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0","subtotal":"1646.00","grand_total":"1859.98","paid_amount":"1859.98","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":"94763","customer_id":"94763","source_of_creation":"PMS","reservation_created_date":"2019-12-22 21:25:50","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"266.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123313","reservation_id":"98556","confirmation_number":"BP12574585738","room_stay_from":"2020-08-03","room_stay_to":"2020-08-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"96.51,96.51,96.51","nightly_discount":"0.00,0.00,17.77","subtotal":"289.53","grand_total":"307.09","paid_amount":"307.09","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":"104573","customer_id":"104573","source_of_creation":"PMS","reservation_created_date":"2020-08-03 23:07:29","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":"96.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092379","reservation_id":"82917","confirmation_number":"PB12365259765","room_stay_from":"2020-08-03","room_stay_to":"2020-08-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"2091.00","grand_total":"2362.83","paid_amount":"2362.83","room_type_id":"289","product_id":"1106","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23537","customer_id":"23537","source_of_creation":"PMS","reservation_created_date":"2019-08-19 16:40:45","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3123297","reservation_id":"88357","confirmation_number":"BV12452301649","room_stay_from":"2020-11-28","room_stay_to":"2020-12-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.00,87.00,87.00,87.00,87.00,87.00,107.00,107.00,87.00,87.00,87.00,87.00,87.00,107.00,107.00,87.00,87.00,87.00,87.00,87.00,107.00,107.00,87.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","subtotal":"2141.00","grand_total":"2419.33","paid_amount":"120.91","room_type_id":"309","product_id":"1226","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24275","customer_id":"24275","source_of_creation":"PMS","reservation_created_date":"2019-12-15 20:47:21","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3122717","reservation_id":"98240","confirmation_number":"PB12210342662","room_confirmation_number":"PB12349766341","room_stay_from":"2020-08-02","room_stay_to":"2020-08-04","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":"100266","product_attribute_values":"extra_person# ","reservation_created_date":"2020-08-01 23:37:33","reservation_modified_date_time":"2020-08-01 23:37:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100266","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3123045","reservation_id":"98326","confirmation_number":"PB12240345539","room_confirmation_number":"PB12380150293","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","room_stay_status":"Active","nightly_price":"30","nightly_discount":"0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"71046","product_attribute_values":"extra_person# ","reservation_created_date":"2020-08-02 23:46:35","reservation_modified_date_time":"2020-08-02 23:46:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71046","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3122858","reservation_id":"98497","confirmation_number":"PB12258420738","room_confirmation_number":"PB12392667542","room_stay_from":"2020-08-02","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"104528","product_attribute_values":"extra_person# ","reservation_created_date":"2020-08-02 17:14:59","reservation_modified_date_time":"2020-08-02 17:14:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104528","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3123179","reservation_id":"98467","confirmation_number":"PB12272511301","room_confirmation_number":"PB12388486854","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"30,30","nightly_discount":"0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"104562","product_attribute_values":"extra_person# ","reservation_created_date":"2020-08-01 15:22:20","reservation_modified_date_time":"2020-08-03 17:41:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104562","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.00","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123277","reservation_id":"98550","confirmation_number":"PB12234270858","room_confirmation_number":"PB12320252262","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","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":"104566","product_attribute_values":"extra_person# ","reservation_created_date":"2020-08-03 21:15:00","reservation_modified_date_time":"2020-08-03 21:15:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104566","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3122849","reservation_id":"98268","confirmation_number":"PB12241323610","room_confirmation_number":"PB12332616595","room_stay_from":"2020-08-02","room_stay_to":"2020-08-06","room_stay_status":"Active","nightly_price":"30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"104527","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-07-28 01:49:07","reservation_modified_date_time":"2020-08-02 16:57:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104527","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123307","reservation_id":"98556","confirmation_number":"BP12257451011","room_confirmation_number":"BP12574585738","room_stay_from":"2020-08-03","room_stay_to":"2020-08-06","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"104573","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-08-03 23:07:29","reservation_modified_date_time":"2020-08-03 23:07:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104573","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3123177","reservation_id":"98251","confirmation_number":"PB12292907551","room_confirmation_number":"PB12397434508","room_stay_from":"2020-08-02","room_stay_to":"2020-08-07","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"104293","product_attribute_values":"extra_person# ","reservation_created_date":"2020-08-03 17:40:14","reservation_modified_date_time":"2020-08-03 17:40:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104293","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","changedComment":"Reservation created with partial past date","deltaChange":"10.00","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3122105","reservation_id":"98386","confirmation_number":"BV12222387527","room_confirmation_number":"BV12441569338","room_stay_from":"2020-07-31","room_stay_to":"2020-08-04","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":"35000","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-30 20:13:08","reservation_modified_date_time":"2020-07-31 18:56:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"35000","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122488","reservation_id":"98231","confirmation_number":"BV12218105475","room_confirmation_number":"BV12427157118","room_stay_from":"2020-08-01","room_stay_to":"2020-08-04","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":"104458","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-01 14:14:45","reservation_modified_date_time":"2020-08-01 14:14:45","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104458","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3122578","reservation_id":"95065","confirmation_number":"PB12251389584","room_confirmation_number":"PB12391621256","room_stay_from":"2020-08-01","room_stay_to":"2020-08-04","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.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"28048","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-19 20:27:43","reservation_modified_date_time":"2020-08-01 18:07:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28048","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122580","reservation_id":"95065","confirmation_number":"PB12261136722","room_confirmation_number":"PB12315855323","room_stay_from":"2020-08-01","room_stay_to":"2020-08-04","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.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"28048","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-19 20:27:43","reservation_modified_date_time":"2020-08-01 18:08:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28048","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122718","reservation_id":"98240","confirmation_number":"PB12288948081","room_confirmation_number":"PB12349766341","room_stay_from":"2020-08-02","room_stay_to":"2020-08-04","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":"100266","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-27 17:10:11","reservation_modified_date_time":"2020-08-01 23:37:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100266","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123046","reservation_id":"98326","confirmation_number":"PB12221508679","room_confirmation_number":"PB12380150293","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","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":"71046","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-29 17:47:35","reservation_modified_date_time":"2020-08-02 23:46:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71046","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123068","reservation_id":"98080","confirmation_number":"BV12223281498","room_confirmation_number":"BV12471090791","room_stay_from":"2020-07-28","room_stay_to":"2020-08-04","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":"101368","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-23 14:36:12","reservation_modified_date_time":"2020-08-03 02:17:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101368","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123101","reservation_id":"98532","confirmation_number":"PB12299786640","room_confirmation_number":"PB12393392548","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","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":"103622","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-03 13:25:29","reservation_modified_date_time":"2020-08-03 13:25:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103622","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3116326","reservation_id":"97805","confirmation_number":"PB12296754052","room_confirmation_number":"PB12380632969","room_stay_from":"2020-08-02","room_stay_to":"2020-08-05","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":"103877","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-16 00:41:11","reservation_modified_date_time":"2020-07-16 00:41:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103877","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3116328","reservation_id":"97805","confirmation_number":"PB12224047208","room_confirmation_number":"PB12317432321","room_stay_from":"2020-08-02","room_stay_to":"2020-08-05","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":"103877","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-16 00:41:12","reservation_modified_date_time":"2020-07-16 00:41:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103877","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3117880","reservation_id":"97805","confirmation_number":"PB12263136998","room_confirmation_number":"PB12392219284","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"103877","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-16 00:41:12","reservation_modified_date_time":"2020-07-19 22:59:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103877","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122509","reservation_id":"98420","confirmation_number":"PB12287629098","room_confirmation_number":"PB12350781144","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"47798","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-31 17:16:30","reservation_modified_date_time":"2020-08-01 15:44:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122574","reservation_id":"95065","confirmation_number":"PB12285655529","room_confirmation_number":"PB12394877671","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"53.38","product_id":"1781","service_quantity":"1","customer_traveller_id":"28048","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-19 20:27:43","reservation_modified_date_time":"2020-08-01 18:03:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28048","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122617","reservation_id":"93878","confirmation_number":"BV12282185498","room_confirmation_number":"BV12411113294","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","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":"104504","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-04-16 18:11:08","reservation_modified_date_time":"2020-08-01 19:38:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104504","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3122859","reservation_id":"98497","confirmation_number":"PB12258483123","room_confirmation_number":"PB12392667542","room_stay_from":"2020-08-02","room_stay_to":"2020-08-05","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":"104528","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-02 17:12:53","reservation_modified_date_time":"2020-08-02 17:14:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104528","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123109","reservation_id":"98423","confirmation_number":"PB12212960425","room_confirmation_number":"PB12389996089","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"104477","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-03 13:56:14","reservation_modified_date_time":"2020-08-03 13:56:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104477","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3123136","reservation_id":"98448","confirmation_number":"PB12270348148","room_confirmation_number":"PB12316274501","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"104466","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-01 00:31:56","reservation_modified_date_time":"2020-08-03 14:50:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104466","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3123170","reservation_id":"98208","confirmation_number":"BP12299198425","room_confirmation_number":"BP12515528150","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"104262","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-26 17:07:16","reservation_modified_date_time":"2020-08-03 17:00:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104262","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123180","reservation_id":"98467","confirmation_number":"PB12235694960","room_confirmation_number":"PB12388486854","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"104562","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-01 14:01:11","reservation_modified_date_time":"2020-08-03 17:41:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104562","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.00","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":"3123195","reservation_id":"98546","confirmation_number":"PB12233059709","room_confirmation_number":"PB12342022185","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"46810","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-03 18:38:40","reservation_modified_date_time":"2020-08-03 18:38:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"46810","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123278","reservation_id":"98550","confirmation_number":"PB12258405469","room_confirmation_number":"PB12320252262","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"104566","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-03 20:34:51","reservation_modified_date_time":"2020-08-03 21:15:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104566","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123394","reservation_id":"98563","confirmation_number":"PB12257809984","room_confirmation_number":"PB12394178184","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"104587","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-04 00:14:11","reservation_modified_date_time":"2020-08-04 03:17:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104587","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095536","reservation_id":"88566","confirmation_number":"PB12294563342","room_confirmation_number":"PB12385391898","room_stay_from":"2020-07-31","room_stay_to":"2020-08-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"94763","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-22 21:25:50","reservation_modified_date_time":"2020-05-20 17:25:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94763","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122850","reservation_id":"98268","confirmation_number":"PB12214544546","room_confirmation_number":"PB12332616595","room_stay_from":"2020-08-02","room_stay_to":"2020-08-06","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":"104527","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-07-28 01:49:07","reservation_modified_date_time":"2020-08-02 16:57:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104527","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","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":"3123205","reservation_id":"98481","confirmation_number":"PB12223652524","room_confirmation_number":"PB12387538847","room_stay_from":"2020-08-03","room_stay_to":"2020-08-06","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":"104564","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-01 21:59:10","reservation_modified_date_time":"2020-08-03 19:03:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104564","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3123314","reservation_id":"98556","confirmation_number":"BP12244326731","room_confirmation_number":"BP12574585738","room_stay_from":"2020-08-03","room_stay_to":"2020-08-06","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":"104573","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-03 23:07:29","reservation_modified_date_time":"2020-08-03 23:29:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104573","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123178","reservation_id":"98251","confirmation_number":"PB12290054895","room_confirmation_number":"PB12397434508","room_stay_from":"2020-08-02","room_stay_to":"2020-08-07","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"104293","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-07-27 20:26:10","reservation_modified_date_time":"2020-08-03 17:40:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104293","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","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":"3123334","reservation_id":"98545","confirmation_number":"PB12245597561","room_confirmation_number":"PB12378996351","room_stay_from":"2020-08-03","room_stay_to":"2020-08-07","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":"104581","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-03 17:44:10","reservation_modified_date_time":"2020-08-04 01:19:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104581","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3092380","reservation_id":"82917","confirmation_number":"PB12261782007","room_confirmation_number":"PB12365259765","room_stay_from":"2020-08-03","room_stay_to":"2020-08-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23537","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-19 16:40:45","reservation_modified_date_time":"2020-05-09 15:00:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23537","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123091","reservation_id":"98490","confirmation_number":"BV12257088433","room_confirmation_number":"BV12482188105","room_stay_from":"2020-08-02","room_stay_to":"2020-08-03","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"104523","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-02 14:34:10","reservation_modified_date_time":"2020-08-03 12:48:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104523","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"Nightly price or discount changed","deltaChange":"-20.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123107","reservation_id":"98423","confirmation_number":"PB12252235814","room_confirmation_number":"PB12325710057","room_stay_from":"2020-07-31","room_stay_to":"2020-08-03","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":"37.79","product_id":"1781","service_quantity":"1","customer_traveller_id":"104477","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-07-31 19:44:12","reservation_modified_date_time":"2020-08-03 13:56:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104477","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123298","reservation_id":"88357","confirmation_number":"BV12246934757","room_confirmation_number":"BV12452301649","room_stay_from":"2020-11-28","room_stay_to":"2020-12-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24275","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-15 20:47:21","reservation_modified_date_time":"2020-08-03 22:09:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24275","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3121810","reservation_id":"98386","confirmation_number":"BV12217650738","room_confirmation_number":"BV12441569338","room_stay_from":"2020-07-31","room_stay_to":"2020-08-04","room_stay_status":"Active","nightly_price":"45.00,45.00,45.00,45.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-30 20:18:24","reservation_modified_date_time":"2020-07-30 20:18:24","customer_id":"35000","parentCustTravId":"35000","customer_traveller_id":"35000","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":"3122489","reservation_id":"98231","confirmation_number":"BV12232442387","room_confirmation_number":"BV12427157118","room_stay_from":"2020-08-01","room_stay_to":"2020-08-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.75","paid_amount":"84.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-01 14:25:20","reservation_modified_date_time":"2020-08-01 14:25:20","customer_id":"104458","parentCustTravId":"104458","customer_traveller_id":"104458","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3123069","reservation_id":"98080","confirmation_number":"BV12241168935","room_confirmation_number":"BV12471090791","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-03 02:16:15","reservation_modified_date_time":"2020-08-03 02:17:24","customer_id":"101368","parentCustTravId":"101368","customer_traveller_id":"101368","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3123114","reservation_id":"98394","confirmation_number":"PB12238556024","room_confirmation_number":"PB12315492117","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":"22.60","paid_amount":"0.00","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-03 14:08:12","reservation_modified_date_time":"2020-08-03 14:08:12","customer_id":"104418","parentCustTravId":"104418","customer_traveller_id":"104418","static_pos_type":"latecheckoutfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3123137","reservation_id":"98448","confirmation_number":"PB12240636709","room_confirmation_number":"PB12316274501","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"2.00","paid_amount":"2.00","product_id":"1213","service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-03 14:53:23","reservation_modified_date_time":"2020-08-03 14:53:23","customer_id":"104466","parentCustTravId":"104466","customer_traveller_id":"104466","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":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3123181","reservation_id":"98467","confirmation_number":"PB12280342894","room_confirmation_number":"PB12388486854","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"26.75","paid_amount":"26.75","product_id":"1175","service_quantity":"1","product_name":"Miscellaneous","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-03 17:35:30","reservation_modified_date_time":"2020-08-03 17:41:30","customer_id":"104562","parentCustTravId":"104562","customer_traveller_id":"104562","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3123204","reservation_id":"98481","confirmation_number":"PB12216433279","room_confirmation_number":"PB12387538847","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1212","service_quantity":"2","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-03 18:55:37","reservation_modified_date_time":"2020-08-03 19:03:42","customer_id":"104564","parentCustTravId":"104564","customer_traveller_id":"104564","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":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3123228","reservation_id":"98481","confirmation_number":"PB12219021479","room_confirmation_number":"PB12387538847","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","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-08-03 20:07:36","reservation_modified_date_time":"2020-08-03 20:07:36","customer_id":"104564","parentCustTravId":"104564","customer_traveller_id":"104564","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":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3123309","reservation_id":"98550","confirmation_number":"PB12232472845","room_confirmation_number":"PB12320252262","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-03 23:16:39","reservation_modified_date_time":"2020-08-03 23:16:39","customer_id":"104566","parentCustTravId":"104566","customer_traveller_id":"104566","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":"28.05","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3123116","reservation_id":"98535","confirmation_number":"PB12288552342","room_confirmation_number":"PB12329793024","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-03 14:12:21","reservation_modified_date_time":"2020-08-03 14:12:21","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3122114","reservation_id":"98293","confirmation_number":"PB12237091630","room_confirmation_number":"PB12332032350","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":"60.00","paid_amount":"0.00","product_id":"2010","service_quantity":"6","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-31 20:10:38","reservation_modified_date_time":"2020-07-31 20:10:38","customer_id":"104440","parentCustTravId":"104440","customer_traveller_id":"104440","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-08-03 17:02:49","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-56.1,"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":"3122531","reservation_id":"98232","confirmation_number":"PB12288459815","room_confirmation_number":"PB12323469302","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":"60.00","paid_amount":"0.00","product_id":"2010","service_quantity":"6","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-01 16:32:45","reservation_modified_date_time":"2020-08-01 16:32:45","customer_id":"104279","parentCustTravId":"104279","customer_traveller_id":"104279","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-08-03 15:56:10","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-56.1,"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":"3122678","reservation_id":"98312","confirmation_number":"PB12254344880","room_confirmation_number":"PB12395836235","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-08-01 21:57:26","reservation_modified_date_time":"2020-08-01 21:57:26","customer_id":"104506","parentCustTravId":"104506","customer_traveller_id":"104506","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-08-03 14:10:01","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"}]},{"room_stay_id":"3122881","reservation_id":"98488","confirmation_number":"PB12216139789","room_confirmation_number":"PB12374563349","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-08-02 18:11:26","reservation_modified_date_time":"2020-08-02 18:11:26","customer_id":"104529","parentCustTravId":"104529","customer_traveller_id":"104529","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-08-03 13:46:40","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":"3123025","reservation_id":"98313","confirmation_number":"BV12211925890","room_confirmation_number":"BV12432795301","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":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-02 22:59:57","reservation_modified_date_time":"2020-08-02 22:59:57","customer_id":"104350","parentCustTravId":"104350","customer_traveller_id":"104350","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-08-03 15:07:24","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-28.05,"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":[]},"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":13,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1108,1121,1097,1104,1116,1107","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12265599492","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","bundle_room":"0"},{"confirmation_number":"PB12252895085","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","bundle_room":"0"},{"confirmation_number":"PB12228866367","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","bundle_room":"0"},{"confirmation_number":"PB12278240267","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","bundle_room":"0"},{"confirmation_number":"PB12259401735","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","bundle_room":"0"},{"confirmation_number":"PB12286454261","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3123182","reservation_id":"98467","confirmation_number":"PB12388486854","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"108.7,108.7","nightly_discount":"0,0","subtotal":"217.40","grand_total":"245.66","paid_amount":"245.66","room_type_id":"289","product_id":"1101","siteminder_id":"BDC-3072093442","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104562","customer_id":"104562","source_of_creation":"Booking.com","reservation_created_date":"2020-08-01 14:01:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"47.61","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"108.7","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":"3122851","reservation_id":"98268","confirmation_number":"PB12332616595","room_stay_from":"2020-08-02","room_stay_to":"2020-08-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"105.58,105.58,105.58,105.58","nightly_discount":"0,0,0,0","subtotal":"422.32","grand_total":"477.22","paid_amount":"477.22","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3025832292","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104527","customer_id":"104527","source_of_creation":"Booking.com","reservation_created_date":"2020-07-28 01:49:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"93.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3123108","reservation_id":"98423","confirmation_number":"PB12389996089","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"129.84,129.84","nightly_discount":"0.00,0.00","subtotal":"259.68","grand_total":"293.44","paid_amount":"293.44","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1684894283","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":"104477","customer_id":"104477","source_of_creation":"Expedia","reservation_created_date":"2020-08-03 13:56:14","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.84","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123206","reservation_id":"98481","confirmation_number":"PB12387538847","room_stay_from":"2020-08-03","room_stay_to":"2020-08-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.00,122.27,131.00","nightly_discount":"0,0,0","subtotal":"384.27","grand_total":"434.23","paid_amount":"434.23","room_type_id":"291","product_id":"1115","siteminder_id":"EXP-1685228949","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":"104564","customer_id":"104564","source_of_creation":"Expedia","reservation_created_date":"2020-08-01 21:59:10","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131.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":"3123176","reservation_id":"98251","confirmation_number":"PB12397434508","room_stay_from":"2020-08-02","room_stay_to":"2020-08-07","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"211.33,211.33,211.33,211.33,211.33","nightly_discount":"0,0,0,0,0","subtotal":"1056.65","grand_total":"1194.02","paid_amount":"0.00","room_type_id":"313","product_id":"1228","siteminder_id":"EXP-1683578773","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104293","customer_id":"104293","source_of_creation":"Expedia","reservation_created_date":"2020-07-27 20:26:10","canceled_nights_data":"","product_name":"PB Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"211.33","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":"3123335","reservation_id":"98545","confirmation_number":"PB12378996351","room_stay_from":"2020-08-03","room_stay_to":"2020-08-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.16,105.16,105.16,105.16","nightly_discount":"0,0,0,0","subtotal":"420.64","grand_total":"475.32","paid_amount":"475.32","room_type_id":"285","product_id":"1084","siteminder_id":"EXP-1685752484","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":"104581","customer_id":"104581","source_of_creation":"Expedia","reservation_created_date":"2020-08-03 17:44:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.16","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123106","reservation_id":"98423","confirmation_number":"PB12325710057","room_stay_from":"2020-07-31","room_stay_to":"2020-08-03","room_stay_status":"Checked-Out","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"145.92,145.92,129.84","nightly_discount":"0.00,0.00,0.00","subtotal":"421.68","grand_total":"476.50","paid_amount":"476.50","room_type_id":"286","product_id":"1086","siteminder_id":"EXP-1684894283","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":"104477","customer_id":"104477","source_of_creation":"Expedia","reservation_created_date":"2020-07-31 19:44:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3123395","reservation_id":"98563","confirmation_number":"PB12394178184","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"111.19,111.19","nightly_discount":"0.00,0.00","subtotal":"222.38","grand_total":"251.29","paid_amount":"176.50","room_type_id":"289","product_id":"1110","siteminder_id":"HTN-134086867-L99Q9T","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":"104587","customer_id":"104587","source_of_creation":"HotelTonight","reservation_created_date":"2020-08-04 00:14:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.19","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3122508","reservation_id":"98420","confirmation_number":"PB12350781144","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.48,99.48","nightly_discount":"0.00,0.00","subtotal":"198.96","grand_total":"224.83","paid_amount":"224.83","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":"47798","customer_id":"47798","source_of_creation":"FE","reservation_created_date":"2020-07-31 17:16:30","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":"99.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3122857","reservation_id":"98497","confirmation_number":"PB12392667542","room_stay_from":"2020-08-02","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"117.04,117.04,117.04","nightly_discount":"0.00,0.00,0.00","subtotal":"351.12","grand_total":"396.77","paid_amount":"396.77","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104528","customer_id":"104528","source_of_creation":"FE","reservation_created_date":"2020-08-02 17:12:53","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.04","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3122577","reservation_id":"95065","confirmation_number":"PB12391621256","room_stay_from":"2020-08-01","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"264.00,264.00,214.00","nightly_discount":"0.00,25.28,0.00","subtotal":"742.00","grand_total":"809.89","paid_amount":"809.89","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":"28048","customer_id":"28048","source_of_creation":"PMS","reservation_created_date":"2020-05-19 20:27:43","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":"214.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3122579","reservation_id":"95065","confirmation_number":"PB12315855323","room_stay_from":"2020-08-01","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"264.00,264.00,214.00","nightly_discount":"0.00,25.28,0.00","subtotal":"742.00","grand_total":"809.89","paid_amount":"809.89","room_type_id":"291","product_id":"1117","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"28048","customer_id":"28048","source_of_creation":"PMS","reservation_created_date":"2020-05-19 20:27:43","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"214.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3122716","reservation_id":"98240","confirmation_number":"PB12349766341","room_stay_from":"2020-08-02","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"161.19,161.19","nightly_discount":"0.00,0.00","subtotal":"322.38","grand_total":"364.29","paid_amount":"364.29","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":"100266","customer_id":"100266","source_of_creation":"PMS","reservation_created_date":"2020-07-27 17:10:11","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":"161.19","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123043","reservation_id":"98326","confirmation_number":"PB12380150293","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"123.20","nightly_discount":"0.00","subtotal":"123.20","grand_total":"139.21","paid_amount":"139.21","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":"71046","customer_id":"71046","source_of_creation":"PMS","reservation_created_date":"2020-07-29 17:47:35","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":"123.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":"3123100","reservation_id":"98532","confirmation_number":"PB12393392548","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"207.07","nightly_discount":"0.00","subtotal":"207.07","grand_total":"233.98","paid_amount":"233.98","room_type_id":"287","product_id":"1088","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":"103622","customer_id":"103622","source_of_creation":"PMS","reservation_created_date":"2020-08-03 13:25:29","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"207.07","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3116325","reservation_id":"97805","confirmation_number":"PB12380632969","room_stay_from":"2020-08-02","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.00,137.00,137.00","nightly_discount":"0.00,0.00,0.00","subtotal":"411.00","grand_total":"464.43","paid_amount":"464.43","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"103877","customer_id":"103877","source_of_creation":"PMS","reservation_created_date":"2020-07-16 00:41:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3116327","reservation_id":"97805","confirmation_number":"PB12317432321","room_stay_from":"2020-08-02","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.00,137.00,137.00","nightly_discount":"0.00,0.00,0.00","subtotal":"411.00","grand_total":"464.43","paid_amount":"464.43","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":"103877","customer_id":"103877","source_of_creation":"PMS","reservation_created_date":"2020-07-16 00:41:12","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":"137.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3117879","reservation_id":"97805","confirmation_number":"PB12392219284","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.00,137.00,137.00,137.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"548.00","grand_total":"619.24","paid_amount":"619.24","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":"103877","customer_id":"103877","source_of_creation":"PMS","reservation_created_date":"2020-07-16 00:41:12","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":"137.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3122573","reservation_id":"95065","confirmation_number":"PB12394877671","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"316.00,316.00,266.00,266.00","nightly_discount":"0.00,44.04,0.00,0.00","subtotal":"1164.00","grand_total":"1265.56","paid_amount":"1265.56","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":"28048","customer_id":"28048","source_of_creation":"PMS","reservation_created_date":"2020-05-19 20:27:43","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":"266.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123135","reservation_id":"98448","confirmation_number":"PB12316274501","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.93,117.04,111.00,111.00","nightly_discount":"7.41,0.00,0.00,0.00","subtotal":"511.97","grand_total":"570.15","paid_amount":"570.15","room_type_id":"289","product_id":"1111","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":"104466","customer_id":"104466","source_of_creation":"PMS","reservation_created_date":"2020-08-01 00:31:56","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"111.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123194","reservation_id":"98546","confirmation_number":"PB12342022185","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"196.72,196.72","nightly_discount":"0.00,0.00","subtotal":"393.44","grand_total":"444.59","paid_amount":"444.59","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":"46810","customer_id":"46810","source_of_creation":"PMS","reservation_created_date":"2020-08-03 18:38:40","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":"196.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123276","reservation_id":"98550","confirmation_number":"PB12320252262","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"111.19,111.19","nightly_discount":"0.00,14.31","subtotal":"222.38","grand_total":"235.11","paid_amount":"235.11","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":"104566","customer_id":"104566","source_of_creation":"PMS","reservation_created_date":"2020-08-03 20:34:51","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":"111.19","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095535","reservation_id":"88566","confirmation_number":"PB12385391898","room_stay_from":"2020-07-31","room_stay_to":"2020-08-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"316.00,266.00,266.00,266.00,266.00,266.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0","subtotal":"1646.00","grand_total":"1859.98","paid_amount":"1859.98","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":"94763","customer_id":"94763","source_of_creation":"PMS","reservation_created_date":"2019-12-22 21:25:50","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"266.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3092379","reservation_id":"82917","confirmation_number":"PB12365259765","room_stay_from":"2020-08-03","room_stay_to":"2020-08-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"2091.00","grand_total":"2362.83","paid_amount":"2362.83","room_type_id":"289","product_id":"1106","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23537","customer_id":"23537","source_of_creation":"PMS","reservation_created_date":"2019-08-19 16:40:45","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3122717","reservation_id":"98240","confirmation_number":"PB12210342662","room_confirmation_number":"PB12349766341","room_stay_from":"2020-08-02","room_stay_to":"2020-08-04","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":"100266","product_attribute_values":"extra_person# ","reservation_created_date":"2020-08-01 23:37:33","reservation_modified_date_time":"2020-08-01 23:37:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100266","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3123045","reservation_id":"98326","confirmation_number":"PB12240345539","room_confirmation_number":"PB12380150293","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","room_stay_status":"Active","nightly_price":"30","nightly_discount":"0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"71046","product_attribute_values":"extra_person# ","reservation_created_date":"2020-08-02 23:46:35","reservation_modified_date_time":"2020-08-02 23:46:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71046","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3122858","reservation_id":"98497","confirmation_number":"PB12258420738","room_confirmation_number":"PB12392667542","room_stay_from":"2020-08-02","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"104528","product_attribute_values":"extra_person# ","reservation_created_date":"2020-08-02 17:14:59","reservation_modified_date_time":"2020-08-02 17:14:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104528","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3123179","reservation_id":"98467","confirmation_number":"PB12272511301","room_confirmation_number":"PB12388486854","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"30,30","nightly_discount":"0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"104562","product_attribute_values":"extra_person# ","reservation_created_date":"2020-08-01 15:22:20","reservation_modified_date_time":"2020-08-03 17:41:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104562","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.00","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123277","reservation_id":"98550","confirmation_number":"PB12234270858","room_confirmation_number":"PB12320252262","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","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":"104566","product_attribute_values":"extra_person# ","reservation_created_date":"2020-08-03 21:15:00","reservation_modified_date_time":"2020-08-03 21:15:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104566","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3122849","reservation_id":"98268","confirmation_number":"PB12241323610","room_confirmation_number":"PB12332616595","room_stay_from":"2020-08-02","room_stay_to":"2020-08-06","room_stay_status":"Active","nightly_price":"30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"104527","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-07-28 01:49:07","reservation_modified_date_time":"2020-08-02 16:57:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104527","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123177","reservation_id":"98251","confirmation_number":"PB12292907551","room_confirmation_number":"PB12397434508","room_stay_from":"2020-08-02","room_stay_to":"2020-08-07","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"104293","product_attribute_values":"extra_person# ","reservation_created_date":"2020-08-03 17:40:14","reservation_modified_date_time":"2020-08-03 17:40:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104293","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","changedComment":"Reservation created with partial past date","deltaChange":"10.00","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3122578","reservation_id":"95065","confirmation_number":"PB12251389584","room_confirmation_number":"PB12391621256","room_stay_from":"2020-08-01","room_stay_to":"2020-08-04","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.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"28048","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-19 20:27:43","reservation_modified_date_time":"2020-08-01 18:07:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28048","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122580","reservation_id":"95065","confirmation_number":"PB12261136722","room_confirmation_number":"PB12315855323","room_stay_from":"2020-08-01","room_stay_to":"2020-08-04","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.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"28048","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-19 20:27:43","reservation_modified_date_time":"2020-08-01 18:08:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28048","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122718","reservation_id":"98240","confirmation_number":"PB12288948081","room_confirmation_number":"PB12349766341","room_stay_from":"2020-08-02","room_stay_to":"2020-08-04","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":"100266","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-27 17:10:11","reservation_modified_date_time":"2020-08-01 23:37:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100266","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123046","reservation_id":"98326","confirmation_number":"PB12221508679","room_confirmation_number":"PB12380150293","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","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":"71046","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-29 17:47:35","reservation_modified_date_time":"2020-08-02 23:46:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71046","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123101","reservation_id":"98532","confirmation_number":"PB12299786640","room_confirmation_number":"PB12393392548","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","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":"103622","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-03 13:25:29","reservation_modified_date_time":"2020-08-03 13:25:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103622","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3116326","reservation_id":"97805","confirmation_number":"PB12296754052","room_confirmation_number":"PB12380632969","room_stay_from":"2020-08-02","room_stay_to":"2020-08-05","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":"103877","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-16 00:41:11","reservation_modified_date_time":"2020-07-16 00:41:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103877","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3116328","reservation_id":"97805","confirmation_number":"PB12224047208","room_confirmation_number":"PB12317432321","room_stay_from":"2020-08-02","room_stay_to":"2020-08-05","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":"103877","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-16 00:41:12","reservation_modified_date_time":"2020-07-16 00:41:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103877","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3117880","reservation_id":"97805","confirmation_number":"PB12263136998","room_confirmation_number":"PB12392219284","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"103877","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-16 00:41:12","reservation_modified_date_time":"2020-07-19 22:59:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103877","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122509","reservation_id":"98420","confirmation_number":"PB12287629098","room_confirmation_number":"PB12350781144","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"47798","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-31 17:16:30","reservation_modified_date_time":"2020-08-01 15:44:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122574","reservation_id":"95065","confirmation_number":"PB12285655529","room_confirmation_number":"PB12394877671","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"53.38","product_id":"1781","service_quantity":"1","customer_traveller_id":"28048","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-19 20:27:43","reservation_modified_date_time":"2020-08-01 18:03:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28048","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122859","reservation_id":"98497","confirmation_number":"PB12258483123","room_confirmation_number":"PB12392667542","room_stay_from":"2020-08-02","room_stay_to":"2020-08-05","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":"104528","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-02 17:12:53","reservation_modified_date_time":"2020-08-02 17:14:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104528","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123109","reservation_id":"98423","confirmation_number":"PB12212960425","room_confirmation_number":"PB12389996089","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"104477","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-03 13:56:14","reservation_modified_date_time":"2020-08-03 13:56:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104477","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3123136","reservation_id":"98448","confirmation_number":"PB12270348148","room_confirmation_number":"PB12316274501","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"104466","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-01 00:31:56","reservation_modified_date_time":"2020-08-03 14:50:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104466","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3123180","reservation_id":"98467","confirmation_number":"PB12235694960","room_confirmation_number":"PB12388486854","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"104562","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-01 14:01:11","reservation_modified_date_time":"2020-08-03 17:41:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104562","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.00","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":"3123195","reservation_id":"98546","confirmation_number":"PB12233059709","room_confirmation_number":"PB12342022185","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"46810","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-03 18:38:40","reservation_modified_date_time":"2020-08-03 18:38:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"46810","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123278","reservation_id":"98550","confirmation_number":"PB12258405469","room_confirmation_number":"PB12320252262","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"104566","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-03 20:34:51","reservation_modified_date_time":"2020-08-03 21:15:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104566","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3123394","reservation_id":"98563","confirmation_number":"PB12257809984","room_confirmation_number":"PB12394178184","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"104587","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-04 00:14:11","reservation_modified_date_time":"2020-08-04 03:17:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104587","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3095536","reservation_id":"88566","confirmation_number":"PB12294563342","room_confirmation_number":"PB12385391898","room_stay_from":"2020-07-31","room_stay_to":"2020-08-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"94763","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-22 21:25:50","reservation_modified_date_time":"2020-05-20 17:25:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94763","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122850","reservation_id":"98268","confirmation_number":"PB12214544546","room_confirmation_number":"PB12332616595","room_stay_from":"2020-08-02","room_stay_to":"2020-08-06","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":"104527","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-07-28 01:49:07","reservation_modified_date_time":"2020-08-02 16:57:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104527","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","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":"3123205","reservation_id":"98481","confirmation_number":"PB12223652524","room_confirmation_number":"PB12387538847","room_stay_from":"2020-08-03","room_stay_to":"2020-08-06","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":"104564","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-01 21:59:10","reservation_modified_date_time":"2020-08-03 19:03:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104564","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3123178","reservation_id":"98251","confirmation_number":"PB12290054895","room_confirmation_number":"PB12397434508","room_stay_from":"2020-08-02","room_stay_to":"2020-08-07","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"104293","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-07-27 20:26:10","reservation_modified_date_time":"2020-08-03 17:40:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104293","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","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":"3123334","reservation_id":"98545","confirmation_number":"PB12245597561","room_confirmation_number":"PB12378996351","room_stay_from":"2020-08-03","room_stay_to":"2020-08-07","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":"104581","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-03 17:44:10","reservation_modified_date_time":"2020-08-04 01:19:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104581","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3092380","reservation_id":"82917","confirmation_number":"PB12261782007","room_confirmation_number":"PB12365259765","room_stay_from":"2020-08-03","room_stay_to":"2020-08-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23537","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-19 16:40:45","reservation_modified_date_time":"2020-05-09 15:00:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23537","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123107","reservation_id":"98423","confirmation_number":"PB12252235814","room_confirmation_number":"PB12325710057","room_stay_from":"2020-07-31","room_stay_to":"2020-08-03","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":"37.79","product_id":"1781","service_quantity":"1","customer_traveller_id":"104477","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-07-31 19:44:12","reservation_modified_date_time":"2020-08-03 13:56:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104477","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3123114","reservation_id":"98394","confirmation_number":"PB12238556024","room_confirmation_number":"PB12315492117","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":"22.60","paid_amount":"0.00","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-03 14:08:12","reservation_modified_date_time":"2020-08-03 14:08:12","customer_id":"104418","parentCustTravId":"104418","customer_traveller_id":"104418","static_pos_type":"latecheckoutfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3123137","reservation_id":"98448","confirmation_number":"PB12240636709","room_confirmation_number":"PB12316274501","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"2.00","paid_amount":"2.00","product_id":"1213","service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-03 14:53:23","reservation_modified_date_time":"2020-08-03 14:53:23","customer_id":"104466","parentCustTravId":"104466","customer_traveller_id":"104466","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":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3123181","reservation_id":"98467","confirmation_number":"PB12280342894","room_confirmation_number":"PB12388486854","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"26.75","paid_amount":"26.75","product_id":"1175","service_quantity":"1","product_name":"Miscellaneous","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-03 17:35:30","reservation_modified_date_time":"2020-08-03 17:41:30","customer_id":"104562","parentCustTravId":"104562","customer_traveller_id":"104562","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3123204","reservation_id":"98481","confirmation_number":"PB12216433279","room_confirmation_number":"PB12387538847","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1212","service_quantity":"2","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-03 18:55:37","reservation_modified_date_time":"2020-08-03 19:03:42","customer_id":"104564","parentCustTravId":"104564","customer_traveller_id":"104564","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":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3123228","reservation_id":"98481","confirmation_number":"PB12219021479","room_confirmation_number":"PB12387538847","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","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-08-03 20:07:36","reservation_modified_date_time":"2020-08-03 20:07:36","customer_id":"104564","parentCustTravId":"104564","customer_traveller_id":"104564","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":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3123309","reservation_id":"98550","confirmation_number":"PB12232472845","room_confirmation_number":"PB12320252262","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-03 23:16:39","reservation_modified_date_time":"2020-08-03 23:16:39","customer_id":"104566","parentCustTravId":"104566","customer_traveller_id":"104566","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":"28.05","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3123116","reservation_id":"98535","confirmation_number":"PB12288552342","room_confirmation_number":"PB12329793024","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"2.00","paid_amount":"2.00","product_id":null,"service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-03 14:12:21","reservation_modified_date_time":"2020-08-03 14:12:21","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3122114","reservation_id":"98293","confirmation_number":"PB12237091630","room_confirmation_number":"PB12332032350","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":"60.00","paid_amount":"0.00","product_id":"2010","service_quantity":"6","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-31 20:10:38","reservation_modified_date_time":"2020-07-31 20:10:38","customer_id":"104440","parentCustTravId":"104440","customer_traveller_id":"104440","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-08-03 17:02:49","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-56.1,"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":"3122531","reservation_id":"98232","confirmation_number":"PB12288459815","room_confirmation_number":"PB12323469302","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":"60.00","paid_amount":"0.00","product_id":"2010","service_quantity":"6","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-01 16:32:45","reservation_modified_date_time":"2020-08-01 16:32:45","customer_id":"104279","parentCustTravId":"104279","customer_traveller_id":"104279","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-08-03 15:56:10","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-56.1,"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":"3122678","reservation_id":"98312","confirmation_number":"PB12254344880","room_confirmation_number":"PB12395836235","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-08-01 21:57:26","reservation_modified_date_time":"2020-08-01 21:57:26","customer_id":"104506","parentCustTravId":"104506","customer_traveller_id":"104506","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-08-03 14:10:01","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"}]},{"room_stay_id":"3122881","reservation_id":"98488","confirmation_number":"PB12216139789","room_confirmation_number":"PB12374563349","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-08-02 18:11:26","reservation_modified_date_time":"2020-08-02 18:11:26","customer_id":"104529","parentCustTravId":"104529","customer_traveller_id":"104529","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-08-03 13:46:40","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":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":3,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3122618","reservation_id":"93878","confirmation_number":"BV12411113294","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.69,90.19,90.19,90.19","nightly_discount":"0,0,0,0","subtotal":"376.26","grand_total":"425.18","paid_amount":"425.18","room_type_id":"308","product_id":"1225","siteminder_id":"EXP-1661090537","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":"104504","customer_id":"104504","source_of_creation":"Expedia","reservation_created_date":"2020-04-16 18:11:08","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.19","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3122487","reservation_id":"98231","confirmation_number":"BV12427157118","room_stay_from":"2020-08-01","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"172.66,172.66,172.66","nightly_discount":"0,0,0","subtotal":"517.98","grand_total":"675.83","paid_amount":"675.83","room_type_id":"304","product_id":"1220","siteminder_id":"ABB-HMEYAWAMJ2","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"517.98","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104458","customer_id":"104458","source_of_creation":"Airbnb","reservation_created_date":"2020-08-01 14:14:45","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"72.41","commision_charges":"16.02","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"172.66","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":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3122104","reservation_id":"98386","confirmation_number":"BV12441569338","room_stay_from":"2020-07-31","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.78,150.78,119.25,119.25","nightly_discount":"0.00,34.87,0.00,0.00","subtotal":"540.06","grand_total":"570.86","paid_amount":"570.86","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"35000","customer_id":"35000","source_of_creation":"PMS","reservation_created_date":"2020-07-30 20:13:08","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123067","reservation_id":"98080","confirmation_number":"BV12471090791","room_stay_from":"2020-07-28","room_stay_to":"2020-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"127.20,127.20,101.76,139.00,139.00,103.00,103.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"840.16","grand_total":"949.38","paid_amount":"949.38","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":"101368","customer_id":"101368","source_of_creation":"PMS","reservation_created_date":"2020-07-23 14:36:12","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":"","currentDayPrice":"103.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123297","reservation_id":"88357","confirmation_number":"BV12452301649","room_stay_from":"2020-11-28","room_stay_to":"2020-12-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.00,87.00,87.00,87.00,87.00,87.00,107.00,107.00,87.00,87.00,87.00,87.00,87.00,107.00,107.00,87.00,87.00,87.00,87.00,87.00,107.00,107.00,87.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","subtotal":"2141.00","grand_total":"2419.33","paid_amount":"120.91","room_type_id":"309","product_id":"1226","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24275","customer_id":"24275","source_of_creation":"PMS","reservation_created_date":"2019-12-15 20:47:21","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"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":"3122105","reservation_id":"98386","confirmation_number":"BV12222387527","room_confirmation_number":"BV12441569338","room_stay_from":"2020-07-31","room_stay_to":"2020-08-04","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":"35000","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-30 20:13:08","reservation_modified_date_time":"2020-07-31 18:56:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"35000","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122488","reservation_id":"98231","confirmation_number":"BV12218105475","room_confirmation_number":"BV12427157118","room_stay_from":"2020-08-01","room_stay_to":"2020-08-04","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":"104458","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-01 14:14:45","reservation_modified_date_time":"2020-08-01 14:14:45","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104458","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3123068","reservation_id":"98080","confirmation_number":"BV12223281498","room_confirmation_number":"BV12471090791","room_stay_from":"2020-07-28","room_stay_to":"2020-08-04","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":"101368","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-23 14:36:12","reservation_modified_date_time":"2020-08-03 02:17:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101368","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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":"3122617","reservation_id":"93878","confirmation_number":"BV12282185498","room_confirmation_number":"BV12411113294","room_stay_from":"2020-08-01","room_stay_to":"2020-08-05","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":"104504","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-04-16 18:11:08","reservation_modified_date_time":"2020-08-01 19:38:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104504","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3123091","reservation_id":"98490","confirmation_number":"BV12257088433","room_confirmation_number":"BV12482188105","room_stay_from":"2020-08-02","room_stay_to":"2020-08-03","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"104523","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-02 14:34:10","reservation_modified_date_time":"2020-08-03 12:48:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104523","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"Nightly price or discount changed","deltaChange":"-20.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123298","reservation_id":"88357","confirmation_number":"BV12246934757","room_confirmation_number":"BV12452301649","room_stay_from":"2020-11-28","room_stay_to":"2020-12-21","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24275","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-15 20:47:21","reservation_modified_date_time":"2020-08-03 22:09:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24275","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3121810","reservation_id":"98386","confirmation_number":"BV12217650738","room_confirmation_number":"BV12441569338","room_stay_from":"2020-07-31","room_stay_to":"2020-08-04","room_stay_status":"Active","nightly_price":"45.00,45.00,45.00,45.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-07-30 20:18:24","reservation_modified_date_time":"2020-07-30 20:18:24","customer_id":"35000","parentCustTravId":"35000","customer_traveller_id":"35000","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":"3122489","reservation_id":"98231","confirmation_number":"BV12232442387","room_confirmation_number":"BV12427157118","room_stay_from":"2020-08-01","room_stay_to":"2020-08-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.75","paid_amount":"84.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-01 14:25:20","reservation_modified_date_time":"2020-08-01 14:25:20","customer_id":"104458","parentCustTravId":"104458","customer_traveller_id":"104458","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3123069","reservation_id":"98080","confirmation_number":"BV12241168935","room_confirmation_number":"BV12471090791","room_stay_from":"2020-08-03","room_stay_to":"2020-08-04","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-03 02:16:15","reservation_modified_date_time":"2020-08-03 02:17:24","customer_id":"101368","parentCustTravId":"101368","customer_traveller_id":"101368","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3123025","reservation_id":"98313","confirmation_number":"BV12211925890","room_confirmation_number":"BV12432795301","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":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-08-02 22:59:57","reservation_modified_date_time":"2020-08-02 22:59:57","customer_id":"104350","parentCustTravId":"104350","customer_traveller_id":"104350","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-08-03 15:07:24","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-28.05,"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":[],"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":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3123169","reservation_id":"98208","confirmation_number":"BP12515528150","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,5.50","subtotal":"198.00","grand_total":"217.53","paid_amount":"218.24","room_type_id":"300","product_id":"1135","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104262","customer_id":"104262","source_of_creation":"PMS","reservation_created_date":"2020-07-26 17:07:16","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":"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":"3123313","reservation_id":"98556","confirmation_number":"BP12574585738","room_stay_from":"2020-08-03","room_stay_to":"2020-08-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"96.51,96.51,96.51","nightly_discount":"0.00,0.00,17.77","subtotal":"289.53","grand_total":"307.09","paid_amount":"307.09","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":"104573","customer_id":"104573","source_of_creation":"PMS","reservation_created_date":"2020-08-03 23:07:29","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":"96.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3123307","reservation_id":"98556","confirmation_number":"BP12257451011","room_confirmation_number":"BP12574585738","room_stay_from":"2020-08-03","room_stay_to":"2020-08-06","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"104573","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-08-03 23:07:29","reservation_modified_date_time":"2020-08-03 23:07:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104573","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3123170","reservation_id":"98208","confirmation_number":"BP12299198425","room_confirmation_number":"BP12515528150","room_stay_from":"2020-08-03","room_stay_to":"2020-08-05","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"104262","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-07-26 17:07:16","reservation_modified_date_time":"2020-08-03 17:00:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104262","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3123314","reservation_id":"98556","confirmation_number":"BP12244326731","room_confirmation_number":"BP12574585738","room_stay_from":"2020-08-03","room_stay_to":"2020-08-06","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":"104573","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-03 23:07:29","reservation_modified_date_time":"2020-08-03 23:29:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104573","canceled_nights_data":"","posAmt_airbnb_taxpaid":"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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}