{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-09-10","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":11,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1101,1113","block_room_bookings":[{"confirmation_number":"PB12273069724","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","bundle_room":"0"},{"confirmation_number":"PB12271617281","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","bundle_room":"0"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3136014","reservation_id":"100206","confirmation_number":"PB12345890032","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.28","nightly_discount":"0","subtotal":"117.28","grand_total":"132.53","paid_amount":"132.53","room_type_id":"292","product_id":"1120","siteminder_id":"BDC-2276909205","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":"106264","customer_id":"106264","source_of_creation":"Booking.com","reservation_created_date":"2020-09-10 14:43:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS 218","ota_service_fee_amount":"0","commision_charges":"20.59","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.28","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":"3135828","reservation_id":"100192","confirmation_number":"PB12347824382","room_stay_from":"2020-09-10","room_stay_to":"2020-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.28,150.57","nightly_discount":"0,0","subtotal":"267.85","grand_total":"302.67","paid_amount":"302.67","room_type_id":"285","product_id":"1084","siteminder_id":"BDC-2973177642","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":"106234","customer_id":"106234","source_of_creation":"Booking.com","reservation_created_date":"2020-09-10 00:54:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"46.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.28","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":"3131844","reservation_id":"97009","confirmation_number":"PB12382402345","room_stay_from":"2020-09-06","room_stay_to":"2020-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"333.97,198.90,198.90,198.90,198.90,210.60,210.60","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1550.77","grand_total":"1752.37","paid_amount":"1752.37","room_type_id":"287","product_id":"1090","siteminder_id":"BDC-3094113428","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":"103134","customer_id":"103134","source_of_creation":"Booking.com","reservation_created_date":"2020-06-23 22:39:11","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"253.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"198.90","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135507","reservation_id":"99830","confirmation_number":"PB12354334478","room_stay_from":"2020-09-09","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.28,117.28,150.57,150.57,117.28,117.28,117.28","nightly_discount":"0,0,0,0,0,0,0","subtotal":"887.54","grand_total":"1002.92","paid_amount":"1002.92","room_type_id":"289","product_id":"1097","siteminder_id":"BDC-2555371487","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":"106190","customer_id":"106190","source_of_creation":"Booking.com","reservation_created_date":"2020-09-01 21:32:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"154.13","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.28","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":"3135532","reservation_id":"100125","confirmation_number":"PB12381399514","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.51,91.51","nightly_discount":"0,0","subtotal":"183.02","grand_total":"206.81","paid_amount":"206.81","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1697039056","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":"106195","customer_id":"106195","source_of_creation":"Expedia","reservation_created_date":"2020-09-08 14:26:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.51","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":"3135845","reservation_id":"99764","confirmation_number":"PB12361094350","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.64","nightly_discount":"0","subtotal":"94.64","grand_total":"106.94","paid_amount":"106.94","room_type_id":"289","product_id":"1112","siteminder_id":"EXP-1694308406","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":"106238","customer_id":"106238","source_of_creation":"Expedia","reservation_created_date":"2020-08-30 23:11:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"94.64","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":"3135563","reservation_id":"100132","confirmation_number":"BV12432386497","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"44.12,44.12","nightly_discount":"0,0","subtotal":"88.24","grand_total":"99.71","paid_amount":"99.71","room_type_id":"285","product_id":"1083","siteminder_id":"HTN-137730244-M4TZGZ","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":"106203","customer_id":"106203","source_of_creation":"HotelTonight","reservation_created_date":"2020-09-08 17:08:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"44.12","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":"3135972","reservation_id":"100235","confirmation_number":"BV12447917740","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"49.02","nightly_discount":"0","subtotal":"49.02","grand_total":"55.39","paid_amount":"55.39","room_type_id":"303","product_id":"1139","siteminder_id":"HTN-137966772-C794XH","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":"106255","customer_id":"106255","source_of_creation":"HotelTonight","reservation_created_date":"2020-09-10 22:18:11","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"49.02","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":"3135836","reservation_id":"100177","confirmation_number":"BV12448692902","room_stay_from":"2020-09-10","room_stay_to":"2020-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.39,88.41","nightly_discount":"0,0","subtotal":"157.80","grand_total":"178.32","paid_amount":"178.32","room_type_id":"305","product_id":"1222","siteminder_id":"HTN-137858006-3N6JNL","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":"106236","customer_id":"106236","source_of_creation":"HotelTonight","reservation_created_date":"2020-09-09 19:03:09","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.39","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3135799","reservation_id":"99887","confirmation_number":"PB12334558156","room_stay_from":"2020-09-10","room_stay_to":"2020-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"119.93,146.89,146.89","nightly_discount":"0,0,0","subtotal":"413.71","grand_total":"467.49","paid_amount":"467.49","room_type_id":"289","product_id":"1108","siteminder_id":"GAM-R2113360465","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"105890","customer_id":"105890","source_of_creation":"Getaroom.com","reservation_created_date":"2020-09-02 19:03:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.93","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3134012","reservation_id":"99979","confirmation_number":"BP12521042857","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"85.85,85.85","nightly_discount":"0.00,0.00","subtotal":"171.70","grand_total":"194.02","paid_amount":"194.02","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"FE","reservation_created_date":"2020-09-04 19:16:18","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135442","reservation_id":"100159","confirmation_number":"BV12499552933","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"88.40,88.40","nightly_discount":"0.00,0.00","subtotal":"176.80","grand_total":"199.79","paid_amount":"199.79","room_type_id":"307","product_id":"1224","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106178","customer_id":"106178","source_of_creation":"FE","reservation_created_date":"2020-09-09 04:42:29","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"88.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":"3132914","reservation_id":"99383","confirmation_number":"PB12319952234","room_stay_from":"2020-09-06","room_stay_to":"2020-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"299.00,137.70,137.70,137.70,137.70,182.00","nightly_discount":"0.00,0.00,0.00,0,0,0","subtotal":"1031.80","grand_total":"1165.94","paid_amount":"1165.94","room_type_id":"288","product_id":"1092","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":"105373","customer_id":"105373","source_of_creation":"FE","reservation_created_date":"2020-08-22 21:21:06","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.70","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3132154","reservation_id":"99729","confirmation_number":"PB12332795348","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.00,169.00","nightly_discount":"0.00,0.00","subtotal":"338.00","grand_total":"381.94","paid_amount":"381.94","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":"105729","customer_id":"105729","source_of_creation":"PMS","reservation_created_date":"2020-08-29 21:04:07","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"169.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3134765","reservation_id":"99782","confirmation_number":"PB12345851748","room_stay_from":"2020-09-08","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.50,110.50,110.50","nightly_discount":"0.00,0.00,0.00","subtotal":"331.50","grand_total":"374.60","paid_amount":"374.60","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":"89098","customer_id":"89098","source_of_creation":"PMS","reservation_created_date":"2020-08-31 15:34: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":"110.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135753","reservation_id":"100187","confirmation_number":"PB12326364213","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"85.00","nightly_discount":"4.85","subtotal":"85.00","grand_total":"90.57","paid_amount":"90.57","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106197","customer_id":"106197","source_of_creation":"PMS","reservation_created_date":"2020-09-09 23:13:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.00","currentDayDiscount":"4.85","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135785","reservation_id":"100209","confirmation_number":"BV12420122532","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"65.00","nightly_discount":"0.00","subtotal":"65.00","grand_total":"73.45","paid_amount":"73.45","room_type_id":"303","product_id":"1140","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":"106212","customer_id":"106212","source_of_creation":"PMS","reservation_created_date":"2020-09-10 15:10:10","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"65.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135790","reservation_id":"100210","confirmation_number":"PB12348226627","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.00","nightly_discount":"4.27","subtotal":"60.00","grand_total":"62.97","paid_amount":"62.97","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":"106230","customer_id":"106230","source_of_creation":"PMS","reservation_created_date":"2020-09-10 15:18:10","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":"60.00","currentDayDiscount":"4.27","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3128013","reservation_id":"99227","confirmation_number":"BV12421401811","room_stay_from":"2020-09-05","room_stay_to":"2020-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"219.00,159.00,132.00,132.00,132.00,132.00,152.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1058.00","grand_total":"1195.54","paid_amount":"1195.54","room_type_id":"309","product_id":"1226","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"105206","customer_id":"105206","source_of_creation":"PMS","reservation_created_date":"2020-08-19 00:11:16","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"132.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3133199","reservation_id":"99844","confirmation_number":"BP12540019580","room_stay_from":"2020-09-09","room_stay_to":"2020-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.10,124.10,166.00","nightly_discount":"0.00,0.00,0.00","subtotal":"414.20","grand_total":"468.04","paid_amount":"468.04","room_type_id":"296","product_id":"1131","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"73886","customer_id":"73886","source_of_creation":"PMS","reservation_created_date":"2020-09-02 00:31:27","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.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":"3135652","reservation_id":"100186","confirmation_number":"PB12388295959","room_stay_from":"2020-09-09","room_stay_to":"2020-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,124.00","nightly_discount":"0.00,0.00,0.00","subtotal":"362.00","grand_total":"409.06","paid_amount":"409.06","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":"106208","customer_id":"106208","source_of_creation":"PMS","reservation_created_date":"2020-09-09 22:53:57","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135707","reservation_id":"100037","confirmation_number":"BV12454683698","room_stay_from":"2020-09-10","room_stay_to":"2020-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.65,209.00","nightly_discount":"0.00,12.16","subtotal":"369.65","grand_total":"403.96","paid_amount":"403.97","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106057","customer_id":"106057","source_of_creation":"PMS","reservation_created_date":"2020-09-05 21:15:45","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"From date changed","deltaChange":"-148.75","currentDayPrice":"160.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3132027","reservation_id":"99709","confirmation_number":"PB12348245530","room_stay_from":"2020-09-10","room_stay_to":"2020-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"170.85,221.00,221.00","nightly_discount":"0.00,0.00,0.00","subtotal":"612.85","grand_total":"692.52","paid_amount":"692.52","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":"73106","customer_id":"73106","source_of_creation":"PMS","reservation_created_date":"2020-08-29 17:54:42","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":"170.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135520","reservation_id":"100175","confirmation_number":"PB12324490803","room_stay_from":"2020-09-09","room_stay_to":"2020-09-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.65,126.65,169.00,169.00,126.65","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"717.95","grand_total":"811.29","paid_amount":"811.29","room_type_id":"291","product_id":"1115","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":"106193","customer_id":"106193","source_of_creation":"PMS","reservation_created_date":"2020-09-09 18:43:07","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":"126.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135992","reservation_id":"99841","confirmation_number":"PB12384876225","room_stay_from":"2020-09-10","room_stay_to":"2020-09-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.65,169.00,169.00,126.65","nightly_discount":"0.00,0.00,0.00,25.63","subtotal":"591.30","grand_total":"639.21","paid_amount":"639.21","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":"58690","customer_id":"58690","source_of_creation":"PMS","reservation_created_date":"2020-09-01 23:58:54","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":"126.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135687","reservation_id":"94488","confirmation_number":"PB12317311697","room_stay_from":"2020-09-11","room_stay_to":"2020-09-19","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,140.00,102.00,102.00,102.00,102.00,102.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"930.00","grand_total":"1050.90","paid_amount":"158.20","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":"58691","customer_id":"58691","source_of_creation":"PMS","reservation_created_date":"2020-05-06 13:26:46","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":"","changedComment":"From 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":"3128014","reservation_id":"99227","confirmation_number":"BV12291040250","room_confirmation_number":"BV12421401811","room_stay_from":"2020-09-05","room_stay_to":"2020-09-12","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"105206","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-08-19 00:11:16","reservation_modified_date_time":"2020-08-19 00:11:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105206","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":"3132915","reservation_id":"99383","confirmation_number":"PB12232937296","room_confirmation_number":"PB12319952234","room_stay_from":"2020-09-06","room_stay_to":"2020-09-12","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0,0,0","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"105373","product_attribute_values":"extra_person# ","reservation_created_date":"2020-08-31 23:30:35","reservation_modified_date_time":"2020-08-31 23:30:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105373","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135800","reservation_id":"99887","confirmation_number":"PB12277717169","room_confirmation_number":"PB12334558156","room_stay_from":"2020-09-10","room_stay_to":"2020-09-13","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":"105890","product_attribute_values":"extra_person# ","reservation_created_date":"2020-09-10 15:40:15","reservation_modified_date_time":"2020-09-10 15:40:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105890","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.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":"3132155","reservation_id":"99729","confirmation_number":"PB12220715960","room_confirmation_number":"PB12332795348","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","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":"105729","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-29 21:04:07","reservation_modified_date_time":"2020-08-29 21:04:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105729","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":"3134013","reservation_id":"99979","confirmation_number":"BP12274014849","room_confirmation_number":"BP12521042857","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","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-09-04 19:16:18","reservation_modified_date_time":"2020-09-04 19:16:18","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":"3134766","reservation_id":"99782","confirmation_number":"PB12282636154","room_confirmation_number":"PB12345851748","room_stay_from":"2020-09-08","room_stay_to":"2020-09-11","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":"89098","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-31 15:34:11","reservation_modified_date_time":"2020-09-06 13:26:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89098","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":"3135443","reservation_id":"100159","confirmation_number":"BV12219047261","room_confirmation_number":"BV12499552933","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","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":"105105","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-09 04:42:29","reservation_modified_date_time":"2020-09-09 04:42:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106178","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":"3135531","reservation_id":"100125","confirmation_number":"PB12297094255","room_confirmation_number":"PB12381399514","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","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":"106195","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-08 14:26:09","reservation_modified_date_time":"2020-09-09 18:58:45","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106195","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":"3135561","reservation_id":"100132","confirmation_number":"BV12258998624","room_confirmation_number":"BV12432386497","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","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":"106203","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-08 17:08:07","reservation_modified_date_time":"2020-09-09 20:13:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106203","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":"3135754","reservation_id":"100187","confirmation_number":"PB12266979621","room_confirmation_number":"PB12326364213","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","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":"106197","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-09 23:13:05","reservation_modified_date_time":"2020-09-10 14:25:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106197","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":"3135786","reservation_id":"100209","confirmation_number":"BV12257024820","room_confirmation_number":"BV12420122532","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","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":"106212","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-10 15:10:10","reservation_modified_date_time":"2020-09-10 15:10:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106212","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":"3135791","reservation_id":"100210","confirmation_number":"PB12223007910","room_confirmation_number":"PB12348226627","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","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":"106230","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-10 15:18:10","reservation_modified_date_time":"2020-09-10 15:20:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106230","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":"3135844","reservation_id":"99764","confirmation_number":"PB12295220298","room_confirmation_number":"PB12361094350","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"106238","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-30 23:11:08","reservation_modified_date_time":"2020-09-10 18:03:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106238","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":"3135973","reservation_id":"100235","confirmation_number":"BV12241636798","room_confirmation_number":"BV12447917740","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"106255","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-10 22:18:11","reservation_modified_date_time":"2020-09-10 22:18:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106255","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":"3136013","reservation_id":"100206","confirmation_number":"PB12210472330","room_confirmation_number":"PB12345890032","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"106264","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-10 14:43:08","reservation_modified_date_time":"2020-09-11 00:11:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106264","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":"3128015","reservation_id":"99227","confirmation_number":"BV12247936559","room_confirmation_number":"BV12421401811","room_stay_from":"2020-09-05","room_stay_to":"2020-09-12","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":"105206","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-19 00:11:16","reservation_modified_date_time":"2020-08-19 00:11:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105206","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":"3132916","reservation_id":"99383","confirmation_number":"PB12279592635","room_confirmation_number":"PB12319952234","room_stay_from":"2020-09-06","room_stay_to":"2020-09-12","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":"105373","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-22 21:21:06","reservation_modified_date_time":"2020-08-31 23:30:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105373","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":"3133200","reservation_id":"99844","confirmation_number":"BP12221707709","room_confirmation_number":"BP12540019580","room_stay_from":"2020-09-09","room_stay_to":"2020-09-12","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":"73886","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-02 00:31:27","reservation_modified_date_time":"2020-09-02 00:31:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73886","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":"3135653","reservation_id":"100186","confirmation_number":"PB12238899336","room_confirmation_number":"PB12388295959","room_stay_from":"2020-09-09","room_stay_to":"2020-09-12","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":"106208","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-09 22:53:57","reservation_modified_date_time":"2020-09-10 12:31:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106208","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":"3135708","reservation_id":"100037","confirmation_number":"BV12258479752","room_confirmation_number":"BV12454683698","room_stay_from":"2020-09-10","room_stay_to":"2020-09-12","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":"106057","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-05 21:15:45","reservation_modified_date_time":"2020-09-10 14:05:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106057","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"From date changed","deltaChange":"-12.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135827","reservation_id":"100192","confirmation_number":"PB12249948638","room_confirmation_number":"PB12347824382","room_stay_from":"2020-09-10","room_stay_to":"2020-09-12","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":"106234","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-10 00:54:11","reservation_modified_date_time":"2020-09-10 16:54:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106234","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":"3135835","reservation_id":"100177","confirmation_number":"BV12273314904","room_confirmation_number":"BV12448692902","room_stay_from":"2020-09-10","room_stay_to":"2020-09-12","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":"106236","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-09 19:03:09","reservation_modified_date_time":"2020-09-10 17:28:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106236","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":"3131845","reservation_id":"97009","confirmation_number":"PB12285473485","room_confirmation_number":"PB12382402345","room_stay_from":"2020-09-06","room_stay_to":"2020-09-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"103134","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-23 22:39:11","reservation_modified_date_time":"2020-08-29 13:07:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103134","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":"3132028","reservation_id":"99709","confirmation_number":"PB12262681298","room_confirmation_number":"PB12348245530","room_stay_from":"2020-09-10","room_stay_to":"2020-09-13","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":"73106","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-29 17:54:42","reservation_modified_date_time":"2020-08-29 17:54:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73106","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":"3135801","reservation_id":"99887","confirmation_number":"PB12210685790","room_confirmation_number":"PB12334558156","room_stay_from":"2020-09-10","room_stay_to":"2020-09-13","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":"105890","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-02 19:03:11","reservation_modified_date_time":"2020-09-10 15:40:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105890","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.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":"3135521","reservation_id":"100175","confirmation_number":"PB12296504086","room_confirmation_number":"PB12324490803","room_stay_from":"2020-09-09","room_stay_to":"2020-09-14","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"106193","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-09 18:43:07","reservation_modified_date_time":"2020-09-09 18:43:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106193","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":"3135993","reservation_id":"99841","confirmation_number":"PB12239380658","room_confirmation_number":"PB12384876225","room_stay_from":"2020-09-10","room_stay_to":"2020-09-14","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":"58690","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-01 23:58:54","reservation_modified_date_time":"2020-09-10 22:38:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58690","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":"3135508","reservation_id":"99830","confirmation_number":"PB12239199340","room_confirmation_number":"PB12354334478","room_stay_from":"2020-09-09","room_stay_to":"2020-09-16","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"106190","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-01 21:32:08","reservation_modified_date_time":"2020-09-09 17:48:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106190","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":"3135688","reservation_id":"94488","confirmation_number":"PB12221277457","room_confirmation_number":"PB12317311697","room_stay_from":"2020-09-11","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"58691","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-06 13:26:46","reservation_modified_date_time":"2020-09-10 13:21:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58691","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"From 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":"3135803","reservation_id":"100213","confirmation_number":"PB12271450957","room_confirmation_number":"PB12335439878","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"3.00","paid_amount":"3.00","product_id":"1213","service_quantity":"3","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-09-10 15:45:00","reservation_modified_date_time":"2020-09-10 15:45:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3135804","reservation_id":"100213","confirmation_number":"PB12232760532","room_confirmation_number":"PB12335439878","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2020-09-10 15:45:00","reservation_modified_date_time":"2020-09-10 15:45:00","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":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3135849","reservation_id":"100220","confirmation_number":"PB12287899082","room_confirmation_number":"PB12364764896","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"3.00","paid_amount":"3.00","product_id":"1213","service_quantity":"3","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-09-10 18:29:13","reservation_modified_date_time":"2020-09-10 18:29:13","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3135233","reservation_id":"98982","confirmation_number":"PB12298320301","room_confirmation_number":"PB12395226234","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-09-07 22:13:41","reservation_modified_date_time":"2020-09-07 22:13:41","customer_id":"104964","parentCustTravId":"104964","customer_traveller_id":"104964","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-09-10 17:54:19","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-09-06","deltaChange":-37.4,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3135331","reservation_id":"100130","confirmation_number":"BV12253724772","room_confirmation_number":"BV12467398169","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-09-08 16:42:51","reservation_modified_date_time":"2020-09-08 16:42:51","customer_id":"106150","parentCustTravId":"106150","customer_traveller_id":"106150","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-09-10 15:41:36","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-09-08","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":"3135547","reservation_id":"100107","confirmation_number":"PB12267214077","room_confirmation_number":"PB12314693314","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-09-09 19:53:37","reservation_modified_date_time":"2020-09-09 19:53:37","customer_id":"106197","parentCustTravId":"106197","customer_traveller_id":"106197","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-09-10 12:28:46","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-09-09","deltaChange":-37.4,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"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":6,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1101,1113","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12273069724","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","bundle_room":"0"},{"confirmation_number":"PB12271617281","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3136014","reservation_id":"100206","confirmation_number":"PB12345890032","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.28","nightly_discount":"0","subtotal":"117.28","grand_total":"132.53","paid_amount":"132.53","room_type_id":"292","product_id":"1120","siteminder_id":"BDC-2276909205","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":"106264","customer_id":"106264","source_of_creation":"Booking.com","reservation_created_date":"2020-09-10 14:43:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS 218","ota_service_fee_amount":"0","commision_charges":"20.59","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.28","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":"3135828","reservation_id":"100192","confirmation_number":"PB12347824382","room_stay_from":"2020-09-10","room_stay_to":"2020-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.28,150.57","nightly_discount":"0,0","subtotal":"267.85","grand_total":"302.67","paid_amount":"302.67","room_type_id":"285","product_id":"1084","siteminder_id":"BDC-2973177642","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":"106234","customer_id":"106234","source_of_creation":"Booking.com","reservation_created_date":"2020-09-10 00:54:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"46.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.28","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":"3131844","reservation_id":"97009","confirmation_number":"PB12382402345","room_stay_from":"2020-09-06","room_stay_to":"2020-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"333.97,198.90,198.90,198.90,198.90,210.60,210.60","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1550.77","grand_total":"1752.37","paid_amount":"1752.37","room_type_id":"287","product_id":"1090","siteminder_id":"BDC-3094113428","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":"103134","customer_id":"103134","source_of_creation":"Booking.com","reservation_created_date":"2020-06-23 22:39:11","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"253.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"198.90","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135507","reservation_id":"99830","confirmation_number":"PB12354334478","room_stay_from":"2020-09-09","room_stay_to":"2020-09-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.28,117.28,150.57,150.57,117.28,117.28,117.28","nightly_discount":"0,0,0,0,0,0,0","subtotal":"887.54","grand_total":"1002.92","paid_amount":"1002.92","room_type_id":"289","product_id":"1097","siteminder_id":"BDC-2555371487","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":"106190","customer_id":"106190","source_of_creation":"Booking.com","reservation_created_date":"2020-09-01 21:32:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"154.13","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.28","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":"3135532","reservation_id":"100125","confirmation_number":"PB12381399514","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.51,91.51","nightly_discount":"0,0","subtotal":"183.02","grand_total":"206.81","paid_amount":"206.81","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1697039056","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":"106195","customer_id":"106195","source_of_creation":"Expedia","reservation_created_date":"2020-09-08 14:26:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.51","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":"3135845","reservation_id":"99764","confirmation_number":"PB12361094350","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.64","nightly_discount":"0","subtotal":"94.64","grand_total":"106.94","paid_amount":"106.94","room_type_id":"289","product_id":"1112","siteminder_id":"EXP-1694308406","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":"106238","customer_id":"106238","source_of_creation":"Expedia","reservation_created_date":"2020-08-30 23:11:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"94.64","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3135799","reservation_id":"99887","confirmation_number":"PB12334558156","room_stay_from":"2020-09-10","room_stay_to":"2020-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"119.93,146.89,146.89","nightly_discount":"0,0,0","subtotal":"413.71","grand_total":"467.49","paid_amount":"467.49","room_type_id":"289","product_id":"1108","siteminder_id":"GAM-R2113360465","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"105890","customer_id":"105890","source_of_creation":"Getaroom.com","reservation_created_date":"2020-09-02 19:03:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.93","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3132914","reservation_id":"99383","confirmation_number":"PB12319952234","room_stay_from":"2020-09-06","room_stay_to":"2020-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"299.00,137.70,137.70,137.70,137.70,182.00","nightly_discount":"0.00,0.00,0.00,0,0,0","subtotal":"1031.80","grand_total":"1165.94","paid_amount":"1165.94","room_type_id":"288","product_id":"1092","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":"105373","customer_id":"105373","source_of_creation":"FE","reservation_created_date":"2020-08-22 21:21:06","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.70","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3132154","reservation_id":"99729","confirmation_number":"PB12332795348","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.00,169.00","nightly_discount":"0.00,0.00","subtotal":"338.00","grand_total":"381.94","paid_amount":"381.94","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":"105729","customer_id":"105729","source_of_creation":"PMS","reservation_created_date":"2020-08-29 21:04:07","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"169.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3134765","reservation_id":"99782","confirmation_number":"PB12345851748","room_stay_from":"2020-09-08","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.50,110.50,110.50","nightly_discount":"0.00,0.00,0.00","subtotal":"331.50","grand_total":"374.60","paid_amount":"374.60","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":"89098","customer_id":"89098","source_of_creation":"PMS","reservation_created_date":"2020-08-31 15:34: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":"110.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135753","reservation_id":"100187","confirmation_number":"PB12326364213","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"85.00","nightly_discount":"4.85","subtotal":"85.00","grand_total":"90.57","paid_amount":"90.57","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106197","customer_id":"106197","source_of_creation":"PMS","reservation_created_date":"2020-09-09 23:13:05","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.00","currentDayDiscount":"4.85","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135790","reservation_id":"100210","confirmation_number":"PB12348226627","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.00","nightly_discount":"4.27","subtotal":"60.00","grand_total":"62.97","paid_amount":"62.97","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":"106230","customer_id":"106230","source_of_creation":"PMS","reservation_created_date":"2020-09-10 15:18:10","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":"60.00","currentDayDiscount":"4.27","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135652","reservation_id":"100186","confirmation_number":"PB12388295959","room_stay_from":"2020-09-09","room_stay_to":"2020-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,124.00","nightly_discount":"0.00,0.00,0.00","subtotal":"362.00","grand_total":"409.06","paid_amount":"409.06","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":"106208","customer_id":"106208","source_of_creation":"PMS","reservation_created_date":"2020-09-09 22:53:57","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3132027","reservation_id":"99709","confirmation_number":"PB12348245530","room_stay_from":"2020-09-10","room_stay_to":"2020-09-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"170.85,221.00,221.00","nightly_discount":"0.00,0.00,0.00","subtotal":"612.85","grand_total":"692.52","paid_amount":"692.52","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":"73106","customer_id":"73106","source_of_creation":"PMS","reservation_created_date":"2020-08-29 17:54:42","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":"170.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135520","reservation_id":"100175","confirmation_number":"PB12324490803","room_stay_from":"2020-09-09","room_stay_to":"2020-09-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.65,126.65,169.00,169.00,126.65","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"717.95","grand_total":"811.29","paid_amount":"811.29","room_type_id":"291","product_id":"1115","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":"106193","customer_id":"106193","source_of_creation":"PMS","reservation_created_date":"2020-09-09 18:43:07","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":"126.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135992","reservation_id":"99841","confirmation_number":"PB12384876225","room_stay_from":"2020-09-10","room_stay_to":"2020-09-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.65,169.00,169.00,126.65","nightly_discount":"0.00,0.00,0.00,25.63","subtotal":"591.30","grand_total":"639.21","paid_amount":"639.21","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":"58690","customer_id":"58690","source_of_creation":"PMS","reservation_created_date":"2020-09-01 23:58:54","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":"126.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135687","reservation_id":"94488","confirmation_number":"PB12317311697","room_stay_from":"2020-09-11","room_stay_to":"2020-09-19","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,140.00,102.00,102.00,102.00,102.00,102.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"930.00","grand_total":"1050.90","paid_amount":"158.20","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":"58691","customer_id":"58691","source_of_creation":"PMS","reservation_created_date":"2020-05-06 13:26:46","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":"","changedComment":"From 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":"3132915","reservation_id":"99383","confirmation_number":"PB12232937296","room_confirmation_number":"PB12319952234","room_stay_from":"2020-09-06","room_stay_to":"2020-09-12","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0,0,0","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"105373","product_attribute_values":"extra_person# ","reservation_created_date":"2020-08-31 23:30:35","reservation_modified_date_time":"2020-08-31 23:30:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105373","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135800","reservation_id":"99887","confirmation_number":"PB12277717169","room_confirmation_number":"PB12334558156","room_stay_from":"2020-09-10","room_stay_to":"2020-09-13","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":"105890","product_attribute_values":"extra_person# ","reservation_created_date":"2020-09-10 15:40:15","reservation_modified_date_time":"2020-09-10 15:40:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105890","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.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":"3132155","reservation_id":"99729","confirmation_number":"PB12220715960","room_confirmation_number":"PB12332795348","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","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":"105729","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-29 21:04:07","reservation_modified_date_time":"2020-08-29 21:04:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105729","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":"3134766","reservation_id":"99782","confirmation_number":"PB12282636154","room_confirmation_number":"PB12345851748","room_stay_from":"2020-09-08","room_stay_to":"2020-09-11","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":"89098","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-31 15:34:11","reservation_modified_date_time":"2020-09-06 13:26:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89098","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":"3135531","reservation_id":"100125","confirmation_number":"PB12297094255","room_confirmation_number":"PB12381399514","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","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":"106195","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-08 14:26:09","reservation_modified_date_time":"2020-09-09 18:58:45","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106195","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":"3135754","reservation_id":"100187","confirmation_number":"PB12266979621","room_confirmation_number":"PB12326364213","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","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":"106197","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-09 23:13:05","reservation_modified_date_time":"2020-09-10 14:25:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106197","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":"3135791","reservation_id":"100210","confirmation_number":"PB12223007910","room_confirmation_number":"PB12348226627","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","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":"106230","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-10 15:18:10","reservation_modified_date_time":"2020-09-10 15:20:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106230","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":"3135844","reservation_id":"99764","confirmation_number":"PB12295220298","room_confirmation_number":"PB12361094350","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"106238","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-08-30 23:11:08","reservation_modified_date_time":"2020-09-10 18:03:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106238","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":"3136013","reservation_id":"100206","confirmation_number":"PB12210472330","room_confirmation_number":"PB12345890032","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"106264","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-10 14:43:08","reservation_modified_date_time":"2020-09-11 00:11:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106264","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":"3132916","reservation_id":"99383","confirmation_number":"PB12279592635","room_confirmation_number":"PB12319952234","room_stay_from":"2020-09-06","room_stay_to":"2020-09-12","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":"105373","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-22 21:21:06","reservation_modified_date_time":"2020-08-31 23:30:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105373","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":"3135653","reservation_id":"100186","confirmation_number":"PB12238899336","room_confirmation_number":"PB12388295959","room_stay_from":"2020-09-09","room_stay_to":"2020-09-12","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":"106208","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-09 22:53:57","reservation_modified_date_time":"2020-09-10 12:31:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106208","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":"3135827","reservation_id":"100192","confirmation_number":"PB12249948638","room_confirmation_number":"PB12347824382","room_stay_from":"2020-09-10","room_stay_to":"2020-09-12","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":"106234","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-10 00:54:11","reservation_modified_date_time":"2020-09-10 16:54:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106234","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":"3131845","reservation_id":"97009","confirmation_number":"PB12285473485","room_confirmation_number":"PB12382402345","room_stay_from":"2020-09-06","room_stay_to":"2020-09-13","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"103134","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-06-23 22:39:11","reservation_modified_date_time":"2020-08-29 13:07:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103134","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":"3132028","reservation_id":"99709","confirmation_number":"PB12262681298","room_confirmation_number":"PB12348245530","room_stay_from":"2020-09-10","room_stay_to":"2020-09-13","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":"73106","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-29 17:54:42","reservation_modified_date_time":"2020-08-29 17:54:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73106","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":"3135801","reservation_id":"99887","confirmation_number":"PB12210685790","room_confirmation_number":"PB12334558156","room_stay_from":"2020-09-10","room_stay_to":"2020-09-13","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":"105890","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-02 19:03:11","reservation_modified_date_time":"2020-09-10 15:40:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105890","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.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":"3135521","reservation_id":"100175","confirmation_number":"PB12296504086","room_confirmation_number":"PB12324490803","room_stay_from":"2020-09-09","room_stay_to":"2020-09-14","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"106193","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-09 18:43:07","reservation_modified_date_time":"2020-09-09 18:43:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106193","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":"3135993","reservation_id":"99841","confirmation_number":"PB12239380658","room_confirmation_number":"PB12384876225","room_stay_from":"2020-09-10","room_stay_to":"2020-09-14","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":"58690","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-01 23:58:54","reservation_modified_date_time":"2020-09-10 22:38:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58690","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":"3135508","reservation_id":"99830","confirmation_number":"PB12239199340","room_confirmation_number":"PB12354334478","room_stay_from":"2020-09-09","room_stay_to":"2020-09-16","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"106190","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-01 21:32:08","reservation_modified_date_time":"2020-09-09 17:48:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106190","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":"3135688","reservation_id":"94488","confirmation_number":"PB12221277457","room_confirmation_number":"PB12317311697","room_stay_from":"2020-09-11","room_stay_to":"2020-09-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"58691","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-06 13:26:46","reservation_modified_date_time":"2020-09-10 13:21:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58691","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"From 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":"3135803","reservation_id":"100213","confirmation_number":"PB12271450957","room_confirmation_number":"PB12335439878","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"3.00","paid_amount":"3.00","product_id":"1213","service_quantity":"3","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-09-10 15:45:00","reservation_modified_date_time":"2020-09-10 15:45:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3135804","reservation_id":"100213","confirmation_number":"PB12232760532","room_confirmation_number":"PB12335439878","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2020-09-10 15:45:00","reservation_modified_date_time":"2020-09-10 15:45:00","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":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3135849","reservation_id":"100220","confirmation_number":"PB12287899082","room_confirmation_number":"PB12364764896","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"3.00","paid_amount":"3.00","product_id":"1213","service_quantity":"3","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-09-10 18:29:13","reservation_modified_date_time":"2020-09-10 18:29:13","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3135233","reservation_id":"98982","confirmation_number":"PB12298320301","room_confirmation_number":"PB12395226234","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-09-07 22:13:41","reservation_modified_date_time":"2020-09-07 22:13:41","customer_id":"104964","parentCustTravId":"104964","customer_traveller_id":"104964","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-09-10 17:54:19","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-09-06","deltaChange":-37.4,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3135547","reservation_id":"100107","confirmation_number":"PB12267214077","room_confirmation_number":"PB12314693314","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2020-09-09 19:53:37","reservation_modified_date_time":"2020-09-09 19:53:37","customer_id":"106197","parentCustTravId":"106197","customer_traveller_id":"106197","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-09-10 12:28:46","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-09-09","deltaChange":-37.4,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"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":[],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3135563","reservation_id":"100132","confirmation_number":"BV12432386497","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"44.12,44.12","nightly_discount":"0,0","subtotal":"88.24","grand_total":"99.71","paid_amount":"99.71","room_type_id":"285","product_id":"1083","siteminder_id":"HTN-137730244-M4TZGZ","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":"106203","customer_id":"106203","source_of_creation":"HotelTonight","reservation_created_date":"2020-09-08 17:08:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"44.12","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":"3135972","reservation_id":"100235","confirmation_number":"BV12447917740","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"49.02","nightly_discount":"0","subtotal":"49.02","grand_total":"55.39","paid_amount":"55.39","room_type_id":"303","product_id":"1139","siteminder_id":"HTN-137966772-C794XH","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":"106255","customer_id":"106255","source_of_creation":"HotelTonight","reservation_created_date":"2020-09-10 22:18:11","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"49.02","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":"3135836","reservation_id":"100177","confirmation_number":"BV12448692902","room_stay_from":"2020-09-10","room_stay_to":"2020-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.39,88.41","nightly_discount":"0,0","subtotal":"157.80","grand_total":"178.32","paid_amount":"178.32","room_type_id":"305","product_id":"1222","siteminder_id":"HTN-137858006-3N6JNL","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":"106236","customer_id":"106236","source_of_creation":"HotelTonight","reservation_created_date":"2020-09-09 19:03:09","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.39","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3135442","reservation_id":"100159","confirmation_number":"BV12499552933","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"88.40,88.40","nightly_discount":"0.00,0.00","subtotal":"176.80","grand_total":"199.79","paid_amount":"199.79","room_type_id":"307","product_id":"1224","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106178","customer_id":"106178","source_of_creation":"FE","reservation_created_date":"2020-09-09 04:42:29","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"88.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3135785","reservation_id":"100209","confirmation_number":"BV12420122532","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"65.00","nightly_discount":"0.00","subtotal":"65.00","grand_total":"73.45","paid_amount":"73.45","room_type_id":"303","product_id":"1140","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":"106212","customer_id":"106212","source_of_creation":"PMS","reservation_created_date":"2020-09-10 15:10:10","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"65.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3128013","reservation_id":"99227","confirmation_number":"BV12421401811","room_stay_from":"2020-09-05","room_stay_to":"2020-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"219.00,159.00,132.00,132.00,132.00,132.00,152.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1058.00","grand_total":"1195.54","paid_amount":"1195.54","room_type_id":"309","product_id":"1226","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"105206","customer_id":"105206","source_of_creation":"PMS","reservation_created_date":"2020-08-19 00:11:16","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"132.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135707","reservation_id":"100037","confirmation_number":"BV12454683698","room_stay_from":"2020-09-10","room_stay_to":"2020-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.65,209.00","nightly_discount":"0.00,12.16","subtotal":"369.65","grand_total":"403.96","paid_amount":"403.97","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106057","customer_id":"106057","source_of_creation":"PMS","reservation_created_date":"2020-09-05 21:15:45","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"From date changed","deltaChange":"-148.75","currentDayPrice":"160.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3128014","reservation_id":"99227","confirmation_number":"BV12291040250","room_confirmation_number":"BV12421401811","room_stay_from":"2020-09-05","room_stay_to":"2020-09-12","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"105206","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-08-19 00:11:16","reservation_modified_date_time":"2020-08-19 00:11:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105206","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":"3135443","reservation_id":"100159","confirmation_number":"BV12219047261","room_confirmation_number":"BV12499552933","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","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":"105105","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-09 04:42:29","reservation_modified_date_time":"2020-09-09 04:42:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106178","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":"3135561","reservation_id":"100132","confirmation_number":"BV12258998624","room_confirmation_number":"BV12432386497","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","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":"106203","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-08 17:08:07","reservation_modified_date_time":"2020-09-09 20:13:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106203","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":"3135786","reservation_id":"100209","confirmation_number":"BV12257024820","room_confirmation_number":"BV12420122532","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","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":"106212","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-10 15:10:10","reservation_modified_date_time":"2020-09-10 15:10:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106212","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":"3135973","reservation_id":"100235","confirmation_number":"BV12241636798","room_confirmation_number":"BV12447917740","room_stay_from":"2020-09-10","room_stay_to":"2020-09-11","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"106255","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-10 22:18:11","reservation_modified_date_time":"2020-09-10 22:18:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106255","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":"3128015","reservation_id":"99227","confirmation_number":"BV12247936559","room_confirmation_number":"BV12421401811","room_stay_from":"2020-09-05","room_stay_to":"2020-09-12","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":"105206","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-08-19 00:11:16","reservation_modified_date_time":"2020-08-19 00:11:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105206","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":"3135708","reservation_id":"100037","confirmation_number":"BV12258479752","room_confirmation_number":"BV12454683698","room_stay_from":"2020-09-10","room_stay_to":"2020-09-12","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":"106057","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-05 21:15:45","reservation_modified_date_time":"2020-09-10 14:05:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106057","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"From date changed","deltaChange":"-12.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3135835","reservation_id":"100177","confirmation_number":"BV12273314904","room_confirmation_number":"BV12448692902","room_stay_from":"2020-09-10","room_stay_to":"2020-09-12","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":"106236","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-09-09 19:03:09","reservation_modified_date_time":"2020-09-10 17:28:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106236","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3135331","reservation_id":"100130","confirmation_number":"BV12253724772","room_confirmation_number":"BV12467398169","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-09-08 16:42:51","reservation_modified_date_time":"2020-09-08 16:42:51","customer_id":"106150","parentCustTravId":"106150","customer_traveller_id":"106150","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-09-10 15:41:36","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2020-09-08","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"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":2,"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":[{"room_stay_id":"3134012","reservation_id":"99979","confirmation_number":"BP12521042857","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"85.85,85.85","nightly_discount":"0.00,0.00","subtotal":"171.70","grand_total":"194.02","paid_amount":"194.02","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"FE","reservation_created_date":"2020-09-04 19:16:18","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3133199","reservation_id":"99844","confirmation_number":"BP12540019580","room_stay_from":"2020-09-09","room_stay_to":"2020-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.10,124.10,166.00","nightly_discount":"0.00,0.00,0.00","subtotal":"414.20","grand_total":"468.04","paid_amount":"468.04","room_type_id":"296","product_id":"1131","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"73886","customer_id":"73886","source_of_creation":"PMS","reservation_created_date":"2020-09-02 00:31:27","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.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"}]}],"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":"3134013","reservation_id":"99979","confirmation_number":"BP12274014849","room_confirmation_number":"BP12521042857","room_stay_from":"2020-09-09","room_stay_to":"2020-09-11","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-09-04 19:16:18","reservation_modified_date_time":"2020-09-04 19:16:18","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":"3133200","reservation_id":"99844","confirmation_number":"BP12221707709","room_confirmation_number":"BP12540019580","room_stay_from":"2020-09-09","room_stay_to":"2020-09-12","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":"73886","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-09-02 00:31:27","reservation_modified_date_time":"2020-09-02 00:31:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"73886","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":[]}}}