{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2021-08-24","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":12,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5208141","reservation_id":"121741","confirmation_number":"PB12396062892","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.69,106.69","nightly_discount":"0,0","subtotal":"213.38","grand_total":"241.12","paid_amount":"241.12","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3891335465","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":"129311","customer_id":"129311","source_of_creation":"Booking.com","reservation_created_date":"2021-08-23 09:24:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"38.01","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"106.69","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":"5208273","reservation_id":"121770","confirmation_number":"PB12370097018","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"105.2,105.2,105.2","nightly_discount":"0,0,0","subtotal":"315.60","grand_total":"356.63","paid_amount":"356.63","room_type_id":"289","product_id":"1095","siteminder_id":"BDC-3246188972","collect_which":"hotel_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":"129319","customer_id":"129319","source_of_creation":"Booking.com","reservation_created_date":"2021-08-23 19:07:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"60.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"105.2","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":"5208521","reservation_id":"121809","confirmation_number":"PB12375020647","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"107.01,107.01","nightly_discount":"0,0","subtotal":"214.02","grand_total":"241.84","paid_amount":"241.84","room_type_id":"289","product_id":"1099","siteminder_id":"BDC-2886504215","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129335","customer_id":"129335","source_of_creation":"Booking.com","reservation_created_date":"2021-08-23 23:23:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"44.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"107.01","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294346","reservation_id":"121816","confirmation_number":"PB12355410343","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"105.2","nightly_discount":"0","subtotal":"105.20","grand_total":"118.87","paid_amount":"118.87","room_type_id":"289","product_id":"1101","siteminder_id":"BDC-2154413163","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129373","customer_id":"129373","source_of_creation":"Booking.com","reservation_created_date":"2021-08-24 01:00:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"20.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"105.2","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":"5294405","reservation_id":"121745","confirmation_number":"BP12585465012","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"90.73","nightly_discount":"0","subtotal":"90.73","grand_total":"102.52","paid_amount":"102.52","room_type_id":"298","product_id":"1133","siteminder_id":"BDC-3227174842","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":"129385","customer_id":"129385","source_of_creation":"Booking.com","reservation_created_date":"2021-08-23 12:51:10","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"19.93","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"90.73","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":"5294545","reservation_id":"121759","confirmation_number":"PB12322888621","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"155.89","nightly_discount":"0","subtotal":"155.89","grand_total":"176.15","paid_amount":"176.15","room_type_id":"291","product_id":"1118","siteminder_id":"BDC-3378483310","collect_which":"hotel_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":"129376","customer_id":"129376","source_of_creation":"Booking.com","reservation_created_date":"2021-08-23 17:11:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"83.65","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"155.89","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":[{"room_stay_id":"5178872","reservation_id":"121712","confirmation_number":"BV12412923107","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.59,115.59,115.59","nightly_discount":"0,0,0","subtotal":"346.77","grand_total":"391.85","paid_amount":"130.62","room_type_id":"306","product_id":"1223","siteminder_id":"BDC-2647229717","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":"129257","customer_id":"129257","source_of_creation":"Booking.com","reservation_created_date":"2021-08-22 19:53:11","service_canceled_date_time":"2021-08-24 13:20:10","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"73.22","reservation_status_type":"tax_exempted_indicator_0","total_paid_amount":"130.62","sub_hotel_id":"124","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3305728","reservation_id":"121503","confirmation_number":"BP12512998763","room_stay_from":"2021-08-24","room_stay_to":"2021-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.90,91.90,91.90,114.35,114.35,83.55,83.55","nightly_discount":"0,0,0,0,0,0,0","subtotal":"671.50","grand_total":"758.80","paid_amount":"758.80","room_type_id":"294","product_id":"1127","siteminder_id":"EXP-1818386710","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":"128715","customer_id":"128715","source_of_creation":"Expedia","reservation_created_date":"2021-08-19 17:21:10","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 822","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"91.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":"5208463","reservation_id":"121804","confirmation_number":"BP12588621768","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.05,71.05","nightly_discount":"0,0","subtotal":"142.10","grand_total":"160.58","paid_amount":"160.58","room_type_id":"293","product_id":"1124","siteminder_id":"EXP-1820253198","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":"129327","customer_id":"129327","source_of_creation":"Expedia","reservation_created_date":"2021-08-23 22:03:11","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"71.05","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":"5208498","reservation_id":"121664","confirmation_number":"BP12587513574","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"101.92,101.92,101.92,101.92,140.85","nightly_discount":"0,0,0,0,0","subtotal":"548.53","grand_total":"619.84","paid_amount":"619.84","room_type_id":"294","product_id":"1126","siteminder_id":"EXP-1819397651","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":"118559","customer_id":"118559","source_of_creation":"Expedia","reservation_created_date":"2021-08-21 20:48:12","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 806","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"101.92","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":"5208529","reservation_id":"121709","confirmation_number":"PB12346075493","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"101.42,101.42,101.42","nightly_discount":"0.00,0.00,0.00","subtotal":"304.26","grand_total":"343.82","paid_amount":"343.82","room_type_id":"289","product_id":"1107","siteminder_id":"EXP-1819726462","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":"129276","customer_id":"129276","source_of_creation":"Expedia","reservation_created_date":"2021-08-22 19:13:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"101.42","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294340","reservation_id":"120654","confirmation_number":"PB12388448295","room_stay_from":"2021-08-24","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.85,122.85,122.85,185.80,185.80,111.70","nightly_discount":"0,0,0,0,0,0","subtotal":"851.85","grand_total":"962.59","paid_amount":"962.59","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1810856615","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":"129371","customer_id":"129371","source_of_creation":"Expedia","reservation_created_date":"2021-08-03 07:17:08","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":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"122.85","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":"5294350","reservation_id":"121824","confirmation_number":"PB12364465859","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"101.42","nightly_discount":"0","subtotal":"101.42","grand_total":"114.61","paid_amount":"114.61","room_type_id":"285","product_id":"1084","siteminder_id":"EXP-1820404677","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":"129375","customer_id":"129375","source_of_creation":"Expedia","reservation_created_date":"2021-08-24 04:58:17","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"101.42","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":"5294400","reservation_id":"121676","confirmation_number":"PB12368857974","room_stay_from":"2021-08-24","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.48,94.48,94.48,149.47,149.47,90.42","nightly_discount":"0,0,0,0,0,0","subtotal":"672.80","grand_total":"760.27","paid_amount":"760.27","room_type_id":"289","product_id":"1098","siteminder_id":"EXP-1819449384","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":"129383","customer_id":"129383","source_of_creation":"Expedia","reservation_created_date":"2021-08-21 23:18:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"94.48","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":"5294426","reservation_id":"121847","confirmation_number":"BV12449481180","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.41,102.41","nightly_discount":"0,0","subtotal":"204.82","grand_total":"231.45","paid_amount":"231.45","room_type_id":"306","product_id":"1223","siteminder_id":"EXP-1820562107","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":"125753","customer_id":"125753","source_of_creation":"Expedia","reservation_created_date":"2021-08-24 15:58:08","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":"","promotion_code":null,"sub_hotel_id":"124","currentDayPrice":"102.41","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":"5294430","reservation_id":"121859","confirmation_number":"BV12479702896","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.37","nightly_discount":"0","subtotal":"78.37","grand_total":"88.56","paid_amount":"88.56","room_type_id":"304","product_id":"1218","siteminder_id":"EXP-1820643969","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":"129390","customer_id":"129390","source_of_creation":"Expedia","reservation_created_date":"2021-08-24 19:08:12","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","currentDayPrice":"78.37","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":"5208555","reservation_id":"121769","confirmation_number":"BV12444969499","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.48,71.48","nightly_discount":"0,0","subtotal":"142.96","grand_total":"161.55","paid_amount":"161.55","room_type_id":"314","product_id":"1229","siteminder_id":"GAM-R2755330318","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":"129312","customer_id":"129312","source_of_creation":"Getaroom.com","reservation_created_date":"2021-08-23 18:54:13","canceled_nights_data":"","product_name":"BV Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"71.48","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":"5294377","reservation_id":"121856","confirmation_number":"BP12541527495","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.81","nightly_discount":"0","subtotal":"73.81","grand_total":"83.41","paid_amount":"83.41","room_type_id":"295","product_id":"1128","siteminder_id":"GAM-R2757622581","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":"129379","customer_id":"129379","source_of_creation":"Getaroom.com","reservation_created_date":"2021-08-24 18:26:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"73.81","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":"5294476","reservation_id":"121825","confirmation_number":"BP12565074638","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.73","nightly_discount":"0","subtotal":"70.73","grand_total":"79.92","paid_amount":"79.92","room_type_id":"299","product_id":"1134","siteminder_id":"GAM-R2756665910","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":"129396","customer_id":"129396","source_of_creation":"Getaroom.com","reservation_created_date":"2021-08-24 05:02:14","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"70.73","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":"5294570","reservation_id":"121848","confirmation_number":"PB12369475004","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.97,95.97","nightly_discount":"0,0","subtotal":"191.94","grand_total":"216.90","paid_amount":"216.90","room_type_id":"289","product_id":"1111","siteminder_id":"GAM-R2757291932","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":"129407","customer_id":"129407","source_of_creation":"Getaroom.com","reservation_created_date":"2021-08-24 16:11:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"95.97","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":"3303687","reservation_id":"120073","confirmation_number":"PB12311386561","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.62","nightly_discount":"0.00","subtotal":"261.62","grand_total":"295.63","paid_amount":"295.63","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":"127318","customer_id":"127318","source_of_creation":"FE","reservation_created_date":"2021-07-25 21:33:33","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"261.62","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3304792","reservation_id":"121459","confirmation_number":"PB12356250571","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"201.22","nightly_discount":"0.00","subtotal":"201.22","grand_total":"227.38","paid_amount":"227.38","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":"128939","customer_id":"128939","source_of_creation":"FE","reservation_created_date":"2021-08-19 03:44:54","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"201.22","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5178462","reservation_id":"120582","confirmation_number":"PB12320170447","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"157.29,157.29,157.29,157.29,157.29,260.97","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1047.42","grand_total":"1183.59","paid_amount":"1183.59","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95312","customer_id":"95312","source_of_creation":"FE","reservation_created_date":"2021-08-02 14:22:59","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"157.29","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5178601","reservation_id":"121687","confirmation_number":"PB12362369851","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"177.78,177.78,177.78","nightly_discount":"0.00,0.00,0.00","subtotal":"533.34","grand_total":"602.67","paid_amount":"602.67","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129226","customer_id":"129226","source_of_creation":"FE","reservation_created_date":"2021-08-22 14:10:57","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"177.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5189060","reservation_id":"121760","confirmation_number":"PB12380126592","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.90","nightly_discount":"0.00","subtotal":"119.90","grand_total":"135.48","paid_amount":"135.48","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129301","customer_id":"129301","source_of_creation":"FE","reservation_created_date":"2021-08-23 17:16:55","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"119.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294384","reservation_id":"121673","confirmation_number":"PB12386843598","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.98,120.98,120.98","nightly_discount":"0.00,0.00,0.00","subtotal":"362.94","grand_total":"410.13","paid_amount":"410.13","room_type_id":"292","product_id":"1120","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":"129210","customer_id":"129210","source_of_creation":"FE","reservation_created_date":"2021-08-21 22:06:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"120.98","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294450","reservation_id":"121600","confirmation_number":"BP12529039816","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.56,152.56,152.56,152.56","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"610.24","grand_total":"689.57","paid_amount":"530.11","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":"129096","customer_id":"129096","source_of_creation":"FE","reservation_created_date":"2021-08-20 20:50:02","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":"","promotion_code":"","sub_hotel_id":"125","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"152.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294477","reservation_id":"120912","confirmation_number":"PB12364745058","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.77","nightly_discount":"0.00","subtotal":"160.77","grand_total":"181.67","paid_amount":"181.67","room_type_id":"290","product_id":"1113","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":"128318","customer_id":"128318","source_of_creation":"FE","reservation_created_date":"2021-08-07 22:08:11","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"160.77","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":[{"room_stay_id":"3263500","reservation_id":"116706","confirmation_number":"PB12399953879","room_stay_from":"2021-08-24","room_stay_to":"2021-08-29","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"307.56,307.56,307.56,373.56,373.56","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1669.80","grand_total":"1886.88","paid_amount":"347.54","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":"123606","customer_id":"123606","source_of_creation":"FE","reservation_created_date":"2021-06-07 05:13:29","service_canceled_date_time":"2021-08-24 02:01:27","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"347.54","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3299886","reservation_id":"116705","confirmation_number":"PB12345870315","room_stay_from":"2021-08-24","room_stay_to":"2021-08-29","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"351.12,351.12,351.12,667.39,667.39","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"2388.14","grand_total":"2698.60","paid_amount":"396.77","room_type_id":"287","product_id":"1090","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"123606","customer_id":"123606","source_of_creation":"FE","reservation_created_date":"2021-06-07 05:01:50","service_canceled_date_time":"2021-08-24 02:03:41","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"396.77","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3299892","reservation_id":"120404","confirmation_number":"PB12370753214","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.25,210.25,210.25,210.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"841.00","grand_total":"950.33","paid_amount":"950.33","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"39368","customer_id":"39368","source_of_creation":"PMS","reservation_created_date":"2021-07-30 15:31:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"210.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3302629","reservation_id":"121192","confirmation_number":"PB12369468734","room_stay_from":"2021-08-22","room_stay_to":"2021-09-01","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,149.00,149.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1090.00","grand_total":"1231.70","paid_amount":"1231.70","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":"110752","customer_id":"110752","source_of_creation":"PMS","reservation_created_date":"2021-08-14 19:51:11","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3303817","reservation_id":"120686","confirmation_number":"PB12356246254","room_stay_from":"2021-08-24","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"157.29,157.29,157.29,157.29","nightly_discount":"0.00,0.00,0.00,0","subtotal":"629.16","grand_total":"710.95","paid_amount":"710.95","room_type_id":"289","product_id":"1105","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":"93147","customer_id":"93147","source_of_creation":"PMS","reservation_created_date":"2021-08-03 19:53:30","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"157.29","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3304875","reservation_id":"121434","confirmation_number":"PB12366711388","room_stay_from":"2021-08-19","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.96,166.11,166.11,117.49,117.49,117.49,117.49","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,49.17","subtotal":"896.14","grand_total":"957.08","paid_amount":"957.08","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128907","customer_id":"128907","source_of_creation":"PMS","reservation_created_date":"2021-08-18 22:51:53","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"117.49","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5178616","reservation_id":"121636","confirmation_number":"PB12390967415","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.82,161.82,161.82","nightly_discount":"0.00,0.00,0","subtotal":"485.46","grand_total":"548.57","paid_amount":"548.57","room_type_id":"286","product_id":"1086","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":"23886","customer_id":"23886","source_of_creation":"PMS","reservation_created_date":"2021-08-21 13:15:52","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"161.82","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":"5178972","reservation_id":"113867","confirmation_number":"BV12428821749","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,159.00,159.00,159.00,159.00,209.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,53.88","subtotal":"1004.00","grand_total":"1073.64","paid_amount":"1073.64","room_type_id":"308","product_id":"1225","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"29257","customer_id":"29257","source_of_creation":"PMS","reservation_created_date":"2021-04-25 18:30:16","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"159.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5179029","reservation_id":"120109","confirmation_number":"PB12310250162","room_stay_from":"2021-08-21","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00,125.00,125.00,125.00,125.00,125.00","nightly_discount":"0.00,0.00,0.00,20.43,0.00,0.00","subtotal":"850.00","grand_total":"937.41","paid_amount":"937.41","room_type_id":"289","product_id":"1112","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":"127230","customer_id":"127230","source_of_creation":"PMS","reservation_created_date":"2021-07-26 15:30:01","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"125.00","currentDayDiscount":"20.43","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5207996","reservation_id":"121765","confirmation_number":"BV12462893024","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.00,82.00,82.00,82.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"328.00","grand_total":"370.64","paid_amount":"370.64","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128720","customer_id":"128720","source_of_creation":"PMS","reservation_created_date":"2021-08-23 17:45:21","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"82.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5208539","reservation_id":"121594","confirmation_number":"BV12479472395","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"118.20","nightly_discount":"0.00","subtotal":"118.20","grand_total":"133.56","paid_amount":"133.56","room_type_id":"304","product_id":"1220","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128747","customer_id":"128747","source_of_creation":"PMS","reservation_created_date":"2021-08-20 20:10:04","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"118.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294382","reservation_id":"121857","confirmation_number":"PB12367021866","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.90,119.90","nightly_discount":"0.00,0.00","subtotal":"239.80","grand_total":"270.98","paid_amount":"270.98","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129380","customer_id":"129380","source_of_creation":"PMS","reservation_created_date":"2021-08-24 18:47:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"119.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294464","reservation_id":"121868","confirmation_number":"PB12331884466","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.90","nightly_discount":"0.00","subtotal":"119.90","grand_total":"135.48","paid_amount":"135.48","room_type_id":"289","product_id":"1121","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129394","customer_id":"129394","source_of_creation":"PMS","reservation_created_date":"2021-08-24 21:52:46","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"119.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294471","reservation_id":"121842","confirmation_number":"BV12452042207","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.31,87.00","nightly_discount":"0.00,0.00","subtotal":"190.31","grand_total":"215.05","paid_amount":"215.05","room_type_id":"303","product_id":"1139","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129325","customer_id":"129325","source_of_creation":"PMS","reservation_created_date":"2021-08-24 14:44:06","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":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"103.31","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294497","reservation_id":"121871","confirmation_number":"BV12499898184","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.31,103.31","nightly_discount":"0.00,0.00","subtotal":"206.62","grand_total":"233.48","paid_amount":"233.48","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":"129397","customer_id":"129397","source_of_creation":"PMS","reservation_created_date":"2021-08-24 23:10:47","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":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"103.31","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3302631","reservation_id":"121192","confirmation_number":"PB12288803786","room_confirmation_number":"PB12369468734","room_stay_from":"2021-08-22","room_stay_to":"2021-09-01","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"110752","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-08-14 19:51:11","reservation_modified_date_time":"2021-08-14 19:51:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110752","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3304793","reservation_id":"121459","confirmation_number":"PB12269794947","room_confirmation_number":"PB12356250571","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"128939","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-08-19 16:23:38","reservation_modified_date_time":"2021-08-19 16:23:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128939","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5178463","reservation_id":"120582","confirmation_number":"PB12265892768","room_confirmation_number":"PB12320170447","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"95312","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-08-21 23:37:12","reservation_modified_date_time":"2021-08-21 23:37:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95312","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5208271","reservation_id":"121770","confirmation_number":"PB12260921978","room_confirmation_number":"PB12370097018","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","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":"129319","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-08-23 19:07:11","reservation_modified_date_time":"2021-08-23 20:06:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129319","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","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":"5208519","reservation_id":"121809","confirmation_number":"PB12225288375","room_confirmation_number":"PB12375020647","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"129335","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-08-23 23:23:11","reservation_modified_date_time":"2021-08-24 00:20:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129335","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5208530","reservation_id":"121709","confirmation_number":"PB12241650369","room_confirmation_number":"PB12346075493","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"20.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"129276","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-08-23 01:05:02","reservation_modified_date_time":"2021-08-24 00:28:03","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129276","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294344","reservation_id":"121816","confirmation_number":"PB12252678972","room_confirmation_number":"PB12355410343","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"129373","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-08-24 01:00:14","reservation_modified_date_time":"2021-08-24 17:05:16","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129373","canceled_nights_data":"","posAmt_airbnb_taxpaid":"10.00","sub_hotel_id":"123","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":"5294546","reservation_id":"121759","confirmation_number":"PB12223704908","room_confirmation_number":"PB12322888621","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"129376","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-08-25 01:40:48","reservation_modified_date_time":"2021-08-25 01:40:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129376","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"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":"3299893","reservation_id":"120404","confirmation_number":"PB12248941432","room_confirmation_number":"PB12370753214","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","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":"39368","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-30 15:31:14","reservation_modified_date_time":"2021-08-07 23:49:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"39368","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"3302630","reservation_id":"121192","confirmation_number":"PB12290189495","room_confirmation_number":"PB12369468734","room_stay_from":"2021-08-22","room_stay_to":"2021-09-01","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"110752","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-14 19:51:11","reservation_modified_date_time":"2021-08-14 19:51:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110752","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"3303688","reservation_id":"120073","confirmation_number":"PB12287324633","room_confirmation_number":"PB12311386561","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"127318","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-25 21:33:33","reservation_modified_date_time":"2021-08-17 12:33:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127318","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"3303818","reservation_id":"120686","confirmation_number":"PB12242095584","room_confirmation_number":"PB12356246254","room_stay_from":"2021-08-24","room_stay_to":"2021-08-28","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":"93147","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-03 19:53:30","reservation_modified_date_time":"2021-08-17 18:17:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93147","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"3304794","reservation_id":"121459","confirmation_number":"PB12229669727","room_confirmation_number":"PB12356250571","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"128939","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-19 03:44:54","reservation_modified_date_time":"2021-08-19 16:23:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128939","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"3304876","reservation_id":"121434","confirmation_number":"PB12232945749","room_confirmation_number":"PB12366711388","room_stay_from":"2021-08-19","room_stay_to":"2021-08-26","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":"128907","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-18 22:51:53","reservation_modified_date_time":"2021-08-19 17:21:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128907","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"3305727","reservation_id":"121503","confirmation_number":"BP12272543316","room_confirmation_number":"BP12512998763","room_stay_from":"2021-08-24","room_stay_to":"2021-08-31","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":"128715","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-19 17:21:10","reservation_modified_date_time":"2021-08-21 00:06:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128715","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5178464","reservation_id":"120582","confirmation_number":"PB12283468292","room_confirmation_number":"PB12320170447","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","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":"95312","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-02 14:22:59","reservation_modified_date_time":"2021-08-21 23:37:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95312","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5178602","reservation_id":"121687","confirmation_number":"PB12220077102","room_confirmation_number":"PB12362369851","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","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":"129226","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-22 14:10:57","reservation_modified_date_time":"2021-08-22 14:10:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129226","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5178617","reservation_id":"121636","confirmation_number":"PB12266292426","room_confirmation_number":"PB12390967415","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","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":"23886","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-21 13:15:52","reservation_modified_date_time":"2021-08-22 15:08:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23886","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5178974","reservation_id":"113867","confirmation_number":"BV12220037573","room_confirmation_number":"BV12428821749","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","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":"51.35","product_id":"1781","service_quantity":"1","customer_traveller_id":"29257","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-04-25 18:30:16","reservation_modified_date_time":"2021-08-23 13:14:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"29257","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5179030","reservation_id":"120109","confirmation_number":"PB12268255284","room_confirmation_number":"PB12310250162","room_stay_from":"2021-08-21","room_stay_to":"2021-08-27","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":"127230","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-26 15:30:01","reservation_modified_date_time":"2021-08-23 15:15:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127230","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5189061","reservation_id":"121760","confirmation_number":"PB12292245530","room_confirmation_number":"PB12380126592","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129301","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-23 17:16:55","reservation_modified_date_time":"2021-08-23 17:16:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129301","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5207997","reservation_id":"121765","confirmation_number":"BV12286813987","room_confirmation_number":"BV12462893024","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","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":"128720","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-23 17:45:21","reservation_modified_date_time":"2021-08-23 17:45:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128720","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5208140","reservation_id":"121741","confirmation_number":"PB12219378309","room_confirmation_number":"PB12396062892","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","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":"129311","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-23 09:24:08","reservation_modified_date_time":"2021-08-23 18:46:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129311","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5208272","reservation_id":"121770","confirmation_number":"PB12210534372","room_confirmation_number":"PB12370097018","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","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":"129319","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-23 19:07:11","reservation_modified_date_time":"2021-08-23 20:06:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129319","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","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":"5208462","reservation_id":"121804","confirmation_number":"BP12230307636","room_confirmation_number":"BP12588621768","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","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":"129327","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-23 22:03:11","reservation_modified_date_time":"2021-08-23 22:23:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129327","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5208497","reservation_id":"121664","confirmation_number":"BP12273791299","room_confirmation_number":"BP12587513574","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"118559","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-21 20:48:12","reservation_modified_date_time":"2021-08-23 22:49:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118559","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5208520","reservation_id":"121809","confirmation_number":"PB12296267071","room_confirmation_number":"PB12375020647","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","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":"129335","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-23 23:23:11","reservation_modified_date_time":"2021-08-24 00:20:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129335","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","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":"5208531","reservation_id":"121709","confirmation_number":"PB12296107503","room_confirmation_number":"PB12346075493","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","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":"129276","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-22 19:13:11","reservation_modified_date_time":"2021-08-24 00:28:03","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129276","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5208540","reservation_id":"121594","confirmation_number":"BV12296811804","room_confirmation_number":"BV12479472395","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"128747","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-20 20:10:04","reservation_modified_date_time":"2021-08-24 01:06:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128747","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5208556","reservation_id":"121769","confirmation_number":"BV12244577365","room_confirmation_number":"BV12444969499","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"129312","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-23 18:54:13","reservation_modified_date_time":"2021-08-24 02:19:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129312","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5294339","reservation_id":"120654","confirmation_number":"PB12213464225","room_confirmation_number":"PB12388448295","room_stay_from":"2021-08-24","room_stay_to":"2021-08-30","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"129371","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-03 07:17:08","reservation_modified_date_time":"2021-08-24 16:48:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129371","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294345","reservation_id":"121816","confirmation_number":"PB12269874066","room_confirmation_number":"PB12355410343","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129373","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-24 01:00:14","reservation_modified_date_time":"2021-08-24 17:05:16","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129373","canceled_nights_data":"","posAmt_airbnb_taxpaid":"10.00","sub_hotel_id":"123","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":"5294349","reservation_id":"121824","confirmation_number":"PB12274877289","room_confirmation_number":"PB12364465859","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129375","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-24 04:58:17","reservation_modified_date_time":"2021-08-24 17:23:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129375","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294378","reservation_id":"121856","confirmation_number":"BP12272367751","room_confirmation_number":"BP12541527495","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129379","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-24 18:26:11","reservation_modified_date_time":"2021-08-24 18:26:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129379","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5294383","reservation_id":"121857","confirmation_number":"PB12268875086","room_confirmation_number":"PB12367021866","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","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":"129380","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-24 18:47:21","reservation_modified_date_time":"2021-08-24 18:47:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129380","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294386","reservation_id":"121673","confirmation_number":"PB12272680942","room_confirmation_number":"PB12386843598","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","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":"20.67","product_id":"1781","service_quantity":"1","customer_traveller_id":"129210","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-21 22:06:14","reservation_modified_date_time":"2021-08-24 18:50:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129210","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294399","reservation_id":"121676","confirmation_number":"PB12295595119","room_confirmation_number":"PB12368857974","room_stay_from":"2021-08-24","room_stay_to":"2021-08-30","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"129383","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-21 23:18:12","reservation_modified_date_time":"2021-08-24 19:13:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129383","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294404","reservation_id":"121745","confirmation_number":"BP12267116567","room_confirmation_number":"BP12585465012","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129385","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-23 12:51:10","reservation_modified_date_time":"2021-08-24 19:17:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129385","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5294424","reservation_id":"121847","confirmation_number":"BV12268021296","room_confirmation_number":"BV12449481180","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","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":"125753","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-24 15:58:08","reservation_modified_date_time":"2021-08-24 20:43:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125753","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5294429","reservation_id":"121859","confirmation_number":"BV12236224260","room_confirmation_number":"BV12479702896","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129390","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-24 19:08:12","reservation_modified_date_time":"2021-08-24 20:49:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129390","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5294452","reservation_id":"121600","confirmation_number":"BP12261049918","room_confirmation_number":"BP12529039816","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"129096","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-20 20:50:02","reservation_modified_date_time":"2021-08-24 21:31:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129096","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5294465","reservation_id":"121868","confirmation_number":"PB12265262655","room_confirmation_number":"PB12331884466","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129394","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-24 21:52:46","reservation_modified_date_time":"2021-08-24 21:52:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129394","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294472","reservation_id":"121842","confirmation_number":"BV12262627121","room_confirmation_number":"BV12452042207","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","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":"129325","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-24 14:44:06","reservation_modified_date_time":"2021-08-24 22:39:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129325","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5294475","reservation_id":"121825","confirmation_number":"BP12295809473","room_confirmation_number":"BP12565074638","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129396","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-24 05:02:14","reservation_modified_date_time":"2021-08-24 22:42:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129396","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5294478","reservation_id":"120912","confirmation_number":"PB12239179014","room_confirmation_number":"PB12364745058","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"128318","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-07 22:08:11","reservation_modified_date_time":"2021-08-24 22:44:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128318","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294499","reservation_id":"121871","confirmation_number":"BV12232326717","room_confirmation_number":"BV12499898184","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","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":"129397","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-24 23:10:47","reservation_modified_date_time":"2021-08-24 23:10:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129397","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5294547","reservation_id":"121759","confirmation_number":"PB12252481517","room_confirmation_number":"PB12322888621","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"129376","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-23 17:11:09","reservation_modified_date_time":"2021-08-25 01:40:49","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129376","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"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":"5294569","reservation_id":"121848","confirmation_number":"PB12239967683","room_confirmation_number":"PB12369475004","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","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":"129407","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-24 16:11:11","reservation_modified_date_time":"2021-08-25 02:37:58","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129407","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5178871","reservation_id":"121712","confirmation_number":"BV12268745200","room_confirmation_number":"BV12412923107","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Canceled","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":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-22 19:53:11","reservation_modified_date_time":"2021-08-23 01:08:30","customer_id":"129257","parentCustTravId":"129257","customer_traveller_id":"129257","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-08-24 13:20:10","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#20","parentRoomStayFrom":"2021-08-23","sub_hotel_id":"124","deltaChange":-20,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5294364","reservation_id":"121760","confirmation_number":"PB12278077148","room_confirmation_number":"PB12380126592","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 18:07:51","reservation_modified_date_time":"2021-08-24 18:07:51","customer_id":"129301","parentCustTravId":"129301","customer_traveller_id":"129301","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294366","reservation_id":"121459","confirmation_number":"PB12242252617","room_confirmation_number":"PB12356250571","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"40.00","paid_amount":"1.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 18:08:01","reservation_modified_date_time":"2021-08-24 18:08:01","customer_id":"128939","parentCustTravId":"128939","customer_traveller_id":"128939","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"123","currentDayPrice":"37.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294379","reservation_id":"120686","confirmation_number":"PB12296521480","room_confirmation_number":"PB12356246254","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 18:43:09","reservation_modified_date_time":"2021-08-24 18:43:09","customer_id":"93147","parentCustTravId":"93147","customer_traveller_id":"93147","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294385","reservation_id":"121673","confirmation_number":"PB12293562816","room_confirmation_number":"PB12386843598","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.01","paid_amount":"20.01","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-23 23:05:33","reservation_modified_date_time":"2021-08-24 18:50:39","customer_id":"129210","parentCustTravId":"129210","customer_traveller_id":"129210","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-22","sub_hotel_id":"123","changedComment":"price, discount or quantity changed","deltaChange":"9.35","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294406","reservation_id":"121676","confirmation_number":"PB12261490901","room_confirmation_number":"PB12368857974","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 19:32:58","reservation_modified_date_time":"2021-08-24 19:32:58","customer_id":"129383","parentCustTravId":"129383","customer_traveller_id":"129383","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294425","reservation_id":"121847","confirmation_number":"BV12282491160","room_confirmation_number":"BV12449481180","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.50","paid_amount":"56.50","product_id":"2108","service_quantity":"2","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 20:28:11","reservation_modified_date_time":"2021-08-24 20:43:48","customer_id":"125753","parentCustTravId":"125753","customer_traveller_id":"125753","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"124","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5294434","reservation_id":"121687","confirmation_number":"PB12248572918","room_confirmation_number":"PB12362369851","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 20:59:21","reservation_modified_date_time":"2021-08-24 20:59:21","customer_id":"129226","parentCustTravId":"129226","customer_traveller_id":"129226","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-23","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294441","reservation_id":"121459","confirmation_number":"PB12299958495","room_confirmation_number":"PB12356250571","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"0.00","product_id":"1213","service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 21:07:53","reservation_modified_date_time":"2021-08-24 21:07:53","customer_id":"128939","parentCustTravId":"128939","customer_traveller_id":"128939","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"123","currentDayPrice":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294448","reservation_id":"121600","confirmation_number":"BP12292741810","room_confirmation_number":"BP12529039816","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"45.00","grand_total":"203.40","paid_amount":"0.00","product_id":"2109","service_quantity":"4","product_name":"Boat Slip Docking","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-20 20:55:07","reservation_modified_date_time":"2021-08-24 21:31:45","customer_id":"129096","parentCustTravId":"129096","customer_traveller_id":"129096","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-23","sub_hotel_id":"125","changedComment":"price, discount or quantity changed","deltaChange":"90.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5294451","reservation_id":"121600","confirmation_number":"BP12296565367","room_confirmation_number":"BP12529039816","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"113.00","paid_amount":"0.00","product_id":"2108","service_quantity":"4","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-20 20:55:18","reservation_modified_date_time":"2021-08-24 21:31:52","customer_id":"129096","parentCustTravId":"129096","customer_traveller_id":"129096","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-23","sub_hotel_id":"125","changedComment":"price, discount or quantity changed","deltaChange":"50.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5294462","reservation_id":"121594","confirmation_number":"BV12261781830","room_confirmation_number":"BV12479472395","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"2.00","paid_amount":"2.00","product_id":"1213","service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 21:48:30","reservation_modified_date_time":"2021-08-24 21:48:30","customer_id":"128747","parentCustTravId":"128747","customer_traveller_id":"128747","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"124","currentDayPrice":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294463","reservation_id":"120654","confirmation_number":"PB12247610202","room_confirmation_number":"PB12388448295","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 21:51:27","reservation_modified_date_time":"2021-08-24 21:51:27","customer_id":"129371","parentCustTravId":"129371","customer_traveller_id":"129371","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294498","reservation_id":"121871","confirmation_number":"BV12212138268","room_confirmation_number":"BV12499898184","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"45.00,45.00","nightly_discount":"0.00,0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 23:10:47","reservation_modified_date_time":"2021-08-24 23:10:47","customer_id":"129397","parentCustTravId":"129397","customer_traveller_id":"129397","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"124","currentDayPrice":"45.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3305541","reservation_id":"121200","confirmation_number":"PB12235766191","room_confirmation_number":"PB12329279509","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":"2021-08-20 19:51:18","reservation_modified_date_time":"2021-08-20 19:51:18","customer_id":"128908","parentCustTravId":"128908","customer_traveller_id":"128908","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-08-24 15:29:00","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-08-19","sub_hotel_id":"123","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":"5208535","reservation_id":"121812","confirmation_number":"PB12244155113","room_confirmation_number":"PB12328864344","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 00:58:50","reservation_modified_date_time":"2021-08-24 00:58:50","customer_id":"129334","parentCustTravId":"129334","customer_traveller_id":"129334","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-08-24 12:04:23","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-08-23","sub_hotel_id":"123","deltaChange":-9.35,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[{"room_stay_id":"5294551","reservation_id":"121759","confirmation_number":"PB12276976771","room_confirmation_number":"PB12322888621","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"47.22","grand_total":"94.44","paid_amount":"87.04","product_id":"1082","service_quantity":"2","product_name":"Upgrade fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-25 01:41:39","reservation_modified_date_time":"2021-08-25 01:41:39","customer_id":"129376","parentCustTravId":"129376","customer_traveller_id":"129376","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"123","currentDayPrice":"94.44","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120","departureCount":7,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5208141","reservation_id":"121741","confirmation_number":"PB12396062892","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.69,106.69","nightly_discount":"0,0","subtotal":"213.38","grand_total":"241.12","paid_amount":"241.12","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3891335465","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":"129311","customer_id":"129311","source_of_creation":"Booking.com","reservation_created_date":"2021-08-23 09:24:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"38.01","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"106.69","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":"5208273","reservation_id":"121770","confirmation_number":"PB12370097018","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"105.2,105.2,105.2","nightly_discount":"0,0,0","subtotal":"315.60","grand_total":"356.63","paid_amount":"356.63","room_type_id":"289","product_id":"1095","siteminder_id":"BDC-3246188972","collect_which":"hotel_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":"129319","customer_id":"129319","source_of_creation":"Booking.com","reservation_created_date":"2021-08-23 19:07:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"60.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"105.2","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":"5208521","reservation_id":"121809","confirmation_number":"PB12375020647","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"107.01,107.01","nightly_discount":"0,0","subtotal":"214.02","grand_total":"241.84","paid_amount":"241.84","room_type_id":"289","product_id":"1099","siteminder_id":"BDC-2886504215","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129335","customer_id":"129335","source_of_creation":"Booking.com","reservation_created_date":"2021-08-23 23:23:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"44.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"107.01","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294346","reservation_id":"121816","confirmation_number":"PB12355410343","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"105.2","nightly_discount":"0","subtotal":"105.20","grand_total":"118.87","paid_amount":"118.87","room_type_id":"289","product_id":"1101","siteminder_id":"BDC-2154413163","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129373","customer_id":"129373","source_of_creation":"Booking.com","reservation_created_date":"2021-08-24 01:00:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"20.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"105.2","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":"5294545","reservation_id":"121759","confirmation_number":"PB12322888621","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"155.89","nightly_discount":"0","subtotal":"155.89","grand_total":"176.15","paid_amount":"176.15","room_type_id":"291","product_id":"1118","siteminder_id":"BDC-3378483310","collect_which":"hotel_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":"129376","customer_id":"129376","source_of_creation":"Booking.com","reservation_created_date":"2021-08-23 17:11:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"83.65","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"155.89","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":"5208529","reservation_id":"121709","confirmation_number":"PB12346075493","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"101.42,101.42,101.42","nightly_discount":"0.00,0.00,0.00","subtotal":"304.26","grand_total":"343.82","paid_amount":"343.82","room_type_id":"289","product_id":"1107","siteminder_id":"EXP-1819726462","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":"129276","customer_id":"129276","source_of_creation":"Expedia","reservation_created_date":"2021-08-22 19:13:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"101.42","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294340","reservation_id":"120654","confirmation_number":"PB12388448295","room_stay_from":"2021-08-24","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.85,122.85,122.85,185.80,185.80,111.70","nightly_discount":"0,0,0,0,0,0","subtotal":"851.85","grand_total":"962.59","paid_amount":"962.59","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1810856615","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":"129371","customer_id":"129371","source_of_creation":"Expedia","reservation_created_date":"2021-08-03 07:17:08","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":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"122.85","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":"5294350","reservation_id":"121824","confirmation_number":"PB12364465859","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"101.42","nightly_discount":"0","subtotal":"101.42","grand_total":"114.61","paid_amount":"114.61","room_type_id":"285","product_id":"1084","siteminder_id":"EXP-1820404677","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":"129375","customer_id":"129375","source_of_creation":"Expedia","reservation_created_date":"2021-08-24 04:58:17","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"101.42","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":"5294400","reservation_id":"121676","confirmation_number":"PB12368857974","room_stay_from":"2021-08-24","room_stay_to":"2021-08-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.48,94.48,94.48,149.47,149.47,90.42","nightly_discount":"0,0,0,0,0,0","subtotal":"672.80","grand_total":"760.27","paid_amount":"760.27","room_type_id":"289","product_id":"1098","siteminder_id":"EXP-1819449384","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":"129383","customer_id":"129383","source_of_creation":"Expedia","reservation_created_date":"2021-08-21 23:18:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"94.48","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":"5294570","reservation_id":"121848","confirmation_number":"PB12369475004","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.97,95.97","nightly_discount":"0,0","subtotal":"191.94","grand_total":"216.90","paid_amount":"216.90","room_type_id":"289","product_id":"1111","siteminder_id":"GAM-R2757291932","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":"129407","customer_id":"129407","source_of_creation":"Getaroom.com","reservation_created_date":"2021-08-24 16:11:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"95.97","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":"3303687","reservation_id":"120073","confirmation_number":"PB12311386561","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"261.62","nightly_discount":"0.00","subtotal":"261.62","grand_total":"295.63","paid_amount":"295.63","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":"127318","customer_id":"127318","source_of_creation":"FE","reservation_created_date":"2021-07-25 21:33:33","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"261.62","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3304792","reservation_id":"121459","confirmation_number":"PB12356250571","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"201.22","nightly_discount":"0.00","subtotal":"201.22","grand_total":"227.38","paid_amount":"227.38","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":"128939","customer_id":"128939","source_of_creation":"FE","reservation_created_date":"2021-08-19 03:44:54","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"201.22","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5178462","reservation_id":"120582","confirmation_number":"PB12320170447","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"157.29,157.29,157.29,157.29,157.29,260.97","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1047.42","grand_total":"1183.59","paid_amount":"1183.59","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95312","customer_id":"95312","source_of_creation":"FE","reservation_created_date":"2021-08-02 14:22:59","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"157.29","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5178601","reservation_id":"121687","confirmation_number":"PB12362369851","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"177.78,177.78,177.78","nightly_discount":"0.00,0.00,0.00","subtotal":"533.34","grand_total":"602.67","paid_amount":"602.67","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129226","customer_id":"129226","source_of_creation":"FE","reservation_created_date":"2021-08-22 14:10:57","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"177.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5189060","reservation_id":"121760","confirmation_number":"PB12380126592","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.90","nightly_discount":"0.00","subtotal":"119.90","grand_total":"135.48","paid_amount":"135.48","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129301","customer_id":"129301","source_of_creation":"FE","reservation_created_date":"2021-08-23 17:16:55","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"119.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294384","reservation_id":"121673","confirmation_number":"PB12386843598","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.98,120.98,120.98","nightly_discount":"0.00,0.00,0.00","subtotal":"362.94","grand_total":"410.13","paid_amount":"410.13","room_type_id":"292","product_id":"1120","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":"129210","customer_id":"129210","source_of_creation":"FE","reservation_created_date":"2021-08-21 22:06:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"120.98","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294477","reservation_id":"120912","confirmation_number":"PB12364745058","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.77","nightly_discount":"0.00","subtotal":"160.77","grand_total":"181.67","paid_amount":"181.67","room_type_id":"290","product_id":"1113","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":"128318","customer_id":"128318","source_of_creation":"FE","reservation_created_date":"2021-08-07 22:08:11","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"160.77","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":[{"room_stay_id":"3263500","reservation_id":"116706","confirmation_number":"PB12399953879","room_stay_from":"2021-08-24","room_stay_to":"2021-08-29","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"307.56,307.56,307.56,373.56,373.56","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1669.80","grand_total":"1886.88","paid_amount":"347.54","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":"123606","customer_id":"123606","source_of_creation":"FE","reservation_created_date":"2021-06-07 05:13:29","service_canceled_date_time":"2021-08-24 02:01:27","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"347.54","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3299886","reservation_id":"116705","confirmation_number":"PB12345870315","room_stay_from":"2021-08-24","room_stay_to":"2021-08-29","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"351.12,351.12,351.12,667.39,667.39","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"2388.14","grand_total":"2698.60","paid_amount":"396.77","room_type_id":"287","product_id":"1090","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"123606","customer_id":"123606","source_of_creation":"FE","reservation_created_date":"2021-06-07 05:01:50","service_canceled_date_time":"2021-08-24 02:03:41","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"396.77","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3299892","reservation_id":"120404","confirmation_number":"PB12370753214","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.25,210.25,210.25,210.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"841.00","grand_total":"950.33","paid_amount":"950.33","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"39368","customer_id":"39368","source_of_creation":"PMS","reservation_created_date":"2021-07-30 15:31:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"210.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3302629","reservation_id":"121192","confirmation_number":"PB12369468734","room_stay_from":"2021-08-22","room_stay_to":"2021-09-01","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,149.00,149.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1090.00","grand_total":"1231.70","paid_amount":"1231.70","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":"110752","customer_id":"110752","source_of_creation":"PMS","reservation_created_date":"2021-08-14 19:51:11","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3303817","reservation_id":"120686","confirmation_number":"PB12356246254","room_stay_from":"2021-08-24","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"157.29,157.29,157.29,157.29","nightly_discount":"0.00,0.00,0.00,0","subtotal":"629.16","grand_total":"710.95","paid_amount":"710.95","room_type_id":"289","product_id":"1105","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":"93147","customer_id":"93147","source_of_creation":"PMS","reservation_created_date":"2021-08-03 19:53:30","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"157.29","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3304875","reservation_id":"121434","confirmation_number":"PB12366711388","room_stay_from":"2021-08-19","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.96,166.11,166.11,117.49,117.49,117.49,117.49","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,49.17","subtotal":"896.14","grand_total":"957.08","paid_amount":"957.08","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128907","customer_id":"128907","source_of_creation":"PMS","reservation_created_date":"2021-08-18 22:51:53","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"117.49","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5178616","reservation_id":"121636","confirmation_number":"PB12390967415","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.82,161.82,161.82","nightly_discount":"0.00,0.00,0","subtotal":"485.46","grand_total":"548.57","paid_amount":"548.57","room_type_id":"286","product_id":"1086","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":"23886","customer_id":"23886","source_of_creation":"PMS","reservation_created_date":"2021-08-21 13:15:52","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"161.82","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":"5179029","reservation_id":"120109","confirmation_number":"PB12310250162","room_stay_from":"2021-08-21","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"225.00,125.00,125.00,125.00,125.00,125.00","nightly_discount":"0.00,0.00,0.00,20.43,0.00,0.00","subtotal":"850.00","grand_total":"937.41","paid_amount":"937.41","room_type_id":"289","product_id":"1112","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":"127230","customer_id":"127230","source_of_creation":"PMS","reservation_created_date":"2021-07-26 15:30:01","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"125.00","currentDayDiscount":"20.43","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294382","reservation_id":"121857","confirmation_number":"PB12367021866","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.90,119.90","nightly_discount":"0.00,0.00","subtotal":"239.80","grand_total":"270.98","paid_amount":"270.98","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129380","customer_id":"129380","source_of_creation":"PMS","reservation_created_date":"2021-08-24 18:47:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"119.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294464","reservation_id":"121868","confirmation_number":"PB12331884466","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.90","nightly_discount":"0.00","subtotal":"119.90","grand_total":"135.48","paid_amount":"135.48","room_type_id":"289","product_id":"1121","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129394","customer_id":"129394","source_of_creation":"PMS","reservation_created_date":"2021-08-24 21:52:46","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"119.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3302631","reservation_id":"121192","confirmation_number":"PB12288803786","room_confirmation_number":"PB12369468734","room_stay_from":"2021-08-22","room_stay_to":"2021-09-01","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"110752","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-08-14 19:51:11","reservation_modified_date_time":"2021-08-14 19:51:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110752","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3304793","reservation_id":"121459","confirmation_number":"PB12269794947","room_confirmation_number":"PB12356250571","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"128939","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-08-19 16:23:38","reservation_modified_date_time":"2021-08-19 16:23:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128939","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5178463","reservation_id":"120582","confirmation_number":"PB12265892768","room_confirmation_number":"PB12320170447","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"95312","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-08-21 23:37:12","reservation_modified_date_time":"2021-08-21 23:37:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95312","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5208271","reservation_id":"121770","confirmation_number":"PB12260921978","room_confirmation_number":"PB12370097018","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","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":"129319","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-08-23 19:07:11","reservation_modified_date_time":"2021-08-23 20:06:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129319","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","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":"5208519","reservation_id":"121809","confirmation_number":"PB12225288375","room_confirmation_number":"PB12375020647","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"129335","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-08-23 23:23:11","reservation_modified_date_time":"2021-08-24 00:20:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129335","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5208530","reservation_id":"121709","confirmation_number":"PB12241650369","room_confirmation_number":"PB12346075493","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"20.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"129276","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-08-23 01:05:02","reservation_modified_date_time":"2021-08-24 00:28:03","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129276","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294344","reservation_id":"121816","confirmation_number":"PB12252678972","room_confirmation_number":"PB12355410343","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"129373","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-08-24 01:00:14","reservation_modified_date_time":"2021-08-24 17:05:16","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129373","canceled_nights_data":"","posAmt_airbnb_taxpaid":"10.00","sub_hotel_id":"123","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":"5294546","reservation_id":"121759","confirmation_number":"PB12223704908","room_confirmation_number":"PB12322888621","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"129376","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-08-25 01:40:48","reservation_modified_date_time":"2021-08-25 01:40:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129376","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"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":"3299893","reservation_id":"120404","confirmation_number":"PB12248941432","room_confirmation_number":"PB12370753214","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","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":"39368","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-30 15:31:14","reservation_modified_date_time":"2021-08-07 23:49:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"39368","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"3302630","reservation_id":"121192","confirmation_number":"PB12290189495","room_confirmation_number":"PB12369468734","room_stay_from":"2021-08-22","room_stay_to":"2021-09-01","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"110752","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-14 19:51:11","reservation_modified_date_time":"2021-08-14 19:51:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110752","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"3303688","reservation_id":"120073","confirmation_number":"PB12287324633","room_confirmation_number":"PB12311386561","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"127318","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-25 21:33:33","reservation_modified_date_time":"2021-08-17 12:33:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127318","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"3303818","reservation_id":"120686","confirmation_number":"PB12242095584","room_confirmation_number":"PB12356246254","room_stay_from":"2021-08-24","room_stay_to":"2021-08-28","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":"93147","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-03 19:53:30","reservation_modified_date_time":"2021-08-17 18:17:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93147","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"3304794","reservation_id":"121459","confirmation_number":"PB12229669727","room_confirmation_number":"PB12356250571","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"128939","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-19 03:44:54","reservation_modified_date_time":"2021-08-19 16:23:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128939","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"3304876","reservation_id":"121434","confirmation_number":"PB12232945749","room_confirmation_number":"PB12366711388","room_stay_from":"2021-08-19","room_stay_to":"2021-08-26","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":"128907","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-18 22:51:53","reservation_modified_date_time":"2021-08-19 17:21:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128907","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5178464","reservation_id":"120582","confirmation_number":"PB12283468292","room_confirmation_number":"PB12320170447","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","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":"95312","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-02 14:22:59","reservation_modified_date_time":"2021-08-21 23:37:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95312","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5178602","reservation_id":"121687","confirmation_number":"PB12220077102","room_confirmation_number":"PB12362369851","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","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":"129226","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-22 14:10:57","reservation_modified_date_time":"2021-08-22 14:10:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129226","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5178617","reservation_id":"121636","confirmation_number":"PB12266292426","room_confirmation_number":"PB12390967415","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","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":"23886","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-21 13:15:52","reservation_modified_date_time":"2021-08-22 15:08:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23886","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5179030","reservation_id":"120109","confirmation_number":"PB12268255284","room_confirmation_number":"PB12310250162","room_stay_from":"2021-08-21","room_stay_to":"2021-08-27","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":"127230","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-26 15:30:01","reservation_modified_date_time":"2021-08-23 15:15:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127230","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5189061","reservation_id":"121760","confirmation_number":"PB12292245530","room_confirmation_number":"PB12380126592","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129301","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-23 17:16:55","reservation_modified_date_time":"2021-08-23 17:16:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129301","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5208140","reservation_id":"121741","confirmation_number":"PB12219378309","room_confirmation_number":"PB12396062892","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","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":"129311","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-23 09:24:08","reservation_modified_date_time":"2021-08-23 18:46:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129311","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5208272","reservation_id":"121770","confirmation_number":"PB12210534372","room_confirmation_number":"PB12370097018","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","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":"129319","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-23 19:07:11","reservation_modified_date_time":"2021-08-23 20:06:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129319","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","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":"5208520","reservation_id":"121809","confirmation_number":"PB12296267071","room_confirmation_number":"PB12375020647","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","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":"129335","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-23 23:23:11","reservation_modified_date_time":"2021-08-24 00:20:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129335","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","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":"5208531","reservation_id":"121709","confirmation_number":"PB12296107503","room_confirmation_number":"PB12346075493","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","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":"129276","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-22 19:13:11","reservation_modified_date_time":"2021-08-24 00:28:03","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129276","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294339","reservation_id":"120654","confirmation_number":"PB12213464225","room_confirmation_number":"PB12388448295","room_stay_from":"2021-08-24","room_stay_to":"2021-08-30","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"129371","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-03 07:17:08","reservation_modified_date_time":"2021-08-24 16:48:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129371","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294345","reservation_id":"121816","confirmation_number":"PB12269874066","room_confirmation_number":"PB12355410343","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129373","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-24 01:00:14","reservation_modified_date_time":"2021-08-24 17:05:16","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129373","canceled_nights_data":"","posAmt_airbnb_taxpaid":"10.00","sub_hotel_id":"123","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":"5294349","reservation_id":"121824","confirmation_number":"PB12274877289","room_confirmation_number":"PB12364465859","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129375","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-24 04:58:17","reservation_modified_date_time":"2021-08-24 17:23:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129375","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294383","reservation_id":"121857","confirmation_number":"PB12268875086","room_confirmation_number":"PB12367021866","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","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":"129380","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-24 18:47:21","reservation_modified_date_time":"2021-08-24 18:47:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129380","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294386","reservation_id":"121673","confirmation_number":"PB12272680942","room_confirmation_number":"PB12386843598","room_stay_from":"2021-08-22","room_stay_to":"2021-08-25","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":"20.67","product_id":"1781","service_quantity":"1","customer_traveller_id":"129210","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-21 22:06:14","reservation_modified_date_time":"2021-08-24 18:50:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129210","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294399","reservation_id":"121676","confirmation_number":"PB12295595119","room_confirmation_number":"PB12368857974","room_stay_from":"2021-08-24","room_stay_to":"2021-08-30","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"129383","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-21 23:18:12","reservation_modified_date_time":"2021-08-24 19:13:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129383","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294465","reservation_id":"121868","confirmation_number":"PB12265262655","room_confirmation_number":"PB12331884466","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129394","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-24 21:52:46","reservation_modified_date_time":"2021-08-24 21:52:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129394","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294478","reservation_id":"120912","confirmation_number":"PB12239179014","room_confirmation_number":"PB12364745058","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"128318","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-07 22:08:11","reservation_modified_date_time":"2021-08-24 22:44:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128318","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294547","reservation_id":"121759","confirmation_number":"PB12252481517","room_confirmation_number":"PB12322888621","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"129376","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-23 17:11:09","reservation_modified_date_time":"2021-08-25 01:40:49","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129376","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"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":"5294569","reservation_id":"121848","confirmation_number":"PB12239967683","room_confirmation_number":"PB12369475004","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","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":"129407","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-24 16:11:11","reservation_modified_date_time":"2021-08-25 02:37:58","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129407","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5294364","reservation_id":"121760","confirmation_number":"PB12278077148","room_confirmation_number":"PB12380126592","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 18:07:51","reservation_modified_date_time":"2021-08-24 18:07:51","customer_id":"129301","parentCustTravId":"129301","customer_traveller_id":"129301","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294366","reservation_id":"121459","confirmation_number":"PB12242252617","room_confirmation_number":"PB12356250571","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"40.00","paid_amount":"1.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 18:08:01","reservation_modified_date_time":"2021-08-24 18:08:01","customer_id":"128939","parentCustTravId":"128939","customer_traveller_id":"128939","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"123","currentDayPrice":"37.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294379","reservation_id":"120686","confirmation_number":"PB12296521480","room_confirmation_number":"PB12356246254","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 18:43:09","reservation_modified_date_time":"2021-08-24 18:43:09","customer_id":"93147","parentCustTravId":"93147","customer_traveller_id":"93147","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294385","reservation_id":"121673","confirmation_number":"PB12293562816","room_confirmation_number":"PB12386843598","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.01","paid_amount":"20.01","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-23 23:05:33","reservation_modified_date_time":"2021-08-24 18:50:39","customer_id":"129210","parentCustTravId":"129210","customer_traveller_id":"129210","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-22","sub_hotel_id":"123","changedComment":"price, discount or quantity changed","deltaChange":"9.35","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294406","reservation_id":"121676","confirmation_number":"PB12261490901","room_confirmation_number":"PB12368857974","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 19:32:58","reservation_modified_date_time":"2021-08-24 19:32:58","customer_id":"129383","parentCustTravId":"129383","customer_traveller_id":"129383","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294434","reservation_id":"121687","confirmation_number":"PB12248572918","room_confirmation_number":"PB12362369851","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 20:59:21","reservation_modified_date_time":"2021-08-24 20:59:21","customer_id":"129226","parentCustTravId":"129226","customer_traveller_id":"129226","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-23","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294441","reservation_id":"121459","confirmation_number":"PB12299958495","room_confirmation_number":"PB12356250571","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"1.00","paid_amount":"0.00","product_id":"1213","service_quantity":"1","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 21:07:53","reservation_modified_date_time":"2021-08-24 21:07:53","customer_id":"128939","parentCustTravId":"128939","customer_traveller_id":"128939","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"123","currentDayPrice":"0.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294463","reservation_id":"120654","confirmation_number":"PB12247610202","room_confirmation_number":"PB12388448295","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 21:51:27","reservation_modified_date_time":"2021-08-24 21:51:27","customer_id":"129371","parentCustTravId":"129371","customer_traveller_id":"129371","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3305541","reservation_id":"121200","confirmation_number":"PB12235766191","room_confirmation_number":"PB12329279509","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":"2021-08-20 19:51:18","reservation_modified_date_time":"2021-08-20 19:51:18","customer_id":"128908","parentCustTravId":"128908","customer_traveller_id":"128908","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-08-24 15:29:00","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-08-19","sub_hotel_id":"123","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":"5208535","reservation_id":"121812","confirmation_number":"PB12244155113","room_confirmation_number":"PB12328864344","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 00:58:50","reservation_modified_date_time":"2021-08-24 00:58:50","customer_id":"129334","parentCustTravId":"129334","customer_traveller_id":"129334","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-08-24 12:04:23","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-08-23","sub_hotel_id":"123","deltaChange":-9.35,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[{"room_stay_id":"5294551","reservation_id":"121759","confirmation_number":"PB12276976771","room_confirmation_number":"PB12322888621","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"47.22","grand_total":"94.44","paid_amount":"87.04","product_id":"1082","service_quantity":"2","product_name":"Upgrade fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-25 01:41:39","reservation_modified_date_time":"2021-08-25 01:41:39","customer_id":"129376","parentCustTravId":"129376","customer_traveller_id":"129376","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"123","currentDayPrice":"94.44","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":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":[{"room_stay_id":"5178872","reservation_id":"121712","confirmation_number":"BV12412923107","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.59,115.59,115.59","nightly_discount":"0,0,0","subtotal":"346.77","grand_total":"391.85","paid_amount":"130.62","room_type_id":"306","product_id":"1223","siteminder_id":"BDC-2647229717","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":"129257","customer_id":"129257","source_of_creation":"Booking.com","reservation_created_date":"2021-08-22 19:53:11","service_canceled_date_time":"2021-08-24 13:20:10","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"73.22","reservation_status_type":"tax_exempted_indicator_0","total_paid_amount":"130.62","sub_hotel_id":"124","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"5294426","reservation_id":"121847","confirmation_number":"BV12449481180","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.41,102.41","nightly_discount":"0,0","subtotal":"204.82","grand_total":"231.45","paid_amount":"231.45","room_type_id":"306","product_id":"1223","siteminder_id":"EXP-1820562107","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":"125753","customer_id":"125753","source_of_creation":"Expedia","reservation_created_date":"2021-08-24 15:58:08","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":"","promotion_code":null,"sub_hotel_id":"124","currentDayPrice":"102.41","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":"5294430","reservation_id":"121859","confirmation_number":"BV12479702896","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.37","nightly_discount":"0","subtotal":"78.37","grand_total":"88.56","paid_amount":"88.56","room_type_id":"304","product_id":"1218","siteminder_id":"EXP-1820643969","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":"129390","customer_id":"129390","source_of_creation":"Expedia","reservation_created_date":"2021-08-24 19:08:12","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","currentDayPrice":"78.37","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":"5208555","reservation_id":"121769","confirmation_number":"BV12444969499","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.48,71.48","nightly_discount":"0,0","subtotal":"142.96","grand_total":"161.55","paid_amount":"161.55","room_type_id":"314","product_id":"1229","siteminder_id":"GAM-R2755330318","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":"129312","customer_id":"129312","source_of_creation":"Getaroom.com","reservation_created_date":"2021-08-23 18:54:13","canceled_nights_data":"","product_name":"BV Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"71.48","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":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"5178972","reservation_id":"113867","confirmation_number":"BV12428821749","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,159.00,159.00,159.00,159.00,209.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,53.88","subtotal":"1004.00","grand_total":"1073.64","paid_amount":"1073.64","room_type_id":"308","product_id":"1225","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"29257","customer_id":"29257","source_of_creation":"PMS","reservation_created_date":"2021-04-25 18:30:16","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"159.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5207996","reservation_id":"121765","confirmation_number":"BV12462893024","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.00,82.00,82.00,82.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"328.00","grand_total":"370.64","paid_amount":"370.64","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128720","customer_id":"128720","source_of_creation":"PMS","reservation_created_date":"2021-08-23 17:45:21","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"82.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5208539","reservation_id":"121594","confirmation_number":"BV12479472395","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"118.20","nightly_discount":"0.00","subtotal":"118.20","grand_total":"133.56","paid_amount":"133.56","room_type_id":"304","product_id":"1220","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128747","customer_id":"128747","source_of_creation":"PMS","reservation_created_date":"2021-08-20 20:10:04","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"118.20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294471","reservation_id":"121842","confirmation_number":"BV12452042207","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.31,87.00","nightly_discount":"0.00,0.00","subtotal":"190.31","grand_total":"215.05","paid_amount":"215.05","room_type_id":"303","product_id":"1139","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129325","customer_id":"129325","source_of_creation":"PMS","reservation_created_date":"2021-08-24 14:44:06","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":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"103.31","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5294497","reservation_id":"121871","confirmation_number":"BV12499898184","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.31,103.31","nightly_discount":"0.00,0.00","subtotal":"206.62","grand_total":"233.48","paid_amount":"233.48","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":"129397","customer_id":"129397","source_of_creation":"PMS","reservation_created_date":"2021-08-24 23:10:47","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":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"103.31","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5178974","reservation_id":"113867","confirmation_number":"BV12220037573","room_confirmation_number":"BV12428821749","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","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":"51.35","product_id":"1781","service_quantity":"1","customer_traveller_id":"29257","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-04-25 18:30:16","reservation_modified_date_time":"2021-08-23 13:14:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"29257","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5207997","reservation_id":"121765","confirmation_number":"BV12286813987","room_confirmation_number":"BV12462893024","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","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":"128720","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-23 17:45:21","reservation_modified_date_time":"2021-08-23 17:45:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128720","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5208540","reservation_id":"121594","confirmation_number":"BV12296811804","room_confirmation_number":"BV12479472395","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"128747","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-20 20:10:04","reservation_modified_date_time":"2021-08-24 01:06:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128747","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5208556","reservation_id":"121769","confirmation_number":"BV12244577365","room_confirmation_number":"BV12444969499","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"129312","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-23 18:54:13","reservation_modified_date_time":"2021-08-24 02:19:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129312","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5294424","reservation_id":"121847","confirmation_number":"BV12268021296","room_confirmation_number":"BV12449481180","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","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":"125753","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-24 15:58:08","reservation_modified_date_time":"2021-08-24 20:43:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125753","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5294429","reservation_id":"121859","confirmation_number":"BV12236224260","room_confirmation_number":"BV12479702896","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129390","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-24 19:08:12","reservation_modified_date_time":"2021-08-24 20:49:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129390","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5294472","reservation_id":"121842","confirmation_number":"BV12262627121","room_confirmation_number":"BV12452042207","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","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":"129325","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-24 14:44:06","reservation_modified_date_time":"2021-08-24 22:39:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129325","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5294499","reservation_id":"121871","confirmation_number":"BV12232326717","room_confirmation_number":"BV12499898184","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","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":"129397","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-24 23:10:47","reservation_modified_date_time":"2021-08-24 23:10:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129397","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5178871","reservation_id":"121712","confirmation_number":"BV12268745200","room_confirmation_number":"BV12412923107","room_stay_from":"2021-08-23","room_stay_to":"2021-08-26","room_stay_status":"Canceled","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":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-22 19:53:11","reservation_modified_date_time":"2021-08-23 01:08:30","customer_id":"129257","parentCustTravId":"129257","customer_traveller_id":"129257","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-08-24 13:20:10","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#20","parentRoomStayFrom":"2021-08-23","sub_hotel_id":"124","deltaChange":-20,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5294425","reservation_id":"121847","confirmation_number":"BV12282491160","room_confirmation_number":"BV12449481180","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.50","paid_amount":"56.50","product_id":"2108","service_quantity":"2","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 20:28:11","reservation_modified_date_time":"2021-08-24 20:43:48","customer_id":"125753","parentCustTravId":"125753","customer_traveller_id":"125753","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"124","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5294462","reservation_id":"121594","confirmation_number":"BV12261781830","room_confirmation_number":"BV12479472395","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"2.00","paid_amount":"2.00","product_id":"1213","service_quantity":"2","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 21:48:30","reservation_modified_date_time":"2021-08-24 21:48:30","customer_id":"128747","parentCustTravId":"128747","customer_traveller_id":"128747","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"124","currentDayPrice":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5294498","reservation_id":"121871","confirmation_number":"BV12212138268","room_confirmation_number":"BV12499898184","room_stay_from":"2021-08-24","room_stay_to":"2021-08-26","room_stay_status":"Active","nightly_price":"45.00,45.00","nightly_discount":"0.00,0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 23:10:47","reservation_modified_date_time":"2021-08-24 23:10:47","customer_id":"129397","parentCustTravId":"129397","customer_traveller_id":"129397","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-24","sub_hotel_id":"124","currentDayPrice":"45.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"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":[{"room_stay_id":"5294405","reservation_id":"121745","confirmation_number":"BP12585465012","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"90.73","nightly_discount":"0","subtotal":"90.73","grand_total":"102.52","paid_amount":"102.52","room_type_id":"298","product_id":"1133","siteminder_id":"BDC-3227174842","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":"129385","customer_id":"129385","source_of_creation":"Booking.com","reservation_created_date":"2021-08-23 12:51:10","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"19.93","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"90.73","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":"3305728","reservation_id":"121503","confirmation_number":"BP12512998763","room_stay_from":"2021-08-24","room_stay_to":"2021-08-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.90,91.90,91.90,114.35,114.35,83.55,83.55","nightly_discount":"0,0,0,0,0,0,0","subtotal":"671.50","grand_total":"758.80","paid_amount":"758.80","room_type_id":"294","product_id":"1127","siteminder_id":"EXP-1818386710","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":"128715","customer_id":"128715","source_of_creation":"Expedia","reservation_created_date":"2021-08-19 17:21:10","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 822","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"91.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":"5208463","reservation_id":"121804","confirmation_number":"BP12588621768","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.05,71.05","nightly_discount":"0,0","subtotal":"142.10","grand_total":"160.58","paid_amount":"160.58","room_type_id":"293","product_id":"1124","siteminder_id":"EXP-1820253198","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":"129327","customer_id":"129327","source_of_creation":"Expedia","reservation_created_date":"2021-08-23 22:03:11","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"71.05","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":"5208498","reservation_id":"121664","confirmation_number":"BP12587513574","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"101.92,101.92,101.92,101.92,140.85","nightly_discount":"0,0,0,0,0","subtotal":"548.53","grand_total":"619.84","paid_amount":"619.84","room_type_id":"294","product_id":"1126","siteminder_id":"EXP-1819397651","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":"118559","customer_id":"118559","source_of_creation":"Expedia","reservation_created_date":"2021-08-21 20:48:12","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 806","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"101.92","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":"5294377","reservation_id":"121856","confirmation_number":"BP12541527495","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.81","nightly_discount":"0","subtotal":"73.81","grand_total":"83.41","paid_amount":"83.41","room_type_id":"295","product_id":"1128","siteminder_id":"GAM-R2757622581","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":"129379","customer_id":"129379","source_of_creation":"Getaroom.com","reservation_created_date":"2021-08-24 18:26:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"73.81","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":"5294476","reservation_id":"121825","confirmation_number":"BP12565074638","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.73","nightly_discount":"0","subtotal":"70.73","grand_total":"79.92","paid_amount":"79.92","room_type_id":"299","product_id":"1134","siteminder_id":"GAM-R2756665910","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":"129396","customer_id":"129396","source_of_creation":"Getaroom.com","reservation_created_date":"2021-08-24 05:02:14","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"70.73","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":"5294450","reservation_id":"121600","confirmation_number":"BP12529039816","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.56,152.56,152.56,152.56","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"610.24","grand_total":"689.57","paid_amount":"530.11","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":"129096","customer_id":"129096","source_of_creation":"FE","reservation_created_date":"2021-08-20 20:50:02","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":"","promotion_code":"","sub_hotel_id":"125","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"152.56","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":[],"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":"3305727","reservation_id":"121503","confirmation_number":"BP12272543316","room_confirmation_number":"BP12512998763","room_stay_from":"2021-08-24","room_stay_to":"2021-08-31","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":"128715","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-19 17:21:10","reservation_modified_date_time":"2021-08-21 00:06:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128715","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5208462","reservation_id":"121804","confirmation_number":"BP12230307636","room_confirmation_number":"BP12588621768","room_stay_from":"2021-08-23","room_stay_to":"2021-08-25","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":"129327","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-23 22:03:11","reservation_modified_date_time":"2021-08-23 22:23:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129327","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5208497","reservation_id":"121664","confirmation_number":"BP12273791299","room_confirmation_number":"BP12587513574","room_stay_from":"2021-08-23","room_stay_to":"2021-08-28","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"118559","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-21 20:48:12","reservation_modified_date_time":"2021-08-23 22:49:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118559","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5294378","reservation_id":"121856","confirmation_number":"BP12272367751","room_confirmation_number":"BP12541527495","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129379","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-24 18:26:11","reservation_modified_date_time":"2021-08-24 18:26:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129379","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5294404","reservation_id":"121745","confirmation_number":"BP12267116567","room_confirmation_number":"BP12585465012","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129385","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-23 12:51:10","reservation_modified_date_time":"2021-08-24 19:17:31","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129385","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5294452","reservation_id":"121600","confirmation_number":"BP12261049918","room_confirmation_number":"BP12529039816","room_stay_from":"2021-08-23","room_stay_to":"2021-08-27","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"129096","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-20 20:50:02","reservation_modified_date_time":"2021-08-24 21:31:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129096","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5294475","reservation_id":"121825","confirmation_number":"BP12295809473","room_confirmation_number":"BP12565074638","room_stay_from":"2021-08-24","room_stay_to":"2021-08-25","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":"129396","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-24 05:02:14","reservation_modified_date_time":"2021-08-24 22:42:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129396","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5294448","reservation_id":"121600","confirmation_number":"BP12292741810","room_confirmation_number":"BP12529039816","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"45.00","grand_total":"203.40","paid_amount":"0.00","product_id":"2109","service_quantity":"4","product_name":"Boat Slip Docking","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-20 20:55:07","reservation_modified_date_time":"2021-08-24 21:31:45","customer_id":"129096","parentCustTravId":"129096","customer_traveller_id":"129096","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-23","sub_hotel_id":"125","changedComment":"price, discount or quantity changed","deltaChange":"90.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5294451","reservation_id":"121600","confirmation_number":"BP12296565367","room_confirmation_number":"BP12529039816","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"113.00","paid_amount":"0.00","product_id":"2108","service_quantity":"4","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-20 20:55:18","reservation_modified_date_time":"2021-08-24 21:31:52","customer_id":"129096","parentCustTravId":"129096","customer_traveller_id":"129096","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-23","sub_hotel_id":"125","changedComment":"price, discount or quantity changed","deltaChange":"50.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}